/// <summary>
/// 获取一条信息记录
/// </summary>
/// <param name="param"></param>
/// <returns></returns>
public STK_InResult GetInfo(STK_InParam param)
{
this.CheckSession();
STK_InResult rst = new STK_InResult();
#region 判断
if (param.StkInGuid == null)
{
throw new WarnException("请指定入库单GUID！");
}
#endregion
#region 获取实体
rst = this.Select <STK_InResult>(GetWhereClip(param));
if (rst != null)
{
rst.StkInLineList = this.SelectList <STK_InLineResult>(STK_InLine._.StkInGuid == rst.StkInGuid);
rst.HR_DepartmentResult = this.Select <HR_DepartmentResult>(new List <Field>()
{
HR_Department._.DeptID, HR_Department._.DeptName
}, HR_Department._.DeptID == rst.OperDeptID);
}
#endregion
return(rst);
}
/// <summary>
/// 删除实体
/// </summary>
/// <param name="param">删除条件实体</param>
/// <returns></returns>
public WCFAddUpdateResult DelInfo(STK_InParam param)
{
this.CheckSession();
WCFAddUpdateResult ret = new WCFAddUpdateResult();
int affect = 0;
try
{
#region 判断
if (param.StkInGuid == null)
{
throw new WarnException("请指定要删除的入库单GUID！");
}
#endregion
WhereClip whereClip = GetWhereClip(param);
STK_InResult info = new STK_InResult();
info.IsDeleted = true;
affect = this.Update <STK_InResult>(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);
}
object Form_GetEditEntity()
{
#region 主单编辑
STK_InResult info = new STK_InResult();
info.StkInGuid = StkInGuid;
info = this.ConvertControlToEntity <STK_InResult>(this.stcpStkIn.Controls, info, null);
this.SetDataIsChanged <STK_InResult>(info);
#endregion
#region 明细项目编辑
bsStkInLine.EndEdit();
tempList.Clear();
foreach (STK_InLineResult rst in addOrModifyList)
{
if (rst.HasChanged())
{
tempList.Add(rst);
}
}
tempList.AddRange(delList);
info.StkInLineList = tempList;
if (tempList.Count > 0)
{
this.DataIsChanged = true;
}
#endregion
return(info);
}
private void tsbAudit_Click(object sender, EventArgs e)
{
//stkInLogic.AuditStkInBill(new STK_InParam() { StkInGuid = StkInGuid });
STK_InResult info = Form_GetEditEntity() as STK_InResult;
this.WF_CheckBill("STK_In", info.BillNo, info.StkInGuid, this.DataIsChanged, delegate() { return(SaveData(false)); }, InitData);
}
private bool SaveData(bool isAsyncExecute)
{
bool ret = false;
STK_InResult info = Form_GetEditEntity() as STK_InResult;
if (isAsyncExecute && !this.DataIsChanged)
{
this.ShowNoChangedMsg();
return(ret);
}
if (!this.CheckSaveData())
{
return(ret);
}
#region 异步执行保存操作
bsStkInLine.EndEdit();
tempList.Clear();
foreach (STK_InLineResult rst in addOrModifyList)
{
if (rst.HasChanged())
{
tempList.Add(rst);
}
}
tempList.AddRange(delList);
info.StkInLineList = tempList;
#region 异步执行操作
if (isAsyncExecute)
{
WCFAddUpdateResult result = this.AsyncExecute <WCFAddUpdateResult, STK_InResult>(info, stkInLogic.AddOrUpdate, (a) =>
{
if (a.KeyGuid.ToGuid() != Guid.Empty)
{
StkInGuid = a.KeyGuid.ToGuid();
if (SaveAttach != null)
{
SaveAttach("STK_In", StkInGuid.ToGuid(), a.BillNo);
}
InitData();
delList.Clear();
}
});
}
#endregion
#region 步执行保存操作
else
{
WCFAddUpdateResult result = stkInLogic.AddOrUpdate(info);
if (result.KeyGuid.ToGuid() != Guid.Empty)
{
ret = true;
}
}
#endregion
return(ret);
}
public WCFAddUpdateResult AddOrUpdate(STK_InResult param)
{
WCFAddUpdateResult ret = new WCFAddUpdateResult();
ExeResult rst = new ExeResult();
rst = this.Execute("ZNLCRM.BLL.STK.STK_InBLL", "AddOrUpdate", param);
ret = (rst == null ? new WCFAddUpdateResult() : rst.Result as WCFAddUpdateResult);
return(ret);
}
public STK_InResult GetInfo(STK_InParam param)
{
STK_InResult ret = new STK_InResult();
ExeResult rst = new ExeResult();
rst = this.Execute("ZNLCRM.BLL.STK.STK_InBLL", "GetInfo", param);
ret = rst == null ? new STK_InResult() : rst.Result as STK_InResult;
return(ret);
}
/// <summary>
/// 获取入库明细的分页信息
/// </summary>
/// <param name="param"></param>
/// <returns></returns>
public PageList <STK_InLineResult> GetPageList(STK_InLineParam param)
{
PageList <STK_InLineResult> ret = new PageList <STK_InLineResult>();
try
{
STK_InParam InParam = new STK_InParam()
{
SourceBillNo = param.SourceBillNo,
BillNo = param.StkInBillNo,
PageIndex = 1,
PageSize = 5000,
Status = param.Status
};
STK_InBLL inBLL = new STK_InBLL();
inBLL.SessionInfo = this.SessionInfo;
PageList <STK_InResult> inList = inBLL.GetPageList(InParam);
if (inList != null && inList.ResultList.Count > 0)
{
Guid?[] StkInGuids = inList.ResultList.Select(a => (Guid?)a.StkInGuid).Distinct().ToArray();
param.StkInGuids = StkInGuids;
ret = this.SelectList <STK_InLineResult>(param.PageIndex.GetValueOrDefault(1), param.PageSize.GetValueOrDefault(50), new List <Field>()
{
Field.All
}, GetWhereClip(param), STK_OutLine._.CreatedTime.Desc);
if (ret != null && ret.ResultList.Count > 0)
{
foreach (STK_InLineResult inLineResult in ret.ResultList)
{
//获取入库单号
STK_InResult inResult = inList.ResultList.FirstOrDefault(a => a.StkInGuid == inLineResult.StkInGuid);
if (inResult != null)
{
inLineResult.StkInBillNo = inResult.BillNo;
inLineResult.SourceBillNo = inResult.SourceBillNo;
}
}
}
}
}
catch (WarnException exp)
{
throw exp;
}
catch (System.Exception exp)
{
LogInfoBLL.WriteLog(this.SessionInfo, exp);
throw exp;
}
return(ret);
}
void biStkIn_Click(object sender, EventArgs e)
{
DataGridViewRow row = dgvPurchaseOrder.CurrentRow;
if (row != null)
{
Guid?poguid = row.Cells["colPOGuid"].Value.ToGuid();
ORD_PurchaseOrderResult orderResult = orderLogic.GetInfo(new ORD_PurchaseOrderParam()
{
POGuid = poguid
});
if (orderResult != null && orderResult.Status == "Complete" && orderResult.StkInOccStatus != "全部占有")
{
List <ORD_PurchaseOrderLineResult> lineList = orderResult.OrderLineList;
if (lineList != null && lineList.Count > 0)
{
//有效的可作为入库明细的采购记录
List <ORD_PurchaseOrderLineResult> effLineList = lineList.Where(a => a.IsCancel == false && a.Qty > a.StkInOccQty).ToList();
if (effLineList != null && effLineList.Count > 0)
{
STK_InResult inResult = stkInLogic.GetInfo(new STK_InParam()
{
SourceBillGuid = poguid, Status = "New"
});
frmStkIn frmStkIn = new frmStkIn();
frmStkIn.BringToFront();
frmStkIn.StartPosition = FormStartPosition.CenterParent;
if (inResult != null)
{
//存在关联的未提交的入库单
frmStkIn.StkInGuid = inResult.StkInGuid;
}
frmStkIn.ShowDialog();
}
else
{
this.ShowMessage("当前采购单没有再需要入库的采购明细！若存在有关联的已提交未审核的入库单，请及时联系相关人员审核！");
}
}
}
else
{
this.ShowMessage("未审核或者全部占有的采购单据不允许入库！");
}
}
else
{
this.ShowMessage("未选中数据行！");
}
}
public bool UpdateStatus(STK_InParam param)
{
bool flag = true;
try
{
STK_InResult inResult = this.GetInfo(param);
if (inResult != null)
{
if (inResult.StkInLineList != null && inResult.StkInLineList.Count > 0)
{
//取消的明细需要排除
List <STK_InLineResult> lineList = inResult.StkInLineList;
if (lineList != null && lineList.Count > 0)
{
int?qty = lineList.Where(a => a.Qty != null).Select(a => a.Qty).Sum();
int?stkOutQty = lineList.Where(a => a.StkOutQty != null).Select(a => a.StkOutQty).Sum();
if (stkOutQty == 0)
{
inResult.StkOutStatus = "待出库";
}
else if (stkOutQty >= qty)
{
inResult.StkOutStatus = "全部出库";
}
else
{
inResult.StkOutStatus = "部分出库";
}
this.AddOrUpdate(inResult);
}
}
}
}
catch (WarnException exp)
{
flag = false;
throw exp;
}
catch (System.Exception exp)
{
flag = false;
LogInfoBLL.WriteLog(this.SessionInfo, exp);
throw exp;
}
return(flag);
}
/// <summary>
/// 获取集合
/// </summary>
/// <param name="param"></param>
/// <returns></returns>
public List <STK_InLineResult> GetList(STK_InLineParam param)
{
this.CheckSession();
List <STK_InLineResult> ret = new List <STK_InLineResult>();
try
{
WhereClip whereClip = GetWhereClip(param);
ret = this.SelectList <STK_InLineResult>(whereClip, STK_InLine._.CreatedTime.Asc);
if (ret != null && ret.Count > 0)
{
Guid?[] StkInGuids = ret.Select(a => a.StkInGuid).Distinct().ToArray();
STK_InBLL stkInBLL = new STK_InBLL();
stkInBLL.SessionInfo = this.SessionInfo;
List <STK_InResult> inResultList = stkInBLL.GetList(new STK_InParam()
{
StkInGuids = StkInGuids
});
foreach (STK_InLineResult inLineResult in ret)
{
STK_InResult inResult = inResultList.FirstOrDefault(a => a.StkInGuid == inLineResult.StkInGuid);
if (inResult != null)
{
inLineResult.StkInBillNo = inResult.BillNo;
inLineResult.SourceBillNo = inResult.SourceBillNo;
}
}
}
}
catch (WarnException exp)
{
throw exp;
}
catch (System.Exception exp)
{
LogInfoBLL.WriteLog(this.SessionInfo, exp);
throw exp;
}
return(ret);
}
private void tsbDel_Click(object sender, EventArgs e)
{
STK_InParam param = new STK_InParam();
param.StkInGuid = stkInGuid;
STK_InResult rst = stkInlogic.GetInfo(param);
if (rst != null)
{
if (MessageBox.Show("请确认是否要删除入库单：【" + rst.BillNo + "】", "操作提示",
MessageBoxButtons.OKCancel,
MessageBoxIcon.Question) == DialogResult.OK)
{
WCFAddUpdateResult result = this.AsyncExecute <WCFAddUpdateResult, STK_InParam>(
param, stkInlogic.DelInfo, a => { SearchStkIn(pgStkIn.PageIndex); });
}
}
else
{
this.ShowMessage("请选择需要删除的入库单！");
}
}
private void InitData()
{
if (StkInGuid != null)//修改
{
STK_InResult info = stkInLogic.GetInfo(new STK_InParam {
StkInGuid = StkInGuid
});
this.ConvertEntityToControl <STK_InResult>(this.stcpStkIn.Controls, info, null);
if (info != null)
{
txtAmount.Text = Math.Round(info.Amount.ToDecimal(), 3, MidpointRounding.AwayFromZero).ToStringHasNull();
txtSCAmount.Text = Math.Round(info.SCAmount.ToDecimal(), 3, MidpointRounding.AwayFromZero).ToStringHasNull();
txtOperDeptName.Text = info.HR_DepartmentResult.DeptName;
if (info.StkInLineList != null)
{
addOrModifyList = info.StkInLineList;
}
}
this.CheckIsReadOnly <STK_InResult>(info);
this.CheckAuditStatus <STK_InResult>(info, this.stcpStkIn, this.panDtlBtn, this.panDtlGrid);
this.EditBeforeData = info;
}
else//新增
{
txtInDate.Text = DateTime.Now.ToStringHasNull();
cboOperOrgID.SelectedValue = MySession.OrgID;
txtOperDeptName.Text = MySession.DeptName;
txtOperDeptID.Text = MySession.DeptID.ToStringHasNull();
txtOperEmpID.Text = MySession.UserID.ToStringHasNull();
txtOperEmpName.Text = MySession.UserName;
}
bsStkInLine.DataSource = addOrModifyList;
dgvStkInLine.DataSource = bsStkInLine;
CheckAuditButton("STK_In", StkInGuid, this.tsbSubmit, null, this.tsbAudit, this.tsbUnDo);
this.DataIsChanged = false;
}
public bool AuditStkOutBill(STK_OutParam param)
{
bool auditFlag = true;
try
{
STK_OutResult outResult = this.GetInfo(param);
if (outResult != null)
{
bool isAllowAudit = true;
if (outResult.ApproveStatus == "待提交")
{
isAllowAudit = false;
throw new WarnException("出库单当前状态为:【待提交】,请先提交！");
}
else if (outResult.ApproveStatus == "审核完成")
{
isAllowAudit = false;
throw new WarnException("出库单当前状态为:【审核完成】,禁止重复审核！");
}
if (isAllowAudit)
{
outResult.Status = "Complete";
outResult.ApproveStatus = "审核完成";
WCFAddUpdateResult ret = this.AddOrUpdate(outResult);
if (ret.KeyGuid.ToGuid() == Guid.Empty)
{
auditFlag = false;
}
else
{
#region 定义相关变量(可重复使用)
STK_OutLineBLL outLineBLL = new STK_OutLineBLL();
outLineBLL.SessionInfo = this.SessionInfo;
STK_InBLL inBLL = new STK_InBLL();
inBLL.SessionInfo = this.SessionInfo;
STK_InLineBLL inLineBLL = new STK_InLineBLL();
inLineBLL.SessionInfo = this.SessionInfo;
ORD_PurchaseOrderLineBLL purOrderLineBLL = new ORD_PurchaseOrderLineBLL();
purOrderLineBLL.SessionInfo = this.SessionInfo;
ORD_PurchaseOrderBLL purOrderBLL = new ORD_PurchaseOrderBLL();
purOrderBLL.SessionInfo = this.SessionInfo;
ORD_SalesOrderBLL saleOrderBLL = new ORD_SalesOrderBLL();
saleOrderBLL.SessionInfo = this.SessionInfo;
ORD_SalesOrderLineBLL saleOrderLineBLL = new ORD_SalesOrderLineBLL();
saleOrderLineBLL.SessionInfo = this.SessionInfo;
ORD_PurchaseReturnBLL purReturnBLL = new ORD_PurchaseReturnBLL();
purReturnBLL.SessionInfo = this.SessionInfo;
ORD_PurchaseReturnLineBLL purReturnLineBLL = new ORD_PurchaseReturnLineBLL();
purReturnLineBLL.SessionInfo = this.SessionInfo;
STK_StockSheetBLL stockSheetBLL = new STK_StockSheetBLL();
stockSheetBLL.SessionInfo = this.SessionInfo;
STK_StockBLL stockBLL = new STK_StockBLL();
stockBLL.SessionInfo = this.SessionInfo;
STK_InOutLinkBLL inOutLinkBLL = new STK_InOutLinkBLL();
inOutLinkBLL.SessionInfo = this.SessionInfo;
List <ORD_SalesOrderResult> saleList = null;
List <ORD_SalesOrderLineResult> saleLineList = null;
List <ORD_PurchaseOrderLineResult> purLineList = null;
List <ORD_PurchaseReturnResult> purReturnList = null;
List <ORD_PurchaseReturnLineResult> purReturnLineList = null;
List <STK_InResult> stkInList = null;
List <STK_InLineResult> stkInLineList = null;
List <STK_InLineResult> effStkInLineList = null;
List <STK_OutResult> stkOutList = null;
List <STK_OutLineResult> stkOutLineList = null;
List <STK_OutLineResult> effStkOutLineList = null;
List <STK_StockResult> stockList = null;
List <STK_StockSheetResult> stkStockSheetList = null;
Guid?[] ItemCodes = null;
Guid?[] StkInGuids = null;
Guid?[] StkInLineGuids = null;
Guid?[] EffStkInGuids = null;
Guid?[] StkOutGuids = null;
Guid?[] _stkOutLineGuids = null;
Guid?[] EffStkOutGuids = null;
Guid?[] POGuids = null;
Guid?[] POLineGuids = null;
Guid?[] SOGuids = null;
Guid?[] SOLineGuids = null;
Guid?[] PRGuids = null;
Guid?[] PRLineGuids = null;
#endregion
//获取出库单下的出库明细集合
List <STK_OutLineResult> outLineList = outLineBLL.GetList(new STK_OutLineParam()
{
StkOutGuid = ret.KeyGuid
});
//获取出库单下的关联明细集合
List <STK_InOutLinkResult> inOutLinkList = inOutLinkBLL.GetList(new STK_InOutLinkParam()
{
StkOutGuid = ret.KeyGuid
});
if (outLineList != null && outLineList.Count > 0)
{
#region 减少库存，形成出库流水
ItemCodes = outLineList.Select(a => a.ItemCode).Distinct().ToArray();
stockList = stockBLL.GetList(new STK_StockParam()
{
ItemCodes = ItemCodes
});
stkStockSheetList = new List <STK_StockSheetResult>();
STK_StockSheetResult stkStockSheetResult = null;
foreach (STK_OutLineResult outLineResult in outLineList)
{
STK_StockResult stockResult = stockList.FirstOrDefault(a => a.ItemCode == outLineResult.ItemCode.ToGuid());
if (stockResult != null)
{
stockResult.InvQty -= outLineResult.Qty;
stockResult.BookedQty -= outLineResult.Qty;
stkStockSheetResult = new STK_StockSheetResult();
stkStockSheetResult.SSType = 2;
stkStockSheetResult.SourceBillGuid = outResult.StkOutGuid;
stkStockSheetResult.SourceBillNo = outResult.BillNo;
stkStockSheetResult.SourceBillLineGuid = outLineResult.StkOutLineGuid;
stkStockSheetResult.ItemCode = outLineResult.ItemCode;
stkStockSheetResult.Model = outLineResult.Model;
stkStockSheetResult.Brand = outLineResult.Brand;
stkStockSheetResult.Batch = outLineResult.Batch;
stkStockSheetResult.Package = outLineResult.Package;
stkStockSheetResult.Quality = outLineResult.Quality;
stkStockSheetResult.MPQ = outLineResult.MPQ;
stkStockSheetResult.MarkCode = outLineResult.MarkCode;
stkStockSheetResult.Currency = outLineResult.Currency;
stkStockSheetResult.FlowQty = outLineResult.Qty;
stkStockSheetResult.FlowPrice = outLineResult.UnitPrice;
stkStockSheetResult.FlowAmount = outLineResult.Amount;
stkStockSheetList.Add(stkStockSheetResult);
}
}
stockBLL.UpdateOrInsertList(stockList);
stockSheetBLL.UpdateOrInsertList(stkStockSheetList);
#endregion
#region 回写关联的入库单的出库数量和出库状态，入库单关联单据的出库数量和出库状态，出库单关联单据的出库数量和出库状态
#region 回写关联入库单的出库数量出库状态
//获取出库明细的guid
StkInLineGuids = inOutLinkList.Select(a => a.StkInLineGuid).Distinct().ToArray();
if (StkInLineGuids != null && StkInLineGuids.Length > 0)
{
//获取出库明细所关联的入库明细
stkInLineList = inLineBLL.GetList(new STK_InLineParam()
{
StkInLineGuids = StkInLineGuids
});
if (stkInLineList != null && stkInLineList.Count > 0)
{
//获取出库明细所关联的入库明细对应的出库明细
List <STK_InOutLinkResult> linkList = inOutLinkBLL.GetList(new STK_InOutLinkParam()
{
StkInLineGuids = StkInLineGuids
});
if (linkList != null && linkList.Count > 0)
{
_stkOutLineGuids = linkList.Select(a => a.StkOutLineGuid).Distinct().ToArray();
stkOutLineList = outLineBLL.GetList(new STK_OutLineParam()
{
StkOutLineGuids = _stkOutLineGuids
});
if (stkOutLineList != null && stkOutLineList.Count > 0)
{
//获取出库明细对应的出库主单guid
StkOutGuids = stkOutLineList.Select(a => a.StkOutGuid).Distinct().ToArray();
if (StkOutGuids != null && StkOutGuids.Length > 0)
{
//获取出库明细对应的出库主单
stkOutList = this.GetList(new STK_OutParam()
{
StkOutGuids = StkOutGuids, Status = "Complete"
});
if (stkOutList != null && stkOutList.Count > 0)
{
//获取有效的出库主单guid
EffStkOutGuids = stkOutList.Select(a => a.StkOutGuid).Distinct().ToArray();
//获取有效的出库明细集合
effStkOutLineList = stkOutLineList.Where(a => EffStkOutGuids.Contains(a.StkOutGuid)).ToList();
foreach (STK_InLineResult stkInLineResult in stkInLineList)
{
//汇总出库明细的出库数量
int?qty = effStkOutLineList.Where(a => a.StkInLineGuid == stkInLineResult.StkInLineGuid).Sum(a => a.Qty.ToInt32());
//回写入库明细的出库数量
stkInLineResult.StkOutQty = qty;
}
}
}
//更新入库明细的集合
inLineBLL.UpdateOrInsertList(stkInLineList);
//获取入库主单guid
StkInGuids = stkInLineList.Select(a => a.StkInGuid).Distinct().ToArray();
foreach (Guid stkinguid in StkInGuids)
{
//更新入库单的状态
inBLL.UpdateStatus(new STK_InParam()
{
StkInGuid = stkinguid
});
//获取入库单
STK_InResult stkInResult = inBLL.GetInfo(new STK_InParam()
{
StkInGuid = stkinguid
});
if (stkInResult.BillType == "PO_IN")
{
#region 回写采购单的出库的数量出库状态
//找到入库明细所关联的采购明细guid和采购明细集合
POLineGuids = stkInLineList.Where(a => a.StkInGuid == stkinguid).Select(a => a.SourceBillLineGuid).Distinct().ToArray();
if (POLineGuids != null && POLineGuids.Length > 0)
{
purLineList = purOrderLineBLL.GetList(new ORD_PurchaseOrderLineParam()
{
POLineGuids = POLineGuids
});
if (purLineList != null && purLineList.Count > 0)
{
//找到采购单明细关联的入库明细
List <STK_InLineResult> linkInLineList = inLineBLL.GetList(new STK_InLineParam()
{
SourceBillLineGuids = POLineGuids
});
if (linkInLineList != null && linkInLineList.Count > 0)
{
//找到采购明细关联的入库明细的入库主单guid
Guid?[] LinkInGuids = linkInLineList.Select(a => a.StkInGuid).Distinct().ToArray();
if (LinkInGuids != null && LinkInGuids.Length > 0)
{
//找到采购单明细关联的入库明细所在的入库主单
stkInList = inBLL.GetList(new STK_InParam()
{
StkInGuids = LinkInGuids, Status = "Complete"
});
if (stkInList != null && stkInList.Count > 0)
{
//有效的入库主单guid
EffStkInGuids = stkInList.Select(a => a.StkInGuid).Distinct().ToArray();
//有效的入库明细集合
effStkInLineList = linkInLineList.Where(a => EffStkInGuids.Contains(a.StkInGuid)).ToList();
foreach (ORD_PurchaseOrderLineResult purLineResult in purLineList)
{
//汇总有效的入库明细的出库数量
int?qty = effStkInLineList.Where(a => a.SourceBillLineGuid == purLineResult.POLineGuid).Sum(a => a.StkOutQty).ToInt32();
//更新采购明细的出库数量
purLineResult.StkOutQty = qty;
}
}
}
}
//更新采购明细集合
purOrderLineBLL.UpdateOrInsertList(purLineList);
POGuids = purLineList.Select(a => a.POGuid).Distinct().ToArray();
foreach (Guid poguid in POGuids)
{
purOrderBLL.UpdateStatus(new ORD_PurchaseOrderParam()
{
POGuid = poguid
});
}
}
}
#endregion
}
else if (stkInResult.BillType == "SOR_IN")
{
}
else if (stkInResult.BillType == "ZX_IN")
{
}
}
}
}
}
}
#endregion
#region 回写出库单关联的业务单据的出库数量和出库状态
if (outResult.BillType == "SO_OUT")
{
#region 回写销售单的出库数量和出库状态
//获取出库明细对应的销售明细guid
SOLineGuids = outLineList.Select(a => a.SourceBillLineGuid).Distinct().ToArray();
if (SOLineGuids != null && SOLineGuids.Length > 0)
{
//获取出库明细对应的销售明细
saleLineList = saleOrderLineBLL.GetList(new ORD_SalesOrderLineParam()
{
SOLineGuids = SOLineGuids
});
if (saleLineList != null && saleLineList.Count > 0)
{
//获取出库明细对应的销售明细关联关联的出库明细
stkOutLineList = outLineBLL.GetList(new STK_OutLineParam()
{
SourceBillLineGuids = SOLineGuids
});
if (stkOutLineList != null && stkOutLineList.Count > 0)
{
//获取出库明细对应的出库主单guid
StkOutGuids = stkOutLineList.Select(a => a.StkOutGuid).Distinct().ToArray();
if (StkOutGuids != null && StkOutGuids.Length > 0)
{
//获取出库明细对应的出库主单
stkOutList = this.GetList(new STK_OutParam()
{
StkOutGuids = StkOutGuids, Status = "Complete"
});
if (stkOutList != null && stkOutList.Count > 0)
{
//获取有效的出库主单guid
EffStkOutGuids = stkOutList.Select(a => a.StkOutGuid).Distinct().ToArray();
//获取有效的出库明细集合
effStkOutLineList = stkOutLineList.Where(a => EffStkOutGuids.Contains(a.StkOutGuid)).ToList();
foreach (ORD_SalesOrderLineResult orderLineResult in saleLineList)
{
//汇总有效的出库明细的出库数量
int?qty = effStkOutLineList.Where(a => a.SourceBillLineGuid == orderLineResult.SOLineGuid).Sum(a => a.Qty).ToInt32();
orderLineResult.StkOutQty = qty;
}
}
}
}
saleOrderLineBLL.UpdateOrInsertList(saleLineList);
SOGuids = saleLineList.Select(a => a.SOGuid).Distinct().ToArray();
foreach (Guid soguid in SOGuids)
{
saleOrderBLL.UpdateStatus(new ORD_SalesOrderParam()
{
SOGuid = soguid
});
}
}
}
#endregion
}
else if (outResult.BillType == "POR_OUT")
{
#region 回写采购退货单的出库数量和出库状态
//获取出库明细对应的退货明细guid
PRLineGuids = outLineList.Select(a => a.SourceBillLineGuid).Distinct().ToArray();
if (PRLineGuids != null && PRLineGuids.Length > 0)
{
//获取出库明细对应的退货明细
purReturnLineList = purReturnLineBLL.GetList(new ORD_PurchaseReturnLineParam()
{
PRLineGuids = PRLineGuids
});
if (purReturnLineList != null && purReturnLineList.Count > 0)
{
//获取出库明细对应的退货明细关联关联的出库明细
stkOutLineList = outLineBLL.GetList(new STK_OutLineParam()
{
SourceBillLineGuids = PRLineGuids
});
if (stkOutLineList != null && stkOutLineList.Count > 0)
{
//获取出库明细对应的出库主单guid
StkOutGuids = stkOutLineList.Select(a => a.StkOutGuid).Distinct().ToArray();
if (StkOutGuids != null && StkOutGuids.Length > 0)
{
//获取出库明细对应的出库主单
stkOutList = this.GetList(new STK_OutParam()
{
StkOutGuids = StkOutGuids, Status = "Complete"
});
if (stkOutList != null && stkOutList.Count > 0)
{
//获取有效的出库主单guid
EffStkOutGuids = stkOutList.Select(a => a.StkOutGuid).Distinct().ToArray();
//获取有效的出库明细集合
effStkOutLineList = stkOutLineList.Where(a => EffStkOutGuids.Contains(a.StkOutGuid)).ToList();
foreach (ORD_PurchaseReturnLineResult purReturnLineResult in purReturnLineList)
{
//汇总有效的出库明细的出库数量
int?qty = effStkOutLineList.Where(a => a.SourceBillLineGuid == purReturnLineResult.PRLineGuid).Sum(a => a.Qty).ToInt32();
purReturnLineResult.StkOutQty = qty;
}
}
}
}
purReturnLineBLL.UpdateOrInsertList(purReturnLineList);
PRGuids = purReturnLineList.Select(a => a.PRGuid).Distinct().ToArray();
foreach (Guid prguid in PRGuids)
{
purReturnBLL.UpdateStatus(new ORD_PurchaseReturnParam()
{
PRGuid = prguid
});
}
}
}
#endregion
}
else if (outResult.BillType == "ZX_OUT")
{
}
#endregion
#endregion
}
}
}
}
else
{
throw new WarnException("要审核的出库单在系统中不存在！");
}
}
catch (WarnException exp)
{
throw exp;
}
catch (Exception exp)
{
LogInfoBLL.WriteLog(this.SessionInfo, exp);
throw exp;
}
return(auditFlag);
}
private void tsbUnDo_Click(object sender, EventArgs e)
{
STK_InResult info = Form_GetEditEntity() as STK_InResult;
this.WF_CancelCheckBill("STK_In", info.StkInGuid, InitData);
}
public bool AuditStkInBill(STK_InParam param)
{
bool auditFlag = true;
try
{
STK_InResult inResult = this.GetInfo(param);;
if (inResult != null)
{
bool isAllowAudit = true;
if (inResult.ApproveStatus == "待提交")
{
isAllowAudit = false;
throw new WarnException("入库单当前状态为:【待提交】,请先提交！");
}
else if (inResult.ApproveStatus == "审核完成")
{
isAllowAudit = false;
throw new WarnException("入库单当前状态为:【审核完成】,禁止重复审核！");
}
if (isAllowAudit)
{
inResult.Status = "Complete";
inResult.ApproveStatus = "审核完成";
WCFAddUpdateResult ret = this.AddOrUpdate(inResult);
if (ret.KeyGuid.ToGuid() == Guid.Empty)
{
auditFlag = false;
}
else
{
#region 定义相关变量(可重复使用)
STK_InLineBLL stkInLineBLL = new STK_InLineBLL();
stkInLineBLL.SessionInfo = this.SessionInfo;
STK_StockBLL stkStockBLL = new STK_StockBLL();
stkStockBLL.SessionInfo = this.SessionInfo;
STK_StockSheetBLL stkStockSheetBLL = new STK_StockSheetBLL();
stkStockSheetBLL.SessionInfo = this.SessionInfo;
STK_StockReserveBLL reserveBLL = new STK_StockReserveBLL();
reserveBLL.SessionInfo = this.SessionInfo;
ORD_SalesOrderBLL saleOrderBLL = new ORD_SalesOrderBLL();
saleOrderBLL.SessionInfo = this.SessionInfo;
ORD_SalesOrderLineBLL saleOrderLineBLL = new ORD_SalesOrderLineBLL();
saleOrderLineBLL.SessionInfo = this.SessionInfo;
ORD_PurchaseOrderBLL purOrderBLL = new ORD_PurchaseOrderBLL();
purOrderBLL.SessionInfo = this.SessionInfo;
ORD_PurchaseOrderLineBLL purOrderLineBLL = new ORD_PurchaseOrderLineBLL();
purOrderLineBLL.SessionInfo = this.SessionInfo;
ORD_SalesReturnBLL returnBLL = new ORD_SalesReturnBLL();
returnBLL.SessionInfo = this.SessionInfo;
ORD_SalesReturnLineBLL returnLineBLL = new ORD_SalesReturnLineBLL();
returnLineBLL.SessionInfo = this.SessionInfo;
Guid?[] _ItemCodes = null;
List <STK_InLineResult> stkInLineList = stkInLineBLL.GetList(new STK_InLineParam()
{
StkInGuid = inResult.StkInGuid
});
#endregion
#region 形成库存，回写库存ID到入库明细，形成库存流水，预留库存 ,回写采购单，销售单的入库数量和入库状态
List <STK_StockResult> stkStockList = new List <STK_StockResult>();
List <STK_StockSheetResult> stkStockSheetList = new List <STK_StockSheetResult>();
if (stkInLineList != null && stkInLineList.Count > 0)
{
if (inResult.BillType == "SOR_IN")
{
_ItemCodes = stkInLineList.Where(a => a.ItemCode != null).Select(a => a.ItemCode).Distinct().ToArray();
stkStockList = stkStockBLL.GetList(new STK_StockParam()
{
ItemCodes = _ItemCodes
});
}
#region 形成库存，回写库存ID，形成流水
STK_StockResult stkStockResult = null;
STK_StockSheetResult stkStockSheetResult = null;
foreach (STK_InLineResult stkInLineResult in stkInLineList)
{
//形成ItemCode,如果是采购入库则new一个实体，如果是销售退货入库则使用传递过来的退货明细的itemCode
Guid?itemCode = null;
#region 形成库存
if (inResult.BillType == "PO_IN")//采购入库
{
itemCode = Guid.NewGuid();
stkStockResult = new STK_StockResult();
stkStockResult.BuyerID = stkInLineResult.BuyerID;
stkStockResult.BuyerName = stkInLineResult.BuyerName;
stkStockResult.POGuid = stkInLineResult.SourceBillGuid;
stkStockResult.POBillNo = stkInLineResult.SourceBillNo;
stkStockResult.POLineGuid = stkInLineResult.SourceBillLineGuid;
stkStockResult.StkInGuid = inResult.StkInGuid;
stkStockResult.StkInBillNo = inResult.BillNo;
stkStockResult.StkInLineGuid = stkInLineResult.StkInLineGuid;
stkStockResult.ItemCode = itemCode;
stkStockResult.Model = stkInLineResult.Model;
stkStockResult.Brand = stkInLineResult.Brand;
stkStockResult.Batch = stkInLineResult.Batch;
stkStockResult.Package = stkInLineResult.Package;
stkStockResult.Quality = stkInLineResult.Quality;
stkStockResult.MPQ = stkInLineResult.MPQ;
stkStockResult.MarkCode = stkInLineResult.MarkCode;
stkStockResult.Remark = stkInLineResult.Remark;
stkStockResult.Warehouse = stkInLineResult.Warehouse;
stkStockResult.Location = stkInLineResult.Location;
stkStockResult.InvType = stkInLineResult.InvType;
stkStockResult.InvQty = stkInLineResult.Qty;
stkStockResult.BookedQty = 0;
stkStockResult.UsableQty = stkInLineResult.Qty;
stkStockResult.Unit = stkInLineResult.Unit;
stkStockResult.Currency = stkInLineResult.Currency;
stkStockResult.BuyPrice = stkInLineResult.CostPrice;
stkStockResult.BuyPriceRMB = stkInLineResult.CostPrice * stkInLineResult.ExchangeRate;
stkStockList.Add(stkStockResult);
stkInLineResult.ItemCode = itemCode; //回写入库明细的库存ID
}
else if (inResult.BillType == "SOR_IN") //销售退货入库
{
itemCode = stkInLineResult.ItemCode;
stkStockResult = stkStockList.FirstOrDefault(a => a.ItemCode == stkInLineResult.ItemCode);
stkStockResult.InvQty += stkInLineResult.Qty;
stkStockResult.UsableQty += stkInLineResult.Qty;
}
else if (inResult.BillType == "ZX_IN")
{
}
#endregion
#region 形成流水
stkStockSheetResult = new STK_StockSheetResult();
stkStockSheetResult.OperEmpID = stkInLineResult.BuyerID;
stkStockSheetResult.OperEmpName = stkInLineResult.BuyerName;
stkStockSheetResult.SSType = 1;
stkStockSheetResult.SourceBillGuid = inResult.StkInGuid;
stkStockSheetResult.SourceBillNo = inResult.BillNo;
stkStockSheetResult.SourceBillLineGuid = stkInLineResult.StkInLineGuid;
stkStockSheetResult.ItemCode = itemCode;
stkStockSheetResult.Model = stkInLineResult.Model;
stkStockSheetResult.Brand = stkInLineResult.Brand;
stkStockSheetResult.Batch = stkInLineResult.Batch;
stkStockSheetResult.Package = stkInLineResult.Package;
stkStockSheetResult.Quality = stkInLineResult.Quality;
stkStockSheetResult.MPQ = stkInLineResult.MPQ;
stkStockSheetResult.MarkCode = stkInLineResult.MarkCode;
stkStockSheetResult.Currency = stkInLineResult.Currency;
stkStockSheetResult.FlowQty = stkInLineResult.Qty;
stkStockSheetResult.FlowPrice = stkInLineResult.CostPrice;
stkStockSheetResult.FlowAmount = stkInLineResult.Amount;
stkStockSheetList.Add(stkStockSheetResult);
#endregion
}
stkStockBLL.UpdateOrInsertList(stkStockList);
stkStockSheetBLL.UpdateOrInsertList(stkStockSheetList);
stkInLineBLL.UpdateOrInsertList(stkInLineList);
#endregion
#region 预留库存
if (inResult.BillType == "PO_IN")//采购入库
{
//有关联销售的采购入库会有销售明细Guid
List <STK_InLineResult> tempInLineList = stkInLineList.Where(a => a.SOLineGuid != null).ToList();
if (tempInLineList != null && tempInLineList.Count > 0)
{
Guid?[] POLineGuids = tempInLineList.Select(a => a.SourceBillLineGuid).Distinct().ToArray();
List <ORD_PurchaseOrderLineResult> purOrderLineList = purOrderLineBLL.GetList(new ORD_PurchaseOrderLineParam()
{
POLineGuids = POLineGuids
});
foreach (STK_InLineResult stkInLineResult in tempInLineList)
{
//入库明细所对应的采购明细
ORD_PurchaseOrderLineResult purOrderLineResult = purOrderLineList.FirstOrDefault(a => a.POLineGuid == stkInLineResult.SourceBillLineGuid);
if (purOrderLineResult != null)
{
//创建预留明细
STK_StockReserveResult reserveResult = new STK_StockReserveResult();
reserveResult.SourceBillGuid = purOrderLineResult.SOGuid; //销售单guid
reserveResult.SourceBillNo = purOrderLineResult.SOBillNo; //销售单编号
reserveResult.SourceBillLineGuid = purOrderLineResult.SOLineGuid; //销售明细guid
reserveResult.SourceBillType = "销售出库";
reserveResult.ReserveType = 1; //采购预留
reserveResult.OperType = false; //系统预留
reserveResult.StkInLineGuid = stkInLineResult.StkInLineGuid; // 入库明细guid
reserveResult.ItemCode = stkInLineResult.ItemCode;
reserveResult.OperFlag = true; //增加
reserveBLL.OperateReserve(reserveResult);
}
}
}
}
#endregion
#region 回写关联单据的入库数量和入库状态
//入库单关联的入库明细
if (stkInLineList != null && stkInLineList.Count > 0)
{
#region 定义相关变量(可重复使用)
Guid?[] SOGuids = null;
Guid?[] SOLineGuids = null;
Guid? POGuid = null;
Guid?[] POLineGuids = null;
Guid? SRGuid = null;
Guid?[] SRLineGuids = null;
Guid?[] StkInGuids = null;
Guid?[] effInGuids = null;
List <ORD_SalesReturnLineResult> returnLineList = null;
List <ORD_PurchaseOrderLineResult> purLineList = null;
List <STK_InResult> inList = null;
List <STK_InLineResult> linkInLineList = null;
List <STK_InLineResult> effInLineList = null;
#endregion
if (inResult.BillType == "PO_IN")
{
#region 更新采购明细的入库数量和采购主单的入库状态
//关联的采购主单
POGuid = inResult.SourceBillGuid;
//关联的采购明细ID集合
POLineGuids = stkInLineList.Where(a => a.SourceBillLineGuid != null).Select(a => a.SourceBillLineGuid).Distinct().ToArray();
if (POLineGuids != null && POLineGuids.Length > 0)
{
//采购明细
purLineList = purOrderLineBLL.GetList(new ORD_PurchaseOrderLineParam()
{
POLineGuids = POLineGuids
});
//采购明细所关联的入库明细
linkInLineList = stkInLineBLL.GetList(new STK_InLineParam()
{
SourceBillLineGuids = POLineGuids
});
StkInGuids = linkInLineList.Select(a => a.StkInGuid).Distinct().ToArray();
if (StkInGuids != null && StkInGuids.Length > 0)
{
//采购明细所关联的入库明细对应的入库主单
inList = this.GetList(new STK_InParam()
{
StkInGuids = StkInGuids, Status = "Complete"
});
if (inList != null && inList.Count > 0)
{
effInGuids = inList.Select(a => a.StkInGuid).Distinct().ToArray();
effInLineList = linkInLineList.Where(a => effInGuids.Contains(a.StkInGuid)).ToList();
foreach (ORD_PurchaseOrderLineResult purLineResult in purLineList)
{
int?qty = effInLineList.Where(a => a.SourceBillLineGuid == purLineResult.POLineGuid).Sum(a => a.Qty.ToInt32());
purLineResult.StkInQty = qty;
}
}
}
purOrderLineBLL.UpdateOrInsertList(purLineList);
purOrderBLL.UpdateStatus(new ORD_PurchaseOrderParam()
{
POGuid = POGuid
});
}
#endregion
#region 更新销售明细的入库数量和销售主单的入库状态
List <STK_InLineResult> tempInLineList = stkInLineList.Where(a => a.SOLineGuid != null).ToList();
if (tempInLineList != null)
{
//获取关联的销售明细ID集合
SOLineGuids = tempInLineList.Select(a => a.SOLineGuid).Distinct().ToArray();
List <ORD_SalesOrderLineResult> saleOrderLineList = saleOrderLineBLL.GetList(new ORD_SalesOrderLineParam()
{
SOLineGuids = SOLineGuids
});
//获取关联的销售明细所关联的入库明细
linkInLineList = stkInLineBLL.GetList(new STK_InLineParam()
{
SOLineGuids = SOLineGuids
});
StkInGuids = linkInLineList.Select(a => a.StkInGuid).Distinct().ToArray();
if (StkInGuids != null && StkInGuids.Length > 0)
{
//销售明细所关联的入库明细对应的入库主单
inList = this.GetList(new STK_InParam()
{
StkInGuids = StkInGuids, Status = "Complete"
});
if (inList != null && inList.Count > 0)
{
effInGuids = inList.Select(a => a.StkInGuid).Distinct().ToArray();
effInLineList = linkInLineList.Where(a => effInGuids.Contains(a.StkInGuid)).ToList();
foreach (ORD_SalesOrderLineResult saleLineResult in saleOrderLineList)
{
int?qty = effInLineList.Where(a => a.SOLineGuid == saleLineResult.SOLineGuid).Sum(a => a.Qty.ToInt32());
saleLineResult.StkInQty = qty;
}
}
}
saleOrderLineBLL.UpdateOrInsertList(saleOrderLineList);
SOGuids = saleOrderLineList.Select(a => a.SOGuid).Distinct().ToArray();
foreach (Guid soguid in SOGuids)
{
saleOrderBLL.UpdateStatus(new ORD_SalesOrderParam()
{
SOGuid = soguid
});
}
}
#endregion
}
else if (inResult.BillType == "SOR_IN")
{
#region 更新销售退货明细的入库数量和退货主单的入库状态
//关联的销售退货主单
SRGuid = inResult.SourceBillGuid;
//关联的销售退货明细ID集合
SRLineGuids = stkInLineList.Where(a => a.SourceBillLineGuid != null).Select(a => a.SourceBillLineGuid).Distinct().ToArray();
if (SRLineGuids != null && SRLineGuids.Length > 0)
{
//退货明细
returnLineList = returnLineBLL.GetList(new ORD_SalesReturnLineParam()
{
SRLineGuids = SRLineGuids
});
//退货明细所关联的入库明细
linkInLineList = stkInLineBLL.GetList(new STK_InLineParam()
{
SourceBillLineGuids = SRLineGuids
});
StkInGuids = linkInLineList.Select(a => a.StkInGuid).Distinct().ToArray();
if (StkInGuids != null && StkInGuids.Length > 0)
{
//退货明细所关联的入库明细对应的入库主单
inList = this.GetList(new STK_InParam()
{
StkInGuids = StkInGuids, Status = "Complete"
});
if (inList != null && inList.Count > 0)
{
effInGuids = inList.Select(a => a.StkInGuid).Distinct().ToArray();
effInLineList = linkInLineList.Where(a => effInGuids.Contains(a.StkInGuid)).ToList();
foreach (ORD_SalesReturnLineResult returnLineResult in returnLineList)
{
int?qty = effInLineList.Where(a => a.SourceBillLineGuid == returnLineResult.SRLineGuid).Sum(a => a.Qty.ToInt32());
returnLineResult.StkInQty = qty;
}
}
}
returnLineBLL.UpdateOrInsertList(returnLineList);
}
#endregion
}
else if (inResult.BillType == "ZX_IN")
{
}
}
#endregion
}
#endregion
}
}
}
else
{
throw new WarnException("要审核的采购单在系统中不存在！");
}
}
catch (WarnException exp)
{
throw exp;
}
catch (Exception exp)
{
LogInfoBLL.WriteLog(this.SessionInfo, exp);
throw exp;
}
return(auditFlag);
}
public bool SubmitStkInBill(STK_InParam param)
{
this.CheckSession();
bool submitFlag = true;
try
{
STK_InResult inResult = this.GetInfo(param);
if (inResult != null)
{
#region 更新关联单据的相关数据（回写）和状态
//入库单关联的入库明细
List <STK_InLineResult> inLineList = inResult.StkInLineList;
if (inLineList != null && inLineList.Count > 0)
{
#region 定义相关变量(可重复使用)
#region 申明逻辑层变量
ORD_PurchaseOrderLineBLL purLineBLL = new ORD_PurchaseOrderLineBLL();
purLineBLL.SessionInfo = this.SessionInfo;
ORD_PurchaseOrderBLL purOrderBLL = new ORD_PurchaseOrderBLL();
purOrderBLL.SessionInfo = this.SessionInfo;
ORD_SalesReturnBLL returnBLL = new ORD_SalesReturnBLL();
returnBLL.SessionInfo = this.SessionInfo;
ORD_SalesReturnLineBLL returnLineBLL = new ORD_SalesReturnLineBLL();
returnLineBLL.SessionInfo = this.SessionInfo;
STK_InLineBLL stkInLineBLL = new STK_InLineBLL();
stkInLineBLL.SessionInfo = this.SessionInfo;
STK_InBLL inBLL = new STK_InBLL();
inBLL.SessionInfo = this.SessionInfo;
#endregion
#region 初始化变量
Guid? POGuid = null;
Guid?[] POLineGuids = null;
Guid? SRGuid = null;
Guid?[] SRLineGuids = null;
Guid?[] StkInGuids = null;
Guid?[] effInGuids = null;
List <ORD_PurchaseOrderLineResult> purLineList = null;
List <ORD_SalesReturnLineResult> returnLineList = null;
List <STK_InResult> inList = null;
List <STK_InLineResult> linkInLineList = null;
List <STK_InLineResult> effInLineList = null;
#endregion
#endregion
if (inResult.BillType == "PO_IN")
{
#region 更新采购明细的占有数量和采购主单的占有状态
POGuid = inResult.SourceBillGuid; //关联的采购主单
POLineGuids = inLineList.Where(a => a.SourceBillLineGuid != null).Select(a => a.SourceBillLineGuid).Distinct().ToArray(); //关联的采购明细ID集合
if (POLineGuids != null && POLineGuids.Length > 0)
{
purLineList = purLineBLL.GetList(new ORD_PurchaseOrderLineParam()
{
POLineGuids = POLineGuids
}); //采购明细
linkInLineList = stkInLineBLL.GetList(new STK_InLineParam()
{
SourceBillLineGuids = POLineGuids
}); //采购明细所关联的入库明细
StkInGuids = linkInLineList.Select(a => a.StkInGuid).Distinct().ToArray();
if (StkInGuids != null && StkInGuids.Length > 0)
{
//采购明细所关联的入库明细对应的入库主单
inList = this.GetList(new STK_InParam()
{
StkInGuids = StkInGuids, StatusArr = new string[] { "Complete", "Approve" }
});
if (inList != null && inList.Count > 0)
{
effInGuids = inList.Select(a => a.StkInGuid).Distinct().ToArray();
effInLineList = linkInLineList.Where(a => effInGuids.Contains(a.StkInGuid)).ToList();
foreach (ORD_PurchaseOrderLineResult purLineResult in purLineList)
{
int?qty = effInLineList.Where(a => a.SourceBillLineGuid == purLineResult.POLineGuid).Sum(a => a.Qty.ToInt32());
purLineResult.StkInOccQty = qty;
}
}
}
purLineBLL.UpdateOrInsertList(purLineList);
purOrderBLL.UpdateStatus(new ORD_PurchaseOrderParam()
{
POGuid = POGuid
});
}
#endregion
}
else if (inResult.BillType == "SOR_IN")
{
#region 更新销售退货明细的入库占有数量和退货主单的占有状态
//关联的销售退货主单
SRGuid = inResult.SourceBillGuid;
//关联的销售退货明细ID集合
SRLineGuids = inLineList.Where(a => a.SourceBillLineGuid != null).Select(a => a.SourceBillLineGuid).Distinct().ToArray();
if (SRLineGuids != null && SRLineGuids.Length > 0)
{
//退货明细
returnLineList = returnLineBLL.GetList(new ORD_SalesReturnLineParam()
{
SRLineGuids = SRLineGuids
});
//退货明细所关联的入库明细
linkInLineList = stkInLineBLL.GetList(new STK_InLineParam()
{
SourceBillLineGuids = SRLineGuids
});
StkInGuids = linkInLineList.Select(a => a.StkInGuid).Distinct().ToArray();
if (StkInGuids != null && StkInGuids.Length > 0)
{
//退货明细所关联的入库明细对应的入库主单
inList = this.GetList(new STK_InParam()
{
StkInGuids = StkInGuids, StatusArr = new string[] { "Complete", "Approve" }
});
if (inList != null && inList.Count > 0)
{
effInGuids = inList.Select(a => a.StkInGuid).Distinct().ToArray();
effInLineList = linkInLineList.Where(a => effInGuids.Contains(a.StkInGuid)).ToList();
foreach (ORD_SalesReturnLineResult returnLineResult in returnLineList)
{
int?qty = effInLineList.Where(a => a.SourceBillLineGuid == returnLineResult.SRLineGuid).Sum(a => a.Qty.ToInt32());
returnLineResult.StkInOccQty = qty;
}
}
}
returnLineBLL.UpdateOrInsertList(returnLineList);
}
#endregion
}
else if (inResult.BillType == "ZX_IN")
{
}
}
#endregion
}
else
{
throw new WarnException("要提交的入库单在系统中不存在！");
}
}
catch (WarnException exp)
{
throw exp;
}
catch (Exception exp)
{
LogInfoBLL.WriteLog(this.SessionInfo, exp);
throw exp;
}
return(submitFlag);
}
/// <summary>
/// 添加和新增修改
/// </summary>
/// <param name="param">新增或修改的实体</param>
/// <returns></returns>
public WCFAddUpdateResult AddOrUpdate(STK_InResult param)
{
this.CheckSession();
WCFAddUpdateResult ret = new WCFAddUpdateResult();
try
{
int affect = 0;
#region 判断
if (string.IsNullOrEmpty(param.BillType))
{
throw new WarnException("请指定入库类型！");
}
if (param.StkInLineList == null)
{
throw new WarnException("请填写入库明细！");
}
string msg = string.Empty;
foreach (STK_InLineResult rst in param.StkInLineList)
{
if (string.IsNullOrEmpty(rst.Model))
{
msg = "请填写入库明细的型号！";
break;
}
if (rst.Qty <= 0)
{
msg = "请填写入库明细的数量！";
}
}
#endregion
List <STK_InLineResult> orderLineList = param.StkInLineList;
#region 系统默认值
if (param.StkInGuid != null)
{
WhereClip where = STK_In._.StkInGuid == param.StkInGuid;
param.UpdatedEmpID = this.SessionInfo.UserID;
param.UpdatedEmpName = this.SessionInfo.UserName;
param.UpdatedTime = DateTime.Now;
affect = this.Update <STK_InResult>(param, where);
}
else
{
param.StkInGuid = Guid.NewGuid();
Sys_CodeRulerBLL codeRulerBll = new Sys_CodeRulerBLL();
codeRulerBll.SessionInfo = this.SessionInfo;
param.BillNo = param.BillNo = codeRulerBll.GetBillNo(new Entity.UserModel.Sys.SYS_CredentialCodeRuleParam()
{
BillDate = DateTime.Today, TableName = "STK_In"
});
param.GCompanyID = this.SessionInfo.CompanyID;
param.Status = "New";
param.ApproveStatus = "待提交";
param.IsDeleted = false;
param.CreatedEmpID = this.SessionInfo.UserID;
param.CreatedEmpName = this.SessionInfo.UserName;
param.CreatedTime = DateTime.Now;
affect = this.Insert <STK_InResult>(param);
param = this.Select <STK_InResult>(new List <Field>()
{
STK_In._.All
}, STK_In._.StkInGuid == param.StkInGuid);
}
foreach (STK_InLineResult rst in orderLineList)
{
if (rst.StkInLineGuid == null)
{
rst.StkInLineGuid = Guid.NewGuid();
rst.StkInGuid = param.StkInGuid;
rst.GCompanyID = this.SessionInfo.CompanyID;
rst.CreatedEmpID = this.SessionInfo.UserID;
rst.CreatedEmpName = this.SessionInfo.UserName;
rst.CreatedTime = DateTime.Now;
rst.IsDeleted = false;
}
else
{
rst.UpdatedEmpID = this.SessionInfo.UserID;
rst.UpdatedEmpName = this.SessionInfo.UserName;
rst.UpdatedTime = DateTime.Now;
}
}
this.BatchInsertOrUpdate <STK_InLineResult>(orderLineList);
this.BatchExecute();
#region 设置返回值
ret.KeyGuid = param.StkInGuid;
ret.CreatedTime = param.CreatedTime;
ret.CreatedEmpID = param.CreatedEmpID;
ret.CreatedEmpName = param.CreatedEmpName;
ret.UpdatedEmpID = param.UpdatedEmpID;
ret.UpdatedEmpName = param.UpdatedEmpName;
ret.UpdatedTime = param.UpdatedTime;
#endregion
#endregion
}
catch (WarnException exp)
{
throw exp;
}
catch (System.Exception exp)
{
LogInfoBLL.WriteLog(this.SessionInfo, exp);
throw exp;
}
return(ret);
}
