public ActionResult AddRemit(UserRemit remit)
{
ViewData["referer"] = ShopUtils.GetAdminRefererCookie();
if (!Users.IsExistMobile(remit.Mobile))
{
return(PromptView("账号不存在"));
}
PartUserInfo user = Users.GetPartUserByMobile(remit.Mobile);
MD_Remit rmt = new MD_Remit
{
Uid = user.Uid,
Mobile = remit.Mobile,
Type = "人工充值",
Name = "系统充值",
Account = "系统充值",
Money = remit.Money,
Status = 0
};
bool addres = NewUser.AddUserRemit(rmt);
if (addres)
{
return(PromptView("添加成功"));
}
else
{
return(PromptView("添加失败"));
}
}
/// <summary>
/// 处理充值记录
/// </summary>
/// <param name="remitid"></param>
/// <param name="status"></param>
/// <returns></returns>
public ActionResult EditRemitState(int remitid, short status)
{
List <MD_Remit> list = NewUser.GetUserRemitList(1, -1, " where a.remitid=" + remitid);
if (list.Count == 0)
{
return(PromptView("用户转账记录不存在"));
}
MD_Remit bk = list[0];
if (status == 1)
{
bk.Status = 1;
}
bk.Updateuid = WorkContext.Uid;
bool result = NewUser.UpdateUserRemit(bk);
if (result)
{
return(PromptView("更新成功"));
}
else
{
return(PromptView("更新失败"));
}
}
/// <summary>
/// 添加用户转账记录
/// </summary>
/// <param name="rmt"></param>
/// <returns></returns>
public string AddUserRemit(MD_Remit rmt)
{
DbParameter[] parms =
{
//GenerateInParam("@mobile", SqlDbType.VarChar,15, rmt.Mobile),
GenerateInParam("@uid", SqlDbType.Int, 4, rmt.Uid),
GenerateInParam("@type", SqlDbType.VarChar, 20, rmt.Type),
GenerateInParam("@name", SqlDbType.VarChar, 50, rmt.Name),
GenerateInParam("@account", SqlDbType.VarChar, 50, rmt.Account),
GenerateInParam("@money", SqlDbType.Int, 4, rmt.Money),
GenerateInParam("@bankname", SqlDbType.VarChar, 50, rmt.Bankname),
GenerateInParam("@status", SqlDbType.Int, 4, rmt.Status)
};
string commandText = string.Format(@"
begin try
begin tran t1
INSERT INTO owzx_userremit([uid],[type],[name],[account],[money],[bankname],[status])
VALUES (@uid,@type,@name,@account,@money,@bankname,@status)
select '添加成功' state
commit tran t1
end try
begin catch
rollback tran t1
select ERROR_MESSAGE() state
end catch
");
return(RDBSHelper.ExecuteScalar(CommandType.Text, commandText, parms).ToString());
}
/// <summary>
/// 更新用户转账记录
/// </summary>
/// <param name="rmt"></param>
/// <returns></returns>
public static bool UpdateUserRemit(MD_Remit rmt)
{
string result = OWZX.Data.NewUser.UpdateUserRemit(rmt);
if (result.EndsWith("成功"))
{
return(true);
}
return(false);
}
public ActionResult EditRemit(int remitid, short status, int realmoney, string chargeremark, string remark)
{
ViewData["referer"] = ShopUtils.GetAdminRefererCookie();
List <MD_Remit> list = NewUser.GetUserRemitList(1, -1, " where a.remitid=" + remitid);
if (list.Count == 0)
{
return(PromptView("用户充值记录不存在"));
}
MD_Remit bk = list[0];
if (status == 1)
{
bk.Status = 1;
}
else
{
if (chargeremark == "")
{
return(PromptView("请输入充值审核备注"));
}
if (realmoney == 0)
{
return(PromptView("请输入实际转账金额"));
}
bk.RealMoney = realmoney;
bk.Remark = remark;
bk.ChargeRemark = chargeremark;
if (remark != "" && remark != null)
{
bk.Status = 3;
}
else
{
bk.Status = 2;
}
}
bk.Updateuid = WorkContext.Uid;
bool result = NewUser.UpdateUserRemit(bk);
if (result)
{
return(PromptView("更新成功"));
}
else
{
return(PromptView("更新失败"));
}
}
/// <summary>
/// 更新用户转账记录
/// </summary>
/// <param name="rmt"></param>
/// <returns></returns>
public string UpdateUserRemit(MD_Remit rmt)
{
DbParameter[] parms =
{
GenerateInParam("@remitid", SqlDbType.VarChar, 15, rmt.Remitid),
GenerateInParam("@remark", SqlDbType.VarChar, 200, rmt.Remark),
GenerateInParam("@chargeremark", SqlDbType.VarChar, 200, rmt.ChargeRemark),
GenerateInParam("@realmoney", SqlDbType.Int, 4, rmt.RealMoney),
GenerateInParam("@status", SqlDbType.Int, 4, rmt.Status),
GenerateInParam("@updateuid", SqlDbType.Int, 4, rmt.Updateuid),
};
string commandText = string.Format(@"
begin try
if exists(select 1 from owzx_userremit where remitid=@remitid )
begin
update a set
a.status = @status
,a.remark = @remark
,a.realmoney=@realmoney,a.chargeremark=@chargeremark
,a.updateuid = @updateuid
,a.updatetime = convert(varchar(25),getdate(),120)
from owzx_userremit a where a.remitid=@remitid
--添加账变记录
if(@status=2)
begin
INSERT INTO [owzx_accountchange]([uid] ,[changemoney],[remark])
select uid ,@realmoney,'充值'
from owzx_userremit where remitid=@remitid
update a set a.totalmoney=isnull(a.totalmoney,0)+@realmoney
from owzx_users a
join owzx_userremit b on a.uid=b.uid and b.remitid=@remitid
insert into owzx_message([uid],[title],[body])
select uid ,'充值'+cast(@realmoney as varchar(20))+'元到账通知','您充值的'+cast(@realmoney as varchar(20))+'元已经到账,请注意查收'
from owzx_userremit where remitid=@remitid
end
end
select '更新成功' state
end try
begin catch
select ERROR_MESSAGE() state
end catch
");
return(RDBSHelper.ExecuteScalar(CommandType.Text, commandText, parms).ToString());
}
/// <summary>
/// 处理充值记录
/// </summary>
/// <param name="remitid"></param>
/// <param name="status"></param>
/// <returns></returns>
public ActionResult EditRemit(int remitid, short status, string remark = "")
{
List <MD_Remit> list = NewUser.GetUserRemitList(1, -1, " where a.remitid=" + remitid);
if (list.Count == 0)
{
return(PromptView("用户转账记录不存在"));
}
MD_Remit bk = list[0];
if (status == 1)
{
bk.Status = 1;
}
else if (status == 2)
{
if (bk.RealMoney == 0)
{
return(PromptView("请输入实际转账金额"));
}
if (bk.Remark != "" && bk.Remark != null)
{
return(PromptView("已输入失败原因,不能完成转账"));
}
bk.Status = 2;
}
else if (status == 3)
{
if (bk.Remark == "")
{
return(PromptView("请输入失败原因"));
}
bk.Remark = remark;
bk.Status = 3;
}
bk.Updateuid = WorkContext.Uid;
bool result = NewUser.UpdateUserRemit(bk);
if (result)
{
return(PromptView("更新成功"));
}
else
{
return(PromptView("更新失败"));
}
}
/// <summary>
/// 提交充值信息
/// </summary>
/// <returns></returns>
public ActionResult AddRemit()
{
try
{
NameValueCollection parmas = WorkContext.postparms;
if (parmas.Keys.Count < 6 || (parmas.Keys.Count == 7 && !parmas.AllKeys.Contains("bankname")))
{
return(APIResult("error", "缺少请求参数"));
}
MD_Remit rmt = new MD_Remit
{
Mobile = parmas["account"],
Type = parmas["type"],
Name = parmas["name"],
Account = parmas["number"],
Money = int.Parse(parmas["money"]),
Status = 0
};
if (parmas.AllKeys.Contains("bankname"))
{
rmt.Bankname = parmas["bankname"];
}
bool addres = NewUser.AddUserRemit(rmt);
if (addres)
{
return(APIResult("success", "提交成功"));
}
else
{
return(APIResult("error", "提交失败"));
}
}
catch (Exception ex)
{
return(APIResult("error", "提交失败"));
}
}
/// <summary>
/// 处理充值记录 记录异常信息
/// </summary>
/// <param name="remitid"></param>
/// <param name="realmoney"></param>
/// <returns></returns>
public ActionResult EditRemitRemark(int remitid, string remark)
{
List <MD_Remit> list = NewUser.GetUserRemitList(1, -1, " where a.remitid=" + remitid);
if (list.Count == 0)
{
return(PromptView("用户转账记录不存在"));
}
MD_Remit bk = list[0];
bk.Remark = remark;
bk.Updateuid = WorkContext.Uid;
bool result = NewUser.UpdateUserRemit(bk);
if (result)
{
return(Content("1"));
}
else
{
return(Content("0"));
}
}
/// <summary>
/// 更新用户转账记录
/// </summary>
/// <param name="rmt"></param>
/// <returns></returns>
public static string UpdateUserRemit(MD_Remit rmt)
{
return(OWZX.Core.BSPData.RDBS.UpdateUserRemit(rmt));
}
/// <summary>
/// 添加用户转账记录
/// </summary>
/// <param name="rmt"></param>
/// <returns></returns>
public static string AddUserRemit(MD_Remit rmt)
{
return(OWZX.Core.BSPData.RDBS.AddUserRemit(rmt));
}
