/// <summary>
        /// 删除一条数据
        /// </summary>
        public bool Delete(int id)
        {
            //取得要删除频道记录
            Model.channel_category model = GetModel(id);
            if (model == null)
            {
                return(false);
            }
            //取得导航的ID
            int nav_id = new navigation(databaseprefix).GetNavId("channel_" + model.build_path);

            using (SqlConnection conn = new SqlConnection(DbHelperSQL.connectionString))
            {
                conn.Open();
                using (SqlTransaction trans = conn.BeginTransaction())
                {
                    try
                    {
                        //删除导航主表
                        if (nav_id > 0)
                        {
                            DbHelperSQL.ExecuteSql(conn, trans, "delete from " + databaseprefix + "navigation  where class_list like '%," + nav_id + ",%'");
                        }
                        //删除频道分类表
                        StringBuilder strSql = new StringBuilder();
                        strSql.Append("delete from " + databaseprefix + "channel_category ");
                        strSql.Append(" where id=@id");
                        SqlParameter[] parameters =
                        {
                            new SqlParameter("@id", SqlDbType.Int, 4)
                        };
                        parameters[0].Value = id;
                        DbHelperSQL.ExecuteSql(conn, trans, strSql.ToString(), parameters);

                        trans.Commit();
                    }
                    catch
                    {
                        trans.Rollback();
                        return(false);
                    }
                }
            }
            return(true);
        }
Example #2
0
        /// <summary>
        /// 添加后台管理导航
        /// </summary>
        public bool AppendMenuNodes(string navPath, string dirPath, string xPath, int parentId)
        {
            XmlNodeList xnList = XmlHelper.ReadNodes(dirPath + MXKeys.FILE_PLUGIN_XML_CONFING, xPath);

            if (xnList.Count > 0)
            {
                foreach (XmlElement xe in xnList)
                {
                    if (xe.NodeType != XmlNodeType.Comment && xe.Name.ToLower() == "nav")
                    {
                        //插入导航记录
                        string nav_name    = string.Empty;
                        string nav_title   = string.Empty;
                        string link_url    = string.Empty;
                        string action_type = string.Empty;
                        if (xe.Attributes["name"] != null)
                        {
                            nav_name = xe.Attributes["name"].Value;
                        }
                        if (xe.Attributes["title"] != null)
                        {
                            nav_title = xe.Attributes["title"].Value;
                        }
                        if (xe.Attributes["url"] != null)
                        {
                            link_url = navPath + xe.Attributes["url"].Value;
                        }
                        if (xe.Attributes["action"] != null)
                        {
                            action_type = xe.Attributes["action"].Value;
                        }
                        int nav_id = new navigation(databaseprefix).Add(parentId, nav_name, nav_title, link_url, 0, 0, action_type); //写入数据库
                        if (nav_id < 1)
                        {
                            return(false);
                        }
                        //调用自身迭代
                        AppendMenuNodes(navPath, dirPath, xPath + "/nav", nav_id);
                    }
                }
            }
            return(true);
        }
Example #3
0
        /// <summary>
        /// 删除后台管理导航
        /// </summary>
        public void RemoveMenuNodes(string dirPath, string xPath)
        {
            XmlNodeList xnList = XmlHelper.ReadNodes(dirPath + MXKeys.FILE_PLUGIN_XML_CONFING, xPath);

            if (xnList.Count > 0)
            {
                DAL.navigation dal = new navigation(databaseprefix);
                foreach (XmlElement xe in xnList)
                {
                    if (xe.NodeType != XmlNodeType.Comment && xe.Name.ToLower() == "nav")
                    {
                        //删除导航记录
                        if (xe.Attributes["name"] != null)
                        {
                            int nav_id = dal.GetNavId(xe.Attributes["name"].Value);
                            if (nav_id > 0)
                            {
                                dal.Delete(nav_id);
                            }
                        }
                    }
                }
            }
        }
Example #4
0
        /// <summary>
        /// 删除一条数据
        /// </summary>
        public bool Delete(int id)
        {
            //取得将要删除的记录
            Model.channel model = GetModel(id);
            if (model == null)
            {
                return false;
            }
            //取得导航的ID
            int nav_id = new navigation(databaseprefix).GetNavId("channel_" + model.name);

            using (SqlConnection conn = new SqlConnection(DbHelperSQL.connectionString))
            {
                conn.Open();
                using (SqlTransaction trans = conn.BeginTransaction())
                {
                    try
                    {
                        //删除导航主表
                        if (nav_id > 0)
                        {
                            DbHelperSQL.ExecuteSql(conn, trans, "delete from " + databaseprefix + "navigation  where class_list like '%," + nav_id + ",%'");
                        }

                        //删除视图
                        StringBuilder strSql1 = new StringBuilder();
                        strSql1.Append("if exists (select 1 from sysobjects where id = object_id('view_channel_" + model.name + "') and type = 'V')");
                        strSql1.Append("drop view view_channel_" + model.name);
                        DbHelperSQL.ExecuteSql(conn, trans, strSql1.ToString());

                        //删除频道扩展字段表
                        StringBuilder strSql2 = new StringBuilder();
                        strSql2.Append("delete from " + databaseprefix + "channel_field ");
                        strSql2.Append(" where channel_id=@channel_id ");
                        SqlParameter[] parameters2 = {
					            new SqlParameter("@channel_id", SqlDbType.Int,4)};
                        parameters2[0].Value = id;
                        DbHelperSQL.ExecuteSql(conn, trans, strSql2.ToString(), parameters2);

                        //删除频道表
                        StringBuilder strSql3 = new StringBuilder();
                        strSql3.Append("delete from " + databaseprefix + "channel ");
                        strSql3.Append(" where id=@id ");
                        SqlParameter[] parameters3 = {
					            new SqlParameter("@id", SqlDbType.Int,4)};
                        parameters3[0].Value = id;
                        DbHelperSQL.ExecuteSql(conn, trans, strSql3.ToString(), parameters3);

                        trans.Commit();
                    }
                    catch
                    {
                        trans.Rollback();
                        return false;
                    }
                }
            }
            return true;
        }
Example #5
0
        /// <summary>
        /// 删除一条数据
        /// </summary>
        public bool Delete(int id)
        {
            //取得将要删除的记录
            Model.channel model = GetModel(id);
            if (model == null)
            {
                return(false);
            }
            //取得导航的ID
            int nav_id = new navigation(databaseprefix).GetNavId("channel_" + model.name);

            using (SqlConnection conn = new SqlConnection(DbHelperSQL.connectionString))
            {
                conn.Open();
                using (SqlTransaction trans = conn.BeginTransaction())
                {
                    try
                    {
                        //删除导航主表
                        if (nav_id > 0)
                        {
                            DbHelperSQL.ExecuteSql(conn, trans, "delete from " + databaseprefix + "navigation  where class_list like '%," + nav_id + ",%'");
                        }

                        //删除视图
                        StringBuilder strSql1 = new StringBuilder();
                        strSql1.Append("if exists (select 1 from sysobjects where id = object_id('view_channel_" + model.name + "') and type = 'V')");
                        strSql1.Append("drop view view_channel_" + model.name);
                        DbHelperSQL.ExecuteSql(conn, trans, strSql1.ToString());

                        //删除频道扩展字段表
                        StringBuilder strSql2 = new StringBuilder();
                        strSql2.Append("delete from " + databaseprefix + "channel_field ");
                        strSql2.Append(" where channel_id=@channel_id ");
                        SqlParameter[] parameters2 =
                        {
                            new SqlParameter("@channel_id", SqlDbType.Int, 4)
                        };
                        parameters2[0].Value = id;
                        DbHelperSQL.ExecuteSql(conn, trans, strSql2.ToString(), parameters2);

                        //删除频道表
                        StringBuilder strSql3 = new StringBuilder();
                        strSql3.Append("delete from " + databaseprefix + "channel ");
                        strSql3.Append(" where id=@id ");
                        SqlParameter[] parameters3 =
                        {
                            new SqlParameter("@id", SqlDbType.Int, 4)
                        };
                        parameters3[0].Value = id;
                        DbHelperSQL.ExecuteSql(conn, trans, strSql3.ToString(), parameters3);

                        trans.Commit();
                    }
                    catch
                    {
                        trans.Rollback();
                        return(false);
                    }
                }
            }
            return(true);
        }
Example #6
0
 /// <summary>
 /// 删除后台管理导航
 /// </summary>
 public void RemoveMenuNodes(string dirPath, string xPath)
 {
     XmlNodeList xnList = XmlHelper.ReadNodes(dirPath + MXKeys.FILE_PLUGIN_XML_CONFING, xPath);
     if (xnList.Count > 0)
     {
         DAL.navigation dal = new navigation(databaseprefix);
         foreach (XmlElement xe in xnList)
         {
             if (xe.NodeType != XmlNodeType.Comment && xe.Name.ToLower() == "nav")
             {
                 //删除导航记录
                 if (xe.Attributes["name"] != null)
                 {
                     int nav_id = dal.GetNavId(xe.Attributes["name"].Value);
                     if (nav_id > 0)
                     {
                         dal.Delete(nav_id);
                     }
                 }
             }
         }
     }
 }
Example #7
0
 /// <summary>
 /// 添加后台管理导航
 /// </summary>
 public bool AppendMenuNodes(string navPath, string dirPath, string xPath, int parentId)
 {
     XmlNodeList xnList = XmlHelper.ReadNodes(dirPath + MXKeys.FILE_PLUGIN_XML_CONFING, xPath);
     if (xnList.Count > 0)
     {
         foreach (XmlElement xe in xnList)
         {
             if (xe.NodeType != XmlNodeType.Comment && xe.Name.ToLower() == "nav")
             {
                 //插入导航记录
                 string nav_name = string.Empty;
                 string nav_title = string.Empty;
                 string link_url = string.Empty;
                 string action_type = string.Empty;
                 if (xe.Attributes["name"] != null)
                 {
                     nav_name = xe.Attributes["name"].Value;
                 }
                 if (xe.Attributes["title"] != null)
                 {
                     nav_title = xe.Attributes["title"].Value;
                 }
                 if (xe.Attributes["url"] != null)
                 {
                     link_url = navPath + xe.Attributes["url"].Value;
                 }
                 if (xe.Attributes["action"] != null)
                 {
                     action_type = xe.Attributes["action"].Value;
                 }
                 int nav_id = new navigation(databaseprefix).Add(parentId, nav_name, nav_title, link_url, 0, 0, action_type); //写入数据库
                 if (nav_id < 1)
                 {
                     return false;
                 }
                 //调用自身迭代
                 AppendMenuNodes(navPath, dirPath, xPath + "/nav", nav_id);
             }
         }
     }
     return true;
 }
        /// <summary>
        /// 删除一条数据
        /// </summary>
        public bool Delete(int id)
        {
            //取得要删除频道记录
            Model.channel_category model = GetModel(id);
            if (model == null)
            {
                return false;
            }
            //取得导航的ID
            int nav_id = new navigation(databaseprefix).GetNavId("channel_" + model.build_path);

            using (SqlConnection conn = new SqlConnection(DbHelperSQL.connectionString))
            {
                conn.Open();
                using (SqlTransaction trans = conn.BeginTransaction())
                {
                    try
                    {
                        //删除导航主表
                        if (nav_id > 0)
                        {
                            DbHelperSQL.ExecuteSql(conn, trans, "delete from " + databaseprefix + "navigation  where class_list like '%," + nav_id + ",%'");
                        }
                        //删除频道分类表
                        StringBuilder strSql = new StringBuilder();
                        strSql.Append("delete from " + databaseprefix + "channel_category ");
                        strSql.Append(" where id=@id");
                        SqlParameter[] parameters = {
					            new SqlParameter("@id", SqlDbType.Int,4)};
                        parameters[0].Value = id;
                        DbHelperSQL.ExecuteSql(conn, trans, strSql.ToString(), parameters);

                        trans.Commit();
                    }
                    catch
                    {
                        trans.Rollback();
                        return false;
                    }
                }
            }
            return true;
        }