/// <summary>
/// 设置会员积分
/// </summary>
/// <param name="pUserId"></param>
/// <param name="pIntegral"></param>
/// <returns></returns>
public string SetUserIntegral(int pUserID, int pFK_All, string pIdentifier, int pIntegral, string pOperator, string pRemark)
{
string sWhere = string.Empty;
if (pIntegral > 0)
{
sWhere = "where UserSN={1}";
}
else
{
sWhere = "where UserSN={1} and UserIntegral+{0}>=0";//扣除积分时不能超过他本身
}
string sSQL = string.Format("update User_Info set UserIntegral=UserIntegral+{0}" + sWhere, pIntegral, pUserID);
if (curHelp.Update(sSQL) > 0)
{
Log_SetUserIntegralM mod = new Log_SetUserIntegralM();
mod.FK_User = pUserID;
mod.FK_All = pFK_All;
mod.Operator = pOperator;
mod.SetValue = pIntegral;
mod.Remark = pRemark;
mod.Fract_Identifier = pIdentifier;
if (new Log_SetUserIntegralL(this.curHelp).Add(mod))
{
if (pIntegral < 0)
{
string sql = "update User_Info set UserConsumeIntegral=UserConsumeIntegral+" + (-pIntegral) + " where UserSN=" + pUserID;
if (this.curHelp.Update(sql) > 0)
{
//成功
}
else
{
return("消耗积分设置失败");
}
}
//成功
}
else
{
return("设置积分成功,但日志添加失败");
}
}
else
{
return("会员积分 设置失败");
}
return("1");
}
public bool Add(Log_SetUserIntegralM pMod)
{
pMod.IP = HttpContext.Current.Request.UserHostAddress;
const string sSQL = "insert into Log_SetUserIntegral(FK_User,FK_All,Operator,Fract_Identifier,SetValue,Remark,IP) values(@FK_User,@FK_All,@Operator,@Fract_Identifier,@SetValue,@Remark,@IP)";
IDataParameter[] dp =
{
DbHelp.Def.AddParam("@FK_User", pMod.FK_User),
DbHelp.Def.AddParam("@FK_All", pMod.FK_All),
DbHelp.Def.AddParam("@Operator", pMod.Operator),
DbHelp.Def.AddParam("@Fract_Identifier", pMod.Fract_Identifier),
DbHelp.Def.AddParam("@SetValue", pMod.SetValue),
DbHelp.Def.AddParam("@Remark", pMod.Remark),
DbHelp.Def.AddParam("@IP", pMod.IP),
};
return(curHelp.Update(sSQL, dp) > 0);
}
