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