/// <summary>
/// 是否可以使用优惠券
/// </summary>
/// <param name="myCoupon"></param>
/// <param name="msg"></param>
/// <returns></returns>
public bool IsCanUseCoupon(MyCardCoupons myCoupon, out string msg)
{
msg = "";
if (myCoupon.Status == 0)
{
CardCoupons cardCoupon = GetCoupon(myCoupon.CardId);
cardCoupon = ConvertExpireTime(cardCoupon);
if (cardCoupon.ValidFrom != null && cardCoupon.ValidTo != null)
{
DateTime dtNow = DateTime.Now;
if (dtNow >= (DateTime)(cardCoupon.ValidFrom) && (dtNow <= (DateTime)(cardCoupon.ValidTo)))
{
return(true);
}
else
{
msg = "优惠券已过期";
}
}
}
else if (myCoupon.Status == 1)
{
msg = "优惠券已经使用";
}
else if (myCoupon.Status == 2)
{
msg = "优惠券已经转赠";
}
return(false);
}
public void SendCardCouponsByCurrUserInfo(UserInfo currUserInfo, string cardId)
{
try
{
BLLWeixin bllWeixin = new BLLWeixin();
BLLWebsiteDomainInfo bllDomain = new BLLWebsiteDomainInfo();
CardCoupons cardCoupon = Get <CardCoupons>(string.Format(" WebsiteOwner='{0}' AND CardId={1} ", currUserInfo.WebsiteOwner, int.Parse(cardId)));
MyCardCoupons model = new MyCardCoupons();
model.CardCouponNumber = GetGUID(BLLJIMP.TransacType.CommAdd);
model.CardCouponType = cardCoupon.CardCouponType;
model.CardId = cardCoupon.CardId;
model.InsertDate = DateTime.Now;
model.UserId = currUserInfo.UserID;
model.WebSiteOwner = currUserInfo.WebsiteOwner;
if (Add(model))
{
string title = "您收到一张优惠券";
string content = string.Format("{0}", cardCoupon.Name);
string redicturl = string.Format("http://{0}/customize/shop/?v=1.0&ngroute=/mycoupons#/mycoupons", bllDomain.GetWebsiteDoMain(currUserInfo.WebsiteOwner));
bllWeixin.SendTemplateMessageNotifyComm(currUserInfo, title, content, redicturl);
}
}
catch (Exception)
{
}
}
/// <summary>
/// 转换卡券生效时间段
/// </summary>
/// <param name="mainCardCoupon">主卡券</param>
/// <param name="myCardCoupon">我的优惠券</param>
/// <returns></returns>
public CardCoupons ConvertExpireTime(CardCoupons mainCardCoupon, MyCardCoupons myCardCoupon = null)
{
try
{
if (myCardCoupon == null)
{
if (mainCardCoupon.ExpireTimeType == "1")
{
mainCardCoupon.ValidFrom = DateTime.Now;
mainCardCoupon.ValidTo = DateTime.Now.AddDays(int.Parse(mainCardCoupon.ExpireDay));
}
return(mainCardCoupon);
}
if (mainCardCoupon.ExpireTimeType == "1" && myCardCoupon != null) //指定天数过期
{
if (!string.IsNullOrEmpty(myCardCoupon.FromUserId)) //转赠的优惠券过期时间跟赠送人的卡券过期时间相同
{
myCardCoupon = GetMyCardCouponMainId(mainCardCoupon.CardId, myCardCoupon.FromUserId); //查找到转赠人的卡券
}
mainCardCoupon.ValidFrom = myCardCoupon.InsertDate;
mainCardCoupon.ValidTo = myCardCoupon.InsertDate.AddDays(int.Parse(mainCardCoupon.ExpireDay));
}
}
catch (Exception)
{
}
return(mainCardCoupon);
}
/// <summary>
/// 添加主卡券
/// </summary>
/// <param name="cardCoupons">主卡券实体</param>
/// <returns></returns>
public bool AddCardCoupon(CardCoupons cardCoupons)
{
cardCoupons.CardId = int.Parse(GetGUID(TransacType.AddCardCoupon));
//if (ExistCardId(cardCoupons.CardId))
//{
// return false;
//}
return(Add(cardCoupons));
}
/// <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>
/// <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="cardCouponId"></param>
/// <param name="userId"></param>
/// <returns></returns>
public bool SendCardCoupon(int cardCouponId, string userId)
{
CardCoupons cardCoupon = GetCardCoupon(cardCouponId);
MyCardCoupons model = new MyCardCoupons();
model.CardCouponNumber = string.Format("No.{0}{1}", DateTime.Now.ToString("yyyyMMdd"), new Random().Next(11111, 99999).ToString() + GetGUID(TransacType.CommAdd));
model.CardCouponType = cardCoupon.CardCouponType;
model.CardId = cardCoupon.CardId;
model.InsertDate = DateTime.Now;
model.UserId = userId;
model.WebSiteOwner = WebsiteOwner;
return(Add(model));
}
/// <summary>
/// 获取我的单个卡券
/// </summary>
/// <param name="context"></param>
/// <returns></returns>
private string getmycoupon(HttpContext context)
{
string CardCouponType = context.Request["cardcoupontype"];
int Id = int.Parse(context.Request["Id"]);
switch (CardCouponType)
{
#region 门票
case "entranceticket": //门票
var SourceData = bllCardCoupon.GetMyCardCoupon(Id, CurrentUserInfo.UserID);
CardCoupons CardCoupon = bllCardCoupon.GetCardCoupon(EnumCardCouponType.EntranceTicket, SourceData.CardId);
MyCardcoupon_EntranceTicket model = new MyCardcoupon_EntranceTicket();
model.card_bigimg = bllCardCoupon.GetImgUrl(CardCoupon.Ex1);
model.card_detail = CardCoupon.Ex2;
if (model.card_detail != null && model.card_detail.Contains("/FileUpload/"))
{
model.card_detail = model.card_detail.Replace("/FileUpload/", string.Format("http://{0}/FileUpload/", context.Request.Url.Host));
}
model.card_logo = bllCardCoupon.GetImgUrl(CardCoupon.Logo);
model.card_name = CardCoupon.Name;
model.card_number = SourceData.CardCouponNumber;
if (CardCoupon.ValidFrom != null)
{
model.card_validfrom = bllCardCoupon.GetTimeStamp((DateTime)CardCoupon.ValidFrom);
}
if (CardCoupon.ValidTo != null)
{
model.card_validto = bllCardCoupon.GetTimeStamp((DateTime)CardCoupon.ValidTo);
}
model.companyname = CardCoupon.Ex3; //公司名称
model.id = SourceData.AutoId;
model.status = SourceData.Status;
if (SourceData.Status == 0)
{
if (bllCardCoupon.IsCardCouponExpire(EnumCardCouponType.EntranceTicket, SourceData.CardId))
{
model.status = 2; //卡券已过期
}
}
return(Common.JSONHelper.ObjectToJson(model));
#endregion
}
return("");
}
/// <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="context"></param>
/// <returns></returns>
private string getcouponinfo(HttpContext context)
{
string cardCouponType = context.Request["cardcoupontype"];
int cardId = int.Parse(context.Request["cardid"]);
switch (cardCouponType)
{
case "entranceticket": //门票
CardCoupons sourceData = bllCardCoupon.GetCardCoupon("EntranceTicket", cardId);
Cardcoupon_EntranceTicket model = new Cardcoupon_EntranceTicket();
model.card_id = sourceData.CardId;
model.card_name = sourceData.Name;
model.card_logo = bllCardCoupon.GetImgUrl(sourceData.Logo);
if (sourceData.ValidFrom != null)
{
model.card_validfrom = bllCardCoupon.GetTimeStamp((DateTime)sourceData.ValidFrom);
}
if (sourceData.ValidTo != null)
{
model.card_validto = bllCardCoupon.GetTimeStamp((DateTime)sourceData.ValidTo);
}
model.card_bigimg = bllCardCoupon.GetImgUrl(sourceData.Ex1); //Ex1 代表门票大图
model.card_detail = sourceData.Ex2; //Ex2 代表门票详情
if (model.card_detail != null && model.card_detail.Contains("/FileUpload/"))
{
model.card_detail = model.card_detail.Replace("/FileUpload/", string.Format("http://{0}/FileUpload/", context.Request.Url.Host));
}
return(Common.JSONHelper.ObjectToJson(model));
default:
break;
}
return("");
}
/// <summary>
/// 卡券转赠
/// </summary>
/// <param name="context"></param>
/// <returns></returns>
private string Give(HttpContext context)
{
string cardcouponId = context.Request["cardcoupon_id"];//我的卡券ID
if (string.IsNullOrEmpty(cardcouponId))
{
apiResp.code = (int)BLLJIMP.Enums.APIErrCode.PrimaryKeyIncomplete;
apiResp.msg = "cardcoupon_id 参数必传";
return(ZentCloud.Common.JSONHelper.ObjectToJson(apiResp));
}
MyCardCoupons fromMyCardCoupon = bllCardCoupon.GetMyCardCoupon(int.Parse(cardcouponId));//要赠送的卡券信息
CardCoupons cardCoupon = bllCardCoupon.GetCardCoupon(fromMyCardCoupon.CardId);
if (fromMyCardCoupon == null)
{
apiResp.code = (int)BLLJIMP.Enums.APIErrCode.PrimaryKeyIncomplete;
apiResp.msg = "卡券不存在";
return(ZentCloud.Common.JSONHelper.ObjectToJson(apiResp));
}
if (fromMyCardCoupon.UserId == currentUserInfo.UserID)
{
apiResp.code = (int)BLLJIMP.Enums.APIErrCode.NoFollow;
apiResp.msg = "不能接收自己的卡券";
return(ZentCloud.Common.JSONHelper.ObjectToJson(apiResp));
}
if (!string.IsNullOrEmpty(fromMyCardCoupon.FromUserId))
{
apiResp.code = (int)BLLJIMP.Enums.APIErrCode.NoFollow;
apiResp.msg = "优惠券不能多次转赠";
return(ZentCloud.Common.JSONHelper.ObjectToJson(apiResp));
}
if (cardCoupon.GetLimitType != null)
{
if (cardCoupon.GetLimitType == "1" && !bllUser.IsDistributionMember(currentUserInfo, true))
{
apiResp.code = (int)BLLJIMP.Enums.APIErrCode.MallGetCardOnlyDistMember;
apiResp.msg = "只有分销员才能领取";
return(ZentCloud.Common.JSONHelper.ObjectToJson(apiResp));
}
if (cardCoupon.GetLimitType == "2" && bllUser.IsDistributionMember(currentUserInfo))
{
apiResp.code = (int)BLLJIMP.Enums.APIErrCode.MallGetCardOnlyNotDistMember;
apiResp.msg = "该券仅新用户（无购买历史）可以领取";
return(ZentCloud.Common.JSONHelper.ObjectToJson(apiResp));
}
}
if (!string.IsNullOrEmpty(cardCoupon.BindChannelUserId))
{
if (string.IsNullOrEmpty(currentUserInfo.DistributionOwner))
{
apiResp.code = (int)BLLJIMP.Enums.APIErrCode.MallGetCardOnlyChannel;
apiResp.msg = "只有指定渠道才能领取";
return(ZentCloud.Common.JSONHelper.ObjectToJson(apiResp));
}
BLLJIMP.BLLDistribution bllDis = new BLLJIMP.BLLDistribution();
string channelUserId = bllDis.GetUserChannel(currentUserInfo);
if (cardCoupon.BindChannelUserId != channelUserId)
{
apiResp.code = (int)BLLJIMP.Enums.APIErrCode.MallGetCardOnlyChannel;
apiResp.msg = "只有指定渠道才能领取";
return(ZentCloud.Common.JSONHelper.ObjectToJson(apiResp));
}
}
string msg = "";
if (!bllCardCoupon.IsCanGiveCoupon(fromMyCardCoupon, out msg))//无法转赠给他人
{
apiResp.msg = msg;
return(ZentCloud.Common.JSONHelper.ObjectToJson(apiResp));
}
ZentCloud.ZCBLLEngine.BLLTransaction tran = new ZCBLLEngine.BLLTransaction();
try
{
MyCardCoupons model = new MyCardCoupons();
model.CardCouponNumber = string.Format("No.{0}{1}", DateTime.Now.ToString("yyyyMMddHHmmss"), bllMall.GetGUID(BLLJIMP.TransacType.CommAdd));
model.CardCouponType = fromMyCardCoupon.CardCouponType;
model.CardId = fromMyCardCoupon.CardId;
model.InsertDate = DateTime.Now;
model.UserId = currentUserInfo.UserID;
model.WebSiteOwner = currentUserInfo.WebsiteOwner;
model.FromUserId = fromMyCardCoupon.UserId;
if (!bllCardCoupon.Add(model))
{
tran.Rollback();
apiResp.msg = "接收失败";
return(ZentCloud.Common.JSONHelper.ObjectToJson(apiResp));
}
fromMyCardCoupon.Status = 2;
fromMyCardCoupon.ToUserId = currentUserInfo.UserID;
if (!bllCardCoupon.Update(fromMyCardCoupon))
{
tran.Rollback();
apiResp.msg = "接收失败";
return(ZentCloud.Common.JSONHelper.ObjectToJson(apiResp));
}
// CardCoupons cardCoupon = bllCardCoupon.GetCardCoupon(fromMyCardCoupon.CardId);
//if (cardCoupon == null)
//{
// tran.Rollback();
// apiResp.msg = "卡券不存在";
// return ZentCloud.Common.JSONHelper.ObjectToJson(apiResp);
//}
UserInfo fromUserInfo = bllUser.GetUserInfo(fromMyCardCoupon.UserId);
if (fromUserInfo == null)
{
tran.Rollback();
apiResp.msg = "赠送用户不存在";
return(ZentCloud.Common.JSONHelper.ObjectToJson(apiResp));
}
bllWeixin.SendTemplateMessageNotifyComm(fromUserInfo, "优惠券转赠通知", string.Format(" {0}已领取你转赠的优惠券{1}", bllUser.GetUserDispalyName(currentUserInfo), cardCoupon.Name));
bllWeixin.SendTemplateMessageNotifyComm(currentUserInfo, "优惠券领取通知", string.Format(" 您已经领取来自{0}转赠的优惠券{1}", bllUser.GetUserDispalyName(fromUserInfo), cardCoupon.Name));
tran.Commit();
#region 分销关系建立
BLLPermission.BLLMenuPermission bllMenuPermission = new BLLPermission.BLLMenuPermission("");
if (bllMenuPermission.CheckUserAndPmsKey(currentUserInfo.WebsiteOwner, BLLPermission.Enums.PermissionSysKey.OnlineDistribution))
{
if (string.IsNullOrWhiteSpace(currentUserInfo.DistributionOwner))
{
WebsiteInfo websiteInfo = bllMall.GetWebsiteInfoModelFromDataBase();
if (websiteInfo.DistributionRelationBuildMallOrder == 1)
{
if (bllUser.IsDistributionMember(fromUserInfo) || (fromUserInfo.UserID == websiteInfo.WebsiteOwner))//上级符合分销员标准
{
BLLJIMP.BLLDistribution bllDis = new BLLJIMP.BLLDistribution();
var setUserDistributionOwnerResult = bllDis.SetUserDistributionOwner(currentUserInfo.UserID, fromUserInfo.UserID, currentUserInfo.WebsiteOwner);
}
}
}
}
#endregion
apiResp.status = true;
apiResp.msg = "ok";
}
catch (Exception ex)
{
apiResp.msg = ex.Message;
return(ZentCloud.Common.JSONHelper.ObjectToJson(apiResp));
}
return(ZentCloud.Common.JSONHelper.ObjectToJson(apiResp));
}
/// <summary>
/// 获取主卡券
/// </summary>
/// <param name="context"></param>
/// <returns></returns>
private string GetMainCardCoupon(HttpContext context)
{
string cardCouponId = context.Request["cardcoupon_id"]; //主卡券ID
string myCardCouponId = context.Request["my_cardcoupon_id"]; //我的卡券ID
if (string.IsNullOrEmpty(cardCouponId))
{
resp.errcode = 1;
resp.errmsg = "cardcoupon_id 参数必传";
return(ZentCloud.Common.JSONHelper.ObjectToJson(resp));
}
CardCoupons cardCoupon = bllCardCoupon.GetCardCoupon(int.Parse(cardCouponId));
if (cardCoupon == null)
{
resp.errcode = 1;
resp.errmsg = "cardcoupon_id 不存在";
return(ZentCloud.Common.JSONHelper.ObjectToJson(resp));
}
cardCoupon = bllCardCoupon.ConvertExpireTime(cardCoupon);
if (!string.IsNullOrEmpty(cardCoupon.BindChannelUserId))
{
if (string.IsNullOrEmpty(currentUserInfo.DistributionOwner))
{
resp.errcode = (int)BLLJIMP.Enums.APIErrCode.MallGetCardOnlyChannel;
resp.errmsg = "只有指定渠道才能领取";
return(ZentCloud.Common.JSONHelper.ObjectToJson(resp));
}
BLLJIMP.BLLDistribution bllDis = new BLLJIMP.BLLDistribution();
string channelUserId = bllDis.GetUserChannel(currentUserInfo);
if (cardCoupon.BindChannelUserId != channelUserId)
{
resp.errcode = (int)BLLJIMP.Enums.APIErrCode.MallGetCardOnlyChannel;
resp.errmsg = "只有指定渠道才能领取";
return(ZentCloud.Common.JSONHelper.ObjectToJson(resp));
}
}
MainCardModel model = new MainCardModel();
model.cardcoupon_id = cardCoupon.CardId;
model.cardcoupon_name = cardCoupon.Name;
model.cardcoupon_type = ConvertCardCouponType(cardCoupon.CardCouponType);
model.valid_from = cardCoupon.ValidFrom.ToString();
model.valid_to = cardCoupon.ValidTo.ToString();
model.img_url = bllMall.GetImgUrl(cardCoupon.Logo);
model.discount = string.IsNullOrEmpty(cardCoupon.Ex1) ? 0 : double.Parse(cardCoupon.Ex1);
model.product_id = string.IsNullOrEmpty(cardCoupon.Ex2) ? 0 : double.Parse(cardCoupon.Ex2);
model.deductible_amount = string.IsNullOrEmpty(cardCoupon.Ex3) ? 0 : double.Parse(cardCoupon.Ex3);
model.freefreight_amount = string.IsNullOrEmpty(cardCoupon.Ex4) ? 0 : double.Parse(cardCoupon.Ex4);
model.buckle_amount = string.IsNullOrEmpty(cardCoupon.Ex5) ? 0 : double.Parse(cardCoupon.Ex5);
model.buckle_sub_amount = string.IsNullOrEmpty(cardCoupon.Ex6) ? 0 : double.Parse(cardCoupon.Ex6);
model.max_count = cardCoupon.MaxCount;
model.send_count = cardCoupon.SendCount;
model.un_send_count = cardCoupon.UnSendCount;
model.is_recivece = bllCardCoupon.IsReciveCoupon(cardCoupon.CardId, currentUserInfo.UserID);
model.valid_to_timestamp = bllCardCoupon.GetTimeStamp((DateTime)cardCoupon.ValidTo);
model.limit_type = cardCoupon.Ex7;
model.product_tags = cardCoupon.Ex8;
model.user_get_limit_type = cardCoupon.GetLimitType;
model.is_can_use_shop = cardCoupon.IsCanUseShop;
model.is_can_use_groupbuy = cardCoupon.IsCanUseGroupbuy;
model.expire_time_type = cardCoupon.ExpireTimeType;
model.expire_day = cardCoupon.ExpireDay;
model.weixin_card_id = cardCoupon.WeixinCardId == null?"":cardCoupon.WeixinCardId;
if (!string.IsNullOrEmpty(myCardCouponId))
{
MyCardCoupons myCardCoupon = bllCardCoupon.GetMyCardCoupon(int.Parse(myCardCouponId));
if (myCardCoupon != null)
{
UserInfo fromUserInfo = bllUser.GetUserInfo(myCardCoupon.UserId);
if (fromUserInfo != null)
{
model.from_user_info = new UserInfoModel();
model.from_user_info.head_img_url = bllUser.GetUserDispalyAvatar(fromUserInfo);
model.from_user_info.nick_name = bllUser.GetUserDispalyName(fromUserInfo);
}
if (!string.IsNullOrEmpty(myCardCoupon.ToUserId))
{
model.is_donation = true;
}
model.cardcoupon_number = myCardCoupon.CardCouponNumber;
}
}
return(ZentCloud.Common.JSONHelper.ObjectToJson(model));
}
/// <summary>
/// 领取卡券
/// </summary>
/// <param name="context"></param>
/// <returns></returns>
private string ReciveCardCoupon(HttpContext context)
{
string cardCouponId = context.Request["cardcoupon_id"];
CardCoupons cardCoupon = bllCardCoupon.GetCardCoupon(int.Parse(cardCouponId));
if (cardCoupon == null)
{
resp.errcode = 1;
resp.errmsg = "cardcoupon_id 不存在";
return(ZentCloud.Common.JSONHelper.ObjectToJson(resp));
}
cardCoupon = bllCardCoupon.ConvertExpireTime(cardCoupon);
var myCardCoupon = bllCardCoupon.GetMyCardCouponMainId(int.Parse(cardCouponId), currentUserInfo.UserID);
if (myCardCoupon != null)
{
resp.errcode = 1;
resp.errmsg = "已经领取过了";
return(ZentCloud.Common.JSONHelper.ObjectToJson(resp));
}
if (DateTime.Now > (DateTime)(cardCoupon.ValidTo))
{
resp.errcode = 2;
resp.errmsg = "卡券已过期";
return(ZentCloud.Common.JSONHelper.ObjectToJson(resp));
}
if (cardCoupon.MaxCount > 0)
{
if (bllCardCoupon.GetCardCouponSendCount(cardCoupon.CardId) >= cardCoupon.MaxCount)
{
resp.errcode = 2;
resp.errmsg = "卡券已经领完";
return(ZentCloud.Common.JSONHelper.ObjectToJson(resp));
}
}
if (cardCoupon.GetLimitType != null)
{
if (cardCoupon.GetLimitType == "1" && !bllUser.IsDistributionMember(currentUserInfo, true))
{
resp.errcode = (int)BLLJIMP.Enums.APIErrCode.MallGetCardOnlyDistMember;
resp.errmsg = "只有分销员才能领取";
return(ZentCloud.Common.JSONHelper.ObjectToJson(resp));
}
if (cardCoupon.GetLimitType == "2" && bllUser.IsDistributionMember(currentUserInfo))
{
resp.errcode = (int)BLLJIMP.Enums.APIErrCode.MallGetCardOnlyNotDistMember;
resp.errmsg = "该券仅新用户（无购买历史）可以领取";
return(ZentCloud.Common.JSONHelper.ObjectToJson(resp));
}
}
if (!string.IsNullOrEmpty(cardCoupon.BindChannelUserId))
{
if (string.IsNullOrEmpty(currentUserInfo.DistributionOwner))
{
resp.errcode = (int)BLLJIMP.Enums.APIErrCode.MallGetCardOnlyChannel;
resp.errmsg = "只有指定渠道才能领取";
return(ZentCloud.Common.JSONHelper.ObjectToJson(resp));
}
BLLJIMP.BLLDistribution bllDis = new BLLJIMP.BLLDistribution();
string channelUserId = bllDis.GetUserChannel(currentUserInfo);
if (cardCoupon.BindChannelUserId != channelUserId)
{
resp.errcode = (int)BLLJIMP.Enums.APIErrCode.MallGetCardOnlyChannel;
resp.errmsg = "只有指定渠道才能领取";
return(ZentCloud.Common.JSONHelper.ObjectToJson(resp));
}
}
MyCardCoupons model = new MyCardCoupons();
model.CardCouponNumber = string.Format("No.{0}{1}", DateTime.Now.ToString("yyyyMMddHHmmss"), bllMall.GetGUID(BLLJIMP.TransacType.CommAdd));
model.CardCouponType = cardCoupon.CardCouponType;
model.CardId = cardCoupon.CardId;
model.InsertDate = DateTime.Now;
model.UserId = currentUserInfo.UserID;
model.WebSiteOwner = bllCardCoupon.WebsiteOwner;
if (bllCardCoupon.Add(model))
{
resp.errmsg = "ok";
string title = "您收到了一张优惠券";
string content = string.Format("{0}", cardCoupon.Name);
if (cardCoupon.ValidTo.HasValue)
{
content += string.Format("\\n{0}", ((DateTime)cardCoupon.ValidTo).ToString("yyyy-MM-dd"));
}
string url = string.Format("http://{0}/customize/shop/?v=1.0&ngroute=/mycoupons#/mycoupons", context.Request.Url.Host);
if (bllUser.WebsiteOwner == "jikuwifi")
{
url = string.Format("http://{0}/customize/jikuwifi/?v=1.0&ngroute=/mycoupons#/mycoupons", context.Request.Url.Host);
}
bllWeixin.SendTemplateMessageNotifyComm(currentUserInfo, title, content, url);
//#region 同时发放到微信卡包
//if (!string.IsNullOrEmpty(cardCoupon.WeixinCardId) && (!string.IsNullOrEmpty(CurrentUserInfo.WXOpenId)))
//{
// bllWeixinCard.SendByMass(cardCoupon.WeixinCardId, CurrentUserInfo.WXOpenId);
//}
//#endregion
}
else
{
resp.errcode = 1;
resp.errmsg = "领取优惠券失败";
return(ZentCloud.Common.JSONHelper.ObjectToJson(resp));
}
return(ZentCloud.Common.JSONHelper.ObjectToJson(resp));
}
public void ProcessRequest(HttpContext context)
{
StringBuilder sbWhere = new StringBuilder();
sbWhere.AppendFormat(" WebsiteOwner= '{0}' And IsNull(IsMain,0)=0", bllMall.WebsiteOwner);
string fromDate = context.Request["from_date"]; //开始日期
string toDate = context.Request["to_date"]; //结束日期
string status = context.Request["status"]; //订单状态
string orderIds = context.Request["oids"]; //订单号
string userAutoIds = context.Request["user_aids"]; //用户自动编号
string userTags = context.Request["user_tags"]; //用户标签
string isYuYueOrder = context.Request["is_yuyue"]; //是否是会议室预约和资源预约订单
string supplierUserId = context.Request["supplier_userid"]; //供应商账号
//订单类型
//0 商城订单
//1 礼品订单
//2 团购订单
//3 无
//4 活动订单
//5 会议室预订
//6 导师预约
string orderType = context.Request["order_type"];
if (!string.IsNullOrEmpty(orderType))
{
if (orderType == "5")
{
sbWhere.AppendFormat(" And ArticleCategoryType='MeetingRoom'");
}
else if (orderType == "6")
{
sbWhere.AppendFormat(" And ArticleCategoryType='BookingTutor'");
}
else
{
sbWhere.AppendFormat(" And OrderType={0}", orderType);
}
}
if (!string.IsNullOrEmpty(fromDate))
{
sbWhere.AppendFormat(" And InsertDate>='{0}'", fromDate);
}
if (!string.IsNullOrEmpty(toDate))
{
sbWhere.AppendFormat(" And InsertDate<='{0}'", toDate);
}
if (orderType == "2" && !string.IsNullOrEmpty(status))
{
status = ConvertGroupbuyStatus(status);
sbWhere.AppendFormat(" And GroupBuyStatus in({0})", status);
}
if (orderType == "2")
{
sbWhere.AppendFormat(" And PaymentStatus=1 ", status);
}
if ((!string.IsNullOrEmpty(status)) && (status != "退款退货") && orderType != "2")
{
status = "'" + status.Replace(",", "','") + "'";
sbWhere.AppendFormat(" And Status in({0})", status);
}
if (status == "退款退货")
{
sbWhere.AppendFormat(" And IsRefund=1 ");
}
if (!string.IsNullOrEmpty(orderIds))
{
orderIds = "'" + orderIds.Replace(",", "','") + "'";
sbWhere.AppendFormat(" And OrderID in({0}) ", orderIds);
}
if (bllUser.IsSupplier(currentUserInfo))
{
sbWhere.AppendFormat(" And SupplierUserId ='{0}' ", currentUserInfo.UserID);
}
if ((!string.IsNullOrEmpty(userAutoIds)) || (!string.IsNullOrEmpty(userTags)))
{
string userIds = "";
if (!string.IsNullOrEmpty(userAutoIds))
{
foreach (var userAutoId in userAutoIds.Split(','))
{
var userInfo = bllUser.GetUserInfoByAutoID(int.Parse(userAutoId));
if (userInfo != null)
{
userIds += string.Format("'{0}',", userInfo.UserID);
}
}
}
if (!string.IsNullOrEmpty(userTags))
{
foreach (string tag in userTags.Split(','))
{
List <UserInfo> userList = bllUser.GetList <UserInfo>(string.Format(" Websiteowner='{0}' And TagName like '%{1}%'", bllUser.WebsiteOwner, tag));
foreach (var userInfo in userList)
{
userIds += string.Format("'{0}',", userInfo.UserID);
}
}
}
userIds = userIds.TrimEnd(',');
sbWhere.AppendFormat(" And OrderUserId in({0}) ", userIds);
}
if (!string.IsNullOrEmpty(supplierUserId))
{
if (supplierUserId == "none")
{
sbWhere.AppendFormat(" And (SupplierUserId='' Or SupplierUserId IS NULL)", "");
}
else
{
sbWhere.AppendFormat(" And SupplierUserId ='{0}' ", supplierUserId);
}
}
sbWhere.AppendFormat(" Order by InsertDate Desc ");
List <WXMallOrderInfo> orderList = bllMall.GetList <WXMallOrderInfo>(sbWhere.ToString());
//sbExport.Append("会员ID\t");
DataTable dt1 = new DataTable();
DataTable dt2 = new DataTable();
dt1.Columns.Add("会员ID");
dt1.Columns.Add("线上卡号");
dt1.Columns.Add("OpenId");
dt1.Columns.Add("订单时间");
dt1.Columns.Add("父订单编号");
dt1.Columns.Add("订单号");
dt1.Columns.Add("订单状态");
dt1.Columns.Add("商品编号");
dt1.Columns.Add("商品编码");
dt1.Columns.Add("商品名称");
if (!string.IsNullOrEmpty(isYuYueOrder))
{
dt1.Columns.Add("预约时间");
}
dt1.Columns.Add("商品原价");
dt1.Columns.Add("商品均摊价格");
dt1.Columns.Add("商品单价");
dt1.Columns.Add("商品规格");
dt1.Columns.Add("商品条码");
dt1.Columns.Add("商品数量");
dt1.Columns.Add("商品总金额");
dt1.Columns.Add("运费");
dt1.Columns.Add("实付金额");
dt1.Columns.Add("收货人姓名");
dt1.Columns.Add("电话");
dt1.Columns.Add("收货地址");
dt1.Columns.Add("留言");
dt1.Columns.Add("支付状态");
dt1.Columns.Add("基础价");
dt1.Columns.Add("使用积分");
dt1.Columns.Add("使用余额");
dt1.Columns.Add("优惠券名称");
dt1.Columns.Add("优惠券ID");
dt1.Columns.Add("退款");
dt1.Columns.Add("主订单号");
dt1.Columns.Add("商户名称");
dt1.Columns.Add("商家备注");
dt1.Columns.Add("快递公司");
dt1.Columns.Add("快递单号");
dt2.Columns.Add("订单时间");
dt2.Columns.Add("订单号");
dt2.Columns.Add("订单状态");
dt2.Columns.Add("商品编号");
dt2.Columns.Add("商品名称");
dt2.Columns.Add("商品规格");
dt2.Columns.Add("商品数量");
dt2.Columns.Add("实付金额");
dt2.Columns.Add("收货人姓名");
dt2.Columns.Add("电话");
dt2.Columns.Add("收货地址");
dt2.Columns.Add("支付状态");
dt2.Columns.Add("退款");
dt2.Columns.Add("主订单号");
dt2.Columns.Add("商户名称");
dt2.Columns.Add("商家备注");
dt2.Columns.Add("快递公司");
dt2.Columns.Add("快递单号");
for (int i = 0; i < orderList.Count; i++)
{
var userInfo = bllUser.GetUserInfo(orderList[i].OrderUserID);
if (userInfo == null)
{
userInfo = new UserInfo();
}
string cardId = string.Empty;
string cardName = string.Empty;
if (!string.IsNullOrEmpty(orderList[i].MyCouponCardId))
{
switch (orderList[i].CouponType)
{
case 0:
MyCardCoupons myCardModel = bllCardcoupon.GetMyCardCoupon(Convert.ToInt32(orderList[i].MyCouponCardId));
if (myCardModel != null)
{
CardCoupons coupns = bllCardcoupon.GetCardCoupon(myCardModel.CardId);
cardId = coupns.CardId.ToString();
cardName = coupns.Name;
}
break;
case 1:
int cardIdInt = Convert.ToInt32(orderList[i].MyCouponCardId);
StoredValueCardRecord storedCard = bllStoredValueCard.GetStoredValueCardRecord(cardIdInt);
if (storedCard != null)
{
StoredValueCard cardModel = bllStoredValueCard.GetStoredValueCard(storedCard.CardId);
cardId = cardModel.AutoId.ToString();
cardName = cardModel.Name;
}
break;
default:
break;
}
}
foreach (var item in bllMall.GetOrderDetailsList(orderList[i].OrderID))
{
if (orderList[i].IsRefund == 1 && string.IsNullOrEmpty(item.RefundStatus) && status == "退款退货")
{
continue;
}
DataRow newRow = dt1.NewRow();
DataRow newRow1 = dt2.NewRow();
newRow["会员ID"] = userInfo.AutoID.ToString();
newRow["OpenId"] = userInfo.WXOpenId;
newRow["订单时间"] = orderList[i].InsertDate.ToString();
newRow1["订单时间"] = orderList[i].InsertDate.ToString();
WXMallProductInfo product = bllMall.GetProduct(item.PID);
switch (orderList[i].OrderType)
{
case 0:
newRow["父订单编号"] = "";
break;
case 1:
newRow["父订单编号"] = orderList[i].ParentOrderId;
break;
case 2:
newRow["父订单编号"] = orderList[i].GroupBuyParentOrderId;
break;
default:
break;
}
newRow["订单号"] = orderList[i].OrderID;
newRow1["订单号"] = orderList[i].OrderID;
newRow["订单状态"] = orderList[i].Status;
newRow1["订单状态"] = orderList[i].Status;
newRow["商品编号"] = product == null ? "" : product.PID;
newRow1["商品编号"] = product == null ? "" : product.PID;
newRow["商品编码"] = product == null ? "" : product.ProductCode;
newRow["商品名称"] = product == null ? item.SkuShowProp : product.PName;
newRow1["商品名称"] = product == null ? item.SkuShowProp : product.PName;
if (!string.IsNullOrEmpty(isYuYueOrder))
{
if (isYuYueOrder == "MeetingRoom")
{
if (!string.IsNullOrEmpty(product.RelationProductId))
{
newRow["预约时间"] = item.StartDate.ToString("yyyy-MM-dd HH：mm") + "-" + item.EndDate.ToString("HH：mm");
}
else
{
newRow["预约时间"] = "";
}
}
else
{
newRow["预约时间"] = item.StartDate.ToString("yyyy-MM-dd HH：mm") + "-" + item.EndDate.ToString("HH：mm");
}
}
newRow["商品原价"] = product.PreviousPrice;
newRow["商品均摊价格"] = item.PaymentFt;
newRow["商品单价"] = item.OrderPrice;
if (item.SkuId.HasValue)
{
newRow["商品规格"] = item.SkuShowProp;
newRow1["商品规格"] = item.SkuShowProp;
newRow["商品条码"] = item.SkuId;
}
else
{
newRow["商品规格"] = "";
newRow1["商品规格"] = "";
newRow["商品条码"] = "";
}
newRow["商品数量"] = item.TotalCount;
newRow1["商品数量"] = item.TotalCount;
newRow["商品总金额"] = item.TotalCount * item.OrderPrice;
newRow["运费"] = orderList[i].Transport_Fee;
newRow["实付金额"] = orderList[i].TotalAmount;
newRow1["实付金额"] = orderList[i].TotalAmount;
newRow["收货人姓名"] = orderList[i].Consignee;
newRow1["收货人姓名"] = orderList[i].Consignee;
newRow["电话"] = orderList[i].Phone;
newRow1["电话"] = orderList[i].Phone;
newRow["收货地址"] = orderList[i].ReceiverProvince + orderList[i].ReceiverCity + orderList[i].ReceiverDist + orderList[i].Address;
newRow1["收货地址"] = orderList[i].ReceiverProvince + orderList[i].ReceiverCity + orderList[i].ReceiverDist + orderList[i].Address;
newRow["留言"] = orderList[i].OrderMemo;
newRow["支付状态"] = ConvertPaymentStatus(orderList[i].PaymentStatus);
newRow1["支付状态"] = ConvertPaymentStatus(orderList[i].PaymentStatus);
newRow["基础价"] = item.BasePrice;
newRow["使用积分"] = orderList[i].UseScore;
newRow["使用余额"] = orderList[i].UseAmount;
newRow["优惠券名称"] = cardName;
newRow["优惠券ID"] = cardId;
newRow["退款"] = ConvertRefundStatus(item.RefundStatus);
newRow1["退款"] = ConvertRefundStatus(item.RefundStatus);
newRow["主订单号"] = orderList[i].ParentOrderId;
newRow1["主订单号"] = orderList[i].ParentOrderId;
newRow["商户名称"] = orderList[i].SupplierName;
newRow1["商户名称"] = orderList[i].SupplierName;
newRow["商家备注"] = orderList[i].Ex21;
newRow1["商家备注"] = orderList[i].Ex21;
newRow["快递公司"] = orderList[i].ExpressCompanyName;
newRow1["快递公司"] = orderList[i].ExpressCompanyName;
newRow["快递单号"] = orderList[i].ExpressNumber;
newRow1["快递单号"] = orderList[i].ExpressNumber;
newRow["线上卡号"] = userInfo.Ex2;
dt1.Rows.Add(newRow);
dt2.Rows.Add(newRow1);
}
//if (orderList[i].OrderType == 2)//团购订单
//{
// foreach (var item in bllMall.GetList<WXMallOrderInfo>(string.Format(" GroupBuyParentOrderId='{0}' And PaymentStatus=1", orderList[i].OrderID)))
// {
// foreach (var detail in bllMall.GetOrderDetailsList(item.OrderID))
// {
// DataRow nowRow1 = dt1.NewRow();
// DataRow nowRow2 = dt2.NewRow();
// WXMallProductInfo product = bllMall.GetProduct(detail.PID);
// nowRow1["订单时间"] = item.InsertDate.ToString();
// nowRow2["订单时间"] = item.InsertDate.ToString();
// nowRow1["父订单编号"] = item.GroupBuyParentOrderId;
// nowRow1["订单号"] = item.OrderID;
// nowRow2["订单号"] = item.OrderID;
// nowRow1["订单状态"] = item.Status;
// nowRow2["订单状态"] = item.Status;
// nowRow1["商品编号"] = product == null ? "" : product.PID;
// nowRow2["商品编号"] = product == null ? "" : product.PID;
// nowRow1["商品编码"] = product == null ? "" : product.ProductCode;
// nowRow1["商品名称"] = product == null ? "" : product.PName;
// nowRow2["商品名称"] = product == null ? "" : product.PName;
// nowRow1["商品原价"] = product.PreviousPrice;
// nowRow1["商品均摊价格"] = detail.PaymentFt;
// nowRow1["商品单价"] = detail.OrderPrice;
// if (detail.SkuId.HasValue)
// {
// nowRow1["商品规格"] = detail.SkuShowProp;
// nowRow2["商品规格"] = detail.SkuShowProp;
// nowRow1["商品条码"] = detail.SkuId;
// }
// else
// {
// nowRow1["商品规格"] = "";
// nowRow2["商品规格"] = "";
// nowRow1["商品条码"] = "";
// }
// nowRow1["商品数量"] = detail.TotalCount;
// nowRow2["商品数量"] = detail.TotalCount;
// nowRow1["商品总金额"] = detail.TotalCount * detail.OrderPrice;
// nowRow1["运费"] = item.Transport_Fee;
// nowRow1["实付金额"] = item.TotalAmount;
// nowRow2["实付金额"] = item.TotalAmount;
// nowRow1["收货人姓名"] = item.Consignee;
// nowRow2["收货人姓名"] = item.Consignee;
// nowRow1["电话"] = item.Phone;
// nowRow2["电话"] = item.Phone;
// nowRow1["收货地址"] = item.ReceiverProvince + item.ReceiverCity + item.ReceiverDist + item.Address;
// nowRow2["收货地址"] = item.ReceiverProvince + item.ReceiverCity + item.ReceiverDist + item.Address;
// nowRow1["留言"] = item.OrderMemo;
// nowRow1["支付状态"] = ConvertPaymentStatus(item.PaymentStatus);
// nowRow2["支付状态"] = ConvertPaymentStatus(item.PaymentStatus);
// nowRow1["基础价"] =detail.BasePrice;
// nowRow1["使用积分"] = orderList[i].UseScore;
// nowRow1["使用余额"] = orderList[i].UseAmount;
// nowRow1["优惠券名称"] = cardName;
// nowRow1["优惠券ID"] = cardId;
// nowRow1["退款"] =ConvertRefundStatus(detail.RefundStatus);
// nowRow2["退款"] = ConvertRefundStatus(detail.RefundStatus);
// dt1.Rows.Add(nowRow1);
// dt2.Rows.Add(nowRow2);
// }
// }
//}
}
dt1.TableName = "订单列表";
dt2.TableName = "精简订单列表";
DataTable[] dt3 = { dt1, dt2 };
DataLoadTool.ExportDataTable(dt3, string.Format("{0}_data.xls", DateTime.Now.ToString()));
}
public void ProcessRequest(HttpContext context)
{
BLLJIMP.Model.API.User.PayUpgrade requestUpgrade = bll.ConvertRequestToModel <BLLJIMP.Model.API.User.PayUpgrade>(new BLLJIMP.Model.API.User.PayUpgrade());
string websiteOwner = bll.WebsiteOwner;
requestUpgrade.level = CurrentUserInfo.MemberLevel;
WebsiteInfo website = bllUser.GetWebsiteInfoModelFromDataBase(websiteOwner);
UserLevelConfig levelConfig = bll.QueryUserLevel(websiteOwner, "DistributionOnLine", requestUpgrade.level.ToString());
if (levelConfig == null)
{
requestUpgrade.userTotalAmount = 0;
}
else
{
requestUpgrade.userTotalAmount = Convert.ToDecimal(levelConfig.FromHistoryScore);
}
UserLevelConfig toLevelConfig = bll.QueryUserLevel(websiteOwner, "DistributionOnLine", requestUpgrade.toLevel.ToString());
if (toLevelConfig == null)
{
apiResp.code = (int)APIErrCode.IsNotFound;
apiResp.msg = "会员等级未找到";
bll.ContextResponse(context, apiResp);
return;
}
if (toLevelConfig.IsDisable == 1)
{
apiResp.code = (int)APIErrCode.IsNotFound;
apiResp.msg = "会员级别禁止升级";
bll.ContextResponse(context, apiResp);
return;
}
requestUpgrade.needAmount = Convert.ToDecimal(toLevelConfig.FromHistoryScore);
requestUpgrade.amount = requestUpgrade.needAmount - requestUpgrade.userTotalAmount;
if (requestUpgrade.amount < 0)
{
apiResp.code = (int)APIErrCode.OperateFail;
apiResp.msg = "暂时不支持降级";
bll.ContextResponse(context, apiResp);
return;
}
string configV1CouponId = ZentCloud.Common.ConfigHelper.GetConfigString("YGBV1CouponId");
string configV2CouponId = ZentCloud.Common.ConfigHelper.GetConfigString("YGBV2CouponId");
string v1LevelNumber = ZentCloud.Common.ConfigHelper.GetConfigString("V1LevelNumber");
string v2LevelNumber = ZentCloud.Common.ConfigHelper.GetConfigString("V2LevelNumber");
string couponId = string.Empty;
CardCoupons cardModel = null;
MyCardCoupons myCardCoupon = null;
if (requestUpgrade.vType == "V1")
{
if (string.IsNullOrEmpty(configV1CouponId))
{
apiResp.code = (int)APIErrCode.ContentNotFound;
apiResp.msg = "V1优惠券未配置";
bllUser.ContextResponse(context, apiResp);
return;
}
couponId = configV1CouponId;
cardModel = bllCardCoupon.GetCardCoupon(Convert.ToInt32(couponId));
myCardCoupon = bllCardCoupon.GetMyCardCouponMainId(Convert.ToInt32(couponId), CurrentUserInfo.UserID);
if (cardModel == null || myCardCoupon == null)
{
apiResp.code = (int)APIErrCode.ContentNotFound;
apiResp.msg = "优惠券不存在";
bllUser.ContextResponse(context, apiResp);
return;
}
if (requestUpgrade.toLevel.ToString() != v1LevelNumber)
{
apiResp.code = (int)APIErrCode.ContentNotFound;
apiResp.msg = "优惠券不匹配";
bllUser.ContextResponse(context, apiResp);
return;
}
}
if (requestUpgrade.vType == "V2")
{
if (string.IsNullOrEmpty(configV2CouponId))
{
apiResp.code = (int)APIErrCode.ContentNotFound;
apiResp.msg = "V2优惠券未配置";
bllUser.ContextResponse(context, apiResp);
return;
}
couponId = configV2CouponId;
cardModel = bllCardCoupon.GetCardCoupon(Convert.ToInt32(couponId));
myCardCoupon = bllCardCoupon.GetMyCardCouponMainId(Convert.ToInt32(couponId), CurrentUserInfo.UserID);
if (cardModel == null || myCardCoupon == null)
{
apiResp.code = (int)APIErrCode.ContentNotFound;
apiResp.msg = "优惠券不存在";
bllUser.ContextResponse(context, apiResp);
return;
}
if (requestUpgrade.toLevel.ToString() != v2LevelNumber)
{
apiResp.code = (int)APIErrCode.ContentNotFound;
apiResp.msg = "优惠券不能用于此升级";
bllUser.ContextResponse(context, apiResp);
return;
}
}
BLLTransaction tran = new BLLTransaction();
StringBuilder sbSql = new StringBuilder();
UserInfo upUserLevel1 = null; //分销上一级
UserInfo upUserLevel2 = null; //分销上二级
UserInfo upUserLevel3 = null; //分销上三级
UserLevelConfig levelConfig1 = null; //分销上一级规则
UserLevelConfig levelConfig2 = null; //分销上二级规则
UserLevelConfig levelConfig3 = null; //分销上三级规则
ProjectCommission modelLevel1 = new ProjectCommission();
ScoreLockInfo scoreLockLevel1Info = new ScoreLockInfo();
ProjectCommission modelLevel1ex1 = new ProjectCommission();
ScoreLockInfo scoreLockLevel1ex1Info = new ScoreLockInfo();
ProjectCommission modelLevel2 = new ProjectCommission();
ScoreLockInfo scoreLockLevel2Info = new ScoreLockInfo();
ProjectCommission modelLevel3 = new ProjectCommission();
ScoreLockInfo scoreLockLevel3Info = new ScoreLockInfo();
int disLevel = 1;
if (website.DistributionLimitLevel > 1)
{
disLevel = website.DistributionLimitLevel;
}
string projectId = bll.GetGUID(TransacType.PayRegisterOrder);
CurrentUserInfo.MemberLevel = requestUpgrade.toLevel;
CurrentUserInfo.MemberApplyStatus = 9;
//计算分佣
bll.ComputeTransfers(disLevel, CurrentUserInfo, projectId, requestUpgrade.amount, websiteOwner, "余额升级", ref sbSql, ref upUserLevel1,
ref upUserLevel2, ref upUserLevel3, ref levelConfig1, ref levelConfig2, ref levelConfig3, ref modelLevel1, ref scoreLockLevel1Info,
ref modelLevel1ex1, ref scoreLockLevel1ex1Info, ref modelLevel2, ref scoreLockLevel2Info, ref modelLevel3, ref scoreLockLevel3Info,
toLevelConfig.LevelString);
if (bll.Update(CurrentUserInfo, string.Format(" MemberLevel={0},IsDisable=0,MemberApplyStatus=9 ", CurrentUserInfo.MemberLevel), string.Format(" AutoId='{0}' ", CurrentUserInfo.AutoID), tran) <= 0)
{
tran.Rollback();
apiResp.msg = "更新用户等级失败";
apiResp.code = (int)APIErrCode.OperateFail;
bll.ContextResponse(context, apiResp);
return;
}
bool hasProjectCommission = false;
#region 记录分佣信息
if (modelLevel1.Amount > 0)
{
hasProjectCommission = true;
int modelLevel1Id = Convert.ToInt32(bll.AddReturnID(modelLevel1, tran));
if (modelLevel1Id <= 0)
{
apiResp.msg = "一级返利失败";
apiResp.code = (int)APIErrCode.OperateFail;
bll.ContextResponse(context, apiResp);
return;
}
scoreLockLevel1Info.ForeignkeyId2 = modelLevel1Id.ToString();
scoreLockLevel1Info.AutoId = Convert.ToInt32(bll.AddReturnID(scoreLockLevel1Info, tran));
if (scoreLockLevel1Info.AutoId <= 0)
{
apiResp.msg = "一级返利冻结失败";
apiResp.code = (int)APIErrCode.OperateFail;
bll.ContextResponse(context, apiResp);
return;
}
string scoreDetailEvent = modelLevel1.ProjectName.Contains("购房补助") ? "返购房补助" : "返利";
if (bllUser.AddScoreDetail(scoreLockLevel1Info.UserId, websiteOwner, (double)scoreLockLevel1Info.Score,
scoreLockLevel1Info.Memo, "TotalAmount", (double)(upUserLevel1.TotalAmount + scoreLockLevel1Info.Score),
scoreLockLevel1Info.AutoId.ToString(), scoreDetailEvent, "", projectId, (double)modelLevel1.SourceAmount, (double)modelLevel1.DeductAmount,
modelLevel1.CommissionUserId, tran,
ex1: levelConfig.LevelNumber.ToString(), ex2: levelConfig.LevelString,
ex3: toLevelConfig.LevelNumber.ToString(), ex4: toLevelConfig.LevelString,
ex5: modelLevel1.CommissionLevel) <= 0)
{
tran.Rollback();
apiResp.msg = "一级返利明细记录失败";
apiResp.code = (int)APIErrCode.OperateFail;
bll.ContextResponse(context, apiResp);
return;
}
}
if (modelLevel1ex1.Amount > 0)
{
hasProjectCommission = true;
int modelLevel1ex1Id = Convert.ToInt32(bll.AddReturnID(modelLevel1ex1, tran));
if (modelLevel1ex1Id <= 0)
{
apiResp.msg = "一级返购房补助失败";
apiResp.code = (int)APIErrCode.OperateFail;
bll.ContextResponse(context, apiResp);
return;
}
scoreLockLevel1ex1Info.ForeignkeyId2 = modelLevel1ex1Id.ToString();
scoreLockLevel1ex1Info.AutoId = Convert.ToInt32(bll.AddReturnID(scoreLockLevel1ex1Info, tran));
if (scoreLockLevel1ex1Info.AutoId <= 0)
{
apiResp.msg = "一级返购房补助冻结失败";
apiResp.code = (int)APIErrCode.OperateFail;
bll.ContextResponse(context, apiResp);
return;
}
string scoreDetailEvent = modelLevel1ex1.ProjectName.Contains("购房补助") ? "返购房补助" : "返利";
if (bllUser.AddScoreDetail(scoreLockLevel1ex1Info.UserId, websiteOwner, (double)scoreLockLevel1ex1Info.Score,
scoreLockLevel1ex1Info.Memo, "TotalAmount", (double)(upUserLevel1.TotalAmount + scoreLockLevel1ex1Info.Score),
scoreLockLevel1ex1Info.AutoId.ToString(), scoreDetailEvent, "", projectId, (double)modelLevel1ex1.SourceAmount, (double)modelLevel1ex1.DeductAmount,
modelLevel1ex1.CommissionUserId, tran,
ex1: levelConfig.LevelNumber.ToString(), ex2: levelConfig.LevelString,
ex3: toLevelConfig.LevelNumber.ToString(), ex4: toLevelConfig.LevelString,
ex5: modelLevel1ex1.CommissionLevel) <= 0)
{
tran.Rollback();
apiResp.msg = "一级返购房补助明细记录失败";
apiResp.code = (int)APIErrCode.OperateFail;
bll.ContextResponse(context, apiResp);
return;
}
}
if (modelLevel2.Amount > 0)
{
hasProjectCommission = true;
int modelLevel2Id = Convert.ToInt32(bll.AddReturnID(modelLevel2, tran));
if (modelLevel2Id <= 0)
{
apiResp.msg = "二级返利失败";
apiResp.code = (int)APIErrCode.OperateFail;
bll.ContextResponse(context, apiResp);
return;
}
scoreLockLevel2Info.ForeignkeyId2 = modelLevel2Id.ToString();
scoreLockLevel2Info.AutoId = Convert.ToInt32(bll.AddReturnID(scoreLockLevel2Info, tran));
if (scoreLockLevel2Info.AutoId <= 0)
{
tran.Rollback();
apiResp.msg = "二级返利冻结失败";
apiResp.code = (int)APIErrCode.OperateFail;
bll.ContextResponse(context, apiResp);
return;
}
string scoreDetailEvent = modelLevel2.ProjectName.Contains("购房补助") ? "返购房补助" : "返利";
if (bllUser.AddScoreDetail(scoreLockLevel2Info.UserId, websiteOwner, (double)scoreLockLevel2Info.Score,
scoreLockLevel2Info.Memo, "TotalAmount", (double)(upUserLevel2.TotalAmount + scoreLockLevel2Info.Score),
scoreLockLevel2Info.AutoId.ToString(), scoreDetailEvent, "", projectId, (double)modelLevel2.SourceAmount, (double)modelLevel2.DeductAmount,
modelLevel2.CommissionUserId, tran,
ex1: levelConfig.LevelNumber.ToString(), ex2: levelConfig.LevelString,
ex3: toLevelConfig.LevelNumber.ToString(), ex4: toLevelConfig.LevelString,
ex5: modelLevel2.CommissionLevel) <= 0)
{
tran.Rollback();
apiResp.msg = "二级返利明细记录失败";
apiResp.code = (int)APIErrCode.OperateFail;
bll.ContextResponse(context, apiResp);
return;
}
}
if (modelLevel3.Amount > 0)
{
hasProjectCommission = true;
int modelLevel3Id = Convert.ToInt32(bll.AddReturnID(modelLevel3, tran));
if (!bll.Add(modelLevel3, tran))
{
tran.Rollback();
apiResp.msg = "三级返利失败";
apiResp.code = (int)APIErrCode.OperateFail;
bll.ContextResponse(context, apiResp);
return;
}
scoreLockLevel3Info.ForeignkeyId2 = modelLevel3Id.ToString();
scoreLockLevel3Info.AutoId = Convert.ToInt32(bll.AddReturnID(scoreLockLevel3Info, tran));
if (scoreLockLevel3Info.AutoId <= 0)
{
tran.Rollback();
apiResp.msg = "三级返利冻结失败";
apiResp.code = (int)APIErrCode.OperateFail;
bll.ContextResponse(context, apiResp);
return;
}
string scoreDetailEvent = modelLevel3.ProjectName.Contains("购房补助") ? "返购房补助" : "返利";
if (bllUser.AddScoreDetail(scoreLockLevel3Info.UserId, websiteOwner, (double)scoreLockLevel3Info.Score,
scoreLockLevel3Info.Memo, "TotalAmount", (double)(upUserLevel3.TotalAmount + scoreLockLevel3Info.Score),
scoreLockLevel3Info.AutoId.ToString(), scoreDetailEvent, "", projectId, (double)modelLevel3.SourceAmount, (double)modelLevel3.DeductAmount,
modelLevel3.CommissionUserId, tran,
ex1: levelConfig.LevelNumber.ToString(), ex2: levelConfig.LevelString,
ex3: toLevelConfig.LevelNumber.ToString(), ex4: toLevelConfig.LevelString,
ex5: modelLevel3.CommissionLevel) <= 0)
{
tran.Rollback();
apiResp.msg = "三级返利明细记录失败";
apiResp.code = (int)APIErrCode.OperateFail;
bll.ContextResponse(context, apiResp);
return;
}
}
#endregion
#region 更新分佣账面金额
if (hasProjectCommission)
{
if (BLLBase.ExecuteSql(sbSql.ToString(), tran) <= 0)
{
tran.Rollback();
apiResp.msg = string.Format("更新分佣账面{0}出错", website.TotalAmountShowName);
apiResp.code = (int)APIErrCode.OperateFail;
bll.ContextResponse(context, apiResp);
return;
}
}
#endregion
#region 记录余额明细
//自己的消费记录
if (bllUser.AddScoreDetail(CurrentUserInfo.UserID, websiteOwner, (double)(0 - requestUpgrade.amount),
string.Format("{1}为{0}", toLevelConfig.LevelString, "升级"), "TotalAmount", (double)(CurrentUserInfo.TotalAmount - requestUpgrade.amount),
"", "升级会员", "", "", (double)requestUpgrade.amount, 0, "",
tran, ex1: levelConfig.LevelNumber.ToString(), ex2: levelConfig.LevelString,
ex3: toLevelConfig.LevelNumber.ToString(), ex4: toLevelConfig.LevelString) <= 0)
{
tran.Rollback();
apiResp.msg = "升级会员明细出错";
apiResp.code = (int)APIErrCode.OperateFail;
bll.ContextResponse(context, apiResp);
return;
}
#endregion
#region 修改优惠券 更新支付状态
myCardCoupon.UseDate = DateTime.Now;
myCardCoupon.Status = 1;
if (!bllCardCoupon.Update(myCardCoupon, tran))
{
tran.Rollback();
apiResp.code = (int)APIErrCode.OperateFail;
apiResp.msg = "更新优惠券状态失败";
bll.ContextResponse(context, apiResp);
return;
}
#endregion
#region 记录业绩明细
TeamPerformanceDetails perDetail = new TeamPerformanceDetails();
perDetail.AddType = "升级";
perDetail.AddNote = "由" + levelConfig.LevelString + "升级" + toLevelConfig.LevelString;
perDetail.AddTime = DateTime.Now;
perDetail.DistributionOwner = CurrentUserInfo.DistributionOwner;
perDetail.UserId = CurrentUserInfo.UserID;
perDetail.UserName = CurrentUserInfo.TrueName;
perDetail.UserPhone = CurrentUserInfo.Phone;
perDetail.Performance = requestUpgrade.amount;
string yearMonthString = perDetail.AddTime.ToString("yyyyMM");
int yearMonth = Convert.ToInt32(yearMonthString);
perDetail.WebsiteOwner = websiteOwner;
perDetail.YearMonth = yearMonth;
if (!bllUser.Add(perDetail, tran))
{
tran.Rollback();
apiResp.msg = "记录业绩明细失败";
apiResp.code = (int)APIErrCode.OperateFail;
bll.ContextResponse(context, apiResp);
return;
}
#endregion
tran.Commit();
if (hasProjectCommission)
{
//异步修改积分明细表
Thread th1 = new Thread(delegate()
{
//计算相关业绩
bll.BuildCurMonthPerformanceByUserID(websiteOwner, CurrentUserInfo.UserID);
});
th1.Start();
}
apiResp.msg = "升级完成";
apiResp.code = (int)APIErrCode.IsSuccess;
apiResp.status = true;
bll.ContextResponse(context, apiResp);
}
public void ProcessRequest(HttpContext context)
{
BLLJIMP.Model.API.User.PayRegisterUser requestUser = bll.ConvertRequestToModel <BLLJIMP.Model.API.User.PayRegisterUser>(new BLLJIMP.Model.API.User.PayRegisterUser());
string websiteOwner = bll.WebsiteOwner;
WebsiteInfo website = bllUser.GetWebsiteInfoModelFromDataBase(websiteOwner);
if (string.IsNullOrWhiteSpace(requestUser.level.ToString()))
{
apiResp.code = (int)APIErrCode.PrimaryKeyIncomplete;
apiResp.msg = "请选择会员级别";
bll.ContextResponse(context, apiResp);
return;
}
if (string.IsNullOrWhiteSpace(requestUser.phone))
{
apiResp.code = (int)APIErrCode.PrimaryKeyIncomplete;
apiResp.msg = "请输入手机号码";
bll.ContextResponse(context, apiResp);
return;
}
if (string.IsNullOrWhiteSpace(requestUser.spreadid))
{
apiResp.code = (int)APIErrCode.PrimaryKeyIncomplete;
apiResp.msg = "请输入推荐人编号";
bll.ContextResponse(context, apiResp);
return;
}
if (!ZentCloud.Common.MyRegex.PhoneNumLogicJudge(requestUser.phone))
{
apiResp.code = (int)APIErrCode.OperateFail;
apiResp.msg = "手机号码格式不正确";
bll.ContextResponse(context, apiResp);
return;
}
if (!ZentCloud.Common.MyRegex.IsIDCard(requestUser.idcard))
{
apiResp.code = (int)APIErrCode.OperateFail;
apiResp.msg = "身份证号码必须如实填写";
bll.ContextResponse(context, apiResp);
return;
}
UserLevelConfig levelConfig = bll.QueryUserLevel(websiteOwner, "DistributionOnLine", requestUser.level.ToString());
if (levelConfig == null)
{
apiResp.code = (int)APIErrCode.IsNotFound;
apiResp.msg = "会员级别未找到";
bll.ContextResponse(context, apiResp);
return;
}
if (levelConfig.IsDisable == 1)
{
apiResp.code = (int)APIErrCode.IsNotFound;
apiResp.msg = "会员级别禁止注册";
bll.ContextResponse(context, apiResp);
return;
}
UserInfo spreadUser = bllUser.GetSpreadUser(requestUser.spreadid, websiteOwner);
if (spreadUser == null)
{
apiResp.code = (int)APIErrCode.IsNotFound;
apiResp.msg = "推荐人未找到";
bll.ContextResponse(context, apiResp);
return;
}
requestUser.spreadid = spreadUser.UserID; //推荐人
UserInfo regUser = bllUser.GetUserInfoByPhone(requestUser.phone, websiteOwner);
if (regUser != null && regUser.MemberLevel >= 10)
{
apiResp.code = (int)APIErrCode.OperateFail;
apiResp.msg = "该手机已注册会员";
bll.ContextResponse(context, apiResp);
return;
}
if (regUser != null && regUser.MemberLevel >= requestUser.level)
{
apiResp.code = (int)APIErrCode.OperateFail;
apiResp.msg = "该会员有更高级别";
bll.ContextResponse(context, apiResp);
return;
}
string configV1CouponId = ZentCloud.Common.ConfigHelper.GetConfigString("YGBV1CouponId");
string configV2CouponId = ZentCloud.Common.ConfigHelper.GetConfigString("YGBV2CouponId");
string v1LevelNumber = ZentCloud.Common.ConfigHelper.GetConfigString("V1LevelNumber");
string v2LevelNumber = ZentCloud.Common.ConfigHelper.GetConfigString("V2LevelNumber");
string couponId = string.Empty;
CardCoupons cardModel = null;
MyCardCoupons myCardCoupon = null;
if (requestUser.vType == "V1")
{
if (string.IsNullOrEmpty(configV1CouponId))
{
apiResp.code = (int)APIErrCode.ContentNotFound;
apiResp.msg = "V1优惠券未配置";
bllUser.ContextResponse(context, apiResp);
return;
}
couponId = configV1CouponId;
cardModel = bllCardCoupon.GetCardCoupon(Convert.ToInt32(couponId));
myCardCoupon = bllCardCoupon.GetMyCardCouponMainId(Convert.ToInt32(couponId), regUser.UserID);
if (cardModel == null || myCardCoupon == null)
{
apiResp.code = (int)APIErrCode.ContentNotFound;
apiResp.msg = "优惠券不存在";
bllUser.ContextResponse(context, apiResp);
return;
}
if (requestUser.level.ToString() != v1LevelNumber)
{
apiResp.code = (int)APIErrCode.ContentNotFound;
apiResp.msg = "优惠券不能用于此升级";
bllUser.ContextResponse(context, apiResp);
return;
}
}
if (requestUser.vType == "V2")
{
if (string.IsNullOrEmpty(configV2CouponId))
{
apiResp.code = (int)APIErrCode.ContentNotFound;
apiResp.msg = "V2优惠券未配置";
bllUser.ContextResponse(context, apiResp);
return;
}
couponId = configV2CouponId;
cardModel = bllCardCoupon.GetCardCoupon(Convert.ToInt32(couponId));
myCardCoupon = bllCardCoupon.GetMyCardCouponMainId(Convert.ToInt32(couponId), regUser.UserID);
if (cardModel == null || myCardCoupon == null)
{
apiResp.code = (int)APIErrCode.ContentNotFound;
apiResp.msg = "优惠券不存在";
bllUser.ContextResponse(context, apiResp);
return;
}
if (requestUser.level.ToString() != v2LevelNumber)
{
apiResp.code = (int)APIErrCode.ContentNotFound;
apiResp.msg = "优惠券不能用于此升级";
bllUser.ContextResponse(context, apiResp);
return;
}
}
if (regUser == null)
{
regUser = new UserInfo();
regUser.UserID = string.Format("ZYUser{0}{1}", DateTime.Now.ToString("yyyyMMdd"), Guid.NewGuid().ToString("N").ToUpper());
regUser.UserType = 2;
regUser.WebsiteOwner = websiteOwner;
regUser.Regtime = DateTime.Now;
regUser.LastLoginDate = DateTime.Parse("1970-01-01");
}
regUser.TrueName = requestUser.truename;
regUser.DistributionOwner = requestUser.spreadid;
regUser.Phone = requestUser.phone;
regUser.MemberLevel = requestUser.level;
regUser.MemberApplyTime = DateTime.Now;
regUser.MemberStartTime = DateTime.Now;
regUser.MemberApplyStatus = 9;
regUser.IdentityCard = requestUser.idcard;
regUser.Province = requestUser.province;
regUser.City = requestUser.city;
regUser.District = requestUser.district;
regUser.Town = requestUser.town;
regUser.ProvinceCode = requestUser.provinceCode;
regUser.CityCode = requestUser.cityCode;
regUser.DistrictCode = requestUser.districtCode;
regUser.TownCode = requestUser.townCode;
regUser.RegIP = context.Request.UserHostAddress;//ip
regUser.Password = ZentCloud.Common.Rand.Number(6);
regUser.RegUserID = CurrentUserInfo.UserID;
regUser.EmptyBill = 0;
regUser.RegisterWay = "线上";
regUser.IsDisable = 0;
int disLevel = 1;
if (website.DistributionLimitLevel > 1)
{
disLevel = website.DistributionLimitLevel;
}
StringBuilder sbSql = new StringBuilder();
UserInfo upUserLevel1 = null; //分销上一级
UserInfo upUserLevel2 = null; //分销上二级
UserInfo upUserLevel3 = null; //分销上三级
UserLevelConfig levelConfig1 = null; //分销上一级规则
UserLevelConfig levelConfig2 = null; //分销上二级规则
UserLevelConfig levelConfig3 = null; //分销上三级规则
ProjectCommission modelLevel1 = new ProjectCommission();
ScoreLockInfo scoreLockLevel1Info = new ScoreLockInfo();
ProjectCommission modelLevel1ex1 = new ProjectCommission();
ScoreLockInfo scoreLockLevel1ex1Info = new ScoreLockInfo();
ProjectCommission modelLevel2 = new ProjectCommission();
ScoreLockInfo scoreLockLevel2Info = new ScoreLockInfo();
ProjectCommission modelLevel3 = new ProjectCommission();
ScoreLockInfo scoreLockLevel3Info = new ScoreLockInfo();
string projectId = bll.GetGUID(TransacType.PayRegisterOrder);
//计算分佣
bll.ComputeTransfers(disLevel, regUser, projectId, decimal.Parse(cardModel.Ex3), websiteOwner, "优惠券注册", ref sbSql, ref upUserLevel1,
ref upUserLevel2, ref upUserLevel3, ref levelConfig1, ref levelConfig2, ref levelConfig3, ref modelLevel1, ref scoreLockLevel1Info,
ref modelLevel1ex1, ref scoreLockLevel1ex1Info, ref modelLevel2, ref scoreLockLevel2Info, ref modelLevel3, ref scoreLockLevel3Info,
levelConfig.LevelString);
BLLTransaction tran = new BLLTransaction();
#region 注册会员
if (regUser.AutoID == 0)
{
regUser.AutoID = Convert.ToInt32(bllUser.AddReturnID(regUser, tran));
if (regUser.AutoID <= 0)
{
tran.Rollback();
apiResp.msg = "注册用户出错";
apiResp.code = (int)APIErrCode.OperateFail;
bll.ContextResponse(context, apiResp);
return;
}
}
else
{
if (!bllUser.Update(regUser, tran))
{
tran.Rollback();
apiResp.msg = "注册用户出错";
apiResp.code = (int)APIErrCode.OperateFail;
bll.ContextResponse(context, apiResp);
return;
}
}
#endregion
#region 更新优惠券状态
myCardCoupon.UseDate = DateTime.Now;
myCardCoupon.Status = 1;
if (!bllCardCoupon.Update(myCardCoupon, tran))
{
tran.Rollback();
apiResp.code = (int)APIErrCode.OperateFail;
apiResp.msg = "更新优惠券状态失败";
bll.ContextResponse(context, apiResp);
return;
}
#endregion
#region 注册账号余额明细
//自己的消费记录
if (bllUser.AddScoreDetail(regUser.UserID, websiteOwner, double.Parse(cardModel.Ex3),
string.Format("优惠券抵扣{0}元", double.Parse(cardModel.Ex3)),
"TotalAmount", double.Parse(cardModel.Ex3),
"", "注册会员", "", "", double.Parse(cardModel.Ex3), 0, regUser.UserID,
tran, ex3: levelConfig.LevelNumber.ToString(), ex4: levelConfig.LevelString) <= 0)
{
tran.Rollback();
apiResp.msg = "积分明细添加失败";
apiResp.code = (int)APIErrCode.OperateFail;
bll.ContextResponse(context, apiResp);
return;
}
#endregion
bool hasProjectCommission = false;
#region 记录分佣信息
if (modelLevel1.Amount > 0)
{
hasProjectCommission = true;
int modelLevel1Id = Convert.ToInt32(bll.AddReturnID(modelLevel1, tran));
if (modelLevel1Id <= 0)
{
tran.Rollback();
apiResp.msg = "一级返利失败";
apiResp.code = (int)APIErrCode.OperateFail;
bll.ContextResponse(context, apiResp);
return;
}
scoreLockLevel1Info.ForeignkeyId2 = modelLevel1Id.ToString();
scoreLockLevel1Info.AutoId = Convert.ToInt32(bll.AddReturnID(scoreLockLevel1Info, tran));
if (scoreLockLevel1Info.AutoId <= 0)
{
tran.Rollback();
apiResp.msg = "一级返利冻结失败";
apiResp.code = (int)APIErrCode.OperateFail;
bll.ContextResponse(context, apiResp);
return;
}
string scoreDetailEvent = modelLevel1.ProjectName.Contains("购房补助") ? "返购房补助" : "返利";
if (bllUser.AddScoreDetail(scoreLockLevel1Info.UserId, websiteOwner, (double)scoreLockLevel1Info.Score,
scoreLockLevel1Info.Memo, "TotalAmount", (double)(upUserLevel1.TotalAmount + scoreLockLevel1Info.Score),
scoreLockLevel1Info.AutoId.ToString(), scoreDetailEvent, "", projectId, (double)modelLevel1.SourceAmount, (double)modelLevel1.DeductAmount,
modelLevel1.CommissionUserId,
tran, ex3: levelConfig.LevelNumber.ToString(), ex4: levelConfig.LevelString,
ex5: modelLevel1.CommissionLevel) <= 0)
{
tran.Rollback();
apiResp.msg = "一级返利明细记录失败";
apiResp.code = (int)APIErrCode.OperateFail;
bll.ContextResponse(context, apiResp);
return;
}
}
if (modelLevel1ex1.Amount > 0)
{
hasProjectCommission = true;
int modelLevel1ex1Id = Convert.ToInt32(bll.AddReturnID(modelLevel1ex1, tran));
if (modelLevel1ex1Id <= 0)
{
tran.Rollback();
apiResp.msg = "一级返购房补助失败";
apiResp.code = (int)APIErrCode.OperateFail;
bll.ContextResponse(context, apiResp);
return;
}
scoreLockLevel1ex1Info.ForeignkeyId2 = modelLevel1ex1Id.ToString();
scoreLockLevel1ex1Info.AutoId = Convert.ToInt32(bll.AddReturnID(scoreLockLevel1ex1Info, tran));
if (scoreLockLevel1ex1Info.AutoId <= 0)
{
tran.Rollback();
apiResp.msg = "一级返购房补助冻结失败";
apiResp.code = (int)APIErrCode.OperateFail;
bll.ContextResponse(context, apiResp);
return;
}
string scoreDetailEvent = modelLevel1ex1.ProjectName.Contains("购房补助") ? "返购房补助" : "返利";
if (bllUser.AddScoreDetail(scoreLockLevel1ex1Info.UserId, websiteOwner, (double)scoreLockLevel1ex1Info.Score,
scoreLockLevel1ex1Info.Memo, "TotalAmount", (double)(upUserLevel1.TotalAmount + scoreLockLevel1ex1Info.Score),
scoreLockLevel1ex1Info.AutoId.ToString(), scoreDetailEvent, "", projectId, (double)modelLevel1ex1.SourceAmount, (double)modelLevel1ex1.DeductAmount,
modelLevel1ex1.CommissionUserId,
tran, ex3: levelConfig.LevelNumber.ToString(), ex4: levelConfig.LevelString,
ex5: modelLevel1ex1.CommissionLevel) <= 0)
{
tran.Rollback();
apiResp.msg = "一级返购房补助明细记录失败";
apiResp.code = (int)APIErrCode.OperateFail;
bll.ContextResponse(context, apiResp);
return;
}
}
if (modelLevel2.Amount > 0)
{
hasProjectCommission = true;
int modelLevel2Id = Convert.ToInt32(bll.AddReturnID(modelLevel2, tran));
if (modelLevel2Id <= 0)
{
tran.Rollback();
apiResp.msg = "二级返利失败";
apiResp.code = (int)APIErrCode.OperateFail;
bll.ContextResponse(context, apiResp);
return;
}
scoreLockLevel2Info.ForeignkeyId2 = modelLevel2Id.ToString();
scoreLockLevel2Info.AutoId = Convert.ToInt32(bll.AddReturnID(scoreLockLevel2Info, tran));
if (scoreLockLevel2Info.AutoId <= 0)
{
tran.Rollback();
apiResp.msg = "二级返利冻结失败";
apiResp.code = (int)APIErrCode.OperateFail;
bll.ContextResponse(context, apiResp);
return;
}
string scoreDetailEvent = modelLevel2.ProjectName.Contains("购房补助") ? "返购房补助" : "返利";
if (bllUser.AddScoreDetail(scoreLockLevel2Info.UserId, websiteOwner, (double)scoreLockLevel2Info.Score,
scoreLockLevel2Info.Memo, "TotalAmount", (double)(upUserLevel2.TotalAmount + scoreLockLevel2Info.Score),
scoreLockLevel2Info.AutoId.ToString(), scoreDetailEvent, "", projectId, (double)modelLevel2.SourceAmount, (double)modelLevel2.DeductAmount,
modelLevel2.CommissionUserId,
tran, ex3: levelConfig.LevelNumber.ToString(), ex4: levelConfig.LevelString,
ex5: modelLevel2.CommissionLevel) <= 0)
{
tran.Rollback();
apiResp.msg = "二级返利明细记录失败";
apiResp.code = (int)APIErrCode.OperateFail;
bll.ContextResponse(context, apiResp);
return;
}
}
if (modelLevel3.Amount > 0)
{
hasProjectCommission = true;
int modelLevel3Id = Convert.ToInt32(bll.AddReturnID(modelLevel3, tran));
if (!bll.Add(modelLevel3, tran))
{
tran.Rollback();
apiResp.msg = "三级返利失败";
apiResp.code = (int)APIErrCode.OperateFail;
bll.ContextResponse(context, apiResp);
return;
}
scoreLockLevel3Info.ForeignkeyId2 = modelLevel3Id.ToString();
scoreLockLevel3Info.AutoId = Convert.ToInt32(bll.AddReturnID(scoreLockLevel3Info, tran));
if (scoreLockLevel3Info.AutoId <= 0)
{
tran.Rollback();
apiResp.msg = "三级返利冻结失败";
apiResp.code = (int)APIErrCode.OperateFail;
bll.ContextResponse(context, apiResp);
return;
}
string scoreDetailEvent = modelLevel3.ProjectName.Contains("购房补助") ? "返购房补助" : "返利";
if (bllUser.AddScoreDetail(scoreLockLevel3Info.UserId, websiteOwner, (double)scoreLockLevel3Info.Score,
scoreLockLevel3Info.Memo, "TotalAmount", (double)(upUserLevel3.TotalAmount + scoreLockLevel3Info.Score),
scoreLockLevel3Info.AutoId.ToString(), scoreDetailEvent, "", projectId, (double)modelLevel3.SourceAmount, (double)modelLevel3.DeductAmount,
modelLevel3.CommissionUserId,
tran, ex3: levelConfig.LevelNumber.ToString(), ex4: levelConfig.LevelString,
ex5: modelLevel3.CommissionLevel) <= 0)
{
tran.Rollback();
apiResp.msg = "三级返利明细记录失败";
apiResp.code = (int)APIErrCode.OperateFail;
bll.ContextResponse(context, apiResp);
return;
}
}
if (hasProjectCommission)
{
if (BLLBase.ExecuteSql(sbSql.ToString(), tran) <= 0)
{
tran.Rollback();
apiResp.msg = string.Format("更新分佣账面{0}出错", website.TotalAmountShowName);
apiResp.code = (int)APIErrCode.OperateFail;
bll.ContextResponse(context, apiResp);
return;
}
}
#endregion
#region 记录业绩明细
TeamPerformanceDetails perDetail = new TeamPerformanceDetails();
perDetail.AddType = "注册";
perDetail.AddNote = "注册" + levelConfig.LevelString;
perDetail.AddTime = DateTime.Now;
perDetail.DistributionOwner = regUser.DistributionOwner;
perDetail.UserId = regUser.UserID;
perDetail.UserName = regUser.TrueName;
perDetail.UserPhone = regUser.Phone;
perDetail.Performance = decimal.Parse(cardModel.Ex3);
string yearMonthString = perDetail.AddTime.ToString("yyyyMM");
int yearMonth = Convert.ToInt32(yearMonthString);
perDetail.YearMonth = yearMonth;
perDetail.WebsiteOwner = websiteOwner;
if (!bllUser.Add(perDetail, tran))
{
tran.Rollback();
apiResp.msg = "记录业绩明细失败";
apiResp.code = (int)APIErrCode.OperateFail;
bll.ContextResponse(context, apiResp);
return;
}
#endregion
tran.Commit();
if (hasProjectCommission)
{
//异步修改积分明细表
Thread th1 = new Thread(delegate()
{
//计算相关业绩
bll.BuildCurMonthPerformanceByUserID(websiteOwner, regUser.UserID);
});
th1.Start();
}
string msg = "";
#region 短信发送密码
BLLSMS bllSms = new BLLSMS("");
bool smsBool = false;
string smsString = string.Format("恭喜您成功注册为天下华商月供宝：{1}，您的初始密码为：{0}。您可关注公众号：songhetz，登录账户修改密码，并设置支付密码。", regUser.Password, levelConfig.LevelString);
bllSms.SendSmsMisson(regUser.Phone, smsString, "", website.SmsSignature, out smsBool, out msg);
#endregion
if (string.IsNullOrWhiteSpace(msg))
{
msg = "注册成功";
}
apiResp.msg = msg;
apiResp.code = (int)APIErrCode.IsSuccess;
apiResp.status = true;
apiResp.result = new
{
password = regUser.Password
};
bll.ContextResponse(context, apiResp);
}
/// <summary>
/// 获取我的卡券列表
/// </summary>
/// <param name="context"></param>
/// <returns></returns>
private string getmycouponlist(HttpContext context)
{
string CardCouponType = context.Request["cardcoupontype"];
int PageIndex = int.Parse(context.Request["pageindex"]);
int PageSize = int.Parse(context.Request["pagesize"]);
string Status = context.Request["status"];
switch (CardCouponType)
{
#region 门票
case "entranceticket": //门票
MyCardcouponList_EntranceTicket apimodel = new MyCardcouponList_EntranceTicket();
int TotalCount = 0;
var SourceData = bllCardCoupon.GetMyCardCoupons(EnumCardCouponType.EntranceTicket, CurrentUserInfo.UserID, PageIndex, PageSize, out TotalCount, "", " AutoID DESC", Status);
apimodel.totalcount = TotalCount;
apimodel.list = new List <MyCardcoupon_EntranceTicket>();
foreach (var item in SourceData)
{
CardCoupons CardCoupon = bllCardCoupon.GetCardCoupon(EnumCardCouponType.EntranceTicket, item.CardId);
MyCardcoupon_EntranceTicket model = new MyCardcoupon_EntranceTicket();
model.card_bigimg = bllCardCoupon.GetImgUrl(CardCoupon.Ex1);
model.card_detail = CardCoupon.Ex2;
if (model.card_detail != null && model.card_detail.Contains("/FileUpload/"))
{
model.card_detail = model.card_detail.Replace("/FileUpload/", string.Format("http://{0}/FileUpload/", context.Request.Url.Host));
}
model.card_logo = bllCardCoupon.GetImgUrl(CardCoupon.Logo);
model.card_name = CardCoupon.Name;
model.card_number = item.CardCouponNumber;
if (CardCoupon.ValidFrom != null)
{
model.card_validfrom = bllCardCoupon.GetTimeStamp((DateTime)CardCoupon.ValidFrom);
}
if (CardCoupon.ValidTo != null)
{
model.card_validto = bllCardCoupon.GetTimeStamp((DateTime)CardCoupon.ValidTo);
}
model.companyname = CardCoupon.Ex3; //公司名称
model.id = item.AutoId;
model.status = item.Status;
if (item.Status == 0)
{
if (bllCardCoupon.IsCardCouponExpire(EnumCardCouponType.EntranceTicket, item.CardId))
{
model.status = 2; //卡券已过期
}
}
apimodel.list.Add(model);
}
return(Common.JSONHelper.ObjectToJson(apimodel));
#endregion
default:
break;
}
return("");
}
/// <summary>
/// 卡券核销
/// </summary>
/// <param name="context"></param>
/// <returns></returns>
private string Hexiao(HttpContext context)
{
string cardCouponId = context.Request["cardcoupon_id"]; //主卡券ID
string hexiaoCode = context.Request["hexiao_code"]; //核销码
if (string.IsNullOrEmpty(cardCouponId))
{
apiResp.msg = "cardcoupon_id 参数必传";
return(ZentCloud.Common.JSONHelper.ObjectToJson(apiResp));
}
if (string.IsNullOrEmpty(hexiaoCode))
{
apiResp.msg = "hexiao_code 参数必传";
return(ZentCloud.Common.JSONHelper.ObjectToJson(apiResp));
}
CardCoupons cardCoupon = bllCardCoupon.GetCardCoupon(int.Parse(cardCouponId));
if (cardCoupon == null)
{
apiResp.msg = "卡券不存在";
return(ZentCloud.Common.JSONHelper.ObjectToJson(apiResp));
}
MyCardCoupons myCardCoupon = bllCardCoupon.Get <MyCardCoupons>(string.Format(" CardId={0} And Status=0 And UserId='{1}'", cardCoupon.CardId, currentUserInfo.UserID));
if (myCardCoupon == null)
{
apiResp.msg = "卡券不存在";
return(ZentCloud.Common.JSONHelper.ObjectToJson(apiResp));
}
if (myCardCoupon.Status == 1)
{
apiResp.msg = "卡券已经使用";
return(ZentCloud.Common.JSONHelper.ObjectToJson(apiResp));
}
string hexiaoChanel = "";
bool hexiaoResult = GetHexiaoChannel(hexiaoCode, out hexiaoChanel);
if (!hexiaoResult)
{
apiResp.msg = "核销失败";
return(ZentCloud.Common.JSONHelper.ObjectToJson(apiResp));
}
try
{
myCardCoupon.HexiaoCode = hexiaoCode;
myCardCoupon.HexiaoChannel = hexiaoChanel;
myCardCoupon.Status = 1;
myCardCoupon.UseDate = DateTime.Now;
if (!bllCardCoupon.Update(myCardCoupon))
{
apiResp.msg = "核销失败";
return(ZentCloud.Common.JSONHelper.ObjectToJson(apiResp));
}
else
{
apiResp.status = true;
apiResp.msg = "ok";
}
}
catch (Exception ex)
{
apiResp.msg = ex.Message;
return(ZentCloud.Common.JSONHelper.ObjectToJson(apiResp));
}
return(ZentCloud.Common.JSONHelper.ObjectToJson(apiResp));
}
public void ProcessRequest(HttpContext context)
{
/// <summary>
/// 卡券BLL
/// </summary>
BLLJIMP.BLLCardCoupon bllCardCoupon = new BLLJIMP.BLLCardCoupon();
/// <summary>
/// 商城BLL
/// </summary>
BLLJIMP.BLLMall bllMall = new BLLJIMP.BLLMall();
/// <summary>
/// 用户BLL
/// </summary>
BLLJIMP.BLLUser bllUser = new BLLJIMP.BLLUser();
/// <summary>
/// 微信BLL
/// </summary>
BLLJIMP.BLLWeixin bllWeixin = new BLLJIMP.BLLWeixin();
/// <summary>
///
/// </summary>
BLLJIMP.BLLStoredValueCard bllStoredValue = new BLLJIMP.BLLStoredValueCard();
/// <summary>
///
/// </summary>
BLLJIMP.BLLWeixinCard bllWeixinCard = new BLLJIMP.BLLWeixinCard();
string cardCouponId = context.Request["cardcoupon_id"]; //主卡券ID
string myCardCouponId = context.Request["my_cardcoupon_id"]; //我的卡券ID
if (string.IsNullOrEmpty(cardCouponId))
{
resp.status = false;
resp.msg = "cardcoupon_id 参数必传";
context.Response.Write(JsonConvert.SerializeObject(resp));
return;
}
CardCoupons cardCoupon = bllCardCoupon.GetCardCouponByWXCardId(cardCouponId);
if (cardCoupon == null)
{
cardCoupon = bllCardCoupon.GetCardCoupon(int.Parse(cardCouponId));
if (cardCoupon == null)
{
resp.status = false;
resp.msg = "cardcoupon_id 不存在";
context.Response.Write(JsonConvert.SerializeObject(resp));
return;
}
}
cardCoupon = bllCardCoupon.ConvertExpireTime(cardCoupon);
MainCardModel model = new MainCardModel();
model.cardcoupon_id = cardCoupon.CardId;
model.cardcoupon_name = cardCoupon.Name;
model.cardcoupon_type = ConvertCardCouponType(cardCoupon.CardCouponType);
model.valid_from = cardCoupon.ValidFrom.ToString();
model.valid_to = cardCoupon.ValidTo.ToString();
model.img_url = bllMall.GetImgUrl(cardCoupon.Logo);
model.discount = string.IsNullOrEmpty(cardCoupon.Ex1) ? 0 : double.Parse(cardCoupon.Ex1);
model.product_id = string.IsNullOrEmpty(cardCoupon.Ex2) ? 0 : double.Parse(cardCoupon.Ex2);
model.deductible_amount = string.IsNullOrEmpty(cardCoupon.Ex3) ? 0 : double.Parse(cardCoupon.Ex3);
model.freefreight_amount = string.IsNullOrEmpty(cardCoupon.Ex4) ? 0 : double.Parse(cardCoupon.Ex4);
model.buckle_amount = string.IsNullOrEmpty(cardCoupon.Ex5) ? 0 : double.Parse(cardCoupon.Ex5);
model.buckle_sub_amount = string.IsNullOrEmpty(cardCoupon.Ex6) ? 0 : double.Parse(cardCoupon.Ex6);
model.max_count = cardCoupon.MaxCount;
model.send_count = cardCoupon.SendCount;
model.un_send_count = cardCoupon.UnSendCount;
//model.is_recivece = bllCardCoupon.IsReciveCoupon(cardCoupon.CardId, CurrentUserInfo.UserID);
model.valid_to_timestamp = bllCardCoupon.GetTimeStamp((DateTime)cardCoupon.ValidTo);
model.limit_type = cardCoupon.Ex7;
model.product_tags = cardCoupon.Ex8;
model.user_get_limit_type = cardCoupon.GetLimitType;
model.is_can_use_shop = cardCoupon.IsCanUseShop;
model.is_can_use_groupbuy = cardCoupon.IsCanUseGroupbuy;
model.expire_time_type = cardCoupon.ExpireTimeType;
model.expire_day = cardCoupon.ExpireDay;
model.weixin_card_id = cardCoupon.WeixinCardId == null ? "" : cardCoupon.WeixinCardId;
if (!string.IsNullOrEmpty(myCardCouponId))
{
MyCardCoupons myCardCoupon = bllCardCoupon.GetMyCardCoupon(int.Parse(myCardCouponId));
if (myCardCoupon != null)
{
UserInfo fromUserInfo = bllUser.GetUserInfo(myCardCoupon.UserId);
if (fromUserInfo != null)
{
model.from_user_info = new UserInfoModel();
model.from_user_info.head_img_url = bllUser.GetUserDispalyAvatar(fromUserInfo);
model.from_user_info.nick_name = bllUser.GetUserDispalyName(fromUserInfo);
}
if (!string.IsNullOrEmpty(myCardCoupon.ToUserId))
{
model.is_donation = true;
}
}
}
resp.status = true;
resp.result = model;
context.Response.Write(JsonConvert.SerializeObject(resp));
}
/// <summary>
/// 获取奖品接口
/// </summary>
/// <param name="context"></param>
/// <returns></returns>
private string GetPrize(HttpContext context)
{
if (!bllUser.IsLogin)
{
resp.errcode = (int)APIErrCode.UserIsNotLogin;
resp.errmsg = "请先登录";
return(ZentCloud.Common.JSONHelper.ObjectToJson(resp));
}
else
{
currentUserInfo = bllUser.GetCurrentUserInfo();
}
VoteInfo voteInfo = bllVote.GetVoteInfo(voteId);//主投票信息
if (!string.IsNullOrEmpty(voteInfo.StopDate))
{
if (DateTime.Now > DateTime.Parse(voteInfo.StopDate))
{
VoteObjectInfo myInfo = bllVote.GetVoteObjectInfo(voteId, currentUserInfo.UserID);
if (myInfo == null)
{
resp.errcode = 1;
resp.errmsg = "未参加";
return(ZentCloud.Common.JSONHelper.ObjectToJson(resp));
}
if (myInfo.Ex1 == "1")//Ex1 表示是否已领奖
{
resp.errcode = 1;
resp.errmsg = "已领奖";
return(ZentCloud.Common.JSONHelper.ObjectToJson(resp));
}
if (myInfo.Rank == 1)
{
//领取奖品
ZentCloud.ZCBLLEngine.BLLTransaction tran = new ZCBLLEngine.BLLTransaction();
try
{
#region 获得积分
if (voteInfo.Ex1 == "0")//获得积分
{
if (string.IsNullOrEmpty(voteInfo.Ex2) && (int.Parse(voteInfo.Ex2) > 0))
{
int addScore = int.Parse(voteInfo.Ex2);//增加的积分
if (bllUser.Update(currentUserInfo, string.Format(" TotalScore+={0}", addScore), string.Format(" AutoID={0}", currentUserInfo.AutoID), tran) <= 0)
{
tran.Rollback();
resp.errcode = 1;
resp.errmsg = "更新用户积分失败";
return(ZentCloud.Common.JSONHelper.ObjectToJson(resp));
}
WBHScoreRecord scoreRecord = new WBHScoreRecord();
scoreRecord.InsertDate = DateTime.Now;
scoreRecord.NameStr = string.Format("参加今日我最美点赞,使用{0}积分", voteInfo.UseScore);
scoreRecord.RecordType = "1";
scoreRecord.ScoreNum = voteInfo.UseScore.ToString();
scoreRecord.UserId = currentUserInfo.UserID;
scoreRecord.WebsiteOwner = bllUser.WebsiteOwner;
if (!bllUser.Add(scoreRecord, tran))
{
tran.Rollback();
resp.errcode = 1;
resp.errmsg = "插入积分记录表失败";
return(ZentCloud.Common.JSONHelper.ObjectToJson(resp));
}
#region 增加yike 积分
if (bllCommRelation.ExistRelation(BLLJIMP.Enums.CommRelationType.SyncYike, bllCommRelation.WebsiteOwner, ""))
{
if (!string.IsNullOrEmpty(currentUserInfo.Phone))
{
yiKeClient.BonusUpdate(currentUserInfo.Ex2, (voteInfo.UseScore), "参加今日我最美获得积分" + voteInfo.UseScore);
}
}
#endregion
}
}
#endregion
#region 获得优惠券
if (voteInfo.Ex1 == "1")//获得积分
{
if (string.IsNullOrEmpty(voteInfo.Ex2) && (int.Parse(voteInfo.Ex2) > 0))
{
int cardCouponId = int.Parse(voteInfo.Ex2); //优惠券编号
CardCoupons cardCoupon = bllCardCoupon.GetCardCoupon(cardCouponId); //主卡券编号
MyCardCoupons myCard = new MyCardCoupons();
myCard.CardCouponNumber = string.Format("No.{0}{1}", DateTime.Now.ToString("yyyyMMdd"), new Random().Next(11111, 99999).ToString());
myCard.CardCouponType = cardCoupon.CardCouponType;
myCard.CardId = cardCouponId;
myCard.InsertDate = DateTime.Now;
myCard.UserId = currentUserInfo.UserID;
myCard.WebSiteOwner = bllUser.WebsiteOwner;
if (!bllCardCoupon.Add(myCard, tran))
{
tran.Rollback();
resp.errcode = 1;
resp.errmsg = "领取优惠券失败";
return(ZentCloud.Common.JSONHelper.ObjectToJson(resp));
}
}
}
#endregion
}
catch (Exception)
{
tran.Rollback();
resp.errcode = 1;
resp.errmsg = "领取失败";
return(ZentCloud.Common.JSONHelper.ObjectToJson(resp));
}
//最后更新选手领奖状态为已经领奖
myInfo.Ex1 = "1";
if (!bllVote.Update(myInfo))
{
tran.Rollback();
resp.errcode = 1;
resp.errmsg = "更新领奖状态失败";
return(ZentCloud.Common.JSONHelper.ObjectToJson(resp));
}
tran.Commit();
resp.errcode = 0;
resp.errmsg = voteInfo.Prize;
return(ZentCloud.Common.JSONHelper.ObjectToJson(resp));
}
}
else
{
resp.errcode = 1;
resp.errmsg = "还未到截止时间";
return(ZentCloud.Common.JSONHelper.ObjectToJson(resp));
}
}
resp.errcode = 1;
resp.errmsg = "";
return(ZentCloud.Common.JSONHelper.ObjectToJson(resp));
}
