C#编程

开发平台：
Others

product.cs：源码内容
							﻿//------------------------------------------------------------------------------
// <autogenerated>
//     This code was generated by a tool.
//     Runtime Version: 1.1.4322.573
//
//     Changes to this file may cause incorrect behavior and will be lost if 
//     the code is regenerated.
// </autogenerated>
//------------------------------------------------------------------------------
// 
// This source code was auto-generated by xsd, Version=1.1.4322.573.
// 
using System;
using System.Data;
using System.Xml;
using System.Runtime.Serialization;
[Serializable()]
[System.ComponentModel.DesignerCategoryAttribute("code")]
[System.Diagnostics.DebuggerStepThrough()]
[System.ComponentModel.ToolboxItem(true)]
public class Products : DataSet {
    
    private ProductDataTable tableProduct;
    
    public Products() {
        this.InitClass();
        System.ComponentModel.CollectionChangeEventHandler schemaChangedHandler = new System.ComponentModel.CollectionChangeEventHandler(this.SchemaChanged);
        this.Tables.CollectionChanged += schemaChangedHandler;
        this.Relations.CollectionChanged += schemaChangedHandler;
    }
    
    protected Products(SerializationInfo info, StreamingContext context) {
        string strSchema = ((string)(info.GetValue("XmlSchema", typeof(string))));
        if ((strSchema != null)) {
            DataSet ds = new DataSet();
            ds.ReadXmlSchema(new XmlTextReader(new System.IO.StringReader(strSchema)));
            if ((ds.Tables["Product"] != null)) {
                this.Tables.Add(new ProductDataTable(ds.Tables["Product"]));
            }
            this.DataSetName = ds.DataSetName;
            this.Prefix = ds.Prefix;
            this.Namespace = ds.Namespace;
            this.Locale = ds.Locale;
            this.CaseSensitive = ds.CaseSensitive;
            this.EnforceConstraints = ds.EnforceConstraints;
            this.Merge(ds, false, System.Data.MissingSchemaAction.Add);
            this.InitVars();
        }
        else {
            this.InitClass();
        }
        this.GetSerializationData(info, context);
        System.ComponentModel.CollectionChangeEventHandler schemaChangedHandler = new System.ComponentModel.CollectionChangeEventHandler(this.SchemaChanged);
        this.Tables.CollectionChanged += schemaChangedHandler;
        this.Relations.CollectionChanged += schemaChangedHandler;
    }
    
    [System.ComponentModel.Browsable(false)]
    [System.ComponentModel.DesignerSerializationVisibilityAttribute(System.ComponentModel.DesignerSerializationVisibility.Content)]
    public ProductDataTable Product {
        get {
            return this.tableProduct;
        }
    }
    
    public override DataSet Clone() {
        Products cln = ((Products)(base.Clone()));
        cln.InitVars();
        return cln;
    }
    
    protected override bool ShouldSerializeTables() {
        return false;
    }
    
    protected override bool ShouldSerializeRelations() {
        return false;
    }
    
    protected override void ReadXmlSerializable(XmlReader reader) {
        this.Reset();
        DataSet ds = new DataSet();
        ds.ReadXml(reader);
        if ((ds.Tables["Product"] != null)) {
            this.Tables.Add(new ProductDataTable(ds.Tables["Product"]));
        }
        this.DataSetName = ds.DataSetName;
        this.Prefix = ds.Prefix;
        this.Namespace = ds.Namespace;
        this.Locale = ds.Locale;
        this.CaseSensitive = ds.CaseSensitive;
        this.EnforceConstraints = ds.EnforceConstraints;
        this.Merge(ds, false, System.Data.MissingSchemaAction.Add);
        this.InitVars();
    }
    
    protected override System.Xml.Schema.XmlSchema GetSchemaSerializable() {
        System.IO.MemoryStream stream = new System.IO.MemoryStream();
        this.WriteXmlSchema(new XmlTextWriter(stream, null));
        stream.Position = 0;
        return System.Xml.Schema.XmlSchema.Read(new XmlTextReader(stream), null);
    }
    
    internal void InitVars() {
        this.tableProduct = ((ProductDataTable)(this.Tables["Product"]));
        if ((this.tableProduct != null)) {
            this.tableProduct.InitVars();
        }
    }
    
    private void InitClass() {
        this.DataSetName = "Products";
        this.Prefix = "";
        this.Namespace = "http://tempuri.org/XMLSchema1.xsd";
        this.Locale = new System.Globalization.CultureInfo("en-GB");
        this.CaseSensitive = false;
        this.EnforceConstraints = true;
        this.tableProduct = new ProductDataTable();
        this.Tables.Add(this.tableProduct);
    }
    
    private bool ShouldSerializeProduct() {
        return false;
    }
    
    private void SchemaChanged(object sender, System.ComponentModel.CollectionChangeEventArgs e) {
        if ((e.Action == System.ComponentModel.CollectionChangeAction.Remove)) {
            this.InitVars();
        }
    }
    
    public delegate void ProductRowChangeEventHandler(object sender, ProductRowChangeEvent e);
    
    [System.Diagnostics.DebuggerStepThrough()]
    public class ProductDataTable : DataTable, System.Collections.IEnumerable {
        
        private DataColumn columnProductID;
        
        private DataColumn columnProductName;
        
        private DataColumn columnSupplierID;
        
        private DataColumn columnCategoryID;
        
        private DataColumn columnQuantityPerUnit;
        
        private DataColumn columnUnitPrice;
        
        private DataColumn columnUnitsInStock;
        
        private DataColumn columnUnitsOnOrder;
        
        private DataColumn columnReorderLevel;
        
        private DataColumn columnDiscontinued;
        
        internal ProductDataTable() : 
                base("Product") {
            this.InitClass();
        }
        
        internal ProductDataTable(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 ProductIDColumn {
            get {
                return this.columnProductID;
            }
        }
        
        internal DataColumn ProductNameColumn {
            get {
                return this.columnProductName;
            }
        }
        
        internal DataColumn SupplierIDColumn {
            get {
                return this.columnSupplierID;
            }
        }
        
        internal DataColumn CategoryIDColumn {
            get {
                return this.columnCategoryID;
            }
        }
        
        internal DataColumn QuantityPerUnitColumn {
            get {
                return this.columnQuantityPerUnit;
            }
        }
        
        internal DataColumn UnitPriceColumn {
            get {
                return this.columnUnitPrice;
            }
        }
        
        internal DataColumn UnitsInStockColumn {
            get {
                return this.columnUnitsInStock;
            }
        }
        
        internal DataColumn UnitsOnOrderColumn {
            get {
                return this.columnUnitsOnOrder;
            }
        }
        
        internal DataColumn ReorderLevelColumn {
            get {
                return this.columnReorderLevel;
            }
        }
        
        internal DataColumn DiscontinuedColumn {
            get {
                return this.columnDiscontinued;
            }
        }
        
        public ProductRow this[int index] {
            get {
                return ((ProductRow)(this.Rows[index]));
            }
        }
        
        public event ProductRowChangeEventHandler ProductRowChanged;
        
        public event ProductRowChangeEventHandler ProductRowChanging;
        
        public event ProductRowChangeEventHandler ProductRowDeleted;
        
        public event ProductRowChangeEventHandler ProductRowDeleting;
        
        public void AddProductRow(ProductRow row) {
            this.Rows.Add(row);
        }
        
        public ProductRow AddProductRow(string ProductName, int SupplierID, int CategoryID, string QuantityPerUnit, System.Decimal UnitPrice, short UnitsInStock, short UnitsOnOrder, short ReorderLevel, bool Discontinued) {
            ProductRow rowProductRow = ((ProductRow)(this.NewRow()));
            rowProductRow.ItemArray = new object[] {
                    null,
                    ProductName,
                    SupplierID,
                    CategoryID,
                    QuantityPerUnit,
                    UnitPrice,
                    UnitsInStock,
                    UnitsOnOrder,
                    ReorderLevel,
                    Discontinued};
            this.Rows.Add(rowProductRow);
            return rowProductRow;
        }
        
        public System.Collections.IEnumerator GetEnumerator() {
            return this.Rows.GetEnumerator();
        }
        
        public override DataTable Clone() {
            ProductDataTable cln = ((ProductDataTable)(base.Clone()));
            cln.InitVars();
            return cln;
        }
        
        protected override DataTable CreateInstance() {
            return new ProductDataTable();
        }
        
        internal void InitVars() {
            this.columnProductID = this.Columns["ProductID"];
            this.columnProductName = this.Columns["ProductName"];
            this.columnSupplierID = this.Columns["SupplierID"];
            this.columnCategoryID = this.Columns["CategoryID"];
            this.columnQuantityPerUnit = this.Columns["QuantityPerUnit"];
            this.columnUnitPrice = this.Columns["UnitPrice"];
            this.columnUnitsInStock = this.Columns["UnitsInStock"];
            this.columnUnitsOnOrder = this.Columns["UnitsOnOrder"];
            this.columnReorderLevel = this.Columns["ReorderLevel"];
            this.columnDiscontinued = this.Columns["Discontinued"];
        }
        
        private void InitClass() {
            this.columnProductID = new DataColumn("ProductID", typeof(int), null, System.Data.MappingType.Element);
            this.Columns.Add(this.columnProductID);
            this.columnProductName = new DataColumn("ProductName", typeof(string), null, System.Data.MappingType.Element);
            this.Columns.Add(this.columnProductName);
            this.columnSupplierID = new DataColumn("SupplierID", typeof(int), null, System.Data.MappingType.Element);
            this.Columns.Add(this.columnSupplierID);
            this.columnCategoryID = new DataColumn("CategoryID", typeof(int), null, System.Data.MappingType.Element);
            this.Columns.Add(this.columnCategoryID);
            this.columnQuantityPerUnit = new DataColumn("QuantityPerUnit", typeof(string), null, System.Data.MappingType.Element);
            this.Columns.Add(this.columnQuantityPerUnit);
            this.columnUnitPrice = new DataColumn("UnitPrice", typeof(System.Decimal), null, System.Data.MappingType.Element);
            this.Columns.Add(this.columnUnitPrice);
            this.columnUnitsInStock = new DataColumn("UnitsInStock", typeof(short), null, System.Data.MappingType.Element);
            this.Columns.Add(this.columnUnitsInStock);
            this.columnUnitsOnOrder = new DataColumn("UnitsOnOrder", typeof(short), null, System.Data.MappingType.Element);
            this.Columns.Add(this.columnUnitsOnOrder);
            this.columnReorderLevel = new DataColumn("ReorderLevel", typeof(short), null, System.Data.MappingType.Element);
            this.Columns.Add(this.columnReorderLevel);
            this.columnDiscontinued = new DataColumn("Discontinued", typeof(bool), null, System.Data.MappingType.Element);
            this.Columns.Add(this.columnDiscontinued);
            this.columnProductID.AutoIncrement = true;
            this.columnProductID.AllowDBNull = false;
            this.columnProductID.ReadOnly = true;
            this.columnProductName.AllowDBNull = false;
            this.columnDiscontinued.AllowDBNull = false;
        }
        
        public ProductRow NewProductRow() {
            return ((ProductRow)(this.NewRow()));
        }
        
        protected override DataRow NewRowFromBuilder(DataRowBuilder builder) {
            return new ProductRow(builder);
        }
        
        protected override System.Type GetRowType() {
            return typeof(ProductRow);
        }
        
        protected override void OnRowChanged(DataRowChangeEventArgs e) {
            base.OnRowChanged(e);
            if ((this.ProductRowChanged != null)) {
                this.ProductRowChanged(this, new ProductRowChangeEvent(((ProductRow)(e.Row)), e.Action));
            }
        }
        
        protected override void OnRowChanging(DataRowChangeEventArgs e) {
            base.OnRowChanging(e);
            if ((this.ProductRowChanging != null)) {
                this.ProductRowChanging(this, new ProductRowChangeEvent(((ProductRow)(e.Row)), e.Action));
            }
        }
        
        protected override void OnRowDeleted(DataRowChangeEventArgs e) {
            base.OnRowDeleted(e);
            if ((this.ProductRowDeleted != null)) {
                this.ProductRowDeleted(this, new ProductRowChangeEvent(((ProductRow)(e.Row)), e.Action));
            }
        }
        
        protected override void OnRowDeleting(DataRowChangeEventArgs e) {
            base.OnRowDeleting(e);
            if ((this.ProductRowDeleting != null)) {
                this.ProductRowDeleting(this, new ProductRowChangeEvent(((ProductRow)(e.Row)), e.Action));
            }
        }
        
        public void RemoveProductRow(ProductRow row) {
            this.Rows.Remove(row);
        }
    }
    
    [System.Diagnostics.DebuggerStepThrough()]
    public class ProductRow : DataRow {
        
        private ProductDataTable tableProduct;
        
        internal ProductRow(DataRowBuilder rb) : 
                base(rb) {
            this.tableProduct = ((ProductDataTable)(this.Table));
        }
        
        public int ProductID {
            get {
                return ((int)(this[this.tableProduct.ProductIDColumn]));
            }
            set {
                this[this.tableProduct.ProductIDColumn] = value;
            }
        }
        
        public string ProductName {
            get {
                return ((string)(this[this.tableProduct.ProductNameColumn]));
            }
            set {
                this[this.tableProduct.ProductNameColumn] = value;
            }
        }
        
        public int SupplierID {
            get {
                try {
                    return ((int)(this[this.tableProduct.SupplierIDColumn]));
                }
                catch (InvalidCastException e) {
                    throw new StrongTypingException("Cannot get value because it is DBNull.", e);
                }
            }
            set {
                this[this.tableProduct.SupplierIDColumn] = value;
            }
        }
        
        public int CategoryID {
            get {
                try {
                    return ((int)(this[this.tableProduct.CategoryIDColumn]));
                }
                catch (InvalidCastException e) {
                    throw new StrongTypingException("Cannot get value because it is DBNull.", e);
                }
            }
            set {
                this[this.tableProduct.CategoryIDColumn] = value;
            }
        }
        
        public string QuantityPerUnit {
            get {
                try {
                    return ((string)(this[this.tableProduct.QuantityPerUnitColumn]));
                }
                catch (InvalidCastException e) {
                    throw new StrongTypingException("Cannot get value because it is DBNull.", e);
                }
            }
            set {
                this[this.tableProduct.QuantityPerUnitColumn] = value;
            }
        }
        
        public System.Decimal UnitPrice {
            get {
                try {
                    return ((System.Decimal)(this[this.tableProduct.UnitPriceColumn]));
                }
                catch (InvalidCastException e) {
                    throw new StrongTypingException("Cannot get value because it is DBNull.", e);
                }
            }
            set {
                this[this.tableProduct.UnitPriceColumn] = value;
            }
        }
        
        public short UnitsInStock {
            get {
                try {
                    return ((short)(this[this.tableProduct.UnitsInStockColumn]));
                }
                catch (InvalidCastException e) {
                    throw new StrongTypingException("Cannot get value because it is DBNull.", e);
                }
            }
            set {
                this[this.tableProduct.UnitsInStockColumn] = value;
            }
        }
        
        public short UnitsOnOrder {
            get {
                try {
                    return ((short)(this[this.tableProduct.UnitsOnOrderColumn]));
                }
                catch (InvalidCastException e) {
                    throw new StrongTypingException("Cannot get value because it is DBNull.", e);
                }
            }
            set {
                this[this.tableProduct.UnitsOnOrderColumn] = value;
            }
        }
        
        public short ReorderLevel {
            get {
                try {
                    return ((short)(this[this.tableProduct.ReorderLevelColumn]));
                }
                catch (InvalidCastException e) {
                    throw new StrongTypingException("Cannot get value because it is DBNull.", e);
                }
            }
            set {
                this[this.tableProduct.ReorderLevelColumn] = value;
            }
        }
        
        public bool Discontinued {
            get {
                return ((bool)(this[this.tableProduct.DiscontinuedColumn]));
            }
            set {
                this[this.tableProduct.DiscontinuedColumn] = value;
            }
        }
        
        public bool IsSupplierIDNull() {
            return this.IsNull(this.tableProduct.SupplierIDColumn);
        }
        
        public void SetSupplierIDNull() {
            this[this.tableProduct.SupplierIDColumn] = System.Convert.DBNull;
        }
        
        public bool IsCategoryIDNull() {
            return this.IsNull(this.tableProduct.CategoryIDColumn);
        }
        
        public void SetCategoryIDNull() {
            this[this.tableProduct.CategoryIDColumn] = System.Convert.DBNull;
        }
        
        public bool IsQuantityPerUnitNull() {
            return this.IsNull(this.tableProduct.QuantityPerUnitColumn);
        }
        
        public void SetQuantityPerUnitNull() {
            this[this.tableProduct.QuantityPerUnitColumn] = System.Convert.DBNull;
        }
        
        public bool IsUnitPriceNull() {
            return this.IsNull(this.tableProduct.UnitPriceColumn);
        }
        
        public void SetUnitPriceNull() {
            this[this.tableProduct.UnitPriceColumn] = System.Convert.DBNull;
        }
        
        public bool IsUnitsInStockNull() {
            return this.IsNull(this.tableProduct.UnitsInStockColumn);
        }
        
        public void SetUnitsInStockNull() {
            this[this.tableProduct.UnitsInStockColumn] = System.Convert.DBNull;
        }
        
        public bool IsUnitsOnOrderNull() {
            return this.IsNull(this.tableProduct.UnitsOnOrderColumn);
        }
        
        public void SetUnitsOnOrderNull() {
            this[this.tableProduct.UnitsOnOrderColumn] = System.Convert.DBNull;
        }
        
        public bool IsReorderLevelNull() {
            return this.IsNull(this.tableProduct.ReorderLevelColumn);
        }
        
        public void SetReorderLevelNull() {
            this[this.tableProduct.ReorderLevelColumn] = System.Convert.DBNull;
        }
    }
    
    [System.Diagnostics.DebuggerStepThrough()]
    public class ProductRowChangeEvent : EventArgs {
        
        private ProductRow eventRow;
        
        private DataRowAction eventAction;
        
        public ProductRowChangeEvent(ProductRow row, DataRowAction action) {
            this.eventRow = row;
            this.eventAction = action;
        }
        
        public ProductRow Row {
            get {
                return this.eventRow;
            }
        }
        
        public DataRowAction Action {
            get {
                return this.eventAction;
            }
        }
    }
}

						