datasetprobuy.cs

《C#数据库项目案例导航》一书的配套光盘

                this.Columns.Add(this.columnProviderName);
                this.columnProBuyUnit = new DataColumn("ProBuyUnit", typeof(string), null, System.Data.MappingType.Element);
                this.Columns.Add(this.columnProBuyUnit);
                this.columnProBuyNumber = new DataColumn("ProBuyNumber", typeof(int), null, System.Data.MappingType.Element);
                this.Columns.Add(this.columnProBuyNumber);
                this.columnProBuyPrice = new DataColumn("ProBuyPrice", typeof(System.Double), null, System.Data.MappingType.Element);
                this.Columns.Add(this.columnProBuyPrice);
                this.columnProBuyDate = new DataColumn("ProBuyDate", typeof(System.DateTime), null, System.Data.MappingType.Element);
                this.Columns.Add(this.columnProBuyDate);
                this.columnProBuyPeople = new DataColumn("ProBuyPeople", typeof(string), null, System.Data.MappingType.Element);
                this.Columns.Add(this.columnProBuyPeople);
                this.columnProBuyReamark = new DataColumn("ProBuyReamark", typeof(string), null, System.Data.MappingType.Element);
                this.Columns.Add(this.columnProBuyReamark);
                this.Constraints.Add(new UniqueConstraint("Constraint1", new DataColumn[] {
                                this.columnProBuyID}, true));
                this.columnProBuyID.AllowDBNull = false;
                this.columnProBuyID.Unique = true;
            }
            
            public ProBuyRow NewProBuyRow() {
                return ((ProBuyRow)(this.NewRow()));
            }
            
            protected override DataRow NewRowFromBuilder(DataRowBuilder builder) {
                return new ProBuyRow(builder);
            }
            
            protected override System.Type GetRowType() {
                return typeof(ProBuyRow);
            }
            
            protected override void OnRowChanged(DataRowChangeEventArgs e) {
                base.OnRowChanged(e);
                if ((this.ProBuyRowChanged != null)) {
                    this.ProBuyRowChanged(this, new ProBuyRowChangeEvent(((ProBuyRow)(e.Row)), e.Action));
                }
            }
            
            protected override void OnRowChanging(DataRowChangeEventArgs e) {
                base.OnRowChanging(e);
                if ((this.ProBuyRowChanging != null)) {
                    this.ProBuyRowChanging(this, new ProBuyRowChangeEvent(((ProBuyRow)(e.Row)), e.Action));
                }
            }
            
            protected override void OnRowDeleted(DataRowChangeEventArgs e) {
                base.OnRowDeleted(e);
                if ((this.ProBuyRowDeleted != null)) {
                    this.ProBuyRowDeleted(this, new ProBuyRowChangeEvent(((ProBuyRow)(e.Row)), e.Action));
                }
            }
            
            protected override void OnRowDeleting(DataRowChangeEventArgs e) {
                base.OnRowDeleting(e);
                if ((this.ProBuyRowDeleting != null)) {
                    this.ProBuyRowDeleting(this, new ProBuyRowChangeEvent(((ProBuyRow)(e.Row)), e.Action));
                }
            }
            
            public void RemoveProBuyRow(ProBuyRow row) {
                this.Rows.Remove(row);
            }
        }
        
        [System.Diagnostics.DebuggerStepThrough()]
        public class ProBuyRow : DataRow {
            
            private ProBuyDataTable tableProBuy;
            
            internal ProBuyRow(DataRowBuilder rb) : 
                    base(rb) {
                this.tableProBuy = ((ProBuyDataTable)(this.Table));
            }
            
            public string ProBuyID {
                get {
                    return ((string)(this[this.tableProBuy.ProBuyIDColumn]));
                }
                set {
                    this[this.tableProBuy.ProBuyIDColumn] = value;
                }
            }
            
            public string ProductID {
                get {
                    try {
                        return ((string)(this[this.tableProBuy.ProductIDColumn]));
                    }
                    catch (InvalidCastException e) {
                        throw new StrongTypingException("无法获取值，因为它是 DBNull。", e);
                    }
                }
                set {
                    this[this.tableProBuy.ProductIDColumn] = value;
                }
            }
            
            public string ProductName {
                get {
                    try {
                        return ((string)(this[this.tableProBuy.ProductNameColumn]));
                    }
                    catch (InvalidCastException e) {
                        throw new StrongTypingException("无法获取值，因为它是 DBNull。", e);
                    }
                }
                set {
                    this[this.tableProBuy.ProductNameColumn] = value;
                }
            }
            
            public string ProviderID {
                get {
                    try {
                        return ((string)(this[this.tableProBuy.ProviderIDColumn]));
                    }
                    catch (InvalidCastException e) {
                        throw new StrongTypingException("无法获取值，因为它是 DBNull。", e);
                    }
                }
                set {
                    this[this.tableProBuy.ProviderIDColumn] = value;
                }
            }
            
            public string ProviderName {
                get {
                    try {
                        return ((string)(this[this.tableProBuy.ProviderNameColumn]));
                    }
                    catch (InvalidCastException e) {
                        throw new StrongTypingException("无法获取值，因为它是 DBNull。", e);
                    }
                }
                set {
                    this[this.tableProBuy.ProviderNameColumn] = value;
                }
            }
            
            public string ProBuyUnit {
                get {
                    try {
                        return ((string)(this[this.tableProBuy.ProBuyUnitColumn]));
                    }
                    catch (InvalidCastException e) {
                        throw new StrongTypingException("无法获取值，因为它是 DBNull。", e);
                    }
                }
                set {
                    this[this.tableProBuy.ProBuyUnitColumn] = value;
                }
            }
            
            public int ProBuyNumber {
                get {
                    try {
                        return ((int)(this[this.tableProBuy.ProBuyNumberColumn]));
                    }
                    catch (InvalidCastException e) {
                        throw new StrongTypingException("无法获取值，因为它是 DBNull。", e);
                    }
                }
                set {
                    this[this.tableProBuy.ProBuyNumberColumn] = value;
                }
            }
            
            public System.Double ProBuyPrice {
                get {
                    try {
                        return ((System.Double)(this[this.tableProBuy.ProBuyPriceColumn]));
                    }
                    catch (InvalidCastException e) {
                        throw new StrongTypingException("无法获取值，因为它是 DBNull。", e);
                    }
                }
                set {
                    this[this.tableProBuy.ProBuyPriceColumn] = value;
                }
            }
            
            public System.DateTime ProBuyDate {
                get {
                    try {
                        return ((System.DateTime)(this[this.tableProBuy.ProBuyDateColumn]));
                    }
                    catch (InvalidCastException e) {
                        throw new StrongTypingException("无法获取值，因为它是 DBNull。", e);
                    }
                }
                set {
                    this[this.tableProBuy.ProBuyDateColumn] = value;
                }
            }
            
            public string ProBuyPeople {
                get {
                    try {
                        return ((string)(this[this.tableProBuy.ProBuyPeopleColumn]));
                    }
                    catch (InvalidCastException e) {
                        throw new StrongTypingException("无法获取值，因为它是 DBNull。", e);
                    }
                }
                set {
                    this[this.tableProBuy.ProBuyPeopleColumn] = value;
                }
            }
            
            public string ProBuyReamark {
                get {
                    try {
                        return ((string)(this[this.tableProBuy.ProBuyReamarkColumn]));
                    }
                    catch (InvalidCastException e) {
                        throw new StrongTypingException("无法获取值，因为它是 DBNull。", e);
                    }
                }
                set {
                    this[this.tableProBuy.ProBuyReamarkColumn] = value;
                }
            }
            
            public bool IsProductIDNull() {
                return this.IsNull(this.tableProBuy.ProductIDColumn);
            }
            
            public void SetProductIDNull() {
                this[this.tableProBuy.ProductIDColumn] = System.Convert.DBNull;
            }
            
            public bool IsProductNameNull() {
                return this.IsNull(this.tableProBuy.ProductNameColumn);
            }
            
            public void SetProductNameNull() {
                this[this.tableProBuy.ProductNameColumn] = System.Convert.DBNull;
            }
            
            public bool IsProviderIDNull() {
                return this.IsNull(this.tableProBuy.ProviderIDColumn);
            }
            
            public void SetProviderIDNull() {
                this[this.tableProBuy.ProviderIDColumn] = System.Convert.DBNull;
            }
            
            public bool IsProviderNameNull() {
                return this.IsNull(this.tableProBuy.ProviderNameColumn);
            }
            
            public void SetProviderNameNull() {
                this[this.tableProBuy.ProviderNameColumn] = System.Convert.DBNull;
            }
            
            public bool IsProBuyUnitNull() {
                return this.IsNull(this.tableProBuy.ProBuyUnitColumn);
            }
            
            public void SetProBuyUnitNull() {
                this[this.tableProBuy.ProBuyUnitColumn] = System.Convert.DBNull;
            }
            
            public bool IsProBuyNumberNull() {
                return this.IsNull(this.tableProBuy.ProBuyNumberColumn);
            }
            
            public void SetProBuyNumberNull() {
                this[this.tableProBuy.ProBuyNumberColumn] = System.Convert.DBNull;
            }
            
            public bool IsProBuyPriceNull() {
                return this.IsNull(this.tableProBuy.ProBuyPriceColumn);
            }
            
            public void SetProBuyPriceNull() {
                this[this.tableProBuy.ProBuyPriceColumn] = System.Convert.DBNull;
            }
            
            public bool IsProBuyDateNull() {
                return this.IsNull(this.tableProBuy.ProBuyDateColumn);
            }
            
            public void SetProBuyDateNull() {
                this[this.tableProBuy.ProBuyDateColumn] = System.Convert.DBNull;
            }
            
            public bool IsProBuyPeopleNull() {
                return this.IsNull(this.tableProBuy.ProBuyPeopleColumn);
            }
            
            public void SetProBuyPeopleNull() {
                this[this.tableProBuy.ProBuyPeopleColumn] = System.Convert.DBNull;
            }
            
            public bool IsProBuyReamarkNull() {
                return this.IsNull(this.tableProBuy.ProBuyReamarkColumn);
            }
            
            public void SetProBuyReamarkNull() {
                this[this.tableProBuy.ProBuyReamarkColumn] = System.Convert.DBNull;
            }
        }
        
        [System.Diagnostics.DebuggerStepThrough()]
        public class ProBuyRowChangeEvent : EventArgs {
            
            private ProBuyRow eventRow;
            
            private DataRowAction eventAction;
            
            public ProBuyRowChangeEvent(ProBuyRow row, DataRowAction action) {
                this.eventRow = row;
                this.eventAction = action;
            }
            
            public ProBuyRow Row {
                get {
                    return this.eventRow;
                }
            }
            
            public DataRowAction Action {
                get {
                    return this.eventAction;
                }
            }
        }
    }
}