frmbuybook.cs

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

			this.btnSubmit.Location = new System.Drawing.Point(202, 267);
			this.btnSubmit.Name = "btnSubmit";
			this.btnSubmit.Size = new System.Drawing.Size(104, 22);
			this.btnSubmit.TabIndex = 22;
			this.btnSubmit.Text = "提交征订（验收）";
			this.btnSubmit.Click += new System.EventHandler(this.btnSubmit_Click);
			// 
			// sqlDataAdapter1
			// 
			this.sqlDataAdapter1.DeleteCommand = this.sqlDeleteCommand1;
			this.sqlDataAdapter1.InsertCommand = this.sqlInsertCommand1;
			this.sqlDataAdapter1.SelectCommand = this.sqlSelectCommand1;
			this.sqlDataAdapter1.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
																									  new System.Data.Common.DataTableMapping("Table", "图书征订", new System.Data.Common.DataColumnMapping[] {
																																																			  new System.Data.Common.DataColumnMapping("征订编号", "征订编号")})});
			this.sqlDataAdapter1.UpdateCommand = this.sqlUpdateCommand1;
			// 
			// sqlDeleteCommand1
			// 
			this.sqlDeleteCommand1.CommandText = "DELETE FROM 图书征订 WHERE (征订编号 = @Original_征订编号)";
			this.sqlDeleteCommand1.Connection = this.sqlConnection1;
			this.sqlDeleteCommand1.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));
			// 
			// sqlConnection1
			// 
			this.sqlConnection1.ConnectionString = "workstation id=JEFF;packet size=4096;integrated security=SSPI;data source=JEFF;pe" +
				"rsist security info=False;initial catalog=libbook";
			// 
			// sqlInsertCommand1
			// 
			this.sqlInsertCommand1.CommandText = "INSERT INTO 图书征订(征订编号) VALUES (@征订编号); SELECT 征订编号 FROM 图书征订 WHERE (征订编号 = @征订编号)" +
				"";
			this.sqlInsertCommand1.Connection = this.sqlConnection1;
			this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@征订编号", System.Data.SqlDbType.VarChar, 50, "征订编号"));
			// 
			// sqlSelectCommand1
			// 
			this.sqlSelectCommand1.CommandText = "SELECT 征订编号 FROM 图书征订";
			this.sqlSelectCommand1.Connection = this.sqlConnection1;
			// 
			// sqlUpdateCommand1
			// 
			this.sqlUpdateCommand1.CommandText = "UPDATE 图书征订 SET 征订编号 = @征订编号 WHERE (征订编号 = @Original_征订编号); SELECT 征订编号 FROM 图书征订" +
				" WHERE (征订编号 = @征订编号)";
			this.sqlUpdateCommand1.Connection = this.sqlConnection1;
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@征订编号", System.Data.SqlDbType.VarChar, 50, "征订编号"));
			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));
			// 
			// dataSet11
			// 
			this.dataSet11.DataSetName = "DataSet1";
			this.dataSet11.Locale = new System.Globalization.CultureInfo("zh-CN");
			// 
			// frmBuyBook
			// 
			this.AutoScaleBaseSize = new System.Drawing.Size(5, 13);
			this.ClientSize = new System.Drawing.Size(568, 293);
			this.Controls.Add(this.GroupBox1);
			this.Controls.Add(this.btnSubmit);
			this.Name = "frmBuyBook";
			this.Load += new System.EventHandler(this.frmBuyBook_Load);
			this.Controls.SetChildIndex(this.dgdList, 0);
			this.Controls.SetChildIndex(this.btnSubmit, 0);
			this.Controls.SetChildIndex(this.GroupBox1, 0);
			((System.ComponentModel.ISupportInitialize)(this.dgdList)).EndInit();
			this.GroupBox1.ResumeLayout(false);
			((System.ComponentModel.ISupportInitialize)(this.dataSet11)).EndInit();
			this.ResumeLayout(false);

		}
		#endregion

		private void btnSubmit_Click(object sender, System.EventArgs e)
		{
			DataBase db = new DataBase();
			db.RunDelOrInsSQL( "exec sf_图书征订" );
			db.Dispose();
			LoadData();
			dgdList.DataSource = dtData.DefaultView;
		}

		public override void LoadData()
		{
			this.Text = "图书征订";
			Label1.Text = "征订编号";
			Label2.Text = "图书编号";
			Label3.Text = "图书名称";
		}

		public override void LoadDataForDetail()
		{
			string strFilter;
			if ( txbOne.Text.Trim().Length == 0 )
			{
				if ( txbTwo.Text.Trim().Length == 0 )
				{
					if ( txbThree.Text.Trim().Length == 0 )
						strFilter = "";
					else
					{
						strFilter = "where 图书名称 like '";
						strFilter += txbThree.Text.Trim() + "%'";
					}
				}
				else
				{
					strFilter = "where 图书编号 like '";
					strFilter += txbTwo.Text.Trim() + "%'";
					if ( txbThree.Text.Trim().Length != 0 )
						strFilter += " and 图书名称 like '" + txbThree.Text.Trim() + "%'";
				}
			}
			else
			{
				strFilter = "where 征订编号 like '" + txbOne.Text.Trim() + "%'";
				if ( txbTwo.Text.Trim().Length != 0 )
				{
					strFilter += " and 图书编号 like '" + txbTwo.Text.Trim() + "%'";
					if ( txbThree.Text.Trim().Length != 0 )
						strFilter += " and 图书名称 like '" + txbThree.Text.Trim() + "%'";
				}
				else
				{
					if ( txbThree.Text.Trim().Length != 0 )
						strFilter += " and 图书名称 like '" + txbThree.Text.Trim() + "%'";
				}						
			}
			dataSet11.Clear();
			sqlConnection1.ConnectionString = DataBase.sConn;
			// string strSQL = "";
			if ( strFilter.Trim().Length == 0 )
				strFilter = " where 是否验收 = 0 ";
			else
				strFilter = " and 是否验收 = 0  ";
			sqlDataAdapter1.SelectCommand.CommandText = "select * from 图书征订 " + strFilter;
			sqlDataAdapter1.Fill( dataSet11 );
			dtData = dataSet11.Tables[ "图书征订" ];
			if ( dtData.Columns.IndexOf( "图书名称" ) == -1 )
				dtData.Columns.Add( "图书名称" );
			SetBookName();
			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 < 14; i ++ )
			{
				aCol = new DataGridTextBoxColumn();
				aCol.MappingName = "图书名称";
				aCol.HeaderText = "图书名称";
				aCol.NullText = "";
				aCol.ReadOnly = true;
				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;
			dv.AllowEdit = false;
			dgdList.DataSource = dv;
			bmData = this.BindingContext[ dataSet11, "图书征订" ];
			lblCount.Text = "记录数:" + dtData.Rows.Count.ToString();
		}

		public override void SetTextBoxState(bool bState)
		{
			GroupBox1.Enabled = !bState;
		}

		public override void Clear()
		{
			DataBase db = new DataBase();
			string strID, strT, strSQL;
			strSQL = "select max(征订编号) as MaxID from 图书征订";
			DataView dv = db.RunSelectSQL( strSQL );
			if ( dv.Count != 0 )
			{
				strT = "00000000";
				strID = Convert.ToString(  Int32.Parse( dv[ 0 ][ 0 ].ToString() ) + 1  );
				txbNumber.Text = strT.Substring( 0, strT.Length - strID.Length ) + strID;
			}
			else
				txbNumber.Text = "00000001";
			txbBookNumber.Text = "";
			txbBookName.Text = "";
			txbContact.Text = "0";
			txbCount.Text = "";
			txbPrice.Text = "0";
			txbSubscriber.Text = "";
			tmDate.Value = DateTime.Now;
		}

		public override void SaveForAdd()
		{
			DataRow dr = dataSet11.Tables[ "图书征订" ].NewRow();
			try
			{
				dr[ "征订编号" ] = txbNumber.Text.Trim();
				dr[ "图书编号" ] = txbBookNumber.Text.Trim();
				dr[ "订购者" ] = txbSubscriber.Text.Trim();
				dr[ "操作员" ] = txbWorker.Text.Trim();
				dr[ "订购数量" ] = txbCount.Text.Trim();
				dr[ "订购单价" ] = txbPrice.Text.Trim();
				dr[ "订购日期" ] = tmDate.Text.Trim();
				dr[ "订购者联系方式" ] = txbContact.Text.Trim();
				dr[ "是否验收" ] = "False";
			}
			catch ( Exception ex )
			{
				MessageBox.Show( "数据格式不正确" + ex.ToString() );
			}
			try
			{
				dataSet11.Tables[ "图书征订" ].Rows.Add( dr );
				if ( dataSet11.HasChanges() )
					sqlDataAdapter1.Update( dataSet11 );
			}
			catch ( Exception ex )
			{
				MessageBox.Show( "数据添加失败" + ex.ToString()  );
			}
			LoadData();
			dgdList.DataSource = dtData.DefaultView;
		}

		public override void DeleteData()
		{
			try
			{
				dataSet11.Tables[ "图书征订" ].Rows[ bmData.Position ].Delete();
				if ( dataSet11.HasChanges() )
					sqlDataAdapter1.Update( dataSet11 );
			}
			catch ( Exception ex )
			{
				MessageBox.Show( ex.ToString() );
			}
		}

		private void btnOpen_Click(object sender, System.EventArgs e)
		{
			frmSelectBook dlgSelect = new frmSelectBook();
			dlgSelect.ShowDialog();
			txbBookNumber.Text = dlgSelect.GetInfo().Trim();		
		}

		private void SetBookName()
		{
			DataBase db = new DataBase();
			string strSQL;
			DataView dv;
			foreach ( DataRow dr in dtData.Rows )
			{
				strSQL = "select 书名 from 图书信息 where 编号=";
				strSQL += dr[ "图书编号" ].ToString().Trim();
				dv = db.RunSelectSQL(strSQL);
				if ( dv.Count != 0 )
					dr[ "图书名称" ] = dv[ 0 ][ 0 ].ToString().Trim();
			}
			db.Dispose();
		}

		private void txbBookNumber_TextChanged(object sender, System.EventArgs e)
		{
			if ( txbBookNumber.Text.Trim().Length == 0 )
				return;
			DataBase db = new DataBase();
			string strSQL = "select 书名 from 图书信息 where 编号=";
			strSQL += txbBookNumber.Text.Trim();
			DataView dv = db.RunSelectSQL( strSQL );
			if ( dv.Count == 0 )
				return;
			else
				txbBookName.Text = dv[ 0 ][ 0 ].ToString();
			db.Dispose();
		}

		public override void SaveForUpdate()
		{
			try
			{
				int row = dgdList.CurrentCell.RowNumber;
				dgdList.CurrentCell = new DataGridCell( ( row + 1 ) % bmData.Count, 0 );
				if ( dataSet11.HasChanges() )
					sqlDataAdapter1.Update( dataSet11 );
			}
			catch ( Exception ex )
			{
				MessageBox.Show( ex.ToString() );
			}
		}

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

	}
}