Пример #1
0
        private void Add()
        {
            if (banH.IsBan())
            {
                msgAjax.Error("ban");
                return;
            }

            string sDetail = Server.HtmlEncode(Req.GetForm("content"));

            if (sDetail.Length == 0)
            {
                msgAjax.Error("input");
                return;
            }

            if (sDetail.Length > 600)
            {
                msgAjax.Error("above");
                return;
            }

            int userID = 0;

            if (!LoginInfo.IsLogin())
            {
                userID = LoginInfo.UserID;
            }

            CaiPu_MsgM mod = new CaiPu_MsgM();

            mod.FK_User = userID;
            mod.FK_Pro  = id;
            mod.Detail  = sDetail;
            mod.Purview = 1;
            mod.IP      = Request.UserHostAddress;

            CaiPuMsg_TransM tmod = new CaiPuMsg_TransM();

            tmod.mod = mod;

            DbHelp.ExecuteTrans(new DbHelpParam(), this.CaiPuEval_Trans, tmod);

            if (tmod.returnValue == "1")
            {
                msgAjax.Success("1");
            }
            else
            {
                msgAjax.Error(tmod.returnValue);
            }
        }
Пример #2
0
        private int CaiPuEval_Trans(IDbHelp thelp, object obj)
        {
            CaiPuMsg_TransM tmod = (CaiPuMsg_TransM)obj;
            CaiPu_MsgM      mod  = tmod.mod;


            string sSql = "insert into CaiPu_Msg(FK_User,FK_Pro,Detail,Purview,IP) values(@FK_User,@FK_Pro,@Detail,@Purview,@IP)";

            IDataParameter[] dp =
            {
                DbHelp.Def.AddParam("@FK_User", mod.FK_User),
                DbHelp.Def.AddParam("@FK_Pro",  mod.FK_Pro),
                DbHelp.Def.AddParam("@Detail",  mod.Detail),
                DbHelp.Def.AddParam("@Purview", mod.Purview),
                DbHelp.Def.AddParam("@IP",      mod.IP),
            };

            if (thelp.Update(sSql, dp) > 0)
            {
                banH.Add();

                //若用户登录
                if (mod.FK_User > 0)
                {
                    //增加积分或经验
                    string sname = DbHelp.First("select ProName from CaiPu_Info where ProSN=" + mod.FK_Pro);
                    User_FractHandler.FractHandlerParam ufParam = new User_FractHandler.FractHandlerParam(mod.FK_User, "system", 1, "caipu_comment", "caipu_comment", "菜谱评论 \"" + sname + "\"");
                    ufParam.FK_All = mod.FK_Pro;
                    string slog = new User_FractHandler(thelp).SetFract(ufParam);
                    //string slog = new User_FractHandler(thelp).SetFract(mod.FK_User, "system", 1, "caipu_comment", "caipu_comment", "菜谱评论 \"" + sname + "\"");
                    if (slog != "1")
                    {
                        tmod.returnValue = slog;
                        return(0);
                    }
                }
            }
            else
            {
                tmod.returnValue = "nosubmit";
                return(0);
            }

            tmod.returnValue = "1";
            return(1);
        }