//更新列表
public void Flush()
{
CMS_Column bCol = new CMS_Column();
GVinfo.DataSource = bCol.GetList("");
GVinfo.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
DoAdminSetting(302);
if (!IsPostBack)
{
CMS_Column bCol = new CMS_Column();
if (Action == "move")
{
bCol.MoveList(CurrentId, IsUp); // 判断页面上是否有上/下移请求
}
Flush();
}
}
/// <summary>
/// 加载栏目权限和系统权限
/// </summary>
protected void LoadSetting()
{
CMS_AdminRole bar = new CMS_AdminRole();
CMS_Column bcol = new CMS_Column();
Model.CMS_AdminRole role = CurrentId > 0 ? bar.GetModel(CurrentId) : new Model.CMS_AdminRole();
hfSetting.Value = role.AdminSetting + "," + role.Setting; //收藏哪些勾选
// 加载系统权限
List <LeftMenu> menus = LeftMenu.Load();
StringBuilder sb = new StringBuilder();
sb.Append("<table border=\"0\" cellspacing=\"0\" cellpadding=\"5\" class=\"setTable\"> ");
foreach (LeftMenu menu in menus)
{
sb.AppendFormat("<tr><td class=\"forumRowHighlight\">{0}</td></tr>", menu.Title);
sb.Append("<tr><td class=\"listRow\">");
foreach (MenuLink link in menu.Links)
{
sb.AppendFormat("<span><input type=\"checkbox\" name=\"admin_setting\" value=\"{0}\" id=\"{1}\">{2}</span> ", link.Code, link.Code, link.Title);
}
sb.Append("</td></tr>");
}
sb.Append("</table>");
ltAdminSetting.Text = sb.ToString();
// 加载栏目权限
DataTable dt = bcol.GetList("").Tables[0];
sb = new StringBuilder();
sb.Append("<table border=\"0\" cellspacing=\"0\" cellpadding=\"5\" class=\"setTable\"> ");
sb.Append("<tr class='listRow'><td style='width:100px'><input type=\"checkbox\" name=\"setting\" value=\"deleteBatch\">批量删除文章</td>");
sb.Append("<td style='width:100px'><input type=\"checkbox\" name=\"setting\" value=\"moveBatch\">批量移动文章</td>");
sb.Append("<td style='width:100px'><input type=\"checkbox\" name=\"setting\" value=\"addBatch\">批量加入专题</td>");
sb.Append("</tr></table>");
sb.Append("<table border=\"0\" cellspacing=\"0\" cellpadding=\"5\" class=\"setTable\"> ");
foreach (DataRow dr in dt.Rows)
{
sb.AppendFormat("<tr class='listRow'><td>{0}</td>", GetColumnName(dr["Title"].ToString(), dr["Code"].ToString()));
sb.AppendFormat("<td style='width:220px'><input type=\"checkbox\" name=\"setting\" value=\"{0}_0\">编辑文章", dr["Id"]);
sb.AppendFormat("<input type=\"checkbox\" name=\"setting\" value=\"{0}_1\">删除文章", dr["Id"]);
sb.AppendFormat("<input type=\"checkbox\" name=\"setting\" value=\"{0}_2\">新增文章", dr["Id"]);
sb.Append("</td></tr>");
}
sb.Append("</table>");
ltSetting.Text = sb.ToString();
tbTitle.Text = role.Name;
}
/// <summary>
/// 更新文本框
/// </summary>
protected void Flush()
{
CMS_Column bCol = new CMS_Column();
Model.CMS_Column col = new Model.CMS_Column();
DataTable dt;
if (CurrentId > 0)
{
col = bCol.GetModel(CurrentId);
tbTitle.Text = col.Title;
if (col.GotoUrl != "")
{
cbLink.Checked = true;
Panel1.Visible = true;
}
cbIsNavi.Checked = col.IsNavigator == 1 ? true : false;
if (col.GotoUrl != "" && col.GotoUrl != null)
{
ClientScript.RegisterStartupScript(this.GetType(), "jsGotoUrl", "<script>$(\"#ckIsLink\").trigger(\"click\");$(\"#trLink\").css(\"display\",\"block\");</script>");
tbLink.Text = col.GotoUrl;
}
//只列出满足以下条件的栏目作为父栏目：不能是自己的下级栏目，不能是跳转到某网站的栏目，不能是已包含文章的栏目
dt = bCol.GetList("Code not like '" +
col.Code + "%' and (Len(GotoUrl)=0 or GotoUrl is NULL) " +
"and Id not in (select distinct ColumnId from CMS_Article)").Tables[0];
}
else
{
//只列出满足以下条件的栏目作为父栏目：不能是跳转到某网站的栏目，不能是已包含文章的栏目
dt = bCol.GetList("(Len(GotoUrl)=0 or " +
"GotoUrl is NULL) and Id not in " +
"(select distinct ColumnId from CMS_Article)").Tables[0];
}
ddlParentId.Items.Add(new ListItem("作为一级", "0"));
foreach (DataRow dr in dt.Rows)
{
ListItem li = new ListItem();
li.Text = GetColumnName(dr["Title"].ToString(), dr["Code"].ToString());
li.Value = dr["Id"].ToString();
if (col.ParentId.ToString() == li.Value)
{
li.Selected = true;
}
ddlParentId.Items.Add(li);
}
}
int Id; // 用来获取欲删除的Id
protected void GVinfo_RowCommand(object sender, GridViewCommandEventArgs e)
{
int theRow = 0; //保存行号
string theCol = ""; //保存列位置信息
theRow = ((GridViewRow)((LinkButton)e.CommandSource).NamingContainer).RowIndex;
theCol = e.CommandName.ToString();
Id = Convert.ToInt32(GVinfo.DataKeys[theRow].Value);
CMS_Column bCol = new CMS_Column();
if (!bCol.Delete(Id))
{
Alert("含有子栏目或文章，不允许删除！");
}
Flush();
}
protected void btSave_Click(object sender, EventArgs e)
{
CMS_Column bCol = new CMS_Column();
Model.CMS_Column col = new Model.CMS_Column();
if (CurrentId > 0)
{
col = bCol.GetModel(CurrentId);
}
col.Title = tbTitle.Text;
col.IsNavigator = cbIsNavi.Checked ? 1 : 0;
if (cbLink.Checked)
{
col.GotoUrl = tbLink.Text;
}
else
{
col.GotoUrl = "";
}
int newParentId = int.Parse(ddlParentId.SelectedValue);
if (CurrentId > 0)
{
int oldParentId = col.ParentId;
bool isChange = newParentId == col.ParentId ? false : true;
col.ParentId = newParentId;
bCol.Update(col, isChange, oldParentId);
//Do something
}
else
{
col.ParentId = newParentId;
int newId = bCol.Add(col);
//Do something
}
Response.Redirect("Column.aspx");
}
protected void ShowEditor()
{
CMS_Article bArt = new CMS_Article();
CMS_Column bCol = new CMS_Column();
Model.CMS_Article mArt = new Model.CMS_Article();
if (CurrentId > 0)//如果是编辑
{
mArt = bArt.GetModel(CurrentId);
if (mArt.ColumnId != 0)
{
DoSetting(Convert.ToInt32(mArt.ColumnId), "修改");
}
ddlTitCor.Items.FindByValue(mArt.titleColor).Selected = true;
ddlTitSty.Items.FindByValue(mArt.titleFont.ToString()).Selected = true;
}
//tbAuthor.Text = mArt.Author;
tbAuthor.Text = CurrentAdmin.Name;
if (mArt.IsPic == true)
{
//显示图片
Image1.Visible = true;
Image1.ImageUrl = "~\\userfiles\\" + mArt.PicUrl.Substring(mArt.PicUrl.LastIndexOf("\\") + 1);;
}
//tbPicUrl.Text = mArt.PicUrl;
tbTitle.Text = mArt.Title;
FCKeditor1.Value = mArt.Body;
//构造SQL语句查询出没有子栏目并且不是跳转网址的栏目
string strSql = "select * from CMS_Column as a where (Len(GotoUrl)=0 or GotoUrl is NULL) and not EXISTS(select b.Id from CMS_Column as b where b.ParentId=a.Id) order by code";
DataTable dt = bCol.CustomGetList(strSql);
//光往栏目下拉列表中加入"无"项
ListItem theLi = new ListItem("无", "0");
ddlCol.Items.Add(theLi);
//通过循环将数据库中满足条件的栏目包装成带缩进的样子加入栏目的下拉列表
foreach (DataRow dr in dt.Rows)
{
ListItem li = new ListItem();
li.Text = GetColumnName(dr["Title"].ToString(), dr["Code"].ToString());
li.Value = dr["Id"].ToString();
//若是编辑则将当前栏目选中
if (li.Value == mArt.ColumnId.ToString())
{
li.Selected = true;
}
ddlCol.Items.Add(li);
}
/*以下是专题的不过没什么用*/
//在视频的第五单元第四课时里
//根据ListItem选项值修改背景颜色 字体粗细
foreach (ListItem lt in ddlTitCor.Items)
{
lt.Attributes.CssStyle.Add(HtmlTextWriterStyle.BackgroundColor, lt.Value);
}
ddlTitSty.Items[0].Attributes.CssStyle.Add(HtmlTextWriterStyle.FontStyle, "bold");
ddlTitSty.Items[1].Attributes.CssStyle.Add(HtmlTextWriterStyle.FontWeight, "bold");
ddlTitSty.Items[2].Attributes.CssStyle.Add(HtmlTextWriterStyle.FontStyle, "italic");
ddlTitSty.Items[3].Attributes.CssStyle.Add(HtmlTextWriterStyle.FontWeight, "bold");
ddlTitSty.Items[3].Attributes.CssStyle.Add(HtmlTextWriterStyle.FontStyle, "italic");
}