From 15eb82df2d6ec539e9d4245bfe08d531e8eb6379 Mon Sep 17 00:00:00 2001
From: username@email.com <yzy2002yzy@163.com>
Date: 星期日, 27 四月 2025 14:33:26 +0800
Subject: [PATCH] 修改培训订单占多个座位
---
zhengcaioa/Services/UserService.cs | 139 ++++++++++++++++++++++++++++++++++++++++++++--
1 files changed, 132 insertions(+), 7 deletions(-)
diff --git a/zhengcaioa/Services/UserService.cs b/zhengcaioa/Services/UserService.cs
index 37529bc..4387ca5 100644
--- a/zhengcaioa/Services/UserService.cs
+++ b/zhengcaioa/Services/UserService.cs
@@ -29,7 +29,7 @@
public PltUser login(string user_sn, string password)
{
- var user = _context.PltUsers.Where(x => (x.UserSn == user_sn || x.Phone == user_sn ) && x.Password == password && x.RecStatus == "A").FirstOrDefault();
+ var user = _context.PltUsers.Where(x => (x.UserSn == user_sn || x.Phone == user_sn ) && x.Password == password && x.RecStatus == "A" && x.Zhiwustatus == "A" ).FirstOrDefault();
return user;
}
@@ -84,13 +84,21 @@
return resultEntity;
}
+ var checkNumber = _context.PltUsers.Where(x => x.Usernumber == pltUserDTO.Usernumber && x.RecStatus == "A" && x.Id != pltUserDTO.Id).FirstOrDefault();
+ if (checkNumber != null && (string.IsNullOrWhiteSpace(pltUserDTO.Id) || (!string.IsNullOrWhiteSpace(pltUserDTO.Id) && checkNumber.Id != pltUserDTO.Id)))
+ {
+ resultEntity.Result = false;
+ resultEntity.Message = "宸ュ彿閲嶅";
+ return resultEntity;
+ }
+
var checkPhone = _context.PltUsers.Where(x => x.Phone == pltUserDTO.Phone && x.RecStatus == "A" && x.Id != pltUserDTO.Id).FirstOrDefault();
if (checkPhone != null && (string.IsNullOrWhiteSpace(pltUserDTO.Id) || (!string.IsNullOrWhiteSpace(pltUserDTO.Id) && checkPhone.Id != pltUserDTO.Id)))
{
resultEntity.Result = false;
resultEntity.Message = "鐢ㄦ埛鎵嬫満鍙烽噸澶�";
return resultEntity;
- }
+ }
var checkIdcard = _context.PltUsers.Where(x => x.Idcard == pltUserDTO.Idcard && x.RecStatus == "A" && x.Id != pltUserDTO.Id).FirstOrDefault();
if (checkIdcard != null && (string.IsNullOrWhiteSpace(pltUserDTO.Id) || (!string.IsNullOrWhiteSpace(pltUserDTO.Id) && checkIdcard.Id != pltUserDTO.Id)))
@@ -99,7 +107,6 @@
resultEntity.Message = "鐢ㄦ埛韬唤璇佸彿閲嶅";
return resultEntity;
}
-
var pltUser = _mapper.Map<PltUser>(pltUserDTO);
if (String.IsNullOrEmpty(pltUser.Id))
@@ -169,6 +176,21 @@
updatepltUser.JzYoubian = pltUser.JzYoubian;
updatepltUser.HjYoubian = pltUser.HjYoubian;
+ updatepltUser.IpMac = pltUser.IpMac;
+ updatepltUser.Iswdenter = pltUser.Iswdenter;
+ updatepltUser.Isxmenter = pltUser.Isxmenter;
+ updatepltUser.Usernumber = pltUser.Usernumber;
+ updatepltUser.advancewages = pltUser.advancewages;
+ 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;
+ updatepltUser.HetongDateEnd = pltUser.HetongDateEnd;
}
_context.SaveChanges();
@@ -246,7 +268,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"
@@ -261,6 +286,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
{
@@ -279,6 +305,8 @@
BasicPrice = a.BasicPrice,
ShiyongPrice = a.ShiyongPrice,
ShiyongPriceName = a.ShiyongPrice.HasValue ? a.ShiyongPrice.Value.ToString("F2") : "",
+ HetongDateEnd = a.HetongDateEnd,
+ HetongDateEndName = a.HetongDateEnd.HasValue ? a.HetongDateEnd.Value.ToString("yyyy-MM-dd") : "",
ShebaodateName = a.Shebaodate.HasValue ? a.Shebaodate.Value.ToString("yyyy-MM-dd") : "",
@@ -289,9 +317,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();
@@ -301,7 +351,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);
@@ -347,6 +397,81 @@
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;
+ }
+
+
+ public ResultEntity savePltUserFenpeiDate(DateTime? FenpeiDate,string userId)
+ {
+ ResultEntity resultEntity = new ResultEntity();
+
+ try {
+
+ var updatepltUser = _context.PltUsers.Find(userId);
+
+ updatepltUser.FenpeiDate = FenpeiDate;
+
+ _context.SaveChanges();
+ resultEntity.ReturnID = userId;
+ resultEntity.Result = true;
+ }
+ catch (Exception ex)
+ {
+ resultEntity.Result = false;
+ resultEntity.Message = "淇濆瓨澶辫触锛岃鑱旂郴绠＄悊鍛�";
+
+ }
+ return resultEntity;
+ }
+
+
+ public ResultEntity saveCustomerYwjl(CustomerYwjl DTO)
+ {
+
+ ResultEntity resultEntity = new ResultEntity();
+ try
+ {
+
+
+
+
+
+ DTO.Id = Guid.NewGuid().ToString();
+
+ _context.CustomerYwjls.Add(DTO);
+
+
+ _context.SaveChanges();
+ resultEntity.ReturnID = DTO.Id;
+ resultEntity.Result = true;
+ }
+ catch (Exception ex)
+ {
+ resultEntity.Result = false;
+ resultEntity.Message = "淇濆瓨澶辫触锛岃鑱旂郴绠＄悊鍛�";
+
+ }
+ return resultEntity;
+ }
+
+
+ public List<CustomerYwjl> GetListCustomerYwjl(string CustomerId)
+ {
+ var listUser = _context.CustomerYwjls.Where(u => u.UserId == CustomerId).OrderByDescending(x=>x.Createtime).ToList();
+ return listUser;
+ }
}
}
\ No newline at end of file
--
Gitblit v1.9.1