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);
}
