/// <summary> /// 得到相似客户 /// </summary> /// <param name="dto"></param> /// <returns></returns> public List <CustomerResultDTO> GetSimilarCustomerList(CustomerSearchDTO dto) { List <CustomerResultDTO> result = null; var tcdmse = SingleQueryObject.GetObj(); var all = tcdmse.master_CustomerInfo.AsNoTracking().Where(p => p.CustomerID != null); if (!string.IsNullOrEmpty(dto.SearchText)) { List <string> dict = new List <string>(); int count = (int)Math.Ceiling(dto.SearchText.Length / 2.0); for (int i = 1; i <= count; i++) { if (i == count) { dict.Add(dto.SearchText.Substring((i - 1) * 2)); } else { dict.Add(dto.SearchText.Substring((i - 1) * 2, 2)); } } var filted = tcdmse.master_CustomerInfo.AsNoTracking().Where(p => p.CustomerID == null); foreach (var di in dict) { filted = filted.Union(all.Where(p => p.CustomerName.Contains(di))); } dto.Count = filted.Count(); filted = filted.OrderBy(m => m.CustomerName).ThenBy(m => m.CustomerID).Skip((dto.page - 1) * dto.rows).Take(dto.rows); result = Mapper.Map <List <master_CustomerInfo>, List <CustomerResultDTO> >(filted.ToList()); } return(result); }
public short CheckPhoneNumber(string PhoneNumber) { short result = 0; var pp = SingleQueryObject.GetObj().master_UserInfo.AsNoTracking().Where(p => p.PhoneNumber == PhoneNumber).FirstOrDefault(); if (pp == null) // 无手机号 { result = 1; } else if (pp.master_RoleInfo.Count() == 0 && pp.master_UserCustomerAuthority.Count() == 0) // 无权限 { result = 2; } else if (!(pp.IsActive ?? false)) // 停用 { result = 3; } else if (pp.StopTime < DateTime.Now) //用户到期时间 { result = 4; } return(result); }
/// <summary> /// 得到反馈信息(查询) /// </summary> /// <param name="dto"></param> /// <returns></returns> public List <FeedbackResultDTO> GetFeedbackList(FeedbackSearchDTO dto) { List <FeedbackResultDTO> result = null; var tcdmse = SingleQueryObject.GetObj(); var pp = tcdmse.master_FeedbackStat.AsNoTracking().Where(p => p.FeedbackStatID != null); { if (!string.IsNullOrEmpty(dto.FeedbackSystem)) { pp = pp.Where(p => p.FeedbackSystem == dto.FeedbackSystem); } if (!string.IsNullOrEmpty(dto.SearchText)) { pp = pp.Where(p => p.master_UserInfo.master_DistributorInfo.Any(m => m.DistributorName.Contains(dto.SearchText)) || p.master_UserInfo.FullName.Contains(dto.SearchText)); } } dto.Count = pp.Count(); pp = pp.OrderBy(m => m.FeedbackStaus).ThenByDescending(m => m.FeedbackDate).ThenBy(m => m.FeedbackStatID).Skip((dto.page - 1) * dto.rows).Take(dto.rows); result = Mapper.Map <List <master_FeedbackStat>, List <FeedbackResultDTO> >(pp.ToList()); return(result); }
/// <summary> /// 得到经销商信息 /// </summary> /// <returns></returns> public List <DistributorResultDTO> GetDistributorList(DistributorSearchDTO dto) { List <DistributorResultDTO> result = null; var tcdmse = SingleQueryObject.GetObj(); var pp = tcdmse.master_DistributorInfo.AsNoTracking().Where(p => p.DistributorID != null); if (dto.DistributorID != null) { pp = pp.Where(p => p.DistributorID == dto.DistributorID); } if (dto.DistributorTypeID != null) { pp = pp.Where(p => p.DistributorTypeID == dto.DistributorTypeID); } if (dto.DistributorServiceTypeID != null) { pp = pp.Where(p => p.DistributorServiceTypeID == dto.DistributorServiceTypeID); } if (!string.IsNullOrEmpty(dto.SearchText)) { pp = pp.Where(p => p.DistributorCode.Contains(dto.SearchText) || p.DistributorName.Contains(dto.SearchText) || p.master_DistributorType.DistributorTypeName.Contains(dto.SearchText)); } if (dto.IsActive != null) { pp = pp.Where(p => p.IsActive == dto.IsActive); } dto.Count = pp.Count(); pp = pp.OrderByDescending(m => m.IsActive).ThenBy(m => m.DistributorID).Skip((dto.page - 1) * dto.rows).Take(dto.rows); result = Mapper.Map <List <master_DistributorInfo>, List <DistributorResultDTO> >(pp.ToList()); return(result); }
/// <summary> /// 查询日志管理 /// </summary> /// <returns></returns> public List <LogDTO> GetLog(LogSearchDTO dto) { List <LogDTO> result = null; var tcdmse = SingleQueryObject.GetObj(); var pp = tcdmse.common_LogInfo.AsNoTracking().Where(p => p.LogIndex != null); if (dto.Year != null) { pp = pp.Where(p => p.LogDate.Value.Year == dto.Year); } if (dto.Month != null) { pp = pp.Where(p => p.LogDate.Value.Month == dto.Month); } if (!string.IsNullOrEmpty(dto.BelongModel)) { pp = pp.Where(p => p.BelongModel == dto.BelongModel); } if (!string.IsNullOrEmpty(dto.SearchText)) { pp = pp.Where(p => p.OpratorName.Contains(dto.SearchText)); } dto.Count = pp.Count(); pp = pp.OrderBy(m => m.LogIndex).Skip((dto.page - 1) * dto.rows).Take(dto.rows); result = Mapper.Map <List <common_LogInfo>, List <LogDTO> >(pp.ToList()); return(result); }
/// <summary> /// 已授权用户模块 /// </summary> /// <param name="dto"></param> /// <returns></returns> public List <UsersByAuthoritedResultDTO> GetUsersByAuthorited(UsersByAuthoritedSearchDTO dto) { List <UsersByAuthoritedResultDTO> lstresult = null; var ww = dto.ApplyUserAuthority.Select(s => s.StructureID).ToList(); var gg = from g in SingleQueryObject.GetObj().master_UserCustomerAuthority where ww.Contains(g.StructureID) && (dto.DistributorID == null || g.master_UserInfo.master_DistributorInfo.Where(w => dto.DistributorID == w.DistributorID.ToString()).Count() > 0) && g.StructureID.Length == 3 select new UsersByAuthoritedResultDTO { UserID = g.master_UserInfo.UserID, FullName = g.master_UserInfo.FullName, StructureID = g.StructureID, StructureName = g.dict_Structure.StructureName }; if (dto.RoleIDlist.Count() != 0) { var modelid = ModelRoleDTO.ModelRolelist.Where(p => dto.RoleIDlist.Contains(p.RoleID)).Select(s => s.ModelID).ToList(); gg = gg.Where(p => modelid.Contains(p.StructureID)); } dto.Count = gg.Select(t => t).Count(); lstresult = gg.Select(t => t).OrderBy(o => o.UserID).ThenBy(t => t.StructureID).Skip((dto.page - 1) * dto.rows).Take(dto.rows).ToList(); return(lstresult); }
/// <summary> /// 得到附件信息(查询) /// </summary> /// <param name="dtolist"></param> /// <returns></returns> public List <AttachFileResultDTO> GetAttachFileList(AttachFileSearchDTO dto) { List <AttachFileResultDTO> result = null; var tcdmse = SingleQueryObject.GetObj(); var pp = tcdmse.common_AttachFileInfo.AsNoTracking().Where(p => p.AttachFileID != null); if (dto.AttachFileID != null) { pp = pp.Where(p => p.AttachFileID == dto.AttachFileID); } else { if (dto.BelongModule != null) { pp = pp.Where(p => p.BelongModule == dto.BelongModule); if (!string.IsNullOrEmpty(dto.BelongModulePrimaryKey)) { pp = pp.Where(p => p.BelongModulePrimaryKey == dto.BelongModulePrimaryKey); } } } result = Mapper.Map <List <common_AttachFileInfo>, List <AttachFileResultDTO> >(pp.ToList()); return(result); }
/// <summary> /// 得到所有模块管理员信息 /// </summary> /// <returns></returns> public List <ModularResultDTO> GetModularList(ModularSearchDTO dto) { List <ModularResultDTO> result = new List <ModularResultDTO>(); var tcdmse = SingleQueryObject.GetObj(); //dict_Structure和master_UserInfo关联查询所有的模块管理员信息 return(result); }
/// <summary> /// 取得所有按钮 /// </summary> /// <returns></returns> public List <ButtonDTO> GetAllButton() { List <ButtonDTO> result = null; var pp = SingleQueryObject.GetObj().dict_ButtonInfo.AsNoTracking().OrderBy(g => g.IndexCode).ToList(); result = Mapper.Map <List <ButtonDTO> >(pp); return(result); }
/// <summary> /// 取得模块日志 /// </summary> /// <returns></returns> public List <LogDTO> GetAllLogByBelongModel(string BelongModel) { List <LogDTO> result = null; var pp = SingleQueryObject.GetObj().common_LogInfo.AsNoTracking().Where(p => p.BelongModel == BelongModel).OrderBy(g => g.LogIndex).ToList(); result = Mapper.Map <List <LogDTO> >(pp); return(result); }
/// <summary> /// 取得所有模块 /// </summary> /// <returns></returns> public List <StructureDTO> GetAllStructure() { List <StructureDTO> result = null; var pp = SingleQueryObject.GetObj().dict_Structure.AsNoTracking().OrderBy(g => new { g.StructureID, g.IndexCode }).ToList(); result = Mapper.Map <List <StructureDTO> >(pp); return(result); }
/// <summary> /// 大小区显示 /// </summary> /// <param name="lngdto"></param> /// <returns></returns> public List <AreaResultDTO> GetAreaTree(AreaSearchDTO dto) { List <AreaResultDTO> result = new List <AreaResultDTO>(); var tcdmse = SingleQueryObject.GetObj(); int i = 0; var pp = tcdmse.master_AreaInfo.AsNoTracking().Where(p => p.AreaID != null); if (dto.DepartID != null) { pp = pp.Where(p => p.DepartID == dto.DepartID); } var qq = pp.ToList(); var mm = qq.Where(p => p.AreaPID == null); foreach (var m in mm) { i++; AreaResultDTO One = new AreaResultDTO(); One = Mapper.Map <master_AreaInfo, AreaResultDTO>(m); One.FictitiousID = i; One.children = new List <AreaResultDTO>(); var nn = qq.Where(p => p.AreaPID == m.AreaID); foreach (var n in nn) { i++; AreaResultDTO Two = new AreaResultDTO(); Two = Mapper.Map <master_AreaInfo, AreaResultDTO>(n); Two.FictitiousID = i; One.children.Add(Two); var ww = tcdmse.master_AreaRegionInfo.AsNoTracking().Where(w => w.AreaID == n.AreaID); List <AreaResultDTO> region = null; region = Mapper.Map <List <master_AreaRegionInfo>, List <AreaResultDTO> >(ww.ToList()); foreach (var r in region) { i++; r.FictitiousID = i; r.AreaPID = n.AreaID; } Two.children = region; } result.Add(One); } //if (dto.DepartID != null) //{ // List<int> Depat = new List<int>(); // UserAuthorityServices.GetDepare(tcdmse, Depat, dto.DepartID); // Depat = Depat.Distinct().ToList(); // result = result.Where(p => Depat.Contains(p.DepartID.Value)).ToList(); //} return(result); }
/// <summary> /// 所有行政区划 /// </summary> /// <param name="dto"></param> /// <returns></returns> public List <RegionResultDTO> GetRegionList() { var result = new List <RegionResultDTO>(); var tcdmse = SingleQueryObject.GetObj(); var list = tcdmse.dict_RegionInfo.AsNoTracking().ToList(); result = Mapper.Map <List <dict_RegionInfo>, List <RegionResultDTO> >(list); return(result); }
/// <summary> /// 得到所有关账日信息 /// </summary> /// <returns></returns> public List <AccountDateResultDTO> GetAccountDateList() { List <AccountDateResultDTO> result = null; var tcdmse = SingleQueryObject.GetObj(); var pp = tcdmse.master_AccountDateInfo.AsNoTracking(); result = Mapper.Map <List <master_AccountDateInfo>, List <AccountDateResultDTO> >(pp.OrderBy(o => o.AccountDateYear).ThenBy(o => o.CreateTime).ThenBy(o => o.AccountDateID).ToList()); return(result); }
/// <summary> /// 得到所有汇率信息 /// </summary> /// <returns></returns> public List <RateResultDTO> GetRateList() { List <RateResultDTO> result = null; var tcdmse = SingleQueryObject.GetObj(); var pp = tcdmse.master_RateInfo.AsNoTracking(); result = Mapper.Map <List <master_RateInfo>, List <RateResultDTO> >(pp.ToList()); return(result); }
/// <summary> /// 大区 /// </summary> /// <param name="dto"></param> /// <returns></returns> public List <AreaResultDTO> GetArea() { List <AreaResultDTO> result = new List <AreaResultDTO>(); var tcdmse = SingleQueryObject.GetObj(); var pp = tcdmse.master_AreaInfo.AsNoTracking().Where(p => p.AreaPID == null).ToList(); result = Mapper.Map <List <master_AreaInfo>, List <AreaResultDTO> >(pp); return(result); }
public List <DepartmentResultDTO> GetDepartment() { List <DepartmentResultDTO> result = new List <DepartmentResultDTO>(); var tcdmse = SingleQueryObject.GetObj(); var roots = tcdmse.master_DepartmentInfo.AsNoTracking().ToList(); result = AutoMapper.Mapper.Map <List <master_DepartmentInfo>, List <DepartmentResultDTO> >(roots); return(result); }
/// <summary> /// 得到一条运输方式信息 /// </summary> /// <returns></returns> public TransportResultDTO GetOneTransport(int id) { TransportResultDTO result = null; var tcdmse = SingleQueryObject.GetObj(); var pp = tcdmse.master_TransportInfo.AsNoTracking().Where(p => p.TransportID == id).FirstOrDefault(); if (pp != null) { result = Mapper.Map <master_TransportInfo, TransportResultDTO>(pp); } return(result); }
/// <summary> /// 得到一条角色信息 /// </summary> /// <returns></returns> public RoleResultDTO GetRole(int id) { RoleResultDTO result = new RoleResultDTO(); var tcdmse = SingleQueryObject.GetObj(); var pp = tcdmse.master_RoleInfo.AsNoTracking().Where(p => p.RoleID == id).FirstOrDefault(); if (pp == null) { throw new Exception("此条信息不存在!"); } result = AutoMapper.Mapper.Map <master_RoleInfo, RoleResultDTO>(pp); return(result); }
/// <summary> /// 得到所有经销商服务类型 /// </summary> /// <returns></returns> public List <DistributorServiceTypeResultDTO> GetDistributorServiceType(DistributorServiceTypeSearchDTO dto) { List <DistributorServiceTypeResultDTO> result = null; var tcdmse = SingleQueryObject.GetObj(); var pp = tcdmse.master_DistributorServiceType.AsNoTracking().Where(p => p.DistributorServiceTypeID != null); if (dto.DistributorServiceTypeID != null) { pp = pp.Where(p => p.DistributorServiceTypeID == dto.DistributorServiceTypeID); } result = Mapper.Map <List <master_DistributorServiceType>, List <DistributorServiceTypeResultDTO> >(pp.ToList()); return(result); }
/// <summary> /// 得到经销商授权产品线区域信息 /// </summary> /// <param name="dto"></param> /// <returns></returns> public List <DistributorRegionResultDTO> GetDistributorAuthorityRegion(DistributorAuthoritySearchDTO dto) { List <DistributorRegionResultDTO> result = null; var tcdmse = SingleQueryObject.GetObj(); var pp = tcdmse.master_DistributorRegionInfo.AsNoTracking().Where(p => (dto.DistributorProductID == null || p.master_DistributorProductLineInfo.DistributorProductLineID == dto.DistributorProductID)); dto.Count = pp.Count(); pp = pp.OrderByDescending(m => m.CreateTime).Skip((dto.page - 1) * dto.rows).Take(dto.rows); result = Mapper.Map <List <master_DistributorRegionInfo>, List <DistributorRegionResultDTO> >(pp.ToList()); return(result); }
/// <summary> /// 得到一条部门信息 /// </summary> /// <returns></returns> public DepartmentResultDTO GetDepartment(int id) { DepartmentResultDTO result = new DepartmentResultDTO(); var tcdmse = SingleQueryObject.GetObj(); var pp = tcdmse.master_DepartmentInfo.AsNoTracking().Where(p => p.DepartID == id).FirstOrDefault(); if (pp == null) { throw new Exception("此条信息不存在!"); } result = AutoMapper.Mapper.Map <master_DepartmentInfo, DepartmentResultDTO>(pp); return(result); }
/// <summary> /// 得到一条付款条款信息 /// </summary> /// <returns></returns> public PaymentResultDTO GetPayment(int id) { PaymentResultDTO result = null; var tcdmse = SingleQueryObject.GetObj(); var pp = tcdmse.master_PaymentInfo.AsNoTracking().Where(p => p.PayID == id).FirstOrDefault(); if (pp == null) { throw new Exception("此条信息不存在!"); } result = Mapper.Map <master_PaymentInfo, PaymentResultDTO>(pp); return(result); }
/// <summary> /// 得到所有运输方式信息 /// </summary> /// <returns></returns> public List <TransportResultDTO> GetTransport(TransportSearchDTO dto) { List <TransportResultDTO> result = null; var tcdmse = SingleQueryObject.GetObj(); var pp = tcdmse.master_TransportInfo.AsNoTracking().Where(p => p.TransportID != null); if (dto.DistributorID != null) { pp = pp.Where(p => p.master_DistributorTransport.Any(m => m.DistributorID == dto.DistributorID)); } result = Mapper.Map <List <master_TransportInfo>, List <TransportResultDTO> >(pp.ToList()); return(result); }
/// <summary> /// 得到一条关账日信息 /// </summary> /// <returns></returns> public AccountDateResultDTO GetAccountDate(int id) { AccountDateResultDTO result = null; var tcdmse = SingleQueryObject.GetObj(); var pp = tcdmse.master_AccountDateInfo.AsNoTracking().Where(p => p.AccountDateID == id).FirstOrDefault(); if (pp == null) { throw new Exception("此条信息不存在!"); } result = Mapper.Map <master_AccountDateInfo, AccountDateResultDTO>(pp); return(result); }
/// <summary> /// 查询提醒管理 /// </summary> /// <returns></returns> public List <WarningDTO> GetWarningInfo(WarningSearchDTO dto) { List <WarningDTO> result = null; var tcdmse = SingleQueryObject.GetObj(); var pp = tcdmse.common_WarningInfo.AsNoTracking().Where(p => p.WarningID != null); pp = pp.Where(t => t.UserID == dto.UserID); dto.Count = pp.Count(); pp = pp.OrderBy(m => m.WarningID).Skip((dto.page - 1) * dto.rows).Take(dto.rows); result = Mapper.Map <List <common_WarningInfo>, List <WarningDTO> >(pp.ToList()); return(result); }
/// <summary> /// 得到所有部门信息 /// </summary> /// <returns></returns> public List <DepartmentResultDTO> GetDepartmentList() { List <DepartmentResultDTO> result = new List <DepartmentResultDTO>(); var tcdmse = SingleQueryObject.GetObj(); var roots = tcdmse.master_DepartmentInfo.AsNoTracking().Where(p => p.DepartParentID == null).ToList(); var departlist = AutoMapper.Mapper.Map <List <master_DepartmentInfo>, List <DepartmentResultDTO> >(roots); for (int i = 0; i < departlist.Count; i++) { departlist[i] = GetDepartTree(departlist[i]); } result = departlist; return(result); }
/// <summary> /// 得到经销商授权付款条款信息 /// </summary> /// <param name="dto"></param> /// <returns></returns> public List <DistributorPaymentResultDTO> GetDistributorAuthorityPay(DistributorAuthoritySearchDTO dto) { List <DistributorPaymentResultDTO> result = null; var tcdmse = SingleQueryObject.GetObj(); var pp = tcdmse.master_DistributorPayInfo.AsNoTracking().Where(p => p.DistributorPayID != null); if (dto.DistributorID != null) { pp = pp.Where(p => p.DistributorID == dto.DistributorID); } result = Mapper.Map <List <master_DistributorPayInfo>, List <DistributorPaymentResultDTO> >(pp.ToList()); return(result); }
/// <summary> /// 得到经销商信息(开头字符为查询条件) /// </summary> /// <returns></returns> public List <DistributorBaseDTO> GetDistributorBaseInfoByName(string DistributorName) { List <DistributorBaseDTO> result = null; var tcdmse = SingleQueryObject.GetObj(); if (!string.IsNullOrEmpty(DistributorName)) { result = tcdmse.master_DistributorInfo.AsNoTracking().Where(m => m.DistributorName.StartsWith(DistributorName)).Take(15).Select(m => new DistributorBaseDTO { DistributorID = m.DistributorID, DistributorName = m.DistributorName }).ToList(); } return(result); }
/// <summary> /// 得到经销商公告授权信息 /// </summary> /// <returns></returns> public List <DistributorAnnounceAuthorityResultDTO> GetDistributorAnnounceAuthorityList(DistributorAnnounceAuthoritySearchDTO dto) { List <DistributorAnnounceAuthorityResultDTO> result = null; var tcdmse = SingleQueryObject.GetObj(); var pp = tcdmse.master_DistributorInfo.AsNoTracking().Where(p => p.DistributorID != null); if (!string.IsNullOrEmpty(dto.SearchText)) { pp = pp.Where(p => p.DistributorName.Contains(dto.SearchText)); } dto.Count = pp.Count(); pp = pp.OrderBy(m => m.DistributorCode).Skip((dto.page - 1) * dto.rows).Take(dto.rows); result = Mapper.Map <List <master_DistributorInfo>, List <DistributorAnnounceAuthorityResultDTO> >(pp.ToList()); return(result); }