dataset1.cs

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

                    }
                }
                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;
            }
            
            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;
            }
            
            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;
            }
            
            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备注;
            
            internal 帐单明细DataTable() : 
                    base("帐单明细") {
                this.InitClass();
            }
            
            internal 帐单明细DataTable(DataTable table) : 
                    base(table.TableName) {
                if ((table.CaseSensitive != table.DataSet.CaseSensitive)) {
                    this.CaseSensitive = table.CaseSensitive;
                }
                if ((table.Locale.ToString() != table.DataSet.Locale.ToString())) {
                    this.Locale = table.Locale;
                }
                if ((table.Namespace != table.DataSet.Namespace)) {
                    this.Namespace = table.Namespace;
                }
                this.Prefix = table.Prefix;
                this.MinimumCapacity = table.MinimumCapacity;
                this.DisplayExpression = table.DisplayExpression;
            }
            
            [System.ComponentModel.Browsable(false)]
            public int Count {
                get {
                    return this.Rows.Count;
                }
            }
            
            internal DataColumn 帐单编号Column {
                get {
                    return this.column帐单编号;
                }
            }
            
            internal DataColumn 入住单号Column {
                get {
                    return this.column入住单号;
                }
            }
            
            internal DataColumn 消费内容Column {
                get {
                    return this.column消费内容;
                }
            }
            
            internal DataColumn 消费金额Column {
                get {
                    return this.column消费金额;
                }
            }
            
            internal DataColumn 消费时间Column {
                get {
                    return this.column消费时间;
                }
            }
            
            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.DateTime 消费时间, string 备注) {
                帐单明细Row row帐单明细Row = ((帐单明细Row)(this.NewRow()));
                row帐单明细Row.ItemArray = new object[] {
                        null,
                        入住单号,
                        消费内容,
                        消费金额,
                        消费时间,
                        备注};
                this.Rows.Add(row帐单明细Row);
                return row帐单明细Row;
            }
            
            public 帐单明细Row FindBy帐单编号(int 帐单编号) {
                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() {