dsFrmYearSalesStatistics.cs 48 KB

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