From 83280d90d12545d36a301c437c7d9095f190aac3 Mon Sep 17 00:00:00 2001
From: username@email.com <yzy2002yzy@163.com>
Date: 星期一, 21 六月 2021 08:54:16 +0800
Subject: [PATCH] 算工资

---
 zhengcaioa/Services/UserService.cs |   37 ++++++++++++++++++++++++++++++++++---
 1 files changed, 34 insertions(+), 3 deletions(-)

diff --git a/zhengcaioa/Services/UserService.cs b/zhengcaioa/Services/UserService.cs
index 9364f63..501d8b6 100644
--- a/zhengcaioa/Services/UserService.cs
+++ b/zhengcaioa/Services/UserService.cs
@@ -184,6 +184,11 @@
                     updatepltUser.miniyearsalary = pltUser.miniyearsalary;
                     updatepltUser.senioritywages = pltUser.senioritywages;
                     updatepltUser.Istravelsubsidy = pltUser.Istravelsubsidy;
+                    updatepltUser.Beizhu = pltUser.Beizhu;
+                    updatepltUser.baomisalary = pltUser.baomisalary;
+                    updatepltUser.jibensalary = pltUser.jibensalary;
+                    updatepltUser.jintiesalary = pltUser.jintiesalary;
+                    updatepltUser.geshuiqizheng = pltUser.geshuiqizheng;
                 }
 
                 _context.SaveChanges();
@@ -261,7 +266,10 @@
                          into fsssss
                          from fff in fsssss.DefaultIfEmpty()
 
-
+                         join h in listCode.Where(x => x.CodeTable == "system" && x.CodeField == "shifou")
+                        on a.Istravelsubsidy equals h.CodeSn
+                        into hsssss
+                         from hhh in hsssss.DefaultIfEmpty()
 
 
                          where a.RecStatus == "A"
@@ -276,6 +284,7 @@
 
                                       && (string.IsNullOrWhiteSpace(searchEntity.Phone) || a.Phone.Contains(searchEntity.Phone.Trim()))
                                        && (string.IsNullOrWhiteSpace(searchEntity.Zhiwustatus) || a.Zhiwustatus == searchEntity.Zhiwustatus.Trim())
+                                        && (string.IsNullOrWhiteSpace(searchEntity.Usernumber) || a.Usernumber == searchEntity.Usernumber.Trim())
                          //select a
                          select new PltUserDTO
                          {
@@ -304,9 +313,31 @@
                              Modifier = a.Modifier,
                              Modifytime = a.Modifytime,
                              UserSn = a.UserSn,
-                             Coler = (a.IsQdht!="A"?"red":((!a.Shebaodate.HasValue) && (a.IsGmsb != "D")? "Darkorange" : ""))
+                             Coler = (a.IsQdht!="A"?"red":((!a.Shebaodate.HasValue) && (a.IsGmsb != "D")? "Darkorange" : "")),
+                             IpMac = a.IpMac,
+                             Iswdenter = a.Iswdenter,
+                             Isxmenter = a.Isxmenter,
+                             Usernumber = a.Usernumber,
+                             advancewages = a.advancewages,
+                             miniyearsalary = a.miniyearsalary,
+                             senioritywages = a.senioritywages,
+                             Istravelsubsidy = a.Istravelsubsidy,
+                             Beizhu = a.Beizhu,
+                             IstravelsubsidyName = hhh.Comments,
+                             advancewagesName = a.advancewages.HasValue ? a.advancewages.Value.ToString("F2") : "",
+                             miniyearsalaryName =   a.miniyearsalary.HasValue ? a.miniyearsalary.Value.ToString("F2") : "",
+                             senioritywagesName =   a.senioritywages.HasValue ? a.senioritywages.Value.ToString("F2") : "",
+                             jibensalary = a.jibensalary,
+                             baomisalary = a.baomisalary,
+                             jintiesalary = a.jintiesalary,
+                             jibensalaryName = a.jibensalary.HasValue ? a.jibensalary.Value.ToString("F2") : "",
+                             baomisalaryName = a.baomisalary.HasValue ? a.baomisalary.Value.ToString("F2") : "",
+                             jintiesalaryName = a.jintiesalary.HasValue ? a.jintiesalary.Value.ToString("F2") : "",
+                             geshuiqizheng = a.geshuiqizheng,
+                             geshuiqizhengName = a.geshuiqizheng.HasValue ? a.geshuiqizheng.Value.ToString("F2") : "",
+
                          }
-              ).OrderBy(x => x.UserSn).ToList();
+              ).OrderBy(x => x.Usernumber).ToList();
 
 
  

--
Gitblit v1.9.1