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)); }