From 15eb82df2d6ec539e9d4245bfe08d531e8eb6379 Mon Sep 17 00:00:00 2001
From: username@email.com <yzy2002yzy@163.com>
Date: 星期日, 27 四月 2025 14:33:26 +0800
Subject: [PATCH] 修改培训订单占多个座位
---
zhengcaioa/Services/FiPiecerateService.cs | 36 ++++++++++++++++++++++++++----------
1 files changed, 26 insertions(+), 10 deletions(-)
diff --git a/zhengcaioa/Services/FiPiecerateService.cs b/zhengcaioa/Services/FiPiecerateService.cs
index f209fcd..e2cc17a 100644
--- a/zhengcaioa/Services/FiPiecerateService.cs
+++ b/zhengcaioa/Services/FiPiecerateService.cs
@@ -127,13 +127,13 @@
var query = (from a in _context.FiPiecerates
-
- join c in listCode.Where(x => x.CodeTable == "CooperVisit" && x.CodeField == "jtype")
- on a.Pieceratetype equals c.CodeSn
- join d in listCode.Where(x => x.CodeTable == "fi_piecerate" && x.CodeField == "Standard")
- on a.Standard equals d.CodeSn
+ join c in listCode.Where(x => x.CodeTable == "system" && x.CodeField == "shifou")
+ on a.Standard equals c.CodeSn
+
+ //join d in listCode.Where(x => x.CodeTable == "fi_piecerate" && x.CodeField == "Standard")
+ //on a.Standard equals d.CodeSn
@@ -144,20 +144,21 @@
&& (string.IsNullOrWhiteSpace(searchEntity.Pieceratetype) || a.Pieceratetype == searchEntity.Pieceratetype.Trim())
-
+ && (string.IsNullOrWhiteSpace(searchEntity.Standard) || a.Standard == searchEntity.Standard.Trim())
+
select new FiPiecerateDTO
{
Id = a.Id,
CreatedAtTime = a.CreatedAtTime,
Pieceratetype = a.Pieceratetype,
- PieceratetypeName = c.Comments,
+ PieceratetypeName = "",//c.Comments,
Project = a.Project,
Amount = a.Amount,
Standard = a.Standard,
- StandardName = d.Comments,
+ StandardName = c.Comments,
Percent = a.Percent,
@@ -170,7 +171,7 @@
- if (searchEntity.totalrows == 0)
+ //if (searchEntity.totalrows == 0)
searchEntity.totalrows = query.Count();
var lianlist = query.Skip((searchEntity.page - 1) * searchEntity.rows).Take(searchEntity.rows).ToList();
data.LoadData(searchEntity, lianlist);
@@ -214,11 +215,26 @@
{
- var listPosition = _context.FiPiecerates.Where(r => r.RecStatus == "A").ToList();
+ var listPosition = _context.FiPiecerates.Where(r => r.RecStatus == "A").OrderBy(x=>x.Createtime).ToList();
var list = _mapper.Map<List<FiPiecerateDTO>>(listPosition);
return list;
}
+
+ /// <summary>
+ /// 鑾峰彇鎵�鏈夎浠堕」鐩�
+ /// </summary>
+ /// <returns></returns>
+ public List<FiPiecerateDTO> GetListAll()
+ {
+
+ var listPosition = _context.FiPiecerates.OrderBy(x => x.Createtime).ToList();
+
+ var list = _mapper.Map<List<FiPiecerateDTO>>(listPosition);
+ return list;
+ }
+
+
}
}
--
Gitblit v1.9.1