dsFrmRegionalLeader.cs 65 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336133713381339134013411342134313441345134613471348134913501351135213531354135513561357135813591360136113621363136413651366136713681369137013711372137313741375137613771378137913801381138213831384138513861387138813891390139113921393139413951396139713981399140014011402140314041405140614071408140914101411141214131414141514161417141814191420142114221423142414251426142714281429143014311432143314341435143614371438143914401441144214431444144514461447144814491450145114521453145414551456145714581459146014611462146314641465146614671468146914701471147214731474147514761477147814791480148114821483148414851486148714881489149014911492149314941495149614971498149915001501150215031504150515061507150815091510151115121513151415151516151715181519152015211522152315241525152615271528152915301531153215331534153515361537153815391540154115421543154415451546154715481549155015511552155315541555155615571558155915601561156215631564156515661567156815691570157115721573157415751576157715781579158015811582158315841585158615871588158915901591159215931594159515961597159815991600160116021603160416051606160716081609161016111612161316141615161616171618161916201621162216231624162516261627162816291630163116321633163416351636163716381639164016411642164316441645164616471648164916501651165216531654165516561657165816591660166116621663166416651666166716681669167016711672167316741675167616771678167916801681168216831684168516861687168816891690169116921693169416951696169716981699170017011702170317041705170617071708170917101711171217131714171517161717171817191720172117221723172417251726172717281729173017311732173317341735173617371738173917401741174217431744174517461747174817491750175117521753175417551756175717581759176017611762176317641765176617671768176917701771177217731774177517761777177817791780178117821783178417851786178717881789179017911792179317941795179617971798179918001801180218031804180518061807180818091810181118121813181418151816181718181819182018211822182318241825182618271828182918301831183218331834183518361837183818391840184118421843184418451846184718481849185018511852185318541855185618571858185918601861186218631864186518661867186818691870187118721873187418751876187718781879188018811882188318841885188618871888188918901891189218931894189518961897189818991900190119021903190419051906190719081909191019111912191319141915191619171918191919201921192219231924192519261927192819291930193119321933193419351936193719381939194019411942194319441945194619471948194919501951195219531954195519561957195819591960196119621963196419651966196719681969197019711972197319741975197619771978197919801981198219831984198519861987198819891990199119921993199419951996199719981999200020012002200320042005200620072008200920102011201220132014201520162017201820192020202120222023202420252026202720282029203020312032203320342035203620372038203920402041204220432044204520462047204820492050205120522053205420552056205720582059206020612062206320642065206620672068206920702071207220732074207520762077207820792080208120822083208420852086208720882089209020912092209320942095209620972098209921002101210221032104210521062107210821092110211121122113211421152116211721182119212021212122212321242125212621272128212921302131213221332134213521362137213821392140214121422143214421452146214721482149215021512152215321542155215621572158215921602161216221632164216521662167216821692170217121722173217421752176217721782179218021812182218321842185218621872188218921902191219221932194219521962197219821992200220122022203220422052206220722082209221022112212221322142215221622172218221922202221222222232224222522262227222822292230223122322233223422352236223722382239224022412242224322442245224622472248224922502251225222532254225522562257225822592260226122622263226422652266226722682269227022712272227322742275227622772278227922802281228222832284228522862287228822892290229122922293229422952296229722982299230023012302230323042305230623072308230923102311231223132314231523162317231823192320232123222323232423252326232723282329233023312332233323342335233623372338233923402341234223432344234523462347234823492350235123522353235423552356235723582359236023612362
  1. using System;
  2. using System.CodeDom.Compiler;
  3. using System.Collections;
  4. using System.ComponentModel;
  5. using System.ComponentModel.Design;
  6. using System.Data;
  7. using System.Diagnostics;
  8. using System.IO;
  9. using System.Runtime.Serialization;
  10. using System.Xml;
  11. using System.Xml.Schema;
  12. using System.Xml.Serialization;
  13. namespace SunRoxm.BizPeri.ReportDataSet.ReportDataSet
  14. {
  15. [Serializable]
  16. [HelpKeyword("vs.data.DataSet")]
  17. [GeneratedCode("System.Data.Design.TypedDataSetGenerator", "2.0.0.0")]
  18. [XmlRoot("dsFrmRegionalLeader")]
  19. [DesignerCategory("code")]
  20. [ToolboxItem(true)]
  21. [XmlSchemaProvider("GetTypedDataSetSchema")]
  22. public class dsFrmRegionalLeader : DataSet
  23. {
  24. public delegate void RegionalLeaderRowChangeEventHandler(object sender, RegionalLeaderRowChangeEvent e);
  25. public delegate void EmployeeRowChangeEventHandler(object sender, EmployeeRowChangeEvent e);
  26. public delegate void PrincipalRowChangeEventHandler(object sender, PrincipalRowChangeEvent e);
  27. [Serializable]
  28. [GeneratedCode("System.Data.Design.TypedDataSetGenerator", "2.0.0.0")]
  29. [XmlSchemaProvider("GetTypedTableSchema")]
  30. public class RegionalLeaderDataTable : DataTable, IEnumerable
  31. {
  32. private DataColumn columnNo_RegionalLeader;
  33. private DataColumn columnName_RegionalLeader;
  34. [DebuggerNonUserCode]
  35. public DataColumn No_RegionalLeaderColumn => columnNo_RegionalLeader;
  36. [DebuggerNonUserCode]
  37. public DataColumn Name_RegionalLeaderColumn => columnName_RegionalLeader;
  38. [DebuggerNonUserCode]
  39. [Browsable(false)]
  40. public int Count => base.Rows.Count;
  41. [DebuggerNonUserCode]
  42. public RegionalLeaderRow this[int index] => (RegionalLeaderRow)base.Rows[index];
  43. public event RegionalLeaderRowChangeEventHandler RegionalLeaderRowChanging;
  44. public event RegionalLeaderRowChangeEventHandler RegionalLeaderRowChanged;
  45. public event RegionalLeaderRowChangeEventHandler RegionalLeaderRowDeleting;
  46. public event RegionalLeaderRowChangeEventHandler RegionalLeaderRowDeleted;
  47. [DebuggerNonUserCode]
  48. public RegionalLeaderDataTable()
  49. {
  50. base.TableName = "RegionalLeader";
  51. BeginInit();
  52. InitClass();
  53. EndInit();
  54. }
  55. [DebuggerNonUserCode]
  56. internal RegionalLeaderDataTable(DataTable table)
  57. {
  58. base.TableName = table.TableName;
  59. if (table.CaseSensitive != table.DataSet.CaseSensitive)
  60. {
  61. base.CaseSensitive = table.CaseSensitive;
  62. }
  63. if (table.Locale.ToString() != table.DataSet.Locale.ToString())
  64. {
  65. base.Locale = table.Locale;
  66. }
  67. if (table.Namespace != table.DataSet.Namespace)
  68. {
  69. base.Namespace = table.Namespace;
  70. }
  71. base.Prefix = table.Prefix;
  72. base.MinimumCapacity = table.MinimumCapacity;
  73. }
  74. [DebuggerNonUserCode]
  75. protected RegionalLeaderDataTable(SerializationInfo info, StreamingContext context)
  76. : base(info, context)
  77. {
  78. InitVars();
  79. }
  80. [DebuggerNonUserCode]
  81. public void AddRegionalLeaderRow(RegionalLeaderRow row)
  82. {
  83. base.Rows.Add(row);
  84. }
  85. [DebuggerNonUserCode]
  86. public RegionalLeaderRow AddRegionalLeaderRow(string No_RegionalLeader, string Name_RegionalLeader)
  87. {
  88. RegionalLeaderRow regionalLeaderRow = (RegionalLeaderRow)NewRow();
  89. object[] array2 = regionalLeaderRow.ItemArray = new object[2]
  90. {
  91. No_RegionalLeader,
  92. Name_RegionalLeader
  93. };
  94. base.Rows.Add(regionalLeaderRow);
  95. return regionalLeaderRow;
  96. }
  97. [DebuggerNonUserCode]
  98. public virtual IEnumerator GetEnumerator()
  99. {
  100. return base.Rows.GetEnumerator();
  101. }
  102. [DebuggerNonUserCode]
  103. public override DataTable Clone()
  104. {
  105. RegionalLeaderDataTable regionalLeaderDataTable = (RegionalLeaderDataTable)base.Clone();
  106. regionalLeaderDataTable.InitVars();
  107. return regionalLeaderDataTable;
  108. }
  109. [DebuggerNonUserCode]
  110. protected override DataTable CreateInstance()
  111. {
  112. return new RegionalLeaderDataTable();
  113. }
  114. [DebuggerNonUserCode]
  115. internal void InitVars()
  116. {
  117. columnNo_RegionalLeader = base.Columns["No_RegionalLeader"];
  118. columnName_RegionalLeader = base.Columns["Name_RegionalLeader"];
  119. }
  120. [DebuggerNonUserCode]
  121. private void InitClass()
  122. {
  123. columnNo_RegionalLeader = new DataColumn("No_RegionalLeader", typeof(string), null, MappingType.Element);
  124. base.Columns.Add(columnNo_RegionalLeader);
  125. columnName_RegionalLeader = new DataColumn("Name_RegionalLeader", typeof(string), null, MappingType.Element);
  126. base.Columns.Add(columnName_RegionalLeader);
  127. columnNo_RegionalLeader.Caption = "Name_Telephone";
  128. columnName_RegionalLeader.Caption = "No_Telephone";
  129. }
  130. [DebuggerNonUserCode]
  131. public RegionalLeaderRow NewRegionalLeaderRow()
  132. {
  133. return (RegionalLeaderRow)NewRow();
  134. }
  135. [DebuggerNonUserCode]
  136. protected override DataRow NewRowFromBuilder(DataRowBuilder builder)
  137. {
  138. return new RegionalLeaderRow(builder);
  139. }
  140. [DebuggerNonUserCode]
  141. protected override Type GetRowType()
  142. {
  143. return typeof(RegionalLeaderRow);
  144. }
  145. [DebuggerNonUserCode]
  146. protected override void OnRowChanged(DataRowChangeEventArgs e)
  147. {
  148. base.OnRowChanged(e);
  149. if (this.RegionalLeaderRowChanged != null)
  150. {
  151. this.RegionalLeaderRowChanged(this, new RegionalLeaderRowChangeEvent((RegionalLeaderRow)e.Row, e.Action));
  152. }
  153. }
  154. [DebuggerNonUserCode]
  155. protected override void OnRowChanging(DataRowChangeEventArgs e)
  156. {
  157. base.OnRowChanging(e);
  158. if (this.RegionalLeaderRowChanging != null)
  159. {
  160. this.RegionalLeaderRowChanging(this, new RegionalLeaderRowChangeEvent((RegionalLeaderRow)e.Row, e.Action));
  161. }
  162. }
  163. [DebuggerNonUserCode]
  164. protected override void OnRowDeleted(DataRowChangeEventArgs e)
  165. {
  166. base.OnRowDeleted(e);
  167. if (this.RegionalLeaderRowDeleted != null)
  168. {
  169. this.RegionalLeaderRowDeleted(this, new RegionalLeaderRowChangeEvent((RegionalLeaderRow)e.Row, e.Action));
  170. }
  171. }
  172. [DebuggerNonUserCode]
  173. protected override void OnRowDeleting(DataRowChangeEventArgs e)
  174. {
  175. base.OnRowDeleting(e);
  176. if (this.RegionalLeaderRowDeleting != null)
  177. {
  178. this.RegionalLeaderRowDeleting(this, new RegionalLeaderRowChangeEvent((RegionalLeaderRow)e.Row, e.Action));
  179. }
  180. }
  181. [DebuggerNonUserCode]
  182. public void RemoveRegionalLeaderRow(RegionalLeaderRow row)
  183. {
  184. base.Rows.Remove(row);
  185. }
  186. [DebuggerNonUserCode]
  187. public static XmlSchemaComplexType GetTypedTableSchema(XmlSchemaSet xs)
  188. {
  189. XmlSchemaComplexType xmlSchemaComplexType = new XmlSchemaComplexType();
  190. XmlSchemaSequence xmlSchemaSequence = new XmlSchemaSequence();
  191. dsFrmRegionalLeader dsFrmRegionalLeader = new dsFrmRegionalLeader();
  192. XmlSchemaAny xmlSchemaAny = new XmlSchemaAny();
  193. xmlSchemaAny.Namespace = "http://www.w3.org/2001/XMLSchema";
  194. xmlSchemaAny.MinOccurs = 0m;
  195. xmlSchemaAny.MaxOccurs = decimal.MaxValue;
  196. xmlSchemaAny.ProcessContents = XmlSchemaContentProcessing.Lax;
  197. xmlSchemaSequence.Items.Add(xmlSchemaAny);
  198. XmlSchemaAny xmlSchemaAny2 = new XmlSchemaAny();
  199. xmlSchemaAny2.Namespace = "urn:schemas-microsoft-com:xml-diffgram-v1";
  200. xmlSchemaAny2.MinOccurs = 1m;
  201. xmlSchemaAny2.ProcessContents = XmlSchemaContentProcessing.Lax;
  202. xmlSchemaSequence.Items.Add(xmlSchemaAny2);
  203. XmlSchemaAttribute xmlSchemaAttribute = new XmlSchemaAttribute();
  204. xmlSchemaAttribute.Name = "namespace";
  205. xmlSchemaAttribute.FixedValue = dsFrmRegionalLeader.Namespace;
  206. xmlSchemaComplexType.Attributes.Add(xmlSchemaAttribute);
  207. XmlSchemaAttribute xmlSchemaAttribute2 = new XmlSchemaAttribute();
  208. xmlSchemaAttribute2.Name = "tableTypeName";
  209. xmlSchemaAttribute2.FixedValue = "RegionalLeaderDataTable";
  210. xmlSchemaComplexType.Attributes.Add(xmlSchemaAttribute2);
  211. xmlSchemaComplexType.Particle = xmlSchemaSequence;
  212. XmlSchema schemaSerializable = dsFrmRegionalLeader.GetSchemaSerializable();
  213. if (xs.Contains(schemaSerializable.TargetNamespace))
  214. {
  215. MemoryStream memoryStream = new MemoryStream();
  216. MemoryStream memoryStream2 = new MemoryStream();
  217. try
  218. {
  219. XmlSchema xmlSchema = null;
  220. schemaSerializable.Write(memoryStream);
  221. IEnumerator enumerator = xs.Schemas(schemaSerializable.TargetNamespace).GetEnumerator();
  222. while (enumerator.MoveNext())
  223. {
  224. xmlSchema = (XmlSchema)enumerator.Current;
  225. memoryStream2.SetLength(0L);
  226. xmlSchema.Write(memoryStream2);
  227. if (memoryStream.Length == memoryStream2.Length)
  228. {
  229. memoryStream.Position = 0L;
  230. memoryStream2.Position = 0L;
  231. while (memoryStream.Position != memoryStream.Length && memoryStream.ReadByte() == memoryStream2.ReadByte())
  232. {
  233. }
  234. if (memoryStream.Position == memoryStream.Length)
  235. {
  236. return xmlSchemaComplexType;
  237. }
  238. }
  239. }
  240. }
  241. finally
  242. {
  243. memoryStream?.Close();
  244. memoryStream2?.Close();
  245. }
  246. }
  247. xs.Add(schemaSerializable);
  248. return xmlSchemaComplexType;
  249. }
  250. }
  251. [Serializable]
  252. [GeneratedCode("System.Data.Design.TypedDataSetGenerator", "2.0.0.0")]
  253. [XmlSchemaProvider("GetTypedTableSchema")]
  254. public class EmployeeDataTable : DataTable, IEnumerable
  255. {
  256. private DataColumn columnNo_Employee;
  257. private DataColumn columnName_Employee;
  258. private DataColumn columnEmployeeNo_Employee;
  259. private DataColumn columnNameEng_Employee;
  260. private DataColumn columnGender_Employee;
  261. private DataColumn columnCountry_Employee;
  262. private DataColumn columnHomeplace_Employee;
  263. private DataColumn columnNation_Employee;
  264. private DataColumn columnIDNo_Employee;
  265. private DataColumn columnPassport_Employee;
  266. private DataColumn columnIsMarried_Employee;
  267. private DataColumn columnCreateDate_Employee;
  268. private DataColumn columnDuty_Employee;
  269. private DataColumn columnProbation_Employee;
  270. private DataColumn columnOnJobDate_Employee;
  271. private DataColumn columnOnDuty_Employee;
  272. private DataColumn columnObJobStatus_Employee;
  273. private DataColumn columnOffDuty_Employee;
  274. private DataColumn columnSuspendDate_Employee;
  275. private DataColumn columnTel_Employee;
  276. private DataColumn columnEMail_Employee;
  277. private DataColumn columnAddress_Employee;
  278. private DataColumn columnComment_Employee;
  279. private DataColumn columnLastModDate_Employee;
  280. [DebuggerNonUserCode]
  281. public DataColumn No_EmployeeColumn => columnNo_Employee;
  282. [DebuggerNonUserCode]
  283. public DataColumn Name_EmployeeColumn => columnName_Employee;
  284. [DebuggerNonUserCode]
  285. public DataColumn EmployeeNo_EmployeeColumn => columnEmployeeNo_Employee;
  286. [DebuggerNonUserCode]
  287. public DataColumn NameEng_EmployeeColumn => columnNameEng_Employee;
  288. [DebuggerNonUserCode]
  289. public DataColumn Gender_EmployeeColumn => columnGender_Employee;
  290. [DebuggerNonUserCode]
  291. public DataColumn Country_EmployeeColumn => columnCountry_Employee;
  292. [DebuggerNonUserCode]
  293. public DataColumn Homeplace_EmployeeColumn => columnHomeplace_Employee;
  294. [DebuggerNonUserCode]
  295. public DataColumn Nation_EmployeeColumn => columnNation_Employee;
  296. [DebuggerNonUserCode]
  297. public DataColumn IDNo_EmployeeColumn => columnIDNo_Employee;
  298. [DebuggerNonUserCode]
  299. public DataColumn Passport_EmployeeColumn => columnPassport_Employee;
  300. [DebuggerNonUserCode]
  301. public DataColumn IsMarried_EmployeeColumn => columnIsMarried_Employee;
  302. [DebuggerNonUserCode]
  303. public DataColumn CreateDate_EmployeeColumn => columnCreateDate_Employee;
  304. [DebuggerNonUserCode]
  305. public DataColumn Duty_EmployeeColumn => columnDuty_Employee;
  306. [DebuggerNonUserCode]
  307. public DataColumn Probation_EmployeeColumn => columnProbation_Employee;
  308. [DebuggerNonUserCode]
  309. public DataColumn OnJobDate_EmployeeColumn => columnOnJobDate_Employee;
  310. [DebuggerNonUserCode]
  311. public DataColumn OnDuty_EmployeeColumn => columnOnDuty_Employee;
  312. [DebuggerNonUserCode]
  313. public DataColumn ObJobStatus_EmployeeColumn => columnObJobStatus_Employee;
  314. [DebuggerNonUserCode]
  315. public DataColumn OffDuty_EmployeeColumn => columnOffDuty_Employee;
  316. [DebuggerNonUserCode]
  317. public DataColumn SuspendDate_EmployeeColumn => columnSuspendDate_Employee;
  318. [DebuggerNonUserCode]
  319. public DataColumn Tel_EmployeeColumn => columnTel_Employee;
  320. [DebuggerNonUserCode]
  321. public DataColumn EMail_EmployeeColumn => columnEMail_Employee;
  322. [DebuggerNonUserCode]
  323. public DataColumn Address_EmployeeColumn => columnAddress_Employee;
  324. [DebuggerNonUserCode]
  325. public DataColumn Comment_EmployeeColumn => columnComment_Employee;
  326. [DebuggerNonUserCode]
  327. public DataColumn LastModDate_EmployeeColumn => columnLastModDate_Employee;
  328. [Browsable(false)]
  329. [DebuggerNonUserCode]
  330. public int Count => base.Rows.Count;
  331. [DebuggerNonUserCode]
  332. public EmployeeRow this[int index] => (EmployeeRow)base.Rows[index];
  333. public event EmployeeRowChangeEventHandler EmployeeRowChanging;
  334. public event EmployeeRowChangeEventHandler EmployeeRowChanged;
  335. public event EmployeeRowChangeEventHandler EmployeeRowDeleting;
  336. public event EmployeeRowChangeEventHandler EmployeeRowDeleted;
  337. [DebuggerNonUserCode]
  338. public EmployeeDataTable()
  339. {
  340. base.TableName = "Employee";
  341. BeginInit();
  342. InitClass();
  343. EndInit();
  344. }
  345. [DebuggerNonUserCode]
  346. internal EmployeeDataTable(DataTable table)
  347. {
  348. base.TableName = table.TableName;
  349. if (table.CaseSensitive != table.DataSet.CaseSensitive)
  350. {
  351. base.CaseSensitive = table.CaseSensitive;
  352. }
  353. if (table.Locale.ToString() != table.DataSet.Locale.ToString())
  354. {
  355. base.Locale = table.Locale;
  356. }
  357. if (table.Namespace != table.DataSet.Namespace)
  358. {
  359. base.Namespace = table.Namespace;
  360. }
  361. base.Prefix = table.Prefix;
  362. base.MinimumCapacity = table.MinimumCapacity;
  363. }
  364. [DebuggerNonUserCode]
  365. protected EmployeeDataTable(SerializationInfo info, StreamingContext context)
  366. : base(info, context)
  367. {
  368. InitVars();
  369. }
  370. [DebuggerNonUserCode]
  371. public void AddEmployeeRow(EmployeeRow row)
  372. {
  373. base.Rows.Add(row);
  374. }
  375. [DebuggerNonUserCode]
  376. 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)
  377. {
  378. EmployeeRow employeeRow = (EmployeeRow)NewRow();
  379. object[] array2 = employeeRow.ItemArray = new object[24]
  380. {
  381. No_Employee,
  382. Name_Employee,
  383. EmployeeNo_Employee,
  384. NameEng_Employee,
  385. Gender_Employee,
  386. Country_Employee,
  387. Homeplace_Employee,
  388. Nation_Employee,
  389. IDNo_Employee,
  390. Passport_Employee,
  391. IsMarried_Employee,
  392. CreateDate_Employee,
  393. Duty_Employee,
  394. Probation_Employee,
  395. OnJobDate_Employee,
  396. OnDuty_Employee,
  397. ObJobStatus_Employee,
  398. OffDuty_Employee,
  399. SuspendDate_Employee,
  400. Tel_Employee,
  401. EMail_Employee,
  402. Address_Employee,
  403. Comment_Employee,
  404. LastModDate_Employee
  405. };
  406. base.Rows.Add(employeeRow);
  407. return employeeRow;
  408. }
  409. [DebuggerNonUserCode]
  410. public virtual IEnumerator GetEnumerator()
  411. {
  412. return base.Rows.GetEnumerator();
  413. }
  414. [DebuggerNonUserCode]
  415. public override DataTable Clone()
  416. {
  417. EmployeeDataTable employeeDataTable = (EmployeeDataTable)base.Clone();
  418. employeeDataTable.InitVars();
  419. return employeeDataTable;
  420. }
  421. [DebuggerNonUserCode]
  422. protected override DataTable CreateInstance()
  423. {
  424. return new EmployeeDataTable();
  425. }
  426. [DebuggerNonUserCode]
  427. internal void InitVars()
  428. {
  429. columnNo_Employee = base.Columns["No_Employee"];
  430. columnName_Employee = base.Columns["Name_Employee"];
  431. columnEmployeeNo_Employee = base.Columns["EmployeeNo_Employee"];
  432. columnNameEng_Employee = base.Columns["NameEng_Employee"];
  433. columnGender_Employee = base.Columns["Gender_Employee"];
  434. columnCountry_Employee = base.Columns["Country_Employee"];
  435. columnHomeplace_Employee = base.Columns["Homeplace_Employee"];
  436. columnNation_Employee = base.Columns["Nation_Employee"];
  437. columnIDNo_Employee = base.Columns["IDNo_Employee"];
  438. columnPassport_Employee = base.Columns["Passport_Employee"];
  439. columnIsMarried_Employee = base.Columns["IsMarried_Employee"];
  440. columnCreateDate_Employee = base.Columns["CreateDate_Employee"];
  441. columnDuty_Employee = base.Columns["Duty_Employee"];
  442. columnProbation_Employee = base.Columns["Probation_Employee"];
  443. columnOnJobDate_Employee = base.Columns["OnJobDate_Employee"];
  444. columnOnDuty_Employee = base.Columns["OnDuty_Employee"];
  445. columnObJobStatus_Employee = base.Columns["ObJobStatus_Employee"];
  446. columnOffDuty_Employee = base.Columns["OffDuty_Employee"];
  447. columnSuspendDate_Employee = base.Columns["SuspendDate_Employee"];
  448. columnTel_Employee = base.Columns["Tel_Employee"];
  449. columnEMail_Employee = base.Columns["EMail_Employee"];
  450. columnAddress_Employee = base.Columns["Address_Employee"];
  451. columnComment_Employee = base.Columns["Comment_Employee"];
  452. columnLastModDate_Employee = base.Columns["LastModDate_Employee"];
  453. }
  454. [DebuggerNonUserCode]
  455. private void InitClass()
  456. {
  457. columnNo_Employee = new DataColumn("No_Employee", typeof(string), null, MappingType.Element);
  458. base.Columns.Add(columnNo_Employee);
  459. columnName_Employee = new DataColumn("Name_Employee", typeof(string), null, MappingType.Element);
  460. base.Columns.Add(columnName_Employee);
  461. columnEmployeeNo_Employee = new DataColumn("EmployeeNo_Employee", typeof(string), null, MappingType.Element);
  462. base.Columns.Add(columnEmployeeNo_Employee);
  463. columnNameEng_Employee = new DataColumn("NameEng_Employee", typeof(string), null, MappingType.Element);
  464. base.Columns.Add(columnNameEng_Employee);
  465. columnGender_Employee = new DataColumn("Gender_Employee", typeof(bool), null, MappingType.Element);
  466. base.Columns.Add(columnGender_Employee);
  467. columnCountry_Employee = new DataColumn("Country_Employee", typeof(int), null, MappingType.Element);
  468. base.Columns.Add(columnCountry_Employee);
  469. columnHomeplace_Employee = new DataColumn("Homeplace_Employee", typeof(string), null, MappingType.Element);
  470. base.Columns.Add(columnHomeplace_Employee);
  471. columnNation_Employee = new DataColumn("Nation_Employee", typeof(string), null, MappingType.Element);
  472. base.Columns.Add(columnNation_Employee);
  473. columnIDNo_Employee = new DataColumn("IDNo_Employee", typeof(string), null, MappingType.Element);
  474. base.Columns.Add(columnIDNo_Employee);
  475. columnPassport_Employee = new DataColumn("Passport_Employee", typeof(string), null, MappingType.Element);
  476. base.Columns.Add(columnPassport_Employee);
  477. columnIsMarried_Employee = new DataColumn("IsMarried_Employee", typeof(bool), null, MappingType.Element);
  478. base.Columns.Add(columnIsMarried_Employee);
  479. columnCreateDate_Employee = new DataColumn("CreateDate_Employee", typeof(DateTime), null, MappingType.Element);
  480. base.Columns.Add(columnCreateDate_Employee);
  481. columnDuty_Employee = new DataColumn("Duty_Employee", typeof(string), null, MappingType.Element);
  482. base.Columns.Add(columnDuty_Employee);
  483. columnProbation_Employee = new DataColumn("Probation_Employee", typeof(decimal), null, MappingType.Element);
  484. base.Columns.Add(columnProbation_Employee);
  485. columnOnJobDate_Employee = new DataColumn("OnJobDate_Employee", typeof(DateTime), null, MappingType.Element);
  486. base.Columns.Add(columnOnJobDate_Employee);
  487. columnOnDuty_Employee = new DataColumn("OnDuty_Employee", typeof(DateTime), null, MappingType.Element);
  488. base.Columns.Add(columnOnDuty_Employee);
  489. columnObJobStatus_Employee = new DataColumn("ObJobStatus_Employee", typeof(int), null, MappingType.Element);
  490. base.Columns.Add(columnObJobStatus_Employee);
  491. columnOffDuty_Employee = new DataColumn("OffDuty_Employee", typeof(DateTime), null, MappingType.Element);
  492. base.Columns.Add(columnOffDuty_Employee);
  493. columnSuspendDate_Employee = new DataColumn("SuspendDate_Employee", typeof(DateTime), null, MappingType.Element);
  494. base.Columns.Add(columnSuspendDate_Employee);
  495. columnTel_Employee = new DataColumn("Tel_Employee", typeof(string), null, MappingType.Element);
  496. base.Columns.Add(columnTel_Employee);
  497. columnEMail_Employee = new DataColumn("EMail_Employee", typeof(string), null, MappingType.Element);
  498. base.Columns.Add(columnEMail_Employee);
  499. columnAddress_Employee = new DataColumn("Address_Employee", typeof(string), null, MappingType.Element);
  500. base.Columns.Add(columnAddress_Employee);
  501. columnComment_Employee = new DataColumn("Comment_Employee", typeof(string), null, MappingType.Element);
  502. base.Columns.Add(columnComment_Employee);
  503. columnLastModDate_Employee = new DataColumn("LastModDate_Employee", typeof(DateTime), null, MappingType.Element);
  504. base.Columns.Add(columnLastModDate_Employee);
  505. }
  506. [DebuggerNonUserCode]
  507. public EmployeeRow NewEmployeeRow()
  508. {
  509. return (EmployeeRow)NewRow();
  510. }
  511. [DebuggerNonUserCode]
  512. protected override DataRow NewRowFromBuilder(DataRowBuilder builder)
  513. {
  514. return new EmployeeRow(builder);
  515. }
  516. [DebuggerNonUserCode]
  517. protected override Type GetRowType()
  518. {
  519. return typeof(EmployeeRow);
  520. }
  521. [DebuggerNonUserCode]
  522. protected override void OnRowChanged(DataRowChangeEventArgs e)
  523. {
  524. base.OnRowChanged(e);
  525. if (this.EmployeeRowChanged != null)
  526. {
  527. this.EmployeeRowChanged(this, new EmployeeRowChangeEvent((EmployeeRow)e.Row, e.Action));
  528. }
  529. }
  530. [DebuggerNonUserCode]
  531. protected override void OnRowChanging(DataRowChangeEventArgs e)
  532. {
  533. base.OnRowChanging(e);
  534. if (this.EmployeeRowChanging != null)
  535. {
  536. this.EmployeeRowChanging(this, new EmployeeRowChangeEvent((EmployeeRow)e.Row, e.Action));
  537. }
  538. }
  539. [DebuggerNonUserCode]
  540. protected override void OnRowDeleted(DataRowChangeEventArgs e)
  541. {
  542. base.OnRowDeleted(e);
  543. if (this.EmployeeRowDeleted != null)
  544. {
  545. this.EmployeeRowDeleted(this, new EmployeeRowChangeEvent((EmployeeRow)e.Row, e.Action));
  546. }
  547. }
  548. [DebuggerNonUserCode]
  549. protected override void OnRowDeleting(DataRowChangeEventArgs e)
  550. {
  551. base.OnRowDeleting(e);
  552. if (this.EmployeeRowDeleting != null)
  553. {
  554. this.EmployeeRowDeleting(this, new EmployeeRowChangeEvent((EmployeeRow)e.Row, e.Action));
  555. }
  556. }
  557. [DebuggerNonUserCode]
  558. public void RemoveEmployeeRow(EmployeeRow row)
  559. {
  560. base.Rows.Remove(row);
  561. }
  562. [DebuggerNonUserCode]
  563. public static XmlSchemaComplexType GetTypedTableSchema(XmlSchemaSet xs)
  564. {
  565. XmlSchemaComplexType xmlSchemaComplexType = new XmlSchemaComplexType();
  566. XmlSchemaSequence xmlSchemaSequence = new XmlSchemaSequence();
  567. dsFrmRegionalLeader dsFrmRegionalLeader = new dsFrmRegionalLeader();
  568. XmlSchemaAny xmlSchemaAny = new XmlSchemaAny();
  569. xmlSchemaAny.Namespace = "http://www.w3.org/2001/XMLSchema";
  570. xmlSchemaAny.MinOccurs = 0m;
  571. xmlSchemaAny.MaxOccurs = decimal.MaxValue;
  572. xmlSchemaAny.ProcessContents = XmlSchemaContentProcessing.Lax;
  573. xmlSchemaSequence.Items.Add(xmlSchemaAny);
  574. XmlSchemaAny xmlSchemaAny2 = new XmlSchemaAny();
  575. xmlSchemaAny2.Namespace = "urn:schemas-microsoft-com:xml-diffgram-v1";
  576. xmlSchemaAny2.MinOccurs = 1m;
  577. xmlSchemaAny2.ProcessContents = XmlSchemaContentProcessing.Lax;
  578. xmlSchemaSequence.Items.Add(xmlSchemaAny2);
  579. XmlSchemaAttribute xmlSchemaAttribute = new XmlSchemaAttribute();
  580. xmlSchemaAttribute.Name = "namespace";
  581. xmlSchemaAttribute.FixedValue = dsFrmRegionalLeader.Namespace;
  582. xmlSchemaComplexType.Attributes.Add(xmlSchemaAttribute);
  583. XmlSchemaAttribute xmlSchemaAttribute2 = new XmlSchemaAttribute();
  584. xmlSchemaAttribute2.Name = "tableTypeName";
  585. xmlSchemaAttribute2.FixedValue = "EmployeeDataTable";
  586. xmlSchemaComplexType.Attributes.Add(xmlSchemaAttribute2);
  587. xmlSchemaComplexType.Particle = xmlSchemaSequence;
  588. XmlSchema schemaSerializable = dsFrmRegionalLeader.GetSchemaSerializable();
  589. if (xs.Contains(schemaSerializable.TargetNamespace))
  590. {
  591. MemoryStream memoryStream = new MemoryStream();
  592. MemoryStream memoryStream2 = new MemoryStream();
  593. try
  594. {
  595. XmlSchema xmlSchema = null;
  596. schemaSerializable.Write(memoryStream);
  597. IEnumerator enumerator = xs.Schemas(schemaSerializable.TargetNamespace).GetEnumerator();
  598. while (enumerator.MoveNext())
  599. {
  600. xmlSchema = (XmlSchema)enumerator.Current;
  601. memoryStream2.SetLength(0L);
  602. xmlSchema.Write(memoryStream2);
  603. if (memoryStream.Length == memoryStream2.Length)
  604. {
  605. memoryStream.Position = 0L;
  606. memoryStream2.Position = 0L;
  607. while (memoryStream.Position != memoryStream.Length && memoryStream.ReadByte() == memoryStream2.ReadByte())
  608. {
  609. }
  610. if (memoryStream.Position == memoryStream.Length)
  611. {
  612. return xmlSchemaComplexType;
  613. }
  614. }
  615. }
  616. }
  617. finally
  618. {
  619. memoryStream?.Close();
  620. memoryStream2?.Close();
  621. }
  622. }
  623. xs.Add(schemaSerializable);
  624. return xmlSchemaComplexType;
  625. }
  626. }
  627. [Serializable]
  628. [XmlSchemaProvider("GetTypedTableSchema")]
  629. [GeneratedCode("System.Data.Design.TypedDataSetGenerator", "2.0.0.0")]
  630. public class PrincipalDataTable : DataTable, IEnumerable
  631. {
  632. private DataColumn columnIsMain_Principal;
  633. private DataColumn columnComment_Principal;
  634. private DataColumn columnName_Employee;
  635. private DataColumn columnNo_Employee;
  636. [DebuggerNonUserCode]
  637. public DataColumn IsMain_PrincipalColumn => columnIsMain_Principal;
  638. [DebuggerNonUserCode]
  639. public DataColumn Comment_PrincipalColumn => columnComment_Principal;
  640. [DebuggerNonUserCode]
  641. public DataColumn Name_EmployeeColumn => columnName_Employee;
  642. [DebuggerNonUserCode]
  643. public DataColumn No_EmployeeColumn => columnNo_Employee;
  644. [Browsable(false)]
  645. [DebuggerNonUserCode]
  646. public int Count => base.Rows.Count;
  647. [DebuggerNonUserCode]
  648. public PrincipalRow this[int index] => (PrincipalRow)base.Rows[index];
  649. public event PrincipalRowChangeEventHandler PrincipalRowChanging;
  650. public event PrincipalRowChangeEventHandler PrincipalRowChanged;
  651. public event PrincipalRowChangeEventHandler PrincipalRowDeleting;
  652. public event PrincipalRowChangeEventHandler PrincipalRowDeleted;
  653. [DebuggerNonUserCode]
  654. public PrincipalDataTable()
  655. {
  656. base.TableName = "Principal";
  657. BeginInit();
  658. InitClass();
  659. EndInit();
  660. }
  661. [DebuggerNonUserCode]
  662. internal PrincipalDataTable(DataTable table)
  663. {
  664. base.TableName = table.TableName;
  665. if (table.CaseSensitive != table.DataSet.CaseSensitive)
  666. {
  667. base.CaseSensitive = table.CaseSensitive;
  668. }
  669. if (table.Locale.ToString() != table.DataSet.Locale.ToString())
  670. {
  671. base.Locale = table.Locale;
  672. }
  673. if (table.Namespace != table.DataSet.Namespace)
  674. {
  675. base.Namespace = table.Namespace;
  676. }
  677. base.Prefix = table.Prefix;
  678. base.MinimumCapacity = table.MinimumCapacity;
  679. }
  680. [DebuggerNonUserCode]
  681. protected PrincipalDataTable(SerializationInfo info, StreamingContext context)
  682. : base(info, context)
  683. {
  684. InitVars();
  685. }
  686. [DebuggerNonUserCode]
  687. public void AddPrincipalRow(PrincipalRow row)
  688. {
  689. base.Rows.Add(row);
  690. }
  691. [DebuggerNonUserCode]
  692. public PrincipalRow AddPrincipalRow(bool IsMain_Principal, string Comment_Principal, string Name_Employee, string No_Employee)
  693. {
  694. PrincipalRow principalRow = (PrincipalRow)NewRow();
  695. object[] array2 = principalRow.ItemArray = new object[4]
  696. {
  697. IsMain_Principal,
  698. Comment_Principal,
  699. Name_Employee,
  700. No_Employee
  701. };
  702. base.Rows.Add(principalRow);
  703. return principalRow;
  704. }
  705. [DebuggerNonUserCode]
  706. public virtual IEnumerator GetEnumerator()
  707. {
  708. return base.Rows.GetEnumerator();
  709. }
  710. [DebuggerNonUserCode]
  711. public override DataTable Clone()
  712. {
  713. PrincipalDataTable principalDataTable = (PrincipalDataTable)base.Clone();
  714. principalDataTable.InitVars();
  715. return principalDataTable;
  716. }
  717. [DebuggerNonUserCode]
  718. protected override DataTable CreateInstance()
  719. {
  720. return new PrincipalDataTable();
  721. }
  722. [DebuggerNonUserCode]
  723. internal void InitVars()
  724. {
  725. columnIsMain_Principal = base.Columns["IsMain_Principal"];
  726. columnComment_Principal = base.Columns["Comment_Principal"];
  727. columnName_Employee = base.Columns["Name_Employee"];
  728. columnNo_Employee = base.Columns["No_Employee"];
  729. }
  730. [DebuggerNonUserCode]
  731. private void InitClass()
  732. {
  733. columnIsMain_Principal = new DataColumn("IsMain_Principal", typeof(bool), null, MappingType.Element);
  734. base.Columns.Add(columnIsMain_Principal);
  735. columnComment_Principal = new DataColumn("Comment_Principal", typeof(string), null, MappingType.Element);
  736. base.Columns.Add(columnComment_Principal);
  737. columnName_Employee = new DataColumn("Name_Employee", typeof(string), null, MappingType.Element);
  738. base.Columns.Add(columnName_Employee);
  739. columnNo_Employee = new DataColumn("No_Employee", typeof(string), null, MappingType.Element);
  740. base.Columns.Add(columnNo_Employee);
  741. }
  742. [DebuggerNonUserCode]
  743. public PrincipalRow NewPrincipalRow()
  744. {
  745. return (PrincipalRow)NewRow();
  746. }
  747. [DebuggerNonUserCode]
  748. protected override DataRow NewRowFromBuilder(DataRowBuilder builder)
  749. {
  750. return new PrincipalRow(builder);
  751. }
  752. [DebuggerNonUserCode]
  753. protected override Type GetRowType()
  754. {
  755. return typeof(PrincipalRow);
  756. }
  757. [DebuggerNonUserCode]
  758. protected override void OnRowChanged(DataRowChangeEventArgs e)
  759. {
  760. base.OnRowChanged(e);
  761. if (this.PrincipalRowChanged != null)
  762. {
  763. this.PrincipalRowChanged(this, new PrincipalRowChangeEvent((PrincipalRow)e.Row, e.Action));
  764. }
  765. }
  766. [DebuggerNonUserCode]
  767. protected override void OnRowChanging(DataRowChangeEventArgs e)
  768. {
  769. base.OnRowChanging(e);
  770. if (this.PrincipalRowChanging != null)
  771. {
  772. this.PrincipalRowChanging(this, new PrincipalRowChangeEvent((PrincipalRow)e.Row, e.Action));
  773. }
  774. }
  775. [DebuggerNonUserCode]
  776. protected override void OnRowDeleted(DataRowChangeEventArgs e)
  777. {
  778. base.OnRowDeleted(e);
  779. if (this.PrincipalRowDeleted != null)
  780. {
  781. this.PrincipalRowDeleted(this, new PrincipalRowChangeEvent((PrincipalRow)e.Row, e.Action));
  782. }
  783. }
  784. [DebuggerNonUserCode]
  785. protected override void OnRowDeleting(DataRowChangeEventArgs e)
  786. {
  787. base.OnRowDeleting(e);
  788. if (this.PrincipalRowDeleting != null)
  789. {
  790. this.PrincipalRowDeleting(this, new PrincipalRowChangeEvent((PrincipalRow)e.Row, e.Action));
  791. }
  792. }
  793. [DebuggerNonUserCode]
  794. public void RemovePrincipalRow(PrincipalRow row)
  795. {
  796. base.Rows.Remove(row);
  797. }
  798. [DebuggerNonUserCode]
  799. public static XmlSchemaComplexType GetTypedTableSchema(XmlSchemaSet xs)
  800. {
  801. XmlSchemaComplexType xmlSchemaComplexType = new XmlSchemaComplexType();
  802. XmlSchemaSequence xmlSchemaSequence = new XmlSchemaSequence();
  803. dsFrmRegionalLeader dsFrmRegionalLeader = new dsFrmRegionalLeader();
  804. XmlSchemaAny xmlSchemaAny = new XmlSchemaAny();
  805. xmlSchemaAny.Namespace = "http://www.w3.org/2001/XMLSchema";
  806. xmlSchemaAny.MinOccurs = 0m;
  807. xmlSchemaAny.MaxOccurs = decimal.MaxValue;
  808. xmlSchemaAny.ProcessContents = XmlSchemaContentProcessing.Lax;
  809. xmlSchemaSequence.Items.Add(xmlSchemaAny);
  810. XmlSchemaAny xmlSchemaAny2 = new XmlSchemaAny();
  811. xmlSchemaAny2.Namespace = "urn:schemas-microsoft-com:xml-diffgram-v1";
  812. xmlSchemaAny2.MinOccurs = 1m;
  813. xmlSchemaAny2.ProcessContents = XmlSchemaContentProcessing.Lax;
  814. xmlSchemaSequence.Items.Add(xmlSchemaAny2);
  815. XmlSchemaAttribute xmlSchemaAttribute = new XmlSchemaAttribute();
  816. xmlSchemaAttribute.Name = "namespace";
  817. xmlSchemaAttribute.FixedValue = dsFrmRegionalLeader.Namespace;
  818. xmlSchemaComplexType.Attributes.Add(xmlSchemaAttribute);
  819. XmlSchemaAttribute xmlSchemaAttribute2 = new XmlSchemaAttribute();
  820. xmlSchemaAttribute2.Name = "tableTypeName";
  821. xmlSchemaAttribute2.FixedValue = "PrincipalDataTable";
  822. xmlSchemaComplexType.Attributes.Add(xmlSchemaAttribute2);
  823. xmlSchemaComplexType.Particle = xmlSchemaSequence;
  824. XmlSchema schemaSerializable = dsFrmRegionalLeader.GetSchemaSerializable();
  825. if (xs.Contains(schemaSerializable.TargetNamespace))
  826. {
  827. MemoryStream memoryStream = new MemoryStream();
  828. MemoryStream memoryStream2 = new MemoryStream();
  829. try
  830. {
  831. XmlSchema xmlSchema = null;
  832. schemaSerializable.Write(memoryStream);
  833. IEnumerator enumerator = xs.Schemas(schemaSerializable.TargetNamespace).GetEnumerator();
  834. while (enumerator.MoveNext())
  835. {
  836. xmlSchema = (XmlSchema)enumerator.Current;
  837. memoryStream2.SetLength(0L);
  838. xmlSchema.Write(memoryStream2);
  839. if (memoryStream.Length == memoryStream2.Length)
  840. {
  841. memoryStream.Position = 0L;
  842. memoryStream2.Position = 0L;
  843. while (memoryStream.Position != memoryStream.Length && memoryStream.ReadByte() == memoryStream2.ReadByte())
  844. {
  845. }
  846. if (memoryStream.Position == memoryStream.Length)
  847. {
  848. return xmlSchemaComplexType;
  849. }
  850. }
  851. }
  852. }
  853. finally
  854. {
  855. memoryStream?.Close();
  856. memoryStream2?.Close();
  857. }
  858. }
  859. xs.Add(schemaSerializable);
  860. return xmlSchemaComplexType;
  861. }
  862. }
  863. [GeneratedCode("System.Data.Design.TypedDataSetGenerator", "2.0.0.0")]
  864. public class RegionalLeaderRow : DataRow
  865. {
  866. private RegionalLeaderDataTable tableRegionalLeader;
  867. [DebuggerNonUserCode]
  868. public string No_RegionalLeader
  869. {
  870. get
  871. {
  872. try
  873. {
  874. return (string)base[tableRegionalLeader.No_RegionalLeaderColumn];
  875. }
  876. catch (InvalidCastException innerException)
  877. {
  878. throw new StrongTypingException("The value for column 'No_RegionalLeader' in table 'RegionalLeader' is DBNull.", innerException);
  879. }
  880. }
  881. set
  882. {
  883. base[tableRegionalLeader.No_RegionalLeaderColumn] = value;
  884. }
  885. }
  886. [DebuggerNonUserCode]
  887. public string Name_RegionalLeader
  888. {
  889. get
  890. {
  891. try
  892. {
  893. return (string)base[tableRegionalLeader.Name_RegionalLeaderColumn];
  894. }
  895. catch (InvalidCastException innerException)
  896. {
  897. throw new StrongTypingException("The value for column 'Name_RegionalLeader' in table 'RegionalLeader' is DBNull.", innerException);
  898. }
  899. }
  900. set
  901. {
  902. base[tableRegionalLeader.Name_RegionalLeaderColumn] = value;
  903. }
  904. }
  905. [DebuggerNonUserCode]
  906. internal RegionalLeaderRow(DataRowBuilder rb)
  907. : base(rb)
  908. {
  909. tableRegionalLeader = (RegionalLeaderDataTable)base.Table;
  910. }
  911. [DebuggerNonUserCode]
  912. public bool IsNo_RegionalLeaderNull()
  913. {
  914. return IsNull(tableRegionalLeader.No_RegionalLeaderColumn);
  915. }
  916. [DebuggerNonUserCode]
  917. public void SetNo_RegionalLeaderNull()
  918. {
  919. base[tableRegionalLeader.No_RegionalLeaderColumn] = Convert.DBNull;
  920. }
  921. [DebuggerNonUserCode]
  922. public bool IsName_RegionalLeaderNull()
  923. {
  924. return IsNull(tableRegionalLeader.Name_RegionalLeaderColumn);
  925. }
  926. [DebuggerNonUserCode]
  927. public void SetName_RegionalLeaderNull()
  928. {
  929. base[tableRegionalLeader.Name_RegionalLeaderColumn] = Convert.DBNull;
  930. }
  931. }
  932. [GeneratedCode("System.Data.Design.TypedDataSetGenerator", "2.0.0.0")]
  933. public class EmployeeRow : DataRow
  934. {
  935. private EmployeeDataTable tableEmployee;
  936. [DebuggerNonUserCode]
  937. public string No_Employee
  938. {
  939. get
  940. {
  941. try
  942. {
  943. return (string)base[tableEmployee.No_EmployeeColumn];
  944. }
  945. catch (InvalidCastException innerException)
  946. {
  947. throw new StrongTypingException("The value for column 'No_Employee' in table 'Employee' is DBNull.", innerException);
  948. }
  949. }
  950. set
  951. {
  952. base[tableEmployee.No_EmployeeColumn] = value;
  953. }
  954. }
  955. [DebuggerNonUserCode]
  956. public string Name_Employee
  957. {
  958. get
  959. {
  960. try
  961. {
  962. return (string)base[tableEmployee.Name_EmployeeColumn];
  963. }
  964. catch (InvalidCastException innerException)
  965. {
  966. throw new StrongTypingException("The value for column 'Name_Employee' in table 'Employee' is DBNull.", innerException);
  967. }
  968. }
  969. set
  970. {
  971. base[tableEmployee.Name_EmployeeColumn] = value;
  972. }
  973. }
  974. [DebuggerNonUserCode]
  975. public string EmployeeNo_Employee
  976. {
  977. get
  978. {
  979. try
  980. {
  981. return (string)base[tableEmployee.EmployeeNo_EmployeeColumn];
  982. }
  983. catch (InvalidCastException innerException)
  984. {
  985. throw new StrongTypingException("The value for column 'EmployeeNo_Employee' in table 'Employee' is DBNull.", innerException);
  986. }
  987. }
  988. set
  989. {
  990. base[tableEmployee.EmployeeNo_EmployeeColumn] = value;
  991. }
  992. }
  993. [DebuggerNonUserCode]
  994. public string NameEng_Employee
  995. {
  996. get
  997. {
  998. try
  999. {
  1000. return (string)base[tableEmployee.NameEng_EmployeeColumn];
  1001. }
  1002. catch (InvalidCastException innerException)
  1003. {
  1004. throw new StrongTypingException("The value for column 'NameEng_Employee' in table 'Employee' is DBNull.", innerException);
  1005. }
  1006. }
  1007. set
  1008. {
  1009. base[tableEmployee.NameEng_EmployeeColumn] = value;
  1010. }
  1011. }
  1012. [DebuggerNonUserCode]
  1013. public bool Gender_Employee
  1014. {
  1015. get
  1016. {
  1017. try
  1018. {
  1019. return (bool)base[tableEmployee.Gender_EmployeeColumn];
  1020. }
  1021. catch (InvalidCastException innerException)
  1022. {
  1023. throw new StrongTypingException("The value for column 'Gender_Employee' in table 'Employee' is DBNull.", innerException);
  1024. }
  1025. }
  1026. set
  1027. {
  1028. base[tableEmployee.Gender_EmployeeColumn] = value;
  1029. }
  1030. }
  1031. [DebuggerNonUserCode]
  1032. public int Country_Employee
  1033. {
  1034. get
  1035. {
  1036. try
  1037. {
  1038. return (int)base[tableEmployee.Country_EmployeeColumn];
  1039. }
  1040. catch (InvalidCastException innerException)
  1041. {
  1042. throw new StrongTypingException("The value for column 'Country_Employee' in table 'Employee' is DBNull.", innerException);
  1043. }
  1044. }
  1045. set
  1046. {
  1047. base[tableEmployee.Country_EmployeeColumn] = value;
  1048. }
  1049. }
  1050. [DebuggerNonUserCode]
  1051. public string Homeplace_Employee
  1052. {
  1053. get
  1054. {
  1055. try
  1056. {
  1057. return (string)base[tableEmployee.Homeplace_EmployeeColumn];
  1058. }
  1059. catch (InvalidCastException innerException)
  1060. {
  1061. throw new StrongTypingException("The value for column 'Homeplace_Employee' in table 'Employee' is DBNull.", innerException);
  1062. }
  1063. }
  1064. set
  1065. {
  1066. base[tableEmployee.Homeplace_EmployeeColumn] = value;
  1067. }
  1068. }
  1069. [DebuggerNonUserCode]
  1070. public string Nation_Employee
  1071. {
  1072. get
  1073. {
  1074. try
  1075. {
  1076. return (string)base[tableEmployee.Nation_EmployeeColumn];
  1077. }
  1078. catch (InvalidCastException innerException)
  1079. {
  1080. throw new StrongTypingException("The value for column 'Nation_Employee' in table 'Employee' is DBNull.", innerException);
  1081. }
  1082. }
  1083. set
  1084. {
  1085. base[tableEmployee.Nation_EmployeeColumn] = value;
  1086. }
  1087. }
  1088. [DebuggerNonUserCode]
  1089. public string IDNo_Employee
  1090. {
  1091. get
  1092. {
  1093. try
  1094. {
  1095. return (string)base[tableEmployee.IDNo_EmployeeColumn];
  1096. }
  1097. catch (InvalidCastException innerException)
  1098. {
  1099. throw new StrongTypingException("The value for column 'IDNo_Employee' in table 'Employee' is DBNull.", innerException);
  1100. }
  1101. }
  1102. set
  1103. {
  1104. base[tableEmployee.IDNo_EmployeeColumn] = value;
  1105. }
  1106. }
  1107. [DebuggerNonUserCode]
  1108. public string Passport_Employee
  1109. {
  1110. get
  1111. {
  1112. try
  1113. {
  1114. return (string)base[tableEmployee.Passport_EmployeeColumn];
  1115. }
  1116. catch (InvalidCastException innerException)
  1117. {
  1118. throw new StrongTypingException("The value for column 'Passport_Employee' in table 'Employee' is DBNull.", innerException);
  1119. }
  1120. }
  1121. set
  1122. {
  1123. base[tableEmployee.Passport_EmployeeColumn] = value;
  1124. }
  1125. }
  1126. [DebuggerNonUserCode]
  1127. public bool IsMarried_Employee
  1128. {
  1129. get
  1130. {
  1131. try
  1132. {
  1133. return (bool)base[tableEmployee.IsMarried_EmployeeColumn];
  1134. }
  1135. catch (InvalidCastException innerException)
  1136. {
  1137. throw new StrongTypingException("The value for column 'IsMarried_Employee' in table 'Employee' is DBNull.", innerException);
  1138. }
  1139. }
  1140. set
  1141. {
  1142. base[tableEmployee.IsMarried_EmployeeColumn] = value;
  1143. }
  1144. }
  1145. [DebuggerNonUserCode]
  1146. public DateTime CreateDate_Employee
  1147. {
  1148. get
  1149. {
  1150. try
  1151. {
  1152. return (DateTime)base[tableEmployee.CreateDate_EmployeeColumn];
  1153. }
  1154. catch (InvalidCastException innerException)
  1155. {
  1156. throw new StrongTypingException("The value for column 'CreateDate_Employee' in table 'Employee' is DBNull.", innerException);
  1157. }
  1158. }
  1159. set
  1160. {
  1161. base[tableEmployee.CreateDate_EmployeeColumn] = value;
  1162. }
  1163. }
  1164. [DebuggerNonUserCode]
  1165. public string Duty_Employee
  1166. {
  1167. get
  1168. {
  1169. try
  1170. {
  1171. return (string)base[tableEmployee.Duty_EmployeeColumn];
  1172. }
  1173. catch (InvalidCastException innerException)
  1174. {
  1175. throw new StrongTypingException("The value for column 'Duty_Employee' in table 'Employee' is DBNull.", innerException);
  1176. }
  1177. }
  1178. set
  1179. {
  1180. base[tableEmployee.Duty_EmployeeColumn] = value;
  1181. }
  1182. }
  1183. [DebuggerNonUserCode]
  1184. public decimal Probation_Employee
  1185. {
  1186. get
  1187. {
  1188. try
  1189. {
  1190. return (decimal)base[tableEmployee.Probation_EmployeeColumn];
  1191. }
  1192. catch (InvalidCastException innerException)
  1193. {
  1194. throw new StrongTypingException("The value for column 'Probation_Employee' in table 'Employee' is DBNull.", innerException);
  1195. }
  1196. }
  1197. set
  1198. {
  1199. base[tableEmployee.Probation_EmployeeColumn] = value;
  1200. }
  1201. }
  1202. [DebuggerNonUserCode]
  1203. public DateTime OnJobDate_Employee
  1204. {
  1205. get
  1206. {
  1207. try
  1208. {
  1209. return (DateTime)base[tableEmployee.OnJobDate_EmployeeColumn];
  1210. }
  1211. catch (InvalidCastException innerException)
  1212. {
  1213. throw new StrongTypingException("The value for column 'OnJobDate_Employee' in table 'Employee' is DBNull.", innerException);
  1214. }
  1215. }
  1216. set
  1217. {
  1218. base[tableEmployee.OnJobDate_EmployeeColumn] = value;
  1219. }
  1220. }
  1221. [DebuggerNonUserCode]
  1222. public DateTime OnDuty_Employee
  1223. {
  1224. get
  1225. {
  1226. try
  1227. {
  1228. return (DateTime)base[tableEmployee.OnDuty_EmployeeColumn];
  1229. }
  1230. catch (InvalidCastException innerException)
  1231. {
  1232. throw new StrongTypingException("The value for column 'OnDuty_Employee' in table 'Employee' is DBNull.", innerException);
  1233. }
  1234. }
  1235. set
  1236. {
  1237. base[tableEmployee.OnDuty_EmployeeColumn] = value;
  1238. }
  1239. }
  1240. [DebuggerNonUserCode]
  1241. public int ObJobStatus_Employee
  1242. {
  1243. get
  1244. {
  1245. try
  1246. {
  1247. return (int)base[tableEmployee.ObJobStatus_EmployeeColumn];
  1248. }
  1249. catch (InvalidCastException innerException)
  1250. {
  1251. throw new StrongTypingException("The value for column 'ObJobStatus_Employee' in table 'Employee' is DBNull.", innerException);
  1252. }
  1253. }
  1254. set
  1255. {
  1256. base[tableEmployee.ObJobStatus_EmployeeColumn] = value;
  1257. }
  1258. }
  1259. [DebuggerNonUserCode]
  1260. public DateTime OffDuty_Employee
  1261. {
  1262. get
  1263. {
  1264. try
  1265. {
  1266. return (DateTime)base[tableEmployee.OffDuty_EmployeeColumn];
  1267. }
  1268. catch (InvalidCastException innerException)
  1269. {
  1270. throw new StrongTypingException("The value for column 'OffDuty_Employee' in table 'Employee' is DBNull.", innerException);
  1271. }
  1272. }
  1273. set
  1274. {
  1275. base[tableEmployee.OffDuty_EmployeeColumn] = value;
  1276. }
  1277. }
  1278. [DebuggerNonUserCode]
  1279. public DateTime SuspendDate_Employee
  1280. {
  1281. get
  1282. {
  1283. try
  1284. {
  1285. return (DateTime)base[tableEmployee.SuspendDate_EmployeeColumn];
  1286. }
  1287. catch (InvalidCastException innerException)
  1288. {
  1289. throw new StrongTypingException("The value for column 'SuspendDate_Employee' in table 'Employee' is DBNull.", innerException);
  1290. }
  1291. }
  1292. set
  1293. {
  1294. base[tableEmployee.SuspendDate_EmployeeColumn] = value;
  1295. }
  1296. }
  1297. [DebuggerNonUserCode]
  1298. public string Tel_Employee
  1299. {
  1300. get
  1301. {
  1302. try
  1303. {
  1304. return (string)base[tableEmployee.Tel_EmployeeColumn];
  1305. }
  1306. catch (InvalidCastException innerException)
  1307. {
  1308. throw new StrongTypingException("The value for column 'Tel_Employee' in table 'Employee' is DBNull.", innerException);
  1309. }
  1310. }
  1311. set
  1312. {
  1313. base[tableEmployee.Tel_EmployeeColumn] = value;
  1314. }
  1315. }
  1316. [DebuggerNonUserCode]
  1317. public string EMail_Employee
  1318. {
  1319. get
  1320. {
  1321. try
  1322. {
  1323. return (string)base[tableEmployee.EMail_EmployeeColumn];
  1324. }
  1325. catch (InvalidCastException innerException)
  1326. {
  1327. throw new StrongTypingException("The value for column 'EMail_Employee' in table 'Employee' is DBNull.", innerException);
  1328. }
  1329. }
  1330. set
  1331. {
  1332. base[tableEmployee.EMail_EmployeeColumn] = value;
  1333. }
  1334. }
  1335. [DebuggerNonUserCode]
  1336. public string Address_Employee
  1337. {
  1338. get
  1339. {
  1340. try
  1341. {
  1342. return (string)base[tableEmployee.Address_EmployeeColumn];
  1343. }
  1344. catch (InvalidCastException innerException)
  1345. {
  1346. throw new StrongTypingException("The value for column 'Address_Employee' in table 'Employee' is DBNull.", innerException);
  1347. }
  1348. }
  1349. set
  1350. {
  1351. base[tableEmployee.Address_EmployeeColumn] = value;
  1352. }
  1353. }
  1354. [DebuggerNonUserCode]
  1355. public string Comment_Employee
  1356. {
  1357. get
  1358. {
  1359. try
  1360. {
  1361. return (string)base[tableEmployee.Comment_EmployeeColumn];
  1362. }
  1363. catch (InvalidCastException innerException)
  1364. {
  1365. throw new StrongTypingException("The value for column 'Comment_Employee' in table 'Employee' is DBNull.", innerException);
  1366. }
  1367. }
  1368. set
  1369. {
  1370. base[tableEmployee.Comment_EmployeeColumn] = value;
  1371. }
  1372. }
  1373. [DebuggerNonUserCode]
  1374. public DateTime LastModDate_Employee
  1375. {
  1376. get
  1377. {
  1378. try
  1379. {
  1380. return (DateTime)base[tableEmployee.LastModDate_EmployeeColumn];
  1381. }
  1382. catch (InvalidCastException innerException)
  1383. {
  1384. throw new StrongTypingException("The value for column 'LastModDate_Employee' in table 'Employee' is DBNull.", innerException);
  1385. }
  1386. }
  1387. set
  1388. {
  1389. base[tableEmployee.LastModDate_EmployeeColumn] = value;
  1390. }
  1391. }
  1392. [DebuggerNonUserCode]
  1393. internal EmployeeRow(DataRowBuilder rb)
  1394. : base(rb)
  1395. {
  1396. tableEmployee = (EmployeeDataTable)base.Table;
  1397. }
  1398. [DebuggerNonUserCode]
  1399. public bool IsNo_EmployeeNull()
  1400. {
  1401. return IsNull(tableEmployee.No_EmployeeColumn);
  1402. }
  1403. [DebuggerNonUserCode]
  1404. public void SetNo_EmployeeNull()
  1405. {
  1406. base[tableEmployee.No_EmployeeColumn] = Convert.DBNull;
  1407. }
  1408. [DebuggerNonUserCode]
  1409. public bool IsName_EmployeeNull()
  1410. {
  1411. return IsNull(tableEmployee.Name_EmployeeColumn);
  1412. }
  1413. [DebuggerNonUserCode]
  1414. public void SetName_EmployeeNull()
  1415. {
  1416. base[tableEmployee.Name_EmployeeColumn] = Convert.DBNull;
  1417. }
  1418. [DebuggerNonUserCode]
  1419. public bool IsEmployeeNo_EmployeeNull()
  1420. {
  1421. return IsNull(tableEmployee.EmployeeNo_EmployeeColumn);
  1422. }
  1423. [DebuggerNonUserCode]
  1424. public void SetEmployeeNo_EmployeeNull()
  1425. {
  1426. base[tableEmployee.EmployeeNo_EmployeeColumn] = Convert.DBNull;
  1427. }
  1428. [DebuggerNonUserCode]
  1429. public bool IsNameEng_EmployeeNull()
  1430. {
  1431. return IsNull(tableEmployee.NameEng_EmployeeColumn);
  1432. }
  1433. [DebuggerNonUserCode]
  1434. public void SetNameEng_EmployeeNull()
  1435. {
  1436. base[tableEmployee.NameEng_EmployeeColumn] = Convert.DBNull;
  1437. }
  1438. [DebuggerNonUserCode]
  1439. public bool IsGender_EmployeeNull()
  1440. {
  1441. return IsNull(tableEmployee.Gender_EmployeeColumn);
  1442. }
  1443. [DebuggerNonUserCode]
  1444. public void SetGender_EmployeeNull()
  1445. {
  1446. base[tableEmployee.Gender_EmployeeColumn] = Convert.DBNull;
  1447. }
  1448. [DebuggerNonUserCode]
  1449. public bool IsCountry_EmployeeNull()
  1450. {
  1451. return IsNull(tableEmployee.Country_EmployeeColumn);
  1452. }
  1453. [DebuggerNonUserCode]
  1454. public void SetCountry_EmployeeNull()
  1455. {
  1456. base[tableEmployee.Country_EmployeeColumn] = Convert.DBNull;
  1457. }
  1458. [DebuggerNonUserCode]
  1459. public bool IsHomeplace_EmployeeNull()
  1460. {
  1461. return IsNull(tableEmployee.Homeplace_EmployeeColumn);
  1462. }
  1463. [DebuggerNonUserCode]
  1464. public void SetHomeplace_EmployeeNull()
  1465. {
  1466. base[tableEmployee.Homeplace_EmployeeColumn] = Convert.DBNull;
  1467. }
  1468. [DebuggerNonUserCode]
  1469. public bool IsNation_EmployeeNull()
  1470. {
  1471. return IsNull(tableEmployee.Nation_EmployeeColumn);
  1472. }
  1473. [DebuggerNonUserCode]
  1474. public void SetNation_EmployeeNull()
  1475. {
  1476. base[tableEmployee.Nation_EmployeeColumn] = Convert.DBNull;
  1477. }
  1478. [DebuggerNonUserCode]
  1479. public bool IsIDNo_EmployeeNull()
  1480. {
  1481. return IsNull(tableEmployee.IDNo_EmployeeColumn);
  1482. }
  1483. [DebuggerNonUserCode]
  1484. public void SetIDNo_EmployeeNull()
  1485. {
  1486. base[tableEmployee.IDNo_EmployeeColumn] = Convert.DBNull;
  1487. }
  1488. [DebuggerNonUserCode]
  1489. public bool IsPassport_EmployeeNull()
  1490. {
  1491. return IsNull(tableEmployee.Passport_EmployeeColumn);
  1492. }
  1493. [DebuggerNonUserCode]
  1494. public void SetPassport_EmployeeNull()
  1495. {
  1496. base[tableEmployee.Passport_EmployeeColumn] = Convert.DBNull;
  1497. }
  1498. [DebuggerNonUserCode]
  1499. public bool IsIsMarried_EmployeeNull()
  1500. {
  1501. return IsNull(tableEmployee.IsMarried_EmployeeColumn);
  1502. }
  1503. [DebuggerNonUserCode]
  1504. public void SetIsMarried_EmployeeNull()
  1505. {
  1506. base[tableEmployee.IsMarried_EmployeeColumn] = Convert.DBNull;
  1507. }
  1508. [DebuggerNonUserCode]
  1509. public bool IsCreateDate_EmployeeNull()
  1510. {
  1511. return IsNull(tableEmployee.CreateDate_EmployeeColumn);
  1512. }
  1513. [DebuggerNonUserCode]
  1514. public void SetCreateDate_EmployeeNull()
  1515. {
  1516. base[tableEmployee.CreateDate_EmployeeColumn] = Convert.DBNull;
  1517. }
  1518. [DebuggerNonUserCode]
  1519. public bool IsDuty_EmployeeNull()
  1520. {
  1521. return IsNull(tableEmployee.Duty_EmployeeColumn);
  1522. }
  1523. [DebuggerNonUserCode]
  1524. public void SetDuty_EmployeeNull()
  1525. {
  1526. base[tableEmployee.Duty_EmployeeColumn] = Convert.DBNull;
  1527. }
  1528. [DebuggerNonUserCode]
  1529. public bool IsProbation_EmployeeNull()
  1530. {
  1531. return IsNull(tableEmployee.Probation_EmployeeColumn);
  1532. }
  1533. [DebuggerNonUserCode]
  1534. public void SetProbation_EmployeeNull()
  1535. {
  1536. base[tableEmployee.Probation_EmployeeColumn] = Convert.DBNull;
  1537. }
  1538. [DebuggerNonUserCode]
  1539. public bool IsOnJobDate_EmployeeNull()
  1540. {
  1541. return IsNull(tableEmployee.OnJobDate_EmployeeColumn);
  1542. }
  1543. [DebuggerNonUserCode]
  1544. public void SetOnJobDate_EmployeeNull()
  1545. {
  1546. base[tableEmployee.OnJobDate_EmployeeColumn] = Convert.DBNull;
  1547. }
  1548. [DebuggerNonUserCode]
  1549. public bool IsOnDuty_EmployeeNull()
  1550. {
  1551. return IsNull(tableEmployee.OnDuty_EmployeeColumn);
  1552. }
  1553. [DebuggerNonUserCode]
  1554. public void SetOnDuty_EmployeeNull()
  1555. {
  1556. base[tableEmployee.OnDuty_EmployeeColumn] = Convert.DBNull;
  1557. }
  1558. [DebuggerNonUserCode]
  1559. public bool IsObJobStatus_EmployeeNull()
  1560. {
  1561. return IsNull(tableEmployee.ObJobStatus_EmployeeColumn);
  1562. }
  1563. [DebuggerNonUserCode]
  1564. public void SetObJobStatus_EmployeeNull()
  1565. {
  1566. base[tableEmployee.ObJobStatus_EmployeeColumn] = Convert.DBNull;
  1567. }
  1568. [DebuggerNonUserCode]
  1569. public bool IsOffDuty_EmployeeNull()
  1570. {
  1571. return IsNull(tableEmployee.OffDuty_EmployeeColumn);
  1572. }
  1573. [DebuggerNonUserCode]
  1574. public void SetOffDuty_EmployeeNull()
  1575. {
  1576. base[tableEmployee.OffDuty_EmployeeColumn] = Convert.DBNull;
  1577. }
  1578. [DebuggerNonUserCode]
  1579. public bool IsSuspendDate_EmployeeNull()
  1580. {
  1581. return IsNull(tableEmployee.SuspendDate_EmployeeColumn);
  1582. }
  1583. [DebuggerNonUserCode]
  1584. public void SetSuspendDate_EmployeeNull()
  1585. {
  1586. base[tableEmployee.SuspendDate_EmployeeColumn] = Convert.DBNull;
  1587. }
  1588. [DebuggerNonUserCode]
  1589. public bool IsTel_EmployeeNull()
  1590. {
  1591. return IsNull(tableEmployee.Tel_EmployeeColumn);
  1592. }
  1593. [DebuggerNonUserCode]
  1594. public void SetTel_EmployeeNull()
  1595. {
  1596. base[tableEmployee.Tel_EmployeeColumn] = Convert.DBNull;
  1597. }
  1598. [DebuggerNonUserCode]
  1599. public bool IsEMail_EmployeeNull()
  1600. {
  1601. return IsNull(tableEmployee.EMail_EmployeeColumn);
  1602. }
  1603. [DebuggerNonUserCode]
  1604. public void SetEMail_EmployeeNull()
  1605. {
  1606. base[tableEmployee.EMail_EmployeeColumn] = Convert.DBNull;
  1607. }
  1608. [DebuggerNonUserCode]
  1609. public bool IsAddress_EmployeeNull()
  1610. {
  1611. return IsNull(tableEmployee.Address_EmployeeColumn);
  1612. }
  1613. [DebuggerNonUserCode]
  1614. public void SetAddress_EmployeeNull()
  1615. {
  1616. base[tableEmployee.Address_EmployeeColumn] = Convert.DBNull;
  1617. }
  1618. [DebuggerNonUserCode]
  1619. public bool IsComment_EmployeeNull()
  1620. {
  1621. return IsNull(tableEmployee.Comment_EmployeeColumn);
  1622. }
  1623. [DebuggerNonUserCode]
  1624. public void SetComment_EmployeeNull()
  1625. {
  1626. base[tableEmployee.Comment_EmployeeColumn] = Convert.DBNull;
  1627. }
  1628. [DebuggerNonUserCode]
  1629. public bool IsLastModDate_EmployeeNull()
  1630. {
  1631. return IsNull(tableEmployee.LastModDate_EmployeeColumn);
  1632. }
  1633. [DebuggerNonUserCode]
  1634. public void SetLastModDate_EmployeeNull()
  1635. {
  1636. base[tableEmployee.LastModDate_EmployeeColumn] = Convert.DBNull;
  1637. }
  1638. }
  1639. [GeneratedCode("System.Data.Design.TypedDataSetGenerator", "2.0.0.0")]
  1640. public class PrincipalRow : DataRow
  1641. {
  1642. private PrincipalDataTable tablePrincipal;
  1643. [DebuggerNonUserCode]
  1644. public bool IsMain_Principal
  1645. {
  1646. get
  1647. {
  1648. try
  1649. {
  1650. return (bool)base[tablePrincipal.IsMain_PrincipalColumn];
  1651. }
  1652. catch (InvalidCastException innerException)
  1653. {
  1654. throw new StrongTypingException("The value for column 'IsMain_Principal' in table 'Principal' is DBNull.", innerException);
  1655. }
  1656. }
  1657. set
  1658. {
  1659. base[tablePrincipal.IsMain_PrincipalColumn] = value;
  1660. }
  1661. }
  1662. [DebuggerNonUserCode]
  1663. public string Comment_Principal
  1664. {
  1665. get
  1666. {
  1667. try
  1668. {
  1669. return (string)base[tablePrincipal.Comment_PrincipalColumn];
  1670. }
  1671. catch (InvalidCastException innerException)
  1672. {
  1673. throw new StrongTypingException("The value for column 'Comment_Principal' in table 'Principal' is DBNull.", innerException);
  1674. }
  1675. }
  1676. set
  1677. {
  1678. base[tablePrincipal.Comment_PrincipalColumn] = value;
  1679. }
  1680. }
  1681. [DebuggerNonUserCode]
  1682. public string Name_Employee
  1683. {
  1684. get
  1685. {
  1686. try
  1687. {
  1688. return (string)base[tablePrincipal.Name_EmployeeColumn];
  1689. }
  1690. catch (InvalidCastException innerException)
  1691. {
  1692. throw new StrongTypingException("The value for column 'Name_Employee' in table 'Principal' is DBNull.", innerException);
  1693. }
  1694. }
  1695. set
  1696. {
  1697. base[tablePrincipal.Name_EmployeeColumn] = value;
  1698. }
  1699. }
  1700. [DebuggerNonUserCode]
  1701. public string No_Employee
  1702. {
  1703. get
  1704. {
  1705. try
  1706. {
  1707. return (string)base[tablePrincipal.No_EmployeeColumn];
  1708. }
  1709. catch (InvalidCastException innerException)
  1710. {
  1711. throw new StrongTypingException("The value for column 'No_Employee' in table 'Principal' is DBNull.", innerException);
  1712. }
  1713. }
  1714. set
  1715. {
  1716. base[tablePrincipal.No_EmployeeColumn] = value;
  1717. }
  1718. }
  1719. [DebuggerNonUserCode]
  1720. internal PrincipalRow(DataRowBuilder rb)
  1721. : base(rb)
  1722. {
  1723. tablePrincipal = (PrincipalDataTable)base.Table;
  1724. }
  1725. [DebuggerNonUserCode]
  1726. public bool IsIsMain_PrincipalNull()
  1727. {
  1728. return IsNull(tablePrincipal.IsMain_PrincipalColumn);
  1729. }
  1730. [DebuggerNonUserCode]
  1731. public void SetIsMain_PrincipalNull()
  1732. {
  1733. base[tablePrincipal.IsMain_PrincipalColumn] = Convert.DBNull;
  1734. }
  1735. [DebuggerNonUserCode]
  1736. public bool IsComment_PrincipalNull()
  1737. {
  1738. return IsNull(tablePrincipal.Comment_PrincipalColumn);
  1739. }
  1740. [DebuggerNonUserCode]
  1741. public void SetComment_PrincipalNull()
  1742. {
  1743. base[tablePrincipal.Comment_PrincipalColumn] = Convert.DBNull;
  1744. }
  1745. [DebuggerNonUserCode]
  1746. public bool IsName_EmployeeNull()
  1747. {
  1748. return IsNull(tablePrincipal.Name_EmployeeColumn);
  1749. }
  1750. [DebuggerNonUserCode]
  1751. public void SetName_EmployeeNull()
  1752. {
  1753. base[tablePrincipal.Name_EmployeeColumn] = Convert.DBNull;
  1754. }
  1755. [DebuggerNonUserCode]
  1756. public bool IsNo_EmployeeNull()
  1757. {
  1758. return IsNull(tablePrincipal.No_EmployeeColumn);
  1759. }
  1760. [DebuggerNonUserCode]
  1761. public void SetNo_EmployeeNull()
  1762. {
  1763. base[tablePrincipal.No_EmployeeColumn] = Convert.DBNull;
  1764. }
  1765. }
  1766. [GeneratedCode("System.Data.Design.TypedDataSetGenerator", "2.0.0.0")]
  1767. public class RegionalLeaderRowChangeEvent : EventArgs
  1768. {
  1769. private RegionalLeaderRow eventRow;
  1770. private DataRowAction eventAction;
  1771. [DebuggerNonUserCode]
  1772. public RegionalLeaderRow Row => eventRow;
  1773. [DebuggerNonUserCode]
  1774. public DataRowAction Action => eventAction;
  1775. [DebuggerNonUserCode]
  1776. public RegionalLeaderRowChangeEvent(RegionalLeaderRow row, DataRowAction action)
  1777. {
  1778. eventRow = row;
  1779. eventAction = action;
  1780. }
  1781. }
  1782. [GeneratedCode("System.Data.Design.TypedDataSetGenerator", "2.0.0.0")]
  1783. public class EmployeeRowChangeEvent : EventArgs
  1784. {
  1785. private EmployeeRow eventRow;
  1786. private DataRowAction eventAction;
  1787. [DebuggerNonUserCode]
  1788. public EmployeeRow Row => eventRow;
  1789. [DebuggerNonUserCode]
  1790. public DataRowAction Action => eventAction;
  1791. [DebuggerNonUserCode]
  1792. public EmployeeRowChangeEvent(EmployeeRow row, DataRowAction action)
  1793. {
  1794. eventRow = row;
  1795. eventAction = action;
  1796. }
  1797. }
  1798. [GeneratedCode("System.Data.Design.TypedDataSetGenerator", "2.0.0.0")]
  1799. public class PrincipalRowChangeEvent : EventArgs
  1800. {
  1801. private PrincipalRow eventRow;
  1802. private DataRowAction eventAction;
  1803. [DebuggerNonUserCode]
  1804. public PrincipalRow Row => eventRow;
  1805. [DebuggerNonUserCode]
  1806. public DataRowAction Action => eventAction;
  1807. [DebuggerNonUserCode]
  1808. public PrincipalRowChangeEvent(PrincipalRow row, DataRowAction action)
  1809. {
  1810. eventRow = row;
  1811. eventAction = action;
  1812. }
  1813. }
  1814. private RegionalLeaderDataTable tableRegionalLeader;
  1815. private EmployeeDataTable tableEmployee;
  1816. private PrincipalDataTable tablePrincipal;
  1817. private SchemaSerializationMode _schemaSerializationMode = SchemaSerializationMode.IncludeSchema;
  1818. [Browsable(false)]
  1819. [DebuggerNonUserCode]
  1820. [DesignerSerializationVisibility(DesignerSerializationVisibility.Content)]
  1821. public RegionalLeaderDataTable RegionalLeader => tableRegionalLeader;
  1822. [DesignerSerializationVisibility(DesignerSerializationVisibility.Content)]
  1823. [DebuggerNonUserCode]
  1824. [Browsable(false)]
  1825. public EmployeeDataTable Employee => tableEmployee;
  1826. [Browsable(false)]
  1827. [DesignerSerializationVisibility(DesignerSerializationVisibility.Content)]
  1828. [DebuggerNonUserCode]
  1829. public PrincipalDataTable Principal => tablePrincipal;
  1830. [DebuggerNonUserCode]
  1831. [Browsable(true)]
  1832. [DesignerSerializationVisibility(DesignerSerializationVisibility.Visible)]
  1833. public override SchemaSerializationMode SchemaSerializationMode
  1834. {
  1835. get
  1836. {
  1837. return _schemaSerializationMode;
  1838. }
  1839. set
  1840. {
  1841. _schemaSerializationMode = value;
  1842. }
  1843. }
  1844. [DebuggerNonUserCode]
  1845. [DesignerSerializationVisibility(DesignerSerializationVisibility.Hidden)]
  1846. public new DataTableCollection Tables => base.Tables;
  1847. [DesignerSerializationVisibility(DesignerSerializationVisibility.Hidden)]
  1848. [DebuggerNonUserCode]
  1849. public new DataRelationCollection Relations => base.Relations;
  1850. [DebuggerNonUserCode]
  1851. public dsFrmRegionalLeader()
  1852. {
  1853. BeginInit();
  1854. InitClass();
  1855. CollectionChangeEventHandler value = SchemaChanged;
  1856. base.Tables.CollectionChanged += value;
  1857. base.Relations.CollectionChanged += value;
  1858. EndInit();
  1859. }
  1860. [DebuggerNonUserCode]
  1861. protected dsFrmRegionalLeader(SerializationInfo info, StreamingContext context)
  1862. : base(info, context, ConstructSchema: false)
  1863. {
  1864. if (IsBinarySerialized(info, context))
  1865. {
  1866. InitVars(initTable: false);
  1867. CollectionChangeEventHandler value = SchemaChanged;
  1868. Tables.CollectionChanged += value;
  1869. Relations.CollectionChanged += value;
  1870. return;
  1871. }
  1872. string s = (string)info.GetValue("XmlSchema", typeof(string));
  1873. if (DetermineSchemaSerializationMode(info, context) == SchemaSerializationMode.IncludeSchema)
  1874. {
  1875. DataSet dataSet = new DataSet();
  1876. dataSet.ReadXmlSchema(new XmlTextReader(new StringReader(s)));
  1877. if (dataSet.Tables["RegionalLeader"] != null)
  1878. {
  1879. base.Tables.Add(new RegionalLeaderDataTable(dataSet.Tables["RegionalLeader"]));
  1880. }
  1881. if (dataSet.Tables["Employee"] != null)
  1882. {
  1883. base.Tables.Add(new EmployeeDataTable(dataSet.Tables["Employee"]));
  1884. }
  1885. if (dataSet.Tables["Principal"] != null)
  1886. {
  1887. base.Tables.Add(new PrincipalDataTable(dataSet.Tables["Principal"]));
  1888. }
  1889. base.DataSetName = dataSet.DataSetName;
  1890. base.Prefix = dataSet.Prefix;
  1891. base.Namespace = dataSet.Namespace;
  1892. base.Locale = dataSet.Locale;
  1893. base.CaseSensitive = dataSet.CaseSensitive;
  1894. base.EnforceConstraints = dataSet.EnforceConstraints;
  1895. Merge(dataSet, preserveChanges: false, MissingSchemaAction.Add);
  1896. InitVars();
  1897. }
  1898. else
  1899. {
  1900. ReadXmlSchema(new XmlTextReader(new StringReader(s)));
  1901. }
  1902. GetSerializationData(info, context);
  1903. CollectionChangeEventHandler value2 = SchemaChanged;
  1904. base.Tables.CollectionChanged += value2;
  1905. Relations.CollectionChanged += value2;
  1906. }
  1907. [DebuggerNonUserCode]
  1908. protected override void InitializeDerivedDataSet()
  1909. {
  1910. BeginInit();
  1911. InitClass();
  1912. EndInit();
  1913. }
  1914. [DebuggerNonUserCode]
  1915. public override DataSet Clone()
  1916. {
  1917. dsFrmRegionalLeader dsFrmRegionalLeader = (dsFrmRegionalLeader)base.Clone();
  1918. dsFrmRegionalLeader.InitVars();
  1919. dsFrmRegionalLeader.SchemaSerializationMode = SchemaSerializationMode;
  1920. return dsFrmRegionalLeader;
  1921. }
  1922. [DebuggerNonUserCode]
  1923. protected override bool ShouldSerializeTables()
  1924. {
  1925. return false;
  1926. }
  1927. [DebuggerNonUserCode]
  1928. protected override bool ShouldSerializeRelations()
  1929. {
  1930. return false;
  1931. }
  1932. [DebuggerNonUserCode]
  1933. protected override void ReadXmlSerializable(XmlReader reader)
  1934. {
  1935. if (DetermineSchemaSerializationMode(reader) == SchemaSerializationMode.IncludeSchema)
  1936. {
  1937. Reset();
  1938. DataSet dataSet = new DataSet();
  1939. dataSet.ReadXml(reader);
  1940. if (dataSet.Tables["RegionalLeader"] != null)
  1941. {
  1942. base.Tables.Add(new RegionalLeaderDataTable(dataSet.Tables["RegionalLeader"]));
  1943. }
  1944. if (dataSet.Tables["Employee"] != null)
  1945. {
  1946. base.Tables.Add(new EmployeeDataTable(dataSet.Tables["Employee"]));
  1947. }
  1948. if (dataSet.Tables["Principal"] != null)
  1949. {
  1950. base.Tables.Add(new PrincipalDataTable(dataSet.Tables["Principal"]));
  1951. }
  1952. base.DataSetName = dataSet.DataSetName;
  1953. base.Prefix = dataSet.Prefix;
  1954. base.Namespace = dataSet.Namespace;
  1955. base.Locale = dataSet.Locale;
  1956. base.CaseSensitive = dataSet.CaseSensitive;
  1957. base.EnforceConstraints = dataSet.EnforceConstraints;
  1958. Merge(dataSet, preserveChanges: false, MissingSchemaAction.Add);
  1959. InitVars();
  1960. }
  1961. else
  1962. {
  1963. ReadXml(reader);
  1964. InitVars();
  1965. }
  1966. }
  1967. [DebuggerNonUserCode]
  1968. protected override XmlSchema GetSchemaSerializable()
  1969. {
  1970. MemoryStream memoryStream = new MemoryStream();
  1971. WriteXmlSchema(new XmlTextWriter(memoryStream, null));
  1972. memoryStream.Position = 0L;
  1973. return XmlSchema.Read(new XmlTextReader(memoryStream), null);
  1974. }
  1975. [DebuggerNonUserCode]
  1976. internal void InitVars()
  1977. {
  1978. InitVars(initTable: true);
  1979. }
  1980. [DebuggerNonUserCode]
  1981. internal void InitVars(bool initTable)
  1982. {
  1983. tableRegionalLeader = (RegionalLeaderDataTable)base.Tables["RegionalLeader"];
  1984. if (initTable && tableRegionalLeader != null)
  1985. {
  1986. tableRegionalLeader.InitVars();
  1987. }
  1988. tableEmployee = (EmployeeDataTable)base.Tables["Employee"];
  1989. if (initTable && tableEmployee != null)
  1990. {
  1991. tableEmployee.InitVars();
  1992. }
  1993. tablePrincipal = (PrincipalDataTable)base.Tables["Principal"];
  1994. if (initTable && tablePrincipal != null)
  1995. {
  1996. tablePrincipal.InitVars();
  1997. }
  1998. }
  1999. [DebuggerNonUserCode]
  2000. private void InitClass()
  2001. {
  2002. base.DataSetName = "dsFrmRegionalLeader";
  2003. base.Prefix = "";
  2004. base.Namespace = "http://tempuri.org/dsFrmRegionalLeader.xsd";
  2005. base.EnforceConstraints = true;
  2006. SchemaSerializationMode = SchemaSerializationMode.IncludeSchema;
  2007. tableRegionalLeader = new RegionalLeaderDataTable();
  2008. base.Tables.Add(tableRegionalLeader);
  2009. tableEmployee = new EmployeeDataTable();
  2010. base.Tables.Add(tableEmployee);
  2011. tablePrincipal = new PrincipalDataTable();
  2012. base.Tables.Add(tablePrincipal);
  2013. }
  2014. [DebuggerNonUserCode]
  2015. private bool ShouldSerializeRegionalLeader()
  2016. {
  2017. return false;
  2018. }
  2019. [DebuggerNonUserCode]
  2020. private bool ShouldSerializeEmployee()
  2021. {
  2022. return false;
  2023. }
  2024. [DebuggerNonUserCode]
  2025. private bool ShouldSerializePrincipal()
  2026. {
  2027. return false;
  2028. }
  2029. [DebuggerNonUserCode]
  2030. private void SchemaChanged(object sender, CollectionChangeEventArgs e)
  2031. {
  2032. if (e.Action == CollectionChangeAction.Remove)
  2033. {
  2034. InitVars();
  2035. }
  2036. }
  2037. [DebuggerNonUserCode]
  2038. public static XmlSchemaComplexType GetTypedDataSetSchema(XmlSchemaSet xs)
  2039. {
  2040. dsFrmRegionalLeader dsFrmRegionalLeader = new dsFrmRegionalLeader();
  2041. XmlSchemaComplexType xmlSchemaComplexType = new XmlSchemaComplexType();
  2042. XmlSchemaSequence xmlSchemaSequence = new XmlSchemaSequence();
  2043. XmlSchemaAny xmlSchemaAny = new XmlSchemaAny();
  2044. xmlSchemaAny.Namespace = dsFrmRegionalLeader.Namespace;
  2045. xmlSchemaSequence.Items.Add(xmlSchemaAny);
  2046. xmlSchemaComplexType.Particle = xmlSchemaSequence;
  2047. XmlSchema schemaSerializable = dsFrmRegionalLeader.GetSchemaSerializable();
  2048. if (xs.Contains(schemaSerializable.TargetNamespace))
  2049. {
  2050. MemoryStream memoryStream = new MemoryStream();
  2051. MemoryStream memoryStream2 = new MemoryStream();
  2052. try
  2053. {
  2054. XmlSchema xmlSchema = null;
  2055. schemaSerializable.Write(memoryStream);
  2056. IEnumerator enumerator = xs.Schemas(schemaSerializable.TargetNamespace).GetEnumerator();
  2057. while (enumerator.MoveNext())
  2058. {
  2059. xmlSchema = (XmlSchema)enumerator.Current;
  2060. memoryStream2.SetLength(0L);
  2061. xmlSchema.Write(memoryStream2);
  2062. if (memoryStream.Length == memoryStream2.Length)
  2063. {
  2064. memoryStream.Position = 0L;
  2065. memoryStream2.Position = 0L;
  2066. while (memoryStream.Position != memoryStream.Length && memoryStream.ReadByte() == memoryStream2.ReadByte())
  2067. {
  2068. }
  2069. if (memoryStream.Position == memoryStream.Length)
  2070. {
  2071. return xmlSchemaComplexType;
  2072. }
  2073. }
  2074. }
  2075. }
  2076. finally
  2077. {
  2078. memoryStream?.Close();
  2079. memoryStream2?.Close();
  2080. }
  2081. }
  2082. xs.Add(schemaSerializable);
  2083. return xmlSchemaComplexType;
  2084. }
  2085. }
  2086. }