2446 lines
118 KiB
C#
2446 lines
118 KiB
C#
//------------------------------------------------------------------------------
|
|
// <auto-generated>
|
|
// 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.
|
|
// </auto-generated>
|
|
//------------------------------------------------------------------------------
|
|
|
|
#pragma warning disable 1591
|
|
|
|
namespace WestinghouseROImport {
|
|
|
|
|
|
/// <summary>
|
|
///Represents a strongly typed in-memory cache of data.
|
|
///</summary>
|
|
[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);
|
|
|
|
/// <summary>
|
|
///Represents the strongly named DataTable class.
|
|
///</summary>
|
|
[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;
|
|
}
|
|
}
|
|
|
|
/// <summary>
|
|
///Represents the strongly named DataTable class.
|
|
///</summary>
|
|
[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;
|
|
}
|
|
}
|
|
|
|
/// <summary>
|
|
///Represents the strongly named DataTable class.
|
|
///</summary>
|
|
[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;
|
|
}
|
|
}
|
|
|
|
/// <summary>
|
|
///Represents strongly named DataRow class.
|
|
///</summary>
|
|
[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;
|
|
}
|
|
}
|
|
|
|
/// <summary>
|
|
///Represents strongly named DataRow class.
|
|
///</summary>
|
|
[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;
|
|
}
|
|
}
|
|
|
|
/// <summary>
|
|
///Represents strongly named DataRow class.
|
|
///</summary>
|
|
[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;
|
|
}
|
|
}
|
|
|
|
/// <summary>
|
|
///Row event argument class
|
|
///</summary>
|
|
[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;
|
|
}
|
|
}
|
|
}
|
|
|
|
/// <summary>
|
|
///Row event argument class
|
|
///</summary>
|
|
[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;
|
|
}
|
|
}
|
|
}
|
|
|
|
/// <summary>
|
|
///Row event argument class
|
|
///</summary>
|
|
[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 {
|
|
|
|
|
|
/// <summary>
|
|
///Represents the connection and commands used to retrieve and save data.
|
|
///</summary>
|
|
[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;
|
|
}
|
|
}
|
|
|
|
/// <summary>
|
|
///Represents the connection and commands used to retrieve and save data.
|
|
///</summary>
|
|
[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;
|
|
}
|
|
}
|
|
|
|
/// <summary>
|
|
///Represents the connection and commands used to retrieve and save data.
|
|
///</summary>
|
|
[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 |