public string Between(string field, ExpressionType nodeType, ref int parIndex, AddParameHandler addParame, object[] args) { string parName = string.Format("@between{0}", parIndex); addParame(parName, args[0]); parIndex += 1; string parName2 = string.Format("@between{0}", parIndex); addParame(parName2, args[1]); parIndex += 1; if (nodeType == ExpressionType.Equal) { return(dBAdapter.BetweenFormat(field, parName, parName2)); } else { return(dBAdapter.NotBetweenFormat(field, parName, parName2)); } //return string.Format("{0} between {1} and {2}", field, parName, parName2); }
public string Between(CRLExpression.MethodCallObj methodInfo, ref int parIndex, AddParameHandler addParame) { var field = methodInfo.MemberQueryName; var nodeType = methodInfo.ExpressionType; var args = methodInfo.Args; string parName = string.Format("@between{0}", parIndex); var args1 = args[0]; var args2 = args[1]; if (args1 is ExpressionValueObj) { parName = args1.ToString(); } else { addParame(parName, args1); } parIndex += 1; string parName2 = string.Format("@between{0}", parIndex); if (args2 is ExpressionValueObj) { parName2 = args2.ToString(); } else { addParame(parName2, args2); } parIndex += 1; if (nodeType == ExpressionType.Equal) { return(dBAdapter.BetweenFormat(field, parName, parName2)); } else { return(dBAdapter.NotBetweenFormat(field, parName, parName2)); } //return string.Format("{0} between {1} and {2}", field, parName, parName2); }