📄 hotelarrival.cs
字号:
this.txt14.ReadOnly = true;
this.txt14.Size = new System.Drawing.Size(72, 21);
this.txt14.TabIndex = 65;
this.txt14.Text = "";
//
// label18
//
this.label18.Location = new System.Drawing.Point(208, 114);
this.label18.Name = "label18";
this.label18.Size = new System.Drawing.Size(64, 16);
this.label18.TabIndex = 47;
this.label18.Text = "单据状态";
//
// txt12
//
this.txt12.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dataSet21, "入住单.加床价格"));
this.txt12.Location = new System.Drawing.Point(24, 130);
this.txt12.Name = "txt12";
this.txt12.ReadOnly = true;
this.txt12.Size = new System.Drawing.Size(72, 21);
this.txt12.TabIndex = 60;
this.txt12.Text = "";
//
// txt15
//
this.txt15.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dataSet21, "入住单.业务员"));
this.txt15.Location = new System.Drawing.Point(408, 130);
this.txt15.Name = "txt15";
this.txt15.ReadOnly = true;
this.txt15.Size = new System.Drawing.Size(72, 21);
this.txt15.TabIndex = 55;
this.txt15.Text = "";
//
// label19
//
this.label19.Location = new System.Drawing.Point(400, 114);
this.label19.Name = "label19";
this.label19.Size = new System.Drawing.Size(56, 16);
this.label19.TabIndex = 44;
this.label19.Text = "业务员";
//
// txt16
//
this.txt16.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dataSet21, "入住单.操作员"));
this.txt16.Location = new System.Drawing.Point(496, 130);
this.txt16.Name = "txt16";
this.txt16.ReadOnly = true;
this.txt16.Size = new System.Drawing.Size(72, 21);
this.txt16.TabIndex = 58;
this.txt16.Text = "";
//
// label20
//
this.label20.Location = new System.Drawing.Point(496, 114);
this.label20.Name = "label20";
this.label20.Size = new System.Drawing.Size(56, 16);
this.label20.TabIndex = 36;
this.label20.Text = "操作员";
//
// label21
//
this.label21.Location = new System.Drawing.Point(584, 114);
this.label21.Name = "label21";
this.label21.Size = new System.Drawing.Size(56, 16);
this.label21.TabIndex = 38;
this.label21.Text = "会员编号";
//
// txt17
//
this.txt17.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dataSet21, "入住单.会员编号"));
this.txt17.Location = new System.Drawing.Point(584, 130);
this.txt17.Name = "txt17";
this.txt17.ReadOnly = true;
this.txt17.Size = new System.Drawing.Size(120, 21);
this.txt17.TabIndex = 59;
this.txt17.Text = "";
//
// label22
//
this.label22.Location = new System.Drawing.Point(24, 160);
this.label22.Name = "label22";
this.label22.Size = new System.Drawing.Size(56, 16);
this.label22.TabIndex = 48;
this.label22.Text = "预定公司";
//
// txt18
//
this.txt18.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dataSet21, "入住单.预定公司"));
this.txt18.Location = new System.Drawing.Point(24, 176);
this.txt18.Name = "txt18";
this.txt18.ReadOnly = true;
this.txt18.Size = new System.Drawing.Size(144, 21);
this.txt18.TabIndex = 56;
this.txt18.Text = "";
//
// txt20
//
this.txt20.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dataSet21, "入住单.备注"));
this.txt20.Location = new System.Drawing.Point(24, 218);
this.txt20.Name = "txt20";
this.txt20.ReadOnly = true;
this.txt20.Size = new System.Drawing.Size(680, 21);
this.txt20.TabIndex = 57;
this.txt20.Text = "";
//
// label23
//
this.label23.Location = new System.Drawing.Point(24, 202);
this.label23.Name = "label23";
this.label23.Size = new System.Drawing.Size(32, 16);
this.label23.TabIndex = 49;
this.label23.Text = "备注";
//
// cmb4
//
this.cmb4.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dataSet21, "入住单.电话等级"));
this.cmb4.Enabled = false;
this.cmb4.Items.AddRange(new object[] {
"不开通",
"市话",
"国内长途",
"国际长途"});
this.cmb4.Location = new System.Drawing.Point(303, 130);
this.cmb4.Name = "cmb4";
this.cmb4.Size = new System.Drawing.Size(80, 20);
this.cmb4.TabIndex = 68;
//
// label24
//
this.label24.Location = new System.Drawing.Point(504, 160);
this.label24.Name = "label24";
this.label24.Size = new System.Drawing.Size(88, 16);
this.label24.TabIndex = 48;
this.label24.Text = "从预定单导入";
//
// txt19
//
this.txt19.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.dataSet21, "入住单.预定单号"));
this.txt19.Location = new System.Drawing.Point(504, 176);
this.txt19.Name = "txt19";
this.txt19.ReadOnly = true;
this.txt19.Size = new System.Drawing.Size(168, 21);
this.txt19.TabIndex = 56;
this.txt19.Text = "";
//
// btnImport
//
this.btnImport.Enabled = false;
this.btnImport.Image = ((System.Drawing.Image)(resources.GetObject("btnImport.Image")));
this.btnImport.Location = new System.Drawing.Point(680, 173);
this.btnImport.Name = "btnImport";
this.btnImport.Size = new System.Drawing.Size(24, 24);
this.btnImport.TabIndex = 72;
this.btnImport.Click += new System.EventHandler(this.btnImport_Click);
this.btnImport.MouseUp += new System.Windows.Forms.MouseEventHandler(this.btnImport_MouseUp);
//
// sqlSelectCommand1
//
this.sqlSelectCommand1.CommandText = @"SELECT 入住单号, 预定单号, 会员编号, 客房类型, 抵店时间, 离店时间, 单据状态, 入住人数, 客房编号, 客房价格, 入住价格, 折扣, 折扣原因, 是否加床, 加床价格, 预收款, 预定人, 预定公司, 联系电话, 备注, 操作员, 业务员, 早餐, 叫醒, 保密, vip, 电话等级, 特要说明, 应收帐款, 是否结帐, 结帐金额, 结帐日期, 付款方式 FROM 入住单 WHERE (入住单号 LIKE @Param4) AND (客房编号 LIKE @Param5) AND (抵店时间 LIKE @Param6)";
this.sqlSelectCommand1.Connection = this.sqlConnection1;
this.sqlSelectCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Param4", System.Data.SqlDbType.VarChar, 36, "入住单号"));
this.sqlSelectCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Param5", System.Data.SqlDbType.VarChar, 12, "客房编号"));
this.sqlSelectCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Param6", System.Data.SqlDbType.VarChar, 4, "抵店时间"));
//
// sqlConnection1
//
this.sqlConnection1.ConnectionString = "workstation id=localhost;Integrated Security=SSPI;Database=hotelbook;";
//
// sqlInsertCommand1
//
this.sqlInsertCommand1.CommandText = @"INSERT INTO 入住单(入住单号, 预定单号, 会员编号, 客房类型, 抵店时间, 离店时间, 单据状态, 入住人数, 客房编号, 客房价格, 入住价格, 折扣, 折扣原因, 是否加床, 加床价格, 预收款, 预定人, 预定公司, 联系电话, 备注, 操作员, 业务员, 早餐, 叫醒, 保密, vip, 电话等级, 特要说明, 应收帐款, 是否结帐, 结帐金额, 结帐日期, 付款方式) VALUES (@入住单号, @预定单号, @会员编号, @客房类型, @抵店时间, @离店时间, @单据状态, @入住人数, @客房编号, @客房价格, @入住价格, @折扣, @折扣原因, @是否加床, @加床价格, @预收款, @预定人, @预定公司, @联系电话, @备注, @操作员, @业务员, @早餐, @叫醒, @保密, @vip, @电话等级, @特要说明, @应收帐款, @是否结帐, @结帐金额, @结帐日期, @付款方式); SELECT 入住单号, 预定单号, 会员编号, 客房类型, 抵店时间, 离店时间, 单据状态, 入住人数, 客房编号, 客房价格, 入住价格, 折扣, 折扣原因, 是否加床, 加床价格, 预收款, 预定人, 预定公司, 联系电话, 备注, 操作员, 业务员, 早餐, 叫醒, 保密, vip, 电话等级, 特要说明, 应收帐款, 是否结帐, 结帐金额, 结帐日期, 付款方式 FROM 入住单 WHERE (入住单号 = @入住单号)";
this.sqlInsertCommand1.Connection = this.sqlConnection1;
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@入住单号", System.Data.SqlDbType.VarChar, 36, "入住单号"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@预定单号", System.Data.SqlDbType.VarChar, 36, "预定单号"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@会员编号", System.Data.SqlDbType.Int, 4, "会员编号"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@客房类型", System.Data.SqlDbType.VarChar, 4, "客房类型"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@抵店时间", System.Data.SqlDbType.DateTime, 4, "抵店时间"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@离店时间", System.Data.SqlDbType.DateTime, 4, "离店时间"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@单据状态", System.Data.SqlDbType.VarChar, 20, "单据状态"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@入住人数", System.Data.SqlDbType.Int, 4, "入住人数"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@客房编号", System.Data.SqlDbType.VarChar, 12, "客房编号"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@客房价格", System.Data.SqlDbType.Money, 8, "客房价格"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@入住价格", System.Data.SqlDbType.Money, 8, "入住价格"));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@折扣", System.Data.SqlDbType.Decimal, 5, System.Data.ParameterDirection.Input, false, ((System.Byte)(4)), ((System.Byte)(2)), "折扣", System.Data.DataRowVersion.Current, null));
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -