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; } }