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