工资绩效改版

username@email.com

2023-02-28 67a0042c5f29e4bb0e0b82f6190f2bc51480b45c

 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;
        }

    }
}