public bool Update(SqlBaseItemXml basemodel, long rowid, Dictionary <string, object> updatefieldlist)
{
var fieldmodel = DBConfig.GetFieldXmlConfig(basemodel).SqlFieldList.Where(m => m.FieldName == basemodel.PrimarykeyName && m.ValueMin <= rowid && m.ValueMax >= rowid).FirstOrDefault();
if (fieldmodel == null)
{
return(false);
}
var servermodel = DBConfig.GetServerItemXmlConfig(basemodel, fieldmodel.ServerNumber);
var databasemodel = DBConfig.GetDatabaseItemXmlConfig(basemodel, fieldmodel.DatabaseNumber);
var tablemodel = DBConfig.GetTableItemXmlConfig(basemodel, fieldmodel.TableNumber);
return(DBProxyAction.Update(basemodel, rowid, servermodel, databasemodel, tablemodel, updatefieldlist));
}
public bool Delete(SqlBaseItemXml basemodel, long rowid)
{
bool revalue = false;
bool changexml = false;
var fieldmodel = DBConfig.GetFieldXmlConfig(basemodel).SqlFieldList.Where(m => m.FieldName == basemodel.PrimarykeyName && m.ValueMin <= rowid && m.ValueMax >= rowid).FirstOrDefault();
if (fieldmodel == null)
{
return(false);
}
var servermodel = DBConfig.GetServerItemXmlConfig(basemodel, fieldmodel.ServerNumber);
var databasemodel = DBConfig.GetDatabaseItemXmlConfig(basemodel, fieldmodel.DatabaseNumber);
var tablemodel = DBConfig.GetTableItemXmlConfig(basemodel, fieldmodel.TableNumber);
revalue = DBProxyAction.Delete(basemodel, rowid, servermodel, databasemodel, tablemodel, fieldmodel);
if (revalue)
{
if (fieldmodel.ValueMin == rowid)
{
DBConfig.FieldRemove(basemodel, fieldmodel);
fieldmodel.ValueMin = rowid + 1;
DBConfig.FieldAdd(basemodel, fieldmodel);
changexml = true;
}
else if (fieldmodel.ValueMax == rowid)
{
DBConfig.FieldRemove(basemodel, fieldmodel);
fieldmodel.ValueMax = rowid - 1;
DBConfig.FieldAdd(basemodel, fieldmodel);
changexml = true;
}
}
if (changexml)
{
new ManagerConfig().SaveConfigField(basemodel);
}
return(revalue);
}