orders.cs

基于微软的 ASP.NET+C#开发的PETSHOP(网上宠物店)项目,在性能及开发效率上明显优于基于SUN J2EE框架开发的PETSHOP. 项目包括所有源码及数据库建库脚本,是不错的学习 AS

                this.columnexprdate.AllowDBNull = false;
                this.Columns.Add(this.columnexprdate);
                this.columncardtype = new DataColumn("cardtype", typeof(string), "", System.Data.MappingType.Element);
                this.columncardtype.AllowDBNull = false;
                this.Columns.Add(this.columncardtype);
                this.columnlocale = new DataColumn("locale", typeof(string), "", System.Data.MappingType.Element);
                this.columnlocale.AllowDBNull = false;
                this.Columns.Add(this.columnlocale);
                this.PrimaryKey = new DataColumn[] {
                        this.columnorderid};
            }
            
            public OrdersRow NewOrdersRow() {
                return ((OrdersRow)(this.NewRow()));
            }
            
            protected override DataRow NewRowFromBuilder(DataRowBuilder builder) {
                // We need to ensure that all Rows in the tabled are typed rows.
                // Table calls newRow whenever it needs to create a row.
                // So the following conditions are covered by Row newRow(Record record)
                // * Cursor calls table.addRecord(record) 
                // * table.addRow(object[] values) calls newRow(record)    
                return new OrdersRow(builder);
            }
            
            protected override System.Type GetRowType() {
                return typeof(OrdersRow);
            }
            
            protected override void OnRowChanged(DataRowChangeEventArgs e) {
                base.OnRowChanged(e);
                if ((this.OrdersRowChanged != null)) {
                    this.OrdersRowChanged(this, new OrdersRowChangeEvent(((OrdersRow)(e.Row)), e.Action));
                }
            }
            
            protected override void OnRowChanging(DataRowChangeEventArgs e) {
                base.OnRowChanging(e);
                if ((this.OrdersRowChanging != null)) {
                    this.OrdersRowChanging(this, new OrdersRowChangeEvent(((OrdersRow)(e.Row)), e.Action));
                }
            }
            
            protected override void OnRowDeleted(DataRowChangeEventArgs e) {
                base.OnRowDeleted(e);
                if ((this.OrdersRowDeleted != null)) {
                    this.OrdersRowDeleted(this, new OrdersRowChangeEvent(((OrdersRow)(e.Row)), e.Action));
                }
            }
            
            protected override void OnRowDeleting(DataRowChangeEventArgs e) {
                base.OnRowDeleting(e);
                if ((this.OrdersRowDeleting != null)) {
                    this.OrdersRowDeleting(this, new OrdersRowChangeEvent(((OrdersRow)(e.Row)), e.Action));
                }
            }
            
            public void RemoveOrdersRow(OrdersRow row) {
                this.Rows.Remove(row);
            }
        }
        
        public class OrdersRow : DataRow {
            
            private OrdersDataTable tableOrders;
            
            internal OrdersRow(DataRowBuilder rb) : 
                    base(rb) {
                this.tableOrders = ((OrdersDataTable)(this.Table));
            }
            
            public int orderid {
                get {
                    return ((int)(this[this.tableOrders.orderidColumn]));
                }
                set {
                    this[this.tableOrders.orderidColumn] = value;
                }
            }
            
            public string userid {
                get {
                    return ((string)(this[this.tableOrders.useridColumn]));
                }
                set {
                    this[this.tableOrders.useridColumn] = value;
                }
            }
            
            public System.DateTime orderdate {
                get {
                    return ((System.DateTime)(this[this.tableOrders.orderdateColumn]));
                }
                set {
                    this[this.tableOrders.orderdateColumn] = value;
                }
            }
            
            public string shipaddr1 {
                get {
                    return ((string)(this[this.tableOrders.shipaddr1Column]));
                }
                set {
                    this[this.tableOrders.shipaddr1Column] = value;
                }
            }
            
            public string shipaddr2 {
                get {
                    try {
                        return ((string)(this[this.tableOrders.shipaddr2Column]));
                    }
                    catch (InvalidCastException e) {
                        throw new StrongTypingException("Cannot get value because it is DBNull.", e);
                    }
                }
                set {
                    this[this.tableOrders.shipaddr2Column] = value;
                }
            }
            
            public string shipcity {
                get {
                    return ((string)(this[this.tableOrders.shipcityColumn]));
                }
                set {
                    this[this.tableOrders.shipcityColumn] = value;
                }
            }
            
            public string shipstate {
                get {
                    return ((string)(this[this.tableOrders.shipstateColumn]));
                }
                set {
                    this[this.tableOrders.shipstateColumn] = value;
                }
            }
            
            public string shipzip {
                get {
                    return ((string)(this[this.tableOrders.shipzipColumn]));
                }
                set {
                    this[this.tableOrders.shipzipColumn] = value;
                }
            }
            
            public string shipcountry {
                get {
                    return ((string)(this[this.tableOrders.shipcountryColumn]));
                }
                set {
                    this[this.tableOrders.shipcountryColumn] = value;
                }
            }
            
            public string billaddr1 {
                get {
                    return ((string)(this[this.tableOrders.billaddr1Column]));
                }
                set {
                    this[this.tableOrders.billaddr1Column] = value;
                }
            }
            
            public string billaddr2 {
                get {
                    try {
                        return ((string)(this[this.tableOrders.billaddr2Column]));
                    }
                    catch (InvalidCastException e) {
                        throw new StrongTypingException("Cannot get value because it is DBNull.", e);
                    }
                }
                set {
                    this[this.tableOrders.billaddr2Column] = value;
                }
            }
            
            public string billcity {
                get {
                    return ((string)(this[this.tableOrders.billcityColumn]));
                }
                set {
                    this[this.tableOrders.billcityColumn] = value;
                }
            }
            
            public string billstate {
                get {
                    return ((string)(this[this.tableOrders.billstateColumn]));
                }
                set {
                    this[this.tableOrders.billstateColumn] = value;
                }
            }
            
            public string billzip {
                get {
                    return ((string)(this[this.tableOrders.billzipColumn]));
                }
                set {
                    this[this.tableOrders.billzipColumn] = value;
                }
            }
            
            public string billcountry {
                get {
                    return ((string)(this[this.tableOrders.billcountryColumn]));
                }
                set {
                    this[this.tableOrders.billcountryColumn] = value;
                }
            }
            
            public string courier {
                get {
                    return ((string)(this[this.tableOrders.courierColumn]));
                }
                set {
                    this[this.tableOrders.courierColumn] = value;
                }
            }
            
            public System.Decimal totalprice {
                get {
                    return ((System.Decimal)(this[this.tableOrders.totalpriceColumn]));
                }
                set {
                    this[this.tableOrders.totalpriceColumn] = value;
                }
            }
            
            public string billtofirstname {
                get {
                    return ((string)(this[this.tableOrders.billtofirstnameColumn]));
                }
                set {
                    this[this.tableOrders.billtofirstnameColumn] = value;
                }
            }
            
            public string billtolastname {
                get {
                    return ((string)(this[this.tableOrders.billtolastnameColumn]));
                }
                set {
                    this[this.tableOrders.billtolastnameColumn] = value;
                }
            }
            
            public string shiptofirstname {
                get {
                    return ((string)(this[this.tableOrders.shiptofirstnameColumn]));
                }
                set {
                    this[this.tableOrders.shiptofirstnameColumn] = value;
                }
            }
            
            public string shiptolastname {
                get {
                    return ((string)(this[this.tableOrders.shiptolastnameColumn]));
                }
                set {
                    this[this.tableOrders.shiptolastnameColumn] = value;
                }
            }
            
            public string creditcard {
                get {
                    return ((string)(this[this.tableOrders.creditcardColumn]));
                }
                set {
                    this[this.tableOrders.creditcardColumn] = value;
                }
            }
            
            public string exprdate {
                get {
                    return ((string)(this[this.tableOrders.exprdateColumn]));
                }
                set {
                    this[this.tableOrders.exprdateColumn] = value;
                }
            }
            
            public string cardtype {
                get {
                    return ((string)(this[this.tableOrders.cardtypeColumn]));
                }
                set {
                    this[this.tableOrders.cardtypeColumn] = value;
                }
            }
            
            public string locale {
                get {
                    return ((string)(this[this.tableOrders.localeColumn]));
                }
                set {
                    this[this.tableOrders.localeColumn] = value;
                }
            }
            
            public bool Isshipaddr2Null() {
                return this.IsNull(this.tableOrders.shipaddr2Column);
            }
            
            public void Setshipaddr2Null() {
                this[this.tableOrders.shipaddr2Column] = System.Convert.DBNull;
            }
            
            public bool Isbilladdr2Null() {
                return this.IsNull(this.tableOrders.billaddr2Column);
            }
            
            public void Setbilladdr2Null() {
                this[this.tableOrders.billaddr2Column] = System.Convert.DBNull;
            }
        }
        
        public class OrdersRowChangeEvent : EventArgs {
            
            private OrdersRow eventRow;
            
            private System.Data.DataRowAction eventAction;
            
            public OrdersRowChangeEvent(OrdersRow row, DataRowAction action) {
                this.eventRow = row;
                this.eventAction = action;
            }
            
            public OrdersRow Row {
                get {
                    return this.eventRow;
                }
            }
            
            public DataRowAction Action {
                get {
                    return this.eventAction;
                }
            }
        }
    }
}