⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 frmconsume.cs

📁 采用C#和SQL Server 2000开发 功能比较全面的酒店管理系统
💻 CS
📖 第 1 页 / 共 2 页
字号:
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 frmConsume : 酒店管理系统.frmBase	{
		internal System.Windows.Forms.GroupBox GroupBox1;
		internal System.Windows.Forms.DateTimePicker tmConsume;
		internal System.Windows.Forms.Button btnOpen;
		internal System.Windows.Forms.ComboBox cbbContent;
		internal System.Windows.Forms.Label Label8;
		internal System.Windows.Forms.TextBox txbRemark;
		internal System.Windows.Forms.TextBox txbMoney;
		internal System.Windows.Forms.TextBox txbInId;
		internal System.Windows.Forms.Label Label7;
		internal System.Windows.Forms.Label Label6;
		internal System.Windows.Forms.Label Label5;
		internal System.Windows.Forms.Label Label4;
		private System.Data.SqlClient.SqlDataAdapter sqlDataAdapter1;
		private System.Data.SqlClient.SqlConnection sqlConnection1;
		private 酒店管理系统.DataSet1 dataSet11;
		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.ComponentModel.IContainer components = null;		public frmConsume()		{			// 该调用是 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.Resources.ResourceManager resources = new System.Resources.ResourceManager(typeof(frmConsume));
			this.GroupBox1 = new System.Windows.Forms.GroupBox();
			this.tmConsume = new System.Windows.Forms.DateTimePicker();
			this.dataSet11 = new 酒店管理系统.DataSet1();
			this.btnOpen = new System.Windows.Forms.Button();
			this.cbbContent = new System.Windows.Forms.ComboBox();
			this.Label8 = new System.Windows.Forms.Label();
			this.txbRemark = new System.Windows.Forms.TextBox();
			this.txbMoney = new System.Windows.Forms.TextBox();
			this.txbInId = new System.Windows.Forms.TextBox();
			this.Label7 = new System.Windows.Forms.Label();
			this.Label6 = new System.Windows.Forms.Label();
			this.Label5 = new System.Windows.Forms.Label();
			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();
			((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(0, 89);
			this.dgdList.Name = "dgdList";
			this.dgdList.Size = new System.Drawing.Size(502, 94);
			// 
			// 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.tmConsume);
			this.GroupBox1.Controls.Add(this.btnOpen);
			this.GroupBox1.Controls.Add(this.cbbContent);
			this.GroupBox1.Controls.Add(this.Label8);
			this.GroupBox1.Controls.Add(this.txbRemark);
			this.GroupBox1.Controls.Add(this.txbMoney);
			this.GroupBox1.Controls.Add(this.txbInId);
			this.GroupBox1.Controls.Add(this.Label7);
			this.GroupBox1.Controls.Add(this.Label6);
			this.GroupBox1.Controls.Add(this.Label5);
			this.GroupBox1.Controls.Add(this.Label4);
			this.GroupBox1.Location = new System.Drawing.Point(0, 192);
			this.GroupBox1.Name = "GroupBox1";
			this.GroupBox1.Size = new System.Drawing.Size(500, 149);
			this.GroupBox1.TabIndex = 7;
			this.GroupBox1.TabStop = false;
			// 
			// tmConsume
			// 
			this.tmConsume.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dataSet11, "帐单明细.消费时间"));
			this.tmConsume.Format = System.Windows.Forms.DateTimePickerFormat.Short;
			this.tmConsume.Location = new System.Drawing.Point(233, 74);
			this.tmConsume.Name = "tmConsume";
			this.tmConsume.Size = new System.Drawing.Size(100, 20);
			this.tmConsume.TabIndex = 11;
			// 
			// dataSet11
			// 
			this.dataSet11.DataSetName = "DataSet1";
			this.dataSet11.Locale = new System.Globalization.CultureInfo("zh-CN");
			// 
			// btnOpen
			// 
			this.btnOpen.Image = ((System.Drawing.Image)(resources.GetObject("btnOpen.Image")));
			this.btnOpen.Location = new System.Drawing.Point(107, 29);
			this.btnOpen.Name = "btnOpen";
			this.btnOpen.Size = new System.Drawing.Size(21, 21);
			this.btnOpen.TabIndex = 10;
			this.btnOpen.Click += new System.EventHandler(this.btnOpen_Click);
			// 
			// cbbContent
			// 
			this.cbbContent.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dataSet11, "帐单明细.消费内容"));
			this.cbbContent.Items.AddRange(new object[] {
															"加收房费",
															"加收水电费",
															"视频点播费",
															"宽带上网费",
															"商品使用费",
															"其他费用"});
			this.cbbContent.Location = new System.Drawing.Point(9, 73);
			this.cbbContent.Name = "cbbContent";
			this.cbbContent.Size = new System.Drawing.Size(101, 21);
			this.cbbContent.TabIndex = 9;
			// 
			// Label8
			// 
			this.Label8.Location = new System.Drawing.Point(9, 56);
			this.Label8.Name = "Label8";
			this.Label8.Size = new System.Drawing.Size(47, 15);
			this.Label8.TabIndex = 8;
			this.Label8.Text = "消费内容";
			// 
			// txbRemark
			// 
			this.txbRemark.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dataSet11, "帐单明细.备注"));
			this.txbRemark.Location = new System.Drawing.Point(9, 120);
			this.txbRemark.Name = "txbRemark";
			this.txbRemark.Size = new System.Drawing.Size(324, 20);
			this.txbRemark.TabIndex = 7;
			this.txbRemark.Text = "";
			// 
			// txbMoney
			// 
			this.txbMoney.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dataSet11, "帐单明细.消费金额"));
			this.txbMoney.Location = new System.Drawing.Point(133, 73);
			this.txbMoney.Name = "txbMoney";
			this.txbMoney.Size = new System.Drawing.Size(84, 20);
			this.txbMoney.TabIndex = 3;
			this.txbMoney.Text = "";
			// 
			// txbInId
			// 
			this.txbInId.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dataSet11, "帐单明细.入住单号"));
			this.txbInId.Location = new System.Drawing.Point(9, 30);
			this.txbInId.Name = "txbInId";
			this.txbInId.Size = new System.Drawing.Size(83, 20);
			this.txbInId.TabIndex = 1;
			this.txbInId.Text = "";
			// 
			// Label7
			// 
			this.Label7.Location = new System.Drawing.Point(9, 99);
			this.Label7.Name = "Label7";
			this.Label7.Size = new System.Drawing.Size(47, 15);
			this.Label7.TabIndex = 6;
			this.Label7.Text = "备注";
			// 
			// Label6
			// 
			this.Label6.Location = new System.Drawing.Point(247, 56);
			this.Label6.Name = "Label6";
			this.Label6.Size = new System.Drawing.Size(46, 15);
			this.Label6.TabIndex = 4;
			this.Label6.Text = "消费时间";
			// 
			// Label5
			// 
			this.Label5.Location = new System.Drawing.Point(134, 56);
			this.Label5.Name = "Label5";
			this.Label5.Size = new System.Drawing.Size(47, 15);
			this.Label5.TabIndex = 2;
			this.Label5.Text = "消费金额";
			// 
			// Label4
			// 
			this.Label4.Location = new System.Drawing.Point(9, 14);
			this.Label4.Name = "Label4";
			this.Label4.Size = new System.Drawing.Size(47, 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("备注", "备注")})});

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -