public string DateTimeBetween(string field, 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]);
return(dBAdapter.BetweenFormat(field, parName, parName2));
//return string.Format("{0} between {1} and {2}", field, parName, parName2);
}
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);
}
