public bool GetBF_TABLE(string db_name, string db_connectstring, string sql_db) { try { DbHelper = new MyDbHelper(MyDbHelper.connectstring_cardqs); dt = DbHelper.ExecuteDataTable("bf_table", sql_db); if (dt == null) { return(false); } if (dt.Rows.Count <= 0) { _bf_table = null; return(true); } _bf_table = new BF_TABLE[dt.Rows.Count]; for (int i = 0; i < dt.Rows.Count; i++) { _bf_table[i] = new BF_TABLE(); _bf_table[i].tablename = dt.Rows[i][0].ToString().Trim(); _bf_table[i].insert_num = dt.Rows[i][1].ToString().Trim(); _bf_table[i].insert_sql = dt.Rows[i][2].ToString().Trim(); _bf_table[i].select_sql = dt.Rows[i][3].ToString().Trim(); _bf_table[i].create_sql = dt.Rows[i][4].ToString().Trim(); _bf_table[i].drop_sql = dt.Rows[i][5].ToString().Trim(); _bf_table[i].table_date = dt.Rows[i][6].ToString().Trim(); _bf_table[i].pre_tablename = dt.Rows[i][7].ToString().Trim(); _bf_table[i].typeflag = dt.Rows[i][8].ToString().Trim(); DropTable(_bf_table[i].drop_sql, _bf_table[i].pre_tablename);//先删除前一个存在的表或者删除已有数据 if (Convert.ToInt16(_bf_table[i].typeflag) == 2) { CreateTable(_bf_table[i].create_sql, _bf_table[i].table_date); //创建一个新表 } InsertData(_bf_table[i].insert_num, _bf_table[i].insert_sql, _bf_table[i].tablename, _bf_table[i].select_sql, db_connectstring); //查询出数据再插入新表 MyLog.Log("0", DateTime.Now.ToString("yyyyMMdd") + _bf_table[i].tablename + "表备份完成"); } MyLog.Log("0", DateTime.Now.ToString("yyyyMMdd") + db_name + "数据库所有表都备份完成"); } catch (Exception ex) { MyLog.DbLog("bf_table", "GetBF_TABLE 发生异常:" + ex.Message); MyLog.Log("3", "GetBF_TABLE 发生异常:" + ex.Message); return(false); } finally { if (DbHelper != null) { DbHelper.Dispose();//新加的 } } MyLog.Log("0", DateTime.Now.ToString("yyyyMMdd") + "数据库所有表都备份完成"); return(true); }
public void type_flow() { try { bool b; DbHelper = new MyDbHelper(MyDbHelper.connectstring_cardqs); dtable = DbHelper.ExecuteDataTable("bf_dbinform", sql); if (dtable == null) { return; } if (dtable.Rows.Count <= 0) { _bf_dbinform = null; return; } _bf_dbinform = new BF_DBINFORM[dtable.Rows.Count]; for (int i = 0; i < dtable.Rows.Count; i++) { _bf_dbinform[i] = new BF_DBINFORM(); _bf_dbinform[i].db_connectstring = dtable.Rows[i][0].ToString().Trim(); _bf_dbinform[i].dbname = dtable.Rows[i][1].ToString().Trim(); _bf_dbinform[i].dbsql = dtable.Rows[i][2].ToString().Trim(); b = GetBF_TABLE(_bf_dbinform[i].dbname, _bf_dbinform[i].db_connectstring, _bf_dbinform[i].dbsql); } } catch (Exception ex) { MyLog.DbLog("bf_dbinform", "type_flow 发生异常:" + ex.Message); MyLog.Log("3", "type_flow 发生异常:" + ex.Message); return; } finally { if (DbHelper != null) { DbHelper.Dispose();//新加的 } } return; }