dataset1.cs

C#数据库编程（酒店管理系统）

                this.Columns.Add(this.column抵店时间);
                this.column离店时间 = new DataColumn("离店时间", typeof(System.DateTime), null, System.Data.MappingType.Element);
                this.Columns.Add(this.column离店时间);
                this.column单据状态 = new DataColumn("单据状态", typeof(string), null, System.Data.MappingType.Element);
                this.Columns.Add(this.column单据状态);
                this.column入住人数 = new DataColumn("入住人数", typeof(int), null, System.Data.MappingType.Element);
                this.Columns.Add(this.column入住人数);
                this.column客房编号 = new DataColumn("客房编号", typeof(string), null, System.Data.MappingType.Element);
                this.Columns.Add(this.column客房编号);
                this.column客房价格 = new DataColumn("客房价格", typeof(System.Decimal), null, System.Data.MappingType.Element);
                this.Columns.Add(this.column客房价格);
                this.column入住价格 = new DataColumn("入住价格", typeof(System.Decimal), null, System.Data.MappingType.Element);
                this.Columns.Add(this.column入住价格);
                this.column折扣 = new DataColumn("折扣", typeof(System.Decimal), null, System.Data.MappingType.Element);
                this.Columns.Add(this.column折扣);
                this.column折扣原因 = new DataColumn("折扣原因", typeof(string), null, System.Data.MappingType.Element);
                this.Columns.Add(this.column折扣原因);
                this.column是否加床 = new DataColumn("是否加床", typeof(bool), null, System.Data.MappingType.Element);
                this.Columns.Add(this.column是否加床);
                this.column加床价格 = new DataColumn("加床价格", typeof(System.Decimal), null, System.Data.MappingType.Element);
                this.Columns.Add(this.column加床价格);
                this.column预收款 = new DataColumn("预收款", typeof(System.Decimal), null, System.Data.MappingType.Element);
                this.Columns.Add(this.column预收款);
                this.column预定人 = new DataColumn("预定人", typeof(string), null, System.Data.MappingType.Element);
                this.Columns.Add(this.column预定人);
                this.column预定公司 = new DataColumn("预定公司", typeof(string), null, System.Data.MappingType.Element);
                this.Columns.Add(this.column预定公司);
                this.column联系电话 = new DataColumn("联系电话", typeof(string), null, System.Data.MappingType.Element);
                this.Columns.Add(this.column联系电话);
                this.column备注 = new DataColumn("备注", typeof(string), null, System.Data.MappingType.Element);
                this.Columns.Add(this.column备注);
                this.column操作员 = new DataColumn("操作员", typeof(string), null, System.Data.MappingType.Element);
                this.Columns.Add(this.column操作员);
                this.column业务员 = new DataColumn("业务员", typeof(string), null, System.Data.MappingType.Element);
                this.Columns.Add(this.column业务员);
                this.Constraints.Add(new UniqueConstraint("Constraint1", new DataColumn[] {
                                this.column预定单号}, true));
                this.column预定单号.AllowDBNull = false;
                this.column预定单号.Unique = true;
                this.column客房类型.AllowDBNull = false;
                this.column抵店时间.AllowDBNull = false;
                this.column是否加床.DefaultValue = false;
            }
            
            public 预定单Row New预定单Row() {
                return ((预定单Row)(this.NewRow()));
            }
            
            protected override DataRow NewRowFromBuilder(DataRowBuilder builder) {
                return new 预定单Row(builder);
            }
            
            protected override System.Type GetRowType() {
                return typeof(预定单Row);
            }
            
            protected override void OnRowChanged(DataRowChangeEventArgs e) {
                base.OnRowChanged(e);
                if ((this.预定单RowChanged != null)) {
                    this.预定单RowChanged(this, new 预定单RowChangeEvent(((预定单Row)(e.Row)), e.Action));
                }
            }
            
            protected override void OnRowChanging(DataRowChangeEventArgs e) {
                base.OnRowChanging(e);
                if ((this.预定单RowChanging != null)) {
                    this.预定单RowChanging(this, new 预定单RowChangeEvent(((预定单Row)(e.Row)), e.Action));
                }
            }
            
            protected override void OnRowDeleted(DataRowChangeEventArgs e) {
                base.OnRowDeleted(e);
                if ((this.预定单RowDeleted != null)) {
                    this.预定单RowDeleted(this, new 预定单RowChangeEvent(((预定单Row)(e.Row)), e.Action));
                }
            }
            
            protected override void OnRowDeleting(DataRowChangeEventArgs e) {
                base.OnRowDeleting(e);
                if ((this.预定单RowDeleting != null)) {
                    this.预定单RowDeleting(this, new 预定单RowChangeEvent(((预定单Row)(e.Row)), e.Action));
                }
            }
            
            public void Remove预定单Row(预定单Row row) {
                this.Rows.Remove(row);
            }
        }
        
        [System.Diagnostics.DebuggerStepThrough()]
        public class 预定单Row : DataRow {
            
            private 预定单DataTable table预定单;
            
            internal 预定单Row(DataRowBuilder rb) : 
                    base(rb) {
                this.table预定单 = ((预定单DataTable)(this.Table));
            }
            
            public string 预定单号 {
                get {
                    return ((string)(this[this.table预定单.预定单号Column]));
                }
                set {
                    this[this.table预定单.预定单号Column] = value;
                }
            }
            
            public int 会员编号 {
                get {
                    try {
                        return ((int)(this[this.table预定单.会员编号Column]));
                    }
                    catch (InvalidCastException e) {
                        throw new StrongTypingException("无法获取值，因为它是 DBNull。", e);
                    }
                }
                set {
                    this[this.table预定单.会员编号Column] = value;
                }
            }
            
            public string 客房类型 {
                get {
                    return ((string)(this[this.table预定单.客房类型Column]));
                }
                set {
                    this[this.table预定单.客房类型Column] = value;
                }
            }
            
            public System.DateTime 抵店时间 {
                get {
                    return ((System.DateTime)(this[this.table预定单.抵店时间Column]));
                }
                set {
                    this[this.table预定单.抵店时间Column] = value;
                }
            }
            
            public System.DateTime 离店时间 {
                get {
                    try {
                        return ((System.DateTime)(this[this.table预定单.离店时间Column]));
                    }
                    catch (InvalidCastException e) {
                        throw new StrongTypingException("无法获取值，因为它是 DBNull。", e);
                    }
                }
                set {
                    this[this.table预定单.离店时间Column] = value;
                }
            }
            
            public string 单据状态 {
                get {
                    try {
                        return ((string)(this[this.table预定单.单据状态Column]));
                    }
                    catch (InvalidCastException e) {
                        throw new StrongTypingException("无法获取值，因为它是 DBNull。", e);
                    }
                }
                set {
                    this[this.table预定单.单据状态Column] = value;
                }
            }
            
            public int 入住人数 {
                get {
                    try {
                        return ((int)(this[this.table预定单.入住人数Column]));
                    }
                    catch (InvalidCastException e) {
                        throw new StrongTypingException("无法获取值，因为它是 DBNull。", e);
                    }
                }
                set {
                    this[this.table预定单.入住人数Column] = value;
                }
            }
            
            public string 客房编号 {
                get {
                    try {
                        return ((string)(this[this.table预定单.客房编号Column]));
                    }
                    catch (InvalidCastException e) {
                        throw new StrongTypingException("无法获取值，因为它是 DBNull。", e);
                    }
                }
                set {
                    this[this.table预定单.客房编号Column] = value;
                }
            }
            
            public System.Decimal 客房价格 {
                get {
                    try {
                        return ((System.Decimal)(this[this.table预定单.客房价格Column]));
                    }
                    catch (InvalidCastException e) {
                        throw new StrongTypingException("无法获取值，因为它是 DBNull。", e);
                    }
                }
                set {
                    this[this.table预定单.客房价格Column] = value;
                }
            }
            
            public System.Decimal 入住价格 {
                get {
                    try {
                        return ((System.Decimal)(this[this.table预定单.入住价格Column]));
                    }
                    catch (InvalidCastException e) {
                        throw new StrongTypingException("无法获取值，因为它是 DBNull。", e);
                    }
                }
                set {
                    this[this.table预定单.入住价格Column] = value;
                }
            }
            
            public System.Decimal 折扣 {
                get {
                    try {
                        return ((System.Decimal)(this[this.table预定单.折扣Column]));
                    }
                    catch (InvalidCastException e) {
                        throw new StrongTypingException("无法获取值，因为它是 DBNull。", e);
                    }
                }
                set {
                    this[this.table预定单.折扣Column] = value;
                }
            }
            
            public string 折扣原因 {
                get {
                    try {
                        return ((string)(this[this.table预定单.折扣原因Column]));
                    }
                    catch (InvalidCastException e) {
                        throw new StrongTypingException("无法获取值，因为它是 DBNull。", e);
                    }
                }
                set {
                    this[this.table预定单.折扣原因Column] = value;
                }
            }
            
            public bool 是否加床 {
                get {
                    try {
                        return ((bool)(this[this.table预定单.是否加床Column]));
                    }
                    catch (InvalidCastException e) {
                        throw new StrongTypingException("无法获取值，因为它是 DBNull。", e);
                    }
                }
                set {
                    this[this.table预定单.是否加床Column] = value;
                }
            }
            
            public System.Decimal 加床价格 {
                get {
                    try {
                        return ((System.Decimal)(this[this.table预定单.加床价格Column]));
                    }
                    catch (InvalidCastException e) {
                        throw new StrongTypingException("无法获取值，因为它是 DBNull。", e);
                    }
                }
                set {
                    this[this.table预定单.加床价格Column] = value;
                }
            }
            
            public System.Decimal 预收款 {
                get {
                    try {
                        return ((System.Decimal)(this[this.table预定单.预收款Column]));
                    }
                    catch (InvalidCastException e) {
                        throw new StrongTypingException("无法获取值，因为它是 DBNull。", e);
                    }
                }
                set {
                    this[this.table预定单.预收款Column] = value;
                }
            }
            
            public string 预定人 {
                get {
                    try {
                        return ((string)(this[this.table预定单.预定人Column]));
                    }
                    catch (InvalidCastException e) {
                        throw new StrongTypingException("无法获取值，因为它是 DBNull。", e);
                    }
                }
                set {
                    this[this.table预定单.预定人Column] = value;
                }
            }
            
            public string 预定公司 {
                get {