frmreserve.cs

简单的酒店客房管理系统

			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

		public override void Prepare()
		{
			this.Text = "预订管理";
			Label1.Text = "预订编号";
			Label2.Text = "预订人";
			Label3.Text = "抵达时间";
			// 为cbbRoomType进行数据邦定
			DataBase db = new DataBase();
			DataView dv = db.RunSelectSQL( "select 类型编号,类型名称 from 客房类型");
			cbbRoomType.DataSource = dv;
			cbbRoomType.DisplayMember = "类型名称";
			cbbRoomType.ValueMember = "类型编号";
			db.Dispose();
		}

		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 '";
						strFilter += txbThree.Text.Trim() + "%'";
					}
				}
			}
			else
			{
				strFilter = "where 预定编号 like '";
				strFilter += txbOne.Text.Trim() + "%'";
				if ( txbTwo.Text.Trim().Length != 0 )
				{
					strFilter += " and 预定人 like '";
					strFilter += txbTwo.Text.Trim() + "%'";
				}
				else
				{
					if ( txbThree.Text.Trim().Length != 0 )
					{
						strFilter += " and 抵店时间 like '";
						strFilter += txbThree.Text.Trim() + "%'";
					}
				}
			}
			// 清空dataSet11
			dataSet11.Clear();
			sqlConnection1.ConnectionString = DataBase.sConn;
			// string strSQL = "";
			sqlDataAdapter1.SelectCommand.CommandText = "select * from 预定单 " + strFilter;
			// 根据查询条件重新填充DataSet11
			sqlDataAdapter1.Fill( dataSet11 );
			dtData = dataSet11.Tables[ "预订单" ];
			bmData = this.BindingContext[ dataSet11, "预订单" ];
			if ( bmData.Count != 0 )
			{
				bmData.Position = 0;
			}
		}

		public override void SetDataGrid()
		{
			LoadData();
			// 定义一个DataGrid表样式
			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 = "";
				if ( i == 11 )
				{
					aCol.NullText = "false";
				}
				aCol.ReadOnly = true;
				if ( bClose )
				{
					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;
			// dv.AllowEdit = false;
			// 设置数据源
			dgdList.DataSource = dtData.DefaultView;
			bmData = this.BindingContext[ dataSet11, "预订单" ];
			lblCount.Text = "记录数:" + dtData.Rows.Count.ToString();
		}

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

		public override void Clear()
		{
			txbAddPrice.Text = "0";
			txbBeforMoney.Text = "0";
			txbDestineCompany.Text = "";
			txbDestinePeople.Text = "";
			txbDiscount.Text = "0";
			txbMemberId.Text = "001";
			txbNowPrice.Text = "";
			txbNumber.Text = "1";
			txbState.Text = "预定";
			txbRoomCode.Text = "";
			txbRemark.Text = "";
			txbReasonDiscount.Text = "";
			txbPhone.Text = "";
			txbOriginPrice.Text = "";
			txbOperator.Text = "";
			txbOriginPrice.Text = "";
			txbOperator.Text = "";
			txbOperationPeople.Text = "";
			cbbRoomType.Text = "";
			ckbAddBed.Checked = false;
			tmArrive.Value = DateTime.Now;
			tmLeft.Value = DateTime.Now;
			txbState.ReadOnly = true;
			cbbRoomType.Text = "普通房";
			string strId = "YD00000000";
			string strId1 = "";
			DataBase db = new DataBase();
			DataView dv = db.RunSelectSQL( "select max(预定单号) as id from 预定单");
			if ( dv[ 0 ][ 0 ].ToString() == "" )
			{
				// 预订单中没有信息
				dv = db.RunSelectSQL( "select max(预定单号) as id from 预定单历史" );
				if ( dv[ 0 ][ 0].ToString() == "" )
				{
					// 预订单历史没有信息
					strId = "YD00000001";
				}
				else
				{
					strId1 = dv[ 0 ][ 0 ].ToString();
					strId1 = strId1.Substring( 2 );
					int id = Int32.Parse( strId1 ) + 1;
					strId = strId.Substring( 0, ( strId1.Length - id.ToString().Length + 2 ) ) + id.ToString();
				}
			}
			else
			{
				strId1 = dv[ 0 ][ 0 ].ToString();
				strId1 = strId1.Substring( 2 );
				int id = Int32.Parse( strId1 ) + 1;
				strId = strId.Substring( 0, ( strId1.Length - id.ToString().Length + 2 ) ) + id.ToString();
			}
			db.Dispose();
			txbListId.Text = strId;
		}

		public override void SaveForAdd()
		{
			if ( txbRoomCode.Text.Trim().Length == 0 )
			{
				MessageBox.Show( "选择的客房不是空房！" );
				return;
			}
			DataRow dr = dataSet11.Tables[ "预订单" ].NewRow();
			try
			{
				dr[ "预订单号" ] = txbListId.Text.Trim();
				dr[ "客房类型" ] = cbbRoomType.SelectedValue.ToString().Trim();
				dr[ "抵店时间" ] = tmArrive.Text.Trim();
				dr[ "离店时间" ]