C# (CSharp) CarsMaintenance.Reports.ScrapByShipDataSet 예제들

예제 #1

파일: SQLHelper.cs 프로젝트: irengine/tms

        public static DataSet QueryScrapByShipReport(DateTime beginDate, DateTime endDate)
        {
            DataSet dataSet = new CarsMaintenance.Reports.ScrapByShipDataSet();

            using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings[CONNECTION_NAME].ConnectionString))
            {
                try
                {
                    conn.Open();

                    string sql = string.Format(sqlScrapByShip, beginDate, endDate);

                    SqlDataAdapter dataAdapter = new SqlDataAdapter(sql, conn);
                    dataAdapter.Fill(dataSet.Tables[0]);
                }
                //catch (Exception e)
                //{
                //}
                finally
                {
                    conn.Close();
                }
            }
            return(dataSet);
        }

예제 #2

파일: SQLHelper.cs 프로젝트: irengine/TMS2

        public static DataSet QueryScrapByShipReport(DateTime beginDate, DateTime endDate)
        {
            DataSet dataSet = new CarsMaintenance.Reports.ScrapByShipDataSet();
            using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings[CONNECTION_NAME].ConnectionString))
            {
                try
                {

                    conn.Open();

                    string sql =string.Format( sqlScrapByShip,beginDate,endDate);

                    SqlDataAdapter dataAdapter = new SqlDataAdapter(sql, conn);
                    dataAdapter.Fill(dataSet.Tables[0]);
                }
                //catch (Exception e)
                //{
                //}
                finally
                {
                    conn.Close();
                }

            }
            return dataSet;
        }