?? clientconsume.cs
字號:
using System;using System.Collections;using System.ComponentModel;using System.Drawing;using System.Windows.Forms;namespace 酒店管理系統{ public class ClientConsume : 醫院管理系統.ParentForm { public static string RZid;//入住單編號
private System.Data.SqlClient.SqlConnection sqlConnection1;
private 酒店管理系統.DataSet2 dataSet21;
private System.Windows.Forms.Label label4;
private System.Windows.Forms.TextBox txt4;
private System.Windows.Forms.TextBox txt5;
private System.Windows.Forms.Label label5;
private System.Windows.Forms.TextBox txt6;
private System.Windows.Forms.Label label6;
private System.Windows.Forms.Label label7;
private System.Windows.Forms.Label label8;
private System.Windows.Forms.ComboBox cmb1;
private System.Windows.Forms.ComboBox cmb2;
private System.Windows.Forms.Button btnSelect;
private System.Windows.Forms.MonthCalendar calen1;
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 ClientConsume() { // 該調用是 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(ClientConsume));
this.sqlConnection1 = new System.Data.SqlClient.SqlConnection();
this.dataSet21 = new 酒店管理系統.DataSet2();
this.label4 = new System.Windows.Forms.Label();
this.txt4 = new System.Windows.Forms.TextBox();
this.txt5 = new System.Windows.Forms.TextBox();
this.label5 = new System.Windows.Forms.Label();
this.txt6 = new System.Windows.Forms.TextBox();
this.label6 = new System.Windows.Forms.Label();
this.label7 = new System.Windows.Forms.Label();
this.label8 = new System.Windows.Forms.Label();
this.cmb1 = new System.Windows.Forms.ComboBox();
this.cmb2 = new System.Windows.Forms.ComboBox();
this.btnSelect = new System.Windows.Forms.Button();
this.calen1 = new System.Windows.Forms.MonthCalendar();
this.sqlSelectCommand1 = new System.Data.SqlClient.SqlCommand();
this.sqlInsertCommand1 = new System.Data.SqlClient.SqlCommand();
this.sqlUpdateCommand1 = new System.Data.SqlClient.SqlCommand();
this.sqlDeleteCommand1 = new System.Data.SqlClient.SqlCommand();
((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).BeginInit();
this.groupBox2.SuspendLayout();
((System.ComponentModel.ISupportInitialize)(this.dataSet21)).BeginInit();
this.SuspendLayout();
//
// groupBox1
//
this.groupBox1.Name = "groupBox1";
//
// txt2
//
this.txt2.Name = "txt2";
//
// label1
//
this.label1.Name = "label1";
this.label1.Text = "消費內容";
//
// btnSearch
//
this.btnSearch.Name = "btnSearch";
this.btnSearch.Click += new System.EventHandler(this.btnSearch_Click);
//
// txt1
//
this.txt1.Name = "txt1";
//
// label2
//
this.label2.Name = "label2";
this.label2.Text = "入住單號";
//
// txt3
//
this.txt3.Name = "txt3";
this.txt3.Visible = false;
//
// label3
//
this.label3.Name = "label3";
this.label3.Visible = false;
//
// toolBar1
//
this.toolBar1.Name = "toolBar1";
this.toolBar1.Size = new System.Drawing.Size(728, 41);
//
// dataGrid1
//
this.dataGrid1.DataMember = "帳單明細";
this.dataGrid1.DataSource = this.dataSet21;
this.dataGrid1.Name = "dataGrid1";
this.dataGrid1.Size = new System.Drawing.Size(728, 240);
//
// groupBox2
//
this.groupBox2.Controls.Add(this.btnSelect);
this.groupBox2.Controls.Add(this.cmb1);
this.groupBox2.Controls.Add(this.txt4);
this.groupBox2.Controls.Add(this.label4);
this.groupBox2.Controls.Add(this.txt5);
this.groupBox2.Controls.Add(this.label5);
this.groupBox2.Controls.Add(this.txt6);
this.groupBox2.Controls.Add(this.label6);
this.groupBox2.Controls.Add(this.label7);
this.groupBox2.Controls.Add(this.label8);
this.groupBox2.Controls.Add(this.cmb2);
this.groupBox2.Location = new System.Drawing.Point(0, 336);
this.groupBox2.Name = "groupBox2";
this.groupBox2.Size = new System.Drawing.Size(728, 160);
//
// da1
//
this.da1.DeleteCommand = this.sqlDeleteCommand1;
this.da1.InsertCommand = this.sqlInsertCommand1;
this.da1.SelectCommand = this.sqlSelectCommand1;
this.da1.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.da1.UpdateCommand = this.sqlUpdateCommand1;
//
// sqlConnection1
//
this.sqlConnection1.ConnectionString = "workstation id=localhost;Integrated Security=SSPI;Database=hotelbook;";
//
// dataSet21
//
this.dataSet21.DataSetName = "DataSet2";
this.dataSet21.Locale = new System.Globalization.CultureInfo("zh-CN");
//
// label4
//
this.label4.Location = new System.Drawing.Point(96, 16);
this.label4.Name = "label4";
this.label4.Size = new System.Drawing.Size(100, 16);
this.label4.TabIndex = 0;
this.label4.Text = "入住單號";
//
// txt4
//
this.txt4.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dataSet21, "帳單明細.入住單號"));
this.txt4.Location = new System.Drawing.Point(96, 32);
this.txt4.Name = "txt4";
this.txt4.ReadOnly = true;
this.txt4.Size = new System.Drawing.Size(176, 21);
this.txt4.TabIndex = 1;
this.txt4.Text = "";
//
// txt5
//
this.txt5.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dataSet21, "帳單明細.消費金額"));
this.txt5.Location = new System.Drawing.Point(96, 80);
this.txt5.Name = "txt5";
this.txt5.ReadOnly = true;
this.txt5.Size = new System.Drawing.Size(176, 21);
this.txt5.TabIndex = 1;
this.txt5.Text = "";
//
// label5
//
this.label5.Location = new System.Drawing.Point(96, 64);
this.label5.Name = "label5";
this.label5.Size = new System.Drawing.Size(100, 16);
this.label5.TabIndex = 0;
this.label5.Text = "消費金額";
//
// txt6
//
this.txt6.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dataSet21, "帳單明細.備注"));
this.txt6.Location = new System.Drawing.Point(96, 128);
this.txt6.Name = "txt6";
this.txt6.ReadOnly = true;
this.txt6.Size = new System.Drawing.Size(464, 21);
this.txt6.TabIndex = 1;
this.txt6.Text = "";
//
// label6
//
this.label6.Location = new System.Drawing.Point(96, 112);
this.label6.Name = "label6";
this.label6.Size = new System.Drawing.Size(100, 16);
this.label6.TabIndex = 0;
this.label6.Text = "備注";
//
// label7
//
this.label7.Location = new System.Drawing.Point(352, 16);
this.label7.Name = "label7";
this.label7.Size = new System.Drawing.Size(100, 16);
this.label7.TabIndex = 0;
this.label7.Text = "消費時間";
//
// label8
//
this.label8.Location = new System.Drawing.Point(352, 64);
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -