/// <summary>
/// 查询销售单详细分页
/// </summary>
/// <returns></returns>
public ActionResult GetDetailList()
{
string CompanyID = WebUtil.GetFormValue <string>("CompanyID");
int PageIndex = WebUtil.GetFormValue <int>("PageIndex", 1);
int PageSize = WebUtil.GetFormValue <int>("PageSize", 10);
string OrderNum = WebUtil.GetFormValue <string>("OrderNum");
string CusNum = WebUtil.GetFormValue <string>("CusNum");
string CusName = WebUtil.GetFormValue <string>("CusName");
string Contact = WebUtil.GetFormValue <string>("Contact");
string Phone = WebUtil.GetFormValue <string>("Phone");
string SaleSnNum = WebUtil.GetFormValue <string>("SaleSnNum");
string SaleOrderNum = WebUtil.GetFormValue <string>("SaleOrderNum");
string BarCode = WebUtil.GetFormValue <string>("BarCode");
string ProductName = WebUtil.GetFormValue <string>("ProductName");
int Status = WebUtil.GetFormValue <int>("Status", 0);
string BeginTime = WebUtil.GetFormValue <string>("BeginTime");
string EndTime = WebUtil.GetFormValue <string>("EndTime");
SaleReturnDetailEntity entity = new SaleReturnDetailEntity();
entity.OrderNum = OrderNum;
entity.CusNum = CusNum;
entity.CusName = CusName;
entity.Contact = Contact;
entity.Phone = Phone;
entity.BarCode = BarCode;
entity.ProductName = ProductName;
entity.SaleSnNum = SaleSnNum;
entity.SaleOrderNum = SaleOrderNum;
entity.Status = Status;
entity.BeginTime = BeginTime;
entity.EndTime = EndTime;
PageInfo pageInfo = new PageInfo()
{
PageIndex = PageIndex, PageSize = PageSize
};
Bill <SaleReturnEntity, SaleReturnDetailEntity> bill = new SaleReturnOrder(CompanyID);
List <SaleReturnDetailEntity> listResult = bill.GetDetailList(entity, ref pageInfo);
DataListResult <SaleReturnDetailEntity> dataResult = new DataListResult <SaleReturnDetailEntity>()
{
Code = (int)EResponseCode.Success,
Message = "响应成功",
Result = listResult,
PageInfo = pageInfo
};
return(Content(JsonHelper.SerializeObject(dataResult)));
}
/// <summary>
/// 查询销售退货订单
/// </summary>
/// <returns></returns>
public ActionResult GetDetail()
{
string SnNum = WebUtil.GetFormValue <string>("SnNum");
string CompanyID = WebUtil.GetFormValue <string>("CompanyID", string.Empty);
SaleReturnDetailEntity entity = new SaleReturnDetailEntity();
entity.OrderSnNum = SnNum;
entity.CompanyID = CompanyID;
Bill <SaleReturnEntity, SaleReturnDetailEntity> bill = new SaleReturnOrder(CompanyID);
List <SaleReturnDetailEntity> list = bill.GetOrderDetail(entity);
DataResult <List <SaleReturnDetailEntity> > dataResult = new DataResult <List <SaleReturnDetailEntity> >();
dataResult.Code = (int)EResponseCode.Success;
dataResult.Message = "响应成功";
dataResult.Result = list;
return(Content(JsonHelper.SerializeObject(dataResult)));
}
/// <summary>
/// 销售退货单
/// </summary>
/// <param name="SnNum"></param>
/// <param name="list"></param>
/// <returns></returns>
public DataResult ToReturn(string SnNum, List <SaleDetailEntity> list)
{
SaleOrderEntity entity = new SaleOrderEntity();
entity.SnNum = SnNum;
entity = this.GetOrder(entity);
DataResult result = new DataResult();
if (entity == null)
{
result.Code = 1001;
result.Message = "销售订单不存在";
return(result);
}
if (!(entity.Status == (int)EOrderStatus.PartialDelivery || entity.Status == (int)EOrderStatus.AllDelivery))
{
result.Code = 1002;
result.Message = "该销售订单未发货,不能申请退货";
return(result);
}
SaleDetailEntity detailEntity = new SaleDetailEntity();
detailEntity.OrderSnNum = SnNum;
List <SaleDetailEntity> listSource = this.GetOrderDetail(detailEntity);
if (listSource.IsNullOrEmpty())
{
result.Code = 1003;
result.Message = "销售订单中不存在出库货品";
return(result);
}
foreach (SaleDetailEntity item in list)
{
if (item.Qty > 0)
{
SaleReturnDetailEntity returnDetail = new SaleReturnDetailEntity();
returnDetail.IncludeAll();
returnDetail
.Where(a => a.CompanyID == this.CompanyID)
.And(a => a.SaleDetailSn == item.SnNum)
;
List <SaleReturnDetailEntity> listDetail = this.SaleReturnDetail.GetList(returnDetail);
if (listDetail != null && listDetail.Where(a => a.SaleDetailSn == item.SnNum).Sum(a => a.ReturnNum) >= item.Num)
{
result.Code = 1006;
result.Message = string.Format("货品[{0}]已经全部退货,请勿重复申请退货", item.ProductName);
return(result);
}
}
}
string returnValue = string.Empty;
using (TransactionScope ts = new TransactionScope())
{
Bill <SaleReturnEntity, SaleReturnDetailEntity> bill = new SaleReturnOrder(this.CompanyID);
SaleReturnEntity SaleReturnEntity = new SaleReturnEntity();
SaleReturnEntity.CusSnNum = entity.CusSnNum;
SaleReturnEntity.CusNum = entity.CusNum;
SaleReturnEntity.CusName = entity.CusName;
SaleReturnEntity.Contact = entity.Contact;
SaleReturnEntity.Phone = entity.Phone;
SaleReturnEntity.SaleSnNum = entity.SnNum;
SaleReturnEntity.SaleOrderNum = entity.OrderNum;
SaleReturnEntity.CompanyID = this.CompanyID;
List <SaleReturnDetailEntity> listReturnDetail = new List <SaleReturnDetailEntity>();
foreach (SaleDetailEntity item in list)
{
if (item.Qty > 0)
{
SaleReturnDetailEntity DetailEntity = new SaleReturnDetailEntity();
DetailEntity.SnNum = ConvertHelper.NewGuid();
DetailEntity.ProductName = item.ProductName;
DetailEntity.BarCode = item.BarCode;
DetailEntity.ProductNum = item.ProductNum;
DetailEntity.Num = item.Num;
DetailEntity.ReturnNum = item.Qty;
DetailEntity.UnitNum = item.UnitNum;
DetailEntity.Price = item.Price;
DetailEntity.Amount = item.Price * item.Qty;
DetailEntity.ReturnTime = DateTime.Now;
DetailEntity.SaleDetailSn = item.SnNum;
DetailEntity.CompanyID = this.CompanyID;
DetailEntity.CreateTime = DateTime.Now;
listReturnDetail.Add(DetailEntity);
}
}
returnValue = bill.Create(SaleReturnEntity, listReturnDetail);
if (EnumHelper.GetEnumDesc <EReturnStatus>(EReturnStatus.Success) == returnValue)
{
Task.Factory.StartNew(() =>
{
foreach (SaleDetailEntity DetailItem in listSource)
{
SaleReturnDetailEntity returnDetail = new SaleReturnDetailEntity();
returnDetail.IncludeAll();
returnDetail
.Where(a => a.CompanyID == this.CompanyID)
.And(a => a.SaleDetailSn == DetailItem.SnNum)
;
SaleReturnEntity returnItem = new SaleReturnEntity();
returnItem.And(a => a.IsDelete == (int)EIsDelete.NotDelete)
;
returnDetail.Left <SaleReturnEntity>(returnItem, new Params <string, string>()
{
Item1 = "OrderSnNum", Item2 = "SnNum"
});
List <SaleReturnDetailEntity> listDetail = this.SaleReturnDetail.GetList(returnDetail);
if (!listDetail.IsNullOrEmpty())
{
double ReturnNum = listDetail.Sum(a => a.ReturnNum);
DetailItem.IncludeReturnNum(true);
DetailItem.ReturnNum = ReturnNum;
DetailItem.Where(a => a.SnNum == DetailItem.SnNum).And(a => a.CompanyID == this.CompanyID);
this.SaleDetail.Update(DetailItem);
}
}
SaleOrderEntity SaleItem = new SaleOrderEntity();
SaleItem.HasReturn = (int)EBool.Yes;
SaleItem.IncludeHasReturn(true);
SaleItem.Where(a => a.SnNum == SnNum).And(a => a.CompanyID == this.CompanyID);
this.SaleOrder.Update(SaleItem);
});
result.Code = (int)EResponseCode.Success;
result.Message = "销售退货单创建成功";
}
else
{
result.Code = (int)EResponseCode.Exception;
result.Message = "销售退货单创建失败";
}
ts.Complete();
}
return(result);
}
