public static DataSet QueryToolInfoReport(DateTime beginDate, DateTime endDate, string JobPosition, string JobType)
{
DataSet dataSet = new CarsMaintenance.Reports.ToolInfoDataSet();
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings[CONNECTION_NAME].ConnectionString))
{
try
{
conn.Open();
string c = "";
if (!JobType.Trim().Equals(string.Empty))
{
c = c + " and o.JobType='" + JobType + "' ";
}
if (!JobPosition.Trim().Equals(string.Empty))
{
c = c + " and o.JobPosition='" + JobPosition + "' ";
}
string sql = string.Format(sqlToolInfoReport, beginDate, endDate, c);
SqlDataAdapter dataAdapter = new SqlDataAdapter(sql, conn);
dataAdapter.Fill(dataSet.Tables[0]);
}
//catch (Exception e)
//{
//}
finally
{
conn.Close();
}
}
return(dataSet);
}
public static DataSet QueryToolInfoReport(DateTime beginDate, DateTime endDate, string JobPosition,string JobType)
{
DataSet dataSet = new CarsMaintenance.Reports.ToolInfoDataSet();
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings[CONNECTION_NAME].ConnectionString))
{
try
{
conn.Open();
string sql =string.Format( sqlToolInfoReport,beginDate,endDate);
if (!JobType.Trim().Equals(string.Empty))
{
sql=sql+ " and o.JobType='"+JobType+"' ";
}
if (!JobPosition.Trim().Equals(string.Empty))
{
sql=sql+ " and o.JobPosition='"+JobPosition+"' ";
}
SqlDataAdapter dataAdapter = new SqlDataAdapter(sql, conn);
dataAdapter.Fill(dataSet.Tables[0]);
}
//catch (Exception e)
//{
//}
finally
{
conn.Close();
}
}
return dataSet;
}
