/// <summary> /// 导出员工信息 /// </summary> public Jinher.AMP.BTP.Deploy.CustomDTO.ResultDTO <Jinher.AMP.BTP.Deploy.CustomDTO.ListResult <Jinher.AMP.BTP.Deploy.YJEmployeeDTO> > ExportYJEmployeeListExt(Jinher.AMP.BTP.Deploy.CustomDTO.YJEmployee.YJEmployeeSearchDTO input) { try { var query = YJEmployee.ObjectSet().Where(_ => _.IsDel == 0 && _.AppId == input.AppId).AsQueryable(); if (!string.IsNullOrWhiteSpace(input.UserCode)) { query = query.Where(_ => _.UserCode == input.UserCode); } if (!string.IsNullOrWhiteSpace(input.UserAccount)) { query = query.Where(_ => _.UserAccount == input.UserAccount); } if (!string.IsNullOrWhiteSpace(input.UserName)) { query = query.Where(_ => _.UserName.Contains(input.UserName) || input.Phone.Contains(_.UserName)); } if (!string.IsNullOrWhiteSpace(input.Phone)) { query = query.Where(_ => _.Phone == input.Phone); } if (!string.IsNullOrWhiteSpace(input.Area)) { query = query.Where(_ => _.Area == input.Area); } if (!string.IsNullOrWhiteSpace(input.Area)) { query = query.Where(_ => _.Area == input.Area); } if (!string.IsNullOrWhiteSpace(input.StationCode)) { query = query.Where(_ => _.StationCode.Contains(input.StationCode) || input.StationCode.Contains(_.StationCode)); } if (!string.IsNullOrWhiteSpace(input.StationName)) { query = query.Where(_ => _.StationName.Contains(input.StationName) || input.StationName.Contains(_.StationName)); } if (input.IsManager > 0) { query = query.Where(_ => _.IsManager == input.IsManager); } if (!string.IsNullOrWhiteSpace(input.Department)) { query = query.Where(_ => _.Department == input.Department); } if (!string.IsNullOrWhiteSpace(input.Station)) { query = query.Where(_ => _.Station == input.Station); } var count = query.Count(); var data = (from n in query select new Jinher.AMP.BTP.Deploy.YJEmployeeDTO { Id = n.Id, UserCode = n.UserCode, UserAccount = n.UserAccount, UserName = n.UserName, IdentityNum = n.IdentityNum, Phone = n.Phone, Area = n.Area, StationCode = n.StationCode, StationName = n.StationName, SubOn = n.SubOn, IsManager = n.IsManager, Department = n.Department, Station = n.Station }).OrderByDescending(q => q.SubOn).ToList(); return(new ResultDTO <ListResult <Jinher.AMP.BTP.Deploy.YJEmployeeDTO> > { isSuccess = true, Data = new ListResult <Jinher.AMP.BTP.Deploy.YJEmployeeDTO> { List = data, Count = count } }); } catch (Exception ex) { LogHelper.Error("YJEmployeeBP.ExportYJEmployeeListExt 异常", ex); return(new ResultDTO <ListResult <Jinher.AMP.BTP.Deploy.YJEmployeeDTO> > { isSuccess = false, Data = null }); } }
/// <summary> /// 查询员工信息 /// </summary> public Jinher.AMP.BTP.Deploy.CustomDTO.ResultDTO <Jinher.AMP.BTP.Deploy.CustomDTO.ListResult <Jinher.AMP.BTP.Deploy.YJEmployeeDTO> > GetYJEmployeeListExt(Jinher.AMP.BTP.Deploy.CustomDTO.YJEmployee.YJEmployeeSearchDTO input) { var query = YJEmployee.ObjectSet().Where(_ => _.AppId == input.AppId && _.IsDel == 0).AsQueryable(); if (!string.IsNullOrWhiteSpace(input.UserCode)) { query = query.Where(_ => _.UserCode == input.UserCode); } if (!string.IsNullOrWhiteSpace(input.UserAccount)) { query = query.Where(_ => _.UserAccount == input.UserAccount); } if (!string.IsNullOrWhiteSpace(input.UserName)) { query = query.Where(_ => _.UserName.Contains(input.UserName) || input.Phone.Contains(_.UserName)); } if (!string.IsNullOrWhiteSpace(input.Phone)) { query = query.Where(_ => _.Phone == input.Phone); } if (!string.IsNullOrWhiteSpace(input.Area)) { query = query.Where(_ => input.Area.Contains(_.Area) || _.Area.Contains(input.Area)); } if (!string.IsNullOrWhiteSpace(input.StationCode)) { query = query.Where(_ => _.StationCode.Contains(input.StationCode) || input.StationCode.Contains(_.StationCode)); } if (!string.IsNullOrWhiteSpace(input.StationName)) { query = query.Where(_ => _.StationName.Contains(input.StationName) || input.StationName.Contains(_.StationName)); } if (!string.IsNullOrWhiteSpace(input.IdentityNum)) { query = query.Where(_ => _.IdentityNum == input.IdentityNum); } if (input.IsManager > 0) { query = query.Where(_ => _.IsManager == input.IsManager); } if (!string.IsNullOrWhiteSpace(input.Department)) { query = query.Where(_ => input.Department.Contains(_.Department) || _.Department.Contains(input.Department)); } if (!string.IsNullOrWhiteSpace(input.Station)) { query = query.Where(_ => input.Station.Contains(_.Station) || _.Station.Contains(input.Station)); } var count = query.Count(); var data = (from n in query select new Jinher.AMP.BTP.Deploy.YJEmployeeDTO { Id = n.Id, UserCode = n.UserCode, UserAccount = n.UserAccount, UserName = n.UserName, IdentityNum = n.IdentityNum, Phone = n.Phone, Area = n.Area, StationCode = n.StationCode, StationName = n.StationName, SubOn = n.SubOn, IsManager = n.IsManager, Department = n.Department, Station = n.Station }).OrderByDescending(q => q.SubOn).Skip((input.PageIndex - 1) * input.PageSize).Take(input.PageSize).ToList(); return(new ResultDTO <ListResult <Jinher.AMP.BTP.Deploy.YJEmployeeDTO> > { isSuccess = true, Data = new ListResult <Jinher.AMP.BTP.Deploy.YJEmployeeDTO> { List = data, Count = count } }); }