public static DataSet QueryOutboundOrder(int id)
{
DataSet dataSet = new CarsMaintenance.Reports.OutboundOrderDataSet();
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings[CONNECTION_NAME].ConnectionString))
{
try{
conn.Open();
string sql = string.Format(sqlOutboundOrder, id);
SqlDataAdapter dataAdapter = new SqlDataAdapter(sql, conn);
dataAdapter.Fill(dataSet.Tables[0]);
}
//catch (Exception e)
//{
//}
finally
{
conn.Close();
}
}
return dataSet;
}
public static DataSet QueryOutboundOrder(int id)
{
DataSet dataSet = new CarsMaintenance.Reports.OutboundOrderDataSet();
using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings[CONNECTION_NAME].ConnectionString))
{
try{
conn.Open();
string sql = string.Format(sqlOutboundOrder, id);
SqlDataAdapter dataAdapter = new SqlDataAdapter(sql, conn);
dataAdapter.Fill(dataSet.Tables[0]);
}
//catch (Exception e)
//{
//}
finally
{
conn.Close();
}
}
return(dataSet);
}
