dsFrmOverallSearchTable.cs 46 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259126012611262126312641265126612671268126912701271127212731274127512761277127812791280128112821283128412851286128712881289129012911292129312941295129612971298129913001301130213031304130513061307130813091310131113121313131413151316131713181319132013211322132313241325132613271328132913301331133213331334133513361337133813391340134113421343134413451346134713481349135013511352135313541355135613571358135913601361136213631364136513661367136813691370137113721373137413751376137713781379138013811382138313841385138613871388138913901391139213931394139513961397139813991400140114021403140414051406140714081409141014111412141314141415141614171418141914201421142214231424142514261427142814291430143114321433143414351436143714381439144014411442144314441445144614471448144914501451145214531454145514561457145814591460146114621463146414651466146714681469147014711472147314741475147614771478147914801481148214831484148514861487148814891490149114921493149414951496149714981499150015011502150315041505150615071508150915101511151215131514151515161517151815191520152115221523152415251526152715281529153015311532153315341535153615371538153915401541154215431544154515461547154815491550155115521553155415551556155715581559156015611562156315641565156615671568156915701571157215731574157515761577157815791580158115821583158415851586158715881589
  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. [GeneratedCode("System.Data.Design.TypedDataSetGenerator", "2.0.0.0")]
  17. [XmlRoot("dsFrmOverallSearchTable")]
  18. [XmlSchemaProvider("GetTypedDataSetSchema")]
  19. [HelpKeyword("vs.data.DataSet")]
  20. [DesignerCategory("code")]
  21. [ToolboxItem(true)]
  22. public class dsFrmOverallSearchTable : DataSet
  23. {
  24. public delegate void TotalRowChangeEventHandler(object sender, TotalRowChangeEvent 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 TotalDataTable : DataTable, IEnumerable
  30. {
  31. private DataColumn columnNo_Product;
  32. private DataColumn columnName_Product;
  33. private DataColumn columnCost_Product;
  34. private DataColumn columnOpeningAvailableQty_ProductStocks;
  35. private DataColumn columnAvailableQty_ProductStocks;
  36. private DataColumn columnQuantity_SaleBillProduct;
  37. private DataColumn columnQuantity_SaleOutDepotBillProduct;
  38. private DataColumn columnOutQuantity_ModifyDepotBillProduct;
  39. private DataColumn columnInQuantity_ModifyDepotBillProduct;
  40. private DataColumn columnQuantity_PurchaseOrderBillProduct;
  41. private DataColumn columnQuantity_PurchaseInDepotBillProduct;
  42. private DataColumn columnOutQuantity_StocktakingBillProduct;
  43. private DataColumn columnInQuantity_StocktakingBillProduct;
  44. private DataColumn columnTotalPrice;
  45. private DataColumn columnQuantity_SaleRtnBillProduct;
  46. private DataColumn columnType_Product;
  47. private DataColumn columnQuantity_RealSale;
  48. private DataColumn columnOpeningStockQty_ProductStocks;
  49. private DataColumn columnStockQty_ProductStocks;
  50. [DebuggerNonUserCode]
  51. public DataColumn No_ProductColumn => columnNo_Product;
  52. [DebuggerNonUserCode]
  53. public DataColumn Name_ProductColumn => columnName_Product;
  54. [DebuggerNonUserCode]
  55. public DataColumn Cost_ProductColumn => columnCost_Product;
  56. [DebuggerNonUserCode]
  57. public DataColumn OpeningAvailableQty_ProductStocksColumn => columnOpeningAvailableQty_ProductStocks;
  58. [DebuggerNonUserCode]
  59. public DataColumn AvailableQty_ProductStocksColumn => columnAvailableQty_ProductStocks;
  60. [DebuggerNonUserCode]
  61. public DataColumn Quantity_SaleBillProductColumn => columnQuantity_SaleBillProduct;
  62. [DebuggerNonUserCode]
  63. public DataColumn Quantity_SaleOutDepotBillProductColumn => columnQuantity_SaleOutDepotBillProduct;
  64. [DebuggerNonUserCode]
  65. public DataColumn OutQuantity_ModifyDepotBillProductColumn => columnOutQuantity_ModifyDepotBillProduct;
  66. [DebuggerNonUserCode]
  67. public DataColumn InQuantity_ModifyDepotBillProductColumn => columnInQuantity_ModifyDepotBillProduct;
  68. [DebuggerNonUserCode]
  69. public DataColumn Quantity_PurchaseOrderBillProductColumn => columnQuantity_PurchaseOrderBillProduct;
  70. [DebuggerNonUserCode]
  71. public DataColumn Quantity_PurchaseInDepotBillProductColumn => columnQuantity_PurchaseInDepotBillProduct;
  72. [DebuggerNonUserCode]
  73. public DataColumn OutQuantity_StocktakingBillProductColumn => columnOutQuantity_StocktakingBillProduct;
  74. [DebuggerNonUserCode]
  75. public DataColumn InQuantity_StocktakingBillProductColumn => columnInQuantity_StocktakingBillProduct;
  76. [DebuggerNonUserCode]
  77. public DataColumn TotalPriceColumn => columnTotalPrice;
  78. [DebuggerNonUserCode]
  79. public DataColumn Quantity_SaleRtnBillProductColumn => columnQuantity_SaleRtnBillProduct;
  80. [DebuggerNonUserCode]
  81. public DataColumn Type_ProductColumn => columnType_Product;
  82. [DebuggerNonUserCode]
  83. public DataColumn Quantity_RealSaleColumn => columnQuantity_RealSale;
  84. [DebuggerNonUserCode]
  85. public DataColumn OpeningStockQty_ProductStocksColumn => columnOpeningStockQty_ProductStocks;
  86. [DebuggerNonUserCode]
  87. public DataColumn StockQty_ProductStocksColumn => columnStockQty_ProductStocks;
  88. [DebuggerNonUserCode]
  89. [Browsable(false)]
  90. public int Count => base.Rows.Count;
  91. [DebuggerNonUserCode]
  92. public TotalRow this[int index] => (TotalRow)base.Rows[index];
  93. public event TotalRowChangeEventHandler TotalRowChanging;
  94. public event TotalRowChangeEventHandler TotalRowChanged;
  95. public event TotalRowChangeEventHandler TotalRowDeleting;
  96. public event TotalRowChangeEventHandler TotalRowDeleted;
  97. [DebuggerNonUserCode]
  98. public TotalDataTable()
  99. {
  100. base.TableName = "Total";
  101. BeginInit();
  102. InitClass();
  103. EndInit();
  104. }
  105. [DebuggerNonUserCode]
  106. internal TotalDataTable(DataTable table)
  107. {
  108. base.TableName = table.TableName;
  109. if (table.CaseSensitive != table.DataSet.CaseSensitive)
  110. {
  111. base.CaseSensitive = table.CaseSensitive;
  112. }
  113. if (table.Locale.ToString() != table.DataSet.Locale.ToString())
  114. {
  115. base.Locale = table.Locale;
  116. }
  117. if (table.Namespace != table.DataSet.Namespace)
  118. {
  119. base.Namespace = table.Namespace;
  120. }
  121. base.Prefix = table.Prefix;
  122. base.MinimumCapacity = table.MinimumCapacity;
  123. }
  124. [DebuggerNonUserCode]
  125. protected TotalDataTable(SerializationInfo info, StreamingContext context)
  126. : base(info, context)
  127. {
  128. InitVars();
  129. }
  130. [DebuggerNonUserCode]
  131. public void AddTotalRow(TotalRow row)
  132. {
  133. base.Rows.Add(row);
  134. }
  135. [DebuggerNonUserCode]
  136. public TotalRow AddTotalRow(string No_Product, string Name_Product, decimal Cost_Product, decimal OpeningAvailableQty_ProductStocks, decimal AvailableQty_ProductStocks, decimal Quantity_SaleBillProduct, decimal Quantity_SaleOutDepotBillProduct, decimal OutQuantity_ModifyDepotBillProduct, decimal InQuantity_ModifyDepotBillProduct, decimal Quantity_PurchaseOrderBillProduct, decimal Quantity_PurchaseInDepotBillProduct, decimal OutQuantity_StocktakingBillProduct, decimal InQuantity_StocktakingBillProduct, decimal TotalPrice, decimal Quantity_SaleRtnBillProduct, string Type_Product, decimal Quantity_RealSale, decimal OpeningStockQty_ProductStocks, decimal StockQty_ProductStocks)
  137. {
  138. TotalRow totalRow = (TotalRow)NewRow();
  139. totalRow.ItemArray = new object[19]
  140. {
  141. No_Product,
  142. Name_Product,
  143. Cost_Product,
  144. OpeningAvailableQty_ProductStocks,
  145. AvailableQty_ProductStocks,
  146. Quantity_SaleBillProduct,
  147. Quantity_SaleOutDepotBillProduct,
  148. OutQuantity_ModifyDepotBillProduct,
  149. InQuantity_ModifyDepotBillProduct,
  150. Quantity_PurchaseOrderBillProduct,
  151. Quantity_PurchaseInDepotBillProduct,
  152. OutQuantity_StocktakingBillProduct,
  153. InQuantity_StocktakingBillProduct,
  154. TotalPrice,
  155. Quantity_SaleRtnBillProduct,
  156. Type_Product,
  157. Quantity_RealSale,
  158. OpeningStockQty_ProductStocks,
  159. StockQty_ProductStocks
  160. };
  161. base.Rows.Add(totalRow);
  162. return totalRow;
  163. }
  164. [DebuggerNonUserCode]
  165. public virtual IEnumerator GetEnumerator()
  166. {
  167. return base.Rows.GetEnumerator();
  168. }
  169. [DebuggerNonUserCode]
  170. public override DataTable Clone()
  171. {
  172. TotalDataTable totalDataTable = (TotalDataTable)base.Clone();
  173. totalDataTable.InitVars();
  174. return totalDataTable;
  175. }
  176. [DebuggerNonUserCode]
  177. protected override DataTable CreateInstance()
  178. {
  179. return new TotalDataTable();
  180. }
  181. [DebuggerNonUserCode]
  182. internal void InitVars()
  183. {
  184. columnNo_Product = base.Columns["No_Product"];
  185. columnName_Product = base.Columns["Name_Product"];
  186. columnCost_Product = base.Columns["Cost_Product"];
  187. columnOpeningAvailableQty_ProductStocks = base.Columns["OpeningAvailableQty_ProductStocks"];
  188. columnAvailableQty_ProductStocks = base.Columns["AvailableQty_ProductStocks"];
  189. columnQuantity_SaleBillProduct = base.Columns["Quantity_SaleBillProduct"];
  190. columnQuantity_SaleOutDepotBillProduct = base.Columns["Quantity_SaleOutDepotBillProduct"];
  191. columnOutQuantity_ModifyDepotBillProduct = base.Columns["OutQuantity_ModifyDepotBillProduct"];
  192. columnInQuantity_ModifyDepotBillProduct = base.Columns["InQuantity_ModifyDepotBillProduct"];
  193. columnQuantity_PurchaseOrderBillProduct = base.Columns["Quantity_PurchaseOrderBillProduct"];
  194. columnQuantity_PurchaseInDepotBillProduct = base.Columns["Quantity_PurchaseInDepotBillProduct"];
  195. columnOutQuantity_StocktakingBillProduct = base.Columns["OutQuantity_StocktakingBillProduct"];
  196. columnInQuantity_StocktakingBillProduct = base.Columns["InQuantity_StocktakingBillProduct"];
  197. columnTotalPrice = base.Columns["TotalPrice"];
  198. columnQuantity_SaleRtnBillProduct = base.Columns["Quantity_SaleRtnBillProduct"];
  199. columnType_Product = base.Columns["Type_Product"];
  200. columnQuantity_RealSale = base.Columns["Quantity_RealSale"];
  201. columnOpeningStockQty_ProductStocks = base.Columns["OpeningStockQty_ProductStocks"];
  202. columnStockQty_ProductStocks = base.Columns["StockQty_ProductStocks"];
  203. }
  204. [DebuggerNonUserCode]
  205. private void InitClass()
  206. {
  207. columnNo_Product = new DataColumn("No_Product", typeof(string), null, MappingType.Element);
  208. base.Columns.Add(columnNo_Product);
  209. columnName_Product = new DataColumn("Name_Product", typeof(string), null, MappingType.Element);
  210. base.Columns.Add(columnName_Product);
  211. columnCost_Product = new DataColumn("Cost_Product", typeof(decimal), null, MappingType.Element);
  212. base.Columns.Add(columnCost_Product);
  213. columnOpeningAvailableQty_ProductStocks = new DataColumn("OpeningAvailableQty_ProductStocks", typeof(decimal), null, MappingType.Element);
  214. base.Columns.Add(columnOpeningAvailableQty_ProductStocks);
  215. columnAvailableQty_ProductStocks = new DataColumn("AvailableQty_ProductStocks", typeof(decimal), null, MappingType.Element);
  216. base.Columns.Add(columnAvailableQty_ProductStocks);
  217. columnQuantity_SaleBillProduct = new DataColumn("Quantity_SaleBillProduct", typeof(decimal), null, MappingType.Element);
  218. base.Columns.Add(columnQuantity_SaleBillProduct);
  219. columnQuantity_SaleOutDepotBillProduct = new DataColumn("Quantity_SaleOutDepotBillProduct", typeof(decimal), null, MappingType.Element);
  220. base.Columns.Add(columnQuantity_SaleOutDepotBillProduct);
  221. columnOutQuantity_ModifyDepotBillProduct = new DataColumn("OutQuantity_ModifyDepotBillProduct", typeof(decimal), null, MappingType.Element);
  222. base.Columns.Add(columnOutQuantity_ModifyDepotBillProduct);
  223. columnInQuantity_ModifyDepotBillProduct = new DataColumn("InQuantity_ModifyDepotBillProduct", typeof(decimal), null, MappingType.Element);
  224. base.Columns.Add(columnInQuantity_ModifyDepotBillProduct);
  225. columnQuantity_PurchaseOrderBillProduct = new DataColumn("Quantity_PurchaseOrderBillProduct", typeof(decimal), null, MappingType.Element);
  226. base.Columns.Add(columnQuantity_PurchaseOrderBillProduct);
  227. columnQuantity_PurchaseInDepotBillProduct = new DataColumn("Quantity_PurchaseInDepotBillProduct", typeof(decimal), null, MappingType.Element);
  228. base.Columns.Add(columnQuantity_PurchaseInDepotBillProduct);
  229. columnOutQuantity_StocktakingBillProduct = new DataColumn("OutQuantity_StocktakingBillProduct", typeof(decimal), null, MappingType.Element);
  230. base.Columns.Add(columnOutQuantity_StocktakingBillProduct);
  231. columnInQuantity_StocktakingBillProduct = new DataColumn("InQuantity_StocktakingBillProduct", typeof(decimal), null, MappingType.Element);
  232. base.Columns.Add(columnInQuantity_StocktakingBillProduct);
  233. columnTotalPrice = new DataColumn("TotalPrice", typeof(decimal), null, MappingType.Element);
  234. base.Columns.Add(columnTotalPrice);
  235. columnQuantity_SaleRtnBillProduct = new DataColumn("Quantity_SaleRtnBillProduct", typeof(decimal), null, MappingType.Element);
  236. base.Columns.Add(columnQuantity_SaleRtnBillProduct);
  237. columnType_Product = new DataColumn("Type_Product", typeof(string), null, MappingType.Element);
  238. base.Columns.Add(columnType_Product);
  239. columnQuantity_RealSale = new DataColumn("Quantity_RealSale", typeof(decimal), null, MappingType.Element);
  240. base.Columns.Add(columnQuantity_RealSale);
  241. columnOpeningStockQty_ProductStocks = new DataColumn("OpeningStockQty_ProductStocks", typeof(decimal), null, MappingType.Element);
  242. base.Columns.Add(columnOpeningStockQty_ProductStocks);
  243. columnStockQty_ProductStocks = new DataColumn("StockQty_ProductStocks", typeof(decimal), null, MappingType.Element);
  244. base.Columns.Add(columnStockQty_ProductStocks);
  245. }
  246. [DebuggerNonUserCode]
  247. public TotalRow NewTotalRow()
  248. {
  249. return (TotalRow)NewRow();
  250. }
  251. [DebuggerNonUserCode]
  252. protected override DataRow NewRowFromBuilder(DataRowBuilder builder)
  253. {
  254. return new TotalRow(builder);
  255. }
  256. [DebuggerNonUserCode]
  257. protected override Type GetRowType()
  258. {
  259. return typeof(TotalRow);
  260. }
  261. [DebuggerNonUserCode]
  262. protected override void OnRowChanged(DataRowChangeEventArgs e)
  263. {
  264. base.OnRowChanged(e);
  265. if (this.TotalRowChanged != null)
  266. {
  267. this.TotalRowChanged(this, new TotalRowChangeEvent((TotalRow)e.Row, e.Action));
  268. }
  269. }
  270. [DebuggerNonUserCode]
  271. protected override void OnRowChanging(DataRowChangeEventArgs e)
  272. {
  273. base.OnRowChanging(e);
  274. if (this.TotalRowChanging != null)
  275. {
  276. this.TotalRowChanging(this, new TotalRowChangeEvent((TotalRow)e.Row, e.Action));
  277. }
  278. }
  279. [DebuggerNonUserCode]
  280. protected override void OnRowDeleted(DataRowChangeEventArgs e)
  281. {
  282. base.OnRowDeleted(e);
  283. if (this.TotalRowDeleted != null)
  284. {
  285. this.TotalRowDeleted(this, new TotalRowChangeEvent((TotalRow)e.Row, e.Action));
  286. }
  287. }
  288. [DebuggerNonUserCode]
  289. protected override void OnRowDeleting(DataRowChangeEventArgs e)
  290. {
  291. base.OnRowDeleting(e);
  292. if (this.TotalRowDeleting != null)
  293. {
  294. this.TotalRowDeleting(this, new TotalRowChangeEvent((TotalRow)e.Row, e.Action));
  295. }
  296. }
  297. [DebuggerNonUserCode]
  298. public void RemoveTotalRow(TotalRow row)
  299. {
  300. base.Rows.Remove(row);
  301. }
  302. [DebuggerNonUserCode]
  303. public static XmlSchemaComplexType GetTypedTableSchema(XmlSchemaSet xs)
  304. {
  305. XmlSchemaComplexType xmlSchemaComplexType = new XmlSchemaComplexType();
  306. XmlSchemaSequence xmlSchemaSequence = new XmlSchemaSequence();
  307. dsFrmOverallSearchTable dsFrmOverallSearchTable = new dsFrmOverallSearchTable();
  308. xs.Add(dsFrmOverallSearchTable.GetSchemaSerializable());
  309. XmlSchemaAny xmlSchemaAny = new XmlSchemaAny();
  310. xmlSchemaAny.Namespace = "http://www.w3.org/2001/XMLSchema";
  311. xmlSchemaAny.MinOccurs = 0m;
  312. xmlSchemaAny.MaxOccurs = decimal.MaxValue;
  313. xmlSchemaAny.ProcessContents = XmlSchemaContentProcessing.Lax;
  314. xmlSchemaSequence.Items.Add(xmlSchemaAny);
  315. XmlSchemaAny xmlSchemaAny2 = new XmlSchemaAny();
  316. xmlSchemaAny2.Namespace = "urn:schemas-microsoft-com:xml-diffgram-v1";
  317. xmlSchemaAny2.MinOccurs = 1m;
  318. xmlSchemaAny2.ProcessContents = XmlSchemaContentProcessing.Lax;
  319. xmlSchemaSequence.Items.Add(xmlSchemaAny2);
  320. XmlSchemaAttribute xmlSchemaAttribute = new XmlSchemaAttribute();
  321. xmlSchemaAttribute.Name = "namespace";
  322. xmlSchemaAttribute.FixedValue = dsFrmOverallSearchTable.Namespace;
  323. xmlSchemaComplexType.Attributes.Add(xmlSchemaAttribute);
  324. XmlSchemaAttribute xmlSchemaAttribute2 = new XmlSchemaAttribute();
  325. xmlSchemaAttribute2.Name = "tableTypeName";
  326. xmlSchemaAttribute2.FixedValue = "TotalDataTable";
  327. xmlSchemaComplexType.Attributes.Add(xmlSchemaAttribute2);
  328. xmlSchemaComplexType.Particle = xmlSchemaSequence;
  329. return xmlSchemaComplexType;
  330. }
  331. }
  332. [Serializable]
  333. [GeneratedCode("System.Data.Design.TypedDataSetGenerator", "2.0.0.0")]
  334. [XmlSchemaProvider("GetTypedTableSchema")]
  335. public class AppendInfoDataTable : DataTable, IEnumerable
  336. {
  337. private DataColumn columnCurrentCompany;
  338. private DataColumn columnCurrentUser;
  339. [DebuggerNonUserCode]
  340. public DataColumn CurrentCompanyColumn => columnCurrentCompany;
  341. [DebuggerNonUserCode]
  342. public DataColumn CurrentUserColumn => columnCurrentUser;
  343. [DebuggerNonUserCode]
  344. [Browsable(false)]
  345. public int Count => base.Rows.Count;
  346. [DebuggerNonUserCode]
  347. public AppendInfoRow this[int index] => (AppendInfoRow)base.Rows[index];
  348. public event AppendInfoRowChangeEventHandler AppendInfoRowChanging;
  349. public event AppendInfoRowChangeEventHandler AppendInfoRowChanged;
  350. public event AppendInfoRowChangeEventHandler AppendInfoRowDeleting;
  351. public event AppendInfoRowChangeEventHandler AppendInfoRowDeleted;
  352. [DebuggerNonUserCode]
  353. public AppendInfoDataTable()
  354. {
  355. base.TableName = "AppendInfo";
  356. BeginInit();
  357. InitClass();
  358. EndInit();
  359. }
  360. [DebuggerNonUserCode]
  361. internal AppendInfoDataTable(DataTable table)
  362. {
  363. base.TableName = table.TableName;
  364. if (table.CaseSensitive != table.DataSet.CaseSensitive)
  365. {
  366. base.CaseSensitive = table.CaseSensitive;
  367. }
  368. if (table.Locale.ToString() != table.DataSet.Locale.ToString())
  369. {
  370. base.Locale = table.Locale;
  371. }
  372. if (table.Namespace != table.DataSet.Namespace)
  373. {
  374. base.Namespace = table.Namespace;
  375. }
  376. base.Prefix = table.Prefix;
  377. base.MinimumCapacity = table.MinimumCapacity;
  378. }
  379. [DebuggerNonUserCode]
  380. protected AppendInfoDataTable(SerializationInfo info, StreamingContext context)
  381. : base(info, context)
  382. {
  383. InitVars();
  384. }
  385. [DebuggerNonUserCode]
  386. public void AddAppendInfoRow(AppendInfoRow row)
  387. {
  388. base.Rows.Add(row);
  389. }
  390. [DebuggerNonUserCode]
  391. public AppendInfoRow AddAppendInfoRow(string CurrentCompany, string CurrentUser)
  392. {
  393. AppendInfoRow appendInfoRow = (AppendInfoRow)NewRow();
  394. appendInfoRow.ItemArray = new object[2]
  395. {
  396. CurrentCompany,
  397. CurrentUser
  398. };
  399. base.Rows.Add(appendInfoRow);
  400. return appendInfoRow;
  401. }
  402. [DebuggerNonUserCode]
  403. public virtual IEnumerator GetEnumerator()
  404. {
  405. return base.Rows.GetEnumerator();
  406. }
  407. [DebuggerNonUserCode]
  408. public override DataTable Clone()
  409. {
  410. AppendInfoDataTable appendInfoDataTable = (AppendInfoDataTable)base.Clone();
  411. appendInfoDataTable.InitVars();
  412. return appendInfoDataTable;
  413. }
  414. [DebuggerNonUserCode]
  415. protected override DataTable CreateInstance()
  416. {
  417. return new AppendInfoDataTable();
  418. }
  419. [DebuggerNonUserCode]
  420. internal void InitVars()
  421. {
  422. columnCurrentCompany = base.Columns["CurrentCompany"];
  423. columnCurrentUser = base.Columns["CurrentUser"];
  424. }
  425. [DebuggerNonUserCode]
  426. private void InitClass()
  427. {
  428. columnCurrentCompany = new DataColumn("CurrentCompany", typeof(string), null, MappingType.Element);
  429. base.Columns.Add(columnCurrentCompany);
  430. columnCurrentUser = new DataColumn("CurrentUser", typeof(string), null, MappingType.Element);
  431. base.Columns.Add(columnCurrentUser);
  432. }
  433. [DebuggerNonUserCode]
  434. public AppendInfoRow NewAppendInfoRow()
  435. {
  436. return (AppendInfoRow)NewRow();
  437. }
  438. [DebuggerNonUserCode]
  439. protected override DataRow NewRowFromBuilder(DataRowBuilder builder)
  440. {
  441. return new AppendInfoRow(builder);
  442. }
  443. [DebuggerNonUserCode]
  444. protected override Type GetRowType()
  445. {
  446. return typeof(AppendInfoRow);
  447. }
  448. [DebuggerNonUserCode]
  449. protected override void OnRowChanged(DataRowChangeEventArgs e)
  450. {
  451. base.OnRowChanged(e);
  452. if (this.AppendInfoRowChanged != null)
  453. {
  454. this.AppendInfoRowChanged(this, new AppendInfoRowChangeEvent((AppendInfoRow)e.Row, e.Action));
  455. }
  456. }
  457. [DebuggerNonUserCode]
  458. protected override void OnRowChanging(DataRowChangeEventArgs e)
  459. {
  460. base.OnRowChanging(e);
  461. if (this.AppendInfoRowChanging != null)
  462. {
  463. this.AppendInfoRowChanging(this, new AppendInfoRowChangeEvent((AppendInfoRow)e.Row, e.Action));
  464. }
  465. }
  466. [DebuggerNonUserCode]
  467. protected override void OnRowDeleted(DataRowChangeEventArgs e)
  468. {
  469. base.OnRowDeleted(e);
  470. if (this.AppendInfoRowDeleted != null)
  471. {
  472. this.AppendInfoRowDeleted(this, new AppendInfoRowChangeEvent((AppendInfoRow)e.Row, e.Action));
  473. }
  474. }
  475. [DebuggerNonUserCode]
  476. protected override void OnRowDeleting(DataRowChangeEventArgs e)
  477. {
  478. base.OnRowDeleting(e);
  479. if (this.AppendInfoRowDeleting != null)
  480. {
  481. this.AppendInfoRowDeleting(this, new AppendInfoRowChangeEvent((AppendInfoRow)e.Row, e.Action));
  482. }
  483. }
  484. [DebuggerNonUserCode]
  485. public void RemoveAppendInfoRow(AppendInfoRow row)
  486. {
  487. base.Rows.Remove(row);
  488. }
  489. [DebuggerNonUserCode]
  490. public static XmlSchemaComplexType GetTypedTableSchema(XmlSchemaSet xs)
  491. {
  492. XmlSchemaComplexType xmlSchemaComplexType = new XmlSchemaComplexType();
  493. XmlSchemaSequence xmlSchemaSequence = new XmlSchemaSequence();
  494. dsFrmOverallSearchTable dsFrmOverallSearchTable = new dsFrmOverallSearchTable();
  495. xs.Add(dsFrmOverallSearchTable.GetSchemaSerializable());
  496. XmlSchemaAny xmlSchemaAny = new XmlSchemaAny();
  497. xmlSchemaAny.Namespace = "http://www.w3.org/2001/XMLSchema";
  498. xmlSchemaAny.MinOccurs = 0m;
  499. xmlSchemaAny.MaxOccurs = decimal.MaxValue;
  500. xmlSchemaAny.ProcessContents = XmlSchemaContentProcessing.Lax;
  501. xmlSchemaSequence.Items.Add(xmlSchemaAny);
  502. XmlSchemaAny xmlSchemaAny2 = new XmlSchemaAny();
  503. xmlSchemaAny2.Namespace = "urn:schemas-microsoft-com:xml-diffgram-v1";
  504. xmlSchemaAny2.MinOccurs = 1m;
  505. xmlSchemaAny2.ProcessContents = XmlSchemaContentProcessing.Lax;
  506. xmlSchemaSequence.Items.Add(xmlSchemaAny2);
  507. XmlSchemaAttribute xmlSchemaAttribute = new XmlSchemaAttribute();
  508. xmlSchemaAttribute.Name = "namespace";
  509. xmlSchemaAttribute.FixedValue = dsFrmOverallSearchTable.Namespace;
  510. xmlSchemaComplexType.Attributes.Add(xmlSchemaAttribute);
  511. XmlSchemaAttribute xmlSchemaAttribute2 = new XmlSchemaAttribute();
  512. xmlSchemaAttribute2.Name = "tableTypeName";
  513. xmlSchemaAttribute2.FixedValue = "AppendInfoDataTable";
  514. xmlSchemaComplexType.Attributes.Add(xmlSchemaAttribute2);
  515. xmlSchemaComplexType.Particle = xmlSchemaSequence;
  516. return xmlSchemaComplexType;
  517. }
  518. }
  519. [GeneratedCode("System.Data.Design.TypedDataSetGenerator", "2.0.0.0")]
  520. public class TotalRow : DataRow
  521. {
  522. private TotalDataTable tableTotal;
  523. [DebuggerNonUserCode]
  524. public string No_Product
  525. {
  526. get
  527. {
  528. try
  529. {
  530. return (string)base[tableTotal.No_ProductColumn];
  531. }
  532. catch (InvalidCastException innerException)
  533. {
  534. throw new StrongTypingException("The value for column 'No_Product' in table 'Total' is DBNull.", innerException);
  535. }
  536. }
  537. set
  538. {
  539. base[tableTotal.No_ProductColumn] = value;
  540. }
  541. }
  542. [DebuggerNonUserCode]
  543. public string Name_Product
  544. {
  545. get
  546. {
  547. try
  548. {
  549. return (string)base[tableTotal.Name_ProductColumn];
  550. }
  551. catch (InvalidCastException innerException)
  552. {
  553. throw new StrongTypingException("The value for column 'Name_Product' in table 'Total' is DBNull.", innerException);
  554. }
  555. }
  556. set
  557. {
  558. base[tableTotal.Name_ProductColumn] = value;
  559. }
  560. }
  561. [DebuggerNonUserCode]
  562. public decimal Cost_Product
  563. {
  564. get
  565. {
  566. try
  567. {
  568. return (decimal)base[tableTotal.Cost_ProductColumn];
  569. }
  570. catch (InvalidCastException innerException)
  571. {
  572. throw new StrongTypingException("The value for column 'Cost_Product' in table 'Total' is DBNull.", innerException);
  573. }
  574. }
  575. set
  576. {
  577. base[tableTotal.Cost_ProductColumn] = value;
  578. }
  579. }
  580. [DebuggerNonUserCode]
  581. public decimal OpeningAvailableQty_ProductStocks
  582. {
  583. get
  584. {
  585. try
  586. {
  587. return (decimal)base[tableTotal.OpeningAvailableQty_ProductStocksColumn];
  588. }
  589. catch (InvalidCastException innerException)
  590. {
  591. throw new StrongTypingException("The value for column 'OpeningAvailableQty_ProductStocks' in table 'Total' is DBNull.", innerException);
  592. }
  593. }
  594. set
  595. {
  596. base[tableTotal.OpeningAvailableQty_ProductStocksColumn] = value;
  597. }
  598. }
  599. [DebuggerNonUserCode]
  600. public decimal AvailableQty_ProductStocks
  601. {
  602. get
  603. {
  604. try
  605. {
  606. return (decimal)base[tableTotal.AvailableQty_ProductStocksColumn];
  607. }
  608. catch (InvalidCastException innerException)
  609. {
  610. throw new StrongTypingException("The value for column 'AvailableQty_ProductStocks' in table 'Total' is DBNull.", innerException);
  611. }
  612. }
  613. set
  614. {
  615. base[tableTotal.AvailableQty_ProductStocksColumn] = value;
  616. }
  617. }
  618. [DebuggerNonUserCode]
  619. public decimal Quantity_SaleBillProduct
  620. {
  621. get
  622. {
  623. try
  624. {
  625. return (decimal)base[tableTotal.Quantity_SaleBillProductColumn];
  626. }
  627. catch (InvalidCastException innerException)
  628. {
  629. throw new StrongTypingException("The value for column 'Quantity_SaleBillProduct' in table 'Total' is DBNull.", innerException);
  630. }
  631. }
  632. set
  633. {
  634. base[tableTotal.Quantity_SaleBillProductColumn] = value;
  635. }
  636. }
  637. [DebuggerNonUserCode]
  638. public decimal Quantity_SaleOutDepotBillProduct
  639. {
  640. get
  641. {
  642. try
  643. {
  644. return (decimal)base[tableTotal.Quantity_SaleOutDepotBillProductColumn];
  645. }
  646. catch (InvalidCastException innerException)
  647. {
  648. throw new StrongTypingException("The value for column 'Quantity_SaleOutDepotBillProduct' in table 'Total' is DBNull.", innerException);
  649. }
  650. }
  651. set
  652. {
  653. base[tableTotal.Quantity_SaleOutDepotBillProductColumn] = value;
  654. }
  655. }
  656. [DebuggerNonUserCode]
  657. public decimal OutQuantity_ModifyDepotBillProduct
  658. {
  659. get
  660. {
  661. try
  662. {
  663. return (decimal)base[tableTotal.OutQuantity_ModifyDepotBillProductColumn];
  664. }
  665. catch (InvalidCastException innerException)
  666. {
  667. throw new StrongTypingException("The value for column 'OutQuantity_ModifyDepotBillProduct' in table 'Total' is DBNull.", innerException);
  668. }
  669. }
  670. set
  671. {
  672. base[tableTotal.OutQuantity_ModifyDepotBillProductColumn] = value;
  673. }
  674. }
  675. [DebuggerNonUserCode]
  676. public decimal InQuantity_ModifyDepotBillProduct
  677. {
  678. get
  679. {
  680. try
  681. {
  682. return (decimal)base[tableTotal.InQuantity_ModifyDepotBillProductColumn];
  683. }
  684. catch (InvalidCastException innerException)
  685. {
  686. throw new StrongTypingException("The value for column 'InQuantity_ModifyDepotBillProduct' in table 'Total' is DBNull.", innerException);
  687. }
  688. }
  689. set
  690. {
  691. base[tableTotal.InQuantity_ModifyDepotBillProductColumn] = value;
  692. }
  693. }
  694. [DebuggerNonUserCode]
  695. public decimal Quantity_PurchaseOrderBillProduct
  696. {
  697. get
  698. {
  699. try
  700. {
  701. return (decimal)base[tableTotal.Quantity_PurchaseOrderBillProductColumn];
  702. }
  703. catch (InvalidCastException innerException)
  704. {
  705. throw new StrongTypingException("The value for column 'Quantity_PurchaseOrderBillProduct' in table 'Total' is DBNull.", innerException);
  706. }
  707. }
  708. set
  709. {
  710. base[tableTotal.Quantity_PurchaseOrderBillProductColumn] = value;
  711. }
  712. }
  713. [DebuggerNonUserCode]
  714. public decimal Quantity_PurchaseInDepotBillProduct
  715. {
  716. get
  717. {
  718. try
  719. {
  720. return (decimal)base[tableTotal.Quantity_PurchaseInDepotBillProductColumn];
  721. }
  722. catch (InvalidCastException innerException)
  723. {
  724. throw new StrongTypingException("The value for column 'Quantity_PurchaseInDepotBillProduct' in table 'Total' is DBNull.", innerException);
  725. }
  726. }
  727. set
  728. {
  729. base[tableTotal.Quantity_PurchaseInDepotBillProductColumn] = value;
  730. }
  731. }
  732. [DebuggerNonUserCode]
  733. public decimal OutQuantity_StocktakingBillProduct
  734. {
  735. get
  736. {
  737. try
  738. {
  739. return (decimal)base[tableTotal.OutQuantity_StocktakingBillProductColumn];
  740. }
  741. catch (InvalidCastException innerException)
  742. {
  743. throw new StrongTypingException("The value for column 'OutQuantity_StocktakingBillProduct' in table 'Total' is DBNull.", innerException);
  744. }
  745. }
  746. set
  747. {
  748. base[tableTotal.OutQuantity_StocktakingBillProductColumn] = value;
  749. }
  750. }
  751. [DebuggerNonUserCode]
  752. public decimal InQuantity_StocktakingBillProduct
  753. {
  754. get
  755. {
  756. try
  757. {
  758. return (decimal)base[tableTotal.InQuantity_StocktakingBillProductColumn];
  759. }
  760. catch (InvalidCastException innerException)
  761. {
  762. throw new StrongTypingException("The value for column 'InQuantity_StocktakingBillProduct' in table 'Total' is DBNull.", innerException);
  763. }
  764. }
  765. set
  766. {
  767. base[tableTotal.InQuantity_StocktakingBillProductColumn] = value;
  768. }
  769. }
  770. [DebuggerNonUserCode]
  771. public decimal TotalPrice
  772. {
  773. get
  774. {
  775. try
  776. {
  777. return (decimal)base[tableTotal.TotalPriceColumn];
  778. }
  779. catch (InvalidCastException innerException)
  780. {
  781. throw new StrongTypingException("The value for column 'TotalPrice' in table 'Total' is DBNull.", innerException);
  782. }
  783. }
  784. set
  785. {
  786. base[tableTotal.TotalPriceColumn] = value;
  787. }
  788. }
  789. [DebuggerNonUserCode]
  790. public decimal Quantity_SaleRtnBillProduct
  791. {
  792. get
  793. {
  794. try
  795. {
  796. return (decimal)base[tableTotal.Quantity_SaleRtnBillProductColumn];
  797. }
  798. catch (InvalidCastException innerException)
  799. {
  800. throw new StrongTypingException("The value for column 'Quantity_SaleRtnBillProduct' in table 'Total' is DBNull.", innerException);
  801. }
  802. }
  803. set
  804. {
  805. base[tableTotal.Quantity_SaleRtnBillProductColumn] = value;
  806. }
  807. }
  808. [DebuggerNonUserCode]
  809. public string Type_Product
  810. {
  811. get
  812. {
  813. try
  814. {
  815. return (string)base[tableTotal.Type_ProductColumn];
  816. }
  817. catch (InvalidCastException innerException)
  818. {
  819. throw new StrongTypingException("The value for column 'Type_Product' in table 'Total' is DBNull.", innerException);
  820. }
  821. }
  822. set
  823. {
  824. base[tableTotal.Type_ProductColumn] = value;
  825. }
  826. }
  827. [DebuggerNonUserCode]
  828. public decimal Quantity_RealSale
  829. {
  830. get
  831. {
  832. try
  833. {
  834. return (decimal)base[tableTotal.Quantity_RealSaleColumn];
  835. }
  836. catch (InvalidCastException innerException)
  837. {
  838. throw new StrongTypingException("The value for column 'Quantity_RealSale' in table 'Total' is DBNull.", innerException);
  839. }
  840. }
  841. set
  842. {
  843. base[tableTotal.Quantity_RealSaleColumn] = value;
  844. }
  845. }
  846. [DebuggerNonUserCode]
  847. public decimal OpeningStockQty_ProductStocks
  848. {
  849. get
  850. {
  851. try
  852. {
  853. return (decimal)base[tableTotal.OpeningStockQty_ProductStocksColumn];
  854. }
  855. catch (InvalidCastException innerException)
  856. {
  857. throw new StrongTypingException("The value for column 'OpeningStockQty_ProductStocks' in table 'Total' is DBNull.", innerException);
  858. }
  859. }
  860. set
  861. {
  862. base[tableTotal.OpeningStockQty_ProductStocksColumn] = value;
  863. }
  864. }
  865. [DebuggerNonUserCode]
  866. public decimal StockQty_ProductStocks
  867. {
  868. get
  869. {
  870. try
  871. {
  872. return (decimal)base[tableTotal.StockQty_ProductStocksColumn];
  873. }
  874. catch (InvalidCastException innerException)
  875. {
  876. throw new StrongTypingException("The value for column 'StockQty_ProductStocks' in table 'Total' is DBNull.", innerException);
  877. }
  878. }
  879. set
  880. {
  881. base[tableTotal.StockQty_ProductStocksColumn] = value;
  882. }
  883. }
  884. [DebuggerNonUserCode]
  885. internal TotalRow(DataRowBuilder rb)
  886. : base(rb)
  887. {
  888. tableTotal = (TotalDataTable)base.Table;
  889. }
  890. [DebuggerNonUserCode]
  891. public bool IsNo_ProductNull()
  892. {
  893. return IsNull(tableTotal.No_ProductColumn);
  894. }
  895. [DebuggerNonUserCode]
  896. public void SetNo_ProductNull()
  897. {
  898. base[tableTotal.No_ProductColumn] = Convert.DBNull;
  899. }
  900. [DebuggerNonUserCode]
  901. public bool IsName_ProductNull()
  902. {
  903. return IsNull(tableTotal.Name_ProductColumn);
  904. }
  905. [DebuggerNonUserCode]
  906. public void SetName_ProductNull()
  907. {
  908. base[tableTotal.Name_ProductColumn] = Convert.DBNull;
  909. }
  910. [DebuggerNonUserCode]
  911. public bool IsCost_ProductNull()
  912. {
  913. return IsNull(tableTotal.Cost_ProductColumn);
  914. }
  915. [DebuggerNonUserCode]
  916. public void SetCost_ProductNull()
  917. {
  918. base[tableTotal.Cost_ProductColumn] = Convert.DBNull;
  919. }
  920. [DebuggerNonUserCode]
  921. public bool IsOpeningAvailableQty_ProductStocksNull()
  922. {
  923. return IsNull(tableTotal.OpeningAvailableQty_ProductStocksColumn);
  924. }
  925. [DebuggerNonUserCode]
  926. public void SetOpeningAvailableQty_ProductStocksNull()
  927. {
  928. base[tableTotal.OpeningAvailableQty_ProductStocksColumn] = Convert.DBNull;
  929. }
  930. [DebuggerNonUserCode]
  931. public bool IsAvailableQty_ProductStocksNull()
  932. {
  933. return IsNull(tableTotal.AvailableQty_ProductStocksColumn);
  934. }
  935. [DebuggerNonUserCode]
  936. public void SetAvailableQty_ProductStocksNull()
  937. {
  938. base[tableTotal.AvailableQty_ProductStocksColumn] = Convert.DBNull;
  939. }
  940. [DebuggerNonUserCode]
  941. public bool IsQuantity_SaleBillProductNull()
  942. {
  943. return IsNull(tableTotal.Quantity_SaleBillProductColumn);
  944. }
  945. [DebuggerNonUserCode]
  946. public void SetQuantity_SaleBillProductNull()
  947. {
  948. base[tableTotal.Quantity_SaleBillProductColumn] = Convert.DBNull;
  949. }
  950. [DebuggerNonUserCode]
  951. public bool IsQuantity_SaleOutDepotBillProductNull()
  952. {
  953. return IsNull(tableTotal.Quantity_SaleOutDepotBillProductColumn);
  954. }
  955. [DebuggerNonUserCode]
  956. public void SetQuantity_SaleOutDepotBillProductNull()
  957. {
  958. base[tableTotal.Quantity_SaleOutDepotBillProductColumn] = Convert.DBNull;
  959. }
  960. [DebuggerNonUserCode]
  961. public bool IsOutQuantity_ModifyDepotBillProductNull()
  962. {
  963. return IsNull(tableTotal.OutQuantity_ModifyDepotBillProductColumn);
  964. }
  965. [DebuggerNonUserCode]
  966. public void SetOutQuantity_ModifyDepotBillProductNull()
  967. {
  968. base[tableTotal.OutQuantity_ModifyDepotBillProductColumn] = Convert.DBNull;
  969. }
  970. [DebuggerNonUserCode]
  971. public bool IsInQuantity_ModifyDepotBillProductNull()
  972. {
  973. return IsNull(tableTotal.InQuantity_ModifyDepotBillProductColumn);
  974. }
  975. [DebuggerNonUserCode]
  976. public void SetInQuantity_ModifyDepotBillProductNull()
  977. {
  978. base[tableTotal.InQuantity_ModifyDepotBillProductColumn] = Convert.DBNull;
  979. }
  980. [DebuggerNonUserCode]
  981. public bool IsQuantity_PurchaseOrderBillProductNull()
  982. {
  983. return IsNull(tableTotal.Quantity_PurchaseOrderBillProductColumn);
  984. }
  985. [DebuggerNonUserCode]
  986. public void SetQuantity_PurchaseOrderBillProductNull()
  987. {
  988. base[tableTotal.Quantity_PurchaseOrderBillProductColumn] = Convert.DBNull;
  989. }
  990. [DebuggerNonUserCode]
  991. public bool IsQuantity_PurchaseInDepotBillProductNull()
  992. {
  993. return IsNull(tableTotal.Quantity_PurchaseInDepotBillProductColumn);
  994. }
  995. [DebuggerNonUserCode]
  996. public void SetQuantity_PurchaseInDepotBillProductNull()
  997. {
  998. base[tableTotal.Quantity_PurchaseInDepotBillProductColumn] = Convert.DBNull;
  999. }
  1000. [DebuggerNonUserCode]
  1001. public bool IsOutQuantity_StocktakingBillProductNull()
  1002. {
  1003. return IsNull(tableTotal.OutQuantity_StocktakingBillProductColumn);
  1004. }
  1005. [DebuggerNonUserCode]
  1006. public void SetOutQuantity_StocktakingBillProductNull()
  1007. {
  1008. base[tableTotal.OutQuantity_StocktakingBillProductColumn] = Convert.DBNull;
  1009. }
  1010. [DebuggerNonUserCode]
  1011. public bool IsInQuantity_StocktakingBillProductNull()
  1012. {
  1013. return IsNull(tableTotal.InQuantity_StocktakingBillProductColumn);
  1014. }
  1015. [DebuggerNonUserCode]
  1016. public void SetInQuantity_StocktakingBillProductNull()
  1017. {
  1018. base[tableTotal.InQuantity_StocktakingBillProductColumn] = Convert.DBNull;
  1019. }
  1020. [DebuggerNonUserCode]
  1021. public bool IsTotalPriceNull()
  1022. {
  1023. return IsNull(tableTotal.TotalPriceColumn);
  1024. }
  1025. [DebuggerNonUserCode]
  1026. public void SetTotalPriceNull()
  1027. {
  1028. base[tableTotal.TotalPriceColumn] = Convert.DBNull;
  1029. }
  1030. [DebuggerNonUserCode]
  1031. public bool IsQuantity_SaleRtnBillProductNull()
  1032. {
  1033. return IsNull(tableTotal.Quantity_SaleRtnBillProductColumn);
  1034. }
  1035. [DebuggerNonUserCode]
  1036. public void SetQuantity_SaleRtnBillProductNull()
  1037. {
  1038. base[tableTotal.Quantity_SaleRtnBillProductColumn] = Convert.DBNull;
  1039. }
  1040. [DebuggerNonUserCode]
  1041. public bool IsType_ProductNull()
  1042. {
  1043. return IsNull(tableTotal.Type_ProductColumn);
  1044. }
  1045. [DebuggerNonUserCode]
  1046. public void SetType_ProductNull()
  1047. {
  1048. base[tableTotal.Type_ProductColumn] = Convert.DBNull;
  1049. }
  1050. [DebuggerNonUserCode]
  1051. public bool IsQuantity_RealSaleNull()
  1052. {
  1053. return IsNull(tableTotal.Quantity_RealSaleColumn);
  1054. }
  1055. [DebuggerNonUserCode]
  1056. public void SetQuantity_RealSaleNull()
  1057. {
  1058. base[tableTotal.Quantity_RealSaleColumn] = Convert.DBNull;
  1059. }
  1060. [DebuggerNonUserCode]
  1061. public bool IsOpeningStockQty_ProductStocksNull()
  1062. {
  1063. return IsNull(tableTotal.OpeningStockQty_ProductStocksColumn);
  1064. }
  1065. [DebuggerNonUserCode]
  1066. public void SetOpeningStockQty_ProductStocksNull()
  1067. {
  1068. base[tableTotal.OpeningStockQty_ProductStocksColumn] = Convert.DBNull;
  1069. }
  1070. [DebuggerNonUserCode]
  1071. public bool IsStockQty_ProductStocksNull()
  1072. {
  1073. return IsNull(tableTotal.StockQty_ProductStocksColumn);
  1074. }
  1075. [DebuggerNonUserCode]
  1076. public void SetStockQty_ProductStocksNull()
  1077. {
  1078. base[tableTotal.StockQty_ProductStocksColumn] = Convert.DBNull;
  1079. }
  1080. }
  1081. [GeneratedCode("System.Data.Design.TypedDataSetGenerator", "2.0.0.0")]
  1082. public class AppendInfoRow : DataRow
  1083. {
  1084. private AppendInfoDataTable tableAppendInfo;
  1085. [DebuggerNonUserCode]
  1086. public string CurrentCompany
  1087. {
  1088. get
  1089. {
  1090. try
  1091. {
  1092. return (string)base[tableAppendInfo.CurrentCompanyColumn];
  1093. }
  1094. catch (InvalidCastException innerException)
  1095. {
  1096. throw new StrongTypingException("The value for column 'CurrentCompany' in table 'AppendInfo' is DBNull.", innerException);
  1097. }
  1098. }
  1099. set
  1100. {
  1101. base[tableAppendInfo.CurrentCompanyColumn] = value;
  1102. }
  1103. }
  1104. [DebuggerNonUserCode]
  1105. public string CurrentUser
  1106. {
  1107. get
  1108. {
  1109. try
  1110. {
  1111. return (string)base[tableAppendInfo.CurrentUserColumn];
  1112. }
  1113. catch (InvalidCastException innerException)
  1114. {
  1115. throw new StrongTypingException("The value for column 'CurrentUser' in table 'AppendInfo' is DBNull.", innerException);
  1116. }
  1117. }
  1118. set
  1119. {
  1120. base[tableAppendInfo.CurrentUserColumn] = value;
  1121. }
  1122. }
  1123. [DebuggerNonUserCode]
  1124. internal AppendInfoRow(DataRowBuilder rb)
  1125. : base(rb)
  1126. {
  1127. tableAppendInfo = (AppendInfoDataTable)base.Table;
  1128. }
  1129. [DebuggerNonUserCode]
  1130. public bool IsCurrentCompanyNull()
  1131. {
  1132. return IsNull(tableAppendInfo.CurrentCompanyColumn);
  1133. }
  1134. [DebuggerNonUserCode]
  1135. public void SetCurrentCompanyNull()
  1136. {
  1137. base[tableAppendInfo.CurrentCompanyColumn] = Convert.DBNull;
  1138. }
  1139. [DebuggerNonUserCode]
  1140. public bool IsCurrentUserNull()
  1141. {
  1142. return IsNull(tableAppendInfo.CurrentUserColumn);
  1143. }
  1144. [DebuggerNonUserCode]
  1145. public void SetCurrentUserNull()
  1146. {
  1147. base[tableAppendInfo.CurrentUserColumn] = Convert.DBNull;
  1148. }
  1149. }
  1150. [GeneratedCode("System.Data.Design.TypedDataSetGenerator", "2.0.0.0")]
  1151. public class TotalRowChangeEvent : EventArgs
  1152. {
  1153. private TotalRow eventRow;
  1154. private DataRowAction eventAction;
  1155. [DebuggerNonUserCode]
  1156. public TotalRow Row => eventRow;
  1157. [DebuggerNonUserCode]
  1158. public DataRowAction Action => eventAction;
  1159. [DebuggerNonUserCode]
  1160. public TotalRowChangeEvent(TotalRow row, DataRowAction action)
  1161. {
  1162. eventRow = row;
  1163. eventAction = action;
  1164. }
  1165. }
  1166. [GeneratedCode("System.Data.Design.TypedDataSetGenerator", "2.0.0.0")]
  1167. public class AppendInfoRowChangeEvent : EventArgs
  1168. {
  1169. private AppendInfoRow eventRow;
  1170. private DataRowAction eventAction;
  1171. [DebuggerNonUserCode]
  1172. public AppendInfoRow Row => eventRow;
  1173. [DebuggerNonUserCode]
  1174. public DataRowAction Action => eventAction;
  1175. [DebuggerNonUserCode]
  1176. public AppendInfoRowChangeEvent(AppendInfoRow row, DataRowAction action)
  1177. {
  1178. eventRow = row;
  1179. eventAction = action;
  1180. }
  1181. }
  1182. private TotalDataTable tableTotal;
  1183. private AppendInfoDataTable tableAppendInfo;
  1184. private SchemaSerializationMode _schemaSerializationMode = SchemaSerializationMode.IncludeSchema;
  1185. [DebuggerNonUserCode]
  1186. [Browsable(false)]
  1187. [DesignerSerializationVisibility(DesignerSerializationVisibility.Content)]
  1188. public TotalDataTable Total => tableTotal;
  1189. [DesignerSerializationVisibility(DesignerSerializationVisibility.Content)]
  1190. [DebuggerNonUserCode]
  1191. [Browsable(false)]
  1192. public AppendInfoDataTable AppendInfo => tableAppendInfo;
  1193. [DebuggerNonUserCode]
  1194. [DesignerSerializationVisibility(DesignerSerializationVisibility.Visible)]
  1195. [Browsable(true)]
  1196. public override SchemaSerializationMode SchemaSerializationMode
  1197. {
  1198. get
  1199. {
  1200. return _schemaSerializationMode;
  1201. }
  1202. set
  1203. {
  1204. _schemaSerializationMode = value;
  1205. }
  1206. }
  1207. [DebuggerNonUserCode]
  1208. [DesignerSerializationVisibility(DesignerSerializationVisibility.Hidden)]
  1209. public new DataTableCollection Tables => base.Tables;
  1210. [DebuggerNonUserCode]
  1211. [DesignerSerializationVisibility(DesignerSerializationVisibility.Hidden)]
  1212. public new DataRelationCollection Relations => base.Relations;
  1213. [DebuggerNonUserCode]
  1214. public dsFrmOverallSearchTable()
  1215. {
  1216. BeginInit();
  1217. InitClass();
  1218. CollectionChangeEventHandler value = SchemaChanged;
  1219. base.Tables.CollectionChanged += value;
  1220. base.Relations.CollectionChanged += value;
  1221. EndInit();
  1222. }
  1223. [DebuggerNonUserCode]
  1224. protected dsFrmOverallSearchTable(SerializationInfo info, StreamingContext context)
  1225. : base(info, context, ConstructSchema: false)
  1226. {
  1227. if (IsBinarySerialized(info, context))
  1228. {
  1229. InitVars(initTable: false);
  1230. CollectionChangeEventHandler value = SchemaChanged;
  1231. Tables.CollectionChanged += value;
  1232. Relations.CollectionChanged += value;
  1233. return;
  1234. }
  1235. string s = (string)info.GetValue("XmlSchema", typeof(string));
  1236. if (DetermineSchemaSerializationMode(info, context) == SchemaSerializationMode.IncludeSchema)
  1237. {
  1238. DataSet dataSet = new DataSet();
  1239. dataSet.ReadXmlSchema(new XmlTextReader(new StringReader(s)));
  1240. if (dataSet.Tables["Total"] != null)
  1241. {
  1242. base.Tables.Add(new TotalDataTable(dataSet.Tables["Total"]));
  1243. }
  1244. if (dataSet.Tables["AppendInfo"] != null)
  1245. {
  1246. base.Tables.Add(new AppendInfoDataTable(dataSet.Tables["AppendInfo"]));
  1247. }
  1248. base.DataSetName = dataSet.DataSetName;
  1249. base.Prefix = dataSet.Prefix;
  1250. base.Namespace = dataSet.Namespace;
  1251. base.Locale = dataSet.Locale;
  1252. base.CaseSensitive = dataSet.CaseSensitive;
  1253. base.EnforceConstraints = dataSet.EnforceConstraints;
  1254. Merge(dataSet, preserveChanges: false, MissingSchemaAction.Add);
  1255. InitVars();
  1256. }
  1257. else
  1258. {
  1259. ReadXmlSchema(new XmlTextReader(new StringReader(s)));
  1260. }
  1261. GetSerializationData(info, context);
  1262. CollectionChangeEventHandler value2 = SchemaChanged;
  1263. base.Tables.CollectionChanged += value2;
  1264. Relations.CollectionChanged += value2;
  1265. }
  1266. [DebuggerNonUserCode]
  1267. protected override void InitializeDerivedDataSet()
  1268. {
  1269. BeginInit();
  1270. InitClass();
  1271. EndInit();
  1272. }
  1273. [DebuggerNonUserCode]
  1274. public override DataSet Clone()
  1275. {
  1276. dsFrmOverallSearchTable dsFrmOverallSearchTable = (dsFrmOverallSearchTable)base.Clone();
  1277. dsFrmOverallSearchTable.InitVars();
  1278. dsFrmOverallSearchTable.SchemaSerializationMode = SchemaSerializationMode;
  1279. return dsFrmOverallSearchTable;
  1280. }
  1281. [DebuggerNonUserCode]
  1282. protected override bool ShouldSerializeTables()
  1283. {
  1284. return false;
  1285. }
  1286. [DebuggerNonUserCode]
  1287. protected override bool ShouldSerializeRelations()
  1288. {
  1289. return false;
  1290. }
  1291. [DebuggerNonUserCode]
  1292. protected override void ReadXmlSerializable(XmlReader reader)
  1293. {
  1294. if (DetermineSchemaSerializationMode(reader) == SchemaSerializationMode.IncludeSchema)
  1295. {
  1296. Reset();
  1297. DataSet dataSet = new DataSet();
  1298. dataSet.ReadXml(reader);
  1299. if (dataSet.Tables["Total"] != null)
  1300. {
  1301. base.Tables.Add(new TotalDataTable(dataSet.Tables["Total"]));
  1302. }
  1303. if (dataSet.Tables["AppendInfo"] != null)
  1304. {
  1305. base.Tables.Add(new AppendInfoDataTable(dataSet.Tables["AppendInfo"]));
  1306. }
  1307. base.DataSetName = dataSet.DataSetName;
  1308. base.Prefix = dataSet.Prefix;
  1309. base.Namespace = dataSet.Namespace;
  1310. base.Locale = dataSet.Locale;
  1311. base.CaseSensitive = dataSet.CaseSensitive;
  1312. base.EnforceConstraints = dataSet.EnforceConstraints;
  1313. Merge(dataSet, preserveChanges: false, MissingSchemaAction.Add);
  1314. InitVars();
  1315. }
  1316. else
  1317. {
  1318. ReadXml(reader);
  1319. InitVars();
  1320. }
  1321. }
  1322. [DebuggerNonUserCode]
  1323. protected override XmlSchema GetSchemaSerializable()
  1324. {
  1325. MemoryStream memoryStream = new MemoryStream();
  1326. WriteXmlSchema(new XmlTextWriter(memoryStream, null));
  1327. memoryStream.Position = 0L;
  1328. return XmlSchema.Read(new XmlTextReader(memoryStream), null);
  1329. }
  1330. [DebuggerNonUserCode]
  1331. internal void InitVars()
  1332. {
  1333. InitVars(initTable: true);
  1334. }
  1335. [DebuggerNonUserCode]
  1336. internal void InitVars(bool initTable)
  1337. {
  1338. tableTotal = (TotalDataTable)base.Tables["Total"];
  1339. if (initTable && tableTotal != null)
  1340. {
  1341. tableTotal.InitVars();
  1342. }
  1343. tableAppendInfo = (AppendInfoDataTable)base.Tables["AppendInfo"];
  1344. if (initTable && tableAppendInfo != null)
  1345. {
  1346. tableAppendInfo.InitVars();
  1347. }
  1348. }
  1349. [DebuggerNonUserCode]
  1350. private void InitClass()
  1351. {
  1352. base.DataSetName = "dsFrmOverallSearchTable";
  1353. base.Prefix = "";
  1354. base.Namespace = "http://tempuri.org/dsFrmOverallSearchTable.xsd";
  1355. base.EnforceConstraints = true;
  1356. SchemaSerializationMode = SchemaSerializationMode.IncludeSchema;
  1357. tableTotal = new TotalDataTable();
  1358. base.Tables.Add(tableTotal);
  1359. tableAppendInfo = new AppendInfoDataTable();
  1360. base.Tables.Add(tableAppendInfo);
  1361. }
  1362. [DebuggerNonUserCode]
  1363. private bool ShouldSerializeTotal()
  1364. {
  1365. return false;
  1366. }
  1367. [DebuggerNonUserCode]
  1368. private bool ShouldSerializeAppendInfo()
  1369. {
  1370. return false;
  1371. }
  1372. [DebuggerNonUserCode]
  1373. private void SchemaChanged(object sender, CollectionChangeEventArgs e)
  1374. {
  1375. if (e.Action == CollectionChangeAction.Remove)
  1376. {
  1377. InitVars();
  1378. }
  1379. }
  1380. [DebuggerNonUserCode]
  1381. public static XmlSchemaComplexType GetTypedDataSetSchema(XmlSchemaSet xs)
  1382. {
  1383. dsFrmOverallSearchTable dsFrmOverallSearchTable = new dsFrmOverallSearchTable();
  1384. XmlSchemaComplexType xmlSchemaComplexType = new XmlSchemaComplexType();
  1385. XmlSchemaSequence xmlSchemaSequence = new XmlSchemaSequence();
  1386. xs.Add(dsFrmOverallSearchTable.GetSchemaSerializable());
  1387. XmlSchemaAny xmlSchemaAny = new XmlSchemaAny();
  1388. xmlSchemaAny.Namespace = dsFrmOverallSearchTable.Namespace;
  1389. xmlSchemaSequence.Items.Add(xmlSchemaAny);
  1390. xmlSchemaComplexType.Particle = xmlSchemaSequence;
  1391. return xmlSchemaComplexType;
  1392. }
  1393. }
  1394. }