/// <summary>
/// 更新提现密码
/// </summary>
/// <param name="drawa"></param>
/// <returns></returns>
public string UpdateDrawPWD(MD_DrawAccount drawa)
{
DbParameter[] parms = {
GenerateInParam("@uid", SqlDbType.VarChar, 15, drawa.Uid),
GenerateInParam("@drawpwd", SqlDbType.VarChar, 50, drawa.Drawpwd)
};
string commandText = string.Format(@"
begin try
if exists(select 1 from owzx_userdrawaccount a join owzx_users b on a.uid=b.uid and b.uid=@uid)
begin
update a set
a.drawpwd=@drawpwd
from owzx_userdrawaccount a
join owzx_users b on a.uid=b.uid and b.uid=@uid
end
else
begin
insert into owzx_userdrawaccount([uid],drawpwd)
select @uid,@drawpwd
end
select '更新成功'
end try
begin catch
select ERROR_MESSAGE() state
end catch
");
return RDBSHelper.ExecuteScalar(CommandType.Text, commandText, parms).ToString();
}
public ActionResult EditDraw(MD_DrawAccount model, int uid = -1)
{
UserInfo userInfo = AdminUsers.GetUserById(uid);
if (userInfo == null)
{
return(PromptView("用户不存在"));
}
if (ModelState.IsValid)
{
model.Drawpwd = Users.CreateUserPassword(model.Drawpwd, userInfo.Salt);
model.Account = userInfo.Mobile;
bool result = false;
result = Recharge.UpdateDrawPWD(model);
if (result)
{
return(PromptView("提现密码修改成功"));
}
else
{
return(PromptView("提现密码修改失败"));
}
}
Load(0);
return(View(model));
}
/// <summary>
/// 更新提现密码
/// </summary>
/// <param name="drawa"></param>
/// <returns></returns>
public static bool UpdateDrawPWD(MD_DrawAccount drawa)
{
string result = OWZX.Data.Recharge.UpdateDrawPWD(drawa);
if (result.EndsWith("成功"))
{
return(true);
}
return(false);
}
/// <summary>
/// 绑定银行卡
/// </summary>
/// <returns></returns>
public ActionResult SetDrawAccount()
{
try
{
NameValueCollection parmas = WorkContext.postparms;
//包含imei号
if (parmas.Keys.Count != 7)
{
return(APIResult("error", "缺少请求参数"));
}
MD_DrawAccount draw = new MD_DrawAccount
{
Account = parmas["account"],
Username = parmas["username"],
Card = parmas["cardname"],
Cardnum = parmas["cardnum"],
Cardaddress = parmas["cardaddress"],
Drawpwd = parmas["pwd"]
};
bool result = Recharge.ValidateDrawPwd(parmas["account"]);
if (!result)
{
return(APIResult("error", "未设置提现密码"));
}
PartUserInfo partUserInfo = Users.GetPartUserByMobile(parmas["account"]);
draw.Drawpwd = Users.CreateUserPassword(draw.Drawpwd, partUserInfo.Salt);
bool pwdres = Recharge.ValidateDrawPwd(draw.Account, draw.Drawpwd);
if (!pwdres)
{
return(APIResult("error", "提现密码错误"));
}
bool saveres = Recharge.UpdateDrawCardInfo(draw);
if (saveres)
{
return(APIResult("success", "保存成功"));
}
else
{
return(APIResult("error", "保存失败"));
}
}
catch (Exception ex)
{
return(APIResult("error", "保存失败"));
}
}
/// <summary>
/// 绑定银行卡
/// </summary>
/// <returns></returns>
public ActionResult SetDrawAccount()
{
try
{
NameValueCollection parmas = WorkContext.postparms;
var id = parmas["id"];
MD_DrawAccount draw = new MD_DrawAccount
{
Uid = WorkContext.Uid,
Username = parmas["username"],
Drawaccid = Convert.ToInt32(parmas["id"]),
Card = parmas["cardname"],
Cardnum = parmas["cardnum"],
Cardaddress = "",// parmas["cardaddress"],
Drawpwd = parmas["pwd"]
};
bool result = Recharge.ValidateDrawPwdByUid(WorkContext.Uid);
if (!result)
{
return(APIResult("error", "未设置提现密码"));
}
PartUserInfo partUserInfo = Users.GetPartUserById(WorkContext.Uid);
//draw.Drawpwd = Users.CreateUserPassword(draw.Drawpwd, partUserInfo.Salt);
bool pwdres = Recharge.ValidateDrawPwdByUid(WorkContext.Uid, draw.Drawpwd);
if (!pwdres)
{
return(APIResult("error", "提现密码错误"));
}
bool saveres = Recharge.UpdateDrawCardInfo(draw);
if (saveres)
{
return(APIResult("success", "保存成功"));
}
else
{
return(APIResult("error", "保存失败"));
}
}
catch (Exception ex)
{
return(APIResult("error", "保存失败"));
}
}
public ActionResult EditBank(int id = -1)
{
ViewData["referer"] = ShopUtils.GetAdminRefererCookie();
List <MD_DrawAccount> list = Recharge.GetDrawAccountList(1, 1, " where a.drawaccid=" + id);
if (list.Count > 0)
{
MD_DrawAccount draw = list[0];
return(View(draw));
}
else
{
return(PromptView("获取用户银行卡信息失败"));
}
}
/// <summary>
/// 更新绑定银行卡信息
/// </summary>
/// <param name="drawa"></param>
/// <returns></returns>
public string UpdateDrawCardInfo(MD_DrawAccount drawa)
{
DbParameter[] parms = {
GenerateInParam("@drawaccid", SqlDbType.Int, 4, drawa.Drawaccid),
GenerateInParam("@uid", SqlDbType.Int, 4, drawa.Uid),
GenerateInParam("@username", SqlDbType.VarChar, 20, drawa.Username),
GenerateInParam("@card", SqlDbType.VarChar, 20, drawa.Card),
GenerateInParam("@cardnum", SqlDbType.VarChar, 20, drawa.Cardnum),
GenerateInParam("@cardaddress", SqlDbType.VarChar, 50, drawa.Cardaddress)
};
string commandText = string.Format(@"
begin try
if(@drawaccid>0 and exists(select 1 from owzx_userdrawaccount a join owzx_users b on a.uid=b.uid and b.uid=@uid where drawaccid=@drawaccid) )
begin
update a set
a.username=@username,
a.card=@card,
a.cardnum=@cardnum,
a.cardaddress=@cardaddress
from owzx_userdrawaccount a where drawaccid=@drawaccid
end
else
begin
if exists(select 1 from owzx_userdrawaccount where uid=@uid)
begin
insert into owzx_userdrawaccount([uid],[username],[card],[cardnum],[cardaddress],drawpwd)
select top 1 @uid,@username,@card,@cardnum,@cardaddress,drawpwd
from owzx_userdrawaccount where uid=@uid
end
end
select '更新成功'
end try
begin catch
select ERROR_MESSAGE() state
end catch
");
return RDBSHelper.ExecuteScalar(CommandType.Text, commandText, parms).ToString();
}
/// <summary>
/// 设置提现密码
/// </summary>
/// <returns></returns>
public ActionResult DrawPwd()
{
try
{
NameValueCollection parmas = WorkContext.postparms;
MD_DrawAccount draw = new MD_DrawAccount
{
Uid = WorkContext.Uid,
Drawpwd = parmas["password"]
};
PartUserInfo partUserInfo = Users.GetPartUserById(WorkContext.Uid);
//draw.Drawpwd = Users.CreateUserPassword(draw.Drawpwd, partUserInfo.Salt);
if (parmas.AllKeys.Contains("oldpwd") && parmas["oldpwd"] != "")
{
//string oldpwd = Users.CreateUserPassword(parmas["oldpwd"], partUserInfo.Salt);
string oldpwd = parmas["oldpwd"];
bool pwdres = Recharge.ValidateDrawPwdByUid(WorkContext.Uid, oldpwd);
if (!pwdres)
{
return(APIResult("error", "原有密码错误"));
}
}
if (partUserInfo.Password == draw.Drawpwd)
{
return(APIResult("error", "提现密码和登录密码不能一致"));
}
bool saveres = Recharge.UpdateDrawPWD(draw);
if (saveres)
{
return(APIResult("success", "保存成功"));
}
else
{
return(APIResult("error", "保存失败"));
}
}
catch (Exception ex)
{
return(APIResult("error", "保存失败"));
}
}
public ActionResult EditDraw(int uid = -1)
{
UserInfo userInfo = AdminUsers.GetUserById(uid);
if (userInfo == null)
{
return(PromptView("用户不存在"));
}
Load(0);
List <MD_DrawAccount> list = Recharge.GetDrawAccountList(1, 1, " where a.uid=" + uid);
MD_DrawAccount draw = new MD_DrawAccount();
if (list.Count > 0)
{
draw = list[0];
draw.Drawpwd = "";
return(View(draw));
}
else
{
return(PromptView("用户未绑定银行卡"));
}
}
public ActionResult EditBank(MD_DrawAccount model)
{
ViewData["referer"] = ShopUtils.GetAdminRefererCookie();
List <MD_DrawAccount> list = Recharge.GetDrawAccountList(1, 1, " where rtrim(b.mobile)='" + model.Account + "'");
if (list.Count > 0)
{
MD_DrawAccount draw = list[0];
draw.Username = model.Username;
bool result = Recharge.UpdateDrawCardInfo(draw);
if (result)
{
return(PromptView("更新成功"));
}
else
{
return(PromptView("更新失败"));
}
}
else
{
return(PromptView("获取用户银行卡信息失败"));
}
}
/// <summary>
/// 更新提现密码
/// </summary>
/// <param name="drawa"></param>
/// <returns></returns>
public static string UpdateDrawPWD(MD_DrawAccount drawa)
{
return(BSPData.RDBS.UpdateDrawPWD(drawa));
}
/// <summary>
/// 更新绑定银行卡信息
/// </summary>
/// <param name="drawa"></param>
/// <returns></returns>
public static string UpdateDrawCardInfo(MD_DrawAccount drawa)
{
return(BSPData.RDBS.UpdateDrawCardInfo(drawa));
}
