📄 frmreside.cs
字号:
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("入住人数", "入住人数"),
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("加床价格", "加床价格"),
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("业务员", "业务员"),
new System.Data.Common.DataColumnMapping("早餐", "早餐"),
new System.Data.Common.DataColumnMapping("叫醒", "叫醒"),
new System.Data.Common.DataColumnMapping("保密", "保密"),
new System.Data.Common.DataColumnMapping("vip", "vip"),
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.sqlDataAdapter1.UpdateCommand = this.sqlUpdateCommand1;
//
// sqlDeleteCommand1
//
this.sqlDeleteCommand1.CommandText = "DELETE FROM 入住单 WHERE (入住单号 = @Original_入住单号) AND (客房价格 = @Original_客房价格 OR @Orig" +
"inal_客房价格 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 (预收款 = @Origi" +
"nal_预收款 OR @Original_预收款 IS NULL AND 预收款 IS NULL) AND (预定人 = @Original_预定人 OR @O" +
"riginal_预定人 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 @Origin" +
"al_早餐 IS NULL AND 早餐 IS NULL) AND (叫醒 = @Original_叫醒 OR @Original_叫醒 IS NULL AND" +
" 叫醒 IS NULL) AND (保密 = @Original_保密 OR @Original_保密 IS NULL AND 保密 IS NULL) AND " +
"(vip = @Original_vip OR @Original_vip IS NULL AND vip IS NULL) AND (电话等级 = @Orig" +
"inal_电话等级 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) 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 (抵店时间 = @Origi" +
"nal_抵店时间 OR @Original_抵店时间 IS NULL AND 抵店时间 IS NULL) AND (离店时间 = @Original_离店时间 " +
"OR @Original_离店时间 IS NULL AND 离店时间 IS NULL) AND (单据状态 = @Original_单据状态 OR @Origi" +
"nal_单据状态 IS NULL AND 单据状态 IS NULL) AND (入住人数 = @Original_入住人数 OR @Original_入住人数 " +
"IS NULL AND 入住人数 IS NULL) AND (客房编号 = @Original_客房编号 OR @Original_客房编号 IS NULL A" +
"ND 客房编号 IS NULL) AND (vip = @Original_Expr26 OR @Original_Expr26 IS NULL AND vip" +
" IS NULL) AND (业务员 = @Original_Expr22 OR @Original_Expr22 IS NULL AND 业务员 IS NUL" +
"L) AND (付款方式 = @Original_Expr33 OR @Original_Expr33 IS NULL AND 付款方式 IS NULL) AN" +
"D (会员编号 = @Original_Expr4 OR @Original_Expr4 IS NULL AND 会员编号 IS NULL) AND (保密 =" +
" @Original_Expr25 OR @Original_Expr25 IS NULL AND 保密 IS NULL) AND (入住人数 = @Origi" +
"nal_Expr8 OR @Original_Expr8 IS NULL AND 入住人数 IS NULL) AND (入住价格 = @Original_Exp" +
"r11 OR @Original_Expr11 IS NULL AND 入住价格 IS NULL) AND (加床价格 = @Original_Expr15 O" +
"R @Original_Expr15 IS NULL AND 加床价格 IS NULL) AND (单据状态 = @Original_Expr7 OR @Ori" +
"ginal_Expr7 IS NULL AND 单据状态 IS NULL) AND (叫醒 = @Original_Expr24 OR @Original_Ex" +
"pr24 IS NULL AND 叫醒 IS NULL) AND (备注 = @Original_Expr20 OR @Original_Expr20 IS N" +
"ULL AND 备注 IS NULL) AND (客房价格 = @Original_Expr10 OR @Original_Expr10 IS NULL AND" +
" 客房价格 IS NULL) AND (客房类型 = @Original_Expr3 OR @Original_Expr3 IS NULL AND 客房类型 I" +
"S NULL) AND (客房编号 = @Original_Expr9 OR @Original_Expr9 IS NULL AND 客房编号 IS NULL)" +
" AND (应收帐款 = @Original_Expr29 OR @Original_Expr29 IS NULL AND 应收帐款 IS NULL) AND " +
"(折扣 = @Original_Expr12 OR @Original_Expr12 IS NULL AND 折扣 IS NULL) AND (折扣原因 = @" +
"Original_Expr13 OR @Original_Expr13 IS NULL AND 折扣原因 IS NULL) AND (抵店时间 = @Origi" +
"nal_Expr5 OR @Original_Expr5 IS NULL AND 抵店时间 IS NULL) AND (操作员 = @Original_Expr" +
"21 OR @Original_Expr21 IS NULL AND 操作员 IS NULL) AND (早餐 = @Original_Expr23 OR @O" +
"riginal_Expr23 IS NULL AND 早餐 IS NULL) AND (是否加床 = @Original_Expr14 OR @Original" +
"_Expr14 IS NULL AND 是否加床 IS NULL) AND (是否结帐 = @Original_Expr30 OR @Original_Expr" +
"30 IS NULL AND 是否结帐 IS NULL) AND (特要说明 = @Original_Expr28 OR @Original_Expr28 IS" +
" NULL AND 特要说明 IS NULL) AND (电话等级 = @Original_Expr27 OR @Original_Expr27 IS NULL" +
" AND 电话等级 IS NULL) AND (离店时间 = @Original_Expr6 OR @Original_Expr6 IS NULL AND 离店" +
"时间 IS NULL) AND (结帐日期 = @Original_Expr32 OR @Original_Expr32 IS NULL AND 结帐日期 IS" +
" NULL) AND (结帐金额 = @Original_Expr31 OR @Original_Expr31 IS NULL AND 结帐金额 IS NULL" +
") AND (联系电话 = @Original_Expr19 OR @Original_Expr19 IS NULL AND 联系电话 IS NULL) AND" +
" (预定人 = @Original_Expr17 OR @Original_Expr17 IS NULL AND 预定人 IS NULL) AND (预定公司 " +
"= @Original_Expr18 OR @Original_Expr18 IS NULL AND 预定公司 IS NULL) AND (预定单号 = @Or" +
"iginal_Expr2 OR @Original_Expr2 IS NULL AND 预定单号 IS NULL) AND (预收款 = @Original_E" +
"xpr16 OR @Original_Expr16 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.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.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.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.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, 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.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, 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, 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.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.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.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.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.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_vip", System.Data.SqlDbType.Bit, 1, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "vip", 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, 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.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.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.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.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.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, 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, 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.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.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, 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.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.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_Expr26", System.Data.SqlDbType.Bit, 1, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "vip", System.Data.DataRowVersion.Original, null));
this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_Expr22", 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_Expr33", 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_Expr4", 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_Expr25", 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_Expr8", 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_Expr11", 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_Expr15", 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_Expr7", 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_Expr24", 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_Expr20", 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_Expr10", 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_Expr3", 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_Expr9", 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_Expr29", 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_Expr12", 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_Expr13", 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_Expr5", 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_Expr21", 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_Expr23", 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_Expr14", 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_Expr30", 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_Expr28", 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_Expr27", 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_Expr6", 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_Expr32", 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_Expr31", 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_Expr19", 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_Expr17", 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_Expr18", 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_Expr2", 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_Expr16", System.Data.SqlDbType.Money, 8, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "预收款", System.Data.DataRowVersion.Original, null));
//
// sqlConnection1
//
this.sqlConnection1.ConnectionString = "workstation id=ACER;packet size=4096;integrated security=SSPI;data source=ACER;pe" +
"rsist security info=False;initial catalog=hotelbook";
//
// sqlInsertCommand1
//
this.sqlInsertCommand1.CommandText = @"INSERT INTO 入住单(入住单号, 预定单号, 客房类型, 会员编号, 抵店时间, 离店时间, 单据状态, 入住人数, 客房编号, 客房价格, 入住价格, 折扣, 折扣原因, 是否加床, 加床价格, 预收款, 预定人, 预定公司, 联系电话, 备注, 操作员, 业务员, 早餐, 叫醒, 保密, vip, 电话等级, 特要说明, 应收帐款, 是否结帐, 结帐金额, 结帐日期, 付款方式) VALUES (@入住单号, @预定单号, @客房类型, @会员编号, @抵店时间, @离店时间, @单据状态, @入住人数, @客房编号, @客房价格, @入住价格, @折扣, @折扣原因, @是否加床, @加床价格, @预收款, @预定人, @预定公司, @联系电话, @备注, @操作员, @业务员, @早餐, @叫醒, @保密, @vip, @电话等级, @特要说明, @应收帐款, @是否结帐, @结帐金额, @结帐日期, @付款方式); SELECT 入住单号 AS Expr1, 预定单号 AS Expr2, 客房类型 AS Expr3, 会员编号 AS Expr4, 抵店时间 AS Expr5, 离店时间 AS Expr6, 单据状态 AS Expr7, 入住人数 AS Expr8, 客房编号 AS Expr9, 客房价格 AS Expr10, 入住价格 AS Expr11, 折扣 AS Expr12, 折扣原因 AS Expr13, 是否加床 AS Expr14, 加床价格 AS Expr15, 预收款 AS Expr16, 预定人 AS Expr17, 预定公司 AS Expr18, 联系电话 AS Expr19, 备注 AS Expr20, 操作员 AS Expr21, 业务员 AS Expr22, 早餐 AS Expr23, 叫醒 AS Expr24, 保密 AS Expr25, vip AS Expr26, 电话等级 AS Expr27, 特要说明 AS Expr28, 应收帐款 AS Expr29, 是否结帐 AS Expr30, 结帐金额 AS Expr31, 结帐日期 AS Expr32, 付款方式 AS Expr33, 入住单号, 预定单号, 会员编号, 客房类型, 抵店时间, 离店时间, 单据状态, 入住人数, 客房编号, 客房价格, 入住价格, 折扣, 折扣原因, 是否加床, 加床价格, 预收款, 预定人, 预定公司, 联系电话, 备注, 操作员, 业务员, 早餐, 叫醒, 保密, vip, 电话等级, 特要说明, 应收帐款, 是否结帐, 结帐金额, 结帐日期, 付款方式 FROM 入住单 WHERE (入住单号 = @入住单号) AND (入住单号 = @入住单号1)";
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.VarChar, 4, "客房类型"));
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.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.SqlPara⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -