/// <summary> /// 删除一条数据 /// </summary> public bool Delete(int id) { //取得频道的名称 string channel_name = GetChannelName(id); if (string.IsNullOrEmpty(channel_name)) { return(false); } //取得要删除的所有导航ID string navIds = new navigation(databaseprefix).GetIds("channel_" + channel_name); try { //删除导航主表 if (!string.IsNullOrEmpty(navIds)) { WriteDataBase.Execute("delete from " + databaseprefix + "navigation where id in(" + navIds + ")"); } //删除频道扩展字段表 StringBuilder strSql2 = new StringBuilder(); strSql2.Append("delete from " + databaseprefix + "site_channel_field "); strSql2.Append(" where channel_id=@0 "); WriteDataBase.Execute(strSql2.ToString(), id); //删除频道缩略图尺寸表 StringBuilder strSql5 = new StringBuilder(); strSql5.Append("delete from " + databaseprefix + "site_channel_thum "); strSql5.Append(" where channel_id=@0 "); WriteDataBase.Execute(strSql5.ToString(), id); //删除频道数据表 StringBuilder strSql4 = new StringBuilder(); strSql4.Append("drop table " + databaseprefix + DTKeys.TABLE_CHANNEL_ARTICLE + channel_name); WriteDataBase.Execute(strSql4.ToString()); //删除频道表 StringBuilder strSql3 = new StringBuilder(); strSql3.Append("delete from " + databaseprefix + "site_channel "); strSql3.Append(" where id=@0 "); WriteDataBase.Execute(strSql3.ToString(), id); } catch (Exception ex) { return(false); } return(true); }
/// <summary> /// 添加后台管理导航 /// </summary> public bool AppendMenuNodes(string navPath, string dirPath, string xPath, string parentName) { XmlNodeList xnList = XmlHelper.ReadNodes(dirPath + DTKeys.FILE_PLUGIN_XML_CONFING, xPath); if (xnList.Count > 0) { foreach (XmlElement xe in xnList) { if (xe.NodeType != XmlNodeType.Comment && xe.Name.ToLower() == "nav") { //插入导航记录 int sort_id = 99; 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; } if (xe.Attributes["sort"] != null) { sort_id = Utils.StrToInt(xe.Attributes["sort"].Value, 99); } int nav_id = new navigation(databaseprefix).Add(parentName, nav_name, nav_title, link_url, sort_id, 0, action_type); //写入数据库 if (nav_id < 1) { return(false); } //调用自身迭代 AppendMenuNodes(navPath, dirPath, xPath + "/nav", nav_name); } } } 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); }
/// <summary> /// 删除一条数据 /// </summary> public bool Delete(int id) { string build_path = GetBuildPath(id); if (string.IsNullOrEmpty(build_path)) { return(false); } //取得要删除的所有导航ID string navIds = new navigation(databaseprefix).GetIds("channel_" + build_path); using (SqlConnection conn = new SqlConnection(DbHelperSQL.connectionString)) { conn.Open(); using (SqlTransaction trans = conn.BeginTransaction()) { try { //删除导航 if (!string.IsNullOrEmpty(navIds)) { DbHelperSQL.ExecuteSql(conn, trans, "delete from [" + databaseprefix + "navigation] where id in(" + navIds + ")"); } //删除站点 StringBuilder strSql = new StringBuilder(); strSql.Append("delete from " + databaseprefix + "channel_site "); 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); }
/// <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; }
/// <summary> /// 添加后台管理导航 /// </summary> public bool AppendMenuNodes(string navPath, string dirPath, string xPath, int parentId) { XmlNodeList xnList = XmlHelper.ReadNodes(dirPath + DTKeys.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) { string build_path = GetBuildPath(id); if (string.IsNullOrEmpty(build_path)) { return(false); } //取得要删除的所有导航ID string navIds = new navigation(databaseprefix).GetIds("channel_" + build_path); using (IDbConnection conn = new DapperView().Context()) { using (IDbTransaction trans = conn.BeginTransaction()) { try { //删除导航 if (!string.IsNullOrEmpty(navIds)) { WriteDataBase.Execute("delete from [" + databaseprefix + "navigation] where id in(" + navIds + ")"); } //删除站点 StringBuilder strSql = new StringBuilder(); strSql.Append("delete from " + databaseprefix + "sites "); strSql.Append(" where id=@0"); WriteDataBase.Execute(strSql.ToString(), id); trans.Commit(); } catch (Exception ex) { trans.Rollback(); return(false); } } } return(true); }
/// <summary> /// 删除后台管理导航 /// </summary> public void RemoveMenuNodes(string dirPath, string xPath) { XmlNodeList xnList = XmlHelper.ReadNodes(dirPath + DTKeys.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); } } } } } }
/// <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; }
/// <summary> /// 删除一条数据 /// </summary> public bool Delete(int id) { //取得频道的名称 string channel_name = GetChannelName(id); if (string.IsNullOrEmpty(channel_name)) { return(false); } //取得要删除的所有导航ID string navIds = new navigation(databaseprefix).GetIds("channel_" + channel_name); using (MySqlConnection conn = new MySqlConnection(DbHelperMySql.connectionString)) { conn.Open(); using (MySqlTransaction trans = conn.BeginTransaction()) { try { //删除导航主表 if (!string.IsNullOrEmpty(navIds)) { DbHelperMySql.ExecuteSql(conn, trans, "delete from " + databaseprefix + "navigation where id in(" + navIds + ")"); } //删除视图 StringBuilder strSql1 = new StringBuilder(); //strSql1.Append("if exists (select 1 from sysobjects where id = object_id('view_channel_" + channel_name + "') and type = 'V')"); strSql1.Append("drop view view_channel_" + channel_name); DbHelperMySql.ExecuteSql(conn, trans, strSql1.ToString()); //删除频道扩展字段表 StringBuilder strSql2 = new StringBuilder(); strSql2.Append("delete from " + databaseprefix + "channel_field "); strSql2.Append(" where channel_id=@channel_id "); MySqlParameter[] parameters2 = { new MySqlParameter("@channel_id", MySqlDbType.Int32, 4) }; parameters2[0].Value = id; DbHelperMySql.ExecuteSql(conn, trans, strSql2.ToString(), parameters2); //删除频道表 StringBuilder strSql3 = new StringBuilder(); strSql3.Append("delete from " + databaseprefix + "channel "); strSql3.Append(" where id=@id "); MySqlParameter[] parameters3 = { new MySqlParameter("@id", MySqlDbType.Int32, 4) }; parameters3[0].Value = id; DbHelperMySql.ExecuteSql(conn, trans, strSql3.ToString(), parameters3); trans.Commit(); } catch { trans.Rollback(); return(false); } } } return(true); }
/// <summary> /// 删除一条数据 /// </summary> public bool Delete(int id) { string build_path = GetBuildPath(id); if (string.IsNullOrEmpty(build_path)) { return false; } //取得要删除的所有导航ID string navIds = new navigation(databaseprefix).GetIds("channel_" + build_path); using (SqlConnection conn = new SqlConnection(DbHelperSQL.connectionString)) { conn.Open(); using (SqlTransaction trans = conn.BeginTransaction()) { try { //删除导航 if (!string.IsNullOrEmpty(navIds)) { DbHelperSQL.ExecuteSql(conn, trans, "delete from " + databaseprefix + "navigation where id in(" + navIds + ")"); } //删除站点 StringBuilder strSql=new StringBuilder(); strSql.Append("delete from " + databaseprefix + "channel_site "); 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; }
/// <summary> /// 删除一条数据 /// </summary> public bool Delete(int id) { //取得频道的名称 string channelName = GetChannelName(id); if (string.IsNullOrEmpty(channelName)) { return(false); } //取得要删除的所有导航ID string navIds = new navigation(databaseprefix).GetIds("channel_" + channelName); using (SqlConnection conn = new SqlConnection(DbHelperSQL.connectionString)) { conn.Open(); using (SqlTransaction trans = conn.BeginTransaction()) { try { //删除导航菜单表 if (!string.IsNullOrEmpty(navIds)) { DbHelperSQL.ExecuteSql(conn, trans, "delete from " + databaseprefix + "navigation where id in(" + navIds + ")"); } //删除扩展字段表 StringBuilder strSql1 = new StringBuilder(); strSql1.Append("delete from " + databaseprefix + "site_channel_field"); strSql1.Append(" where channel_id=@channel_id "); SqlParameter[] parameters1 = { new SqlParameter("@channel_id", SqlDbType.Int, 4) }; parameters1[0].Value = id; DbHelperSQL.ExecuteSql(conn, trans, strSql1.ToString(), parameters1); //删除频道数据表 StringBuilder strSql2 = new StringBuilder(); strSql2.Append("drop table " + databaseprefix + DTKeys.TABLE_CHANNEL_ARTICLE + channelName); DbHelperSQL.ExecuteSql(conn, trans, strSql2.ToString()); //删除频道表 StringBuilder strSql = new StringBuilder(); strSql.Append("delete from " + databaseprefix + "site_channel"); 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); }
/// <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); }
/// <summary> /// 删除一条数据 /// </summary> public bool Delete(int id) { //取得频道的名称 string channel_name = GetChannelName(id); if (string.IsNullOrEmpty(channel_name)) { return false; } //取得要删除的所有导航ID string navIds = new navigation(databaseprefix).GetIds("channel_" + channel_name); using (SqlConnection conn = new SqlConnection(DbHelperSQL.connectionString)) { conn.Open(); using (SqlTransaction trans = conn.BeginTransaction()) { try { //删除导航主表 if (!string.IsNullOrEmpty(navIds)) { DbHelperSQL.ExecuteSql(conn, trans, "delete from " + databaseprefix + "navigation where id in(" + navIds + ")"); } //删除视图 StringBuilder strSql1 = new StringBuilder(); strSql1.Append("if exists (select 1 from sysobjects where id = object_id('view_channel_" + channel_name + "') and type = 'V')"); strSql1.Append("drop view view_channel_" + channel_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; }