//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 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();//新加的
}
}
}