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/SysCodeService.cs | 220 ++++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 217 insertions(+), 3 deletions(-)
diff --git a/zhengcaioa/Services/SysCodeService.cs b/zhengcaioa/Services/SysCodeService.cs
index 59459b6..cb525f1 100644
--- a/zhengcaioa/Services/SysCodeService.cs
+++ b/zhengcaioa/Services/SysCodeService.cs
@@ -402,13 +402,18 @@
(string.IsNullOrWhiteSpace(searchEntity.Comments) ? true : a.Comments.Contains(searchEntity.Comments)) &&
(string.IsNullOrWhiteSpace(searchEntity.CodeSn) ? true : a.CodeSn.Contains(searchEntity.CodeSn)) &&
(string.IsNullOrWhiteSpace(searchEntity.Contents) ? true : a.Contents.Contains(searchEntity.Contents)) &&
- (string.IsNullOrWhiteSpace(searchEntity.WentiId) ? true : a.Contents == searchEntity.WentiId)
+ (string.IsNullOrWhiteSpace(searchEntity.WentiId) ? true : a.Contents == searchEntity.WentiId) &&
+ (string.IsNullOrWhiteSpace(searchEntity.Classify1) ? true : a.Classify1.Contains(searchEntity.Classify1))
select a
).OrderBy(x=>x.Sort).ToList();
if (!string.IsNullOrEmpty(searchEntity.Sort))
{
listCode = listCode.OrderBy(x => x.CodeSn).ToList();
+ }
+ else if (!string.IsNullOrEmpty(searchEntity.Sort1))
+ {
+ listCode = listCode.OrderBy(x => x.Classify1).ThenBy(x=>x.CodeSn).ToList();
}
//if (searchEntity.totalrows == 0)
@@ -433,7 +438,8 @@
Comments = l.Comments,
Contents = l.Contents,
Sort = l.Sort,
-
+ Classify1 = l.Classify1,
+ Classify2 = l.Classify2,
Creater = l.Creater,
Createtime = l.Createtime,
RecStatus = l.RecStatus,
@@ -473,6 +479,7 @@
alldtl.Createtime = model.Createtime;
alldtl.Modifier = model.Modifier;
alldtl.Modifytime = model.Modifytime;
+ alldtl.Classify1 = model.Classify1;
alldtl.CreatetimeStr = model.Createtime.ToString();
alldtl.RecStatusName = model.RecStatus.ToString().Equals("A") ? "鍚敤" : "鍋滅敤";
}
@@ -498,6 +505,68 @@
return alldtl;
+ }
+
+ public List<SysCodeDtlEntity> GetSysCodeDtlInfoss(string Classify1, string CodeTable, string CodeField, string WentiId = "")
+ {
+
+
+ List<SysCodeDtlEntity> sysCodeDtlEntities = new List<SysCodeDtlEntity>();
+ var models = _context.SysCodeDtls.Where(x => x.Classify1 == Classify1).OrderBy(x=>x.CodeSn).ToList(); ;
+
+
+ if (models != null&& models.Count>0)
+ {
+ foreach (var model in models)
+ {
+ var alldtl = new SysCodeDtlEntity();
+ alldtl.Id = model.Id;
+ alldtl.CodeId = model.CodeId;
+ alldtl.CodeSn = model.CodeSn;
+ alldtl.Comments = model.Comments;
+ alldtl.Contents = model.Contents;
+ alldtl.Sort = model.Sort;
+ alldtl.RecStatus = model.RecStatus;
+ alldtl.Creater = model.Creater;
+ alldtl.Createtime = model.Createtime;
+ alldtl.Modifier = model.Modifier;
+ alldtl.Modifytime = model.Modifytime;
+ alldtl.Classify1 = model.Classify1;
+ alldtl.Classify2 = model.Classify2;
+ alldtl.CreatetimeStr = model.Createtime.ToString();
+ alldtl.RecStatusName = model.RecStatus.ToString().Equals("A") ? "鍚敤" : "鍋滅敤";
+ sysCodeDtlEntities.Add(alldtl);
+ }
+
+
+ }
+ else
+ {
+ var alldtl = new SysCodeDtlEntity();
+ var syscode = _context.SysCodes.Where(x => x.RecStatus == "A" && x.CodeTable == CodeTable && x.CodeField == CodeField).FirstOrDefault();
+ if (syscode != null)
+ {
+ alldtl.Contents = WentiId;
+ alldtl.CodeId = syscode.Id;
+ }
+
+
+ alldtl.Classify1 = Classify1;
+ sysCodeDtlEntities.Add(alldtl);
+ }
+
+
+
+
+
+
+
+
+
+
+
+
+ return sysCodeDtlEntities;
}
public ResultEntity SaveSysCodeDtl(SysCodeDtlEntity Entity)
@@ -533,6 +602,7 @@
mModel.Contents = Entity.Contents + "";
mModel.Sort = Entity.Sort;
mModel.RecStatus = "A";
+ mModel.Classify1 = Entity.Classify1;
mModel.Modifier = Entity.Modifier;
mModel.Modifytime = Entity.Modifytime;
@@ -561,7 +631,8 @@
Creater = Entity.Modifier,
Createtime = Entity.Modifytime,
Modifier = Entity.Modifier,
- Modifytime = Entity.Modifytime
+ Modifytime = Entity.Modifytime,
+ Classify1 = Entity.Classify1,
});
@@ -578,5 +649,148 @@
return resultEntity;
}
+
+
+ public ResultEntity SaveSysCodeDtls(SysCodeDtlEntity Entity)
+ {
+ var resultEntity = new ResultEntity();
+
+
+ //浜嬪姟
+ resultEntity.Result = true;
+ try
+ {
+
+
+ var sysCodeDtls = _context.SysCodeDtls.Where(x => x.RecStatus == "A" && x.CodeId == Entity.CodeId && x.Classify1 == Entity.Classify1).ToList();
+ if (sysCodeDtls != null && sysCodeDtls.Count > 0)
+ {
+ foreach (var sysCodeDtl in sysCodeDtls)
+ {
+ _context.SysCodeDtls.Remove(sysCodeDtl);
+ }
+ }
+
+ var CodeSns = Entity.CodeSns;
+ if (CodeSns != null && CodeSns.Length > 0)
+ {
+ for (int i = 0; i < CodeSns.Length; i++)
+ {
+ if (!string.IsNullOrEmpty(Entity.CodeSns[i]) || !string.IsNullOrEmpty(Entity.Commentss[i]) )
+ {
+ _context.SysCodeDtls.Add(new SysCodeDtl()
+ {
+ Id = Guid.NewGuid().ToString(),
+ CodeSn = Entity.CodeSns[i],
+ RoleId = "",
+ CodeId = Entity.CodeId,
+ Comments = Entity.Commentss[i],
+ Contents = Entity.Contentss[i],
+ Sort = Entity.Sorts[i],
+ RecStatus = "A",
+ Creater = Entity.Modifier,
+ Createtime = Entity.Modifytime,
+ Modifier = Entity.Modifier,
+ Modifytime = Entity.Modifytime,
+ Classify1 = Entity.Classify1,
+ Classify2 = Entity.Classify2s[i],
+ });
+ }
+ }
+ }
+
+
+
+
+ _context.SaveChanges();
+
+ }
+ catch (Exception ex)
+ {
+ resultEntity.Message = "淇℃伅淇濆瓨澶辫触锛岃鑱旂郴绠＄悊浜哄憳銆�" + ex.Message; ;
+ resultEntity.Result = false;
+
+ }
+
+ return resultEntity;
+ }
+
+
+ public ResultEntity addSysCodeDtls(SysCodeDtlEntity Entity)
+ {
+ var resultEntity = new ResultEntity();
+
+
+ //浜嬪姟
+ resultEntity.Result = true;
+ resultEntity.ReturnID = "";
+ try
+ {
+
+
+ //var sysCodeDtls = _context.SysCodeDtls.Where(x => x.RecStatus == "A" && x.CodeId == Entity.CodeId && x.Classify1 == Entity.Classify1).ToList();
+ //if (sysCodeDtls != null && sysCodeDtls.Count > 0)
+ //{
+ // foreach (var sysCodeDtl in sysCodeDtls)
+ // {
+ // _context.SysCodeDtls.Remove(sysCodeDtl);
+ // }
+ //}
+
+ var CodeSns = Entity.CodeSns;
+ if (CodeSns != null && CodeSns.Length > 0)
+ {
+ for (int i = 0; i < CodeSns.Length; i++)
+ {
+ if (!string.IsNullOrEmpty(Entity.CodeSns[i]) || !string.IsNullOrEmpty(Entity.Commentss[i]))
+ {
+ var id = Guid.NewGuid().ToString();
+ _context.SysCodeDtls.Add(new SysCodeDtl()
+ {
+ Id = id,
+ CodeSn = Entity.CodeSns[i],
+ RoleId = "",
+ CodeId = Entity.CodeId,
+ Comments = Entity.Commentss[i],
+ Contents = Entity.Contentss[i],
+ Sort = Entity.Sorts[i],
+ RecStatus = "A",
+ Creater = Entity.Modifier,
+ Createtime = Entity.Modifytime,
+ Modifier = Entity.Modifier,
+ Modifytime = Entity.Modifytime,
+ Classify1 = Entity.Classify1,
+ Classify2 = Entity.Classify2s[i],
+ });
+
+ if(i == CodeSns.Length - 1)
+ {
+ resultEntity.ReturnID += Entity.CodeSns[i];
+ }
+ else
+ {
+ resultEntity.ReturnID += Entity.CodeSns[i] + ",";
+ }
+
+ }
+ }
+ }
+
+
+
+
+ _context.SaveChanges();
+
+ }
+ catch (Exception ex)
+ {
+ resultEntity.Message = "淇℃伅淇濆瓨澶辫触锛岃鑱旂郴绠＄悊浜哄憳銆�" + ex.Message; ;
+ resultEntity.Result = false;
+
+ }
+
+ return resultEntity;
+ }
+
}
}
--
Gitblit v1.9.1