customerdataset.cs

第三方物流信息管理平台 1、数据库配置： 需要打开MS SQL SERVER 2000企业管理器

                return rowcustomerRow;
            }
            
            public customerRow FindBy客户编号(string 客户编号) {
                return ((customerRow)(this.Rows.Find(new object[] {
                            客户编号})));
            }
            
            public System.Collections.IEnumerator GetEnumerator() {
                return this.Rows.GetEnumerator();
            }
            
            public override DataTable Clone() {
                customerDataTable cln = ((customerDataTable)(base.Clone()));
                cln.InitVars();
                return cln;
            }
            
            protected override DataTable CreateInstance() {
                return new customerDataTable();
            }
            
            internal void InitVars() {
                this.column客户编号 = this.Columns["客户编号"];
                this.column客户名称 = this.Columns["客户名称"];
                this.column客户简称 = this.Columns["客户简称"];
                this.column企业法人 = this.Columns["企业法人"];
                this.column客户地址 = this.Columns["客户地址"];
                this.column邮政编码 = this.Columns["邮政编码"];
                this.column业务联系人 = this.Columns["业务联系人"];
                this.column电话 = this.Columns["电话"];
                this.column传真 = this.Columns["传真"];
                this.column电子邮件 = this.Columns["电子邮件"];
                this.column开户银行 = this.Columns["开户银行"];
                this.column银行帐号 = this.Columns["银行帐号"];
            }
            
            private void InitClass() {
                this.column客户编号 = new DataColumn("客户编号", typeof(string), null, System.Data.MappingType.Element);
                this.Columns.Add(this.column客户编号);
                this.column客户名称 = new DataColumn("客户名称", typeof(string), null, System.Data.MappingType.Element);
                this.Columns.Add(this.column客户名称);
                this.column客户简称 = new DataColumn("客户简称", typeof(string), null, System.Data.MappingType.Element);
                this.Columns.Add(this.column客户简称);
                this.column企业法人 = new DataColumn("企业法人", typeof(string), null, System.Data.MappingType.Element);
                this.Columns.Add(this.column企业法人);
                this.column客户地址 = new DataColumn("客户地址", typeof(string), null, System.Data.MappingType.Element);
                this.Columns.Add(this.column客户地址);
                this.column邮政编码 = new DataColumn("邮政编码", typeof(string), null, System.Data.MappingType.Element);
                this.Columns.Add(this.column邮政编码);
                this.column业务联系人 = new DataColumn("业务联系人", typeof(string), null, System.Data.MappingType.Element);
                this.Columns.Add(this.column业务联系人);
                this.column电话 = new DataColumn("电话", typeof(string), null, System.Data.MappingType.Element);
                this.Columns.Add(this.column电话);
                this.column传真 = new DataColumn("传真", typeof(string), null, System.Data.MappingType.Element);
                this.Columns.Add(this.column传真);
                this.column电子邮件 = new DataColumn("电子邮件", typeof(string), null, System.Data.MappingType.Element);
                this.Columns.Add(this.column电子邮件);
                this.column开户银行 = new DataColumn("开户银行", typeof(string), null, System.Data.MappingType.Element);
                this.Columns.Add(this.column开户银行);
                this.column银行帐号 = new DataColumn("银行帐号", typeof(string), null, System.Data.MappingType.Element);
                this.Columns.Add(this.column银行帐号);
                this.Constraints.Add(new UniqueConstraint("Constraint1", new DataColumn[] {
                                this.column客户编号}, true));
                this.column客户编号.AllowDBNull = false;
                this.column客户编号.Unique = true;
                this.column客户名称.AllowDBNull = false;
                this.column企业法人.AllowDBNull = false;
                this.column客户地址.AllowDBNull = false;
                this.column邮政编码.AllowDBNull = false;
                this.column业务联系人.AllowDBNull = false;
                this.column电话.AllowDBNull = false;
                this.column电子邮件.AllowDBNull = false;
                this.column开户银行.AllowDBNull = false;
                this.column银行帐号.AllowDBNull = false;
            }
            
            public customerRow NewcustomerRow() {
                return ((customerRow)(this.NewRow()));
            }
            
            protected override DataRow NewRowFromBuilder(DataRowBuilder builder) {
                return new customerRow(builder);
            }
            
            protected override System.Type GetRowType() {
                return typeof(customerRow);
            }
            
            protected override void OnRowChanged(DataRowChangeEventArgs e) {
                base.OnRowChanged(e);
                if ((this.customerRowChanged != null)) {
                    this.customerRowChanged(this, new customerRowChangeEvent(((customerRow)(e.Row)), e.Action));
                }
            }
            
            protected override void OnRowChanging(DataRowChangeEventArgs e) {
                base.OnRowChanging(e);
                if ((this.customerRowChanging != null)) {
                    this.customerRowChanging(this, new customerRowChangeEvent(((customerRow)(e.Row)), e.Action));
                }
            }
            
            protected override void OnRowDeleted(DataRowChangeEventArgs e) {
                base.OnRowDeleted(e);
                if ((this.customerRowDeleted != null)) {
                    this.customerRowDeleted(this, new customerRowChangeEvent(((customerRow)(e.Row)), e.Action));
                }
            }
            
            protected override void OnRowDeleting(DataRowChangeEventArgs e) {
                base.OnRowDeleting(e);
                if ((this.customerRowDeleting != null)) {
                    this.customerRowDeleting(this, new customerRowChangeEvent(((customerRow)(e.Row)), e.Action));
                }
            }
            
            public void RemovecustomerRow(customerRow row) {
                this.Rows.Remove(row);
            }
        }
        
        [System.Diagnostics.DebuggerStepThrough()]
        public class customerRow : DataRow {
            
            private customerDataTable tablecustomer;
            
            internal customerRow(DataRowBuilder rb) : 
                    base(rb) {
                this.tablecustomer = ((customerDataTable)(this.Table));
            }
            
            public string 客户编号 {
                get {
                    return ((string)(this[this.tablecustomer.客户编号Column]));
                }
                set {
                    this[this.tablecustomer.客户编号Column] = value;
                }
            }
            
            public string 客户名称 {
                get {
                    return ((string)(this[this.tablecustomer.客户名称Column]));
                }
                set {
                    this[this.tablecustomer.客户名称Column] = value;
                }
            }
            
            public string 客户简称 {
                get {
                    try {
                        return ((string)(this[this.tablecustomer.客户简称Column]));
                    }
                    catch (InvalidCastException e) {
                        throw new StrongTypingException("无法获取值，因为它是 DBNull。", e);
                    }
                }
                set {
                    this[this.tablecustomer.客户简称Column] = value;
                }
            }
            
            public string 企业法人 {
                get {
                    return ((string)(this[this.tablecustomer.企业法人Column]));
                }
                set {
                    this[this.tablecustomer.企业法人Column] = value;
                }
            }
            
            public string 客户地址 {
                get {
                    return ((string)(this[this.tablecustomer.客户地址Column]));
                }
                set {
                    this[this.tablecustomer.客户地址Column] = value;
                }
            }
            
            public string 邮政编码 {
                get {
                    return ((string)(this[this.tablecustomer.邮政编码Column]));
                }
                set {
                    this[this.tablecustomer.邮政编码Column] = value;
                }
            }
            
            public string 业务联系人 {
                get {
                    return ((string)(this[this.tablecustomer.业务联系人Column]));
                }
                set {
                    this[this.tablecustomer.业务联系人Column] = value;
                }
            }
            
            public string 电话 {
                get {
                    return ((string)(this[this.tablecustomer.电话Column]));
                }
                set {
                    this[this.tablecustomer.电话Column] = value;
                }
            }
            
            public string 传真 {
                get {
                    try {
                        return ((string)(this[this.tablecustomer.传真Column]));
                    }
                    catch (InvalidCastException e) {
                        throw new StrongTypingException("无法获取值，因为它是 DBNull。", e);
                    }
                }
                set {
                    this[this.tablecustomer.传真Column] = value;
                }
            }
            
            public string 电子邮件 {
                get {
                    return ((string)(this[this.tablecustomer.电子邮件Column]));
                }
                set {
                    this[this.tablecustomer.电子邮件Column] = value;
                }
            }
            
            public string 开户银行 {
                get {
                    return ((string)(this[this.tablecustomer.开户银行Column]));
                }
                set {
                    this[this.tablecustomer.开户银行Column] = value;
                }
            }
            
            public string 银行帐号 {
                get {
                    return ((string)(this[this.tablecustomer.银行帐号Column]));
                }
                set {
                    this[this.tablecustomer.银行帐号Column] = value;
                }
            }
            
            public bool Is客户简称Null() {
                return this.IsNull(this.tablecustomer.客户简称Column);
            }
            
            public void Set客户简称Null() {
                this[this.tablecustomer.客户简称Column] = System.Convert.DBNull;
            }
            
            public bool Is传真Null() {
                return this.IsNull(this.tablecustomer.传真Column);
            }
            
            public void Set传真Null() {
                this[this.tablecustomer.传真Column] = System.Convert.DBNull;
            }
        }
        
        [System.Diagnostics.DebuggerStepThrough()]
        public class customerRowChangeEvent : EventArgs {
            
            private customerRow eventRow;
            
            private DataRowAction eventAction;
            
            public customerRowChangeEvent(customerRow row, DataRowAction action) {
                this.eventRow = row;
                this.eventAction = action;
            }
            
            public customerRow Row {
                get {
                    return this.eventRow;
                }
            }
            
            public DataRowAction Action {
                get {
                    return this.eventAction;
                }
            }
        }
    }
}