C# (CSharp) CarsMaintenance.Reports.ToolDataSet示例

示例#1

文件： SQLHelper.cs 项目： irengine/tms

        public static DataSet QueryToolReport(string name, string code)
        {
            DataSet dataSet = new CarsMaintenance.Reports.ToolDataSet();

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

                    string sql = string.Format(sqlToolReport, name, code);;

                    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 QueryToolReport(string name, string code)
        {
            DataSet dataSet = new CarsMaintenance.Reports.ToolDataSet();
            using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings[CONNECTION_NAME].ConnectionString))
            {
                try
                {

                    conn.Open();

                    string sql = string.Format(sqlToolReport, name, code); ;

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

            }
            return dataSet;
        }