📄 admin_articledit.aspx.cs
字号:
using System;using System.Collections;using System.ComponentModel;using System.Data;using System.Drawing;using System.Web;using System.Web.SessionState;using System.Web.UI;using System.Web.UI.WebControls;using System.Web.UI.HtmlControls;using System.Data.OleDb;namespace Lb_news{ /// <summary> /// admin_articledit 的摘要说明。 /// </summary> public class admin_articledit : System.Web.UI.Page { protected System.Web.UI.HtmlControls.HtmlInputButton Submit1; protected System.Web.UI.HtmlControls.HtmlInputHidden LbNewsContent; protected System.Web.UI.WebControls.TextBox Lb_Title; protected System.Web.UI.WebControls.DropDownList ddl_class; protected System.Web.UI.WebControls.CheckBox Is_Commend; protected System.Web.UI.WebControls.CheckBox Is_Index; protected System.Web.UI.WebControls.TextBox Lb_Author; protected int Lb_IsIndex; protected int Lb_IsCommend; protected int Lb_Classid; protected int Lb_IsPic; protected System.Web.UI.HtmlControls.HtmlInputHidden Lb_TitlePic; protected System.Web.UI.WebControls.CheckBox Is_Pic; protected string Content; protected string Publisher; protected System.Web.UI.WebControls.TextBox LbNews_Intro; protected System.Web.UI.WebControls.TextBox lbContent; protected Conn ds1=new Conn(); protected OleDbDataReader rd; protected DataSet ds; private void Page_Load(object sender, System.EventArgs e) { ds1.CheckCookies(2); // 在此处放置用户代码以初始化页面postform Submit1.Attributes.Add("OnClick", "document.postform.LbNewsContent.value = content1.document.body.innerHTML;return check_empty(this.form)"); if(!Page.IsPostBack) { LbNews_Default(); } } private void LbNews_Default() { try { ds1.DBopen(); int nid=ds1.ChangeToInt(Request["nid"].ToString()); rd=ds1.ExecuteOleDbDataReader("select * from Lb_News where n_id="+nid+""); if (rd.HasRows) { rd.Read(); Lb_Title.Text=rd["n_title"].ToString(); lbContent.Text=rd["n_content"].ToString(); int IsIndex=(int)rd["n_index"]; if (IsIndex==1) { Is_Index.Checked=true; } int IsCommend=(int)rd["n_commend"]; if(IsCommend==1) { Is_Commend.Checked=true; } int IsPic=(int)rd["n_ispic"]; if(IsPic==1) { Is_Pic.Checked=true; } Lb_Author.Text=rd["n_author"].ToString(); Lb_TitlePic.Value=rd["n_spic"].ToString(); string cid=rd["n_cid"].ToString(); LbNews_Intro.Text=rd["n_intro"].ToString().Replace("<br>","\r\n"); rd.Close(); ds=ds1.CreateDataSet("select * from Lb_Class","Lb_class"); ddl_class.DataSource=ds; ddl_class.DataTextField="C_Name"; ddl_class.DataValueField="C_Id"; ddl_class.DataBind(); ddl_class.Items.FindByValue(cid).Selected= true; } else { Response.Write ("暂时没有记录"); } } catch(System.Data.OleDb.OleDbException ex) { Response.Write (ex.ToString()); } finally { ds1.DBclose(); } } #region Web 窗体设计器生成的代码 override protected void OnInit(EventArgs e) { // // CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。 // InitializeComponent(); base.OnInit(e); } /// <summary> /// 设计器支持所需的方法 - 不要使用代码编辑器修改 /// 此方法的内容。 /// </summary> private void InitializeComponent() { this.ddl_class.SelectedIndexChanged += new System.EventHandler(this.ddl_class_SelectedIndexChanged); this.Submit1.ServerClick += new System.EventHandler(this.Submit1_ServerClick); this.Load += new System.EventHandler(this.Page_Load); } #endregion private void Submit1_ServerClick(object sender, System.EventArgs e) { if(Is_Commend.Checked) { Lb_IsCommend=1; } else { Lb_IsCommend=0; } if(Is_Index.Checked) { Lb_IsIndex=1; } else { Lb_IsIndex=0; } if(Is_Pic.Checked) { Lb_IsPic=1; } else { Lb_IsPic=0; } int NewType=ds1.ChangeToInt(Request["type"].ToString()); int newid=ds1.ChangeToInt(Request["nid"].ToString()); int nid=ds1.ChangeToInt(ddl_class.SelectedItem.Value.ToString()); string title=Lb_Title.Text.ToString(); string Content=LbNewsContent.Value.ToString().Replace("'"," "); string Author=Lb_Author.Text.ToString(); string TitlePic=Lb_TitlePic.Value.ToString(); string Intro=LbNews_Intro.Text.ToString().Replace("\r\n","<br>").Replace("'"," "); try { ds1.DBopen(); int result=ds1.ExecuteSql("update Lb_News set n_cid="+nid+",n_commend="+Lb_IsCommend+",n_index="+Lb_IsIndex+",n_ispic="+Lb_IsPic+",n_title='"+title+"',n_spic='"+TitlePic+"',n_author='"+Author+"',n_content='"+Content+"',n_intro='"+Intro+"' where n_id="+newid+""); if (result>0) { if (NewType==1) { ds1.alert("修改成功","admin_article.aspx"); } else { ds1.alert("修改成功","admin_checknews.aspx"); } } else { Response.Write ("修改失败"); } } catch(System.Data.OleDb.OleDbException ex) { Response.Write (ex.ToString()); } finally { ds1.DBclose(); } } private void ddl_class_SelectedIndexChanged(object sender, System.EventArgs e) { Lb_Classid=ds1.ChangeToInt(ddl_class.SelectedItem.Value.ToString()); } }}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -