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