private void VisitOrderField(LiteOrderField field)
{
switch (field.OrderMethod)
{
case OrderMethod.ASC:
case OrderMethod.DESC:
this.sb.Append(" ");
this.sb.Append(field.TableAlias);
this.sb.Append(".");
this.sb.Append(field.FieldName);
this.sb.Append(" ");
this.sb.Append(field.OrderMethod.ToString());
break;
case OrderMethod.ASC_PY:
this.sb.AppendFormat("nlssort({0}.{1},'NLS_SORT=SCHINESE_PINYIN_M') asc", field.TableAlias, field.FieldName);
break;
case OrderMethod.DESC_PY:
this.sb.AppendFormat("nlssort({0}.{1},'NLS_SORT=SCHINESE_PINYIN_M') desc", field.TableAlias, field.FieldName);
break;
default:
throw new Exception("排序方式无法解析");
}
}
private void VisitOrderField(LiteOrderField field)
{
this.sb.Append(" [");
this.sb.Append(field.TableAlias);
this.sb.Append("].[");
this.sb.Append(field.FieldName);
this.sb.Append("] ");
switch (field.OrderMethod)
{
case OrderMethod.ASC:
case OrderMethod.ASC_PY:
this.sb.Append("asc");
break;
case OrderMethod.DESC:
case OrderMethod.DESC_PY:
this.sb.Append("desc");
break;
default:
throw new Exception("排序方式无法解析");
}
}
