/// <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", "提交失败");
}
}
