/// <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 }); }