/// <summary>
/// 获取一条信息记录
/// </summary>
/// <param name="param"></param>
/// <returns></returns>
public STK_StockReserveResult GetInfo(STK_StockReserveParam param)
{
this.CheckSession();
STK_StockReserveResult rst = new STK_StockReserveResult();
#region 判断
if (param.SRGuid == null)
{
throw new WarnException("请指定GUID！");
}
#endregion
#region 获取实体
try
{
rst = this.Select <STK_StockReserveResult>(GetWhereClip(param));
}
catch (WarnException exp)
{
throw exp;
}
catch (System.Exception exp)
{
LogInfoBLL.WriteLog(this.SessionInfo, exp);
throw exp;
}
#endregion
return(rst);
}
/// <summary>
/// 删除实体
/// </summary>
/// <param name="param">删除条件实体</param>
/// <returns></returns>
public WCFAddUpdateResult DelInfo(STK_StockReserveParam param)
{
this.CheckSession();
WCFAddUpdateResult ret = new WCFAddUpdateResult();
int affect = 0;
try
{
#region 判断
if (param.SRGuid == null)
{
throw new WarnException("请指定GUID！");
}
#endregion
WhereClip whereClip = GetWhereClip(param);
STK_StockReserveResult info = new STK_StockReserveResult();
info.IsDeleted = true;
affect = this.Update <STK_StockReserveResult>(info, whereClip);
#region 设置返回值
ret.Key = affect;
#endregion
}
catch (WarnException exp)
{
throw exp;
}
catch (System.Exception exp)
{
LogInfoBLL.WriteLog(this.SessionInfo, exp);
throw exp;
}
return(ret);
}
/// <summary>
/// 获取集合
/// </summary>
/// <param name="param"></param>
/// <returns></returns>
public List <STK_StockReserveResult> GetList(STK_StockReserveParam param)
{
this.CheckSession();
List <STK_StockReserveResult> ret = new List <STK_StockReserveResult>();
try
{
WhereClip whereClip = GetWhereClip(param);
ret = this.SelectList <STK_StockReserveResult>(whereClip, STK_StockReserve._.CreatedTime.Asc);
if (ret != null && ret.Count > 0)
{
Guid?[] ItemCodes = ret.Select(a => a.ItemCode).Distinct().ToArray();
STK_StockBLL stockBLL = new STK_StockBLL();
stockBLL.SessionInfo = this.SessionInfo;
List <STK_StockResult> stockList = stockBLL.GetList(new STK_StockParam()
{
ItemCodes = ItemCodes
});
if (stockList != null && stockList.Count > 0)
{
foreach (STK_StockReserveResult sr in ret)
{
if (stockList != null && stockList.Count > 0)
{
STK_StockResult stockResult = stockList.FirstOrDefault(a => a.ItemCode == sr.ItemCode);
if (stockResult != null)
{
sr.Unit = stockResult.Unit;
sr.Model = stockResult.Model;
sr.Brand = stockResult.Brand;
sr.Batch = stockResult.Batch;
sr.Package = stockResult.Package;
sr.Quality = stockResult.Quality;
sr.MPQ = stockResult.MPQ;
sr.MarkCode = stockResult.MarkCode;
sr.Warehouse = stockResult.Warehouse;
sr.Location = stockResult.Location;
sr.InvType = stockResult.InvType;
sr.InBatchNo = stockResult.InBatchNo;
}
}
}
}
}
}
catch (WarnException exp)
{
throw exp;
}
catch (System.Exception exp)
{
LogInfoBLL.WriteLog(this.SessionInfo, exp);
throw exp;
}
return(ret);
}
public WCFAddUpdateResult DelInfo(STK_StockReserveParam param)
{
WCFAddUpdateResult ret = new WCFAddUpdateResult();
ExeResult rst = new ExeResult();
rst = this.Execute("ZNLCRM.BLL.STK.STK_StockReserveBLL", "DelInfo", param);
ret = (rst == null ? new WCFAddUpdateResult() : rst.Result as WCFAddUpdateResult);
return(ret);
}
public STK_StockReserveResult GetInfo(STK_StockReserveParam param)
{
STK_StockReserveResult ret = new STK_StockReserveResult();
ExeResult rst = new ExeResult();
rst = this.Execute("ZNLCRM.BLL.STK.STK_StockReserveBLL", "GetInfo", param);
ret = (rst == null ? new STK_StockReserveResult() : rst.Result as STK_StockReserveResult);
return(ret);
}
public List <STK_StockReserveResult> GetList(STK_StockReserveParam param)
{
ExeResult rst = new ExeResult();
rst = this.Execute("ZNLCRM.BLL.STK.STK_StockReserveBLL", "GetList", param);
List <STK_StockReserveResult> list = new List <STK_StockReserveResult>();
list = (rst == null ? new List <STK_StockReserveResult>() : rst.Result as List <STK_StockReserveResult>);
return(list);
}
private void BindReserveDataGridView()
{
STK_StockReserveParam param = new STK_StockReserveParam();
param.SourceBillGuid = SourceBillGuid;
param.SourceBillLineGuid = SourceBillLineGuid;
List <STK_StockReserveResult> stockReserveList = this.AsyncExecute <List <STK_StockReserveResult>, STK_StockReserveParam>(param, reserveLogic.GetList, a =>
{
dgvReserve.DataSource = a;
});
}
public PageList <STK_StockReserveResult> GetPageList(STK_StockReserveParam param)
{
ExeResult rst = new ExeResult();
rst = this.Execute("ZNLCRM.BLL.STK.STK_StockReserveBLL", "GetPageList", param);
PageList <STK_StockReserveResult> pageList = new PageList <STK_StockReserveResult>();
pageList = (rst == null ? new PageList <STK_StockReserveResult>() : rst.Result as PageList <STK_StockReserveResult>);
return(pageList);
}
private void BindDataGridView()
{
STK_StockReserveParam param = new STK_StockReserveParam();
param.Model = txtModel.Text.Trim();
param.SourceBillGuid = SourceBillGuid;
param.SourceBillLineGuid = SourceBillLineGuid;
param.SRGuid = SRGuid;
param.Model = Model;
param.NoSRGuids = NoSRGuids;
List <STK_StockReserveResult> lstRst = reserveLogic.GetList(param);
dgvStockReserve.DataSource = lstRst;
this.SetDataSource <STK_StockReserveResult>(lstRst);
SetGridCheck(this.dgvStockReserve, _idColName, _chkColName);
}
private void BindSuperGrid(int pageIndex)
{
STK_StockReserveParam param = new STK_StockReserveParam();
param.Model = txtModel.Text;
param.SourceBillNo = txtBillNo.Text;
param.SourceBillLineCode = txtLineCode.Text;
param.SourceBillGuid = SourceBillGuid;
param.PageIndex = pageIndex;
param.PageSize = 100;
PageList <STK_StockReserveResult> pageList = this.AsyncExecute <PageList <STK_StockReserveResult>, STK_StockReserveParam>(param, reserveLogic.GetPageList, a =>
{
reserveList = a.ResultList;
usgSource.PrimaryGrid.DataSource = reserveList;
pgSource.RecordCount = a.TotalCount;
});
}
WhereClip GetWhereClip(STK_StockReserveParam param)
{
this.CheckSession();
WhereClip where = STK_StockReserve._.IsDeleted == 0;
if (param.SRGuid != null)
{
where = where && STK_StockReserve._.SRGuid == param.SRGuid;
}
if (param.SRGuids != null && param.SRGuids.Length > 0)
{
where = where && STK_StockReserve._.SRGuid.In(param.SRGuids);
}
if (param.NoSRGuids != null && param.NoSRGuids.Length > 0)
{
where = where && !STK_StockReserve._.SRGuid.In(param.NoSRGuids);
}
if (param.SourceBillGuid != null)
{
where = where && STK_StockReserve._.SourceBillGuid == param.SourceBillGuid;
}
if (param.SourceBillLineGuid != null)
{
where = where && STK_StockReserve._.SourceBillLineGuid == param.SourceBillLineGuid;
}
if (param.ItemCode != null)
{
where = where && STK_StockReserve._.ItemCode == param.ItemCode;
}
if (!string.IsNullOrEmpty(param.SourceBillNo))
{
where = where && STK_StockReserve._.SourceBillNo == param.SourceBillNo;
}
if (param.SourceBillLineGuids != null && param.SourceBillLineGuids.Length > 0)
{
where = where && STK_StockReserve._.SourceBillLineGuid.In(param.SourceBillLineGuids);
}
if (param.IsUsedOver != null && !param.IsUsedOver.ToBooleanHasNull())
{
where = where && STK_StockReserve._.UsedQty.IsNull(0) < STK_StockReserve._.ReserveQty;
}
return(where);
}
/// <summary>
/// 分页集合
/// </summary>
/// <param name="param"></param>
/// <returns></returns>
public PageList <STK_StockReserveResult> GetPageList(STK_StockReserveParam param)
{
this.CheckSession();
PageList <STK_StockReserveResult> ret = new PageList <STK_StockReserveResult>();
try
{
#region 处理销售明细
WhereClip orderClip = ORD_SalesOrder._.IsDeleted == 0;
if (!string.IsNullOrEmpty(param.SourceBillNo))
{
orderClip = orderClip && ORD_SalesOrder._.BillNo.Like(param.SourceBillNo + "%");
}
if (param.SourceBillGuid != null)
{
orderClip = orderClip && ORD_SalesOrder._.SOGuid == param.SourceBillGuid;
}
PageList <ORD_SalesOrderResult> orderList = this.SelectList <ORD_SalesOrderResult>(1, 5000, new List <Field>()
{
Field.All
}, orderClip, ORD_SalesOrder._.CreatedTime.Desc);
PageList <ORD_SalesOrderLineResult> lineList = null;
Guid?[] SOGuids = null;
if (orderList.ResultList != null && orderList.ResultList.Count > 0)
{
SOGuids = orderList.ResultList.Select(a => a.SOGuid).Distinct().ToArray();
}
WhereClip lineClip = ORD_SalesOrderLine._.IsDeleted == 0;
if (SOGuids != null)
{
lineClip = lineClip && ORD_SalesOrderLine._.SOGuid.In(SOGuids);
}
if (!string.IsNullOrEmpty(param.Model))
{
lineClip = lineClip && ORD_SalesOrderLine._.Model.Like(param.Model + "%");
}
if (!string.IsNullOrEmpty(param.SourceBillLineCode))
{
lineClip = lineClip && ORD_SalesOrderLine._.SOLineCode.Like(param.SourceBillLineCode + "%");
}
lineList = this.SelectList <ORD_SalesOrderLineResult>(param.PageIndex.GetValueOrDefault(1), param.PageSize.GetValueOrDefault(100), new List <Field>()
{
Field.All
}, lineClip, ORD_SalesOrderLine._.CreatedTime.Desc);
if (lineList != null && lineList.ResultList.Count > 0)
{
#region 获取业务明细下的预留信息
Guid?[] SOLineGuids = lineList.ResultList.Select(a => (Guid?)a.SOLineGuid).Distinct().ToArray();
STK_StockReserveParam reserveParam = new STK_StockReserveParam();
reserveParam.SourceBillLineGuids = SOLineGuids;
List <STK_StockReserveResult> childReserveResultList = this.GetList(reserveParam);
#endregion
List <STK_StockReserveResult> reserveResultList = new List <STK_StockReserveResult> ();
STK_StockReserveResult reserveResult = null;
foreach (ORD_SalesOrderLineResult lineResult in lineList.ResultList)
{
reserveResult = new STK_StockReserveResult();
ORD_SalesOrderResult orderResult = orderList.ResultList.FirstOrDefault(a => a.SOGuid == lineResult.SOGuid);
if (orderResult != null)
{
reserveResult.SourceBillNo = orderResult.BillNo;
reserveResult.SourceBillType = "销售出库";
reserveResult.BelongEmpName = orderResult.SalerName;
reserveResult.SourceBillDate = orderResult.SODate;
}
reserveResult.SourceBillGuid = lineResult.SOGuid;
reserveResult.SourceBillLineGuid = lineResult.SOLineGuid;
reserveResult.SourceBillLineCode = lineResult.SOLineCode;
reserveResult.Model = lineResult.Model;
reserveResult.Brand = lineResult.Brand;
reserveResult.Qty = lineResult.Qty;
reserveResult.ReserveQty = lineResult.ReserveQty;
reserveResult.CreatedEmpName = lineResult.CreatedEmpName;
reserveResult.CreatedTime = lineResult.CreatedTime;
reserveResult.UpdatedEmpName = lineResult.UpdatedEmpName;
reserveResult.UpdatedTime = lineResult.UpdatedTime;
if (childReserveResultList != null && childReserveResultList.Count > 0)
{
List <STK_StockReserveResult> srList = childReserveResultList.Where(a => a.SourceBillLineGuid == lineResult.SOLineGuid).ToList();
if (srList != null && srList.Count > 0)
{
Guid?[] ItemCodes = srList.Select(a => a.ItemCode).Distinct().ToArray();
STK_StockBLL stockBLL = new STK_StockBLL();
stockBLL.SessionInfo = this.SessionInfo;
List <STK_StockResult> stockList = stockBLL.GetList(new STK_StockParam()
{
ItemCodes = ItemCodes
});
foreach (STK_StockReserveResult sr in srList)
{
if (stockList != null && stockList.Count > 0)
{
STK_StockResult stockResult = stockList.FirstOrDefault(a => a.ItemCode == sr.ItemCode);
sr.Model = stockResult.Model;
sr.Brand = stockResult.Brand;
sr.Batch = stockResult.Batch;
sr.Package = stockResult.Package;
sr.Quality = stockResult.Quality;
sr.MPQ = stockResult.MPQ;
sr.MarkCode = stockResult.MarkCode;
sr.Warehouse = stockResult.Warehouse;
sr.Location = stockResult.Location;
sr.InvType = stockResult.InvType;
sr.InBatchNo = stockResult.InBatchNo;
}
}
reserveResult.ReserveList = srList;
}
}
reserveResultList.Add(reserveResult);
}
if (ret.ResultList == null)
{
ret.ResultList = new List <STK_StockReserveResult>();
}
ret.ResultList.AddRange(reserveResultList);
ret.TotalCount = lineList.TotalCount;
}
#endregion
#region 处理采购退货明细
#endregion
}
catch (WarnException exp)
{
throw exp;
}
catch (System.Exception exp)
{
LogInfoBLL.WriteLog(this.SessionInfo, exp);
throw exp;
}
return(ret);
}
/// <summary>
/// 操作预留
/// </summary>
/// <param name="result"></param>
/// <returns></returns>
public bool OperateReserve(STK_StockReserveResult result)
{
this.CheckSession();
try
{
//预留调整量
int?tempReserveQty = 0;
ORD_SalesOrderLineResult orderLineResult = new ORD_SalesOrderLineResult();
ORD_SalesOrderLineBLL orderLineBLL = new ORD_SalesOrderLineBLL();
orderLineBLL.SessionInfo = this.SessionInfo;
ORD_PurchaseReturnLineResult returnLineResult = new ORD_PurchaseReturnLineResult();
ORD_PurchaseReturnLineBLL returnLineBLL = new ORD_PurchaseReturnLineBLL();
returnLineBLL.SessionInfo = this.SessionInfo;
//空值转换为零
if (result.ReserveQty == null)
{
result.ReserveQty = 0;
}
// 预留明细的业务类型
switch (result.SourceBillType)
{
case "销售出库":
orderLineResult = orderLineBLL.GetInfo(new ORD_SalesOrderLineParam()
{
SOLineGuid = result.SourceBillLineGuid
});
if (orderLineResult != null)
{
if (orderLineResult.Qty == null)
{
orderLineResult.Qty = 0;
}
if (orderLineResult.ReserveQty == null)
{
orderLineResult.ReserveQty = 0;
}
tempReserveQty = orderLineResult.Qty - orderLineResult.ReserveQty;
}
break;
case "采购退货出库":
returnLineResult = returnLineBLL.GetInfo(new ORD_PurchaseReturnLineParam()
{
PRLineGuid = result.SourceBillLineGuid
});
if (returnLineResult != null)
{
if (returnLineResult.Qty == null)
{
returnLineResult.Qty = 0;
}
if (returnLineResult.ReserveQty == null)
{
returnLineResult.ReserveQty = 0;
}
tempReserveQty = returnLineResult.Qty - returnLineResult.ReserveQty;
}
break;
}
//获取已存在的预留信息
STK_StockReserveResult oldReserveResult = null;
if (result.SRGuid != null)
{
STK_StockReserveParam reserveParam = new STK_StockReserveParam();
reserveParam.SRGuid = result.SRGuid;
oldReserveResult = this.GetInfo(reserveParam);
}
if (oldReserveResult != null)
{
if (oldReserveResult.ReserveQty == null)
{
orderLineResult.ReserveQty = 0;
}
//修改预留数量，预留量增加
if (result.ReserveQty >= oldReserveResult.ReserveQty)
{
tempReserveQty = result.ReserveQty - oldReserveResult.ReserveQty;
result.OperFlag = true;
}
//修改预留数量，预留量减少
else if (result.ReserveQty < oldReserveResult.ReserveQty)
{
tempReserveQty = oldReserveResult.ReserveQty - result.ReserveQty;
result.OperFlag = false;
}
}
//获取库存信息
STK_StockBLL stockBLL = new STK_StockBLL();
stockBLL.SessionInfo = this.SessionInfo;
STK_StockResult stockResult = stockBLL.GetInfo(new STK_StockParam()
{
ItemCode = result.ItemCode
});
if (stockResult != null)
{
//空值转换为零
if (stockResult.UsableQty == null)
{
stockResult.UsableQty = 0;
}
if (stockResult.BookedQty == null)
{
stockResult.BookedQty = 0;
}
}
int?UsableQty = stockResult.UsableQty;
//删除预留信息
if (result.IsDeleted.ToBooleanHasNull())
{
result = oldReserveResult;
stockResult.UsableQty += result.ReserveQty;
stockResult.BookedQty -= result.ReserveQty;
switch (result.SourceBillType)
{
case "销售出库":
orderLineResult.ReserveQty -= result.ReserveQty;
break;
case "采购退货出库":
returnLineResult.ReserveQty -= result.ReserveQty;
break;
}
}
//新增或者修改预留信息
else
{
switch (result.OperFlag)
{
case true: //增加
//预留信息已经存在
if (oldReserveResult != null)
{
result = oldReserveResult;
if (UsableQty >= tempReserveQty) //大于需要预留数量
{
result.ReserveQty += tempReserveQty;
}
else //小于需要预留数量
{
result.ReserveQty += UsableQty;
}
}
//新的预留
else
{
if (UsableQty >= tempReserveQty) //大于需要预留数量
{
result.ReserveQty = tempReserveQty;
}
else //小于需要预留数量
{
result.ReserveQty = UsableQty;
}
}
if (UsableQty >= tempReserveQty) //大于需要预留数量
{
stockResult.UsableQty -= tempReserveQty;
stockResult.BookedQty += tempReserveQty;
switch (result.SourceBillType)
{
case "销售出库":
orderLineResult.ReserveQty += tempReserveQty;
break;
case "采购退货出库":
returnLineResult.ReserveQty += tempReserveQty;
break;
}
}
else
{
stockResult.UsableQty -= UsableQty;
stockResult.BookedQty += UsableQty;
switch (result.SourceBillType)
{
case "销售出库":
orderLineResult.ReserveQty += UsableQty;
break;
case "采购退货出库":
returnLineResult.ReserveQty += UsableQty;
break;
}
}
break;
case false: //减少库存量
result = oldReserveResult;
result.ReserveQty -= tempReserveQty;
stockResult.UsableQty += tempReserveQty;
stockResult.BookedQty -= tempReserveQty;
switch (result.SourceBillType)
{
case "销售出库":
orderLineResult.ReserveQty -= tempReserveQty;
break;
case "采购退货出库":
returnLineResult.ReserveQty -= tempReserveQty;
break;
}
break;
} // end of switch
} //end of if else
//更改预留表
this.AddOrUpdate(result);
//更改库存
stockBLL.AddOrUpdate(stockResult);
//更新预留关联单据明细
switch (result.SourceBillType)
{
case "销售出库":
orderLineBLL.AddOrUpdate(orderLineResult);
break;
case "采购退货出库":
returnLineBLL.AddOrUpdate(returnLineResult);
break;
} // end of if else
}
catch (WarnException exp)
{
throw exp;
}
catch (System.Exception exp)
{
LogInfoBLL.WriteLog(this.SessionInfo, exp);
throw exp;
}
return(true);
}
