public static long GetAllCount(SqlBaseItemXml basemodel, ref long sqlnum)
{
sqlnum = 0;
long rownum = 0;
List <TaskDataParam> taskdataparam = new List <TaskDataParam>();
var databaselist = DBConfig.GetDatabaseXmlConfig(basemodel).SqlDatabaseList.Where(m => m.IsUse == true).ToList();
foreach (var item in databaselist)
{
var servermodel = DBConfig.GetServerItemXmlConfig(basemodel, item.ServerNumber);
if (servermodel != null)
{
TaskDataParam tempparam = new TaskDataParam();
tempparam.servername = servermodel.ServerName;
tempparam.dbtype = servermodel.DBType;
tempparam.connstr = GetConnStr(basemodel, servermodel, item);
tempparam.sqlstr = "select sum(b.rows) as 记录条数 from sysobjects a,sysindexes b where a.id=b.id and a.xtype='u' and b.indid=1 ";
taskdataparam.Add(tempparam);
}
}
DBTask servicetask = new DBTask();
rownum = servicetask.SyncThreadPoolManagerSum(taskdataparam, 100, false);
sqlnum = servicetask.runnumcurrent;
return(rownum);
}
