channel.cs

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

            param[15].Value = uc1.specialtemplet;
            param[16] = new SqlParameter("@newstemplet", SqlDbType.NVarChar, 200);
            param[16].Value = uc1.newstemplet;
            param[17] = new SqlParameter("@isHTML", SqlDbType.TinyInt, 1);
            param[17].Value = uc1.isHTML;
            param[18] = new SqlParameter("@channelEItem", SqlDbType.NVarChar, 20);
            param[18].Value = uc1.channelEItem;
            param[19] = new SqlParameter("@ClassSave", SqlDbType.NVarChar, 50);
            param[19].Value = uc1.ClassSave;
            param[20] = new SqlParameter("@ClassFileName", SqlDbType.NVarChar, 50);
            param[20].Value = uc1.ClassFileName;
            param[21] = new SqlParameter("@SavePath", SqlDbType.NVarChar, 50);
            param[21].Value = uc1.SavePath;
            param[22] = new SqlParameter("@FileName", SqlDbType.NVarChar, 50);
            param[22].Value = uc1.FileName;
            param[23] = new SqlParameter("@issys", SqlDbType.TinyInt, 1);
            param[23].Value = uc1.issys;
            param[24] = new SqlParameter("@binddomain", SqlDbType.NVarChar, 150);
            param[24].Value = uc1.binddomain;
            param[25] = new SqlParameter("@TempletPath", SqlDbType.NVarChar, 100);
            param[25].Value = uc1.TempletPath;
            param[26] = new SqlParameter("@indexFileName", SqlDbType.NVarChar, 50);
            param[26].Value = uc1.indexFileName;

            param[27] = new SqlParameter("@isDelPoint", SqlDbType.TinyInt);
            param[27].Value = uc1.isDelPoint;
            param[28] = new SqlParameter("@Gpoint", SqlDbType.Int, 4);
            param[28].Value = uc1.Gpoint;
            param[29] = new SqlParameter("@iPoint", SqlDbType.Int, 4);
            param[29].Value = uc1.iPoint;
            param[30] = new SqlParameter("@GroupNumber", SqlDbType.NVarChar, 200);
            param[30].Value = uc1.GroupNumber;
            param[31] = new SqlParameter("@ParentID", SqlDbType.Int, 4);
            param[31].Value = uc1.ParentID;
            return param;
        }

        public int getItemCount(string eName, int ChID)
        {
            SqlParameter param = new SqlParameter("@eName", eName);
            string wStr = string.Empty;
            if (ChID != 0)
            {
                wStr = " and ID<>" + ChID + "";
            }
            string sql = "select count(id) from " + Pre + "sys_channel where channelEItem=@eName " + wStr + "";
            return Convert.ToInt32(DbHelper.ExecuteScalar(CommandType.Text, sql, param));
        }
        public int getDbCount(string Table, int ChID)
        {
            SqlParameter param = new SqlParameter("@Table", Table);
            string wStr = string.Empty;
            if (ChID != 0)
            {
                wStr = " and ID<>" + ChID + "";
            }
            string sql = "select count(id) from " + Pre + "sys_channel where DataLib=@Table " + wStr + "";
            return Convert.ToInt32(DbHelper.ExecuteScalar(CommandType.Text, sql, param));
        }

        public int getSysCord(int ID)
        {
            SqlParameter param = new SqlParameter("@ID", ID);
            string sql = "select issys from " + Pre + "sys_channel where ID=@ID";
            return Convert.ToInt32(DbHelper.ExecuteScalar(CommandType.Text, sql, param));
        }

        public void delModel(int ID)
        {
            SqlParameter param = new SqlParameter("@ID", ID);
            string gSQL = "select Datalib from " + Pre + "sys_channel where ID=@ID";
            string DbTable = Convert.ToString(DbHelper.ExecuteScalar(CommandType.Text, gSQL, param));
            string sql = "delete from " + Pre + "sys_channel where ID=@ID";
            DbHelper.ExecuteNonQuery(CommandType.Text, sql, param);
            try
            {
                string delDB = "drop table [" + DbTable + "]";
                DbHelper.ExecuteNonQuery(CommandType.Text, delDB, null);
            }
            catch
            { }
        }

        public void ModelStat(int ID, int isLock)
        {
            SqlParameter param = new SqlParameter("@ID", ID);
            string sql = "update " + Pre + "sys_channel set islock=" + isLock + " where ID=@ID";
            DbHelper.ExecuteNonQuery(CommandType.Text, sql, param);
        }

        public IDataReader getChInfoMenu(int ChID)
        {
            SqlParameter param = new SqlParameter("@ID", ChID);
            string sql = "select a.id,a.channelName,a.channelItem,a.TempletPath,a.isConstr,(select count(id) from " + Pre + "sys_channel b where b.parentID=a.id) as hashCount from " + Pre + "sys_channel a where a.ID=@ID";
            return DbHelper.ExecuteReader(CommandType.Text, sql, param);
        }

        public IDataReader getChValue(int ID)
        {
            SqlParameter param = new SqlParameter("@ID", ID);
            string sql = "select * from " + Pre + "sys_channelvalue where ID=@ID";
            return DbHelper.ExecuteReader(CommandType.Text, sql, param);
        }

        public int getChannelParentCount(int ID)
        {
            SqlParameter param = new SqlParameter("@ID", ID);
            string sql = "select count(id) from "+Pre+"sys_channel where ParentID=@ID";
            return Convert.ToInt16(DbHelper.ExecuteScalar(CommandType.Text, sql, param));
        }

        public string getChannelTable(int ChID)
        {
            string TableStr = "#";
            string TmpTable = string.Empty;
            int GetTableRecord = 0;
            SqlParameter param = new SqlParameter("@ChID", ChID);
            string sql = "select DataLib from " + Pre + "sys_channel where ID=@ChID";
            IDataReader dr = DbHelper.ExecuteReader(CommandType.Text, sql, param);
            if (dr.Read())
            {
                TmpTable = dr["DataLib"].ToString();
                string TableSQL = "select count(*) from sysobjects where id = object_id(N'[" + TmpTable + "]') and OBJECTPROPERTY(id, N'IsUserTable') = 1";
                GetTableRecord = Convert.ToInt32(DbHelper.ExecuteScalar(CommandType.Text, TableSQL, null));
                if (GetTableRecord > 0)
                {
                    TableStr = TmpTable;
                }
            }
            dr.Close();
            return TableStr;
        }

        public bool getChannelValueTF(int ChID, string EName, int vID)
        {
            SqlParameter param = new SqlParameter("@ChID", @ChID);
            string sql = "select Count(id) from " + Pre + "sys_channelvalue where ChID=@ChID and EName='" + EName + "' and ID<>" + vID + "";
            int count = Convert.ToInt32(DbHelper.ExecuteScalar(CommandType.Text, sql, param));
            if (count > 0)
            {
                return true;
            }
            else
            {
                return false;
            }
        }

        /// <summary>
        /// 插入字段入数据库进行保存
        /// </summary>
        /// <param name="uc"></param>
        public void insertFields(NetCMS.Model.ChannelValue uc, string TableSTR)
        {
            string Sql = "insert into " + Pre + "sys_channelvalue (";
            Sql += "ChID,OrderID,CName,EName,vDescript,vType,vLength,vValue,isNulls,isUser,vitem,isLock,SiteID,fieldLength,HTMLedit,isSearch,vHeight";
            Sql += ") values (";
            Sql += "@ChID,@OrderID,@CName,@EName,@vDescript,@vType,@vLength,@vValue,@isNulls,@isUser,@vitem,@isLock,@SiteID,@fieldLength,@HTMLedit,@isSearch,@vHeight)";
            SqlParameter[] param = ValueParameters(uc);
            //创建数据库字段
            string CreateSql = "ALTER TABLE [" + TableSTR + "] ADD [" + uc.EName + "] " + CreatevType(uc.vType) + "";
            DbHelper.ExecuteNonQuery(CommandType.Text, CreateSql, param);
            DbHelper.ExecuteNonQuery(CommandType.Text, Sql, param);
        }

        /// <summary>
        /// 更新字段
        /// </summary>
        /// <param name="uc"></param>
        /// <param name="TableSTR"></param>
        public void UpdateFields(NetCMS.Model.ChannelValue uc, string TableSTR)
        {
            string Sql = "update " + Pre + "sys_channelvalue set ";
            Sql += "OrderID=@OrderID,CName=@CName,vDescript=@vDescript,vLength=@vLength,vValue=@vValue,isNulls=@isNulls,isUser=@isUser,vitem=@vitem,isLock=@isLock,isSearch=@isSearch,vHeight=@vHeight,HTMLedit=@HTMLedit where ID=@Id and SiteID=@SiteID";
            SqlParameter[] param = ValueParameters(uc);
            DbHelper.ExecuteNonQuery(CommandType.Text, Sql, param);
        }

        /// <summary>
        /// 得到字段类型
        /// </summary>
        /// <param name="vType"></param>
        /// <returns></returns>
        protected string CreatevType(int vType)
        {
            string LenStr = string.Empty;
            string NullStr = "NULL";
            switch (vType)
            {
                case 0:
                    LenStr = "[nvarchar] (20) " + NullStr + "";
                    break;
                case 1:
                    LenStr = "[nvarchar] (50) " + NullStr + "";
                    break;
                case 2:
                    LenStr = "[nvarchar] (100) " + NullStr + "";
                    break;
                case 3:
                    LenStr = "[nvarchar] (180) " + NullStr + "";
                    break;
                case 4:
                    LenStr = "[nvarchar] (225) " + NullStr + "";
                    break;
                case 5:
                    LenStr = "[ntext] " + NullStr + "";
                    break;
                case 6:
                    LenStr = "[nvarchar] (200) " + NullStr + "";
                    break;
                case 7:
                    LenStr = "[int] " + NullStr + "";
                    break;
                case 8:
                    LenStr = "[tinyint] " + NullStr + "";
                    break;
                case 9:
                    LenStr = "[money] " + NullStr + "";
                    break;
                case 10:
                    LenStr = "[datetime] " + NullStr + "";
                    break;
                case 11:
                    LenStr = "[smalldatetime] " + NullStr + "";
                    break;
                case 12:
                    LenStr = "[nvarchar] (200) " + NullStr + "";
                    break;
                case 13:
                    LenStr = "[ntext] " + NullStr + "";
                    break;
                case 14:
                    LenStr = "[nvarchar] (200) " + NullStr + "";
                    break;
                case 15:
                    LenStr = "[ntext] " + NullStr + "";
                    break;
                case 16:
                    LenStr = "[ntext] " + NullStr + "";
                    break;
                case 17:
                    LenStr = "[ntext] " + NullStr + "";
                    break;
                default:
                    LenStr = "[nvarchar] (200) " + NullStr + "";
                    break;
            }
            return LenStr;
        }

        /// <summary>
        /// 得到所有参数
        /// </summary>
        /// <param name="uc1"></param>
        /// <returns></returns>
        private SqlParameter[] ValueParameters(NetCMS.Model.ChannelValue uc1)
        {
            SqlParameter[] param = new SqlParameter[18];