orders.cs

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

            private DataColumn columnshipzip;
            
            private DataColumn columnshipcountry;
            
            private DataColumn columnbilladdr1;
            
            private DataColumn columnbilladdr2;
            
            private DataColumn columnbillcity;
            
            private DataColumn columnbillstate;
            
            private DataColumn columnbillzip;
            
            private DataColumn columnbillcountry;
            
            private DataColumn columncourier;
            
            private DataColumn columntotalprice;
            
            private DataColumn columnbilltofirstname;
            
            private DataColumn columnbilltolastname;
            
            private DataColumn columnshiptofirstname;
            
            private DataColumn columnshiptolastname;
            
            private DataColumn columncreditcard;
            
            private DataColumn columnexprdate;
            
            private DataColumn columncardtype;
            
            private DataColumn columnlocale;
            
            internal OrdersDataTable() : 
                    base("Orders") {
                this.InitClass();
            }
            
            [System.ComponentModel.Browsable(false)]
            public int Count {
                get {
                    return this.Rows.Count;
                }
            }
            
            internal DataColumn orderidColumn {
                get {
                    return this.columnorderid;
                }
            }
            
            internal DataColumn useridColumn {
                get {
                    return this.columnuserid;
                }
            }
            
            internal DataColumn orderdateColumn {
                get {
                    return this.columnorderdate;
                }
            }
            
            internal DataColumn shipaddr1Column {
                get {
                    return this.columnshipaddr1;
                }
            }
            
            internal DataColumn shipaddr2Column {
                get {
                    return this.columnshipaddr2;
                }
            }
            
            internal DataColumn shipcityColumn {
                get {
                    return this.columnshipcity;
                }
            }
            
            internal DataColumn shipstateColumn {
                get {
                    return this.columnshipstate;
                }
            }
            
            internal DataColumn shipzipColumn {
                get {
                    return this.columnshipzip;
                }
            }
            
            internal DataColumn shipcountryColumn {
                get {
                    return this.columnshipcountry;
                }
            }
            
            internal DataColumn billaddr1Column {
                get {
                    return this.columnbilladdr1;
                }
            }
            
            internal DataColumn billaddr2Column {
                get {
                    return this.columnbilladdr2;
                }
            }
            
            internal DataColumn billcityColumn {
                get {
                    return this.columnbillcity;
                }
            }
            
            internal DataColumn billstateColumn {
                get {
                    return this.columnbillstate;
                }
            }
            
            internal DataColumn billzipColumn {
                get {
                    return this.columnbillzip;
                }
            }
            
            internal DataColumn billcountryColumn {
                get {
                    return this.columnbillcountry;
                }
            }
            
            internal DataColumn courierColumn {
                get {
                    return this.columncourier;
                }
            }
            
            internal DataColumn totalpriceColumn {
                get {
                    return this.columntotalprice;
                }
            }
            
            internal DataColumn billtofirstnameColumn {
                get {
                    return this.columnbilltofirstname;
                }
            }
            
            internal DataColumn billtolastnameColumn {
                get {
                    return this.columnbilltolastname;
                }
            }
            
            internal DataColumn shiptofirstnameColumn {
                get {
                    return this.columnshiptofirstname;
                }
            }
            
            internal DataColumn shiptolastnameColumn {
                get {
                    return this.columnshiptolastname;
                }
            }
            
            internal DataColumn creditcardColumn {
                get {
                    return this.columncreditcard;
                }
            }
            
            internal DataColumn exprdateColumn {
                get {
                    return this.columnexprdate;
                }
            }
            
            internal DataColumn cardtypeColumn {
                get {
                    return this.columncardtype;
                }
            }
            
            internal DataColumn localeColumn {
                get {
                    return this.columnlocale;
                }
            }
            
            public OrdersRow this[int index] {
                get {
                    return ((OrdersRow)(this.Rows[index]));
                }
            }
            
            public event OrdersRowChangeEventHandler OrdersRowChanged;
            
            public event OrdersRowChangeEventHandler OrdersRowChanging;
            
            public event OrdersRowChangeEventHandler OrdersRowDeleted;
            
            public event OrdersRowChangeEventHandler OrdersRowDeleting;
            
            public void AddOrdersRow(OrdersRow row) {
                this.Rows.Add(row);
            }
            
            public OrdersRow AddOrdersRow(
                        string userid, 
                        System.DateTime orderdate, 
                        string shipaddr1, 
                        string shipaddr2, 
                        string shipcity, 
                        string shipstate, 
                        string shipzip, 
                        string shipcountry, 
                        string billaddr1, 
                        string billaddr2, 
                        string billcity, 
                        string billstate, 
                        string billzip, 
                        string billcountry, 
                        string courier, 
                        System.Decimal totalprice, 
                        string billtofirstname, 
                        string billtolastname, 
                        string shiptofirstname, 
                        string shiptolastname, 
                        string creditcard, 
                        string exprdate, 
                        string cardtype, 
                        string locale) {
                OrdersRow rowOrdersRow = ((OrdersRow)(this.NewRow()));
                rowOrdersRow.ItemArray = new object[] {
                        null,
                        userid,
                        orderdate,
                        shipaddr1,
                        shipaddr2,
                        shipcity,
                        shipstate,
                        shipzip,
                        shipcountry,
                        billaddr1,
                        billaddr2,
                        billcity,
                        billstate,
                        billzip,
                        billcountry,
                        courier,
                        totalprice,
                        billtofirstname,
                        billtolastname,
                        shiptofirstname,
                        shiptolastname,
                        creditcard,
                        exprdate,
                        cardtype,
                        locale};
                this.Rows.Add(rowOrdersRow);
                return rowOrdersRow;
            }
            
            public OrdersRow FindByorderid(int orderid) {
                return ((OrdersRow)(this.Rows.Find(new object[] {
                            orderid})));
            }
            
            public System.Collections.IEnumerator GetEnumerator() {
                return this.Rows.GetEnumerator();
            }
            
            private void InitClass() {
                this.columnorderid = new DataColumn("orderid", typeof(int), "", System.Data.MappingType.Element);
                this.columnorderid.AutoIncrement = true;
                this.columnorderid.AllowDBNull = false;
                this.columnorderid.ReadOnly = true;
                this.columnorderid.Unique = true;
                this.Columns.Add(this.columnorderid);
                this.columnuserid = new DataColumn("userid", typeof(string), "", System.Data.MappingType.Element);
                this.columnuserid.AllowDBNull = false;
                this.Columns.Add(this.columnuserid);
                this.columnorderdate = new DataColumn("orderdate", typeof(System.DateTime), "", System.Data.MappingType.Element);
                this.columnorderdate.AllowDBNull = false;
                this.Columns.Add(this.columnorderdate);
                this.columnshipaddr1 = new DataColumn("shipaddr1", typeof(string), "", System.Data.MappingType.Element);
                this.columnshipaddr1.AllowDBNull = false;
                this.Columns.Add(this.columnshipaddr1);
                this.columnshipaddr2 = new DataColumn("shipaddr2", typeof(string), "", System.Data.MappingType.Element);
                this.Columns.Add(this.columnshipaddr2);
                this.columnshipcity = new DataColumn("shipcity", typeof(string), "", System.Data.MappingType.Element);
                this.columnshipcity.AllowDBNull = false;
                this.Columns.Add(this.columnshipcity);
                this.columnshipstate = new DataColumn("shipstate", typeof(string), "", System.Data.MappingType.Element);
                this.columnshipstate.AllowDBNull = false;
                this.Columns.Add(this.columnshipstate);
                this.columnshipzip = new DataColumn("shipzip", typeof(string), "", System.Data.MappingType.Element);
                this.columnshipzip.AllowDBNull = false;
                this.Columns.Add(this.columnshipzip);
                this.columnshipcountry = new DataColumn("shipcountry", typeof(string), "", System.Data.MappingType.Element);
                this.columnshipcountry.AllowDBNull = false;
                this.Columns.Add(this.columnshipcountry);
                this.columnbilladdr1 = new DataColumn("billaddr1", typeof(string), "", System.Data.MappingType.Element);
                this.columnbilladdr1.AllowDBNull = false;
                this.Columns.Add(this.columnbilladdr1);
                this.columnbilladdr2 = new DataColumn("billaddr2", typeof(string), "", System.Data.MappingType.Element);
                this.Columns.Add(this.columnbilladdr2);
                this.columnbillcity = new DataColumn("billcity", typeof(string), "", System.Data.MappingType.Element);
                this.columnbillcity.AllowDBNull = false;
                this.Columns.Add(this.columnbillcity);
                this.columnbillstate = new DataColumn("billstate", typeof(string), "", System.Data.MappingType.Element);
                this.columnbillstate.AllowDBNull = false;
                this.Columns.Add(this.columnbillstate);
                this.columnbillzip = new DataColumn("billzip", typeof(string), "", System.Data.MappingType.Element);
                this.columnbillzip.AllowDBNull = false;
                this.Columns.Add(this.columnbillzip);
                this.columnbillcountry = new DataColumn("billcountry", typeof(string), "", System.Data.MappingType.Element);
                this.columnbillcountry.AllowDBNull = false;
                this.Columns.Add(this.columnbillcountry);
                this.columncourier = new DataColumn("courier", typeof(string), "", System.Data.MappingType.Element);
                this.columncourier.AllowDBNull = false;
                this.Columns.Add(this.columncourier);
                this.columntotalprice = new DataColumn("totalprice", typeof(System.Decimal), "", System.Data.MappingType.Element);
                this.columntotalprice.AllowDBNull = false;
                this.Columns.Add(this.columntotalprice);
                this.columnbilltofirstname = new DataColumn("billtofirstname", typeof(string), "", System.Data.MappingType.Element);
                this.columnbilltofirstname.AllowDBNull = false;
                this.Columns.Add(this.columnbilltofirstname);
                this.columnbilltolastname = new DataColumn("billtolastname", typeof(string), "", System.Data.MappingType.Element);
                this.columnbilltolastname.AllowDBNull = false;
                this.Columns.Add(this.columnbilltolastname);
                this.columnshiptofirstname = new DataColumn("shiptofirstname", typeof(string), "", System.Data.MappingType.Element);
                this.columnshiptofirstname.AllowDBNull = false;
                this.Columns.Add(this.columnshiptofirstname);
                this.columnshiptolastname = new DataColumn("shiptolastname", typeof(string), "", System.Data.MappingType.Element);
                this.columnshiptolastname.AllowDBNull = false;
                this.Columns.Add(this.columnshiptolastname);
                this.columncreditcard = new DataColumn("creditcard", typeof(string), "", System.Data.MappingType.Element);
                this.columncreditcard.AllowDBNull = false;
                this.Columns.Add(this.columncreditcard);
                this.columnexprdate = new DataColumn("exprdate", typeof(string), "", System.Data.MappingType.Element);