/// <summary>
/// 删除地址
/// </summary>
/// <param name="snNum"></param>
/// <param name="cusNum"></param>
/// <returns></returns>
public int DelCusAddress(string snNum, string cusNum)
{
int line = 0;
List <CusAddressEntity> list = GetAddressList(cusNum);
list.ForEach(a =>
{
if (!snNum.IsNullOrEmpty() && !cusNum.IsNullOrEmpty())
{
CusAddressEntity entity = new CusAddressEntity();
entity.IncludeIsDelete(true);
entity.IsDelete = (int)EIsDelete.Deleted;
entity.Where(c => c.SnNum == snNum).And(c => c.CusNum == cusNum);
line += this.CusAddress.Update(entity);
if (a.SnNum == snNum)
{
a.IsDelete = (int)EIsDelete.Deleted;
line++;
}
}
else
{
if (a.SnNum == snNum)
{
a.IsDelete = (int)EIsDelete.Deleted;
line++;
}
}
});
list.Remove(a => a.IsDelete == (int)EIsDelete.Deleted);
CacheHelper.Insert(CacheKey.JOOSHOW_CUSADDRESS_CACHE, list);
return(line);
}
/// <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="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="SnNum"></param>
/// <param name="CustomerSN"></param>
/// <returns></returns>
public int DeleteAddress(string SnNum, string CustomerSN)
{
CusAddressEntity entity = new CusAddressEntity();
entity.IsDelete = (int)EIsDelete.Deleted;
entity.IncludeIsDelete(true);
entity.Where(a => a.SnNum == SnNum)
.And(a => a.CustomerSN == CustomerSN);
int line = this.CusAddress.Update(entity);
return(line);
}
/// <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);
}
