channel.cs

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

            else
            {
                return 0;
            }
        }

        public int lockstat(int ClassID, int num)
        {
            SqlParameter param = new SqlParameter("@ClassID", ClassID);
            string sql = "update " + Pre + "sys_channelclass set islock=" + num + " where Id=@ClassID";
            return DbHelper.ExecuteNonQuery(CommandType.Text, sql, param);
        }


        public void utilClass(int sClassID, int tClassID, int ChID)
        {
            //Copy content
            SqlParameter param = new SqlParameter("@ChID", ChID);
            string sql = "select DataLib from " + Pre + "sys_channel where ID=@ChID";
            string dbTable = Convert.ToString(DbHelper.ExecuteScalar(CommandType.Text, sql, param));
            if (dbTable != string.Empty)
            {
                string usql = "update " + dbTable + " set ClassID=" + tClassID + " where ClassID=" + sClassID + "";
                DbHelper.ExecuteNonQuery(CommandType.Text, usql, null);
            }
            //更新源栏目下级的父类
            string ssql = "select ParentID from " + Pre + "sys_channelclass where ID=" + sClassID + "";
            string ParentID = Convert.ToString(DbHelper.ExecuteScalar(CommandType.Text, ssql, null));
            if (ParentID != string.Empty)
            {
                string usql = "update " + Pre + "sys_channelclass set ParentID=" + int.Parse(ParentID) + " where ParentID=" + sClassID + "";
                DbHelper.ExecuteNonQuery(CommandType.Text, usql, null);
            }
            //删除源栏目
            string delsql = "delete from " + Pre + "sys_channelclass where id=" + sClassID + "";
            DbHelper.ExecuteNonQuery(CommandType.Text, delsql, null);
        }

        public void moveClass(int sClassID, int tClassID)
        {
            string sql = "update " + Pre + "sys_channelclass set ParentID=" + tClassID + " where Id=" + sClassID + "";
            DbHelper.ExecuteNonQuery(CommandType.Text, sql, null);
        }

        #endregion
        #region 内容部分
        public DataTable GetChannelValueFormInfo(int ChID, string DTable, int ID)
        {
            SqlParameter[] param = new SqlParameter[2];
            param[0] = new SqlParameter("@ChID", SqlDbType.Int, 4);
            param[0].Value = ChID;
            param[1] = new SqlParameter("@ID", SqlDbType.Int, 4);
            param[1].Value = ID;
            string sql = string.Empty;
            if (ID != 0)
            {
                sql = "select a.*,b.* from " + Pre + "sys_channelvalue a," + DTable + " b where a.ChID=@ChID and b.ID=@ID and a.isLock=0 order by a.OrderID desc,a.id desc";
            }
            else
            {
                sql = "select * from " + Pre + "sys_channelvalue where ChID=@ChID and isLock=0 order by OrderID desc,id desc";
            }
            return DbHelper.ExecuteTable(CommandType.Text, sql, param);
        }

        public DataTable GetChannelUserValueFormInfo(int ChID, string DTable, int ID)
        {
            SqlParameter[] param = new SqlParameter[2];
            param[0] = new SqlParameter("@ChID", SqlDbType.Int, 4);
            param[0].Value = ChID;
            param[1] = new SqlParameter("@ID", SqlDbType.Int, 4);
            param[1].Value = ID;
            string sql = string.Empty;
            if (ID != 0)
            {
                sql = "select a.*,b.* from " + Pre + "sys_channelvalue a," + DTable + " b where a.ChID=@ChID and b.ID=@ID and a.isLock=0 and a.isUser=1 order by a.OrderID desc,a.id desc";
            }
            else
            {
                sql = "select * from " + Pre + "sys_channelvalue where ChID=@ChID and isLock=0 and isUser=1 order by OrderID desc,id desc";
            }
            return DbHelper.ExecuteTable(CommandType.Text, sql, param);
        }

        public DataTable GetPage(string keywords, string islock, string author, string ClassID, string SpecialID, string stat, int ChID, string dbTable, int PageIndex, int PageSize, out int RecordCount, out int PageCount, params SQLConditionInfo[] SqlCondition)
        {
            string sFilter = " where a.ChID=" + ChID + " and a.ClassID=b.id";
            if (ClassID != "#0")
            {
                sFilter += " and a.ClassID=" + int.Parse(ClassID) + "";
            }
            if (islock != "#0")
            {
                sFilter += " and a.islock=" + int.Parse(islock) + "";
            }
            if (SpecialID != "#0")
            {
                sFilter += " and a.SpecialID like '%" + SpecialID + "%'";
            }
            if (keywords != "#0")
            {
                sFilter += " and (a.Content like '%" + keywords + "%' or a.Author like '%" + keywords + "%' or a.Title like '%" + keywords + "%')";
            }
            string gSQLstr = "order by a.OrderID desc";
            if (stat != "#0")
            {
                switch (stat)//推荐|热点|幻灯|滚动|头条
                {
                    case "rec":
                        sFilter += "  And ContentProperty like '1%'";
                        break;
                    case "hot":
                        sFilter += " And ContentProperty like '__1%'";
                        break;
                    case "filt":
                        sFilter += " And ContentProperty like '____1%'";
                        break;
                    case "mar":
                        sFilter += " And ContentProperty like '______1%'";
                        break;
                    case "hnews":
                        sFilter += " And ContentProperty like '________1%'";
                        break;
                    case "constr":
                        sFilter += " and isConstr=1";
                        break;
                    case "isadmin":
                        sFilter += " and isConstr=0";
                        break;
                    case "unlock":
                        sFilter += " and a.islock=0";
                        break;
                    case "lock":
                        sFilter += " and a.islock=1";
                        break;
                    case "click":
                        gSQLstr = "order by a.click desc";
                        break;
                    default:
                        if (stat.IndexOf("SP|") > -1)
                        {
                            string[] SPSTRARR = stat.Split('|');
                            sFilter += " and a.SpecialID='" + SPSTRARR[1] + "'";
                        }
                        break;
                }
            }
            if (author != "#0")
            {
                sFilter += " and a.author='" + author + "'";
            }
            string AllFields = "a.*";
            string Condition = dbTable + " a," + Pre + "sys_channelclass b" + sFilter;
            string IndexField = "a.Id";
            string OrderFields = gSQLstr + ",a.Id desc";
            return DbHelper.ExecutePage(AllFields, Condition, IndexField, OrderFields, PageIndex, PageSize, out RecordCount, out PageCount, null);
        }

        public int delContent(int id, int ChID, int Num)
        {
            string sql = string.Empty;
            SqlParameter param = new SqlParameter("@id", id);
            string dTable = getChannelTable(ChID);
            if (Num == 0)
            {
                sql = "delete from " + dTable + " where id=@id and ChID=" + ChID + "";
            }
            else
            {
                if (id == 0)
                {
                    sql = "delete from " + dTable + " where ChID=" + ChID + "";
                }
                else
                {
                    sql = "delete from " + dTable + " where ClassID=@id and ChID=" + ChID + "";
                }
            }
            return DbHelper.ExecuteNonQuery(CommandType.Text, sql, param);
        }

        public int inserContentInfo(NetCMS.Model.ChInfoContent uc, string DTable)
        {
            SqlParameter[] param = GetChInfoParams(uc);
            string Sql = "insert into " + DTable + " (";
            Sql += "ChID,ClassID,SpecialID,title,TitleColor,TitleITF,TitleBTF,PicURL,NaviContent,Content,Author,Souce,OrderID,Tags,";
            Sql += "Templet,SavePath,FileName,isDelPoint,Gpoint,iPoint,GroupNumber,Metakeywords,Metadesc,Click,CreatTime,isHTML,isConstr,islock,ContentProperty,Editor,ConstrTF";
            Sql += ") values (";
            Sql += "@ChID,@ClassID,@SpecialID,@title,@TitleColor,@TitleITF,@TitleBTF,@PicURL,@NaviContent,@Content,@Author,@Souce,@OrderID,@Tags,";
            Sql += "@Templet,@SavePath,@FileName,@isDelPoint,@Gpoint,@iPoint,@GroupNumber,@Metakeywords,@Metadesc,@Click,'" + DateTime.Now + "',@isHTML,@isConstr,@islock,@ContentProperty,@Editor,0)";
            DbHelper.ExecuteNonQuery(CommandType.Text, Sql, param);
            string sqlid = "select top 1 id from " + DTable + " where title=@title and FileName=@FileName order by id desc";
            return Convert.ToInt32(DbHelper.ExecuteScalar(CommandType.Text, sqlid, param));
        }

        public void updateContentInfo(NetCMS.Model.ChInfoContent uc, string DTable)
        {
            SqlParameter[] param = GetChInfoParams(uc);
            string Sql = "update " + DTable + " set ";
            Sql += "ChID=@ChID,ClassID=@ClassID,SpecialID=@SpecialID,title=@title,TitleColor=@TitleColor,TitleITF=@TitleITF,TitleBTF=@TitleBTF,PicURL=@PicURL,NaviContent=@NaviContent,Content=@Content,Author=@Author,Souce=@Souce,OrderID=@OrderID,Tags=@Tags,";
            Sql += "Templet=@Templet,SavePath=@SavePath,FileName=@FileName,isDelPoint=@isDelPoint,Gpoint=@Gpoint,iPoint=@iPoint,GroupNumber=@GroupNumber,Metakeywords=@Metakeywords,Metadesc=@Metadesc,Click=@Click,isHTML=@isHTML,isConstr=@isConstr,islock=@islock,ContentProperty=@ContentProperty,Editor=@Editor where ID=@Id";
            DbHelper.ExecuteNonQuery(CommandType.Text, Sql, param);
        }
        public void updateUserContentInfo(NetCMS.Model.ChInfoContent uc, string DTable)
        {
            SqlParameter[] param = GetChInfoParams1(uc);
            string Sql = "update " + DTable + " set ";
            Sql += "ChID=@ChID,ClassID=@ClassID,title=@title,PicURL=@PicURL,NaviContent=@NaviContent,Content=@Content,Author=@Author,Souce=@Souce,Tags=@Tags,";
            Sql += "isConstr=@isConstr,islock=@islock where ID=@Id";
            DbHelper.ExecuteNonQuery(CommandType.Text, Sql, param);
        }

        public void updatePreContentInfo(int ID, string PreContentName, object PreContent, string DTable)
        {
            SqlParameter param = null;
            string gSQL = "select vType from " + Pre + "sys_channelvalue where EName='" + PreContentName + "'";
            string getType = Convert.ToString(DbHelper.ExecuteScalar(CommandType.Text, gSQL, null));
            switch (getType)
            {
                case "7":
                    if (PreContent != null)
                    {
                        param = new SqlParameter("@ContentParam", Convert.ToInt16(PreContent));
                    }
                    else
                    {
                        int gparam0 = 0;
                        param = new SqlParameter("@ContentParam", gparam0);
                    }
                    break;
                case "8":
                    if (PreContent != null)
                    {
                        param = new SqlParameter("@ContentParam", Convert.ToInt16(PreContent));
                    }
                    else
                    {
                        int gparam8 = 0;
                        param = new SqlParameter("@ContentParam", gparam8);
                    }
                    break;
                case "9":
                    if (PreContent != null)
                    {
                        param = new SqlParameter("@ContentParam", Convert.ToDouble(PreContent));
                    }
                    else
                    {
                        int gparam9 = 0;
                        param = new SqlParameter("@ContentParam", gparam9);
                    }
                    break;
                case "10":
                    if (PreContent != null)
                    {
                        param = new SqlParameter("@ContentParam", Convert.ToDateTime(PreContent));
                    }
                    else