/// <summary>
/// 获取优惠券
/// </summary>
/// <param name="openid"></param>
/// <returns></returns>
public MEMBER_COUPON GetCoupon(string account_id)
{
MEMBER_COUPON coupon = new MEMBER_COUPON();
dt_Dyn_PosCpSearch_req reqs = new dt_Dyn_PosCpSearch_req();
reqs.ACCOUNT_ID = account_id; //会员账号和MOB_NUMBER至少输入一个
reqs.DATA_SOURCE = "0000"; //0002为 佰草集
reqs.LOYALTY_BRAND = AppConfig.LOYALTY_BRAND; //忠诚度品牌
reqs.SOURCE_SYSTEM = AppConfig.SOURCE_SYSTEM; //来源系统
reqs.VGROUP = AppConfig.VGROUP; //销售组织
dt_Dyn_PosCpSearch_res resok = WebApiHelp.PosCpSearch(reqs);
//已使用
List <COUPONS> shiyong = new List <COUPONS>();
//未使用
List <COUPONS> meiyou = new List <COUPONS>();
//已过期
List <COUPONS> guoqi = new List <COUPONS>();
if (resok != null)
{
if (resok.ZTYPE != "Y")
{
return(null);
}
if (resok.ZPARTERN_CP2.Count() > 0)
{
foreach (ZPARTERN_CP2 item in resok.ZPARTERN_CP2)
{
//查询另外一个集合的数据
dt_Dyn_PosCpSearch_resITEM resout = resok.ZCPQ_RESULT.Where(a => a.ZCP_NUM == item.ZCP_NUM).
ToList().FirstOrDefault();
string QrCode = resout.ZCP_PASSW + ".jpg";
GenerateCode(resout.ZCP_PASSW);
//RULE = {"type":"DJQ","value":"100"} 这个就解析成100元代金券
//RULE = {"type":"ZKQ","value":"5"} 解析成 5者折扣券
string RULE = "";
if (!string.IsNullOrWhiteSpace(resout.RULE))
{
CouponRule CouponRule = JsonHelper.DeserializeObject <CouponRule>(resout.RULE);
if (CouponRule != null)
{
if (CouponRule.type == "DJQ")
{
RULE = CouponRule.value;
}
else if (CouponRule.type == "ZKQ")
{
RULE = CouponRule.value;
}
}
}
COUPONS one = new COUPONS()
{
BPEXT = item.BPEXT,
ZCP_EDATE = resout.ZCP_EDATE,
ZCP_EDATE_EX = resout.ZCP_EDATE,
ZCP_JE = resout.ZCP_JE,
ZCP_POINT = resout.ZCP_POINT,
ZCP_PROD = resout.ZCP_PROD,
ZCP_TYPE = item.ZCP_TYPE,
ZCP_YHQDES = resout.ZCP_YHQDES,
ZCP_ZK = resout.ZCP_ZK,
ZCP_NUM = resout.ZCP_NUM,
ZCP_YHQ = resout.ZCP_YHQ,
ZCP_BDATE = resout.ZCP_BDATE,
ZCP_PASSW = resout.ZCP_PASSW,
IS_BOOK = 0,
QrCode = AppConfig.HmjWebApi_https + "/QrCode/" + QrCode,
CONTENT = resout.CONTENT,
RULE = RULE,
ZCP_USE_FLAG = item.ZCP_USE_FLAG
};
one.ZCPUDATE = item.ZCPUDATE;
//已使用
if (item.ZCP_USE_FLAG == "X")
{
shiyong.Add(one);
}
//未使用
if (string.IsNullOrEmpty(item.ZCP_USE_FLAG) || item.ZCP_USE_FLAG == "N") //item.ZCP_USE_FLAG="N" 未使用未激活
{
DateTime endTime = one.ZCP_EDATE;
if (endTime >= DateTime.Parse(DateTime.Now.ToShortDateString()))
{
//BCJ_BOOK_EX book = _book.GetBookByNo(one.ZCP_NUM);
//if (book != null)
//{
// if (book.STATUS == 1)
// {
// shiyong.Add(one);
// }
// else if (book.STATUS == 0)
// {
// one.IS_BOOK = 1;
// meiyou.Add(one);
// }
//}
//else
//{
// meiyou.Add(one);
//}
meiyou.Add(one);
}
else
{
guoqi.Add(one);
}
}
}
}
}
coupon.ALREADY_USE = shiyong.OrderByDescending(a => a.ZCPUDATE).ToList();
coupon.NOT_USE = meiyou.OrderBy(a => a.ZCP_EDATE_EX).ToList();
coupon.OBSOLETE = guoqi.OrderByDescending(a => a.ZCP_EDATE_EX).ToList();
return(coupon);
}
/// <summary>
/// 获取优惠券
/// </summary>
/// <param name="openid"></param>
/// <returns></returns>
public MEMBER_COUPON GetCoupon(string openid)
{
MEMBER_COUPON coupon = new MEMBER_COUPON();
//查询会员主数据信息
CUST_MEMBER member = _repo.GetMemberByOpenId(openid);
dt_Dyn_PosCpSearch_req reqs = new dt_Dyn_PosCpSearch_req();
reqs.ACCOUNT_ID = member.MEMBERNO;//会员账号和MOB_NUMBER至少输入一个
reqs.DATA_SOURCE = "0002";
reqs.LOYALTY_BRAND = AppConfig.LOYALTY_BRAND; //忠诚度品牌
reqs.SOURCE_SYSTEM = AppConfig.SOURCE_SYSTEM; //来源系统
reqs.VGROUP = AppConfig.VGROUP; //销售组织
dt_Dyn_PosCpSearch_res resok = WebApiHelp.PosCpSearch(reqs);
if (resok.ZTYPE != "Y")
{
return(null);
}
//已使用
List <COUPONS> shiyong = new List <COUPONS>();
//未使用
List <COUPONS> meiyou = new List <COUPONS>();
//已过期
List <COUPONS> guoqi = new List <COUPONS>();
if (resok.ZPARTERN_CP2.Count() > 0)
{
foreach (ZPARTERN_CP2 item in resok.ZPARTERN_CP2)
{
//查询另外一个集合的数据
dt_Dyn_PosCpSearch_resITEM resout = resok.ZCPQ_RESULT.Where(a => a.ZCP_NUM == item.ZCP_NUM).
ToList().FirstOrDefault();
COUPONS one = new COUPONS()
{
BPEXT = item.BPEXT,
ZCP_EDATE = resout.ZCP_EDATE,
ZCP_EDATE_EX = resout.ZCP_EDATE,
ZCP_JE = resout.ZCP_JE,
ZCP_POINT = resout.ZCP_POINT,
ZCP_PROD = resout.ZCP_PROD,
ZCP_TYPE = item.ZCP_TYPE,
ZCP_YHQDES = resout.ZCP_YHQDES,
ZCP_ZK = resout.ZCP_ZK,
ZCP_NUM = resout.ZCP_NUM,
ZCP_YHQ = resout.ZCP_YHQ,
ZCP_BDATE = resout.ZCP_BDATE,
ZCP_PASSW = resout.ZCP_PASSW,
IS_BOOK = 0
};
one.ZCPUDATE = item.ZCPUDATE;
//已使用
if (item.ZCP_USE_FLAG == "X")
{
shiyong.Add(one);
}
//未使用
if (string.IsNullOrEmpty(item.ZCP_USE_FLAG))
{
DateTime endTime = one.ZCP_EDATE;
if (endTime > DateTime.Now)
{
HMJ_BOOK_EX book = _book.GetBookByNo(one.ZCP_NUM);
if (book != null)
{
if (book.STATUS == 1)
{
shiyong.Add(one);
}
else if (book.STATUS == 0)
{
one.IS_BOOK = 1;
meiyou.Add(one);
}
}
else
{
meiyou.Add(one);
}
}
else
{
guoqi.Add(one);
}
}
}
}
coupon.ALREADY_USE = shiyong.OrderByDescending(a => a.ZCPUDATE).ToList();
coupon.NOT_USE = meiyou.OrderBy(a => a.ZCP_EDATE_EX).ToList();
coupon.OBSOLETE = guoqi.OrderByDescending(a => a.ZCP_EDATE_EX).ToList();
return(coupon);
}