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/WfNeeddeelService.cs |   46 +++++++++++++++++++++++++++++++++++++---------
 1 files changed, 37 insertions(+), 9 deletions(-)

diff --git a/zhengcaioa/Services/WfNeeddeelService.cs b/zhengcaioa/Services/WfNeeddeelService.cs
index 7b01ff3..30f0f34 100644
--- a/zhengcaioa/Services/WfNeeddeelService.cs
+++ b/zhengcaioa/Services/WfNeeddeelService.cs
@@ -2,6 +2,7 @@
 using DTO;
 using DTO.Models;
 using IServices;
+using Microsoft.EntityFrameworkCore;
 using System;
 using System.Collections.Generic;
 using System.Linq;
@@ -117,7 +118,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);
             }
 
             ///WfNeeddeels
@@ -141,7 +142,9 @@
                          from fff in fsssss.DefaultIfEmpty()
 
                          join d in _context.WfApplytypes
-                       on k.Applytiye equals d.Id
+                       on k.Applytiye equals d.Applyno
+                         into dsssss
+                         from ddd in dsssss.DefaultIfEmpty()
 
                          join b in _context.PltUsers 
                         on k.Creater equals b.Id
@@ -160,7 +163,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 WfNeeddeelDTO
                          {
@@ -184,7 +187,7 @@
                              Applyno = k.Applyno,
                              CreaterName = b.UserName,
                              DeptName = c.DeptName,
-                             Applytiye = d.Applytiye,
+                             Applytiye = ddd.Applytiye,
                              Content = k.Content,
                              ShenpiStatusName = eee.Comments,
                              Resivetime = a.Resivetime,
@@ -192,20 +195,20 @@
                              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,
 
                          }
-                 ).OrderBy(x => x.Sort).ThenByDescending(x => x.Resivetime).ToList();
+                 ).OrderByDescending(x=>x.Applyno).ThenBy(x => x.Sort).ThenByDescending(x => x.Resivetime).ToList();
 
 
 
-            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);
@@ -236,12 +239,37 @@
         /// 鑾峰彇鎵�鏈夋湁鏁堟祦绋嬬被鍨�
         /// </summary>
         /// <returns></returns>
-        public List<WfNeeddeelDTO> GetList()
+        public List<WfNeeddeelDTO> GetList(string RunProcessId = "", string step = "")
+        {
+
+
+            var listRole = _context.WfNeeddeels.AsNoTracking().Where(r => r.RecStatus == "A").ToList();
+
+            if (!string.IsNullOrEmpty(RunProcessId) && !string.IsNullOrEmpty(step))
+            {
+                listRole = listRole.Where(x => x.RunProcessId == RunProcessId && x.Step == step).ToList();
+            }
+
+            var list = _mapper.Map<List<WfNeeddeelDTO>>(listRole);
+            return list;
+        }
+
+
+        /// <summary>
+        /// 鑾峰彇鎵�鏈夋湁鏁堟祦绋嬬被鍨�
+        /// </summary>
+        /// <returns></returns>
+        public List<WfNeeddeelDTO> GetListTracking(string RunProcessId = "", string step = "")
         {
 
 
             var listRole = _context.WfNeeddeels.Where(r => r.RecStatus == "A").ToList();
 
+            if (!string.IsNullOrEmpty(RunProcessId) && !string.IsNullOrEmpty(step))
+            {
+                listRole = listRole.Where(x => x.RunProcessId == RunProcessId && x.Step == step).ToList();
+            }
+
             var list = _mapper.Map<List<WfNeeddeelDTO>>(listRole);
             return list;
         }

--
Gitblit v1.9.1