internal void AppendStatusCriteria(StringBuilder cmdText, RecordStatusEnum status = RecordStatusEnum.All) { if (status == RecordStatusEnum.All) { return; //nothing to do } //add missing where clause if (!cmdText.ToString().ToLowerInvariant().Contains("where")) { cmdText.Append(" WHERE "); } if (status == RecordStatusEnum.Active) { cmdText.Append($" {Config.ISACTIVE_COLUMN.Name}={BITTRUEVALUE}"); } else if (status == RecordStatusEnum.InActive) { cmdText.Append($" {Config.ISACTIVE_COLUMN.Name}={BITFALSEVALUE}"); } }
public static string GetRecordStatusName(RecordStatusEnum e) { string a = ""; switch (e) { case RecordStatusEnum.Ongoing: a = "进行中"; break; case RecordStatusEnum.Complete: a = "完成"; break; } return a; }