admin_articleadd.aspx.cs

如果遇到MD5加密文件(一般都是这个)

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;
//该源码下载自www.51aspx.com(５１ａｓｐｘ．ｃｏｍ)

namespace Lb_news
{
	/// <summary>
	/// admin_articleadd 的摘要说明。
	/// </summary>
	public class admin_articleadd : System.Web.UI.Page
	{
		protected System.Web.UI.HtmlControls.HtmlInputButton Submit1;
		protected System.Web.UI.HtmlControls.HtmlInputHidden LbNewsContent;
		protected System.Web.UI.HtmlControls.HtmlInputText 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.HtmlControls.HtmlInputText Lb_Author;
		protected int Lb_IsIndex=0;
		protected int Lb_IsCommend=0;
		protected int Lb_Classid;
		protected int Lb_IsPic=0;
		protected System.Web.UI.WebControls.CheckBox Is_Pic;
		protected string Lb_Grade;
		protected string Publisher;
		protected System.Web.UI.HtmlControls.HtmlInputHidden LbNewsPublisher;
		protected System.Web.UI.WebControls.TextBox LbNews_Intro;

		protected Conn ds1=new Conn();

		protected  OleDbDataReader rd;
		protected System.Web.UI.HtmlControls.HtmlInputHidden Lb_TitlePic;
		protected System.Web.UI.WebControls.Label News_Error;
		protected  DataSet ds;

		private void Page_Load(object sender, System.EventArgs e)
		{

			ds1.CheckCookies(1);

			// 在此处放置用户代码以初始化页面postform
			Submit1.Attributes.Add("OnClick", "document.postform.LbNewsContent.value = content1.document.body.innerHTML;return check_empty(this.form)");
			
			HttpCookie cookie=Request.Cookies["UserInfo"];
                    

			Publisher=cookie.Values["username"].ToString();

			Lb_Grade=cookie.Values["grade"].ToString();



			if(!Page.IsPostBack)
			{
			
					
				
				classDate();

			}	

		
		}

		private void classDate()
		{
			ds1.DBopen();
		
			ds=ds1.CreateDataSet("select * from Lb_Class","Lb_class");



			if (ds.Tables["Lb_class"].DefaultView.Count==0)
			{
				
				News_Error.Text="目前没有类别,请先添加一级分类";
			}
			else
			{
				
				ddl_class.DataSource=ds;
				ddl_class.DataTextField="C_Name";
				ddl_class.DataValueField="C_Id";
				ddl_class.DataBind();
			}

			

			ListItem ClassDefault=new ListItem("请选择类别","def");  //增加一个空白项，并使之位于首位。	
			ddl_class.Items.Insert(0,ClassDefault);
			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.Is_Commend.CheckedChanged += new System.EventHandler(this.Is_Commend_CheckedChanged);
			this.Is_Index.CheckedChanged += new System.EventHandler(this.Is_Index_CheckedChanged);
			this.Is_Pic.CheckedChanged += new System.EventHandler(this.Is_Pic_CheckedChanged);
			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)
		{
			ds1.DBopen();
			string title=Lb_Title.Value.ToString();
			string Content=LbNewsContent.Value.ToString().Replace("'","　");		
			string Author=Lb_Author.Value.ToString();
			string TitlePic=Lb_TitlePic.Value.ToString();
			string Intro=LbNews_Intro.Text.ToString().Replace("\r\n","<br>").Replace("'","　");
			int lb_check;
           
			Lb_Classid=ds1.ChangeToInt(ddl_class.SelectedItem.Value.ToString());
			try
			{
				if (Lb_Grade=="1")
				{
					lb_check=0;
				}
				else
				{
					lb_check=1;
				}

				int result=ds1.ExecuteSql("insert into Lb_News([n_cid],[n_commend],[n_index],[n_ispic],[n_title],[n_spic],[n_author],[n_content],[n_publisher],[n_intro],[n_check])values("+Lb_Classid+","+Lb_IsCommend+","+Lb_IsIndex+","+Lb_IsPic+",'"+title+"','"+TitlePic+"','"+Author+"','"+Content+"','"+Publisher+"','"+Intro+"',"+lb_check+")");	
				if (result>0)
				{

					if (Lb_Grade=="1")
					{
						ds1.alert("添加成功,需等待管理员审核","admin_articleadd.aspx");
				
					}
					else
					{
						ds1.alert("添加成功","admin_articleadd.aspx");
					}
				
				}
				else
				{
				
					Response.Write ("增加失败");
				}
			
			}
			catch(System.Data.OleDb.OleDbException ex)
			{
				Response.Write (ex.ToString());

			}
			finally
			{
				ds1.DBclose();
			}		
		
			
            

		}

		private void Is_Commend_CheckedChanged(object sender, System.EventArgs e)
		{
			if(Is_Commend.Checked)
			{
				Lb_IsCommend=1;
			}
		}

		private void Is_Index_CheckedChanged(object sender, System.EventArgs e)
		{
			if(Is_Index.Checked)
			{
				Lb_IsIndex=1;
			}
		}

		private void ddl_class_SelectedIndexChanged(object sender, System.EventArgs e)
		{
			Lb_Classid=ds1.ChangeToInt(ddl_class.SelectedItem.Value.ToString());
		
		}

		private void Is_Pic_CheckedChanged(object sender, System.EventArgs e)
		{
			if(Is_Pic.Checked)
			{
				Lb_IsPic=1;
			

			}
		
		}

	

	


	
	}
}