renew.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.SqlClient;

namespace Library_BS
{
	/// <summary>
	/// Renew 的摘要说明。
	/// </summary>
	public class Renew : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.Label lblReaderName;
		protected System.Web.UI.WebControls.Label Label3;
		protected System.Web.UI.WebControls.Label lblBarCode;
		protected System.Web.UI.WebControls.DataList DataList1;
		protected System.Web.UI.WebControls.DataList DataList2;
		protected System.Web.UI.WebControls.Label lblRegisterName;
		protected System.Web.UI.WebControls.Label BarCode;
		protected System.Web.UI.WebControls.TextBox TextBox1;
		protected System.Web.UI.WebControls.Button btnRenew;
		protected System.Web.UI.WebControls.Label Label1;
	
		private void Page_Load(object sender, System.EventArgs e)
		{
			this.lblRegisterName.Text=Request["RegistName"];
			this.BarCode.Text=Request["barcode"];
			string connStr="server=\'(local)\'; trusted_connection=true; database=\'Library\'";
			SqlConnection myConnection=new SqlConnection(connStr);
			myConnection.Open();
			//Response.Write("shujuku lianjiechenggong!!");
			string queryStr1="select BookName,CirculateType,IndexID,BookID,Status,FinalBorrowTime,ShouldReturntime,RenewTimes from BookDuplication where UserBarCode='"+this.BarCode.Text+"'and Status='"+"借出"+"'";
			SqlDataAdapter myDadaAdapter1=new SqlDataAdapter(queryStr1,myConnection);

			DataSet myDataSet1=new DataSet();
			
			myDadaAdapter1.Fill(myDataSet1,"Student");
			DataList2.DataSource=myDataSet1.Tables["Student"].DefaultView;
			DataList2.DataBind();
			// 在此处放置用户代码以初始化页面
		}

		#region Web 窗体设计器生成的代码
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{    
			this.btnRenew.Click += new System.EventHandler(this.btnRenew_Click);
			this.DataList2.SelectedIndexChanged += new System.EventHandler(this.DataList2_SelectedIndexChanged);
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion

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

		private void btnRenew_Click(object sender, System.EventArgs e)
		{
			double a;
			Borrow borrow=new Borrow();
			System.Data.IDataReader Fine=borrow.GetFineInfo(this.BarCode.Text);
			Fine.Read();
			a=double.Parse(Fine["FineMoney"].ToString());
			System.Data.IDataReader Renew=borrow.GetRenewTimes(int.Parse(this.TextBox1.Text));
			Renew.Read();
			int b=int.Parse(Renew["RenewTimes"].ToString());
			if((a>1)||(borrow.GetReturn()!=0)||(b==1))
			{
			
				if(a>1.0)
				{
					Response.Redirect("RenewTip.aspx?message="+"续借失败，你的罚款超过一元"+"&regstname="+this.lblRegisterName.Text+"&barcode="+this.BarCode.Text);
				}
				if(borrow.GetReturn()!=0) 
				{
					Response.Redirect("RenewTip.aspx?message="+"续借失败，你有过期的图书未归还"+"&regstname="+this.lblRegisterName.Text+"&barcode="+this.BarCode.Text);
				}
				if(b==1)
					Response.Redirect("RenewTip.aspx?message="+"续借失败，该图书你已经续借过一次了,不能再续借了"+"&regstname="+this.lblRegisterName.Text+"&barcode="+this.BarCode.Text);
			}
			else
			{
				System.DateTime day=System.DateTime.Now.AddDays(10);
				int RowsAffected=borrow.MyUpdatexjtufb(int.Parse(this.TextBox1.Text),this.BarCode.Text,day,1);
				if(RowsAffected==1)
					Response.Redirect("RenewTip.aspx?message="+"续借成功！"+"&regstname="+this.lblRegisterName.Text+"&barcode="+this.BarCode.Text);
				else 
					Response.Redirect("RenewTip.aspx?message="+"续借失败！"+"&regstname="+this.lblRegisterName.Text+"&barcode="+this.BarCode.Text);
			}
				
			

		}
	}
}