c#中山火炬开发区cast( (case whe...

来源：蜘蛛抓取(WebSpider) 时间：2011-09-22 03:51 标签： 中山火炬开发区
抱歉，您访问我们网站速度过快，我们已经禁止您访问我们的站点，请30分钟以后再尝试访问我们站点。hibernate使用case when 语句报错
[问题点数：100分，结帖人zfz1214]
hibernate使用case when 语句报错
[问题点数：100分，结帖人zfz1214]
不显示删除回复
显示所有回复
显示星级回复
显示得分回复
只显示楼主
相关帖子推荐：
本帖子已过去太久远了，不再提供回复功能。CodeFans.net.url
ClientDataManage.resx
CrystalReport.resx
CrystalReport1.rpt
DataGridComboBoxColumn.resx
DataGridNoActiveCellColumn.resx
DataSet1.xsx
DataSet2.xsd
LoginFrm.resx
MainFrm.resx
PopedomManage.resx
SelectStorage.resx
SellTable.resx
StockTable.resx
StokerDataManage.resx
StorageSearch.resx
WareDataManage.resx
{5FBCA18-A8D9-CD}.rpt
进销存管理系统.csproj
进销存管理系统.csproj.user
进销存管理系统.sln
jxcbook.bak
jxcbook_Data.MDF
jxcbook_Log.LDF
进销存管理.sql
CodeFans.net.url
上记录.bmp
下记录.bmp
尾记录.bmp
查询选择.bmp
首记录.bmp
AmendStafferInfo.resx
DataGridNoActiveCellColumn.resx
DataSet1.xsd
DataSet1.xsx
DataSet11.xsd
DataSet2.xsd
DataSet2.xsx
HortationManage.resx
IncomeTax.resx
LookupStafferInfo.resx
MainFrm.resx
OrgInfo.resx
PayoffHistory.resx
PunishmentManage.resx
SalaryManage.resx
SetOrgInfo.resx
人力资源管理系统.csproj
人力资源管理系统.csproj.user
人力资源管理系统.sln
hrmbook.bak
hrmbook.mdf
hrmbook_log.ldf
人力资源管理.sql
人力资源管理实例程序.sql
CodeFans.net.url
上记录.bmp
下记录.bmp
尾记录.bmp
查询选择.bmp
首记录.bmp
生产管理系统
BomForm.resx
DataSet1.xsd
DataSet1.xsx
DataSet2.xsd
DataSet2.xsx
DataSet3.xsd
FactorySchedule.resx
Form1.resx
MainForm.resx
MaterialsForm.resx
MRPCal.resx
MRPHistory.resx
ProducePlan.resx
RequirePlan.resx
SelectMaterial.resx
生产管理系统.csproj
生产管理系统.csproj.user
生产管理系统.sln
mrpbook.bak
mrpbook_Data.MDF
mrpbook_Log.LDF
生产管理系统.sql
生产管理系统实例程序.sql
CodeFans.net.url
上记录.bmp
下记录.bmp
启用帐簿.bmp
尾记录.bmp
建立新帐簿.bmp
查询选择.bmp
试算平衡.bmp
首记录.bmp
财务管理系统
AccountSetting.resx
CrystalReport1.rpt
DataSet1.xsd
DataSet1.xsx
DataSet2.xsd
DataSet2.xsx
DetailQuery.resx
FinancialReport.resx
LedgerQuery.resx
MainForm.resx
SelectSubject.resx
SubjectSetting.resx
TrialBalance.resx
WarrentInput.resx
财务管理系统.csproj
财务管理系统.csproj.user
财务管理系统.sln
caiwubook.bak
caiwubook_Data.MDF
caiwubook_Log.LDF
财务管理系统.sql
财务管理系统实例程序.sql
CodeFans.net.url
上记录.bmp
下记录.bmp
尾记录.bmp
查询选择.bmp
首记录.bmp
图书馆管理系统
BookBorrow.resx
BookClassify.resx
BookInfo.resx
BookPenalty.resx
BookReturn.resx
BookSubscribe.resx
DataSet1.xsd
DataSet1.xsx
DataSet2.xsd
MainFrm.resx
OverdueBook.resx
ReaderClassfiy.resx
ReaderClassify.resx
ReaderInfo.resx
SelectBook.resx
图书馆管理系统.csproj
图书馆管理系统.csproj.user
图书馆管理系统.sln
libbook.bak
libbook.mdf
libbook_log.ldf
图书馆管理系统.sql
房态之住房.bmp
房态之将到.bmp
房态之将离.bmp
房态之空房.bmp
房态之维修房.bmp
房态之自用房.bmp
CodeFans.net.url
上记录.bmp
下记录.bmp
尾记录.bmp
查询选择.bmp
首记录.bmp
酒店管理系统
ClientConsume.resx
DataSet1.xsd
DataSet1.xsx
DataSet2.xsd
DataSet2.xsx
HotelArrival.resx
HotelLeave.resx
HotelReserve.resx
MainForm.resx
ParentForm.resx
RoomInfo.resx
RoomStatus.resx
RoomType.resx
SelectTable.resx
酒店管理系统.csproj
酒店管理系统.csproj.user
酒店管理系统.sln
CodeFans.net.url
hotelbook.bak
hotelbook_Data.MDF
hotelbook_Log.LDF
酒店管理系统.sql
酒店管理系统实例程序.sql
上记录.bmp
下记录.bmp
尾记录.bmp
查询选择.bmp
首记录.bmp
医院管理系统
ClinicCharge.resx
ClinicPriceConfirm.resx
ClinicReg.resx
DataSet1.xsd
DataSet2.xsd
DataSet2.xsx
DataSet3.xsd
InputBox.resx
MainFrm.resx
MedInfo.resx
ParentForm.resx
RegQuery.resx
SendMedicine.resx
ServiceInfo.resx
StoreQuery.resx
医院管理系统.csproj
医院管理系统.csproj.user
医院管理系统.sln
hisbook.bak
hisbook_Data.MDF
hisbook_Log.LDF
医院管理系统.sql
医院管理系统实例程序.sql
CodeFans.net.url
上记录.bmp
下记录.bmp
尾记录.bmp
查询选择.bmp
首记录.bmp
教务管理系统
ClassInfo.resx
CourseElect.resx
CourseInfo.resx
CrystalReport.resx
CrystalReport1.rpt
CurriculumSchedule.resx
DataSet1.xsd
DataSet2.xsd
MainForm.resx
ParentForm.resx
ScoreInput.resx
StudentInfo.resx
ViewScore.resx
教务管理系统.csproj
教务管理系统.csproj.user
教务管理系统.sln
CodeFans.net.url
eisbook.bak
eisbook_Data.MDF
eisbook_Log.LDF
教务管理系统.sql
教务管理系统实例程序.sql
程序运行所需文件
报表Setup.msi
autorun.inf
Readme.txt
tup_cd.bmp
using System.C
using System.D
using System.Windows.F
using System.D
using System.Data.SqlC
namespace 酒店管理系统
public class HotelReserve : 医院管理系统.ParentForm
public static string[] roomI//保存从房态图中返回的信息
private System.Data.SqlClient.SqlConnection sqlConnection1;
private 酒店管理系统.DataSet2 dataSet21;
private System.Data.SqlClient.SqlDataAdapter da2;
private System.Data.SqlClient.SqlCommand sqlSelectCommand2;
private System.Windows.Forms.TextBox txt4;
private System.Windows.Forms.Label label4;
private System.boBox cmb1;
private System.Windows.Forms.TextBox txt5;
private System.boBox cmb2;
private System.boBox cmb3;
private System.Windows.Forms.Label label5;
private System.Windows.Forms.Label label6;
private System.Windows.Forms.Label label8;
private System.Windows.Forms.Label label10;
private System.Windows.Forms.TextBox txt7;
private System.Windows.Forms.TextBox txt6;
private System.Windows.Forms.TextBox txt8;
private System.Windows.Forms.TextBox txt9;
private System.Windows.Forms.TextBox txt10;
private System.Windows.Forms.TextBox txt11;
private System.Windows.Forms.Label label9;
private System.Windows.Forms.Label label7;
private System.Windows.Forms.Label label11;
private System.Windows.Forms.Label label12;
private System.Windows.Forms.Label label13;
private System.Windows.Forms.Label label14;
private System.Windows.Forms.TextBox txt13;
private System.Windows.Forms.TextBox txt14;
private System.Windows.Forms.TextBox txt12;
private System.Windows.Forms.TextBox txt15;
private System.Windows.Forms.TextBox txt16;
private System.Windows.Forms.TextBox txt17;
private System.Windows.Forms.TextBox txt18;
private System.Windows.Forms.TextBox txt19;
private System.Windows.Forms.TextBox txt20;
private System.Windows.Forms.Label label15;
private System.Windows.Forms.Label label16;
private System.Windows.Forms.Label label17;
private System.Windows.Forms.Label label18;
private System.Windows.Forms.Label label19;
private System.Windows.Forms.Label label20;
private System.Windows.Forms.Label label21;
private System.Windows.Forms.Label label22;
private System.Windows.Forms.Label label23;
private System.Windows.Forms.CheckBox checkBox1;
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.Windows.Forms.Button btnR
ponentModel.IContainer components =
public HotelReserve()
// 该调用是 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(HotelReserve));
this.sqlConnection1 = new System.Data.SqlClient.SqlConnection();
this.dataSet21 = new 酒店管理系统.DataSet2();
this.da2 = new System.Data.SqlClient.SqlDataAdapter();
this.sqlSelectCommand2 = new System.Data.SqlClient.SqlCommand();
this.txt4 = new System.Windows.Forms.TextBox();
this.label4 = new System.Windows.Forms.Label();
this.cmb1 = new System.boBox();
this.txt5 = new System.Windows.Forms.TextBox();
this.cmb2 = new System.boBox();
this.cmb3 = new System.boBox();
this.label5 = new System.Windows.Forms.Label();
this.label6 = new System.Windows.Forms.Label();
this.label8 = new System.Windows.Forms.Label();
this.label10 = new System.Windows.Forms.Label();
this.txt7 = new System.Windows.Forms.TextBox();
this.txt6 = new System.Windows.Forms.TextBox();
this.txt8 = new System.Windows.Forms.TextBox();
this.txt9 = new System.Windows.Forms.TextBox();
this.txt10 = new System.Windows.Forms.TextBox();
this.txt11 = new System.Windows.Forms.TextBox();
this.label9 = new System.Windows.Forms.Label();
this.label7 = new System.Windows.Forms.Label();
this.label11 = new System.Windows.Forms.Label();
this.label12 = new System.Windows.Forms.Label();
this.label13 = new System.Windows.Forms.Label();
this.label14 = new System.Windows.Forms.Label();
this.txt13 = new System.Windows.Forms.TextBox();
this.txt14 = new System.Windows.Forms.TextBox();
this.txt12 = new System.Windows.Forms.TextBox();
this.txt15 = new System.Windows.Forms.TextBox();
this.txt16 = new System.Windows.Forms.TextBox();
this.txt17 = new System.Windows.Forms.TextBox();
this.txt18 = new System.Windows.Forms.TextBox();
this.txt19 = new System.Windows.Forms.TextBox();
this.txt20 = new System.Windows.Forms.TextBox();
this.label15 = new System.Windows.Forms.Label();
this.label16 = new System.Windows.Forms.Label();
this.label17 = new System.Windows.Forms.Label();
this.label18 = new System.Windows.Forms.Label();
this.label19 = new System.Windows.Forms.Label();
this.label20 = new System.Windows.Forms.Label();
this.label21 = new System.Windows.Forms.Label();
this.label22 = new System.Windows.Forms.Label();
this.label23 = new System.Windows.Forms.Label();
this.checkBox1 = new System.Windows.Forms.CheckBox();
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();
this.btnRoom = new System.Windows.Forms.Button();
((ponentModel.ISupportInitialize)(this.dataGrid1)).BeginInit();
this.groupBox2.SuspendLayout();
((ponentModel.ISupportInitialize)(this.dataSet21)).BeginInit();
this.SuspendLayout();
// groupBox1
this.groupBox1.Name = &groupBox1&;
this.txt2.Name = &txt2&;
this.label1.Name = &label1&;
this.label1.Text = &抵店时间&;
// btnSearch
this.btnSearch.Name = &btnSearch&;
this.btnSearch.Click += new System.EventHandler(this.btnSearch_Click);
this.txt1.Name = &txt1&;
this.label2.Name = &label2&;
this.label2.Text = &预定单号&;
this.txt3.Name = &txt3&;
this.label3.Name = &label3&;
this.label3.Text = &预定人&;
// toolBar1
this.toolBar1.Name = &toolBar1&;
this.toolBar1.Size = new System.Drawing.Size(728, 41);
this.toolBar1.ButtonClick += new System.Windows.Forms.ToolBarButtonClickEventHandler(this.toolBar1_ButtonClick);
// dataGrid1
this.dataGrid1.DataMember = &预定单&;
this.dataGrid1.DataSource = this.dataSet21;
this.dataGrid1.Name = &dataGrid1&;
this.dataGrid1.Size = new System.Drawing.Size(728, 216);
// groupBox2
this.groupBox2.Controls.Add(this.btnRoom);
this.groupBox2.Controls.Add(this.checkBox1);
this.groupBox2.Controls.Add(this.txt13);
this.groupBox2.Controls.Add(this.txt14);
this.groupBox2.Controls.Add(this.txt12);
this.groupBox2.Controls.Add(this.txt15);
this.groupBox2.Controls.Add(this.txt16);
this.groupBox2.Controls.Add(this.txt17);
this.groupBox2.Controls.Add(this.txt18);
this.groupBox2.Controls.Add(this.txt19);
this.groupBox2.Controls.Add(this.txt20);
this.groupBox2.Controls.Add(this.txt7);
this.groupBox2.Controls.Add(this.txt6);
this.groupBox2.Controls.Add(this.txt8);
this.groupBox2.Controls.Add(this.txt9);
this.groupBox2.Controls.Add(this.txt10);
this.groupBox2.Controls.Add(this.txt11);
this.groupBox2.Controls.Add(this.txt5);
this.groupBox2.Controls.Add(this.txt4);
this.groupBox2.Controls.Add(this.label15);
this.groupBox2.Controls.Add(this.label16);
this.groupBox2.Controls.Add(this.label17);
this.groupBox2.Controls.Add(this.label18);
this.groupBox2.Controls.Add(this.label19);
this.groupBox2.Controls.Add(this.label20);
this.groupBox2.Controls.Add(this.label21);
this.groupBox2.Controls.Add(this.label22);
this.groupBox2.Controls.Add(this.label23);
this.groupBox2.Controls.Add(this.label9);
this.groupBox2.Controls.Add(this.label7);
this.groupBox2.Controls.Add(this.label11);
this.groupBox2.Controls.Add(this.label12);
this.groupBox2.Controls.Add(this.label13);
this.groupBox2.Controls.Add(this.label14);
this.groupBox2.Controls.Add(this.cmb1);
this.groupBox2.Controls.Add(this.cmb2);
this.groupBox2.Controls.Add(this.cmb3);
this.groupBox2.Controls.Add(this.label5);
this.groupBox2.Controls.Add(this.label6);
this.groupBox2.Controls.Add(this.label8);
this.groupBox2.Controls.Add(this.label10);
this.groupBox2.Controls.Add(this.label4);
this.groupBox2.Location = new System.Drawing.Point(0, 320);
this.groupBox2.Name = &groupBox2&;
this.groupBox2.Size = new System.Drawing.Size(728, 192);
this.da1.DeleteCommand = this.sqlDeleteCommand1;
this.da1.InsertCommand = this.sqlInsertCommand1;
this.da1.SelectCommand = this.sqlSelectCommand1;
this.da1.TableMappings.AddRange(new mon.DataTableMapping[] {
new mon.DataTableMapping(&Table&, &预定单&, new mon.DataColumnMapping[] {
new mon.DataColumnMapping(&预定单号&, &预定单号&),
new mon.DataColumnMapping(&会员编号&, &会员编号&),
new mon.DataColumnMapping(&客房类型&, &客房类型&),
new mon.DataColumnMapping(&抵店时间&, &抵店时间&),
new mon.DataColumnMapping(&离店时间&, &离店时间&),
new mon.DataColumnMapping(&单据状态&, &单据状态&),
new mon.DataColumnMapping(&入住人数&, &入住人数&),
new mon.DataColumnMapping(&客房编号&, &客房编号&),
new mon.DataColumnMapping(&客房价格&, &客房价格&),
new mon.DataColumnMapping(&入住价格&, &入住价格&),
new mon.DataColumnMapping(&折扣&, &折扣&),
new mon.DataColumnMapping(&折扣原因&, &折扣原因&),
new mon.DataColumnMapping(&是否加床&, &是否加床&),
new mon.DataColumnMapping(&加床价格&, &加床价格&),
new mon.DataColumnMapping(&预收款&, &预收款&),
new mon.DataColumnMapping(&预定人&, &预定人&),
new mon.DataColumnMapping(&预定公司&, &预定公司&),
new mon.DataColumnMapping(&联系电话&, &联系电话&),
new mon.DataColumnMapping(&备注&, &备注&),
new mon.DataColumnMapping(&操作员&, &操作员&),
new mon.DataColumnMapping(&业务员&, &业务员&)})});
this.da1.UpdateCommand = this.sqlUpdateCommand1;
// sqlConnection1
this.sqlConnection1.ConnectionString = &workstation id=Integrated Security=SSPI;Database=&;
// dataSet21
this.dataSet21.DataSetName = &DataSet2&;
this.dataSet21.Locale = new System.Globalization.CultureInfo(&zh-CN&);
this.da2.SelectCommand = this.sqlSelectCommand2;
this.da2.TableMappings.AddRange(new mon.DataTableMapping[] {
new mon.DataTableMapping(&Table&, &客房类型&, new mon.DataColumnMapping[] {
new mon.DataColumnMapping(&类型编号&, &类型编号&),
new mon.DataColumnMapping(&类型名称&, &类型名称&)})});
// sqlSelectCommand2
mandText = &SELECT 类型编号, 类型名称 FROM 客房类型&;
this.sqlSelectCommand2.Connection = this.sqlConnection1;
this.txt4.DataBindings.Add(new System.Windows.Forms.Binding(&Text&, this.dataSet21, &预定单.预定单号&));
this.txt4.Location = new System.Drawing.Point(24, 32);
this.txt4.Name = &txt4&;
this.txt4.ReadOnly =
this.txt4.Size = new System.Drawing.Size(112, 21);
this.txt4.TabIndex = 97;
this.txt4.Text = &&;
this.label4.Location = new System.Drawing.Point(24, 16);
this.label4.Name = &label4&;
this.label4.Size = new System.Drawing.Size(100, 16);
this.label4.TabIndex = 96;
this.label4.Text = &预定单号&;
this.cmb1.DataBindings.Add(new System.Windows.Forms.Binding(&SelectedValue&, this.dataSet21, &预定单.客房类型&));
this.cmb1.DataSource = this.dataSet21;
this.cmb1.DisplayMember = &客房类型.类型名称&;
this.cmb1.Enabled =
this.cmb1.Location = new System.Drawing.Point(152, 32);
this.cmb1.Name = &cmb1&;
this.cmb1.Size = new System.Drawing.Size(112, 20);
this.cmb1.TabIndex = 118;
this.cmb1.ValueMember = &客房类型.类型编号&;
this.txt5.DataBindings.Add(new System.Windows.Forms.Binding(&Text&, this.dataSet21, &预定单.联系电话&));
this.txt5.Location = new System.Drawing.Point(568, 32);
this.txt5.Name = &txt5&;
this.txt5.ReadOnly =
this.txt5.Size = new System.Drawing.Size(136, 21);
this.txt5.TabIndex = 117;
this.txt5.Text = &&;
this.cmb2.DataBindings.Add(new System.Windows.Forms.Binding(&Text&, this.dataSet21, &预定单.抵店时间&));
this.cmb2.Enabled =
this.cmb2.Location = new System.Drawing.Point(280, 32);
this.cmb2.Name = &cmb2&;
this.cmb2.Size = new System.Drawing.Size(128, 20);
this.cmb2.TabIndex = 120;
this.cmb2.DropDown += new System.EventHandler(this.cmb2_DropDown);
this.cmb2.Leave += new System.EventHandler(this.cmb2_Leave);
this.cmb3.DataBindings.Add(new System.Windows.Forms.Binding(&Text&, this.dataSet21, &预定单.离店时间&));
this.cmb3.Enabled =
this.cmb3.Location = new System.Drawing.Point(424, 32);
this.cmb3.Name = &cmb3&;
this.cmb3.Size = new System.Drawing.Size(128, 20);
this.cmb3.TabIndex = 119;
this.cmb3.DropDown += new System.EventHandler(this.cmb3_DropDown);
this.cmb3.Leave += new System.EventHandler(this.cmb3_Leave);
this.label5.Location = new System.Drawing.Point(568, 16);
this.label5.Name = &label5&;
this.label5.Size = new System.Drawing.Size(100, 16);
this.label5.TabIndex = 113;
this.label5.Text = &联系电话&;
this.label6.Location = new System.Drawing.Point(152, 16);
this.label6.Name = &label6&;
this.label6.Size = new System.Drawing.Size(56, 16);
this.label6.TabIndex = 114;
this.label6.Text = &客房类型&;
this.label8.Location = new System.Drawing.Point(280, 16);
this.label8.Name = &label8&;
this.label8.Size = new System.Drawing.Size(100, 16);
this.label8.TabIndex = 115;
this.label8.Text = &抵店时间&;
// label10
this.label10.Location = new System.Drawing.Point(424, 16);
this.label10.Name = &label10&;
this.label10.Size = new System.Drawing.Size(100, 16);
this.label10.TabIndex = 116;
this.label10.Text = &离店时间&;
this.txt7.DataBindings.Add(new System.Windows.Forms.Binding(&Text&, this.dataSet21, &预定单.客房价格&));
this.txt7.Location = new System.Drawing.Point(128, 78);
this.txt7.Name = &txt7&;
this.txt7.ReadOnly =
this.txt7.Size = new System.Drawing.Size(72, 21);
this.txt7.TabIndex = 129;
this.txt7.Text = &&;
this.txt6.DataBindings.Add(new System.Windows.Forms.Binding(&Text&, this.dataSet21, &预定单.客房编号&));
this.txt6.Location = new System.Drawing.Point(24, 78);
this.txt6.Name = &txt6&;
this.txt6.ReadOnly =
this.txt6.Size = new System.Drawing.Size(64, 21);
this.txt6.TabIndex = 127;
this.txt6.Text = &&;
this.txt8.DataBindings.Add(new System.Windows.Forms.Binding(&Text&, this.dataSet21, &预定单.入住价格&));
this.txt8.Location = new System.Drawing.Point(216, 78);
this.txt8.Name = &txt8&;
this.txt8.ReadOnly =
this.txt8.Size = new System.Drawing.Size(72, 21);
this.txt8.TabIndex = 128;
this.txt8.Text = &&;
this.txt9.DataBindings.Add(new System.Windows.Forms.Binding(&Text&, this.dataSet21, &预定单.折扣&));
this.txt9.Location = new System.Drawing.Point(304, 78);
this.txt9.Name = &txt9&;
this.txt9.ReadOnly =
this.txt9.Size = new System.Drawing.Size(64, 21);
this.txt9.TabIndex = 130;
this.txt9.Text = &&;
this.txt10.DataBindings.Add(new System.Windows.Forms.Binding(&Text&, this.dataSet21, &预定单.折扣原因&));
this.txt10.Location = new System.Drawing.Point(392, 78);
this.txt10.Name = &txt10&;
this.txt10.ReadOnly =
this.txt10.Size = new System.Drawing.Size(128, 21);
this.txt10.TabIndex = 132;
this.txt10.Text = &&;
this.txt11.DataBindings.Add(new System.Windows.Forms.Binding(&Text&, this.dataSet21, &预定单.入住人数&));
this.txt11.Location = new System.Drawing.Point(544, 78);
this.txt11.Name = &txt11&;
this.txt11.ReadOnly =
this.txt11.Size = new System.Drawing.Size(48, 21);
this.txt11.TabIndex = 131;
this.txt11.Text = &&;
this.label9.Location = new System.Drawing.Point(24, 62);
this.label9.Name = &label9&;
this.label9.Size = new System.Drawing.Size(64, 16);
this.label9.TabIndex = 121;
this.label9.Text = &客房编号&;
this.label7.Location = new System.Drawing.Point(128, 62);
this.label7.Name = &label7&;
this.label7.Size = new System.Drawing.Size(64, 16);
this.label7.TabIndex = 123;
this.label7.Text = &客房价格&;
// label11
this.label11.Location = new System.Drawing.Point(208, 62);
this.label11.Name = &label11&;
this.label11.Size = new System.Drawing.Size(64, 16);
this.label11.TabIndex = 125;
this.label11.Text = &入住价格&;
// label12
this.label12.Location = new System.Drawing.Point(304, 62);
this.label12.Name = &label12&;
this.label12.Size = new System.Drawing.Size(40, 16);
this.label12.TabIndex = 124;
this.label12.Text = &折扣&;
// label13
this.label13.Location = new System.Drawing.Point(392, 62);
this.label13.Name = &label13&;
this.label13.Size = new System.Drawing.Size(100, 16);
this.label13.TabIndex = 122;
this.label13.Text = &折扣原因&;
// label14
this.label14.Location = new System.Drawing.Point(544, 62);
this.label14.Name = &label14&;
this.label14.Size = new System.Drawing.Size(56, 16);
this.label14.TabIndex = 126;
this.label14.Text = &入住人数&;
this.txt13.DataBindings.Add(new System.Windows.Forms.Binding(&Text&, this.dataSet21, &预定单.预收款&));
this.txt13.Location = new System.Drawing.Point(120, 120);
this.txt13.Name = &txt13&;
this.txt13.ReadOnly =
this.txt13.Size = new System.Drawing.Size(64, 21);
this.txt13.TabIndex = 164;
this.txt13.Text = &&;
this.txt14.DataBindings.Add(new System.Windows.Forms.Binding(&Text&, this.dataSet21, &预定单.单据状态&));
this.txt14.Location = new System.Drawing.Point(208, 120);
this.txt14.Name = &txt14&;
this.txt14.ReadOnly =
this.txt14.Size = new System.Drawing.Size(72, 21);
this.txt14.TabIndex = 165;
this.txt14.Text = &&;
this.txt12.DataBindings.Add(new System.Windows.Forms.Binding(&Text&, this.dataSet21, &预定单.加床价格&));
this.txt12.Location = new System.Drawing.Point(24, 120);
this.txt12.Name = &txt12&;
this.txt12.ReadOnly =
this.txt12.Size = new System.Drawing.Size(72, 21);
this.txt12.TabIndex = 162;
this.txt12.Text = &&;
this.txt15.DataBindings.Add(new System.Windows.Forms.Binding(&Text&, this.dataSet21, &预定单.预定人&));
this.txt15.Location = new System.Drawing.Point(304, 120);
this.txt15.Name = &txt15&;
this.txt15.ReadOnly =
this.txt15.Size = new System.Drawing.Size(72, 21);
this.txt15.TabIndex = 163;
this.txt15.Text = &&;
this.txt16.DataBindings.Add(new System.Windows.Forms.Binding(&Text&, this.dataSet21, &预定单.业务员&));
this.txt16.Location = new System.Drawing.Point(400, 120);
this.txt16.Name = &txt16&;
this.txt16.ReadOnly =
this.txt16.Size = new System.Drawing.Size(72, 21);
this.txt16.TabIndex = 166;
this.txt16.Text = &&;
this.txt17.DataBindings.Add(new System.Windows.Forms.Binding(&Text&, this.dataSet21, &预定单.操作员&));
this.txt17.Location = new System.Drawing.Point(496, 120);
this.txt17.Name = &txt17&;
this.txt17.ReadOnly =
this.txt17.Size = new System.Drawing.Size(72, 21);
this.txt17.TabIndex = 168;
this.txt17.Text = &&;
this.txt18.DataBindings.Add(new System.Windows.Forms.Binding(&Text&, this.dataSet21, &预定单.会员编号&));
this.txt18.Location = new System.Drawing.Point(584, 120);
this.txt18.Name = &txt18&;
this.txt18.ReadOnly =
this.txt18.Size = new System.Drawing.Size(120, 21);
this.txt18.TabIndex = 167;
this.txt18.Text = &&;
this.txt19.Location = new System.Drawing.Point(24, 168);
this.txt19.Name = &txt19&;
this.txt19.ReadOnly =
this.txt19.Size = new System.Drawing.Size(144, 21);
this.txt19.TabIndex = 160;
this.txt19.Text = &&;
this.txt20.Location = new System.Drawing.Point(200, 168);
this.txt20.Name = &txt20&;
this.txt20.ReadOnly =
this.txt20.Size = new System.Drawing.Size(504, 21);
this.txt20.TabIndex = 161;
this.txt20.Text = &&;
// label15
this.label15.Location = new System.Drawing.Point(304, 104);
this.label15.Name = &label15&;
this.label15.Size = new System.Drawing.Size(56, 16);
this.label15.TabIndex = 153;
this.label15.Text = &预定人&;
// label16
this.label16.Location = new System.Drawing.Point(120, 104);
this.label16.Name = &label16&;
this.label16.Size = new System.Drawing.Size(56, 16);
this.label16.TabIndex = 154;
this.label16.Text = &预收款&;
// label17
this.label17.Location = new System.Drawing.Point(24, 104);
this.label17.Name = &label17&;
this.label17.Size = new System.Drawing.Size(64, 16);
this.label17.TabIndex = 151;
this.label17.Text = &加床价格&;
// label18
this.label18.Location = new System.Drawing.Point(208, 104);
this.label18.Name = &label18&;
this.label18.Size = new System.Drawing.Size(64, 16);
this.label18.TabIndex = 152;
this.label18.Text = &单据状态&;
// label19
this.label19.Location = new System.Drawing.Point(400, 104);
this.label19.Name = &label19&;
this.label19.Size = new System.Drawing.Size(56, 16);
this.label19.TabIndex = 155;
this.label19.Text = &业务员&;
// label20
this.label20.Location = new System.Drawing.Point(496, 104);
this.label20.Name = &label20&;
this.label20.Size = new System.Drawing.Size(56, 16);
this.label20.TabIndex = 158;
this.label20.Text = &操作员&;
// label21
this.label21.Location = new System.Drawing.Point(584, 104);
this.label21.Name = &label21&;
this.label21.Size = new System.Drawing.Size(56, 16);
this.label21.TabIndex = 159;
this.label21.Text = &会员编号&;
// label22
this.label22.Location = new System.Drawing.Point(24, 152);
this.label22.Name = &label22&;
this.label22.Size = new System.Drawing.Size(56, 16);
this.label22.TabIndex = 157;
this.label22.Text = &预定公司&;
// label23
this.label23.Location = new System.Drawing.Point(200, 152);
this.label23.Name = &label23&;
this.label23.Size = new System.Drawing.Size(56, 16);
this.label23.TabIndex = 156;
this.label23.Text = &备注&;
// checkBox1
this.checkBox1.DataBindings.Add(new System.Windows.Forms.Binding(&Checked&, this.dataSet21, &预定单.是否加床&));
this.checkBox1.Enabled =
this.checkBox1.Location = new System.Drawing.Point(616, 72);
this.checkBox1.Name = &checkBox1&;
this.checkBox1.Size = new System.Drawing.Size(80, 24);
this.checkBox1.TabIndex = 169;
this.checkBox1.Text = &是否加床&;
this.calen1.Location = new System.Drawing.Point(328, 192);
this.calen1.Name = &calen1&;
this.calen1.TabIndex = 33;
this.calen1.Visible =
this.calen1.DateSelected += new System.Windows.Forms.DateRangeEventHandler(this.calen1_DateSelected);
// sqlSelectCommand1
mandText = &SELECT 预定单号, 会员编号, 客房类型, 抵店时间, 离店时间, 单据状态, 入住人数, 客房编号, 客房价格, 入住价格, 折扣, 折扣原因, 是否加床& +
&, 加床价格, 预收款, 预定人, 预定公司, 联系电话, 备注, 操作员, 业务员 FROM 预定单 WHERE (预定单号 LIKE @Param4) AN& +
&D (抵店时间 LIKE @Param5) AND (预定人 LIKE @Param6 OR 预定人 IS NULL)&;
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, 10, &抵店时间&));
this.sqlSelectCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter(&@Param6&, System.Data.SqlDbType.VarChar, 20, &预定人&));
// sqlInsertCommand1
mandText = @&INSERT INTO 预定单(预定单号, 会员编号, 客房类型, 抵店时间, 离店时间, 单据状态, 入住人数, 客房编号, 客房价格, 入住价格, 折扣, 折扣原因, 是否加床, 加床价格, 预收款, 预定人, 预定公司, 联系电话, 备注, 操作员, 业务员) VALUES (@预定单号, @会员编号, @客房类型, @抵店时间, @离店时间, @单据状态, @入住人数, @客房编号, @客房价格, @入住价格, @折扣, @折扣原因, @是否加床, @加床价格, @预收款, @预定人, @预定公司, @联系电话, @备注, @操作员, @业务员); SELECT 预定单号, 会员编号, 客房类型, 抵店时间, 离店时间, 单据状态, 入住人数, 客房编号, 客房价格, 入住价格, 折扣, 折扣原因, 是否加床, 加床价格, 预收款, 预定人, 预定公司, 联系电话, 备注, 操作员, 业务员 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.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));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter(&@折扣原因&, System.Data.SqlDbType.VarChar, 60, &折扣原因&));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter(&@是否加床&, System.Data.SqlDbType.Bit, 1, &是否加床&));
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.VarChar, 20, &预定人&));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter(&@预定公司&, System.Data.SqlDbType.VarChar, 60, &预定公司&));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter(&@联系电话&, System.Data.SqlDbType.VarChar, 40, &联系电话&));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter(&@备注&, System.Data.SqlDbType.VarChar, 510, &备注&));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter(&@操作员&, System.Data.SqlDbType.VarChar, 10, &操作员&));
this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter(&@业务员&, System.Data.SqlDbType.VarChar, 50, &业务员&));
// sqlUpdateCommand1
mandText = &UPDATE 预定单 SET 预定单号 = @预定单号, 会员编号 = @会员编号, 客房类型 = @客房类型, 抵店时间 = @抵店时间, 离店时间 = @离店& +
&时间, 单据状态 = @单据状态, 入住人数 = @入住人数, 客房编号 = @客房编号, 客房价格 = @客房价格, 入住价格 = @入住价格, 折扣 = @& +
&折扣, 折扣原因 = @折扣原因, 是否加床 = @是否加床, 加床价格 = @加床价格, 预收款 = @预收款, 预定人 = @预定人, 预定公司 = @预定& +
&公司, 联系电话 = @联系电话, 备注 = @备注, 操作员 = @操作员, 业务员 = @业务员 WHERE (预定单号 = @Original_预定单号)& +
& AND (业务员 = @Original_业务员 OR @Original_业务员 IS NULL AND 业务员 IS NULL) AND (会员编号 = & +
&@Original_会员编号 OR @Original_会员编号 IS NULL AND 会员编号 IS NULL) AND (入住人数 = @Original& +
&_入住人数 OR @Original_入住人数 IS NULL AND 入住人数 IS NULL) AND (入住价格 = @Original_入住价格 OR & +
&@Original_入住价格 IS NULL AND 入住价格 IS NULL) AND (加床价格 = @Original_加床价格 OR @Original& +
&_加床价格 IS NULL AND 加床价格 IS NULL) AND (单据状态 = @Original_单据状态 OR @Original_单据状态 IS & +
&NULL AND 单据状态 IS NULL) AND (备注 = @Original_备注 OR @Original_备注 IS NULL AND 备注 IS & +
&NULL) AND (客房价格 = @Original_客房价格 OR @Original_客房价格 IS NULL AND 客房价格 IS NULL) AND& +
& (客房类型 = @Original_客房类型) AND (客房编号 = @Original_客房编号 OR @Original_客房编号 IS NULL AN& +
&D 客房编号 IS NULL) AND (折扣 = @Original_折扣 OR @Original_折扣 IS NULL AND 折扣 IS NULL) A& +
&ND (折扣原因 = @Original_折扣原因 OR @Original_折扣原因 IS NULL AND 折扣原因 IS NULL) AND (抵店时间 & +
&= @Original_抵店时间) AND (操作员 = @Original_操作员 OR @Original_操作员 IS NULL AND 操作员 IS N& +
&ULL) AND (是否加床 = @Original_是否加床 OR @Original_是否加床 IS NULL AND 是否加床 IS NULL) AND & +
&(离店时间 = @Original_离店时间 OR @Original_离店时间 IS NULL AND 离店时间 IS NULL) AND (联系电话 = @& +
&Original_联系电话 OR @Original_联系电话 IS NULL AND 联系电话 IS NULL) AND (预定人 = @Original_预& +
&定人 OR @Original_预定人 IS NULL AND 预定人 IS NULL) AND (预定公司 = @Original_预定公司 OR @Orig& +
&inal_预定公司 IS NULL AND 预定公司 IS NULL) AND (预收款 = @Original_预收款 OR @Original_预收款 IS& +
& NULL AND 预收款 IS NULL); SELECT 预定单号, 会员编号, 客房类型, 抵店时间, 离店时间, 单据状态, 入住人数, 客房编号, 客& +
&房价格, 入住价格, 折扣, 折扣原因, 是否加床, 加床价格, 预收款, 预定人, 预定公司, 联系电话, 备注, 操作员, 业务员 FROM 预定单 WHE& +
&RE (预定单号 = @预定单号)&;
this.sqlUpdateCommand1.Connection = this.sqlConnection1;
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter(&@预定单号&, System.Data.SqlDbType.VarChar, 36, &预定单号&));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter(&@会员编号&, System.Data.SqlDbType.Int, 4, &会员编号&));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter(&@客房类型&, System.Data.SqlDbType.VarChar, 4, &客房类型&));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter(&@抵店时间&, System.Data.SqlDbType.DateTime, 4, &抵店时间&));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter(&@离店时间&, System.Data.SqlDbType.DateTime, 4, &离店时间&));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter(&@单据状态&, System.Data.SqlDbType.VarChar, 20, &单据状态&));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter(&@入住人数&, System.Data.SqlDbType.Int, 4, &入住人数&));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter(&@客房编号&, System.Data.SqlDbType.VarChar, 12, &客房编号&));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter(&@客房价格&, System.Data.SqlDbType.Money, 8, &客房价格&));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter(&@入住价格&, System.Data.SqlDbType.Money, 8, &入住价格&));
this.sqlUpdateCommand1.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));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter(&@折扣原因&, System.Data.SqlDbType.VarChar, 60, &折扣原因&));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter(&@是否加床&, System.Data.SqlDbType.Bit, 1, &是否加床&));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter(&@加床价格&, System.Data.SqlDbType.Money, 8, &加床价格&));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter(&@预收款&, System.Data.SqlDbType.Money, 8, &预收款&));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter(&@预定人&, System.Data.SqlDbType.VarChar, 20, &预定人&));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter(&@预定公司&, System.Data.SqlDbType.VarChar, 60, &预定公司&));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter(&@联系电话&, System.Data.SqlDbType.VarChar, 40, &联系电话&));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter(&@备注&, System.Data.SqlDbType.VarChar, 510, &备注&));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter(&@操作员&, System.Data.SqlDbType.VarChar, 10, &操作员&));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter(&@业务员&, System.Data.SqlDbType.VarChar, 50, &业务员&));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter(&@Original_预定单号&, System.Data.SqlDbType.VarChar, 36, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), &预定单号&, System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter(&@Original_业务员&, System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), &业务员&, System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter(&@Original_会员编号&, System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), &会员编号&, System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter(&@Original_入住人数&, System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), &入住人数&, System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter(&@Original_入住价格&, System.Data.SqlDbType.Money, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), &入住价格&, System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter(&@Original_加床价格&, System.Data.SqlDbType.Money, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), &加床价格&, System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter(&@Original_单据状态&, System.Data.SqlDbType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), &单据状态&, System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter(&@Original_备注&, System.Data.SqlDbType.VarChar, 510, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), &备注&, System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter(&@Original_客房价格&, System.Data.SqlDbType.Money, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), &客房价格&, System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter(&@Original_客房类型&, System.Data.SqlDbType.VarChar, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), &客房类型&, System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter(&@Original_客房编号&, System.Data.SqlDbType.VarChar, 12, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), &客房编号&, System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter(&@Original_折扣&, System.Data.SqlDbType.Decimal, 5, System.Data.ParameterDirection.Input, false, ((System.Byte)(4)), ((System.Byte)(2)), &折扣&, System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter(&@Original_折扣原因&, System.Data.SqlDbType.VarChar, 60, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), &折扣原因&, System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter(&@Original_抵店时间&, System.Data.SqlDbType.DateTime, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), &抵店时间&, System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter(&@Original_操作员&, System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), &操作员&, System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter(&@Original_是否加床&, System.Data.SqlDbType.Bit, 1, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), &是否加床&, System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter(&@Original_离店时间&, System.Data.SqlDbType.DateTime, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), &离店时间&, System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter(&@Original_联系电话&, System.Data.SqlDbType.VarChar, 40, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), &联系电话&, System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter(&@Original_预定人&, System.Data.SqlDbType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), &预定人&, System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter(&@Original_预定公司&, System.Data.SqlDbType.VarChar, 60, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), &预定公司&, System.Data.DataRowVersion.Original, null));
this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter(&@Original_预收款&, System.Data.SqlDbType.Money, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), &预收款&, System.Data.DataRowVersion.Original, null));
// sqlDeleteCommand1
mandText = @&DELETE FROM 预定单 WHERE (预定单号 = @Original_预定单号) AND (业务员 = @Original_业务员 OR @Original_业务员 IS NULL AND 业务员 IS NULL) AND (会员编号 = @Original_会员编号 OR @Original_会员编号 IS NULL AND 会员编号 IS NULL) AND (入住人数 = @Original_入住人数 OR @Original_入住人数 IS NULL AND 入住人数 IS NULL) AND (入住价格 = @Original_入住价格 OR @Original_入住价格 IS NULL AND 入住价格 IS NULL) AND (加床价格 = @Original_加床价格 OR @Original_加床价格 IS NULL AND 加床价格 IS NULL) AND (单据状态 = @Original_单据状态 OR @Original_单据状态 IS NULL AND 单据状态 IS NULL) AND (备注 = @Original_备注 OR @Original_备注 IS NULL AND 备注 IS NULL) AND (客房价格 = @Original_客房价格 OR @Original_客房价格 IS NULL AND 客房价格 IS NULL) AND (客房类型 = @Original_客房类型) AND (客房编号 = @Original_客房编号 OR @Original_客房编号 IS NULL AND 客房编号 IS NULL) AND (折扣 = @Original_折扣 OR @Original_折扣 IS NULL AND 折扣 IS NULL) AND (折扣原因 = @Original_折扣原因 OR @Original_折扣原因 IS NULL AND 折扣原因 IS NULL) AND (抵店时间 = @Original_抵店时间) AND (操作员 = @Original_操作员 OR @Original_操作员 IS NULL AND 操作员 IS NULL) AND (是否加床 = @Original_是否加床 OR @Original_是否加床 IS NULL AND 是否加床 IS NULL) AND (离店时间 = @Original_离店时间 OR @Original_离店时间 IS NULL AND 离店时间 IS NULL) AND (联系电话 = @Original_联系电话 OR @Original_联系电话 IS NULL AND 联系电话 IS NULL) AND (预定人 = @Original_预定人 OR @Original_预定人 IS NULL AND 预定人 IS NULL) AND (预定公司 = @Original_预定公司 OR @Original_预定公司 IS NULL AND 预定公司 IS NULL) AND (预收款 = @Original_预收款 OR @Original_预收款 IS NULL AND 预收款 IS NULL)&;
this.sqlDeleteCommand1.Connection = this.sqlConnection1;
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter(&@Original_预定单号&, System.Data.SqlDbType.VarChar, 36, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), &预定单号&, System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter(&@Original_业务员&, System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), &业务员&, System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter(&@Original_会员编号&, System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), &会员编号&, System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter(&@Original_入住人数&, System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), &入住人数&, System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter(&@Original_入住价格&, System.Data.SqlDbType.Money, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), &入住价格&, System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter(&@Original_加床价格&, System.Data.SqlDbType.Money, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), &加床价格&, System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter(&@Original_单据状态&, System.Data.SqlDbType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), &单据状态&, System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter(&@Original_备注&, System.Data.SqlDbType.VarChar, 510, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), &备注&, System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter(&@Original_客房价格&, System.Data.SqlDbType.Money, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), &客房价格&, System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter(&@Original_客房类型&, System.Data.SqlDbType.VarChar, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), &客房类型&, System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter(&@Original_客房编号&, System.Data.SqlDbType.VarChar, 12, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), &客房编号&, System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter(&@Original_折扣&, System.Data.SqlDbType.Decimal, 5, System.Data.ParameterDirection.Input, false, ((System.Byte)(4)), ((System.Byte)(2)), &折扣&, System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter(&@Original_折扣原因&, System.Data.SqlDbType.VarChar, 60, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), &折扣原因&, System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter(&@Original_抵店时间&, System.Data.SqlDbType.DateTime, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), &抵店时间&, System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter(&@Original_操作员&, System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), &操作员&, System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter(&@Original_是否加床&, System.Data.SqlDbType.Bit, 1, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), &是否加床&, System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter(&@Original_离店时间&, System.Data.SqlDbType.DateTime, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), &离店时间&, System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter(&@Original_联系电话&, System.Data.SqlDbType.VarChar, 40, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), &联系电话&, System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter(&@Original_预定人&, System.Data.SqlDbType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), &预定人&, System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter(&@Original_预定公司&, System.Data.SqlDbType.VarChar, 60, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), &预定公司&, System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter(&@Original_预收款&, System.Data.SqlDbType.Money, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), &预收款&, System.Data.DataRowVersion.Original, null));
// btnRoom
this.btnRoom.Enabled =
this.btnRoom.Image = ((System.Drawing.Image)(resources.GetObject(&btnRoom.Image&)));
this.btnRoom.Location = new System.Drawing.Point(96, 78);
this.btnRoom.Name = &btnRoom&;
this.btnRoom.Size = new System.Drawing.Size(24, 24);
this.btnRoom.TabIndex = 170;
this.btnRoom.Click += new System.EventHandler(this.btnRoom_Click);
this.btnRoom.MouseUp += new System.Windows.Forms.MouseEventHandler(this.btnRoom_MouseUp);
// HotelReserve
this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
this.ClientSize = new System.Drawing.Size(728, 517);
this.Controls.Add(this.calen1);
this.Name = &HotelReserve&;
this.Text = &【客房预定】&;
this.Load += new System.EventHandler(this.HotelReserve_Load);
this.Controls.SetChildIndex(this.groupBox1, 0);
this.Controls.SetChildIndex(this.toolBar1, 0);
this.Controls.SetChildIndex(this.dataGrid1, 0);
this.Controls.SetChildIndex(this.groupBox2, 0);
this.Controls.SetChildIndex(this.calen1, 0);
((ponentModel.ISupportInitialize)(this.dataGrid1)).EndInit();
this.groupBox2.ResumeLayout(false);
((ponentModel.ISupportInitialize)(this.dataSet21)).EndInit();
this.ResumeLayout(false);
#endregion
//----------创建窗体时，读入数据并完成数据控件连接---------
private void HotelReserve_Load(object sender, System.EventArgs e)
//填充数据集
da2.Fill(dataSet21);
da1.SelectCommand.Parameters[0].Value=&%&;
da1.SelectCommand.Parameters[1].SqlDbType=SqlDbType.VarC
da1.SelectCommand.Parameters[1].Value=&%&;
da1.SelectCommand.Parameters[2].SqlDbType=SqlDbType.VarC
da1.SelectCommand.Parameters[2].Value=&%&;
da1.Fill(dataSet21);//填充客房预定信息
base.dataSet11=this.dataSet21;
this.cmOrders=(CurrencyManager) BindingContext[dataSet21,&预定单&];
//----------重写设置控件只读属性函数----------
protected override void SetModifyMode(bool blnEdit)
base.SetModifyMode (blnEdit);
txt4.ReadOnly=!blnE
txt5.ReadOnly=!blnE
txt6.ReadOnly=!blnE
txt8.ReadOnly=!blnE
txt9.ReadOnly=!blnE
txt10.ReadOnly=!blnE
txt11.ReadOnly=!blnE
txt12.ReadOnly=!blnE
txt13.ReadOnly=!blnE
txt15.ReadOnly=!blnE
txt16.ReadOnly=!blnE
txt17.ReadOnly=!blnE
txt18.ReadOnly=!blnE
txt19.ReadOnly=!blnE
txt20.ReadOnly=!blnE
cmb2.Enabled=blnE
cmb3.Enabled=blnE
checkBox1.Enabled=blnE
btnRoom.Enabled=blnE
//-------重写新增记录时设置默认值函数--------
protected override void SetDefaultValue()
//base.SetDefaultValue();
txt14.Text=&预定&;//新增单据状态为预定
//自动计算新编号
string connStr=&workstation id=Integrated Security=SSPI;Database=&;
SqlConnection cn=new SqlConnection(connStr);
cn.Open();
SqlCommand cmd=cn.CreateCommand();
if(dataSet21.预定单.Rows.Count==0)
mandText=&select max(预定单号) 最大编号 from 预定单历史&;
mandText=&select max(预定单号) 最大编号 from 预定单&;
object result=cmd.ExecuteScalar();
int order=1;
if(result!=System.DBNull.Value)
string maxID=result.ToString().Trim();
maxID=maxID.Substring(2,maxID.Length-2);
order=Convert.ToInt16(maxID)+1;
int length=order.ToString().L
string newID=&&;
switch(length)
newID=&YD0000000&+order.ToString();
newID=&YD000000&+order.ToString();
newID=&YD00000&+order.ToString();
newID=&YD0000&+order.ToString();
newID=&YD000&+order.ToString();
newID=&YD00&+order.ToString();
newID=&YD0&+order.ToString();
txt4.Text=newID;//自动生成编号
cmb2.Text=System.DateTime.Now.Date.ToString();//抵店时间默认为当天
cmb3.Text=System.DateTime.Now.Date.AddDays(3).ToString();//离店时间为3天后
//-------重写检查非空字段函数--------
protected override bool CheckNotNull()
if(txt4.Text.Trim()==&&)// 检查预定编号
MessageBox.Show(&预定编号不能为空&,&提示&,MessageBoxButtons.OK,MessageBoxIcon.Stop);
return(false);
if(txt6.Text.Trim()==&&)//检查客房编号
MessageBox.Show(&请选择客房编号&,&提示&,MessageBoxButtons.OK,MessageBoxIcon.Stop);
return(false);
if(cmb2.Text.Trim()==&&)//检查抵店时间
MessageBox.Show(&请选择抵店时间&,&提示&,MessageBoxButtons.OK,MessageBoxIcon.Stop);
return(false);
return base.CheckNotNull ();
//-----显示和选择抵店日期和离店日期-----
private void cmb2_DropDown(object sender, System.EventArgs e)
selectDate(cmb2);
private void cmb3_DropDown(object sender, System.EventArgs e)
selectDate(cmb3);
//----------关闭日期控件的显示----------
private void cmb2_Leave(object sender, System.EventArgs e)
calen1.Visible=
private void cmb3_Leave(object sender, System.EventArgs e)
calen1.Visible=
//-----------单击下拉列表框下拉箭头时显示日期以供选择---------------
private void selectDate(ComboBox cb)
calen1.Left=cb.L//设置日期控件的位置
calen1.Top=cb.Top-calen1.Height-10+groupBox2.T
if(cb.Text.Trim()!=&&)
calen1.SelectionStart=Convert.ToDateTime(cb.Text);//日历显示的时间为数据时间
calen1.SelectionEnd=Convert.ToDateTime(cb.Text);
calen1.Visible=//显示日期
calen1.Show();
//-----------从日历控件中选择日期信息------------
private void calen1_DateSelected(object sender, System.Windows.Forms.DateRangeEventArgs e)
//判断是由哪个下拉列表框调出日历，以便回馈日期信息
if(calen1.Left==cmb2.Left)
cmb2.Text=calen1.SelectionEnd.ToString();
if(calen1.Left==cmb3.Left)
cmb3.Text=calen1.SelectionEnd.ToString();
//--------根据输入条件，搜索数据----------
private void btnSearch_Click(object sender, System.EventArgs e)
da1.SelectCommand.Parameters[0].Value=&%&;
da1.SelectCommand.Parameters[1].Value=&%&;
da1.SelectCommand.Parameters[2].Value=&%&;
if(txt1.Text.Trim()!=&&)
da1.SelectCommand.Parameters[0].Value=&%&+txt1.Text.Trim()+&%&;
if(txt2.Text.Trim()!=&&)
da1.SelectCommand.Parameters[1].Value=&%&+txt2.Text.Trim()+&%&;
if(txt3.Text.Trim()!=&&)
da1.SelectCommand.Parameters[2].Value=&%&+txt3.Text.Trim()+&%&;
dataSet21.Clear();//刷新数据集
da1.Fill(dataSet21);
//填充其他编号和名称数据
da2.Fill(dataSet21);
//----------显示房态图并选择房间---------
private void btnRoom_Click(object sender, System.EventArgs e)
RoomStatus newfrm=new RoomStatus(1);
newfrm.ShowDialog();
private void btnRoom_MouseUp(object sender, System.Windows.Forms.MouseEventArgs e)
if(roomInfo[0].Trim()==&&)
txt6.Text=roomInfo[0];//显示房间编号
cmb1.Text=roomInfo[1];//显示房间类型
string strConn=&workstation id=Integrated Security=SSPI;Database=&;
SqlConnection cn=new SqlConnection(strConn);
cn.Open();
SqlCommand cmd=cn.CreateCommand();
mandText=&SELECT 价格 FROM 客房类型 where 类型名称='&+cmb1.Text+&'&;
txt7.Text=cmd.ExecuteScalar().ToString().Trim();//读入该类型客房价格
txt8.Text=txt7.T//入住价格默认和客房价格一致
//---------保存预定单后更新房态-----------
private void toolBar1_ButtonClick(object sender, System.Windows.Forms.ToolBarButtonClickEventArgs e)
//在保存数据后再进行处理
if(e.Button.ToolTipText==&提交&)
//更新预定房间状态
string strConn=&workstation id=Integrated Security=SSPI;Database=&;
SqlConnection cn=new SqlConnection(strConn);
cn.Open();
SqlCommand cmd=cn.CreateCommand();
mandText=&update 客房信息 set 状态='将到' where 客房编号='&+txt6.Text+&'&;
cmd.ExecuteNonQuery();
Copyright(C)
OKBASE.NET All Rights Reserved 好库网 版权所有

我要回帖

更多关于 中山火炬开发区 的文章

 

随机推荐