/// <summary> /// 我的客户信息 /// </summary> /// <returns></returns> public ActionResult Index() { var model = new CustomerCompanySearchViewModel(); ViewBag.Data_CustomerCompany_CustomerCateID = Utilities.GetSelectListData( CustomerCateService.GetALL() .Where(x => x.ID != 6), x => x.ID, x => x.CateName, true, true); return View(model); }
/// <summary> /// 客户信息查询处理 /// </summary> /// <param name="model"></param> /// <returns></returns> private IQueryable<CustomerCompany> GetSearch(CustomerCompanySearchViewModel model) { var query = CustomerCompanyService.GetALL() .Include(x => x.AddMember) .Include(x => x.CustomerCate) .Include(x => x.Customer); if (!string.IsNullOrEmpty(model.CustomerCompany_SearchName)) { query = query.Where(x => x.Name.Contains(model.CustomerCompany_SearchName)); } if (!string.IsNullOrEmpty(model.CustomerCompany_BrandName)) { query = query.Where(x => x.BrandName.Contains(model.CustomerCompany_BrandName)); } if (!string.IsNullOrEmpty(model.CustomerCompany_Customer)) { query = query.Where(x => x.Customer.Any(c => c.Name.Contains(model.CustomerCompany_Customer))); } if (!string.IsNullOrEmpty(model.CustomerCompany_UserName)) { query = query.Where(x => x.AddMember.NickName.Contains(model.CustomerCompany_UserName)); } if (model.CustomerCompany_CustomerCateID != 0) { query = query.Where(x => x.CustomerCateID == model.CustomerCompany_CustomerCateID); } if (!string.IsNullOrEmpty(model.CustomerCompany_Mobile)) { query = query.Where(x => x.Customer.Any(c => c.Mobile.Contains(model.CustomerCompany_Mobile) || c.Mobile1.Contains(model.CustomerCompany_Mobile))); } if (!string.IsNullOrEmpty(model.CustomerCompany_Phone)) { query = query.Where(x => x.Customer.Any(c => c.Phone.Contains(model.CustomerCompany_Phone)) || x.Phone.Contains(model.CustomerCompany_Phone)); } if (!string.IsNullOrEmpty(model.CustomerCompany_QQ)) { query = query.Where(x => x.Customer.Any(c => c.QQ.Contains(model.CustomerCompany_QQ))); } if (!string.IsNullOrEmpty(model.CustomerCompany_Address)) { query = query.Where(x => x.Customer.Any(c => c.Address.Contains(model.CustomerCompany_Address)) || x.Address.Contains(model.CustomerCompany_Address)); } if (!string.IsNullOrEmpty(model.CustomerCompany_Fax)) { query = query.Where(x => x.Fax.Contains(model.CustomerCompany_Fax)); } //if (CookieHelper.CheckPermission("boss")) //{ //} //else if (CookieHelper.CheckPermission("manager")) //{ // var memberIds = MemberService.GetMemberIDs(CookieHelper.GetDepartmentID()); // query = query.Where(x => memberIds.Contains(x.AddUser)); //} //else //{ // query = query.Where(x => x.AddUser == CookieHelper.MemberID); //} if (model.CustomerCompany_IsInTime) { query = query.Where(x => x.AddTime < model.CustomerCompany_EndTime && x.AddTime > model.CustomerCompany_StartTime); } query = query.Where(x => x.Status > (int)CustomerCompanyStatus.Delete && x.CustomerCateID != 6 ).OrderByDescending(x => x.AddTime); return query; }
/// <summary> /// 我的客户信息读取 /// </summary> /// <param name="model"></param> /// <param name="page"></param> /// <param name="rows"></param> /// <returns></returns> public ActionResult getall(CustomerCompanySearchViewModel model, int page = 1, int rows = 10) { var query = GetSearch(model); var count = query.Count(); var data = query.Select(x => new CustomerCompanyListViewModel() { ID = x.ID, Name = x.Name, BrandName = x.BrandName, CityID = x.CityID, CityValue = x.CityValue, IndustryID = x.IndustryID, IndustryValue = x.IndustryValue, CustomerCateID = x.CustomerCateID, CustomerCateName = x.CustomerCate.CateName, CoopCateID = x.CoopCateID, SourceCateID = x.SourceCateID, Fax = x.Fax, Phone = x.Phone, Address = x.Address, Description = x.Description, IsCommon = x.IsCommon, AddTime = x.AddTime, LastTime = x.LastTime, Status = x.Status, AddUser = x.AddUser, AddUserName = x.AddMember.NickName, LastUser = x.LastUser, Visits = x.Visits, Finance = x.Finance, FinancePhone = x.FinancePhone, ProxyName = x.ProxyName, ProxyAddress = x.ProxyAddress, ProxyPhone = x.ProxyPhone, RelationID = x.RelationID, }) .OrderBy(x => x.ID) .Skip((page - 1) * rows) .Take(rows).ToList(); foreach (var item in data) { item.CityValue = CityCateService.GetCascadingName(item.CityValue); item.IndustryValue = CityCateService.GetCascadingName(item.IndustryValue); } var obj = new { rows = data, total = count }; return Json(obj); }