public int TableAddIndexServer(object model)
{
int changetablenum = 0;
int changetableindexnum = 0;
var item = model as SqlServerItemXml;
var basemodel = DBConfig.GetBaseXmlConfig(item.BaseNumber);
if (item != null)
{
var databaselist = DBConfig.GetDatabaseItemXmlConfigList(basemodel, item.Number);
foreach (var item2 in databaselist)
{
var tablelist = DBConfig.GetTableItemXmlConfigList(basemodel, item2.Number);
string connstr = DBProxyAction.GetConnStr(basemodel, item);
foreach (var item3 in tablelist)
{
int validnum = 0;
foreach (var itemfield in basemodel.FieldIndexList)
{
string indexname = basemodel.IndexPrev + item3.TableName + itemfield;
if (!DBProxy.GetDBAccess(item.DBType).TableIndexExists(connstr, item2.DatabaseName, item3.TableName, indexname))
{
validnum++;
changetableindexnum++;
DBProxy.GetDBAccess(item.DBType).TableIndexAdd(connstr, item2.DatabaseName, item3.TableName, itemfield, indexname);
Console.WriteLine("添加索引服务器:" + item.ServerName + ",数据库:" + item2.DatabaseName + ",表：" + item3.TableName);
}
}
if (validnum > 0)
{
changetablenum++;
}
}
}
}
Console.WriteLine("服务器:" + item.ServerName + ",涉及表总数:" + changetablenum + ",添加索引总数:" + changetableindexnum);
return(1);
}
