Пример #1
0
        public static void smethod_4(SqlConnection sqlConnection_0, string string_0, SqlParameter[] sqlParameter_0, out DataSet dataSet_0)
        {
            SqlCommand sqlCommand = SqlDBA.smethod_6(sqlConnection_0, string_0, sqlParameter_0);

            using (SqlDataAdapter sqlDataAdapter = new SqlDataAdapter(sqlCommand))
            {
                DataSet dataSet = new DataSet();
                sqlDataAdapter.Fill(dataSet);
                sqlCommand.Parameters.Clear();
                sqlConnection_0.Close();
                sqlConnection_0.Dispose();
                dataSet_0 = dataSet;
                sqlDataAdapter.Dispose();
            }
        }
Пример #2
0
        public static DataTable smethod_5(SqlConnection sqlConnection_0, string string_0, SqlParameter[] sqlParameter_0)
        {
            DataTable  dataTable  = new DataTable();
            SqlCommand sqlCommand = SqlDBA.smethod_6(sqlConnection_0, string_0, sqlParameter_0);

            using (SqlDataAdapter sqlDataAdapter = new SqlDataAdapter(sqlCommand))
            {
                try
                {
                    sqlDataAdapter.Fill(dataTable);
                }
                catch (Exception exception)
                {
                }
                sqlCommand.Parameters.Clear();
                sqlDataAdapter.Dispose();
                sqlConnection_0.Close();
                sqlConnection_0.Dispose();
            }
            return(dataTable);
        }
Пример #3
0
        public static int RunProc(SqlConnection sqlConnection_0, string string_0, SqlParameter[] sqlParameter_0)
        {
            int num;

            try
            {
                sqlConnection_0.Open();
            }
            catch (Exception exception1)
            {
                Exception exception = exception1;
                Form1.WriteLine(100, string.Concat("SqlDBA数据层_错误1", exception.Message));
                num = -1;
                return(num);
            }
            SqlCommand sqlCommand = SqlDBA.smethod_6(sqlConnection_0, string_0, sqlParameter_0);

            try
            {
                try
                {
                    sqlCommand.ExecuteNonQuery();
                    return((int)sqlCommand.Parameters["ReturnValue"].Value);
                }
                catch (Exception exception3)
                {
                    Exception exception2 = exception3;
                    Form1.WriteLine(100, string.Concat("SqlDBA数据层_错误2", exception2.Message));
                    sqlCommand.Parameters.Clear();
                    num = -1;
                }
            }
            finally
            {
                sqlConnection_0.Close();
                sqlConnection_0.Dispose();
            }
            return(num);
        }
Пример #4
0
 public static void smethod_3(SqlConnection sqlConnection_0, string string_0, SqlParameter[] sqlParameter_0, out SqlDataReader sqlDataReader_0)
 {
     sqlDataReader_0 = SqlDBA.smethod_6(sqlConnection_0, string_0, sqlParameter_0).ExecuteReader(CommandBehavior.CloseConnection);
 }