/// <summary>
///
/// </summary>
/// <param name="paras"></param>
/// <param name="isInnerOrder">内部的排序用相反排序，外部正常排序</param>
/// <returns></returns>
protected virtual string ProcessOrderBy(Dictionary <string, object> paras, int layer, string defaultSort)
{
string sql = defaultSort;
string sortField = DataConvert.ToString(paras["sortField"]);
string sortType = DataConvert.ToString(paras["sortType"]);
if (sortField != "")
{
if (SafeSql.ProcessSqlStr(sortField, 0) && SafeSql.ProcessSqlStr(sortType, 0))
{
if (layer == 2)
{
if (sortType == "asc")
{
sql = string.Format(" order by {0} desc ", sortField);
}
else
{
sql = string.Format(" order by {0} ", sortField);
}
}
else
{
sql = string.Format(" order by {0} {1} ", sortField, sortType);
}
}
}
return(sql);
}
/// <summary>
///
/// </summary>
/// <param name="paras"></param>
/// <param name="isInnerOrder">内部的排序用相反排序，外部正常排序</param>
/// <returns></returns>
private string OrderBy(ListCondition condition, int layer, string defaultSort)
{
string sql = defaultSort;
string sortField = condition.SortField;
string sortType = condition.SortType;
if (sortField != "")
{
if (SafeSql.ProcessSqlStr(sortField, 0) && SafeSql.ProcessSqlStr(sortType, 0))
{
if (layer == 2)
{
if (sortType == "asc")
{
sql = string.Format(" order by {0} desc ", sortField);
}
else
{
sql = string.Format(" order by {0} ", sortField);
}
}
else
{
sql = string.Format(" order by {0} {1} ", sortField, sortType);
}
}
}
return(sql);
}
