| | |
| | | |
| | | 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; |
| | | } |
| | |
| | | updatepltUser.jibensalary = pltUser.jibensalary; |
| | | updatepltUser.jintiesalary = pltUser.jintiesalary; |
| | | updatepltUser.geshuiqizheng = pltUser.geshuiqizheng; |
| | | updatepltUser.Yaoqingma = pltUser.Yaoqingma; |
| | | updatepltUser.HetongDateEnd = pltUser.HetongDateEnd; |
| | | } |
| | | |
| | | _context.SaveChanges(); |
| | |
| | | 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") : "", |
| | | |
| | |
| | | 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.Usernumber).ToList(); |
| | | |
| | |
| | | |
| | | |
| | | // 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); |
| | |
| | | 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; |
| | | } |
| | | } |
| | | } |
| | | |