public static DataSet QuerysqlScrapByUnitReport(DateTime beginDate, DateTime endDate) { DataSet dataSet = new CarsMaintenance.Reports.ScrapByUnitDataSet(); using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings[CONNECTION_NAME].ConnectionString)) { try { conn.Open(); string sql = string.Format(sqlScrapByUnit, beginDate, endDate, beginDate, endDate); SqlDataAdapter dataAdapter = new SqlDataAdapter(sql, conn); dataAdapter.Fill(dataSet.Tables[0]); } //catch (Exception e) //{ //} finally { conn.Close(); } } return(dataSet); }
public static DataSet QuerysqlScrapByUnitReport(DateTime beginDate, DateTime endDate) { DataSet dataSet = new CarsMaintenance.Reports.ScrapByUnitDataSet(); using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings[CONNECTION_NAME].ConnectionString)) { try { conn.Open(); string sql =string.Format( sqlScrapByUnit,beginDate,endDate,beginDate,endDate); SqlDataAdapter dataAdapter = new SqlDataAdapter(sql, conn); dataAdapter.Fill(dataSet.Tables[0]); } //catch (Exception e) //{ //} finally { conn.Close(); } } return dataSet; }