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