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)); }