/// <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 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)
{
//取得频道的名称
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;
}
