frmlist.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 frmList : 图书馆管理系统.frmBase
	{
		private System.ComponentModel.IContainer components = null;

		public frmList()
		{
			// 该调用是 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()
		{
			((System.ComponentModel.ISupportInitialize)(this.dgdList)).BeginInit();
			// 
			// dgdList
			// 
			this.dgdList.Name = "dgdList";
			this.dgdList.Size = new System.Drawing.Size(495, 110);
			// 
			// frmList
			// 
			this.AutoScaleBaseSize = new System.Drawing.Size(5, 13);
			this.ClientSize = new System.Drawing.Size(506, 294);
			this.Name = "frmList";
			((System.ComponentModel.ISupportInitialize)(this.dgdList)).EndInit();

		}
		#endregion

		public override void Prepare()
		{
			this.Text = "图书逾期清单";
			Label1.Text = "读者编号";
			Label2.Text = "读者条码";
			Label3.Text = "图书编号";
			ToolBar1.Visible = false;
			dgdList.Dock = DockStyle.Fill;
		}

		public override void LoadData()
		{
			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() + "%'";
				}						
			}
			DataBase db = new DataBase();
			string strSQL = "select 借阅编号,c.图书编号,书名 as 图书名称 ,借阅时间,应还时间,姓名,c.读者编号,续借次数,c.操作员,状态 from 图书信息 as a, 读者信息 as b,图书借阅 as c where a.编号 = c.图书编号 and b.编号 = c.读者编号 ";
			strSQL += strFilter + " and 应还时间 < '" + DateTime.Now.ToString() + "' and 状态='未还'";
			DataView dv = db.RunSelectSQL( strSQL );
			dtData = dv.Table;
		}

		public override void SetDataGrid()
		{
			
			LoadData();
			DataGridTableStyle ts = new DataGridTableStyle();
			DataGridTextBoxColumn aCol;
			int numCols = dtData.Columns.Count;
			for ( int i = 0; i < numCols; i ++ )
			{
				aCol = new DataGridTextBoxColumn();
				aCol.MappingName = dtData.Columns[ i ].ColumnName;
				aCol.HeaderText = dtData.Columns[ i ].ColumnName;
				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;
			dgdList.DataSource = dv;
			lblCount.Text = "记录数:" + dtData.Rows.Count.ToString();
		}

	}
}