public static DataSet getDataSet(string[] inSelectSQL, string inConString)
{
OleDbConnection connection1 = new OleDbConnection(inConString);
DataSet set1 = new DataSet();
EmedDB.SQLRowIndex = 0;
try
{
connection1.Open();
for (int num1 = 0; num1 < inSelectSQL.Length; num1++)
{
EmedDB.SQLRowIndex = num1;
new OleDbDataAdapter(inSelectSQL[num1], connection1).Fill(set1, "uncnet" + num1.ToString());
}
connection1.Close();
}
catch (Exception exception1)
{
EmedDB.SaveErrorToLog(exception1.Message, inSelectSQL[EmedDB.SQLRowIndex]);
}
finally
{
connection1.Dispose();
OleDbConnection.ReleaseObjectPool();
GC.Collect();
}
return(set1);
}
public static bool TestConnection(string inConntionString)
{
bool flag1;
OleDbConnection connection1 = new OleDbConnection(inConntionString);
try
{
connection1.Open();
if (connection1.State == ConnectionState.Open)
{
connection1.Close();
OleDbConnection.ReleaseObjectPool();
GC.Collect();
return(true);
}
flag1 = false;
}
catch (Exception exception1)
{
EmedDB.SaveErrorToLog(exception1.Message, "TestConnection");
flag1 = false;
}
finally
{
connection1.Dispose();
OleDbConnection.ReleaseObjectPool();
}
return(flag1);
}
public static bool Transaction(string[] inSQL, string inConString)
{
if (inSQL.Length < 1)
{
return(true);
}
bool flag1 = false;
using (OleDbConnection connection1 = new OleDbConnection(inConString))
{
try
{
connection1.Open();
OleDbTransaction transaction1 = connection1.BeginTransaction(IsolationLevel.ReadCommitted);
try
{
for (int num1 = 0; num1 < inSQL.Length; num1++)
{
EmedDB.SQLRowIndex = num1;
EmedDB.DBErrorSQL = inSQL[num1];
if (inSQL[num1].CompareTo("") > 0)
{
OleDbCommand command1 = new OleDbCommand();
command1.Connection = connection1;
command1.CommandText = inSQL[num1];
command1.Transaction = transaction1;
command1.ExecuteNonQuery();
}
}
transaction1.Commit();
flag1 = true;
}
catch (Exception exception1)
{
transaction1.Rollback();
flag1 = false;
EmedDB.SaveErrorToLog(exception1.Message, EmedDB.DBErrorSQL);
}
connection1.Close();
}
catch
{
flag1 = false;
}
finally
{
connection1.Dispose();
OleDbConnection.ReleaseObjectPool();
GC.Collect();
}
}
return(flag1);
}
private static string GetPurchaseCode()
{
string text1 = "select iif( max(mid(purchase_code,10,8)) is null, '00000001', max(mid(purchase_code,10,8)) + 1 ) from gpo_purchase";
string text2 = EmedDB.getScalar(text1);
if ((text2 != null) && (text2 != ""))
{
return(int.Parse(text2).ToString("00000000"));
}
return("00000001");
}
public static string getScalar(string inSelectSQL, string inConString)
{
if (inSelectSQL.CompareTo("") == 0)
{
return(null);
}
string text1 = null;
OleDbConnection connection1 = new OleDbConnection(inConString);
try
{
connection1.Open();
OleDbCommand command1 = new OleDbCommand(inSelectSQL, connection1);
try
{
object obj1 = command1.ExecuteScalar();
if (obj1 == null)
{
text1 = null;
}
else
{
text1 = obj1.ToString();
}
}
catch (Exception exception1)
{
EmedDB.SaveErrorToLog(exception1.Message, inSelectSQL);
text1 = null;
}
finally
{
command1.Dispose();
}
connection1.Close();
}
catch (Exception exception2)
{
EmedDB.SaveErrorToLog(exception2.Message, inSelectSQL);
}
finally
{
connection1.Dispose();
OleDbConnection.ReleaseObjectPool();
GC.Collect();
}
return(text1);
}
/// <summary>
/// 批量执行SQL
/// </summary>
/// <param name="inSQL">源SQL</param>
/// <returns></returns>
public static bool ExcuteSql(string[] inSQL)
{
bool flag1 = true;
OleDbConnection connection1 = new OleDbConnection(EmedDB.connStr);
try
{
connection1.Open();
OleDbCommand command1 = new OleDbCommand();
for (int num1 = 0; num1 < inSQL.Length; num1++)
{
if (inSQL[num1].Trim().CompareTo("") != 0)
{
command1 = new OleDbCommand(inSQL[num1], connection1);
try
{
command1.ExecuteNonQuery();
}
catch (Exception exception1)
{
string text1 = DateTime.Now.ToString() + "\t" + exception1.Message + "\t" + inSQL[num1];
EmedDB.SaveErrorToLog(text1, inSQL[num1]);
flag1 = false;
}
}
}
command1.Dispose();
connection1.Close();
}
catch (Exception exception2)
{
EmedDB.SaveErrorToLog(exception2.Message, "Some sql exectue has error");
flag1 = false;
}
finally
{
connection1.Dispose();
OleDbConnection.ReleaseObjectPool();
GC.Collect();
}
return(flag1);
}
/// <summary>
/// 单条执行SQL
/// </summary>
/// <param name="inSQL"></param>
/// <returns></returns>
public static bool ExcuteSql(string inSQL)
{
bool flag1 = false;
OleDbConnection connection1 = new OleDbConnection(EmedDB.connStr);
try
{
connection1.Open();
OleDbCommand command1 = new OleDbCommand(inSQL, connection1);
try
{
if (command1.ExecuteNonQuery() > -1)
{
flag1 = true;
}
}
catch (Exception exception1)
{
string text1 = DateTime.Now.ToString() + "\t" + exception1.Message + "\t" + inSQL;
EmedDB.SaveErrorToLog(text1, inSQL);
flag1 = false;
}
finally
{
command1.Dispose();
}
connection1.Close();
}
catch (Exception exception2)
{
EmedDB.SaveErrorToLog(exception2.Message, inSQL);
flag1 = false;
}
finally
{
connection1.Dispose();
OleDbConnection.ReleaseObjectPool();
GC.Collect();
}
return(flag1);
}
public static DataSet getDataSet(string inSelectSQL, string inConString)
{
OleDbConnection connection1 = new OleDbConnection(inConString);
DataSet set1 = new DataSet();
try
{
connection1.Open();
new OleDbDataAdapter(inSelectSQL, connection1).Fill(set1, "uncnet");
connection1.Close();
}
catch (Exception exception1)
{
EmedDB.SaveErrorToLog(exception1.Message, inSelectSQL);
}
finally
{
connection1.Dispose();
OleDbConnection.ReleaseObjectPool();
GC.Collect();
}
return(set1);
}
public static bool TestConnection()
{
return(EmedDB.TestConnection(EmedDB.connStr));
}
