ASTMStandardABCDDS.cs 33 KB

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