/// <summary> /// 得到会员的直荐名单 /// </summary> /// <param name="ID"></param> /// <returns></returns> public List <ReMemberRelationModel> GetRecommdMemberModel(int rmid) { List <ReMemberRelationModel> list = new List <ReMemberRelationModel>(); StringBuilder strSql = new StringBuilder(); strSql.Append("select ID, MemberID, MemberPhone, MemberTruthName, RecommMID, RecommMPhone, RecommMTruthName, RStatus, AddTime "); strSql.Append(" from ReMemberRelation "); strSql.Append(" where RecommMID=@rmid"); SqlParameter[] parameters = { new SqlParameter("@rmid", SqlDbType.Int) }; parameters[0].Value = rmid; DataSet ds = helper.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { foreach (DataRow item in ds.Tables[0].Rows) { ReMemberRelationModel model = new ReMemberRelationModel(); if (item["ID"].ToString() != "") { model.ID = int.Parse(item["ID"].ToString()); } if (item["MemberID"].ToString() != "") { model.MemberID = int.Parse(item["MemberID"].ToString()); } model.MemberPhone = item["MemberPhone"].ToString(); model.MemberTruthName = item["MemberTruthName"].ToString(); if (item["RecommMID"].ToString() != "") { model.RecommMID = int.Parse(item["RecommMID"].ToString()); } model.RecommMPhone = item["RecommMPhone"].ToString(); model.RecommMTruthName = item["RecommMTruthName"].ToString(); if (item["RStatus"].ToString() != "") { model.RStatus = int.Parse(item["RStatus"].ToString()); } if (item["AddTime"].ToString() != "") { model.AddTime = DateTime.Parse(item["AddTime"].ToString()); } list.Add(model); } return(list); } else { return(null); } }
/// <summary> /// 按照会员ID查找被推荐人列表 /// </summary> /// <param name="recommmid"></param> /// <returns></returns> public static List <ReMemberRelationModel> GetReMemberRelationList(string memberids) { StringBuilder strSql = new StringBuilder(); strSql.Append("select ID, MemberID, MemberPhone, MemberTruthName, RecommMID, RecommMPhone, RecommMTruthName, RStatus, AddTime "); strSql.Append(" from ReMemberRelation "); strSql.Append(" where MemberID in (" + memberids.TrimEnd(',') + ")"); List <ReMemberRelationModel> list = new List <ReMemberRelationModel>(); DataSet ds = helper.Query(strSql.ToString()); if (ds.Tables[0].Rows.Count > 0) { foreach (DataRow item in ds.Tables[0].Rows) { ReMemberRelationModel model = new ReMemberRelationModel(); if (item["ID"].ToString() != "") { model.ID = int.Parse(item["ID"].ToString()); } if (item["MemberID"].ToString() != "") { model.MemberID = int.Parse(item["MemberID"].ToString()); } model.MemberPhone = item["MemberPhone"].ToString(); model.MemberTruthName = item["MemberTruthName"].ToString(); if (item["RecommMID"].ToString() != "") { model.RecommMID = int.Parse(item["RecommMID"].ToString()); } model.RecommMPhone = item["RecommMPhone"].ToString(); model.RecommMTruthName = item["RecommMTruthName"].ToString(); if (item["RStatus"].ToString() != "") { model.RStatus = int.Parse(item["RStatus"].ToString()); } if (item["AddTime"].ToString() != "") { model.AddTime = DateTime.Parse(item["AddTime"].ToString()); } list.Add(model); } return(list); } else { return(null); } }
/// <summary> /// 添加会员推荐关系 /// </summary> /// <param name="model"></param> /// <returns></returns> public static int AddReMemberRelation(ReMemberRelationModel model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into ReMemberRelation("); strSql.Append("MemberID,MemberPhone,MemberTruthName,RecommMID,RecommMPhone,RecommMTruthName,RStatus,AddTime"); strSql.Append(") values ("); strSql.Append("@MemberID,@MemberPhone,@MemberTruthName,@RecommMID,@RecommMPhone,@RecommMTruthName,1,GETDATE()"); strSql.Append(") "); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@MemberID", SqlDbType.Int), new SqlParameter("@MemberPhone", SqlDbType.NVarChar), new SqlParameter("@MemberTruthName", SqlDbType.NVarChar), new SqlParameter("@RecommMID", SqlDbType.Int), new SqlParameter("@RecommMPhone", SqlDbType.NVarChar), new SqlParameter("@RecommMTruthName", SqlDbType.NVarChar) }; parameters[0].Value = model.MemberID; parameters[1].Value = model.MemberPhone; parameters[2].Value = model.MemberTruthName; parameters[3].Value = model.RecommMID; parameters[4].Value = model.RecommMPhone; parameters[5].Value = model.RecommMTruthName; object obj = helper.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> ///注册会员(已追加注册返还金额功能) /// </summary> public string AddMemberInfo(MemberInfoModel model) { string result = "1"; string value = SysAdminConfigDAL.GetConfigsByID(4);//得到注册返还金额 #region 验证用户真实姓名 和手机 int rows = MemberInfoDAL.GetMemberCountInfoByName(model.TruethName.Trim()); if (rows > 2) { return("0用户姓名重复"); } rows = MemberInfoDAL.GetMemberCountInfoByMobile(model.MobileNum.Trim()); if (rows > 0) { return("0手机号已被注册"); } //rows = MemberInfoDAL.GetMemberCountInfoByAlipayNum(model.AliPayNum.Trim()); //if (rows > 0) //{ // return "0支付宝ID已被注册"; //} rows = MemberInfoDAL.GetMemberCountInfoByAliPayName(model.AliPayName.Trim()); if (rows > 0) { return("0支付宝账户已被注册"); } #endregion using (TransactionScope scope = new TransactionScope()) { int memberid = dal.AddMemberInfo(model); if (memberid < 1) { return("0注册失败"); } decimal amont = 0; if (!string.IsNullOrWhiteSpace(value)) { if (!decimal.TryParse(value, out amont)) { return("0注册失败"); } int row = MemberCapitalDetailDAL.UpdateMemberStaticFreezeMoney(memberid, amont, model.TruethName, model.MobileNum); if (row < 1) { return("0注册失败"); } } //返还激活码金额 AmountChangeLogModel logmodel = new AmountChangeLogModel(); logmodel.MemberID = memberid; logmodel.MemberName = model.TruethName; logmodel.MemberPhone = model.MobileNum; logmodel.ProduceMoney = amont; logmodel.Remark = "会员注册激活码" + amont.ToString() + "元"; logmodel.Type = 5; int rowcount = OperateLogDAL.AddAmountChangeLog(logmodel); if (rowcount < 1) { return("0注册失败"); } if (model.MemberPhone != model.MobileNum) { //插入推荐人信息表 MemberInfoModel soucemember = MemberInfoDAL.GetMember(model.MemberPhone); if (soucemember.MStatus == 3) { return("0推荐人账户被冻结"); } ReMemberRelationModel remodel = new ReMemberRelationModel(); remodel.MemberID = soucemember.ID; remodel.MemberTruthName = soucemember.TruethName; remodel.MemberPhone = soucemember.MobileNum; remodel.RecommMID = memberid; remodel.RecommMPhone = model.MobileNum; remodel.RecommMTruthName = model.TruethName; rowcount = ReMemberRelationDAL.AddReMemberRelation(remodel); if (rowcount < 1) { return("0注册失败"); } } //初始化会员扩展信息表 MemberExtendInfoModel extendinfo = new MemberExtendInfoModel(); extendinfo.MemberID = memberid; extendinfo.MemberHelpCount = 0; extendinfo.LastHelpMoney = 0; extendinfo.LastHelperTime = DateTime.Now.AddYears(-1); rowcount = MemberExtendInfoDAL.AddModelExtendinfo(extendinfo); if (rowcount < 1) { return("0注册失败"); } scope.Complete(); result = "1"; } return(result); }
/// <summary> /// 按照被推荐的会员ID查找推荐人 /// </summary> /// <param name="recommmid"></param> /// <returns></returns> public static ReMemberRelationModel GetReMemberRelation(int recommmid) { string sqltxt = @"SELECT ID , A.MemberID , MemberPhone , MemberTruthName , RecommMID , RecommMPhone , RecommMTruthName , RStatus , AddTime, B.LastHelpMoney FROM ReMemberRelation A INNER JOIN dbo.MemberExtendInfo B ON A.MemberID=B.MemberID WHERE RecommMID = @RecommMID"; SqlParameter[] parameters = { new SqlParameter("@RecommMID", SqlDbType.Int) }; parameters[0].Value = recommmid; ReMemberRelationModel model = new ReMemberRelationModel(); DataSet ds = helper.Query(sqltxt, parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["ID"].ToString() != "") { model.ID = int.Parse(ds.Tables[0].Rows[0]["ID"].ToString()); } if (ds.Tables[0].Rows[0]["MemberID"].ToString() != "") { model.MemberID = int.Parse(ds.Tables[0].Rows[0]["MemberID"].ToString()); } model.MemberPhone = ds.Tables[0].Rows[0]["MemberPhone"].ToString(); model.MemberTruthName = ds.Tables[0].Rows[0]["MemberTruthName"].ToString(); if (ds.Tables[0].Rows[0]["RecommMID"].ToString() != "") { model.RecommMID = int.Parse(ds.Tables[0].Rows[0]["RecommMID"].ToString()); } model.RecommMPhone = ds.Tables[0].Rows[0]["RecommMPhone"].ToString(); model.RecommMTruthName = ds.Tables[0].Rows[0]["RecommMTruthName"].ToString(); if (ds.Tables[0].Rows[0]["RStatus"].ToString() != "") { model.RStatus = int.Parse(ds.Tables[0].Rows[0]["RStatus"].ToString()); } if (ds.Tables[0].Rows[0]["AddTime"].ToString() != "") { model.AddTime = DateTime.Parse(ds.Tables[0].Rows[0]["AddTime"].ToString()); } if (ds.Tables[0].Rows[0]["LastHelpMoney"].ToString() != "") { model.Amount = ds.Tables[0].Rows[0]["LastHelpMoney"].ToString().ParseToDecimal(0); } return(model); } else { return(null); } }
/// <summary> /// 添加一条提供帮助单据 /// </summary> public string AddHelpeOrder(HelpeOrderModel model) { string result = "0"; string minhelpamont = SystemConfigs.GetminHelpAmont(); //得到最小的提供帮助限制 string maxhelpamont = SystemConfigs.GetmaxHelpAmont(); //得到最大的提供帮助限制 string interest = SysAdminConfigDAL.GetConfigsByID(5); //得到排单后的利率 string inteistlist = SysAdminConfigDAL.GetConfigsByID(11); //得到领导奖利率 decimal reinteist = SysAdminConfigDAL.GetConfigsByID(16).ParseToDecimal(10); //得到首次推荐的利率 decimal maxcount = SysAdminConfigDAL.GetConfigsByID(17).ParseToInt(1); //得到每日最大排单数 MemberExtendInfoModel meinfo = MemberExtendInfoDAL.GetMemberExtendInfo(model.MemberID); int helpcount = HelpeOrderDAL.GetTodayHelpCount(model.MemberID); if (model.Amount < minhelpamont.ParseToDecimal(0)) { return("0超出了平台规定的最小规定值"); } if (model.Amount > maxhelpamont.ParseToDecimal(0)) { return("0超出了平台规定的最大规定值"); } if (helpcount >= maxcount) { return("0今天已经提供过帮助"); } bool isfirst = false;//默认不是第一次 if (meinfo == null) { isfirst = true; } else { isfirst = meinfo.MemberHelpCount == 0; } if (string.IsNullOrWhiteSpace(model.ActiveCode)) { return("0没有填写排单币"); } ActiveCodeModel activemodel = ActiveCodeDAL.GetActiveCodeExtendModel(model.ActiveCode); if (activemodel == null)//没有该激活码信息为失败 { return("0排单币无效"); } if (activemodel.AStatus == 10)//改激活码已使用为失败 { return("0排单币已经被使用"); } if (model.Amount % 100 > 0) { return("0提供金额应为100的整数倍"); } ReMemberRelationModel remember = ReMemberRelationDAL.GetReMemberRelation(model.MemberID); using (TransactionScope scope = new TransactionScope()) { //更改激活码的使用状态 int rowcount = ActiveCodeDAL.UpdateStatus(activemodel.ID, 10); if (rowcount < 1) { return("0操作失败"); } rowcount = ActiveCodeDAL.UpdateMemberActiveToUse(model.MemberID, model.OrderCode, model.ActiveCode); if (rowcount < 1) { return("0操作失败"); } //插入激活码的使用日志 ActiveCodeLogModel aclogmodel = new ActiveCodeLogModel(); aclogmodel.ActiveCode = model.ActiveCode; aclogmodel.AID = model.ActiveCodeID; aclogmodel.MemberID = model.MemberID; aclogmodel.MemberName = model.MemberName; aclogmodel.MemberPhone = model.MemberPhone; aclogmodel.Remark = "会员:" + model.MemberName + " 使用排单币:" + model.ActiveCode + " 进行排单"; rowcount = OperateLogDAL.AddActiveCodeLog(aclogmodel); if (rowcount < 1) { return("0操作失败"); } //更改会员的资金信息和利率 decimal dinterest = 1; if (!string.IsNullOrWhiteSpace(interest)) { if (!decimal.TryParse(interest, out dinterest)) { return("0操作失败"); } } //rowcount = MemberCapitalDetailDAL.UpdateMemberStaticCapital(model.MemberID, model.Amount, dinterest,model.MemberName,model.MemberPhone); rowcount = MemberCapitalDetailDAL.UpdateMemberStaticFreezeMoneyAndinster(model.MemberID, model.Amount, dinterest, model.MemberName, model.MemberPhone); if (rowcount < 1) { return("0操作失败"); } //插入表记录 model.IsFristOrder = isfirst ? 1 : 0; int orderid = dal.AddHelpeOrder(model); if (orderid < 1) { return("0操作失败"); } //更新会员的统计信息 rowcount = MemberExtendInfoDAL.Update(model.MemberID, model.Amount); if (rowcount < 1) { return("0操作失败"); } //插入会员的资金变动纪录 AmountChangeLogModel logmodel = new AmountChangeLogModel(); logmodel.MemberID = model.MemberID; logmodel.MemberName = model.MemberName; logmodel.MemberPhone = model.MemberPhone; logmodel.OrderCode = model.OrderCode; logmodel.OrderID = orderid; logmodel.ProduceMoney = model.Amount; logmodel.Remark = "会员:" + model.MemberPhone + " 申请提供帮助 " + model.Amount.ToString() + "元"; logmodel.Type = 1; rowcount = OperateLogDAL.AddAmountChangeLog(logmodel); if (rowcount < 1) { return("0操作失败"); } //为推荐人添加领导奖 rowcount = MemberCapitalDetailDAL.PaymentLeaderPrize(model.MemberID, model.Amount, inteistlist, model.OrderCode, orderid); if (rowcount < 1) { return("0操作失败"); } //若此会员第一次排单,则给推荐人奖励 if (isfirst) { rowcount = MemberCapitalDetailDAL.UpdateMemberDynamicFreezeMoney(remember.MemberID, (model.Amount * reinteist / 100), remember.MemberTruthName, remember.MemberPhone); if (rowcount < 1) { return("0操作失败"); } LeaderAmountModel leadermodel = new LeaderAmountModel();//插入领导奖记录 leadermodel.OrderID = orderid; leadermodel.OrderCode = model.OrderCode; leadermodel.MemberPhone = remember.MemberPhone; leadermodel.MemberName = remember.MemberTruthName; leadermodel.MemberID = remember.MemberID; leadermodel.LType = 1; leadermodel.Amount = (model.Amount * reinteist / 100); rowcount = MemberCapitalDetailDAL.AddLeaderAmount(leadermodel); if (rowcount < 1) { return("0操作失败"); } AmountChangeLogModel logmodel1 = new AmountChangeLogModel(); logmodel1.MemberID = remember.MemberID; logmodel1.MemberName = remember.MemberTruthName; logmodel1.MemberPhone = remember.MemberPhone; logmodel1.OrderCode = model.OrderCode; logmodel1.OrderID = orderid; logmodel1.ProduceMoney = (model.Amount * reinteist / 100); logmodel1.Remark = "会员:" + remember.MemberPhone + " 得到来自 " + model.MemberPhone + "的首单推荐奖(已冻结)" + (model.Amount * reinteist / 100).ToString() + "元"; logmodel1.Type = 3; rowcount = OperateLogDAL.AddAmountChangeLog(logmodel1); if (rowcount < 1) { return("0操作失败"); } } try { UserBehaviorLogModel log = new UserBehaviorLogModel(); log.AOrderCode = ""; log.BehaviorSource = 1; log.BehaviorType = 2; log.HOrderCode = model.OrderCode; log.MemberID = model.MemberID; log.MemberName = model.MemberName; log.MemberPhone = model.MemberPhone; log.ProcAmount = model.Amount; log.Remark = "会员:" + model.MemberPhone + "提供帮助单号为:" + model.OrderCode; rowcount = UserBehaviorLogDAL.AddUserBehaviorLog(log); } catch { } scope.Complete(); result = "1"; } return(result); }
/// <summary> /// 更新状态为已完成 /// </summary> /// <returns></returns> public int UpdateSingleOrderToComplete(int aid, int hid) { int result = 0; //List<MatchOrderModel> matchorders = MatchOrderDAL.GetMatchOrderInfo(0, aid); HelpeOrderModel helporder = HelpeOrderDAL.GetHelpOrderInfo(hid); //查询提供帮助的单据 AcceptHelpOrderModel accorder = AcceptHelpOrderDAL.GetAcceptOrderInfo(aid); //查询接受单据的信息 List <MatchOrderModel> matchinfo = MatchOrderDAL.GetMatchOrderInfo(hid, aid); //单据的匹配信息 string value = SysAdminConfigDAL.GetConfigsByID(4); //得到注册返还金额 string scvalue = SysAdminConfigDAL.GetConfigsByID(6); //得到注册返还金额 string inteistlist = SysAdminConfigDAL.GetConfigsByID(11); //得到领导奖利率 int day = SysAdminConfigDAL.GetConfigsByID(22).ParseToInt(20); //得到领导奖推荐奖冻结天数 string inteist = SysAdminConfigDAL.GetConfigsByID(7); //得到打款后利率 using (TransactionScope scope = new TransactionScope()) { //更改当前的接受单据状态和完成金额 int rowcount = AcceptHelpOrderDAL.UpdateStatusAndMoneyToComplete(aid, matchinfo[0].MatchedMoney); if (rowcount < 1) { return(0); } //更改匹配信息 rowcount = MatchOrderDAL.UpdateStatusToComplete(hid, aid); if (rowcount < 1) { return(0); } //更改匹配的提供帮助订单的状态 rowcount = HelpeOrderDAL.UpdateStatusForCompleteV1(helporder.ID, matchinfo[0].MatchedMoney); if (rowcount < 1) { return(0); } decimal diffamount = (helporder.Amount - helporder.PayedAmount - matchinfo[0].MatchedMoney); if (diffamount == 0) { //返还匹配会员的静态冻结资金和利息 rowcount = MemberCapitalDetailDAL.UpdateStaticInterestAndStaticFreezeMoney(helporder.MemberID, helporder.Amount, helporder.Interest); if (rowcount < 1) { return(0); } //更改单据利率为高利率 rowcount = HelpeOrderDAL.UpdateCurrentInterest(hid, inteist.ParseToInt(2)); if (rowcount < 1) { return(0); } //更改该单据的利息为0 rowcount = HelpeOrderDAL.UpdateHelperOrderClearInterest(helporder.ID); if (rowcount < 1) { return(0); } //返还推荐奖 if (helporder.IsFristOrder == 1 && helporder.IsRecommendBack == 0) { decimal inster = SysAdminConfigDAL.GetConfigsByID(16).ParseToInt(10);//得到首次推荐的利率 decimal money = helporder.Amount * inster / 100; ReMemberRelationModel model = ReMemberRelationDAL.GetReMemberRelation(helporder.MemberID); if (day == 0)//若为0,则当时返还 { //返还推荐奖 rowcount = MemberCapitalDetailDAL.UpdateDynamicInterestForComplete(model.MemberID, money); if (rowcount < 1) { return(0); } AmountChangeLogModel logmodel = new AmountChangeLogModel(); logmodel.MemberID = model.MemberID; logmodel.MemberName = model.MemberTruthName; logmodel.MemberPhone = model.MemberPhone; logmodel.OrderCode = helporder.OrderCode; logmodel.OrderID = helporder.ID; logmodel.ProduceMoney = money; logmodel.Remark = "会员:" + model.MemberPhone + " 得到来自单据:" + helporder.OrderCode + "的推荐奖"; logmodel.Type = 3; rowcount = OperateLogDAL.AddAmountChangeLog(logmodel); if (rowcount < 1) { return(result); } } else { //返还推荐奖到待返还列表 WaitFreeLeaderAmountModel waitfreemodel = new WaitFreeLeaderAmountModel(); waitfreemodel.MemberID = model.MemberID; waitfreemodel.MemberName = model.MemberTruthName; waitfreemodel.MemberPhone = model.MemberPhone; waitfreemodel.Amount = money; waitfreemodel.AStatus = 1; waitfreemodel.TheoryFreeTime = DateTime.Now.AddDays(day); waitfreemodel.Type = 2; waitfreemodel.OrderCode = helporder.OrderCode; waitfreemodel.OrderID = helporder.ID; rowcount = MemberCapitalDetailDAL.AddWaitFreeMoney(waitfreemodel); if (rowcount < 1) { return(0); } } //返还激活码的钱 rowcount = MemberCapitalDetailDAL.UpdateStaticFreezeMoneyForReiger(helporder.MemberID, value.ParseToDecimal(0)); //更改单据为已经派发推荐奖 rowcount = HelpeOrderDAL.UpdateHelperOrderIsRecommendBack(helporder.ID); } if (helporder.IsLeaderBack == 0) { if (day == 0) { //返还领导奖 rowcount = MemberCapitalDetailDAL.PaymentLeaderPrizeForComplete(helporder.MemberID, inteistlist, helporder.OrderCode, helporder.ID); } else { //返还领导奖到待返还列表 rowcount = MemberCapitalDetailDAL.PaymentLeaderPrizeForComplete(helporder.MemberID, inteistlist, helporder.OrderCode, helporder.ID, day); } //更新单据状态 rowcount = HelpeOrderDAL.UpdateHelperOrderIsLeaderBack(helporder.ID); } //返还该单据排单币的金额 if (helporder.SchedulingAmount == 0) { rowcount = MemberCapitalDetailDAL.UpdateMemberStaticCapital(helporder.MemberID, scvalue.ParseToDecimal(0), helporder.MemberName, helporder.MemberPhone); if (rowcount < 1) { return(0); } rowcount = HelpeOrderDAL.UpdateHelperOrderIsRecommendBack(helporder.ID, scvalue.ParseToDecimal(0));//更新单据的排单币金额 if (rowcount < 1) { return(0); } AmountChangeLogModel logmodel = new AmountChangeLogModel(); logmodel.MemberID = helporder.MemberID; logmodel.MemberName = helporder.MemberName; logmodel.MemberPhone = helporder.MemberPhone; logmodel.OrderCode = helporder.OrderCode; logmodel.OrderID = helporder.ID; logmodel.ProduceMoney = scvalue.ParseToDecimal(0); logmodel.Remark = "会员:" + helporder.MemberPhone + " 打款完成,返还排单币" + scvalue + "元"; logmodel.Type = 5; rowcount = OperateLogDAL.AddAmountChangeLog(logmodel); if (rowcount < 1) { return(0); } } } try { UserBehaviorLogModel log = new UserBehaviorLogModel(); log.AOrderCode = accorder.OrderCode; log.BehaviorSource = 1; log.BehaviorType = 5; log.HOrderCode = helporder.OrderCode; log.MemberID = accorder.MemberID; log.MemberName = accorder.MemberName; log.MemberPhone = accorder.MemberPhone; log.ProcAmount = matchinfo[0].MatchedMoney; log.Remark = "会员:" + accorder.MemberPhone + "为单据" + accorder.OrderCode + "确认收款"; rowcount = UserBehaviorLogDAL.AddUserBehaviorLog(log); } catch { } scope.Complete(); result = 1; } return(result); }
/// <summary> /// 更新状态为已完成(遗弃) /// </summary> /// <returns></returns> public int UpdateStatusToComplete(int aid) { int result = 0; //List<MatchOrderModel> matchorders = MatchOrderDAL.GetMatchOrderInfo(0, aid); List <HelpeOrderModel> matchorderlist = MatchOrderDAL.GetMatchHelpOrderByAid(aid); string value = SysAdminConfigDAL.GetConfigsByID(4); //得到注册返还金额 string inteistlist = SysAdminConfigDAL.GetConfigsByID(11); //得到领导奖利率 using (TransactionScope scope = new TransactionScope()) { //更改当前的状态 int rowcount = AcceptHelpOrderDAL.UpdateStatusToComplete(aid); if (rowcount < 1) { return(0); } //更改匹配的提供帮助订单的状态 #region 注释 //foreach (var item in matchorders) //{ // rowcount = HelpeOrderDAL.UpdateStatusForComplete(item.HelperOrderID); // if (rowcount < 1) // { // return 0; // } // HelpeOrderModel order = HelpeOrderDAL.GetHelpOrderInfo(item.HelperOrderID); // //解冻会员的静态冻结资金 // rowcount = MemberCapitalDetailDAL.UpdateStaticThawDetail(order.MemberID); // if (rowcount < 1) // { // return 0; // } // //插入会员的资金变动记录 // AmountChangeLogModel logmodel = new AmountChangeLogModel(); // logmodel.MemberID = order.MemberID; // logmodel.MemberName = order.MemberName; // logmodel.MemberPhone = order.MemberPhone; // logmodel.OrderCode = order.OrderCode; // logmodel.OrderID = item.HelperOrderID; // logmodel.ProduceMoney = 0; // logmodel.Remark = "会员:" + order.MemberPhone + " 所有冻结资金解冻"; // logmodel.Type = 5; // rowcount = OperateLogDAL.AddAmountChangeLog(logmodel); // if (rowcount < 1) // { // return 0; // } //} #endregion foreach (var item in matchorderlist) { rowcount = HelpeOrderDAL.UpdateStatusForComplete(item.ID); if (rowcount < 1) { return(0); } if (item.DiffAmount == 0) { //返还匹配会员的静态冻结资金和利息 rowcount = MemberCapitalDetailDAL.UpdateStaticInterestAndStaticFreezeMoney(item.MemberID, item.Amount, item.Interest); if (rowcount < 1) { return(0); } //返还推荐奖 if (item.IsFristOrder == 1) { decimal inster = SysAdminConfigDAL.GetConfigsByID(16).ParseToInt(10);//得到首次推荐的利率 decimal money = item.Amount * inster / 100; ReMemberRelationModel model = ReMemberRelationDAL.GetReMemberRelation(item.ID); rowcount = MemberCapitalDetailDAL.UpdateDynamicInterestForComplete(model.MemberID, money); if (rowcount < 1) { return(0); } rowcount = MemberCapitalDetailDAL.UpdateStaticFreezeMoneyForReiger(item.MemberID, value.ParseToDecimal(0)); } //返还领导奖 rowcount = MemberCapitalDetailDAL.PaymentLeaderPrizeForComplete(item.MemberID, inteistlist, item.OrderCode, item.ID); } } scope.Complete(); result = 1; } return(result); }