/// <summary>
/// 设置排序
/// </summary>
public SimpleQuery OrderBy(string _IOrderColumn)
{
List <string> _OrderInfo = _IOrderColumn.SplitString(",").ToList();
if (_IOrderColumn.IsNotNullOrEmpty())
{
OrderColumn = string.Empty;
OrderDirection = string.Empty;
foreach (string _FKOrderKey in _OrderInfo)
{
string _Col = string.Empty;
string _Dir = string.Empty;
if (_FKOrderKey.SplitString(" ").Length == 2)
{
_Col = _FKOrderKey.SplitString(" ")[0].Trim();
_Dir = _FKOrderKey.SplitString(" ")[1].Trim();
if (_Dir.ToUpper() != "ASC" && _Dir.ToUpper() != "DESC")
{
_Dir = "ASC";
}
}
else if (_FKOrderKey.SplitString(" ").Length == 1 && _FKOrderKey.IndexOf(" ") < 0)
{
_Col = _FKOrderKey.Trim();
_Dir = "ASC";
}
if (_Col.IsNotNullOrEmpty() && _Dir.IsNotNullOrEmpty())
{
OrderColumn += _Col + ",";
OrderDirection += _Dir + ",";
}
}
OrderColumn = OrderColumn.RemoveEndChar(",");
OrderDirection = OrderDirection.RemoveEndChar(",");
}
return(this);
}
