private void InitialOtherOutInPlan() { using (OtherOutInPickOutPlanBB pickOutPlanBB = new OtherOutInPickOutPlanBB()) { //查找当前备货单下的拣货计划 string StockUpBillNO = pickOutPlanBB.GetStockUpBillNo(DocEntry); if (string.IsNullOrEmpty(StockUpBillNO)) { StockUpBillNO = ""; } this.DtResultNew = pickOutPlanBB.GetList("stockUpBillNo='" + StockUpBillNO.Trim() + "'").Tables[0]; //添加GUID、是否删除标志 this.DtResultNew.Columns.Add(new DataColumn("rowId", typeof(string))); this.DtResultNew.Columns.Add(new DataColumn("isdel", typeof(bool))); if (this.DtResultNew != null && this.DtResultNew != null && this.DtResultNew.Rows.Count > 0) { foreach (DataRow row in this.DtResultNew.Rows) { row["rowId"] = Guid.NewGuid().ToString(); row["isdel"] = false; } this.BindGridPickOutPlan();//绑定拣货计划列表 //this.btnNewPlan.Enabled = false; //this.btnSubmit.Enabled = false; } } }
public void FinishOtherPickOutPlan(int pickOutPlanId, int pickOutEmpId) { OtherOutInPickOutPlanBB pickOutPlanBB = new OtherOutInPickOutPlanBB(); SCommBB commBB = new SCommBB(); try { StringBuilder strSql = new StringBuilder(); OtherOutInPickOutPlanData pickOutPlanModel = new OtherOutInPickOutPlanData(); pickOutPlanModel = pickOutPlanBB.GetModel(pickOutPlanId); pickOutPlanModel.pickOutDt = System.DateTime.Now.ToString();//拣货时间 pickOutPlanModel.pickOutEmpId = pickOutEmpId;//拣货人 pickOutPlanModel.instantState = "03";//已完成 pickOutPlanBB.ModifyRecord(pickOutPlanModel); ////解除库位的锁定 //strSql.Append(@"update dbo.UStock set isOutStocking=0 where wareLocatorNo='" + pickOutPlanModel.wareLocatorNo // + "' and materialNo='" + pickOutPlanModel.materialNo + "'and isOutStocking=1"); //commBB.ExecuteSql(strSql.ToString()); ////更改原箱的是否锁定状态 //strSql = new StringBuilder(); //strSql.Append("update dbo.BArrangeBillBox set isOutStocking=0 where wareLocatorNo='" + pickOutPlanModel.wareLocatorNo // + "' and materialNo='" + pickOutPlanModel.materialNo + "' and isOutStocking=1"); //commBB.ExecuteSql(strSql.ToString()); } finally { pickOutPlanBB.Dispose(); commBB.Dispose(); } }