//------------------------------------------------------------------------------ // // This code was generated by a tool. // Runtime Version:2.0.50727.4234 // // Changes to this file may cause incorrect behavior and will be lost if // the code is regenerated. // //------------------------------------------------------------------------------ #pragma warning disable 1591 namespace WestinghouseROImport { /// ///Represents a strongly typed in-memory cache of data. /// [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "2.0.0.0")] [global::System.Serializable()] [global::System.ComponentModel.DesignerCategoryAttribute("code")] [global::System.ComponentModel.ToolboxItem(true)] [global::System.Xml.Serialization.XmlSchemaProviderAttribute("GetTypedDataSetSchema")] [global::System.Xml.Serialization.XmlRootAttribute("ROImportDataSet")] [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.DataSet")] public partial class ROImportDataSet : global::System.Data.DataSet { private ImportSTP_qryDataTable tableImportSTP_qry; private ImportMEL_qryDataTable tableImportMEL_qry; private ImportARP_tblDataTable tableImportARP_tbl; private global::System.Data.SchemaSerializationMode _schemaSerializationMode = global::System.Data.SchemaSerializationMode.IncludeSchema; [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] public ROImportDataSet() { this.BeginInit(); this.InitClass(); global::System.ComponentModel.CollectionChangeEventHandler schemaChangedHandler = new global::System.ComponentModel.CollectionChangeEventHandler(this.SchemaChanged); base.Tables.CollectionChanged += schemaChangedHandler; base.Relations.CollectionChanged += schemaChangedHandler; this.EndInit(); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] protected ROImportDataSet(global::System.Runtime.Serialization.SerializationInfo info, global::System.Runtime.Serialization.StreamingContext context) : base(info, context, false) { if ((this.IsBinarySerialized(info, context) == true)) { this.InitVars(false); global::System.ComponentModel.CollectionChangeEventHandler schemaChangedHandler1 = new global::System.ComponentModel.CollectionChangeEventHandler(this.SchemaChanged); this.Tables.CollectionChanged += schemaChangedHandler1; this.Relations.CollectionChanged += schemaChangedHandler1; return; } string strSchema = ((string)(info.GetValue("XmlSchema", typeof(string)))); if ((this.DetermineSchemaSerializationMode(info, context) == global::System.Data.SchemaSerializationMode.IncludeSchema)) { global::System.Data.DataSet ds = new global::System.Data.DataSet(); ds.ReadXmlSchema(new global::System.Xml.XmlTextReader(new global::System.IO.StringReader(strSchema))); if ((ds.Tables["ImportSTP_qry"] != null)) { base.Tables.Add(new ImportSTP_qryDataTable(ds.Tables["ImportSTP_qry"])); } if ((ds.Tables["ImportMEL_qry"] != null)) { base.Tables.Add(new ImportMEL_qryDataTable(ds.Tables["ImportMEL_qry"])); } if ((ds.Tables["ImportARP_tbl"] != null)) { base.Tables.Add(new ImportARP_tblDataTable(ds.Tables["ImportARP_tbl"])); } 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, global::System.Data.MissingSchemaAction.Add); this.InitVars(); } else { this.ReadXmlSchema(new global::System.Xml.XmlTextReader(new global::System.IO.StringReader(strSchema))); } this.GetSerializationData(info, context); global::System.ComponentModel.CollectionChangeEventHandler schemaChangedHandler = new global::System.ComponentModel.CollectionChangeEventHandler(this.SchemaChanged); base.Tables.CollectionChanged += schemaChangedHandler; this.Relations.CollectionChanged += schemaChangedHandler; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.ComponentModel.Browsable(false)] [global::System.ComponentModel.DesignerSerializationVisibility(global::System.ComponentModel.DesignerSerializationVisibility.Content)] public ImportSTP_qryDataTable ImportSTP_qry { get { return this.tableImportSTP_qry; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.ComponentModel.Browsable(false)] [global::System.ComponentModel.DesignerSerializationVisibility(global::System.ComponentModel.DesignerSerializationVisibility.Content)] public ImportMEL_qryDataTable ImportMEL_qry { get { return this.tableImportMEL_qry; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.ComponentModel.Browsable(false)] [global::System.ComponentModel.DesignerSerializationVisibility(global::System.ComponentModel.DesignerSerializationVisibility.Content)] public ImportARP_tblDataTable ImportARP_tbl { get { return this.tableImportARP_tbl; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.ComponentModel.BrowsableAttribute(true)] [global::System.ComponentModel.DesignerSerializationVisibilityAttribute(global::System.ComponentModel.DesignerSerializationVisibility.Visible)] public override global::System.Data.SchemaSerializationMode SchemaSerializationMode { get { return this._schemaSerializationMode; } set { this._schemaSerializationMode = value; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.ComponentModel.DesignerSerializationVisibilityAttribute(global::System.ComponentModel.DesignerSerializationVisibility.Hidden)] public new global::System.Data.DataTableCollection Tables { get { return base.Tables; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.ComponentModel.DesignerSerializationVisibilityAttribute(global::System.ComponentModel.DesignerSerializationVisibility.Hidden)] public new global::System.Data.DataRelationCollection Relations { get { return base.Relations; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] protected override void InitializeDerivedDataSet() { this.BeginInit(); this.InitClass(); this.EndInit(); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] public override global::System.Data.DataSet Clone() { ROImportDataSet cln = ((ROImportDataSet)(base.Clone())); cln.InitVars(); cln.SchemaSerializationMode = this.SchemaSerializationMode; return cln; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] protected override bool ShouldSerializeTables() { return false; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] protected override bool ShouldSerializeRelations() { return false; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] protected override void ReadXmlSerializable(global::System.Xml.XmlReader reader) { if ((this.DetermineSchemaSerializationMode(reader) == global::System.Data.SchemaSerializationMode.IncludeSchema)) { this.Reset(); global::System.Data.DataSet ds = new global::System.Data.DataSet(); ds.ReadXml(reader); if ((ds.Tables["ImportSTP_qry"] != null)) { base.Tables.Add(new ImportSTP_qryDataTable(ds.Tables["ImportSTP_qry"])); } if ((ds.Tables["ImportMEL_qry"] != null)) { base.Tables.Add(new ImportMEL_qryDataTable(ds.Tables["ImportMEL_qry"])); } if ((ds.Tables["ImportARP_tbl"] != null)) { base.Tables.Add(new ImportARP_tblDataTable(ds.Tables["ImportARP_tbl"])); } 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, global::System.Data.MissingSchemaAction.Add); this.InitVars(); } else { this.ReadXml(reader); this.InitVars(); } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] protected override global::System.Xml.Schema.XmlSchema GetSchemaSerializable() { global::System.IO.MemoryStream stream = new global::System.IO.MemoryStream(); this.WriteXmlSchema(new global::System.Xml.XmlTextWriter(stream, null)); stream.Position = 0; return global::System.Xml.Schema.XmlSchema.Read(new global::System.Xml.XmlTextReader(stream), null); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] internal void InitVars() { this.InitVars(true); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] internal void InitVars(bool initTable) { this.tableImportSTP_qry = ((ImportSTP_qryDataTable)(base.Tables["ImportSTP_qry"])); if ((initTable == true)) { if ((this.tableImportSTP_qry != null)) { this.tableImportSTP_qry.InitVars(); } } this.tableImportMEL_qry = ((ImportMEL_qryDataTable)(base.Tables["ImportMEL_qry"])); if ((initTable == true)) { if ((this.tableImportMEL_qry != null)) { this.tableImportMEL_qry.InitVars(); } } this.tableImportARP_tbl = ((ImportARP_tblDataTable)(base.Tables["ImportARP_tbl"])); if ((initTable == true)) { if ((this.tableImportARP_tbl != null)) { this.tableImportARP_tbl.InitVars(); } } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] private void InitClass() { this.DataSetName = "ROImportDataSet"; this.Prefix = ""; this.Namespace = "http://tempuri.org/ROImportDataSet.xsd"; this.EnforceConstraints = true; this.SchemaSerializationMode = global::System.Data.SchemaSerializationMode.IncludeSchema; this.tableImportSTP_qry = new ImportSTP_qryDataTable(); base.Tables.Add(this.tableImportSTP_qry); this.tableImportMEL_qry = new ImportMEL_qryDataTable(); base.Tables.Add(this.tableImportMEL_qry); this.tableImportARP_tbl = new ImportARP_tblDataTable(); base.Tables.Add(this.tableImportARP_tbl); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] private bool ShouldSerializeImportSTP_qry() { return false; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] private bool ShouldSerializeImportMEL_qry() { return false; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] private bool ShouldSerializeImportARP_tbl() { return false; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] private void SchemaChanged(object sender, global::System.ComponentModel.CollectionChangeEventArgs e) { if ((e.Action == global::System.ComponentModel.CollectionChangeAction.Remove)) { this.InitVars(); } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedDataSetSchema(global::System.Xml.Schema.XmlSchemaSet xs) { ROImportDataSet ds = new ROImportDataSet(); global::System.Xml.Schema.XmlSchemaComplexType type = new global::System.Xml.Schema.XmlSchemaComplexType(); global::System.Xml.Schema.XmlSchemaSequence sequence = new global::System.Xml.Schema.XmlSchemaSequence(); global::System.Xml.Schema.XmlSchemaAny any = new global::System.Xml.Schema.XmlSchemaAny(); any.Namespace = ds.Namespace; sequence.Items.Add(any); type.Particle = sequence; global::System.Xml.Schema.XmlSchema dsSchema = ds.GetSchemaSerializable(); if (xs.Contains(dsSchema.TargetNamespace)) { global::System.IO.MemoryStream s1 = new global::System.IO.MemoryStream(); global::System.IO.MemoryStream s2 = new global::System.IO.MemoryStream(); try { global::System.Xml.Schema.XmlSchema schema = null; dsSchema.Write(s1); for (global::System.Collections.IEnumerator schemas = xs.Schemas(dsSchema.TargetNamespace).GetEnumerator(); schemas.MoveNext(); ) { schema = ((global::System.Xml.Schema.XmlSchema)(schemas.Current)); s2.SetLength(0); schema.Write(s2); if ((s1.Length == s2.Length)) { s1.Position = 0; s2.Position = 0; for (; ((s1.Position != s1.Length) && (s1.ReadByte() == s2.ReadByte())); ) { ; } if ((s1.Position == s1.Length)) { return type; } } } } finally { if ((s1 != null)) { s1.Close(); } if ((s2 != null)) { s2.Close(); } } } xs.Add(dsSchema); return type; } public delegate void ImportSTP_qryRowChangeEventHandler(object sender, ImportSTP_qryRowChangeEvent e); public delegate void ImportMEL_qryRowChangeEventHandler(object sender, ImportMEL_qryRowChangeEvent e); public delegate void ImportARP_tblRowChangeEventHandler(object sender, ImportARP_tblRowChangeEvent e); /// ///Represents the strongly named DataTable class. /// [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "2.0.0.0")] [global::System.Serializable()] [global::System.Xml.Serialization.XmlSchemaProviderAttribute("GetTypedTableSchema")] public partial class ImportSTP_qryDataTable : global::System.Data.DataTable, global::System.Collections.IEnumerable { private global::System.Data.DataColumn columnParameter; private global::System.Data.DataColumn columnName; private global::System.Data.DataColumn columnValue; private global::System.Data.DataColumn columnDescription; [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] public ImportSTP_qryDataTable() { this.TableName = "ImportSTP_qry"; this.BeginInit(); this.InitClass(); this.EndInit(); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] internal ImportSTP_qryDataTable(global::System.Data.DataTable table) { this.TableName = 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; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] protected ImportSTP_qryDataTable(global::System.Runtime.Serialization.SerializationInfo info, global::System.Runtime.Serialization.StreamingContext context) : base(info, context) { this.InitVars(); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] public global::System.Data.DataColumn ParameterColumn { get { return this.columnParameter; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] public global::System.Data.DataColumn NameColumn { get { return this.columnName; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] public global::System.Data.DataColumn ValueColumn { get { return this.columnValue; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] public global::System.Data.DataColumn DescriptionColumn { get { return this.columnDescription; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.ComponentModel.Browsable(false)] public int Count { get { return this.Rows.Count; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] public ImportSTP_qryRow this[int index] { get { return ((ImportSTP_qryRow)(this.Rows[index])); } } public event ImportSTP_qryRowChangeEventHandler ImportSTP_qryRowChanging; public event ImportSTP_qryRowChangeEventHandler ImportSTP_qryRowChanged; public event ImportSTP_qryRowChangeEventHandler ImportSTP_qryRowDeleting; public event ImportSTP_qryRowChangeEventHandler ImportSTP_qryRowDeleted; [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] public void AddImportSTP_qryRow(ImportSTP_qryRow row) { this.Rows.Add(row); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] public ImportSTP_qryRow AddImportSTP_qryRow(string Parameter, string Name, string Value, string Description) { ImportSTP_qryRow rowImportSTP_qryRow = ((ImportSTP_qryRow)(this.NewRow())); object[] columnValuesArray = new object[] { Parameter, Name, Value, Description}; rowImportSTP_qryRow.ItemArray = columnValuesArray; this.Rows.Add(rowImportSTP_qryRow); return rowImportSTP_qryRow; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] public virtual global::System.Collections.IEnumerator GetEnumerator() { return this.Rows.GetEnumerator(); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] public override global::System.Data.DataTable Clone() { ImportSTP_qryDataTable cln = ((ImportSTP_qryDataTable)(base.Clone())); cln.InitVars(); return cln; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] protected override global::System.Data.DataTable CreateInstance() { return new ImportSTP_qryDataTable(); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] internal void InitVars() { this.columnParameter = base.Columns["Parameter"]; this.columnName = base.Columns["Name"]; this.columnValue = base.Columns["Value"]; this.columnDescription = base.Columns["Description"]; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] private void InitClass() { this.columnParameter = new global::System.Data.DataColumn("Parameter", typeof(string), null, global::System.Data.MappingType.Element); base.Columns.Add(this.columnParameter); this.columnName = new global::System.Data.DataColumn("Name", typeof(string), null, global::System.Data.MappingType.Element); base.Columns.Add(this.columnName); this.columnValue = new global::System.Data.DataColumn("Value", typeof(string), null, global::System.Data.MappingType.Element); base.Columns.Add(this.columnValue); this.columnDescription = new global::System.Data.DataColumn("Description", typeof(string), null, global::System.Data.MappingType.Element); base.Columns.Add(this.columnDescription); this.columnParameter.MaxLength = 255; this.columnName.MaxLength = 255; this.columnValue.MaxLength = 255; this.columnDescription.MaxLength = 255; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] public ImportSTP_qryRow NewImportSTP_qryRow() { return ((ImportSTP_qryRow)(this.NewRow())); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] protected override global::System.Data.DataRow NewRowFromBuilder(global::System.Data.DataRowBuilder builder) { return new ImportSTP_qryRow(builder); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] protected override global::System.Type GetRowType() { return typeof(ImportSTP_qryRow); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] protected override void OnRowChanged(global::System.Data.DataRowChangeEventArgs e) { base.OnRowChanged(e); if ((this.ImportSTP_qryRowChanged != null)) { this.ImportSTP_qryRowChanged(this, new ImportSTP_qryRowChangeEvent(((ImportSTP_qryRow)(e.Row)), e.Action)); } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] protected override void OnRowChanging(global::System.Data.DataRowChangeEventArgs e) { base.OnRowChanging(e); if ((this.ImportSTP_qryRowChanging != null)) { this.ImportSTP_qryRowChanging(this, new ImportSTP_qryRowChangeEvent(((ImportSTP_qryRow)(e.Row)), e.Action)); } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] protected override void OnRowDeleted(global::System.Data.DataRowChangeEventArgs e) { base.OnRowDeleted(e); if ((this.ImportSTP_qryRowDeleted != null)) { this.ImportSTP_qryRowDeleted(this, new ImportSTP_qryRowChangeEvent(((ImportSTP_qryRow)(e.Row)), e.Action)); } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] protected override void OnRowDeleting(global::System.Data.DataRowChangeEventArgs e) { base.OnRowDeleting(e); if ((this.ImportSTP_qryRowDeleting != null)) { this.ImportSTP_qryRowDeleting(this, new ImportSTP_qryRowChangeEvent(((ImportSTP_qryRow)(e.Row)), e.Action)); } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] public void RemoveImportSTP_qryRow(ImportSTP_qryRow row) { this.Rows.Remove(row); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedTableSchema(global::System.Xml.Schema.XmlSchemaSet xs) { global::System.Xml.Schema.XmlSchemaComplexType type = new global::System.Xml.Schema.XmlSchemaComplexType(); global::System.Xml.Schema.XmlSchemaSequence sequence = new global::System.Xml.Schema.XmlSchemaSequence(); ROImportDataSet ds = new ROImportDataSet(); global::System.Xml.Schema.XmlSchemaAny any1 = new global::System.Xml.Schema.XmlSchemaAny(); any1.Namespace = "http://www.w3.org/2001/XMLSchema"; any1.MinOccurs = new decimal(0); any1.MaxOccurs = decimal.MaxValue; any1.ProcessContents = global::System.Xml.Schema.XmlSchemaContentProcessing.Lax; sequence.Items.Add(any1); global::System.Xml.Schema.XmlSchemaAny any2 = new global::System.Xml.Schema.XmlSchemaAny(); any2.Namespace = "urn:schemas-microsoft-com:xml-diffgram-v1"; any2.MinOccurs = new decimal(1); any2.ProcessContents = global::System.Xml.Schema.XmlSchemaContentProcessing.Lax; sequence.Items.Add(any2); global::System.Xml.Schema.XmlSchemaAttribute attribute1 = new global::System.Xml.Schema.XmlSchemaAttribute(); attribute1.Name = "namespace"; attribute1.FixedValue = ds.Namespace; type.Attributes.Add(attribute1); global::System.Xml.Schema.XmlSchemaAttribute attribute2 = new global::System.Xml.Schema.XmlSchemaAttribute(); attribute2.Name = "tableTypeName"; attribute2.FixedValue = "ImportSTP_qryDataTable"; type.Attributes.Add(attribute2); type.Particle = sequence; global::System.Xml.Schema.XmlSchema dsSchema = ds.GetSchemaSerializable(); if (xs.Contains(dsSchema.TargetNamespace)) { global::System.IO.MemoryStream s1 = new global::System.IO.MemoryStream(); global::System.IO.MemoryStream s2 = new global::System.IO.MemoryStream(); try { global::System.Xml.Schema.XmlSchema schema = null; dsSchema.Write(s1); for (global::System.Collections.IEnumerator schemas = xs.Schemas(dsSchema.TargetNamespace).GetEnumerator(); schemas.MoveNext(); ) { schema = ((global::System.Xml.Schema.XmlSchema)(schemas.Current)); s2.SetLength(0); schema.Write(s2); if ((s1.Length == s2.Length)) { s1.Position = 0; s2.Position = 0; for (; ((s1.Position != s1.Length) && (s1.ReadByte() == s2.ReadByte())); ) { ; } if ((s1.Position == s1.Length)) { return type; } } } } finally { if ((s1 != null)) { s1.Close(); } if ((s2 != null)) { s2.Close(); } } } xs.Add(dsSchema); return type; } } /// ///Represents the strongly named DataTable class. /// [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "2.0.0.0")] [global::System.Serializable()] [global::System.Xml.Serialization.XmlSchemaProviderAttribute("GetTypedTableSchema")] public partial class ImportMEL_qryDataTable : global::System.Data.DataTable, global::System.Collections.IEnumerable { private global::System.Data.DataColumn columnSystemID; private global::System.Data.DataColumn columnSystemDesc; private global::System.Data.DataColumn columnComponentID; private global::System.Data.DataColumn columnCompDesc; private global::System.Data.DataColumn columnFullName; private global::System.Data.DataColumn columnShortName; private global::System.Data.DataColumn columnRoom; private global::System.Data.DataColumn columnDescription; private global::System.Data.DataColumn columnCommonDesc; [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] public ImportMEL_qryDataTable() { this.TableName = "ImportMEL_qry"; this.BeginInit(); this.InitClass(); this.EndInit(); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] internal ImportMEL_qryDataTable(global::System.Data.DataTable table) { this.TableName = 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; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] protected ImportMEL_qryDataTable(global::System.Runtime.Serialization.SerializationInfo info, global::System.Runtime.Serialization.StreamingContext context) : base(info, context) { this.InitVars(); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] public global::System.Data.DataColumn SystemIDColumn { get { return this.columnSystemID; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] public global::System.Data.DataColumn SystemDescColumn { get { return this.columnSystemDesc; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] public global::System.Data.DataColumn ComponentIDColumn { get { return this.columnComponentID; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] public global::System.Data.DataColumn CompDescColumn { get { return this.columnCompDesc; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] public global::System.Data.DataColumn FullNameColumn { get { return this.columnFullName; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] public global::System.Data.DataColumn ShortNameColumn { get { return this.columnShortName; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] public global::System.Data.DataColumn RoomColumn { get { return this.columnRoom; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] public global::System.Data.DataColumn DescriptionColumn { get { return this.columnDescription; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] public global::System.Data.DataColumn CommonDescColumn { get { return this.columnCommonDesc; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.ComponentModel.Browsable(false)] public int Count { get { return this.Rows.Count; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] public ImportMEL_qryRow this[int index] { get { return ((ImportMEL_qryRow)(this.Rows[index])); } } public event ImportMEL_qryRowChangeEventHandler ImportMEL_qryRowChanging; public event ImportMEL_qryRowChangeEventHandler ImportMEL_qryRowChanged; public event ImportMEL_qryRowChangeEventHandler ImportMEL_qryRowDeleting; public event ImportMEL_qryRowChangeEventHandler ImportMEL_qryRowDeleted; [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] public void AddImportMEL_qryRow(ImportMEL_qryRow row) { this.Rows.Add(row); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] public ImportMEL_qryRow AddImportMEL_qryRow(string SystemID, string SystemDesc, string ComponentID, string CompDesc, string FullName, string ShortName, string Room, string Description, string CommonDesc) { ImportMEL_qryRow rowImportMEL_qryRow = ((ImportMEL_qryRow)(this.NewRow())); object[] columnValuesArray = new object[] { SystemID, SystemDesc, ComponentID, CompDesc, FullName, ShortName, Room, Description, CommonDesc}; rowImportMEL_qryRow.ItemArray = columnValuesArray; this.Rows.Add(rowImportMEL_qryRow); return rowImportMEL_qryRow; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] public virtual global::System.Collections.IEnumerator GetEnumerator() { return this.Rows.GetEnumerator(); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] public override global::System.Data.DataTable Clone() { ImportMEL_qryDataTable cln = ((ImportMEL_qryDataTable)(base.Clone())); cln.InitVars(); return cln; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] protected override global::System.Data.DataTable CreateInstance() { return new ImportMEL_qryDataTable(); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] internal void InitVars() { this.columnSystemID = base.Columns["SystemID"]; this.columnSystemDesc = base.Columns["SystemDesc"]; this.columnComponentID = base.Columns["ComponentID"]; this.columnCompDesc = base.Columns["CompDesc"]; this.columnFullName = base.Columns["FullName"]; this.columnShortName = base.Columns["ShortName"]; this.columnRoom = base.Columns["Room"]; this.columnDescription = base.Columns["Description"]; this.columnCommonDesc = base.Columns["CommonDesc"]; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] private void InitClass() { this.columnSystemID = new global::System.Data.DataColumn("SystemID", typeof(string), null, global::System.Data.MappingType.Element); base.Columns.Add(this.columnSystemID); this.columnSystemDesc = new global::System.Data.DataColumn("SystemDesc", typeof(string), null, global::System.Data.MappingType.Element); base.Columns.Add(this.columnSystemDesc); this.columnComponentID = new global::System.Data.DataColumn("ComponentID", typeof(string), null, global::System.Data.MappingType.Element); base.Columns.Add(this.columnComponentID); this.columnCompDesc = new global::System.Data.DataColumn("CompDesc", typeof(string), null, global::System.Data.MappingType.Element); base.Columns.Add(this.columnCompDesc); this.columnFullName = new global::System.Data.DataColumn("FullName", typeof(string), null, global::System.Data.MappingType.Element); base.Columns.Add(this.columnFullName); this.columnShortName = new global::System.Data.DataColumn("ShortName", typeof(string), null, global::System.Data.MappingType.Element); base.Columns.Add(this.columnShortName); this.columnRoom = new global::System.Data.DataColumn("Room", typeof(string), null, global::System.Data.MappingType.Element); base.Columns.Add(this.columnRoom); this.columnDescription = new global::System.Data.DataColumn("Description", typeof(string), null, global::System.Data.MappingType.Element); base.Columns.Add(this.columnDescription); this.columnCommonDesc = new global::System.Data.DataColumn("CommonDesc", typeof(string), null, global::System.Data.MappingType.Element); base.Columns.Add(this.columnCommonDesc); this.columnSystemID.ReadOnly = true; this.columnSystemID.MaxLength = 255; this.columnSystemDesc.MaxLength = 255; this.columnComponentID.ReadOnly = true; this.columnComponentID.MaxLength = 255; this.columnCompDesc.MaxLength = 255; this.columnFullName.MaxLength = 255; this.columnShortName.MaxLength = 255; this.columnRoom.MaxLength = 255; this.columnDescription.MaxLength = 255; this.columnCommonDesc.MaxLength = 255; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] public ImportMEL_qryRow NewImportMEL_qryRow() { return ((ImportMEL_qryRow)(this.NewRow())); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] protected override global::System.Data.DataRow NewRowFromBuilder(global::System.Data.DataRowBuilder builder) { return new ImportMEL_qryRow(builder); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] protected override global::System.Type GetRowType() { return typeof(ImportMEL_qryRow); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] protected override void OnRowChanged(global::System.Data.DataRowChangeEventArgs e) { base.OnRowChanged(e); if ((this.ImportMEL_qryRowChanged != null)) { this.ImportMEL_qryRowChanged(this, new ImportMEL_qryRowChangeEvent(((ImportMEL_qryRow)(e.Row)), e.Action)); } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] protected override void OnRowChanging(global::System.Data.DataRowChangeEventArgs e) { base.OnRowChanging(e); if ((this.ImportMEL_qryRowChanging != null)) { this.ImportMEL_qryRowChanging(this, new ImportMEL_qryRowChangeEvent(((ImportMEL_qryRow)(e.Row)), e.Action)); } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] protected override void OnRowDeleted(global::System.Data.DataRowChangeEventArgs e) { base.OnRowDeleted(e); if ((this.ImportMEL_qryRowDeleted != null)) { this.ImportMEL_qryRowDeleted(this, new ImportMEL_qryRowChangeEvent(((ImportMEL_qryRow)(e.Row)), e.Action)); } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] protected override void OnRowDeleting(global::System.Data.DataRowChangeEventArgs e) { base.OnRowDeleting(e); if ((this.ImportMEL_qryRowDeleting != null)) { this.ImportMEL_qryRowDeleting(this, new ImportMEL_qryRowChangeEvent(((ImportMEL_qryRow)(e.Row)), e.Action)); } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] public void RemoveImportMEL_qryRow(ImportMEL_qryRow row) { this.Rows.Remove(row); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedTableSchema(global::System.Xml.Schema.XmlSchemaSet xs) { global::System.Xml.Schema.XmlSchemaComplexType type = new global::System.Xml.Schema.XmlSchemaComplexType(); global::System.Xml.Schema.XmlSchemaSequence sequence = new global::System.Xml.Schema.XmlSchemaSequence(); ROImportDataSet ds = new ROImportDataSet(); global::System.Xml.Schema.XmlSchemaAny any1 = new global::System.Xml.Schema.XmlSchemaAny(); any1.Namespace = "http://www.w3.org/2001/XMLSchema"; any1.MinOccurs = new decimal(0); any1.MaxOccurs = decimal.MaxValue; any1.ProcessContents = global::System.Xml.Schema.XmlSchemaContentProcessing.Lax; sequence.Items.Add(any1); global::System.Xml.Schema.XmlSchemaAny any2 = new global::System.Xml.Schema.XmlSchemaAny(); any2.Namespace = "urn:schemas-microsoft-com:xml-diffgram-v1"; any2.MinOccurs = new decimal(1); any2.ProcessContents = global::System.Xml.Schema.XmlSchemaContentProcessing.Lax; sequence.Items.Add(any2); global::System.Xml.Schema.XmlSchemaAttribute attribute1 = new global::System.Xml.Schema.XmlSchemaAttribute(); attribute1.Name = "namespace"; attribute1.FixedValue = ds.Namespace; type.Attributes.Add(attribute1); global::System.Xml.Schema.XmlSchemaAttribute attribute2 = new global::System.Xml.Schema.XmlSchemaAttribute(); attribute2.Name = "tableTypeName"; attribute2.FixedValue = "ImportMEL_qryDataTable"; type.Attributes.Add(attribute2); type.Particle = sequence; global::System.Xml.Schema.XmlSchema dsSchema = ds.GetSchemaSerializable(); if (xs.Contains(dsSchema.TargetNamespace)) { global::System.IO.MemoryStream s1 = new global::System.IO.MemoryStream(); global::System.IO.MemoryStream s2 = new global::System.IO.MemoryStream(); try { global::System.Xml.Schema.XmlSchema schema = null; dsSchema.Write(s1); for (global::System.Collections.IEnumerator schemas = xs.Schemas(dsSchema.TargetNamespace).GetEnumerator(); schemas.MoveNext(); ) { schema = ((global::System.Xml.Schema.XmlSchema)(schemas.Current)); s2.SetLength(0); schema.Write(s2); if ((s1.Length == s2.Length)) { s1.Position = 0; s2.Position = 0; for (; ((s1.Position != s1.Length) && (s1.ReadByte() == s2.ReadByte())); ) { ; } if ((s1.Position == s1.Length)) { return type; } } } } finally { if ((s1 != null)) { s1.Close(); } if ((s2 != null)) { s2.Close(); } } } xs.Add(dsSchema); return type; } } /// ///Represents the strongly named DataTable class. /// [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "2.0.0.0")] [global::System.Serializable()] [global::System.Xml.Serialization.XmlSchemaProviderAttribute("GetTypedTableSchema")] public partial class ImportARP_tblDataTable : global::System.Data.DataTable, global::System.Collections.IEnumerable { private global::System.Data.DataColumn columnDocument; private global::System.Data.DataColumn columnAlarm; private global::System.Data.DataColumn columnPointName; private global::System.Data.DataColumn columnType; private global::System.Data.DataColumn columnValue; private global::System.Data.DataColumn columnDescription; private global::System.Data.DataColumn columnSystemID; private global::System.Data.DataColumn columnSysTitle; [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] public ImportARP_tblDataTable() { this.TableName = "ImportARP_tbl"; this.BeginInit(); this.InitClass(); this.EndInit(); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] internal ImportARP_tblDataTable(global::System.Data.DataTable table) { this.TableName = 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; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] protected ImportARP_tblDataTable(global::System.Runtime.Serialization.SerializationInfo info, global::System.Runtime.Serialization.StreamingContext context) : base(info, context) { this.InitVars(); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] public global::System.Data.DataColumn DocumentColumn { get { return this.columnDocument; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] public global::System.Data.DataColumn AlarmColumn { get { return this.columnAlarm; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] public global::System.Data.DataColumn PointNameColumn { get { return this.columnPointName; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] public global::System.Data.DataColumn TypeColumn { get { return this.columnType; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] public global::System.Data.DataColumn ValueColumn { get { return this.columnValue; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] public global::System.Data.DataColumn DescriptionColumn { get { return this.columnDescription; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] public global::System.Data.DataColumn SystemIDColumn { get { return this.columnSystemID; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] public global::System.Data.DataColumn SysTitleColumn { get { return this.columnSysTitle; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.ComponentModel.Browsable(false)] public int Count { get { return this.Rows.Count; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] public ImportARP_tblRow this[int index] { get { return ((ImportARP_tblRow)(this.Rows[index])); } } public event ImportARP_tblRowChangeEventHandler ImportARP_tblRowChanging; public event ImportARP_tblRowChangeEventHandler ImportARP_tblRowChanged; public event ImportARP_tblRowChangeEventHandler ImportARP_tblRowDeleting; public event ImportARP_tblRowChangeEventHandler ImportARP_tblRowDeleted; [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] public void AddImportARP_tblRow(ImportARP_tblRow row) { this.Rows.Add(row); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] public ImportARP_tblRow AddImportARP_tblRow(string Document, string Alarm, string PointName, string Type, string Value, string Description, string SystemID, string SysTitle) { ImportARP_tblRow rowImportARP_tblRow = ((ImportARP_tblRow)(this.NewRow())); object[] columnValuesArray = new object[] { Document, Alarm, PointName, Type, Value, Description, SystemID, SysTitle}; rowImportARP_tblRow.ItemArray = columnValuesArray; this.Rows.Add(rowImportARP_tblRow); return rowImportARP_tblRow; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] public virtual global::System.Collections.IEnumerator GetEnumerator() { return this.Rows.GetEnumerator(); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] public override global::System.Data.DataTable Clone() { ImportARP_tblDataTable cln = ((ImportARP_tblDataTable)(base.Clone())); cln.InitVars(); return cln; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] protected override global::System.Data.DataTable CreateInstance() { return new ImportARP_tblDataTable(); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] internal void InitVars() { this.columnDocument = base.Columns["Document"]; this.columnAlarm = base.Columns["Alarm"]; this.columnPointName = base.Columns["PointName"]; this.columnType = base.Columns["Type"]; this.columnValue = base.Columns["Value"]; this.columnDescription = base.Columns["Description"]; this.columnSystemID = base.Columns["SystemID"]; this.columnSysTitle = base.Columns["SysTitle"]; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] private void InitClass() { this.columnDocument = new global::System.Data.DataColumn("Document", typeof(string), null, global::System.Data.MappingType.Element); base.Columns.Add(this.columnDocument); this.columnAlarm = new global::System.Data.DataColumn("Alarm", typeof(string), null, global::System.Data.MappingType.Element); base.Columns.Add(this.columnAlarm); this.columnPointName = new global::System.Data.DataColumn("PointName", typeof(string), null, global::System.Data.MappingType.Element); base.Columns.Add(this.columnPointName); this.columnType = new global::System.Data.DataColumn("Type", typeof(string), null, global::System.Data.MappingType.Element); base.Columns.Add(this.columnType); this.columnValue = new global::System.Data.DataColumn("Value", typeof(string), null, global::System.Data.MappingType.Element); base.Columns.Add(this.columnValue); this.columnDescription = new global::System.Data.DataColumn("Description", typeof(string), null, global::System.Data.MappingType.Element); base.Columns.Add(this.columnDescription); this.columnSystemID = new global::System.Data.DataColumn("SystemID", typeof(string), null, global::System.Data.MappingType.Element); base.Columns.Add(this.columnSystemID); this.columnSysTitle = new global::System.Data.DataColumn("SysTitle", typeof(string), null, global::System.Data.MappingType.Element); base.Columns.Add(this.columnSysTitle); this.columnDocument.MaxLength = 255; this.columnAlarm.MaxLength = 255; this.columnPointName.MaxLength = 255; this.columnType.MaxLength = 255; this.columnValue.MaxLength = 255; this.columnDescription.MaxLength = 255; this.columnSystemID.MaxLength = 255; this.columnSysTitle.MaxLength = 255; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] public ImportARP_tblRow NewImportARP_tblRow() { return ((ImportARP_tblRow)(this.NewRow())); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] protected override global::System.Data.DataRow NewRowFromBuilder(global::System.Data.DataRowBuilder builder) { return new ImportARP_tblRow(builder); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] protected override global::System.Type GetRowType() { return typeof(ImportARP_tblRow); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] protected override void OnRowChanged(global::System.Data.DataRowChangeEventArgs e) { base.OnRowChanged(e); if ((this.ImportARP_tblRowChanged != null)) { this.ImportARP_tblRowChanged(this, new ImportARP_tblRowChangeEvent(((ImportARP_tblRow)(e.Row)), e.Action)); } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] protected override void OnRowChanging(global::System.Data.DataRowChangeEventArgs e) { base.OnRowChanging(e); if ((this.ImportARP_tblRowChanging != null)) { this.ImportARP_tblRowChanging(this, new ImportARP_tblRowChangeEvent(((ImportARP_tblRow)(e.Row)), e.Action)); } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] protected override void OnRowDeleted(global::System.Data.DataRowChangeEventArgs e) { base.OnRowDeleted(e); if ((this.ImportARP_tblRowDeleted != null)) { this.ImportARP_tblRowDeleted(this, new ImportARP_tblRowChangeEvent(((ImportARP_tblRow)(e.Row)), e.Action)); } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] protected override void OnRowDeleting(global::System.Data.DataRowChangeEventArgs e) { base.OnRowDeleting(e); if ((this.ImportARP_tblRowDeleting != null)) { this.ImportARP_tblRowDeleting(this, new ImportARP_tblRowChangeEvent(((ImportARP_tblRow)(e.Row)), e.Action)); } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] public void RemoveImportARP_tblRow(ImportARP_tblRow row) { this.Rows.Remove(row); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedTableSchema(global::System.Xml.Schema.XmlSchemaSet xs) { global::System.Xml.Schema.XmlSchemaComplexType type = new global::System.Xml.Schema.XmlSchemaComplexType(); global::System.Xml.Schema.XmlSchemaSequence sequence = new global::System.Xml.Schema.XmlSchemaSequence(); ROImportDataSet ds = new ROImportDataSet(); global::System.Xml.Schema.XmlSchemaAny any1 = new global::System.Xml.Schema.XmlSchemaAny(); any1.Namespace = "http://www.w3.org/2001/XMLSchema"; any1.MinOccurs = new decimal(0); any1.MaxOccurs = decimal.MaxValue; any1.ProcessContents = global::System.Xml.Schema.XmlSchemaContentProcessing.Lax; sequence.Items.Add(any1); global::System.Xml.Schema.XmlSchemaAny any2 = new global::System.Xml.Schema.XmlSchemaAny(); any2.Namespace = "urn:schemas-microsoft-com:xml-diffgram-v1"; any2.MinOccurs = new decimal(1); any2.ProcessContents = global::System.Xml.Schema.XmlSchemaContentProcessing.Lax; sequence.Items.Add(any2); global::System.Xml.Schema.XmlSchemaAttribute attribute1 = new global::System.Xml.Schema.XmlSchemaAttribute(); attribute1.Name = "namespace"; attribute1.FixedValue = ds.Namespace; type.Attributes.Add(attribute1); global::System.Xml.Schema.XmlSchemaAttribute attribute2 = new global::System.Xml.Schema.XmlSchemaAttribute(); attribute2.Name = "tableTypeName"; attribute2.FixedValue = "ImportARP_tblDataTable"; type.Attributes.Add(attribute2); type.Particle = sequence; global::System.Xml.Schema.XmlSchema dsSchema = ds.GetSchemaSerializable(); if (xs.Contains(dsSchema.TargetNamespace)) { global::System.IO.MemoryStream s1 = new global::System.IO.MemoryStream(); global::System.IO.MemoryStream s2 = new global::System.IO.MemoryStream(); try { global::System.Xml.Schema.XmlSchema schema = null; dsSchema.Write(s1); for (global::System.Collections.IEnumerator schemas = xs.Schemas(dsSchema.TargetNamespace).GetEnumerator(); schemas.MoveNext(); ) { schema = ((global::System.Xml.Schema.XmlSchema)(schemas.Current)); s2.SetLength(0); schema.Write(s2); if ((s1.Length == s2.Length)) { s1.Position = 0; s2.Position = 0; for (; ((s1.Position != s1.Length) && (s1.ReadByte() == s2.ReadByte())); ) { ; } if ((s1.Position == s1.Length)) { return type; } } } } finally { if ((s1 != null)) { s1.Close(); } if ((s2 != null)) { s2.Close(); } } } xs.Add(dsSchema); return type; } } /// ///Represents strongly named DataRow class. /// [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "2.0.0.0")] public partial class ImportSTP_qryRow : global::System.Data.DataRow { private ImportSTP_qryDataTable tableImportSTP_qry; [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] internal ImportSTP_qryRow(global::System.Data.DataRowBuilder rb) : base(rb) { this.tableImportSTP_qry = ((ImportSTP_qryDataTable)(this.Table)); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] public string Parameter { get { try { return ((string)(this[this.tableImportSTP_qry.ParameterColumn])); } catch (global::System.InvalidCastException e) { throw new global::System.Data.StrongTypingException("The value for column \'Parameter\' in table \'ImportSTP_qry\' is DBNull.", e); } } set { this[this.tableImportSTP_qry.ParameterColumn] = value; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] public string Name { get { try { return ((string)(this[this.tableImportSTP_qry.NameColumn])); } catch (global::System.InvalidCastException e) { throw new global::System.Data.StrongTypingException("The value for column \'Name\' in table \'ImportSTP_qry\' is DBNull.", e); } } set { this[this.tableImportSTP_qry.NameColumn] = value; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] public string Value { get { try { return ((string)(this[this.tableImportSTP_qry.ValueColumn])); } catch (global::System.InvalidCastException e) { throw new global::System.Data.StrongTypingException("The value for column \'Value\' in table \'ImportSTP_qry\' is DBNull.", e); } } set { this[this.tableImportSTP_qry.ValueColumn] = value; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] public string Description { get { try { return ((string)(this[this.tableImportSTP_qry.DescriptionColumn])); } catch (global::System.InvalidCastException e) { throw new global::System.Data.StrongTypingException("The value for column \'Description\' in table \'ImportSTP_qry\' is DBNull.", e); } } set { this[this.tableImportSTP_qry.DescriptionColumn] = value; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] public bool IsParameterNull() { return this.IsNull(this.tableImportSTP_qry.ParameterColumn); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] public void SetParameterNull() { this[this.tableImportSTP_qry.ParameterColumn] = global::System.Convert.DBNull; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] public bool IsNameNull() { return this.IsNull(this.tableImportSTP_qry.NameColumn); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] public void SetNameNull() { this[this.tableImportSTP_qry.NameColumn] = global::System.Convert.DBNull; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] public bool IsValueNull() { return this.IsNull(this.tableImportSTP_qry.ValueColumn); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] public void SetValueNull() { this[this.tableImportSTP_qry.ValueColumn] = global::System.Convert.DBNull; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] public bool IsDescriptionNull() { return this.IsNull(this.tableImportSTP_qry.DescriptionColumn); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] public void SetDescriptionNull() { this[this.tableImportSTP_qry.DescriptionColumn] = global::System.Convert.DBNull; } } /// ///Represents strongly named DataRow class. /// [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "2.0.0.0")] public partial class ImportMEL_qryRow : global::System.Data.DataRow { private ImportMEL_qryDataTable tableImportMEL_qry; [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] internal ImportMEL_qryRow(global::System.Data.DataRowBuilder rb) : base(rb) { this.tableImportMEL_qry = ((ImportMEL_qryDataTable)(this.Table)); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] public string SystemID { get { try { return ((string)(this[this.tableImportMEL_qry.SystemIDColumn])); } catch (global::System.InvalidCastException e) { throw new global::System.Data.StrongTypingException("The value for column \'SystemID\' in table \'ImportMEL_qry\' is DBNull.", e); } } set { this[this.tableImportMEL_qry.SystemIDColumn] = value; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] public string SystemDesc { get { try { return ((string)(this[this.tableImportMEL_qry.SystemDescColumn])); } catch (global::System.InvalidCastException e) { throw new global::System.Data.StrongTypingException("The value for column \'SystemDesc\' in table \'ImportMEL_qry\' is DBNull.", e); } } set { this[this.tableImportMEL_qry.SystemDescColumn] = value; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] public string ComponentID { get { try { return ((string)(this[this.tableImportMEL_qry.ComponentIDColumn])); } catch (global::System.InvalidCastException e) { throw new global::System.Data.StrongTypingException("The value for column \'ComponentID\' in table \'ImportMEL_qry\' is DBNull.", e); } } set { this[this.tableImportMEL_qry.ComponentIDColumn] = value; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] public string CompDesc { get { try { return ((string)(this[this.tableImportMEL_qry.CompDescColumn])); } catch (global::System.InvalidCastException e) { throw new global::System.Data.StrongTypingException("The value for column \'CompDesc\' in table \'ImportMEL_qry\' is DBNull.", e); } } set { this[this.tableImportMEL_qry.CompDescColumn] = value; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] public string FullName { get { try { return ((string)(this[this.tableImportMEL_qry.FullNameColumn])); } catch (global::System.InvalidCastException e) { throw new global::System.Data.StrongTypingException("The value for column \'FullName\' in table \'ImportMEL_qry\' is DBNull.", e); } } set { this[this.tableImportMEL_qry.FullNameColumn] = value; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] public string ShortName { get { try { return ((string)(this[this.tableImportMEL_qry.ShortNameColumn])); } catch (global::System.InvalidCastException e) { throw new global::System.Data.StrongTypingException("The value for column \'ShortName\' in table \'ImportMEL_qry\' is DBNull.", e); } } set { this[this.tableImportMEL_qry.ShortNameColumn] = value; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] public string Room { get { try { return ((string)(this[this.tableImportMEL_qry.RoomColumn])); } catch (global::System.InvalidCastException e) { throw new global::System.Data.StrongTypingException("The value for column \'Room\' in table \'ImportMEL_qry\' is DBNull.", e); } } set { this[this.tableImportMEL_qry.RoomColumn] = value; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] public string Description { get { try { return ((string)(this[this.tableImportMEL_qry.DescriptionColumn])); } catch (global::System.InvalidCastException e) { throw new global::System.Data.StrongTypingException("The value for column \'Description\' in table \'ImportMEL_qry\' is DBNull.", e); } } set { this[this.tableImportMEL_qry.DescriptionColumn] = value; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] public string CommonDesc { get { try { return ((string)(this[this.tableImportMEL_qry.CommonDescColumn])); } catch (global::System.InvalidCastException e) { throw new global::System.Data.StrongTypingException("The value for column \'CommonDesc\' in table \'ImportMEL_qry\' is DBNull.", e); } } set { this[this.tableImportMEL_qry.CommonDescColumn] = value; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] public bool IsSystemIDNull() { return this.IsNull(this.tableImportMEL_qry.SystemIDColumn); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] public void SetSystemIDNull() { this[this.tableImportMEL_qry.SystemIDColumn] = global::System.Convert.DBNull; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] public bool IsSystemDescNull() { return this.IsNull(this.tableImportMEL_qry.SystemDescColumn); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] public void SetSystemDescNull() { this[this.tableImportMEL_qry.SystemDescColumn] = global::System.Convert.DBNull; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] public bool IsComponentIDNull() { return this.IsNull(this.tableImportMEL_qry.ComponentIDColumn); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] public void SetComponentIDNull() { this[this.tableImportMEL_qry.ComponentIDColumn] = global::System.Convert.DBNull; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] public bool IsCompDescNull() { return this.IsNull(this.tableImportMEL_qry.CompDescColumn); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] public void SetCompDescNull() { this[this.tableImportMEL_qry.CompDescColumn] = global::System.Convert.DBNull; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] public bool IsFullNameNull() { return this.IsNull(this.tableImportMEL_qry.FullNameColumn); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] public void SetFullNameNull() { this[this.tableImportMEL_qry.FullNameColumn] = global::System.Convert.DBNull; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] public bool IsShortNameNull() { return this.IsNull(this.tableImportMEL_qry.ShortNameColumn); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] public void SetShortNameNull() { this[this.tableImportMEL_qry.ShortNameColumn] = global::System.Convert.DBNull; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] public bool IsRoomNull() { return this.IsNull(this.tableImportMEL_qry.RoomColumn); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] public void SetRoomNull() { this[this.tableImportMEL_qry.RoomColumn] = global::System.Convert.DBNull; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] public bool IsDescriptionNull() { return this.IsNull(this.tableImportMEL_qry.DescriptionColumn); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] public void SetDescriptionNull() { this[this.tableImportMEL_qry.DescriptionColumn] = global::System.Convert.DBNull; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] public bool IsCommonDescNull() { return this.IsNull(this.tableImportMEL_qry.CommonDescColumn); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] public void SetCommonDescNull() { this[this.tableImportMEL_qry.CommonDescColumn] = global::System.Convert.DBNull; } } /// ///Represents strongly named DataRow class. /// [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "2.0.0.0")] public partial class ImportARP_tblRow : global::System.Data.DataRow { private ImportARP_tblDataTable tableImportARP_tbl; [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] internal ImportARP_tblRow(global::System.Data.DataRowBuilder rb) : base(rb) { this.tableImportARP_tbl = ((ImportARP_tblDataTable)(this.Table)); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] public string Document { get { try { return ((string)(this[this.tableImportARP_tbl.DocumentColumn])); } catch (global::System.InvalidCastException e) { throw new global::System.Data.StrongTypingException("The value for column \'Document\' in table \'ImportARP_tbl\' is DBNull.", e); } } set { this[this.tableImportARP_tbl.DocumentColumn] = value; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] public string Alarm { get { try { return ((string)(this[this.tableImportARP_tbl.AlarmColumn])); } catch (global::System.InvalidCastException e) { throw new global::System.Data.StrongTypingException("The value for column \'Alarm\' in table \'ImportARP_tbl\' is DBNull.", e); } } set { this[this.tableImportARP_tbl.AlarmColumn] = value; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] public string PointName { get { try { return ((string)(this[this.tableImportARP_tbl.PointNameColumn])); } catch (global::System.InvalidCastException e) { throw new global::System.Data.StrongTypingException("The value for column \'PointName\' in table \'ImportARP_tbl\' is DBNull.", e); } } set { this[this.tableImportARP_tbl.PointNameColumn] = value; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] public string Type { get { try { return ((string)(this[this.tableImportARP_tbl.TypeColumn])); } catch (global::System.InvalidCastException e) { throw new global::System.Data.StrongTypingException("The value for column \'Type\' in table \'ImportARP_tbl\' is DBNull.", e); } } set { this[this.tableImportARP_tbl.TypeColumn] = value; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] public string Value { get { try { return ((string)(this[this.tableImportARP_tbl.ValueColumn])); } catch (global::System.InvalidCastException e) { throw new global::System.Data.StrongTypingException("The value for column \'Value\' in table \'ImportARP_tbl\' is DBNull.", e); } } set { this[this.tableImportARP_tbl.ValueColumn] = value; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] public string Description { get { try { return ((string)(this[this.tableImportARP_tbl.DescriptionColumn])); } catch (global::System.InvalidCastException e) { throw new global::System.Data.StrongTypingException("The value for column \'Description\' in table \'ImportARP_tbl\' is DBNull.", e); } } set { this[this.tableImportARP_tbl.DescriptionColumn] = value; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] public string SystemID { get { try { return ((string)(this[this.tableImportARP_tbl.SystemIDColumn])); } catch (global::System.InvalidCastException e) { throw new global::System.Data.StrongTypingException("The value for column \'SystemID\' in table \'ImportARP_tbl\' is DBNull.", e); } } set { this[this.tableImportARP_tbl.SystemIDColumn] = value; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] public string SysTitle { get { try { return ((string)(this[this.tableImportARP_tbl.SysTitleColumn])); } catch (global::System.InvalidCastException e) { throw new global::System.Data.StrongTypingException("The value for column \'SysTitle\' in table \'ImportARP_tbl\' is DBNull.", e); } } set { this[this.tableImportARP_tbl.SysTitleColumn] = value; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] public bool IsDocumentNull() { return this.IsNull(this.tableImportARP_tbl.DocumentColumn); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] public void SetDocumentNull() { this[this.tableImportARP_tbl.DocumentColumn] = global::System.Convert.DBNull; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] public bool IsAlarmNull() { return this.IsNull(this.tableImportARP_tbl.AlarmColumn); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] public void SetAlarmNull() { this[this.tableImportARP_tbl.AlarmColumn] = global::System.Convert.DBNull; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] public bool IsPointNameNull() { return this.IsNull(this.tableImportARP_tbl.PointNameColumn); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] public void SetPointNameNull() { this[this.tableImportARP_tbl.PointNameColumn] = global::System.Convert.DBNull; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] public bool IsTypeNull() { return this.IsNull(this.tableImportARP_tbl.TypeColumn); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] public void SetTypeNull() { this[this.tableImportARP_tbl.TypeColumn] = global::System.Convert.DBNull; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] public bool IsValueNull() { return this.IsNull(this.tableImportARP_tbl.ValueColumn); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] public void SetValueNull() { this[this.tableImportARP_tbl.ValueColumn] = global::System.Convert.DBNull; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] public bool IsDescriptionNull() { return this.IsNull(this.tableImportARP_tbl.DescriptionColumn); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] public void SetDescriptionNull() { this[this.tableImportARP_tbl.DescriptionColumn] = global::System.Convert.DBNull; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] public bool IsSystemIDNull() { return this.IsNull(this.tableImportARP_tbl.SystemIDColumn); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] public void SetSystemIDNull() { this[this.tableImportARP_tbl.SystemIDColumn] = global::System.Convert.DBNull; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] public bool IsSysTitleNull() { return this.IsNull(this.tableImportARP_tbl.SysTitleColumn); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] public void SetSysTitleNull() { this[this.tableImportARP_tbl.SysTitleColumn] = global::System.Convert.DBNull; } } /// ///Row event argument class /// [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "2.0.0.0")] public class ImportSTP_qryRowChangeEvent : global::System.EventArgs { private ImportSTP_qryRow eventRow; private global::System.Data.DataRowAction eventAction; [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] public ImportSTP_qryRowChangeEvent(ImportSTP_qryRow row, global::System.Data.DataRowAction action) { this.eventRow = row; this.eventAction = action; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] public ImportSTP_qryRow Row { get { return this.eventRow; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] public global::System.Data.DataRowAction Action { get { return this.eventAction; } } } /// ///Row event argument class /// [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "2.0.0.0")] public class ImportMEL_qryRowChangeEvent : global::System.EventArgs { private ImportMEL_qryRow eventRow; private global::System.Data.DataRowAction eventAction; [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] public ImportMEL_qryRowChangeEvent(ImportMEL_qryRow row, global::System.Data.DataRowAction action) { this.eventRow = row; this.eventAction = action; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] public ImportMEL_qryRow Row { get { return this.eventRow; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] public global::System.Data.DataRowAction Action { get { return this.eventAction; } } } /// ///Row event argument class /// [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "2.0.0.0")] public class ImportARP_tblRowChangeEvent : global::System.EventArgs { private ImportARP_tblRow eventRow; private global::System.Data.DataRowAction eventAction; [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] public ImportARP_tblRowChangeEvent(ImportARP_tblRow row, global::System.Data.DataRowAction action) { this.eventRow = row; this.eventAction = action; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] public ImportARP_tblRow Row { get { return this.eventRow; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] public global::System.Data.DataRowAction Action { get { return this.eventAction; } } } } } namespace WestinghouseROImport.ROImportDataSetTableAdapters { /// ///Represents the connection and commands used to retrieve and save data. /// [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "2.0.0.0")] [global::System.ComponentModel.DesignerCategoryAttribute("code")] [global::System.ComponentModel.ToolboxItem(true)] [global::System.ComponentModel.DataObjectAttribute(true)] [global::System.ComponentModel.DesignerAttribute("Microsoft.VSDesigner.DataSource.Design.TableAdapterDesigner, Microsoft.VSDesigner" + ", Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a")] [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")] public partial class ImportSTP_qryTableAdapter : global::System.ComponentModel.Component { private global::System.Data.OleDb.OleDbDataAdapter _adapter; private global::System.Data.OleDb.OleDbConnection _connection; private global::System.Data.OleDb.OleDbCommand[] _commandCollection; private bool _clearBeforeFill; [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] public ImportSTP_qryTableAdapter() { this.ClearBeforeFill = true; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] private global::System.Data.OleDb.OleDbDataAdapter Adapter { get { if ((this._adapter == null)) { this.InitAdapter(); } return this._adapter; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] internal global::System.Data.OleDb.OleDbConnection Connection { get { if ((this._connection == null)) { this.InitConnection(); } return this._connection; } set { this._connection = value; if ((this.Adapter.InsertCommand != null)) { this.Adapter.InsertCommand.Connection = value; } if ((this.Adapter.DeleteCommand != null)) { this.Adapter.DeleteCommand.Connection = value; } if ((this.Adapter.UpdateCommand != null)) { this.Adapter.UpdateCommand.Connection = value; } for (int i = 0; (i < this.CommandCollection.Length); i = (i + 1)) { if ((this.CommandCollection[i] != null)) { ((global::System.Data.OleDb.OleDbCommand)(this.CommandCollection[i])).Connection = value; } } } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] protected global::System.Data.OleDb.OleDbCommand[] CommandCollection { get { if ((this._commandCollection == null)) { this.InitCommandCollection(); } return this._commandCollection; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] public bool ClearBeforeFill { get { return this._clearBeforeFill; } set { this._clearBeforeFill = value; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] private void InitAdapter() { this._adapter = new global::System.Data.OleDb.OleDbDataAdapter(); global::System.Data.Common.DataTableMapping tableMapping = new global::System.Data.Common.DataTableMapping(); tableMapping.SourceTable = "Table"; tableMapping.DataSetTable = "ImportSTP_qry"; tableMapping.ColumnMappings.Add("Parameter", "Parameter"); tableMapping.ColumnMappings.Add("Name", "Name"); tableMapping.ColumnMappings.Add("Value", "Value"); tableMapping.ColumnMappings.Add("Description", "Description"); this._adapter.TableMappings.Add(tableMapping); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] private void InitConnection() { this._connection = new global::System.Data.OleDb.OleDbConnection(); this._connection.ConnectionString = global::WestinghouseROImport.Properties.Settings.Default.ROImportConnectionString; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] private void InitCommandCollection() { this._commandCollection = new global::System.Data.OleDb.OleDbCommand[1]; this._commandCollection[0] = new global::System.Data.OleDb.OleDbCommand(); this._commandCollection[0].Connection = this.Connection; this._commandCollection[0].CommandText = "SELECT Parameter, Name, [Value], Description FROM ImportSTP_qry"; this._commandCollection[0].CommandType = global::System.Data.CommandType.Text; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")] [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Fill, true)] public virtual int Fill(ROImportDataSet.ImportSTP_qryDataTable dataTable) { this.Adapter.SelectCommand = this.CommandCollection[0]; if ((this.ClearBeforeFill == true)) { dataTable.Clear(); } int returnValue = this.Adapter.Fill(dataTable); return returnValue; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")] [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Select, true)] public virtual ROImportDataSet.ImportSTP_qryDataTable GetData() { this.Adapter.SelectCommand = this.CommandCollection[0]; ROImportDataSet.ImportSTP_qryDataTable dataTable = new ROImportDataSet.ImportSTP_qryDataTable(); this.Adapter.Fill(dataTable); return dataTable; } } /// ///Represents the connection and commands used to retrieve and save data. /// [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "2.0.0.0")] [global::System.ComponentModel.DesignerCategoryAttribute("code")] [global::System.ComponentModel.ToolboxItem(true)] [global::System.ComponentModel.DataObjectAttribute(true)] [global::System.ComponentModel.DesignerAttribute("Microsoft.VSDesigner.DataSource.Design.TableAdapterDesigner, Microsoft.VSDesigner" + ", Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a")] [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")] public partial class ImportMEL_qryTableAdapter : global::System.ComponentModel.Component { private global::System.Data.OleDb.OleDbDataAdapter _adapter; private global::System.Data.OleDb.OleDbConnection _connection; private global::System.Data.OleDb.OleDbCommand[] _commandCollection; private bool _clearBeforeFill; [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] public ImportMEL_qryTableAdapter() { this.ClearBeforeFill = true; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] private global::System.Data.OleDb.OleDbDataAdapter Adapter { get { if ((this._adapter == null)) { this.InitAdapter(); } return this._adapter; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] internal global::System.Data.OleDb.OleDbConnection Connection { get { if ((this._connection == null)) { this.InitConnection(); } return this._connection; } set { this._connection = value; if ((this.Adapter.InsertCommand != null)) { this.Adapter.InsertCommand.Connection = value; } if ((this.Adapter.DeleteCommand != null)) { this.Adapter.DeleteCommand.Connection = value; } if ((this.Adapter.UpdateCommand != null)) { this.Adapter.UpdateCommand.Connection = value; } for (int i = 0; (i < this.CommandCollection.Length); i = (i + 1)) { if ((this.CommandCollection[i] != null)) { ((global::System.Data.OleDb.OleDbCommand)(this.CommandCollection[i])).Connection = value; } } } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] protected global::System.Data.OleDb.OleDbCommand[] CommandCollection { get { if ((this._commandCollection == null)) { this.InitCommandCollection(); } return this._commandCollection; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] public bool ClearBeforeFill { get { return this._clearBeforeFill; } set { this._clearBeforeFill = value; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] private void InitAdapter() { this._adapter = new global::System.Data.OleDb.OleDbDataAdapter(); global::System.Data.Common.DataTableMapping tableMapping = new global::System.Data.Common.DataTableMapping(); tableMapping.SourceTable = "Table"; tableMapping.DataSetTable = "ImportMEL_qry"; tableMapping.ColumnMappings.Add("SystemID", "SystemID"); tableMapping.ColumnMappings.Add("SystemDesc", "SystemDesc"); tableMapping.ColumnMappings.Add("ComponentID", "ComponentID"); tableMapping.ColumnMappings.Add("CompDesc", "CompDesc"); tableMapping.ColumnMappings.Add("FullName", "FullName"); tableMapping.ColumnMappings.Add("ShortName", "ShortName"); tableMapping.ColumnMappings.Add("Room", "Room"); tableMapping.ColumnMappings.Add("Description", "Description"); tableMapping.ColumnMappings.Add("CommonDesc", "CommonDesc"); this._adapter.TableMappings.Add(tableMapping); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] private void InitConnection() { this._connection = new global::System.Data.OleDb.OleDbConnection(); this._connection.ConnectionString = global::WestinghouseROImport.Properties.Settings.Default.ROImportConnectionString; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] private void InitCommandCollection() { this._commandCollection = new global::System.Data.OleDb.OleDbCommand[1]; this._commandCollection[0] = new global::System.Data.OleDb.OleDbCommand(); this._commandCollection[0].Connection = this.Connection; this._commandCollection[0].CommandText = "SELECT SystemID, SystemDesc, ComponentID, CompDesc, FullName, ShortName, Room, De" + "scription, CommonDesc FROM ImportMEL_qry"; this._commandCollection[0].CommandType = global::System.Data.CommandType.Text; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")] [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Fill, true)] public virtual int Fill(ROImportDataSet.ImportMEL_qryDataTable dataTable) { this.Adapter.SelectCommand = this.CommandCollection[0]; if ((this.ClearBeforeFill == true)) { dataTable.Clear(); } int returnValue = this.Adapter.Fill(dataTable); return returnValue; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")] [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Select, true)] public virtual ROImportDataSet.ImportMEL_qryDataTable GetData() { this.Adapter.SelectCommand = this.CommandCollection[0]; ROImportDataSet.ImportMEL_qryDataTable dataTable = new ROImportDataSet.ImportMEL_qryDataTable(); this.Adapter.Fill(dataTable); return dataTable; } } /// ///Represents the connection and commands used to retrieve and save data. /// [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "2.0.0.0")] [global::System.ComponentModel.DesignerCategoryAttribute("code")] [global::System.ComponentModel.ToolboxItem(true)] [global::System.ComponentModel.DataObjectAttribute(true)] [global::System.ComponentModel.DesignerAttribute("Microsoft.VSDesigner.DataSource.Design.TableAdapterDesigner, Microsoft.VSDesigner" + ", Version=8.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a")] [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")] public partial class ImportARP_tblTableAdapter : global::System.ComponentModel.Component { private global::System.Data.OleDb.OleDbDataAdapter _adapter; private global::System.Data.OleDb.OleDbConnection _connection; private global::System.Data.OleDb.OleDbCommand[] _commandCollection; private bool _clearBeforeFill; [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] public ImportARP_tblTableAdapter() { this.ClearBeforeFill = true; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] private global::System.Data.OleDb.OleDbDataAdapter Adapter { get { if ((this._adapter == null)) { this.InitAdapter(); } return this._adapter; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] internal global::System.Data.OleDb.OleDbConnection Connection { get { if ((this._connection == null)) { this.InitConnection(); } return this._connection; } set { this._connection = value; if ((this.Adapter.InsertCommand != null)) { this.Adapter.InsertCommand.Connection = value; } if ((this.Adapter.DeleteCommand != null)) { this.Adapter.DeleteCommand.Connection = value; } if ((this.Adapter.UpdateCommand != null)) { this.Adapter.UpdateCommand.Connection = value; } for (int i = 0; (i < this.CommandCollection.Length); i = (i + 1)) { if ((this.CommandCollection[i] != null)) { ((global::System.Data.OleDb.OleDbCommand)(this.CommandCollection[i])).Connection = value; } } } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] protected global::System.Data.OleDb.OleDbCommand[] CommandCollection { get { if ((this._commandCollection == null)) { this.InitCommandCollection(); } return this._commandCollection; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] public bool ClearBeforeFill { get { return this._clearBeforeFill; } set { this._clearBeforeFill = value; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] private void InitAdapter() { this._adapter = new global::System.Data.OleDb.OleDbDataAdapter(); global::System.Data.Common.DataTableMapping tableMapping = new global::System.Data.Common.DataTableMapping(); tableMapping.SourceTable = "Table"; tableMapping.DataSetTable = "ImportARP_tbl"; tableMapping.ColumnMappings.Add("Document", "Document"); tableMapping.ColumnMappings.Add("Alarm", "Alarm"); tableMapping.ColumnMappings.Add("PointName", "PointName"); tableMapping.ColumnMappings.Add("Type", "Type"); tableMapping.ColumnMappings.Add("Value", "Value"); tableMapping.ColumnMappings.Add("Description", "Description"); tableMapping.ColumnMappings.Add("SystemID", "SystemID"); tableMapping.ColumnMappings.Add("SysTitle", "SysTitle"); this._adapter.TableMappings.Add(tableMapping); this._adapter.InsertCommand = new global::System.Data.OleDb.OleDbCommand(); this._adapter.InsertCommand.Connection = this.Connection; this._adapter.InsertCommand.CommandText = "INSERT INTO `ImportARP_tbl` (`Document`, `Alarm`, `PointName`, `Type`, `Value`, `" + "Description`, `SystemID`, `SysTitle`) VALUES (?, ?, ?, ?, ?, ?, ?, ?)"; this._adapter.InsertCommand.CommandType = global::System.Data.CommandType.Text; this._adapter.InsertCommand.Parameters.Add(new global::System.Data.OleDb.OleDbParameter("Document", global::System.Data.OleDb.OleDbType.VarWChar, 0, global::System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "Document", global::System.Data.DataRowVersion.Current, false, null)); this._adapter.InsertCommand.Parameters.Add(new global::System.Data.OleDb.OleDbParameter("Alarm", global::System.Data.OleDb.OleDbType.VarWChar, 0, global::System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "Alarm", global::System.Data.DataRowVersion.Current, false, null)); this._adapter.InsertCommand.Parameters.Add(new global::System.Data.OleDb.OleDbParameter("PointName", global::System.Data.OleDb.OleDbType.VarWChar, 0, global::System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "PointName", global::System.Data.DataRowVersion.Current, false, null)); this._adapter.InsertCommand.Parameters.Add(new global::System.Data.OleDb.OleDbParameter("Type", global::System.Data.OleDb.OleDbType.VarWChar, 0, global::System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "Type", global::System.Data.DataRowVersion.Current, false, null)); this._adapter.InsertCommand.Parameters.Add(new global::System.Data.OleDb.OleDbParameter("Value", global::System.Data.OleDb.OleDbType.VarWChar, 0, global::System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "Value", global::System.Data.DataRowVersion.Current, false, null)); this._adapter.InsertCommand.Parameters.Add(new global::System.Data.OleDb.OleDbParameter("Description", global::System.Data.OleDb.OleDbType.VarWChar, 0, global::System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "Description", global::System.Data.DataRowVersion.Current, false, null)); this._adapter.InsertCommand.Parameters.Add(new global::System.Data.OleDb.OleDbParameter("SystemID", global::System.Data.OleDb.OleDbType.VarWChar, 0, global::System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "SystemID", global::System.Data.DataRowVersion.Current, false, null)); this._adapter.InsertCommand.Parameters.Add(new global::System.Data.OleDb.OleDbParameter("SysTitle", global::System.Data.OleDb.OleDbType.VarWChar, 0, global::System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "SysTitle", global::System.Data.DataRowVersion.Current, false, null)); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] private void InitConnection() { this._connection = new global::System.Data.OleDb.OleDbConnection(); this._connection.ConnectionString = global::WestinghouseROImport.Properties.Settings.Default.ROImportConnectionString; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] private void InitCommandCollection() { this._commandCollection = new global::System.Data.OleDb.OleDbCommand[1]; this._commandCollection[0] = new global::System.Data.OleDb.OleDbCommand(); this._commandCollection[0].Connection = this.Connection; this._commandCollection[0].CommandText = "SELECT Document, Alarm, PointName, Type, [Value], Description, SystemID, S" + "ysTitle\r\nFROM ImportARP_tbl"; this._commandCollection[0].CommandType = global::System.Data.CommandType.Text; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")] [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Fill, true)] public virtual int Fill(ROImportDataSet.ImportARP_tblDataTable dataTable) { this.Adapter.SelectCommand = this.CommandCollection[0]; if ((this.ClearBeforeFill == true)) { dataTable.Clear(); } int returnValue = this.Adapter.Fill(dataTable); return returnValue; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")] [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Select, true)] public virtual ROImportDataSet.ImportARP_tblDataTable GetData() { this.Adapter.SelectCommand = this.CommandCollection[0]; ROImportDataSet.ImportARP_tblDataTable dataTable = new ROImportDataSet.ImportARP_tblDataTable(); this.Adapter.Fill(dataTable); return dataTable; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")] public virtual int Update(ROImportDataSet.ImportARP_tblDataTable dataTable) { return this.Adapter.Update(dataTable); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")] public virtual int Update(ROImportDataSet dataSet) { return this.Adapter.Update(dataSet, "ImportARP_tbl"); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")] public virtual int Update(global::System.Data.DataRow dataRow) { return this.Adapter.Update(new global::System.Data.DataRow[] { dataRow}); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")] public virtual int Update(global::System.Data.DataRow[] dataRows) { return this.Adapter.Update(dataRows); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")] [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Insert, true)] public virtual int Insert(string Document, string Alarm, string PointName, string Type, string Value, string Description, string SystemID, string SysTitle) { if ((Document == null)) { this.Adapter.InsertCommand.Parameters[0].Value = global::System.DBNull.Value; } else { this.Adapter.InsertCommand.Parameters[0].Value = ((string)(Document)); } if ((Alarm == null)) { this.Adapter.InsertCommand.Parameters[1].Value = global::System.DBNull.Value; } else { this.Adapter.InsertCommand.Parameters[1].Value = ((string)(Alarm)); } if ((PointName == null)) { this.Adapter.InsertCommand.Parameters[2].Value = global::System.DBNull.Value; } else { this.Adapter.InsertCommand.Parameters[2].Value = ((string)(PointName)); } if ((Type == null)) { this.Adapter.InsertCommand.Parameters[3].Value = global::System.DBNull.Value; } else { this.Adapter.InsertCommand.Parameters[3].Value = ((string)(Type)); } if ((Value == null)) { this.Adapter.InsertCommand.Parameters[4].Value = global::System.DBNull.Value; } else { this.Adapter.InsertCommand.Parameters[4].Value = ((string)(Value)); } if ((Description == null)) { this.Adapter.InsertCommand.Parameters[5].Value = global::System.DBNull.Value; } else { this.Adapter.InsertCommand.Parameters[5].Value = ((string)(Description)); } if ((SystemID == null)) { this.Adapter.InsertCommand.Parameters[6].Value = global::System.DBNull.Value; } else { this.Adapter.InsertCommand.Parameters[6].Value = ((string)(SystemID)); } if ((SysTitle == null)) { this.Adapter.InsertCommand.Parameters[7].Value = global::System.DBNull.Value; } else { this.Adapter.InsertCommand.Parameters[7].Value = ((string)(SysTitle)); } global::System.Data.ConnectionState previousConnectionState = this.Adapter.InsertCommand.Connection.State; if (((this.Adapter.InsertCommand.Connection.State & global::System.Data.ConnectionState.Open) != global::System.Data.ConnectionState.Open)) { this.Adapter.InsertCommand.Connection.Open(); } try { int returnValue = this.Adapter.InsertCommand.ExecuteNonQuery(); return returnValue; } finally { if ((previousConnectionState == global::System.Data.ConnectionState.Closed)) { this.Adapter.InsertCommand.Connection.Close(); } } } } } #pragma warning restore 1591