public string CheckItemApprove(string Item, string Period)
{
try
{
DBO.MaintainAcceptDBO dbo = new DBO.MaintainAcceptDBO(ref USEDB);
ArrayList QueryParameter = new ArrayList();
QueryParameter.Clear();
QueryParameter.Add(Item);
QueryParameter.Add(Period);
DataTable dtResult = dbo.GetItemApprove(QueryParameter);
if (dtResult.Rows[0]["Acct_Validate"].ToString() != "1") //未核准
{
return "1";
}
string dateNow = DateTime.Now.ToString("yyyyMMdd");
string EndDate = dtResult.Rows[0]["Period_End_Date"].ToString();
if (EndDate == "")
{
return "0";
}
if (int.Parse(EndDate) < int.Parse(dateNow)) //過期
{
return "2";
}
return "0";
}
catch (Exception ex)
{
throw ex;
}
}