/// <summary> /// 根据关键字搜索客户信息 /// </summary> /// <param name="KeyWord"></param> /// <param name="TopSize"></param> /// <returns></returns> public List <CusAddressEntity> SearchCustomer(string KeyWord, int TopSize) { CusAddressEntity entity = new CusAddressEntity(); entity.IncludeAll(); entity.OrderBy(a => a.ID, EOrderBy.DESC); entity.Where(a => a.CompanyID == this.CompanyID); CustomerEntity customer = new CustomerEntity(); customer.Include(a => new { CusNum = a.CusNum, CusName = a.CusName, CusType = a.CusType, Fax = a.Fax, Email = a.Email }); entity.Left <CustomerEntity>(customer, new Params <string, string>() { Item1 = "CustomerSN", Item2 = "SnNum" }); customer.And(a => a.IsDelete == (int)EIsDelete.NotDelete); PageInfo pageInfo = new PageInfo() { PageIndex = 1, PageSize = 10 }; customer.AndBegin <CustomerEntity>() .Or <CustomerEntity>("CusNum", ECondition.Like, "%" + KeyWord + "%") .Or <CustomerEntity>("CusName", ECondition.Like, "%" + KeyWord + "%") .Or <CustomerEntity>("Phone", ECondition.Like, "%" + KeyWord + "%") .End(); int rowCount = 0; List <CusAddressEntity> listResult = this.CusAddress.GetList(entity, pageInfo.PageSize, pageInfo.PageIndex, out rowCount); pageInfo.RowCount = rowCount; return(listResult); }
/// <summary> /// 获得所有的地址 /// </summary> /// <param name="cusNum"></param> /// <returns></returns> public List <CusAddressEntity> GetAddressList(string cusNum) { CusAddressEntity entity = new CusAddressEntity(); entity.IncludeAll(); entity.Where <CusAddressEntity>(a => a.CusNum == cusNum).And <CusAddressEntity>(a => a.IsDelete == (int)EIsDelete.NotDelete); List <CusAddressEntity> listResult = this.CusAddress.GetList(entity); return(listResult); }
/// <summary> /// 添加地址 /// </summary> /// <param name="entity"></param> /// <returns></returns> public int AddCusAddress(CusAddressEntity entity) { entity.IncludeAll(); int line = this.CusAddress.Add(entity); if (line > 0) { CacheHelper.Remove(CacheKey.JOOSHOW_CUSADDRESS_CACHE); } return(line); }
/// <summary> /// 根据收货单位编号获得地址信息 /// </summary> /// <param name="snNum"></param> /// <returns></returns> public CusAddressEntity GetSingleAddress(string SnNum) { CusAddressEntity entity = new CusAddressEntity(); entity.IncludeAll(); entity.Where(a => a.SnNum == SnNum) .And(a => a.CompanyID == this.CompanyID) ; entity = this.CusAddress.GetSingle(entity); return(entity); }
/// <summary> /// 获得所有的地址 /// </summary> /// <param name="cusNum"></param> /// <returns></returns> public List <CusAddressEntity> GetAddressList(string CustomerSN) { CusAddressEntity entity = new CusAddressEntity(); entity.IncludeAll(); entity.Where <CusAddressEntity>(a => a.CustomerSN == CustomerSN) .And <CusAddressEntity>(a => a.IsDelete == (int)EIsDelete.NotDelete) .And(a => a.CompanyID == this.CompanyID); List <CusAddressEntity> listResult = this.CusAddress.GetList(entity); return(listResult); }
/// <summary> /// 根据收货单位编号获得地址信息 /// </summary> /// <param name="snNum"></param> /// <returns></returns> public CusAddressEntity GetSingleAddress(string snNum) { try { CusAddressEntity entity = new CusAddressEntity(); entity.IncludeAll(); entity.Where(a => a.SnNum == snNum); entity = this.CusAddress.GetSingle(entity); return(entity); } catch { return(null); } }
/// <summary> /// 修改 /// </summary> /// <param name="entity"></param> /// <param name="list"></param> /// <returns></returns> public int Update(CustomerEntity entity, List <CusAddressEntity> list) { entity.IncludeCusName(true) .IncludeEmail(true) .IncludeFax(true) .IncludePhone(true) .IncludeRemark(true) .IncludeCusType(true) ; entity.Where(a => a.CusNum == entity.CusNum); int line = this.Customer.Update(entity); if (!list.IsNullOrEmpty()) { foreach (CusAddressEntity item in list) { item.CusNum = entity.CusNum; CusAddressEntity tempEntity = new CusAddressEntity(); tempEntity.IncludeAll(); tempEntity.Where(a => a.CusNum == item.CusNum).And(a => a.SnNum == item.SnNum); tempEntity = this.CusAddress.GetSingle(tempEntity); if (tempEntity.IsNotNull()) { item.IncludeAddress(true) .IncludeContact(true) .IncludePhone(true) ; item.Where(a => a.SnNum == item.SnNum).And(a => a.CusNum == item.CusNum); line += this.CusAddress.Update(item); } else { item.IncludeAll(); line = this.CusAddress.Add(item); } } if (line > 0) { CacheHelper.Remove(CacheKey.JOOSHOW_CUSADDRESS_CACHE); } } return(line); }
/// <summary> /// 查询客户地址分页列表 /// </summary> /// <param name="entity"></param> /// <param name="pageInfo"></param> /// <returns></returns> public List <CusAddressEntity> GetList(CusAddressEntity entity, ref PageInfo pageInfo) { entity.IncludeAll(); entity.OrderBy(a => a.ID, EOrderBy.DESC); entity.Where(a => a.CompanyID == this.CompanyID) .And(a => a.IsDelete == (int)EIsDelete.NotDelete); CustomerEntity customer = new CustomerEntity(); customer.Include(a => new { CusNum = a.CusNum, CusName = a.CusName, CusType = a.CusType, Fax = a.Fax, Email = a.Email }); entity.Left <CustomerEntity>(customer, new Params <string, string>() { Item1 = "CustomerSN", Item2 = "SnNum" }); customer.And(a => a.IsDelete == (int)EIsDelete.NotDelete); if (entity.CusType > 0) { customer.And(item => item.CusType == entity.CusType); } if (!entity.Address.IsEmpty()) { entity.And("Address", ECondition.Like, "%" + entity.Address + "%"); } if (!entity.Phone.IsEmpty()) { entity.And("Phone", ECondition.Like, "%" + entity.Phone + "%"); } if (!entity.CusNum.IsEmpty()) { customer.And("CusNum", ECondition.Like, "%" + entity.CusNum + "%"); } if (!entity.CusName.IsEmpty()) { customer.And("CusName", ECondition.Like, "%" + entity.CusName + "%"); } int rowCount = 0; List <CusAddressEntity> listResult = this.CusAddress.GetList(entity, pageInfo.PageSize, pageInfo.PageIndex, out rowCount); pageInfo.RowCount = rowCount; return(listResult); }
/// <summary> /// 修改 /// </summary> /// <param name="entity"></param> /// <param name="list"></param> /// <returns></returns> public int Update(CustomerEntity entity, List <CusAddressEntity> list) { string Key = string.Format(CacheKey.JOOSHOW_CUSADDRESS_CACHE, this.CompanyID); entity.IncludeCusName(true) .IncludeEmail(true) .IncludeFax(true) .IncludePhone(true) .IncludeRemark(true) .IncludeCusType(true) .IncludeCusNum(true) ; entity.Where(a => a.SnNum == entity.SnNum); int line = this.Customer.Update(entity); if (!list.IsNullOrEmpty()) { CusAddressEntity addSource = new CusAddressEntity(); addSource.IncludeAll(); addSource.Where(a => a.CustomerSN == entity.SnNum) .And(a => a.IsDelete == (int)EIsDelete.NotDelete) ; List <CusAddressEntity> listSource = this.CusAddress.GetList(addSource); listSource = listSource.IsNull() ? new List <CusAddressEntity>() : listSource; //处理未删除的 foreach (CusAddressEntity item in list.Where(a => a.IsDelete == (int)EIsDelete.NotDelete)) { if (listSource.Exists(a => a.SnNum == item.SnNum)) { item.Include(a => new { a.Contact, a.Phone, a.Address, a.Remark }); item.Where(a => a.SnNum == item.SnNum); line += this.CusAddress.Update(item); } else { item.IncludeAll(); item.CustomerSN = entity.SnNum; item.CreateTime = DateTime.Now; item.IsDelete = (int)EIsDelete.NotDelete; item.CompanyID = this.CompanyID; line += this.CusAddress.Add(item); } } //处理删除的 foreach (CusAddressEntity item in listSource) { if (!list.Exists(a => a.SnNum == item.SnNum)) { item.IsDelete = (int)EIsDelete.Deleted; item.IncludeIsDelete(true); item.Where(a => a.SnNum == item.SnNum); line += this.CusAddress.Update(item); } } } if (line > 0) { CacheHelper.Remove(Key); } return(line); }