ASTMStandardABCDDS.cs 29 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760
  1. using System;
  2. using System.Collections.Generic;
  3. using System.ComponentModel;
  4. using System.Drawing;
  5. using System.Data;
  6. using System.Linq;
  7. using System.Text;
  8. using System.Threading.Tasks;
  9. using System.Windows.Forms;
  10. using OTSIncAReportMailInterface;
  11. using OTSINTERFACE;
  12. using OTSIncAReportGrids.OTSIncAReportGridsFuncation;
  13. using System.Collections;
  14. using OTSIncAReportApp.SysMgrTools;
  15. namespace OTSIncAReportGrids
  16. {
  17. public partial class ASTMStandardABCDDS : UserControl
  18. {
  19. #region 全局变量
  20. //设置数据表
  21. public DataTable m_dt_A = new DataTable();
  22. public DataTable m_dt_B = new DataTable();
  23. public DataTable m_dt_C = new DataTable();
  24. public DataTable m_dt_D = new DataTable();
  25. public DataTable m_dt_DS = new DataTable();
  26. //底层相关,项目操作管理类
  27. COTSReportProjFileMgrClr m_COTSReportProjFileMgrClr = null;
  28. //日志类
  29. //public NSLogFunExport.CFunExportClass m_LogFunExport = null;
  30. //日志文件名
  31. const String m_csFileName = "OTSReportAppLog";
  32. //底层操作类
  33. OTSIncAReportGridsFun m_OTSIncAReportGridsFun = null;
  34. //获取从框架得到的底层计算结果,国标表A
  35. List<CGridDataClr> m_list_cgriddataclr_A = null;
  36. //获取从框架得到的底层计算结果,国标表B
  37. List<CGridDataClr> m_list_cgriddataclr_B = null;
  38. //获取从框架得到的底层计算结果,国标表C
  39. List<CGridDataClr> m_list_cgriddataclr_C = null;
  40. //获取从框架得到的底层计算结果,国标表D
  41. List<CGridDataClr> m_list_cgriddataclr_D = null;
  42. //获取从框架得到的底层计算结果,国标表DS
  43. List<CGridDataClr> m_list_cgriddataclr_DS = null;
  44. //定义整个一组返回List
  45. List<CGridDataClr> m_list_ALL = null;
  46. //接收底层数据
  47. public List<CGridDataClr> DataAll;
  48. //一个数据源包含几个列数的记录数
  49. private int m_oneresult_columnscount_A = 3;
  50. private int m_oneresult_columnscount_B = 3;
  51. private int m_oneresult_columnscount_C = 3;
  52. private int m_oneresult_columnscount_D = 3;
  53. private int m_oneresult_columnscount_DS = 3;
  54. #endregion
  55. #region 自定义方法
  56. private void SetDataGridViewStyleAll()
  57. {
  58. //用户不能调整标题的高度
  59. Gview_gzA.ColumnHeadersHeightSizeMode = DataGridViewColumnHeadersHeightSizeMode.DisableResizing;
  60. //用户不能调整 行高
  61. Gview_gzA.AllowUserToResizeRows = false;
  62. //点击选择整行
  63. Gview_gzA.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
  64. //居中显示
  65. System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle1 = new System.Windows.Forms.DataGridViewCellStyle();
  66. dataGridViewCellStyle1.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter;
  67. Gview_gzA.DefaultCellStyle = dataGridViewCellStyle1;
  68. Gview_gzA.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
  69. //再次重覆禁用拖动表头高度,居然有效果了
  70. Gview_gzA.ColumnHeadersHeightSizeMode = DataGridViewColumnHeadersHeightSizeMode.DisableResizing;
  71. //设置grid可以复制
  72. Gview_gzA.ClipboardCopyMode = DataGridViewClipboardCopyMode.EnableAlwaysIncludeHeaderText;
  73. }
  74. /// <summary>
  75. /// 设置DataGridView样式,B类表
  76. /// </summary>
  77. private void SetDataGridViewStyleB()
  78. {
  79. //用户不能调整标题的高度
  80. Gview_gzB.ColumnHeadersHeightSizeMode = DataGridViewColumnHeadersHeightSizeMode.DisableResizing;
  81. //用户不能调整 行高
  82. Gview_gzB.AllowUserToResizeRows = false;
  83. //点击选择整行
  84. Gview_gzB.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
  85. //居中显示
  86. System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle1 = new System.Windows.Forms.DataGridViewCellStyle();
  87. dataGridViewCellStyle1.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter;
  88. Gview_gzB.DefaultCellStyle = dataGridViewCellStyle1;
  89. Gview_gzB.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
  90. //再次重覆禁用拖动表头高度,居然有效果了
  91. Gview_gzB.ColumnHeadersHeightSizeMode = DataGridViewColumnHeadersHeightSizeMode.DisableResizing;
  92. //设置grid可以复制
  93. Gview_gzB.ClipboardCopyMode = DataGridViewClipboardCopyMode.EnableAlwaysIncludeHeaderText;
  94. //设置每列的宽度
  95. Gview_gzB.Columns[0].Width = 40;//第一列序号的宽度设置一下吧,要不太丑
  96. //设置序号列不排序
  97. Gview_gzB.Columns[0].SortMode = DataGridViewColumnSortMode.NotSortable;
  98. //设置序号列不可以设置宽度
  99. Gview_gzB.Columns[0].Resizable = DataGridViewTriState.False;
  100. }
  101. /// <summary>
  102. /// 设置DataGridView样式,C类表
  103. /// </summary>
  104. private void SetDataGridViewStyleC()
  105. {
  106. //用户不能调整标题的高度
  107. Gview_gzC.ColumnHeadersHeightSizeMode = DataGridViewColumnHeadersHeightSizeMode.DisableResizing;
  108. //用户不能调整 行高
  109. Gview_gzC.AllowUserToResizeRows = false;
  110. //点击选择整行
  111. Gview_gzC.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
  112. //居中显示
  113. System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle1 = new System.Windows.Forms.DataGridViewCellStyle();
  114. dataGridViewCellStyle1.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter;
  115. Gview_gzC.DefaultCellStyle = dataGridViewCellStyle1;
  116. Gview_gzC.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
  117. //再次重覆禁用拖动表头高度,居然有效果了
  118. Gview_gzC.ColumnHeadersHeightSizeMode = DataGridViewColumnHeadersHeightSizeMode.DisableResizing;
  119. //设置grid可以复制
  120. Gview_gzC.ClipboardCopyMode = DataGridViewClipboardCopyMode.EnableAlwaysIncludeHeaderText;
  121. //设置每列的宽度
  122. Gview_gzC.Columns[0].Width = 40;//第一列序号的宽度设置一下吧,要不太丑
  123. //设置序号列不排序
  124. Gview_gzC.Columns[0].SortMode = DataGridViewColumnSortMode.NotSortable;
  125. //设置序号列不可以设置宽度
  126. Gview_gzC.Columns[0].Resizable = DataGridViewTriState.False;
  127. }
  128. /// <summary>
  129. /// 设置DataGridView样式,D类表
  130. /// </summary>
  131. private void SetDataGridViewStyleD()
  132. {
  133. //用户不能调整标题的高度
  134. Gview_gzD.ColumnHeadersHeightSizeMode = DataGridViewColumnHeadersHeightSizeMode.DisableResizing;
  135. //用户不能调整 行高
  136. Gview_gzD.AllowUserToResizeRows = false;
  137. //改变行的高度;
  138. //Gview_gz.RowTemplate.Height = 20;
  139. //点击选择整行
  140. Gview_gzD.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
  141. //居中显示
  142. System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle1 = new System.Windows.Forms.DataGridViewCellStyle();
  143. dataGridViewCellStyle1.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter;
  144. Gview_gzD.DefaultCellStyle = dataGridViewCellStyle1;
  145. Gview_gzD.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
  146. //再次重覆禁用拖动表头高度,居然有效果了
  147. Gview_gzD.ColumnHeadersHeightSizeMode = DataGridViewColumnHeadersHeightSizeMode.DisableResizing;
  148. //设置grid可以复制
  149. Gview_gzD.ClipboardCopyMode = DataGridViewClipboardCopyMode.EnableAlwaysIncludeHeaderText;
  150. //设置每列的宽度
  151. Gview_gzD.Columns[0].Width = 40;//第一列序号的宽度设置一下吧,要不太丑
  152. //设置序号列不排序
  153. Gview_gzD.Columns[0].SortMode = DataGridViewColumnSortMode.NotSortable;
  154. //设置序号列不可以设置宽度
  155. Gview_gzD.Columns[0].Resizable = DataGridViewTriState.False;
  156. }
  157. /// <summary>
  158. /// 设置DataGridView样式,DS类表
  159. /// </summary>
  160. private void SetDataGridViewStyleDS()
  161. {
  162. //用户不能调整标题的高度
  163. Gview_gzDS.ColumnHeadersHeightSizeMode = DataGridViewColumnHeadersHeightSizeMode.DisableResizing;
  164. //用户不能调整 行高
  165. Gview_gzDS.AllowUserToResizeRows = false;
  166. //点击选择整行
  167. Gview_gzDS.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
  168. //居中显示
  169. System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle1 = new System.Windows.Forms.DataGridViewCellStyle();
  170. dataGridViewCellStyle1.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter;
  171. Gview_gzDS.DefaultCellStyle = dataGridViewCellStyle1;
  172. Gview_gzDS.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
  173. //再次重覆禁用拖动表头高度,居然有效果了
  174. Gview_gzDS.ColumnHeadersHeightSizeMode = DataGridViewColumnHeadersHeightSizeMode.DisableResizing;
  175. //设置grid可以复制
  176. Gview_gzDS.ClipboardCopyMode = DataGridViewClipboardCopyMode.EnableAlwaysIncludeHeaderText;
  177. //设置每列的宽度
  178. Gview_gzDS.Columns[0].Width = 40;//第一列序号的宽度设置一下吧,要不太丑
  179. //设置序号列不排序
  180. Gview_gzDS.Columns[0].SortMode = DataGridViewColumnSortMode.NotSortable;
  181. //设置序号列不可以设置宽度
  182. Gview_gzDS.Columns[0].Resizable = DataGridViewTriState.False;
  183. }
  184. #endregion
  185. #region 窗体加载及初始化
  186. public ASTMStandardABCDDS()
  187. {
  188. InitializeComponent();
  189. }
  190. /// <summary>
  191. /// 国标报表,构造函数,接收A,B,C,D,DS五种结果,并进行显示
  192. /// </summary>
  193. /// <param name="in_sec"></param>
  194. /// <param name="in_Cotsreportprojfilemgrclr"></param>
  195. /// <param name="in_list_CGridDataClrAll"></param> //all 代表A、B、C、D、DS按顺序得表
  196. public string ColumnName;
  197. public string RowName;
  198. #region 国际化语言
  199. Language lan;
  200. Hashtable table;
  201. #endregion
  202. public ASTMStandardABCDDS(COTSReportProjFileMgrClr in_Cotsreportprojfilemgrclr, List<CGridDataClr> in_list_CGridDataClrAll)
  203. {
  204. DataAll = in_list_CGridDataClrAll;
  205. //获取报告项目类对象
  206. m_COTSReportProjFileMgrClr = in_Cotsreportprojfilemgrclr;
  207. m_list_cgriddataclr_A = in_list_CGridDataClrAll.GetRange(0, 1);
  208. m_list_cgriddataclr_B = in_list_CGridDataClrAll.GetRange(1, 1);
  209. m_list_cgriddataclr_C = in_list_CGridDataClrAll.GetRange(2, 1);
  210. m_list_cgriddataclr_D = in_list_CGridDataClrAll.GetRange(3, 1);
  211. m_list_cgriddataclr_DS = in_list_CGridDataClrAll.GetRange(4, 1);
  212. m_list_ALL = in_list_CGridDataClrAll;
  213. InitializeComponent();
  214. #region 国际化语言
  215. lan = new Language(this);
  216. table = lan.GetNameTable(this.Name);
  217. #endregion
  218. }
  219. private void ASTMStandardABCDDS_Load(object sender, EventArgs e)
  220. {
  221. //从底层结果类对象中,分解出数据保存到datatable中
  222. if (m_list_ALL.Count > 6)
  223. {
  224. int SouseData = (m_COTSReportProjFileMgrClr.GetSmplMsrResultMgrs().Count) * 5;
  225. for (int g = 0; g < m_COTSReportProjFileMgrClr.GetSmplMsrResultMgrs().Count; g++)
  226. {
  227. for (int i = 0; i < 5; i++)
  228. {
  229. DataTable dt = new DataTable();
  230. DataColumn cc = new DataColumn();
  231. int q = g * 6 + i;
  232. dt = ChineseStandardABCD_GetDataTable_Total(DataAll.GetRange(q, 1), out m_oneresult_columnscount_A);
  233. DataGridView aa = new DataGridView();
  234. int start = 40;
  235. int end = 0;
  236. end = 150 * q;
  237. aa.Location = new Point(start, end);
  238. aa.Width = panel1.Width;
  239. aa.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
  240. aa.BackgroundColor = Color.White;
  241. panel1.Controls.Add(aa);
  242. aa.DataSource = dt;
  243. aa.Name = i.ToString();
  244. Label bb = new Label();
  245. int startLabel = 0;
  246. int endLabel = 0;
  247. endLabel = 150 * q;
  248. bb.Location = new Point(startLabel, endLabel);
  249. bb.Width = 75;
  250. for (int t = 0; t < SouseData; t++)
  251. {
  252. if (i == t * 5)
  253. {
  254. bb.Text = table["label1"].ToString();
  255. break;
  256. }
  257. if (i == t * 5 + 1)
  258. {
  259. bb.Text = table["label2"].ToString();
  260. }
  261. if (i == t * 5 + 2)
  262. {
  263. bb.Text = table["label3"].ToString();
  264. }
  265. if (i == t * 5 + 3)
  266. {
  267. bb.Text = table["label4"].ToString();
  268. }
  269. if (i == t * 5 + 4)
  270. {
  271. bb.Text = table["label5"].ToString();
  272. }
  273. }
  274. bb.Font = new Font(bb.Font.Name, 12, FontStyle.Bold | FontStyle.Underline);
  275. panel1.Controls.Add(bb);
  276. }
  277. }
  278. Gview_gzA.Visible = false;
  279. Gview_gzB.Visible = false;
  280. Gview_gzC.Visible = false;
  281. Gview_gzD.Visible = false;
  282. Gview_gzDS.Visible = false;
  283. label1.Visible = false;
  284. label2.Visible = false;
  285. label3.Visible = false;
  286. label4.Visible = false;
  287. label5.Visible = false;
  288. Invalidate();
  289. }
  290. else
  291. {
  292. m_dt_A = ChineseStandardABCD_GetDataTable_Total(m_list_cgriddataclr_A, out m_oneresult_columnscount_A);
  293. m_dt_B = ChineseStandardABCD_GetDataTable_Total(m_list_cgriddataclr_B, out m_oneresult_columnscount_B);
  294. m_dt_C = ChineseStandardABCD_GetDataTable_Total(m_list_cgriddataclr_C, out m_oneresult_columnscount_C);
  295. m_dt_D = ChineseStandardABCD_GetDataTable_Total(m_list_cgriddataclr_D, out m_oneresult_columnscount_D);
  296. m_dt_DS = ChineseStandardABCD_GetDataTable_Total(m_list_cgriddataclr_DS, out m_oneresult_columnscount_DS);
  297. Gview_gzA.DataSource = m_dt_A;
  298. for (int i = 0; i < 13; i++)
  299. {
  300. Gview_gzA.Columns[i].Width = 68;
  301. }
  302. Gview_gzB.DataSource = m_dt_B;
  303. for (int i = 0; i < 13; i++)
  304. {
  305. Gview_gzB.Columns[i].Width = 68;
  306. }
  307. Gview_gzC.DataSource = m_dt_C;
  308. for (int i = 0; i < 13; i++)
  309. {
  310. Gview_gzC.Columns[i].Width = 68;
  311. }
  312. Gview_gzD.DataSource = m_dt_D;
  313. for (int i = 0; i < 13; i++)
  314. {
  315. Gview_gzD.Columns[i].Width = 68;
  316. }
  317. Gview_gzDS.DataSource = m_dt_DS;
  318. Gview_gzA.Width = panel1.Width;
  319. Gview_gzB.Width = panel1.Width;
  320. Gview_gzC.Width = panel1.Width;
  321. Gview_gzD.Width = panel1.Width;
  322. Gview_gzDS.Width = panel1.Width;
  323. }
  324. Invalidate();
  325. }
  326. #endregion
  327. #region 相关事件
  328. /// <summary>
  329. /// 复制选择区域,A
  330. /// </summary>
  331. public void CopySelected_A()
  332. {
  333. //复制选择区域
  334. object oo = Gview_gzA.GetClipboardContent();
  335. Clipboard.SetDataObject(Gview_gzA.GetClipboardContent());
  336. }
  337. /// <summary>
  338. /// 复制选择区域,B
  339. /// </summary>
  340. public void CopySelected_B()
  341. {
  342. //复制选择区域
  343. object oo = Gview_gzB.GetClipboardContent();
  344. Clipboard.SetDataObject(Gview_gzA.GetClipboardContent());
  345. }
  346. /// <summary>
  347. /// 复制选择区域,C
  348. /// </summary>
  349. public void CopySelected_C()
  350. {
  351. //复制选择区域
  352. object oo = Gview_gzC.GetClipboardContent();
  353. Clipboard.SetDataObject(Gview_gzA.GetClipboardContent());
  354. }
  355. /// <summary>
  356. /// 复制选择区域,D
  357. /// </summary>
  358. public void CopySelected_D()
  359. {
  360. //复制选择区域
  361. object oo = Gview_gzD.GetClipboardContent();
  362. Clipboard.SetDataObject(Gview_gzA.GetClipboardContent());
  363. }
  364. /// <summary>
  365. /// 复制选择区域,DS
  366. /// </summary>
  367. public void CopySelected_DS()
  368. {
  369. //复制选择区域
  370. object oo = Gview_gzDS.GetClipboardContent();
  371. Clipboard.SetDataObject(Gview_gzA.GetClipboardContent());
  372. }
  373. /// <summary>
  374. /// 复制所有,A
  375. /// </summary>
  376. public void CopyAll_A()
  377. {
  378. Gview_gzA.SelectAll();
  379. Clipboard.SetDataObject(Gview_gzA.GetClipboardContent());
  380. }
  381. /// <summary>
  382. /// 复制所有,B
  383. /// </summary>
  384. public void CopyAll_B()
  385. {
  386. Gview_gzB.SelectAll();
  387. Clipboard.SetDataObject(Gview_gzB.GetClipboardContent());
  388. }
  389. /// <summary>
  390. /// 复制所有,C
  391. /// </summary>
  392. public void CopyAll_C()
  393. {
  394. Gview_gzC.SelectAll();
  395. Clipboard.SetDataObject(Gview_gzC.GetClipboardContent());
  396. }
  397. /// <summary>
  398. /// 复制所有,D
  399. /// </summary>
  400. public void CopyAll_D()
  401. {
  402. Gview_gzD.SelectAll();
  403. Clipboard.SetDataObject(Gview_gzD.GetClipboardContent());
  404. }
  405. /// <summary>
  406. /// 复制所有,DS
  407. /// </summary>
  408. public void CopyAll_DS()
  409. {
  410. Gview_gzDS.SelectAll();
  411. Clipboard.SetDataObject(Gview_gzDS.GetClipboardContent());
  412. }
  413. private void ToolStripMenuItem1_Click(object sender, EventArgs e)
  414. {
  415. //A,复制整个表
  416. CopyAll_A();
  417. }
  418. private void ToolStripMenuItem2_Click(object sender, EventArgs e)
  419. {
  420. //A,复制选择区域
  421. CopySelected_A();
  422. }
  423. private void toolStripMenuItem4_Click(object sender, EventArgs e)
  424. {
  425. //B,复制整个表
  426. CopyAll_B();
  427. }
  428. private void toolStripMenuItem5_Click(object sender, EventArgs e)
  429. {
  430. //B,复制选择区域
  431. CopySelected_B();
  432. }
  433. private void toolStripMenuItem7_Click(object sender, EventArgs e)
  434. {
  435. //C,复制整个表
  436. CopyAll_C();
  437. }
  438. private void toolStripMenuItem8_Click(object sender, EventArgs e)
  439. {
  440. //C,复制选择区域
  441. CopySelected_C();
  442. }
  443. private void toolStripMenuItem10_Click(object sender, EventArgs e)
  444. {
  445. //D,复制整个表
  446. CopyAll_D();
  447. }
  448. private void toolStripMenuItem11_Click(object sender, EventArgs e)
  449. {
  450. //D,复制选择区域
  451. CopySelected_D();
  452. }
  453. private void toolStripMenuItem13_Click(object sender, EventArgs e)
  454. {
  455. //DS,复制整个表
  456. CopyAll_DS();
  457. }
  458. private void toolStripMenuItem14_Click(object sender, EventArgs e)
  459. {
  460. //DS,复制选择区域
  461. CopySelected_DS();
  462. }
  463. #endregion
  464. #region 获取向导出模块提供的DataTable和GridView对象
  465. /// <summary>
  466. /// 获取到该模块输出后形成的DataTable,和GridView
  467. /// </summary>
  468. /// <param name="out_dt"></param>
  469. /// <param name="out_dg"></param>
  470. public void GetDataTableAndGridView(out DataTable out_dtA, out DataTable out_dtB, out DataTable out_dtC, out DataTable out_dtD, out DataTable out_dtDS,
  471. out DataGridView out_dgA, out DataGridView out_dgB, out DataGridView out_dgC, out DataGridView out_dgD, out DataGridView out_dgDS)
  472. {
  473. //从panel中找出前5个datagridview,然后进行输出
  474. foreach (Control ctl in this.panel1.Controls)
  475. {
  476. if (ctl.Name == "0")
  477. {
  478. this.Gview_gzA = (DataGridView)ctl;
  479. }
  480. if (ctl.Name == "1")
  481. {
  482. this.Gview_gzB = (DataGridView)ctl;
  483. }
  484. if (ctl.Name == "2")
  485. {
  486. this.Gview_gzC = (DataGridView)ctl;
  487. }
  488. if (ctl.Name == "3")
  489. {
  490. this.Gview_gzD = (DataGridView)ctl;
  491. }
  492. if (ctl.Name == "4")
  493. {
  494. this.Gview_gzDS = (DataGridView)ctl;
  495. }
  496. }
  497. out_dtA = m_dt_A;
  498. out_dgA = this.Gview_gzA;
  499. out_dtB = m_dt_B;
  500. out_dgB = this.Gview_gzB;
  501. out_dtC = m_dt_C;
  502. out_dgC = this.Gview_gzC;
  503. out_dtD = m_dt_D;
  504. out_dgD = this.Gview_gzD;
  505. out_dtDS = m_dt_DS;
  506. out_dgDS = this.Gview_gzDS;
  507. }
  508. #endregion
  509. #region clr加载数据部分
  510. public DataTable ChineseStandardABCD_GetDataTable_Total(List<CGridDataClr> in_list_cgriddataclr, out int oneresult_columncount)
  511. {
  512. oneresult_columncount = 1;//一个数据源的跨度,计算出一个数据源包含几个列
  513. //创建一个临时表
  514. DataTable ret_dt = new DataTable();
  515. //判断传入的数据对象是否为空
  516. if (in_list_cgriddataclr == null)
  517. {
  518. string str1 = "传入分解表格数据的CGridDataClr对象为空!";
  519. str1 = table["str1"].ToString();
  520. //log.Error("(OTSIncAReportGridsFun.ChineseStandardABCD_GetDataTable_Total)" + str1);
  521. return ret_dt;
  522. }
  523. #region 根据返回的结构创建DataTable的结构---------------------------------------------
  524. for (int i = 0; i < in_list_cgriddataclr.Count(); i++)
  525. {
  526. //分解结果内容
  527. List<CGridColumnClr> list_cgridcolumnclrs = new List<CGridColumnClr>();
  528. list_cgridcolumnclrs = in_list_cgriddataclr[i].GetGridColumnList(); //获取各列
  529. //单个数据源包含几个列的跨度
  530. if (oneresult_columncount < list_cgridcolumnclrs.Count())
  531. oneresult_columncount = list_cgridcolumnclrs.Count();
  532. if (in_list_cgriddataclr.Count > 1)
  533. {
  534. //创建DT的列,多个数据源,为每个字段带上索引号
  535. foreach (CGridColumnClr ls_cgridcolumnclr in list_cgridcolumnclrs)
  536. {
  537. string ls_fl_strName = ls_cgridcolumnclr.GetName();
  538. //通过获取到的列,创建表的列
  539. ret_dt.Columns.Add(ls_fl_strName + "(" + (i + 1).ToString() + ")");
  540. }
  541. }
  542. else
  543. {
  544. //创建DT的列,单个数据源,不带索引号
  545. foreach (CGridColumnClr ls_cgridcolumnclr in list_cgridcolumnclrs)
  546. {
  547. string ls_fl_strName = ls_cgridcolumnclr.GetName();
  548. //通过获取到的列,创建表的列
  549. ret_dt.Columns.Add(ls_fl_strName);
  550. }
  551. }
  552. }
  553. #endregion
  554. #region 再创建表的行------------------------------------------------------------------
  555. //取最大的rowlistcount,要不然,不知道这底层返回的数据居然还有2,2,3这样的行数据
  556. int maxrownumber = 0;
  557. for (int i = 0; i < in_list_cgriddataclr.Count(); i++)
  558. {
  559. //分解结果内容
  560. List<CGridColumnClr> list_cgridcolumnclrs = new List<CGridColumnClr>();
  561. list_cgridcolumnclrs = in_list_cgriddataclr[i].GetGridColumnList(); //获取各列
  562. //创建DT的行
  563. if (list_cgridcolumnclrs != null)
  564. {
  565. foreach (CGridColumnClr ls_cgridcolumnclr in list_cgridcolumnclrs)
  566. {
  567. if (maxrownumber < ls_cgridcolumnclr.GetRowList().Count())
  568. {
  569. maxrownumber = ls_cgridcolumnclr.GetRowList().Count();
  570. }
  571. }
  572. }
  573. }
  574. for (int k = 0; k < maxrownumber; k++)
  575. {
  576. DataRow dr = ret_dt.NewRow();
  577. ret_dt.Rows.Add(dr);
  578. }
  579. #endregion
  580. #region //再次重新分解,先分解列,然后将获取到的各行各列的数据,填充到相应的位置上---
  581. for (int i = 0; i < in_list_cgriddataclr.Count(); i++)
  582. {
  583. //分解结果内容
  584. List<CGridColumnClr> list_cgridcolumnclrs = new List<CGridColumnClr>();
  585. list_cgridcolumnclrs = in_list_cgriddataclr[i].GetGridColumnList(); //获取各列
  586. //再次重新分解,先分解列,然后将获取到的
  587. for (int k = 0; k < list_cgridcolumnclrs.Count(); k++)
  588. {
  589. string ls_fl_strName = list_cgridcolumnclrs[k].GetName();
  590. List<CGridRowClr> ls_list_cgridrowclr = new List<CGridRowClr>();
  591. ls_list_cgridrowclr = list_cgridcolumnclrs[k].GetRowList();
  592. for (int j = 0; j < ls_list_cgridrowclr.Count(); j++)
  593. {
  594. //先判断该行该单元格的数据类型
  595. string str_value = "";//因为显示只需要对字符串进行操作就可以了,所以将底层获取到的数据,除了颗粒类型外的都转成string
  596. switch (ls_list_cgridrowclr[j].GetDataType())
  597. {
  598. case 0:
  599. //string
  600. str_value = ls_list_cgridrowclr[j].GetStringValue();
  601. ret_dt.Rows[j][k + i * oneresult_columncount] = str_value;
  602. break;
  603. case 1:
  604. //该元素含量表没有需要显示的颗粒图像
  605. //ret_dt.Rows[j][k+i*oneresult_columncount] = GetBitmapByParticleList(ls_list_cgridrowclr[k].GetParticle());
  606. break;
  607. case 2:
  608. //int
  609. str_value = ls_list_cgridrowclr[j].GetIntValue().ToString();
  610. ret_dt.Rows[j][k + i * oneresult_columncount] = str_value;
  611. break;
  612. case 3:
  613. //float
  614. str_value = ls_list_cgridrowclr[j].GetDoubleValue().ToString("0.00");
  615. ret_dt.Rows[j][k + i * oneresult_columncount] = str_value;
  616. break;
  617. default:
  618. str_value = "";
  619. ret_dt.Rows[j][k + i * oneresult_columncount] = str_value;
  620. break;
  621. }
  622. }
  623. }
  624. }
  625. #endregion
  626. return ret_dt;
  627. }
  628. #endregion
  629. }
  630. }