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(); } }
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); }
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); }
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); }