frmselectbook.cs

采用C#和SQL Server 2000开发 功能比较全面的图书馆管理系统

			this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@操作员", System.Data.SqlDbType.VarChar, 20, "操作员"));
			this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@简介", System.Data.SqlDbType.VarChar, 100, "简介"));
			this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@借出次数", System.Data.SqlDbType.Int, 4, "借出次数"));
			this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@是否注销", System.Data.SqlDbType.Bit, 1, "是否注销"));
			// 
			// sqlSelectCommand1
			// 
			this.sqlSelectCommand1.CommandText = "SELECT 条形码, 编号, 书名, 类型, 作者, 译者, ISBN, 出版社, 价格, 页码, 书架名称, 现存量, 库存总量, 入库时间, 操作员, 简介" +
				", 借出次数, 是否注销 FROM 图书信息";
			this.sqlSelectCommand1.Connection = this.sqlConnection1;
			// 
			// sqlUpdateCommand1
			// 
			this.sqlUpdateCommand1.CommandText = @"UPDATE 图书信息 SET 条形码 = @条形码, 编号 = @编号, 书名 = @书名, 类型 = @类型, 作者 = @作者, 译者 = @译者, ISBN = @ISBN, 出版社 = @出版社, 价格 = @价格, 页码 = @页码, 书架名称 = @书架名称, 现存量 = @现存量, 库存总量 = @库存总量, 入库时间 = @入库时间, 操作员 = @操作员, 简介 = @简介, 借出次数 = @借出次数, 是否注销 = @是否注销 WHERE (编号 = @Original_编号) AND (ISBN = @Original_ISBN OR @Original_ISBN IS NULL AND ISBN IS NULL) AND (书名 = @Original_书名 OR @Original_书名 IS NULL AND 书名 IS NULL) AND (书架名称 = @Original_书架名称 OR @Original_书架名称 IS NULL AND 书架名称 IS NULL) AND (价格 = @Original_价格 OR @Original_价格 IS NULL AND 价格 IS NULL) AND (作者 = @Original_作者 OR @Original_作者 IS NULL AND 作者 IS NULL) AND (借出次数 = @Original_借出次数 OR @Original_借出次数 IS NULL AND 借出次数 IS NULL) AND (入库时间 = @Original_入库时间 OR @Original_入库时间 IS NULL AND 入库时间 IS NULL) AND (出版社 = @Original_出版社 OR @Original_出版社 IS NULL AND 出版社 IS NULL) AND (库存总量 = @Original_库存总量 OR @Original_库存总量 IS NULL AND 库存总量 IS NULL) AND (操作员 = @Original_操作员 OR @Original_操作员 IS NULL AND 操作员 IS NULL) AND (是否注销 = @Original_是否注销) AND (条形码 = @Original_条形码 OR @Original_条形码 IS NULL AND 条形码 IS NULL) AND (现存量 = @Original_现存量 OR @Original_现存量 IS NULL AND 现存量 IS NULL) AND (简介 = @Original_简介 OR @Original_简介 IS NULL AND 简介 IS NULL) AND (类型 = @Original_类型 OR @Original_类型 IS NULL AND 类型 IS NULL) AND (译者 = @Original_译者 OR @Original_译者 IS NULL AND 译者 IS NULL) AND (页码 = @Original_页码 OR @Original_页码 IS NULL AND 页码 IS NULL); SELECT 条形码, 编号, 书名, 类型, 作者, 译者, ISBN, 出版社, 价格, 页码, 书架名称, 现存量, 库存总量, 入库时间, 操作员, 简介, 借出次数, 是否注销 FROM 图书信息 WHERE (编号 = @编号)";
			this.sqlUpdateCommand1.Connection = this.sqlConnection1;
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@条形码", System.Data.SqlDbType.VarChar, 40, "条形码"));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@编号", System.Data.SqlDbType.VarChar, 50, "编号"));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@书名", System.Data.SqlDbType.VarChar, 200, "书名"));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@类型", System.Data.SqlDbType.VarChar, 100, "类型"));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@作者", System.Data.SqlDbType.VarChar, 100, "作者"));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@译者", System.Data.SqlDbType.VarChar, 100, "译者"));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ISBN", System.Data.SqlDbType.VarChar, 40, "ISBN"));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@出版社", System.Data.SqlDbType.VarChar, 100, "出版社"));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@价格", System.Data.SqlDbType.Money, 8, "价格"));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@页码", System.Data.SqlDbType.Int, 4, "页码"));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@书架名称", System.Data.SqlDbType.VarChar, 200, "书架名称"));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@现存量", System.Data.SqlDbType.Int, 4, "现存量"));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@库存总量", System.Data.SqlDbType.Int, 4, "库存总量"));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@入库时间", System.Data.SqlDbType.DateTime, 4, "入库时间"));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@操作员", System.Data.SqlDbType.VarChar, 20, "操作员"));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@简介", System.Data.SqlDbType.VarChar, 100, "简介"));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@借出次数", System.Data.SqlDbType.Int, 4, "借出次数"));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@是否注销", System.Data.SqlDbType.Bit, 1, "是否注销"));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_编号", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "编号", System.Data.DataRowVersion.Original, null));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_ISBN", System.Data.SqlDbType.VarChar, 40, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "ISBN", System.Data.DataRowVersion.Original, null));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_书名", System.Data.SqlDbType.VarChar, 200, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "书名", System.Data.DataRowVersion.Original, null));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_书架名称", System.Data.SqlDbType.VarChar, 200, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "书架名称", System.Data.DataRowVersion.Original, null));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_价格", System.Data.SqlDbType.Money, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "价格", System.Data.DataRowVersion.Original, null));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_作者", System.Data.SqlDbType.VarChar, 100, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "作者", System.Data.DataRowVersion.Original, null));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_借出次数", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "借出次数", System.Data.DataRowVersion.Original, null));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_入库时间", System.Data.SqlDbType.DateTime, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "入库时间", System.Data.DataRowVersion.Original, null));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_出版社", System.Data.SqlDbType.VarChar, 100, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "出版社", System.Data.DataRowVersion.Original, null));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_库存总量", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "库存总量", System.Data.DataRowVersion.Original, null));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_操作员", System.Data.SqlDbType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "操作员", System.Data.DataRowVersion.Original, null));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_是否注销", System.Data.SqlDbType.Bit, 1, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "是否注销", System.Data.DataRowVersion.Original, null));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_条形码", System.Data.SqlDbType.VarChar, 40, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "条形码", System.Data.DataRowVersion.Original, null));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_现存量", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "现存量", System.Data.DataRowVersion.Original, null));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_简介", System.Data.SqlDbType.VarChar, 100, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "简介", System.Data.DataRowVersion.Original, null));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_类型", System.Data.SqlDbType.VarChar, 100, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "类型", System.Data.DataRowVersion.Original, null));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_译者", System.Data.SqlDbType.VarChar, 100, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "译者", System.Data.DataRowVersion.Original, null));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_页码", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "页码", System.Data.DataRowVersion.Original, null));
			// 
			// dataSet11
			// 
			this.dataSet11.DataSetName = "DataSet1";
			this.dataSet11.Locale = new System.Globalization.CultureInfo("zh-CN");
			// 
			// frmSelectBook
			// 
			this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
			this.ClientSize = new System.Drawing.Size(608, 317);
			this.Name = "frmSelectBook";
			((System.ComponentModel.ISupportInitialize)(this.dgdList)).EndInit();
			((System.ComponentModel.ISupportInitialize)(this.dataSet11)).EndInit();

		}
		#endregion

		public override void Prepare()
		{
			this.Text = "选择图书";
			grbSearch.Visible = false;
			dgdList.Dock = DockStyle.Fill;
			ToolBar1.Visible = false;
		}

		public override void LoadData()
		{
			dataSet11.Clear();
			sqlConnection1.ConnectionString = DataBase.sConn;
			sqlDataAdapter1.Fill( dataSet11 );
			dtData = dataSet11.Tables[ "图书信息" ];
			bmData = this.BindingContext[ dataSet11, "图书信息" ];
			if ( bmData.Count != 0 )
				bmData.Position = 0;
		}

		public override void SetDataGrid()
		{
			LoadData();
			DataGridTableStyle ts = new DataGridTableStyle();
			DataGridTextBoxColumn aCol;
			int numCols = dtData.Columns.Count;
			for ( int i = 0; i < numCols - 2; i ++ )
			{
				aCol = new DataGridTextBoxColumn();
				aCol.MappingName = dtData.Columns[ i ].ColumnName;
				aCol.HeaderText = dtData.Columns[ i ].ColumnName;
				aCol.NullText = "";
				aCol.ReadOnly = true;
				aCol.TextBox.MouseDown +=new MouseEventHandler( DGDoubleClick );
				aCol.TextBox.DoubleClick +=new EventHandler( dgdList_DoubleClick );
				ts.GridColumnStyles.Add( aCol );
			}
			ts.AlternatingBackColor = Color.LightGray;
			ts.AllowSorting = false;
			ts.MappingName = dtData.TableName;
			dgdList.TableStyles.Clear();
			dgdList.TableStyles.Add( ts );
			DataView dv = dtData.DefaultView;
			dv.AllowNew = false;
			dv.AllowDelete = false;
			dgdList.DataSource = dv;
			bmData = this.BindingContext[ dataSet11, "图书信息" ];
			lblCount.Text = "记录数：" + dtData.Rows.Count.ToString();
		}

		public string GetInfo()
		{
			int iRow = dgdList.CurrentRowIndex;
			return dtData.Rows[ iRow ][ "编号" ].ToString();
		}

		private void dgdList_DoubleClick(object sender, System.EventArgs e)
		{
			this.Close();
		}

		private void dgdList_MouseDown(object sender, System.Windows.Forms.MouseEventArgs e)
		{
			gr = DateTime.Now;
		}

		private void DGDoubleClick( object sender, System.Windows.Forms.MouseEventArgs e )
		{
			if ( DateTime.Now < gr.AddMilliseconds( SystemInformation.DoubleClickTime ) )
				this.dgdList_DoubleClick( null, null );
		}
	}
}