contentmanage.cs

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

                DataTable dtss = DbHelper.ExecuteTable(CommandType.Text, getSQL, null);
                if (dtss != null && dtss.Rows.Count > 0)
                {
                    Sql = "delete from " + Pre + "news_URL where NewsId='" + dtss.Rows[0]["NewsID"].ToString() + "'";
                    DbHelper.ExecuteNonQuery(CommandType.Text, Sql, null);
                    string sSql = "update " + dtss.Rows[0]["DataLib"].ToString() + " set isFiles=0 where NewsId='" + dtss.Rows[0]["NewsID"].ToString() + "'";
                    DbHelper.ExecuteNonQuery(CommandType.Text, sSql, null);
                    dtss.Clear(); dtss.Dispose();
                }
            }
            #endregion
        }

        /// <summary>
        /// 得到新闻是否有附件
        /// </summary>
        /// <param name="ID"></param>
        /// <returns></returns>
        public int getFileIDTF(int ID)
        {
            int intflg = 0;
            string Sql = "select id from " + Pre + "news_URL where ID='" + ID + "'";
            DataTable rdr = DbHelper.ExecuteTable(CommandType.Text, Sql, null);
            if (rdr != null)
            {
                if (rdr.Rows.Count > 0)
                {
                    intflg = 1;
                }
                rdr.Clear(); rdr.Dispose();
            }
            return intflg;
        }
        /// <summary>
        /// 得到新闻附件地址
        /// </summary>
        /// <param name="ID"></param>
        /// <returns></returns>
        public string getNewsAccessory(int ID)
        {
            SqlParameter param = new SqlParameter("@ID", ID);
            string Sql = "select FileURL from " + Pre + "news_URL where ID=@ID";
            return Convert.ToString(DbHelper.ExecuteScalar(CommandType.Text, Sql, param));
        }

        /// <summary>
        /// 插入投票
        /// </summary>
        /// <param name="uc2"></param>
        public void addUpdate_Vote(NetCMS.Model.VoteContent uc, int flag)
        {
            string Sql = null;
            if (flag == 0)
            {
                Sql = "insert into " + Pre + "news_vote(";
                Sql += "voteNum,voteTitle,voteContent,creattime,ismTF,isMember,NewsID,DataLib,SiteID,isTimeOutTime";
                Sql += ") values (";
                Sql += "@voteNum,@voteTitle,@voteContent,@creattime,@ismTF,@isMember,@NewsID,@DataLib,@SiteID,@isTimeOutTime)";
            }
            else if (flag == 1)
            {
                Sql = "Update " + Pre + "news_vote set voteTitle=@voteTitle,voteContent=@voteContent,creattime=@creattime,ismTF=@ismTF,isMember=@isMember,isTimeOutTime=@isTimeOutTime where NewsId='" + uc.NewsID + "' and SiteID='" + NetCMS.Global.Current.SiteID + "'";
            }
            SqlParameter[] parm = intsertVoteParameters(uc);
            DbHelper.ExecuteNonQuery(CommandType.Text, Sql, parm);
        }

        /// <summary>
        /// 获取VoteContent构造(插入)
        /// </summary>
        /// <param name="uc"></param>
        /// <returns></returns>
        private SqlParameter[] intsertVoteParameters(NetCMS.Model.VoteContent ucv)
        {
            #region
            SqlParameter[] param = new SqlParameter[10];
            param[0] = new SqlParameter("@voteNum", SqlDbType.NVarChar, 20);
            param[0].Value = ucv.voteNum;
            param[1] = new SqlParameter("@voteTitle", SqlDbType.NVarChar, 100);
            param[1].Value = ucv.voteTitle;
            param[2] = new SqlParameter("@voteContent", SqlDbType.NText);
            param[2].Value = ucv.voteContent;
            param[3] = new SqlParameter("@creattime", SqlDbType.DateTime, 8);
            param[3].Value = ucv.creattime;
            param[4] = new SqlParameter("@ismTF", SqlDbType.TinyInt, 1);
            param[4].Value = ucv.ismTF;
            param[5] = new SqlParameter("@isMember", SqlDbType.TinyInt, 1);
            param[5].Value = ucv.isMember;
            param[6] = new SqlParameter("@NewsID", SqlDbType.NVarChar, 12);
            param[6].Value = ucv.NewsID;
            param[7] = new SqlParameter("@DataLib", SqlDbType.NVarChar, 20);
            param[7].Value = ucv.DataLib;
            param[8] = new SqlParameter("@SiteID", SqlDbType.NVarChar, 12);
            param[8].Value = ucv.SiteID;
            param[9] = new SqlParameter("@isTimeOutTime", SqlDbType.DateTime, 8);
            param[9].Value = ucv.isTimeOutTime;
            return param;
            #endregion
        }

        /// <summary>
        /// 获取VoteContent构造（更新）
        /// </summary>
        /// <param name="uc"></param>
        /// <returns></returns>
        private SqlParameter[] updateVoteParameters(NetCMS.Model.VoteContent ucv)
        {
            #region
            SqlParameter[] param = new SqlParameter[7];
            param[0] = new SqlParameter("@voteTitle", SqlDbType.NVarChar, 100);
            param[0].Value = ucv.voteTitle;
            param[1] = new SqlParameter("@voteContent", SqlDbType.NText);
            param[1].Value = ucv.voteContent;
            param[2] = new SqlParameter("@creattime", SqlDbType.DateTime, 8);
            param[2].Value = ucv.creattime;
            param[3] = new SqlParameter("@ismTF", SqlDbType.TinyInt, 1);
            param[3].Value = ucv.ismTF;
            param[4] = new SqlParameter("@isMember", SqlDbType.TinyInt, 1);
            param[4].Value = ucv.isMember;
            param[5] = new SqlParameter("@isTimeOutTime", SqlDbType.DateTime, 8);
            param[5].Value = ucv.isTimeOutTime;
            param[6] = new SqlParameter("@NewsID", SqlDbType.NVarChar, 12);
            param[6].Value = ucv.NewsID;
            return param;
            #endregion
        }

        /// <summary>
        /// 得到头条(NewsID)
        /// </summary>
        /// <param name="NewsID"></param>
        /// <param name="DataLib"></param>
        /// <returns></returns>
        public DataTable getTopline(string NewsID, string DataLib, int NewsTFNum)
        {
            string Sql = "select NewsTF,NewsID,DataLib,tl_style,tl_font,tl_size,tl_color,tl_space,tl_PicColor,tl_Title,tl_Width,SiteID,tl_SavePath from " + Pre + "news_topline where NewsID='" + NewsID + "' and SiteID='" + NetCMS.Global.Current.SiteID + "' and DataLib='" + DataLib + "' and NewsTF=" + NewsTFNum + "";
            DataTable rdr = DbHelper.ExecuteTable(CommandType.Text, Sql, null);
            return rdr;
        }

        /// <summary>
        /// ajax保存新闻
        /// </summary>
        /// <param name="Content"></param>
        /// <returns></returns>
        public string saveAjaxContent(string Content)
        {
            //删除今天前的新闻
            //string SqlTemp = "delete from " + Pre + "news_temp where CreatTime<>" + DateTime.Now.ToShortDateString() + "";
            //DbHelper.ExecuteNonQuery(CommandType.Text, SqlTemp, null);

            string _RandStr = NetCMS.Common.Rand.Number(12);
            //string Sql = "insert into " + Pre + "news_temp(";
            //Sql += "randNum,Content,CreatTime";
            //Sql += ") values (";
            //Sql += "'" + _RandStr + "','" + Content + "','" + DateTime.Now.ToShortDateString() + "')";
            //DbHelper.ExecuteNonQuery(CommandType.Text, Sql, null);
            return _RandStr;
        }

        /// <summary>
        /// 得到栏目中文名称
        /// </summary>
        /// <param name="ClassID"></param>
        /// <returns></returns>
        public string sel_cName(string ClassID, int flag)
        {
            #region
            string strflg = null;
            string Sql = null;
            if (flag == 0)
            {
                strflg = "没选择栏目";
                SqlParameter param = new SqlParameter("@ClassID", ClassID);
                Sql = "Select ClassCName From " + Pre + "news_class where ClassID=@ClassID";
                object obj = DbHelper.ExecuteScalar(CommandType.Text, Sql, param);
                if (obj != null)
                {
                    if (obj != DBNull.Value)
                        strflg = obj.ToString();
                    else
                        strflg = string.Empty;
                }
            }
            else if (flag == 1)
            {
                strflg = "没选择专题";
                Sql = "Select SpecialCName From " + Pre + "news_special where SpecialID='" + ClassID + "'";
                DataTable rdr = DbHelper.ExecuteTable(CommandType.Text, Sql, null);
                if (rdr != null)
                {
                    if (rdr.Rows.Count > 0)
                    {
                        strflg = rdr.Rows[0]["SpecialCName"].ToString();
                    }
                    rdr.Clear(); rdr.Dispose();
                }
            }
            return strflg;
            #endregion
        }

        #endregion 新闻

        #region 栏目开始
        public DataTable getClassContent(string ClassID, int flag)
        {
            #region
            SqlParameter Param = null;
            string Sql = null;
            if (flag == 0)// 得到栏目信息
            {
                Sql = "Select ClassID,ClassCName,ClassEName,ParentID,IsURL,Checkint,OrderID,Urladdress,Domain,ClassTemplet,ReadNewsTemplet,SavePath,SaveClassframe,ClassSaveRule,ClassIndexRule,NewsSavePath,NewsFileRule,PicDirPath,ContentPicTF,ContentPICurl,ContentPicSize,InHitoryDay,DataLib,SiteID,NaviShowtf,NaviPIC,NaviContent,MetaKeywords,MetaDescript,isDelPoint,Gpoint,iPoint,GroupNumber,FileName,isComm,NaviPosition,NewsPosition,Defineworkey From " + Pre + "news_class where ClassID='" + ClassID + "' " + NetCMS.Common.Public.getSessionStr() + "";
            }
            else if (flag == 1)// 得到父类型是否合法
            {
                Sql = "Select ClassID From " + Pre + "News_Class Where ClassID='" + ClassID + "' " + NetCMS.Common.Public.getSessionStr() + "";
            }
            else if (flag == 2)// 判断 栏目重复
            {
                Sql = "Select ClassEName From " + Pre + "news_class where ClassEName='" + ClassID + "'";
            }
            else if (flag == 3)// 得到自定义字段类型（修改）
            {
                Sql = "Select * From " + Pre + "News_Class where ClassID='" + ClassID + "'";
            }
            else if (flag == 4)// 得到某个自定义字段的值
            {
                Sql = "Select id,defineInfoId,defineCname,defineColumns,defineType,IsNull,defineValue,defineExpr,definedvalue,Type From " + Pre + "Define_Data where id=" + int.Parse(ClassID) + "";
            }
            else if (flag == 5)// 得到栏目列表的子类
            {
                Sql = "Select id,ClassID,ClassCName,ClassEname,ParentID,OrderID,IsURL,IsLock,[Domain],NaviShowtf,isPage From " + Pre + "News_Class Where isRecyle!=1 and ParentID='" + ClassID + "' order by OrderId desc,id desc";
            }
            else if (flag == 6)//得到栏目列表的子类
            {
                Sql = "Select isLock From " + Pre + "news_Class Where ClassID='" + ClassID + "' and SiteID='" + NetCMS.Global.Current.SiteID + "'";
            }
            else if (flag == 7)//得到最新新闻ID
            {
                Sql = "select Id from " + ClassID + " order by id desc";
            }
            else if (flag == 8)// 得到站点参数
            {
                Param = new SqlParameter("@ChannelID", ClassID);
                Sql = "select ClassTemplet,ReadNewsTemplet,SaveFileRule,SaveDirPath,SaveDirRule,PicSavePath,DataLib from " + Pre + "news_site where IsURL=0 and isRecyle=0 and isLock=0 and ChannelID=@ChannelID";
            }
            else if (flag == 9)//得到归档数字，并归档
            {
                Sql = "select id,CreatTime from " + Pre + "News Where ClassID='" + ClassID + "'";
            }