/// <summary> /// 初始化拣货计划数据源 /// </summary> private void InitDtPickOutPlan() { using (CPickOutPlanBB pickOutPlanBB = new CPickOutPlanBB()) { //查找当前备货单下的拣货计划 this.DtResult = pickOutPlanBB.GetVList("stockUpBillNo='" + this.stockUpBillNo.Text.Trim() + "'").Tables[0]; if (this.DtResult != null && this.DtResult != null && this.DtResult.Rows.Count > 0) { this.grid.DataSource = this.DtResult; this.grid.DataBind(); } } }
/// <summary> /// 初始化拣货计划数据源 /// </summary> private void InitDtPickOutPlan() { using (CPickOutPlanBB pickOutPlanBB = new CPickOutPlanBB()) { //查找当前备货单下的拣货计划 this.DtResult = pickOutPlanBB.GetVList("stockUpBillNo='" + this.stockUpBillNo.Text.Trim() + "'").Tables[0]; //添加GUID、是否删除标志 this.DtResult.Columns.Add(new DataColumn("rowId", typeof(string))); this.DtResult.Columns.Add(new DataColumn("isdel", typeof(bool))); if (this.DtResult != null && this.DtResult != null && this.DtResult.Rows.Count > 0) { foreach (DataRow row in this.DtResult.Rows) { row["rowId"] = Guid.NewGuid().ToString(); row["isdel"] = false; } this.BindGridPickOutPlan();//绑定拣货计划列表 this.btnNewPlan.Enabled = false; } } }
public DataTable GetPickOutDetail_NoFinish(string strStockUpBillNo) { CPickOutPlanBB pickOutPlanBB = new CPickOutPlanBB(); try { DataTable dt = new DataTable(); //限制托盘在拣货库区 dt = pickOutPlanBB.GetVList("stockUpBillNo='" + strStockUpBillNo + "' and instantState='02' and not exists(select 1 from dbo.vBArrangeBillBox where dbo.vCPickOutPlan.palletNo=dbo.vBArrangeBillBox.palletNo and dbo.vBArrangeBillBox.wareType<>'04') and isnull(dbo.vArrangeBillNox.wareNo,'')<>''").Tables[0]; return dt; } finally { pickOutPlanBB.Dispose(); } }