data1.designer.cs

从数据库导入文件到EXCEL 从EXCEL导入到数据库表 速度快

                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;
            }
            
            [System.Diagnostics.DebuggerNonUserCodeAttribute()]
            protected zSYSSequenceDataTable(System.Runtime.Serialization.SerializationInfo info, System.Runtime.Serialization.StreamingContext context) : 
                    base(info, context) {
                this.InitVars();
            }
            
            [System.Diagnostics.DebuggerNonUserCodeAttribute()]
            public System.Data.DataColumn zTableNameColumn {
                get {
                    return this.columnzTableName;
                }
            }
            
            [System.Diagnostics.DebuggerNonUserCodeAttribute()]
            public System.Data.DataColumn zFieldNameColumn {
                get {
                    return this.columnzFieldName;
                }
            }
            
            [System.Diagnostics.DebuggerNonUserCodeAttribute()]
            public System.Data.DataColumn zMinValueColumn {
                get {
                    return this.columnzMinValue;
                }
            }
            
            [System.Diagnostics.DebuggerNonUserCodeAttribute()]
            public System.Data.DataColumn zValidValueColumn {
                get {
                    return this.columnzValidValue;
                }
            }
            
            [System.Diagnostics.DebuggerNonUserCodeAttribute()]
            public System.Data.DataColumn zMaxValueColumn {
                get {
                    return this.columnzMaxValue;
                }
            }
            
            [System.Diagnostics.DebuggerNonUserCodeAttribute()]
            public System.Data.DataColumn zMemoColumn {
                get {
                    return this.columnzMemo;
                }
            }
            
            [System.Diagnostics.DebuggerNonUserCodeAttribute()]
            public System.Data.DataColumn zIsValidColumn {
                get {
                    return this.columnzIsValid;
                }
            }
            
            [System.Diagnostics.DebuggerNonUserCodeAttribute()]
            public System.Data.DataColumn zCreatedByColumn {
                get {
                    return this.columnzCreatedBy;
                }
            }
            
            [System.Diagnostics.DebuggerNonUserCodeAttribute()]
            public System.Data.DataColumn zDateCreatedColumn {
                get {
                    return this.columnzDateCreated;
                }
            }
            
            [System.Diagnostics.DebuggerNonUserCodeAttribute()]
            [System.ComponentModel.Browsable(false)]
            public int Count {
                get {
                    return this.Rows.Count;
                }
            }
            
            [System.Diagnostics.DebuggerNonUserCodeAttribute()]
            public zSYSSequenceRow this[int index] {
                get {
                    return ((zSYSSequenceRow)(this.Rows[index]));
                }
            }
            
            public event zSYSSequenceRowChangeEventHandler zSYSSequenceRowChanging;
            
            public event zSYSSequenceRowChangeEventHandler zSYSSequenceRowChanged;
            
            public event zSYSSequenceRowChangeEventHandler zSYSSequenceRowDeleting;
            
            public event zSYSSequenceRowChangeEventHandler zSYSSequenceRowDeleted;
            
            [System.Diagnostics.DebuggerNonUserCodeAttribute()]
            public void AddzSYSSequenceRow(zSYSSequenceRow row) {
                this.Rows.Add(row);
            }
            
            [System.Diagnostics.DebuggerNonUserCodeAttribute()]
            public zSYSSequenceRow AddzSYSSequenceRow(string zTableName, string zFieldName, long zMinValue, long zValidValue, long zMaxValue, string zMemo, int zIsValid, string zCreatedBy, System.DateTime zDateCreated) {
                zSYSSequenceRow rowzSYSSequenceRow = ((zSYSSequenceRow)(this.NewRow()));
                rowzSYSSequenceRow.ItemArray = new object[] {
                        zTableName,
                        zFieldName,
                        zMinValue,
                        zValidValue,
                        zMaxValue,
                        zMemo,
                        zIsValid,
                        zCreatedBy,
                        zDateCreated};
                this.Rows.Add(rowzSYSSequenceRow);
                return rowzSYSSequenceRow;
            }
            
            [System.Diagnostics.DebuggerNonUserCodeAttribute()]
            public zSYSSequenceRow FindByzTableName(string zTableName) {
                return ((zSYSSequenceRow)(this.Rows.Find(new object[] {
                            zTableName})));
            }
            
            [System.Diagnostics.DebuggerNonUserCodeAttribute()]
            public virtual System.Collections.IEnumerator GetEnumerator() {
                return this.Rows.GetEnumerator();
            }
            
            [System.Diagnostics.DebuggerNonUserCodeAttribute()]
            public override System.Data.DataTable Clone() {
                zSYSSequenceDataTable cln = ((zSYSSequenceDataTable)(base.Clone()));
                cln.InitVars();
                return cln;
            }
            
            [System.Diagnostics.DebuggerNonUserCodeAttribute()]
            protected override System.Data.DataTable CreateInstance() {
                return new zSYSSequenceDataTable();
            }
            
            [System.Diagnostics.DebuggerNonUserCodeAttribute()]
            internal void InitVars() {
                this.columnzTableName = base.Columns["zTableName"];
                this.columnzFieldName = base.Columns["zFieldName"];
                this.columnzMinValue = base.Columns["zMinValue"];
                this.columnzValidValue = base.Columns["zValidValue"];
                this.columnzMaxValue = base.Columns["zMaxValue"];
                this.columnzMemo = base.Columns["zMemo"];
                this.columnzIsValid = base.Columns["zIsValid"];
                this.columnzCreatedBy = base.Columns["zCreatedBy"];
                this.columnzDateCreated = base.Columns["zDateCreated"];
            }
            
            [System.Diagnostics.DebuggerNonUserCodeAttribute()]
            private void InitClass() {
                this.columnzTableName = new System.Data.DataColumn("zTableName", typeof(string), null, System.Data.MappingType.Element);
                base.Columns.Add(this.columnzTableName);
                this.columnzFieldName = new System.Data.DataColumn("zFieldName", typeof(string), null, System.Data.MappingType.Element);
                base.Columns.Add(this.columnzFieldName);
                this.columnzMinValue = new System.Data.DataColumn("zMinValue", typeof(long), null, System.Data.MappingType.Element);
                base.Columns.Add(this.columnzMinValue);
                this.columnzValidValue = new System.Data.DataColumn("zValidValue", typeof(long), null, System.Data.MappingType.Element);
                base.Columns.Add(this.columnzValidValue);
                this.columnzMaxValue = new System.Data.DataColumn("zMaxValue", typeof(long), null, System.Data.MappingType.Element);
                base.Columns.Add(this.columnzMaxValue);
                this.columnzMemo = new System.Data.DataColumn("zMemo", typeof(string), null, System.Data.MappingType.Element);
                base.Columns.Add(this.columnzMemo);
                this.columnzIsValid = new System.Data.DataColumn("zIsValid", typeof(int), null, System.Data.MappingType.Element);
                base.Columns.Add(this.columnzIsValid);
                this.columnzCreatedBy = new System.Data.DataColumn("zCreatedBy", typeof(string), null, System.Data.MappingType.Element);
                base.Columns.Add(this.columnzCreatedBy);
                this.columnzDateCreated = new System.Data.DataColumn("zDateCreated", typeof(System.DateTime), null, System.Data.MappingType.Element);
                base.Columns.Add(this.columnzDateCreated);
                this.Constraints.Add(new System.Data.UniqueConstraint("Constraint1", new System.Data.DataColumn[] {
                                this.columnzTableName}, true));
                this.columnzTableName.AllowDBNull = false;
                this.columnzTableName.Unique = true;
                this.columnzFieldName.AllowDBNull = false;
            }
            
            [System.Diagnostics.DebuggerNonUserCodeAttribute()]
            public zSYSSequenceRow NewzSYSSequenceRow() {
                return ((zSYSSequenceRow)(this.NewRow()));
            }
            
            [System.Diagnostics.DebuggerNonUserCodeAttribute()]
            protected override System.Data.DataRow NewRowFromBuilder(System.Data.DataRowBuilder builder) {
                return new zSYSSequenceRow(builder);
            }
            
            [System.Diagnostics.DebuggerNonUserCodeAttribute()]
            protected override System.Type GetRowType() {
                return typeof(zSYSSequenceRow);
            }
            
            [System.Diagnostics.DebuggerNonUserCodeAttribute()]
            protected override void OnRowChanged(System.Data.DataRowChangeEventArgs e) {
                base.OnRowChanged(e);
                if ((this.zSYSSequenceRowChanged != null)) {
                    this.zSYSSequenceRowChanged(this, new zSYSSequenceRowChangeEvent(((zSYSSequenceRow)(e.Row)), e.Action));
                }
            }
            
            [System.Diagnostics.DebuggerNonUserCodeAttribute()]
            protected override void OnRowChanging(System.Data.DataRowChangeEventArgs e) {
                base.OnRowChanging(e);
                if ((this.zSYSSequenceRowChanging != null)) {
                    this.zSYSSequenceRowChanging(this, new zSYSSequenceRowChangeEvent(((zSYSSequenceRow)(e.Row)), e.Action));
                }
            }
            
            [System.Diagnostics.DebuggerNonUserCodeAttribute()]
            protected override void OnRowDeleted(System.Data.DataRowChangeEventArgs e) {
                base.OnRowDeleted(e);
                if ((this.zSYSSequenceRowDeleted != null)) {
                    this.zSYSSequenceRowDeleted(this, new zSYSSequenceRowChangeEvent(((zSYSSequenceRow)(e.Row)), e.Action));
                }
            }
            
            [System.Diagnostics.DebuggerNonUserCodeAttribute()]
            protected override void OnRowDeleting(System.Data.DataRowChangeEventArgs e) {
                base.OnRowDeleting(e);
                if ((this.zSYSSequenceRowDeleting != null)) {
                    this.zSYSSequenceRowDeleting(this, new zSYSSequenceRowChangeEvent(((zSYSSequenceRow)(e.Row)), e.Action));
                }
            }
            
            [System.Diagnostics.DebuggerNonUserCodeAttribute()]
            public void RemovezSYSSequenceRow(zSYSSequenceRow row) {
                this.Rows.Remove(row);
            }
            
            [System.Diagnostics.DebuggerNonUserCodeAttribute()]
            public static System.Xml.Schema.XmlSchemaComplexType GetTypedTableSchema(System.Xml.Schema.XmlSchemaSet xs) {
                System.Xml.Schema.XmlSchemaComplexType type = new System.Xml.Schema.XmlSchemaComplexType();
                System.Xml.Schema.XmlSchemaSequence sequence = new System.Xml.Schema.XmlSchemaSequence();
                data1 ds = new data1();
                xs.Add(ds.GetSchemaSerializable());
                System.Xml.Schema.XmlSchemaAny any1 = new System.Xml.Schema.XmlSchemaAny();
                any1.Namespace = "http://www.w3.org/2001/XMLSchema";
                any1.MinOccurs = new decimal(0);
                any1.MaxOccurs = decimal.MaxValue;
                any1.ProcessContents = System.Xml.Schema.XmlSchemaContentProcessing.Lax;
                sequence.Items.Add(any1);
                System.Xml.Schema.XmlSchemaAny any2 = new System.Xml.Schema.XmlSchemaAny();
                any2.Namespace = "urn:schemas-microsoft-com:xml-diffgram-v1";