discuss.cs

最好用的站点内容管理系统 全部源代码都有

            param[2].Value = ActiveExpense;
            param[3] = new SqlParameter("@Anum", SqlDbType.Int, 4);
            param[3].Value = Anum;
            param[4] = new SqlParameter("@ActivePlan", SqlDbType.NVarChar, 200);
            param[4].Value = ActivePlan;
            param[5] = new SqlParameter("@Contactmethod", SqlDbType.NVarChar, 50);
            param[5].Value = Contactmethod;
            param[6] = new SqlParameter("@Cutofftime", SqlDbType.DateTime,8);
            param[6].Value = Cutofftime;
            param[7] = new SqlParameter("@CreaTime", SqlDbType.DateTime,8);
            param[7].Value = CreaTime;
            param[8] = new SqlParameter("@ALabel", SqlDbType.Int, 4);
            param[8].Value = ALabel;
            param[9] = new SqlParameter("@AIds", SqlDbType.NVarChar,18);
            param[9].Value = AIds;

            string Sql = "update " + Pre + "user_DiscussActive set Activesubject=@Activesubject,ActivePlace=@ActivePlace," +
                         "ActiveExpense=@ActiveExpense,Anum=@Anum,ActivePlan=@ActivePlan,Contactmethod=@Contactmethod," +
                         "Cutofftime=@Cutofftime,CreaTime=@CreaTime,ALabel=@ALabel where AId=@AIds";
            return DbHelper.ExecuteNonQuery(CommandType.Text, Sql, param);
            #endregion
        }
        #endregion

        #region discussManage_DC.aspx
        public string sel_userDisClass(string DcID, string indexnumber)
        {
            #region
            SqlParameter[] param = new SqlParameter[] { new SqlParameter("@DcID", DcID), new SqlParameter("@indexnumber", indexnumber) };
            string _str = "栏目不存在.";
            string Sql = null;
            if (indexnumber == "@")
            {
                Sql = "select Cname from " + Pre + "user_DiscussClass where DcID=@DcID";
            }
            else
            {
                Sql = "select Cname from " + Pre + "user_DiscussClass where DcID=@DcID and indexnumber=@indexnumber";
            }
            DataTable dt = DbHelper.ExecuteTable(CommandType.Text, Sql, param);
            if (dt != null)
            {
                if (dt.Rows.Count > 0)
                {
                    _str = dt.Rows[0]["Cname"].ToString();
                }
                dt.Clear(); dt.Dispose();
            }
            return _str;
            #endregion
        }
        #endregion

        #region discusssubclass_add.aspx
        public int add_discussClass(string DcID, string Cname, string Content, string indexnumber,bool flag)
        {
            #region
            SqlParameter[] param = new SqlParameter[4] ;
            param[0] = new SqlParameter("@DcID", SqlDbType.NVarChar, 50);
            param[0].Value  = DcID;
            param[1] =  new SqlParameter("@Cname", SqlDbType.NVarChar,50);
            param[1].Value  = Cname;
            param[2] =  new SqlParameter("@Content", SqlDbType.NVarChar,200);
            param[2].Value  = Content;
            param[3] =  new SqlParameter("@indexnumber", SqlDbType.NVarChar,50);
            param[3].Value  = indexnumber;
            string Sql = null;
            if (flag)
            {
                Sql = "insert into " + Pre + "User_DiscussClass(DcID,Cname,Content,indexnumber,SiteID,UserNum) values(@DcID,@Cname,@Content,@indexnumber,'" + NetCMS.Global.Current.SiteID + "','" + NetCMS.Global.Current.UserNum + "')";
            }
            else
            {
                Sql = "insert into " + Pre + "user_Vote(DtID,VoteID,votegenre,VoteNum,Voteitem) values(@DcID,@Cname,@Content,0,@indexnumber)";
            }
            return DbHelper.ExecuteNonQuery(CommandType.Text, Sql, param);
            #endregion
        }
        #endregion

        #region discussTopi_add.aspx
        public int add_discussTopic(string DtID, string Title, string Content, int source, string DtUrl, string UserNum, DateTime creatTime, DateTime voteTime, string DisID)
        {
            #region
            SqlParameter[] param = new SqlParameter[9];
            param[0] = new SqlParameter("@DtID", SqlDbType.NVarChar, 12);
            param[0].Value = DtID;
            param[1] = new SqlParameter("@Title", SqlDbType.NVarChar, 200);
            param[1].Value = Title;
            param[2] = new SqlParameter("@Content", SqlDbType.NText);
            param[2].Value = Content;
            param[3] = new SqlParameter("@source", SqlDbType.Int, 4);
            param[3].Value = source;
            param[4] = new SqlParameter("@DtUrl", SqlDbType.NVarChar, 50);
            param[4].Value = DtUrl;
            param[5] = new SqlParameter("@UserNum", SqlDbType.NVarChar, 15);
            param[5].Value = UserNum;
            param[6] = new SqlParameter("@creatTime", SqlDbType.DateTime, 8);
            param[6].Value = creatTime;
            param[7] = new SqlParameter("@voteTime", SqlDbType.DateTime, 8);
            param[7].Value = voteTime;
            param[8] = new SqlParameter("@DisID", SqlDbType.NVarChar, 18);
            param[8].Value = DisID;
            string Sql = "insert into " + Pre + "User_DiscussTopic(DtID,Title,Content,source,DtUrl,UserNum,ParentID,creatTime,voteTime,DisID,VoteTF) values(@DtID,@Title,@Content,@source,@DtUrl,@UserNum,'0',@creatTime,@voteTime,@DisID,0)";
            return DbHelper.ExecuteNonQuery(CommandType.Text, Sql, param);
            #endregion
        }
        #endregion

        #region discussTopi_ballot.aspx
        public int add_userDiscussTopic(string DtID, string Title, string Content, string UserNum, DateTime creatTime, DateTime voteTime, string DisID)
        {
            #region
            SqlParameter[] param = new SqlParameter[7];
            param[0] = new SqlParameter("@DtID", SqlDbType.NVarChar, 12);
            param[0].Value = DtID;
            param[1] = new SqlParameter("@Title", SqlDbType.NVarChar, 200);
            param[1].Value = Title;
            param[2] = new SqlParameter("@Content", SqlDbType.NText);
            param[2].Value = Content;
            param[3] = new SqlParameter("@UserNum", SqlDbType.NVarChar, 15);
            param[3].Value = UserNum;
            param[4] = new SqlParameter("@creatTime", SqlDbType.DateTime, 8);
            param[4].Value = creatTime;
            param[5] = new SqlParameter("@voteTime", SqlDbType.DateTime, 8);
            param[5].Value = voteTime;
            param[6] = new SqlParameter("@DisID", SqlDbType.NVarChar, 18);
            param[6].Value = DisID;
            string Sql = "insert into " + Pre + "User_DiscussTopic(DtID,Title,Content,source,UserNum,ParentID,creatTime," +
                         "voteTime,DisID,VoteTF) values(@DtID,@Title,@Content,0,@UserNum,'0',@creatTime,@voteTime,@DisID,1)";
            return DbHelper.ExecuteNonQuery(CommandType.Text, Sql, param);
            #endregion
        }
        #endregion

        #region discussTopi_commentary.aspx
        public void add_userDisTopic(NetCMS.Model.STADDDiscuss uc)
        {
            string Sql = "insert into " + Pre + "User_DiscussTopic(DtID,Title,Content,UserNum,ParentID,creatTime,DisID) values(@DtID,@Title,@Content,@UserNum,@ParentID,@creatTime,@DisID)";
            SqlParameter[] parm = Add_Parameters(uc);
            DbHelper.ExecuteNonQuery(CommandType.Text, Sql, parm);
        }

        private SqlParameter[] Add_Parameters(NetCMS.Model.STADDDiscuss uc1)
        {
            #region
            SqlParameter[] param = new SqlParameter[7];
            param[0] = new SqlParameter("@DtID", SqlDbType.NVarChar, 12);
            param[0].Value = uc1.DtID;
            param[1] = new SqlParameter("@Title", SqlDbType.NVarChar, 200);
            param[1].Value = uc1.Title;
            param[2] = new SqlParameter("@Content", SqlDbType.NText);
            param[2].Value = uc1.Content;
            param[3] = new SqlParameter("@UserNum", SqlDbType.NVarChar, 15);
            param[3].Value = uc1.UserNum;
            param[4] = new SqlParameter("@ParentID", SqlDbType.NVarChar, 12);
            param[4].Value = uc1.ParentID;
            param[5] = new SqlParameter("@creatTime", SqlDbType.DateTime, 8);
            param[5].Value = uc1.creatTime;
            param[6] = new SqlParameter("@DisID", SqlDbType.NVarChar, 18);
            param[6].Value = uc1.DisID;
            return param;
            #endregion
        }
        
        public int update_userVote(int VoteNumsel, string VoteID)
        {
            SqlParameter param = new SqlParameter("@VoteID", VoteID);
            string Sql = "update " + Pre + "User_Vote set VoteNum='" + VoteNumsel + "' where VoteID=@VoteID";
            return DbHelper.ExecuteNonQuery(CommandType.Text, Sql, param);
        }
        public void updateTopicDtID(string DtID, string title, string content)
        {
            #region
            SqlParameter[] param = new SqlParameter[3];
            param[0] = new SqlParameter("@DtID", SqlDbType.NVarChar, 12);
            param[0].Value = DtID;
            param[1] = new SqlParameter("@title", SqlDbType.NVarChar, 200);
            param[1].Value = title;
            param[2] = new SqlParameter("@content", SqlDbType.NText);
            param[2].Value = content;
            string Sql = "update " + Pre + "User_DiscussTopic set title=@title,content=@content where DtID=@DtID and UserNum='" + NetCMS.Global.Current.UserNum + "'";
            DbHelper.ExecuteNonQuery(CommandType.Text, Sql, param);
            #endregion
        }
        #endregion

        #region disFundwarehouse.aspx
        public int add_userGhistory(string GhID, string UserNum, int gPoint1, int iPoint1, DateTime Creatime)
        {
            #region
            SqlParameter[] param = new SqlParameter[4];
            param[0] = new SqlParameter("@GhID", SqlDbType.NVarChar, 12);
            param[0].Value = GhID;
            param[1] = new SqlParameter("@UserNum", SqlDbType.NVarChar, 15);
            param[1].Value = UserNum;
            param[2] = new SqlParameter("@gPoint1", SqlDbType.Int, 4);
            param[2].Value = gPoint1;
            param[3] = new SqlParameter("@iPoint1", SqlDbType.Int, 4);
            param[3].Value = iPoint1;
            param[3] = new SqlParameter("@Creatime", SqlDbType.DateTime, 8);
            param[3].Value = Creatime;

            string Sql = "insert into " + Pre + "User_Ghistory(GhID,UserNUM,Gpoint,iPoint,ghtype,Money,CreatTime) values(@GhID,@UserNum,@gPoint1,@iPoint1,0,0,@Creatime)";
            return DbHelper.ExecuteNonQuery(CommandType.Text, Sql, param);
            #endregion
        }

        public int add_userDisCon(string Fundwarehouse2, string UserNum, string DisID, DateTime Creatime)
        {
            #region
            SqlParameter[] param = new SqlParameter[4];
            param[0] = new SqlParameter("@Fundwarehouse2", SqlDbType.NVarChar, 50);
            param[0].Value = Fundwarehouse2;
            param[1] = new SqlParameter("@UserNum", SqlDbType.NVarChar, 12);
            param[1].Value = UserNum;
            param[2] = new SqlParameter("@DisID", SqlDbType.NVarChar, 12);
            param[2].Value = DisID;
            param[3] = new SqlParameter("@Creatime", SqlDbType.DateTime, 8);
            param[3].Value = Creatime;
            string Sql = "insert into " + Pre + "User_DiscussContribute(Membermoney,Member,DisID,Creatime) values(@Fundwarehouse2,@UserNum,@DisID,@Creatime)";
            return DbHelper.ExecuteNonQuery(CommandType.Text, Sql, param);
            #endregion
        }
        #endregion

        #region up_discussManage.aspx
        public DataTable sel_userDiscuss(string DID, string UserName)
        {
            SqlParameter[] param = new SqlParameter[] { new SqlParameter("@DisID", DID), new SqlParameter("@UserName", UserName) };
            string Sql = "select Cname,Authority,Authoritymoney,D_Content,D_anno,ClassID from " + Pre + "user_Discuss where DisID=@DisID and UserName=@UserName";
            return DbHelper.ExecuteTable(CommandType.Text, Sql, param);
        }
        public int update_userDis(string Cname, string Authority, string Authoritymoney, string D_Content, string D_anno, DateTime Creatime, string ClassID, string Did, string UserName1)
        {
            #region
            SqlParameter[] param = new SqlParameter[9];
            param[0] = new SqlParameter("@Cname",SqlDbType.NVarChar,100);
            param[0].Value = Cname;
            param[1] = new SqlParameter("@Authority",SqlDbType.NVarChar,12);
            param[1].Value = Authority;
            param[2] = new SqlParameter("@Authoritymoney",SqlDbType.NVarChar,12);
            param[2].Value = Authoritymoney;
            param[3] = new SqlParameter("@D_Content",SqlDbType.NVarChar,200);
            param[3].Value = D_Content;
            param[4] = new SqlParameter("@D_anno",SqlDbType.NVarChar,200);
            param[4].Value = D_anno;
            param[5] = new SqlParameter("@Creatime",SqlDbType.DateTime,8);
            param[5].Value = Creatime;
            param[6] = new SqlParameter("@ClassID",SqlDbType.NVarChar,50);
            param[6].Value = ClassID;
            param[7] = new SqlParameter("@Did",SqlDbType.NVarChar,50);
            param[7].Value = Did;
            param[8] = new SqlParameter("@UserName1",SqlDbType.NVarChar,15);
            param[8].Value = UserName1;
            string Sql = "update " + Pre + "user_Discuss set Cname=@Cname,Authority=@Authority,Authoritymoney=@Authoritymoney,D_Content=@D_Content,D_anno=@D_anno,Creatime=@Creatime,ClassID=@ClassID where DisID=@Did and UserName=@UserName1";
            return DbHelper.ExecuteNonQuery(CommandType.Text, Sql, param);
            #endregion
        }
        #endregion
    }
}