private bool DoEdit(int _id) { try { Rain.BLL.article_category articleCategory = new Rain.BLL.article_category(); Rain.Model.article_category model = articleCategory.GetModel(_id); int num = int.Parse(this.ddlParentId.SelectedValue); model.channel_id = this.channel_id; model.call_index = this.txtCallIndex.Text.Trim(); model.title = this.txtTitle.Text.Trim(); if (num != model.id) { model.parent_id = num; } model.sort_id = int.Parse(this.txtSortId.Text.Trim()); model.seo_title = this.txtSeoTitle.Text; model.seo_keywords = this.txtSeoKeywords.Text; model.seo_description = this.txtSeoDescription.Text; model.link_url = this.txtLinkUrl.Text.Trim(); model.img_url = this.txtImgUrl.Text.Trim(); model.content = this.txtContent.Value; if (articleCategory.Update(model)) { this.AddAdminLog(DTEnums.ActionEnum.Edit.ToString(), "修改" + this.channel_name + "频道栏目分类:" + model.title); return(true); } } catch { return(false); } return(false); }
protected override void ShowPage() { this.page = DTRequest.GetQueryInt("page", 1); this.category_id = DTRequest.GetQueryInt("category_id"); Rain.BLL.article_category articleCategory = new Rain.BLL.article_category(); this.model.title = "所有类别"; if (this.category_id <= 0 || !articleCategory.Exists(this.category_id)) { return; } this.model = articleCategory.GetModel(this.category_id); }
private void UpdateChilds(OleDbConnection conn, OleDbTransaction trans, int parent_id) { Rain.Model.article_category model = this.GetModel(conn, trans, parent_id); if (model == null) { return; } string SQLString = "select id from " + this.databaseprefix + "article_category where parent_id=" + (object)parent_id; foreach (DataRow row in (InternalDataCollectionBase)DbHelperOleDb.Query(conn, trans, SQLString).Tables[0].Rows) { int parent_id1 = int.Parse(row["id"].ToString()); string str = model.class_list + (object)parent_id1 + ","; int num = model.class_layer + 1; DbHelperOleDb.ExecuteSql(conn, trans, "update " + this.databaseprefix + "article_category set class_list='" + str + "', class_layer=" + (object)num + " where id=" + (object)parent_id1); this.UpdateChilds(conn, trans, parent_id1); } }
public Rain.Model.article_category GetModel(int id) { StringBuilder stringBuilder = new StringBuilder(); stringBuilder.Append("select top 1 id,channel_id,title,call_index,parent_id,class_list,class_layer,sort_id,link_url,img_url,content,seo_title,seo_keywords,seo_description"); stringBuilder.Append(" from " + this.databaseprefix + "article_category "); stringBuilder.Append(" where id=@id"); OleDbParameter[] oleDbParameterArray = new OleDbParameter[1] { new OleDbParameter("@id", OleDbType.Integer, 4) }; oleDbParameterArray[0].Value = (object)id; Rain.Model.article_category articleCategory = new Rain.Model.article_category(); DataSet dataSet = DbHelperOleDb.Query(stringBuilder.ToString(), oleDbParameterArray); if (dataSet.Tables[0].Rows.Count > 0) { return(this.DataRowToModel(dataSet.Tables[0].Rows[0])); } return((Rain.Model.article_category)null); }
public int Add(Rain.Model.article_category model) { using (OleDbConnection oleDbConnection = new OleDbConnection(DbHelperOleDb.connectionString)) { oleDbConnection.Open(); using (OleDbTransaction trans = oleDbConnection.BeginTransaction()) { try { StringBuilder stringBuilder = new StringBuilder(); stringBuilder.Append("insert into " + this.databaseprefix + "article_category("); stringBuilder.Append("channel_id,title,call_index,parent_id,class_list,class_layer,sort_id,link_url,img_url,content,seo_title,seo_keywords,seo_description)"); stringBuilder.Append(" values ("); stringBuilder.Append("@channel_id,@title,@call_index,@parent_id,@class_list,@class_layer,@sort_id,@link_url,@img_url,@content,@seo_title,@seo_keywords,@seo_description)"); OleDbParameter[] oleDbParameterArray = new OleDbParameter[13] { new OleDbParameter("@channel_id", OleDbType.Integer, 4), new OleDbParameter("@title", OleDbType.VarChar, 100), new OleDbParameter("@call_index", OleDbType.VarChar, 50), new OleDbParameter("@parent_id", OleDbType.Integer, 4), new OleDbParameter("@class_list", OleDbType.VarChar, 500), new OleDbParameter("@class_layer", OleDbType.Integer, 4), new OleDbParameter("@sort_id", OleDbType.Integer, 4), new OleDbParameter("@link_url", OleDbType.VarChar, (int)byte.MaxValue), new OleDbParameter("@img_url", OleDbType.VarChar, (int)byte.MaxValue), new OleDbParameter("@content", OleDbType.VarChar), new OleDbParameter("@seo_title", OleDbType.VarChar, (int)byte.MaxValue), new OleDbParameter("@seo_keywords", OleDbType.VarChar, (int)byte.MaxValue), new OleDbParameter("@seo_description", OleDbType.VarChar, (int)byte.MaxValue) }; oleDbParameterArray[0].Value = (object)model.channel_id; oleDbParameterArray[1].Value = (object)model.title; oleDbParameterArray[2].Value = (object)model.call_index; oleDbParameterArray[3].Value = (object)model.parent_id; oleDbParameterArray[4].Value = (object)model.class_list; oleDbParameterArray[5].Value = (object)model.class_layer; oleDbParameterArray[6].Value = (object)model.sort_id; oleDbParameterArray[7].Value = (object)model.link_url; oleDbParameterArray[8].Value = (object)model.img_url; oleDbParameterArray[9].Value = (object)model.content; oleDbParameterArray[10].Value = (object)model.seo_title; oleDbParameterArray[11].Value = (object)model.seo_keywords; oleDbParameterArray[12].Value = (object)model.seo_description; DbHelperOleDb.ExecuteSql(oleDbConnection, trans, stringBuilder.ToString(), oleDbParameterArray); model.id = this.GetMaxId(oleDbConnection, trans); if (model.parent_id > 0) { Rain.Model.article_category model1 = this.GetModel(oleDbConnection, trans, model.parent_id); model.class_list = model1.class_list + (object)model.id + ","; model.class_layer = model1.class_layer + 1; } else { model.class_list = "," + (object)model.id + ","; model.class_layer = 1; } DbHelperOleDb.ExecuteSql(oleDbConnection, trans, "update " + this.databaseprefix + "article_category set class_list='" + model.class_list + "', class_layer=" + (object)model.class_layer + " where id=" + (object)model.id); trans.Commit(); } catch { trans.Rollback(); return(0); } } } return(model.id); }
public Rain.Model.article_category DataRowToModel(DataRow row) { Rain.Model.article_category articleCategory = new Rain.Model.article_category(); if (row != null) { if (row["id"] != null && row["id"].ToString() != "") { articleCategory.id = int.Parse(row["id"].ToString()); } if (row["channel_id"] != null && row["channel_id"].ToString() != "") { articleCategory.channel_id = int.Parse(row["channel_id"].ToString()); } if (row["title"] != null) { articleCategory.title = row["title"].ToString(); } if (row["call_index"] != null) { articleCategory.call_index = row["call_index"].ToString(); } if (row["parent_id"] != null && row["parent_id"].ToString() != "") { articleCategory.parent_id = int.Parse(row["parent_id"].ToString()); } if (row["class_list"] != null) { articleCategory.class_list = row["class_list"].ToString(); } if (row["class_layer"] != null && row["class_layer"].ToString() != "") { articleCategory.class_layer = int.Parse(row["class_layer"].ToString()); } if (row["sort_id"] != null && row["sort_id"].ToString() != "") { articleCategory.sort_id = int.Parse(row["sort_id"].ToString()); } if (row["link_url"] != null) { articleCategory.link_url = row["link_url"].ToString(); } if (row["img_url"] != null) { articleCategory.img_url = row["img_url"].ToString(); } if (row["content"] != null) { articleCategory.content = row["content"].ToString(); } if (row["seo_title"] != null) { articleCategory.seo_title = row["seo_title"].ToString(); } if (row["seo_keywords"] != null) { articleCategory.seo_keywords = row["seo_keywords"].ToString(); } if (row["seo_description"] != null) { articleCategory.seo_description = row["seo_description"].ToString(); } } return(articleCategory); }
public bool Update(Rain.Model.article_category model) { using (OleDbConnection oleDbConnection = new OleDbConnection(DbHelperOleDb.connectionString)) { oleDbConnection.Open(); using (OleDbTransaction trans = oleDbConnection.BeginTransaction()) { try { if (this.IsContainNode(model.id, model.parent_id)) { Rain.Model.article_category model1 = this.GetModel(model.id); string str = "," + (object)model.parent_id + ","; int num = 1; if (model1.parent_id > 0) { Rain.Model.article_category model2 = this.GetModel(oleDbConnection, trans, model1.parent_id); str = model2.class_list + (object)model.parent_id + ","; num = model2.class_layer + 1; } DbHelperOleDb.ExecuteSql(oleDbConnection, trans, "update " + this.databaseprefix + "article_category set parent_id=" + (object)model1.parent_id + ",class_list='" + str + "', class_layer=" + (object)num + " where id=" + (object)model.parent_id); this.UpdateChilds(oleDbConnection, trans, model.parent_id); } if (model.parent_id > 0) { Rain.Model.article_category model1 = this.GetModel(oleDbConnection, trans, model.parent_id); model.class_list = model1.class_list + (object)model.id + ","; model.class_layer = model1.class_layer + 1; } else { model.class_list = "," + (object)model.id + ","; model.class_layer = 1; } StringBuilder stringBuilder = new StringBuilder(); stringBuilder.Append("update " + this.databaseprefix + "article_category set "); stringBuilder.Append("channel_id=@channel_id,"); stringBuilder.Append("title=@title,"); stringBuilder.Append("call_index=@call_index,"); stringBuilder.Append("parent_id=@parent_id,"); stringBuilder.Append("class_list=@class_list,"); stringBuilder.Append("class_layer=@class_layer,"); stringBuilder.Append("sort_id=@sort_id,"); stringBuilder.Append("link_url=@link_url,"); stringBuilder.Append("img_url=@img_url,"); stringBuilder.Append("content=@content,"); stringBuilder.Append("seo_title=@seo_title,"); stringBuilder.Append("seo_keywords=@seo_keywords,"); stringBuilder.Append("seo_description=@seo_description"); stringBuilder.Append(" where id=@id"); OleDbParameter[] oleDbParameterArray = new OleDbParameter[14] { new OleDbParameter("@channel_id", OleDbType.Integer, 4), new OleDbParameter("@title", OleDbType.VarChar, 100), new OleDbParameter("@call_index", OleDbType.VarChar, 50), new OleDbParameter("@parent_id", OleDbType.Integer, 4), new OleDbParameter("@class_list", OleDbType.VarChar, 500), new OleDbParameter("@class_layer", OleDbType.Integer, 4), new OleDbParameter("@sort_id", OleDbType.Integer, 4), new OleDbParameter("@link_url", OleDbType.VarChar, (int)byte.MaxValue), new OleDbParameter("@img_url", OleDbType.VarChar, (int)byte.MaxValue), new OleDbParameter("@content", OleDbType.VarChar), new OleDbParameter("@seo_title", OleDbType.VarChar, (int)byte.MaxValue), new OleDbParameter("@seo_keywords", OleDbType.VarChar, (int)byte.MaxValue), new OleDbParameter("@seo_description", OleDbType.VarChar, (int)byte.MaxValue), new OleDbParameter("@id", OleDbType.Integer, 4) }; oleDbParameterArray[0].Value = (object)model.channel_id; oleDbParameterArray[1].Value = (object)model.title; oleDbParameterArray[2].Value = (object)model.call_index; oleDbParameterArray[3].Value = (object)model.parent_id; oleDbParameterArray[4].Value = (object)model.class_list; oleDbParameterArray[5].Value = (object)model.class_layer; oleDbParameterArray[6].Value = (object)model.sort_id; oleDbParameterArray[7].Value = (object)model.link_url; oleDbParameterArray[8].Value = (object)model.img_url; oleDbParameterArray[9].Value = (object)model.content; oleDbParameterArray[10].Value = (object)model.seo_title; oleDbParameterArray[11].Value = (object)model.seo_keywords; oleDbParameterArray[12].Value = (object)model.seo_description; oleDbParameterArray[13].Value = (object)model.id; DbHelperOleDb.ExecuteSql(oleDbConnection, trans, stringBuilder.ToString(), oleDbParameterArray); this.UpdateChilds(oleDbConnection, trans, model.id); trans.Commit(); } catch (Exception ex) { trans.Rollback(); return(false); } } } return(true); }
public bool Update(Rain.Model.article_category model) { return(this.dal.Update(model)); }
public int Add(Rain.Model.article_category model) { return(this.dal.Add(model)); }