public bool GetServer(SqlBaseItemXml basemodel)
{
var templist = DBConfig.GetServerXmlConfig(basemodel).SqlServerList.Where(m => m.IsUse == true && m.IsWrite == true).ToList();
foreach (SqlServerItemXml item in templist)
{
long currentStorageSize = 0;
currentserver = item.ServerName;
currentservernumber = item.Number;
currentconnstrserver = DBProxyAction.GetConnStr(basemodel, item);
try
{
currentStorageSize = DBProxy.GetDBAccess(item.DBType).DatabaseStorageSizeAll(currentconnstrserver, basemodel.DatabasePrev);
}
catch (Exception ex)
{
Console.WriteLine("error:" + ex.Message);
new ManagerConfig().ServerChangeIsUse(item);
return(false);
}
if ((item.StorageSize - item.RetainStorageSize) > currentStorageSize)
{
if (GetDatabase(basemodel, item))
{
return(isposition);
}
}
else
{
new ManagerConfig().ServerChangeIsWrite(item);
}
}
return(false);
}
public static SqlServerItemXml GetServerItemXmlConfig(SqlBaseItemXml basemodel, long Number, bool IsUse = true)
{
return(DBConfig.GetServerXmlConfig(basemodel).SqlServerList.Where(m => m.IsUse == IsUse && m.Number == Number).FirstOrDefault());
}
public static List <SqlServerItemXml> GetServerItemXmlConfigList(SqlBaseItemXml basemodel, bool IsUse = true)
{
return(DBConfig.GetServerXmlConfig(basemodel).SqlServerList.Where(m => m.IsUse == IsUse).ToList());
}