frmcash.cs

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

			this.Controls.Add(this.GroupBox1);
			this.Controls.Add(this.dgdDetail);
			this.Name = "frmCash";
			this.Controls.SetChildIndex(this.dgdDetail, 0);
			this.Controls.SetChildIndex(this.GroupBox1, 0);
			this.Controls.SetChildIndex(this.dgdList, 0);
			((System.ComponentModel.ISupportInitialize)(this.dgdList)).EndInit();
			this.GroupBox1.ResumeLayout(false);
			((System.ComponentModel.ISupportInitialize)(this.dgdDetail)).EndInit();
			((System.ComponentModel.ISupportInitialize)(this.dataSet11)).EndInit();
			this.ResumeLayout(false);

		}
		#endregion

		public override void Prepare()
		{
			this.Text = "收银退房";
			Label1.Visible = false;
			Label2.Visible = false;
			Label3.Visible = false;
			txbThree.Visible = false;
			txbOne.Visible = false;
			txbTwo.Visible = false;
			ToolBar1.Buttons[ 4 ].Visible = false;
			ToolBar1.Buttons[ 5 ].Visible = false;
			ToolBar1.Buttons[ 6 ].Visible = false;
			ToolBar1.Buttons[ 7 ].Visible = false;
			ToolBar1.Buttons[ 8 ].Visible = false;
		}

		public override void LoadData()
		{
			// 清空dataSet11
			dataSet11.Clear();
			sqlConnection1.ConnectionString = DataBase.sConn;
			// string strSQL = "";
			sqlDataAdapter1.SelectCommand.CommandText = 
				"SELECT 入住单号, 客房类型, 客房编号, 抵店时间, 离店时间, 入住价格, 加床价格, 预收款, 应收帐款, 结帐金额, 是否结帐, 结帐日期, 付款方式 FROM 入住单 ";
			// 根据查询条件重新填充dataSet11
			sqlDataAdapter1.Fill( dataSet11 );
			dtData = dataSet11.Tables[ "入住单" ];
			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 < 11; i ++ )
			{
				aCol = new DataGridTextBoxColumn();
				aCol.MappingName = dtData.Columns[ i ].ColumnName;
				aCol.HeaderText = dtData.Columns[ i ].ColumnName;
				aCol.NullText = "";
				aCol.ReadOnly = true;
				aCol.Width = 70;
				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();
			SetData();
		}

		public override void SetData()
		{
			txbRemailMoney.Text = dtData.Rows[ bmData.Position ][ "结帐金额" ].ToString().Trim();
			DataBase db = new DataBase();
			string strSQL = "select * from 帐单明细 where 入住单号='";
			strSQL += dtData.Rows[ bmData.Position ][ "入住单号" ] + "'";
			DataView dv = db.RunSelectSQL( strSQL );
			dv.AllowNew = false;
			dv.AllowEdit = false;
			dv.AllowDelete = false;
			// 定义一个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 = "";
				aCol.ReadOnly = true;
				ts.GridColumnStyles.Add( aCol );
			}
			ts.AlternatingBackColor = Color.LightGray;
			ts.AllowSorting = false;
			ts.MappingName = dtData.TableName;
			dgdDetail.TableStyles .Clear();
			dgdDetail.TableStyles.Add( ts );
			// DataView dv = dtData.DefaultView;
			// dv.AllowNew = false;
			// dv.AllowDelete = false;
			// dv.AllowEdit = false;
			// 设置数据源
			dgdDetail.DataSource = dv;
		}

		private void btnPayMoney_Click(object sender, System.EventArgs e)
		{
			// 执行存储过程
			DataBase db = new DataBase();
			db.RunDelOrInsSQL( "exec sf_计算应收帐款'" + 
				dtData.Rows[ bmData.Position ][ "入住单号" ] + "'" );
			db.Dispose();
			SetDataGrid();
		}

		private void btnOver_Click(object sender, System.EventArgs e)
		{
			DataBase db = new DataBase();
			string strSQL = "exec sf_收银退房 '";
			strSQL += dtData.Rows[ bmData.Position ][ "入住单号" ].ToString();
			strSQL += "','" + cbbPayWay.Text + "'";
			db.RunDelOrInsSQL( strSQL );
			db.Dispose();
			SetDataGrid();
		}

	}
}