Пример #1
0
        new protected string GetWhere()
        {
            string command = "";

            if ((WhereFields.Count() > 0) || (BetweenField != null))
            {
                command += $" WHERE ";
                if (BetweenField != null)
                {
                    command += $"{BetweenField.GetName()} {GetNot()} BETWEEN ({Between1.GetValue()} AND {Between2.GetValue()}";
                }
                if (WhereFields.Count() > 0)
                {
                    command += $"{WhereFields.GetFieldOperandValueasStringorNum()}";
                }
            }
            return(command);
        }
Пример #2
0
        new protected string GetWhere()
        {
            string command = "";

            if ((WhereFields.Count() > 0) || (WhereINValues.Count() > 0) || SelectInTable != null)
            {
                command += $" WHERE ";
                if (WhereINValues.Count() > 0)
                {
                    command += $"{WhereInField.GetName()} {GetNot()} IN ({WhereINValues.GetFieldValues()}) ";
                }
                else if (SelectInTable != null)
                {
                    command += $"{WhereInField.GetName()} {GetNot()} IN ({SelectInTable.GetSql()}) ";
                }
                if (WhereFields.Count() > 0)
                {
                    command += $"{WhereFields.GetFieldOperandValueasStringorNum()}";
                }
            }
            return(command);
        }