public static DataSet QueryColligateReport(DateTime beginDate, DateTime endDate)
{
DataSet dataSet = new CarsMaintenance.Reports.ColligateDataSet();
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings[CONNECTION_NAME].ConnectionString))
{
try
{
conn.Open();
string sql = "";
sql = string.Format(sqlColligaterByJobTypeReport, beginDate, endDate);
SqlDataAdapter dataAdapter = new SqlDataAdapter(sql, conn);
dataAdapter.Fill(dataSet.Tables["ColligateByJobType"]);
sql = string.Format(sqlColligaterByJobPosition, beginDate, endDate);
dataAdapter = new SqlDataAdapter(sql, conn);
dataAdapter.Fill(dataSet.Tables["ColligateByJobPosition"]);
sql = string.Format(sqlColligaterByUnitName, beginDate, endDate);
dataAdapter = new SqlDataAdapter(sql, conn);
dataAdapter.Fill(dataSet.Tables["CooligateByUnitName"]);
}
//catch (Exception e)
//{
//}
finally
{
conn.Close();
}
}
return(dataSet);
}
public static DataSet QueryColligateReport(DateTime beginDate, DateTime endDate)
{
DataSet dataSet = new CarsMaintenance.Reports.ColligateDataSet();
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings[CONNECTION_NAME].ConnectionString))
{
try
{
conn.Open();
string sql="";
sql=string.Format( sqlColligaterByJobTypeReport,beginDate,endDate);
SqlDataAdapter dataAdapter = new SqlDataAdapter(sql, conn);
dataAdapter.Fill(dataSet.Tables["ColligateByJobType"]);
sql =string.Format( sqlColligaterByJobPosition,beginDate,endDate);
dataAdapter = new SqlDataAdapter(sql, conn);
dataAdapter.Fill(dataSet.Tables["ColligateByJobPosition"]);
sql =string.Format( sqlColligaterByUnitName,beginDate,endDate);
dataAdapter = new SqlDataAdapter(sql, conn);
dataAdapter.Fill(dataSet.Tables["CooligateByUnitName"]);
}
//catch (Exception e)
//{
//}
finally
{
conn.Close();
}
}
return dataSet;
}
