/// <summary> /// 设置会员等级 /// </summary> /// <param name="pUserId"></param> /// <param name="pLevel"></param> public string SetUserLevel(int pUserID, int pLevel, string pOperator, string pRemark) { string sSQL = "update User_Info set FK_User_Level=" + pLevel + " where UserSN=" + pUserID; if (curHelp.Update(sSQL) > 0) { Log_SetUserLevelM mod = new Log_SetUserLevelM(); mod.FK_User = pUserID; mod.Operator = pOperator; mod.SetLevel = pLevel; mod.Remark = pRemark; if (new Log_SetUserLevelL(this.curHelp).Add(mod)) { return("1"); } else { return("设置等级成功,但日志添加失败"); } } else { return("会员等级 设置失败"); } }
public bool Add(Log_SetUserLevelM pMod) { pMod.IP = HttpContext.Current.Request.UserHostAddress; const string sSQL = "insert into Log_SetUserLevel(FK_User,Operator,SetLevel,Remark,IP) values(@FK_User,@Operator,@SetLevel,@Remark,@IP)"; IDataParameter[] dp = { DbHelp.Def.AddParam("@FK_User", pMod.FK_User), DbHelp.Def.AddParam("@Operator", pMod.Operator), DbHelp.Def.AddParam("@SetLevel", pMod.SetLevel), DbHelp.Def.AddParam("@Remark", pMod.Remark), DbHelp.Def.AddParam("@IP", pMod.IP), }; return(curHelp.Update(sSQL, dp) > 0); }