contentmanage.cs

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

        /// <param name="NewsTitle"></param>
        /// <param name="tb"></param>
        /// <returns></returns>
        public int newsTitletf(string NewsTitle, string dtable, string EditAction, string NewsID)
        {
            #region
            int intflg = 0;
            SqlParameter param = new SqlParameter("@NewsTitle", NewsTitle);
            string Sql = "";
            if (EditAction == "Edit")
            {
                Sql = "select ID from " + dtable + " where NewsTitle=@NewsTitle and NewsID!='" + NewsID + "'";
            }
            else
            {
                Sql = "select ID from " + dtable + " where NewsTitle=@NewsTitle";
            }
            DataTable rdr = DbHelper.ExecuteTable(CommandType.Text, Sql, param);
            if (rdr != null)
            {
                if (rdr.Rows.Count > 0) { intflg = 1; }
                rdr.Clear(); rdr.Dispose();
            }
            return intflg;
            #endregion
        }

        /// <summary>
        /// 插入常规
        /// </summary>
        /// <param name="_TempStr"></param>
        /// <param name="_URL"></param>
        /// <param name="_EmailURL"></param>
        /// <param name="_num"></param>
        public void iGen(string _TempStr, string _URL, string _EmailURL, int _num)
        {
            #region
            string SQLTF = "select id from " + Pre + "News_Gen where Cname='" + _TempStr.Trim() + "' and gType=" + _num + " and SiteID='" + NetCMS.Global.Current.SiteID + "'";
            DataTable rdr = DbHelper.ExecuteTable(CommandType.Text, SQLTF, null);
            if (rdr != null)
            {
                if (rdr.Rows.Count == 0)
                {
                    string Sql = "insert into " + Pre + "News_Gen(";
                    Sql += "Cname,gType,URL,EmailURL,isLock,SiteID";
                    Sql += ") values (";
                    Sql += "'" + _TempStr + "'," + _num + ",'" + _URL + "','" + _EmailURL + "',0,'" + NetCMS.Global.Current.SiteID + "')";
                    DbHelper.ExecuteNonQuery(CommandType.Text, Sql, null);
                }
                rdr.Clear(); rdr.Dispose();
            }
            #endregion
        }

        /// <summary>
        /// 插入栏目新记录
        /// </summary>
        /// <param name="uc2"></param>
        public void addUpdate_newsContent(NetCMS.Model.NewsContent uc, int flag)
        {
            #region
            string Sql = null;
            SqlParameter[] parm = insertNewsContentParameters(uc);
            if (flag == 0)
            {
                Sql = "insert into " + uc.DataLib + "(";
                Sql += "NewsID,NewsType,OrderID,NewsTitle,sNewsTitle,TitleColor,TitleITF,TitleBTF,CommLinkTF,SubNewsTF,URLaddress,PicURL,SPicURL,ClassID,Author,Souce,Tags,NewsProperty,NewsPicTopline,Templet,Content,vURL,naviContent,Click,CreatTime,EditTime,SavePath,FileName,FileEXName,ContentPicTF,ContentPicURL,ContentPicSize,CommTF,DiscussTF,TopNum,VoteTF,CheckStat,isLock,isRecyle,SiteID,DataLib,DefineID,isVoteTF,Editor,isHtml,isDelPoint,Gpoint,iPoint,GroupNumber,Metakeywords,Metadesc,isConstr,isFiles";
                Sql += ") values (";
                Sql += "@NewsID,@NewsType,@OrderID,@NewsTitle,@sNewsTitle,@TitleColor,@TitleITF,@TitleBTF,@CommLinkTF,@SubNewsTF,@URLaddress,@PicURL,@SPicURL,@ClassID,@Author,@Souce,@Tags,@NewsProperty,@NewsPicTopline,@Templet,@Content,@vURL,@naviContent,@Click,@CreatTime,'" + DateTime.Now + "',@SavePath,@FileName,@FileEXName,@ContentPicTF,@ContentPicURL,@ContentPicSize,@CommTF,@DiscussTF,@TopNum,@VoteTF,@CheckStat,@isLock,@isRecyle,@SiteID,@DataLib,@DefineID,@isVoteTF,@Editor,@isHtml,@isDelPoint,@Gpoint,@iPoint,@GroupNumber,@Metakeywords,@Metadesc,0,@isFiles)";
                DbHelper.ExecuteNonQuery(CommandType.Text, Sql, parm);
            }
            else if (flag == 1)
            {
                Sql = "Update " + uc.DataLib + " set NewsType=@NewsType,OrderID=@OrderID,NewsTitle=@NewsTitle,sNewsTitle=@sNewsTitle,TitleColor=@TitleColor,TitleITF=@TitleITF,TitleBTF=@TitleBTF,CommLinkTF=@CommLinkTF,SubNewsTF=@SubNewsTF,URLaddress=@URLaddress,PicURL=@PicURL,SPicURL=@SPicURL,ClassID=@ClassID,Author=@Author,Souce=@Souce,Tags=@Tags,NewsProperty=@NewsProperty,NewsPicTopline=@NewsPicTopline,Templet=@Templet,Content=@Content,vURL=@vURL,naviContent=@naviContent,Click=@Click,EditTime='" + DateTime.Now + "',ContentPicTF=@ContentPicTF,ContentPicURL=@ContentPicURL,ContentPicSize=@ContentPicSize,CommTF=@CommTF,DiscussTF=@DiscussTF,TopNum=@TopNum,VoteTF=@VoteTF,CheckStat=@CheckStat,DefineID=@DefineID,isVoteTF=@isVoteTF,Editor=@Editor,isHtml=@isHtml,isDelPoint=@isDelPoint,Gpoint=@Gpoint,iPoint=@iPoint,GroupNumber=@GroupNumber,Metakeywords=@Metakeywords,Metadesc=@Metadesc,isFiles=@isFiles,FileEXName=@FileEXName,FileName=@FileName where NewsId='" + uc.NewsID + "' " + NetCMS.Common.Public.getSessionStr() + "";
                DbHelper.ExecuteNonQuery(CommandType.Text, Sql, parm);
                string usql = "update " + uc.DataLib + " set islock=1 where NewsID='" + uc.NewsID + "' and substring(CheckStat,3,5)!='0|0|0'";
                DbHelper.ExecuteNonQuery(CommandType.Text, usql, parm);
                //删除新闻所属专题
                DbHelper.ExecuteNonQuery(CommandType.Text, "Delete From " + Pre + "special_news Where NewsID='" + uc.NewsID + "'", null);
            }

            //添加专题
            if (uc.SpecialID != null && uc.SpecialID != "")
            {
                string[] arr_specialID = uc.SpecialID.Split(',');
                for (int i = 0; i < arr_specialID.Length; i++)
                {
                    SqlParameter[] param1 = new SqlParameter[2];
                    param1[0] = new SqlParameter("@SpecialID", SqlDbType.NVarChar, 20);
                    param1[0].Value = arr_specialID[i].ToString();
                    param1[1] = new SqlParameter("@NewsID", SqlDbType.NVarChar, 12);
                    param1[1].Value = uc.NewsID;
                    Sql = "Insert Into " + Pre + "special_news(SpecialID,NewsID) Values(@SpecialID,@NewsID)";
                    DbHelper.ExecuteNonQuery(CommandType.Text, Sql, param1);
                }
            }
            #endregion
        }

        /// <summary>
        /// 获取NewsContent构造（修改）
        /// </summary>
        /// <param name="uc"></param>
        /// <returns></returns>
        private SqlParameter[] UpdateNewsContentParameters(NetCMS.Model.NewsContent uc)
        {
            #region
            SqlParameter[] param = new SqlParameter[45];
            param[0] = new SqlParameter("@NewsType", SqlDbType.TinyInt, 1);
            param[0].Value = uc.NewsType;
            param[1] = new SqlParameter("@OrderID", SqlDbType.TinyInt, 1);
            param[1].Value = uc.OrderID;
            param[2] = new SqlParameter("@NewsTitle", SqlDbType.NVarChar, 100);
            param[2].Value = uc.NewsTitle;
            param[3] = new SqlParameter("@sNewsTitle", SqlDbType.NVarChar, 100);
            param[3].Value = uc.sNewsTitle;
            param[4] = new SqlParameter("@TitleColor", SqlDbType.NVarChar, 10);
            param[4].Value = uc.TitleColor;
            param[5] = new SqlParameter("@TitleITF", SqlDbType.TinyInt, 1);
            param[5].Value = uc.TitleITF;
            param[6] = new SqlParameter("@TitleBTF", SqlDbType.TinyInt, 1);
            param[6].Value = uc.TitleBTF;
            param[7] = new SqlParameter("@CommLinkTF", SqlDbType.TinyInt, 1);
            param[7].Value = uc.CommLinkTF;
            param[8] = new SqlParameter("@SubNewsTF", SqlDbType.TinyInt, 1);
            param[8].Value = uc.SubNewsTF;
            param[9] = new SqlParameter("@URLaddress", SqlDbType.NVarChar, 200);
            param[9].Value = uc.URLaddress;
            param[10] = new SqlParameter("@PicURL", SqlDbType.NVarChar, 200);
            param[10].Value = uc.PicURL;
            param[11] = new SqlParameter("@SPicURL", SqlDbType.NVarChar, 200);
            param[11].Value = uc.SPicURL;
            param[12] = new SqlParameter("@ClassID", SqlDbType.NVarChar, 12);
            param[12].Value = uc.ClassID;
            param[13] = new SqlParameter("@SpecialID", SqlDbType.NVarChar, 200);
            param[13].Value = "";
            param[14] = new SqlParameter("@Author", SqlDbType.NVarChar, 100);
            param[14].Value = uc.Author;
            param[15] = new SqlParameter("@Souce", SqlDbType.NVarChar, 100);
            param[15].Value = uc.Souce;
            param[16] = new SqlParameter("@Tags", SqlDbType.NVarChar, 100);
            param[16].Value = uc.Tags;
            param[17] = new SqlParameter("@NewsProperty", SqlDbType.NVarChar, 30);
            param[17].Value = uc.NewsProperty;
            param[18] = new SqlParameter("@Templet", SqlDbType.NVarChar, 200);
            param[18].Value = uc.Templet;
            param[19] = new SqlParameter("@Content", SqlDbType.NText);
            param[19].Value = uc.Content;
            param[20] = new SqlParameter("@naviContent", SqlDbType.NVarChar, 255);
            param[20].Value = uc.naviContent;
            param[21] = new SqlParameter("@ContentPicTF", SqlDbType.TinyInt, 1);
            param[21].Value = uc.ContentPicTF;
            param[22] = new SqlParameter("@ContentPicURL", SqlDbType.NVarChar, 200);
            param[22].Value = uc.ContentPicURL;
            param[23] = new SqlParameter("@ContentPicSize", SqlDbType.NVarChar, 10);
            param[23].Value = uc.ContentPicSize;
            param[24] = new SqlParameter("@CommTF", SqlDbType.TinyInt, 1);
            param[24].Value = uc.CommTF;
            param[25] = new SqlParameter("@DiscussTF", SqlDbType.TinyInt, 1);
            param[25].Value = uc.DiscussTF;
            param[26] = new SqlParameter("@TopNum", SqlDbType.Int, 4);
            param[26].Value = uc.TopNum;
            param[27] = new SqlParameter("@VoteTF", SqlDbType.TinyInt, 1);
            param[27].Value = uc.VoteTF;
            param[28] = new SqlParameter("@NewsPicTopline", SqlDbType.TinyInt, 1);
            param[28].Value = uc.NewsPicTopline;
            param[29] = new SqlParameter("@CheckStat", SqlDbType.NVarChar, 10);
            param[29].Value = uc.CheckStat;
            param[30] = new SqlParameter("@isLock", SqlDbType.TinyInt, 1);
            param[30].Value = uc.isLock;
            param[31] = new SqlParameter("@DefineID", SqlDbType.TinyInt, 1);
            param[31].Value = uc.DefineID;
            param[32] = new SqlParameter("@isVoteTF", SqlDbType.TinyInt, 1);
            param[32].Value = uc.isVoteTF;
            param[33] = new SqlParameter("@Editor", SqlDbType.NVarChar, 18);
            param[33].Value = uc.Editor;
            param[34] = new SqlParameter("@isHtml", SqlDbType.TinyInt, 1);
            param[34].Value = uc.isHtml;
            param[35] = new SqlParameter("@Click", SqlDbType.Int, 4);
            param[35].Value = uc.Click;
            param[36] = new SqlParameter("@isDelPoint", SqlDbType.TinyInt, 1);
            param[36].Value = uc.isDelPoint;
            param[37] = new SqlParameter("@Gpoint", SqlDbType.Int, 4);
            param[37].Value = uc.Gpoint;
            param[38] = new SqlParameter("@iPoint", SqlDbType.Int, 4);
            param[38].Value = uc.iPoint;
            param[39] = new SqlParameter("@GroupNumber", SqlDbType.NText);
            param[39].Value = uc.GroupNumber;
            param[40] = new SqlParameter("@NewsID", SqlDbType.NVarChar, 12);
            param[40].Value = uc.NewsID;
            param[41] = new SqlParameter("@DataLib", SqlDbType.NVarChar, 20);
            param[41].Value = uc.DataLib;
            param[42] = new SqlParameter("@Metakeywords", SqlDbType.NVarChar, 200);
            param[42].Value = uc.Metakeywords;
            param[43] = new SqlParameter("@Metadesc", SqlDbType.NVarChar, 200);
            param[43].Value = uc.Metadesc;
            param[44] = new SqlParameter("@isFiles", SqlDbType.TinyInt, 1);
            param[44].Value = uc.isFiles;
            return param;
            #endregion
        }

        /// <summary>
        /// 获取NewsContent构造(插入)
        /// </summary>
        /// <param name="uc"></param>
        /// <returns></returns>
        private SqlParameter[] insertNewsContentParameters(NetCMS.Model.NewsContent uc)
        {
            #region
            SqlParameter[] param = new SqlParameter[52];
            param[0] = new SqlParameter("@NewsID", SqlDbType.NVarChar, 12);
            param[0].Value = uc.NewsID;
            param[1] = new SqlParameter("@NewsType", SqlDbType.TinyInt, 1);
            param[1].Value = uc.NewsType;
            param[2] = new SqlParameter("@OrderID", SqlDbType.TinyInt, 1);
            param[2].Value = uc.OrderID;
            param[3] = new SqlParameter("@NewsTitle", SqlDbType.NVarChar, 100);
            param[3].Value = uc.NewsTitle;
            param[4] = new SqlParameter("@sNewsTitle", SqlDbType.NVarChar, 100);
            param[4].Value = uc.sNewsTitle;
            param[5] = new SqlParameter("@TitleColor", SqlDbType.NVarChar, 10);
            param[5].Value = uc.TitleColor;
            param[6] = new SqlParameter("@TitleITF", SqlDbType.TinyInt, 1);
            param[6].Value = uc.TitleITF;
            param[7] = new SqlParameter("@TitleBTF", SqlDbType.TinyInt, 1);
            param[7].Value = uc.TitleBTF;
            param[8] = new SqlParameter("@CommLinkTF", SqlDbType.TinyInt, 1);
            param[8].Value = uc.CommLinkTF;
            param[9] = new SqlParameter("@SubNewsTF", SqlDbType.TinyInt, 1);
            param[9].Value = uc.SubNewsTF;
            param[10] = new SqlParameter("@URLaddress", SqlDbType.NVarChar, 200);
            param[10].Value = uc.URLaddress;
            param[11] = new SqlParameter("@PicURL", SqlDbType.NVarChar, 200);
            param[11].Value = uc.PicURL;
            param[12] = new SqlParameter("@SPicURL", SqlDbType.NVarChar, 200);
            param[12].Value = uc.SPicURL;
            param[13] = new SqlParameter("@ClassID", SqlDbType.NVarChar, 12);
            param[13].Value = uc.ClassID;
            param[14] = new SqlParameter("@SpecialID", SqlDbType.NVarChar, 200);
            param[14].Value = "";
            param[15] = new SqlParameter("@Author", SqlDbType.NVarChar, 100);
            param[15].Value = uc.Author;
            param[16] = new SqlParameter("@Souce", SqlDbType.NVarChar, 100);
            param[16].Value = uc.Souce;
            param[17] = new SqlParameter("@Tags", SqlDbType.NVarChar, 100);
            param[17].Value = uc.Tags;
            param[18] = new SqlParameter("@NewsProperty", SqlDbType.NVarChar, 30);
            param[18].Value = uc.NewsProperty;
            param[19] = new SqlParameter("@Templet", SqlDbType.NVarChar, 200);
            param[19].Value = uc.Templet;