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