public override string FormatField(ConListField field)
{
switch (field.Adorn)
{
case Adorns.Average:
return(String.Format("AVE(`{0}`) AS `{1}`", field.FieldName, field.AliasName));
case Adorns.Distinct:
return(String.Format("DISTINCT(`{0}`) AS `{1}`", field.FieldName, field.AliasName));
case Adorns.Maximum:
return(String.Format("MAX(`{0}`) AS `{1}`", field.FieldName, field.AliasName));
case Adorns.Minimum:
return(String.Format("MIN(`{0}`) AS `{1}`", field.FieldName, field.AliasName));
case Adorns.None:
if (field.FieldName == field.AliasName)
{
return(String.Format("`{0}`", field.FieldName));
}
else
{
return(String.Format("`{0}` AS `{1}`", field.FieldName, field.AliasName));
}
break;
case Adorns.Substring:
return(String.Format("SUBSTR(`{0}`," + (field.Start + 1)
+ "," + field.Length + ") AS `{1}`", field.FieldName, field.AliasName));
break;
case Adorns.Sum:
return(String.Format("SUM(`{0}`) AS `{1}`", field.FieldName, field.AliasName));
break;
case Adorns.Total:
default:
return(String.Format("TOTAL(`{0}`) AS `{1}`", field.FieldName, field.AliasName));
}
}
/// <summary> /// 格式化字段名（包括函数）,用于扩展字段类 /// </summary> /// <param name="conListField"></param> /// <returns></returns> public abstract string FormatField(ConListField conListField);