/// <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 OrderSnNum = WebUtil.GetFormValue <string>("OrderSnNum");
string OrderNum = WebUtil.GetFormValue <string>("OrderNum");
int OrderType = WebUtil.GetFormValue <int>("OrderType", 0);
string CusName = WebUtil.GetFormValue <string>("CusName", string.Empty);
string CusNum = WebUtil.GetFormValue <string>("CusNum", string.Empty);
string Phone = WebUtil.GetFormValue <string>("Phone", string.Empty);
int Status = WebUtil.GetFormValue <int>("Status", 0);
int AuditeStatus = WebUtil.GetFormValue <int>("AuditeStatus", 0);
string ContractOrder = WebUtil.GetFormValue <string>("ContractOrder", string.Empty);
string CusOrderNum = WebUtil.GetFormValue <string>("CusOrderNum", string.Empty);
string BarCode = WebUtil.GetFormValue <string>("BarCode", string.Empty);
string ProductName = WebUtil.GetFormValue <string>("ProductName", string.Empty);
string BeginTime = WebUtil.GetFormValue <string>("BeginTime", string.Empty);
string EndTime = WebUtil.GetFormValue <string>("EndTime", string.Empty);
SaleDetailEntity entity = new SaleDetailEntity();
entity.CompanyID = CompanyID;
entity.OrderSnNum = OrderSnNum;
entity.OrderNum = OrderNum;
entity.CusName = CusName;
entity.CusNum = CusNum;
entity.Phone = Phone;
entity.Status = Status;
entity.AuditeStatus = AuditeStatus;
entity.ContractOrder = ContractOrder;
entity.CusOrderNum = CusOrderNum;
entity.BarCode = BarCode;
entity.ProductName = ProductName;
entity.BeginTime = BeginTime;
entity.EndTime = EndTime;
PageInfo pageInfo = new PageInfo()
{
PageIndex = PageIndex, PageSize = PageSize
};
Bill <SaleOrderEntity, SaleDetailEntity> bill = new SaleOrder(CompanyID);
List <SaleDetailEntity> listResult = bill.GetDetailList(entity, ref pageInfo);
DataListResult <SaleDetailEntity> dataResult = new DataListResult <SaleDetailEntity>()
{
Code = (int)EResponseCode.Success,
Message = "响应成功",
Result = listResult,
PageInfo = pageInfo
};
return(Content(JsonHelper.SerializeObject(dataResult)));
}
public ActionResult AddProduct()
{
List <SaleDetailEntity> listDetail = Session[SessionKey.SESSION_SALEORDER_DETAIL] as List <SaleDetailEntity>;
listDetail = listDetail.IsNull() ? new List <SaleDetailEntity>() : listDetail;
List <SaleDetailEntity> list = WebUtil.GetFormObject <List <SaleDetailEntity> >("List");
if (!list.IsNullOrEmpty())
{
foreach (SaleDetailEntity item in list)
{
if (listDetail.Exists(a => a.ProductNum == item.ProductNum))
{
SaleDetailEntity entity = listDetail.First(a => a.ProductNum == item.ProductNum);
entity.Num = entity.Num + item.Num;
entity.Amount = entity.Price * entity.Num;
}
else
{
SaleDetailEntity entity = new SaleDetailEntity();
entity.SnNum = ConvertHelper.NewGuid();
entity.ProductName = item.ProductName;
entity.BarCode = item.BarCode;
entity.ProductNum = item.ProductNum;
entity.Num = item.Num;
entity.UnitNum = item.UnitNum;
entity.UnitName = item.UnitName;
entity.Price = item.Price;
entity.Amount = entity.Price * entity.Num;
entity.Status = (int)EOrderStatus.CreateOrder;
entity.CreateTime = DateTime.Now;
entity.CompanyID = this.CompanyID;
entity.Size = item.Size;
listDetail.Add(entity);
}
}
}
Session[SessionKey.SESSION_SALEORDER_DETAIL] = listDetail;
DataResult dataResult = new DataResult()
{
Code = (int)EResponseCode.Success,
Message = "响应成功"
};
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);
SaleDetailEntity entity = new SaleDetailEntity();
entity.OrderSnNum = SnNum;
entity.CompanyID = CompanyID;
Bill <SaleOrderEntity, SaleDetailEntity> bill = new SaleOrder(CompanyID);
List <SaleDetailEntity> list = bill.GetOrderDetail(entity);
DataResult <List <SaleDetailEntity> > dataResult = new DataResult <List <SaleDetailEntity> >();
dataResult.Code = (int)EResponseCode.Success;
dataResult.Message = "响应成功";
dataResult.Result = list;
return(Content(JsonHelper.SerializeObject(dataResult)));
}
/// <summary>
/// 根据销售订单转换为出库单
/// </summary>
/// <param name="SnNum"></param>
/// <returns></returns>
public DataResult ToOutStorage(string SnNum, List <SaleDetailEntity> list, string StorageNum)
{
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.CreateOrder)
{
result.Code = 1001;
result.Message = "销售订单审核流程不正确,不能生成出库单";
return(result);
}
if (entity.Status == (int)EPurchaseStatus.AllIn)
{
result.Code = 1002;
result.Message = "销售订单已经全部出库,请勿重新出库";
return(result);
}
if (entity.Status == (int)EPurchaseStatus.OrderCancel)
{
result.Code = 1003;
result.Message = "订单已经被取消,不能出库";
return(result);
}
SaleDetailEntity detailEntity = new SaleDetailEntity();
detailEntity.OrderSnNum = SnNum;
List <SaleDetailEntity> listSource = this.GetOrderDetail(detailEntity);
if (listSource.IsNullOrEmpty())
{
result.Code = 1004;
result.Message = "销售订单中不存在出库货品";
return(result);
}
//检查入库产品是否在采购单内
List <SaleDetailEntity> listExists = new List <SaleDetailEntity>();
foreach (SaleDetailEntity item in list)
{
if (!listSource.Exists(a => a.SnNum == item.SnNum))
{
//不存在添加到集合
listExists.Add(item);
}
}
if (!listExists.IsNullOrEmpty())
{
string content = listExists.Select(a => string.Format("[{0}]{1}", a.BarCode, a.ProductName)).ToArray().ToString();
result.Code = 1005;
result.Message = content + " 不在销售订单[" + entity.OrderNum + "]中,请重新确认再出库";
return(result);
}
List <LocalProductEntity> listResult = new List <LocalProductEntity>();
//拣货
foreach (SaleDetailEntity item in list)
{
Proc_PickProductEntity pickEntity = new Proc_PickProductEntity();
pickEntity.InStorageNum = StorageNum;
pickEntity.InProductNum = item.ProductNum;
pickEntity.InCompanyID = this.CompanyID;
pickEntity.InNum = item.Qty;
List <LocalProductEntity> listPickResult = this.Proc_PickProduct.ExceuteEntityList <LocalProductEntity>(pickEntity);
if (listPickResult.IsNullOrEmpty() || listPickResult.Sum(a => a.Num) < item.Qty)
{
result.Code = 1006;
result.Message = string.Format("货品[{0}]拣货数 {1} 不满足要求数 {2},请确保仓库有足够的货品", item.ProductName, listPickResult.Sum(a => a.Num).ToString("0.00"), item.Qty.ToString("0.00"));
return(result);
}
listResult.AddRange(listPickResult);
}
OutStorageEntity outEntity = new OutStorageEntity();
outEntity.SnNum = ConvertHelper.NewGuid();
outEntity.OutType = (int)EOutType.Sell;
outEntity.ProductType = (int)EProductType.Goods;
outEntity.StorageNum = StorageNum;
outEntity.CusSnNum = entity.CusSnNum;
outEntity.CusNum = entity.CusNum;
outEntity.CusName = entity.CusName;
outEntity.Contact = entity.Contact;
outEntity.Phone = entity.Phone;
outEntity.Address = entity.Address;
outEntity.ContractOrder = entity.SnNum;
outEntity.SendDate = entity.SendDate;
outEntity.Status = (int)EAudite.Wait;
outEntity.IsDelete = (int)EIsDelete.NotDelete;
outEntity.CreateTime = DateTime.Now;
outEntity.CreateUser = entity.CreateUser;
outEntity.OperateType = (int)EOpType.PC;
outEntity.EquipmentNum = "";
outEntity.EquipmentCode = "";
outEntity.CompanyID = this.CompanyID;
List <OutStoDetailEntity> listDetails = new List <OutStoDetailEntity>();
foreach (LocalProductEntity item in listResult)
{
OutStoDetailEntity detail = new OutStoDetailEntity();
detail.SnNum = ConvertHelper.NewGuid();
detail.OrderSnNum = outEntity.SnNum;
detail.ProductName = item.ProductName;
detail.ProductNum = item.ProductNum;
detail.BarCode = item.BarCode;
detail.BatchNum = item.BatchNum;
detail.LocalNum = item.LocalNum;
detail.StorageNum = item.StorageNum;
detail.Num = item.Num;
detail.IsPick = (int)EBool.No;
detail.RealNum = 0;
SaleDetailEntity saleEntity = list.FirstOrDefault(a => a.ProductNum == item.ProductNum);
if (saleEntity != null)
{
detail.OutPrice = saleEntity.Price;
detail.Amount = detail.OutPrice * detail.Num;
detail.ContractOrder = entity.OrderNum;
detail.ContractSn = saleEntity.SnNum;
}
detail.LocalSn = item.Sn;
detail.CreateTime = DateTime.Now;
detail.CompanyID = this.CompanyID;
listDetails.Add(detail);
}
string returnValue = string.Empty;
using (TransactionScope ts = new TransactionScope())
{
Bill <OutStorageEntity, OutStoDetailEntity> bill = new OutStorage.OutStorageOrder(this.CompanyID);
returnValue = bill.Create(outEntity, listDetails);
if (EnumHelper.GetEnumDesc <EReturnStatus>(EReturnStatus.Success) == returnValue)
{
foreach (SaleDetailEntity item in list)
{
if (item.RealNum + item.Qty >= item.Num)
{
item.Status = (int)EOrderStatus.AllDelivery;
item.RealNum += item.Qty;
}
else if ((item.RealNum + item.Qty) < item.Num && (item.RealNum + item.Qty) > 0)
{
item.Status = (int)EOrderStatus.PartialDelivery;
item.RealNum += item.Qty;
}
item.Include(a => new { a.RealNum, a.Status });
item.Where(a => a.SnNum == item.SnNum);
this.SaleDetail.Update(item);
}
//再次查询校验状态
detailEntity = new SaleDetailEntity();
detailEntity.OrderSnNum = SnNum;
listSource = this.GetOrderDetail(detailEntity);
if (!listSource.IsNullOrEmpty())
{
if (listSource.Count(a => a.Status == (int)EOrderStatus.PartialDelivery) > 0 ||
(listSource.Count(a => a.Status == (int)EOrderStatus.AllDelivery) < listSource.Count() && listSource.Count(a => a.Status == (int)EOrderStatus.AllDelivery) > 0)
)
{
entity.Status = (int)EOrderStatus.PartialDelivery;
}
else if (listSource.Count(a => a.Status == (int)EOrderStatus.AllDelivery) == listSource.Count())
{
entity.Status = (int)EOrderStatus.AllDelivery;
}
entity.IncludeStatus(true);
entity.Where(a => a.SnNum == entity.SnNum);
this.SaleOrder.Update(entity);
}
result.Code = (int)EResponseCode.Success;
result.Message = "出库单创建成功";
}
else
{
result.Code = (int)EResponseCode.Exception;
result.Message = "出库单创建失败";
}
ts.Complete();
}
return(result);
}
/// <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);
}
