public static void TableAdd(SqlBaseItemXml basemodel, SqlTableItemXml item) { var templist = DBConfig.listtablexmlconfig[basemodel.Number]; templist.SqlTableList.Add(item); DBConfig.listtablexmlconfig[basemodel.Number] = templist; }
public void TableChangeIsUse(SqlTableItemXml item, bool isuse = false) { var basemodel = DBConfig.GetBaseXmlConfig(item.BaseNumber); DBConfig.TableRemove(basemodel, item); item.IsUse = isuse; DBConfig.TableAdd(basemodel, item); }
public static SqlTableItemXml AddTable(string currentconnstr, SqlServerItemXml item, SqlDatabaseItemXml item2) { var basemodel = DBConfig.GetBaseXmlConfig(item.BaseNumber); SqlTableItemXml tabletempmodel = new SqlTableItemXml(); tabletempmodel.BaseNumber = item.BaseNumber; tabletempmodel.ServerNumber = item.Number; tabletempmodel.DataBaseNumber = item2.Number; tabletempmodel.Number = DBConfig.GetTableNumber; tabletempmodel.TableName = basemodel.TablePrev + tabletempmodel.Number; tabletempmodel.IsWrite = true; tabletempmodel.IsUse = true; tabletempmodel.RowNum = basemodel.DefaultTableRowNum; tabletempmodel.StorageSize = (item2.StorageSize - item2.StorageSize / 5) / item2.TableNum; DBConfig.TableAdd(basemodel, tabletempmodel); DBProxy.GetDBHelper(item.DBType).ExecuteSql(currentconnstr, DBConfig.GetTableSql(basemodel, tabletempmodel.TableName)); return(tabletempmodel); }
public static bool Update(SqlBaseItemXml basemodel, long rowid, SqlServerItemXml servermodel, SqlDatabaseItemXml databasemodel, SqlTableItemXml tablemodel, Dictionary <string, object> updatefieldlist) { bool revalue = false; string connstr = GetConnStr(basemodel, servermodel); string sqlstr = string.Format("update {0}.dbo.{1} set {4} where {2}={3}", databasemodel.DatabaseName, tablemodel.TableName, basemodel.PrimarykeyName, rowid, GetSqlUpdate(basemodel, updatefieldlist)); long temp = CommonHelper.ToLong(DBProxy.GetDBHelper(servermodel.DBType).ExecuteSql(connstr, sqlstr)); if (temp > 0) { revalue = true; } return(revalue); }
public static bool Delete(SqlBaseItemXml basemodel, long rowid, SqlServerItemXml servermodel, SqlDatabaseItemXml databasemodel, SqlTableItemXml tablemodel, SqlFieldItemXml fieldmodel) { bool revalue = false; string connstr = GetConnStr(basemodel, servermodel); string sqlstr = string.Format("delete from {0}.dbo.{1} where {2}={3}", databasemodel.DatabaseName, tablemodel.TableName, basemodel.PrimarykeyName, rowid); long temp = CommonHelper.ToLong(DBProxy.GetDBHelper(servermodel.DBType).ExecuteSql(connstr, sqlstr)); if (temp > 0) { revalue = true; } return(revalue); }