private MatchServerList GetMatchObject(SqlFieldItemXml item)
{
MatchServerList temp = new MatchServerList();
temp.ServerNumber = item.ServerNumber;
temp.DatabaseNumber = item.DatabaseNumber;
temp.TableNumber = item.TableNumber;
return(temp);
}
public static string GetSqlCount(SqlServerItemXml servermodel, MatchServerList item, ConditionFieldModel conditionfield)
{
return(string.Format(@"select COUNT(0) from {0}.dbo.{1} where {2}", item.DatabaseNumber, item.TableNumber, GetSqlWhere(servermodel, conditionfield)));
}
public static string GetSqlList(SqlServerItemXml servermodel, MatchServerList item, ConditionFieldModel conditionfield, long getmaxnum = 500)
{
return(string.Format(@"select top {3} * from {0}.dbo.{1} where {2} ", item.DatabaseNumber, item.TableNumber, GetSqlWhere(servermodel, conditionfield), getmaxnum));
}
