public static int smethod_7(string string_0, string string_1)
{
int num;
DBA.serlog(string_0);
using (SqlConnection sqlConnection = new SqlConnection(DBA.smethod_3(string_1)))
{
using (SqlCommand sqlCommand = new SqlCommand(string_0, sqlConnection))
{
int num1 = -1;
try
{
sqlConnection.Open();
}
catch
{
num = -1;
return(num);
}
try
{
num1 = sqlCommand.ExecuteNonQuery();
}
catch (Exception exception)
{
DBA.smethod_2(string_0, null, exception);
}
sqlCommand.Dispose();
sqlConnection.Close();
sqlConnection.Dispose();
return(num1);
}
}
return(num);
}
public static DataTable smethod_9(string string_0, SqlParameter[] sqlParameter_0)
{
DataTable dataTable;
DBA.serlog(string_0, sqlParameter_0);
using (SqlConnection sqlConnection = new SqlConnection(DBA.smethod_3(null)))
{
using (SqlDataAdapter sqlDataAdapter = new SqlDataAdapter())
{
SqlCommand sqlCommand = SqlDBA.smethod_7(sqlConnection, string_0, sqlParameter_0);
SqlCommand sqlCommand1 = sqlCommand;
sqlDataAdapter.SelectCommand = sqlCommand;
using (sqlCommand1)
{
try
{
sqlConnection.Open();
}
catch (Exception exception1)
{
Exception exception = exception1;
Form1.WriteLine(100, string.Concat("DBA数据层_错误", exception.Message, " ", string_0));
dataTable = null;
return(dataTable);
}
DataTable dataTable1 = new DataTable();
try
{
sqlDataAdapter.Fill(dataTable1);
}
catch (Exception exception2)
{
DBA.smethod_2(string_0, sqlParameter_0, exception2);
}
sqlDataAdapter.Dispose();
sqlConnection.Close();
sqlConnection.Dispose();
return(dataTable1);
}
}
}
return(dataTable);
}
public static DataTable GetDBToDataTable(string string_0, string string_1)
{
DataTable dataTable;
DBA.serlog(string_0);
using (SqlConnection sqlConnection = new SqlConnection(DBA.smethod_3(string_1)))
{
using (SqlDataAdapter sqlDataAdapter = new SqlDataAdapter())
{
SqlCommand sqlCommand = new SqlCommand(string_0, sqlConnection);
SqlCommand sqlCommand1 = sqlCommand;
sqlDataAdapter.SelectCommand = sqlCommand;
using (sqlCommand1)
{
try
{
sqlConnection.Open();
}
catch
{
dataTable = null;
return(dataTable);
}
DataTable dataTable1 = new DataTable();
try
{
sqlDataAdapter.Fill(dataTable1);
}
catch (Exception exception)
{
DBA.smethod_2(string_0, null, exception);
}
sqlDataAdapter.Dispose();
sqlConnection.Close();
sqlConnection.Dispose();
return(dataTable1);
}
}
}
return(dataTable);
}