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));
}
