12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259126012611262126312641265126612671268126912701271127212731274127512761277127812791280128112821283128412851286128712881289129012911292129312941295129612971298129913001301130213031304130513061307130813091310131113121313131413151316131713181319132013211322132313241325132613271328132913301331133213331334133513361337133813391340134113421343134413451346134713481349135013511352135313541355135613571358135913601361136213631364136513661367136813691370137113721373137413751376137713781379138013811382138313841385138613871388138913901391139213931394139513961397139813991400140114021403140414051406140714081409141014111412141314141415141614171418141914201421142214231424142514261427142814291430143114321433143414351436143714381439144014411442144314441445144614471448144914501451145214531454145514561457145814591460146114621463146414651466146714681469147014711472147314741475147614771478147914801481148214831484148514861487148814891490149114921493149414951496149714981499150015011502150315041505150615071508150915101511151215131514151515161517151815191520152115221523152415251526152715281529153015311532153315341535153615371538153915401541154215431544154515461547154815491550155115521553155415551556155715581559156015611562156315641565156615671568156915701571157215731574157515761577157815791580158115821583158415851586158715881589159015911592159315941595159615971598159916001601160216031604160516061607160816091610161116121613161416151616161716181619162016211622162316241625162616271628162916301631163216331634163516361637163816391640164116421643164416451646164716481649165016511652165316541655165616571658165916601661166216631664166516661667166816691670167116721673167416751676167716781679168016811682168316841685168616871688168916901691169216931694169516961697169816991700170117021703170417051706170717081709171017111712171317141715171617171718171917201721172217231724172517261727172817291730173117321733173417351736173717381739174017411742174317441745174617471748174917501751175217531754175517561757175817591760176117621763176417651766176717681769177017711772177317741775177617771778177917801781178217831784178517861787178817891790179117921793179417951796179717981799180018011802180318041805180618071808180918101811181218131814181518161817181818191820182118221823182418251826182718281829183018311832183318341835183618371838183918401841184218431844184518461847184818491850185118521853185418551856185718581859186018611862186318641865186618671868186918701871187218731874187518761877187818791880188118821883188418851886188718881889189018911892189318941895189618971898189919001901190219031904190519061907190819091910191119121913191419151916191719181919192019211922192319241925192619271928192919301931193219331934193519361937193819391940194119421943194419451946194719481949195019511952195319541955195619571958195919601961196219631964196519661967196819691970197119721973197419751976197719781979198019811982198319841985198619871988198919901991199219931994199519961997199819992000200120022003200420052006200720082009201020112012201320142015201620172018201920202021202220232024202520262027202820292030203120322033203420352036203720382039204020412042204320442045204620472048204920502051205220532054205520562057205820592060206120622063206420652066206720682069207020712072207320742075207620772078207920802081 |
- using System;
- using System.CodeDom.Compiler;
- using System.Collections;
- using System.ComponentModel;
- using System.ComponentModel.Design;
- using System.Data;
- using System.Diagnostics;
- using System.IO;
- using System.Runtime.Serialization;
- using System.Xml;
- using System.Xml.Schema;
- using System.Xml.Serialization;
- namespace SunRoxm.BizPeri.ReportDataSet.ReportDataSet
- {
- [Serializable]
- [DesignerCategory("code")]
- [XmlRoot("dsFrmEmployee")]
- [HelpKeyword("vs.data.DataSet")]
- [XmlSchemaProvider("GetTypedDataSetSchema")]
- [GeneratedCode("System.Data.Design.TypedDataSetGenerator", "2.0.0.0")]
- [ToolboxItem(true)]
- public class dsFrmEmployee : DataSet
- {
- public delegate void EmployeeRowChangeEventHandler(object sender, EmployeeRowChangeEvent e);
- public delegate void AppendInfoRowChangeEventHandler(object sender, AppendInfoRowChangeEvent e);
- [Serializable]
- [GeneratedCode("System.Data.Design.TypedDataSetGenerator", "2.0.0.0")]
- [XmlSchemaProvider("GetTypedTableSchema")]
- public class EmployeeDataTable : DataTable, IEnumerable
- {
- private DataColumn columnNo_Employee;
- private DataColumn columnName_Employee;
- private DataColumn columnEmployeeNo_Employee;
- private DataColumn columnNameEng_Employee;
- private DataColumn columnGender_Employee;
- private DataColumn columnCountry_Employee;
- private DataColumn columnHomeplace_Employee;
- private DataColumn columnNation_Employee;
- private DataColumn columnIDNo_Employee;
- private DataColumn columnPassport_Employee;
- private DataColumn columnIsMarried_Employee;
- private DataColumn columnCreateDate_Employee;
- private DataColumn columnDuty_Employee;
- private DataColumn columnProbation_Employee;
- private DataColumn columnOnJobDate_Employee;
- private DataColumn columnOnDuty_Employee;
- private DataColumn columnObJobStatus_Employee;
- private DataColumn columnOffDuty_Employee;
- private DataColumn columnSuspendDate_Employee;
- private DataColumn columnTel_Employee;
- private DataColumn columnEMail_Employee;
- private DataColumn columnAddress_Employee;
- private DataColumn columnComment_Employee;
- private DataColumn columnLastModDate_Employee;
- private DataColumn columnMarried_Employee;
- private DataColumn columnObJobStatus;
- private DataColumn columnCreatorName_Employee;
- private DataColumn columnLastModUser_EmployeeName;
- private DataColumn columnName_Department;
- private DataColumn columnNo_Department;
- private DataColumn columnCountryName;
- [DebuggerNonUserCode]
- public DataColumn No_EmployeeColumn => columnNo_Employee;
- [DebuggerNonUserCode]
- public DataColumn Name_EmployeeColumn => columnName_Employee;
- [DebuggerNonUserCode]
- public DataColumn EmployeeNo_EmployeeColumn => columnEmployeeNo_Employee;
- [DebuggerNonUserCode]
- public DataColumn NameEng_EmployeeColumn => columnNameEng_Employee;
- [DebuggerNonUserCode]
- public DataColumn Gender_EmployeeColumn => columnGender_Employee;
- [DebuggerNonUserCode]
- public DataColumn Country_EmployeeColumn => columnCountry_Employee;
- [DebuggerNonUserCode]
- public DataColumn Homeplace_EmployeeColumn => columnHomeplace_Employee;
- [DebuggerNonUserCode]
- public DataColumn Nation_EmployeeColumn => columnNation_Employee;
- [DebuggerNonUserCode]
- public DataColumn IDNo_EmployeeColumn => columnIDNo_Employee;
- [DebuggerNonUserCode]
- public DataColumn Passport_EmployeeColumn => columnPassport_Employee;
- [DebuggerNonUserCode]
- public DataColumn IsMarried_EmployeeColumn => columnIsMarried_Employee;
- [DebuggerNonUserCode]
- public DataColumn CreateDate_EmployeeColumn => columnCreateDate_Employee;
- [DebuggerNonUserCode]
- public DataColumn Duty_EmployeeColumn => columnDuty_Employee;
- [DebuggerNonUserCode]
- public DataColumn Probation_EmployeeColumn => columnProbation_Employee;
- [DebuggerNonUserCode]
- public DataColumn OnJobDate_EmployeeColumn => columnOnJobDate_Employee;
- [DebuggerNonUserCode]
- public DataColumn OnDuty_EmployeeColumn => columnOnDuty_Employee;
- [DebuggerNonUserCode]
- public DataColumn ObJobStatus_EmployeeColumn => columnObJobStatus_Employee;
- [DebuggerNonUserCode]
- public DataColumn OffDuty_EmployeeColumn => columnOffDuty_Employee;
- [DebuggerNonUserCode]
- public DataColumn SuspendDate_EmployeeColumn => columnSuspendDate_Employee;
- [DebuggerNonUserCode]
- public DataColumn Tel_EmployeeColumn => columnTel_Employee;
- [DebuggerNonUserCode]
- public DataColumn EMail_EmployeeColumn => columnEMail_Employee;
- [DebuggerNonUserCode]
- public DataColumn Address_EmployeeColumn => columnAddress_Employee;
- [DebuggerNonUserCode]
- public DataColumn Comment_EmployeeColumn => columnComment_Employee;
- [DebuggerNonUserCode]
- public DataColumn LastModDate_EmployeeColumn => columnLastModDate_Employee;
- [DebuggerNonUserCode]
- public DataColumn Married_EmployeeColumn => columnMarried_Employee;
- [DebuggerNonUserCode]
- public DataColumn ObJobStatusColumn => columnObJobStatus;
- [DebuggerNonUserCode]
- public DataColumn CreatorName_EmployeeColumn => columnCreatorName_Employee;
- [DebuggerNonUserCode]
- public DataColumn LastModUser_EmployeeNameColumn => columnLastModUser_EmployeeName;
- [DebuggerNonUserCode]
- public DataColumn Name_DepartmentColumn => columnName_Department;
- [DebuggerNonUserCode]
- public DataColumn No_DepartmentColumn => columnNo_Department;
- [DebuggerNonUserCode]
- public DataColumn CountryNameColumn => columnCountryName;
- [DebuggerNonUserCode]
- [Browsable(false)]
- public int Count => base.Rows.Count;
- [DebuggerNonUserCode]
- public EmployeeRow this[int index] => (EmployeeRow)base.Rows[index];
- public event EmployeeRowChangeEventHandler EmployeeRowChanging;
- public event EmployeeRowChangeEventHandler EmployeeRowChanged;
- public event EmployeeRowChangeEventHandler EmployeeRowDeleting;
- public event EmployeeRowChangeEventHandler EmployeeRowDeleted;
- [DebuggerNonUserCode]
- public EmployeeDataTable()
- {
- base.TableName = "Employee";
- BeginInit();
- InitClass();
- EndInit();
- }
- [DebuggerNonUserCode]
- internal EmployeeDataTable(DataTable table)
- {
- base.TableName = table.TableName;
- if (table.CaseSensitive != table.DataSet.CaseSensitive)
- {
- base.CaseSensitive = table.CaseSensitive;
- }
- if (table.Locale.ToString() != table.DataSet.Locale.ToString())
- {
- base.Locale = table.Locale;
- }
- if (table.Namespace != table.DataSet.Namespace)
- {
- base.Namespace = table.Namespace;
- }
- base.Prefix = table.Prefix;
- base.MinimumCapacity = table.MinimumCapacity;
- }
- [DebuggerNonUserCode]
- protected EmployeeDataTable(SerializationInfo info, StreamingContext context)
- : base(info, context)
- {
- InitVars();
- }
- [DebuggerNonUserCode]
- public void AddEmployeeRow(EmployeeRow row)
- {
- base.Rows.Add(row);
- }
- [DebuggerNonUserCode]
- public EmployeeRow AddEmployeeRow(string No_Employee, string Name_Employee, string EmployeeNo_Employee, string NameEng_Employee, bool Gender_Employee, int Country_Employee, string Homeplace_Employee, string Nation_Employee, string IDNo_Employee, string Passport_Employee, bool IsMarried_Employee, DateTime CreateDate_Employee, string Duty_Employee, decimal Probation_Employee, DateTime OnJobDate_Employee, DateTime OnDuty_Employee, int ObJobStatus_Employee, DateTime OffDuty_Employee, DateTime SuspendDate_Employee, string Tel_Employee, string EMail_Employee, string Address_Employee, string Comment_Employee, DateTime LastModDate_Employee, string Married_Employee, string ObJobStatus, string CreatorName_Employee, string LastModUser_EmployeeName, string Name_Department, string No_Department, string CountryName)
- {
- EmployeeRow employeeRow = (EmployeeRow)NewRow();
- employeeRow.ItemArray = new object[31]
- {
- No_Employee,
- Name_Employee,
- EmployeeNo_Employee,
- NameEng_Employee,
- Gender_Employee,
- Country_Employee,
- Homeplace_Employee,
- Nation_Employee,
- IDNo_Employee,
- Passport_Employee,
- IsMarried_Employee,
- CreateDate_Employee,
- Duty_Employee,
- Probation_Employee,
- OnJobDate_Employee,
- OnDuty_Employee,
- ObJobStatus_Employee,
- OffDuty_Employee,
- SuspendDate_Employee,
- Tel_Employee,
- EMail_Employee,
- Address_Employee,
- Comment_Employee,
- LastModDate_Employee,
- Married_Employee,
- ObJobStatus,
- CreatorName_Employee,
- LastModUser_EmployeeName,
- Name_Department,
- No_Department,
- CountryName
- };
- base.Rows.Add(employeeRow);
- return employeeRow;
- }
- [DebuggerNonUserCode]
- public virtual IEnumerator GetEnumerator()
- {
- return base.Rows.GetEnumerator();
- }
- [DebuggerNonUserCode]
- public override DataTable Clone()
- {
- EmployeeDataTable employeeDataTable = (EmployeeDataTable)base.Clone();
- employeeDataTable.InitVars();
- return employeeDataTable;
- }
- [DebuggerNonUserCode]
- protected override DataTable CreateInstance()
- {
- return new EmployeeDataTable();
- }
- [DebuggerNonUserCode]
- internal void InitVars()
- {
- columnNo_Employee = base.Columns["No_Employee"];
- columnName_Employee = base.Columns["Name_Employee"];
- columnEmployeeNo_Employee = base.Columns["EmployeeNo_Employee"];
- columnNameEng_Employee = base.Columns["NameEng_Employee"];
- columnGender_Employee = base.Columns["Gender_Employee"];
- columnCountry_Employee = base.Columns["Country_Employee"];
- columnHomeplace_Employee = base.Columns["Homeplace_Employee"];
- columnNation_Employee = base.Columns["Nation_Employee"];
- columnIDNo_Employee = base.Columns["IDNo_Employee"];
- columnPassport_Employee = base.Columns["Passport_Employee"];
- columnIsMarried_Employee = base.Columns["IsMarried_Employee"];
- columnCreateDate_Employee = base.Columns["CreateDate_Employee"];
- columnDuty_Employee = base.Columns["Duty_Employee"];
- columnProbation_Employee = base.Columns["Probation_Employee"];
- columnOnJobDate_Employee = base.Columns["OnJobDate_Employee"];
- columnOnDuty_Employee = base.Columns["OnDuty_Employee"];
- columnObJobStatus_Employee = base.Columns["ObJobStatus_Employee"];
- columnOffDuty_Employee = base.Columns["OffDuty_Employee"];
- columnSuspendDate_Employee = base.Columns["SuspendDate_Employee"];
- columnTel_Employee = base.Columns["Tel_Employee"];
- columnEMail_Employee = base.Columns["EMail_Employee"];
- columnAddress_Employee = base.Columns["Address_Employee"];
- columnComment_Employee = base.Columns["Comment_Employee"];
- columnLastModDate_Employee = base.Columns["LastModDate_Employee"];
- columnMarried_Employee = base.Columns["Married_Employee"];
- columnObJobStatus = base.Columns["ObJobStatus"];
- columnCreatorName_Employee = base.Columns["CreatorName_Employee"];
- columnLastModUser_EmployeeName = base.Columns["LastModUser_EmployeeName"];
- columnName_Department = base.Columns["Name_Department"];
- columnNo_Department = base.Columns["No_Department"];
- columnCountryName = base.Columns["CountryName"];
- }
- [DebuggerNonUserCode]
- private void InitClass()
- {
- columnNo_Employee = new DataColumn("No_Employee", typeof(string), null, MappingType.Element);
- base.Columns.Add(columnNo_Employee);
- columnName_Employee = new DataColumn("Name_Employee", typeof(string), null, MappingType.Element);
- base.Columns.Add(columnName_Employee);
- columnEmployeeNo_Employee = new DataColumn("EmployeeNo_Employee", typeof(string), null, MappingType.Element);
- base.Columns.Add(columnEmployeeNo_Employee);
- columnNameEng_Employee = new DataColumn("NameEng_Employee", typeof(string), null, MappingType.Element);
- base.Columns.Add(columnNameEng_Employee);
- columnGender_Employee = new DataColumn("Gender_Employee", typeof(bool), null, MappingType.Element);
- base.Columns.Add(columnGender_Employee);
- columnCountry_Employee = new DataColumn("Country_Employee", typeof(int), null, MappingType.Element);
- base.Columns.Add(columnCountry_Employee);
- columnHomeplace_Employee = new DataColumn("Homeplace_Employee", typeof(string), null, MappingType.Element);
- base.Columns.Add(columnHomeplace_Employee);
- columnNation_Employee = new DataColumn("Nation_Employee", typeof(string), null, MappingType.Element);
- base.Columns.Add(columnNation_Employee);
- columnIDNo_Employee = new DataColumn("IDNo_Employee", typeof(string), null, MappingType.Element);
- base.Columns.Add(columnIDNo_Employee);
- columnPassport_Employee = new DataColumn("Passport_Employee", typeof(string), null, MappingType.Element);
- base.Columns.Add(columnPassport_Employee);
- columnIsMarried_Employee = new DataColumn("IsMarried_Employee", typeof(bool), null, MappingType.Element);
- base.Columns.Add(columnIsMarried_Employee);
- columnCreateDate_Employee = new DataColumn("CreateDate_Employee", typeof(DateTime), null, MappingType.Element);
- base.Columns.Add(columnCreateDate_Employee);
- columnDuty_Employee = new DataColumn("Duty_Employee", typeof(string), null, MappingType.Element);
- base.Columns.Add(columnDuty_Employee);
- columnProbation_Employee = new DataColumn("Probation_Employee", typeof(decimal), null, MappingType.Element);
- base.Columns.Add(columnProbation_Employee);
- columnOnJobDate_Employee = new DataColumn("OnJobDate_Employee", typeof(DateTime), null, MappingType.Element);
- base.Columns.Add(columnOnJobDate_Employee);
- columnOnDuty_Employee = new DataColumn("OnDuty_Employee", typeof(DateTime), null, MappingType.Element);
- base.Columns.Add(columnOnDuty_Employee);
- columnObJobStatus_Employee = new DataColumn("ObJobStatus_Employee", typeof(int), null, MappingType.Element);
- base.Columns.Add(columnObJobStatus_Employee);
- columnOffDuty_Employee = new DataColumn("OffDuty_Employee", typeof(DateTime), null, MappingType.Element);
- base.Columns.Add(columnOffDuty_Employee);
- columnSuspendDate_Employee = new DataColumn("SuspendDate_Employee", typeof(DateTime), null, MappingType.Element);
- base.Columns.Add(columnSuspendDate_Employee);
- columnTel_Employee = new DataColumn("Tel_Employee", typeof(string), null, MappingType.Element);
- base.Columns.Add(columnTel_Employee);
- columnEMail_Employee = new DataColumn("EMail_Employee", typeof(string), null, MappingType.Element);
- base.Columns.Add(columnEMail_Employee);
- columnAddress_Employee = new DataColumn("Address_Employee", typeof(string), null, MappingType.Element);
- base.Columns.Add(columnAddress_Employee);
- columnComment_Employee = new DataColumn("Comment_Employee", typeof(string), null, MappingType.Element);
- base.Columns.Add(columnComment_Employee);
- columnLastModDate_Employee = new DataColumn("LastModDate_Employee", typeof(DateTime), null, MappingType.Element);
- base.Columns.Add(columnLastModDate_Employee);
- columnMarried_Employee = new DataColumn("Married_Employee", typeof(string), null, MappingType.Element);
- base.Columns.Add(columnMarried_Employee);
- columnObJobStatus = new DataColumn("ObJobStatus", typeof(string), null, MappingType.Element);
- base.Columns.Add(columnObJobStatus);
- columnCreatorName_Employee = new DataColumn("CreatorName_Employee", typeof(string), null, MappingType.Element);
- base.Columns.Add(columnCreatorName_Employee);
- columnLastModUser_EmployeeName = new DataColumn("LastModUser_EmployeeName", typeof(string), null, MappingType.Element);
- base.Columns.Add(columnLastModUser_EmployeeName);
- columnName_Department = new DataColumn("Name_Department", typeof(string), null, MappingType.Element);
- base.Columns.Add(columnName_Department);
- columnNo_Department = new DataColumn("No_Department", typeof(string), null, MappingType.Element);
- base.Columns.Add(columnNo_Department);
- columnCountryName = new DataColumn("CountryName", typeof(string), null, MappingType.Element);
- base.Columns.Add(columnCountryName);
- }
- [DebuggerNonUserCode]
- public EmployeeRow NewEmployeeRow()
- {
- return (EmployeeRow)NewRow();
- }
- [DebuggerNonUserCode]
- protected override DataRow NewRowFromBuilder(DataRowBuilder builder)
- {
- return new EmployeeRow(builder);
- }
- [DebuggerNonUserCode]
- protected override Type GetRowType()
- {
- return typeof(EmployeeRow);
- }
- [DebuggerNonUserCode]
- protected override void OnRowChanged(DataRowChangeEventArgs e)
- {
- base.OnRowChanged(e);
- if (this.EmployeeRowChanged != null)
- {
- this.EmployeeRowChanged(this, new EmployeeRowChangeEvent((EmployeeRow)e.Row, e.Action));
- }
- }
- [DebuggerNonUserCode]
- protected override void OnRowChanging(DataRowChangeEventArgs e)
- {
- base.OnRowChanging(e);
- if (this.EmployeeRowChanging != null)
- {
- this.EmployeeRowChanging(this, new EmployeeRowChangeEvent((EmployeeRow)e.Row, e.Action));
- }
- }
- [DebuggerNonUserCode]
- protected override void OnRowDeleted(DataRowChangeEventArgs e)
- {
- base.OnRowDeleted(e);
- if (this.EmployeeRowDeleted != null)
- {
- this.EmployeeRowDeleted(this, new EmployeeRowChangeEvent((EmployeeRow)e.Row, e.Action));
- }
- }
- [DebuggerNonUserCode]
- protected override void OnRowDeleting(DataRowChangeEventArgs e)
- {
- base.OnRowDeleting(e);
- if (this.EmployeeRowDeleting != null)
- {
- this.EmployeeRowDeleting(this, new EmployeeRowChangeEvent((EmployeeRow)e.Row, e.Action));
- }
- }
- [DebuggerNonUserCode]
- public void RemoveEmployeeRow(EmployeeRow row)
- {
- base.Rows.Remove(row);
- }
- [DebuggerNonUserCode]
- public static XmlSchemaComplexType GetTypedTableSchema(XmlSchemaSet xs)
- {
- XmlSchemaComplexType xmlSchemaComplexType = new XmlSchemaComplexType();
- XmlSchemaSequence xmlSchemaSequence = new XmlSchemaSequence();
- dsFrmEmployee dsFrmEmployee = new dsFrmEmployee();
- xs.Add(dsFrmEmployee.GetSchemaSerializable());
- XmlSchemaAny xmlSchemaAny = new XmlSchemaAny();
- xmlSchemaAny.Namespace = "http://www.w3.org/2001/XMLSchema";
- xmlSchemaAny.MinOccurs = 0m;
- xmlSchemaAny.MaxOccurs = decimal.MaxValue;
- xmlSchemaAny.ProcessContents = XmlSchemaContentProcessing.Lax;
- xmlSchemaSequence.Items.Add(xmlSchemaAny);
- XmlSchemaAny xmlSchemaAny2 = new XmlSchemaAny();
- xmlSchemaAny2.Namespace = "urn:schemas-microsoft-com:xml-diffgram-v1";
- xmlSchemaAny2.MinOccurs = 1m;
- xmlSchemaAny2.ProcessContents = XmlSchemaContentProcessing.Lax;
- xmlSchemaSequence.Items.Add(xmlSchemaAny2);
- XmlSchemaAttribute xmlSchemaAttribute = new XmlSchemaAttribute();
- xmlSchemaAttribute.Name = "namespace";
- xmlSchemaAttribute.FixedValue = dsFrmEmployee.Namespace;
- xmlSchemaComplexType.Attributes.Add(xmlSchemaAttribute);
- XmlSchemaAttribute xmlSchemaAttribute2 = new XmlSchemaAttribute();
- xmlSchemaAttribute2.Name = "tableTypeName";
- xmlSchemaAttribute2.FixedValue = "EmployeeDataTable";
- xmlSchemaComplexType.Attributes.Add(xmlSchemaAttribute2);
- xmlSchemaComplexType.Particle = xmlSchemaSequence;
- return xmlSchemaComplexType;
- }
- }
- [Serializable]
- [XmlSchemaProvider("GetTypedTableSchema")]
- [GeneratedCode("System.Data.Design.TypedDataSetGenerator", "2.0.0.0")]
- public class AppendInfoDataTable : DataTable, IEnumerable
- {
- private DataColumn columnCurrentCompany;
- private DataColumn columnCurrentUser;
- [DebuggerNonUserCode]
- public DataColumn CurrentCompanyColumn => columnCurrentCompany;
- [DebuggerNonUserCode]
- public DataColumn CurrentUserColumn => columnCurrentUser;
- [DebuggerNonUserCode]
- [Browsable(false)]
- public int Count => base.Rows.Count;
- [DebuggerNonUserCode]
- public AppendInfoRow this[int index] => (AppendInfoRow)base.Rows[index];
- public event AppendInfoRowChangeEventHandler AppendInfoRowChanging;
- public event AppendInfoRowChangeEventHandler AppendInfoRowChanged;
- public event AppendInfoRowChangeEventHandler AppendInfoRowDeleting;
- public event AppendInfoRowChangeEventHandler AppendInfoRowDeleted;
- [DebuggerNonUserCode]
- public AppendInfoDataTable()
- {
- base.TableName = "AppendInfo";
- BeginInit();
- InitClass();
- EndInit();
- }
- [DebuggerNonUserCode]
- internal AppendInfoDataTable(DataTable table)
- {
- base.TableName = table.TableName;
- if (table.CaseSensitive != table.DataSet.CaseSensitive)
- {
- base.CaseSensitive = table.CaseSensitive;
- }
- if (table.Locale.ToString() != table.DataSet.Locale.ToString())
- {
- base.Locale = table.Locale;
- }
- if (table.Namespace != table.DataSet.Namespace)
- {
- base.Namespace = table.Namespace;
- }
- base.Prefix = table.Prefix;
- base.MinimumCapacity = table.MinimumCapacity;
- }
- [DebuggerNonUserCode]
- protected AppendInfoDataTable(SerializationInfo info, StreamingContext context)
- : base(info, context)
- {
- InitVars();
- }
- [DebuggerNonUserCode]
- public void AddAppendInfoRow(AppendInfoRow row)
- {
- base.Rows.Add(row);
- }
- [DebuggerNonUserCode]
- public AppendInfoRow AddAppendInfoRow(string CurrentCompany, string CurrentUser)
- {
- AppendInfoRow appendInfoRow = (AppendInfoRow)NewRow();
- appendInfoRow.ItemArray = new object[2]
- {
- CurrentCompany,
- CurrentUser
- };
- base.Rows.Add(appendInfoRow);
- return appendInfoRow;
- }
- [DebuggerNonUserCode]
- public virtual IEnumerator GetEnumerator()
- {
- return base.Rows.GetEnumerator();
- }
- [DebuggerNonUserCode]
- public override DataTable Clone()
- {
- AppendInfoDataTable appendInfoDataTable = (AppendInfoDataTable)base.Clone();
- appendInfoDataTable.InitVars();
- return appendInfoDataTable;
- }
- [DebuggerNonUserCode]
- protected override DataTable CreateInstance()
- {
- return new AppendInfoDataTable();
- }
- [DebuggerNonUserCode]
- internal void InitVars()
- {
- columnCurrentCompany = base.Columns["CurrentCompany"];
- columnCurrentUser = base.Columns["CurrentUser"];
- }
- [DebuggerNonUserCode]
- private void InitClass()
- {
- columnCurrentCompany = new DataColumn("CurrentCompany", typeof(string), null, MappingType.Element);
- base.Columns.Add(columnCurrentCompany);
- columnCurrentUser = new DataColumn("CurrentUser", typeof(string), null, MappingType.Element);
- base.Columns.Add(columnCurrentUser);
- }
- [DebuggerNonUserCode]
- public AppendInfoRow NewAppendInfoRow()
- {
- return (AppendInfoRow)NewRow();
- }
- [DebuggerNonUserCode]
- protected override DataRow NewRowFromBuilder(DataRowBuilder builder)
- {
- return new AppendInfoRow(builder);
- }
- [DebuggerNonUserCode]
- protected override Type GetRowType()
- {
- return typeof(AppendInfoRow);
- }
- [DebuggerNonUserCode]
- protected override void OnRowChanged(DataRowChangeEventArgs e)
- {
- base.OnRowChanged(e);
- if (this.AppendInfoRowChanged != null)
- {
- this.AppendInfoRowChanged(this, new AppendInfoRowChangeEvent((AppendInfoRow)e.Row, e.Action));
- }
- }
- [DebuggerNonUserCode]
- protected override void OnRowChanging(DataRowChangeEventArgs e)
- {
- base.OnRowChanging(e);
- if (this.AppendInfoRowChanging != null)
- {
- this.AppendInfoRowChanging(this, new AppendInfoRowChangeEvent((AppendInfoRow)e.Row, e.Action));
- }
- }
- [DebuggerNonUserCode]
- protected override void OnRowDeleted(DataRowChangeEventArgs e)
- {
- base.OnRowDeleted(e);
- if (this.AppendInfoRowDeleted != null)
- {
- this.AppendInfoRowDeleted(this, new AppendInfoRowChangeEvent((AppendInfoRow)e.Row, e.Action));
- }
- }
- [DebuggerNonUserCode]
- protected override void OnRowDeleting(DataRowChangeEventArgs e)
- {
- base.OnRowDeleting(e);
- if (this.AppendInfoRowDeleting != null)
- {
- this.AppendInfoRowDeleting(this, new AppendInfoRowChangeEvent((AppendInfoRow)e.Row, e.Action));
- }
- }
- [DebuggerNonUserCode]
- public void RemoveAppendInfoRow(AppendInfoRow row)
- {
- base.Rows.Remove(row);
- }
- [DebuggerNonUserCode]
- public static XmlSchemaComplexType GetTypedTableSchema(XmlSchemaSet xs)
- {
- XmlSchemaComplexType xmlSchemaComplexType = new XmlSchemaComplexType();
- XmlSchemaSequence xmlSchemaSequence = new XmlSchemaSequence();
- dsFrmEmployee dsFrmEmployee = new dsFrmEmployee();
- xs.Add(dsFrmEmployee.GetSchemaSerializable());
- XmlSchemaAny xmlSchemaAny = new XmlSchemaAny();
- xmlSchemaAny.Namespace = "http://www.w3.org/2001/XMLSchema";
- xmlSchemaAny.MinOccurs = 0m;
- xmlSchemaAny.MaxOccurs = decimal.MaxValue;
- xmlSchemaAny.ProcessContents = XmlSchemaContentProcessing.Lax;
- xmlSchemaSequence.Items.Add(xmlSchemaAny);
- XmlSchemaAny xmlSchemaAny2 = new XmlSchemaAny();
- xmlSchemaAny2.Namespace = "urn:schemas-microsoft-com:xml-diffgram-v1";
- xmlSchemaAny2.MinOccurs = 1m;
- xmlSchemaAny2.ProcessContents = XmlSchemaContentProcessing.Lax;
- xmlSchemaSequence.Items.Add(xmlSchemaAny2);
- XmlSchemaAttribute xmlSchemaAttribute = new XmlSchemaAttribute();
- xmlSchemaAttribute.Name = "namespace";
- xmlSchemaAttribute.FixedValue = dsFrmEmployee.Namespace;
- xmlSchemaComplexType.Attributes.Add(xmlSchemaAttribute);
- XmlSchemaAttribute xmlSchemaAttribute2 = new XmlSchemaAttribute();
- xmlSchemaAttribute2.Name = "tableTypeName";
- xmlSchemaAttribute2.FixedValue = "AppendInfoDataTable";
- xmlSchemaComplexType.Attributes.Add(xmlSchemaAttribute2);
- xmlSchemaComplexType.Particle = xmlSchemaSequence;
- return xmlSchemaComplexType;
- }
- }
- [GeneratedCode("System.Data.Design.TypedDataSetGenerator", "2.0.0.0")]
- public class EmployeeRow : DataRow
- {
- private EmployeeDataTable tableEmployee;
- [DebuggerNonUserCode]
- public string No_Employee
- {
- get
- {
- try
- {
- return (string)base[tableEmployee.No_EmployeeColumn];
- }
- catch (InvalidCastException innerException)
- {
- throw new StrongTypingException("The value for column 'No_Employee' in table 'Employee' is DBNull.", innerException);
- }
- }
- set
- {
- base[tableEmployee.No_EmployeeColumn] = value;
- }
- }
- [DebuggerNonUserCode]
- public string Name_Employee
- {
- get
- {
- try
- {
- return (string)base[tableEmployee.Name_EmployeeColumn];
- }
- catch (InvalidCastException innerException)
- {
- throw new StrongTypingException("The value for column 'Name_Employee' in table 'Employee' is DBNull.", innerException);
- }
- }
- set
- {
- base[tableEmployee.Name_EmployeeColumn] = value;
- }
- }
- [DebuggerNonUserCode]
- public string EmployeeNo_Employee
- {
- get
- {
- try
- {
- return (string)base[tableEmployee.EmployeeNo_EmployeeColumn];
- }
- catch (InvalidCastException innerException)
- {
- throw new StrongTypingException("The value for column 'EmployeeNo_Employee' in table 'Employee' is DBNull.", innerException);
- }
- }
- set
- {
- base[tableEmployee.EmployeeNo_EmployeeColumn] = value;
- }
- }
- [DebuggerNonUserCode]
- public string NameEng_Employee
- {
- get
- {
- try
- {
- return (string)base[tableEmployee.NameEng_EmployeeColumn];
- }
- catch (InvalidCastException innerException)
- {
- throw new StrongTypingException("The value for column 'NameEng_Employee' in table 'Employee' is DBNull.", innerException);
- }
- }
- set
- {
- base[tableEmployee.NameEng_EmployeeColumn] = value;
- }
- }
- [DebuggerNonUserCode]
- public bool Gender_Employee
- {
- get
- {
- try
- {
- return (bool)base[tableEmployee.Gender_EmployeeColumn];
- }
- catch (InvalidCastException innerException)
- {
- throw new StrongTypingException("The value for column 'Gender_Employee' in table 'Employee' is DBNull.", innerException);
- }
- }
- set
- {
- base[tableEmployee.Gender_EmployeeColumn] = value;
- }
- }
- [DebuggerNonUserCode]
- public int Country_Employee
- {
- get
- {
- try
- {
- return (int)base[tableEmployee.Country_EmployeeColumn];
- }
- catch (InvalidCastException innerException)
- {
- throw new StrongTypingException("The value for column 'Country_Employee' in table 'Employee' is DBNull.", innerException);
- }
- }
- set
- {
- base[tableEmployee.Country_EmployeeColumn] = value;
- }
- }
- [DebuggerNonUserCode]
- public string Homeplace_Employee
- {
- get
- {
- try
- {
- return (string)base[tableEmployee.Homeplace_EmployeeColumn];
- }
- catch (InvalidCastException innerException)
- {
- throw new StrongTypingException("The value for column 'Homeplace_Employee' in table 'Employee' is DBNull.", innerException);
- }
- }
- set
- {
- base[tableEmployee.Homeplace_EmployeeColumn] = value;
- }
- }
- [DebuggerNonUserCode]
- public string Nation_Employee
- {
- get
- {
- try
- {
- return (string)base[tableEmployee.Nation_EmployeeColumn];
- }
- catch (InvalidCastException innerException)
- {
- throw new StrongTypingException("The value for column 'Nation_Employee' in table 'Employee' is DBNull.", innerException);
- }
- }
- set
- {
- base[tableEmployee.Nation_EmployeeColumn] = value;
- }
- }
- [DebuggerNonUserCode]
- public string IDNo_Employee
- {
- get
- {
- try
- {
- return (string)base[tableEmployee.IDNo_EmployeeColumn];
- }
- catch (InvalidCastException innerException)
- {
- throw new StrongTypingException("The value for column 'IDNo_Employee' in table 'Employee' is DBNull.", innerException);
- }
- }
- set
- {
- base[tableEmployee.IDNo_EmployeeColumn] = value;
- }
- }
- [DebuggerNonUserCode]
- public string Passport_Employee
- {
- get
- {
- try
- {
- return (string)base[tableEmployee.Passport_EmployeeColumn];
- }
- catch (InvalidCastException innerException)
- {
- throw new StrongTypingException("The value for column 'Passport_Employee' in table 'Employee' is DBNull.", innerException);
- }
- }
- set
- {
- base[tableEmployee.Passport_EmployeeColumn] = value;
- }
- }
- [DebuggerNonUserCode]
- public bool IsMarried_Employee
- {
- get
- {
- try
- {
- return (bool)base[tableEmployee.IsMarried_EmployeeColumn];
- }
- catch (InvalidCastException innerException)
- {
- throw new StrongTypingException("The value for column 'IsMarried_Employee' in table 'Employee' is DBNull.", innerException);
- }
- }
- set
- {
- base[tableEmployee.IsMarried_EmployeeColumn] = value;
- }
- }
- [DebuggerNonUserCode]
- public DateTime CreateDate_Employee
- {
- get
- {
- try
- {
- return (DateTime)base[tableEmployee.CreateDate_EmployeeColumn];
- }
- catch (InvalidCastException innerException)
- {
- throw new StrongTypingException("The value for column 'CreateDate_Employee' in table 'Employee' is DBNull.", innerException);
- }
- }
- set
- {
- base[tableEmployee.CreateDate_EmployeeColumn] = value;
- }
- }
- [DebuggerNonUserCode]
- public string Duty_Employee
- {
- get
- {
- try
- {
- return (string)base[tableEmployee.Duty_EmployeeColumn];
- }
- catch (InvalidCastException innerException)
- {
- throw new StrongTypingException("The value for column 'Duty_Employee' in table 'Employee' is DBNull.", innerException);
- }
- }
- set
- {
- base[tableEmployee.Duty_EmployeeColumn] = value;
- }
- }
- [DebuggerNonUserCode]
- public decimal Probation_Employee
- {
- get
- {
- try
- {
- return (decimal)base[tableEmployee.Probation_EmployeeColumn];
- }
- catch (InvalidCastException innerException)
- {
- throw new StrongTypingException("The value for column 'Probation_Employee' in table 'Employee' is DBNull.", innerException);
- }
- }
- set
- {
- base[tableEmployee.Probation_EmployeeColumn] = value;
- }
- }
- [DebuggerNonUserCode]
- public DateTime OnJobDate_Employee
- {
- get
- {
- try
- {
- return (DateTime)base[tableEmployee.OnJobDate_EmployeeColumn];
- }
- catch (InvalidCastException innerException)
- {
- throw new StrongTypingException("The value for column 'OnJobDate_Employee' in table 'Employee' is DBNull.", innerException);
- }
- }
- set
- {
- base[tableEmployee.OnJobDate_EmployeeColumn] = value;
- }
- }
- [DebuggerNonUserCode]
- public DateTime OnDuty_Employee
- {
- get
- {
- try
- {
- return (DateTime)base[tableEmployee.OnDuty_EmployeeColumn];
- }
- catch (InvalidCastException innerException)
- {
- throw new StrongTypingException("The value for column 'OnDuty_Employee' in table 'Employee' is DBNull.", innerException);
- }
- }
- set
- {
- base[tableEmployee.OnDuty_EmployeeColumn] = value;
- }
- }
- [DebuggerNonUserCode]
- public int ObJobStatus_Employee
- {
- get
- {
- try
- {
- return (int)base[tableEmployee.ObJobStatus_EmployeeColumn];
- }
- catch (InvalidCastException innerException)
- {
- throw new StrongTypingException("The value for column 'ObJobStatus_Employee' in table 'Employee' is DBNull.", innerException);
- }
- }
- set
- {
- base[tableEmployee.ObJobStatus_EmployeeColumn] = value;
- }
- }
- [DebuggerNonUserCode]
- public DateTime OffDuty_Employee
- {
- get
- {
- try
- {
- return (DateTime)base[tableEmployee.OffDuty_EmployeeColumn];
- }
- catch (InvalidCastException innerException)
- {
- throw new StrongTypingException("The value for column 'OffDuty_Employee' in table 'Employee' is DBNull.", innerException);
- }
- }
- set
- {
- base[tableEmployee.OffDuty_EmployeeColumn] = value;
- }
- }
- [DebuggerNonUserCode]
- public DateTime SuspendDate_Employee
- {
- get
- {
- try
- {
- return (DateTime)base[tableEmployee.SuspendDate_EmployeeColumn];
- }
- catch (InvalidCastException innerException)
- {
- throw new StrongTypingException("The value for column 'SuspendDate_Employee' in table 'Employee' is DBNull.", innerException);
- }
- }
- set
- {
- base[tableEmployee.SuspendDate_EmployeeColumn] = value;
- }
- }
- [DebuggerNonUserCode]
- public string Tel_Employee
- {
- get
- {
- try
- {
- return (string)base[tableEmployee.Tel_EmployeeColumn];
- }
- catch (InvalidCastException innerException)
- {
- throw new StrongTypingException("The value for column 'Tel_Employee' in table 'Employee' is DBNull.", innerException);
- }
- }
- set
- {
- base[tableEmployee.Tel_EmployeeColumn] = value;
- }
- }
- [DebuggerNonUserCode]
- public string EMail_Employee
- {
- get
- {
- try
- {
- return (string)base[tableEmployee.EMail_EmployeeColumn];
- }
- catch (InvalidCastException innerException)
- {
- throw new StrongTypingException("The value for column 'EMail_Employee' in table 'Employee' is DBNull.", innerException);
- }
- }
- set
- {
- base[tableEmployee.EMail_EmployeeColumn] = value;
- }
- }
- [DebuggerNonUserCode]
- public string Address_Employee
- {
- get
- {
- try
- {
- return (string)base[tableEmployee.Address_EmployeeColumn];
- }
- catch (InvalidCastException innerException)
- {
- throw new StrongTypingException("The value for column 'Address_Employee' in table 'Employee' is DBNull.", innerException);
- }
- }
- set
- {
- base[tableEmployee.Address_EmployeeColumn] = value;
- }
- }
- [DebuggerNonUserCode]
- public string Comment_Employee
- {
- get
- {
- try
- {
- return (string)base[tableEmployee.Comment_EmployeeColumn];
- }
- catch (InvalidCastException innerException)
- {
- throw new StrongTypingException("The value for column 'Comment_Employee' in table 'Employee' is DBNull.", innerException);
- }
- }
- set
- {
- base[tableEmployee.Comment_EmployeeColumn] = value;
- }
- }
- [DebuggerNonUserCode]
- public DateTime LastModDate_Employee
- {
- get
- {
- try
- {
- return (DateTime)base[tableEmployee.LastModDate_EmployeeColumn];
- }
- catch (InvalidCastException innerException)
- {
- throw new StrongTypingException("The value for column 'LastModDate_Employee' in table 'Employee' is DBNull.", innerException);
- }
- }
- set
- {
- base[tableEmployee.LastModDate_EmployeeColumn] = value;
- }
- }
- [DebuggerNonUserCode]
- public string Married_Employee
- {
- get
- {
- try
- {
- return (string)base[tableEmployee.Married_EmployeeColumn];
- }
- catch (InvalidCastException innerException)
- {
- throw new StrongTypingException("The value for column 'Married_Employee' in table 'Employee' is DBNull.", innerException);
- }
- }
- set
- {
- base[tableEmployee.Married_EmployeeColumn] = value;
- }
- }
- [DebuggerNonUserCode]
- public string ObJobStatus
- {
- get
- {
- try
- {
- return (string)base[tableEmployee.ObJobStatusColumn];
- }
- catch (InvalidCastException innerException)
- {
- throw new StrongTypingException("The value for column 'ObJobStatus' in table 'Employee' is DBNull.", innerException);
- }
- }
- set
- {
- base[tableEmployee.ObJobStatusColumn] = value;
- }
- }
- [DebuggerNonUserCode]
- public string CreatorName_Employee
- {
- get
- {
- try
- {
- return (string)base[tableEmployee.CreatorName_EmployeeColumn];
- }
- catch (InvalidCastException innerException)
- {
- throw new StrongTypingException("The value for column 'CreatorName_Employee' in table 'Employee' is DBNull.", innerException);
- }
- }
- set
- {
- base[tableEmployee.CreatorName_EmployeeColumn] = value;
- }
- }
- [DebuggerNonUserCode]
- public string LastModUser_EmployeeName
- {
- get
- {
- try
- {
- return (string)base[tableEmployee.LastModUser_EmployeeNameColumn];
- }
- catch (InvalidCastException innerException)
- {
- throw new StrongTypingException("The value for column 'LastModUser_EmployeeName' in table 'Employee' is DBNull.", innerException);
- }
- }
- set
- {
- base[tableEmployee.LastModUser_EmployeeNameColumn] = value;
- }
- }
- [DebuggerNonUserCode]
- public string Name_Department
- {
- get
- {
- try
- {
- return (string)base[tableEmployee.Name_DepartmentColumn];
- }
- catch (InvalidCastException innerException)
- {
- throw new StrongTypingException("The value for column 'Name_Department' in table 'Employee' is DBNull.", innerException);
- }
- }
- set
- {
- base[tableEmployee.Name_DepartmentColumn] = value;
- }
- }
- [DebuggerNonUserCode]
- public string No_Department
- {
- get
- {
- try
- {
- return (string)base[tableEmployee.No_DepartmentColumn];
- }
- catch (InvalidCastException innerException)
- {
- throw new StrongTypingException("The value for column 'No_Department' in table 'Employee' is DBNull.", innerException);
- }
- }
- set
- {
- base[tableEmployee.No_DepartmentColumn] = value;
- }
- }
- [DebuggerNonUserCode]
- public string CountryName
- {
- get
- {
- try
- {
- return (string)base[tableEmployee.CountryNameColumn];
- }
- catch (InvalidCastException innerException)
- {
- throw new StrongTypingException("The value for column 'CountryName' in table 'Employee' is DBNull.", innerException);
- }
- }
- set
- {
- base[tableEmployee.CountryNameColumn] = value;
- }
- }
- [DebuggerNonUserCode]
- internal EmployeeRow(DataRowBuilder rb)
- : base(rb)
- {
- tableEmployee = (EmployeeDataTable)base.Table;
- }
- [DebuggerNonUserCode]
- public bool IsNo_EmployeeNull()
- {
- return IsNull(tableEmployee.No_EmployeeColumn);
- }
- [DebuggerNonUserCode]
- public void SetNo_EmployeeNull()
- {
- base[tableEmployee.No_EmployeeColumn] = Convert.DBNull;
- }
- [DebuggerNonUserCode]
- public bool IsName_EmployeeNull()
- {
- return IsNull(tableEmployee.Name_EmployeeColumn);
- }
- [DebuggerNonUserCode]
- public void SetName_EmployeeNull()
- {
- base[tableEmployee.Name_EmployeeColumn] = Convert.DBNull;
- }
- [DebuggerNonUserCode]
- public bool IsEmployeeNo_EmployeeNull()
- {
- return IsNull(tableEmployee.EmployeeNo_EmployeeColumn);
- }
- [DebuggerNonUserCode]
- public void SetEmployeeNo_EmployeeNull()
- {
- base[tableEmployee.EmployeeNo_EmployeeColumn] = Convert.DBNull;
- }
- [DebuggerNonUserCode]
- public bool IsNameEng_EmployeeNull()
- {
- return IsNull(tableEmployee.NameEng_EmployeeColumn);
- }
- [DebuggerNonUserCode]
- public void SetNameEng_EmployeeNull()
- {
- base[tableEmployee.NameEng_EmployeeColumn] = Convert.DBNull;
- }
- [DebuggerNonUserCode]
- public bool IsGender_EmployeeNull()
- {
- return IsNull(tableEmployee.Gender_EmployeeColumn);
- }
- [DebuggerNonUserCode]
- public void SetGender_EmployeeNull()
- {
- base[tableEmployee.Gender_EmployeeColumn] = Convert.DBNull;
- }
- [DebuggerNonUserCode]
- public bool IsCountry_EmployeeNull()
- {
- return IsNull(tableEmployee.Country_EmployeeColumn);
- }
- [DebuggerNonUserCode]
- public void SetCountry_EmployeeNull()
- {
- base[tableEmployee.Country_EmployeeColumn] = Convert.DBNull;
- }
- [DebuggerNonUserCode]
- public bool IsHomeplace_EmployeeNull()
- {
- return IsNull(tableEmployee.Homeplace_EmployeeColumn);
- }
- [DebuggerNonUserCode]
- public void SetHomeplace_EmployeeNull()
- {
- base[tableEmployee.Homeplace_EmployeeColumn] = Convert.DBNull;
- }
- [DebuggerNonUserCode]
- public bool IsNation_EmployeeNull()
- {
- return IsNull(tableEmployee.Nation_EmployeeColumn);
- }
- [DebuggerNonUserCode]
- public void SetNation_EmployeeNull()
- {
- base[tableEmployee.Nation_EmployeeColumn] = Convert.DBNull;
- }
- [DebuggerNonUserCode]
- public bool IsIDNo_EmployeeNull()
- {
- return IsNull(tableEmployee.IDNo_EmployeeColumn);
- }
- [DebuggerNonUserCode]
- public void SetIDNo_EmployeeNull()
- {
- base[tableEmployee.IDNo_EmployeeColumn] = Convert.DBNull;
- }
- [DebuggerNonUserCode]
- public bool IsPassport_EmployeeNull()
- {
- return IsNull(tableEmployee.Passport_EmployeeColumn);
- }
- [DebuggerNonUserCode]
- public void SetPassport_EmployeeNull()
- {
- base[tableEmployee.Passport_EmployeeColumn] = Convert.DBNull;
- }
- [DebuggerNonUserCode]
- public bool IsIsMarried_EmployeeNull()
- {
- return IsNull(tableEmployee.IsMarried_EmployeeColumn);
- }
- [DebuggerNonUserCode]
- public void SetIsMarried_EmployeeNull()
- {
- base[tableEmployee.IsMarried_EmployeeColumn] = Convert.DBNull;
- }
- [DebuggerNonUserCode]
- public bool IsCreateDate_EmployeeNull()
- {
- return IsNull(tableEmployee.CreateDate_EmployeeColumn);
- }
- [DebuggerNonUserCode]
- public void SetCreateDate_EmployeeNull()
- {
- base[tableEmployee.CreateDate_EmployeeColumn] = Convert.DBNull;
- }
- [DebuggerNonUserCode]
- public bool IsDuty_EmployeeNull()
- {
- return IsNull(tableEmployee.Duty_EmployeeColumn);
- }
- [DebuggerNonUserCode]
- public void SetDuty_EmployeeNull()
- {
- base[tableEmployee.Duty_EmployeeColumn] = Convert.DBNull;
- }
- [DebuggerNonUserCode]
- public bool IsProbation_EmployeeNull()
- {
- return IsNull(tableEmployee.Probation_EmployeeColumn);
- }
- [DebuggerNonUserCode]
- public void SetProbation_EmployeeNull()
- {
- base[tableEmployee.Probation_EmployeeColumn] = Convert.DBNull;
- }
- [DebuggerNonUserCode]
- public bool IsOnJobDate_EmployeeNull()
- {
- return IsNull(tableEmployee.OnJobDate_EmployeeColumn);
- }
- [DebuggerNonUserCode]
- public void SetOnJobDate_EmployeeNull()
- {
- base[tableEmployee.OnJobDate_EmployeeColumn] = Convert.DBNull;
- }
- [DebuggerNonUserCode]
- public bool IsOnDuty_EmployeeNull()
- {
- return IsNull(tableEmployee.OnDuty_EmployeeColumn);
- }
- [DebuggerNonUserCode]
- public void SetOnDuty_EmployeeNull()
- {
- base[tableEmployee.OnDuty_EmployeeColumn] = Convert.DBNull;
- }
- [DebuggerNonUserCode]
- public bool IsObJobStatus_EmployeeNull()
- {
- return IsNull(tableEmployee.ObJobStatus_EmployeeColumn);
- }
- [DebuggerNonUserCode]
- public void SetObJobStatus_EmployeeNull()
- {
- base[tableEmployee.ObJobStatus_EmployeeColumn] = Convert.DBNull;
- }
- [DebuggerNonUserCode]
- public bool IsOffDuty_EmployeeNull()
- {
- return IsNull(tableEmployee.OffDuty_EmployeeColumn);
- }
- [DebuggerNonUserCode]
- public void SetOffDuty_EmployeeNull()
- {
- base[tableEmployee.OffDuty_EmployeeColumn] = Convert.DBNull;
- }
- [DebuggerNonUserCode]
- public bool IsSuspendDate_EmployeeNull()
- {
- return IsNull(tableEmployee.SuspendDate_EmployeeColumn);
- }
- [DebuggerNonUserCode]
- public void SetSuspendDate_EmployeeNull()
- {
- base[tableEmployee.SuspendDate_EmployeeColumn] = Convert.DBNull;
- }
- [DebuggerNonUserCode]
- public bool IsTel_EmployeeNull()
- {
- return IsNull(tableEmployee.Tel_EmployeeColumn);
- }
- [DebuggerNonUserCode]
- public void SetTel_EmployeeNull()
- {
- base[tableEmployee.Tel_EmployeeColumn] = Convert.DBNull;
- }
- [DebuggerNonUserCode]
- public bool IsEMail_EmployeeNull()
- {
- return IsNull(tableEmployee.EMail_EmployeeColumn);
- }
- [DebuggerNonUserCode]
- public void SetEMail_EmployeeNull()
- {
- base[tableEmployee.EMail_EmployeeColumn] = Convert.DBNull;
- }
- [DebuggerNonUserCode]
- public bool IsAddress_EmployeeNull()
- {
- return IsNull(tableEmployee.Address_EmployeeColumn);
- }
- [DebuggerNonUserCode]
- public void SetAddress_EmployeeNull()
- {
- base[tableEmployee.Address_EmployeeColumn] = Convert.DBNull;
- }
- [DebuggerNonUserCode]
- public bool IsComment_EmployeeNull()
- {
- return IsNull(tableEmployee.Comment_EmployeeColumn);
- }
- [DebuggerNonUserCode]
- public void SetComment_EmployeeNull()
- {
- base[tableEmployee.Comment_EmployeeColumn] = Convert.DBNull;
- }
- [DebuggerNonUserCode]
- public bool IsLastModDate_EmployeeNull()
- {
- return IsNull(tableEmployee.LastModDate_EmployeeColumn);
- }
- [DebuggerNonUserCode]
- public void SetLastModDate_EmployeeNull()
- {
- base[tableEmployee.LastModDate_EmployeeColumn] = Convert.DBNull;
- }
- [DebuggerNonUserCode]
- public bool IsMarried_EmployeeNull()
- {
- return IsNull(tableEmployee.Married_EmployeeColumn);
- }
- [DebuggerNonUserCode]
- public void SetMarried_EmployeeNull()
- {
- base[tableEmployee.Married_EmployeeColumn] = Convert.DBNull;
- }
- [DebuggerNonUserCode]
- public bool IsObJobStatusNull()
- {
- return IsNull(tableEmployee.ObJobStatusColumn);
- }
- [DebuggerNonUserCode]
- public void SetObJobStatusNull()
- {
- base[tableEmployee.ObJobStatusColumn] = Convert.DBNull;
- }
- [DebuggerNonUserCode]
- public bool IsCreatorName_EmployeeNull()
- {
- return IsNull(tableEmployee.CreatorName_EmployeeColumn);
- }
- [DebuggerNonUserCode]
- public void SetCreatorName_EmployeeNull()
- {
- base[tableEmployee.CreatorName_EmployeeColumn] = Convert.DBNull;
- }
- [DebuggerNonUserCode]
- public bool IsLastModUser_EmployeeNameNull()
- {
- return IsNull(tableEmployee.LastModUser_EmployeeNameColumn);
- }
- [DebuggerNonUserCode]
- public void SetLastModUser_EmployeeNameNull()
- {
- base[tableEmployee.LastModUser_EmployeeNameColumn] = Convert.DBNull;
- }
- [DebuggerNonUserCode]
- public bool IsName_DepartmentNull()
- {
- return IsNull(tableEmployee.Name_DepartmentColumn);
- }
- [DebuggerNonUserCode]
- public void SetName_DepartmentNull()
- {
- base[tableEmployee.Name_DepartmentColumn] = Convert.DBNull;
- }
- [DebuggerNonUserCode]
- public bool IsNo_DepartmentNull()
- {
- return IsNull(tableEmployee.No_DepartmentColumn);
- }
- [DebuggerNonUserCode]
- public void SetNo_DepartmentNull()
- {
- base[tableEmployee.No_DepartmentColumn] = Convert.DBNull;
- }
- [DebuggerNonUserCode]
- public bool IsCountryNameNull()
- {
- return IsNull(tableEmployee.CountryNameColumn);
- }
- [DebuggerNonUserCode]
- public void SetCountryNameNull()
- {
- base[tableEmployee.CountryNameColumn] = Convert.DBNull;
- }
- }
- [GeneratedCode("System.Data.Design.TypedDataSetGenerator", "2.0.0.0")]
- public class AppendInfoRow : DataRow
- {
- private AppendInfoDataTable tableAppendInfo;
- [DebuggerNonUserCode]
- public string CurrentCompany
- {
- get
- {
- try
- {
- return (string)base[tableAppendInfo.CurrentCompanyColumn];
- }
- catch (InvalidCastException innerException)
- {
- throw new StrongTypingException("The value for column 'CurrentCompany' in table 'AppendInfo' is DBNull.", innerException);
- }
- }
- set
- {
- base[tableAppendInfo.CurrentCompanyColumn] = value;
- }
- }
- [DebuggerNonUserCode]
- public string CurrentUser
- {
- get
- {
- try
- {
- return (string)base[tableAppendInfo.CurrentUserColumn];
- }
- catch (InvalidCastException innerException)
- {
- throw new StrongTypingException("The value for column 'CurrentUser' in table 'AppendInfo' is DBNull.", innerException);
- }
- }
- set
- {
- base[tableAppendInfo.CurrentUserColumn] = value;
- }
- }
- [DebuggerNonUserCode]
- internal AppendInfoRow(DataRowBuilder rb)
- : base(rb)
- {
- tableAppendInfo = (AppendInfoDataTable)base.Table;
- }
- [DebuggerNonUserCode]
- public bool IsCurrentCompanyNull()
- {
- return IsNull(tableAppendInfo.CurrentCompanyColumn);
- }
- [DebuggerNonUserCode]
- public void SetCurrentCompanyNull()
- {
- base[tableAppendInfo.CurrentCompanyColumn] = Convert.DBNull;
- }
- [DebuggerNonUserCode]
- public bool IsCurrentUserNull()
- {
- return IsNull(tableAppendInfo.CurrentUserColumn);
- }
- [DebuggerNonUserCode]
- public void SetCurrentUserNull()
- {
- base[tableAppendInfo.CurrentUserColumn] = Convert.DBNull;
- }
- }
- [GeneratedCode("System.Data.Design.TypedDataSetGenerator", "2.0.0.0")]
- public class EmployeeRowChangeEvent : EventArgs
- {
- private EmployeeRow eventRow;
- private DataRowAction eventAction;
- [DebuggerNonUserCode]
- public EmployeeRow Row => eventRow;
- [DebuggerNonUserCode]
- public DataRowAction Action => eventAction;
- [DebuggerNonUserCode]
- public EmployeeRowChangeEvent(EmployeeRow row, DataRowAction action)
- {
- eventRow = row;
- eventAction = action;
- }
- }
- [GeneratedCode("System.Data.Design.TypedDataSetGenerator", "2.0.0.0")]
- public class AppendInfoRowChangeEvent : EventArgs
- {
- private AppendInfoRow eventRow;
- private DataRowAction eventAction;
- [DebuggerNonUserCode]
- public AppendInfoRow Row => eventRow;
- [DebuggerNonUserCode]
- public DataRowAction Action => eventAction;
- [DebuggerNonUserCode]
- public AppendInfoRowChangeEvent(AppendInfoRow row, DataRowAction action)
- {
- eventRow = row;
- eventAction = action;
- }
- }
- private EmployeeDataTable tableEmployee;
- private AppendInfoDataTable tableAppendInfo;
- private SchemaSerializationMode _schemaSerializationMode = SchemaSerializationMode.IncludeSchema;
- [DesignerSerializationVisibility(DesignerSerializationVisibility.Content)]
- [DebuggerNonUserCode]
- [Browsable(false)]
- public EmployeeDataTable Employee => tableEmployee;
- [Browsable(false)]
- [DebuggerNonUserCode]
- [DesignerSerializationVisibility(DesignerSerializationVisibility.Content)]
- public AppendInfoDataTable AppendInfo => tableAppendInfo;
- [DebuggerNonUserCode]
- [DesignerSerializationVisibility(DesignerSerializationVisibility.Visible)]
- [Browsable(true)]
- public override SchemaSerializationMode SchemaSerializationMode
- {
- get
- {
- return _schemaSerializationMode;
- }
- set
- {
- _schemaSerializationMode = value;
- }
- }
- [DebuggerNonUserCode]
- [DesignerSerializationVisibility(DesignerSerializationVisibility.Hidden)]
- public new DataTableCollection Tables => base.Tables;
- [DebuggerNonUserCode]
- [DesignerSerializationVisibility(DesignerSerializationVisibility.Hidden)]
- public new DataRelationCollection Relations => base.Relations;
- [DebuggerNonUserCode]
- public dsFrmEmployee()
- {
- BeginInit();
- InitClass();
- CollectionChangeEventHandler value = SchemaChanged;
- base.Tables.CollectionChanged += value;
- base.Relations.CollectionChanged += value;
- EndInit();
- }
- [DebuggerNonUserCode]
- protected dsFrmEmployee(SerializationInfo info, StreamingContext context)
- : base(info, context, ConstructSchema: false)
- {
- if (IsBinarySerialized(info, context))
- {
- InitVars(initTable: false);
- CollectionChangeEventHandler value = SchemaChanged;
- Tables.CollectionChanged += value;
- Relations.CollectionChanged += value;
- return;
- }
- string s = (string)info.GetValue("XmlSchema", typeof(string));
- if (DetermineSchemaSerializationMode(info, context) == SchemaSerializationMode.IncludeSchema)
- {
- DataSet dataSet = new DataSet();
- dataSet.ReadXmlSchema(new XmlTextReader(new StringReader(s)));
- if (dataSet.Tables["Employee"] != null)
- {
- base.Tables.Add(new EmployeeDataTable(dataSet.Tables["Employee"]));
- }
- if (dataSet.Tables["AppendInfo"] != null)
- {
- base.Tables.Add(new AppendInfoDataTable(dataSet.Tables["AppendInfo"]));
- }
- base.DataSetName = dataSet.DataSetName;
- base.Prefix = dataSet.Prefix;
- base.Namespace = dataSet.Namespace;
- base.Locale = dataSet.Locale;
- base.CaseSensitive = dataSet.CaseSensitive;
- base.EnforceConstraints = dataSet.EnforceConstraints;
- Merge(dataSet, preserveChanges: false, MissingSchemaAction.Add);
- InitVars();
- }
- else
- {
- ReadXmlSchema(new XmlTextReader(new StringReader(s)));
- }
- GetSerializationData(info, context);
- CollectionChangeEventHandler value2 = SchemaChanged;
- base.Tables.CollectionChanged += value2;
- Relations.CollectionChanged += value2;
- }
- [DebuggerNonUserCode]
- protected override void InitializeDerivedDataSet()
- {
- BeginInit();
- InitClass();
- EndInit();
- }
- [DebuggerNonUserCode]
- public override DataSet Clone()
- {
- dsFrmEmployee dsFrmEmployee = (dsFrmEmployee)base.Clone();
- dsFrmEmployee.InitVars();
- dsFrmEmployee.SchemaSerializationMode = SchemaSerializationMode;
- return dsFrmEmployee;
- }
- [DebuggerNonUserCode]
- protected override bool ShouldSerializeTables()
- {
- return false;
- }
- [DebuggerNonUserCode]
- protected override bool ShouldSerializeRelations()
- {
- return false;
- }
- [DebuggerNonUserCode]
- protected override void ReadXmlSerializable(XmlReader reader)
- {
- if (DetermineSchemaSerializationMode(reader) == SchemaSerializationMode.IncludeSchema)
- {
- Reset();
- DataSet dataSet = new DataSet();
- dataSet.ReadXml(reader);
- if (dataSet.Tables["Employee"] != null)
- {
- base.Tables.Add(new EmployeeDataTable(dataSet.Tables["Employee"]));
- }
- if (dataSet.Tables["AppendInfo"] != null)
- {
- base.Tables.Add(new AppendInfoDataTable(dataSet.Tables["AppendInfo"]));
- }
- base.DataSetName = dataSet.DataSetName;
- base.Prefix = dataSet.Prefix;
- base.Namespace = dataSet.Namespace;
- base.Locale = dataSet.Locale;
- base.CaseSensitive = dataSet.CaseSensitive;
- base.EnforceConstraints = dataSet.EnforceConstraints;
- Merge(dataSet, preserveChanges: false, MissingSchemaAction.Add);
- InitVars();
- }
- else
- {
- ReadXml(reader);
- InitVars();
- }
- }
- [DebuggerNonUserCode]
- protected override XmlSchema GetSchemaSerializable()
- {
- MemoryStream memoryStream = new MemoryStream();
- WriteXmlSchema(new XmlTextWriter(memoryStream, null));
- memoryStream.Position = 0L;
- return XmlSchema.Read(new XmlTextReader(memoryStream), null);
- }
- [DebuggerNonUserCode]
- internal void InitVars()
- {
- InitVars(initTable: true);
- }
- [DebuggerNonUserCode]
- internal void InitVars(bool initTable)
- {
- tableEmployee = (EmployeeDataTable)base.Tables["Employee"];
- if (initTable && tableEmployee != null)
- {
- tableEmployee.InitVars();
- }
- tableAppendInfo = (AppendInfoDataTable)base.Tables["AppendInfo"];
- if (initTable && tableAppendInfo != null)
- {
- tableAppendInfo.InitVars();
- }
- }
- [DebuggerNonUserCode]
- private void InitClass()
- {
- base.DataSetName = "dsFrmEmployee";
- base.Prefix = "";
- base.Namespace = "http://tempuri.org/dsFrmEmployee.xsd";
- base.EnforceConstraints = true;
- SchemaSerializationMode = SchemaSerializationMode.IncludeSchema;
- tableEmployee = new EmployeeDataTable();
- base.Tables.Add(tableEmployee);
- tableAppendInfo = new AppendInfoDataTable();
- base.Tables.Add(tableAppendInfo);
- }
- [DebuggerNonUserCode]
- private bool ShouldSerializeEmployee()
- {
- return false;
- }
- [DebuggerNonUserCode]
- private bool ShouldSerializeAppendInfo()
- {
- return false;
- }
- [DebuggerNonUserCode]
- private void SchemaChanged(object sender, CollectionChangeEventArgs e)
- {
- if (e.Action == CollectionChangeAction.Remove)
- {
- InitVars();
- }
- }
- [DebuggerNonUserCode]
- public static XmlSchemaComplexType GetTypedDataSetSchema(XmlSchemaSet xs)
- {
- dsFrmEmployee dsFrmEmployee = new dsFrmEmployee();
- XmlSchemaComplexType xmlSchemaComplexType = new XmlSchemaComplexType();
- XmlSchemaSequence xmlSchemaSequence = new XmlSchemaSequence();
- xs.Add(dsFrmEmployee.GetSchemaSerializable());
- XmlSchemaAny xmlSchemaAny = new XmlSchemaAny();
- xmlSchemaAny.Namespace = dsFrmEmployee.Namespace;
- xmlSchemaSequence.Items.Add(xmlSchemaAny);
- xmlSchemaComplexType.Particle = xmlSchemaSequence;
- return xmlSchemaComplexType;
- }
- }
- }
|