internal override string CreateSqlString(CommandFactory factory, out DataParameter[] dataParameters)
{
string pn = factory.CreateTempParamName();
DataParameter dataParameter = new DataParameter(pn, _value, null);
List <DataParameter> list = new List <DataParameter> ();
DataParameter[] ps = null;
string functionSql = _function.CreateSqlString(factory, out ps);
list.AddRange(ps);
list.Add(dataParameter);
dataParameters = list.ToArray();
return(factory.CreateSingleParamSql(functionSql, _predicate, _isReverse, dataParameter));
}
internal override string CreateSqlString(CommandFactory factory, out DataParameter[] dataParameters)
{
string queryString = null;
List <DataParameter> list = new List <DataParameter> ();
DataParameter[] ps = null;
string functionSql = _function.CreateSqlString(factory, out ps);
list.AddRange(ps);
DataParameter[] ps2 = null;
queryString = _queryExpression.CreateSqlString(factory, out ps2);
list.AddRange(ps2);
dataParameters = list.ToArray();
return(factory.CreateSubQuerySql(functionSql, _predicate, _queryFieldInfo.FieldName, _queryFieldInfo.TableMapping.TableName, queryString));
}
internal override string CreateSqlString(CommandFactory factory, out DataParameter[] dataParameters)
{
string pn = factory.CreateTempParamName();
string pn1 = factory.CreateTempParamName();
DataParameter fromParam = new DataParameter(pn, _fromValue, null);
DataParameter toParam = new DataParameter(pn1, _toValue, null);
List <DataParameter> list = new List <DataParameter> ();
DataParameter[] ps = null;
string functionSql = _function.CreateSqlString(factory, out ps);
list.AddRange(ps);
list.Add(fromParam);
list.Add(toParam);
dataParameters = list.ToArray();
return(factory.CreateBetweenParamsQuerySql(functionSql, _isNot, fromParam, toParam));
}
internal override string CreateSqlString(CommandFactory factory, out DataParameter[] dataParameters)
{
List <DataParameter> list = new List <DataParameter>();
DataParameter[] ps = null;
string functionSql = _function.CreateSqlString(factory, out ps);
list.AddRange(ps);
foreach (object value in _values)
{
string pn = factory.CreateTempParamName();
list.Add(new DataParameter(pn, value, null));
}
dataParameters = list.ToArray();
return(factory.CreateCollectionParamsQuerySql(functionSql, _predicate, list));
}
internal override string CreateSqlString(CommandFactory factory, out DataParameter[] dataParameters)
{
string functionSql = _function.CreateSqlString(factory, out dataParameters);
return(factory.CreateOrderBySql(functionSql, _orderType));
}
internal override string CreateSqlString(CommandFactory factory, out DataParameter[] dataParameters)
{
string functionSql = _function.CreateSqlString(factory, out dataParameters);
return(factory.CreateNullQuerySql(functionSql, _isNull));
}