//static DBCenter() //{ // //需要在非web应用上使用,避免报错影响初始化 // try // { // //根据类型,初始化不同的辅助类,和读取连接字符串 // string dbtype = ConfigurationManager.AppSettings["DBType"]; // if (string.IsNullOrEmpty(dbtype)) { dbtype = "mssql"; } // DB = SqlBase.CreateHelper(dbtype); // switch (dbtype)//为多数据库读取 // { // case "oracle": // DB.ConnectionString = ConfigurationManager.ConnectionStrings["OraConnection String"].ConnectionString; // break; // default: // DB.ConnectionString = ConfigurationManager.ConnectionStrings["Connection String"].ConnectionString; // break; // } // } // catch { } //} #region 兼容区 /// <summary> /// 依据ID和主键删除 /// </summary> public static bool Del(string tbname, string pk, int id) { SqlModel model = new SqlModel() { cmd = SqlCmd.Delete, tbName = tbname, }; model.where = "" + pk + "=" + id; DB.ExecuteNonQuery(model); return(true); }
private void btn_ok_Click(object sender, EventArgs e) { string tabName = ""; string sqlStr = ""; if (string.IsNullOrEmpty(this.txt_tableName.Text)) { //同步所有的zdzdbiao sqlStr = $" select name from sysobjects where xtype='u' and name like 'ZDZD_%'"; } else { //指定的表 tabName = this.txt_tableName.Text; sqlStr = $" select name from sysobjects where xtype='u' and name = 'ZDZD_{tabName}'"; } //ZDZD_ZX SqlBase _sqlBase = new SqlBase(ESqlConnType.ConnectionStringJCJT); SqlBase _DebugTool = new SqlBase(ESqlConnType.ConnectionStringDebugTool); SqlBase ngJCJG = new SqlBase(ESqlConnType.ConnectionStringJCJG); //string sqlStr = string.Format($"SELECT 表名 = D.name,字段序号 = A.colorder,字段名 = A.name,字段说明 = isnull(G.[value], ''),类型 = B.name,占用字节数 = A.Length " + // $"FROM syscolumns A Left Join systypes B On A.xusertype = B.xusertype Inner Join sysobjects D On A.id = D.id and D.xtype = 'U' and D.name <> 'dtproperties'" + // $" Left Join syscomments E on A.cdefault = E.id Left Join sys.extended_properties G on A.id = G.major_id and A.colid = G.minor_id Left Join sys.extended_properties F On D.id = F.major_id and F.minor_id = 0 " + // $"where d.name = '{tabName}' " // + wheresql + // $" Order By A.id, A.colorder"); var dtTableName = _sqlBase.ExecuteDataset(sqlStr); if (dtTableName.Tables.Count == 0) { return; } var dt = dtTableName.Tables[0]; var sql = ""; var syxmbh = ""; DataSet ds = null; foreach (DataRow item in dt.Rows) { syxmbh = item["name"].ToString().ToUpper().Replace("ZDZD_", ""); ds = _DebugTool.ExecuteDataset($" select name from sysobjects where xtype='u' and name = 'ZDZD_{syxmbh}'"); if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { //如果已经同步过,则执行下一个 //MessageBox.Show($"项目{syxmbh}已经同步"); continue; } sql = $"select * into ZDZD_{syxmbh} from jcjt_wh.dbo.ZDZD_{syxmbh} where sjbmc like 'S_{syxmbh}' or sjbmc like 'M_{syxmbh}'"; //sql = $"select * into ZDZD_{syxmbh} from ITSV.jcjt_wh.dbo.ZDZD_{syxmbh} where sjbmc like 'S_{syxmbh}' or sjbmc like 'M_{syxmbh}'"; //sql = $"alter table zdzd_{syxmbh} drop column sj_zs"; try { _sqlBase.ExecuteNonQuery(sql); } catch { } } //select* from ITSV.jcjt_wh.dbo.ZDZD_ZX where sjbmc like 'S_%' or sjbmc like 'M_%' }