public static void FieldAdd(SqlBaseItemXml basemodel, SqlFieldItemXml item)
{
var templist = DBConfig.listfieldxmlconfig[basemodel.Number];
templist.SqlFieldList.Add(item);
DBConfig.listfieldxmlconfig[basemodel.Number] = templist;
}
private MatchServerList GetMatchObject(SqlFieldItemXml item)
{
MatchServerList temp = new MatchServerList();
temp.ServerNumber = item.ServerNumber;
temp.DatabaseNumber = item.DatabaseNumber;
temp.TableNumber = item.TableNumber;
return(temp);
}
private bool GetMatchValid(SqlFieldItemXml item, long valuemin, long valuemax)
{
bool revalue = false;
if ((item.ValueMin <= valuemin && item.ValueMax >= valuemin) || (item.ValueMin <= valuemax && item.ValueMax >= valuemax) ||
(valuemin <= item.ValueMin && valuemax >= item.ValueMin) || (valuemin <= item.ValueMax && valuemax >= item.ValueMax))
{
revalue = true;
}
return(revalue);
}
public static void AddBulkRow(SqlBaseItemXml basemodel, SqlServerItemXml servermodel, string connstr, DataTable bulkdata, long databasenumber, long tablenumber, List <string> fieldtotal)
{
if (fieldtotal != null && fieldtotal.Count > 0)
{
var fieldlist = DBConfig.GetFieldXmlConfig(basemodel);
foreach (var fieldname in fieldtotal)
{
string currentfieldname = fieldname;
long rowmin = CommonHelper.ToLong(bulkdata.Compute("min(" + currentfieldname + ")", ""));
long rowmax = CommonHelper.ToLong(bulkdata.Compute("max(" + currentfieldname + ")", ""));
var fileldobjecttemp = fieldlist.SqlFieldList.Where(m => m.FieldName == currentfieldname && m.TableNumber == tablenumber).FirstOrDefault();
if (fileldobjecttemp != null)
{
DBConfig.FieldRemove(basemodel, fileldobjecttemp);
if (fileldobjecttemp.ValueMin > rowmin)
{
fileldobjecttemp.ValueMin = rowmin;
}
if (fileldobjecttemp.ValueMax < rowmax)
{
fileldobjecttemp.ValueMax = rowmax;
}
DBConfig.FieldAdd(basemodel, fileldobjecttemp);
}
else
{
SqlFieldItemXml fileldmodel = new SqlFieldItemXml();
fileldmodel.BaseNumber = servermodel.BaseNumber;
fileldmodel.ServerNumber = servermodel.Number;
fileldmodel.DatabaseNumber = databasenumber;
fileldmodel.TableNumber = tablenumber;
fileldmodel.Number = DBConfig.GetFieldNumber;
fileldmodel.FieldName = currentfieldname;
fileldmodel.ValueMin = rowmin;
fileldmodel.ValueMax = rowmax;
DBConfig.FieldAdd(basemodel, fileldmodel);
}
}
}
DBProxy.GetDBHelper(servermodel.DBType).WriteBlockDataToDB(connstr, bulkdata);
}
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);
}
