public void RehabChannelViews(
OleDbConnection conn,
OleDbTransaction trans,
Rain.Model.channel model,
string old_name)
{
StringBuilder stringBuilder1 = new StringBuilder();
stringBuilder1.Append("drop view view_channel_" + old_name);
DbHelperOleDb.ExecuteSql(conn, trans, stringBuilder1.ToString());
StringBuilder stringBuilder2 = new StringBuilder();
stringBuilder2.Append("CREATE VIEW view_channel_" + model.name + " as");
stringBuilder2.Append(" SELECT " + this.databaseprefix + "article.*");
if (model.channel_fields != null)
{
foreach (channel_field channelField in model.channel_fields)
{
Rain.Model.article_attribute_field model1 = new article_attribute_field(this.databaseprefix).GetModel(channelField.field_id);
if (model1 != null)
{
stringBuilder2.Append("," + this.databaseprefix + "article_attribute_value." + model1.name);
}
}
}
stringBuilder2.Append(" FROM " + this.databaseprefix + "article_attribute_value INNER JOIN");
stringBuilder2.Append(" " + this.databaseprefix + "article ON " + this.databaseprefix + "article_attribute_value.article_id = " + this.databaseprefix + "article.id");
stringBuilder2.Append(" WHERE " + this.databaseprefix + "article.channel_id=" + (object)model.id);
DbHelperOleDb.ExecuteSql(conn, trans, stringBuilder2.ToString());
}
public Rain.Model.channel GetModel(string channel_name)
{
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append("select top 1 id,site_id,[name],title,is_albums,is_attach,is_spec,sort_id from " + this.databaseprefix + "channel ");
stringBuilder.Append(" where name=@channel_name ");
OleDbParameter[] oleDbParameterArray = new OleDbParameter[1]
{
new OleDbParameter("@channel_name", OleDbType.VarChar, 50)
};
oleDbParameterArray[0].Value = (object)channel_name;
Rain.Model.channel channel = new Rain.Model.channel();
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.channel)null);
}
public Rain.Model.channel GetModel(
OleDbConnection conn,
OleDbTransaction trans,
int id)
{
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append("select top 1 id,site_id,[name],title,is_albums,is_attach,is_spec,sort_id from " + this.databaseprefix + "channel ");
stringBuilder.Append(" where id=@id ");
OleDbParameter[] oleDbParameterArray = new OleDbParameter[1]
{
new OleDbParameter("@id", OleDbType.Integer, 4)
};
oleDbParameterArray[0].Value = (object)id;
Rain.Model.channel channel = new Rain.Model.channel();
DataSet dataSet = DbHelperOleDb.Query(conn, trans, stringBuilder.ToString(), oleDbParameterArray);
if (dataSet.Tables[0].Rows.Count > 0)
{
return(this.DataRowToModel(conn, trans, dataSet.Tables[0].Rows[0]));
}
return((Rain.Model.channel)null);
}
public int Add(Rain.Model.channel model)
{
int siteNavId = new channel_site(this.databaseprefix).GetSiteNavId(model.site_id);
if (siteNavId == 0)
{
return(0);
}
using (OleDbConnection oleDbConnection = new OleDbConnection(DbHelperOleDb.connectionString))
{
oleDbConnection.Open();
using (OleDbTransaction trans = oleDbConnection.BeginTransaction())
{
try
{
StringBuilder stringBuilder1 = new StringBuilder();
stringBuilder1.Append("insert into " + this.databaseprefix + "channel(");
stringBuilder1.Append("site_id,[name],title,is_albums,is_attach,is_spec,sort_id)");
stringBuilder1.Append(" values (");
stringBuilder1.Append("@site_id,@name,@title,@is_albums,@is_attach,@is_spec,@sort_id)");
OleDbParameter[] oleDbParameterArray1 = new OleDbParameter[7]
{
new OleDbParameter("@site_id", OleDbType.Integer, 4),
new OleDbParameter("@name", OleDbType.VarChar, 50),
new OleDbParameter("@title", OleDbType.VarChar, 100),
new OleDbParameter("@is_albums", OleDbType.Integer, 4),
new OleDbParameter("@is_attach", OleDbType.Integer, 4),
new OleDbParameter("@is_spec", OleDbType.Integer, 4),
new OleDbParameter("@sort_id", OleDbType.Integer, 4)
};
oleDbParameterArray1[0].Value = (object)model.site_id;
oleDbParameterArray1[1].Value = (object)model.name;
oleDbParameterArray1[2].Value = (object)model.title;
oleDbParameterArray1[3].Value = (object)model.is_albums;
oleDbParameterArray1[4].Value = (object)model.is_attach;
oleDbParameterArray1[5].Value = (object)model.is_spec;
oleDbParameterArray1[6].Value = (object)model.sort_id;
DbHelperOleDb.ExecuteSql(oleDbConnection, trans, stringBuilder1.ToString(), oleDbParameterArray1);
model.id = this.GetMaxId(oleDbConnection, trans);
if (model.channel_fields != null)
{
foreach (channel_field channelField in model.channel_fields)
{
StringBuilder stringBuilder2 = new StringBuilder();
stringBuilder2.Append("insert into " + this.databaseprefix + "channel_field(");
stringBuilder2.Append("channel_id,field_id)");
stringBuilder2.Append(" values (");
stringBuilder2.Append("@channel_id,@field_id)");
OleDbParameter[] oleDbParameterArray2 = new OleDbParameter[2]
{
new OleDbParameter("@channel_id", OleDbType.Integer, 4),
new OleDbParameter("@field_id", OleDbType.Integer, 4)
};
oleDbParameterArray2[0].Value = (object)model.id;
oleDbParameterArray2[1].Value = (object)channelField.field_id;
DbHelperOleDb.ExecuteSql(oleDbConnection, trans, stringBuilder2.ToString(), oleDbParameterArray2);
}
}
StringBuilder stringBuilder3 = new StringBuilder();
stringBuilder3.Append("CREATE VIEW view_channel_" + model.name + " as");
stringBuilder3.Append(" SELECT " + this.databaseprefix + "article.*");
if (model.channel_fields != null)
{
foreach (channel_field channelField in model.channel_fields)
{
Rain.Model.article_attribute_field model1 = new article_attribute_field(this.databaseprefix).GetModel(channelField.field_id);
if (model1 != null)
{
stringBuilder3.Append("," + this.databaseprefix + "article_attribute_value." + model1.name);
}
}
}
stringBuilder3.Append(" FROM " + this.databaseprefix + "article_attribute_value INNER JOIN");
stringBuilder3.Append(" " + this.databaseprefix + "article ON " + this.databaseprefix + "article_attribute_value.article_id = " + this.databaseprefix + "article.id");
stringBuilder3.Append(" WHERE " + this.databaseprefix + "article.channel_id=" + (object)model.id);
DbHelperOleDb.ExecuteSql(oleDbConnection, trans, stringBuilder3.ToString());
int parent_id = new navigation(this.databaseprefix).Add(oleDbConnection, trans, siteNavId, "channel_" + model.name, model.title, "", model.sort_id, model.id, "Show");
new navigation(this.databaseprefix).Add(oleDbConnection, trans, parent_id, "channel_" + model.name + "_list", "内容管理", "article/article_list.aspx", 99, model.id, "Show,View,Add,Edit,Delete,Audit");
new navigation(this.databaseprefix).Add(oleDbConnection, trans, parent_id, "channel_" + model.name + "_category", "栏目类别", "article/category_list.aspx", 100, model.id, "Show,View,Add,Edit,Delete");
new navigation(this.databaseprefix).Add(oleDbConnection, trans, parent_id, "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);
}
public Rain.Model.channel DataRowToModel(
OleDbConnection conn,
OleDbTransaction trans,
DataRow row)
{
Rain.Model.channel channel = new Rain.Model.channel();
if (row != null)
{
if (row["id"] != null && row["id"].ToString() != "")
{
channel.id = int.Parse(row["id"].ToString());
}
if (row["site_id"] != null && row["site_id"].ToString() != "")
{
channel.site_id = int.Parse(row["site_id"].ToString());
}
if (row["name"] != null)
{
channel.name = row["name"].ToString();
}
if (row["title"] != null)
{
channel.title = row["title"].ToString();
}
if (row["is_albums"] != null && row["is_albums"].ToString() != "")
{
channel.is_albums = int.Parse(row["is_albums"].ToString());
}
if (row["is_attach"] != null && row["is_attach"].ToString() != "")
{
channel.is_attach = int.Parse(row["is_attach"].ToString());
}
if (row["is_spec"] != null && row["is_spec"].ToString() != "")
{
channel.is_spec = int.Parse(row["is_spec"].ToString());
}
if (row["sort_id"] != null && row["sort_id"].ToString() != "")
{
channel.sort_id = int.Parse(row["sort_id"].ToString());
}
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append("select top 1 id,channel_id,field_id from " + this.databaseprefix + "channel_field ");
stringBuilder.Append(" where channel_id=@channel_id ");
OleDbParameter[] oleDbParameterArray = new OleDbParameter[1]
{
new OleDbParameter("@channel_id", OleDbType.Integer, 4)
};
oleDbParameterArray[0].Value = (object)channel.id;
DataSet dataSet = DbHelperOleDb.Query(conn, trans, stringBuilder.ToString(), oleDbParameterArray);
if (dataSet.Tables[0].Rows.Count > 0)
{
int count = dataSet.Tables[0].Rows.Count;
List <channel_field> channelFieldList = new List <channel_field>();
for (int index = 0; index < count; ++index)
{
channel_field channelField = new channel_field();
if (dataSet.Tables[0].Rows[index]["id"].ToString() != "")
{
channelField.id = int.Parse(dataSet.Tables[0].Rows[index]["id"].ToString());
}
if (dataSet.Tables[0].Rows[index]["channel_id"].ToString() != "")
{
channelField.channel_id = int.Parse(dataSet.Tables[0].Rows[index]["channel_id"].ToString());
}
if (dataSet.Tables[0].Rows[index]["field_id"].ToString() != "")
{
channelField.field_id = int.Parse(dataSet.Tables[0].Rows[index]["field_id"].ToString());
}
channelFieldList.Add(channelField);
}
channel.channel_fields = channelFieldList;
}
}
return(channel);
}
public bool Update(Rain.Model.channel model)
{
Rain.Model.channel model1 = this.GetModel(model.id);
int siteNavId = new channel_site(this.databaseprefix).GetSiteNavId(model.site_id);
if (siteNavId == 0)
{
return(false);
}
using (OleDbConnection oleDbConnection = new OleDbConnection(DbHelperOleDb.connectionString))
{
oleDbConnection.Open();
using (OleDbTransaction trans = oleDbConnection.BeginTransaction())
{
try
{
StringBuilder stringBuilder1 = new StringBuilder();
stringBuilder1.Append("update " + this.databaseprefix + "channel set ");
stringBuilder1.Append("site_id=@site_id,");
stringBuilder1.Append("[name]=@name,");
stringBuilder1.Append("title=@title,");
stringBuilder1.Append("is_albums=@is_albums,");
stringBuilder1.Append("is_attach=@is_attach,");
stringBuilder1.Append("is_spec=@is_spec,");
stringBuilder1.Append("sort_id=@sort_id");
stringBuilder1.Append(" where id=@id ");
OleDbParameter[] oleDbParameterArray1 = new OleDbParameter[8]
{
new OleDbParameter("@site_id", OleDbType.Integer, 4),
new OleDbParameter("@name", OleDbType.VarChar, 50),
new OleDbParameter("@title", OleDbType.VarChar, 100),
new OleDbParameter("@is_albums", OleDbType.Integer, 4),
new OleDbParameter("@is_attach", OleDbType.Integer, 4),
new OleDbParameter("@is_spec", OleDbType.Integer, 4),
new OleDbParameter("@sort_id", OleDbType.Integer, 4),
new OleDbParameter("@id", OleDbType.Integer, 4)
};
oleDbParameterArray1[0].Value = (object)model.site_id;
oleDbParameterArray1[1].Value = (object)model.name;
oleDbParameterArray1[2].Value = (object)model.title;
oleDbParameterArray1[3].Value = (object)model.is_albums;
oleDbParameterArray1[4].Value = (object)model.is_attach;
oleDbParameterArray1[5].Value = (object)model.is_spec;
oleDbParameterArray1[6].Value = (object)model.sort_id;
oleDbParameterArray1[7].Value = (object)model.id;
DbHelperOleDb.ExecuteSql(oleDbConnection, trans, stringBuilder1.ToString(), oleDbParameterArray1);
this.FieldDelete(oleDbConnection, trans, model.channel_fields, model.id);
if (model.channel_fields != null)
{
using (List <channel_field> .Enumerator enumerator = model.channel_fields.GetEnumerator())
{
while (enumerator.MoveNext())
{
channel_field modelt = enumerator.Current;
StringBuilder stringBuilder2 = new StringBuilder();
channel_field channelField = (channel_field)null;
if (model1.channel_fields != null)
{
channelField = model1.channel_fields.Find((Predicate <channel_field>)(p => p.field_id == modelt.field_id));
}
if (channelField == null)
{
stringBuilder2.Append("insert into " + this.databaseprefix + "channel_field(");
stringBuilder2.Append("channel_id,field_id)");
stringBuilder2.Append(" values (");
stringBuilder2.Append("@channel_id,@field_id)");
OleDbParameter[] oleDbParameterArray2 = new OleDbParameter[2]
{
new OleDbParameter("@channel_id", OleDbType.Integer, 4),
new OleDbParameter("@field_id", OleDbType.Integer, 4)
};
oleDbParameterArray2[0].Value = (object)modelt.channel_id;
oleDbParameterArray2[1].Value = (object)modelt.field_id;
DbHelperOleDb.ExecuteSql(oleDbConnection, trans, stringBuilder2.ToString(), oleDbParameterArray2);
}
}
}
}
this.RehabChannelViews(oleDbConnection, trans, model, model1.name);
new navigation(this.databaseprefix).Update(oleDbConnection, trans, "channel_" + model1.name, siteNavId, "channel_" + model.name, model.title, model.sort_id);
new navigation(this.databaseprefix).Update(oleDbConnection, trans, "channel_" + model1.name + "_list", "channel_" + model.name + "_list");
new navigation(this.databaseprefix).Update(oleDbConnection, trans, "channel_" + model1.name + "_category", "channel_" + model.name + "_category");
new navigation(this.databaseprefix).Update(oleDbConnection, trans, "channel_" + model1.name + "_comment", "channel_" + model.name + "_comment");
trans.Commit();
}
catch
{
trans.Rollback();
return(false);
}
}
}
return(true);
}
private bool DoEdit(int _id)
{
Rain.BLL.channel channel = new Rain.BLL.channel();
Rain.Model.channel model1 = channel.GetModel(_id);
string name = model1.name;
model1.site_id = Utils.StrToInt(this.ddlSiteId.SelectedValue, 0);
model1.name = this.txtName.Text.Trim();
model1.title = this.txtTitle.Text.Trim();
model1.is_albums = 0;
model1.is_attach = 0;
model1.is_spec = 0;
if (this.cbIsAlbums.Checked)
{
model1.is_albums = 1;
}
if (this.cbIsAttach.Checked)
{
model1.is_attach = 1;
}
if (this.cbIsSpec.Checked)
{
model1.is_spec = 1;
}
model1.sort_id = Utils.StrToInt(this.txtSortId.Text.Trim(), 99);
List <channel_field> channelFieldList = new List <channel_field>();
for (int index = 0; index < this.cblAttributeField.Items.Count; ++index)
{
if (this.cblAttributeField.Items[index].Selected)
{
string[] strArray = this.cblAttributeField.Items[index].Value.Split(',');
channelFieldList.Add(new channel_field()
{
channel_id = model1.id,
field_id = Utils.StrToInt(strArray[1], 0)
});
}
}
model1.channel_fields = channelFieldList;
if (!channel.Update(model1))
{
return(false);
}
Rain.BLL.url_rewrite urlRewrite = new Rain.BLL.url_rewrite();
urlRewrite.Remove("channel", name);
string[] values1 = this.Request.Form.GetValues("item_type");
string[] values2 = this.Request.Form.GetValues("item_name");
string[] values3 = this.Request.Form.GetValues("item_page");
string[] values4 = this.Request.Form.GetValues("item_templet");
string[] values5 = this.Request.Form.GetValues("item_pagesize");
string[] values6 = this.Request.Form.GetValues("item_rewrite");
if (values1 != null && values2 != null && (values3 != null && values4 != null) && values5 != null && values6 != null && (values1.Length == values2.Length && values2.Length == values3.Length && (values3.Length == values4.Length && values4.Length == values5.Length) && values5.Length == values6.Length))
{
for (int index = 0; index < values1.Length; ++index)
{
Rain.Model.url_rewrite model2 = new Rain.Model.url_rewrite()
{
name = values2[index].Trim(),
type = values1[index].Trim(),
page = values3[index].Trim()
};
model2.inherit = this.GetInherit(model2.type);
model2.templet = values4[index].Trim();
if (Utils.StrToInt(values5[index].Trim(), 0) > 0)
{
model2.pagesize = values5[index].Trim();
}
model2.channel = model1.name;
List <url_rewrite_item> urlRewriteItemList = new List <url_rewrite_item>();
string str1 = values6[index];
char[] chArray1 = new char[1] {
'&'
};
foreach (string str2 in str1.Split(chArray1))
{
char[] chArray2 = new char[1] {
','
};
string[] strArray = str2.Split(chArray2);
if (strArray.Length == 3)
{
urlRewriteItemList.Add(new url_rewrite_item()
{
path = strArray[0],
pattern = strArray[1],
querystring = strArray[2]
});
}
}
model2.url_rewrite_items = urlRewriteItemList;
urlRewrite.Add(model2);
}
}
this.AddAdminLog(DTEnums.ActionEnum.Edit.ToString(), "修改频道" + model1.title);
return(true);
}
