GetTestData() public static method

public static GetTestData ( string sSQLQuery ) : DataTable
sSQLQuery string
return System.Data.DataTable
DatabaseUpdate Class Documentation
Exemplo n.º 1
0
        private static bool RunEval(List <SQLUpdateNugget> nugs)
        {
            foreach (var n in nugs)
            {
                DataTable table1      = DatabaseUpdate.GetTestData(n.SQLQuery);
                int       iMatchCount = table1.Rows.Count;

                switch (n.Mode)
                {
                case CompareMode.DNEQ:
                    if (iMatchCount != n.RowCount)
                    {
                        return(true);
                    }
                    break;

                case CompareMode.EQ:
                    if (iMatchCount == n.RowCount)
                    {
                        return(true);
                    }
                    break;

                case CompareMode.LT:
                    if (iMatchCount < n.RowCount)
                    {
                        return(true);
                    }
                    break;

                case CompareMode.GT:
                    if (iMatchCount > n.RowCount)
                    {
                        return(true);
                    }
                    break;

                case CompareMode.LTE:
                    if (iMatchCount <= n.RowCount)
                    {
                        return(true);
                    }
                    break;

                case CompareMode.GTE:
                    if (iMatchCount >= n.RowCount)
                    {
                        return(true);
                    }
                    break;

                default:
                    break;
                }
            }

            return(false);
        }