From 67a0042c5f29e4bb0e0b82f6190f2bc51480b45c Mon Sep 17 00:00:00 2001
From: username@email.com <yzy2002yzy@163.com>
Date: 星期二, 28 二月 2023 13:25:09 +0800
Subject: [PATCH] 工资绩效改版
---
zhengcaioa/Services/SysCodeService.cs | 210 ++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 210 insertions(+), 0 deletions(-)
diff --git a/zhengcaioa/Services/SysCodeService.cs b/zhengcaioa/Services/SysCodeService.cs
index 73baf70..cb525f1 100644
--- a/zhengcaioa/Services/SysCodeService.cs
+++ b/zhengcaioa/Services/SysCodeService.cs
@@ -411,6 +411,10 @@
{
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)
//{
@@ -435,6 +439,7 @@
Contents = l.Contents,
Sort = l.Sort,
Classify1 = l.Classify1,
+ Classify2 = l.Classify2,
Creater = l.Creater,
Createtime = l.Createtime,
RecStatus = l.RecStatus,
@@ -500,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)
@@ -582,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