/// <summary> /// 用户已付款 /// </summary> /// <param name="pUserID"></param> /// <param name="pMoney"></param> /// <param name="pRemark"></param> public string UserPay(int pUserID, double pMoney, string pOperator, string pRemark, string pNumber) { if (pMoney == 0) { return("1"); } if (pMoney > 0) { return("设置付款,金额应是负数"); } string sSQL = string.Format("update User_Info set UserMoney=UserMoney+{0},UserFreezeMoney=UserFreezeMoney+{0} where UserSN={1} and UserMoney+{0}>=0 and UserFreezeMoney+{0}>=0", pMoney, pUserID); if (curHelp.Update(sSQL) > 0) { string sMsg = string.Empty; //添加 冻结金额日志 Log_SetUserFreezeMoneyM freMod = new Log_SetUserFreezeMoneyM(); freMod.FK_User = pUserID; freMod.Number = pNumber; freMod.Operator = pOperator; freMod.SetFreezeMoney = pMoney; freMod.Remark = pRemark; if (!(new Log_SetUserFreezeMoneyL(this.curHelp).Add(freMod))) { return("设置冻结金额成功,但日志添加失败"); } //添加 预存款日志 Log_SetUserMoneyM mod = new Log_SetUserMoneyM(); mod.FK_User = pUserID; mod.Number = pNumber; mod.Operator = pOperator; mod.SetMoney = pMoney; mod.Remark = pRemark; if (new Log_SetUserMoneyL(this.curHelp).Add(mod)) { return("1"); } else { return("设置预存款成功,但日志添加失败"); } } else { return("会员预存款不足 或 解冻金额超出范围"); } }
public bool Add(Log_SetUserFreezeMoneyM pMod) { pMod.IP = HttpContext.Current.Request.UserHostAddress; const string sSQL = "insert into Log_SetUserFreezeMoney(FK_User,Number,Operator,SetFreezeMoney,Remark,IP) values(@FK_User,@Number,@Operator,@SetFreezeMoney,@Remark,@IP)"; IDataParameter[] dp = { DbHelp.Def.AddParam("@FK_User", pMod.FK_User), DbHelp.Def.AddParam("@Number", pMod.Number), DbHelp.Def.AddParam("@Operator", pMod.Operator), DbHelp.Def.AddParam("@SetFreezeMoney", pMod.SetFreezeMoney), DbHelp.Def.AddParam("@Remark", pMod.Remark), DbHelp.Def.AddParam("@IP", pMod.IP), }; return(curHelp.Update(sSQL, dp) > 0); }
/// <summary> /// 设置 冻结/解冻金额 /// </summary> /// <param name="pUserID"></param> /// <param name="pMoney"></param> /// <param name="pRemark">备注</param> /// <returns></returns> public string SetFreezeMoney(int pUserID, double pMoney, string pOperator, string pRemark, string pNumber) { if (pMoney == 0) { return("1"); } string sWhere = string.Empty; if (pMoney > 0) { sWhere = " where UserSN={1} and UserMoney>=(UserFreezeMoney+{0})";//冻结时不能超过会员的预存款 } else { sWhere = " where UserSN={1} and UserFreezeMoney+{0}>=0";//解冻时不能超过已冻结的金额 } string sSQL = string.Format("update User_Info set UserFreezeMoney=UserFreezeMoney+{0}" + sWhere, pMoney, pUserID); if (curHelp.Update(sSQL) > 0) { Log_SetUserFreezeMoneyM freMod = new Log_SetUserFreezeMoneyM(); freMod.FK_User = pUserID; freMod.Number = pNumber; freMod.Operator = pOperator; freMod.SetFreezeMoney = pMoney; freMod.Remark = pRemark; if (new Log_SetUserFreezeMoneyL(this.curHelp).Add(freMod)) { return("1"); } else { return("设置冻结金额成功,但日志添加失败");//设置冻结金额成功,但日志添加失败 } } else { return("解冻金额 设置失败");//冻结/解冻金额 设置失败 } }