/// <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); }