public bool IsExistsArrangeBillFactPallet(string strArriveBillNo, string strPalletNo)
{
BArrangeBillFactBB arrangeBillFactBB = new BArrangeBillFactBB();
try
{
DataTable dt = new DataTable();
dt = arrangeBillFactBB.GetList("arriveBillNo='" + strArriveBillNo + "' and palletNo='" + strPalletNo + "'").Tables[0];
return dt.Rows.Count > 0 ? true : false;
}
finally
{
arrangeBillFactBB.Dispose();
}
}
public DataTable GetArrangeBillFactDetail(string strArriveBillNo, string strPalletIndex, string strRegion)
{
BArrangeBillFactBB arrangeBillFactBB = new BArrangeBillFactBB();
BArrangeBillFactDetailBB arrangeBillFactDetailBB = new BArrangeBillFactDetailBB();
try
{
DataTable dt = new DataTable();
DataSet ds = new DataSet();
string mainId = "0";
ds = arrangeBillFactBB.GetList("arriveBillNo='" + strArriveBillNo + "' and palletIndex='" + strPalletIndex + "'");
if (ds.Tables[0].Rows.Count > 0)
{
mainId = ds.Tables[0].Rows[0]["id"].ToString();
}
dt = arrangeBillFactDetailBB.GetVList("mainId='" + mainId + "' and region='" + strRegion + "'").Tables[0];
return dt;
}
finally
{
arrangeBillFactBB.Dispose();
arrangeBillFactDetailBB.Dispose();
}
}
public string GetPalletNo(string strArriveBillNo, string strPalletIndex)
{
BArrangeBillFactBB arrangeBillFactBB = new BArrangeBillFactBB();
try
{
DataSet ds = new DataSet();
string strPalletNo = "";
ds = arrangeBillFactBB.GetList("arriveBillNo='" + strArriveBillNo + "' and palletIndex='" + strPalletIndex + "'");
if (ds.Tables[0].Rows.Count > 0)
{
strPalletNo = ds.Tables[0].Rows[0]["palletNo"].ToString();
}
return strPalletNo;
}
finally
{
arrangeBillFactBB.Dispose();
}
}