// AsFieldAndParameter internal static string AsFieldAndParameter(this QueryField queryField) { if (queryField.Operation == Operation.Equal && queryField.Parameter.Value == null) { return($"{queryField.AsField()} IS NULL"); } else if (queryField.Operation == Operation.NotEqual && queryField.Parameter.Value == null) { return($"{queryField.AsField()} IS NOT NULL"); } else { var operationText = queryField.GetOperationText(); if (queryField.Operation == Operation.Between || queryField.Operation == Operation.NotBetween) { return($"{queryField.AsField()} {operationText} {queryField.AsBetweenParameter()}"); } else if (queryField.Operation == Operation.In || queryField.Operation == Operation.NotIn) { return($"{queryField.AsField()} {operationText} {queryField.AsInParameter()}"); } else { return($"{queryField.AsField()} {operationText} {queryField.AsParameter()}"); } } }
// AsFieldAndParameter internal static string AsFieldAndParameter(this QueryField queryField, int index = 0) { if (queryField.Operation == Operation.Equal && queryField.Parameter.Value == null) { return(string.Concat(queryField.AsField(), " IS NULL")); } else if (queryField.Operation == Operation.NotEqual && queryField.Parameter.Value == null) { return(string.Concat(queryField.AsField(), " IS NOT NULL")); } else { if (queryField.Operation == Operation.Between || queryField.Operation == Operation.NotBetween) { return(string.Concat(queryField.AsField(), " ", queryField.GetOperationText(), " ", queryField.AsBetweenParameter(index))); } else if (queryField.Operation == Operation.In || queryField.Operation == Operation.NotIn) { return(string.Concat(queryField.AsField(), " ", queryField.GetOperationText(), " ", queryField.AsInParameter(index))); } else { return(string.Concat(queryField.AsField(), " ", queryField.GetOperationText(), " ", queryField.AsParameter(index))); } } }
// AsParameterAsField internal static string AsParameterAsField(this QueryField queryField, int index, IDbSetting dbSetting) { return(string.Concat(queryField.AsParameter(index, dbSetting), " AS ", queryField.AsField(dbSetting))); }
/// <summary> /// /// </summary> /// <param name="queryField"></param> /// <param name="index"></param> /// <param name="dbSetting"></param> /// <returns></returns> internal static string AsFieldAndParameter(this QueryField queryField, int index, IDbSetting dbSetting) { if (queryField.Operation == Operation.Equal && queryField.Parameter.Value == null) { return(string.Concat(queryField.AsField(dbSetting), " IS NULL")); } else if (queryField.Operation == Operation.NotEqual && queryField.Parameter.Value == null) { return(string.Concat(queryField.AsField(dbSetting), " IS NOT NULL")); } else if (queryField.Operation == Operation.Between || queryField.Operation == Operation.NotBetween) { return(AsFieldAndParameterForBetween(queryField, index, dbSetting)); } else if (queryField.Operation == Operation.In || queryField.Operation == Operation.NotIn) { return(AsFieldAndParameterForIn(queryField, index, dbSetting)); } else { return(string.Concat(queryField.AsField(dbSetting), " ", queryField.Operation.GetText(), " ", queryField.AsParameter(index, dbSetting))); } }