public void ProcessRequest(HttpContext context)
{
if (CurrentUserInfo.IsLock == 1)
{
apiResp.code = (int)APIErrCode.NoPms;
apiResp.msg = "账号已被锁定";
bllUser.ContextResponse(context, apiResp);
return;
}
if (CurrentUserInfo.MemberApplyStatus != 9)
{
apiResp.code = (int)APIErrCode.NoPms;
apiResp.msg = "您的账号正在审核中";
bllUser.ContextResponse(context, apiResp);
return;
}
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;
}
decimal levelAmount = Convert.ToDecimal(levelConfig.FromHistoryScore);
if (CurrentUserInfo.TotalAmount < levelAmount)
{
apiResp.code = (int)APIErrCode.OperateFail;
apiResp.msg = string.Format("您的{0}不足", website.TotalAmountShowName);
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;
}
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, levelAmount, 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 消耗报单人金额
if (bllUser.AddScoreDetail(CurrentUserInfo.UserID, websiteOwner, (double)(0 - levelAmount),
string.Format("替{0}[{1}]注册{2}", regUser.TrueName, regUser.Phone, levelConfig.LevelString),
"TotalAmount", (double)(CurrentUserInfo.TotalAmount - levelAmount),
"", "替他人注册", "", "", (double)levelAmount, 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;
}
if (bllUser.Update(CurrentUserInfo, string.Format("TotalAmount=ISNULL(TotalAmount,0)-{0},AccountAmountEstimate=ISNULL(AccountAmountEstimate,0)-{0}", levelAmount),
string.Format("UserID='{0}' And WebsiteOwner='{1}' And TotalAmount-{2}>=0 ",
CurrentUserInfo.UserID, websiteOwner, levelAmount),
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(regUser.UserID, websiteOwner, (double)(levelAmount),
string.Format("{0}[{1}]转入", CurrentUserInfo.TrueName, CurrentUserInfo.Phone, (double)levelAmount),
"TotalAmount", (double)(levelAmount),
"", "他人注册转入", "", "", (double)levelAmount, 0, CurrentUserInfo.UserID,
tran, ex3: levelConfig.LevelNumber.ToString(), ex4: levelConfig.LevelString) <= 0)
{
tran.Rollback();
apiResp.msg = "他人注册转入记录出错";
apiResp.code = (int)APIErrCode.OperateFail;
bll.ContextResponse(context, apiResp);
return;
}
int mainDetailId = bllUser.AddScoreDetail(regUser.UserID, websiteOwner, (double)(0 - levelAmount),
string.Format("{0}[{1}]替您注册{2}", CurrentUserInfo.TrueName, CurrentUserInfo.Phone, levelConfig.LevelString),
"TotalAmount", 0,
"", "他人代替注册", "", "", (double)levelAmount, 0, CurrentUserInfo.UserID,
tran, ex3: levelConfig.LevelNumber.ToString(), ex4: levelConfig.LevelString);
if (mainDetailId <= 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 = levelAmount;
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);
}
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);
}
/// <summary>
/// 获取渠道下级订单
/// </summary>
/// <returns></returns>
private string QueryMyOrderChannel(HttpContext context)
{
int pageIndex = int.Parse(context.Request["PageIndex"]); //第几页
int pageSize = int.Parse(context.Request["PageSize"]); //每页记录数
int status = int.Parse(context.Request["Status"]); //分销订单状态
string level = context.Request["level"]; //1 直接销售
string autoId = context.Request["autoId"];
string channelUserId = bllDis.GetChannelUserId(currUserInfo);
if (!string.IsNullOrEmpty(autoId) && (currUserInfo.UserID == bllUser.WebsiteOwner || currUserInfo.UserType == 1) && (autoId != "0"))
{
status = -1;
pageSize = 20;
channelUserId = bllUser.GetUserInfoByAutoID(int.Parse(autoId)).UserID;
}
var channelUserInfo = bllUser.GetUserInfo(channelUserId);
List <WXMallOrderInfo> sourceData = new List <WXMallOrderInfo>();
if (string.IsNullOrEmpty(level))
{
sourceData = bllDis.GetChannelAllOrder(channelUserId, bllUser.WebsiteOwner);
}
else if (level == "1")
{
sourceData = bllDis.GetChannelAllFirstLevelOrder(channelUserId, bllUser.WebsiteOwner);
}
if (status != -1)
{
sourceData = sourceData.Where(p => p.DistributionStatus == status).ToList();
}
WebsiteInfo websiteInfo = bllDis.GetWebsiteInfoModelFromDataBase();
List <OrderModel> orderList = new List <OrderModel>();
var data = sourceData.Skip((pageIndex - 1) * pageSize).Take(pageSize).ToList();
foreach (WXMallOrderInfo item in data)
{
OrderModel order = new OrderModel();
#region 分销提成比例
#region 已分佣 提成比例及金额根据提成记录
if (item.DistributionStatus == 3)//已打佣金,分佣金额根据记录表去查
{
ProjectCommission projectCommission = bllDis.Get <ProjectCommission>(string.Format(" ProjectId='{0}' And UserId='{1}' And WebsiteOwner='{2}' ", item.OrderID, channelUserInfo.UserID, bllDis.WebsiteOwner));
if (projectCommission != null)
{
order.DistributionAmount = projectCommission.Amount;
order.DistributionRate = projectCommission.Rate.ToString();
order.TotalAmount = item.TotalAmount - item.Transport_Fee;
if (order.TotalAmount * (decimal.Parse(order.DistributionRate) / 100) != order.DistributionAmount)
{
order.DistributionRate = (Math.Round((order.DistributionAmount / order.TotalAmount), 3) * 100).ToString();
}
}
else
{
order.DistributionAmount = 0;
order.DistributionRate = "0";
}
}
#endregion
#region 还未分佣，根据预估分佣表
else
{
if (websiteInfo.IsDisabledCommission == 0)
{
//decimal rate = (decimal)bllDis.GetDistributionRateChannel(channelUserInfo);
//order.DistributionAmount = (rate / 100) * (item.TotalAmount - item.Transport_Fee);
//order.DistributionRate = rate.ToString();
//order.DistributionAmount = Math.Round(order.DistributionAmount, 2);
//if (order.DistributionAmount < 0)
//{
// order.DistributionAmount = 0;
//}
ProjectCommissionEstimate esti = bllDis.Get <ProjectCommissionEstimate>(string.Format("ProjectId={0} And ProjectType='DistributionOnLineChannel' And UserId='{1}' ", item.OrderID, channelUserInfo.UserID));
if (esti != null)
{
order.DistributionAmount = esti.Amount;
order.DistributionRate = esti.Rate.ToString();
}
else
{
order.DistributionRate = "0";
}
}
else
{
order.DistributionAmount = 0;
order.DistributionRate = "0";
}
}
#endregion
#endregion
order.DistributionStatus = item.DistributionStatus;
if (item.IsRefund == 1)
{
order.DistributionStatus = -1;
}
order.InsertDate = item.InsertDate.ToString("yyyy-MM-dd");
order.OrderID = item.OrderID;
order.ProductCount = item.ProductCount;
order.TotalAmount = item.TotalAmount - item.Transport_Fee;
order.ProductList = new List <WXMallProductInfo>();
//order.WXNickName = bllUser.GetUserInfo(item.OrderUserID).WXNickname;
UserInfo orderUserInfo = bllUser.GetUserInfo(item.OrderUserID);
if (orderUserInfo != null)
{
order.TrueName = orderUserInfo.TrueName;
order.Phone = orderUserInfo.Phone;
order.AutoID = orderUserInfo.AutoID;
order.WXNickName = orderUserInfo.WXNickname;
}
foreach (var orderdetail in bllMall.GetOrderDetailsList(item.OrderID))
{
var productInfo = bllMall.GetProduct(orderdetail.PID);
if (productInfo != null)
{
productInfo.PDescription = null;
productInfo.CategoryId = null;
productInfo.IP = 0;
productInfo.UserID = null;
productInfo.WebsiteOwner = null;
productInfo.Price = (decimal)orderdetail.OrderPrice;
productInfo.Stock = orderdetail.TotalCount;
order.ProductList.Add(productInfo);
}
}
order.OrderType = item.OrderType;
if (!string.IsNullOrEmpty(order.Remark))
{
order.Remark = item.OrderMemo.Replace("购买选项:", "<br/>购买选项:<br/>").Replace("金额:", "<br/>金额:");
}
orderList.Add(order);
}
return(Common.JSONHelper.ObjectToJson(orderList));
}
public void ProcessRequest(HttpContext context)
{
if (CurrentUserInfo.IsLock == 1)
{
apiResp.code = (int)APIErrCode.NoPms;
apiResp.msg = "账号已被锁定";
bllUser.ContextResponse(context, apiResp);
return;
}
if (CurrentUserInfo.MemberApplyStatus != 9)
{
apiResp.code = (int)APIErrCode.NoPms;
apiResp.msg = "您的账号正在审核中";
bllUser.ContextResponse(context, apiResp);
return;
}
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;
}
if (CurrentUserInfo.TotalAmount < requestUpgrade.amount)
{
apiResp.code = (int)APIErrCode.OperateFail;
apiResp.msg = string.Format("您的可用{0}不足", website.TotalAmountShowName);
bll.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);
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 修改金额 更新支付状态
if (BLLBase.ExecuteSql(string.Format("UPDATE ZCJ_UserInfo SET MemberLevel={0},IsDisable=0,MemberApplyStatus=9,TotalAmount=ISNULL(TotalAmount,0)-{3},AccountAmountEstimate=ISNULL(AccountAmountEstimate,0)-{3} FROM ZCJ_UserInfo WHERE UserID='{1}' And WebsiteOwner='{2}' And ISNULL(TotalAmount,0)-{3}>=0 ;",
requestUpgrade.toLevel, CurrentUserInfo.UserID, websiteOwner, requestUpgrade.amount),
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 + "升级" + 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);
}
/// <summary>
/// 获取我的下级订单
/// </summary>
/// <returns></returns>
private string QueryMyOrder(HttpContext context)
{
try
{
int pageIndex = int.Parse(context.Request["PageIndex"]); //第几页
int pageSize = int.Parse(context.Request["PageSize"]); //每页记录数
int level = int.Parse(context.Request["Level"]); //显示几级
int status = int.Parse(context.Request["Status"]); //分销订单状态
List <WXMallOrderInfo> sourceData = new List <WXMallOrderInfo>();
switch (status)
{
case 0:
sourceData = bllDis.GetOrderList(currUserInfo.UserID, level, BLLJIMP.BLLDistribution.DistributionStatus.NotPay);
break;
case 1:
sourceData = bllDis.GetOrderList(currUserInfo.UserID, level, BLLJIMP.BLLDistribution.DistributionStatus.Paied);
break;
case 2:
sourceData = bllDis.GetOrderList(currUserInfo.UserID, level, BLLJIMP.BLLDistribution.DistributionStatus.Received);
break;
case 3:
sourceData = bllDis.GetOrderList(currUserInfo.UserID, level, BLLJIMP.BLLDistribution.DistributionStatus.Verified);
break;
case 4:
sourceData = bllDis.GetOrderList(currUserInfo.UserID, level, BLLJIMP.BLLDistribution.DistributionStatus.Withdraw);
break;
default:
break;
}
if (level == 0)
{
sourceData = sourceData.Where(p => p.OrderUserID == currUserInfo.UserID).ToList();
}
else
{
sourceData = sourceData.Where(p => p.OrderUserID != currUserInfo.UserID).ToList();
}
WebsiteInfo websiteInfo = bllDis.GetWebsiteInfoModelFromDataBase();
List <OrderModel> orderList = new List <OrderModel>();
sourceData = sourceData.OrderByDescending(p => p.InsertDate).ToList();
var data = sourceData.Skip((pageIndex - 1) * pageSize).Take(pageSize).ToList();
foreach (WXMallOrderInfo item in data)
{
OrderModel order = new OrderModel();
#region 分销提成比例
#region 已分佣 提成比例及金额根据提成记录
if (item.DistributionStatus == 3)//已打佣金,分佣金额根据记录表去查
{
ProjectCommission projectCommission = bllDis.Get <ProjectCommission>(string.Format(" ProjectId='{0}' And UserId='{1}' And WebsiteOwner='{2}' And ProjectType='DistributionOnLine'", item.OrderID, currUserInfo.UserID, bllDis.WebsiteOwner));
if (projectCommission != null)
{
order.DistributionAmount = projectCommission.Amount;
order.DistributionRate = projectCommission.Rate.ToString();
order.TotalAmount = item.TotalAmount - item.Transport_Fee;
if (order.TotalAmount * (decimal.Parse(order.DistributionRate) / 100) != order.DistributionAmount)
{
order.DistributionRate = (Math.Round((order.DistributionAmount / order.TotalAmount), 3) * 100).ToString();
}
}
else
{
order.DistributionAmount = 0;
order.DistributionRate = "0";
}
}
#endregion
#region 还未分佣，根据预估分佣表
else
{
if (websiteInfo.IsDisabledCommission == 0)//分佣
{
// UserLevelConfig userLevel = bllDis.GetUserLevel(currUserInfo);
//bool isFirst = bllDis.IsFirstOrder(item);
switch (level)
{
case 0:
//decimal rate = (decimal)bllDis.GetDistributionRate(currUserInfo, 0, isFirst);//直销提成比例
//order.DistributionAmount = bllDis.GetUserCommission(item, currUserInfo, 0);
//order.DistributionRate = rate.ToString();
ProjectCommissionEstimate esti = bllDis.Get <ProjectCommissionEstimate>(string.Format("ProjectId={0} And ProjectType='DistributionOnLine' And UserId='{1}' ", item.OrderID, currUserInfo.UserID));
if (esti != null)
{
order.DistributionAmount = esti.Amount;
order.DistributionRate = esti.Rate.ToString();
}
else
{
order.DistributionRate = "0";
}
break;
case 1:
// var upUserLevel1 = bllDis.GetUpUser(item.OrderUserID, 1);
//var orderUser = bllUser.GetUserInfo(item.OrderUserID);
// decimal rateLevel1 = (decimal)bllDis.GetDistributionRate(currUserInfo, 1, isFirst);
//order.DistributionAmount = bllDis.GetUserCommission(item, currUserInfo, 1);
// order.DistributionRate = rateLevel1.ToString();
ProjectCommissionEstimate estiUpLevel = bllDis.Get <ProjectCommissionEstimate>(string.Format("ProjectId={0} And ProjectType='DistributionOnLine' And UserId='{1}' ", item.OrderID, currUserInfo.UserID));
if (estiUpLevel != null)
{
order.DistributionAmount = estiUpLevel.Amount;
order.DistributionRate = estiUpLevel.Rate.ToString();
}
else
{
order.DistributionRate = "0";
}
break;
//case 2:
// order.DistributionAmount = (decimal.Parse(userLevel.DistributionRateLevel2) / 100) * (item.TotalAmount - item.Transport_Fee);
// order.DistributionRate = userLevel.DistributionRateLevel2;
// break;
//case 3:
// order.DistributionAmount = (decimal.Parse(userLevel.DistributionRateLevel3) / 100) * item.TotalAmount;
// order.DistributionRate = userLevel.DistributionRateLevel3;
// break;
default:
break;
}
//order.DistributionAmount = Math.Round(order.DistributionAmount, 2);
}
else//不分佣
{
order.DistributionAmount = 0;
order.DistributionRate = "0";
}
}
#endregion
#endregion
order.DistributionStatus = item.DistributionStatus;
if (item.IsRefund == 1)
{
order.DistributionStatus = -1;
}
order.InsertDate = item.InsertDate.ToString("yyyy-MM-dd");
order.OrderID = item.OrderID;
order.ProductCount = item.ProductCount;
order.TotalAmount = item.TotalAmount - item.Transport_Fee;
order.ProductList = new List <WXMallProductInfo>();
//order.WXNickName = bllUser.GetUserInfo(item.OrderUserID).WXNickname;
UserInfo orderUserInfo = bllUser.GetUserInfo(item.OrderUserID);
if (orderUserInfo != null)
{
order.TrueName = orderUserInfo.TrueName;
order.Phone = orderUserInfo.Phone;
order.AutoID = orderUserInfo.AutoID;
order.WXNickName = orderUserInfo.WXNickname;
}
foreach (var orderdetail in bllMall.GetOrderDetailsList(item.OrderID))
{
var productInfo = bllMall.GetProduct(orderdetail.PID);
if (productInfo != null)
{
productInfo.PDescription = null;
productInfo.CategoryId = null;
productInfo.IP = 0;
productInfo.UserID = null;
productInfo.WebsiteOwner = null;
productInfo.Price = (decimal)orderdetail.OrderPrice;
productInfo.Stock = orderdetail.TotalCount;
order.ProductList.Add(productInfo);
}
}
order.OrderType = item.OrderType;
if (!string.IsNullOrEmpty(order.Remark))
{
order.Remark = item.OrderMemo.Replace("购买选项:", "<br/>购买选项:<br/>").Replace("金额:", "<br/>金额:");
}
orderList.Add(order);
}
return(Common.JSONHelper.ObjectToJson(orderList));
}
catch (Exception ex)
{
return(ex.ToString());
}
}
