/// <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>
/// <returns></returns>
public ActionResult GetAddressListPage()
{
string CompanyID = WebUtil.GetFormValue <string>("CompanyID");
int PageIndex = WebUtil.GetFormValue <int>("PageIndex", 1);
int PageSize = WebUtil.GetFormValue <int>("PageSize", 10);
string Address = WebUtil.GetFormValue <string>("Address", string.Empty);
string Phone = WebUtil.GetFormValue <string>("Phone", string.Empty);
string CusNum = WebUtil.GetFormValue <string>("CusNum", string.Empty);
string CusName = WebUtil.GetFormValue <string>("CusName", string.Empty);
int CusType = WebUtil.GetFormValue <int>("CusType", 0);
CusAddressEntity entity = new CusAddressEntity();
entity.Address = Address;
entity.Phone = Phone;
entity.CusNum = CusNum;
entity.CusName = CusName;
PageInfo pageInfo = new PageInfo();
pageInfo.PageIndex = PageIndex;
pageInfo.PageSize = PageSize;
CustomerProvider provider = new CustomerProvider(CompanyID);
List <CusAddressEntity> list = provider.GetList(entity, ref pageInfo);
DataListResult <CusAddressEntity> result = new DataListResult <CusAddressEntity>()
{
Code = (int)EResponseCode.Success, Message = "响应成功", Result = list, PageInfo = pageInfo
};
return(Content(JsonHelper.SerializeObject(result)));
}
/// <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);
}
public ActionResult AddAddress([ModelBinder(typeof(JsonBinder <CusAddressEntity>))] CusAddressEntity entity)
{
List <CusAddressEntity> list = Session[CacheKey.JOOSHOW_CUSADDRESS_CACHE] as List <CusAddressEntity>;
list = list == null ? new List <CusAddressEntity>() : list;
if (entity.SnNum.IsEmpty())
{
entity.CreateTime = DateTime.Now;
entity.SnNum = SequenceProvider.GetSequence(typeof(CusAddressEntity));
list.Add(entity);
this.ReturnJson.AddProperty("d", "success");
}
else
{
list.ForEach(a =>
{
if (a.SnNum == entity.SnNum)
{
a.Address = entity.Address;
a.Contact = entity.Contact;
a.Phone = entity.Phone;
}
});
this.ReturnJson.AddProperty("d", "success");
}
Session[CacheKey.JOOSHOW_CUSADDRESS_CACHE] = list;
return(Content(this.ReturnJson.ToString()));
}
public ActionResult Address()
{
string SnNum = WebUtil.GetQueryStringValue <string>("SnNum", string.Empty);
if (SnNum.IsEmpty())
{
ViewBag.CusAddress = new CusAddressEntity();
return(View());
}
else
{
List <CusAddressEntity> list = Session[CacheKey.JOOSHOW_CUSADDRESS_CACHE] as List <CusAddressEntity>;
if (!list.IsNullOrEmpty())
{
CusAddressEntity entity = list.FirstOrDefault(a => a.SnNum == SnNum);
entity = entity.IsNull() ? new CusAddressEntity() : entity;
ViewBag.CusAddress = entity;
}
else
{
CustomerProvider provider = new CustomerProvider();
CusAddressEntity entity = provider.GetSingleAddress(SnNum);
entity = entity == null ? new CusAddressEntity() : entity;
ViewBag.CusAddress = entity;
}
return(View());
}
}
/// <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="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>
/// <returns></returns>
public ActionResult GetAddress()
{
string CompanyID = WebUtil.GetFormValue <string>("CompanyID");
string SnNum = WebUtil.GetFormValue <string>("SnNum");
CustomerProvider provider = new CustomerProvider(CompanyID);
CusAddressEntity entity = provider.GetSingleAddress(SnNum);
DataResult <CusAddressEntity> result = new DataResult <CusAddressEntity>()
{
Code = (int)EResponseCode.Success, Message = "响应成功", Result = entity
};
return(Content(JsonHelper.SerializeObject(result)));
}
/// <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);
}
}
public ActionResult AddAddress()
{
string SnNum = WebUtil.GetFormValue <string>("SnNum");
string CustomerSN = WebUtil.GetFormValue <string>("CustomerSN");
string Contact = WebUtil.GetFormValue <string>("Contact");
string Phone = WebUtil.GetFormValue <string>("Phone");
string Address = WebUtil.GetFormValue <string>("Address");
string Remark = WebUtil.GetFormValue <string>("Remark");
SnNum = SnNum.IsEmpty() ? ConvertHelper.NewGuid() : SnNum;
List <CusAddressEntity> listAddress = Session[SessionKey.SESSION_CUSTOMER_ADDRESS] as List <CusAddressEntity>;
listAddress = listAddress.IsNull() ? new List <CusAddressEntity>() : listAddress;
if (!SnNum.IsEmpty() && listAddress.Exists(a => a.SnNum == SnNum))
{
CusAddressEntity entity = listAddress.First(a => a.SnNum == SnNum);
entity.CustomerSN = CustomerSN;
entity.Contact = Contact;
entity.Phone = Phone;
entity.Address = Address;
entity.Remark = Remark;
}
else
{
CusAddressEntity entity = new CusAddressEntity();
entity.SnNum = SnNum;
entity.CustomerSN = CustomerSN;
entity.Contact = Contact;
entity.Phone = Phone;
entity.Address = Address;
entity.IsDelete = (int)EIsDelete.NotDelete;
entity.CreateTime = DateTime.Now;
entity.CreateUser = this.LoginUser.UserNum;
entity.Remark = Remark;
entity.CompanyID = this.CompanyID;
listAddress.Add(entity);
}
Session[SessionKey.SESSION_CUSTOMER_ADDRESS] = listAddress;
DataResult dataResult = new DataResult();
dataResult.Code = (int)EResponseCode.Success;
dataResult.Message = "操作成功";
string result = JsonConvert.SerializeObject(dataResult);
return(Content(result));
}
public static CusAddress_CE ToCE(CusAddressEntity item)
{
CusAddress_CE target = new CusAddress_CE();
target.ID = item.ID;
target.SnNum = item.SnNum;
target.CusNum = item.CusNum;
target.Contact = item.Contact;
target.Phone = item.Phone;
target.Address = item.Address;
target.IsDelete = item.IsDelete;
target.CreateTime = item.CreateTime;
target.CreateUser = item.CreateUser;
target.Remark = item.Remark;
return(target);
}
public ActionResult Address()
{
string SnNum = WebUtil.GetQueryStringValue <string>("SnNum");
CusAddressEntity entity = null;
ITopClient client = new TopClientDefault();
if (!SnNum.IsEmpty())
{
List <CusAddressEntity> listAddress = Session[SessionKey.SESSION_CUSTOMER_ADDRESS] as List <CusAddressEntity>;
listAddress = listAddress.IsNull() ? new List <CusAddressEntity>() : listAddress;
entity = listAddress.FirstOrDefault(a => a.SnNum == SnNum);
}
entity = entity.IsNull() ? new CusAddressEntity() : entity;
ViewBag.Entity = entity;
return(View());
}
public ActionResult GetContact()
{
string snNum = WebUtil.GetFormValue <string>("SnNum", string.Empty);
CustomerProvider provider = new CustomerProvider();
CusAddressEntity entity = new CusAddressEntity();
entity = provider.GetSingleAddress(snNum);
if (entity.IsNotNull())
{
StringBuilder sb = new StringBuilder();
List <CusAddressEntity> listResult = new List <CusAddressEntity>();
listResult.Add(entity);
string json = ConvertJson.ListToJson(listResult, "List");
this.ReturnJson.AddProperty("Data", new JsonObject(json));
}
return(Content(this.ReturnJson.ToString()));
}
/// <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)
{
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="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);
}
