/// <summary>
/// 查询我的卡券
/// </summary>
/// <param name="pageIndex">页码</param>
/// <param name="pageSize">页数</param>
/// <param name="cardCouponType">卡券类型</param>
/// <param name="where">关键字查询</param>
/// <param name="orderBy">排序</param>
/// <returns></returns>
public List <MyCardCoupons> GetMyCardCoupons(EnumCardCouponType cardCouponType, string userId, int pageIndex, int pageSize, out int totalCount, string where = "", string orderBy = "", string status = "")
{
totalCount = 0;
StringBuilder sbWhere = new StringBuilder();
sbWhere.AppendFormat(" CardCouponType='{0}' And WebSiteOwner='{1}' And UserId='{2}'", CommonPlatform.Helper.EnumStringHelper.ToString(cardCouponType), WebsiteOwner, userId);
//if (!string.IsNullOrEmpty(where))
//{
// sbWhere.AppendFormat("And {0}", where);
//}
switch (status)
{
case "0":
sbWhere.AppendFormat(" And Status=0");
break;
case "1":
sbWhere.AppendFormat(" And Status=1");
break;
case "2":
sbWhere.AppendFormat(" And CardId in (Select CardId from ZCJ_CardCoupons where DateDiff(s,ValidTo,getdate())>0 ) ");
break;
default:
break;
}
totalCount = GetCount <MyCardCoupons>(sbWhere.ToString());
if (!string.IsNullOrEmpty(orderBy))
{
return(GetLit <MyCardCoupons>(pageSize, pageIndex, sbWhere.ToString(), orderBy));
}
return(GetLit <MyCardCoupons>(pageSize, pageIndex, sbWhere.ToString()));
}
/// <summary>
/// 卡券类型
/// </summary>
/// <param name="cardCoupons">主卡券实体</param>
/// <param name="cardCouponType">卡券类型</param>
/// <returns></returns>
public bool AddCardCoupon(CardCoupons cardCoupons, EnumCardCouponType cardCouponType)
{
//if (ExistCardId(cardCoupons.CardId))
//{
// return false;
//}
cardCoupons.CardCouponType = CommonPlatform.Helper.EnumStringHelper.ToString(cardCouponType);
return(Add(cardCoupons));
}
/// <summary>
/// 是否使用了卡券
/// </summary>
/// <param name="cardCouponType">卡券类型</param>
/// <param name="cardId">券编号</param>
/// <param name="userId">用户名</param>
/// <returns></returns>
public bool IsUseCoupon(EnumCardCouponType cardCouponType, int cardId, string userId)
{
int count = GetCount <MyCardCoupons>(string.Format("CardId={0} And CardCouponType='{1}' And UserId='{2}' And Status=1", cardId, CommonPlatform.Helper.EnumStringHelper.ToString(cardCouponType), userId));
if (count > 0)
{
return(true);
}
return(false);
}
/// <summary>
/// 检查卡券是否已经过期
/// </summary>
/// <param name="cardCouponType"></param>
/// <param name="cardId"></param>
/// <returns></returns>
public bool IsCardCouponExpire(EnumCardCouponType cardCouponType, int cardId)
{
CardCoupons model = GetCardCoupon(cardCouponType, cardId);
if (model.ValidTo != null)
{
if ((DateTime)model.ValidTo < DateTime.Now)
{
return(true);
}
}
return(false);
}
/// <summary>
/// 获取 站点下主卡券列表
/// </summary>
/// <param name="cardCouponType">卡券类型</param>
/// <param name="pageIndex">页码</param>
/// <param name="pageSize">页数</param>
/// <param name="where">查询条件</param>
/// <param name="order">排序</param>
/// <returns></returns>
public List <CardCoupons> GetCardCouponList(EnumCardCouponType cardCouponType, int pageIndex, int pageSize, string where = "", string order = "")
{
StringBuilder sbWhere = new StringBuilder();
sbWhere.AppendFormat(" CardCouponType='{0}' And WebSiteOwner='{1}'", CommonPlatform.Helper.EnumStringHelper.ToString(cardCouponType), WebsiteOwner);
if (!string.IsNullOrEmpty(where))
{
sbWhere.AppendFormat("And {0}", where);
}
if (!string.IsNullOrEmpty(order))
{
return(GetLit <CardCoupons>(pageSize, pageIndex, sbWhere.ToString(), order));
}
return(GetLit <CardCoupons>(pageSize, pageIndex, sbWhere.ToString()));
}
/// <summary>
/// 使用我的卡券
/// </summary>
/// <param name="autoId">卡券自动编号（不是卡券号码）</param>
/// <param name="msg">返回消息</param>
/// <returns></returns>
public bool UseMyCardCoupons(EnumCardCouponType cardCouponType, string userId, int autoId, out string msg)
{
msg = "";
MyCardCoupons myCardCoupons = Get <MyCardCoupons>(string.Format("CardCouponType='{0}' And UserId='{1}' And AutoId={2}", CommonPlatform.Helper.EnumStringHelper.ToString(cardCouponType), userId, autoId));
if (myCardCoupons == null)
{
msg = "卡券不存在";
return(false);
}
CardCoupons cardCoupons = GetCardCoupon(CommonPlatform.Helper.EnumStringHelper.ToString(cardCouponType), myCardCoupons.CardId);
if (cardCoupons == null)
{
msg = "卡券不存在";
return(false);
}
if (myCardCoupons.Status == 1)
{
msg = "卡券已使用过了";
return(false);
}
if (cardCoupons.ValidFrom != null)
{
if (DateTime.Now < (DateTime)(cardCoupons.ValidFrom))
{
msg = string.Format("请在{0}后使用", cardCoupons.ValidFrom.ToString());
return(false);
}
}
if (cardCoupons.ValidTo != null)
{
if (DateTime.Now > (DateTime)(cardCoupons.ValidTo))
{
msg = "卡券已过期";
return(false);
}
}
myCardCoupons.Status = 1;
myCardCoupons.UseDate = DateTime.Now;
if (Update(myCardCoupons))
{
msg = "成功使用";
return(true);
}
return(false);
}
/// <summary>
/// 接收门票信息
/// </summary>
/// <param name="cardCouponType">卡券类型</param>
/// <param name="cardId">卡券编号</param>
/// <param name="userId">用户名</param>
/// <param name="msg">提示信息</param>
/// <returns></returns>
public bool ReciveCoupon(EnumCardCouponType cardCouponType, int cardId, string userId, out string msg)
{
msg = "";
if (IsCardCouponExpire(cardCouponType, cardId))
{
msg = "卡券已经过期";
return(false);
}
if (IsReciveCoupon(cardCouponType, cardId, userId))
{
msg = "已经领取过了";
return(false);
}
switch (cardCouponType)
{
case EnumCardCouponType.EntranceTicket:
MyCardCoupons Model = new MyCardCoupons();
Model.CardCouponType = CommonPlatform.Helper.EnumStringHelper.ToString(cardCouponType);
Model.CardCouponNumber = string.Format("No.{0}{1}", DateTime.Now.ToString("yyyyMMdd"), new Random().Next(11111, 99999).ToString());
Model.CardId = cardId;
Model.InsertDate = DateTime.Now;
Model.Status = 0;
Model.UserId = userId;
Model.WebSiteOwner = WebsiteOwner;
if (Add(Model))
{
msg = "领取成功";
return(true);
}
else
{
msg = "领取失败";
return(false);
}
default:
break;
}
return(false);
}
/// <summary>
/// 获取单个主卡券
/// </summary>
/// <param name="cardId">卡券编号</param>
/// <returns></returns>
public CardCoupons GetCardCoupon(EnumCardCouponType cardCouponType, int cardId)
{
return(Get <CardCoupons>(string.Format(" CardId={0} And CardCouponType='{1}'", cardId, CommonPlatform.Helper.EnumStringHelper.ToString(cardCouponType))));
}
