jyskxg.aspx.cs

图书馆里系统实现 jsp servlet bian

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.SqlClient;
namespace 图书管理.Tsczgl
{
	/// <summary>
	/// Jyskxg 的摘要说明。
	/// </summary>
	public class Jyskxg : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.Button Button6;
		protected System.Web.UI.WebControls.Button Button1;
		protected System.Web.UI.WebControls.Calendar Calendar1;
		protected System.Web.UI.WebControls.Calendar Calendar2;
		protected System.Web.UI.WebControls.Button Button3;
		protected System.Web.UI.WebControls.TextBox TextBox6;
		protected System.Web.UI.WebControls.Button Button4;
		protected System.Web.UI.WebControls.TextBox TextBox10;
		protected System.Web.UI.WebControls.Label Label15;
		protected System.Web.UI.WebControls.DropDownList DropDownList2;
		protected System.Web.UI.WebControls.Label Label13;
		protected System.Web.UI.WebControls.Label Label19;
		protected System.Web.UI.WebControls.TextBox TextBox2;
		protected System.Web.UI.WebControls.Label Label12;
		protected System.Web.UI.WebControls.TextBox TextBox4;
		protected System.Web.UI.WebControls.Label Label11;
		protected System.Web.UI.WebControls.Label Label9;
		protected System.Web.UI.WebControls.TextBox TextBox3;
		protected System.Web.UI.WebControls.Label Label8;
		protected System.Web.UI.WebControls.TextBox TextBox1;
		protected System.Web.UI.WebControls.Label Label7;
		protected System.Web.UI.WebControls.Label Label2;
		protected System.Web.UI.WebControls.Label Label1;
		protected System.Web.UI.WebControls.TextBox TextBox5;
		protected System.Web.UI.WebControls.Button Button2;
		protected System.Web.UI.WebControls.Calendar Calendar3;
		protected System.Web.UI.WebControls.Label Label6;
	    static int OP;
		protected System.Web.UI.WebControls.CheckBox CheckBox1;
		protected System.Web.UI.WebControls.CheckBox CheckBox2;
		protected System.Web.UI.WebControls.CheckBox CheckBox3;
		protected System.Web.UI.WebControls.CheckBox CheckBox4;
		protected System.Web.UI.WebControls.CheckBox CheckBox5;
		protected System.Web.UI.WebControls.CheckBox CheckBox6;
		protected System.Web.UI.WebControls.CheckBox CheckBox7;
		static int id;
		private void Page_Load(object sender, System.EventArgs e)
		{
			// 在此处放置用户代码以初始化页面
			Calendar1.Visible=false;
			Calendar2.Visible=false;
			Calendar3.Visible=false;
			if(!Page.IsPostBack)
			{
			
		    OP=int.Parse(Request.QueryString["op"]);
				if (OP!=1)
				{
					Button1.Text="添加";
				    TextBox1.Enabled=false;
					data.message  my_message = new 图书管理.data.message();
					TextBox1.Text=my_message.CreatID();
				}
				else
				{
					Button1.Text="修改";
					data.message  my_select=new 图书管理.data.message();
					id=int.Parse(Request.QueryString["ygid"]);
					SqlDataReader dr2=my_select.Select(id); 
					if (dr2.Read())
					{
						TextBox1.Enabled=false;
						TextBox3.Enabled=false;
						TextBox1.Text=dr2[1].ToString();    
						TextBox3.Text=dr2[2].ToString();　　　 
						DropDownList2.SelectedValue=dr2[3].ToString();;　　
						TextBox2.Text=dr2[4].ToString();     
						TextBox4.Text=dr2[5].ToString();　　 
						TextBox10.Text=dr2[6].ToString();     
						TextBox6.Text=dr2[7].ToString();     
						TextBox5.Text=dr2[8].ToString();    
					}
				}
			}
		}

		#region Web 窗体设计器生成的代码
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{    
			this.Calendar3.SelectionChanged += new System.EventHandler(this.Calendar3_SelectionChanged);
			this.Button4.Click += new System.EventHandler(this.Button4_Click);
			this.Button3.Click += new System.EventHandler(this.Button3_Click);
			this.Calendar2.SelectionChanged += new System.EventHandler(this.Calendar2_SelectionChanged);
			this.Calendar1.SelectionChanged += new System.EventHandler(this.Calendar1_SelectionChanged);
			this.Button1.Click += new System.EventHandler(this.Button1_Click);
			this.Button6.Click += new System.EventHandler(this.Button6_Click);
			this.Button2.Click += new System.EventHandler(this.Button2_Click);
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion

		private void Button4_Click(object sender, System.EventArgs e)
		{
		     Calendar1.Visible= true;
		}

		private void Button3_Click(object sender, System.EventArgs e)
		{
		     Calendar2.Visible= true;
		}

		private void Button2_Click(object sender, System.EventArgs e)
		{
		     Calendar3.Visible= true;
		}

		private void Calendar1_SelectionChanged(object sender, System.EventArgs e)
		{
		     TextBox10.Text = Calendar1.SelectedDate.Date.ToShortDateString();
		}

		private void Calendar2_SelectionChanged(object sender, System.EventArgs e)
		{
		     TextBox6.Text = Calendar2.SelectedDate.Date.ToShortDateString();
		}

		private void Calendar3_SelectionChanged(object sender, System.EventArgs e)
		{
		     TextBox5.Text = Calendar3.SelectedDate.Date.ToShortDateString();
		}

		private void Button6_Click(object sender, System.EventArgs e)
		{
		     Response.Redirect("Jysk.aspx");
		}

		private void Button1_Click(object sender, System.EventArgs e)
		{
			if (OP!=1)
			{
				INS();
			}
			else
			{
				UPD();
			}
		}
		private void INS()
		{
			string jszh=TextBox1.Text;     //借书证号
			string xm=TextBox3.Text;　　　 //姓名
			string skzl=DropDownList2.SelectedValue;　　 //书刊种类
			string skmc=TextBox2.Text;     //书刊名称
			string skbh=TextBox4.Text;　　 //书刊编号
			string jyrq=TextBox10.Text;     //借阅日期
			string yhrq=TextBox6.Text;     //应还日期
			string fhrq=TextBox5.Text;     //返还日期
			///string qx=yjt();
			data.Student  stu = new 图书管理.data.Student();
			stu.Jszh=jszh;
		    stu.Xm=xm;
		    stu.Skzl=skzl;
		    stu.Skmc=skmc;
		    stu.Skbh=skbh;
			stu.Jyrq=jyrq;
			stu.Yhrq=yhrq;
			stu.Fhrq=fhrq;
		    //stu.qx1;
			data.message  my_message = new 图书管理.data.message();
			my_message.Stu_Add(stu);
		    Response.Write("<script>alert('添加成功 ！！！');</script>");
		    qq();
			TextBox1.Text=my_message.CreatID();
		}
		private void UPD()
		{
			string jszh=TextBox1.Text;     //借书证号
			string xm=TextBox3.Text;　　　 //姓名
			string skzl1=DropDownList2.SelectedValue;　　 //书刊种类
			string skmc=TextBox2.Text;     //书刊名称
			string skbh=TextBox4.Text;　　 //书刊编号
			string jyrq=TextBox10.Text;     //借阅日期
			string yhrq=TextBox6.Text;     //应还日期
			string fhrq=TextBox5.Text;     //返还日期
			data.Student  stu = new 图书管理.data.Student();
			stu.Id=id;
			stu.Jszh=jszh;
			stu.Xm=xm;
			stu.Skzl=skzl1;
			stu.Skmc=skmc;
			stu.Skbh=skbh;
			stu.Jyrq=jyrq;
			stu.Yhrq=yhrq;
			stu.Fhrq=fhrq;
			data.message  my_message = new 图书管理.data.message();
			my_message.Stu_Upd(stu);
		   Response.Write("<script>alert('修改成功 ！！！');</script>");
		   qq();
		}
		//public string yjt()
		//{
			
			//string text="";
			//for(int i=1;i<=7;i++)
			//{
				//string a;
				//string id="CheckBox"+i.ToString();
				//CheckBox cb=(CheckBox)Page.FindControl(id); 
				//if(cb.Checked)
				//{
					//a="1";
					//text+=a;
				//}
				//else
				//{
					//a="0";
					//text+=a;
				//}
			   // return text;
			//}
			//Label1.Text=text;
		//}
		public void qq()
		{
			TextBox1.Text="";    
			TextBox3.Text="";　　　 
			TextBox2.Text="";     
			TextBox4.Text="";　　 
			TextBox10.Text="";     
			TextBox6.Text="";     
			TextBox5.Text="";
		}
	
	}
}