private string GetDataType(OrderCriterion orderCriterion)
{
if (orderCriterion.DataType == typeof(string))
{
if (orderCriterion.Length > 0 && orderCriterion.Length < 4000)
{
return(string.Format("NVARCHAR({0})", orderCriterion.Length));
}
else
{
return("NVARCHAR(max)");
}
}
else if (orderCriterion.DataType == typeof(DateTime))
{
return("DATETIME");
}
else if (orderCriterion.DataType == typeof(Guid))
{
return("UNIQUEIDENTIFIER");
}
else if (orderCriterion.DataType == typeof(Int64))
{
return("BIGINT");
}
else if (orderCriterion.DataType == typeof(Int32))
{
return("INTEGER");
}
else if (orderCriterion.DataType == typeof(Int16))
{
return("SMALLINT");
}
else if (orderCriterion.DataType == typeof(Decimal))
{
return("FLOAT");
}
else if (orderCriterion.DataType == typeof(Double))
{
return("FLOAT");
}
else if (orderCriterion.DataType == typeof(Boolean))
{
return("BIT");
}
return("NVARCHAR(max)");
}
public void AddXmlOrder(Type type, Type dataType, Int32 length, string xmlPath, string propertyName, string wtName, string sortOrder)
{
OrderCriterion orderCriterion = new OrderCriterion(type, dataType, length, xmlPath, propertyName, wtName, sortOrder, AggregateFunction.None);
m_OrderCriteriaList.Add(orderCriterion);
}
public void AddOrder(Type type, string propertyName, string sortOrder, AggregateFunction aggregateFunction)
{
OrderCriterion orderCriterion = new OrderCriterion(type, propertyName, sortOrder, aggregateFunction);
m_OrderCriteriaList.Add(orderCriterion);
}
public OrderCriterion(OrderCriterion orderCriterion)
{
m_OriginalPropertyName = orderCriterion.OriginalPropertyName;
Initialize(orderCriterion.Type, orderCriterion.DataType, orderCriterion.Length, orderCriterion.XmlPath, orderCriterion.PropertyInfo, orderCriterion.SortOrder, orderCriterion.AggregateFunction);
}