dataset1.cs

采用C#和SQL Server 2000开发 功能比较全面的酒店管理系统

            }
            
            internal DataColumn 是否可拼房Column {
                get {
                    return this.column是否可拼房;
                }
            }
            
            public 客房类型Row this[int index] {
                get {
                    return ((客房类型Row)(this.Rows[index]));
                }
            }
            
            public event 客房类型RowChangeEventHandler 客房类型RowChanged;
            
            public event 客房类型RowChangeEventHandler 客房类型RowChanging;
            
            public event 客房类型RowChangeEventHandler 客房类型RowDeleted;
            
            public event 客房类型RowChangeEventHandler 客房类型RowDeleting;
            
            public void Add客房类型Row(客房类型Row row) {
                this.Rows.Add(row);
            }
            
            public 客房类型Row Add客房类型Row(string 类型编号, string 类型名称, System.Decimal 价格, System.Decimal 拼房价格, System.Decimal 可超预定数, bool 是否可拼房) {
                客房类型Row row客房类型Row = ((客房类型Row)(this.NewRow()));
                row客房类型Row.ItemArray = new object[] {
                        类型编号,
                        类型名称,
                        价格,
                        拼房价格,
                        可超预定数,
                        是否可拼房};
                this.Rows.Add(row客房类型Row);
                return row客房类型Row;
            }
            
            public 客房类型Row FindBy类型编号(string 类型编号) {
                return ((客房类型Row)(this.Rows.Find(new object[] {
                            类型编号})));
            }
            
            public System.Collections.IEnumerator GetEnumerator() {
                return this.Rows.GetEnumerator();
            }
            
            public override DataTable Clone() {
                客房类型DataTable cln = ((客房类型DataTable)(base.Clone()));
                cln.InitVars();
                return cln;
            }
            
            protected override DataTable CreateInstance() {
                return new 客房类型DataTable();
            }
            
            internal void InitVars() {
                this.column类型编号 = this.Columns["类型编号"];
                this.column类型名称 = this.Columns["类型名称"];
                this.column价格 = this.Columns["价格"];
                this.column拼房价格 = this.Columns["拼房价格"];
                this.column可超预定数 = this.Columns["可超预定数"];
                this.column是否可拼房 = this.Columns["是否可拼房"];
            }
            
            private void InitClass() {
                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(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(bool), 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;
            }
            
            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 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 bool 是否可拼房 {
                get {
                    try {
                        return ((bool)(this[this.table客房类型.是否可拼房Column]));
                    }
                    catch (InvalidCastException e) {
                        throw new StrongTypingException("无法获取值，因为它是 DBNull。", e);
                    }
                }
                set {
                    this[this.table客房类型.是否可拼房Column] = value;
                }
            }
            
            public bool Is类型名称Null() {
                return this.IsNull(this.table客房类型.类型名称Column);
            }
            
            public void Set类型名称Null() {
                this[this.table客房类型.类型名称Column] = System.Convert.DBNull;
            }
            
            public bool Is价格Null() {
                return this.IsNull(this.table客房类型.价格Column);
            }
            
            public void Set价格Null() {
                this[this.table客房类型.价格Column] = System.Convert.DBNull;
            }
            
            public bool Is拼房价格Null() {
                return this.IsNull(this.table客房类型.拼房价格Column);
            }
            
            public void Set拼房价格Null() {
                this[this.table客房类型.拼房价格Column] = System.Convert.DBNull;
            }
            
            public bool Is可超预定数Null() {
                return this.IsNull(this.table客房类型.可超预定数Column);
            }
            
            public void Set可超预定数Null() {
                this[this.table客房类型.可超预定数Column] = System.Convert.DBNull;
            }
            
            public bool Is是否可拼房Null() {
                return this.IsNull(this.table客房类型.是否可拼房Column);
            }
            
            public void Set是否可拼房Null() {
                this[this.table客房类型.是否可拼房Column] = System.Convert.DBNull;
            }
        }
        
        [System.Diagnostics.DebuggerStepThrough()]
        public class 客房类型RowChangeEvent : EventArgs {
            
            private 客房类型Row eventRow;
            
            private DataRowAction eventAction;
            
            public 客房类型RowChangeEvent(客房类型Row row, DataRowAction action) {
                this.eventRow = row;
                this.eventAction = action;
            }
            
            public 客房类型Row Row {
                get {
                    return this.eventRow;
                }
            }
            
            public DataRowAction Action {
                get {
                    return this.eventAction;
                }
            }
        }
        
        [System.Diagnostics.DebuggerStepThrough()]
        public class 预定单DataTable : DataTable, System.Collections.IEnumerable {
            
            private DataColumn column预定单号;
            
            private DataColumn column会员编号;
            
            private DataColumn column客房类型;
            
            private DataColumn column抵店时间;
            
            private DataColumn column离店时间;
            
            private DataColumn column单据状态;
            
            private DataColumn column入住人数;
            
            private DataColumn column客房编号;
            
            private DataColumn column客房价格;
            
            private DataColumn column入住价格;
            
            private DataColumn column折扣;
            
            private DataColumn column折扣原因;
            
            private DataColumn column是否加床;
            
            private DataColumn column加床价格;