private void Add() { if (banH.IsBan()) { msgAjax.Error("ban"); return; } int userID = 0; if (LoginInfo.IsLogin()) { } else { userID = LoginInfo.UserID; } string sDetail = Server.HtmlEncode(Req.GetForm("content")); if (sDetail.Length == 0) { msgAjax.Error("input"); return; } if (sDetail.Length == 0 || sDetail.Length > 600) { msgAjax.Error("nobuy"); return; } News_MsgM mod = new News_MsgM(); mod.FK_User = userID; mod.FK_News = id; mod.Detail = sDetail; mod.Purview = 1; mod.IP = Request.UserHostAddress; NewsMsg_TransM tmod = new NewsMsg_TransM(); tmod.mod = mod; DbHelp.ExecuteTrans(new DbHelpParam(), this.NewsEval_Trans, tmod); if (tmod.returnValue == "1") { msgAjax.Success("1"); } else { msgAjax.Error(tmod.returnValue); } }
public static int Add(News_MsgM pMod) { string sql = "insert News_msg (FK_User,FK_News,Detail,Purview) values(@FK_User,@FK_News,@Detail,@Purview)"; IDataParameter[] param = { DbHelp.Def.AddParam("@FK_User", pMod.FK_User), DbHelp.Def.AddParam("@FK_News", pMod.FK_News), DbHelp.Def.AddParam("@Detail", pMod.Detail), DbHelp.Def.AddParam("@Purview", pMod.Purview) }; int count = DbHelp.Update(sql, param); return(count); }
private int NewsEval_Trans(IDbHelp thelp, object obj) { NewsMsg_TransM tmod = (NewsMsg_TransM)obj; News_MsgM mod = tmod.mod; string sql = "insert into News_Msg(FK_User,FK_News,Detail,Purview,IP) values(@FK_User,@FK_News,@Detail,@Purview,@IP)"; IDataParameter[] dp = { DbHelp.Def.AddParam("@FK_User", mod.FK_User), DbHelp.Def.AddParam("@FK_News", mod.FK_News), DbHelp.Def.AddParam("@Detail", mod.Detail), DbHelp.Def.AddParam("@Purview", mod.Purview), DbHelp.Def.AddParam("@IP", mod.IP), }; if (thelp.Update(sql, dp) > 0) { banH.Add(); //若用户登录 if (mod.FK_User > 0) { //增加积分或经验 string sname = DbHelp.First("select Title from News_Info where NewsSN=" + mod.FK_News); User_FractHandler.FractHandlerParam ufParam = new User_FractHandler.FractHandlerParam(mod.FK_User, "system", 1, "news_comment", "news_comment", "新闻评论 \"" + sname + "\""); ufParam.FK_All = mod.FK_News; string slog = new User_FractHandler(thelp).SetFract(ufParam); //string slog = new User_FractHandler(thelp).SetFract(mod.FK_User, "system", 1, "news_comment", "news_comment", "新闻评论 \"" + sname + "\""); if (slog != "1") { tmod.returnValue = slog; return(0); } } } else { tmod.returnValue = "nosubmit"; return(0); } tmod.returnValue = "1"; return(1); }