public static DataTable GetLeaveReportForUnit(string Year, string Month, string UnitCode) { DataTable table2; QueryAgent agent = new QueryAgent(); try { string queryString = "sp_LeaveReportForPerson"; string[] parameterNames = new string[] { "@Year", "@Month", "@UnitCode" }; object[] values = new object[] { Year, Month, UnitCode }; DataTable table = agent.ExecSPForDataSet(queryString, parameterNames, values).Tables[0]; table2 = table; } finally { agent.Dispose(); } return(table2); }
public static DataTable BiddingProcess(string BiddingCode) { DataTable table2; QueryAgent agent = new QueryAgent(); try { string queryString = "sp_BiddingProcess"; string[] parameterNames = new string[] { "@BiddingCode" }; object[] values = new object[] { BiddingCode }; DataTable table = agent.ExecSPForDataSet(queryString, parameterNames, values).Tables[0]; table2 = table; } finally { agent.Dispose(); } return(table2); }