/// <summary>
/// 增加排序条件
/// </summary>
/// <param name="sortField">排序字段</param>
public SearchCondition AddSort(string sortField, SortDir dir)
{
sortField = sortField.ToLower().Trim();
if (_sortSql.Trim() == "")
{
_sortSql = string.Format("{0} {1}", sortField, dir);
}
else
{
if (_sortSql.IndexOf(sortField) >= 0)
{
string[] strAry = _sortSql.Split(new char[] { ',' }, StringSplitOptions.None);
for (int i = 0; i < strAry.Length; i++)
{
if (strAry[i].IndexOf(sortField) >= 0)
{
strAry[i] = string.Format("{0} {1}", sortField, dir.ToString());
break;
}
}
_sortSql = string.Join(",", strAry);
}
else
{
_sortSql = string.Format("{0},{1} {2}", _sortSql, sortField, dir.ToString());
}
}
return(this);
}
private SqlParameter CreateSortDirParameter(SortDir sortDir)
{
return(new SqlParameter("@sortDir", sortDir.ToString())
{
SqlDbType = SqlDbType.NVarChar
});
}
