From 57556b16aafbafebc7f9fc86745ac2ea83e7616d Mon Sep 17 00:00:00 2001 From: username@email.com <yzy2002yzy@163.com> Date: 星期四, 01 七月 2021 14:26:35 +0800 Subject: [PATCH] 流程 请假 销假 待办 已办 我得申请 --- zhengcaioa/Services/WfHistoryService.cs | 72 ++++++++++++++++++++++++++++++++--- 1 files changed, 65 insertions(+), 7 deletions(-) diff --git a/zhengcaioa/Services/WfHistoryService.cs b/zhengcaioa/Services/WfHistoryService.cs index 11421d4..41f1668 100644 --- a/zhengcaioa/Services/WfHistoryService.cs +++ b/zhengcaioa/Services/WfHistoryService.cs @@ -116,7 +116,7 @@ string[] Applytimes = searchEntity.Applytime.Split("|"); DateTime.TryParse(Applytimes[0], out Applytimestart); DateTime.TryParse(Applytimes[1], out Applytimeend); - //Applytimeend = Applytimeend.AddDays(1); + Applytimeend = Applytimeend.AddDays(1); } ///WfHistories @@ -140,7 +140,7 @@ from fff in fsssss.DefaultIfEmpty() join d in _context.WfApplytypes - on k.Applytiye equals d.Id + on k.Applytiye equals d.Applyno join b in _context.PltUsers on k.Creater equals b.Id @@ -159,7 +159,7 @@ && (string.IsNullOrWhiteSpace(searchEntity.RunProcessId) || a.RunProcessId == searchEntity.RunProcessId.Trim()) && (string.IsNullOrWhiteSpace(searchEntity.Applyno) || k.Applyno == searchEntity.Applyno.Trim()) - + && (string.IsNullOrWhiteSpace(searchEntity.Creater) || a.DeelUserId == searchEntity.Creater.Trim()) select new WfHistoryDTO { @@ -191,10 +191,10 @@ NeeddeelTypeName = fff.Comments, Contentyijian = a.Content, Sort = a.Sort, - + Deelurl = a.Deelurl, Creater = a.Creater, Createtime = a.Createtime, - + Step = a.Step, RecStatus = a.RecStatus, Modifier = a.Modifier, Modifytime = a.Modifytime, @@ -235,14 +235,72 @@ /// 鑾峰彇鎵�鏈夋湁鏁堟祦绋嬬被鍨� /// </summary> /// <returns></returns> - public List<WfHistoryDTO> GetList() + public List<WfHistoryDTO> GetList(string RunProcessId = "") { - var listRole = _context.WfHistories.Where(r => r.RecStatus == "A").ToList(); + var listRole = _context.WfHistories.Where(r => r.RecStatus == "A").OrderBy(x=>x.Sort).ToList(); + if (!string.IsNullOrEmpty(RunProcessId)) + { + listRole = listRole.Where(x => x.RunProcessId == RunProcessId).ToList(); + } var list = _mapper.Map<List<WfHistoryDTO>>(listRole); return list; } + /// <summary> + /// 鏌ヨ鍘嗗彶瀹℃壒鎰忚 + /// </summary> + /// <returns></returns> + public List<WfHistoryDTO> GetListshenpi(string RunProcessId) + { + + + var listRole = (from a in _context.WfHistories.Where(x => x.RecStatus == "A" && x.NeeddeelType =="1" && x.ChuliStatus != "0" && x.RunProcessId == RunProcessId) + + join b in _context.PltUsers + on a.DeelUserId equals b.Id + + + select new WfHistoryDTO + { + RunProcessId = a.RunProcessId, + SendUserId = a.SendUserId, + DeelUserId = a.DeelUserId, + Sendtime = a.Sendtime, + Resivetime = a.Resivetime, + Step = a.Step, + ChuliStatus = a.ChuliStatus, + Deelurl = a.Deelurl, + NeeddeelType = a.NeeddeelType, + Sort = a.Sort, + Content = a.Content, + + + RecStatus = a.RecStatus, + Creater = a.Creater, + Createtime = a.Createtime, + Modifier = a.Modifier, + Modifytime = a.Modifytime, + ChuliStatusName = a.Step == "鎻愪氦"? "鎻愪氦" : a.ChuliStatus == "2" ? "鍚屾剰" : "鎷掔粷", + DeelUserIdName = b.UserName, + ModifytimeName = a.Modifytime.ToString("yyyy-MM-dd HH:mm:ss"), + } + ).OrderBy(x => x.Modifytime).ToList(); + + + + // _context.WfHistories.Where(r => r.RecStatus == "A").OrderBy(x => x.Sort).ToList(); + //if (!string.IsNullOrEmpty(RunProcessId)) + //{ + // listRole = listRole.Where(x => x.RunProcessId == RunProcessId).ToList(); + //} + + + + + return listRole; + } + } } -- Gitblit v1.9.1