/// <summary> /// 更新提现记录 /// </summary> /// <param name="draw"></param> /// <returns></returns> public static bool UpdateDraw(DrawInfoModel draw) { string result = OWZX.Data.Recharge.UpdateDraw(draw); if (result.EndsWith("成功")) { return(true); } return(false); }
/// <summary> /// 提现申请 /// </summary> /// <returns></returns> public ActionResult UserDraw() { NameValueCollection parmas = WorkContext.postparms; if (parmas.Keys.Count != 4) { return(APIResult("error", "缺少请求参数")); } string account = parmas["account"]; decimal money = decimal.Parse(parmas["money"]); if (money < 100) { return(APIResult("error", "最低请提现100元宝")); } PartUserInfo partUserInfo = Users.GetPartUserByMobile(account); if (partUserInfo.TotalMoney < money) { return(APIResult("error", "余额不足")); } string mdpwd = Users.CreateUserPassword(parmas["password"], partUserInfo.Salt); bool pwdres = Recharge.ValidateDrawPwd(account, mdpwd); if (!pwdres) { return(APIResult("error", "提现密码错误")); } DrawInfoModel draw = new DrawInfoModel { Account = account, Money = int.Parse(parmas["money"]), }; string addres = Recharge.AddDraw(draw); if (addres.EndsWith("成功")) { return(APIResult("success", "申请成功")); } else if (addres == "-1") { return(APIResult("error", "余额不足")); } else { return(APIResult("error", "申请失败")); } }
/// <summary> /// 完成提现转账 /// </summary> public ActionResult EditDraw(int drawId, string exception, string type) { List <DrawInfoModel> listdraw = Recharge.GetDrawList(1, 15, " where drawid=" + drawId); DrawInfoModel draw = new DrawInfoModel(); if (listdraw.Count > 0) { draw = listdraw[0]; } else { return(AjaxResult("error", "提现信息不存在")); } if (type == "2") { //完成 draw.Updateuser = WorkContext.UserName; if (exception == "") { draw.State = "2"; } else { draw.State = "3"; } draw.Exception = exception; } else if (type == "1") { //审核中 draw.Exception = ""; draw.Updateuser = WorkContext.UserName; draw.State = "1"; } bool result = Recharge.UpdateDraw(draw); if (result) { return(AjaxResult("success", "处理成功")); } else { return(AjaxResult("error", "处理失败")); } }
/// <summary> /// 更新提现记录 /// </summary> /// <param name="draw"></param> /// <returns></returns> public string UpdateDraw(DrawInfoModel draw) { DbParameter[] parms = { GenerateInParam("@drawid", SqlDbType.Int, 4, draw.Drawid), GenerateInParam("@state", SqlDbType.VarChar, 1, draw.State), GenerateInParam("@exception", SqlDbType.VarChar, 100, draw.Exception), GenerateInParam("@updateuser", SqlDbType.VarChar, 30, draw.Updateuser) }; string commandText = string.Format(@" begin try begin tran t1 if exists(select 1 from [{0}userdraw] where drawid=@drawid) begin UPDATE [{0}userdraw] SET state = @state,exception=@exception,updateuser=@updateuser,updatetime=convert(varchar(25),getdate(),120) where drawid=@drawid --提现成功 发送消息 if(@state='2') begin insert into owzx_message([uid],[title],[body]) select a.uid ,'提现'+cast(b.money as varchar(20))+'元到账通知','您提现的'+cast(b.money as varchar(20))+'元已经到账,请注意查收' from {0}users a join {0}userdraw b on a.uid=b.uid and b.drawid=@drawid end else if(@state='3') begin declare @count int select @count=COUNT(1) from [owzx_userdraw] a where a.uid=(select uid from owzx_userdraw where drawid=@drawid) and CONVERT(varchar(10),a.addtime,120)=CONVERT(varchar(10),getdate(),120) if(@count>3) begin --每天免费3次,超过收取1%手续费 INSERT INTO owzx_accountchange([uid],[changemoney],[remark],accounted) select uid ,money+money*1*0.01,'提现失败',(select isnull(totalmoney,0) from owzx_users a where a.uid=uid) from owzx_userdraw where drawid=@drawid update a set a.totalmoney=a.totalmoney+b.money+b.money*1*0.01 from {0}users a join {0}userdraw b on a.uid=b.uid and b.drawid=@drawid end else begin INSERT INTO owzx_accountchange([uid],[changemoney],[remark],accounted) select uid ,money,'提现失败',(select isnull(totalmoney,0) from owzx_users a where a.uid=uid) from owzx_userdraw where drawid=@drawid update a set a.totalmoney=a.totalmoney+b.money from {0}users a join {0}userdraw b on a.uid=b.uid and b.drawid=@drawid end end select '修改成功' state commit tran t1 end else begin select '提现记录已被删除' state commit tran t1 end end try begin catch rollback tran t1 select ERROR_MESSAGE() state end catch ", RDBSHelper.RDBSTablePre); return RDBSHelper.ExecuteScalar(CommandType.Text, commandText, parms).ToString(); }
/// <summary> /// 添加提现记录 /// </summary> /// <param name="draw"></param> /// <returns></returns> public string AddDraw(DrawInfoModel draw) { DbParameter[] parms = { //GenerateInParam("@account", SqlDbType.VarChar, 15, draw.Account), GenerateInParam("@uid", SqlDbType.Int, 4, draw.Uid), GenerateInParam("@money", SqlDbType.Int, 4, draw.Money), GenerateInParam("@Drawaccid", SqlDbType.Int, 4, draw.Drawaccid), }; string commandText = string.Format(@" begin try begin tran t1 if exists(select 1 from {0}users where uid=@uid and totalmoney>=@money) begin INSERT INTO [{0}userdraw]([uid],[money],[state],Drawaccid) VALUES (@uid,@money,0,@Drawaccid) declare @count int select @count=COUNT(1) from [owzx_userdraw] a where a.uid=@uid and CONVERT(varchar(10),a.addtime,120)=CONVERT(varchar(10),getdate(),120) if(@count>3) begin --每天免费3次,超过收取1%手续费 INSERT INTO owzx_accountchange([uid],[changemoney],[remark],accounted) select @uid ,-(@money+@money*1*0.01),'提现',(select isnull(totalmoney,0) from owzx_users where uid=@uid) update a set a.totalmoney=a.totalmoney-@money-@money*1*0.01 from {0}users a where a.uid=@uid end else begin INSERT INTO owzx_accountchange([uid],[changemoney],[remark],accounted) select @uid ,-@money,'提现',(select isnull(totalmoney,0) from owzx_users where uid=@uid) update a set a.totalmoney=a.totalmoney-@money from {0}users a where a.uid=@uid end select '添加成功' state commit tran t1 end else begin select '-1' state commit tran t1 end end try begin catch rollback tran t1 select ERROR_MESSAGE() state end catch ", RDBSHelper.RDBSTablePre); return RDBSHelper.ExecuteScalar(CommandType.Text, commandText, parms).ToString(); }
/// <summary> /// 更新提现记录 /// </summary> /// <param name="draw"></param> /// <returns></returns> public static string UpdateDraw(DrawInfoModel draw) { return(BSPData.RDBS.UpdateDraw(draw)); }
/// <summary> /// 添加提现记录 /// </summary> /// <param name="draw"></param> /// <returns></returns> public static string AddDraw(DrawInfoModel draw) { return(BSPData.RDBS.AddDraw(draw)); }
/// <summary> /// 添加提现记录 /// </summary> /// <param name="draw"></param> /// <returns></returns> public static string AddDraw(DrawInfoModel draw) { return(OWZX.Data.Recharge.AddDraw(draw)); }
/// <summary> /// 提现申请 /// </summary> /// <returns></returns> public ActionResult UserDraw() { NameValueCollection parmas = WorkContext.postparms; if (!Recharge.ValidateDrawPwdByUid(WorkContext.Uid)) { return(Content("5"));//没有设置提现密码 } if (parmas["drawaccid"] == "") { return(Content("6"));//没有添加银行卡信息 } List <MD_DrawAccount> drawgt = Recharge.GetDrawAccountList(1, 1, " where a.drawaccid=" + parmas["drawaccid"].ToString() + ""); if (drawgt == null || drawgt.Count == 0) { return(Content("6"));//没有添加银行卡信息 } //string account = parmas["account"]; decimal money = decimal.Parse(parmas["money"]); if (money < 100) { //return APIResult("error", "最低请提现100元"); return(Content("2")); } PartUserInfo partUserInfo = Users.GetPartUserById(WorkContext.Uid); if (partUserInfo.TotalMoney < money) { //return APIResult("error", "账户余额不足"); return(Content("2")); } string mdpwd = parmas["password"];// Users.CreateUserPassword(parmas["password"], partUserInfo.Salt); bool pwdres = Recharge.ValidateDrawPwdByUid(WorkContext.Uid, mdpwd); if (!pwdres) { //return APIResult("error", "提现密码错误"); return(Content("1")); } DrawInfoModel draw = new DrawInfoModel { Uid = WorkContext.Uid, Money = int.Parse(parmas["money"]), Drawaccid = int.Parse(parmas["drawaccid"]) }; string addres = Recharge.AddDraw(draw); if (addres.EndsWith("成功")) { return(Content("4")); //return APIResult("success", "已经提交请等待客服处理"); } else if (addres == "-1") { //return APIResult("error", "账户余额不足"); return(Content("2")); } else { return(Content("3")); //return APIResult("error", "提交失败"); } }