dsFrmCostSearch.cs 30 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138
  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. [DesignerCategory("code")]
  19. [XmlSchemaProvider("GetTypedDataSetSchema")]
  20. [XmlRoot("dsFrmCostSearch")]
  21. [ToolboxItem(true)]
  22. public class dsFrmCostSearch : DataSet
  23. {
  24. public delegate void ProductRowChangeEventHandler(object sender, ProductRowChangeEvent e);
  25. public delegate void AppendInfoRowChangeEventHandler(object sender, AppendInfoRowChangeEvent e);
  26. [Serializable]
  27. [GeneratedCode("System.Data.Design.TypedDataSetGenerator", "2.0.0.0")]
  28. [XmlSchemaProvider("GetTypedTableSchema")]
  29. public class ProductDataTable : DataTable, IEnumerable
  30. {
  31. private DataColumn columnNo_Product;
  32. private DataColumn columnName_Product;
  33. private DataColumn columnInvoiceName_Product;
  34. private DataColumn columnUnit_Product;
  35. private DataColumn columnCost_Product;
  36. private DataColumn columnPrice_Product;
  37. private DataColumn columnStockQty_ProductStocks;
  38. private DataColumn columnTotalCost;
  39. [DebuggerNonUserCode]
  40. public DataColumn No_ProductColumn => columnNo_Product;
  41. [DebuggerNonUserCode]
  42. public DataColumn Name_ProductColumn => columnName_Product;
  43. [DebuggerNonUserCode]
  44. public DataColumn InvoiceName_ProductColumn => columnInvoiceName_Product;
  45. [DebuggerNonUserCode]
  46. public DataColumn Unit_ProductColumn => columnUnit_Product;
  47. [DebuggerNonUserCode]
  48. public DataColumn Cost_ProductColumn => columnCost_Product;
  49. [DebuggerNonUserCode]
  50. public DataColumn Price_ProductColumn => columnPrice_Product;
  51. [DebuggerNonUserCode]
  52. public DataColumn StockQty_ProductStocksColumn => columnStockQty_ProductStocks;
  53. [DebuggerNonUserCode]
  54. public DataColumn TotalCostColumn => columnTotalCost;
  55. [Browsable(false)]
  56. [DebuggerNonUserCode]
  57. public int Count => base.Rows.Count;
  58. [DebuggerNonUserCode]
  59. public ProductRow this[int index] => (ProductRow)base.Rows[index];
  60. public event ProductRowChangeEventHandler ProductRowChanging;
  61. public event ProductRowChangeEventHandler ProductRowChanged;
  62. public event ProductRowChangeEventHandler ProductRowDeleting;
  63. public event ProductRowChangeEventHandler ProductRowDeleted;
  64. [DebuggerNonUserCode]
  65. public ProductDataTable()
  66. {
  67. base.TableName = "Product";
  68. BeginInit();
  69. InitClass();
  70. EndInit();
  71. }
  72. [DebuggerNonUserCode]
  73. internal ProductDataTable(DataTable table)
  74. {
  75. base.TableName = table.TableName;
  76. if (table.CaseSensitive != table.DataSet.CaseSensitive)
  77. {
  78. base.CaseSensitive = table.CaseSensitive;
  79. }
  80. if (table.Locale.ToString() != table.DataSet.Locale.ToString())
  81. {
  82. base.Locale = table.Locale;
  83. }
  84. if (table.Namespace != table.DataSet.Namespace)
  85. {
  86. base.Namespace = table.Namespace;
  87. }
  88. base.Prefix = table.Prefix;
  89. base.MinimumCapacity = table.MinimumCapacity;
  90. }
  91. [DebuggerNonUserCode]
  92. protected ProductDataTable(SerializationInfo info, StreamingContext context)
  93. : base(info, context)
  94. {
  95. InitVars();
  96. }
  97. [DebuggerNonUserCode]
  98. public void AddProductRow(ProductRow row)
  99. {
  100. base.Rows.Add(row);
  101. }
  102. [DebuggerNonUserCode]
  103. public ProductRow AddProductRow(string No_Product, string Name_Product, string InvoiceName_Product, string Unit_Product, decimal Cost_Product, decimal Price_Product, decimal StockQty_ProductStocks, decimal TotalCost)
  104. {
  105. ProductRow productRow = (ProductRow)NewRow();
  106. productRow.ItemArray = new object[8]
  107. {
  108. No_Product,
  109. Name_Product,
  110. InvoiceName_Product,
  111. Unit_Product,
  112. Cost_Product,
  113. Price_Product,
  114. StockQty_ProductStocks,
  115. TotalCost
  116. };
  117. base.Rows.Add(productRow);
  118. return productRow;
  119. }
  120. [DebuggerNonUserCode]
  121. public virtual IEnumerator GetEnumerator()
  122. {
  123. return base.Rows.GetEnumerator();
  124. }
  125. [DebuggerNonUserCode]
  126. public override DataTable Clone()
  127. {
  128. ProductDataTable productDataTable = (ProductDataTable)base.Clone();
  129. productDataTable.InitVars();
  130. return productDataTable;
  131. }
  132. [DebuggerNonUserCode]
  133. protected override DataTable CreateInstance()
  134. {
  135. return new ProductDataTable();
  136. }
  137. [DebuggerNonUserCode]
  138. internal void InitVars()
  139. {
  140. columnNo_Product = base.Columns["No_Product"];
  141. columnName_Product = base.Columns["Name_Product"];
  142. columnInvoiceName_Product = base.Columns["InvoiceName_Product"];
  143. columnUnit_Product = base.Columns["Unit_Product"];
  144. columnCost_Product = base.Columns["Cost_Product"];
  145. columnPrice_Product = base.Columns["Price_Product"];
  146. columnStockQty_ProductStocks = base.Columns["StockQty_ProductStocks"];
  147. columnTotalCost = base.Columns["TotalCost"];
  148. }
  149. [DebuggerNonUserCode]
  150. private void InitClass()
  151. {
  152. columnNo_Product = new DataColumn("No_Product", typeof(string), null, MappingType.Element);
  153. base.Columns.Add(columnNo_Product);
  154. columnName_Product = new DataColumn("Name_Product", typeof(string), null, MappingType.Element);
  155. base.Columns.Add(columnName_Product);
  156. columnInvoiceName_Product = new DataColumn("InvoiceName_Product", typeof(string), null, MappingType.Element);
  157. base.Columns.Add(columnInvoiceName_Product);
  158. columnUnit_Product = new DataColumn("Unit_Product", typeof(string), null, MappingType.Element);
  159. base.Columns.Add(columnUnit_Product);
  160. columnCost_Product = new DataColumn("Cost_Product", typeof(decimal), null, MappingType.Element);
  161. base.Columns.Add(columnCost_Product);
  162. columnPrice_Product = new DataColumn("Price_Product", typeof(decimal), null, MappingType.Element);
  163. base.Columns.Add(columnPrice_Product);
  164. columnStockQty_ProductStocks = new DataColumn("StockQty_ProductStocks", typeof(decimal), null, MappingType.Element);
  165. base.Columns.Add(columnStockQty_ProductStocks);
  166. columnTotalCost = new DataColumn("TotalCost", typeof(decimal), null, MappingType.Element);
  167. base.Columns.Add(columnTotalCost);
  168. }
  169. [DebuggerNonUserCode]
  170. public ProductRow NewProductRow()
  171. {
  172. return (ProductRow)NewRow();
  173. }
  174. [DebuggerNonUserCode]
  175. protected override DataRow NewRowFromBuilder(DataRowBuilder builder)
  176. {
  177. return new ProductRow(builder);
  178. }
  179. [DebuggerNonUserCode]
  180. protected override Type GetRowType()
  181. {
  182. return typeof(ProductRow);
  183. }
  184. [DebuggerNonUserCode]
  185. protected override void OnRowChanged(DataRowChangeEventArgs e)
  186. {
  187. base.OnRowChanged(e);
  188. if (this.ProductRowChanged != null)
  189. {
  190. this.ProductRowChanged(this, new ProductRowChangeEvent((ProductRow)e.Row, e.Action));
  191. }
  192. }
  193. [DebuggerNonUserCode]
  194. protected override void OnRowChanging(DataRowChangeEventArgs e)
  195. {
  196. base.OnRowChanging(e);
  197. if (this.ProductRowChanging != null)
  198. {
  199. this.ProductRowChanging(this, new ProductRowChangeEvent((ProductRow)e.Row, e.Action));
  200. }
  201. }
  202. [DebuggerNonUserCode]
  203. protected override void OnRowDeleted(DataRowChangeEventArgs e)
  204. {
  205. base.OnRowDeleted(e);
  206. if (this.ProductRowDeleted != null)
  207. {
  208. this.ProductRowDeleted(this, new ProductRowChangeEvent((ProductRow)e.Row, e.Action));
  209. }
  210. }
  211. [DebuggerNonUserCode]
  212. protected override void OnRowDeleting(DataRowChangeEventArgs e)
  213. {
  214. base.OnRowDeleting(e);
  215. if (this.ProductRowDeleting != null)
  216. {
  217. this.ProductRowDeleting(this, new ProductRowChangeEvent((ProductRow)e.Row, e.Action));
  218. }
  219. }
  220. [DebuggerNonUserCode]
  221. public void RemoveProductRow(ProductRow row)
  222. {
  223. base.Rows.Remove(row);
  224. }
  225. [DebuggerNonUserCode]
  226. public static XmlSchemaComplexType GetTypedTableSchema(XmlSchemaSet xs)
  227. {
  228. XmlSchemaComplexType xmlSchemaComplexType = new XmlSchemaComplexType();
  229. XmlSchemaSequence xmlSchemaSequence = new XmlSchemaSequence();
  230. dsFrmCostSearch dsFrmCostSearch = new dsFrmCostSearch();
  231. xs.Add(dsFrmCostSearch.GetSchemaSerializable());
  232. XmlSchemaAny xmlSchemaAny = new XmlSchemaAny();
  233. xmlSchemaAny.Namespace = "http://www.w3.org/2001/XMLSchema";
  234. xmlSchemaAny.MinOccurs = 0m;
  235. xmlSchemaAny.MaxOccurs = decimal.MaxValue;
  236. xmlSchemaAny.ProcessContents = XmlSchemaContentProcessing.Lax;
  237. xmlSchemaSequence.Items.Add(xmlSchemaAny);
  238. XmlSchemaAny xmlSchemaAny2 = new XmlSchemaAny();
  239. xmlSchemaAny2.Namespace = "urn:schemas-microsoft-com:xml-diffgram-v1";
  240. xmlSchemaAny2.MinOccurs = 1m;
  241. xmlSchemaAny2.ProcessContents = XmlSchemaContentProcessing.Lax;
  242. xmlSchemaSequence.Items.Add(xmlSchemaAny2);
  243. XmlSchemaAttribute xmlSchemaAttribute = new XmlSchemaAttribute();
  244. xmlSchemaAttribute.Name = "namespace";
  245. xmlSchemaAttribute.FixedValue = dsFrmCostSearch.Namespace;
  246. xmlSchemaComplexType.Attributes.Add(xmlSchemaAttribute);
  247. XmlSchemaAttribute xmlSchemaAttribute2 = new XmlSchemaAttribute();
  248. xmlSchemaAttribute2.Name = "tableTypeName";
  249. xmlSchemaAttribute2.FixedValue = "ProductDataTable";
  250. xmlSchemaComplexType.Attributes.Add(xmlSchemaAttribute2);
  251. xmlSchemaComplexType.Particle = xmlSchemaSequence;
  252. return xmlSchemaComplexType;
  253. }
  254. }
  255. [Serializable]
  256. [GeneratedCode("System.Data.Design.TypedDataSetGenerator", "2.0.0.0")]
  257. [XmlSchemaProvider("GetTypedTableSchema")]
  258. public class AppendInfoDataTable : DataTable, IEnumerable
  259. {
  260. private DataColumn columnCurrentCompany;
  261. private DataColumn columnCurrentUser;
  262. [DebuggerNonUserCode]
  263. public DataColumn CurrentCompanyColumn => columnCurrentCompany;
  264. [DebuggerNonUserCode]
  265. public DataColumn CurrentUserColumn => columnCurrentUser;
  266. [Browsable(false)]
  267. [DebuggerNonUserCode]
  268. public int Count => base.Rows.Count;
  269. [DebuggerNonUserCode]
  270. public AppendInfoRow this[int index] => (AppendInfoRow)base.Rows[index];
  271. public event AppendInfoRowChangeEventHandler AppendInfoRowChanging;
  272. public event AppendInfoRowChangeEventHandler AppendInfoRowChanged;
  273. public event AppendInfoRowChangeEventHandler AppendInfoRowDeleting;
  274. public event AppendInfoRowChangeEventHandler AppendInfoRowDeleted;
  275. [DebuggerNonUserCode]
  276. public AppendInfoDataTable()
  277. {
  278. base.TableName = "AppendInfo";
  279. BeginInit();
  280. InitClass();
  281. EndInit();
  282. }
  283. [DebuggerNonUserCode]
  284. internal AppendInfoDataTable(DataTable table)
  285. {
  286. base.TableName = table.TableName;
  287. if (table.CaseSensitive != table.DataSet.CaseSensitive)
  288. {
  289. base.CaseSensitive = table.CaseSensitive;
  290. }
  291. if (table.Locale.ToString() != table.DataSet.Locale.ToString())
  292. {
  293. base.Locale = table.Locale;
  294. }
  295. if (table.Namespace != table.DataSet.Namespace)
  296. {
  297. base.Namespace = table.Namespace;
  298. }
  299. base.Prefix = table.Prefix;
  300. base.MinimumCapacity = table.MinimumCapacity;
  301. }
  302. [DebuggerNonUserCode]
  303. protected AppendInfoDataTable(SerializationInfo info, StreamingContext context)
  304. : base(info, context)
  305. {
  306. InitVars();
  307. }
  308. [DebuggerNonUserCode]
  309. public void AddAppendInfoRow(AppendInfoRow row)
  310. {
  311. base.Rows.Add(row);
  312. }
  313. [DebuggerNonUserCode]
  314. public AppendInfoRow AddAppendInfoRow(string CurrentCompany, string CurrentUser)
  315. {
  316. AppendInfoRow appendInfoRow = (AppendInfoRow)NewRow();
  317. appendInfoRow.ItemArray = new object[2]
  318. {
  319. CurrentCompany,
  320. CurrentUser
  321. };
  322. base.Rows.Add(appendInfoRow);
  323. return appendInfoRow;
  324. }
  325. [DebuggerNonUserCode]
  326. public virtual IEnumerator GetEnumerator()
  327. {
  328. return base.Rows.GetEnumerator();
  329. }
  330. [DebuggerNonUserCode]
  331. public override DataTable Clone()
  332. {
  333. AppendInfoDataTable appendInfoDataTable = (AppendInfoDataTable)base.Clone();
  334. appendInfoDataTable.InitVars();
  335. return appendInfoDataTable;
  336. }
  337. [DebuggerNonUserCode]
  338. protected override DataTable CreateInstance()
  339. {
  340. return new AppendInfoDataTable();
  341. }
  342. [DebuggerNonUserCode]
  343. internal void InitVars()
  344. {
  345. columnCurrentCompany = base.Columns["CurrentCompany"];
  346. columnCurrentUser = base.Columns["CurrentUser"];
  347. }
  348. [DebuggerNonUserCode]
  349. private void InitClass()
  350. {
  351. columnCurrentCompany = new DataColumn("CurrentCompany", typeof(string), null, MappingType.Element);
  352. base.Columns.Add(columnCurrentCompany);
  353. columnCurrentUser = new DataColumn("CurrentUser", typeof(string), null, MappingType.Element);
  354. base.Columns.Add(columnCurrentUser);
  355. }
  356. [DebuggerNonUserCode]
  357. public AppendInfoRow NewAppendInfoRow()
  358. {
  359. return (AppendInfoRow)NewRow();
  360. }
  361. [DebuggerNonUserCode]
  362. protected override DataRow NewRowFromBuilder(DataRowBuilder builder)
  363. {
  364. return new AppendInfoRow(builder);
  365. }
  366. [DebuggerNonUserCode]
  367. protected override Type GetRowType()
  368. {
  369. return typeof(AppendInfoRow);
  370. }
  371. [DebuggerNonUserCode]
  372. protected override void OnRowChanged(DataRowChangeEventArgs e)
  373. {
  374. base.OnRowChanged(e);
  375. if (this.AppendInfoRowChanged != null)
  376. {
  377. this.AppendInfoRowChanged(this, new AppendInfoRowChangeEvent((AppendInfoRow)e.Row, e.Action));
  378. }
  379. }
  380. [DebuggerNonUserCode]
  381. protected override void OnRowChanging(DataRowChangeEventArgs e)
  382. {
  383. base.OnRowChanging(e);
  384. if (this.AppendInfoRowChanging != null)
  385. {
  386. this.AppendInfoRowChanging(this, new AppendInfoRowChangeEvent((AppendInfoRow)e.Row, e.Action));
  387. }
  388. }
  389. [DebuggerNonUserCode]
  390. protected override void OnRowDeleted(DataRowChangeEventArgs e)
  391. {
  392. base.OnRowDeleted(e);
  393. if (this.AppendInfoRowDeleted != null)
  394. {
  395. this.AppendInfoRowDeleted(this, new AppendInfoRowChangeEvent((AppendInfoRow)e.Row, e.Action));
  396. }
  397. }
  398. [DebuggerNonUserCode]
  399. protected override void OnRowDeleting(DataRowChangeEventArgs e)
  400. {
  401. base.OnRowDeleting(e);
  402. if (this.AppendInfoRowDeleting != null)
  403. {
  404. this.AppendInfoRowDeleting(this, new AppendInfoRowChangeEvent((AppendInfoRow)e.Row, e.Action));
  405. }
  406. }
  407. [DebuggerNonUserCode]
  408. public void RemoveAppendInfoRow(AppendInfoRow row)
  409. {
  410. base.Rows.Remove(row);
  411. }
  412. [DebuggerNonUserCode]
  413. public static XmlSchemaComplexType GetTypedTableSchema(XmlSchemaSet xs)
  414. {
  415. XmlSchemaComplexType xmlSchemaComplexType = new XmlSchemaComplexType();
  416. XmlSchemaSequence xmlSchemaSequence = new XmlSchemaSequence();
  417. dsFrmCostSearch dsFrmCostSearch = new dsFrmCostSearch();
  418. xs.Add(dsFrmCostSearch.GetSchemaSerializable());
  419. XmlSchemaAny xmlSchemaAny = new XmlSchemaAny();
  420. xmlSchemaAny.Namespace = "http://www.w3.org/2001/XMLSchema";
  421. xmlSchemaAny.MinOccurs = 0m;
  422. xmlSchemaAny.MaxOccurs = decimal.MaxValue;
  423. xmlSchemaAny.ProcessContents = XmlSchemaContentProcessing.Lax;
  424. xmlSchemaSequence.Items.Add(xmlSchemaAny);
  425. XmlSchemaAny xmlSchemaAny2 = new XmlSchemaAny();
  426. xmlSchemaAny2.Namespace = "urn:schemas-microsoft-com:xml-diffgram-v1";
  427. xmlSchemaAny2.MinOccurs = 1m;
  428. xmlSchemaAny2.ProcessContents = XmlSchemaContentProcessing.Lax;
  429. xmlSchemaSequence.Items.Add(xmlSchemaAny2);
  430. XmlSchemaAttribute xmlSchemaAttribute = new XmlSchemaAttribute();
  431. xmlSchemaAttribute.Name = "namespace";
  432. xmlSchemaAttribute.FixedValue = dsFrmCostSearch.Namespace;
  433. xmlSchemaComplexType.Attributes.Add(xmlSchemaAttribute);
  434. XmlSchemaAttribute xmlSchemaAttribute2 = new XmlSchemaAttribute();
  435. xmlSchemaAttribute2.Name = "tableTypeName";
  436. xmlSchemaAttribute2.FixedValue = "AppendInfoDataTable";
  437. xmlSchemaComplexType.Attributes.Add(xmlSchemaAttribute2);
  438. xmlSchemaComplexType.Particle = xmlSchemaSequence;
  439. return xmlSchemaComplexType;
  440. }
  441. }
  442. [GeneratedCode("System.Data.Design.TypedDataSetGenerator", "2.0.0.0")]
  443. public class ProductRow : DataRow
  444. {
  445. private ProductDataTable tableProduct;
  446. [DebuggerNonUserCode]
  447. public string No_Product
  448. {
  449. get
  450. {
  451. try
  452. {
  453. return (string)base[tableProduct.No_ProductColumn];
  454. }
  455. catch (InvalidCastException innerException)
  456. {
  457. throw new StrongTypingException("The value for column 'No_Product' in table 'Product' is DBNull.", innerException);
  458. }
  459. }
  460. set
  461. {
  462. base[tableProduct.No_ProductColumn] = value;
  463. }
  464. }
  465. [DebuggerNonUserCode]
  466. public string Name_Product
  467. {
  468. get
  469. {
  470. try
  471. {
  472. return (string)base[tableProduct.Name_ProductColumn];
  473. }
  474. catch (InvalidCastException innerException)
  475. {
  476. throw new StrongTypingException("The value for column 'Name_Product' in table 'Product' is DBNull.", innerException);
  477. }
  478. }
  479. set
  480. {
  481. base[tableProduct.Name_ProductColumn] = value;
  482. }
  483. }
  484. [DebuggerNonUserCode]
  485. public string InvoiceName_Product
  486. {
  487. get
  488. {
  489. try
  490. {
  491. return (string)base[tableProduct.InvoiceName_ProductColumn];
  492. }
  493. catch (InvalidCastException innerException)
  494. {
  495. throw new StrongTypingException("The value for column 'InvoiceName_Product' in table 'Product' is DBNull.", innerException);
  496. }
  497. }
  498. set
  499. {
  500. base[tableProduct.InvoiceName_ProductColumn] = value;
  501. }
  502. }
  503. [DebuggerNonUserCode]
  504. public string Unit_Product
  505. {
  506. get
  507. {
  508. try
  509. {
  510. return (string)base[tableProduct.Unit_ProductColumn];
  511. }
  512. catch (InvalidCastException innerException)
  513. {
  514. throw new StrongTypingException("The value for column 'Unit_Product' in table 'Product' is DBNull.", innerException);
  515. }
  516. }
  517. set
  518. {
  519. base[tableProduct.Unit_ProductColumn] = value;
  520. }
  521. }
  522. [DebuggerNonUserCode]
  523. public decimal Cost_Product
  524. {
  525. get
  526. {
  527. try
  528. {
  529. return (decimal)base[tableProduct.Cost_ProductColumn];
  530. }
  531. catch (InvalidCastException innerException)
  532. {
  533. throw new StrongTypingException("The value for column 'Cost_Product' in table 'Product' is DBNull.", innerException);
  534. }
  535. }
  536. set
  537. {
  538. base[tableProduct.Cost_ProductColumn] = value;
  539. }
  540. }
  541. [DebuggerNonUserCode]
  542. public decimal Price_Product
  543. {
  544. get
  545. {
  546. try
  547. {
  548. return (decimal)base[tableProduct.Price_ProductColumn];
  549. }
  550. catch (InvalidCastException innerException)
  551. {
  552. throw new StrongTypingException("The value for column 'Price_Product' in table 'Product' is DBNull.", innerException);
  553. }
  554. }
  555. set
  556. {
  557. base[tableProduct.Price_ProductColumn] = value;
  558. }
  559. }
  560. [DebuggerNonUserCode]
  561. public decimal StockQty_ProductStocks
  562. {
  563. get
  564. {
  565. try
  566. {
  567. return (decimal)base[tableProduct.StockQty_ProductStocksColumn];
  568. }
  569. catch (InvalidCastException innerException)
  570. {
  571. throw new StrongTypingException("The value for column 'StockQty_ProductStocks' in table 'Product' is DBNull.", innerException);
  572. }
  573. }
  574. set
  575. {
  576. base[tableProduct.StockQty_ProductStocksColumn] = value;
  577. }
  578. }
  579. [DebuggerNonUserCode]
  580. public decimal TotalCost
  581. {
  582. get
  583. {
  584. try
  585. {
  586. return (decimal)base[tableProduct.TotalCostColumn];
  587. }
  588. catch (InvalidCastException innerException)
  589. {
  590. throw new StrongTypingException("The value for column 'TotalCost' in table 'Product' is DBNull.", innerException);
  591. }
  592. }
  593. set
  594. {
  595. base[tableProduct.TotalCostColumn] = value;
  596. }
  597. }
  598. [DebuggerNonUserCode]
  599. internal ProductRow(DataRowBuilder rb)
  600. : base(rb)
  601. {
  602. tableProduct = (ProductDataTable)base.Table;
  603. }
  604. [DebuggerNonUserCode]
  605. public bool IsNo_ProductNull()
  606. {
  607. return IsNull(tableProduct.No_ProductColumn);
  608. }
  609. [DebuggerNonUserCode]
  610. public void SetNo_ProductNull()
  611. {
  612. base[tableProduct.No_ProductColumn] = Convert.DBNull;
  613. }
  614. [DebuggerNonUserCode]
  615. public bool IsName_ProductNull()
  616. {
  617. return IsNull(tableProduct.Name_ProductColumn);
  618. }
  619. [DebuggerNonUserCode]
  620. public void SetName_ProductNull()
  621. {
  622. base[tableProduct.Name_ProductColumn] = Convert.DBNull;
  623. }
  624. [DebuggerNonUserCode]
  625. public bool IsInvoiceName_ProductNull()
  626. {
  627. return IsNull(tableProduct.InvoiceName_ProductColumn);
  628. }
  629. [DebuggerNonUserCode]
  630. public void SetInvoiceName_ProductNull()
  631. {
  632. base[tableProduct.InvoiceName_ProductColumn] = Convert.DBNull;
  633. }
  634. [DebuggerNonUserCode]
  635. public bool IsUnit_ProductNull()
  636. {
  637. return IsNull(tableProduct.Unit_ProductColumn);
  638. }
  639. [DebuggerNonUserCode]
  640. public void SetUnit_ProductNull()
  641. {
  642. base[tableProduct.Unit_ProductColumn] = Convert.DBNull;
  643. }
  644. [DebuggerNonUserCode]
  645. public bool IsCost_ProductNull()
  646. {
  647. return IsNull(tableProduct.Cost_ProductColumn);
  648. }
  649. [DebuggerNonUserCode]
  650. public void SetCost_ProductNull()
  651. {
  652. base[tableProduct.Cost_ProductColumn] = Convert.DBNull;
  653. }
  654. [DebuggerNonUserCode]
  655. public bool IsPrice_ProductNull()
  656. {
  657. return IsNull(tableProduct.Price_ProductColumn);
  658. }
  659. [DebuggerNonUserCode]
  660. public void SetPrice_ProductNull()
  661. {
  662. base[tableProduct.Price_ProductColumn] = Convert.DBNull;
  663. }
  664. [DebuggerNonUserCode]
  665. public bool IsStockQty_ProductStocksNull()
  666. {
  667. return IsNull(tableProduct.StockQty_ProductStocksColumn);
  668. }
  669. [DebuggerNonUserCode]
  670. public void SetStockQty_ProductStocksNull()
  671. {
  672. base[tableProduct.StockQty_ProductStocksColumn] = Convert.DBNull;
  673. }
  674. [DebuggerNonUserCode]
  675. public bool IsTotalCostNull()
  676. {
  677. return IsNull(tableProduct.TotalCostColumn);
  678. }
  679. [DebuggerNonUserCode]
  680. public void SetTotalCostNull()
  681. {
  682. base[tableProduct.TotalCostColumn] = Convert.DBNull;
  683. }
  684. }
  685. [GeneratedCode("System.Data.Design.TypedDataSetGenerator", "2.0.0.0")]
  686. public class AppendInfoRow : DataRow
  687. {
  688. private AppendInfoDataTable tableAppendInfo;
  689. [DebuggerNonUserCode]
  690. public string CurrentCompany
  691. {
  692. get
  693. {
  694. try
  695. {
  696. return (string)base[tableAppendInfo.CurrentCompanyColumn];
  697. }
  698. catch (InvalidCastException innerException)
  699. {
  700. throw new StrongTypingException("The value for column 'CurrentCompany' in table 'AppendInfo' is DBNull.", innerException);
  701. }
  702. }
  703. set
  704. {
  705. base[tableAppendInfo.CurrentCompanyColumn] = value;
  706. }
  707. }
  708. [DebuggerNonUserCode]
  709. public string CurrentUser
  710. {
  711. get
  712. {
  713. try
  714. {
  715. return (string)base[tableAppendInfo.CurrentUserColumn];
  716. }
  717. catch (InvalidCastException innerException)
  718. {
  719. throw new StrongTypingException("The value for column 'CurrentUser' in table 'AppendInfo' is DBNull.", innerException);
  720. }
  721. }
  722. set
  723. {
  724. base[tableAppendInfo.CurrentUserColumn] = value;
  725. }
  726. }
  727. [DebuggerNonUserCode]
  728. internal AppendInfoRow(DataRowBuilder rb)
  729. : base(rb)
  730. {
  731. tableAppendInfo = (AppendInfoDataTable)base.Table;
  732. }
  733. [DebuggerNonUserCode]
  734. public bool IsCurrentCompanyNull()
  735. {
  736. return IsNull(tableAppendInfo.CurrentCompanyColumn);
  737. }
  738. [DebuggerNonUserCode]
  739. public void SetCurrentCompanyNull()
  740. {
  741. base[tableAppendInfo.CurrentCompanyColumn] = Convert.DBNull;
  742. }
  743. [DebuggerNonUserCode]
  744. public bool IsCurrentUserNull()
  745. {
  746. return IsNull(tableAppendInfo.CurrentUserColumn);
  747. }
  748. [DebuggerNonUserCode]
  749. public void SetCurrentUserNull()
  750. {
  751. base[tableAppendInfo.CurrentUserColumn] = Convert.DBNull;
  752. }
  753. }
  754. [GeneratedCode("System.Data.Design.TypedDataSetGenerator", "2.0.0.0")]
  755. public class ProductRowChangeEvent : EventArgs
  756. {
  757. private ProductRow eventRow;
  758. private DataRowAction eventAction;
  759. [DebuggerNonUserCode]
  760. public ProductRow Row => eventRow;
  761. [DebuggerNonUserCode]
  762. public DataRowAction Action => eventAction;
  763. [DebuggerNonUserCode]
  764. public ProductRowChangeEvent(ProductRow row, DataRowAction action)
  765. {
  766. eventRow = row;
  767. eventAction = action;
  768. }
  769. }
  770. [GeneratedCode("System.Data.Design.TypedDataSetGenerator", "2.0.0.0")]
  771. public class AppendInfoRowChangeEvent : EventArgs
  772. {
  773. private AppendInfoRow eventRow;
  774. private DataRowAction eventAction;
  775. [DebuggerNonUserCode]
  776. public AppendInfoRow Row => eventRow;
  777. [DebuggerNonUserCode]
  778. public DataRowAction Action => eventAction;
  779. [DebuggerNonUserCode]
  780. public AppendInfoRowChangeEvent(AppendInfoRow row, DataRowAction action)
  781. {
  782. eventRow = row;
  783. eventAction = action;
  784. }
  785. }
  786. private ProductDataTable tableProduct;
  787. private AppendInfoDataTable tableAppendInfo;
  788. private SchemaSerializationMode _schemaSerializationMode = SchemaSerializationMode.IncludeSchema;
  789. [Browsable(false)]
  790. [DesignerSerializationVisibility(DesignerSerializationVisibility.Content)]
  791. [DebuggerNonUserCode]
  792. public ProductDataTable Product => tableProduct;
  793. [DebuggerNonUserCode]
  794. [Browsable(false)]
  795. [DesignerSerializationVisibility(DesignerSerializationVisibility.Content)]
  796. public AppendInfoDataTable AppendInfo => tableAppendInfo;
  797. [Browsable(true)]
  798. [DesignerSerializationVisibility(DesignerSerializationVisibility.Visible)]
  799. [DebuggerNonUserCode]
  800. public override SchemaSerializationMode SchemaSerializationMode
  801. {
  802. get
  803. {
  804. return _schemaSerializationMode;
  805. }
  806. set
  807. {
  808. _schemaSerializationMode = value;
  809. }
  810. }
  811. [DesignerSerializationVisibility(DesignerSerializationVisibility.Hidden)]
  812. [DebuggerNonUserCode]
  813. public new DataTableCollection Tables => base.Tables;
  814. [DesignerSerializationVisibility(DesignerSerializationVisibility.Hidden)]
  815. [DebuggerNonUserCode]
  816. public new DataRelationCollection Relations => base.Relations;
  817. [DebuggerNonUserCode]
  818. public dsFrmCostSearch()
  819. {
  820. BeginInit();
  821. InitClass();
  822. CollectionChangeEventHandler value = SchemaChanged;
  823. base.Tables.CollectionChanged += value;
  824. base.Relations.CollectionChanged += value;
  825. EndInit();
  826. }
  827. [DebuggerNonUserCode]
  828. protected dsFrmCostSearch(SerializationInfo info, StreamingContext context)
  829. : base(info, context, ConstructSchema: false)
  830. {
  831. if (IsBinarySerialized(info, context))
  832. {
  833. InitVars(initTable: false);
  834. CollectionChangeEventHandler value = SchemaChanged;
  835. Tables.CollectionChanged += value;
  836. Relations.CollectionChanged += value;
  837. return;
  838. }
  839. string s = (string)info.GetValue("XmlSchema", typeof(string));
  840. if (DetermineSchemaSerializationMode(info, context) == SchemaSerializationMode.IncludeSchema)
  841. {
  842. DataSet dataSet = new DataSet();
  843. dataSet.ReadXmlSchema(new XmlTextReader(new StringReader(s)));
  844. if (dataSet.Tables["Product"] != null)
  845. {
  846. base.Tables.Add(new ProductDataTable(dataSet.Tables["Product"]));
  847. }
  848. if (dataSet.Tables["AppendInfo"] != null)
  849. {
  850. base.Tables.Add(new AppendInfoDataTable(dataSet.Tables["AppendInfo"]));
  851. }
  852. base.DataSetName = dataSet.DataSetName;
  853. base.Prefix = dataSet.Prefix;
  854. base.Namespace = dataSet.Namespace;
  855. base.Locale = dataSet.Locale;
  856. base.CaseSensitive = dataSet.CaseSensitive;
  857. base.EnforceConstraints = dataSet.EnforceConstraints;
  858. Merge(dataSet, preserveChanges: false, MissingSchemaAction.Add);
  859. InitVars();
  860. }
  861. else
  862. {
  863. ReadXmlSchema(new XmlTextReader(new StringReader(s)));
  864. }
  865. GetSerializationData(info, context);
  866. CollectionChangeEventHandler value2 = SchemaChanged;
  867. base.Tables.CollectionChanged += value2;
  868. Relations.CollectionChanged += value2;
  869. }
  870. [DebuggerNonUserCode]
  871. protected override void InitializeDerivedDataSet()
  872. {
  873. BeginInit();
  874. InitClass();
  875. EndInit();
  876. }
  877. [DebuggerNonUserCode]
  878. public override DataSet Clone()
  879. {
  880. dsFrmCostSearch dsFrmCostSearch = (dsFrmCostSearch)base.Clone();
  881. dsFrmCostSearch.InitVars();
  882. dsFrmCostSearch.SchemaSerializationMode = SchemaSerializationMode;
  883. return dsFrmCostSearch;
  884. }
  885. [DebuggerNonUserCode]
  886. protected override bool ShouldSerializeTables()
  887. {
  888. return false;
  889. }
  890. [DebuggerNonUserCode]
  891. protected override bool ShouldSerializeRelations()
  892. {
  893. return false;
  894. }
  895. [DebuggerNonUserCode]
  896. protected override void ReadXmlSerializable(XmlReader reader)
  897. {
  898. if (DetermineSchemaSerializationMode(reader) == SchemaSerializationMode.IncludeSchema)
  899. {
  900. Reset();
  901. DataSet dataSet = new DataSet();
  902. dataSet.ReadXml(reader);
  903. if (dataSet.Tables["Product"] != null)
  904. {
  905. base.Tables.Add(new ProductDataTable(dataSet.Tables["Product"]));
  906. }
  907. if (dataSet.Tables["AppendInfo"] != null)
  908. {
  909. base.Tables.Add(new AppendInfoDataTable(dataSet.Tables["AppendInfo"]));
  910. }
  911. base.DataSetName = dataSet.DataSetName;
  912. base.Prefix = dataSet.Prefix;
  913. base.Namespace = dataSet.Namespace;
  914. base.Locale = dataSet.Locale;
  915. base.CaseSensitive = dataSet.CaseSensitive;
  916. base.EnforceConstraints = dataSet.EnforceConstraints;
  917. Merge(dataSet, preserveChanges: false, MissingSchemaAction.Add);
  918. InitVars();
  919. }
  920. else
  921. {
  922. ReadXml(reader);
  923. InitVars();
  924. }
  925. }
  926. [DebuggerNonUserCode]
  927. protected override XmlSchema GetSchemaSerializable()
  928. {
  929. MemoryStream memoryStream = new MemoryStream();
  930. WriteXmlSchema(new XmlTextWriter(memoryStream, null));
  931. memoryStream.Position = 0L;
  932. return XmlSchema.Read(new XmlTextReader(memoryStream), null);
  933. }
  934. [DebuggerNonUserCode]
  935. internal void InitVars()
  936. {
  937. InitVars(initTable: true);
  938. }
  939. [DebuggerNonUserCode]
  940. internal void InitVars(bool initTable)
  941. {
  942. tableProduct = (ProductDataTable)base.Tables["Product"];
  943. if (initTable && tableProduct != null)
  944. {
  945. tableProduct.InitVars();
  946. }
  947. tableAppendInfo = (AppendInfoDataTable)base.Tables["AppendInfo"];
  948. if (initTable && tableAppendInfo != null)
  949. {
  950. tableAppendInfo.InitVars();
  951. }
  952. }
  953. [DebuggerNonUserCode]
  954. private void InitClass()
  955. {
  956. base.DataSetName = "dsFrmCostSearch";
  957. base.Prefix = "";
  958. base.Namespace = "http://tempuri.org/dsFrmCostSearch.xsd";
  959. base.EnforceConstraints = true;
  960. SchemaSerializationMode = SchemaSerializationMode.IncludeSchema;
  961. tableProduct = new ProductDataTable();
  962. base.Tables.Add(tableProduct);
  963. tableAppendInfo = new AppendInfoDataTable();
  964. base.Tables.Add(tableAppendInfo);
  965. }
  966. [DebuggerNonUserCode]
  967. private bool ShouldSerializeProduct()
  968. {
  969. return false;
  970. }
  971. [DebuggerNonUserCode]
  972. private bool ShouldSerializeAppendInfo()
  973. {
  974. return false;
  975. }
  976. [DebuggerNonUserCode]
  977. private void SchemaChanged(object sender, CollectionChangeEventArgs e)
  978. {
  979. if (e.Action == CollectionChangeAction.Remove)
  980. {
  981. InitVars();
  982. }
  983. }
  984. [DebuggerNonUserCode]
  985. public static XmlSchemaComplexType GetTypedDataSetSchema(XmlSchemaSet xs)
  986. {
  987. dsFrmCostSearch dsFrmCostSearch = new dsFrmCostSearch();
  988. XmlSchemaComplexType xmlSchemaComplexType = new XmlSchemaComplexType();
  989. XmlSchemaSequence xmlSchemaSequence = new XmlSchemaSequence();
  990. xs.Add(dsFrmCostSearch.GetSchemaSerializable());
  991. XmlSchemaAny xmlSchemaAny = new XmlSchemaAny();
  992. xmlSchemaAny.Namespace = dsFrmCostSearch.Namespace;
  993. xmlSchemaSequence.Items.Add(xmlSchemaAny);
  994. xmlSchemaComplexType.Particle = xmlSchemaSequence;
  995. return xmlSchemaComplexType;
  996. }
  997. }
  998. }