/// <summary>
/// 删除优惠卡类型
/// </summary>
/// <param name="sysNo">优惠卡类型编号</param>
/// <returns></returns>
/// <remarks>2014-01-09 朱成果 创建</remarks>
public void DeleteCouponCardType(int sysNo)
{
ParaCouponCard filter = new ParaCouponCard();
filter.CardTypeSysNo = sysNo;
filter.Id = 1;
filter.PageSize = 1;
var lst = ISpCouponCardDao.Instance.GetCouponCard(filter);
if (lst.TotalRows > 0)
{
throw new Exception("当前优惠卡类型已经在使用");
}
else
{
Hyt.DataAccess.Promotion.ISpCouponCardAssociateDao.Instance.DeleteByCardTypeSysNo(sysNo);
Hyt.DataAccess.Promotion.ISpCouponCardTypeDao.Instance.Delete(sysNo);
}
}
/// <summary>
/// 分页获取优惠券卡号
/// </summary>
/// <param name="filter">筛选条件</param>
/// <returns>分页列表</returns>
/// <remarks>
/// 2014-01-08 余勇 创建
/// </remarks>
public override Pager <CBSpCouponCard> GetCouponCard(ParaCouponCard filter)
{
var sql =
@"SpCouponCard a
left join SpCouponCardType b on a.CardTypeSysNo = b.SysNo
where {0} ";
#region 构造sql
var paras = new ArrayList();
var where = "1=1 ";
int i = 0;
if (filter.CardTypeSysNo != null)
{
//优惠券类型
where += " and a.CardTypeSysNo=@p0p" + i;
paras.Add(filter.CardTypeSysNo);
i++;
}
if (!string.IsNullOrEmpty(filter.StartCardNo) && !string.IsNullOrEmpty(filter.EndCardNo))
{
//起始卡号和结束卡号都不为空
where += " and a.CouponCardNo >= @p0p" + i;
i++;
where += " and a.CouponCardNo <= @p0p" + i;
i++;
paras.Add(filter.StartCardNo);
paras.Add(filter.EndCardNo);
}
else if (!string.IsNullOrEmpty(filter.StartCardNo))
{
where += " and a.CouponCardNo = @p0p" + i;
paras.Add(filter.StartCardNo);
i++;
}
else if (!string.IsNullOrEmpty(filter.EndCardNo))
{
where += " and a.CouponCardNo = @p0p" + i;
paras.Add(filter.EndCardNo);
i++;
}
sql = string.Format(sql, where);
#endregion
var dataList =
Context.Select <CBSpCouponCard>(
@"a.SysNo, a.CouponCardNo, a.ActivationTime, a.TerminationTime,
a.Status, b.TypeName").From(sql);
var dataCount = Context.Select <int>("count(0)").From(sql);
dataList.Parameters(paras);
dataCount.Parameters(paras);
var pager = new Pager <CBSpCouponCard>
{
CurrentPage = filter.Id.Value,
PageSize = filter.PageSize
};
var totalRows = dataCount.QuerySingle();
var rows = dataList.OrderBy("a.SysNo desc").Paging(pager.CurrentPage, pager.PageSize).QueryMany();
pager.TotalRows = totalRows;
pager.Rows = rows;
return(pager);
}
/// <summary>
/// 分页获取优惠券卡号
/// </summary>
/// <param name="filter">筛选条件</param>
/// <returns>分页列表</returns>
/// <remarks>2014-01-08 余勇 创建</remarks>
public Pager <CBSpCouponCard> DoCouponCardQuery(ParaCouponCard filter)
{
return(DataAccess.Promotion.ISpCouponCardDao.Instance.GetCouponCard(filter));
}
/// <summary> /// 分页获取优惠券卡号 /// </summary> /// <param name="filter">筛选条件</param> /// <returns>分页列表</returns> /// <remarks>2014-01-08 余勇 创建</remarks> public abstract Pager <CBSpCouponCard> GetCouponCard(ParaCouponCard filter);
