public channel_site() { dal = new DAL.channel_site(siteConfig.sysdatabaseprefix); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Model.channel model) { Model.channel oldModel = GetModel(model.id); //旧的数据 //取得站点对应的导航ID int parent_id = new DAL.channel_site(databaseprefix).GetSiteNavId(model.site_id); if (parent_id == 0) { return(false); } using (MySqlConnection conn = new MySqlConnection(DbHelperMySql.connectionString)) { conn.Open(); using (MySqlTransaction trans = conn.BeginTransaction()) { try { StringBuilder strSql = new StringBuilder(); strSql.Append("update " + databaseprefix + "channel set "); strSql.Append("site_id=@site_id,"); strSql.Append("name=@name,"); strSql.Append("title=@title,"); strSql.Append("is_albums=@is_albums,"); strSql.Append("is_attach=@is_attach,"); strSql.Append("is_spec=@is_spec,"); strSql.Append("sort_id=@sort_id"); strSql.Append(" where id=@id "); MySqlParameter[] parameters = { new MySqlParameter("@site_id", MySqlDbType.Int32, 4), new MySqlParameter("@name", MySqlDbType.VarChar, 50), new MySqlParameter("@title", MySqlDbType.VarChar, 100), new MySqlParameter("@is_albums", MySqlDbType.Int32, 4), new MySqlParameter("@is_attach", MySqlDbType.Int32, 4), new MySqlParameter("@is_spec", MySqlDbType.Int32, 4), new MySqlParameter("@sort_id", MySqlDbType.Int32, 4), new MySqlParameter("@id", MySqlDbType.Int32, 4) }; parameters[0].Value = model.site_id; parameters[1].Value = model.name; parameters[2].Value = model.title; parameters[3].Value = model.is_albums; parameters[4].Value = model.is_attach; parameters[5].Value = model.is_spec; parameters[6].Value = model.sort_id; parameters[7].Value = model.id; DbHelperMySql.ExecuteSql(conn, trans, strSql.ToString(), parameters); //删除已移除的扩展字段 FieldDelete(conn, trans, model.channel_fields, model.id); //添加扩展字段 if (model.channel_fields != null) { StringBuilder strSql2; foreach (Model.channel_field modelt in model.channel_fields) { strSql2 = new StringBuilder(); Model.channel_field fieldModel = null; if (oldModel.channel_fields != null) { fieldModel = oldModel.channel_fields.Find(p => p.field_id == modelt.field_id); //查找是否已经存在 } if (fieldModel == null) //如果不存在则添加 { strSql2.Append("insert into " + databaseprefix + "channel_field("); strSql2.Append("channel_id,field_id)"); strSql2.Append(" values ("); strSql2.Append("@channel_id,@field_id)"); MySqlParameter[] parameters2 = { new MySqlParameter("@channel_id", MySqlDbType.Int32, 4), new MySqlParameter("@field_id", MySqlDbType.Int32, 4) }; parameters2[0].Value = modelt.channel_id; parameters2[1].Value = modelt.field_id; DbHelperMySql.ExecuteSql(conn, trans, strSql2.ToString(), parameters2); } } } //删除旧视图重建新视图 RehabChannelViews(conn, trans, model, oldModel.name); //修改对应的导航 new DAL.navigation(databaseprefix).Update(conn, trans, "channel_" + oldModel.name, parent_id, "channel_" + model.name, model.title, model.sort_id); new DAL.navigation(databaseprefix).Update(conn, trans, "channel_" + oldModel.name + "_list", "channel_" + model.name + "_list"); //内容管理 new DAL.navigation(databaseprefix).Update(conn, trans, "channel_" + oldModel.name + "_category", "channel_" + model.name + "_category"); //栏目类别 new DAL.navigation(databaseprefix).Update(conn, trans, "channel_" + oldModel.name + "_comment", "channel_" + model.name + "_comment"); //评论管理 trans.Commit(); } catch { trans.Rollback(); return(false); } } } return(true); }
/// <summary> /// 增加一条数据及其子表 /// </summary> public int Add(Model.channel model) { //取得站点对应的导航ID int parent_id = new DAL.channel_site(databaseprefix).GetSiteNavId(model.site_id); if (parent_id == 0) { return(0); } using (MySqlConnection conn = new MySqlConnection(DbHelperMySql.connectionString)) { conn.Open(); using (MySqlTransaction trans = conn.BeginTransaction()) { try { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into " + databaseprefix + "channel("); strSql.Append("site_id,name,title,is_albums,is_attach,is_spec,sort_id)"); strSql.Append(" values ("); strSql.Append("@site_id,@name,@title,@is_albums,@is_attach,@is_spec,@sort_id)"); MySqlParameter[] parameters = { new MySqlParameter("@site_id", MySqlDbType.Int32, 4), new MySqlParameter("@name", MySqlDbType.VarChar, 50), new MySqlParameter("@title", MySqlDbType.VarChar, 100), new MySqlParameter("@is_albums", MySqlDbType.Int32, 4), new MySqlParameter("@is_attach", MySqlDbType.Int32, 4), new MySqlParameter("@is_spec", MySqlDbType.Int32, 4), new MySqlParameter("@sort_id", MySqlDbType.Int32, 4) }; parameters[0].Value = model.site_id; parameters[1].Value = model.name; parameters[2].Value = model.title; parameters[3].Value = model.is_albums; parameters[4].Value = model.is_attach; parameters[5].Value = model.is_spec; parameters[6].Value = model.sort_id; DbHelperMySql.ExecuteSql(conn, trans, strSql.ToString(), parameters); //取得新插入的ID model.id = GetMaxId(conn, trans); //扩展字段 if (model.channel_fields != null) { StringBuilder strSql2; foreach (Model.channel_field modelt in model.channel_fields) { strSql2 = new StringBuilder(); strSql2.Append("insert into " + databaseprefix + "channel_field("); strSql2.Append("channel_id,field_id)"); strSql2.Append(" values ("); strSql2.Append("@channel_id,@field_id)"); MySqlParameter[] parameters2 = { new MySqlParameter("@channel_id", MySqlDbType.Int32, 4), new MySqlParameter("@field_id", MySqlDbType.Int32, 4) }; parameters2[0].Value = model.id; parameters2[1].Value = modelt.field_id; DbHelperMySql.ExecuteSql(conn, trans, strSql2.ToString(), parameters2); } } //添加视图 StringBuilder strSql3 = new StringBuilder(); strSql3.Append("CREATE VIEW view_channel_" + model.name + " as"); strSql3.Append(" SELECT " + databaseprefix + "article.*"); if (model.channel_fields != null) { foreach (Model.channel_field modelt in model.channel_fields) { Model.article_attribute_field fieldModel = new DAL.article_attribute_field(databaseprefix).GetModel(modelt.field_id); if (fieldModel != null) { strSql3.Append("," + databaseprefix + "article_attribute_value." + fieldModel.name); } } } strSql3.Append(" FROM " + databaseprefix + "article_attribute_value INNER JOIN"); strSql3.Append(" " + databaseprefix + "article ON " + databaseprefix + "article_attribute_value.article_id = " + databaseprefix + "article.id"); strSql3.Append(" WHERE " + databaseprefix + "article.channel_id=" + model.id); DbHelperMySql.ExecuteSql(conn, trans, strSql3.ToString()); //添加导航菜单 int newNavId = new DAL.navigation(databaseprefix).Add(conn, trans, parent_id, "channel_" + model.name, model.title, "", model.sort_id, model.id, "Show"); new DAL.navigation(databaseprefix).Add(conn, trans, newNavId, "channel_" + model.name + "_list", "内容管理", "article/article_list.aspx", 99, model.id, "Show,View,Add,Edit,Delete,Audit"); new DAL.navigation(databaseprefix).Add(conn, trans, newNavId, "channel_" + model.name + "_category", "栏目类别", "article/category_list.aspx", 100, model.id, "Show,View,Add,Edit,Delete"); new DAL.navigation(databaseprefix).Add(conn, trans, newNavId, "channel_" + model.name + "_comment", "评论管理", "article/comment_list.aspx", 101, model.id, "Show,View,Delete,Reply"); trans.Commit(); } catch { trans.Rollback(); return(0); } } } return(model.id); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Model.channel model) { Model.channel oldModel = GetModel(model.id); //旧的数据 //取得站点对应的导航ID int parent_id = new DAL.channel_site(databaseprefix).GetSiteNavId(model.site_id); if (parent_id == 0) { return(false); } using (SqlConnection conn = new SqlConnection(DbHelperSQL.connectionString)) { conn.Open(); using (SqlTransaction trans = conn.BeginTransaction()) { try { StringBuilder strSql = new StringBuilder(); strSql.Append("update [" + databaseprefix + "channel] set "); strSql.Append("site_id=@site_id,"); strSql.Append("name=@name,"); strSql.Append("title=@title,"); strSql.Append("is_albums=@is_albums,"); strSql.Append("is_attach=@is_attach,"); strSql.Append("is_spec=@is_spec,"); strSql.Append("sort_id=@sort_id,"); strSql.Append("seo_title=@seo_title,"); strSql.Append("seo_keywords=@seo_keywords,"); strSql.Append("seo_description=@seo_description,"); strSql.Append("is_type=@is_type,"); strSql.Append("is_attribute=@is_attribute,"); strSql.Append("is_comment=@is_comment,"); strSql.Append("height=@height,"); strSql.Append("width=@width,"); strSql.Append("is_recycle=@is_recycle"); strSql.Append(" where id=@id"); SqlParameter[] parameters = { new SqlParameter("@site_id", SqlDbType.Int, 4), new SqlParameter("@name", SqlDbType.VarChar, 50), new SqlParameter("@title", SqlDbType.VarChar, 100), new SqlParameter("@is_albums", SqlDbType.TinyInt, 1), new SqlParameter("@is_attach", SqlDbType.TinyInt, 1), new SqlParameter("@is_spec", SqlDbType.TinyInt, 1), new SqlParameter("@sort_id", SqlDbType.Int, 4), new SqlParameter("@seo_title", SqlDbType.NVarChar, 255), new SqlParameter("@seo_keywords", SqlDbType.NVarChar, 255), new SqlParameter("@seo_description", SqlDbType.NVarChar, 255), new SqlParameter("@is_type", SqlDbType.TinyInt, 1), new SqlParameter("@is_attribute", SqlDbType.TinyInt, 1), new SqlParameter("@is_comment", SqlDbType.TinyInt, 1), new SqlParameter("@height", SqlDbType.Int, 4), new SqlParameter("@width", SqlDbType.Int, 4), new SqlParameter("@is_recycle", SqlDbType.TinyInt, 1), new SqlParameter("@id", SqlDbType.Int, 4) }; parameters[0].Value = model.site_id; parameters[1].Value = model.name; parameters[2].Value = model.title; parameters[3].Value = model.is_albums; parameters[4].Value = model.is_attach; parameters[5].Value = model.is_spec; parameters[6].Value = model.sort_id; parameters[7].Value = model.seo_title; parameters[8].Value = model.seo_keywords; parameters[9].Value = model.seo_description; parameters[10].Value = model.is_type; parameters[11].Value = model.is_attribute; parameters[12].Value = model.is_comment; parameters[13].Value = model.height; parameters[14].Value = model.width; parameters[15].Value = model.is_recycle; parameters[16].Value = model.id; DbHelperSQL.ExecuteSql(conn, trans, strSql.ToString(), parameters); //删除已移除的扩展字段 FieldDelete(conn, trans, model.channel_fields, model.id); //添加扩展字段 if (model.channel_fields != null) { StringBuilder strSql2; foreach (Model.channel_field modelt in model.channel_fields) { strSql2 = new StringBuilder(); Model.channel_field fieldModel = null; if (oldModel.channel_fields != null) { fieldModel = oldModel.channel_fields.Find(p => p.field_id == modelt.field_id); //查找是否已经存在 } if (fieldModel == null) //如果不存在则添加 { strSql2.Append("insert into " + databaseprefix + "channel_field("); strSql2.Append("channel_id,field_id)"); strSql2.Append(" values ("); strSql2.Append("@channel_id,@field_id)"); SqlParameter[] parameters2 = { new SqlParameter("@channel_id", SqlDbType.Int, 4), new SqlParameter("@field_id", SqlDbType.Int, 4) }; parameters2[0].Value = modelt.channel_id; parameters2[1].Value = modelt.field_id; DbHelperSQL.ExecuteSql(conn, trans, strSql2.ToString(), parameters2); } } } //删除旧视图重建新视图 RehabChannelViews(conn, trans, model, oldModel.name); int newNavId = 0; DAL.navigation dal = new DAL.navigation(databaseprefix); if (!dal.Exists("channel_" + oldModel.name)) { //添加导航菜单 newNavId = dal.Add(conn, trans, parent_id, "channel_" + model.name, model.title, "", model.sort_id, model.id, "Show"); dal.Add(conn, trans, newNavId, "channel_" + model.name + "_list", "内容管理", "article/article_list.aspx", 99, model.id, "Show,View,Add,Edit,Delete,Audit"); dal.Add(conn, trans, newNavId, "channel_" + model.name + "_category", "栏目类别", "article/category_list.aspx", 100, model.id, "Show,View,Add,Edit,Delete"); //是否开启评论 if (model.is_comment > 0) { dal.Add(conn, trans, newNavId, "channel_" + model.name + "_comment", "评论管理", "article/comment_list.aspx", 101, model.id, "Show,View,Delete,Audit,Reply"); } //是否开启回收站 if (model.is_recycle > 0) { dal.Add(conn, trans, newNavId, "channel_" + model.name + "_recycle", "回收站", "article/recycle_list.aspx", 102, model.id, "Show,View,Edit,Delete,Audit"); } } else { //修改菜单 newNavId = new DAL.navigation(databaseprefix).GetId(conn, trans, "channel_" + oldModel.name); dal.Update(conn, trans, "channel_" + oldModel.name, parent_id, "channel_" + model.name, model.title, model.sort_id); dal.Update(conn, trans, "channel_" + oldModel.name + "_list", "channel_" + model.name + "_list"); //内容管理 dal.Update(conn, trans, "channel_" + oldModel.name + "_category", "channel_" + model.name + "_category"); //栏目类别 //是否开启评论 if (model.is_comment > 0) { if (Convert.ToInt32(DbHelperSQL.GetSingle(conn, trans, "select count(*) as H from [" + databaseprefix + "navigation] where name='channel_" + oldModel.name + "_comment'")) == 0) { dal.Add(conn, trans, newNavId, "channel_" + model.name + "_comment", "评论管理", "article/comment_list.aspx", 101, model.id, "Show,View,Delete,Audit,Reply"); } else { dal.Update(conn, trans, "channel_" + oldModel.name + "_comment", "channel_" + model.name + "_comment"); //评论管理 } } else { dal.Delete(conn, trans, "channel_" + oldModel.name + "_comment"); } //是否开启回收站 if (model.is_recycle > 0) { if (Convert.ToInt32(DbHelperSQL.GetSingle(conn, trans, "select count(*) as H from [" + databaseprefix + "navigation] where name='channel_" + oldModel.name + "_recycle'")) == 0) { dal.Add(conn, trans, newNavId, "channel_" + model.name + "_recycle", "回收站", "article/recycle_list.aspx", 102, model.id, "Show,View,Edit,Delete,Audit"); } else { dal.Update(conn, trans, "channel_" + oldModel.name + "_recycle", "channel_" + model.name + "_recycle"); //回收站 } } else { dal.Delete(conn, trans, "channel_" + oldModel.name + "_recycle"); } } trans.Commit(); } catch { trans.Rollback(); return(false); } } } return(true); }
/// <summary> /// 增加一条数据及其子表 /// </summary> public int Add(Model.channel model) { //取得站点对应的导航ID int parent_id = new DAL.channel_site(databaseprefix).GetSiteNavId(model.site_id); if (parent_id == 0) { return(0); } using (SqlConnection conn = new SqlConnection(DbHelperSQL.connectionString)) { conn.Open(); using (SqlTransaction trans = conn.BeginTransaction()) { try { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into [" + databaseprefix + "channel]("); strSql.Append("site_id,name,title,is_albums,is_attach,is_spec,sort_id,seo_title,seo_keywords,seo_description,is_type,is_attribute,is_comment,height,width,is_recycle"); strSql.Append(") values("); strSql.Append("@site_id,@name,@title,@is_albums,@is_attach,@is_spec,@sort_id,@seo_title,@seo_keywords,@seo_description,@is_type,@is_attribute,@is_comment,@height,@width,@is_recycle)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@site_id", SqlDbType.Int, 4), new SqlParameter("@name", SqlDbType.VarChar, 50), new SqlParameter("@title", SqlDbType.VarChar, 100), new SqlParameter("@is_albums", SqlDbType.TinyInt, 1), new SqlParameter("@is_attach", SqlDbType.TinyInt, 1), new SqlParameter("@is_spec", SqlDbType.TinyInt, 1), new SqlParameter("@sort_id", SqlDbType.Int, 4), new SqlParameter("@seo_title", SqlDbType.NVarChar, 255), new SqlParameter("@seo_keywords", SqlDbType.NVarChar, 255), new SqlParameter("@seo_description", SqlDbType.NVarChar, 255), new SqlParameter("@is_type", SqlDbType.TinyInt, 1), new SqlParameter("@is_attribute", SqlDbType.TinyInt, 1), new SqlParameter("@is_comment", SqlDbType.TinyInt, 1), new SqlParameter("@height", SqlDbType.Int, 4), new SqlParameter("@width", SqlDbType.Int, 4), new SqlParameter("@is_recycle", SqlDbType.TinyInt, 1) }; parameters[0].Value = model.site_id; parameters[1].Value = model.name; parameters[2].Value = model.title; parameters[3].Value = model.is_albums; parameters[4].Value = model.is_attach; parameters[5].Value = model.is_spec; parameters[6].Value = model.sort_id; parameters[7].Value = model.seo_title; parameters[8].Value = model.seo_keywords; parameters[9].Value = model.seo_description; parameters[10].Value = model.is_type; parameters[11].Value = model.is_attribute; parameters[12].Value = model.is_comment; parameters[13].Value = model.height; parameters[14].Value = model.width; parameters[15].Value = model.is_recycle; object obj = DbHelperSQL.GetSingle(conn, trans, strSql.ToString(), parameters); //带事务 model.id = Convert.ToInt32(obj); //扩展字段 if (model.channel_fields != null) { StringBuilder strSql2; foreach (Model.channel_field modelt in model.channel_fields) { strSql2 = new StringBuilder(); strSql2.Append("insert into " + databaseprefix + "channel_field("); strSql2.Append("channel_id,field_id)"); strSql2.Append(" values ("); strSql2.Append("@channel_id,@field_id)"); SqlParameter[] parameters2 = { new SqlParameter("@channel_id", SqlDbType.Int, 4), new SqlParameter("@field_id", SqlDbType.Int, 4) }; parameters2[0].Value = model.id; parameters2[1].Value = modelt.field_id; DbHelperSQL.ExecuteSql(conn, trans, strSql2.ToString(), parameters2); } } //添加视图 StringBuilder strSql3 = new StringBuilder(); strSql3.Append("CREATE VIEW view_channel_" + model.name + " as"); strSql3.Append(" SELECT " + databaseprefix + "article.*"); if (model.channel_fields != null) { foreach (Model.channel_field modelt in model.channel_fields) { Model.article_attribute_field fieldModel = new DAL.article_attribute_field(databaseprefix).GetModel(modelt.field_id); if (fieldModel != null) { strSql3.Append("," + databaseprefix + "article_attribute_value." + fieldModel.name); } } } strSql3.Append(" FROM " + databaseprefix + "article_attribute_value INNER JOIN"); strSql3.Append(" " + databaseprefix + "article ON " + databaseprefix + "article_attribute_value.article_id = " + databaseprefix + "article.id"); strSql3.Append(" WHERE " + databaseprefix + "article.channel_id=" + model.id); DbHelperSQL.ExecuteSql(conn, trans, strSql3.ToString()); //添加导航菜单 DAL.navigation dal = new DAL.navigation(databaseprefix); int newNavId = dal.Add(conn, trans, parent_id, "channel_" + model.name, model.title, "", model.sort_id, model.id, "Show"); dal.Add(conn, trans, newNavId, "channel_" + model.name + "_list", "内容管理", "article/article_list.aspx", 99, model.id, "Show,View,Add,Edit,Delete,Audit"); dal.Add(conn, trans, newNavId, "channel_" + model.name + "_category", "栏目类别", "article/category_list.aspx", 100, model.id, "Show,View,Add,Edit,Delete"); if (model.is_comment == 1) { dal.Add(conn, trans, newNavId, "channel_" + model.name + "_comment", "评论管理", "article/comment_list.aspx", 101, model.id, "Show,View,Delete,Reply"); } if (model.is_recycle == 1) { dal.Add(conn, trans, newNavId, "channel_" + model.name + "_recycle", "回收站", "article/recycle_list.aspx", 102, model.id, "Show,View,Edit,Delete,Audit"); } trans.Commit(); } catch { trans.Rollback(); return(0); } } } return(model.id); }
private readonly Model.siteconfig siteConfig = new BLL.siteconfig().loadConfig(); //获得站点配置信息 #endregion Fields #region Constructors public channel_site() { dal = new DAL.channel_site(siteConfig.sysdatabaseprefix); }
/// <summary> /// 增加一条数据及其子表 /// </summary> public int Add(Model.channel model) { //取得站点对应的导航ID int parent_id = new DAL.channel_site(databaseprefix).GetSiteNavId(model.site_id); if (parent_id == 0) { return 0; } using (SqlConnection conn = new SqlConnection(DbHelperSQL.connectionString)) { conn.Open(); using (SqlTransaction trans = conn.BeginTransaction()) { try { StringBuilder strSql=new StringBuilder(); strSql.Append("insert into " + databaseprefix + "channel("); strSql.Append("site_id,name,title,is_albums,is_attach,is_spec,sort_id)"); strSql.Append(" values ("); strSql.Append("@site_id,@name,@title,@is_albums,@is_attach,@is_spec,@sort_id)"); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@site_id", SqlDbType.Int,4), new SqlParameter("@name", SqlDbType.VarChar,50), new SqlParameter("@title", SqlDbType.NVarChar,100), new SqlParameter("@is_albums", SqlDbType.TinyInt,1), new SqlParameter("@is_attach", SqlDbType.TinyInt,1), new SqlParameter("@is_spec", SqlDbType.TinyInt,1), new SqlParameter("@sort_id", SqlDbType.Int,4)}; parameters[0].Value = model.site_id; parameters[1].Value = model.name; parameters[2].Value = model.title; parameters[3].Value = model.is_albums; parameters[4].Value = model.is_attach; parameters[5].Value = model.is_spec; parameters[6].Value = model.sort_id; object obj = DbHelperSQL.GetSingle(conn, trans, strSql.ToString(), parameters); //带事务 model.id = Convert.ToInt32(obj); //扩展字段 if (model.channel_fields != null) { StringBuilder strSql2; foreach (Model.channel_field modelt in model.channel_fields) { strSql2 = new StringBuilder(); strSql2.Append("insert into " + databaseprefix + "channel_field("); strSql2.Append("channel_id,field_id)"); strSql2.Append(" values ("); strSql2.Append("@channel_id,@field_id)"); SqlParameter[] parameters2 = { new SqlParameter("@channel_id", SqlDbType.Int,4), new SqlParameter("@field_id", SqlDbType.Int,4)}; parameters2[0].Value = model.id; parameters2[1].Value = modelt.field_id; DbHelperSQL.ExecuteSql(conn, trans, strSql2.ToString(), parameters2); } } //添加视图 StringBuilder strSql3 = new StringBuilder(); strSql3.Append("CREATE VIEW view_channel_" + model.name + " as"); strSql3.Append(" SELECT " + databaseprefix + "article.*"); if (model.channel_fields != null) { foreach (Model.channel_field modelt in model.channel_fields) { Model.article_attribute_field fieldModel = new DAL.article_attribute_field(databaseprefix).GetModel(modelt.field_id); if (fieldModel != null) { strSql3.Append("," + databaseprefix + "article_attribute_value." + fieldModel.name); } } } strSql3.Append(" FROM " + databaseprefix + "article_attribute_value INNER JOIN"); strSql3.Append(" " + databaseprefix + "article ON " + databaseprefix + "article_attribute_value.article_id = " + databaseprefix + "article.id"); strSql3.Append(" WHERE " + databaseprefix + "article.channel_id=" + model.id); DbHelperSQL.ExecuteSql(conn, trans, strSql3.ToString()); //添加导航菜单 int newNavId = new DAL.navigation(databaseprefix).Add(conn, trans, parent_id, "channel_" + model.name, model.title, "", model.sort_id, model.id, "Show"); new DAL.navigation(databaseprefix).Add(conn, trans, newNavId, "channel_" + model.name + "_list", "内容管理", "article/article_list.aspx", 99, model.id, "Show,View,Add,Edit,Delete,Audit"); new DAL.navigation(databaseprefix).Add(conn, trans, newNavId, "channel_" + model.name + "_category", "栏目类别", "article/category_list.aspx", 100, model.id, "Show,View,Add,Edit,Delete"); new DAL.navigation(databaseprefix).Add(conn, trans, newNavId, "channel_" + model.name + "_comment", "评论管理", "article/comment_list.aspx", 101, model.id, "Show,View,Delete,Reply"); trans.Commit(); } catch { trans.Rollback(); return 0; } } } return model.id; }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(Model.channel model) { Model.channel oldModel = GetModel(model.id); //旧的数据 //取得站点对应的导航ID int parent_id = new DAL.channel_site(databaseprefix).GetSiteNavId(model.site_id); if (parent_id == 0) { return false; } using (SqlConnection conn = new SqlConnection(DbHelperSQL.connectionString)) { conn.Open(); using (SqlTransaction trans = conn.BeginTransaction()) { try { StringBuilder strSql=new StringBuilder(); strSql.Append("update " + databaseprefix + "channel set "); strSql.Append("site_id=@site_id,"); strSql.Append("name=@name,"); strSql.Append("title=@title,"); strSql.Append("is_albums=@is_albums,"); strSql.Append("is_attach=@is_attach,"); strSql.Append("is_spec=@is_spec,"); strSql.Append("sort_id=@sort_id"); strSql.Append(" where id=@id "); SqlParameter[] parameters = { new SqlParameter("@site_id", SqlDbType.Int,4), new SqlParameter("@name", SqlDbType.VarChar,50), //SqlDbType.VarChar 只能存英文?买了个表的 new SqlParameter("@title", SqlDbType.NVarChar,100), new SqlParameter("@is_albums", SqlDbType.TinyInt,1), new SqlParameter("@is_attach", SqlDbType.TinyInt,1), new SqlParameter("@is_spec", SqlDbType.TinyInt,1), new SqlParameter("@sort_id", SqlDbType.Int,4), new SqlParameter("@id", SqlDbType.Int,4)}; parameters[0].Value = model.site_id; parameters[1].Value = model.name; parameters[2].Value = model.title; parameters[3].Value = model.is_albums; parameters[4].Value = model.is_attach; parameters[5].Value = model.is_spec; parameters[6].Value = model.sort_id; parameters[7].Value = model.id; DbHelperSQL.ExecuteSql(conn, trans, strSql.ToString(), parameters); //删除已移除的扩展字段 FieldDelete(conn, trans, model.channel_fields, model.id); //添加扩展字段 if (model.channel_fields != null) { StringBuilder strSql2; foreach (Model.channel_field modelt in model.channel_fields) { strSql2 = new StringBuilder(); Model.channel_field fieldModel = null; if (oldModel.channel_fields != null) { fieldModel = oldModel.channel_fields.Find(p => p.field_id == modelt.field_id); //查找是否已经存在 } if (fieldModel == null) //如果不存在则添加 { strSql2.Append("insert into " + databaseprefix + "channel_field("); strSql2.Append("channel_id,field_id)"); strSql2.Append(" values ("); strSql2.Append("@channel_id,@field_id)"); SqlParameter[] parameters2 = { new SqlParameter("@channel_id", SqlDbType.Int,4), new SqlParameter("@field_id", SqlDbType.Int,4)}; parameters2[0].Value = modelt.channel_id; parameters2[1].Value = modelt.field_id; DbHelperSQL.ExecuteSql(conn, trans, strSql2.ToString(), parameters2); } } } //删除旧视图重建新视图 RehabChannelViews(conn, trans, model, oldModel.name); //修改对应的导航 new DAL.navigation(databaseprefix).Update(conn, trans, "channel_" + oldModel.name, parent_id, "channel_" + model.name, model.title, model.sort_id); new DAL.navigation(databaseprefix).Update(conn, trans, "channel_" + oldModel.name + "_list", "channel_" + model.name + "_list"); //内容管理 new DAL.navigation(databaseprefix).Update(conn, trans, "channel_" + oldModel.name + "_category", "channel_" + model.name + "_category"); //栏目类别 new DAL.navigation(databaseprefix).Update(conn, trans, "channel_" + oldModel.name + "_comment", "channel_" + model.name + "_comment"); //评论管理 trans.Commit(); } catch { trans.Rollback(); return false; } } } return true; }