ChineseStandardABCDDS.cs 34 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872
  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 OTSCLRINTERFACE;
  11. using System.Collections;
  12. using OTSCommon;
  13. namespace OTSIncAReportGB
  14. {
  15. public partial class ChineseStandardABCDDS : 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_ReportMgrClr = 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 ChineseStandardABCDDS()
  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. #region 国际化语言
  192. Language lan;
  193. Hashtable table;
  194. #endregion
  195. public ChineseStandardABCDDS(CReportMgrClr in_Cotsreportprojfilemgrclr, List<CGridDataClr> in_list_CGridDataClrAll)
  196. {
  197. DataAll = in_list_CGridDataClrAll;
  198. //获取报告项目类对象
  199. m_ReportMgrClr = in_Cotsreportprojfilemgrclr;
  200. m_list_cgriddataclr_A = in_list_CGridDataClrAll.GetRange(0, 1);
  201. m_list_cgriddataclr_B = in_list_CGridDataClrAll.GetRange(1, 1);
  202. m_list_cgriddataclr_C = in_list_CGridDataClrAll.GetRange(2, 1);
  203. m_list_cgriddataclr_D = in_list_CGridDataClrAll.GetRange(3, 1);
  204. m_list_cgriddataclr_DS = in_list_CGridDataClrAll.GetRange(4, 1);
  205. m_list_ALL = in_list_CGridDataClrAll;
  206. //初始化底层操作类
  207. // m_OTSIncAReportGridsFun = new OTSIncAReportGridsFun(m_COTSReportProjFileMgrClr, m_list_cgriddataclr_A);
  208. InitializeComponent();
  209. #region 国际化语言
  210. lan = new Language(this);
  211. table = lan.GetNameTable(this.Name);
  212. #endregion
  213. log_1.Text = "";
  214. log_2.Text = "";
  215. log_3.Text = "";
  216. log_4.Text = "";
  217. log_5.Text = "";
  218. log_1_1.Text = "";
  219. log_2_1.Text = "";
  220. log_3_1.Text = "";
  221. log_4_1.Text = "";
  222. log_5_1.Text = "";
  223. }
  224. private void ChineseStandardABCDDS_Load(object sender, EventArgs e)
  225. {
  226. //从底层结果类对象中,分解出数据保存到datatable中
  227. if (m_list_ALL.Count > 6)
  228. {
  229. int SouseData = (m_ReportMgrClr.GetSmplMsrResultMgrs().Count) * 5;
  230. for (int g = 0; g < m_ReportMgrClr.GetSmplMsrResultMgrs().Count; g++)
  231. {
  232. for (int i = 0; i < 5; i++)
  233. {
  234. DataTable dt ;
  235. //DataColumn cc ;
  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 ;
  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. DataView dv = m_dt_DS.DefaultView;
  303. dv.Sort = "Grade desc";
  304. DataTable dt_DS_data = dv.ToTable();
  305. Gview_gzA.DataSource = m_dt_A;
  306. for (int i = 0; i < 13; i++)
  307. {
  308. Gview_gzA.Columns[i].Width = 68;
  309. }
  310. Gview_gzB.DataSource = m_dt_B;
  311. for (int i = 0; i < 13; i++)
  312. {
  313. Gview_gzB.Columns[i].Width = 68;
  314. }
  315. Gview_gzC.DataSource = m_dt_C;
  316. for (int i = 0; i < 13; i++)
  317. {
  318. Gview_gzC.Columns[i].Width = 68;
  319. }
  320. Gview_gzD.DataSource = m_dt_D;
  321. for (int i = 0; i < 13; i++)
  322. {
  323. Gview_gzD.Columns[i].Width = 68;
  324. }
  325. //Gview_gzDS.DataSource = m_dt_DS;
  326. Gview_gzDS.DataSource = dt_DS_data;
  327. Gview_gzA.Width = panel1.Width;
  328. Gview_gzB.Width = panel1.Width;
  329. Gview_gzC.Width = panel1.Width;
  330. Gview_gzD.Width = panel1.Width;
  331. Gview_gzDS.Width = panel1.Width;
  332. int it = 0;
  333. if(DetermineWhetherImprovementIsNeeded("A类", m_dt_A))
  334. {
  335. str_result = str_result+ "夹杂物评级达到2.0:表明钢中的MnS或硫化物夹杂物控制不够理想。" +
  336. "针对这一问题,我们建议您在相关工艺上进行优化和改进。";
  337. LabelAssignment(it);
  338. it++;
  339. str_result = "";
  340. }
  341. if(DetermineWhetherImprovementIsNeeded("B类", m_dt_B))
  342. {
  343. str_result = str_result+"夹杂物评级达到2.0:表明钢中的不连续串(条)氧化物夹杂物控制不够理想。" +
  344. "针对这一问题,我们建议您在相关工艺上进行优化和改进。" ;
  345. LabelAssignment(it);
  346. it++;
  347. str_result = "";
  348. }
  349. if(DetermineWhetherImprovementIsNeeded("C类", m_dt_C))
  350. {
  351. str_result = str_result+"夹杂物评级达到2.0:表明钢中的串(条)状氧化物夹杂物控制不够理想。" +
  352. "针对这一问题,我们建议您在相关工艺上进行优化和改进。";
  353. LabelAssignment(it);
  354. it++;
  355. str_result = "";
  356. }
  357. if(DetermineWhetherImprovementIsNeeded("D类", m_dt_D))
  358. {
  359. str_result = str_result+"夹杂物评级达到2.0:表明钢中的单颗粒球状氧化物夹杂物控制不够理想。" +
  360. "针对这一问题,我们建议您在相关工艺上进行优化和改进。";
  361. LabelAssignment(it);
  362. it++;
  363. str_result = "";
  364. }
  365. }
  366. Invalidate();
  367. }
  368. private void LabelAssignment(int it)
  369. {
  370. if (it == 0)
  371. {
  372. log_1.Text = str_result;
  373. log_1_1.Text = "为了获取更具体的改进措施,您可以随时联系我们公司的软件售后服务团队," +
  374. "我们的炼钢工艺专家将为您提供专业的建议和支持。";
  375. }
  376. else if (it == 1)
  377. {
  378. log_2.Text = str_result;
  379. log_2_1.Text = "为了获取更具体的改进措施,您可以随时联系我们公司的软件售后服务团队," +
  380. "我们的炼钢工艺专家将为您提供专业的建议和支持。";
  381. }
  382. else if (it == 2)
  383. {
  384. log_3.Text = str_result;
  385. log_3_1.Text = "为了获取更具体的改进措施,您可以随时联系我们公司的软件售后服务团队," +
  386. "我们的炼钢工艺专家将为您提供专业的建议和支持。";
  387. }
  388. else if (it == 3)
  389. {
  390. log_4.Text = str_result;
  391. log_4_1.Text = "为了获取更具体的改进措施,您可以随时联系我们公司的软件售后服务团队," +
  392. "我们的炼钢工艺专家将为您提供专业的建议和支持。";
  393. }
  394. }
  395. private bool DetermineWhetherImprovementIsNeeded(string str, DataTable data)
  396. {
  397. string Thin = ""; string Thick = ""; string OverSize = "";
  398. for (int i = 6; i < data.Columns.Count; i++)
  399. {
  400. if (Convert.ToInt32(data.Rows[0][i]) > 0)
  401. {
  402. Thin = "细系";
  403. }
  404. if (Convert.ToInt32(data.Rows[1][i]) > 0)
  405. {
  406. Thick = "粗系";
  407. }
  408. if (Convert.ToInt32(data.Rows[2][i]) > 0)
  409. {
  410. OverSize = "超尺寸";
  411. }
  412. }
  413. if (Thin != "" || Thick != "" || OverSize != "")
  414. {
  415. str_result = str + "的" + Thin + Thick + OverSize ;
  416. return true;
  417. }
  418. return false;
  419. }
  420. #endregion
  421. #region 相关事件
  422. /// <summary>
  423. /// 复制选择区域,A
  424. /// </summary>
  425. public void CopySelected_A()
  426. {
  427. //复制选择区域
  428. object oo = Gview_gzA.GetClipboardContent();
  429. Clipboard.SetDataObject(Gview_gzA.GetClipboardContent());
  430. }
  431. /// <summary>
  432. /// 复制选择区域,B
  433. /// </summary>
  434. public void CopySelected_B()
  435. {
  436. //复制选择区域
  437. object oo = Gview_gzB.GetClipboardContent();
  438. Clipboard.SetDataObject(Gview_gzA.GetClipboardContent());
  439. }
  440. /// <summary>
  441. /// 复制选择区域,C
  442. /// </summary>
  443. public void CopySelected_C()
  444. {
  445. //复制选择区域
  446. object oo = Gview_gzC.GetClipboardContent();
  447. Clipboard.SetDataObject(Gview_gzA.GetClipboardContent());
  448. }
  449. /// <summary>
  450. /// 复制选择区域,D
  451. /// </summary>
  452. public void CopySelected_D()
  453. {
  454. //复制选择区域
  455. object oo = Gview_gzD.GetClipboardContent();
  456. Clipboard.SetDataObject(Gview_gzA.GetClipboardContent());
  457. }
  458. /// <summary>
  459. /// 复制选择区域,DS
  460. /// </summary>
  461. public void CopySelected_DS()
  462. {
  463. //复制选择区域
  464. object oo = Gview_gzDS.GetClipboardContent();
  465. Clipboard.SetDataObject(Gview_gzA.GetClipboardContent());
  466. }
  467. /// <summary>
  468. /// 复制所有,A
  469. /// </summary>
  470. public void CopyAll_A()
  471. {
  472. Gview_gzA.SelectAll();
  473. Clipboard.SetDataObject(Gview_gzA.GetClipboardContent());
  474. }
  475. /// <summary>
  476. /// 复制所有,B
  477. /// </summary>
  478. public void CopyAll_B()
  479. {
  480. Gview_gzB.SelectAll();
  481. Clipboard.SetDataObject(Gview_gzB.GetClipboardContent());
  482. }
  483. /// <summary>
  484. /// 复制所有,C
  485. /// </summary>
  486. public void CopyAll_C()
  487. {
  488. Gview_gzC.SelectAll();
  489. Clipboard.SetDataObject(Gview_gzC.GetClipboardContent());
  490. }
  491. /// <summary>
  492. /// 复制所有,D
  493. /// </summary>
  494. public void CopyAll_D()
  495. {
  496. Gview_gzD.SelectAll();
  497. Clipboard.SetDataObject(Gview_gzD.GetClipboardContent());
  498. }
  499. /// <summary>
  500. /// 复制所有,DS
  501. /// </summary>
  502. public void CopyAll_DS()
  503. {
  504. Gview_gzDS.SelectAll();
  505. Clipboard.SetDataObject(Gview_gzDS.GetClipboardContent());
  506. }
  507. private void ToolStripMenuItem1_Click(object sender, EventArgs e)
  508. {
  509. //A,复制整个表
  510. CopyAll_A();
  511. }
  512. private void ToolStripMenuItem2_Click(object sender, EventArgs e)
  513. {
  514. //A,复制选择区域
  515. CopySelected_A();
  516. }
  517. private void toolStripMenuItem4_Click(object sender, EventArgs e)
  518. {
  519. //B,复制整个表
  520. CopyAll_B();
  521. }
  522. private void toolStripMenuItem5_Click(object sender, EventArgs e)
  523. {
  524. //B,复制选择区域
  525. CopySelected_B();
  526. }
  527. private void toolStripMenuItem7_Click(object sender, EventArgs e)
  528. {
  529. //C,复制整个表
  530. CopyAll_C();
  531. }
  532. private void toolStripMenuItem8_Click(object sender, EventArgs e)
  533. {
  534. //C,复制选择区域
  535. CopySelected_C();
  536. }
  537. private void toolStripMenuItem10_Click(object sender, EventArgs e)
  538. {
  539. //D,复制整个表
  540. CopyAll_D();
  541. }
  542. private void toolStripMenuItem11_Click(object sender, EventArgs e)
  543. {
  544. //D,复制选择区域
  545. CopySelected_D();
  546. }
  547. private void toolStripMenuItem13_Click(object sender, EventArgs e)
  548. {
  549. //DS,复制整个表
  550. CopyAll_DS();
  551. }
  552. private void toolStripMenuItem14_Click(object sender, EventArgs e)
  553. {
  554. //DS,复制选择区域
  555. CopySelected_DS();
  556. }
  557. #endregion
  558. #region 获取向导出模块提供的DataTable和GridView对象
  559. /// <summary>
  560. /// 获取到该模块输出后形成的DataTable,和GridView
  561. /// </summary>
  562. /// <param name="out_dt"></param>
  563. /// <param name="out_dg"></param>
  564. public void GetDataTableAndGridView(out DataTable out_dtA, out DataTable out_dtB, out DataTable out_dtC, out DataTable out_dtD, out DataTable out_dtDS,
  565. out DataGridView out_dgA, out DataGridView out_dgB, out DataGridView out_dgC, out DataGridView out_dgD, out DataGridView out_dgDS)
  566. {
  567. //从panel中找出前5个datagridview,然后进行输出
  568. foreach (Control ctl in this.panel1.Controls)
  569. {
  570. if (ctl.Name == "0")
  571. {
  572. this.Gview_gzA = (DataGridView)ctl;
  573. }
  574. if (ctl.Name == "1")
  575. {
  576. this.Gview_gzB = (DataGridView)ctl;
  577. }
  578. if (ctl.Name == "2")
  579. {
  580. this.Gview_gzC = (DataGridView)ctl;
  581. }
  582. if (ctl.Name == "3")
  583. {
  584. this.Gview_gzD = (DataGridView)ctl;
  585. }
  586. if (ctl.Name == "4")
  587. {
  588. this.Gview_gzDS = (DataGridView)ctl;
  589. }
  590. }
  591. out_dtA = m_dt_A;
  592. out_dgA = this.Gview_gzA;
  593. out_dtB = m_dt_B;
  594. out_dgB = this.Gview_gzB;
  595. out_dtC = m_dt_C;
  596. out_dgC = this.Gview_gzC;
  597. out_dtD = m_dt_D;
  598. out_dgD = this.Gview_gzD;
  599. out_dtDS = m_dt_DS;
  600. out_dgDS = this.Gview_gzDS;
  601. }
  602. #endregion
  603. #region clr加载数据部分
  604. public DataTable ChineseStandardABCD_GetDataTable_Total(List<CGridDataClr> in_list_cgriddataclr, out int oneresult_columncount)
  605. {
  606. oneresult_columncount = 1;//一个数据源的跨度,计算出一个数据源包含几个列
  607. //创建一个临时表
  608. DataTable ret_dt = new DataTable();
  609. //判断传入的数据对象是否为空
  610. if (in_list_cgriddataclr == null)
  611. {
  612. string str1 = "传入分解表格数据的CGridDataClr对象为空!";
  613. str1 = table["str1"].ToString();
  614. //log.Error("(OTSIncAReportGridsFun.ChineseStandardABCD_GetDataTable_Total)" + str1);
  615. return ret_dt;
  616. }
  617. #region 根据返回的结构创建DataTable的结构---------------------------------------------
  618. for (int i = 0; i < in_list_cgriddataclr.Count(); i++)
  619. {
  620. //分解结果内容
  621. List<CGridColumnClr> list_cgridcolumnclrs = new List<CGridColumnClr>();
  622. list_cgridcolumnclrs = in_list_cgriddataclr[i].GetGridColumnList(); //获取各列
  623. //单个数据源包含几个列的跨度
  624. if (oneresult_columncount < list_cgridcolumnclrs.Count())
  625. oneresult_columncount = list_cgridcolumnclrs.Count();
  626. if (in_list_cgriddataclr.Count > 1)
  627. {
  628. //创建DT的列,多个数据源,为每个字段带上索引号
  629. foreach (CGridColumnClr ls_cgridcolumnclr in list_cgridcolumnclrs)
  630. {
  631. string ls_fl_strName = ls_cgridcolumnclr.GetName();
  632. //通过获取到的列,创建表的列
  633. ret_dt.Columns.Add(ls_fl_strName + "(" + (i + 1).ToString() + ")");
  634. }
  635. }
  636. else
  637. {
  638. //创建DT的列,单个数据源,不带索引号
  639. foreach (CGridColumnClr ls_cgridcolumnclr in list_cgridcolumnclrs)
  640. {
  641. string ls_fl_strName = ls_cgridcolumnclr.GetName();
  642. //通过获取到的列,创建表的列
  643. ret_dt.Columns.Add(ls_fl_strName);
  644. }
  645. }
  646. }
  647. #endregion
  648. #region 再创建表的行------------------------------------------------------------------
  649. //取最大的rowlistcount,要不然,不知道这底层返回的数据居然还有2,2,3这样的行数据
  650. int maxrownumber = 0;
  651. for (int i = 0; i < in_list_cgriddataclr.Count(); i++)
  652. {
  653. //分解结果内容
  654. List<CGridColumnClr> list_cgridcolumnclrs = new List<CGridColumnClr>();
  655. list_cgridcolumnclrs = in_list_cgriddataclr[i].GetGridColumnList(); //获取各列
  656. //创建DT的行
  657. if (list_cgridcolumnclrs != null)
  658. {
  659. foreach (CGridColumnClr ls_cgridcolumnclr in list_cgridcolumnclrs)
  660. {
  661. if (maxrownumber < ls_cgridcolumnclr.GetRowList().Count())
  662. {
  663. maxrownumber = ls_cgridcolumnclr.GetRowList().Count();
  664. }
  665. }
  666. }
  667. }
  668. for (int k = 0; k < maxrownumber; k++)
  669. {
  670. DataRow dr = ret_dt.NewRow();
  671. ret_dt.Rows.Add(dr);
  672. }
  673. #endregion
  674. #region //再次重新分解,先分解列,然后将获取到的各行各列的数据,填充到相应的位置上---
  675. for (int i = 0; i < in_list_cgriddataclr.Count(); i++)
  676. {
  677. //分解结果内容
  678. List<CGridColumnClr> list_cgridcolumnclrs = new List<CGridColumnClr>();
  679. list_cgridcolumnclrs = in_list_cgriddataclr[i].GetGridColumnList(); //获取各列
  680. //再次重新分解,先分解列,然后将获取到的
  681. for (int k = 0; k < list_cgridcolumnclrs.Count(); k++)
  682. {
  683. string ls_fl_strName = list_cgridcolumnclrs[k].GetName();
  684. List<CGridRowClr> ls_list_cgridrowclr = new List<CGridRowClr>();
  685. ls_list_cgridrowclr = list_cgridcolumnclrs[k].GetRowList();
  686. for (int j = 0; j < ls_list_cgridrowclr.Count(); j++)
  687. {
  688. //先判断该行该单元格的数据类型
  689. string str_value = "";//因为显示只需要对字符串进行操作就可以了,所以将底层获取到的数据,除了颗粒类型外的都转成string
  690. switch (ls_list_cgridrowclr[j].GetDataType())
  691. {
  692. case 0:
  693. //string
  694. str_value = ls_list_cgridrowclr[j].GetStringValue();
  695. ret_dt.Rows[j][k + i * oneresult_columncount] = str_value;
  696. break;
  697. case 1:
  698. //该元素含量表没有需要显示的颗粒图像
  699. //ret_dt.Rows[j][k+i*oneresult_columncount] = GetBitmapByParticleList(ls_list_cgridrowclr[k].GetParticle());
  700. break;
  701. case 2:
  702. //int
  703. str_value = ls_list_cgridrowclr[j].GetIntValue().ToString();
  704. ret_dt.Rows[j][k + i * oneresult_columncount] = str_value;
  705. break;
  706. case 3:
  707. //float
  708. str_value = ls_list_cgridrowclr[j].GetDoubleValue().ToString("0.00");
  709. ret_dt.Rows[j][k + i * oneresult_columncount] = str_value;
  710. break;
  711. default:
  712. str_value = "";
  713. ret_dt.Rows[j][k + i * oneresult_columncount] = str_value;
  714. break;
  715. }
  716. }
  717. }
  718. }
  719. #endregion
  720. return ret_dt;
  721. }
  722. #endregion
  723. #region clr数据导出DataTable表
  724. public List<DataTable> ChineseStandardABCD_GetDataTable()
  725. {
  726. List<DataTable> dataTables = new List<DataTable>();
  727. dataTables.Add( ChineseStandardABCD_GetDataTable_Total(m_list_cgriddataclr_A, out m_oneresult_columnscount_A));
  728. dataTables.Add( ChineseStandardABCD_GetDataTable_Total(m_list_cgriddataclr_B, out m_oneresult_columnscount_B));
  729. dataTables.Add( ChineseStandardABCD_GetDataTable_Total(m_list_cgriddataclr_C, out m_oneresult_columnscount_C));
  730. dataTables.Add( ChineseStandardABCD_GetDataTable_Total(m_list_cgriddataclr_D, out m_oneresult_columnscount_D));
  731. dataTables.Add( ChineseStandardABCD_GetDataTable_Total(m_list_cgriddataclr_DS, out m_oneresult_columnscount_DS));
  732. return dataTables;
  733. }
  734. #endregion
  735. }
  736. }