//------------------------------------------------------------------------------ // // This code was generated by a tool. // Runtime Version:4.0.30319.33440 // // Changes to this file may cause incorrect behavior and will be lost if // the code is regenerated. // //------------------------------------------------------------------------------ #pragma warning disable 1591 namespace Saving.Applications.divavg.ws_divsrv_req_methpay_ytk_ctrl { /// ///Represents a strongly typed in-memory cache of data. /// [global::System.Serializable()] [global::System.ComponentModel.DesignerCategoryAttribute("code")] [global::System.ComponentModel.ToolboxItem(true)] [global::System.Xml.Serialization.XmlSchemaProviderAttribute("GetTypedDataSetSchema")] [global::System.Xml.Serialization.XmlRootAttribute("DataSet1")] [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.DataSet")] public partial class DataSet1 : global::System.Data.DataSet { private DataTable1DataTable tableDataTable1; private YRDIVMASTERDataTable tableYRDIVMASTER; private DT_LOANDataTable tableDT_LOAN; private global::System.Data.SchemaSerializationMode _schemaSerializationMode = global::System.Data.SchemaSerializationMode.IncludeSchema; [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public DataSet1() { 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()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] protected DataSet1(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["DataTable1"] != null)) { base.Tables.Add(new DataTable1DataTable(ds.Tables["DataTable1"])); } if ((ds.Tables["YRDIVMASTER"] != null)) { base.Tables.Add(new YRDIVMASTERDataTable(ds.Tables["YRDIVMASTER"])); } if ((ds.Tables["DT_LOAN"] != null)) { base.Tables.Add(new DT_LOANDataTable(ds.Tables["DT_LOAN"])); } 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.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] [global::System.ComponentModel.Browsable(false)] [global::System.ComponentModel.DesignerSerializationVisibility(global::System.ComponentModel.DesignerSerializationVisibility.Content)] public DataTable1DataTable DataTable1 { get { return this.tableDataTable1; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] [global::System.ComponentModel.Browsable(false)] [global::System.ComponentModel.DesignerSerializationVisibility(global::System.ComponentModel.DesignerSerializationVisibility.Content)] public YRDIVMASTERDataTable YRDIVMASTER { get { return this.tableYRDIVMASTER; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] [global::System.ComponentModel.Browsable(false)] [global::System.ComponentModel.DesignerSerializationVisibility(global::System.ComponentModel.DesignerSerializationVisibility.Content)] public DT_LOANDataTable DT_LOAN { get { return this.tableDT_LOAN; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] [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.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] [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.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] [global::System.ComponentModel.DesignerSerializationVisibilityAttribute(global::System.ComponentModel.DesignerSerializationVisibility.Hidden)] public new global::System.Data.DataRelationCollection Relations { get { return base.Relations; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] protected override void InitializeDerivedDataSet() { this.BeginInit(); this.InitClass(); this.EndInit(); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public override global::System.Data.DataSet Clone() { DataSet1 cln = ((DataSet1)(base.Clone())); cln.InitVars(); cln.SchemaSerializationMode = this.SchemaSerializationMode; return cln; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] protected override bool ShouldSerializeTables() { return false; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] protected override bool ShouldSerializeRelations() { return false; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] 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["DataTable1"] != null)) { base.Tables.Add(new DataTable1DataTable(ds.Tables["DataTable1"])); } if ((ds.Tables["YRDIVMASTER"] != null)) { base.Tables.Add(new YRDIVMASTERDataTable(ds.Tables["YRDIVMASTER"])); } if ((ds.Tables["DT_LOAN"] != null)) { base.Tables.Add(new DT_LOANDataTable(ds.Tables["DT_LOAN"])); } 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()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] 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()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] internal void InitVars() { this.InitVars(true); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] internal void InitVars(bool initTable) { this.tableDataTable1 = ((DataTable1DataTable)(base.Tables["DataTable1"])); if ((initTable == true)) { if ((this.tableDataTable1 != null)) { this.tableDataTable1.InitVars(); } } this.tableYRDIVMASTER = ((YRDIVMASTERDataTable)(base.Tables["YRDIVMASTER"])); if ((initTable == true)) { if ((this.tableYRDIVMASTER != null)) { this.tableYRDIVMASTER.InitVars(); } } this.tableDT_LOAN = ((DT_LOANDataTable)(base.Tables["DT_LOAN"])); if ((initTable == true)) { if ((this.tableDT_LOAN != null)) { this.tableDT_LOAN.InitVars(); } } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] private void InitClass() { this.DataSetName = "DataSet1"; this.Prefix = ""; this.Namespace = "http://tempuri.org/DataSet1.xsd"; this.EnforceConstraints = true; this.SchemaSerializationMode = global::System.Data.SchemaSerializationMode.IncludeSchema; this.tableDataTable1 = new DataTable1DataTable(); base.Tables.Add(this.tableDataTable1); this.tableYRDIVMASTER = new YRDIVMASTERDataTable(); base.Tables.Add(this.tableYRDIVMASTER); this.tableDT_LOAN = new DT_LOANDataTable(); base.Tables.Add(this.tableDT_LOAN); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] private bool ShouldSerializeDataTable1() { return false; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] private bool ShouldSerializeYRDIVMASTER() { return false; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] private bool ShouldSerializeDT_LOAN() { return false; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] private void SchemaChanged(object sender, global::System.ComponentModel.CollectionChangeEventArgs e) { if ((e.Action == global::System.ComponentModel.CollectionChangeAction.Remove)) { this.InitVars(); } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedDataSetSchema(global::System.Xml.Schema.XmlSchemaSet xs) { DataSet1 ds = new DataSet1(); 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; } [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public delegate void DataTable1RowChangeEventHandler(object sender, DataTable1RowChangeEvent e); [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public delegate void YRDIVMASTERRowChangeEventHandler(object sender, YRDIVMASTERRowChangeEvent e); [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public delegate void DT_LOANRowChangeEventHandler(object sender, DT_LOANRowChangeEvent e); /// ///Represents the strongly named DataTable class. /// [global::System.Serializable()] [global::System.Xml.Serialization.XmlSchemaProviderAttribute("GetTypedTableSchema")] public partial class DataTable1DataTable : global::System.Data.TypedTableBase { private global::System.Data.DataColumn columnDIV_YEAR; private global::System.Data.DataColumn columnMEMBER_NO; private global::System.Data.DataColumn columnCOOP_ID; private global::System.Data.DataColumn columnAVG_BALAMT; private global::System.Data.DataColumn columnETC_AMT; private global::System.Data.DataColumn columnETC_BALAMT; private global::System.Data.DataColumn columnAVG_AMT; private global::System.Data.DataColumn columnITEM_BALAMT; private global::System.Data.DataColumn columnDIV_AMT; private global::System.Data.DataColumn columnDIV_BALAMT; private global::System.Data.DataColumn columnmkbuy_amt; private global::System.Data.DataColumn columnmkbuy_balamt; private global::System.Data.DataColumn columnmksale_amt; private global::System.Data.DataColumn columnmksale_balamt; private global::System.Data.DataColumn columnoil_amt; private global::System.Data.DataColumn columnoil_balamt; private global::System.Data.DataColumn columnpalm_amt; private global::System.Data.DataColumn columnpalm_balamt; private global::System.Data.DataColumn columndonate_amt; private global::System.Data.DataColumn columndonate_balamt; private global::System.Data.DataColumn columnshr_amt; private global::System.Data.DataColumn columnshr_balamt; private global::System.Data.DataColumn columnkathin_amt; private global::System.Data.DataColumn columnkathin_balamt; private global::System.Data.DataColumn columnint_amt; private global::System.Data.DataColumn columnint_balamt; private global::System.Data.DataColumn columntotal_amt; private global::System.Data.DataColumn columntotal_balamt; private global::System.Data.DataColumn columnbfint_arrear; private global::System.Data.DataColumn columntran_amt; private global::System.Data.DataColumn columnmini_amt; private global::System.Data.DataColumn columntranout_amt; private global::System.Data.DataColumn columndeptaccount_no; [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public DataTable1DataTable() { this.TableName = "DataTable1"; this.BeginInit(); this.InitClass(); this.EndInit(); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] internal DataTable1DataTable(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()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] protected DataTable1DataTable(global::System.Runtime.Serialization.SerializationInfo info, global::System.Runtime.Serialization.StreamingContext context) : base(info, context) { this.InitVars(); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public global::System.Data.DataColumn DIV_YEARColumn { get { return this.columnDIV_YEAR; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public global::System.Data.DataColumn MEMBER_NOColumn { get { return this.columnMEMBER_NO; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public global::System.Data.DataColumn COOP_IDColumn { get { return this.columnCOOP_ID; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public global::System.Data.DataColumn AVG_BALAMTColumn { get { return this.columnAVG_BALAMT; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public global::System.Data.DataColumn ETC_AMTColumn { get { return this.columnETC_AMT; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public global::System.Data.DataColumn ETC_BALAMTColumn { get { return this.columnETC_BALAMT; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public global::System.Data.DataColumn AVG_AMTColumn { get { return this.columnAVG_AMT; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public global::System.Data.DataColumn ITEM_BALAMTColumn { get { return this.columnITEM_BALAMT; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public global::System.Data.DataColumn DIV_AMTColumn { get { return this.columnDIV_AMT; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public global::System.Data.DataColumn DIV_BALAMTColumn { get { return this.columnDIV_BALAMT; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public global::System.Data.DataColumn mkbuy_amtColumn { get { return this.columnmkbuy_amt; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public global::System.Data.DataColumn mkbuy_balamtColumn { get { return this.columnmkbuy_balamt; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public global::System.Data.DataColumn mksale_amtColumn { get { return this.columnmksale_amt; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public global::System.Data.DataColumn mksale_balamtColumn { get { return this.columnmksale_balamt; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public global::System.Data.DataColumn oil_amtColumn { get { return this.columnoil_amt; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public global::System.Data.DataColumn oil_balamtColumn { get { return this.columnoil_balamt; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public global::System.Data.DataColumn palm_amtColumn { get { return this.columnpalm_amt; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public global::System.Data.DataColumn palm_balamtColumn { get { return this.columnpalm_balamt; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public global::System.Data.DataColumn donate_amtColumn { get { return this.columndonate_amt; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public global::System.Data.DataColumn donate_balamtColumn { get { return this.columndonate_balamt; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public global::System.Data.DataColumn shr_amtColumn { get { return this.columnshr_amt; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public global::System.Data.DataColumn shr_balamtColumn { get { return this.columnshr_balamt; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public global::System.Data.DataColumn kathin_amtColumn { get { return this.columnkathin_amt; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public global::System.Data.DataColumn kathin_balamtColumn { get { return this.columnkathin_balamt; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public global::System.Data.DataColumn int_amtColumn { get { return this.columnint_amt; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public global::System.Data.DataColumn int_balamtColumn { get { return this.columnint_balamt; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public global::System.Data.DataColumn total_amtColumn { get { return this.columntotal_amt; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public global::System.Data.DataColumn total_balamtColumn { get { return this.columntotal_balamt; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public global::System.Data.DataColumn bfint_arrearColumn { get { return this.columnbfint_arrear; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public global::System.Data.DataColumn tran_amtColumn { get { return this.columntran_amt; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public global::System.Data.DataColumn mini_amtColumn { get { return this.columnmini_amt; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public global::System.Data.DataColumn tranout_amtColumn { get { return this.columntranout_amt; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public global::System.Data.DataColumn deptaccount_noColumn { get { return this.columndeptaccount_no; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] [global::System.ComponentModel.Browsable(false)] public int Count { get { return this.Rows.Count; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public DataTable1Row this[int index] { get { return ((DataTable1Row)(this.Rows[index])); } } [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public event DataTable1RowChangeEventHandler DataTable1RowChanging; [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public event DataTable1RowChangeEventHandler DataTable1RowChanged; [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public event DataTable1RowChangeEventHandler DataTable1RowDeleting; [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public event DataTable1RowChangeEventHandler DataTable1RowDeleted; [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public void AddDataTable1Row(DataTable1Row row) { this.Rows.Add(row); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public DataTable1Row AddDataTable1Row( string DIV_YEAR, string MEMBER_NO, string COOP_ID, decimal AVG_BALAMT, decimal ETC_AMT, decimal ETC_BALAMT, decimal AVG_AMT, decimal ITEM_BALAMT, decimal DIV_AMT, decimal DIV_BALAMT, decimal mkbuy_amt, decimal mkbuy_balamt, decimal mksale_amt, decimal mksale_balamt, decimal oil_amt, decimal oil_balamt, decimal palm_amt, decimal palm_balamt, decimal donate_amt, decimal donate_balamt, decimal shr_amt, decimal shr_balamt, decimal kathin_amt, decimal kathin_balamt, decimal int_amt, decimal int_balamt, decimal total_amt, decimal total_balamt, decimal bfint_arrear, decimal tran_amt, decimal mini_amt, decimal tranout_amt, string deptaccount_no) { DataTable1Row rowDataTable1Row = ((DataTable1Row)(this.NewRow())); object[] columnValuesArray = new object[] { DIV_YEAR, MEMBER_NO, COOP_ID, AVG_BALAMT, ETC_AMT, ETC_BALAMT, AVG_AMT, ITEM_BALAMT, DIV_AMT, DIV_BALAMT, mkbuy_amt, mkbuy_balamt, mksale_amt, mksale_balamt, oil_amt, oil_balamt, palm_amt, palm_balamt, donate_amt, donate_balamt, shr_amt, shr_balamt, kathin_amt, kathin_balamt, int_amt, int_balamt, total_amt, total_balamt, bfint_arrear, tran_amt, mini_amt, tranout_amt, deptaccount_no}; rowDataTable1Row.ItemArray = columnValuesArray; this.Rows.Add(rowDataTable1Row); return rowDataTable1Row; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public DataTable1Row FindByDIV_YEARMEMBER_NOCOOP_ID(string DIV_YEAR, string MEMBER_NO, string COOP_ID) { return ((DataTable1Row)(this.Rows.Find(new object[] { DIV_YEAR, MEMBER_NO, COOP_ID}))); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public override global::System.Data.DataTable Clone() { DataTable1DataTable cln = ((DataTable1DataTable)(base.Clone())); cln.InitVars(); return cln; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] protected override global::System.Data.DataTable CreateInstance() { return new DataTable1DataTable(); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] internal void InitVars() { this.columnDIV_YEAR = base.Columns["DIV_YEAR"]; this.columnMEMBER_NO = base.Columns["MEMBER_NO"]; this.columnCOOP_ID = base.Columns["COOP_ID"]; this.columnAVG_BALAMT = base.Columns["AVG_BALAMT"]; this.columnETC_AMT = base.Columns["ETC_AMT"]; this.columnETC_BALAMT = base.Columns["ETC_BALAMT"]; this.columnAVG_AMT = base.Columns["AVG_AMT"]; this.columnITEM_BALAMT = base.Columns["ITEM_BALAMT"]; this.columnDIV_AMT = base.Columns["DIV_AMT"]; this.columnDIV_BALAMT = base.Columns["DIV_BALAMT"]; this.columnmkbuy_amt = base.Columns["mkbuy_amt"]; this.columnmkbuy_balamt = base.Columns["mkbuy_balamt"]; this.columnmksale_amt = base.Columns["mksale_amt"]; this.columnmksale_balamt = base.Columns["mksale_balamt"]; this.columnoil_amt = base.Columns["oil_amt"]; this.columnoil_balamt = base.Columns["oil_balamt"]; this.columnpalm_amt = base.Columns["palm_amt"]; this.columnpalm_balamt = base.Columns["palm_balamt"]; this.columndonate_amt = base.Columns["donate_amt"]; this.columndonate_balamt = base.Columns["donate_balamt"]; this.columnshr_amt = base.Columns["shr_amt"]; this.columnshr_balamt = base.Columns["shr_balamt"]; this.columnkathin_amt = base.Columns["kathin_amt"]; this.columnkathin_balamt = base.Columns["kathin_balamt"]; this.columnint_amt = base.Columns["int_amt"]; this.columnint_balamt = base.Columns["int_balamt"]; this.columntotal_amt = base.Columns["total_amt"]; this.columntotal_balamt = base.Columns["total_balamt"]; this.columnbfint_arrear = base.Columns["bfint_arrear"]; this.columntran_amt = base.Columns["tran_amt"]; this.columnmini_amt = base.Columns["mini_amt"]; this.columntranout_amt = base.Columns["tranout_amt"]; this.columndeptaccount_no = base.Columns["deptaccount_no"]; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] private void InitClass() { this.columnDIV_YEAR = new global::System.Data.DataColumn("DIV_YEAR", typeof(string), null, global::System.Data.MappingType.Element); base.Columns.Add(this.columnDIV_YEAR); this.columnMEMBER_NO = new global::System.Data.DataColumn("MEMBER_NO", typeof(string), null, global::System.Data.MappingType.Element); base.Columns.Add(this.columnMEMBER_NO); this.columnCOOP_ID = new global::System.Data.DataColumn("COOP_ID", typeof(string), null, global::System.Data.MappingType.Element); base.Columns.Add(this.columnCOOP_ID); this.columnAVG_BALAMT = new global::System.Data.DataColumn("AVG_BALAMT", typeof(decimal), null, global::System.Data.MappingType.Element); base.Columns.Add(this.columnAVG_BALAMT); this.columnETC_AMT = new global::System.Data.DataColumn("ETC_AMT", typeof(decimal), null, global::System.Data.MappingType.Element); base.Columns.Add(this.columnETC_AMT); this.columnETC_BALAMT = new global::System.Data.DataColumn("ETC_BALAMT", typeof(decimal), null, global::System.Data.MappingType.Element); base.Columns.Add(this.columnETC_BALAMT); this.columnAVG_AMT = new global::System.Data.DataColumn("AVG_AMT", typeof(decimal), null, global::System.Data.MappingType.Element); base.Columns.Add(this.columnAVG_AMT); this.columnITEM_BALAMT = new global::System.Data.DataColumn("ITEM_BALAMT", typeof(decimal), null, global::System.Data.MappingType.Element); base.Columns.Add(this.columnITEM_BALAMT); this.columnDIV_AMT = new global::System.Data.DataColumn("DIV_AMT", typeof(decimal), null, global::System.Data.MappingType.Element); base.Columns.Add(this.columnDIV_AMT); this.columnDIV_BALAMT = new global::System.Data.DataColumn("DIV_BALAMT", typeof(decimal), null, global::System.Data.MappingType.Element); base.Columns.Add(this.columnDIV_BALAMT); this.columnmkbuy_amt = new global::System.Data.DataColumn("mkbuy_amt", typeof(decimal), null, global::System.Data.MappingType.Element); base.Columns.Add(this.columnmkbuy_amt); this.columnmkbuy_balamt = new global::System.Data.DataColumn("mkbuy_balamt", typeof(decimal), null, global::System.Data.MappingType.Element); base.Columns.Add(this.columnmkbuy_balamt); this.columnmksale_amt = new global::System.Data.DataColumn("mksale_amt", typeof(decimal), null, global::System.Data.MappingType.Element); base.Columns.Add(this.columnmksale_amt); this.columnmksale_balamt = new global::System.Data.DataColumn("mksale_balamt", typeof(decimal), null, global::System.Data.MappingType.Element); base.Columns.Add(this.columnmksale_balamt); this.columnoil_amt = new global::System.Data.DataColumn("oil_amt", typeof(decimal), null, global::System.Data.MappingType.Element); base.Columns.Add(this.columnoil_amt); this.columnoil_balamt = new global::System.Data.DataColumn("oil_balamt", typeof(decimal), null, global::System.Data.MappingType.Element); base.Columns.Add(this.columnoil_balamt); this.columnpalm_amt = new global::System.Data.DataColumn("palm_amt", typeof(decimal), null, global::System.Data.MappingType.Element); base.Columns.Add(this.columnpalm_amt); this.columnpalm_balamt = new global::System.Data.DataColumn("palm_balamt", typeof(decimal), null, global::System.Data.MappingType.Element); base.Columns.Add(this.columnpalm_balamt); this.columndonate_amt = new global::System.Data.DataColumn("donate_amt", typeof(decimal), null, global::System.Data.MappingType.Element); base.Columns.Add(this.columndonate_amt); this.columndonate_balamt = new global::System.Data.DataColumn("donate_balamt", typeof(decimal), null, global::System.Data.MappingType.Element); base.Columns.Add(this.columndonate_balamt); this.columnshr_amt = new global::System.Data.DataColumn("shr_amt", typeof(decimal), null, global::System.Data.MappingType.Element); base.Columns.Add(this.columnshr_amt); this.columnshr_balamt = new global::System.Data.DataColumn("shr_balamt", typeof(decimal), null, global::System.Data.MappingType.Element); base.Columns.Add(this.columnshr_balamt); this.columnkathin_amt = new global::System.Data.DataColumn("kathin_amt", typeof(decimal), null, global::System.Data.MappingType.Element); base.Columns.Add(this.columnkathin_amt); this.columnkathin_balamt = new global::System.Data.DataColumn("kathin_balamt", typeof(decimal), null, global::System.Data.MappingType.Element); base.Columns.Add(this.columnkathin_balamt); this.columnint_amt = new global::System.Data.DataColumn("int_amt", typeof(decimal), null, global::System.Data.MappingType.Element); base.Columns.Add(this.columnint_amt); this.columnint_balamt = new global::System.Data.DataColumn("int_balamt", typeof(decimal), null, global::System.Data.MappingType.Element); base.Columns.Add(this.columnint_balamt); this.columntotal_amt = new global::System.Data.DataColumn("total_amt", typeof(decimal), null, global::System.Data.MappingType.Element); base.Columns.Add(this.columntotal_amt); this.columntotal_balamt = new global::System.Data.DataColumn("total_balamt", typeof(decimal), null, global::System.Data.MappingType.Element); base.Columns.Add(this.columntotal_balamt); this.columnbfint_arrear = new global::System.Data.DataColumn("bfint_arrear", typeof(decimal), null, global::System.Data.MappingType.Element); base.Columns.Add(this.columnbfint_arrear); this.columntran_amt = new global::System.Data.DataColumn("tran_amt", typeof(decimal), null, global::System.Data.MappingType.Element); base.Columns.Add(this.columntran_amt); this.columnmini_amt = new global::System.Data.DataColumn("mini_amt", typeof(decimal), null, global::System.Data.MappingType.Element); base.Columns.Add(this.columnmini_amt); this.columntranout_amt = new global::System.Data.DataColumn("tranout_amt", typeof(decimal), null, global::System.Data.MappingType.Element); base.Columns.Add(this.columntranout_amt); this.columndeptaccount_no = new global::System.Data.DataColumn("deptaccount_no", typeof(string), null, global::System.Data.MappingType.Element); base.Columns.Add(this.columndeptaccount_no); this.Constraints.Add(new global::System.Data.UniqueConstraint("Constraint1", new global::System.Data.DataColumn[] { this.columnDIV_YEAR, this.columnMEMBER_NO, this.columnCOOP_ID}, true)); this.columnDIV_YEAR.AllowDBNull = false; this.columnDIV_YEAR.MaxLength = 2; this.columnMEMBER_NO.AllowDBNull = false; this.columnMEMBER_NO.MaxLength = 4; this.columnCOOP_ID.AllowDBNull = false; this.columnCOOP_ID.MaxLength = 3; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public DataTable1Row NewDataTable1Row() { return ((DataTable1Row)(this.NewRow())); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] protected override global::System.Data.DataRow NewRowFromBuilder(global::System.Data.DataRowBuilder builder) { return new DataTable1Row(builder); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] protected override global::System.Type GetRowType() { return typeof(DataTable1Row); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] protected override void OnRowChanged(global::System.Data.DataRowChangeEventArgs e) { base.OnRowChanged(e); if ((this.DataTable1RowChanged != null)) { this.DataTable1RowChanged(this, new DataTable1RowChangeEvent(((DataTable1Row)(e.Row)), e.Action)); } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] protected override void OnRowChanging(global::System.Data.DataRowChangeEventArgs e) { base.OnRowChanging(e); if ((this.DataTable1RowChanging != null)) { this.DataTable1RowChanging(this, new DataTable1RowChangeEvent(((DataTable1Row)(e.Row)), e.Action)); } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] protected override void OnRowDeleted(global::System.Data.DataRowChangeEventArgs e) { base.OnRowDeleted(e); if ((this.DataTable1RowDeleted != null)) { this.DataTable1RowDeleted(this, new DataTable1RowChangeEvent(((DataTable1Row)(e.Row)), e.Action)); } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] protected override void OnRowDeleting(global::System.Data.DataRowChangeEventArgs e) { base.OnRowDeleting(e); if ((this.DataTable1RowDeleting != null)) { this.DataTable1RowDeleting(this, new DataTable1RowChangeEvent(((DataTable1Row)(e.Row)), e.Action)); } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public void RemoveDataTable1Row(DataTable1Row row) { this.Rows.Remove(row); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] 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(); DataSet1 ds = new DataSet1(); 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 = "DataTable1DataTable"; type.Attributes.Add(attribute2); type.Particle = sequence; global::System.Xml.Schema.XmlSchema dsSchema = ds.GetSchemaSerializable(); if (xs.Contains(dsSchema.TargetNamespace)) { global::System.IO.MemoryStream s1 = new global::System.IO.MemoryStream(); global::System.IO.MemoryStream s2 = new global::System.IO.MemoryStream(); try { global::System.Xml.Schema.XmlSchema schema = null; dsSchema.Write(s1); for (global::System.Collections.IEnumerator schemas = xs.Schemas(dsSchema.TargetNamespace).GetEnumerator(); schemas.MoveNext(); ) { schema = ((global::System.Xml.Schema.XmlSchema)(schemas.Current)); s2.SetLength(0); schema.Write(s2); if ((s1.Length == s2.Length)) { s1.Position = 0; s2.Position = 0; for (; ((s1.Position != s1.Length) && (s1.ReadByte() == s2.ReadByte())); ) { ; } if ((s1.Position == s1.Length)) { return type; } } } } finally { if ((s1 != null)) { s1.Close(); } if ((s2 != null)) { s2.Close(); } } } xs.Add(dsSchema); return type; } } /// ///Represents the strongly named DataTable class. /// [global::System.Serializable()] [global::System.Xml.Serialization.XmlSchemaProviderAttribute("GetTypedTableSchema")] public partial class YRDIVMASTERDataTable : global::System.Data.TypedTableBase { private global::System.Data.DataColumn columnCOOP_ID; private global::System.Data.DataColumn columnMEMBER_NO; private global::System.Data.DataColumn columnDIV_YEAR; private global::System.Data.DataColumn columnDIV_AMT; private global::System.Data.DataColumn columnDIV_BALAMT; private global::System.Data.DataColumn columnAVG_AMT; private global::System.Data.DataColumn columnAVG_BALAMT; private global::System.Data.DataColumn columnETC_AMT; private global::System.Data.DataColumn columnETC_BALAMT; private global::System.Data.DataColumn columnITEM_BALAMT; private global::System.Data.DataColumn columnSHOP1_AMT; private global::System.Data.DataColumn columnSHOP2_AMT; private global::System.Data.DataColumn columnOIL_AMT; private global::System.Data.DataColumn columnSHOP1_BALAMT; private global::System.Data.DataColumn columnSHOP2_BALAMT; private global::System.Data.DataColumn columnOIL_BALAMT; private global::System.Data.DataColumn columnRICE_AMT; private global::System.Data.DataColumn columnRICE_BALAMT; private global::System.Data.DataColumn columnDEPT_AMT; private global::System.Data.DataColumn columnLOANLAW_AMT; private global::System.Data.DataColumn columnSHR_AMT; private global::System.Data.DataColumn columndeptaccount_no; private global::System.Data.DataColumn columntotal_amt; private global::System.Data.DataColumn columnloan_amt; private global::System.Data.DataColumn columnNOTIS_AMT; private global::System.Data.DataColumn columnREMARK; [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public YRDIVMASTERDataTable() { this.TableName = "YRDIVMASTER"; this.BeginInit(); this.InitClass(); this.EndInit(); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] internal YRDIVMASTERDataTable(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()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] protected YRDIVMASTERDataTable(global::System.Runtime.Serialization.SerializationInfo info, global::System.Runtime.Serialization.StreamingContext context) : base(info, context) { this.InitVars(); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public global::System.Data.DataColumn COOP_IDColumn { get { return this.columnCOOP_ID; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public global::System.Data.DataColumn MEMBER_NOColumn { get { return this.columnMEMBER_NO; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public global::System.Data.DataColumn DIV_YEARColumn { get { return this.columnDIV_YEAR; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public global::System.Data.DataColumn DIV_AMTColumn { get { return this.columnDIV_AMT; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public global::System.Data.DataColumn DIV_BALAMTColumn { get { return this.columnDIV_BALAMT; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public global::System.Data.DataColumn AVG_AMTColumn { get { return this.columnAVG_AMT; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public global::System.Data.DataColumn AVG_BALAMTColumn { get { return this.columnAVG_BALAMT; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public global::System.Data.DataColumn ETC_AMTColumn { get { return this.columnETC_AMT; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public global::System.Data.DataColumn ETC_BALAMTColumn { get { return this.columnETC_BALAMT; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public global::System.Data.DataColumn ITEM_BALAMTColumn { get { return this.columnITEM_BALAMT; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public global::System.Data.DataColumn SHOP1_AMTColumn { get { return this.columnSHOP1_AMT; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public global::System.Data.DataColumn SHOP2_AMTColumn { get { return this.columnSHOP2_AMT; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public global::System.Data.DataColumn OIL_AMTColumn { get { return this.columnOIL_AMT; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public global::System.Data.DataColumn SHOP1_BALAMTColumn { get { return this.columnSHOP1_BALAMT; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public global::System.Data.DataColumn SHOP2_BALAMTColumn { get { return this.columnSHOP2_BALAMT; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public global::System.Data.DataColumn OIL_BALAMTColumn { get { return this.columnOIL_BALAMT; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public global::System.Data.DataColumn RICE_AMTColumn { get { return this.columnRICE_AMT; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public global::System.Data.DataColumn RICE_BALAMTColumn { get { return this.columnRICE_BALAMT; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public global::System.Data.DataColumn DEPT_AMTColumn { get { return this.columnDEPT_AMT; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public global::System.Data.DataColumn LOANLAW_AMTColumn { get { return this.columnLOANLAW_AMT; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public global::System.Data.DataColumn SHR_AMTColumn { get { return this.columnSHR_AMT; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public global::System.Data.DataColumn deptaccount_noColumn { get { return this.columndeptaccount_no; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public global::System.Data.DataColumn total_amtColumn { get { return this.columntotal_amt; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public global::System.Data.DataColumn loan_amtColumn { get { return this.columnloan_amt; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public global::System.Data.DataColumn NOTIS_AMTColumn { get { return this.columnNOTIS_AMT; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public global::System.Data.DataColumn REMARKColumn { get { return this.columnREMARK; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] [global::System.ComponentModel.Browsable(false)] public int Count { get { return this.Rows.Count; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public YRDIVMASTERRow this[int index] { get { return ((YRDIVMASTERRow)(this.Rows[index])); } } [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public event YRDIVMASTERRowChangeEventHandler YRDIVMASTERRowChanging; [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public event YRDIVMASTERRowChangeEventHandler YRDIVMASTERRowChanged; [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public event YRDIVMASTERRowChangeEventHandler YRDIVMASTERRowDeleting; [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public event YRDIVMASTERRowChangeEventHandler YRDIVMASTERRowDeleted; [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public void AddYRDIVMASTERRow(YRDIVMASTERRow row) { this.Rows.Add(row); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public YRDIVMASTERRow AddYRDIVMASTERRow( string COOP_ID, string MEMBER_NO, string DIV_YEAR, decimal DIV_AMT, decimal DIV_BALAMT, decimal AVG_AMT, decimal AVG_BALAMT, decimal ETC_AMT, decimal ETC_BALAMT, decimal ITEM_BALAMT, decimal SHOP1_AMT, decimal SHOP2_AMT, decimal OIL_AMT, decimal SHOP1_BALAMT, decimal SHOP2_BALAMT, decimal OIL_BALAMT, decimal RICE_AMT, decimal RICE_BALAMT, decimal DEPT_AMT, decimal LOANLAW_AMT, decimal SHR_AMT, string deptaccount_no, decimal total_amt, decimal loan_amt, decimal NOTIS_AMT, string REMARK) { YRDIVMASTERRow rowYRDIVMASTERRow = ((YRDIVMASTERRow)(this.NewRow())); object[] columnValuesArray = new object[] { COOP_ID, MEMBER_NO, DIV_YEAR, DIV_AMT, DIV_BALAMT, AVG_AMT, AVG_BALAMT, ETC_AMT, ETC_BALAMT, ITEM_BALAMT, SHOP1_AMT, SHOP2_AMT, OIL_AMT, SHOP1_BALAMT, SHOP2_BALAMT, OIL_BALAMT, RICE_AMT, RICE_BALAMT, DEPT_AMT, LOANLAW_AMT, SHR_AMT, deptaccount_no, total_amt, loan_amt, NOTIS_AMT, REMARK}; rowYRDIVMASTERRow.ItemArray = columnValuesArray; this.Rows.Add(rowYRDIVMASTERRow); return rowYRDIVMASTERRow; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public YRDIVMASTERRow FindByCOOP_IDMEMBER_NODIV_YEAR(string COOP_ID, string MEMBER_NO, string DIV_YEAR) { return ((YRDIVMASTERRow)(this.Rows.Find(new object[] { COOP_ID, MEMBER_NO, DIV_YEAR}))); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public override global::System.Data.DataTable Clone() { YRDIVMASTERDataTable cln = ((YRDIVMASTERDataTable)(base.Clone())); cln.InitVars(); return cln; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] protected override global::System.Data.DataTable CreateInstance() { return new YRDIVMASTERDataTable(); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] internal void InitVars() { this.columnCOOP_ID = base.Columns["COOP_ID"]; this.columnMEMBER_NO = base.Columns["MEMBER_NO"]; this.columnDIV_YEAR = base.Columns["DIV_YEAR"]; this.columnDIV_AMT = base.Columns["DIV_AMT"]; this.columnDIV_BALAMT = base.Columns["DIV_BALAMT"]; this.columnAVG_AMT = base.Columns["AVG_AMT"]; this.columnAVG_BALAMT = base.Columns["AVG_BALAMT"]; this.columnETC_AMT = base.Columns["ETC_AMT"]; this.columnETC_BALAMT = base.Columns["ETC_BALAMT"]; this.columnITEM_BALAMT = base.Columns["ITEM_BALAMT"]; this.columnSHOP1_AMT = base.Columns["SHOP1_AMT"]; this.columnSHOP2_AMT = base.Columns["SHOP2_AMT"]; this.columnOIL_AMT = base.Columns["OIL_AMT"]; this.columnSHOP1_BALAMT = base.Columns["SHOP1_BALAMT"]; this.columnSHOP2_BALAMT = base.Columns["SHOP2_BALAMT"]; this.columnOIL_BALAMT = base.Columns["OIL_BALAMT"]; this.columnRICE_AMT = base.Columns["RICE_AMT"]; this.columnRICE_BALAMT = base.Columns["RICE_BALAMT"]; this.columnDEPT_AMT = base.Columns["DEPT_AMT"]; this.columnLOANLAW_AMT = base.Columns["LOANLAW_AMT"]; this.columnSHR_AMT = base.Columns["SHR_AMT"]; this.columndeptaccount_no = base.Columns["deptaccount_no"]; this.columntotal_amt = base.Columns["total_amt"]; this.columnloan_amt = base.Columns["loan_amt"]; this.columnNOTIS_AMT = base.Columns["NOTIS_AMT"]; this.columnREMARK = base.Columns["REMARK"]; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] private void InitClass() { this.columnCOOP_ID = new global::System.Data.DataColumn("COOP_ID", typeof(string), null, global::System.Data.MappingType.Element); base.Columns.Add(this.columnCOOP_ID); this.columnMEMBER_NO = new global::System.Data.DataColumn("MEMBER_NO", typeof(string), null, global::System.Data.MappingType.Element); base.Columns.Add(this.columnMEMBER_NO); this.columnDIV_YEAR = new global::System.Data.DataColumn("DIV_YEAR", typeof(string), null, global::System.Data.MappingType.Element); base.Columns.Add(this.columnDIV_YEAR); this.columnDIV_AMT = new global::System.Data.DataColumn("DIV_AMT", typeof(decimal), null, global::System.Data.MappingType.Element); base.Columns.Add(this.columnDIV_AMT); this.columnDIV_BALAMT = new global::System.Data.DataColumn("DIV_BALAMT", typeof(decimal), null, global::System.Data.MappingType.Element); base.Columns.Add(this.columnDIV_BALAMT); this.columnAVG_AMT = new global::System.Data.DataColumn("AVG_AMT", typeof(decimal), null, global::System.Data.MappingType.Element); base.Columns.Add(this.columnAVG_AMT); this.columnAVG_BALAMT = new global::System.Data.DataColumn("AVG_BALAMT", typeof(decimal), null, global::System.Data.MappingType.Element); base.Columns.Add(this.columnAVG_BALAMT); this.columnETC_AMT = new global::System.Data.DataColumn("ETC_AMT", typeof(decimal), null, global::System.Data.MappingType.Element); base.Columns.Add(this.columnETC_AMT); this.columnETC_BALAMT = new global::System.Data.DataColumn("ETC_BALAMT", typeof(decimal), null, global::System.Data.MappingType.Element); base.Columns.Add(this.columnETC_BALAMT); this.columnITEM_BALAMT = new global::System.Data.DataColumn("ITEM_BALAMT", typeof(decimal), null, global::System.Data.MappingType.Element); base.Columns.Add(this.columnITEM_BALAMT); this.columnSHOP1_AMT = new global::System.Data.DataColumn("SHOP1_AMT", typeof(decimal), null, global::System.Data.MappingType.Element); base.Columns.Add(this.columnSHOP1_AMT); this.columnSHOP2_AMT = new global::System.Data.DataColumn("SHOP2_AMT", typeof(decimal), null, global::System.Data.MappingType.Element); base.Columns.Add(this.columnSHOP2_AMT); this.columnOIL_AMT = new global::System.Data.DataColumn("OIL_AMT", typeof(decimal), null, global::System.Data.MappingType.Element); base.Columns.Add(this.columnOIL_AMT); this.columnSHOP1_BALAMT = new global::System.Data.DataColumn("SHOP1_BALAMT", typeof(decimal), null, global::System.Data.MappingType.Element); base.Columns.Add(this.columnSHOP1_BALAMT); this.columnSHOP2_BALAMT = new global::System.Data.DataColumn("SHOP2_BALAMT", typeof(decimal), null, global::System.Data.MappingType.Element); base.Columns.Add(this.columnSHOP2_BALAMT); this.columnOIL_BALAMT = new global::System.Data.DataColumn("OIL_BALAMT", typeof(decimal), null, global::System.Data.MappingType.Element); base.Columns.Add(this.columnOIL_BALAMT); this.columnRICE_AMT = new global::System.Data.DataColumn("RICE_AMT", typeof(decimal), null, global::System.Data.MappingType.Element); base.Columns.Add(this.columnRICE_AMT); this.columnRICE_BALAMT = new global::System.Data.DataColumn("RICE_BALAMT", typeof(decimal), null, global::System.Data.MappingType.Element); base.Columns.Add(this.columnRICE_BALAMT); this.columnDEPT_AMT = new global::System.Data.DataColumn("DEPT_AMT", typeof(decimal), null, global::System.Data.MappingType.Element); base.Columns.Add(this.columnDEPT_AMT); this.columnLOANLAW_AMT = new global::System.Data.DataColumn("LOANLAW_AMT", typeof(decimal), null, global::System.Data.MappingType.Element); base.Columns.Add(this.columnLOANLAW_AMT); this.columnSHR_AMT = new global::System.Data.DataColumn("SHR_AMT", typeof(decimal), null, global::System.Data.MappingType.Element); base.Columns.Add(this.columnSHR_AMT); this.columndeptaccount_no = new global::System.Data.DataColumn("deptaccount_no", typeof(string), null, global::System.Data.MappingType.Element); base.Columns.Add(this.columndeptaccount_no); this.columntotal_amt = new global::System.Data.DataColumn("total_amt", typeof(decimal), null, global::System.Data.MappingType.Element); base.Columns.Add(this.columntotal_amt); this.columnloan_amt = new global::System.Data.DataColumn("loan_amt", typeof(decimal), null, global::System.Data.MappingType.Element); base.Columns.Add(this.columnloan_amt); this.columnNOTIS_AMT = new global::System.Data.DataColumn("NOTIS_AMT", typeof(decimal), null, global::System.Data.MappingType.Element); base.Columns.Add(this.columnNOTIS_AMT); this.columnREMARK = new global::System.Data.DataColumn("REMARK", typeof(string), null, global::System.Data.MappingType.Element); base.Columns.Add(this.columnREMARK); this.Constraints.Add(new global::System.Data.UniqueConstraint("Constraint1", new global::System.Data.DataColumn[] { this.columnCOOP_ID, this.columnMEMBER_NO, this.columnDIV_YEAR}, true)); this.columnCOOP_ID.AllowDBNull = false; this.columnCOOP_ID.MaxLength = 6; this.columnMEMBER_NO.AllowDBNull = false; this.columnMEMBER_NO.MaxLength = 8; this.columnDIV_YEAR.AllowDBNull = false; this.columnDIV_YEAR.MaxLength = 5; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public YRDIVMASTERRow NewYRDIVMASTERRow() { return ((YRDIVMASTERRow)(this.NewRow())); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] protected override global::System.Data.DataRow NewRowFromBuilder(global::System.Data.DataRowBuilder builder) { return new YRDIVMASTERRow(builder); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] protected override global::System.Type GetRowType() { return typeof(YRDIVMASTERRow); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] protected override void OnRowChanged(global::System.Data.DataRowChangeEventArgs e) { base.OnRowChanged(e); if ((this.YRDIVMASTERRowChanged != null)) { this.YRDIVMASTERRowChanged(this, new YRDIVMASTERRowChangeEvent(((YRDIVMASTERRow)(e.Row)), e.Action)); } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] protected override void OnRowChanging(global::System.Data.DataRowChangeEventArgs e) { base.OnRowChanging(e); if ((this.YRDIVMASTERRowChanging != null)) { this.YRDIVMASTERRowChanging(this, new YRDIVMASTERRowChangeEvent(((YRDIVMASTERRow)(e.Row)), e.Action)); } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] protected override void OnRowDeleted(global::System.Data.DataRowChangeEventArgs e) { base.OnRowDeleted(e); if ((this.YRDIVMASTERRowDeleted != null)) { this.YRDIVMASTERRowDeleted(this, new YRDIVMASTERRowChangeEvent(((YRDIVMASTERRow)(e.Row)), e.Action)); } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] protected override void OnRowDeleting(global::System.Data.DataRowChangeEventArgs e) { base.OnRowDeleting(e); if ((this.YRDIVMASTERRowDeleting != null)) { this.YRDIVMASTERRowDeleting(this, new YRDIVMASTERRowChangeEvent(((YRDIVMASTERRow)(e.Row)), e.Action)); } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public void RemoveYRDIVMASTERRow(YRDIVMASTERRow row) { this.Rows.Remove(row); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] 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(); DataSet1 ds = new DataSet1(); 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 = "YRDIVMASTERDataTable"; type.Attributes.Add(attribute2); type.Particle = sequence; global::System.Xml.Schema.XmlSchema dsSchema = ds.GetSchemaSerializable(); if (xs.Contains(dsSchema.TargetNamespace)) { global::System.IO.MemoryStream s1 = new global::System.IO.MemoryStream(); global::System.IO.MemoryStream s2 = new global::System.IO.MemoryStream(); try { global::System.Xml.Schema.XmlSchema schema = null; dsSchema.Write(s1); for (global::System.Collections.IEnumerator schemas = xs.Schemas(dsSchema.TargetNamespace).GetEnumerator(); schemas.MoveNext(); ) { schema = ((global::System.Xml.Schema.XmlSchema)(schemas.Current)); s2.SetLength(0); schema.Write(s2); if ((s1.Length == s2.Length)) { s1.Position = 0; s2.Position = 0; for (; ((s1.Position != s1.Length) && (s1.ReadByte() == s2.ReadByte())); ) { ; } if ((s1.Position == s1.Length)) { return type; } } } } finally { if ((s1 != null)) { s1.Close(); } if ((s2 != null)) { s2.Close(); } } } xs.Add(dsSchema); return type; } } /// ///Represents the strongly named DataTable class. /// [global::System.Serializable()] [global::System.Xml.Serialization.XmlSchemaProviderAttribute("GetTypedTableSchema")] public partial class DT_LOANDataTable : global::System.Data.TypedTableBase { private global::System.Data.DataColumn columnCOOP_ID; private global::System.Data.DataColumn columnMEMBER_NO; private global::System.Data.DataColumn columnDIV_YEAR; private global::System.Data.DataColumn columnSEQ_NO; private global::System.Data.DataColumn columnCONCOOP_ID; private global::System.Data.DataColumn columnLOANCONTRACT_NO; private global::System.Data.DataColumn columnINTEREST_ACCUM; private global::System.Data.DataColumn columnMISSPAY_AMT; private global::System.Data.DataColumn columnAVG_AMT; private global::System.Data.DataColumn columnRAVG_AMT; private global::System.Data.DataColumn columnavgpercent_rate; [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public DT_LOANDataTable() { this.TableName = "DT_LOAN"; this.BeginInit(); this.InitClass(); this.EndInit(); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] internal DT_LOANDataTable(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()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] protected DT_LOANDataTable(global::System.Runtime.Serialization.SerializationInfo info, global::System.Runtime.Serialization.StreamingContext context) : base(info, context) { this.InitVars(); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public global::System.Data.DataColumn COOP_IDColumn { get { return this.columnCOOP_ID; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public global::System.Data.DataColumn MEMBER_NOColumn { get { return this.columnMEMBER_NO; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public global::System.Data.DataColumn DIV_YEARColumn { get { return this.columnDIV_YEAR; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public global::System.Data.DataColumn SEQ_NOColumn { get { return this.columnSEQ_NO; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public global::System.Data.DataColumn CONCOOP_IDColumn { get { return this.columnCONCOOP_ID; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public global::System.Data.DataColumn LOANCONTRACT_NOColumn { get { return this.columnLOANCONTRACT_NO; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public global::System.Data.DataColumn INTEREST_ACCUMColumn { get { return this.columnINTEREST_ACCUM; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public global::System.Data.DataColumn MISSPAY_AMTColumn { get { return this.columnMISSPAY_AMT; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public global::System.Data.DataColumn AVG_AMTColumn { get { return this.columnAVG_AMT; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public global::System.Data.DataColumn RAVG_AMTColumn { get { return this.columnRAVG_AMT; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public global::System.Data.DataColumn avgpercent_rateColumn { get { return this.columnavgpercent_rate; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] [global::System.ComponentModel.Browsable(false)] public int Count { get { return this.Rows.Count; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public DT_LOANRow this[int index] { get { return ((DT_LOANRow)(this.Rows[index])); } } [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public event DT_LOANRowChangeEventHandler DT_LOANRowChanging; [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public event DT_LOANRowChangeEventHandler DT_LOANRowChanged; [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public event DT_LOANRowChangeEventHandler DT_LOANRowDeleting; [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public event DT_LOANRowChangeEventHandler DT_LOANRowDeleted; [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public void AddDT_LOANRow(DT_LOANRow row) { this.Rows.Add(row); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public DT_LOANRow AddDT_LOANRow(string COOP_ID, string MEMBER_NO, string DIV_YEAR, decimal SEQ_NO, string CONCOOP_ID, string LOANCONTRACT_NO, decimal INTEREST_ACCUM, decimal MISSPAY_AMT, decimal AVG_AMT, decimal RAVG_AMT, decimal avgpercent_rate) { DT_LOANRow rowDT_LOANRow = ((DT_LOANRow)(this.NewRow())); object[] columnValuesArray = new object[] { COOP_ID, MEMBER_NO, DIV_YEAR, SEQ_NO, CONCOOP_ID, LOANCONTRACT_NO, INTEREST_ACCUM, MISSPAY_AMT, AVG_AMT, RAVG_AMT, avgpercent_rate}; rowDT_LOANRow.ItemArray = columnValuesArray; this.Rows.Add(rowDT_LOANRow); return rowDT_LOANRow; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public DT_LOANRow FindByCOOP_IDMEMBER_NODIV_YEARSEQ_NO(string COOP_ID, string MEMBER_NO, string DIV_YEAR, decimal SEQ_NO) { return ((DT_LOANRow)(this.Rows.Find(new object[] { COOP_ID, MEMBER_NO, DIV_YEAR, SEQ_NO}))); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public override global::System.Data.DataTable Clone() { DT_LOANDataTable cln = ((DT_LOANDataTable)(base.Clone())); cln.InitVars(); return cln; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] protected override global::System.Data.DataTable CreateInstance() { return new DT_LOANDataTable(); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] internal void InitVars() { this.columnCOOP_ID = base.Columns["COOP_ID"]; this.columnMEMBER_NO = base.Columns["MEMBER_NO"]; this.columnDIV_YEAR = base.Columns["DIV_YEAR"]; this.columnSEQ_NO = base.Columns["SEQ_NO"]; this.columnCONCOOP_ID = base.Columns["CONCOOP_ID"]; this.columnLOANCONTRACT_NO = base.Columns["LOANCONTRACT_NO"]; this.columnINTEREST_ACCUM = base.Columns["INTEREST_ACCUM"]; this.columnMISSPAY_AMT = base.Columns["MISSPAY_AMT"]; this.columnAVG_AMT = base.Columns["AVG_AMT"]; this.columnRAVG_AMT = base.Columns["RAVG_AMT"]; this.columnavgpercent_rate = base.Columns["avgpercent_rate"]; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] private void InitClass() { this.columnCOOP_ID = new global::System.Data.DataColumn("COOP_ID", typeof(string), null, global::System.Data.MappingType.Element); base.Columns.Add(this.columnCOOP_ID); this.columnMEMBER_NO = new global::System.Data.DataColumn("MEMBER_NO", typeof(string), null, global::System.Data.MappingType.Element); base.Columns.Add(this.columnMEMBER_NO); this.columnDIV_YEAR = new global::System.Data.DataColumn("DIV_YEAR", typeof(string), null, global::System.Data.MappingType.Element); base.Columns.Add(this.columnDIV_YEAR); this.columnSEQ_NO = new global::System.Data.DataColumn("SEQ_NO", typeof(decimal), null, global::System.Data.MappingType.Element); base.Columns.Add(this.columnSEQ_NO); this.columnCONCOOP_ID = new global::System.Data.DataColumn("CONCOOP_ID", typeof(string), null, global::System.Data.MappingType.Element); base.Columns.Add(this.columnCONCOOP_ID); this.columnLOANCONTRACT_NO = new global::System.Data.DataColumn("LOANCONTRACT_NO", typeof(string), null, global::System.Data.MappingType.Element); base.Columns.Add(this.columnLOANCONTRACT_NO); this.columnINTEREST_ACCUM = new global::System.Data.DataColumn("INTEREST_ACCUM", typeof(decimal), null, global::System.Data.MappingType.Element); base.Columns.Add(this.columnINTEREST_ACCUM); this.columnMISSPAY_AMT = new global::System.Data.DataColumn("MISSPAY_AMT", typeof(decimal), null, global::System.Data.MappingType.Element); base.Columns.Add(this.columnMISSPAY_AMT); this.columnAVG_AMT = new global::System.Data.DataColumn("AVG_AMT", typeof(decimal), null, global::System.Data.MappingType.Element); base.Columns.Add(this.columnAVG_AMT); this.columnRAVG_AMT = new global::System.Data.DataColumn("RAVG_AMT", typeof(decimal), null, global::System.Data.MappingType.Element); base.Columns.Add(this.columnRAVG_AMT); this.columnavgpercent_rate = new global::System.Data.DataColumn("avgpercent_rate", typeof(decimal), null, global::System.Data.MappingType.Element); base.Columns.Add(this.columnavgpercent_rate); this.Constraints.Add(new global::System.Data.UniqueConstraint("Constraint1", new global::System.Data.DataColumn[] { this.columnCOOP_ID, this.columnMEMBER_NO, this.columnDIV_YEAR, this.columnSEQ_NO}, true)); this.columnCOOP_ID.AllowDBNull = false; this.columnCOOP_ID.MaxLength = 6; this.columnMEMBER_NO.AllowDBNull = false; this.columnMEMBER_NO.MaxLength = 8; this.columnDIV_YEAR.AllowDBNull = false; this.columnDIV_YEAR.MaxLength = 5; this.columnSEQ_NO.AllowDBNull = false; this.columnCONCOOP_ID.MaxLength = 6; this.columnLOANCONTRACT_NO.MaxLength = 15; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public DT_LOANRow NewDT_LOANRow() { return ((DT_LOANRow)(this.NewRow())); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] protected override global::System.Data.DataRow NewRowFromBuilder(global::System.Data.DataRowBuilder builder) { return new DT_LOANRow(builder); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] protected override global::System.Type GetRowType() { return typeof(DT_LOANRow); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] protected override void OnRowChanged(global::System.Data.DataRowChangeEventArgs e) { base.OnRowChanged(e); if ((this.DT_LOANRowChanged != null)) { this.DT_LOANRowChanged(this, new DT_LOANRowChangeEvent(((DT_LOANRow)(e.Row)), e.Action)); } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] protected override void OnRowChanging(global::System.Data.DataRowChangeEventArgs e) { base.OnRowChanging(e); if ((this.DT_LOANRowChanging != null)) { this.DT_LOANRowChanging(this, new DT_LOANRowChangeEvent(((DT_LOANRow)(e.Row)), e.Action)); } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] protected override void OnRowDeleted(global::System.Data.DataRowChangeEventArgs e) { base.OnRowDeleted(e); if ((this.DT_LOANRowDeleted != null)) { this.DT_LOANRowDeleted(this, new DT_LOANRowChangeEvent(((DT_LOANRow)(e.Row)), e.Action)); } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] protected override void OnRowDeleting(global::System.Data.DataRowChangeEventArgs e) { base.OnRowDeleting(e); if ((this.DT_LOANRowDeleting != null)) { this.DT_LOANRowDeleting(this, new DT_LOANRowChangeEvent(((DT_LOANRow)(e.Row)), e.Action)); } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public void RemoveDT_LOANRow(DT_LOANRow row) { this.Rows.Remove(row); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] 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(); DataSet1 ds = new DataSet1(); 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 = "DT_LOANDataTable"; type.Attributes.Add(attribute2); type.Particle = sequence; global::System.Xml.Schema.XmlSchema dsSchema = ds.GetSchemaSerializable(); if (xs.Contains(dsSchema.TargetNamespace)) { global::System.IO.MemoryStream s1 = new global::System.IO.MemoryStream(); global::System.IO.MemoryStream s2 = new global::System.IO.MemoryStream(); try { global::System.Xml.Schema.XmlSchema schema = null; dsSchema.Write(s1); for (global::System.Collections.IEnumerator schemas = xs.Schemas(dsSchema.TargetNamespace).GetEnumerator(); schemas.MoveNext(); ) { schema = ((global::System.Xml.Schema.XmlSchema)(schemas.Current)); s2.SetLength(0); schema.Write(s2); if ((s1.Length == s2.Length)) { s1.Position = 0; s2.Position = 0; for (; ((s1.Position != s1.Length) && (s1.ReadByte() == s2.ReadByte())); ) { ; } if ((s1.Position == s1.Length)) { return type; } } } } finally { if ((s1 != null)) { s1.Close(); } if ((s2 != null)) { s2.Close(); } } } xs.Add(dsSchema); return type; } } /// ///Represents strongly named DataRow class. /// public partial class DataTable1Row : global::System.Data.DataRow { private DataTable1DataTable tableDataTable1; [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] internal DataTable1Row(global::System.Data.DataRowBuilder rb) : base(rb) { this.tableDataTable1 = ((DataTable1DataTable)(this.Table)); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public string DIV_YEAR { get { return ((string)(this[this.tableDataTable1.DIV_YEARColumn])); } set { this[this.tableDataTable1.DIV_YEARColumn] = value; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public string MEMBER_NO { get { return ((string)(this[this.tableDataTable1.MEMBER_NOColumn])); } set { this[this.tableDataTable1.MEMBER_NOColumn] = value; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public string COOP_ID { get { return ((string)(this[this.tableDataTable1.COOP_IDColumn])); } set { this[this.tableDataTable1.COOP_IDColumn] = value; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public decimal AVG_BALAMT { get { try { return ((decimal)(this[this.tableDataTable1.AVG_BALAMTColumn])); } catch (global::System.InvalidCastException e) { throw new global::System.Data.StrongTypingException("The value for column \'AVG_BALAMT\' in table \'DataTable1\' is DBNull.", e); } } set { this[this.tableDataTable1.AVG_BALAMTColumn] = value; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public decimal ETC_AMT { get { try { return ((decimal)(this[this.tableDataTable1.ETC_AMTColumn])); } catch (global::System.InvalidCastException e) { throw new global::System.Data.StrongTypingException("The value for column \'ETC_AMT\' in table \'DataTable1\' is DBNull.", e); } } set { this[this.tableDataTable1.ETC_AMTColumn] = value; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public decimal ETC_BALAMT { get { try { return ((decimal)(this[this.tableDataTable1.ETC_BALAMTColumn])); } catch (global::System.InvalidCastException e) { throw new global::System.Data.StrongTypingException("The value for column \'ETC_BALAMT\' in table \'DataTable1\' is DBNull.", e); } } set { this[this.tableDataTable1.ETC_BALAMTColumn] = value; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public decimal AVG_AMT { get { try { return ((decimal)(this[this.tableDataTable1.AVG_AMTColumn])); } catch (global::System.InvalidCastException e) { throw new global::System.Data.StrongTypingException("The value for column \'AVG_AMT\' in table \'DataTable1\' is DBNull.", e); } } set { this[this.tableDataTable1.AVG_AMTColumn] = value; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public decimal ITEM_BALAMT { get { try { return ((decimal)(this[this.tableDataTable1.ITEM_BALAMTColumn])); } catch (global::System.InvalidCastException e) { throw new global::System.Data.StrongTypingException("The value for column \'ITEM_BALAMT\' in table \'DataTable1\' is DBNull.", e); } } set { this[this.tableDataTable1.ITEM_BALAMTColumn] = value; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public decimal DIV_AMT { get { try { return ((decimal)(this[this.tableDataTable1.DIV_AMTColumn])); } catch (global::System.InvalidCastException e) { throw new global::System.Data.StrongTypingException("The value for column \'DIV_AMT\' in table \'DataTable1\' is DBNull.", e); } } set { this[this.tableDataTable1.DIV_AMTColumn] = value; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public decimal DIV_BALAMT { get { try { return ((decimal)(this[this.tableDataTable1.DIV_BALAMTColumn])); } catch (global::System.InvalidCastException e) { throw new global::System.Data.StrongTypingException("The value for column \'DIV_BALAMT\' in table \'DataTable1\' is DBNull.", e); } } set { this[this.tableDataTable1.DIV_BALAMTColumn] = value; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public decimal mkbuy_amt { get { try { return ((decimal)(this[this.tableDataTable1.mkbuy_amtColumn])); } catch (global::System.InvalidCastException e) { throw new global::System.Data.StrongTypingException("The value for column \'mkbuy_amt\' in table \'DataTable1\' is DBNull.", e); } } set { this[this.tableDataTable1.mkbuy_amtColumn] = value; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public decimal mkbuy_balamt { get { try { return ((decimal)(this[this.tableDataTable1.mkbuy_balamtColumn])); } catch (global::System.InvalidCastException e) { throw new global::System.Data.StrongTypingException("The value for column \'mkbuy_balamt\' in table \'DataTable1\' is DBNull.", e); } } set { this[this.tableDataTable1.mkbuy_balamtColumn] = value; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public decimal mksale_amt { get { try { return ((decimal)(this[this.tableDataTable1.mksale_amtColumn])); } catch (global::System.InvalidCastException e) { throw new global::System.Data.StrongTypingException("The value for column \'mksale_amt\' in table \'DataTable1\' is DBNull.", e); } } set { this[this.tableDataTable1.mksale_amtColumn] = value; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public decimal mksale_balamt { get { try { return ((decimal)(this[this.tableDataTable1.mksale_balamtColumn])); } catch (global::System.InvalidCastException e) { throw new global::System.Data.StrongTypingException("The value for column \'mksale_balamt\' in table \'DataTable1\' is DBNull.", e); } } set { this[this.tableDataTable1.mksale_balamtColumn] = value; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public decimal oil_amt { get { try { return ((decimal)(this[this.tableDataTable1.oil_amtColumn])); } catch (global::System.InvalidCastException e) { throw new global::System.Data.StrongTypingException("The value for column \'oil_amt\' in table \'DataTable1\' is DBNull.", e); } } set { this[this.tableDataTable1.oil_amtColumn] = value; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public decimal oil_balamt { get { try { return ((decimal)(this[this.tableDataTable1.oil_balamtColumn])); } catch (global::System.InvalidCastException e) { throw new global::System.Data.StrongTypingException("The value for column \'oil_balamt\' in table \'DataTable1\' is DBNull.", e); } } set { this[this.tableDataTable1.oil_balamtColumn] = value; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public decimal palm_amt { get { try { return ((decimal)(this[this.tableDataTable1.palm_amtColumn])); } catch (global::System.InvalidCastException e) { throw new global::System.Data.StrongTypingException("The value for column \'palm_amt\' in table \'DataTable1\' is DBNull.", e); } } set { this[this.tableDataTable1.palm_amtColumn] = value; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public decimal palm_balamt { get { try { return ((decimal)(this[this.tableDataTable1.palm_balamtColumn])); } catch (global::System.InvalidCastException e) { throw new global::System.Data.StrongTypingException("The value for column \'palm_balamt\' in table \'DataTable1\' is DBNull.", e); } } set { this[this.tableDataTable1.palm_balamtColumn] = value; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public decimal donate_amt { get { try { return ((decimal)(this[this.tableDataTable1.donate_amtColumn])); } catch (global::System.InvalidCastException e) { throw new global::System.Data.StrongTypingException("The value for column \'donate_amt\' in table \'DataTable1\' is DBNull.", e); } } set { this[this.tableDataTable1.donate_amtColumn] = value; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public decimal donate_balamt { get { try { return ((decimal)(this[this.tableDataTable1.donate_balamtColumn])); } catch (global::System.InvalidCastException e) { throw new global::System.Data.StrongTypingException("The value for column \'donate_balamt\' in table \'DataTable1\' is DBNull.", e); } } set { this[this.tableDataTable1.donate_balamtColumn] = value; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public decimal shr_amt { get { try { return ((decimal)(this[this.tableDataTable1.shr_amtColumn])); } catch (global::System.InvalidCastException e) { throw new global::System.Data.StrongTypingException("The value for column \'shr_amt\' in table \'DataTable1\' is DBNull.", e); } } set { this[this.tableDataTable1.shr_amtColumn] = value; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public decimal shr_balamt { get { try { return ((decimal)(this[this.tableDataTable1.shr_balamtColumn])); } catch (global::System.InvalidCastException e) { throw new global::System.Data.StrongTypingException("The value for column \'shr_balamt\' in table \'DataTable1\' is DBNull.", e); } } set { this[this.tableDataTable1.shr_balamtColumn] = value; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public decimal kathin_amt { get { try { return ((decimal)(this[this.tableDataTable1.kathin_amtColumn])); } catch (global::System.InvalidCastException e) { throw new global::System.Data.StrongTypingException("The value for column \'kathin_amt\' in table \'DataTable1\' is DBNull.", e); } } set { this[this.tableDataTable1.kathin_amtColumn] = value; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public decimal kathin_balamt { get { try { return ((decimal)(this[this.tableDataTable1.kathin_balamtColumn])); } catch (global::System.InvalidCastException e) { throw new global::System.Data.StrongTypingException("The value for column \'kathin_balamt\' in table \'DataTable1\' is DBNull.", e); } } set { this[this.tableDataTable1.kathin_balamtColumn] = value; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public decimal int_amt { get { try { return ((decimal)(this[this.tableDataTable1.int_amtColumn])); } catch (global::System.InvalidCastException e) { throw new global::System.Data.StrongTypingException("The value for column \'int_amt\' in table \'DataTable1\' is DBNull.", e); } } set { this[this.tableDataTable1.int_amtColumn] = value; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public decimal int_balamt { get { try { return ((decimal)(this[this.tableDataTable1.int_balamtColumn])); } catch (global::System.InvalidCastException e) { throw new global::System.Data.StrongTypingException("The value for column \'int_balamt\' in table \'DataTable1\' is DBNull.", e); } } set { this[this.tableDataTable1.int_balamtColumn] = value; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public decimal total_amt { get { try { return ((decimal)(this[this.tableDataTable1.total_amtColumn])); } catch (global::System.InvalidCastException e) { throw new global::System.Data.StrongTypingException("The value for column \'total_amt\' in table \'DataTable1\' is DBNull.", e); } } set { this[this.tableDataTable1.total_amtColumn] = value; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public decimal total_balamt { get { try { return ((decimal)(this[this.tableDataTable1.total_balamtColumn])); } catch (global::System.InvalidCastException e) { throw new global::System.Data.StrongTypingException("The value for column \'total_balamt\' in table \'DataTable1\' is DBNull.", e); } } set { this[this.tableDataTable1.total_balamtColumn] = value; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public decimal bfint_arrear { get { try { return ((decimal)(this[this.tableDataTable1.bfint_arrearColumn])); } catch (global::System.InvalidCastException e) { throw new global::System.Data.StrongTypingException("The value for column \'bfint_arrear\' in table \'DataTable1\' is DBNull.", e); } } set { this[this.tableDataTable1.bfint_arrearColumn] = value; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public decimal tran_amt { get { try { return ((decimal)(this[this.tableDataTable1.tran_amtColumn])); } catch (global::System.InvalidCastException e) { throw new global::System.Data.StrongTypingException("The value for column \'tran_amt\' in table \'DataTable1\' is DBNull.", e); } } set { this[this.tableDataTable1.tran_amtColumn] = value; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public decimal mini_amt { get { try { return ((decimal)(this[this.tableDataTable1.mini_amtColumn])); } catch (global::System.InvalidCastException e) { throw new global::System.Data.StrongTypingException("The value for column \'mini_amt\' in table \'DataTable1\' is DBNull.", e); } } set { this[this.tableDataTable1.mini_amtColumn] = value; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public decimal tranout_amt { get { try { return ((decimal)(this[this.tableDataTable1.tranout_amtColumn])); } catch (global::System.InvalidCastException e) { throw new global::System.Data.StrongTypingException("The value for column \'tranout_amt\' in table \'DataTable1\' is DBNull.", e); } } set { this[this.tableDataTable1.tranout_amtColumn] = value; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public string deptaccount_no { get { try { return ((string)(this[this.tableDataTable1.deptaccount_noColumn])); } catch (global::System.InvalidCastException e) { throw new global::System.Data.StrongTypingException("The value for column \'deptaccount_no\' in table \'DataTable1\' is DBNull.", e); } } set { this[this.tableDataTable1.deptaccount_noColumn] = value; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public bool IsAVG_BALAMTNull() { return this.IsNull(this.tableDataTable1.AVG_BALAMTColumn); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public void SetAVG_BALAMTNull() { this[this.tableDataTable1.AVG_BALAMTColumn] = global::System.Convert.DBNull; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public bool IsETC_AMTNull() { return this.IsNull(this.tableDataTable1.ETC_AMTColumn); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public void SetETC_AMTNull() { this[this.tableDataTable1.ETC_AMTColumn] = global::System.Convert.DBNull; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public bool IsETC_BALAMTNull() { return this.IsNull(this.tableDataTable1.ETC_BALAMTColumn); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public void SetETC_BALAMTNull() { this[this.tableDataTable1.ETC_BALAMTColumn] = global::System.Convert.DBNull; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public bool IsAVG_AMTNull() { return this.IsNull(this.tableDataTable1.AVG_AMTColumn); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public void SetAVG_AMTNull() { this[this.tableDataTable1.AVG_AMTColumn] = global::System.Convert.DBNull; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public bool IsITEM_BALAMTNull() { return this.IsNull(this.tableDataTable1.ITEM_BALAMTColumn); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public void SetITEM_BALAMTNull() { this[this.tableDataTable1.ITEM_BALAMTColumn] = global::System.Convert.DBNull; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public bool IsDIV_AMTNull() { return this.IsNull(this.tableDataTable1.DIV_AMTColumn); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public void SetDIV_AMTNull() { this[this.tableDataTable1.DIV_AMTColumn] = global::System.Convert.DBNull; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public bool IsDIV_BALAMTNull() { return this.IsNull(this.tableDataTable1.DIV_BALAMTColumn); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public void SetDIV_BALAMTNull() { this[this.tableDataTable1.DIV_BALAMTColumn] = global::System.Convert.DBNull; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public bool Ismkbuy_amtNull() { return this.IsNull(this.tableDataTable1.mkbuy_amtColumn); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public void Setmkbuy_amtNull() { this[this.tableDataTable1.mkbuy_amtColumn] = global::System.Convert.DBNull; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public bool Ismkbuy_balamtNull() { return this.IsNull(this.tableDataTable1.mkbuy_balamtColumn); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public void Setmkbuy_balamtNull() { this[this.tableDataTable1.mkbuy_balamtColumn] = global::System.Convert.DBNull; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public bool Ismksale_amtNull() { return this.IsNull(this.tableDataTable1.mksale_amtColumn); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public void Setmksale_amtNull() { this[this.tableDataTable1.mksale_amtColumn] = global::System.Convert.DBNull; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public bool Ismksale_balamtNull() { return this.IsNull(this.tableDataTable1.mksale_balamtColumn); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public void Setmksale_balamtNull() { this[this.tableDataTable1.mksale_balamtColumn] = global::System.Convert.DBNull; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public bool Isoil_amtNull() { return this.IsNull(this.tableDataTable1.oil_amtColumn); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public void Setoil_amtNull() { this[this.tableDataTable1.oil_amtColumn] = global::System.Convert.DBNull; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public bool Isoil_balamtNull() { return this.IsNull(this.tableDataTable1.oil_balamtColumn); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public void Setoil_balamtNull() { this[this.tableDataTable1.oil_balamtColumn] = global::System.Convert.DBNull; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public bool Ispalm_amtNull() { return this.IsNull(this.tableDataTable1.palm_amtColumn); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public void Setpalm_amtNull() { this[this.tableDataTable1.palm_amtColumn] = global::System.Convert.DBNull; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public bool Ispalm_balamtNull() { return this.IsNull(this.tableDataTable1.palm_balamtColumn); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public void Setpalm_balamtNull() { this[this.tableDataTable1.palm_balamtColumn] = global::System.Convert.DBNull; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public bool Isdonate_amtNull() { return this.IsNull(this.tableDataTable1.donate_amtColumn); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public void Setdonate_amtNull() { this[this.tableDataTable1.donate_amtColumn] = global::System.Convert.DBNull; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public bool Isdonate_balamtNull() { return this.IsNull(this.tableDataTable1.donate_balamtColumn); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public void Setdonate_balamtNull() { this[this.tableDataTable1.donate_balamtColumn] = global::System.Convert.DBNull; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public bool Isshr_amtNull() { return this.IsNull(this.tableDataTable1.shr_amtColumn); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public void Setshr_amtNull() { this[this.tableDataTable1.shr_amtColumn] = global::System.Convert.DBNull; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public bool Isshr_balamtNull() { return this.IsNull(this.tableDataTable1.shr_balamtColumn); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public void Setshr_balamtNull() { this[this.tableDataTable1.shr_balamtColumn] = global::System.Convert.DBNull; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public bool Iskathin_amtNull() { return this.IsNull(this.tableDataTable1.kathin_amtColumn); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public void Setkathin_amtNull() { this[this.tableDataTable1.kathin_amtColumn] = global::System.Convert.DBNull; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public bool Iskathin_balamtNull() { return this.IsNull(this.tableDataTable1.kathin_balamtColumn); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public void Setkathin_balamtNull() { this[this.tableDataTable1.kathin_balamtColumn] = global::System.Convert.DBNull; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public bool Isint_amtNull() { return this.IsNull(this.tableDataTable1.int_amtColumn); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public void Setint_amtNull() { this[this.tableDataTable1.int_amtColumn] = global::System.Convert.DBNull; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public bool Isint_balamtNull() { return this.IsNull(this.tableDataTable1.int_balamtColumn); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public void Setint_balamtNull() { this[this.tableDataTable1.int_balamtColumn] = global::System.Convert.DBNull; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public bool Istotal_amtNull() { return this.IsNull(this.tableDataTable1.total_amtColumn); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public void Settotal_amtNull() { this[this.tableDataTable1.total_amtColumn] = global::System.Convert.DBNull; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public bool Istotal_balamtNull() { return this.IsNull(this.tableDataTable1.total_balamtColumn); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public void Settotal_balamtNull() { this[this.tableDataTable1.total_balamtColumn] = global::System.Convert.DBNull; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public bool Isbfint_arrearNull() { return this.IsNull(this.tableDataTable1.bfint_arrearColumn); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public void Setbfint_arrearNull() { this[this.tableDataTable1.bfint_arrearColumn] = global::System.Convert.DBNull; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public bool Istran_amtNull() { return this.IsNull(this.tableDataTable1.tran_amtColumn); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public void Settran_amtNull() { this[this.tableDataTable1.tran_amtColumn] = global::System.Convert.DBNull; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public bool Ismini_amtNull() { return this.IsNull(this.tableDataTable1.mini_amtColumn); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public void Setmini_amtNull() { this[this.tableDataTable1.mini_amtColumn] = global::System.Convert.DBNull; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public bool Istranout_amtNull() { return this.IsNull(this.tableDataTable1.tranout_amtColumn); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public void Settranout_amtNull() { this[this.tableDataTable1.tranout_amtColumn] = global::System.Convert.DBNull; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public bool Isdeptaccount_noNull() { return this.IsNull(this.tableDataTable1.deptaccount_noColumn); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public void Setdeptaccount_noNull() { this[this.tableDataTable1.deptaccount_noColumn] = global::System.Convert.DBNull; } } /// ///Represents strongly named DataRow class. /// public partial class YRDIVMASTERRow : global::System.Data.DataRow { private YRDIVMASTERDataTable tableYRDIVMASTER; [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] internal YRDIVMASTERRow(global::System.Data.DataRowBuilder rb) : base(rb) { this.tableYRDIVMASTER = ((YRDIVMASTERDataTable)(this.Table)); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public string COOP_ID { get { return ((string)(this[this.tableYRDIVMASTER.COOP_IDColumn])); } set { this[this.tableYRDIVMASTER.COOP_IDColumn] = value; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public string MEMBER_NO { get { return ((string)(this[this.tableYRDIVMASTER.MEMBER_NOColumn])); } set { this[this.tableYRDIVMASTER.MEMBER_NOColumn] = value; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public string DIV_YEAR { get { return ((string)(this[this.tableYRDIVMASTER.DIV_YEARColumn])); } set { this[this.tableYRDIVMASTER.DIV_YEARColumn] = value; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public decimal DIV_AMT { get { try { return ((decimal)(this[this.tableYRDIVMASTER.DIV_AMTColumn])); } catch (global::System.InvalidCastException e) { throw new global::System.Data.StrongTypingException("The value for column \'DIV_AMT\' in table \'YRDIVMASTER\' is DBNull.", e); } } set { this[this.tableYRDIVMASTER.DIV_AMTColumn] = value; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public decimal DIV_BALAMT { get { try { return ((decimal)(this[this.tableYRDIVMASTER.DIV_BALAMTColumn])); } catch (global::System.InvalidCastException e) { throw new global::System.Data.StrongTypingException("The value for column \'DIV_BALAMT\' in table \'YRDIVMASTER\' is DBNull.", e); } } set { this[this.tableYRDIVMASTER.DIV_BALAMTColumn] = value; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public decimal AVG_AMT { get { try { return ((decimal)(this[this.tableYRDIVMASTER.AVG_AMTColumn])); } catch (global::System.InvalidCastException e) { throw new global::System.Data.StrongTypingException("The value for column \'AVG_AMT\' in table \'YRDIVMASTER\' is DBNull.", e); } } set { this[this.tableYRDIVMASTER.AVG_AMTColumn] = value; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public decimal AVG_BALAMT { get { try { return ((decimal)(this[this.tableYRDIVMASTER.AVG_BALAMTColumn])); } catch (global::System.InvalidCastException e) { throw new global::System.Data.StrongTypingException("The value for column \'AVG_BALAMT\' in table \'YRDIVMASTER\' is DBNull.", e); } } set { this[this.tableYRDIVMASTER.AVG_BALAMTColumn] = value; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public decimal ETC_AMT { get { try { return ((decimal)(this[this.tableYRDIVMASTER.ETC_AMTColumn])); } catch (global::System.InvalidCastException e) { throw new global::System.Data.StrongTypingException("The value for column \'ETC_AMT\' in table \'YRDIVMASTER\' is DBNull.", e); } } set { this[this.tableYRDIVMASTER.ETC_AMTColumn] = value; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public decimal ETC_BALAMT { get { try { return ((decimal)(this[this.tableYRDIVMASTER.ETC_BALAMTColumn])); } catch (global::System.InvalidCastException e) { throw new global::System.Data.StrongTypingException("The value for column \'ETC_BALAMT\' in table \'YRDIVMASTER\' is DBNull.", e); } } set { this[this.tableYRDIVMASTER.ETC_BALAMTColumn] = value; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public decimal ITEM_BALAMT { get { try { return ((decimal)(this[this.tableYRDIVMASTER.ITEM_BALAMTColumn])); } catch (global::System.InvalidCastException e) { throw new global::System.Data.StrongTypingException("The value for column \'ITEM_BALAMT\' in table \'YRDIVMASTER\' is DBNull.", e); } } set { this[this.tableYRDIVMASTER.ITEM_BALAMTColumn] = value; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public decimal SHOP1_AMT { get { try { return ((decimal)(this[this.tableYRDIVMASTER.SHOP1_AMTColumn])); } catch (global::System.InvalidCastException e) { throw new global::System.Data.StrongTypingException("The value for column \'SHOP1_AMT\' in table \'YRDIVMASTER\' is DBNull.", e); } } set { this[this.tableYRDIVMASTER.SHOP1_AMTColumn] = value; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public decimal SHOP2_AMT { get { try { return ((decimal)(this[this.tableYRDIVMASTER.SHOP2_AMTColumn])); } catch (global::System.InvalidCastException e) { throw new global::System.Data.StrongTypingException("The value for column \'SHOP2_AMT\' in table \'YRDIVMASTER\' is DBNull.", e); } } set { this[this.tableYRDIVMASTER.SHOP2_AMTColumn] = value; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public decimal OIL_AMT { get { try { return ((decimal)(this[this.tableYRDIVMASTER.OIL_AMTColumn])); } catch (global::System.InvalidCastException e) { throw new global::System.Data.StrongTypingException("The value for column \'OIL_AMT\' in table \'YRDIVMASTER\' is DBNull.", e); } } set { this[this.tableYRDIVMASTER.OIL_AMTColumn] = value; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public decimal SHOP1_BALAMT { get { try { return ((decimal)(this[this.tableYRDIVMASTER.SHOP1_BALAMTColumn])); } catch (global::System.InvalidCastException e) { throw new global::System.Data.StrongTypingException("The value for column \'SHOP1_BALAMT\' in table \'YRDIVMASTER\' is DBNull.", e); } } set { this[this.tableYRDIVMASTER.SHOP1_BALAMTColumn] = value; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public decimal SHOP2_BALAMT { get { try { return ((decimal)(this[this.tableYRDIVMASTER.SHOP2_BALAMTColumn])); } catch (global::System.InvalidCastException e) { throw new global::System.Data.StrongTypingException("The value for column \'SHOP2_BALAMT\' in table \'YRDIVMASTER\' is DBNull.", e); } } set { this[this.tableYRDIVMASTER.SHOP2_BALAMTColumn] = value; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public decimal OIL_BALAMT { get { try { return ((decimal)(this[this.tableYRDIVMASTER.OIL_BALAMTColumn])); } catch (global::System.InvalidCastException e) { throw new global::System.Data.StrongTypingException("The value for column \'OIL_BALAMT\' in table \'YRDIVMASTER\' is DBNull.", e); } } set { this[this.tableYRDIVMASTER.OIL_BALAMTColumn] = value; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public decimal RICE_AMT { get { try { return ((decimal)(this[this.tableYRDIVMASTER.RICE_AMTColumn])); } catch (global::System.InvalidCastException e) { throw new global::System.Data.StrongTypingException("The value for column \'RICE_AMT\' in table \'YRDIVMASTER\' is DBNull.", e); } } set { this[this.tableYRDIVMASTER.RICE_AMTColumn] = value; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public decimal RICE_BALAMT { get { try { return ((decimal)(this[this.tableYRDIVMASTER.RICE_BALAMTColumn])); } catch (global::System.InvalidCastException e) { throw new global::System.Data.StrongTypingException("The value for column \'RICE_BALAMT\' in table \'YRDIVMASTER\' is DBNull.", e); } } set { this[this.tableYRDIVMASTER.RICE_BALAMTColumn] = value; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public decimal DEPT_AMT { get { try { return ((decimal)(this[this.tableYRDIVMASTER.DEPT_AMTColumn])); } catch (global::System.InvalidCastException e) { throw new global::System.Data.StrongTypingException("The value for column \'DEPT_AMT\' in table \'YRDIVMASTER\' is DBNull.", e); } } set { this[this.tableYRDIVMASTER.DEPT_AMTColumn] = value; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public decimal LOANLAW_AMT { get { try { return ((decimal)(this[this.tableYRDIVMASTER.LOANLAW_AMTColumn])); } catch (global::System.InvalidCastException e) { throw new global::System.Data.StrongTypingException("The value for column \'LOANLAW_AMT\' in table \'YRDIVMASTER\' is DBNull.", e); } } set { this[this.tableYRDIVMASTER.LOANLAW_AMTColumn] = value; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public decimal SHR_AMT { get { try { return ((decimal)(this[this.tableYRDIVMASTER.SHR_AMTColumn])); } catch (global::System.InvalidCastException e) { throw new global::System.Data.StrongTypingException("The value for column \'SHR_AMT\' in table \'YRDIVMASTER\' is DBNull.", e); } } set { this[this.tableYRDIVMASTER.SHR_AMTColumn] = value; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public string deptaccount_no { get { try { return ((string)(this[this.tableYRDIVMASTER.deptaccount_noColumn])); } catch (global::System.InvalidCastException e) { throw new global::System.Data.StrongTypingException("The value for column \'deptaccount_no\' in table \'YRDIVMASTER\' is DBNull.", e); } } set { this[this.tableYRDIVMASTER.deptaccount_noColumn] = value; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public decimal total_amt { get { try { return ((decimal)(this[this.tableYRDIVMASTER.total_amtColumn])); } catch (global::System.InvalidCastException e) { throw new global::System.Data.StrongTypingException("The value for column \'total_amt\' in table \'YRDIVMASTER\' is DBNull.", e); } } set { this[this.tableYRDIVMASTER.total_amtColumn] = value; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public decimal loan_amt { get { try { return ((decimal)(this[this.tableYRDIVMASTER.loan_amtColumn])); } catch (global::System.InvalidCastException e) { throw new global::System.Data.StrongTypingException("The value for column \'loan_amt\' in table \'YRDIVMASTER\' is DBNull.", e); } } set { this[this.tableYRDIVMASTER.loan_amtColumn] = value; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public decimal NOTIS_AMT { get { try { return ((decimal)(this[this.tableYRDIVMASTER.NOTIS_AMTColumn])); } catch (global::System.InvalidCastException e) { throw new global::System.Data.StrongTypingException("The value for column \'NOTIS_AMT\' in table \'YRDIVMASTER\' is DBNull.", e); } } set { this[this.tableYRDIVMASTER.NOTIS_AMTColumn] = value; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public string REMARK { get { try { return ((string)(this[this.tableYRDIVMASTER.REMARKColumn])); } catch (global::System.InvalidCastException e) { throw new global::System.Data.StrongTypingException("The value for column \'REMARK\' in table \'YRDIVMASTER\' is DBNull.", e); } } set { this[this.tableYRDIVMASTER.REMARKColumn] = value; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public bool IsDIV_AMTNull() { return this.IsNull(this.tableYRDIVMASTER.DIV_AMTColumn); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public void SetDIV_AMTNull() { this[this.tableYRDIVMASTER.DIV_AMTColumn] = global::System.Convert.DBNull; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public bool IsDIV_BALAMTNull() { return this.IsNull(this.tableYRDIVMASTER.DIV_BALAMTColumn); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public void SetDIV_BALAMTNull() { this[this.tableYRDIVMASTER.DIV_BALAMTColumn] = global::System.Convert.DBNull; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public bool IsAVG_AMTNull() { return this.IsNull(this.tableYRDIVMASTER.AVG_AMTColumn); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public void SetAVG_AMTNull() { this[this.tableYRDIVMASTER.AVG_AMTColumn] = global::System.Convert.DBNull; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public bool IsAVG_BALAMTNull() { return this.IsNull(this.tableYRDIVMASTER.AVG_BALAMTColumn); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public void SetAVG_BALAMTNull() { this[this.tableYRDIVMASTER.AVG_BALAMTColumn] = global::System.Convert.DBNull; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public bool IsETC_AMTNull() { return this.IsNull(this.tableYRDIVMASTER.ETC_AMTColumn); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public void SetETC_AMTNull() { this[this.tableYRDIVMASTER.ETC_AMTColumn] = global::System.Convert.DBNull; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public bool IsETC_BALAMTNull() { return this.IsNull(this.tableYRDIVMASTER.ETC_BALAMTColumn); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public void SetETC_BALAMTNull() { this[this.tableYRDIVMASTER.ETC_BALAMTColumn] = global::System.Convert.DBNull; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public bool IsITEM_BALAMTNull() { return this.IsNull(this.tableYRDIVMASTER.ITEM_BALAMTColumn); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public void SetITEM_BALAMTNull() { this[this.tableYRDIVMASTER.ITEM_BALAMTColumn] = global::System.Convert.DBNull; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public bool IsSHOP1_AMTNull() { return this.IsNull(this.tableYRDIVMASTER.SHOP1_AMTColumn); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public void SetSHOP1_AMTNull() { this[this.tableYRDIVMASTER.SHOP1_AMTColumn] = global::System.Convert.DBNull; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public bool IsSHOP2_AMTNull() { return this.IsNull(this.tableYRDIVMASTER.SHOP2_AMTColumn); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public void SetSHOP2_AMTNull() { this[this.tableYRDIVMASTER.SHOP2_AMTColumn] = global::System.Convert.DBNull; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public bool IsOIL_AMTNull() { return this.IsNull(this.tableYRDIVMASTER.OIL_AMTColumn); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public void SetOIL_AMTNull() { this[this.tableYRDIVMASTER.OIL_AMTColumn] = global::System.Convert.DBNull; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public bool IsSHOP1_BALAMTNull() { return this.IsNull(this.tableYRDIVMASTER.SHOP1_BALAMTColumn); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public void SetSHOP1_BALAMTNull() { this[this.tableYRDIVMASTER.SHOP1_BALAMTColumn] = global::System.Convert.DBNull; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public bool IsSHOP2_BALAMTNull() { return this.IsNull(this.tableYRDIVMASTER.SHOP2_BALAMTColumn); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public void SetSHOP2_BALAMTNull() { this[this.tableYRDIVMASTER.SHOP2_BALAMTColumn] = global::System.Convert.DBNull; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public bool IsOIL_BALAMTNull() { return this.IsNull(this.tableYRDIVMASTER.OIL_BALAMTColumn); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public void SetOIL_BALAMTNull() { this[this.tableYRDIVMASTER.OIL_BALAMTColumn] = global::System.Convert.DBNull; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public bool IsRICE_AMTNull() { return this.IsNull(this.tableYRDIVMASTER.RICE_AMTColumn); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public void SetRICE_AMTNull() { this[this.tableYRDIVMASTER.RICE_AMTColumn] = global::System.Convert.DBNull; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public bool IsRICE_BALAMTNull() { return this.IsNull(this.tableYRDIVMASTER.RICE_BALAMTColumn); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public void SetRICE_BALAMTNull() { this[this.tableYRDIVMASTER.RICE_BALAMTColumn] = global::System.Convert.DBNull; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public bool IsDEPT_AMTNull() { return this.IsNull(this.tableYRDIVMASTER.DEPT_AMTColumn); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public void SetDEPT_AMTNull() { this[this.tableYRDIVMASTER.DEPT_AMTColumn] = global::System.Convert.DBNull; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public bool IsLOANLAW_AMTNull() { return this.IsNull(this.tableYRDIVMASTER.LOANLAW_AMTColumn); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public void SetLOANLAW_AMTNull() { this[this.tableYRDIVMASTER.LOANLAW_AMTColumn] = global::System.Convert.DBNull; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public bool IsSHR_AMTNull() { return this.IsNull(this.tableYRDIVMASTER.SHR_AMTColumn); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public void SetSHR_AMTNull() { this[this.tableYRDIVMASTER.SHR_AMTColumn] = global::System.Convert.DBNull; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public bool Isdeptaccount_noNull() { return this.IsNull(this.tableYRDIVMASTER.deptaccount_noColumn); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public void Setdeptaccount_noNull() { this[this.tableYRDIVMASTER.deptaccount_noColumn] = global::System.Convert.DBNull; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public bool Istotal_amtNull() { return this.IsNull(this.tableYRDIVMASTER.total_amtColumn); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public void Settotal_amtNull() { this[this.tableYRDIVMASTER.total_amtColumn] = global::System.Convert.DBNull; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public bool Isloan_amtNull() { return this.IsNull(this.tableYRDIVMASTER.loan_amtColumn); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public void Setloan_amtNull() { this[this.tableYRDIVMASTER.loan_amtColumn] = global::System.Convert.DBNull; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public bool IsNOTIS_AMTNull() { return this.IsNull(this.tableYRDIVMASTER.NOTIS_AMTColumn); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public void SetNOTIS_AMTNull() { this[this.tableYRDIVMASTER.NOTIS_AMTColumn] = global::System.Convert.DBNull; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public bool IsREMARKNull() { return this.IsNull(this.tableYRDIVMASTER.REMARKColumn); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public void SetREMARKNull() { this[this.tableYRDIVMASTER.REMARKColumn] = global::System.Convert.DBNull; } } /// ///Represents strongly named DataRow class. /// public partial class DT_LOANRow : global::System.Data.DataRow { private DT_LOANDataTable tableDT_LOAN; [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] internal DT_LOANRow(global::System.Data.DataRowBuilder rb) : base(rb) { this.tableDT_LOAN = ((DT_LOANDataTable)(this.Table)); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public string COOP_ID { get { return ((string)(this[this.tableDT_LOAN.COOP_IDColumn])); } set { this[this.tableDT_LOAN.COOP_IDColumn] = value; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public string MEMBER_NO { get { return ((string)(this[this.tableDT_LOAN.MEMBER_NOColumn])); } set { this[this.tableDT_LOAN.MEMBER_NOColumn] = value; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public string DIV_YEAR { get { return ((string)(this[this.tableDT_LOAN.DIV_YEARColumn])); } set { this[this.tableDT_LOAN.DIV_YEARColumn] = value; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public decimal SEQ_NO { get { return ((decimal)(this[this.tableDT_LOAN.SEQ_NOColumn])); } set { this[this.tableDT_LOAN.SEQ_NOColumn] = value; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public string CONCOOP_ID { get { try { return ((string)(this[this.tableDT_LOAN.CONCOOP_IDColumn])); } catch (global::System.InvalidCastException e) { throw new global::System.Data.StrongTypingException("The value for column \'CONCOOP_ID\' in table \'DT_LOAN\' is DBNull.", e); } } set { this[this.tableDT_LOAN.CONCOOP_IDColumn] = value; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public string LOANCONTRACT_NO { get { try { return ((string)(this[this.tableDT_LOAN.LOANCONTRACT_NOColumn])); } catch (global::System.InvalidCastException e) { throw new global::System.Data.StrongTypingException("The value for column \'LOANCONTRACT_NO\' in table \'DT_LOAN\' is DBNull.", e); } } set { this[this.tableDT_LOAN.LOANCONTRACT_NOColumn] = value; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public decimal INTEREST_ACCUM { get { try { return ((decimal)(this[this.tableDT_LOAN.INTEREST_ACCUMColumn])); } catch (global::System.InvalidCastException e) { throw new global::System.Data.StrongTypingException("The value for column \'INTEREST_ACCUM\' in table \'DT_LOAN\' is DBNull.", e); } } set { this[this.tableDT_LOAN.INTEREST_ACCUMColumn] = value; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public decimal MISSPAY_AMT { get { try { return ((decimal)(this[this.tableDT_LOAN.MISSPAY_AMTColumn])); } catch (global::System.InvalidCastException e) { throw new global::System.Data.StrongTypingException("The value for column \'MISSPAY_AMT\' in table \'DT_LOAN\' is DBNull.", e); } } set { this[this.tableDT_LOAN.MISSPAY_AMTColumn] = value; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public decimal AVG_AMT { get { try { return ((decimal)(this[this.tableDT_LOAN.AVG_AMTColumn])); } catch (global::System.InvalidCastException e) { throw new global::System.Data.StrongTypingException("The value for column \'AVG_AMT\' in table \'DT_LOAN\' is DBNull.", e); } } set { this[this.tableDT_LOAN.AVG_AMTColumn] = value; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public decimal RAVG_AMT { get { try { return ((decimal)(this[this.tableDT_LOAN.RAVG_AMTColumn])); } catch (global::System.InvalidCastException e) { throw new global::System.Data.StrongTypingException("The value for column \'RAVG_AMT\' in table \'DT_LOAN\' is DBNull.", e); } } set { this[this.tableDT_LOAN.RAVG_AMTColumn] = value; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public decimal avgpercent_rate { get { try { return ((decimal)(this[this.tableDT_LOAN.avgpercent_rateColumn])); } catch (global::System.InvalidCastException e) { throw new global::System.Data.StrongTypingException("The value for column \'avgpercent_rate\' in table \'DT_LOAN\' is DBNull.", e); } } set { this[this.tableDT_LOAN.avgpercent_rateColumn] = value; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public bool IsCONCOOP_IDNull() { return this.IsNull(this.tableDT_LOAN.CONCOOP_IDColumn); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public void SetCONCOOP_IDNull() { this[this.tableDT_LOAN.CONCOOP_IDColumn] = global::System.Convert.DBNull; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public bool IsLOANCONTRACT_NONull() { return this.IsNull(this.tableDT_LOAN.LOANCONTRACT_NOColumn); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public void SetLOANCONTRACT_NONull() { this[this.tableDT_LOAN.LOANCONTRACT_NOColumn] = global::System.Convert.DBNull; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public bool IsINTEREST_ACCUMNull() { return this.IsNull(this.tableDT_LOAN.INTEREST_ACCUMColumn); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public void SetINTEREST_ACCUMNull() { this[this.tableDT_LOAN.INTEREST_ACCUMColumn] = global::System.Convert.DBNull; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public bool IsMISSPAY_AMTNull() { return this.IsNull(this.tableDT_LOAN.MISSPAY_AMTColumn); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public void SetMISSPAY_AMTNull() { this[this.tableDT_LOAN.MISSPAY_AMTColumn] = global::System.Convert.DBNull; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public bool IsAVG_AMTNull() { return this.IsNull(this.tableDT_LOAN.AVG_AMTColumn); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public void SetAVG_AMTNull() { this[this.tableDT_LOAN.AVG_AMTColumn] = global::System.Convert.DBNull; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public bool IsRAVG_AMTNull() { return this.IsNull(this.tableDT_LOAN.RAVG_AMTColumn); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public void SetRAVG_AMTNull() { this[this.tableDT_LOAN.RAVG_AMTColumn] = global::System.Convert.DBNull; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public bool Isavgpercent_rateNull() { return this.IsNull(this.tableDT_LOAN.avgpercent_rateColumn); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public void Setavgpercent_rateNull() { this[this.tableDT_LOAN.avgpercent_rateColumn] = global::System.Convert.DBNull; } } /// ///Row event argument class /// [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public class DataTable1RowChangeEvent : global::System.EventArgs { private DataTable1Row eventRow; private global::System.Data.DataRowAction eventAction; [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public DataTable1RowChangeEvent(DataTable1Row row, global::System.Data.DataRowAction action) { this.eventRow = row; this.eventAction = action; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public DataTable1Row Row { get { return this.eventRow; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public global::System.Data.DataRowAction Action { get { return this.eventAction; } } } /// ///Row event argument class /// [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public class YRDIVMASTERRowChangeEvent : global::System.EventArgs { private YRDIVMASTERRow eventRow; private global::System.Data.DataRowAction eventAction; [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public YRDIVMASTERRowChangeEvent(YRDIVMASTERRow row, global::System.Data.DataRowAction action) { this.eventRow = row; this.eventAction = action; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public YRDIVMASTERRow Row { get { return this.eventRow; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public global::System.Data.DataRowAction Action { get { return this.eventAction; } } } /// ///Row event argument class /// [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public class DT_LOANRowChangeEvent : global::System.EventArgs { private DT_LOANRow eventRow; private global::System.Data.DataRowAction eventAction; [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public DT_LOANRowChangeEvent(DT_LOANRow row, global::System.Data.DataRowAction action) { this.eventRow = row; this.eventAction = action; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public DT_LOANRow Row { get { return this.eventRow; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public global::System.Data.DataRowAction Action { get { return this.eventAction; } } } } } namespace Saving.Applications.divavg.ws_divsrv_req_methpay_ytk_ctrl.DataSet1TableAdapters { /// ///Represents the connection and commands used to retrieve and save data. /// [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=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a")] [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")] public partial class DataTable1TableAdapter : global::System.ComponentModel.Component { private global::System.Data.Odbc.OdbcDataAdapter _adapter; private global::System.Data.Odbc.OdbcConnection _connection; private global::System.Data.Odbc.OdbcTransaction _transaction; private global::System.Data.Odbc.OdbcCommand[] _commandCollection; private bool _clearBeforeFill; [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public DataTable1TableAdapter() { this.ClearBeforeFill = true; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] protected internal global::System.Data.Odbc.OdbcDataAdapter Adapter { get { if ((this._adapter == null)) { this.InitAdapter(); } return this._adapter; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] internal global::System.Data.Odbc.OdbcConnection 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.Odbc.OdbcCommand)(this.CommandCollection[i])).Connection = value; } } } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] internal global::System.Data.Odbc.OdbcTransaction Transaction { get { return this._transaction; } set { this._transaction = value; for (int i = 0; (i < this.CommandCollection.Length); i = (i + 1)) { this.CommandCollection[i].Transaction = this._transaction; } if (((this.Adapter != null) && (this.Adapter.DeleteCommand != null))) { this.Adapter.DeleteCommand.Transaction = this._transaction; } if (((this.Adapter != null) && (this.Adapter.InsertCommand != null))) { this.Adapter.InsertCommand.Transaction = this._transaction; } if (((this.Adapter != null) && (this.Adapter.UpdateCommand != null))) { this.Adapter.UpdateCommand.Transaction = this._transaction; } } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] protected global::System.Data.Odbc.OdbcCommand[] CommandCollection { get { if ((this._commandCollection == null)) { this.InitCommandCollection(); } return this._commandCollection; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public bool ClearBeforeFill { get { return this._clearBeforeFill; } set { this._clearBeforeFill = value; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] private void InitAdapter() { this._adapter = new global::System.Data.Odbc.OdbcDataAdapter(); global::System.Data.Common.DataTableMapping tableMapping = new global::System.Data.Common.DataTableMapping(); tableMapping.SourceTable = "Table"; tableMapping.DataSetTable = "DataTable1"; tableMapping.ColumnMappings.Add("DIV_YEAR", "DIV_YEAR"); tableMapping.ColumnMappings.Add("MEMBER_NO", "MEMBER_NO"); tableMapping.ColumnMappings.Add("COOP_ID", "COOP_ID"); tableMapping.ColumnMappings.Add("AVG_BALAMT", "AVG_BALAMT"); tableMapping.ColumnMappings.Add("ETC_AMT", "ETC_AMT"); tableMapping.ColumnMappings.Add("ETC_BALAMT", "ETC_BALAMT"); tableMapping.ColumnMappings.Add("AVG_AMT", "AVG_AMT"); tableMapping.ColumnMappings.Add("ITEM_BALAMT", "ITEM_BALAMT"); tableMapping.ColumnMappings.Add("DIV_AMT", "DIV_AMT"); tableMapping.ColumnMappings.Add("DIV_BALAMT", "DIV_BALAMT"); tableMapping.ColumnMappings.Add("mkbuy_amt", "mkbuy_amt"); tableMapping.ColumnMappings.Add("mkbuy_balamt", "mkbuy_balamt"); tableMapping.ColumnMappings.Add("mksale_amt", "mksale_amt"); tableMapping.ColumnMappings.Add("mksale_balamt", "mksale_balamt"); tableMapping.ColumnMappings.Add("oil_amt", "oil_amt"); tableMapping.ColumnMappings.Add("oil_balamt", "oil_balamt"); tableMapping.ColumnMappings.Add("palm_amt", "palm_amt"); tableMapping.ColumnMappings.Add("palm_balamt", "palm_balamt"); tableMapping.ColumnMappings.Add("donate_amt", "donate_amt"); tableMapping.ColumnMappings.Add("donate_balamt", "donate_balamt"); tableMapping.ColumnMappings.Add("shr_amt", "shr_amt"); tableMapping.ColumnMappings.Add("shr_balamt", "shr_balamt"); tableMapping.ColumnMappings.Add("kathin_amt", "kathin_amt"); tableMapping.ColumnMappings.Add("kathin_balamt", "kathin_balamt"); tableMapping.ColumnMappings.Add("int_amt", "int_amt"); tableMapping.ColumnMappings.Add("int_balamt", "int_balamt"); tableMapping.ColumnMappings.Add("total_amt", "total_amt"); tableMapping.ColumnMappings.Add("total_balamt", "total_balamt"); this._adapter.TableMappings.Add(tableMapping); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] private void InitConnection() { this._connection = new global::System.Data.Odbc.OdbcConnection(); this._connection.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["ConnectionString2"].ConnectionString; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] private void InitCommandCollection() { this._commandCollection = new global::System.Data.Odbc.OdbcCommand[1]; this._commandCollection[0] = new global::System.Data.Odbc.OdbcCommand(); this._commandCollection[0].Connection = this.Connection; this._commandCollection[0].CommandText = "select * from yrdivmaster"; this._commandCollection[0].CommandType = global::System.Data.CommandType.Text; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")] [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Fill, true)] public virtual int Fill(DataSet1.DataTable1DataTable 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.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")] [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Select, true)] public virtual DataSet1.DataTable1DataTable GetData() { this.Adapter.SelectCommand = this.CommandCollection[0]; DataSet1.DataTable1DataTable dataTable = new DataSet1.DataTable1DataTable(); this.Adapter.Fill(dataTable); return dataTable; } } /// ///Represents the connection and commands used to retrieve and save data. /// [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=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a")] [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")] public partial class YRDIVMASTERTableAdapter : global::System.ComponentModel.Component { private global::System.Data.OracleClient.OracleDataAdapter _adapter; private global::System.Data.OracleClient.OracleConnection _connection; private global::System.Data.OracleClient.OracleTransaction _transaction; private global::System.Data.OracleClient.OracleCommand[] _commandCollection; private bool _clearBeforeFill; [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public YRDIVMASTERTableAdapter() { this.ClearBeforeFill = true; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] protected internal global::System.Data.OracleClient.OracleDataAdapter Adapter { get { if ((this._adapter == null)) { this.InitAdapter(); } return this._adapter; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] internal global::System.Data.OracleClient.OracleConnection 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.OracleClient.OracleCommand)(this.CommandCollection[i])).Connection = value; } } } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] internal global::System.Data.OracleClient.OracleTransaction Transaction { get { return this._transaction; } set { this._transaction = value; for (int i = 0; (i < this.CommandCollection.Length); i = (i + 1)) { this.CommandCollection[i].Transaction = this._transaction; } if (((this.Adapter != null) && (this.Adapter.DeleteCommand != null))) { this.Adapter.DeleteCommand.Transaction = this._transaction; } if (((this.Adapter != null) && (this.Adapter.InsertCommand != null))) { this.Adapter.InsertCommand.Transaction = this._transaction; } if (((this.Adapter != null) && (this.Adapter.UpdateCommand != null))) { this.Adapter.UpdateCommand.Transaction = this._transaction; } } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] protected global::System.Data.OracleClient.OracleCommand[] CommandCollection { get { if ((this._commandCollection == null)) { this.InitCommandCollection(); } return this._commandCollection; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public bool ClearBeforeFill { get { return this._clearBeforeFill; } set { this._clearBeforeFill = value; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] private void InitAdapter() { this._adapter = new global::System.Data.OracleClient.OracleDataAdapter(); global::System.Data.Common.DataTableMapping tableMapping = new global::System.Data.Common.DataTableMapping(); tableMapping.SourceTable = "Table"; tableMapping.DataSetTable = "YRDIVMASTER"; tableMapping.ColumnMappings.Add("COOP_ID", "COOP_ID"); tableMapping.ColumnMappings.Add("MEMBER_NO", "MEMBER_NO"); tableMapping.ColumnMappings.Add("DIV_YEAR", "DIV_YEAR"); tableMapping.ColumnMappings.Add("DIV_AMT", "DIV_AMT"); tableMapping.ColumnMappings.Add("DIV_BALAMT", "DIV_BALAMT"); tableMapping.ColumnMappings.Add("AVG_AMT", "AVG_AMT"); tableMapping.ColumnMappings.Add("AVG_BALAMT", "AVG_BALAMT"); tableMapping.ColumnMappings.Add("ETC_AMT", "ETC_AMT"); tableMapping.ColumnMappings.Add("ETC_BALAMT", "ETC_BALAMT"); tableMapping.ColumnMappings.Add("ITEM_BALAMT", "ITEM_BALAMT"); tableMapping.ColumnMappings.Add("SHOP1_AMT", "SHOP1_AMT"); tableMapping.ColumnMappings.Add("SHOP2_AMT", "SHOP2_AMT"); tableMapping.ColumnMappings.Add("OIL_AMT", "OIL_AMT"); tableMapping.ColumnMappings.Add("SHOP1_BALAMT", "SHOP1_BALAMT"); tableMapping.ColumnMappings.Add("SHOP2_BALAMT", "SHOP2_BALAMT"); tableMapping.ColumnMappings.Add("OIL_BALAMT", "OIL_BALAMT"); tableMapping.ColumnMappings.Add("RICE_AMT", "RICE_AMT"); tableMapping.ColumnMappings.Add("RICE_BALAMT", "RICE_BALAMT"); tableMapping.ColumnMappings.Add("DEPT_AMT", "DEPT_AMT"); tableMapping.ColumnMappings.Add("LOANLAW_AMT", "LOANLAW_AMT"); tableMapping.ColumnMappings.Add("SHR_AMT", "SHR_AMT"); this._adapter.TableMappings.Add(tableMapping); this._adapter.DeleteCommand = new global::System.Data.OracleClient.OracleCommand(); this._adapter.DeleteCommand.Connection = this.Connection; this._adapter.DeleteCommand.CommandText = "DELETE FROM \"YRDIVMASTER\" WHERE ((\"COOP_ID\" = :Original_COOP_ID) AND (\"MEMBER_NO\"" + " = :Original_MEMBER_NO) AND (\"DIV_YEAR\" = :Original_DIV_YEAR))"; this._adapter.DeleteCommand.CommandType = global::System.Data.CommandType.Text; this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.OracleClient.OracleParameter("Original_COOP_ID", global::System.Data.OracleClient.OracleType.Char, 0, global::System.Data.ParameterDirection.Input, "COOP_ID", global::System.Data.DataRowVersion.Original, false, null)); this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.OracleClient.OracleParameter("Original_MEMBER_NO", global::System.Data.OracleClient.OracleType.Char, 0, global::System.Data.ParameterDirection.Input, "MEMBER_NO", global::System.Data.DataRowVersion.Original, false, null)); this._adapter.DeleteCommand.Parameters.Add(new global::System.Data.OracleClient.OracleParameter("Original_DIV_YEAR", global::System.Data.OracleClient.OracleType.Char, 0, global::System.Data.ParameterDirection.Input, "DIV_YEAR", global::System.Data.DataRowVersion.Original, false, null)); this._adapter.InsertCommand = new global::System.Data.OracleClient.OracleCommand(); this._adapter.InsertCommand.Connection = this.Connection; this._adapter.InsertCommand.CommandText = @"INSERT INTO ""YRDIVMASTER"" (""COOP_ID"", ""MEMBER_NO"", ""DIV_YEAR"", ""DIV_AMT"", ""DIV_BALAMT"", ""AVG_AMT"", ""AVG_BALAMT"", ""ETC_AMT"", ""ETC_BALAMT"", ""ITEM_BALAMT"", ""SHOP1_AMT"", ""SHOP2_AMT"", ""OIL_AMT"", ""SHOP1_BALAMT"", ""SHOP2_BALAMT"", ""OIL_BALAMT"", ""RICE_AMT"", ""RICE_BALAMT"", ""DEPT_AMT"", ""LOANLAW_AMT"", ""SHR_AMT"") VALUES (:COOP_ID, :MEMBER_NO, :DIV_YEAR, :DIV_AMT, :DIV_BALAMT, :AVG_AMT, :AVG_BALAMT, :ETC_AMT, :ETC_BALAMT, :ITEM_BALAMT, :SHOP1_AMT, :SHOP2_AMT, :OIL_AMT, :SHOP1_BALAMT, :SHOP2_BALAMT, :OIL_BALAMT, :RICE_AMT, :RICE_BALAMT, :DEPT_AMT, :LOANLAW_AMT, :SHR_AMT)"; this._adapter.InsertCommand.CommandType = global::System.Data.CommandType.Text; this._adapter.InsertCommand.Parameters.Add(new global::System.Data.OracleClient.OracleParameter("COOP_ID", global::System.Data.OracleClient.OracleType.Char, 0, global::System.Data.ParameterDirection.Input, "COOP_ID", global::System.Data.DataRowVersion.Current, false, null)); this._adapter.InsertCommand.Parameters.Add(new global::System.Data.OracleClient.OracleParameter("MEMBER_NO", global::System.Data.OracleClient.OracleType.Char, 0, global::System.Data.ParameterDirection.Input, "MEMBER_NO", global::System.Data.DataRowVersion.Current, false, null)); this._adapter.InsertCommand.Parameters.Add(new global::System.Data.OracleClient.OracleParameter("DIV_YEAR", global::System.Data.OracleClient.OracleType.Char, 0, global::System.Data.ParameterDirection.Input, "DIV_YEAR", global::System.Data.DataRowVersion.Current, false, null)); this._adapter.InsertCommand.Parameters.Add(new global::System.Data.OracleClient.OracleParameter("DIV_AMT", global::System.Data.OracleClient.OracleType.Number, 0, global::System.Data.ParameterDirection.Input, "DIV_AMT", global::System.Data.DataRowVersion.Current, false, null)); this._adapter.InsertCommand.Parameters.Add(new global::System.Data.OracleClient.OracleParameter("DIV_BALAMT", global::System.Data.OracleClient.OracleType.Number, 0, global::System.Data.ParameterDirection.Input, "DIV_BALAMT", global::System.Data.DataRowVersion.Current, false, null)); this._adapter.InsertCommand.Parameters.Add(new global::System.Data.OracleClient.OracleParameter("AVG_AMT", global::System.Data.OracleClient.OracleType.Number, 0, global::System.Data.ParameterDirection.Input, "AVG_AMT", global::System.Data.DataRowVersion.Current, false, null)); this._adapter.InsertCommand.Parameters.Add(new global::System.Data.OracleClient.OracleParameter("AVG_BALAMT", global::System.Data.OracleClient.OracleType.Number, 0, global::System.Data.ParameterDirection.Input, "AVG_BALAMT", global::System.Data.DataRowVersion.Current, false, null)); this._adapter.InsertCommand.Parameters.Add(new global::System.Data.OracleClient.OracleParameter("ETC_AMT", global::System.Data.OracleClient.OracleType.Number, 0, global::System.Data.ParameterDirection.Input, "ETC_AMT", global::System.Data.DataRowVersion.Current, false, null)); this._adapter.InsertCommand.Parameters.Add(new global::System.Data.OracleClient.OracleParameter("ETC_BALAMT", global::System.Data.OracleClient.OracleType.Number, 0, global::System.Data.ParameterDirection.Input, "ETC_BALAMT", global::System.Data.DataRowVersion.Current, false, null)); this._adapter.InsertCommand.Parameters.Add(new global::System.Data.OracleClient.OracleParameter("ITEM_BALAMT", global::System.Data.OracleClient.OracleType.Number, 0, global::System.Data.ParameterDirection.Input, "ITEM_BALAMT", global::System.Data.DataRowVersion.Current, false, null)); this._adapter.InsertCommand.Parameters.Add(new global::System.Data.OracleClient.OracleParameter("SHOP1_AMT", global::System.Data.OracleClient.OracleType.Number, 0, global::System.Data.ParameterDirection.Input, "SHOP1_AMT", global::System.Data.DataRowVersion.Current, false, null)); this._adapter.InsertCommand.Parameters.Add(new global::System.Data.OracleClient.OracleParameter("SHOP2_AMT", global::System.Data.OracleClient.OracleType.Number, 0, global::System.Data.ParameterDirection.Input, "SHOP2_AMT", global::System.Data.DataRowVersion.Current, false, null)); this._adapter.InsertCommand.Parameters.Add(new global::System.Data.OracleClient.OracleParameter("OIL_AMT", global::System.Data.OracleClient.OracleType.Number, 0, global::System.Data.ParameterDirection.Input, "OIL_AMT", global::System.Data.DataRowVersion.Current, false, null)); this._adapter.InsertCommand.Parameters.Add(new global::System.Data.OracleClient.OracleParameter("SHOP1_BALAMT", global::System.Data.OracleClient.OracleType.Number, 0, global::System.Data.ParameterDirection.Input, "SHOP1_BALAMT", global::System.Data.DataRowVersion.Current, false, null)); this._adapter.InsertCommand.Parameters.Add(new global::System.Data.OracleClient.OracleParameter("SHOP2_BALAMT", global::System.Data.OracleClient.OracleType.Number, 0, global::System.Data.ParameterDirection.Input, "SHOP2_BALAMT", global::System.Data.DataRowVersion.Current, false, null)); this._adapter.InsertCommand.Parameters.Add(new global::System.Data.OracleClient.OracleParameter("OIL_BALAMT", global::System.Data.OracleClient.OracleType.Number, 0, global::System.Data.ParameterDirection.Input, "OIL_BALAMT", global::System.Data.DataRowVersion.Current, false, null)); this._adapter.InsertCommand.Parameters.Add(new global::System.Data.OracleClient.OracleParameter("RICE_AMT", global::System.Data.OracleClient.OracleType.Number, 0, global::System.Data.ParameterDirection.Input, "RICE_AMT", global::System.Data.DataRowVersion.Current, false, null)); this._adapter.InsertCommand.Parameters.Add(new global::System.Data.OracleClient.OracleParameter("RICE_BALAMT", global::System.Data.OracleClient.OracleType.Number, 0, global::System.Data.ParameterDirection.Input, "RICE_BALAMT", global::System.Data.DataRowVersion.Current, false, null)); this._adapter.InsertCommand.Parameters.Add(new global::System.Data.OracleClient.OracleParameter("DEPT_AMT", global::System.Data.OracleClient.OracleType.Number, 0, global::System.Data.ParameterDirection.Input, "DEPT_AMT", global::System.Data.DataRowVersion.Current, false, null)); this._adapter.InsertCommand.Parameters.Add(new global::System.Data.OracleClient.OracleParameter("LOANLAW_AMT", global::System.Data.OracleClient.OracleType.Number, 0, global::System.Data.ParameterDirection.Input, "LOANLAW_AMT", global::System.Data.DataRowVersion.Current, false, null)); this._adapter.InsertCommand.Parameters.Add(new global::System.Data.OracleClient.OracleParameter("SHR_AMT", global::System.Data.OracleClient.OracleType.Number, 0, global::System.Data.ParameterDirection.Input, "SHR_AMT", global::System.Data.DataRowVersion.Current, false, null)); this._adapter.UpdateCommand = new global::System.Data.OracleClient.OracleCommand(); this._adapter.UpdateCommand.Connection = this.Connection; this._adapter.UpdateCommand.CommandText = @"UPDATE ""YRDIVMASTER"" SET ""COOP_ID"" = :COOP_ID, ""MEMBER_NO"" = :MEMBER_NO, ""DIV_YEAR"" = :DIV_YEAR, ""DIV_AMT"" = :DIV_AMT, ""DIV_BALAMT"" = :DIV_BALAMT, ""AVG_AMT"" = :AVG_AMT, ""AVG_BALAMT"" = :AVG_BALAMT, ""ETC_AMT"" = :ETC_AMT, ""ETC_BALAMT"" = :ETC_BALAMT, ""ITEM_BALAMT"" = :ITEM_BALAMT, ""SHOP1_AMT"" = :SHOP1_AMT, ""SHOP2_AMT"" = :SHOP2_AMT, ""OIL_AMT"" = :OIL_AMT, ""SHOP1_BALAMT"" = :SHOP1_BALAMT, ""SHOP2_BALAMT"" = :SHOP2_BALAMT, ""OIL_BALAMT"" = :OIL_BALAMT, ""RICE_AMT"" = :RICE_AMT, ""RICE_BALAMT"" = :RICE_BALAMT, ""DEPT_AMT"" = :DEPT_AMT, ""LOANLAW_AMT"" = :LOANLAW_AMT, ""SHR_AMT"" = :SHR_AMT WHERE ((""COOP_ID"" = :Original_COOP_ID) AND (""MEMBER_NO"" = :Original_MEMBER_NO) AND (""DIV_YEAR"" = :Original_DIV_YEAR))"; this._adapter.UpdateCommand.CommandType = global::System.Data.CommandType.Text; this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.OracleClient.OracleParameter("COOP_ID", global::System.Data.OracleClient.OracleType.Char, 0, global::System.Data.ParameterDirection.Input, "COOP_ID", global::System.Data.DataRowVersion.Current, false, null)); this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.OracleClient.OracleParameter("MEMBER_NO", global::System.Data.OracleClient.OracleType.Char, 0, global::System.Data.ParameterDirection.Input, "MEMBER_NO", global::System.Data.DataRowVersion.Current, false, null)); this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.OracleClient.OracleParameter("DIV_YEAR", global::System.Data.OracleClient.OracleType.Char, 0, global::System.Data.ParameterDirection.Input, "DIV_YEAR", global::System.Data.DataRowVersion.Current, false, null)); this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.OracleClient.OracleParameter("DIV_AMT", global::System.Data.OracleClient.OracleType.Number, 0, global::System.Data.ParameterDirection.Input, "DIV_AMT", global::System.Data.DataRowVersion.Current, false, null)); this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.OracleClient.OracleParameter("DIV_BALAMT", global::System.Data.OracleClient.OracleType.Number, 0, global::System.Data.ParameterDirection.Input, "DIV_BALAMT", global::System.Data.DataRowVersion.Current, false, null)); this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.OracleClient.OracleParameter("AVG_AMT", global::System.Data.OracleClient.OracleType.Number, 0, global::System.Data.ParameterDirection.Input, "AVG_AMT", global::System.Data.DataRowVersion.Current, false, null)); this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.OracleClient.OracleParameter("AVG_BALAMT", global::System.Data.OracleClient.OracleType.Number, 0, global::System.Data.ParameterDirection.Input, "AVG_BALAMT", global::System.Data.DataRowVersion.Current, false, null)); this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.OracleClient.OracleParameter("ETC_AMT", global::System.Data.OracleClient.OracleType.Number, 0, global::System.Data.ParameterDirection.Input, "ETC_AMT", global::System.Data.DataRowVersion.Current, false, null)); this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.OracleClient.OracleParameter("ETC_BALAMT", global::System.Data.OracleClient.OracleType.Number, 0, global::System.Data.ParameterDirection.Input, "ETC_BALAMT", global::System.Data.DataRowVersion.Current, false, null)); this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.OracleClient.OracleParameter("ITEM_BALAMT", global::System.Data.OracleClient.OracleType.Number, 0, global::System.Data.ParameterDirection.Input, "ITEM_BALAMT", global::System.Data.DataRowVersion.Current, false, null)); this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.OracleClient.OracleParameter("SHOP1_AMT", global::System.Data.OracleClient.OracleType.Number, 0, global::System.Data.ParameterDirection.Input, "SHOP1_AMT", global::System.Data.DataRowVersion.Current, false, null)); this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.OracleClient.OracleParameter("SHOP2_AMT", global::System.Data.OracleClient.OracleType.Number, 0, global::System.Data.ParameterDirection.Input, "SHOP2_AMT", global::System.Data.DataRowVersion.Current, false, null)); this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.OracleClient.OracleParameter("OIL_AMT", global::System.Data.OracleClient.OracleType.Number, 0, global::System.Data.ParameterDirection.Input, "OIL_AMT", global::System.Data.DataRowVersion.Current, false, null)); this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.OracleClient.OracleParameter("SHOP1_BALAMT", global::System.Data.OracleClient.OracleType.Number, 0, global::System.Data.ParameterDirection.Input, "SHOP1_BALAMT", global::System.Data.DataRowVersion.Current, false, null)); this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.OracleClient.OracleParameter("SHOP2_BALAMT", global::System.Data.OracleClient.OracleType.Number, 0, global::System.Data.ParameterDirection.Input, "SHOP2_BALAMT", global::System.Data.DataRowVersion.Current, false, null)); this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.OracleClient.OracleParameter("OIL_BALAMT", global::System.Data.OracleClient.OracleType.Number, 0, global::System.Data.ParameterDirection.Input, "OIL_BALAMT", global::System.Data.DataRowVersion.Current, false, null)); this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.OracleClient.OracleParameter("RICE_AMT", global::System.Data.OracleClient.OracleType.Number, 0, global::System.Data.ParameterDirection.Input, "RICE_AMT", global::System.Data.DataRowVersion.Current, false, null)); this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.OracleClient.OracleParameter("RICE_BALAMT", global::System.Data.OracleClient.OracleType.Number, 0, global::System.Data.ParameterDirection.Input, "RICE_BALAMT", global::System.Data.DataRowVersion.Current, false, null)); this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.OracleClient.OracleParameter("DEPT_AMT", global::System.Data.OracleClient.OracleType.Number, 0, global::System.Data.ParameterDirection.Input, "DEPT_AMT", global::System.Data.DataRowVersion.Current, false, null)); this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.OracleClient.OracleParameter("LOANLAW_AMT", global::System.Data.OracleClient.OracleType.Number, 0, global::System.Data.ParameterDirection.Input, "LOANLAW_AMT", global::System.Data.DataRowVersion.Current, false, null)); this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.OracleClient.OracleParameter("SHR_AMT", global::System.Data.OracleClient.OracleType.Number, 0, global::System.Data.ParameterDirection.Input, "SHR_AMT", global::System.Data.DataRowVersion.Current, false, null)); this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.OracleClient.OracleParameter("Original_COOP_ID", global::System.Data.OracleClient.OracleType.Char, 0, global::System.Data.ParameterDirection.Input, "COOP_ID", global::System.Data.DataRowVersion.Original, false, null)); this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.OracleClient.OracleParameter("Original_MEMBER_NO", global::System.Data.OracleClient.OracleType.Char, 0, global::System.Data.ParameterDirection.Input, "MEMBER_NO", global::System.Data.DataRowVersion.Original, false, null)); this._adapter.UpdateCommand.Parameters.Add(new global::System.Data.OracleClient.OracleParameter("Original_DIV_YEAR", global::System.Data.OracleClient.OracleType.Char, 0, global::System.Data.ParameterDirection.Input, "DIV_YEAR", global::System.Data.DataRowVersion.Original, false, null)); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] private void InitConnection() { this._connection = new global::System.Data.OracleClient.OracleConnection(); this._connection.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["ConnectionString3"].ConnectionString; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] private void InitCommandCollection() { this._commandCollection = new global::System.Data.OracleClient.OracleCommand[1]; this._commandCollection[0] = new global::System.Data.OracleClient.OracleCommand(); this._commandCollection[0].Connection = this.Connection; this._commandCollection[0].CommandText = "select * from yrdivmaster"; this._commandCollection[0].CommandType = global::System.Data.CommandType.Text; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")] [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Fill, true)] public virtual int Fill(DataSet1.YRDIVMASTERDataTable 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.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")] [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Select, true)] public virtual DataSet1.YRDIVMASTERDataTable GetData() { this.Adapter.SelectCommand = this.CommandCollection[0]; DataSet1.YRDIVMASTERDataTable dataTable = new DataSet1.YRDIVMASTERDataTable(); this.Adapter.Fill(dataTable); return dataTable; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")] public virtual int Update(DataSet1.YRDIVMASTERDataTable dataTable) { return this.Adapter.Update(dataTable); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")] public virtual int Update(DataSet1 dataSet) { return this.Adapter.Update(dataSet, "YRDIVMASTER"); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] [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.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] [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.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")] [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Delete, true)] public virtual int Delete(string Original_COOP_ID, string Original_MEMBER_NO, string Original_DIV_YEAR) { if ((Original_COOP_ID == null)) { throw new global::System.ArgumentNullException("Original_COOP_ID"); } else { this.Adapter.DeleteCommand.Parameters[0].Value = ((string)(Original_COOP_ID)); } if ((Original_MEMBER_NO == null)) { throw new global::System.ArgumentNullException("Original_MEMBER_NO"); } else { this.Adapter.DeleteCommand.Parameters[1].Value = ((string)(Original_MEMBER_NO)); } if ((Original_DIV_YEAR == null)) { throw new global::System.ArgumentNullException("Original_DIV_YEAR"); } else { this.Adapter.DeleteCommand.Parameters[2].Value = ((string)(Original_DIV_YEAR)); } 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.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")] [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Insert, true)] public virtual int Insert( string COOP_ID, string MEMBER_NO, string DIV_YEAR, global::System.Nullable DIV_AMT, global::System.Nullable DIV_BALAMT, global::System.Nullable AVG_AMT, global::System.Nullable AVG_BALAMT, global::System.Nullable ETC_AMT, global::System.Nullable ETC_BALAMT, global::System.Nullable ITEM_BALAMT, global::System.Nullable SHOP1_AMT, global::System.Nullable SHOP2_AMT, global::System.Nullable OIL_AMT, global::System.Nullable SHOP1_BALAMT, global::System.Nullable SHOP2_BALAMT, global::System.Nullable OIL_BALAMT, global::System.Nullable RICE_AMT, global::System.Nullable RICE_BALAMT, global::System.Nullable DEPT_AMT, global::System.Nullable LOANLAW_AMT, global::System.Nullable SHR_AMT) { if ((COOP_ID == null)) { throw new global::System.ArgumentNullException("COOP_ID"); } else { this.Adapter.InsertCommand.Parameters[0].Value = ((string)(COOP_ID)); } if ((MEMBER_NO == null)) { throw new global::System.ArgumentNullException("MEMBER_NO"); } else { this.Adapter.InsertCommand.Parameters[1].Value = ((string)(MEMBER_NO)); } if ((DIV_YEAR == null)) { throw new global::System.ArgumentNullException("DIV_YEAR"); } else { this.Adapter.InsertCommand.Parameters[2].Value = ((string)(DIV_YEAR)); } if ((DIV_AMT.HasValue == true)) { this.Adapter.InsertCommand.Parameters[3].Value = ((decimal)(DIV_AMT.Value)); } else { this.Adapter.InsertCommand.Parameters[3].Value = global::System.DBNull.Value; } if ((DIV_BALAMT.HasValue == true)) { this.Adapter.InsertCommand.Parameters[4].Value = ((decimal)(DIV_BALAMT.Value)); } else { this.Adapter.InsertCommand.Parameters[4].Value = global::System.DBNull.Value; } if ((AVG_AMT.HasValue == true)) { this.Adapter.InsertCommand.Parameters[5].Value = ((decimal)(AVG_AMT.Value)); } else { this.Adapter.InsertCommand.Parameters[5].Value = global::System.DBNull.Value; } if ((AVG_BALAMT.HasValue == true)) { this.Adapter.InsertCommand.Parameters[6].Value = ((decimal)(AVG_BALAMT.Value)); } else { this.Adapter.InsertCommand.Parameters[6].Value = global::System.DBNull.Value; } if ((ETC_AMT.HasValue == true)) { this.Adapter.InsertCommand.Parameters[7].Value = ((decimal)(ETC_AMT.Value)); } else { this.Adapter.InsertCommand.Parameters[7].Value = global::System.DBNull.Value; } if ((ETC_BALAMT.HasValue == true)) { this.Adapter.InsertCommand.Parameters[8].Value = ((decimal)(ETC_BALAMT.Value)); } else { this.Adapter.InsertCommand.Parameters[8].Value = global::System.DBNull.Value; } if ((ITEM_BALAMT.HasValue == true)) { this.Adapter.InsertCommand.Parameters[9].Value = ((decimal)(ITEM_BALAMT.Value)); } else { this.Adapter.InsertCommand.Parameters[9].Value = global::System.DBNull.Value; } if ((SHOP1_AMT.HasValue == true)) { this.Adapter.InsertCommand.Parameters[10].Value = ((decimal)(SHOP1_AMT.Value)); } else { this.Adapter.InsertCommand.Parameters[10].Value = global::System.DBNull.Value; } if ((SHOP2_AMT.HasValue == true)) { this.Adapter.InsertCommand.Parameters[11].Value = ((decimal)(SHOP2_AMT.Value)); } else { this.Adapter.InsertCommand.Parameters[11].Value = global::System.DBNull.Value; } if ((OIL_AMT.HasValue == true)) { this.Adapter.InsertCommand.Parameters[12].Value = ((decimal)(OIL_AMT.Value)); } else { this.Adapter.InsertCommand.Parameters[12].Value = global::System.DBNull.Value; } if ((SHOP1_BALAMT.HasValue == true)) { this.Adapter.InsertCommand.Parameters[13].Value = ((decimal)(SHOP1_BALAMT.Value)); } else { this.Adapter.InsertCommand.Parameters[13].Value = global::System.DBNull.Value; } if ((SHOP2_BALAMT.HasValue == true)) { this.Adapter.InsertCommand.Parameters[14].Value = ((decimal)(SHOP2_BALAMT.Value)); } else { this.Adapter.InsertCommand.Parameters[14].Value = global::System.DBNull.Value; } if ((OIL_BALAMT.HasValue == true)) { this.Adapter.InsertCommand.Parameters[15].Value = ((decimal)(OIL_BALAMT.Value)); } else { this.Adapter.InsertCommand.Parameters[15].Value = global::System.DBNull.Value; } if ((RICE_AMT.HasValue == true)) { this.Adapter.InsertCommand.Parameters[16].Value = ((decimal)(RICE_AMT.Value)); } else { this.Adapter.InsertCommand.Parameters[16].Value = global::System.DBNull.Value; } if ((RICE_BALAMT.HasValue == true)) { this.Adapter.InsertCommand.Parameters[17].Value = ((decimal)(RICE_BALAMT.Value)); } else { this.Adapter.InsertCommand.Parameters[17].Value = global::System.DBNull.Value; } if ((DEPT_AMT.HasValue == true)) { this.Adapter.InsertCommand.Parameters[18].Value = ((decimal)(DEPT_AMT.Value)); } else { this.Adapter.InsertCommand.Parameters[18].Value = global::System.DBNull.Value; } if ((LOANLAW_AMT.HasValue == true)) { this.Adapter.InsertCommand.Parameters[19].Value = ((decimal)(LOANLAW_AMT.Value)); } else { this.Adapter.InsertCommand.Parameters[19].Value = global::System.DBNull.Value; } if ((SHR_AMT.HasValue == true)) { this.Adapter.InsertCommand.Parameters[20].Value = ((decimal)(SHR_AMT.Value)); } else { this.Adapter.InsertCommand.Parameters[20].Value = global::System.DBNull.Value; } 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.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapter")] [global::System.ComponentModel.DataObjectMethodAttribute(global::System.ComponentModel.DataObjectMethodType.Update, true)] public virtual int Update( string COOP_ID, string MEMBER_NO, string DIV_YEAR, global::System.Nullable DIV_AMT, global::System.Nullable DIV_BALAMT, global::System.Nullable AVG_AMT, global::System.Nullable AVG_BALAMT, global::System.Nullable ETC_AMT, global::System.Nullable ETC_BALAMT, global::System.Nullable ITEM_BALAMT, global::System.Nullable SHOP1_AMT, global::System.Nullable SHOP2_AMT, global::System.Nullable OIL_AMT, global::System.Nullable SHOP1_BALAMT, global::System.Nullable SHOP2_BALAMT, global::System.Nullable OIL_BALAMT, global::System.Nullable RICE_AMT, global::System.Nullable RICE_BALAMT, global::System.Nullable DEPT_AMT, global::System.Nullable LOANLAW_AMT, global::System.Nullable SHR_AMT, string Original_COOP_ID, string Original_MEMBER_NO, string Original_DIV_YEAR) { if ((COOP_ID == null)) { throw new global::System.ArgumentNullException("COOP_ID"); } else { this.Adapter.UpdateCommand.Parameters[0].Value = ((string)(COOP_ID)); } if ((MEMBER_NO == null)) { throw new global::System.ArgumentNullException("MEMBER_NO"); } else { this.Adapter.UpdateCommand.Parameters[1].Value = ((string)(MEMBER_NO)); } if ((DIV_YEAR == null)) { throw new global::System.ArgumentNullException("DIV_YEAR"); } else { this.Adapter.UpdateCommand.Parameters[2].Value = ((string)(DIV_YEAR)); } if ((DIV_AMT.HasValue == true)) { this.Adapter.UpdateCommand.Parameters[3].Value = ((decimal)(DIV_AMT.Value)); } else { this.Adapter.UpdateCommand.Parameters[3].Value = global::System.DBNull.Value; } if ((DIV_BALAMT.HasValue == true)) { this.Adapter.UpdateCommand.Parameters[4].Value = ((decimal)(DIV_BALAMT.Value)); } else { this.Adapter.UpdateCommand.Parameters[4].Value = global::System.DBNull.Value; } if ((AVG_AMT.HasValue == true)) { this.Adapter.UpdateCommand.Parameters[5].Value = ((decimal)(AVG_AMT.Value)); } else { this.Adapter.UpdateCommand.Parameters[5].Value = global::System.DBNull.Value; } if ((AVG_BALAMT.HasValue == true)) { this.Adapter.UpdateCommand.Parameters[6].Value = ((decimal)(AVG_BALAMT.Value)); } else { this.Adapter.UpdateCommand.Parameters[6].Value = global::System.DBNull.Value; } if ((ETC_AMT.HasValue == true)) { this.Adapter.UpdateCommand.Parameters[7].Value = ((decimal)(ETC_AMT.Value)); } else { this.Adapter.UpdateCommand.Parameters[7].Value = global::System.DBNull.Value; } if ((ETC_BALAMT.HasValue == true)) { this.Adapter.UpdateCommand.Parameters[8].Value = ((decimal)(ETC_BALAMT.Value)); } else { this.Adapter.UpdateCommand.Parameters[8].Value = global::System.DBNull.Value; } if ((ITEM_BALAMT.HasValue == true)) { this.Adapter.UpdateCommand.Parameters[9].Value = ((decimal)(ITEM_BALAMT.Value)); } else { this.Adapter.UpdateCommand.Parameters[9].Value = global::System.DBNull.Value; } if ((SHOP1_AMT.HasValue == true)) { this.Adapter.UpdateCommand.Parameters[10].Value = ((decimal)(SHOP1_AMT.Value)); } else { this.Adapter.UpdateCommand.Parameters[10].Value = global::System.DBNull.Value; } if ((SHOP2_AMT.HasValue == true)) { this.Adapter.UpdateCommand.Parameters[11].Value = ((decimal)(SHOP2_AMT.Value)); } else { this.Adapter.UpdateCommand.Parameters[11].Value = global::System.DBNull.Value; } if ((OIL_AMT.HasValue == true)) { this.Adapter.UpdateCommand.Parameters[12].Value = ((decimal)(OIL_AMT.Value)); } else { this.Adapter.UpdateCommand.Parameters[12].Value = global::System.DBNull.Value; } if ((SHOP1_BALAMT.HasValue == true)) { this.Adapter.UpdateCommand.Parameters[13].Value = ((decimal)(SHOP1_BALAMT.Value)); } else { this.Adapter.UpdateCommand.Parameters[13].Value = global::System.DBNull.Value; } if ((SHOP2_BALAMT.HasValue == true)) { this.Adapter.UpdateCommand.Parameters[14].Value = ((decimal)(SHOP2_BALAMT.Value)); } else { this.Adapter.UpdateCommand.Parameters[14].Value = global::System.DBNull.Value; } if ((OIL_BALAMT.HasValue == true)) { this.Adapter.UpdateCommand.Parameters[15].Value = ((decimal)(OIL_BALAMT.Value)); } else { this.Adapter.UpdateCommand.Parameters[15].Value = global::System.DBNull.Value; } if ((RICE_AMT.HasValue == true)) { this.Adapter.UpdateCommand.Parameters[16].Value = ((decimal)(RICE_AMT.Value)); } else { this.Adapter.UpdateCommand.Parameters[16].Value = global::System.DBNull.Value; } if ((RICE_BALAMT.HasValue == true)) { this.Adapter.UpdateCommand.Parameters[17].Value = ((decimal)(RICE_BALAMT.Value)); } else { this.Adapter.UpdateCommand.Parameters[17].Value = global::System.DBNull.Value; } if ((DEPT_AMT.HasValue == true)) { this.Adapter.UpdateCommand.Parameters[18].Value = ((decimal)(DEPT_AMT.Value)); } else { this.Adapter.UpdateCommand.Parameters[18].Value = global::System.DBNull.Value; } if ((LOANLAW_AMT.HasValue == true)) { this.Adapter.UpdateCommand.Parameters[19].Value = ((decimal)(LOANLAW_AMT.Value)); } else { this.Adapter.UpdateCommand.Parameters[19].Value = global::System.DBNull.Value; } if ((SHR_AMT.HasValue == true)) { this.Adapter.UpdateCommand.Parameters[20].Value = ((decimal)(SHR_AMT.Value)); } else { this.Adapter.UpdateCommand.Parameters[20].Value = global::System.DBNull.Value; } if ((Original_COOP_ID == null)) { throw new global::System.ArgumentNullException("Original_COOP_ID"); } else { this.Adapter.UpdateCommand.Parameters[21].Value = ((string)(Original_COOP_ID)); } if ((Original_MEMBER_NO == null)) { throw new global::System.ArgumentNullException("Original_MEMBER_NO"); } else { this.Adapter.UpdateCommand.Parameters[22].Value = ((string)(Original_MEMBER_NO)); } if ((Original_DIV_YEAR == null)) { throw new global::System.ArgumentNullException("Original_DIV_YEAR"); } else { this.Adapter.UpdateCommand.Parameters[23].Value = ((string)(Original_DIV_YEAR)); } 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.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] [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 DIV_AMT, global::System.Nullable DIV_BALAMT, global::System.Nullable AVG_AMT, global::System.Nullable AVG_BALAMT, global::System.Nullable ETC_AMT, global::System.Nullable ETC_BALAMT, global::System.Nullable ITEM_BALAMT, global::System.Nullable SHOP1_AMT, global::System.Nullable SHOP2_AMT, global::System.Nullable OIL_AMT, global::System.Nullable SHOP1_BALAMT, global::System.Nullable SHOP2_BALAMT, global::System.Nullable OIL_BALAMT, global::System.Nullable RICE_AMT, global::System.Nullable RICE_BALAMT, global::System.Nullable DEPT_AMT, global::System.Nullable LOANLAW_AMT, global::System.Nullable SHR_AMT, string Original_COOP_ID, string Original_MEMBER_NO, string Original_DIV_YEAR) { return this.Update(Original_COOP_ID, Original_MEMBER_NO, Original_DIV_YEAR, DIV_AMT, DIV_BALAMT, AVG_AMT, AVG_BALAMT, ETC_AMT, ETC_BALAMT, ITEM_BALAMT, SHOP1_AMT, SHOP2_AMT, OIL_AMT, SHOP1_BALAMT, SHOP2_BALAMT, OIL_BALAMT, RICE_AMT, RICE_BALAMT, DEPT_AMT, LOANLAW_AMT, SHR_AMT, Original_COOP_ID, Original_MEMBER_NO, Original_DIV_YEAR); } } /// ///TableAdapterManager is used to coordinate TableAdapters in the dataset to enable Hierarchical Update scenarios /// [global::System.ComponentModel.DesignerCategoryAttribute("code")] [global::System.ComponentModel.ToolboxItem(true)] [global::System.ComponentModel.DesignerAttribute("Microsoft.VSDesigner.DataSource.Design.TableAdapterManagerDesigner, Microsoft.VSD" + "esigner, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a")] [global::System.ComponentModel.Design.HelpKeywordAttribute("vs.data.TableAdapterManager")] public partial class TableAdapterManager : global::System.ComponentModel.Component { private UpdateOrderOption _updateOrder; private YRDIVMASTERTableAdapter _yRDIVMASTERTableAdapter; private bool _backupDataSetBeforeUpdate; private global::System.Data.IDbConnection _connection; [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public UpdateOrderOption UpdateOrder { get { return this._updateOrder; } set { this._updateOrder = value; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] [global::System.ComponentModel.EditorAttribute("Microsoft.VSDesigner.DataSource.Design.TableAdapterManagerPropertyEditor, Microso" + "ft.VSDesigner, Version=10.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3" + "a", "System.Drawing.Design.UITypeEditor")] public YRDIVMASTERTableAdapter YRDIVMASTERTableAdapter { get { return this._yRDIVMASTERTableAdapter; } set { this._yRDIVMASTERTableAdapter = value; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public bool BackupDataSetBeforeUpdate { get { return this._backupDataSetBeforeUpdate; } set { this._backupDataSetBeforeUpdate = value; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] [global::System.ComponentModel.Browsable(false)] public global::System.Data.IDbConnection Connection { get { if ((this._connection != null)) { return this._connection; } if (((this._yRDIVMASTERTableAdapter != null) && (this._yRDIVMASTERTableAdapter.Connection != null))) { return this._yRDIVMASTERTableAdapter.Connection; } return null; } set { this._connection = value; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] [global::System.ComponentModel.Browsable(false)] public int TableAdapterInstanceCount { get { int count = 0; if ((this._yRDIVMASTERTableAdapter != null)) { count = (count + 1); } return count; } } /// ///Update rows in top-down order. /// [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] private int UpdateUpdatedRows(DataSet1 dataSet, global::System.Collections.Generic.List allChangedRows, global::System.Collections.Generic.List allAddedRows) { int result = 0; if ((this._yRDIVMASTERTableAdapter != null)) { global::System.Data.DataRow[] updatedRows = dataSet.YRDIVMASTER.Select(null, null, global::System.Data.DataViewRowState.ModifiedCurrent); updatedRows = this.GetRealUpdatedRows(updatedRows, allAddedRows); if (((updatedRows != null) && (0 < updatedRows.Length))) { result = (result + this._yRDIVMASTERTableAdapter.Update(updatedRows)); allChangedRows.AddRange(updatedRows); } } return result; } /// ///Insert rows in top-down order. /// [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] private int UpdateInsertedRows(DataSet1 dataSet, global::System.Collections.Generic.List allAddedRows) { int result = 0; if ((this._yRDIVMASTERTableAdapter != null)) { global::System.Data.DataRow[] addedRows = dataSet.YRDIVMASTER.Select(null, null, global::System.Data.DataViewRowState.Added); if (((addedRows != null) && (0 < addedRows.Length))) { result = (result + this._yRDIVMASTERTableAdapter.Update(addedRows)); allAddedRows.AddRange(addedRows); } } return result; } /// ///Delete rows in bottom-up order. /// [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] private int UpdateDeletedRows(DataSet1 dataSet, global::System.Collections.Generic.List allChangedRows) { int result = 0; if ((this._yRDIVMASTERTableAdapter != null)) { global::System.Data.DataRow[] deletedRows = dataSet.YRDIVMASTER.Select(null, null, global::System.Data.DataViewRowState.Deleted); if (((deletedRows != null) && (0 < deletedRows.Length))) { result = (result + this._yRDIVMASTERTableAdapter.Update(deletedRows)); allChangedRows.AddRange(deletedRows); } } return result; } /// ///Remove inserted rows that become updated rows after calling TableAdapter.Update(inserted rows) first /// [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] private global::System.Data.DataRow[] GetRealUpdatedRows(global::System.Data.DataRow[] updatedRows, global::System.Collections.Generic.List allAddedRows) { if (((updatedRows == null) || (updatedRows.Length < 1))) { return updatedRows; } if (((allAddedRows == null) || (allAddedRows.Count < 1))) { return updatedRows; } global::System.Collections.Generic.List realUpdatedRows = new global::System.Collections.Generic.List(); for (int i = 0; (i < updatedRows.Length); i = (i + 1)) { global::System.Data.DataRow row = updatedRows[i]; if ((allAddedRows.Contains(row) == false)) { realUpdatedRows.Add(row); } } return realUpdatedRows.ToArray(); } /// ///Update all changes to the dataset. /// [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public virtual int UpdateAll(DataSet1 dataSet) { if ((dataSet == null)) { throw new global::System.ArgumentNullException("dataSet"); } if ((dataSet.HasChanges() == false)) { return 0; } if (((this._yRDIVMASTERTableAdapter != null) && (this.MatchTableAdapterConnection(this._yRDIVMASTERTableAdapter.Connection) == false))) { throw new global::System.ArgumentException("All TableAdapters managed by a TableAdapterManager must use the same connection s" + "tring."); } global::System.Data.IDbConnection workConnection = this.Connection; if ((workConnection == null)) { throw new global::System.ApplicationException("TableAdapterManager contains no connection information. Set each TableAdapterMana" + "ger TableAdapter property to a valid TableAdapter instance."); } bool workConnOpened = false; if (((workConnection.State & global::System.Data.ConnectionState.Broken) == global::System.Data.ConnectionState.Broken)) { workConnection.Close(); } if ((workConnection.State == global::System.Data.ConnectionState.Closed)) { workConnection.Open(); workConnOpened = true; } global::System.Data.IDbTransaction workTransaction = workConnection.BeginTransaction(); if ((workTransaction == null)) { throw new global::System.ApplicationException("The transaction cannot begin. The current data connection does not support transa" + "ctions or the current state is not allowing the transaction to begin."); } global::System.Collections.Generic.List allChangedRows = new global::System.Collections.Generic.List(); global::System.Collections.Generic.List allAddedRows = new global::System.Collections.Generic.List(); global::System.Collections.Generic.List adaptersWithAcceptChangesDuringUpdate = new global::System.Collections.Generic.List(); global::System.Collections.Generic.Dictionary revertConnections = new global::System.Collections.Generic.Dictionary(); int result = 0; global::System.Data.DataSet backupDataSet = null; if (this.BackupDataSetBeforeUpdate) { backupDataSet = new global::System.Data.DataSet(); backupDataSet.Merge(dataSet); } try { // ---- Prepare for update ----------- // if ((this._yRDIVMASTERTableAdapter != null)) { revertConnections.Add(this._yRDIVMASTERTableAdapter, this._yRDIVMASTERTableAdapter.Connection); this._yRDIVMASTERTableAdapter.Connection = ((global::System.Data.OracleClient.OracleConnection)(workConnection)); this._yRDIVMASTERTableAdapter.Transaction = ((global::System.Data.OracleClient.OracleTransaction)(workTransaction)); if (this._yRDIVMASTERTableAdapter.Adapter.AcceptChangesDuringUpdate) { this._yRDIVMASTERTableAdapter.Adapter.AcceptChangesDuringUpdate = false; adaptersWithAcceptChangesDuringUpdate.Add(this._yRDIVMASTERTableAdapter.Adapter); } } // //---- Perform updates ----------- // if ((this.UpdateOrder == UpdateOrderOption.UpdateInsertDelete)) { result = (result + this.UpdateUpdatedRows(dataSet, allChangedRows, allAddedRows)); result = (result + this.UpdateInsertedRows(dataSet, allAddedRows)); } else { result = (result + this.UpdateInsertedRows(dataSet, allAddedRows)); result = (result + this.UpdateUpdatedRows(dataSet, allChangedRows, allAddedRows)); } result = (result + this.UpdateDeletedRows(dataSet, allChangedRows)); // //---- Commit updates ----------- // workTransaction.Commit(); if ((0 < allAddedRows.Count)) { global::System.Data.DataRow[] rows = new System.Data.DataRow[allAddedRows.Count]; allAddedRows.CopyTo(rows); for (int i = 0; (i < rows.Length); i = (i + 1)) { global::System.Data.DataRow row = rows[i]; row.AcceptChanges(); } } if ((0 < allChangedRows.Count)) { global::System.Data.DataRow[] rows = new System.Data.DataRow[allChangedRows.Count]; allChangedRows.CopyTo(rows); for (int i = 0; (i < rows.Length); i = (i + 1)) { global::System.Data.DataRow row = rows[i]; row.AcceptChanges(); } } } catch (global::System.Exception ex) { workTransaction.Rollback(); // ---- Restore the dataset ----------- if (this.BackupDataSetBeforeUpdate) { global::System.Diagnostics.Debug.Assert((backupDataSet != null)); dataSet.Clear(); dataSet.Merge(backupDataSet); } else { if ((0 < allAddedRows.Count)) { global::System.Data.DataRow[] rows = new System.Data.DataRow[allAddedRows.Count]; allAddedRows.CopyTo(rows); for (int i = 0; (i < rows.Length); i = (i + 1)) { global::System.Data.DataRow row = rows[i]; row.AcceptChanges(); row.SetAdded(); } } } throw ex; } finally { if (workConnOpened) { workConnection.Close(); } if ((this._yRDIVMASTERTableAdapter != null)) { this._yRDIVMASTERTableAdapter.Connection = ((global::System.Data.OracleClient.OracleConnection)(revertConnections[this._yRDIVMASTERTableAdapter])); this._yRDIVMASTERTableAdapter.Transaction = null; } if ((0 < adaptersWithAcceptChangesDuringUpdate.Count)) { global::System.Data.Common.DataAdapter[] adapters = new System.Data.Common.DataAdapter[adaptersWithAcceptChangesDuringUpdate.Count]; adaptersWithAcceptChangesDuringUpdate.CopyTo(adapters); for (int i = 0; (i < adapters.Length); i = (i + 1)) { global::System.Data.Common.DataAdapter adapter = adapters[i]; adapter.AcceptChangesDuringUpdate = true; } } } return result; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] protected virtual void SortSelfReferenceRows(global::System.Data.DataRow[] rows, global::System.Data.DataRelation relation, bool childFirst) { global::System.Array.Sort(rows, new SelfReferenceComparer(relation, childFirst)); } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] protected virtual bool MatchTableAdapterConnection(global::System.Data.IDbConnection inputConnection) { if ((this._connection != null)) { return true; } if (((this.Connection == null) || (inputConnection == null))) { return true; } if (string.Equals(this.Connection.ConnectionString, inputConnection.ConnectionString, global::System.StringComparison.Ordinal)) { return true; } return false; } /// ///Update Order Option /// [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public enum UpdateOrderOption { InsertUpdateDelete = 0, UpdateInsertDelete = 1, } /// ///Used to sort self-referenced table's rows /// [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] private class SelfReferenceComparer : object, global::System.Collections.Generic.IComparer { private global::System.Data.DataRelation _relation; private int _childFirst; [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] internal SelfReferenceComparer(global::System.Data.DataRelation relation, bool childFirst) { this._relation = relation; if (childFirst) { this._childFirst = -1; } else { this._childFirst = 1; } } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] private global::System.Data.DataRow GetRoot(global::System.Data.DataRow row, out int distance) { global::System.Diagnostics.Debug.Assert((row != null)); global::System.Data.DataRow root = row; distance = 0; global::System.Collections.Generic.IDictionary traversedRows = new global::System.Collections.Generic.Dictionary(); traversedRows[row] = row; global::System.Data.DataRow parent = row.GetParentRow(this._relation, global::System.Data.DataRowVersion.Default); for ( ; ((parent != null) && (traversedRows.ContainsKey(parent) == false)); ) { distance = (distance + 1); root = parent; traversedRows[parent] = parent; parent = parent.GetParentRow(this._relation, global::System.Data.DataRowVersion.Default); } if ((distance == 0)) { traversedRows.Clear(); traversedRows[row] = row; parent = row.GetParentRow(this._relation, global::System.Data.DataRowVersion.Original); for ( ; ((parent != null) && (traversedRows.ContainsKey(parent) == false)); ) { distance = (distance + 1); root = parent; traversedRows[parent] = parent; parent = parent.GetParentRow(this._relation, global::System.Data.DataRowVersion.Original); } } return root; } [global::System.Diagnostics.DebuggerNonUserCodeAttribute()] [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Data.Design.TypedDataSetGenerator", "4.0.0.0")] public int Compare(global::System.Data.DataRow row1, global::System.Data.DataRow row2) { if (object.ReferenceEquals(row1, row2)) { return 0; } if ((row1 == null)) { return -1; } if ((row2 == null)) { return 1; } int distance1 = 0; global::System.Data.DataRow root1 = this.GetRoot(row1, out distance1); int distance2 = 0; global::System.Data.DataRow root2 = this.GetRoot(row2, out distance2); if (object.ReferenceEquals(root1, root2)) { return (this._childFirst * distance1.CompareTo(distance2)); } else { global::System.Diagnostics.Debug.Assert(((root1.Table != null) && (root2.Table != null))); if ((root1.Table.Rows.IndexOf(root1) < root2.Table.Rows.IndexOf(root2))) { return -1; } else { return 1; } } } } } } #pragma warning restore 1591