contentmanage.cs

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

            else if (flag == 10)
            {
                Sql = "select NewsID,NewsTitle,PicURL,ClassID,CreatTime from " + Pre + "News where SiteID='" + NetCMS.Global.Current.SiteID + "' and Id='" + ClassID + "'";
            }
            else if (flag == 11)//得到不规则新闻
            {
                Sql = "Select unName,titleCSS,SubCSS,UnID,ONewsID,[Rows],unTitle,NewsTable From [" + Pre + "news_unNews] where UnID='" + ClassID + "'" + NetCMS.Common.Public.getSessionStr() + "";
            }
            else if (flag == 12)
            {
                Sql = "Select NewsID,NewsTitle,getNewsID,colsNum,DataLib,titleCSS From [" + Pre + "news_Sub] where NewsID='" + ClassID + "'" + NetCMS.Common.Public.getSessionStr() + "";
            }
            else if (flag == 13)
            {
                Param = new SqlParameter("@uID", ClassID);
                Sql = "Select [unName],[TitleCSS],[SubCSS],[ONewsID],[Rows],[unTitle],[NewsTable] From [" + Pre + "news_unNews] Where [UnID]=@uID Order By [Rows] Asc,[ID] Asc";
            }
            return DbHelper.ExecuteTable(CommandType.Text, Sql, Param);
            #endregion
        }

        /// <summary>
        /// 插入栏目新记录
        /// </summary>
        /// <param name="uc2"></param>
        public void addUpdate_ClassContent(NetCMS.Model.ClassContent uc, int flag)
        {
            #region
            string Sql = null;
            if (flag == 0)
            {
                Sql = "insert into " + Pre + "News_Class(";
                Sql += "ClassID,ClassCName,ClassEName,URLaddress,ParentID,IsURL,OrderID,NaviShowtf,NaviContent,NaviPIC,MetaKeywords,MetaDescript,SiteID,isLock,isRecyle,NaviPosition,Domain,ClassTemplet,ReadNewsTemplet,SavePath,SaveClassframe,Checkint,ClassSaveRule,ClassIndexRule,NewsSavePath,NewsFileRule,PicDirPath,ContentPicTF,ContentPICurl,ContentPicSize,InHitoryDay,isDelPoint,Gpoint,iPoint,GroupNumber,FileName,isComm,NewsPosition,Defineworkey,CreatTime,isPage,ModelID,isunHTML,DataLib";
                Sql += ") values (";
                Sql += "@ClassID,@ClassCName,@ClassEName,@URLaddress,@ParentID,@IsURL,@OrderID,@NaviShowtf,@NaviContent,@NaviPIC,@MetaKeywords,@MetaDescript,@SiteID,@isLock,@isRecyle,@NaviPosition,@Domain,@ClassTemplet,@ReadNewsTemplet,@SavePath,@SaveClassframe,@Checkint,@ClassSaveRule,@ClassIndexRule,@NewsSavePath,@NewsFileRule,@PicDirPath,@ContentPicTF,@ContentPICurl,@ContentPicSize,@InHitoryDay,@isDelPoint,@Gpoint,@iPoint,@GroupNumber,@FileName,@isComm,@NewsPosition,@Defineworkey,@CreatTime,0,'0',0,'" + Pre + "News')";
            }
            else if (flag == 1)
            {
                Sql = "Update " + Pre + "News_Class set ClassCName=@ClassCName,ClassEName=@ClassEName,URLaddress=@URLaddress,ParentID=@ParentID,IsURL=@IsURL,OrderID=@OrderID,NaviShowtf=@NaviShowtf,NaviContent=@NaviContent,NaviPIC=@NaviPIC,MetaKeywords=@MetaKeywords,MetaDescript=@MetaDescript,isLock=@isLock,isRecyle=@isRecyle,NaviPosition=@NaviPosition,Domain=@Domain,ClassTemplet=@ClassTemplet,ReadNewsTemplet=@ReadNewsTemplet,SavePath=@SavePath,SaveClassframe=@SaveClassframe,Checkint=@Checkint,ClassSaveRule=@ClassSaveRule,ClassIndexRule=@ClassIndexRule,NewsSavePath=@NewsSavePath,NewsFileRule=@NewsFileRule,PicDirPath=@PicDirPath,ContentPicTF=@ContentPicTF,ContentPICurl=@ContentPICurl,ContentPicSize=@ContentPicSize,InHitoryDay=@InHitoryDay,isDelPoint=@isDelPoint,Gpoint=@Gpoint,iPoint=@iPoint,GroupNumber=@GroupNumber,FileName=@FileName,isComm=@isComm,NewsPosition=@NewsPosition,Defineworkey=@Defineworkey,isPage=0,ModelID='0' where ClassID='" + uc.ClassID.ToString() + "' " + NetCMS.Common.Public.getSessionStr() + "";
            }
            SqlParameter[] parm = insertClassContentParameters(uc);
            DbHelper.ExecuteNonQuery(CommandType.Text, Sql, parm);
            #endregion
        }

        /// <summary>
        /// 获取ClassContent构造
        /// </summary>
        /// <param name="uc"></param>
        /// <returns></returns>
        private SqlParameter[] insertClassContentParameters(NetCMS.Model.ClassContent uc)
        {
            #region
            SqlParameter[] param = new SqlParameter[41];
            param[0] = new SqlParameter("@Defineworkey", SqlDbType.NVarChar, 255);
            param[0].Value = uc.Defineworkey;
            param[1] = new SqlParameter("@ClassID", SqlDbType.NVarChar, 12);
            param[1].Value = uc.ClassID;
            param[2] = new SqlParameter("@ClassCName", SqlDbType.NVarChar, 50);
            param[2].Value = uc.ClassCName;
            param[3] = new SqlParameter("@ClassEName", SqlDbType.NVarChar, 50);
            param[3].Value = uc.ClassEName;
            param[4] = new SqlParameter("@ParentID", SqlDbType.NVarChar, 12);
            param[4].Value = uc.ParentID;
            param[5] = new SqlParameter("@IsURL", SqlDbType.TinyInt, 1);
            param[5].Value = uc.IsURL;
            param[6] = new SqlParameter("@OrderID", SqlDbType.Int, 4);
            param[6].Value = uc.OrderID;
            param[7] = new SqlParameter("@URLaddress", SqlDbType.NVarChar, 200);
            param[7].Value = uc.URLaddress;
            param[8] = new SqlParameter("@Domain", SqlDbType.NVarChar, 150);
            param[8].Value = uc.Domain;
            param[9] = new SqlParameter("@ClassTemplet", SqlDbType.NVarChar, 200);
            param[9].Value = uc.ClassTemplet;
            param[10] = new SqlParameter("@ReadNewsTemplet", SqlDbType.NVarChar, 200);
            param[10].Value = uc.ReadNewsTemplet;
            param[11] = new SqlParameter("@SavePath", SqlDbType.NVarChar, 50);
            param[11].Value = uc.SavePath;
            param[12] = new SqlParameter("@SaveClassframe", SqlDbType.NVarChar, 200);
            param[12].Value = uc.SaveClassframe;
            param[13] = new SqlParameter("@Checkint", SqlDbType.TinyInt, 1);
            param[13].Value = uc.Checkint;
            param[14] = new SqlParameter("@ClassSaveRule", SqlDbType.NVarChar, 200);
            param[14].Value = uc.ClassSaveRule;
            param[15] = new SqlParameter("@ClassIndexRule", SqlDbType.NVarChar, 50);
            param[15].Value = uc.ClassIndexRule;
            param[16] = new SqlParameter("@NewsSavePath", SqlDbType.NVarChar, 50);
            param[16].Value = uc.NewsSavePath;
            param[17] = new SqlParameter("@NewsFileRule", SqlDbType.NVarChar, 200);
            param[17].Value = uc.NewsFileRule;
            param[18] = new SqlParameter("@PicDirPath", SqlDbType.NVarChar, 50);
            param[18].Value = uc.PicDirPath;
            param[19] = new SqlParameter("@ContentPicTF", SqlDbType.TinyInt, 1);
            param[19].Value = uc.ContentPicTF;
            param[20] = new SqlParameter("@ContentPICurl", SqlDbType.NVarChar, 200);
            param[20].Value = uc.ContentPICurl;
            param[21] = new SqlParameter("@ContentPicSize", SqlDbType.NVarChar, 15);
            param[21].Value = uc.ContentPicSize;
            param[22] = new SqlParameter("@InHitoryDay", SqlDbType.Int, 4);
            param[22].Value = uc.InHitoryDay;
            param[24] = new SqlParameter("@SiteID", SqlDbType.NVarChar, 12);
            param[24].Value = uc.SiteID;
            param[25] = new SqlParameter("@NaviShowtf", SqlDbType.TinyInt, 1);
            param[25].Value = uc.NaviShowtf;
            param[26] = new SqlParameter("@NaviPIC", SqlDbType.NVarChar, 200);
            param[26].Value = uc.NaviPIC;
            param[27] = new SqlParameter("@NaviContent", SqlDbType.NVarChar, 255);
            param[27].Value = uc.NaviContent;
            param[28] = new SqlParameter("@MetaKeywords", SqlDbType.NVarChar, 200);
            param[28].Value = uc.MetaKeywords;
            param[29] = new SqlParameter("@MetaDescript", SqlDbType.NVarChar, 200);
            param[29].Value = uc.MetaDescript;
            param[30] = new SqlParameter("@isDelPoint", SqlDbType.TinyInt, 1);
            param[30].Value = uc.isDelPoint;
            param[31] = new SqlParameter("@Gpoint", SqlDbType.Int, 4);
            param[31].Value = uc.Gpoint;
            param[32] = new SqlParameter("@iPoint", SqlDbType.Int, 4);
            param[32].Value = uc.iPoint;
            param[33] = new SqlParameter("@GroupNumber", SqlDbType.NVarChar, 255);
            param[33].Value = uc.GroupNumber;
            param[34] = new SqlParameter("@FileName", SqlDbType.NVarChar, 6);
            param[34].Value = uc.FileName;
            param[35] = new SqlParameter("@isLock", SqlDbType.TinyInt, 1);
            param[35].Value = uc.isLock;
            param[36] = new SqlParameter("@isRecyle", SqlDbType.TinyInt, 1);
            param[36].Value = uc.isRecyle;
            param[37] = new SqlParameter("@NaviPosition", SqlDbType.NVarChar, 255);
            param[37].Value = uc.NaviPosition;
            param[38] = new SqlParameter("@NewsPosition", SqlDbType.NVarChar, 255);
            param[38].Value = uc.NewsPosition;
            param[39] = new SqlParameter("@isComm", SqlDbType.TinyInt, 1);
            param[39].Value = uc.isComm;
            param[40] = new SqlParameter("@CreatTime", SqlDbType.DateTime, 8);
            param[40].Value = uc.CreatTime;

            return param;
            #endregion
        }

        /// <summary>
        /// 删除栏目到回收站
        /// </summary>
        /// <param name="ClassID"></param>
        public void del_newsInfos(string ClassID, int flag)
        {
            string str_sql = null;
            if (flag == 0)
            {
                str_sql = "Update " + Pre + "news_Class Set isRecyle=1 Where ClassID ='" + ClassID.ToString() + "' " + NetCMS.Common.Public.getSessionStr() + "";
            }
            else if (flag == 1)
            {
                str_sql = "Delete From " + Pre + "news_Class Where ClassID ='" + ClassID.ToString() + "' " + NetCMS.Common.Public.getSessionStr() + "";
            }
            else if (flag == 2)
            {
                str_sql = "delete from  " + Pre + "News_unNews where UnID='" + ClassID + "' and SiteID='" + NetCMS.Global.Current.SiteID + "'";
            }
            DbHelper.ExecuteNonQuery(CommandType.Text, str_sql, null);
            if (flag == 0)
            {
                del_News(ClassID, 1);
            }
            else if (flag == 1)
            {
                del_News(ClassID, 0);
            }
        }

        /// <summary>
        /// 得到栏目下的子类并彻底删除
        /// </summary>
        /// <param name="ParentID"></param>
        /// <returns></returns>

        public void GetChildClassdel(string ParentID, int flag)
        {
            #region
            string Sql = "select ClassID from " + Pre + "news_Class where ParentID=@ParentID";
            SqlParameter Param = new SqlParameter("@ParentID", ParentID);
            object obj = DbHelper.ExecuteScalar(CommandType.Text, Sql, Param);
            if (obj != null && obj != DBNull.Value)
            {
                if (flag == 0)
                {
                    del_newsInfos(obj.ToString(), 1);
                }
                else if (flag == 1)
                {
                    del_newsInfos(obj.ToString(), 0);
                }
                GetChildClassdel(obj.ToString(), flag);
            }
            #endregion
        }

        /// <summary>
        /// 删除栏目同时删除新闻
        /// </summary>
        /// <param name="ClassID"></param>
        public void del_News(string ClassID, int flag)
        {
            #region
            string Sql = null;
            if (flag == 0)
            {
                Sql = "Delete From " + Pre + "news Where ClassID ='" + ClassID.ToString() + "' and SiteID = '" + NetCMS.Global.Current.SiteID + "'";
            }
            else if (flag == 1)// 删除栏目同时更新新闻到回收站
            {
                Sql = "Update " + Pre + "news set isRecyle=1 Where ClassID ='" + ClassID.ToString() + "' and SiteID = '" + NetCMS.Global.Current.SiteID + "'";
            }
            else if (flag == 2)
            {
                Sql = "Delete From " + Pre + "news_Class Where ClassID='" + ClassID + "' and SiteID = '" + NetCMS.Global.Current.SiteID + "'";
            }
            else if (flag == 3)
            {
                Sql = "delete From " + Pre + "News where ClassID='" + ClassID.ToString() + "'" + NetCMS.Common.Public.getSessionStr() + "";
            }
            else if (flag == 4)
            {
                Sql = "Update " + Pre + "news_Class Set ParentID=0 Where isLock=0 and isRecyle=0";
                if (ClassID != null)
                    Sql += " and ClassID In(" + ClassID + ")";
            }
            else if (flag == 5)
            {
                string dSql = "select NewsID from " + Pre + "News where id=" + ClassID;
                object obj = DbHelper.ExecuteScalar(CommandType.Text, dSql, null);
                if (obj != null && obj != DBNull.Value)
                {
                    del_News(obj.ToString(), 6);
                }
                Sql = "delete from " + Pre + "News where Id=" + ClassID + " " + NetCMS.Common.Public.getSessionStr();
            }
            else if (flag == 6)
            {
                Sql = "delete from " + Pre + "News_Sub where NewsID='" + ClassID + "' and SiteID='" + NetCMS.Global.Current.SiteID + "'";
            }
            DbHelper.ExecuteNonQuery(CommandType.Text, Sql, null);
            #endregion
        }

        /// <summary>
        /// 得到栏目列表的子类
        /// </summary>
        /// <returns></returns>
        public void ChangeLock(string ClassID, int NUM)
        {
            string str_sql = "Update " + Pre + "ne