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