// 修改文章函数 private void MyInitForUpdate() { using (SqlConnection conn = new DB().GetConnection()) { SqlCommand cmd = conn.CreateCommand(); cmd.CommandText = "select * from Cats order by Orders desc"; conn.Open(); SqlDataReader rd = cmd.ExecuteReader(); Cats.DataSource = rd; Cats.DataValueField = "ID"; Cats.DataTextField = "CatName"; Cats.DataBind(); rd.Close(); cmd.CommandText = "select * from UserTags order by ID asc"; rd = cmd.ExecuteReader(); UserTag.DataSource = rd; UserTag.DataTextField = "TagName"; UserTag.DataValueField = "ID"; UserTag.DataBind(); rd.Close(); int RoleID = Convert.ToInt16(Session["RoleID"].ToString()); if (RoleID > 2) { cmd.Parameters.AddWithValue("@Status", 0); //状态:新投稿/待审核=0,审核已过=1,审核未过=2 } else { cmd.Parameters.AddWithValue("@Status", 1); //状态:新投稿/待审核=0,审核已过=1,审核未过=2 } cmd.CommandText = "select max(Orders) as orders from Articles"; rd = cmd.ExecuteReader(); if (rd.Read()) { MaxOrders.Text = rd[0].ToString(); } rd.Close(); string SubID = ""; cmd.CommandText = "select * from Articles where ID =" + IDLabel.Text; rd = cmd.ExecuteReader(); if (rd.Read()) { TitleTB.Text = rd["Title"].ToString(); Summary.Text = rd["Summary"].ToString(); string UserTagID = rd["TagID"].ToString(); if (UserTag.Items.FindByValue(UserTagID) != null) { UserTag.ClearSelection(); UserTag.Items.FindByValue(UserTagID).Selected = true; } string CatID = rd["CatID"].ToString(); if (Cats.Items.FindByValue(CatID) != null) { Cats.ClearSelection(); Cats.Items.FindByValue(CatID).Selected = true; } SubID = rd["SubID"].ToString(); CDT_TextBox.Text = String.Format("{0:yyyy-MM-dd}", rd["CDT"]); Orders.Text = rd["Orders"].ToString(); Editor1.Text = rd["Content"].ToString(); CoverPhoto.ImageUrl = rd["CoverImageURL"].ToString(); RandomID.Text = rd["RandomID"].ToString(); RandomIDCD = RandomID.Text; int PC1 = Convert.ToInt32(rd["PC"]); if (PC1 == 1) { PC.Checked = true; } int Phone1 = Convert.ToInt32(rd["Phone"]); if (Phone1 == 1) { Phone.Checked = true; } int Wechat1 = Convert.ToInt32(rd["Wechat"]); if (Wechat1 == 1) { Wechat.Checked = true; } int iPad1 = Convert.ToInt32(rd["iPad"]); if (iPad1 == 1) { iPad.Checked = true; } int APP1 = Convert.ToInt32(rd["APP"]); if (APP1 == 1) { APP.Checked = true; } int TV1 = Convert.ToInt32(rd["TV"]); if (TV1 == 1) { TV.Checked = true; } } rd.Close(); cmd.CommandText = "select * from Subs where CatID = " + Cats.SelectedValue + " order by Orders desc"; rd = cmd.ExecuteReader(); Subs.DataSource = rd; Subs.DataTextField = "SubName"; Subs.DataValueField = "ID"; Subs.DataBind(); rd.Close(); if (Subs.Items.Count > 0) { Subs.Visible = true; if (Subs.Items.FindByValue(SubID) != null) { Subs.ClearSelection(); Subs.Items.FindByValue(SubID).Selected = true; } } else { Subs.Visible = false; } } }