//public OleDbDataReader GetData(string tablename, string select_sql)
//{
// MyDbHelper DbHelper = new MyDbHelper(MyDbHelper.connectstring_prec);
// OleDbDataReader dr;
// dr= DbHelper.ExecuteDataReader(select_sql);
// return dr;
//}
private void CreateTable(string create_sql, string table_date)
{
try
{
MyDbHelper DbHelper = new MyDbHelper(MyDbHelper.connectstring_cardqs_bftb);
int i = Convert.ToInt32(DbHelper.ExecuteScalar("select count(*) from user_tables where upper(table_name)=upper('" + table_date + "')"));
if (i == 1)
{
DbHelper.ExecuteNonQuery("drop table " + table_date);
}
int ret = DbHelper.ExecuteNonQuery(create_sql);
}
catch (Exception ex)
{
MyLog.DbLog(table_date, "CreateTable 发生异常：" + ex.Message);
MyLog.Log("3", "CreateTable 发生异常：" + ex.Message);
}
finally
{
if (DbHelper != null)
{
DbHelper.Dispose();//新加的
}
}
}
public static void DbLog(string table, string erreason)
{
string sql; //DateTime.Now.ToString("YYYYmmddHHMMSS.FFF");
sql = "insert into LOG_bf(ERRDATETIME,ERRREASON,relatetable) values('";
sql += DateTime.Now.ToString("yyyyMMddHHmmss.FFF") + "','";
sql += erreason + "','";
sql += table + "')";
try
{
MyDbHelper DbHelper = new MyDbHelper(MyDbHelper.connectstring_cardqs);
DbHelper.ExecuteNonQuery(sql);
}
catch (Exception ex)
{
Log("3", "连接数据库插入日志异常：" + ex.Message);
//MessageBox.Show(ex.Message);
}
}
private void InsertData(string insert_num, string insert_sql, string tablename, string select_sql, string db_connectstring)
{
OleDbConnection con = new OleDbConnection(db_connectstring);
con.Open();
OleDbCommand comm = new OleDbCommand(select_sql, con);
OleDbDataReader dbReader = comm.ExecuteReader();
//dbReader = GetData(tablename, select_sql);
string comText;
try
{
MyDbHelper DbHelper = new MyDbHelper(MyDbHelper.connectstring_cardqs_bftb);
while (dbReader.Read())
{
comText = insert_sql;
for (int i = 0; i < int.Parse(insert_num) - 1; i++)
{
comText = comText + "'" + Convert.ToString(dbReader.GetValue(i)).Replace("'", "''") + "',";
}
comText = comText + "'" + Convert.ToString(dbReader.GetValue(int.Parse(insert_num) - 1)) + "')";
DbHelper.ExecuteNonQuery(comText);
}
}
catch (Exception ex)
{
MyLog.DbLog(tablename, "插入数据发生异常：" + ex.Message);
MyLog.Log("3", "插入" + tablename + "数据发生异常：" + ex.Message);
}
finally
{
if (DbHelper != null)
{
DbHelper.Dispose();//新加的
}
}
comm.Dispose();
con.Close();
}
public void DropTable(string drop_sql, string pre_tablename)
{
try
{
MyDbHelper DbHelper = new MyDbHelper(MyDbHelper.connectstring_cardqs_bftb);
int i = Convert.ToInt32(DbHelper.ExecuteScalar("select count(*) from user_tables where upper(table_name)=upper('" + pre_tablename + "')"));
if (i == 1)
{
DbHelper.ExecuteNonQuery(drop_sql);
}
}
catch (Exception ex)
{
MyLog.DbLog(pre_tablename, "DropTable 发生异常：" + ex.Message);
MyLog.Log("3", "DropTable 发生异常：" + ex.Message);
}
finally
{
if (DbHelper != null)
{
DbHelper.Dispose();//新加的
}
}
}