dataset2.cs

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

                    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 {
                    try {
                        return ((string)(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 {
                    try {
                        return ((string)(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 {
                    try {
                        return ((string)(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;
            }