m_bookinfo.aspx.cs

自己写的一个网上图书馆 可实现图书上传借阅等功能

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Data.SqlClient;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;

namespace e_librarys
{
	/// <summary>
	/// M_BookInfo 的摘要说明。
	/// </summary>
	public partial class M_BookInfo : System.Web.UI.Page
	{
      
		protected void Page_Load(object sender, System.EventArgs e)
		{
			// 在此处放置用户代码以初始化页面

            //绑定图书信息
			SqlConnection Conn = new SqlConnection("server=(local);database=e_library;uid=sa;pwd=");
			Conn.Open();
			SqlDataAdapter Da = new SqlDataAdapter("select * from Book_Info ",Conn);
			DataSet Ds = new DataSet();
			Da.Fill(Ds);

			DataList_M_BookInfo.DataKeyField="B_ID";
			DataList_M_BookInfo.DataSource = Ds.Tables[0];

			if(!Page.IsPostBack)
			{DataList_M_BookInfo.DataBind();}

			DataList_M_BookInfo.DataBind();
			Conn.Close();
		}

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

		}
		#endregion

		




		//选择
		protected void DataList_M_BookInfo_SelectedIndexChanged(object sender, System.EventArgs e)
		{
          //Session["BookIndex"]=DataList_M_BookInfo.DataKeys[DataList_M_BookInfo.SelectedIndex];
		}

		protected void Button_Select_Click(object sender, System.EventArgs e)
		{
			SqlConnection Conn=new SqlConnection("server=(local);database=e_library;uid=sa;pwd=");
			Conn.Open();
		    string StrSql="select * from User_Info";
          
			//判断选择查询类型
			if(Request.Form["Select"].ToString()!="")
			{
				switch(Request.Form["Select"].ToString())
				{
					case "ID":StrSql="select * from Book_Info where B_ID='"+TextBox.Text.ToString()+"'";break;
					case "Name":StrSql="select * from Book_Info where B_Name like '%"+TextBox.Text.ToString()+"%'";break;
					case "BDSID":StrSql="select * from Book_Info a,Book_Style b,Book_DetailStyle c where  b.B_S_ID=c.B_S_ID and a.B_BDS_ID=c.B_DS_ID and B_S_Name like '%"+TextBox.Text.ToString()+"%'";break;
					case "Director":StrSql="select * from Book_Info where B_Director like '%"+TextBox.Text.ToString()+"%'";break;
					case "Issuer":StrSql="select * from Book_Info where B_Issuer like '%"+TextBox.Text.ToString()+"%'";break;
					case "RentCount":StrSql="select * from Book_Info where B_RentCount='"+TextBox.Text.ToString()+"'";break;
					case "Count":StrSql="select * from Book_Info where B_Count='"+TextBox.Text.ToString()+"'";break;
					case "PublishTime":StrSql="select * from Book_Info where B_PublishTime='"+TextBox.Text.ToString()+"'";break;
					case "PMTID":StrSql="select * from Book_Info,Payment where P_Price='"+TextBox.Text.ToString()+"' and P_ID=B_PMT_ID";break;
					default:Response.Write("<Script Language='JavaScript'>alert('你没有选择类型')</Script>");break;
				}
			}

			SqlDataAdapter Da=new SqlDataAdapter(StrSql,Conn);
			DataSet Ds=new DataSet();
			Da.Fill(Ds);
			DataList_M_BookInfo.DataSource = Ds.Tables[0];
			DataList_M_BookInfo.DataBind();
			Conn.Close();
		}

        //租赁图书信息绑定
		protected void LinkButton_Tenancy_Click(object sender, System.EventArgs e)
		{
			SqlConnection Conn = new SqlConnection("server=(local);database=e_library;uid=sa;pwd=");
			Conn.Open();
			SqlDataAdapter Da = new SqlDataAdapter("select * from Book_Info,Tenancy where T_B_ID=B_ID and T_Status=2 and T_Return=0",Conn);
			DataSet Ds = new DataSet();
			Da.Fill(Ds);			
			DataList_M_BookInfo.DataSource = Ds.Tables[0];
        	DataList_M_BookInfo.DataBind();
			Conn.Close();
		}

        //已经预定图书信息绑定
		protected void Linkbutton_schedule_Click(object sender, System.EventArgs e)
		{
			SqlConnection Conn = new SqlConnection("server=(local);database=e_library;uid=sa;pwd=");
			Conn.Open();
			SqlDataAdapter Da = new SqlDataAdapter("select * from Book_Info,Tenancy where T_B_ID=B_ID and T_Status=1 and T_Return=0",Conn);
			DataSet Ds = new DataSet();
			Da.Fill(Ds);			
			DataList_M_BookInfo.DataSource = Ds.Tables[0];
			DataList_M_BookInfo.DataBind();
			Conn.Close();
		}

        //超期未还
		protected void Linkbutton_TimeOut_Click(object sender, System.EventArgs e)
		{
			SqlConnection Conn = new SqlConnection("server=(local);database=e_library;uid=sa;pwd=");
			Conn.Open();
			SqlDataAdapter Da = new SqlDataAdapter("select * from Book_Info,Tenancy where T_B_ID=B_ID and T_TimeOut!=0 and T_Return=0",Conn);
			DataSet Ds = new DataSet();
			Da.Fill(Ds);			
			DataList_M_BookInfo.DataSource = Ds.Tables[0];
			DataList_M_BookInfo.DataBind();
			Conn.Close();
		}




        //删除
        protected void DataList_M_BookInfo_DeleteCommand(object source, DataListCommandEventArgs e)
        {
            string BookID = DataList_M_BookInfo.DataKeys[e.Item.ItemIndex].ToString();

            string StrSql = "delete from Book_Info where B_ID='" + BookID + "'";
            SqlConnection Conn = new SqlConnection("server=(local);database=e_library;uid=sa;pwd=");
            Conn.Open();
            SqlCommand Comm = new SqlCommand(StrSql, Conn);
            Comm.ExecuteNonQuery();
            Conn.Close();
            Response.Write("<Script Language='JavaScript'>alert('删除成功!')</Script>");
        }

        //取消
        protected void DataList_M_BookInfo_CancelCommand(object source, DataListCommandEventArgs e)
        {
            DataList_M_BookInfo.EditItemIndex = -1;
            DataList_M_BookInfo.DataBind();
        }


        //编辑
        protected void DataList_M_BookInfo_EditCommand1(object source, DataListCommandEventArgs e)
        {
            DataList_M_BookInfo.EditItemIndex = e.Item.ItemIndex;
            DataList_M_BookInfo.DataBind();
        }


        //更新
        protected void DataList_M_BookInfo_UpdateCommand(object source, DataListCommandEventArgs e)
        {
            string BID = DataList_M_BookInfo.DataKeys[e.Item.ItemIndex].ToString();

            string TextName = e.Item.FindControl("BName").ToString();
            string TextDirector = e.Item.FindControl("BDirector").ToString();
            string TextID = e.Item.FindControl("BID").ToString();
            string TextBDSID = e.Item.FindControl("BBDSID").ToString();
            string TextContent = e.Item.FindControl("BContent").ToString();
            string TextIssuer = e.Item.FindControl("BIssuer").ToString();
            string TextRentCount = e.Item.FindControl("BRentCount").ToString();
            string TextCount = e.Item.FindControl("BCount").ToString();
            string TextRankCount = e.Item.FindControl("BRankCount").ToString();
            string TextWordSum = e.Item.FindControl("BWordSum").ToString();
            string TextPageSum = e.Item.FindControl("BPageSum").ToString();
            string TextPublishTime = e.Item.FindControl("BPublishTime").ToString();
            string TextAddTime = e.Item.FindControl("BAddTime").ToString();
            string TextPMTID = e.Item.FindControl("BPMTID").ToString();
            string TextStatus = e.Item.FindControl("BStatus").ToString();

            string StrSql = "update Book_Info set B_Name='" + TextName + "',B_Director='" + TextDirector + "',B_ID='" + TextID + "',B_BDS_ID='" + TextBDSID + "'," +
                                               "B_Content='" + TextContent + "',B_Issuer='" + TextIssuer + "',B_RentCount='" + TextRentCount + "'," +
                                               "B_Count='" + TextCount + "',B_RankCount='" + TextRankCount + "',B_WordSum='" + TextWordSum + "',B_PageSum='" + TextPageSum + "'," +
                                               "B_PublishTime='" + TextPublishTime + "',B_AddTime='" + TextAddTime + "',B_PMT_ID='" + TextPMTID + "',B_Status='" + TextStatus + "' where B_ID='" + BID + "'";

            SqlConnection Conn = new SqlConnection("server=(local);database=e_library;uid=sa;pwd=");
            Conn.Open();
            SqlCommand Comm = new SqlCommand(StrSql, Conn);
            Comm.ExecuteNonQuery();
            Conn.Close();
            Response.Write("<Script Language='JavaScript'>alert('修改成功!!')</Script>");
        }
}
}