From fc1fe356e1cb43c7654c653e8921ee9e72150f96 Mon Sep 17 00:00:00 2001
From: username@email.com <yzy2002yzy@163.com>
Date: 星期三, 21 七月 2021 16:18:30 +0800
Subject: [PATCH] 今日开发   7月5日以及之前的订单删除                增加功能 账户转账                会员订单同步到会员端                员工获取会员邀请码

---
 zhengcaioa/Services/UserService.cs |   54 ++++++++++++++++++++++++++++++++++++++++++++++++++----
 1 files changed, 50 insertions(+), 4 deletions(-)

diff --git a/zhengcaioa/Services/UserService.cs b/zhengcaioa/Services/UserService.cs
index 9364f63..9e13482 100644
--- a/zhengcaioa/Services/UserService.cs
+++ b/zhengcaioa/Services/UserService.cs
@@ -184,6 +184,12 @@
                     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;
+                    updatepltUser.Yaoqingma = pltUser.Yaoqingma;
                 }
 
                 _context.SaveChanges();
@@ -261,7 +267,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 +285,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 +314,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") : "",
+                             Yaoqingma = a.Yaoqingma,
                          }
-              ).OrderBy(x => x.UserSn).ToList();
+              ).OrderBy(x => x.Usernumber).ToList();
 
 
  
@@ -316,7 +348,7 @@
              
 
           //  query = query.OrderByDescending(x => x.Modifytime).ToList();
-            if (searchEntity.totalrows == 0)
+            //if (searchEntity.totalrows == 0)
                 searchEntity.totalrows = query.Count();
             var userlist = query.Skip((searchEntity.page - 1) * searchEntity.rows).Take(searchEntity.rows).ToList();
            // list = _mapper.Map<List<PltUserDTO>>(userlist);
@@ -362,6 +394,20 @@
             var list = _mapper.Map<List<PltUserDTO>>(listUser.ToList());
             return list;
         }
+
+        /// <summary>
+        /// 鑾峰彇鎵�鏈夋椿鍔ㄧ姸鎬佺殑浜哄憳
+        /// </summary>
+        /// <returns></returns>
+        public List<PltUserDTO> GetListjisuankaoqin(DateTime dateminkaoqin, DateTime datemaxkaoqin)
+        {
+
+
+            var listUser = _context.PltUsers.Where(u => u.RecStatus == "A" && ( u.Zhiwustatus == "A" || ( u.Zhiwustatus =="D" && u.Outdate>= dateminkaoqin && u.Outdate < datemaxkaoqin )));
+           
+            var list = _mapper.Map<List<PltUserDTO>>(listUser.ToList());
+            return list;
+        }
     }
 }
                                                          
\ No newline at end of file

--
Gitblit v1.9.1