private int CheckItemOverDate(string strItem)
{
int iResult = 1;//0:無資料 -1:過期 1:正常 -2:品號不屬於此供應商
MaintainPurchaseOrder BCO = new MaintainPurchaseOrder(ConntionDB);
ParameterList.Clear();
ParameterList.Add(strItem);
DataTable dt = BCO.QueryItem(ParameterList);
if (dt.Rows.Count > 0)
{
if (PUR_VendorCode.Text.Trim() != dt.Rows[0]["MANUFACTURE"].ToString().Trim())
{
iResult = -2;
}
else
{
string strNowDate = DateTime.Now.ToString("yyyy/MM/dd");
if (string.Compare(dt.Rows[0]["mdc_end_date"].ToString(), strNowDate) < 0)
{
iResult = -1;
}
}
}
else
{
iResult = 0;
}
return iResult;
}
private static int CheckItemDate(string sItem)
{
int iResult = -2; //-2:無資料 -1:過期 0:正常
MaintainPurchaseOrder BCO = new MaintainPurchaseOrder(ConntionDB);
ParameterList.Clear();
ParameterList.Add(sItem);
DataTable dt = BCO.QueryItem(ParameterList);
if (dt.Rows.Count > 0)
{
string strNowDate = DateTime.Now.ToString("yyyy/MM/dd");
if (string.Compare(dt.Rows[0]["mdc_end_date"].ToString(), strNowDate) < 0)
{
iResult = -1;
}
else
{
iResult = 0;
}
}
return iResult;
}