01.private void RefreshData()
02. {
03. Cursor = Cursors.WaitCursor;
04. List<string> _file = new List<string>();
05. _file = TORServices.clsFile_Path.GetFilesRecursive(TORServices.clsPathData.Path_AllReport, "*.Report");
06. if (_file.Count <= 0) { return; }
07. DataTable dt = new DataTable();
08. dt.Columns.Add(new DataColumn("SampleID",typeof(string)));
09. dt.Columns.Add(new DataColumn("Parameter", typeof(string)));
10. dt.Columns.Add(new DataColumn("Value", typeof(string)));
11. dt.Columns.Add(new DataColumn("Date", typeof(string)));
12. dt.Columns.Add(new DataColumn("ผู้วิเคราะห์", typeof(string)));
13. dt.Columns.Add(new DataColumn("Seleced", typeof(Boolean)));
14. for(int f = 0;f < _file.Count-1;f++)
15. {
16. dgvmgKg.DataSource = GetTable("SELECT * FROM `mg_Kg$Print_Area`", _file[f]).DefaultView;
17. dgvmgL.DataSource = GetTable("SELECT * FROM `mg_L$Print_Area`", _file[f]).DefaultView;
18. for (int i = 0; i < this.dgvmgL.RowCount - 1; i++)
19. {
20. if (this.dgvmgL[this.dgvmgL.ColumnCount - 1, i].Value.ToString().Trim().Length != 0)
21. {
22. DataRow dr = dt.NewRow();
23. dr["SampleID"] = this.dgvmgL[this.dgvmgL.ColumnCount - 6, i].Value.ToString().Trim();
24. dr["Parameter"] = this.dgvmgL[this.dgvmgL.ColumnCount - 5, i].Value.ToString().Trim();
25. dr["Value"] = this.dgvmgL[this.dgvmgL.ColumnCount - 4, i].Value.ToString().Trim();
26. dr["Date"] = this.dgvmgL[this.dgvmgL.ColumnCount - 3, i].Value.ToString().Trim();
27. dr["ผู้วิเคราะห์"] = this.dgvmgL[this.dgvmgL.ColumnCount - 2, i].Value.ToString().Trim();
28. dr["Seleced"] = true;
29. dt.Rows.Add(dr);
30.
31. }
32. }
33.
34. for (int i = 0; i < this.dgvmgKg.RowCount - 1; i++)
35. {
36. if (this.dgvmgKg[this.dgvmgKg.ColumnCount - 1, i].Value.ToString().Trim().Length != 0)
37. {
38. DataRow dr = dt.NewRow();
39. dr["SampleID"] = this.dgvmgKg[this.dgvmgKg.ColumnCount - 6, i].Value.ToString().Trim();
40. dr["Parameter"] = this.dgvmgKg[this.dgvmgKg.ColumnCount - 5, i].Value.ToString().Trim();
41. dr["Value"] = this.dgvmgKg[this.dgvmgKg.ColumnCount - 4, i].Value.ToString().Trim();
42. dr["Date"] = this.dgvmgKg[this.dgvmgKg.ColumnCount - 3, i].Value.ToString().Trim();
43. dr["ผู้วิเคราะห์"] = this.dgvmgKg[this.dgvmgKg.ColumnCount - 2, i].Value.ToString().Trim();
44. dr["Seleced"] = true;
45. dt.Rows.Add(dr);
46. }
47. }
48. }
49. dt.Select("", "SampleID ASC");
50. dataGridView1.DataSource =dt ;
51. Cursor = Cursors.Default;
52. }
