public bool QueryItemData(string ItemBarCode, string PeriodBarCode, string PurchaseNo, out string Item, out string Period,
out string Cost, out string Price, out string TaxType, out string PURCHASE_QTY,
out string PLAN_ACCEPT_DATE, out string accept_qty, out string Qty,
out string DIS_Qty)
{
//1.取得ITEM PERIOD商品基本資料
Item = string.Empty;
Period = string.Empty;
Cost = string.Empty;
Price = string.Empty;
TaxType = string.Empty;
PURCHASE_QTY = string.Empty;
PLAN_ACCEPT_DATE = string.Empty;
accept_qty = string.Empty;
Qty = string.Empty;
DIS_Qty = string.Empty;
DataTable dtResult = new DataTable();
try
{
DBO.MaintainAcceptDBO dbo = new DBO.MaintainAcceptDBO(ref USEDB);
ArrayList QueryParameter = new ArrayList();
QueryParameter.Clear();
QueryParameter.Add(ItemBarCode);
QueryParameter.Add(PeriodBarCode);
QueryParameter.Add(PurchaseNo);
dtResult = dbo.GetItemPeriod(QueryParameter);
if (dtResult.Rows.Count > 0)
{
Item = dtResult.Rows[0]["Item"].ToString();
Period = dtResult.Rows[0]["Period"].ToString();
Cost = dtResult.Rows[0]["Cost"].ToString();
Price = dtResult.Rows[0]["Price"].ToString();
TaxType = dtResult.Rows[0]["Tax_Type"].ToString();
}
else
{
return false;
}
QueryParameter.Clear();
QueryParameter.Add(Item);
QueryParameter.Add(Period);
QueryParameter.Add(PurchaseNo);
dtResult = dbo.GetPurQtyDate(QueryParameter);
if (dtResult.Rows.Count > 0)
{
PURCHASE_QTY = dtResult.Rows[0]["PURCHASE_QTY"].ToString();
PLAN_ACCEPT_DATE = dtResult.Rows[0]["PLAN_ACCEPT_DATE"].ToString();
}
else
{
return false;
}
dtResult = dbo.GetTotalPurQty(QueryParameter);
if (dtResult.Rows.Count > 0)
{
accept_qty = dtResult.Rows[0]["accept_qty"].ToString();
}
else
{
//return false;
accept_qty = "0";
}
QueryParameter.Clear();
QueryParameter.Add(Item);
QueryParameter.Add(Period);
dtResult = dbo.GetTotalDisQty(QueryParameter);
if (dtResult.Rows.Count > 0)
{
if (dtResult.Rows[0]["Qty"].ToString() == "")
{
Qty = "0";
}
else
{
Qty = dtResult.Rows[0]["Qty"].ToString();
}
if (dtResult.Rows[0]["DIS_Qty"].ToString() == "")
{
DIS_Qty = "0";
}
else
{
DIS_Qty = dtResult.Rows[0]["DIS_Qty"].ToString();
}
}
else
{
//return false;
Qty = "0";
DIS_Qty = "0";
}
return true;
}
catch (Exception ex)
{
throw ex;
}
}