public static ListItem GetListItem(ECouponStatus type, bool selected)
{
var item = new ListItem(GetText(type), GetValue(type));
if (selected)
{
item.Selected = true;
}
return(item);
}
public static bool Equals(ECouponStatus type, string typeStr)
{
if (string.IsNullOrEmpty(typeStr))
{
return(false);
}
if (string.Equals(GetValue(type).ToLower(), typeStr.ToLower()))
{
return(true);
}
return(false);
}
public void UpdateStatus(ECouponStatus status, List <int> snIdList)
{
string sqlString =
$"UPDATE {TableName} SET {CouponSnAttribute.Status} = '{ECouponStatusUtils.GetValue(status)}' WHERE ID IN ({TranslateUtils.ToSqlInStringWithoutQuote(snIdList)})";
if (status == ECouponStatus.Cash)
{
sqlString =
$"UPDATE {TableName} SET {CouponSnAttribute.Status} = '{ECouponStatusUtils.GetValue(status)}', {CouponSnAttribute.HoldDate} = getdate(), {CouponSnAttribute.CashDate} = getdate() WHERE ID IN ({TranslateUtils.ToSqlInStringWithoutQuote(snIdList)})";
}
else if (status == ECouponStatus.Hold)
{
sqlString =
$"UPDATE {TableName} SET {CouponSnAttribute.Status} = '{ECouponStatusUtils.GetValue(status)}', {CouponSnAttribute.HoldDate} = getdate() WHERE ID IN ({TranslateUtils.ToSqlInStringWithoutQuote(snIdList)})";
}
ExecuteNonQuery(sqlString);
}
public static string GetText(ECouponStatus type)
{
if (type == ECouponStatus.Unused)
{
return("未领取");
}
else if (type == ECouponStatus.Hold)
{
return("已领取");
}
else if (type == ECouponStatus.Cash)
{
return("已使用");
}
else
{
throw new Exception();
}
}
public static string GetValue(ECouponStatus type)
{
if (type == ECouponStatus.Unused)
{
return("Unused");
}
else if (type == ECouponStatus.Hold)
{
return("Hold");
}
else if (type == ECouponStatus.Cash)
{
return("Cash");
}
else
{
throw new Exception();
}
}
public static bool Equals(string typeStr, ECouponStatus type)
{
return(Equals(type, typeStr));
}
