frmreadertype.cs

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

using System;
using System.Collections;
using System.ComponentModel;
using System.Drawing;
using System.Windows.Forms;
using System.Data;
using System.Data.SqlClient;

namespace 图书馆管理系统
{
	public class frmReaderType : 图书馆管理系统.frmBase
	{
		internal System.Windows.Forms.GroupBox GroupBox1;
		internal System.Windows.Forms.CheckBox cbbMagzine;
		internal System.Windows.Forms.CheckBox cbbBook;
		internal System.Windows.Forms.TextBox txbTimes;
		internal System.Windows.Forms.Label Label7;
		internal System.Windows.Forms.TextBox txbMagzineCount;
		internal System.Windows.Forms.Label Label6;
		internal System.Windows.Forms.TextBox txbBookCount;
		internal System.Windows.Forms.Label Label5;
		internal System.Windows.Forms.TextBox txbType;
		internal System.Windows.Forms.Label Label4;
		private System.Data.SqlClient.SqlDataAdapter sqlDataAdapter1;
		private System.Data.SqlClient.SqlCommand sqlSelectCommand1;
		private System.Data.SqlClient.SqlCommand sqlInsertCommand1;
		private System.Data.SqlClient.SqlCommand sqlUpdateCommand1;
		private System.Data.SqlClient.SqlCommand sqlDeleteCommand1;
		private System.Data.SqlClient.SqlConnection sqlConnection1;
		private 图书馆管理系统.DataSet1 dataSet11;
		private System.ComponentModel.IContainer components = null;

		public frmReaderType()
		{
			// 该调用是 Windows 窗体设计器所必需的。
			InitializeComponent();

			// TODO: 在 InitializeComponent 调用后添加任何初始化
		}

		/// <summary>
		/// 清理所有正在使用的资源。
		/// </summary>
		protected override void Dispose( bool disposing )
		{
			if( disposing )
			{
				if (components != null) 
				{
					components.Dispose();
				}
			}
			base.Dispose( disposing );
		}

		#region 设计器生成的代码
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{
			this.GroupBox1 = new System.Windows.Forms.GroupBox();
			this.cbbMagzine = new System.Windows.Forms.CheckBox();
			this.cbbBook = new System.Windows.Forms.CheckBox();
			this.txbTimes = new System.Windows.Forms.TextBox();
			this.Label7 = new System.Windows.Forms.Label();
			this.txbMagzineCount = new System.Windows.Forms.TextBox();
			this.Label6 = new System.Windows.Forms.Label();
			this.txbBookCount = new System.Windows.Forms.TextBox();
			this.Label5 = new System.Windows.Forms.Label();
			this.txbType = new System.Windows.Forms.TextBox();
			this.Label4 = new System.Windows.Forms.Label();
			this.sqlDataAdapter1 = new System.Data.SqlClient.SqlDataAdapter();
			this.sqlDeleteCommand1 = new System.Data.SqlClient.SqlCommand();
			this.sqlConnection1 = new System.Data.SqlClient.SqlConnection();
			this.sqlInsertCommand1 = new System.Data.SqlClient.SqlCommand();
			this.sqlSelectCommand1 = new System.Data.SqlClient.SqlCommand();
			this.sqlUpdateCommand1 = new System.Data.SqlClient.SqlCommand();
			this.dataSet11 = new 图书馆管理系统.DataSet1();
			((System.ComponentModel.ISupportInitialize)(this.dgdList)).BeginInit();
			this.GroupBox1.SuspendLayout();
			((System.ComponentModel.ISupportInitialize)(this.dataSet11)).BeginInit();
			this.SuspendLayout();
			// 
			// dgdList
			// 
			this.dgdList.Location = new System.Drawing.Point(6, 76);
			this.dgdList.Name = "dgdList";
			this.dgdList.Size = new System.Drawing.Size(498, 62);
			// 
			// GroupBox1
			// 
			this.GroupBox1.Anchor = ((System.Windows.Forms.AnchorStyles)(((System.Windows.Forms.AnchorStyles.Bottom | System.Windows.Forms.AnchorStyles.Left) 
				| System.Windows.Forms.AnchorStyles.Right)));
			this.GroupBox1.Controls.Add(this.cbbMagzine);
			this.GroupBox1.Controls.Add(this.cbbBook);
			this.GroupBox1.Controls.Add(this.txbTimes);
			this.GroupBox1.Controls.Add(this.Label7);
			this.GroupBox1.Controls.Add(this.txbMagzineCount);
			this.GroupBox1.Controls.Add(this.Label6);
			this.GroupBox1.Controls.Add(this.txbBookCount);
			this.GroupBox1.Controls.Add(this.Label5);
			this.GroupBox1.Controls.Add(this.txbType);
			this.GroupBox1.Controls.Add(this.Label4);
			this.GroupBox1.Location = new System.Drawing.Point(8, 144);
			this.GroupBox1.Name = "GroupBox1";
			this.GroupBox1.Size = new System.Drawing.Size(496, 136);
			this.GroupBox1.TabIndex = 7;
			this.GroupBox1.TabStop = false;
			// 
			// cbbMagzine
			// 
			this.cbbMagzine.Location = new System.Drawing.Point(112, 72);
			this.cbbMagzine.Name = "cbbMagzine";
			this.cbbMagzine.Size = new System.Drawing.Size(80, 22);
			this.cbbMagzine.TabIndex = 9;
			this.cbbMagzine.Text = "限制期刊";
			// 
			// cbbBook
			// 
			this.cbbBook.Location = new System.Drawing.Point(20, 67);
			this.cbbBook.Name = "cbbBook";
			this.cbbBook.Size = new System.Drawing.Size(84, 22);
			this.cbbBook.TabIndex = 8;
			this.cbbBook.Text = "限制图书";
			// 
			// txbTimes
			// 
			this.txbTimes.Location = new System.Drawing.Point(376, 40);
			this.txbTimes.Name = "txbTimes";
			this.txbTimes.Size = new System.Drawing.Size(48, 20);
			this.txbTimes.TabIndex = 7;
			this.txbTimes.Text = "";
			// 
			// Label7
			// 
			this.Label7.Location = new System.Drawing.Point(313, 42);
			this.Label7.Name = "Label7";
			this.Label7.Size = new System.Drawing.Size(63, 15);
			this.Label7.TabIndex = 6;
			this.Label7.Text = "续借次数";
			// 
			// txbMagzineCount
			// 
			this.txbMagzineCount.Location = new System.Drawing.Point(253, 37);
			this.txbMagzineCount.Name = "txbMagzineCount";
			this.txbMagzineCount.Size = new System.Drawing.Size(49, 20);
			this.txbMagzineCount.TabIndex = 5;
			this.txbMagzineCount.Text = "";
			// 
			// Label6
			// 
			this.Label6.Location = new System.Drawing.Point(207, 42);
			this.Label6.Name = "Label6";
			this.Label6.Size = new System.Drawing.Size(46, 15);
			this.Label6.TabIndex = 4;
			this.Label6.Text = "期刊册数";
			// 
			// txbBookCount
			// 
			this.txbBookCount.Location = new System.Drawing.Point(147, 37);
			this.txbBookCount.Name = "txbBookCount";
			this.txbBookCount.Size = new System.Drawing.Size(48, 20);
			this.txbBookCount.TabIndex = 3;
			this.txbBookCount.Text = "";
			// 
			// Label5
			// 
			this.Label5.Location = new System.Drawing.Point(100, 42);
			this.Label5.Name = "Label5";
			this.Label5.Size = new System.Drawing.Size(47, 15);
			this.Label5.TabIndex = 2;
			this.Label5.Text = "图书册数";
			// 
			// txbType
			// 
			this.txbType.Location = new System.Drawing.Point(48, 37);
			this.txbType.Name = "txbType";
			this.txbType.Size = new System.Drawing.Size(48, 20);
			this.txbType.TabIndex = 1;
			this.txbType.Text = "";
			// 
			// Label4
			// 
			this.Label4.Location = new System.Drawing.Point(13, 42);
			this.Label4.Name = "Label4";
			this.Label4.Size = new System.Drawing.Size(35, 15);
			this.Label4.TabIndex = 0;
			this.Label4.Text = "类型";
			// 
			// 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("类型", "类型"),
																																																			  new System.Data.Common.DataColumnMapping("图书册书", "图书册书"),
																																																			  new System.Data.Common.DataColumnMapping("期刊册书", "期刊册书"),
																																																			  new System.Data.Common.DataColumnMapping("续借次数", "续借次数"),
																																																			  new System.Data.Common.DataColumnMapping("限制图书", "限制图书"),
																																																			  new System.Data.Common.DataColumnMapping("限制期刊", "限制期刊")})});
			this.sqlDataAdapter1.UpdateCommand = this.sqlUpdateCommand1;