Volian/SourceCode
8
0
Fork 0
Code Issues Pull Requests 1 Projects Releases Wiki Activity
SourceCode/PROMS/ROConvert/WestinghouseROImport/ROMasterDataSet.Designer.cs

3816 lines
207 KiB
C#
Raw Permalink Blame History

//------------------------------------------------------------------------------
// <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("ROMasterDataSet")]
[global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.DataSet")]
public partial class ROMasterDataSet : global::System.Data.DataSet {
private RO000002DataTable tableRO000002;
private RO000003DataTable tableRO000003;
private RO000004DataTable tableRO000004;
private ROMASTERDataTable tableROMASTER;
private global::System.Data.SchemaSerializationMode _schemaSerializationMode = global::System.Data.SchemaSerializationMode.IncludeSchema;
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
public ROMasterDataSet() {
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 ROMasterDataSet(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["RO000002"] != null)) {
base.Tables.Add(new RO000002DataTable(ds.Tables["RO000002"]));
}
if ((ds.Tables["RO000003"] != null)) {
base.Tables.Add(new RO000003DataTable(ds.Tables["RO000003"]));
}
if ((ds.Tables["RO000004"] != null)) {
base.Tables.Add(new RO000004DataTable(ds.Tables["RO000004"]));
}
if ((ds.Tables["ROMASTER"] != null)) {
base.Tables.Add(new ROMASTERDataTable(ds.Tables["ROMASTER"]));
}
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 RO000002DataTable RO000002 {
get {
return this.tableRO000002;
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.ComponentModel.Browsable(false)]
[global::System.ComponentModel.DesignerSerializationVisibility(global::System.ComponentModel.DesignerSerializationVisibility.Content)]
public RO000003DataTable RO000003 {
get {
return this.tableRO000003;
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.ComponentModel.Browsable(false)]
[global::System.ComponentModel.DesignerSerializationVisibility(global::System.ComponentModel.DesignerSerializationVisibility.Content)]
public RO000004DataTable RO000004 {
get {
return this.tableRO000004;
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.ComponentModel.Browsable(false)]
[global::System.ComponentModel.DesignerSerializationVisibility(global::System.ComponentModel.DesignerSerializationVisibility.Content)]
public ROMASTERDataTable ROMASTER {
get {
return this.tableROMASTER;
}
}
[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() {
ROMasterDataSet cln = ((ROMasterDataSet)(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["RO000002"] != null)) {
base.Tables.Add(new RO000002DataTable(ds.Tables["RO000002"]));
}
if ((ds.Tables["RO000003"] != null)) {
base.Tables.Add(new RO000003DataTable(ds.Tables["RO000003"]));
}
if ((ds.Tables["RO000004"] != null)) {
base.Tables.Add(new RO000004DataTable(ds.Tables["RO000004"]));
}
if ((ds.Tables["ROMASTER"] != null)) {
base.Tables.Add(new ROMASTERDataTable(ds.Tables["ROMASTER"]));
}
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.tableRO000002 = ((RO000002DataTable)(base.Tables["RO000002"]));
if ((initTable == true)) {
if ((this.tableRO000002 != null)) {
this.tableRO000002.InitVars();
}
}
this.tableRO000003 = ((RO000003DataTable)(base.Tables["RO000003"]));
if ((initTable == true)) {
if ((this.tableRO000003 != null)) {
this.tableRO000003.InitVars();
}
}
this.tableRO000004 = ((RO000004DataTable)(base.Tables["RO000004"]));
if ((initTable == true)) {
if ((this.tableRO000004 != null)) {
this.tableRO000004.InitVars();
}
}
this.tableROMASTER = ((ROMASTERDataTable)(base.Tables["ROMASTER"]));
if ((initTable == true)) {
if ((this.tableROMASTER != null)) {
this.tableROMASTER.InitVars();
}
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
private void InitClass() {
this.DataSetName = "ROMasterDataSet";
this.Prefix = "";
this.Namespace = "http://tempuri.org/ROMasterDataSet.xsd";
this.EnforceConstraints = true;
this.SchemaSerializationMode = global::System.Data.SchemaSerializationMode.IncludeSchema;
this.tableRO000002 = new RO000002DataTable();
base.Tables.Add(this.tableRO000002);
this.tableRO000003 = new RO000003DataTable();
base.Tables.Add(this.tableRO000003);
this.tableRO000004 = new RO000004DataTable();
base.Tables.Add(this.tableRO000004);
this.tableROMASTER = new ROMASTERDataTable();
base.Tables.Add(this.tableROMASTER);
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
private bool ShouldSerializeRO000002() {
return false;
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
private bool ShouldSerializeRO000003() {
return false;
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
private bool ShouldSerializeRO000004() {
return false;
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
private bool ShouldSerializeROMASTER() {
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) {
ROMasterDataSet ds = new ROMasterDataSet();
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 RO000002RowChangeEventHandler(object sender, RO000002RowChangeEvent e);
public delegate void RO000003RowChangeEventHandler(object sender, RO000003RowChangeEvent e);
public delegate void RO000004RowChangeEventHandler(object sender, RO000004RowChangeEvent e);
public delegate void ROMASTERRowChangeEventHandler(object sender, ROMASTERRowChangeEvent 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 RO000002DataTable : global::System.Data.DataTable, global::System.Collections.IEnumerable {
private global::System.Data.DataColumn columnRecID;
private global::System.Data.DataColumn columnRecType;
private global::System.Data.DataColumn columnParentID;
private global::System.Data.DataColumn columnAccPageID;
private global::System.Data.DataColumn columnModDateTime;
private global::System.Data.DataColumn columnInfo;
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
public RO000002DataTable() {
this.TableName = "RO000002";
this.BeginInit();
this.InitClass();
this.EndInit();
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
internal RO000002DataTable(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 RO000002DataTable(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 RecIDColumn {
get {
return this.columnRecID;
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
public global::System.Data.DataColumn RecTypeColumn {
get {
return this.columnRecType;
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
public global::System.Data.DataColumn ParentIDColumn {
get {
return this.columnParentID;
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
public global::System.Data.DataColumn AccPageIDColumn {
get {
return this.columnAccPageID;
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
public global::System.Data.DataColumn ModDateTimeColumn {
get {
return this.columnModDateTime;
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
public global::System.Data.DataColumn InfoColumn {
get {
return this.columnInfo;
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.ComponentModel.Browsable(false)]
public int Count {
get {
return this.Rows.Count;
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
public RO000002Row this[int index] {
get {
return ((RO000002Row)(this.Rows[index]));
}
}
public event RO000002RowChangeEventHandler RO000002RowChanging;
public event RO000002RowChangeEventHandler RO000002RowChanged;
public event RO000002RowChangeEventHandler RO000002RowDeleting;
public event RO000002RowChangeEventHandler RO000002RowDeleted;
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
public void AddRO000002Row(RO000002Row row) {
this.Rows.Add(row);
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
public RO000002Row AddRO000002Row(string RecID, int RecType, string ParentID, string AccPageID, string ModDateTime, string Info) {
RO000002Row rowRO000002Row = ((RO000002Row)(this.NewRow()));
object[] columnValuesArray = new object[] {
RecID,
RecType,
ParentID,
AccPageID,
ModDateTime,
Info};
rowRO000002Row.ItemArray = columnValuesArray;
this.Rows.Add(rowRO000002Row);
return rowRO000002Row;
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
public RO000002Row FindByRecID(string RecID) {
return ((RO000002Row)(this.Rows.Find(new object[] {
RecID})));
}
[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() {
RO000002DataTable cln = ((RO000002DataTable)(base.Clone()));
cln.InitVars();
return cln;
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
protected override global::System.Data.DataTable CreateInstance() {
return new RO000002DataTable();
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
internal void InitVars() {
this.columnRecID = base.Columns["RecID"];
this.columnRecType = base.Columns["RecType"];
this.columnParentID = base.Columns["ParentID"];
this.columnAccPageID = base.Columns["AccPageID"];
this.columnModDateTime = base.Columns["ModDateTime"];
this.columnInfo = base.Columns["Info"];
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
private void InitClass() {
this.columnRecID = new global::System.Data.DataColumn("RecID", typeof(string), null, global::System.Data.MappingType.Element);
base.Columns.Add(this.columnRecID);
this.columnRecType = new global::System.Data.DataColumn("RecType", typeof(int), null, global::System.Data.MappingType.Element);
base.Columns.Add(this.columnRecType);
this.columnParentID = new global::System.Data.DataColumn("ParentID", typeof(string), null, global::System.Data.MappingType.Element);
base.Columns.Add(this.columnParentID);
this.columnAccPageID = new global::System.Data.DataColumn("AccPageID", typeof(string), null, global::System.Data.MappingType.Element);
base.Columns.Add(this.columnAccPageID);
this.columnModDateTime = new global::System.Data.DataColumn("ModDateTime", typeof(string), null, global::System.Data.MappingType.Element);
base.Columns.Add(this.columnModDateTime);
this.columnInfo = new global::System.Data.DataColumn("Info", typeof(string), null, global::System.Data.MappingType.Element);
base.Columns.Add(this.columnInfo);
this.Constraints.Add(new global::System.Data.UniqueConstraint("Constraint1", new global::System.Data.DataColumn[] {
this.columnRecID}, true));
this.columnRecID.AllowDBNull = false;
this.columnRecID.Unique = true;
this.columnRecID.MaxLength = 8;
this.columnParentID.MaxLength = 8;
this.columnAccPageID.MaxLength = 32;
this.columnModDateTime.MaxLength = 14;
this.columnInfo.MaxLength = 536870910;
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
public RO000002Row NewRO000002Row() {
return ((RO000002Row)(this.NewRow()));
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
protected override global::System.Data.DataRow NewRowFromBuilder(global::System.Data.DataRowBuilder builder) {
return new RO000002Row(builder);
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
protected override global::System.Type GetRowType() {
return typeof(RO000002Row);
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
protected override void OnRowChanged(global::System.Data.DataRowChangeEventArgs e) {
base.OnRowChanged(e);
if ((this.RO000002RowChanged != null)) {
this.RO000002RowChanged(this, new RO000002RowChangeEvent(((RO000002Row)(e.Row)), e.Action));
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
protected override void OnRowChanging(global::System.Data.DataRowChangeEventArgs e) {
base.OnRowChanging(e);
if ((this.RO000002RowChanging != null)) {
this.RO000002RowChanging(this, new RO000002RowChangeEvent(((RO000002Row)(e.Row)), e.Action));
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
protected override void OnRowDeleted(global::System.Data.DataRowChangeEventArgs e) {
base.OnRowDeleted(e);
if ((this.RO000002RowDeleted != null)) {
this.RO000002RowDeleted(this, new RO000002RowChangeEvent(((RO000002Row)(e.Row)), e.Action));
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
protected override void OnRowDeleting(global::System.Data.DataRowChangeEventArgs e) {
base.OnRowDeleting(e);
if ((this.RO000002RowDeleting != null)) {
this.RO000002RowDeleting(this, new RO000002RowChangeEvent(((RO000002Row)(e.Row)), e.Action));
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
public void RemoveRO000002Row(RO000002Row 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();
ROMasterDataSet ds = new ROMasterDataSet();
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 = "RO000002DataTable";
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 RO000003DataTable : global::System.Data.DataTable, global::System.Collections.IEnumerable {
private global::System.Data.DataColumn columnRecID;
private global::System.Data.DataColumn columnRecType;
private global::System.Data.DataColumn columnParentID;
private global::System.Data.DataColumn columnAccPageID;
private global::System.Data.DataColumn columnModDateTime;
private global::System.Data.DataColumn columnInfo;
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
public RO000003DataTable() {
this.TableName = "RO000003";
this.BeginInit();
this.InitClass();
this.EndInit();
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
internal RO000003DataTable(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 RO000003DataTable(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 RecIDColumn {
get {
return this.columnRecID;
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
public global::System.Data.DataColumn RecTypeColumn {
get {
return this.columnRecType;
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
public global::System.Data.DataColumn ParentIDColumn {
get {
return this.columnParentID;
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
public global::System.Data.DataColumn AccPageIDColumn {
get {
return this.columnAccPageID;
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
public global::System.Data.DataColumn ModDateTimeColumn {
get {
return this.columnModDateTime;
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
public global::System.Data.DataColumn InfoColumn {
get {
return this.columnInfo;
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.ComponentModel.Browsable(false)]
public int Count {
get {
return this.Rows.Count;
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
public RO000003Row this[int index] {
get {
return ((RO000003Row)(this.Rows[index]));
}
}
public event RO000003RowChangeEventHandler RO000003RowChanging;
public event RO000003RowChangeEventHandler RO000003RowChanged;
public event RO000003RowChangeEventHandler RO000003RowDeleting;
public event RO000003RowChangeEventHandler RO000003RowDeleted;
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
public void AddRO000003Row(RO000003Row row) {
this.Rows.Add(row);
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
public RO000003Row AddRO000003Row(string RecID, int RecType, string ParentID, string AccPageID, string ModDateTime, string Info) {
RO000003Row rowRO000003Row = ((RO000003Row)(this.NewRow()));
object[] columnValuesArray = new object[] {
RecID,
RecType,
ParentID,
AccPageID,
ModDateTime,
Info};
rowRO000003Row.ItemArray = columnValuesArray;
this.Rows.Add(rowRO000003Row);
return rowRO000003Row;
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
public RO000003Row FindByRecID(string RecID) {
return ((RO000003Row)(this.Rows.Find(new object[] {
RecID})));
}
[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() {
RO000003DataTable cln = ((RO000003DataTable)(base.Clone()));
cln.InitVars();
return cln;
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
protected override global::System.Data.DataTable CreateInstance() {
return new RO000003DataTable();
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
internal void InitVars() {
this.columnRecID = base.Columns["RecID"];
this.columnRecType = base.Columns["RecType"];
this.columnParentID = base.Columns["ParentID"];
this.columnAccPageID = base.Columns["AccPageID"];
this.columnModDateTime = base.Columns["ModDateTime"];
this.columnInfo = base.Columns["Info"];
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
private void InitClass() {
this.columnRecID = new global::System.Data.DataColumn("RecID", typeof(string), null, global::System.Data.MappingType.Element);
base.Columns.Add(this.columnRecID);
this.columnRecType = new global::System.Data.DataColumn("RecType", typeof(int), null, global::System.Data.MappingType.Element);
base.Columns.Add(this.columnRecType);
this.columnParentID = new global::System.Data.DataColumn("ParentID", typeof(string), null, global::System.Data.MappingType.Element);
base.Columns.Add(this.columnParentID);
this.columnAccPageID = new global::System.Data.DataColumn("AccPageID", typeof(string), null, global::System.Data.MappingType.Element);
base.Columns.Add(this.columnAccPageID);
this.columnModDateTime = new global::System.Data.DataColumn("ModDateTime", typeof(string), null, global::System.Data.MappingType.Element);
base.Columns.Add(this.columnModDateTime);
this.columnInfo = new global::System.Data.DataColumn("Info", typeof(string), null, global::System.Data.MappingType.Element);
base.Columns.Add(this.columnInfo);
this.Constraints.Add(new global::System.Data.UniqueConstraint("Constraint1", new global::System.Data.DataColumn[] {
this.columnRecID}, true));
this.columnRecID.AllowDBNull = false;
this.columnRecID.Unique = true;
this.columnRecID.MaxLength = 8;
this.columnParentID.MaxLength = 8;
this.columnAccPageID.MaxLength = 32;
this.columnModDateTime.MaxLength = 14;
this.columnInfo.MaxLength = 536870910;
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
public RO000003Row NewRO000003Row() {
return ((RO000003Row)(this.NewRow()));
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
protected override global::System.Data.DataRow NewRowFromBuilder(global::System.Data.DataRowBuilder builder) {
return new RO000003Row(builder);
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
protected override global::System.Type GetRowType() {
return typeof(RO000003Row);
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
protected override void OnRowChanged(global::System.Data.DataRowChangeEventArgs e) {
base.OnRowChanged(e);
if ((this.RO000003RowChanged != null)) {
this.RO000003RowChanged(this, new RO000003RowChangeEvent(((RO000003Row)(e.Row)), e.Action));
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
protected override void OnRowChanging(global::System.Data.DataRowChangeEventArgs e) {
base.OnRowChanging(e);
if ((this.RO000003RowChanging != null)) {
this.RO000003RowChanging(this, new RO000003RowChangeEvent(((RO000003Row)(e.Row)), e.Action));
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
protected override void OnRowDeleted(global::System.Data.DataRowChangeEventArgs e) {
base.OnRowDeleted(e);
if ((this.RO000003RowDeleted != null)) {
this.RO000003RowDeleted(this, new RO000003RowChangeEvent(((RO000003Row)(e.Row)), e.Action));
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
protected override void OnRowDeleting(global::System.Data.DataRowChangeEventArgs e) {
base.OnRowDeleting(e);
if ((this.RO000003RowDeleting != null)) {
this.RO000003RowDeleting(this, new RO000003RowChangeEvent(((RO000003Row)(e.Row)), e.Action));
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
public void RemoveRO000003Row(RO000003Row 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();
ROMasterDataSet ds = new ROMasterDataSet();
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 = "RO000003DataTable";
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 RO000004DataTable : global::System.Data.DataTable, global::System.Collections.IEnumerable {
private global::System.Data.DataColumn columnRecID;
private global::System.Data.DataColumn columnRecType;
private global::System.Data.DataColumn columnParentID;
private global::System.Data.DataColumn columnAccPageID;
private global::System.Data.DataColumn columnModDateTime;
private global::System.Data.DataColumn columnInfo;
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
public RO000004DataTable() {
this.TableName = "RO000004";
this.BeginInit();
this.InitClass();
this.EndInit();
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
internal RO000004DataTable(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 RO000004DataTable(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 RecIDColumn {
get {
return this.columnRecID;
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
public global::System.Data.DataColumn RecTypeColumn {
get {
return this.columnRecType;
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
public global::System.Data.DataColumn ParentIDColumn {
get {
return this.columnParentID;
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
public global::System.Data.DataColumn AccPageIDColumn {
get {
return this.columnAccPageID;
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
public global::System.Data.DataColumn ModDateTimeColumn {
get {
return this.columnModDateTime;
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
public global::System.Data.DataColumn InfoColumn {
get {
return this.columnInfo;
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.ComponentModel.Browsable(false)]
public int Count {
get {
return this.Rows.Count;
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
public RO000004Row this[int index] {
get {
return ((RO000004Row)(this.Rows[index]));
}
}
public event RO000004RowChangeEventHandler RO000004RowChanging;
public event RO000004RowChangeEventHandler RO000004RowChanged;
public event RO000004RowChangeEventHandler RO000004RowDeleting;
public event RO000004RowChangeEventHandler RO000004RowDeleted;
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
public void AddRO000004Row(RO000004Row row) {
this.Rows.Add(row);
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
public RO000004Row AddRO000004Row(string RecID, int RecType, string ParentID, string AccPageID, string ModDateTime, string Info) {
RO000004Row rowRO000004Row = ((RO000004Row)(this.NewRow()));
object[] columnValuesArray = new object[] {
RecID,
RecType,
ParentID,
AccPageID,
ModDateTime,
Info};
rowRO000004Row.ItemArray = columnValuesArray;
this.Rows.Add(rowRO000004Row);
return rowRO000004Row;
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
public RO000004Row FindByRecID(string RecID) {
return ((RO000004Row)(this.Rows.Find(new object[] {
RecID})));
}
[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() {
RO000004DataTable cln = ((RO000004DataTable)(base.Clone()));
cln.InitVars();
return cln;
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
protected override global::System.Data.DataTable CreateInstance() {
return new RO000004DataTable();
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
internal void InitVars() {
this.columnRecID = base.Columns["RecID"];
this.columnRecType = base.Columns["RecType"];
this.columnParentID = base.Columns["ParentID"];
this.columnAccPageID = base.Columns["AccPageID"];
this.columnModDateTime = base.Columns["ModDateTime"];
this.columnInfo = base.Columns["Info"];
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
private void InitClass() {
this.columnRecID = new global::System.Data.DataColumn("RecID", typeof(string), null, global::System.Data.MappingType.Element);
base.Columns.Add(this.columnRecID);
this.columnRecType = new global::System.Data.DataColumn("RecType", typeof(int), null, global::System.Data.MappingType.Element);
base.Columns.Add(this.columnRecType);
this.columnParentID = new global::System.Data.DataColumn("ParentID", typeof(string), null, global::System.Data.MappingType.Element);
base.Columns.Add(this.columnParentID);
this.columnAccPageID = new global::System.Data.DataColumn("AccPageID", typeof(string), null, global::System.Data.MappingType.Element);
base.Columns.Add(this.columnAccPageID);
this.columnModDateTime = new global::System.Data.DataColumn("ModDateTime", typeof(string), null, global::System.Data.MappingType.Element);
base.Columns.Add(this.columnModDateTime);
this.columnInfo = new global::System.Data.DataColumn("Info", typeof(string), null, global::System.Data.MappingType.Element);
base.Columns.Add(this.columnInfo);
this.Constraints.Add(new global::System.Data.UniqueConstraint("Constraint1", new global::System.Data.DataColumn[] {
this.columnRecID}, true));
this.columnRecID.AllowDBNull = false;
this.columnRecID.Unique = true;
this.columnRecID.MaxLength = 8;
this.columnParentID.MaxLength = 8;
this.columnAccPageID.MaxLength = 32;
this.columnModDateTime.MaxLength = 14;
this.columnInfo.MaxLength = 536870910;
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
public RO000004Row NewRO000004Row() {
return ((RO000004Row)(this.NewRow()));
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
protected override global::System.Data.DataRow NewRowFromBuilder(global::System.Data.DataRowBuilder builder) {
return new RO000004Row(builder);
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
protected override global::System.Type GetRowType() {
return typeof(RO000004Row);
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
protected override void OnRowChanged(global::System.Data.DataRowChangeEventArgs e) {
base.OnRowChanged(e);
if ((this.RO000004RowChanged != null)) {
this.RO000004RowChanged(this, new RO000004RowChangeEvent(((RO000004Row)(e.Row)), e.Action));
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
protected override void OnRowChanging(global::System.Data.DataRowChangeEventArgs e) {
base.OnRowChanging(e);
if ((this.RO000004RowChanging != null)) {
this.RO000004RowChanging(this, new RO000004RowChangeEvent(((RO000004Row)(e.Row)), e.Action));
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
protected override void OnRowDeleted(global::System.Data.DataRowChangeEventArgs e) {
base.OnRowDeleted(e);
if ((this.RO000004RowDeleted != null)) {
this.RO000004RowDeleted(this, new RO000004RowChangeEvent(((RO000004Row)(e.Row)), e.Action));
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
protected override void OnRowDeleting(global::System.Data.DataRowChangeEventArgs e) {
base.OnRowDeleting(e);
if ((this.RO000004RowDeleting != null)) {
this.RO000004RowDeleting(this, new RO000004RowChangeEvent(((RO000004Row)(e.Row)), e.Action));
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
public void RemoveRO000004Row(RO000004Row 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();
ROMasterDataSet ds = new ROMasterDataSet();
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 = "RO000004DataTable";
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 ROMASTERDataTable : global::System.Data.DataTable, global::System.Collections.IEnumerable {
private global::System.Data.DataColumn columnRecID;
private global::System.Data.DataColumn columnRecType;
private global::System.Data.DataColumn columnParentID;
private global::System.Data.DataColumn columnAccPageID;
private global::System.Data.DataColumn columnModDateTime;
private global::System.Data.DataColumn columnInfo;
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
public ROMASTERDataTable() {
this.TableName = "ROMASTER";
this.BeginInit();
this.InitClass();
this.EndInit();
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
internal ROMASTERDataTable(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 ROMASTERDataTable(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 RecIDColumn {
get {
return this.columnRecID;
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
public global::System.Data.DataColumn RecTypeColumn {
get {
return this.columnRecType;
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
public global::System.Data.DataColumn ParentIDColumn {
get {
return this.columnParentID;
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
public global::System.Data.DataColumn AccPageIDColumn {
get {
return this.columnAccPageID;
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
public global::System.Data.DataColumn ModDateTimeColumn {
get {
return this.columnModDateTime;
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
public global::System.Data.DataColumn InfoColumn {
get {
return this.columnInfo;
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.ComponentModel.Browsable(false)]
public int Count {
get {
return this.Rows.Count;
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
public ROMASTERRow this[int index] {
get {
return ((ROMASTERRow)(this.Rows[index]));
}
}
public event ROMASTERRowChangeEventHandler ROMASTERRowChanging;
public event ROMASTERRowChangeEventHandler ROMASTERRowChanged;
public event ROMASTERRowChangeEventHandler ROMASTERRowDeleting;
public event ROMASTERRowChangeEventHandler ROMASTERRowDeleted;
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
public void AddROMASTERRow(ROMASTERRow row) {
this.Rows.Add(row);
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
public ROMASTERRow AddROMASTERRow(string RecID, int RecType, string ParentID, string AccPageID, string ModDateTime, string Info) {
ROMASTERRow rowROMASTERRow = ((ROMASTERRow)(this.NewRow()));
object[] columnValuesArray = new object[] {
RecID,
RecType,
ParentID,
AccPageID,
ModDateTime,
Info};
rowROMASTERRow.ItemArray = columnValuesArray;
this.Rows.Add(rowROMASTERRow);
return rowROMASTERRow;
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
public ROMASTERRow FindByRecID(string RecID) {
return ((ROMASTERRow)(this.Rows.Find(new object[] {
RecID})));
}
[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() {
ROMASTERDataTable cln = ((ROMASTERDataTable)(base.Clone()));
cln.InitVars();
return cln;
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
protected override global::System.Data.DataTable CreateInstance() {
return new ROMASTERDataTable();
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
internal void InitVars() {
this.columnRecID = base.Columns["RecID"];
this.columnRecType = base.Columns["RecType"];
this.columnParentID = base.Columns["ParentID"];
this.columnAccPageID = base.Columns["AccPageID"];
this.columnModDateTime = base.Columns["ModDateTime"];
this.columnInfo = base.Columns["Info"];
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
private void InitClass() {
this.columnRecID = new global::System.Data.DataColumn("RecID", typeof(string), null, global::System.Data.MappingType.Element);
base.Columns.Add(this.columnRecID);
this.columnRecType = new global::System.Data.DataColumn("RecType", typeof(int), null, global::System.Data.MappingType.Element);
base.Columns.Add(this.columnRecType);
this.columnParentID = new global::System.Data.DataColumn("ParentID", typeof(string), null, global::System.Data.MappingType.Element);
base.Columns.Add(this.columnParentID);
this.columnAccPageID = new global::System.Data.DataColumn("AccPageID", typeof(string), null, global::System.Data.MappingType.Element);
base.Columns.Add(this.columnAccPageID);
this.columnModDateTime = new global::System.Data.DataColumn("ModDateTime", typeof(string), null, global::System.Data.MappingType.Element);
base.Columns.Add(this.columnModDateTime);
this.columnInfo = new global::System.Data.DataColumn("Info", typeof(string), null, global::System.Data.MappingType.Element);
base.Columns.Add(this.columnInfo);
this.Constraints.Add(new global::System.Data.UniqueConstraint("Constraint1", new global::System.Data.DataColumn[] {
this.columnRecID}, true));
this.columnRecID.AllowDBNull = false;
this.columnRecID.Unique = true;
this.columnRecID.MaxLength = 8;
this.columnParentID.MaxLength = 8;
this.columnAccPageID.MaxLength = 32;
this.columnModDateTime.MaxLength = 14;
this.columnInfo.MaxLength = 536870910;
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
public ROMASTERRow NewROMASTERRow() {
return ((ROMASTERRow)(this.NewRow()));
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
protected override global::System.Data.DataRow NewRowFromBuilder(global::System.Data.DataRowBuilder builder) {
return new ROMASTERRow(builder);
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
protected override global::System.Type GetRowType() {
return typeof(ROMASTERRow);
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
protected override void OnRowChanged(global::System.Data.DataRowChangeEventArgs e) {
base.OnRowChanged(e);
if ((this.ROMASTERRowChanged != null)) {
this.ROMASTERRowChanged(this, new ROMASTERRowChangeEvent(((ROMASTERRow)(e.Row)), e.Action));
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
protected override void OnRowChanging(global::System.Data.DataRowChangeEventArgs e) {
base.OnRowChanging(e);
if ((this.ROMASTERRowChanging != null)) {
this.ROMASTERRowChanging(this, new ROMASTERRowChangeEvent(((ROMASTERRow)(e.Row)), e.Action));
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
protected override void OnRowDeleted(global::System.Data.DataRowChangeEventArgs e) {
base.OnRowDeleted(e);
if ((this.ROMASTERRowDeleted != null)) {
this.ROMASTERRowDeleted(this, new ROMASTERRowChangeEvent(((ROMASTERRow)(e.Row)), e.Action));
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
protected override void OnRowDeleting(global::System.Data.DataRowChangeEventArgs e) {
base.OnRowDeleting(e);
if ((this.ROMASTERRowDeleting != null)) {
this.ROMASTERRowDeleting(this, new ROMASTERRowChangeEvent(((ROMASTERRow)(e.Row)), e.Action));
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
public void RemoveROMASTERRow(ROMASTERRow 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();
ROMasterDataSet ds = new ROMasterDataSet();
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 = "ROMASTERDataTable";
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 RO000002Row : global::System.Data.DataRow {
private RO000002DataTable tableRO000002;
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
internal RO000002Row(global::System.Data.DataRowBuilder rb) :
base(rb) {
this.tableRO000002 = ((RO000002DataTable)(this.Table));
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
public string RecID {
get {
return ((string)(this[this.tableRO000002.RecIDColumn]));
}
set {
this[this.tableRO000002.RecIDColumn] = value;
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
public int RecType {
get {
try {
return ((int)(this[this.tableRO000002.RecTypeColumn]));
}
catch (global::System.InvalidCastException e) {
throw new global::System.Data.StrongTypingException("The value for column \'RecType\' in table \'RO000002\' is DBNull.", e);
}
}
set {
this[this.tableRO000002.RecTypeColumn] = value;
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
public string ParentID {
get {
try {
return ((string)(this[this.tableRO000002.ParentIDColumn]));
}
catch (global::System.InvalidCastException e) {
throw new global::System.Data.StrongTypingException("The value for column \'ParentID\' in table \'RO000002\' is DBNull.", e);
}
}
set {
this[this.tableRO000002.ParentIDColumn] = value;
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
public string AccPageID {
get {
try {
return ((string)(this[this.tableRO000002.AccPageIDColumn]));
}
catch (global::System.InvalidCastException e) {
throw new global::System.Data.StrongTypingException("The value for column \'AccPageID\' in table \'RO000002\' is DBNull.", e);
}
}
set {
this[this.tableRO000002.AccPageIDColumn] = value;
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
public string ModDateTime {
get {
try {
return ((string)(this[this.tableRO000002.ModDateTimeColumn]));
}
catch (global::System.InvalidCastException e) {
throw new global::System.Data.StrongTypingException("The value for column \'ModDateTime\' in table \'RO000002\' is DBNull.", e);
}
}
set {
this[this.tableRO000002.ModDateTimeColumn] = value;
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
public string Info {
get {
try {
return ((string)(this[this.tableRO000002.InfoColumn]));
}
catch (global::System.InvalidCastException e) {
throw new global::System.Data.StrongTypingException("The value for column \'Info\' in table \'RO000002\' is DBNull.", e);
}
}
set {
this[this.tableRO000002.InfoColumn] = value;
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
public bool IsRecTypeNull() {
return this.IsNull(this.tableRO000002.RecTypeColumn);
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
public void SetRecTypeNull() {
this[this.tableRO000002.RecTypeColumn] = global::System.Convert.DBNull;
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
public bool IsParentIDNull() {
return this.IsNull(this.tableRO000002.ParentIDColumn);
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
public void SetParentIDNull() {
this[this.tableRO000002.ParentIDColumn] = global::System.Convert.DBNull;
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
public bool IsAccPageIDNull() {
return this.IsNull(this.tableRO000002.AccPageIDColumn);
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
public void SetAccPageIDNull() {
this[this.tableRO000002.AccPageIDColumn] = global::System.Convert.DBNull;
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
public bool IsModDateTimeNull() {
return this.IsNull(this.tableRO000002.ModDateTimeColumn);
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
public void SetModDateTimeNull() {
this[this.tableRO000002.ModDateTimeColumn] = global::System.Convert.DBNull;
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
public bool IsInfoNull() {
return this.IsNull(this.tableRO000002.InfoColumn);
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
public void SetInfoNull() {
this[this.tableRO000002.InfoColumn] = 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 RO000003Row : global::System.Data.DataRow {
private RO000003DataTable tableRO000003;
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
internal RO000003Row(global::System.Data.DataRowBuilder rb) :
base(rb) {
this.tableRO000003 = ((RO000003DataTable)(this.Table));
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
public string RecID {
get {
return ((string)(this[this.tableRO000003.RecIDColumn]));
}
set {
this[this.tableRO000003.RecIDColumn] = value;
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
public int RecType {
get {
try {
return ((int)(this[this.tableRO000003.RecTypeColumn]));
}
catch (global::System.InvalidCastException e) {
throw new global::System.Data.StrongTypingException("The value for column \'RecType\' in table \'RO000003\' is DBNull.", e);
}
}
set {
this[this.tableRO000003.RecTypeColumn] = value;
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
public string ParentID {
get {
try {
return ((string)(this[this.tableRO000003.ParentIDColumn]));
}
catch (global::System.InvalidCastException e) {
throw new global::System.Data.StrongTypingException("The value for column \'ParentID\' in table \'RO000003\' is DBNull.", e);
}
}
set {
this[this.tableRO000003.ParentIDColumn] = value;
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
public string AccPageID {
get {
try {
return ((string)(this[this.tableRO000003.AccPageIDColumn]));
}
catch (global::System.InvalidCastException e) {
throw new global::System.Data.StrongTypingException("The value for column \'AccPageID\' in table \'RO000003\' is DBNull.", e);
}
}
set {
this[this.tableRO000003.AccPageIDColumn] = value;
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
public string ModDateTime {
get {
try {
return ((string)(this[this.tableRO000003.ModDateTimeColumn]));
}
catch (global::System.InvalidCastException e) {
throw new global::System.Data.StrongTypingException("The value for column \'ModDateTime\' in table \'RO000003\' is DBNull.", e);
}
}
set {
this[this.tableRO000003.ModDateTimeColumn] = value;
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
public string Info {
get {
try {
return ((string)(this[this.tableRO000003.InfoColumn]));
}
catch (global::System.InvalidCastException e) {
throw new global::System.Data.StrongTypingException("The value for column \'Info\' in table \'RO000003\' is DBNull.", e);
}
}
set {
this[this.tableRO000003.InfoColumn] = value;
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
public bool IsRecTypeNull() {
return this.IsNull(this.tableRO000003.RecTypeColumn);
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
public void SetRecTypeNull() {
this[this.tableRO000003.RecTypeColumn] = global::System.Convert.DBNull;
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
public bool IsParentIDNull() {
return this.IsNull(this.tableRO000003.ParentIDColumn);
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
public void SetParentIDNull() {
this[this.tableRO000003.ParentIDColumn] = global::System.Convert.DBNull;
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
public bool IsAccPageIDNull() {
return this.IsNull(this.tableRO000003.AccPageIDColumn);
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
public void SetAccPageIDNull() {
this[this.tableRO000003.AccPageIDColumn] = global::System.Convert.DBNull;
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
public bool IsModDateTimeNull() {
return this.IsNull(this.tableRO000003.ModDateTimeColumn);
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
public void SetModDateTimeNull() {
this[this.tableRO000003.ModDateTimeColumn] = global::System.Convert.DBNull;
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
public bool IsInfoNull() {
return this.IsNull(this.tableRO000003.InfoColumn);
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
public void SetInfoNull() {
this[this.tableRO000003.InfoColumn] = 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 RO000004Row : global::System.Data.DataRow {
private RO000004DataTable tableRO000004;
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
internal RO000004Row(global::System.Data.DataRowBuilder rb) :
base(rb) {
this.tableRO000004 = ((RO000004DataTable)(this.Table));
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
public string RecID {
get {
return ((string)(this[this.tableRO000004.RecIDColumn]));
}
set {
this[this.tableRO000004.RecIDColumn] = value;
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
public int RecType {
get {
try {
return ((int)(this[this.tableRO000004.RecTypeColumn]));
}
catch (global::System.InvalidCastException e) {
throw new global::System.Data.StrongTypingException("The value for column \'RecType\' in table \'RO000004\' is DBNull.", e);
}
}
set {
this[this.tableRO000004.RecTypeColumn] = value;
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
public string ParentID {
get {
try {
return ((string)(this[this.tableRO000004.ParentIDColumn]));
}
catch (global::System.InvalidCastException e) {
throw new global::System.Data.StrongTypingException("The value for column \'ParentID\' in table \'RO000004\' is DBNull.", e);
}
}
set {
this[this.tableRO000004.ParentIDColumn] = value;
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
public string AccPageID {
get {
try {
return ((string)(this[this.tableRO000004.AccPageIDColumn]));
}
catch (global::System.InvalidCastException e) {
throw new global::System.Data.StrongTypingException("The value for column \'AccPageID\' in table \'RO000004\' is DBNull.", e);
}
}
set {
this[this.tableRO000004.AccPageIDColumn] = value;
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
public string ModDateTime {
get {
try {
return ((string)(this[this.tableRO000004.ModDateTimeColumn]));
}
catch (global::System.InvalidCastException e) {
throw new global::System.Data.StrongTypingException("The value for column \'ModDateTime\' in table \'RO000004\' is DBNull.", e);
}
}
set {
this[this.tableRO000004.ModDateTimeColumn] = value;
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
public string Info {
get {
try {
return ((string)(this[this.tableRO000004.InfoColumn]));
}
catch (global::System.InvalidCastException e) {
throw new global::System.Data.StrongTypingException("The value for column \'Info\' in table \'RO000004\' is DBNull.", e);
}
}
set {
this[this.tableRO000004.InfoColumn] = value;
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
public bool IsRecTypeNull() {
return this.IsNull(this.tableRO000004.RecTypeColumn);
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
public void SetRecTypeNull() {
this[this.tableRO000004.RecTypeColumn] = global::System.Convert.DBNull;
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
public bool IsParentIDNull() {
return this.IsNull(this.tableRO000004.ParentIDColumn);
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
public void SetParentIDNull() {
this[this.tableRO000004.ParentIDColumn] = global::System.Convert.DBNull;
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
public bool IsAccPageIDNull() {
return this.IsNull(this.tableRO000004.AccPageIDColumn);
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
public void SetAccPageIDNull() {
this[this.tableRO000004.AccPageIDColumn] = global::System.Convert.DBNull;
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
public bool IsModDateTimeNull() {
return this.IsNull(this.tableRO000004.ModDateTimeColumn);
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
public void SetModDateTimeNull() {
this[this.tableRO000004.ModDateTimeColumn] = global::System.Convert.DBNull;
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
public bool IsInfoNull() {
return this.IsNull(this.tableRO000004.InfoColumn);
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
public void SetInfoNull() {
this[this.tableRO000004.InfoColumn] = 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 ROMASTERRow : global::System.Data.DataRow {
private ROMASTERDataTable tableROMASTER;
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
internal ROMASTERRow(global::System.Data.DataRowBuilder rb) :
base(rb) {
this.tableROMASTER = ((ROMASTERDataTable)(this.Table));
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
public string RecID {
get {
return ((string)(this[this.tableROMASTER.RecIDColumn]));
}
set {
this[this.tableROMASTER.RecIDColumn] = value;
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
public int RecType {
get {
try {
return ((int)(this[this.tableROMASTER.RecTypeColumn]));
}
catch (global::System.InvalidCastException e) {
throw new global::System.Data.StrongTypingException("The value for column \'RecType\' in table \'ROMASTER\' is DBNull.", e);
}
}
set {
this[this.tableROMASTER.RecTypeColumn] = value;
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
public string ParentID {
get {
try {
return ((string)(this[this.tableROMASTER.ParentIDColumn]));
}
catch (global::System.InvalidCastException e) {
throw new global::System.Data.StrongTypingException("The value for column \'ParentID\' in table \'ROMASTER\' is DBNull.", e);
}
}
set {
this[this.tableROMASTER.ParentIDColumn] = value;
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
public string AccPageID {
get {
try {
return ((string)(this[this.tableROMASTER.AccPageIDColumn]));
}
catch (global::System.InvalidCastException e) {
throw new global::System.Data.StrongTypingException("The value for column \'AccPageID\' in table \'ROMASTER\' is DBNull.", e);
}
}
set {
this[this.tableROMASTER.AccPageIDColumn] = value;
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
public string ModDateTime {
get {
try {
return ((string)(this[this.tableROMASTER.ModDateTimeColumn]));
}
catch (global::System.InvalidCastException e) {
throw new global::System.Data.StrongTypingException("The value for column \'ModDateTime\' in table \'ROMASTER\' is DBNull.", e);
}
}
set {
this[this.tableROMASTER.ModDateTimeColumn] = value;
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
public string Info {
get {
try {
return ((string)(this[this.tableROMASTER.InfoColumn]));
}
catch (global::System.InvalidCastException e) {
throw new global::System.Data.StrongTypingException("The value for column \'Info\' in table \'ROMASTER\' is DBNull.", e);
}
}
set {
this[this.tableROMASTER.InfoColumn] = value;
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
public bool IsRecTypeNull() {
return this.IsNull(this.tableROMASTER.RecTypeColumn);
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
public void SetRecTypeNull() {
this[this.tableROMASTER.RecTypeColumn] = global::System.Convert.DBNull;
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
public bool IsParentIDNull() {
return this.IsNull(this.tableROMASTER.ParentIDColumn);
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
public void SetParentIDNull() {
this[this.tableROMASTER.ParentIDColumn] = global::System.Convert.DBNull;
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
public bool IsAccPageIDNull() {
return this.IsNull(this.tableROMASTER.AccPageIDColumn);
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
public void SetAccPageIDNull() {
this[this.tableROMASTER.AccPageIDColumn] = global::System.Convert.DBNull;
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
public bool IsModDateTimeNull() {
return this.IsNull(this.tableROMASTER.ModDateTimeColumn);
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
public void SetModDateTimeNull() {
this[this.tableROMASTER.ModDateTimeColumn] = global::System.Convert.DBNull;
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
public bool IsInfoNull() {
return this.IsNull(this.tableROMASTER.InfoColumn);
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
public void SetInfoNull() {
this[this.tableROMASTER.InfoColumn] = 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 RO000002RowChangeEvent : global::System.EventArgs {
private RO000002Row eventRow;
private global::System.Data.DataRowAction eventAction;
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
public RO000002RowChangeEvent(RO000002Row row, global::System.Data.DataRowAction action) {
this.eventRow = row;
this.eventAction = action;
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
public RO000002Row 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 RO000003RowChangeEvent : global::System.EventArgs {
private RO000003Row eventRow;
private global::System.Data.DataRowAction eventAction;
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
public RO000003RowChangeEvent(RO000003Row row, global::System.Data.DataRowAction action) {
this.eventRow = row;
this.eventAction = action;
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
public RO000003Row 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 RO000004RowChangeEvent : global::System.EventArgs {
private RO000004Row eventRow;
private global::System.Data.DataRowAction eventAction;
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
public RO000004RowChangeEvent(RO000004Row row, global::System.Data.DataRowAction action) {
this.eventRow = row;
this.eventAction = action;
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
public RO000004Row 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 ROMASTERRowChangeEvent : global::System.EventArgs {
private ROMASTERRow eventRow;
private global::System.Data.DataRowAction eventAction;
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
public ROMASTERRowChangeEvent(ROMASTERRow row, global::System.Data.DataRowAction action) {
this.eventRow = row;
this.eventAction = action;
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
public ROMASTERRow Row {
get {
return this.eventRow;
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
public global::System.Data.DataRowAction Action {
get {
return this.eventAction;
}
}
}
}
}
namespace WestinghouseROImport.ROMasterDataSetTableAdapters {
/// <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 RO000002TableAdapter : 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 RO000002TableAdapter() {
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 = "RO000002";
tableMapping.ColumnMappings.Add("RecID", "RecID");
tableMapping.ColumnMappings.Add("RecType", "RecType");
tableMapping.ColumnMappings.Add("ParentID", "ParentID");
tableMapping.ColumnMappings.Add("AccPageID", "AccPageID");
tableMapping.ColumnMappings.Add("ModDateTime", "ModDateTime");
tableMapping.ColumnMappings.Add("Info", "Info");
this._adapter.TableMappings.Add(tableMapping);
this._adapter.DeleteCommand = new global::System.Data.OleDb.OleDbCommand();
this._adapter.DeleteCommand.Connection = this.Connection;
this._adapter.DeleteCommand.CommandText = "DELETE FROM RO000002\r\nWHERE (RecID = ?)";
this._adapter.DeleteCommand.CommandType = global::System.Data.CommandType.Text;
this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.OleDb.OleDbParameter("RecID", global::System.Data.OleDb.OleDbType.WChar, 8, global::System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "RecID", global::System.Data.DataRowVersion.Original, false, null));
this._adapter.InsertCommand = new global::System.Data.OleDb.OleDbCommand();
this._adapter.InsertCommand.Connection = this.Connection;
this._adapter.InsertCommand.CommandText = "INSERT INTO `RO000002` (`RecID`, `RecType`, `ParentID`, `AccPageID`, `ModDateTime" +
"`, `Info`) VALUES (?, ?, ?, ?, ?, ?)";
this._adapter.InsertCommand.CommandType = global::System.Data.CommandType.Text;
this._adapter.InsertCommand.Parameters.Add(new global::System.Data.OleDb.OleDbParameter("RecID", global::System.Data.OleDb.OleDbType.WChar, 0, global::System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "RecID", global::System.Data.DataRowVersion.Current, false, null));
this._adapter.InsertCommand.Parameters.Add(new global::System.Data.OleDb.OleDbParameter("RecType", global::System.Data.OleDb.OleDbType.Integer, 0, global::System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "RecType", global::System.Data.DataRowVersion.Current, false, null));
this._adapter.InsertCommand.Parameters.Add(new global::System.Data.OleDb.OleDbParameter("ParentID", global::System.Data.OleDb.OleDbType.WChar, 0, global::System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "ParentID", global::System.Data.DataRowVersion.Current, false, null));
this._adapter.InsertCommand.Parameters.Add(new global::System.Data.OleDb.OleDbParameter("AccPageID", global::System.Data.OleDb.OleDbType.WChar, 0, global::System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "AccPageID", global::System.Data.DataRowVersion.Current, false, null));
this._adapter.InsertCommand.Parameters.Add(new global::System.Data.OleDb.OleDbParameter("ModDateTime", global::System.Data.OleDb.OleDbType.WChar, 0, global::System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "ModDateTime", global::System.Data.DataRowVersion.Current, false, null));
this._adapter.InsertCommand.Parameters.Add(new global::System.Data.OleDb.OleDbParameter("Info", global::System.Data.OleDb.OleDbType.LongVarWChar, 0, global::System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "Info", global::System.Data.DataRowVersion.Current, false, null));
this._adapter.UpdateCommand = new global::System.Data.OleDb.OleDbCommand();
this._adapter.UpdateCommand.Connection = this.Connection;
this._adapter.UpdateCommand.CommandText = "UPDATE RO000002\r\nSET RecType = ?, ParentID = ?, AccPageID = " +
"?, ModDateTime = ?, Info = ?\r\nWHERE (RecID = ?)";
this._adapter.UpdateCommand.CommandType = global::System.Data.CommandType.Text;
this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.OleDb.OleDbParameter("RecType", global::System.Data.OleDb.OleDbType.Integer, 0, global::System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "RecType", global::System.Data.DataRowVersion.Current, false, null));
this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.OleDb.OleDbParameter("ParentID", global::System.Data.OleDb.OleDbType.WChar, 8, global::System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "ParentID", global::System.Data.DataRowVersion.Current, false, null));
this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.OleDb.OleDbParameter("AccPageID", global::System.Data.OleDb.OleDbType.WChar, 32, global::System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "AccPageID", global::System.Data.DataRowVersion.Current, false, null));
this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.OleDb.OleDbParameter("ModDateTime", global::System.Data.OleDb.OleDbType.WChar, 14, global::System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "ModDateTime", global::System.Data.DataRowVersion.Current, false, null));
this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.OleDb.OleDbParameter("Info", global::System.Data.OleDb.OleDbType.WChar, 1024, global::System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "Info", global::System.Data.DataRowVersion.Current, false, null));
this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.OleDb.OleDbParameter("Original_RecID", global::System.Data.OleDb.OleDbType.WChar, 8, global::System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "RecID", global::System.Data.DataRowVersion.Original, 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.ROMasterConnectionString;
}
[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 RecID, RecType, ParentID, AccPageID, ModDateTime, Info\r\nFROM " +
" RO000002\r\nORDER BY RecID";
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(ROMasterDataSet.RO000002DataTable 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 ROMasterDataSet.RO000002DataTable GetData() {
this.Adapter.SelectCommand = this.CommandCollection[0];
ROMasterDataSet.RO000002DataTable dataTable = new ROMasterDataSet.RO000002DataTable();
this.Adapter.Fill(dataTable);
return dataTable;
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
public virtual int Update(ROMasterDataSet.RO000002DataTable dataTable) {
return this.Adapter.Update(dataTable);
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
public virtual int Update(ROMasterDataSet dataSet) {
return this.Adapter.Update(dataSet, "RO000002");
}
[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.Delete, true)]
public virtual int Delete(string RecID) {
if ((RecID == null)) {
this.Adapter.DeleteCommand.Parameters[0].Value = global::System.DBNull.Value;
}
else {
this.Adapter.DeleteCommand.Parameters[0].Value = ((string)(RecID));
}
global::System.Data.ConnectionState previousConnectionState = this.Adapter.DeleteCommand.Connection.State;
if (((this.Adapter.DeleteCommand.Connection.State & global::System.Data.ConnectionState.Open)
!= global::System.Data.ConnectionState.Open)) {
this.Adapter.DeleteCommand.Connection.Open();
}
try {
int returnValue = this.Adapter.DeleteCommand.ExecuteNonQuery();
return returnValue;
}
finally {
if ((previousConnectionState == global::System.Data.ConnectionState.Closed)) {
this.Adapter.DeleteCommand.Connection.Close();
}
}
}
[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 RecID, global::System.Nullable<int> RecType, string ParentID, string AccPageID, string ModDateTime, string Info) {
if ((RecID == null)) {
this.Adapter.InsertCommand.Parameters[0].Value = global::System.DBNull.Value;
}
else {
this.Adapter.InsertCommand.Parameters[0].Value = ((string)(RecID));
}
if ((RecType.HasValue == true)) {
this.Adapter.InsertCommand.Parameters[1].Value = ((int)(RecType.Value));
}
else {
this.Adapter.InsertCommand.Parameters[1].Value = global::System.DBNull.Value;
}
if ((ParentID == null)) {
this.Adapter.InsertCommand.Parameters[2].Value = global::System.DBNull.Value;
}
else {
this.Adapter.InsertCommand.Parameters[2].Value = ((string)(ParentID));
}
if ((AccPageID == null)) {
this.Adapter.InsertCommand.Parameters[3].Value = global::System.DBNull.Value;
}
else {
this.Adapter.InsertCommand.Parameters[3].Value = ((string)(AccPageID));
}
if ((ModDateTime == null)) {
this.Adapter.InsertCommand.Parameters[4].Value = global::System.DBNull.Value;
}
else {
this.Adapter.InsertCommand.Parameters[4].Value = ((string)(ModDateTime));
}
if ((Info == null)) {
this.Adapter.InsertCommand.Parameters[5].Value = global::System.DBNull.Value;
}
else {
this.Adapter.InsertCommand.Parameters[5].Value = ((string)(Info));
}
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();
}
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
[global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Update, true)]
public virtual int Update(global::System.Nullable<int> RecType, string ParentID, string AccPageID, string ModDateTime, string Info, string Original_RecID) {
if ((RecType.HasValue == true)) {
this.Adapter.UpdateCommand.Parameters[0].Value = ((int)(RecType.Value));
}
else {
this.Adapter.UpdateCommand.Parameters[0].Value = global::System.DBNull.Value;
}
if ((ParentID == null)) {
this.Adapter.UpdateCommand.Parameters[1].Value = global::System.DBNull.Value;
}
else {
this.Adapter.UpdateCommand.Parameters[1].Value = ((string)(ParentID));
}
if ((AccPageID == null)) {
this.Adapter.UpdateCommand.Parameters[2].Value = global::System.DBNull.Value;
}
else {
this.Adapter.UpdateCommand.Parameters[2].Value = ((string)(AccPageID));
}
if ((ModDateTime == null)) {
this.Adapter.UpdateCommand.Parameters[3].Value = global::System.DBNull.Value;
}
else {
this.Adapter.UpdateCommand.Parameters[3].Value = ((string)(ModDateTime));
}
if ((Info == null)) {
this.Adapter.UpdateCommand.Parameters[4].Value = global::System.DBNull.Value;
}
else {
this.Adapter.UpdateCommand.Parameters[4].Value = ((string)(Info));
}
if ((Original_RecID == null)) {
this.Adapter.UpdateCommand.Parameters[5].Value = global::System.DBNull.Value;
}
else {
this.Adapter.UpdateCommand.Parameters[5].Value = ((string)(Original_RecID));
}
global::System.Data.ConnectionState previousConnectionState = this.Adapter.UpdateCommand.Connection.State;
if (((this.Adapter.UpdateCommand.Connection.State & global::System.Data.ConnectionState.Open)
!= global::System.Data.ConnectionState.Open)) {
this.Adapter.UpdateCommand.Connection.Open();
}
try {
int returnValue = this.Adapter.UpdateCommand.ExecuteNonQuery();
return returnValue;
}
finally {
if ((previousConnectionState == global::System.Data.ConnectionState.Closed)) {
this.Adapter.UpdateCommand.Connection.Close();
}
}
}
}
/// <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 RO000003TableAdapter : 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 RO000003TableAdapter() {
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 = "RO000003";
tableMapping.ColumnMappings.Add("RecID", "RecID");
tableMapping.ColumnMappings.Add("RecType", "RecType");
tableMapping.ColumnMappings.Add("ParentID", "ParentID");
tableMapping.ColumnMappings.Add("AccPageID", "AccPageID");
tableMapping.ColumnMappings.Add("ModDateTime", "ModDateTime");
tableMapping.ColumnMappings.Add("Info", "Info");
this._adapter.TableMappings.Add(tableMapping);
this._adapter.DeleteCommand = new global::System.Data.OleDb.OleDbCommand();
this._adapter.DeleteCommand.Connection = this.Connection;
this._adapter.DeleteCommand.CommandText = "DELETE FROM RO000003\r\nWHERE (RecID = ?)";
this._adapter.DeleteCommand.CommandType = global::System.Data.CommandType.Text;
this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.OleDb.OleDbParameter("RecID", global::System.Data.OleDb.OleDbType.WChar, 8, global::System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "RecID", global::System.Data.DataRowVersion.Original, false, null));
this._adapter.InsertCommand = new global::System.Data.OleDb.OleDbCommand();
this._adapter.InsertCommand.Connection = this.Connection;
this._adapter.InsertCommand.CommandText = "INSERT INTO `RO000003` (`RecID`, `RecType`, `ParentID`, `AccPageID`, `ModDateTime" +
"`, `Info`) VALUES (?, ?, ?, ?, ?, ?)";
this._adapter.InsertCommand.CommandType = global::System.Data.CommandType.Text;
this._adapter.InsertCommand.Parameters.Add(new global::System.Data.OleDb.OleDbParameter("RecID", global::System.Data.OleDb.OleDbType.WChar, 0, global::System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "RecID", global::System.Data.DataRowVersion.Current, false, null));
this._adapter.InsertCommand.Parameters.Add(new global::System.Data.OleDb.OleDbParameter("RecType", global::System.Data.OleDb.OleDbType.Integer, 0, global::System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "RecType", global::System.Data.DataRowVersion.Current, false, null));
this._adapter.InsertCommand.Parameters.Add(new global::System.Data.OleDb.OleDbParameter("ParentID", global::System.Data.OleDb.OleDbType.WChar, 0, global::System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "ParentID", global::System.Data.DataRowVersion.Current, false, null));
this._adapter.InsertCommand.Parameters.Add(new global::System.Data.OleDb.OleDbParameter("AccPageID", global::System.Data.OleDb.OleDbType.WChar, 0, global::System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "AccPageID", global::System.Data.DataRowVersion.Current, false, null));
this._adapter.InsertCommand.Parameters.Add(new global::System.Data.OleDb.OleDbParameter("ModDateTime", global::System.Data.OleDb.OleDbType.WChar, 0, global::System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "ModDateTime", global::System.Data.DataRowVersion.Current, false, null));
this._adapter.InsertCommand.Parameters.Add(new global::System.Data.OleDb.OleDbParameter("Info", global::System.Data.OleDb.OleDbType.LongVarWChar, 0, global::System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "Info", global::System.Data.DataRowVersion.Current, false, null));
this._adapter.UpdateCommand = new global::System.Data.OleDb.OleDbCommand();
this._adapter.UpdateCommand.Connection = this.Connection;
this._adapter.UpdateCommand.CommandText = @"UPDATE `RO000003` SET `RecID` = ?, `RecType` = ?, `ParentID` = ?, `AccPageID` = ?, `ModDateTime` = ?, `Info` = ? WHERE ((`RecID` = ?) AND ((? = 1 AND `RecType` IS NULL) OR (`RecType` = ?)) AND ((? = 1 AND `ParentID` IS NULL) OR (`ParentID` = ?)) AND ((? = 1 AND `AccPageID` IS NULL) OR (`AccPageID` = ?)) AND ((? = 1 AND `ModDateTime` IS NULL) OR (`ModDateTime` = ?)))";
this._adapter.UpdateCommand.CommandType = global::System.Data.CommandType.Text;
this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.OleDb.OleDbParameter("RecID", global::System.Data.OleDb.OleDbType.WChar, 0, global::System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "RecID", global::System.Data.DataRowVersion.Current, false, null));
this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.OleDb.OleDbParameter("RecType", global::System.Data.OleDb.OleDbType.Integer, 0, global::System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "RecType", global::System.Data.DataRowVersion.Current, false, null));
this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.OleDb.OleDbParameter("ParentID", global::System.Data.OleDb.OleDbType.WChar, 0, global::System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "ParentID", global::System.Data.DataRowVersion.Current, false, null));
this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.OleDb.OleDbParameter("AccPageID", global::System.Data.OleDb.OleDbType.WChar, 0, global::System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "AccPageID", global::System.Data.DataRowVersion.Current, false, null));
this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.OleDb.OleDbParameter("ModDateTime", global::System.Data.OleDb.OleDbType.WChar, 0, global::System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "ModDateTime", global::System.Data.DataRowVersion.Current, false, null));
this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.OleDb.OleDbParameter("Info", global::System.Data.OleDb.OleDbType.LongVarWChar, 0, global::System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "Info", global::System.Data.DataRowVersion.Current, false, null));
this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.OleDb.OleDbParameter("Original_RecID", global::System.Data.OleDb.OleDbType.WChar, 0, global::System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "RecID", global::System.Data.DataRowVersion.Original, false, null));
this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.OleDb.OleDbParameter("IsNull_RecType", global::System.Data.OleDb.OleDbType.Integer, 0, global::System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "RecType", global::System.Data.DataRowVersion.Original, true, null));
this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.OleDb.OleDbParameter("Original_RecType", global::System.Data.OleDb.OleDbType.Integer, 0, global::System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "RecType", global::System.Data.DataRowVersion.Original, false, null));
this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.OleDb.OleDbParameter("IsNull_ParentID", global::System.Data.OleDb.OleDbType.Integer, 0, global::System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "ParentID", global::System.Data.DataRowVersion.Original, true, null));
this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.OleDb.OleDbParameter("Original_ParentID", global::System.Data.OleDb.OleDbType.WChar, 0, global::System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "ParentID", global::System.Data.DataRowVersion.Original, false, null));
this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.OleDb.OleDbParameter("IsNull_AccPageID", global::System.Data.OleDb.OleDbType.Integer, 0, global::System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "AccPageID", global::System.Data.DataRowVersion.Original, true, null));
this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.OleDb.OleDbParameter("Original_AccPageID", global::System.Data.OleDb.OleDbType.WChar, 0, global::System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "AccPageID", global::System.Data.DataRowVersion.Original, false, null));
this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.OleDb.OleDbParameter("IsNull_ModDateTime", global::System.Data.OleDb.OleDbType.Integer, 0, global::System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "ModDateTime", global::System.Data.DataRowVersion.Original, true, null));
this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.OleDb.OleDbParameter("Original_ModDateTime", global::System.Data.OleDb.OleDbType.WChar, 0, global::System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "ModDateTime", global::System.Data.DataRowVersion.Original, 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.ROMasterConnectionString;
}
[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 RecID, RecType, ParentID, AccPageID, ModDateTime, Info\r\nFROM " +
" RO000003\r\nORDER BY RecID";
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(ROMasterDataSet.RO000003DataTable 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 ROMasterDataSet.RO000003DataTable GetData() {
this.Adapter.SelectCommand = this.CommandCollection[0];
ROMasterDataSet.RO000003DataTable dataTable = new ROMasterDataSet.RO000003DataTable();
this.Adapter.Fill(dataTable);
return dataTable;
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
public virtual int Update(ROMasterDataSet.RO000003DataTable dataTable) {
return this.Adapter.Update(dataTable);
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
public virtual int Update(ROMasterDataSet dataSet) {
return this.Adapter.Update(dataSet, "RO000003");
}
[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.Delete, true)]
public virtual int Delete(string RecID) {
if ((RecID == null)) {
this.Adapter.DeleteCommand.Parameters[0].Value = global::System.DBNull.Value;
}
else {
this.Adapter.DeleteCommand.Parameters[0].Value = ((string)(RecID));
}
global::System.Data.ConnectionState previousConnectionState = this.Adapter.DeleteCommand.Connection.State;
if (((this.Adapter.DeleteCommand.Connection.State & global::System.Data.ConnectionState.Open)
!= global::System.Data.ConnectionState.Open)) {
this.Adapter.DeleteCommand.Connection.Open();
}
try {
int returnValue = this.Adapter.DeleteCommand.ExecuteNonQuery();
return returnValue;
}
finally {
if ((previousConnectionState == global::System.Data.ConnectionState.Closed)) {
this.Adapter.DeleteCommand.Connection.Close();
}
}
}
[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 RecID, global::System.Nullable<int> RecType, string ParentID, string AccPageID, string ModDateTime, string Info) {
if ((RecID == null)) {
this.Adapter.InsertCommand.Parameters[0].Value = global::System.DBNull.Value;
}
else {
this.Adapter.InsertCommand.Parameters[0].Value = ((string)(RecID));
}
if ((RecType.HasValue == true)) {
this.Adapter.InsertCommand.Parameters[1].Value = ((int)(RecType.Value));
}
else {
this.Adapter.InsertCommand.Parameters[1].Value = global::System.DBNull.Value;
}
if ((ParentID == null)) {
this.Adapter.InsertCommand.Parameters[2].Value = global::System.DBNull.Value;
}
else {
this.Adapter.InsertCommand.Parameters[2].Value = ((string)(ParentID));
}
if ((AccPageID == null)) {
this.Adapter.InsertCommand.Parameters[3].Value = global::System.DBNull.Value;
}
else {
this.Adapter.InsertCommand.Parameters[3].Value = ((string)(AccPageID));
}
if ((ModDateTime == null)) {
this.Adapter.InsertCommand.Parameters[4].Value = global::System.DBNull.Value;
}
else {
this.Adapter.InsertCommand.Parameters[4].Value = ((string)(ModDateTime));
}
if ((Info == null)) {
this.Adapter.InsertCommand.Parameters[5].Value = global::System.DBNull.Value;
}
else {
this.Adapter.InsertCommand.Parameters[5].Value = ((string)(Info));
}
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();
}
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
[global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Update, true)]
public virtual int Update(string RecID, global::System.Nullable<int> RecType, string ParentID, string AccPageID, string ModDateTime, string Info, string Original_RecID, global::System.Nullable<int> Original_RecType, string Original_ParentID, string Original_AccPageID, string Original_ModDateTime) {
if ((RecID == null)) {
this.Adapter.UpdateCommand.Parameters[0].Value = global::System.DBNull.Value;
}
else {
this.Adapter.UpdateCommand.Parameters[0].Value = ((string)(RecID));
}
if ((RecType.HasValue == true)) {
this.Adapter.UpdateCommand.Parameters[1].Value = ((int)(RecType.Value));
}
else {
this.Adapter.UpdateCommand.Parameters[1].Value = global::System.DBNull.Value;
}
if ((ParentID == null)) {
this.Adapter.UpdateCommand.Parameters[2].Value = global::System.DBNull.Value;
}
else {
this.Adapter.UpdateCommand.Parameters[2].Value = ((string)(ParentID));
}
if ((AccPageID == null)) {
this.Adapter.UpdateCommand.Parameters[3].Value = global::System.DBNull.Value;
}
else {
this.Adapter.UpdateCommand.Parameters[3].Value = ((string)(AccPageID));
}
if ((ModDateTime == null)) {
this.Adapter.UpdateCommand.Parameters[4].Value = global::System.DBNull.Value;
}
else {
this.Adapter.UpdateCommand.Parameters[4].Value = ((string)(ModDateTime));
}
if ((Info == null)) {
this.Adapter.UpdateCommand.Parameters[5].Value = global::System.DBNull.Value;
}
else {
this.Adapter.UpdateCommand.Parameters[5].Value = ((string)(Info));
}
if ((Original_RecID == null)) {
this.Adapter.UpdateCommand.Parameters[6].Value = global::System.DBNull.Value;
}
else {
this.Adapter.UpdateCommand.Parameters[6].Value = ((string)(Original_RecID));
}
if ((Original_RecType.HasValue == true)) {
this.Adapter.UpdateCommand.Parameters[7].Value = ((object)(0));
this.Adapter.UpdateCommand.Parameters[8].Value = ((int)(Original_RecType.Value));
}
else {
this.Adapter.UpdateCommand.Parameters[7].Value = ((object)(1));
this.Adapter.UpdateCommand.Parameters[8].Value = global::System.DBNull.Value;
}
if ((Original_ParentID == null)) {
this.Adapter.UpdateCommand.Parameters[9].Value = ((object)(1));
this.Adapter.UpdateCommand.Parameters[10].Value = global::System.DBNull.Value;
}
else {
this.Adapter.UpdateCommand.Parameters[9].Value = ((object)(0));
this.Adapter.UpdateCommand.Parameters[10].Value = ((string)(Original_ParentID));
}
if ((Original_AccPageID == null)) {
this.Adapter.UpdateCommand.Parameters[11].Value = ((object)(1));
this.Adapter.UpdateCommand.Parameters[12].Value = global::System.DBNull.Value;
}
else {
this.Adapter.UpdateCommand.Parameters[11].Value = ((object)(0));
this.Adapter.UpdateCommand.Parameters[12].Value = ((string)(Original_AccPageID));
}
if ((Original_ModDateTime == null)) {
this.Adapter.UpdateCommand.Parameters[13].Value = ((object)(1));
this.Adapter.UpdateCommand.Parameters[14].Value = global::System.DBNull.Value;
}
else {
this.Adapter.UpdateCommand.Parameters[13].Value = ((object)(0));
this.Adapter.UpdateCommand.Parameters[14].Value = ((string)(Original_ModDateTime));
}
global::System.Data.ConnectionState previousConnectionState = this.Adapter.UpdateCommand.Connection.State;
if (((this.Adapter.UpdateCommand.Connection.State & global::System.Data.ConnectionState.Open)
!= global::System.Data.ConnectionState.Open)) {
this.Adapter.UpdateCommand.Connection.Open();
}
try {
int returnValue = this.Adapter.UpdateCommand.ExecuteNonQuery();
return returnValue;
}
finally {
if ((previousConnectionState == global::System.Data.ConnectionState.Closed)) {
this.Adapter.UpdateCommand.Connection.Close();
}
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
[global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Update, true)]
public virtual int Update(global::System.Nullable<int> RecType, string ParentID, string AccPageID, string ModDateTime, string Info, string Original_RecID, global::System.Nullable<int> Original_RecType, string Original_ParentID, string Original_AccPageID, string Original_ModDateTime) {
return this.Update(Original_RecID, RecType, ParentID, AccPageID, ModDateTime, Info, Original_RecID, Original_RecType, Original_ParentID, Original_AccPageID, Original_ModDateTime);
}
}
/// <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 RO000004TableAdapter : 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 RO000004TableAdapter() {
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 = "RO000004";
tableMapping.ColumnMappings.Add("RecID", "RecID");
tableMapping.ColumnMappings.Add("RecType", "RecType");
tableMapping.ColumnMappings.Add("ParentID", "ParentID");
tableMapping.ColumnMappings.Add("AccPageID", "AccPageID");
tableMapping.ColumnMappings.Add("ModDateTime", "ModDateTime");
tableMapping.ColumnMappings.Add("Info", "Info");
this._adapter.TableMappings.Add(tableMapping);
this._adapter.DeleteCommand = new global::System.Data.OleDb.OleDbCommand();
this._adapter.DeleteCommand.Connection = this.Connection;
this._adapter.DeleteCommand.CommandText = "DELETE FROM RO000004\r\nWHERE (RecID = ?)";
this._adapter.DeleteCommand.CommandType = global::System.Data.CommandType.Text;
this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.OleDb.OleDbParameter("RecID", global::System.Data.OleDb.OleDbType.WChar, 8, global::System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "RecID", global::System.Data.DataRowVersion.Original, false, null));
this._adapter.InsertCommand = new global::System.Data.OleDb.OleDbCommand();
this._adapter.InsertCommand.Connection = this.Connection;
this._adapter.InsertCommand.CommandText = "INSERT INTO `RO000004` (`RecID`, `RecType`, `ParentID`, `AccPageID`, `ModDateTime" +
"`, `Info`) VALUES (?, ?, ?, ?, ?, ?)";
this._adapter.InsertCommand.CommandType = global::System.Data.CommandType.Text;
this._adapter.InsertCommand.Parameters.Add(new global::System.Data.OleDb.OleDbParameter("RecID", global::System.Data.OleDb.OleDbType.WChar, 0, global::System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "RecID", global::System.Data.DataRowVersion.Current, false, null));
this._adapter.InsertCommand.Parameters.Add(new global::System.Data.OleDb.OleDbParameter("RecType", global::System.Data.OleDb.OleDbType.Integer, 0, global::System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "RecType", global::System.Data.DataRowVersion.Current, false, null));
this._adapter.InsertCommand.Parameters.Add(new global::System.Data.OleDb.OleDbParameter("ParentID", global::System.Data.OleDb.OleDbType.WChar, 0, global::System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "ParentID", global::System.Data.DataRowVersion.Current, false, null));
this._adapter.InsertCommand.Parameters.Add(new global::System.Data.OleDb.OleDbParameter("AccPageID", global::System.Data.OleDb.OleDbType.WChar, 0, global::System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "AccPageID", global::System.Data.DataRowVersion.Current, false, null));
this._adapter.InsertCommand.Parameters.Add(new global::System.Data.OleDb.OleDbParameter("ModDateTime", global::System.Data.OleDb.OleDbType.WChar, 0, global::System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "ModDateTime", global::System.Data.DataRowVersion.Current, false, null));
this._adapter.InsertCommand.Parameters.Add(new global::System.Data.OleDb.OleDbParameter("Info", global::System.Data.OleDb.OleDbType.LongVarWChar, 0, global::System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "Info", global::System.Data.DataRowVersion.Current, false, null));
this._adapter.UpdateCommand = new global::System.Data.OleDb.OleDbCommand();
this._adapter.UpdateCommand.Connection = this.Connection;
this._adapter.UpdateCommand.CommandText = @"UPDATE `RO000004` SET `RecID` = ?, `RecType` = ?, `ParentID` = ?, `AccPageID` = ?, `ModDateTime` = ?, `Info` = ? WHERE ((`RecID` = ?) AND ((? = 1 AND `RecType` IS NULL) OR (`RecType` = ?)) AND ((? = 1 AND `ParentID` IS NULL) OR (`ParentID` = ?)) AND ((? = 1 AND `AccPageID` IS NULL) OR (`AccPageID` = ?)) AND ((? = 1 AND `ModDateTime` IS NULL) OR (`ModDateTime` = ?)))";
this._adapter.UpdateCommand.CommandType = global::System.Data.CommandType.Text;
this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.OleDb.OleDbParameter("RecID", global::System.Data.OleDb.OleDbType.WChar, 0, global::System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "RecID", global::System.Data.DataRowVersion.Current, false, null));
this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.OleDb.OleDbParameter("RecType", global::System.Data.OleDb.OleDbType.Integer, 0, global::System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "RecType", global::System.Data.DataRowVersion.Current, false, null));
this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.OleDb.OleDbParameter("ParentID", global::System.Data.OleDb.OleDbType.WChar, 0, global::System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "ParentID", global::System.Data.DataRowVersion.Current, false, null));
this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.OleDb.OleDbParameter("AccPageID", global::System.Data.OleDb.OleDbType.WChar, 0, global::System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "AccPageID", global::System.Data.DataRowVersion.Current, false, null));
this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.OleDb.OleDbParameter("ModDateTime", global::System.Data.OleDb.OleDbType.WChar, 0, global::System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "ModDateTime", global::System.Data.DataRowVersion.Current, false, null));
this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.OleDb.OleDbParameter("Info", global::System.Data.OleDb.OleDbType.LongVarWChar, 0, global::System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "Info", global::System.Data.DataRowVersion.Current, false, null));
this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.OleDb.OleDbParameter("Original_RecID", global::System.Data.OleDb.OleDbType.WChar, 0, global::System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "RecID", global::System.Data.DataRowVersion.Original, false, null));
this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.OleDb.OleDbParameter("IsNull_RecType", global::System.Data.OleDb.OleDbType.Integer, 0, global::System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "RecType", global::System.Data.DataRowVersion.Original, true, null));
this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.OleDb.OleDbParameter("Original_RecType", global::System.Data.OleDb.OleDbType.Integer, 0, global::System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "RecType", global::System.Data.DataRowVersion.Original, false, null));
this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.OleDb.OleDbParameter("IsNull_ParentID", global::System.Data.OleDb.OleDbType.Integer, 0, global::System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "ParentID", global::System.Data.DataRowVersion.Original, true, null));
this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.OleDb.OleDbParameter("Original_ParentID", global::System.Data.OleDb.OleDbType.WChar, 0, global::System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "ParentID", global::System.Data.DataRowVersion.Original, false, null));
this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.OleDb.OleDbParameter("IsNull_AccPageID", global::System.Data.OleDb.OleDbType.Integer, 0, global::System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "AccPageID", global::System.Data.DataRowVersion.Original, true, null));
this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.OleDb.OleDbParameter("Original_AccPageID", global::System.Data.OleDb.OleDbType.WChar, 0, global::System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "AccPageID", global::System.Data.DataRowVersion.Original, false, null));
this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.OleDb.OleDbParameter("IsNull_ModDateTime", global::System.Data.OleDb.OleDbType.Integer, 0, global::System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "ModDateTime", global::System.Data.DataRowVersion.Original, true, null));
this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.OleDb.OleDbParameter("Original_ModDateTime", global::System.Data.OleDb.OleDbType.WChar, 0, global::System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "ModDateTime", global::System.Data.DataRowVersion.Original, 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.ROMasterConnectionString;
}
[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 RecID, RecType, ParentID, AccPageID, ModDateTime, Info\r\nFROM " +
" RO000004\r\nORDER BY RecID";
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(ROMasterDataSet.RO000004DataTable 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 ROMasterDataSet.RO000004DataTable GetData() {
this.Adapter.SelectCommand = this.CommandCollection[0];
ROMasterDataSet.RO000004DataTable dataTable = new ROMasterDataSet.RO000004DataTable();
this.Adapter.Fill(dataTable);
return dataTable;
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
public virtual int Update(ROMasterDataSet.RO000004DataTable dataTable) {
return this.Adapter.Update(dataTable);
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
public virtual int Update(ROMasterDataSet dataSet) {
return this.Adapter.Update(dataSet, "RO000004");
}
[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.Delete, true)]
public virtual int Delete(string RecID) {
if ((RecID == null)) {
this.Adapter.DeleteCommand.Parameters[0].Value = global::System.DBNull.Value;
}
else {
this.Adapter.DeleteCommand.Parameters[0].Value = ((string)(RecID));
}
global::System.Data.ConnectionState previousConnectionState = this.Adapter.DeleteCommand.Connection.State;
if (((this.Adapter.DeleteCommand.Connection.State & global::System.Data.ConnectionState.Open)
!= global::System.Data.ConnectionState.Open)) {
this.Adapter.DeleteCommand.Connection.Open();
}
try {
int returnValue = this.Adapter.DeleteCommand.ExecuteNonQuery();
return returnValue;
}
finally {
if ((previousConnectionState == global::System.Data.ConnectionState.Closed)) {
this.Adapter.DeleteCommand.Connection.Close();
}
}
}
[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 RecID, global::System.Nullable<int> RecType, string ParentID, string AccPageID, string ModDateTime, string Info) {
if ((RecID == null)) {
this.Adapter.InsertCommand.Parameters[0].Value = global::System.DBNull.Value;
}
else {
this.Adapter.InsertCommand.Parameters[0].Value = ((string)(RecID));
}
if ((RecType.HasValue == true)) {
this.Adapter.InsertCommand.Parameters[1].Value = ((int)(RecType.Value));
}
else {
this.Adapter.InsertCommand.Parameters[1].Value = global::System.DBNull.Value;
}
if ((ParentID == null)) {
this.Adapter.InsertCommand.Parameters[2].Value = global::System.DBNull.Value;
}
else {
this.Adapter.InsertCommand.Parameters[2].Value = ((string)(ParentID));
}
if ((AccPageID == null)) {
this.Adapter.InsertCommand.Parameters[3].Value = global::System.DBNull.Value;
}
else {
this.Adapter.InsertCommand.Parameters[3].Value = ((string)(AccPageID));
}
if ((ModDateTime == null)) {
this.Adapter.InsertCommand.Parameters[4].Value = global::System.DBNull.Value;
}
else {
this.Adapter.InsertCommand.Parameters[4].Value = ((string)(ModDateTime));
}
if ((Info == null)) {
this.Adapter.InsertCommand.Parameters[5].Value = global::System.DBNull.Value;
}
else {
this.Adapter.InsertCommand.Parameters[5].Value = ((string)(Info));
}
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();
}
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
[global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Update, true)]
public virtual int Update(string RecID, global::System.Nullable<int> RecType, string ParentID, string AccPageID, string ModDateTime, string Info, string Original_RecID, global::System.Nullable<int> Original_RecType, string Original_ParentID, string Original_AccPageID, string Original_ModDateTime) {
if ((RecID == null)) {
this.Adapter.UpdateCommand.Parameters[0].Value = global::System.DBNull.Value;
}
else {
this.Adapter.UpdateCommand.Parameters[0].Value = ((string)(RecID));
}
if ((RecType.HasValue == true)) {
this.Adapter.UpdateCommand.Parameters[1].Value = ((int)(RecType.Value));
}
else {
this.Adapter.UpdateCommand.Parameters[1].Value = global::System.DBNull.Value;
}
if ((ParentID == null)) {
this.Adapter.UpdateCommand.Parameters[2].Value = global::System.DBNull.Value;
}
else {
this.Adapter.UpdateCommand.Parameters[2].Value = ((string)(ParentID));
}
if ((AccPageID == null)) {
this.Adapter.UpdateCommand.Parameters[3].Value = global::System.DBNull.Value;
}
else {
this.Adapter.UpdateCommand.Parameters[3].Value = ((string)(AccPageID));
}
if ((ModDateTime == null)) {
this.Adapter.UpdateCommand.Parameters[4].Value = global::System.DBNull.Value;
}
else {
this.Adapter.UpdateCommand.Parameters[4].Value = ((string)(ModDateTime));
}
if ((Info == null)) {
this.Adapter.UpdateCommand.Parameters[5].Value = global::System.DBNull.Value;
}
else {
this.Adapter.UpdateCommand.Parameters[5].Value = ((string)(Info));
}
if ((Original_RecID == null)) {
this.Adapter.UpdateCommand.Parameters[6].Value = global::System.DBNull.Value;
}
else {
this.Adapter.UpdateCommand.Parameters[6].Value = ((string)(Original_RecID));
}
if ((Original_RecType.HasValue == true)) {
this.Adapter.UpdateCommand.Parameters[7].Value = ((object)(0));
this.Adapter.UpdateCommand.Parameters[8].Value = ((int)(Original_RecType.Value));
}
else {
this.Adapter.UpdateCommand.Parameters[7].Value = ((object)(1));
this.Adapter.UpdateCommand.Parameters[8].Value = global::System.DBNull.Value;
}
if ((Original_ParentID == null)) {
this.Adapter.UpdateCommand.Parameters[9].Value = ((object)(1));
this.Adapter.UpdateCommand.Parameters[10].Value = global::System.DBNull.Value;
}
else {
this.Adapter.UpdateCommand.Parameters[9].Value = ((object)(0));
this.Adapter.UpdateCommand.Parameters[10].Value = ((string)(Original_ParentID));
}
if ((Original_AccPageID == null)) {
this.Adapter.UpdateCommand.Parameters[11].Value = ((object)(1));
this.Adapter.UpdateCommand.Parameters[12].Value = global::System.DBNull.Value;
}
else {
this.Adapter.UpdateCommand.Parameters[11].Value = ((object)(0));
this.Adapter.UpdateCommand.Parameters[12].Value = ((string)(Original_AccPageID));
}
if ((Original_ModDateTime == null)) {
this.Adapter.UpdateCommand.Parameters[13].Value = ((object)(1));
this.Adapter.UpdateCommand.Parameters[14].Value = global::System.DBNull.Value;
}
else {
this.Adapter.UpdateCommand.Parameters[13].Value = ((object)(0));
this.Adapter.UpdateCommand.Parameters[14].Value = ((string)(Original_ModDateTime));
}
global::System.Data.ConnectionState previousConnectionState = this.Adapter.UpdateCommand.Connection.State;
if (((this.Adapter.UpdateCommand.Connection.State & global::System.Data.ConnectionState.Open)
!= global::System.Data.ConnectionState.Open)) {
this.Adapter.UpdateCommand.Connection.Open();
}
try {
int returnValue = this.Adapter.UpdateCommand.ExecuteNonQuery();
return returnValue;
}
finally {
if ((previousConnectionState == global::System.Data.ConnectionState.Closed)) {
this.Adapter.UpdateCommand.Connection.Close();
}
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
[global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Update, true)]
public virtual int Update(global::System.Nullable<int> RecType, string ParentID, string AccPageID, string ModDateTime, string Info, string Original_RecID, global::System.Nullable<int> Original_RecType, string Original_ParentID, string Original_AccPageID, string Original_ModDateTime) {
return this.Update(Original_RecID, RecType, ParentID, AccPageID, ModDateTime, Info, Original_RecID, Original_RecType, Original_ParentID, Original_AccPageID, Original_ModDateTime);
}
}
/// <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 ROMASTERTableAdapter : 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 ROMASTERTableAdapter() {
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 = "ROMASTER";
tableMapping.ColumnMappings.Add("RecID", "RecID");
tableMapping.ColumnMappings.Add("RecType", "RecType");
tableMapping.ColumnMappings.Add("ParentID", "ParentID");
tableMapping.ColumnMappings.Add("AccPageID", "AccPageID");
tableMapping.ColumnMappings.Add("ModDateTime", "ModDateTime");
tableMapping.ColumnMappings.Add("Info", "Info");
this._adapter.TableMappings.Add(tableMapping);
this._adapter.DeleteCommand = new global::System.Data.OleDb.OleDbCommand();
this._adapter.DeleteCommand.Connection = this.Connection;
this._adapter.DeleteCommand.CommandText = @"DELETE FROM `ROMASTER` WHERE ((`RecID` = ?) AND ((? = 1 AND `RecType` IS NULL) OR (`RecType` = ?)) AND ((? = 1 AND `ParentID` IS NULL) OR (`ParentID` = ?)) AND ((? = 1 AND `AccPageID` IS NULL) OR (`AccPageID` = ?)) AND ((? = 1 AND `ModDateTime` IS NULL) OR (`ModDateTime` = ?)))";
this._adapter.DeleteCommand.CommandType = global::System.Data.CommandType.Text;
this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.OleDb.OleDbParameter("Original_RecID", global::System.Data.OleDb.OleDbType.WChar, 0, global::System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "RecID", global::System.Data.DataRowVersion.Original, false, null));
this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.OleDb.OleDbParameter("IsNull_RecType", global::System.Data.OleDb.OleDbType.Integer, 0, global::System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "RecType", global::System.Data.DataRowVersion.Original, true, null));
this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.OleDb.OleDbParameter("Original_RecType", global::System.Data.OleDb.OleDbType.Integer, 0, global::System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "RecType", global::System.Data.DataRowVersion.Original, false, null));
this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.OleDb.OleDbParameter("IsNull_ParentID", global::System.Data.OleDb.OleDbType.Integer, 0, global::System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "ParentID", global::System.Data.DataRowVersion.Original, true, null));
this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.OleDb.OleDbParameter("Original_ParentID", global::System.Data.OleDb.OleDbType.WChar, 0, global::System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "ParentID", global::System.Data.DataRowVersion.Original, false, null));
this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.OleDb.OleDbParameter("IsNull_AccPageID", global::System.Data.OleDb.OleDbType.Integer, 0, global::System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "AccPageID", global::System.Data.DataRowVersion.Original, true, null));
this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.OleDb.OleDbParameter("Original_AccPageID", global::System.Data.OleDb.OleDbType.WChar, 0, global::System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "AccPageID", global::System.Data.DataRowVersion.Original, false, null));
this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.OleDb.OleDbParameter("IsNull_ModDateTime", global::System.Data.OleDb.OleDbType.Integer, 0, global::System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "ModDateTime", global::System.Data.DataRowVersion.Original, true, null));
this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.OleDb.OleDbParameter("Original_ModDateTime", global::System.Data.OleDb.OleDbType.WChar, 0, global::System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "ModDateTime", global::System.Data.DataRowVersion.Original, false, null));
this._adapter.InsertCommand = new global::System.Data.OleDb.OleDbCommand();
this._adapter.InsertCommand.Connection = this.Connection;
this._adapter.InsertCommand.CommandText = "INSERT INTO `ROMASTER` (`RecID`, `RecType`, `ParentID`, `AccPageID`, `ModDateTime" +
"`, `Info`) VALUES (?, ?, ?, ?, ?, ?)";
this._adapter.InsertCommand.CommandType = global::System.Data.CommandType.Text;
this._adapter.InsertCommand.Parameters.Add(new global::System.Data.OleDb.OleDbParameter("RecID", global::System.Data.OleDb.OleDbType.WChar, 0, global::System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "RecID", global::System.Data.DataRowVersion.Current, false, null));
this._adapter.InsertCommand.Parameters.Add(new global::System.Data.OleDb.OleDbParameter("RecType", global::System.Data.OleDb.OleDbType.Integer, 0, global::System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "RecType", global::System.Data.DataRowVersion.Current, false, null));
this._adapter.InsertCommand.Parameters.Add(new global::System.Data.OleDb.OleDbParameter("ParentID", global::System.Data.OleDb.OleDbType.WChar, 0, global::System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "ParentID", global::System.Data.DataRowVersion.Current, false, null));
this._adapter.InsertCommand.Parameters.Add(new global::System.Data.OleDb.OleDbParameter("AccPageID", global::System.Data.OleDb.OleDbType.WChar, 0, global::System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "AccPageID", global::System.Data.DataRowVersion.Current, false, null));
this._adapter.InsertCommand.Parameters.Add(new global::System.Data.OleDb.OleDbParameter("ModDateTime", global::System.Data.OleDb.OleDbType.WChar, 0, global::System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "ModDateTime", global::System.Data.DataRowVersion.Current, false, null));
this._adapter.InsertCommand.Parameters.Add(new global::System.Data.OleDb.OleDbParameter("Info", global::System.Data.OleDb.OleDbType.LongVarWChar, 0, global::System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "Info", global::System.Data.DataRowVersion.Current, false, null));
this._adapter.UpdateCommand = new global::System.Data.OleDb.OleDbCommand();
this._adapter.UpdateCommand.Connection = this.Connection;
this._adapter.UpdateCommand.CommandText = @"UPDATE `ROMASTER` SET `RecID` = ?, `RecType` = ?, `ParentID` = ?, `AccPageID` = ?, `ModDateTime` = ?, `Info` = ? WHERE ((`RecID` = ?) AND ((? = 1 AND `RecType` IS NULL) OR (`RecType` = ?)) AND ((? = 1 AND `ParentID` IS NULL) OR (`ParentID` = ?)) AND ((? = 1 AND `AccPageID` IS NULL) OR (`AccPageID` = ?)) AND ((? = 1 AND `ModDateTime` IS NULL) OR (`ModDateTime` = ?)))";
this._adapter.UpdateCommand.CommandType = global::System.Data.CommandType.Text;
this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.OleDb.OleDbParameter("RecID", global::System.Data.OleDb.OleDbType.WChar, 0, global::System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "RecID", global::System.Data.DataRowVersion.Current, false, null));
this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.OleDb.OleDbParameter("RecType", global::System.Data.OleDb.OleDbType.Integer, 0, global::System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "RecType", global::System.Data.DataRowVersion.Current, false, null));
this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.OleDb.OleDbParameter("ParentID", global::System.Data.OleDb.OleDbType.WChar, 0, global::System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "ParentID", global::System.Data.DataRowVersion.Current, false, null));
this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.OleDb.OleDbParameter("AccPageID", global::System.Data.OleDb.OleDbType.WChar, 0, global::System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "AccPageID", global::System.Data.DataRowVersion.Current, false, null));
this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.OleDb.OleDbParameter("ModDateTime", global::System.Data.OleDb.OleDbType.WChar, 0, global::System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "ModDateTime", global::System.Data.DataRowVersion.Current, false, null));
this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.OleDb.OleDbParameter("Info", global::System.Data.OleDb.OleDbType.LongVarWChar, 0, global::System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "Info", global::System.Data.DataRowVersion.Current, false, null));
this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.OleDb.OleDbParameter("Original_RecID", global::System.Data.OleDb.OleDbType.WChar, 0, global::System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "RecID", global::System.Data.DataRowVersion.Original, false, null));
this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.OleDb.OleDbParameter("IsNull_RecType", global::System.Data.OleDb.OleDbType.Integer, 0, global::System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "RecType", global::System.Data.DataRowVersion.Original, true, null));
this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.OleDb.OleDbParameter("Original_RecType", global::System.Data.OleDb.OleDbType.Integer, 0, global::System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "RecType", global::System.Data.DataRowVersion.Original, false, null));
this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.OleDb.OleDbParameter("IsNull_ParentID", global::System.Data.OleDb.OleDbType.Integer, 0, global::System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "ParentID", global::System.Data.DataRowVersion.Original, true, null));
this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.OleDb.OleDbParameter("Original_ParentID", global::System.Data.OleDb.OleDbType.WChar, 0, global::System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "ParentID", global::System.Data.DataRowVersion.Original, false, null));
this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.OleDb.OleDbParameter("IsNull_AccPageID", global::System.Data.OleDb.OleDbType.Integer, 0, global::System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "AccPageID", global::System.Data.DataRowVersion.Original, true, null));
this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.OleDb.OleDbParameter("Original_AccPageID", global::System.Data.OleDb.OleDbType.WChar, 0, global::System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "AccPageID", global::System.Data.DataRowVersion.Original, false, null));
this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.OleDb.OleDbParameter("IsNull_ModDateTime", global::System.Data.OleDb.OleDbType.Integer, 0, global::System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "ModDateTime", global::System.Data.DataRowVersion.Original, true, null));
this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.OleDb.OleDbParameter("Original_ModDateTime", global::System.Data.OleDb.OleDbType.WChar, 0, global::System.Data.ParameterDirection.Input, ((byte)(0)), ((byte)(0)), "ModDateTime", global::System.Data.DataRowVersion.Original, 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.ROMasterConnectionString;
}
[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 RecID, RecType, ParentID, AccPageID, ModDateTime, Info FROM ROMASTER";
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(ROMasterDataSet.ROMASTERDataTable 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 ROMasterDataSet.ROMASTERDataTable GetData() {
this.Adapter.SelectCommand = this.CommandCollection[0];
ROMasterDataSet.ROMASTERDataTable dataTable = new ROMasterDataSet.ROMASTERDataTable();
this.Adapter.Fill(dataTable);
return dataTable;
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
public virtual int Update(ROMasterDataSet.ROMASTERDataTable dataTable) {
return this.Adapter.Update(dataTable);
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
public virtual int Update(ROMasterDataSet dataSet) {
return this.Adapter.Update(dataSet, "ROMASTER");
}
[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.Delete, true)]
public virtual int Delete(string Original_RecID, global::System.Nullable<int> Original_RecType, string Original_ParentID, string Original_AccPageID, string Original_ModDateTime) {
if ((Original_RecID == null)) {
this.Adapter.DeleteCommand.Parameters[0].Value = global::System.DBNull.Value;
}
else {
this.Adapter.DeleteCommand.Parameters[0].Value = ((string)(Original_RecID));
}
if ((Original_RecType.HasValue == true)) {
this.Adapter.DeleteCommand.Parameters[1].Value = ((object)(0));
this.Adapter.DeleteCommand.Parameters[2].Value = ((int)(Original_RecType.Value));
}
else {
this.Adapter.DeleteCommand.Parameters[1].Value = ((object)(1));
this.Adapter.DeleteCommand.Parameters[2].Value = global::System.DBNull.Value;
}
if ((Original_ParentID == null)) {
this.Adapter.DeleteCommand.Parameters[3].Value = ((object)(1));
this.Adapter.DeleteCommand.Parameters[4].Value = global::System.DBNull.Value;
}
else {
this.Adapter.DeleteCommand.Parameters[3].Value = ((object)(0));
this.Adapter.DeleteCommand.Parameters[4].Value = ((string)(Original_ParentID));
}
if ((Original_AccPageID == null)) {
this.Adapter.DeleteCommand.Parameters[5].Value = ((object)(1));
this.Adapter.DeleteCommand.Parameters[6].Value = global::System.DBNull.Value;
}
else {
this.Adapter.DeleteCommand.Parameters[5].Value = ((object)(0));
this.Adapter.DeleteCommand.Parameters[6].Value = ((string)(Original_AccPageID));
}
if ((Original_ModDateTime == null)) {
this.Adapter.DeleteCommand.Parameters[7].Value = ((object)(1));
this.Adapter.DeleteCommand.Parameters[8].Value = global::System.DBNull.Value;
}
else {
this.Adapter.DeleteCommand.Parameters[7].Value = ((object)(0));
this.Adapter.DeleteCommand.Parameters[8].Value = ((string)(Original_ModDateTime));
}
global::System.Data.ConnectionState previousConnectionState = this.Adapter.DeleteCommand.Connection.State;
if (((this.Adapter.DeleteCommand.Connection.State & global::System.Data.ConnectionState.Open)
!= global::System.Data.ConnectionState.Open)) {
this.Adapter.DeleteCommand.Connection.Open();
}
try {
int returnValue = this.Adapter.DeleteCommand.ExecuteNonQuery();
return returnValue;
}
finally {
if ((previousConnectionState == global::System.Data.ConnectionState.Closed)) {
this.Adapter.DeleteCommand.Connection.Close();
}
}
}
[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 RecID, global::System.Nullable<int> RecType, string ParentID, string AccPageID, string ModDateTime, string Info) {
if ((RecID == null)) {
this.Adapter.InsertCommand.Parameters[0].Value = global::System.DBNull.Value;
}
else {
this.Adapter.InsertCommand.Parameters[0].Value = ((string)(RecID));
}
if ((RecType.HasValue == true)) {
this.Adapter.InsertCommand.Parameters[1].Value = ((int)(RecType.Value));
}
else {
this.Adapter.InsertCommand.Parameters[1].Value = global::System.DBNull.Value;
}
if ((ParentID == null)) {
this.Adapter.InsertCommand.Parameters[2].Value = global::System.DBNull.Value;
}
else {
this.Adapter.InsertCommand.Parameters[2].Value = ((string)(ParentID));
}
if ((AccPageID == null)) {
this.Adapter.InsertCommand.Parameters[3].Value = global::System.DBNull.Value;
}
else {
this.Adapter.InsertCommand.Parameters[3].Value = ((string)(AccPageID));
}
if ((ModDateTime == null)) {
this.Adapter.InsertCommand.Parameters[4].Value = global::System.DBNull.Value;
}
else {
this.Adapter.InsertCommand.Parameters[4].Value = ((string)(ModDateTime));
}
if ((Info == null)) {
this.Adapter.InsertCommand.Parameters[5].Value = global::System.DBNull.Value;
}
else {
this.Adapter.InsertCommand.Parameters[5].Value = ((string)(Info));
}
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();
}
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
[global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Update, true)]
public virtual int Update(string RecID, global::System.Nullable<int> RecType, string ParentID, string AccPageID, string ModDateTime, string Info, string Original_RecID, global::System.Nullable<int> Original_RecType, string Original_ParentID, string Original_AccPageID, string Original_ModDateTime) {
if ((RecID == null)) {
this.Adapter.UpdateCommand.Parameters[0].Value = global::System.DBNull.Value;
}
else {
this.Adapter.UpdateCommand.Parameters[0].Value = ((string)(RecID));
}
if ((RecType.HasValue == true)) {
this.Adapter.UpdateCommand.Parameters[1].Value = ((int)(RecType.Value));
}
else {
this.Adapter.UpdateCommand.Parameters[1].Value = global::System.DBNull.Value;
}
if ((ParentID == null)) {
this.Adapter.UpdateCommand.Parameters[2].Value = global::System.DBNull.Value;
}
else {
this.Adapter.UpdateCommand.Parameters[2].Value = ((string)(ParentID));
}
if ((AccPageID == null)) {
this.Adapter.UpdateCommand.Parameters[3].Value = global::System.DBNull.Value;
}
else {
this.Adapter.UpdateCommand.Parameters[3].Value = ((string)(AccPageID));
}
if ((ModDateTime == null)) {
this.Adapter.UpdateCommand.Parameters[4].Value = global::System.DBNull.Value;
}
else {
this.Adapter.UpdateCommand.Parameters[4].Value = ((string)(ModDateTime));
}
if ((Info == null)) {
this.Adapter.UpdateCommand.Parameters[5].Value = global::System.DBNull.Value;
}
else {
this.Adapter.UpdateCommand.Parameters[5].Value = ((string)(Info));
}
if ((Original_RecID == null)) {
this.Adapter.UpdateCommand.Parameters[6].Value = global::System.DBNull.Value;
}
else {
this.Adapter.UpdateCommand.Parameters[6].Value = ((string)(Original_RecID));
}
if ((Original_RecType.HasValue == true)) {
this.Adapter.UpdateCommand.Parameters[7].Value = ((object)(0));
this.Adapter.UpdateCommand.Parameters[8].Value = ((int)(Original_RecType.Value));
}
else {
this.Adapter.UpdateCommand.Parameters[7].Value = ((object)(1));
this.Adapter.UpdateCommand.Parameters[8].Value = global::System.DBNull.Value;
}
if ((Original_ParentID == null)) {
this.Adapter.UpdateCommand.Parameters[9].Value = ((object)(1));
this.Adapter.UpdateCommand.Parameters[10].Value = global::System.DBNull.Value;
}
else {
this.Adapter.UpdateCommand.Parameters[9].Value = ((object)(0));
this.Adapter.UpdateCommand.Parameters[10].Value = ((string)(Original_ParentID));
}
if ((Original_AccPageID == null)) {
this.Adapter.UpdateCommand.Parameters[11].Value = ((object)(1));
this.Adapter.UpdateCommand.Parameters[12].Value = global::System.DBNull.Value;
}
else {
this.Adapter.UpdateCommand.Parameters[11].Value = ((object)(0));
this.Adapter.UpdateCommand.Parameters[12].Value = ((string)(Original_AccPageID));
}
if ((Original_ModDateTime == null)) {
this.Adapter.UpdateCommand.Parameters[13].Value = ((object)(1));
this.Adapter.UpdateCommand.Parameters[14].Value = global::System.DBNull.Value;
}
else {
this.Adapter.UpdateCommand.Parameters[13].Value = ((object)(0));
this.Adapter.UpdateCommand.Parameters[14].Value = ((string)(Original_ModDateTime));
}
global::System.Data.ConnectionState previousConnectionState = this.Adapter.UpdateCommand.Connection.State;
if (((this.Adapter.UpdateCommand.Connection.State & global::System.Data.ConnectionState.Open)
!= global::System.Data.ConnectionState.Open)) {
this.Adapter.UpdateCommand.Connection.Open();
}
try {
int returnValue = this.Adapter.UpdateCommand.ExecuteNonQuery();
return returnValue;
}
finally {
if ((previousConnectionState == global::System.Data.ConnectionState.Closed)) {
this.Adapter.UpdateCommand.Connection.Close();
}
}
}
[global::System.Diagnostics.DebuggerNonUserCodeAttribute()]
[global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")]
[global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Update, true)]
public virtual int Update(global::System.Nullable<int> RecType, string ParentID, string AccPageID, string ModDateTime, string Info, string Original_RecID, global::System.Nullable<int> Original_RecType, string Original_ParentID, string Original_AccPageID, string Original_ModDateTime) {
return this.Update(Original_RecID, RecType, ParentID, AccPageID, ModDateTime, Info, Original_RecID, Original_RecType, Original_ParentID, Original_AccPageID, Original_ModDateTime);
}
}
}
#pragma warning restore 1591
Reference in New Issue View Git Blame Copy Permalink