public ActionResult behaviorloglist(UserBehaviorLogModel seachmodel, int page = 1) { behaviorloglistViewModel model = new behaviorloglistViewModel(); int totalrowcount = 0; UserBehaviorLogModel seach = new UserBehaviorLogModel(); seach.PageIndex = page; seach.PageSize = PageSize; seach.BehaviorType = seachmodel.BehaviorType; seach.MemberName = seachmodel.MemberName; seach.MemberPhone = seachmodel.MemberPhone; List <UserBehaviorLogModel> list = logbll.GetUserBehaviorLogByPage(seach, out totalrowcount); PagedList <UserBehaviorLogModel> pagelist = null; if (list.Count > 0) { pagelist = new PagedList <UserBehaviorLogModel>(list, page, PageSize, totalrowcount); } model.currentpage = page; model.list = pagelist; model.pagesize = PageSize; model.totalcount = totalrowcount; ViewBag.PageTitle = "操作日志"; this.ViewData["seachmodel.BehaviorType"] = GetBehaviorTypeListItem(1); return(View(model)); }
/// <summary> /// 惩罚会员静态金额 /// </summary> /// <param name="memberphone"></param> /// <param name="money"></param> /// <returns></returns> public string punishmentStaticMoney(int memberid, decimal money, string reason) { string result = "0"; MemberInfoModel member = MemberInfoDAL.GetMember(memberid); if (member == null) { return("0无此会员"); } using (TransactionScope scope = new TransactionScope()) { int rowcount = MemberCapitalDetailDAL.UpdateStaticPunishMoney(member.ID, money, member.TruethName, member.MobileNum); if (rowcount < 1) { return("0操作失败"); } AmountChangeLogModel logmodel = new AmountChangeLogModel(); logmodel.MemberID = member.ID; logmodel.MemberName = member.TruethName; logmodel.MemberPhone = member.MobileNum; logmodel.OrderCode = ""; logmodel.OrderID = 0; logmodel.ProduceMoney = (0 - money); logmodel.Remark = "会员:" + member.MobileNum + " 被平台惩罚:" + money.ToString() + " 元,原因:" + reason; logmodel.Type = 3; rowcount = OperateLogDAL.AddAmountChangeLog(logmodel); if (rowcount < 1) { return("0操作失败"); } try { UserBehaviorLogModel log = new UserBehaviorLogModel(); log.AOrderCode = ""; log.BehaviorSource = 2; log.BehaviorType = 10; log.HOrderCode = ""; log.MemberID = member.ID; log.MemberName = member.TruethName; log.MemberPhone = member.MobileNum; log.ProcAmount = money; log.Remark = "会员:" + member.MobileNum + " 被惩罚静态资金" + money + "元"; rowcount = UserBehaviorLogDAL.AddUserBehaviorLog(log); } catch { } scope.Complete(); result = "1"; } return(result); }
/// <summary> /// 为会员分派动态奖金 /// </summary> /// <param name="memberphone"></param> /// <param name="money"></param> /// <returns></returns> public string FenPaiMoneyToDynamic(int memberid, decimal money) { string result = "0"; MemberInfoModel member = MemberInfoDAL.GetMember(memberid); if (member == null) { return("0无此会员"); } using (TransactionScope scope = new TransactionScope()) { int rowcount = MemberCapitalDetailDAL.UpdateMemberDynamicFunds(member.ID, money, member.TruethName, member.MobileNum); if (rowcount < 1) { return("0操作失败"); } AmountChangeLogModel logmodel = new AmountChangeLogModel(); logmodel.MemberID = member.ID; logmodel.MemberName = member.TruethName; logmodel.MemberPhone = member.MobileNum; logmodel.OrderCode = ""; logmodel.OrderID = 0; logmodel.ProduceMoney = money; logmodel.Remark = "会员:" + member.MobileNum + " 得到系统派发的奖金"; logmodel.Type = 3; rowcount = OperateLogDAL.AddAmountChangeLog(logmodel); if (rowcount < 1) { return("0操作失败"); } try { UserBehaviorLogModel log = new UserBehaviorLogModel(); log.AOrderCode = ""; log.BehaviorSource = 2; log.BehaviorType = 9; log.HOrderCode = ""; log.MemberID = member.ID; log.MemberName = member.TruethName; log.MemberPhone = member.MobileNum; log.ProcAmount = money; log.Remark = "会员:" + member.MobileNum + " 获得系统奖励动态资金" + money + "元"; rowcount = UserBehaviorLogDAL.AddUserBehaviorLog(log); } catch { } scope.Complete(); result = "1"; } return(result); }
/// <summary> /// 更新提供帮助订单为已打款 /// </summary> /// <param name="hid"></param> /// <returns></returns> public int UpdateToPlayMoneyV1(int hid, int aid) { int result = 0; string value = SysAdminConfigDAL.GetConfigsByID(6); //得到打款后返还金额 string inteist = SysAdminConfigDAL.GetConfigsByID(7); //得到打款后利率 string inteistlist = SysAdminConfigDAL.GetConfigsByID(11); //得到领导奖利率 HelpeOrderModel order = HelpeOrderDAL.GetHelpOrderInfo(hid); List <MatchOrderModel> matchorders = MatchOrderDAL.GetMatchOrderInfo(hid, aid); using (TransactionScope scope = new TransactionScope()) { //更改状态为已打款(此处不在变更利率为打款后利率) //int rowcount = HelpeOrderDAL.UpdateStatusandinster(hid, 4, decimal.Parse(inteist)); int rowcount = HelpeOrderDAL.UpdateStatus(hid, 4); if (rowcount < 1) { return(0); } rowcount = MatchOrderDAL.UpdateStatusToPayed(hid, aid); if (rowcount < 1) { return(0); } //更新匹配接受订单的状态为对方已打款 rowcount = AcceptHelpOrderDAL.UpdateStatus(aid, 4); if (rowcount < 1) { return(0); } try { UserBehaviorLogModel log = new UserBehaviorLogModel(); log.AOrderCode = matchorders[0].AcceptOrderCode; log.BehaviorSource = 1; log.BehaviorType = 4; log.HOrderCode = matchorders[0].HelperOrderCode; log.MemberID = order.MemberID; log.MemberName = order.MemberName; log.MemberPhone = order.MemberPhone; log.ProcAmount = matchorders[0].MatchedMoney; log.Remark = "会员:" + order.MemberPhone + " 变更单据为打款"; rowcount = UserBehaviorLogDAL.AddUserBehaviorLog(log); } catch { } scope.Complete(); result = 1; } return(result); }
/// <summary> /// 为会员派发利息(V3版) /// </summary> /// <param name="day"></param> /// <returns></returns> public string PaymentInterestV3() { string result = ""; int days = int.Parse(SysAdminConfigDAL.GetConfigsByID(10)); using (TransactionScope scope = new TransactionScope()) { //为每个单据派发利息 int rowcount = MemberCapitalDetailDAL.PaymentInterestForOrderWithLog(days); if (rowcount < 1) { result = "0为单据派发利息失败"; return(result); } //更改会员的当前利率和利息 rowcount = MemberCapitalDetailDAL.ResetInster(days); //汇总并加入到账户信息记录日志 rowcount = MemberCapitalDetailDAL.SumInterestMoneyWithoutLog(); if (rowcount < 1) { result = "0为会员更新利息总额失败"; return(result); } //解冻单据利率为2,状态为5的单据的利息 rowcount = MemberCapitalDetailDAL.UpdateStaticCaptail(); try { UserBehaviorLogModel log = new UserBehaviorLogModel(); log.AOrderCode = ""; log.BehaviorSource = 2; log.BehaviorType = 11; log.HOrderCode = ""; log.MemberID = 0; log.MemberName = ""; log.MemberPhone = ""; log.ProcAmount = 0; log.Remark = "系统派发利息"; rowcount = UserBehaviorLogDAL.AddUserBehaviorLog(log); } catch { } scope.Complete(); result = "1"; } return(result); }
/// <summary> /// 添加用户操作日志 /// </summary> /// <param name="model"></param> /// <returns></returns> public static int AddUserBehaviorLog(UserBehaviorLogModel model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into UserBehaviorLog("); strSql.Append("Remark,AddTime,MemberID,MemberPhone,MemberName,BehaviorSource,BehaviorType,ProcAmount,HOrderCode,AOrderCode"); strSql.Append(") values ("); strSql.Append("@Remark,GETDATE(),@MemberID,@MemberPhone,@MemberName,@BehaviorSource,@BehaviorType,@ProcAmount,@HOrderCode,@AOrderCode"); strSql.Append(") "); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@Remark", SqlDbType.NVarChar), new SqlParameter("@MemberID", SqlDbType.Int), new SqlParameter("@MemberPhone", SqlDbType.NVarChar), new SqlParameter("@MemberName", SqlDbType.NVarChar), new SqlParameter("@BehaviorSource", SqlDbType.Int), new SqlParameter("@BehaviorType", SqlDbType.Int), new SqlParameter("@ProcAmount", SqlDbType.Decimal), new SqlParameter("@HOrderCode", SqlDbType.NVarChar), new SqlParameter("@AOrderCode", SqlDbType.NVarChar) }; parameters[0].Value = model.Remark; parameters[1].Value = model.MemberID; parameters[2].Value = model.MemberPhone; parameters[3].Value = model.MemberName; parameters[4].Value = model.BehaviorSource; parameters[5].Value = model.BehaviorType; parameters[6].Value = model.ProcAmount; parameters[7].Value = model.HOrderCode; parameters[8].Value = model.AOrderCode; object obj = helper.GetSingle(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }
/// <summary> /// 查询系统的操作变动信息 /// </summary> /// <param name="model"></param> /// <param name="totalrowcount"></param> /// <returns></returns> public List <UserBehaviorLogModel> GetUserBehaviorLogByPage(UserBehaviorLogModel model, out int totalrowcount) { return(UserBehaviorLogDAL.GetUserBehaviorLogByPage(model, out totalrowcount)); }
/// <summary> /// 登录信息 /// </summary> /// <param name="user"></param> /// <returns></returns> public SysAdminUserModel GetUserForLogin(SysAdminUserModel user) { SysAdminUserModel result = null; string sqltxt = @"SELECT ID , UserName , UserPwd , UserStatus , UserEmail , TruethName , UserPhone , Question , Answer , GID , GName, LoginName,HeaderImg,WebSkin,LastLoginIP,LastLoginTime,IsAdmin FROM dbo.SysAdminUser WHERE LoginName=@loginname "; SqlParameter[] paramter = { new SqlParameter("@loginname", user.LoginName) }; DataTable dt = helper.Query(sqltxt, paramter).Tables[0]; if (dt != null && dt.Rows.Count > 0) { result = new SysAdminUserModel(); result.Answer = dt.Rows[0]["Answer"].ToString(); result.GID = int.Parse(dt.Rows[0]["GID"].ToString()); result.GName = dt.Rows[0]["GName"].ToString(); result.ID = int.Parse(dt.Rows[0]["ID"].ToString()); result.LoginName = dt.Rows[0]["LoginName"].ToString(); result.Question = dt.Rows[0]["Question"].ToString(); result.TruethName = dt.Rows[0]["TruethName"].ToString(); result.UserEmail = dt.Rows[0]["UserEmail"].ToString(); result.UserName = dt.Rows[0]["UserName"].ToString(); result.UserPhone = dt.Rows[0]["UserPhone"].ToString(); result.UserPwd = dt.Rows[0]["UserPwd"].ToString(); result.HeaderImg = dt.Rows[0]["HeaderImg"].ToString(); result.UserStatus = int.Parse(dt.Rows[0]["UserStatus"].ToString()); result.WebSkin = string.IsNullOrWhiteSpace(dt.Rows[0]["WebSkin"].ToString()) ? "default" : dt.Rows[0]["WebSkin"].ToString(); result.LastLoginIP = string.IsNullOrWhiteSpace(dt.Rows[0]["LastLoginIP"].ToString()) ? "" : dt.Rows[0]["LastLoginIP"].ToString(); result.LastLoginTime = string.IsNullOrWhiteSpace(dt.Rows[0]["LastLoginTime"].ToString()) ? DateTime.MinValue : DateTime.Parse(dt.Rows[0]["LastLoginTime"].ToString()); result.IsAdmin = dt.Rows[0]["IsAdmin"].ToString().ParseToInt(0); if (result.UserPwd != user.UserPwd) { result.LoginResult = "0用户密码不正确"; return(result); } if (result.UserStatus == 0) { result.LoginResult = "0用户已经被禁用"; return(result); } UpdateLoginMsg(user.LastLoginTime, user.LastLoginIP, result.ID); try { UserBehaviorLogModel log = new UserBehaviorLogModel(); log.AOrderCode = ""; log.BehaviorSource = 2; log.BehaviorType = 1; log.HOrderCode = ""; log.MemberID = result.ID; log.MemberName = result.UserName; log.MemberPhone = result.UserPhone; log.ProcAmount = 0; log.Remark = "管理员:" + result.UserName + "登陆"; int rowcount = UserBehaviorLogDAL.AddUserBehaviorLog(log); } catch { } result.LoginResult = "1"; } else { result = new SysAdminUserModel(); result.LoginResult = "0无此用户"; return(result); } return(result); }
/// <summary> /// 会员间赠送激活码 /// </summary> /// <param name="soucememberID">原始会员ID</param> /// <param name="type">赠送激活码类型</param> /// <param name="acceptMemberPhone">接受会员电话</param> /// <param name="count">赠送数量</param> /// <returns>返回值(-1 接受会员不存在 -2 没有足够的激活币赠送 0 数据库操作失败 1 成功)</returns> public int GiveActiveCodeFromMember(int soucememberID, int type, string acceptMemberPhone, int count) { int result = 0; //读取接受会员信息 MemberInfoModel member = GetMember(acceptMemberPhone); if (member == null) { return(-1); } if (member.MStatus != 2) { return(-1); } //开启事务 using (TransactionScope scope = new TransactionScope()) { //查询该会员名下可用类型的激活码数量 List <MemberActiveCodeModel> aclist = GetMemberActiveCodeList(soucememberID, type); if (aclist.Count < count) { return(-2); } //修改激活码的所有者信息 string sqltxt = @"UPDATE TOP ( @count) MemberActiveCode SET MemberID = @memberid , MemberPhone = @MemberPhone , MemberName = @MemberName WHERE MemberID = @soucemid AND AMStatus = 1 AND AMType = @AMType"; SqlParameter[] paramter = { new SqlParameter("@memberid", member.ID), new SqlParameter("@MemberPhone", member.MobileNum), new SqlParameter("@MemberName", member.TruethName), new SqlParameter("@soucemid", soucememberID), new SqlParameter("@AMType", type), new SqlParameter("@count", count) }; int row = helper.ExecuteSql(sqltxt, paramter); if (row < 0) { return(0); } int rowcount = row; //记录转出者名下日志 MemberInfoModel sourcemodel = GetMember(soucememberID); ActiveCodeLogModel souce = new ActiveCodeLogModel(); souce.MemberID = soucememberID; souce.MemberName = sourcemodel.TruethName; souce.MemberPhone = sourcemodel.MobileNum; souce.ActiveCode = ""; souce.AID = 0; souce.Remark = " 转出" + rowcount.ToString() + "个" + (type == 1 ? "激活币" : "排单币"); row = OperateLogDAL.AddActiveCodeLog(souce); if (row < 0) { return(0); } //记录转入者名下日志 ActiveCodeLogModel accept = new ActiveCodeLogModel(); accept.MemberID = member.ID; accept.MemberName = member.TruethName; accept.MemberPhone = member.MobileNum; accept.ActiveCode = ""; accept.AID = 0; accept.Remark = "接收" + rowcount.ToString() + "个" + (type == 1 ? "激活币" : "排单币"); row = OperateLogDAL.AddActiveCodeLog(accept); if (row < 0) { return(0); } //记录系统操作日志 try { UserBehaviorLogModel log = new UserBehaviorLogModel(); log.AOrderCode = ""; log.BehaviorSource = 1; if (type == 1) { log.BehaviorType = 8; } else { log.BehaviorType = 7; } log.HOrderCode = ""; log.MemberID = member.ID; log.MemberName = member.TruethName; log.MemberPhone = member.MobileNum; log.ProcAmount = 0; log.Remark = "会员:" + member.MobileNum + " 得到来自" + sourcemodel.MobileNum + "转来的" + rowcount.ToString() + "个" + (type == 1 ? "激活币" : "排单币"); UserBehaviorLogDAL.AddUserBehaviorLog(log); } catch { } scope.Complete(); result = 1; } return(result); }
/// <summary> /// 分配激活码 /// </summary> /// <param name="codes"></param> /// <param name="memberphone"></param> /// <returns></returns> public int AssignedCode(List <string> codes, string memberphone) { int result = 0; //得到激活码信息 List <ActiveCodeModel> codelist = GetCodeMassage(codes); //得到被分配会员信息 MemberInfoModel member = GetMember(memberphone); if (member.MStatus != 2) { return(0); } //开启事务,分配激活码 try { using (TransactionScope scope = new TransactionScope()) { //更改原表状态 result = UpdateStatus(codelist); if (result < codelist.Count) { throw new Exception("更改激活码原表失败"); } List <MemberActiveCodeModel> maclist = new List <MemberActiveCodeModel>(); foreach (var item in codelist) { MemberActiveCodeModel mac = new MemberActiveCodeModel(); mac.ActiveCode = item.ActivationCode; mac.MemberID = member.ID; mac.MemberName = member.TruethName; mac.MemberPhone = member.MobileNum; mac.AMType = item.AType; maclist.Add(mac); } result = AddMemberActiveCode(maclist); if (result < 1) { return(0); } ActiveCodeLogModel activemodel = new ActiveCodeLogModel(); activemodel.ActiveCode = ""; activemodel.Addtime = DateTime.Now; activemodel.AID = 0; activemodel.MemberID = member.ID; activemodel.MemberName = member.TruethName; activemodel.MemberPhone = member.MobileNum; activemodel.Remark = "接收" + codelist.Count + "个" + (codelist[0].AType == 1 ? "激活币" : "排单币"); OperateLogDAL.AddActiveCodeLog(activemodel); try { UserBehaviorLogModel log = new UserBehaviorLogModel(); log.AOrderCode = ""; log.BehaviorSource = 2; if (codelist[0].AType == 1) { log.BehaviorType = 8; } else { log.BehaviorType = 7; } log.HOrderCode = ""; log.MemberID = member.ID; log.MemberName = member.TruethName; log.MemberPhone = member.MobileNum; log.ProcAmount = 0; log.Remark = "系统派发激活码/排单币" + codelist.Count + "个"; UserBehaviorLogDAL.AddUserBehaviorLog(log); } catch { } scope.Complete(); result = 1; } } catch { return(0); } return(result); }
/// <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> public string AddAcceptHelpOrder(AcceptHelpOrderModel model) { string result = "0"; MemberCapitalDetailModel moneydetail = MemberCapitalDetailDAL.GetMemberStaticCapital(model.MemberID); int rows = AcceptHelpOrderDAL.GetNotFinishOrderByMember(model.MemberID); if (rows > 0) { return("0还有未完成的接受帮助单据"); } string maxacceptamont = SystemConfigs.GetmaxAcceptAmont(); //得到最大的接受帮助限制 string minacceptamont = SystemConfigs.GetminAcceptAmont(); //得到最小的接受帮助限制 if (model.Amount > maxacceptamont.ParseToDecimal(0)) { return("0超出了平台规定的最大接受值"); } if (model.Amount < minacceptamont.ParseToDecimal(0)) { return("0超出了平台规定的最小接受值"); } int daynum = SysAdminConfigBLL.GetConfigValue(24).ParseToInt(15); MemberExtendInfoModel extentmember = MemberExtendInfoDAL.GetMemberExtendInfo(model.MemberID); if (DateTime.Now < extentmember.LastHelperTime.AddDays(daynum)) { return("0会员提供帮助单据仍处于冻结期"); } using (TransactionScope scope = new TransactionScope()) { //插入表 int orderid = dal.AddAcceptHelpOrder(model); if (orderid < 1) { return("0操作失败"); } //扣减会员的相应金额记录 int rowcount = 0; if (model.SourceType == 1) { if (moneydetail.StaticCapital < model.Amount) { return("0操作失败"); } rowcount = MemberCapitalDetailDAL.DeductionMemberStaticCapital(model.MemberID, 0 - model.Amount, 0); //清空会员的利率(不判断结果,不排除没有这样单据的可能,因为存在特殊账户) int rowcounts = HelpeOrderDAL.UpdateCurrentInterestToClear(model.MemberID); } else { if (moneydetail.DynamicFunds < model.Amount) { return("0操作失败"); } rowcount = MemberCapitalDetailDAL.DeductionMemberDynamicFunds(model.MemberID, 0 - model.Amount, 0); } 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 = 0 - model.Amount; logmodel.Remark = "会员:" + model.MemberPhone + " 申请接受帮助 " + model.Amount.ToString() + "元"; logmodel.Type = 1; rowcount = OperateLogDAL.AddAmountChangeLog(logmodel); if (rowcount < 1) { return("0操作失败"); } try { UserBehaviorLogModel log = new UserBehaviorLogModel(); log.AOrderCode = model.OrderCode; log.BehaviorSource = 1; log.BehaviorType = 3; log.HOrderCode = ""; 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> /// <param name="model"></param> /// <param name="totalrowcount"></param> /// <returns></returns> public static List <UserBehaviorLogModel> GetUserBehaviorLogByPage(UserBehaviorLogModel model, out int totalrowcount) { List <UserBehaviorLogModel> list = new List <UserBehaviorLogModel>(); string columms = @" ID,MemberID,MemberPhone,MemberName,BehaviorSource,BehaviorType,ProcAmount,HOrderCode,AOrderCode,Remark,AddTime,CASE BehaviorType WHEN 1 THEN '登陆' WHEN 2 THEN '提供帮助' WHEN 3 THEN '接受帮助' WHEN 4 THEN '变更打款' WHEN 5 THEN '确认单据' WHEN 6 THEN '撤销单据' WHEN 7 THEN '发放排单币' WHEN 8 THEN '发放激活币' WHEN 9 THEN '奖励会员' WHEN 10 THEN '惩罚会员' WHEN 11 THEN '系统派息' END AS BehaviorTypeName,CASE BehaviorSource WHEN 1 THEN '前端' WHEN 2 THEN '后台' END AS BehaviorSourceName "; string where = ""; if (model != null) { if (model.BehaviorType > 0) { where += @"BehaviorType='" + model.BehaviorType + "'"; } if (!string.IsNullOrWhiteSpace(model.MemberName) && string.IsNullOrWhiteSpace(where)) { where += @" MemberName=" + model.MemberID.ToString(); } else if (!string.IsNullOrWhiteSpace(where) && !string.IsNullOrWhiteSpace(model.MemberName)) { where += @" AND MemberName=" + model.MemberID.ToString(); } if (!string.IsNullOrWhiteSpace(model.MemberPhone) && string.IsNullOrWhiteSpace(where)) { where += @" MemberPhone = '" + model.MemberPhone + "'"; } else if (!string.IsNullOrWhiteSpace(model.MemberPhone) && !string.IsNullOrWhiteSpace(where)) { where += @" AND MemberPhone = '" + model.MemberPhone + "'"; } } PageProModel page = new PageProModel(); page.colums = columms; page.orderby = "ID"; page.pageindex = model.PageIndex; page.pagesize = model.PageSize; page.tablename = @"dbo.UserBehaviorLog"; page.where = where; DataTable dt = PublicHelperDAL.GetTable(page, out totalrowcount); if (dt.Rows.Count > 0) { foreach (DataRow item in dt.Rows) { UserBehaviorLogModel usermodel = new UserBehaviorLogModel(); if (item["ID"].ToString() != "") { usermodel.ID = int.Parse(item["ID"].ToString()); } usermodel.Remark = item["Remark"].ToString(); if (item["AddTime"].ToString() != "") { usermodel.AddTime = DateTime.Parse(item["AddTime"].ToString()); } if (item["MemberID"].ToString() != "") { usermodel.MemberID = int.Parse(item["MemberID"].ToString()); } usermodel.MemberPhone = item["MemberPhone"].ToString(); usermodel.MemberName = item["MemberName"].ToString(); if (item["BehaviorSource"].ToString() != "") { usermodel.BehaviorSource = int.Parse(item["BehaviorSource"].ToString()); } if (item["BehaviorType"].ToString() != "") { usermodel.BehaviorType = int.Parse(item["BehaviorType"].ToString()); } if (item["ProcAmount"].ToString() != "") { usermodel.ProcAmount = decimal.Parse(item["ProcAmount"].ToString()); } usermodel.HOrderCode = item["HOrderCode"].ToString(); usermodel.AOrderCode = item["AOrderCode"].ToString(); usermodel.BehaviorSourceName = item["BehaviorSourceName"].ToString(); usermodel.BehaviorTypeName = item["BehaviorTypeName"].ToString(); list.Add(usermodel); } } return(list); }
/// <summary> /// 前端会员登陆 /// </summary> /// <param name="phone"></param> /// <param name="pwd"></param> /// <returns></returns> public MemberInfoModel GetMemberInfo(string phone, string pwd, out string logmsg) { MemberInfoModel model = null; string sqltxt = @"SELECT ID , TruethName , Sex , TelPhone , MobileNum , Email , IdentificationID , Province , City , Area , [Address] , WeixinNum , AliPayName , AliPayNum , SecurityQuestion , SecurityAnswer , LogPwd , MStatus , AddTime FROM dbo.MemberInfo WHERE MobileNum=@MobileNum"; SqlParameter[] paramter = { new SqlParameter("@MobileNum", phone) }; DataTable dt = helper.Query(sqltxt, paramter).Tables[0]; if (dt.Rows.Count > 0) { string logpwd = dt.Rows[0]["LogPwd"].ToString(); if (logpwd != pwd) { logmsg = "登陆密码不正确"; return(null); } if (dt.Rows[0]["MStatus"].ToString() == "1") { logmsg = "该账户未激活"; return(null); } if (dt.Rows[0]["MStatus"].ToString() == "3") { logmsg = "该账户已被冻结"; return(null); } model = new MemberInfoModel(); if (dt.Rows[0]["ID"].ToString() != "") { model.ID = int.Parse(dt.Rows[0]["ID"].ToString()); } if (dt.Rows[0]["Area"].ToString() != "") { model.Area = dt.Rows[0]["Area"].ToString(); } model.Address = dt.Rows[0]["Address"].ToString(); model.WeixinNum = dt.Rows[0]["WeixinNum"].ToString(); model.AliPayName = dt.Rows[0]["AliPayName"].ToString(); model.AliPayNum = dt.Rows[0]["AliPayNum"].ToString(); model.SecurityQuestion = dt.Rows[0]["SecurityQuestion"].ToString(); model.SecurityAnswer = dt.Rows[0]["SecurityAnswer"].ToString(); model.LogPwd = "password"; if (dt.Rows[0]["MStatus"].ToString() != "") { model.MStatus = int.Parse(dt.Rows[0]["MStatus"].ToString()); } if (dt.Rows[0]["AddTime"].ToString() != "") { model.AddTime = DateTime.Parse(dt.Rows[0]["AddTime"].ToString()); } model.TruethName = dt.Rows[0]["TruethName"].ToString(); if (dt.Rows[0]["Sex"].ToString() != "") { model.Sex = int.Parse(dt.Rows[0]["Sex"].ToString()); } model.TelPhone = dt.Rows[0]["TelPhone"].ToString(); model.MobileNum = dt.Rows[0]["MobileNum"].ToString(); model.Email = dt.Rows[0]["Email"].ToString(); model.IdentificationID = dt.Rows[0]["IdentificationID"].ToString(); if (dt.Rows[0]["Province"].ToString() != "") { model.Province = dt.Rows[0]["Province"].ToString(); } if (dt.Rows[0]["City"].ToString() != "") { model.City = dt.Rows[0]["City"].ToString(); } logmsg = "1"; try { UserBehaviorLogModel log = new UserBehaviorLogModel(); log.AOrderCode = ""; log.BehaviorSource = 1; log.BehaviorType = 1; log.HOrderCode = ""; log.MemberID = model.ID; log.MemberName = model.TruethName; log.MemberPhone = model.MobileNum; log.ProcAmount = 0; log.Remark = "会员:" + model.MobileNum + "登陆"; int rowcount = UserBehaviorLogDAL.AddUserBehaviorLog(log); } catch { } return(model); } else { logmsg = "手机号不存在"; return(null); } }