Query_ExeProgress.cs 8.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207
  1. using System;
  2. using System.Collections.Generic;
  3. using System.ComponentModel;
  4. using System.Data;
  5. using System.Drawing;
  6. using System.Drawing.Drawing2D;
  7. using System.Linq;
  8. using System.Text;
  9. using System.Windows.Forms;
  10. using UAS_MES.DataOperate;
  11. using UAS_MES.PublicMethod;
  12. namespace UAS_MES.Query
  13. {
  14. public partial class Query_ExeProgress : Form
  15. {
  16. DataHelper dh;
  17. LogStringBuilder sql = new LogStringBuilder();
  18. //经过的步骤
  19. string PastStep = "";
  20. //拆分后的经过的步骤
  21. Dictionary<int, string> Step;
  22. //屏幕高度
  23. int ScreenWidth;
  24. //屏幕宽度
  25. int ScreenHeight;
  26. DataTable dt;
  27. public Query_ExeProgress()
  28. {
  29. InitializeComponent();
  30. }
  31. private void 工单执行进度_Load(object sender, EventArgs e)
  32. {
  33. dh = new DataHelper();
  34. ScreenWidth = this.Width;
  35. ScreenHeight = this.Height;
  36. }
  37. private void 工单执行进度_SizeChanged(object sender, EventArgs e)
  38. {
  39. }
  40. private void sn_code_KeyDown(object sender, KeyEventArgs e)
  41. {
  42. if (e.KeyCode == Keys.Enter)
  43. {
  44. if (Step != null && Step.Count > 0)
  45. {
  46. for (int i = 0; i < Step.Count; i++)
  47. {
  48. Controls.Remove(Controls[i + Step[i] + "_label"]);
  49. }
  50. }
  51. //查询执行过的步骤
  52. sql.Clear();
  53. sql.Append("select CD_DETNO, CD_STEPCODE from craft left join craftdetail on cd_crid = cr_id where ");
  54. sql.Append("cr_code=(select ms_craftcode from makeserial where ms_sncode='" + sn_code.Text + "') order by cd_detno");
  55. dt = (DataTable)dh.ExecuteSql(sql.GetString(), "select");
  56. Step = new Dictionary<int, string>();
  57. PastStep = dh.getFieldDataByCondition("makeserial", "ms_paststep", "ms_sncode='" + sn_code.Text + "'").ToString();
  58. for (int i = 0; i < dt.Rows.Count + 2; i++)
  59. {
  60. if (i == 0)
  61. Step.Add(i, "开始");
  62. else if (i == dt.Rows.Count + 1)
  63. Step.Add(i, "结束");
  64. else
  65. Step.Add(i, dt.Rows[i - 1]["CD_STEPCODE"].ToString());
  66. }
  67. Refresh();
  68. sql.Clear();
  69. sql.Append("select mp_makecode,ma_prodcode,ma_linecode,ma_craftcode,mp_sourcecode,mp_sncode,mp_indate ");
  70. sql.Append("from makeprocess left join make on mp_makecode=ma_code where mp_sncode='"+sn_code.Text+"'");
  71. dt = (DataTable)dh.ExecuteSql(sql.GetString(),"select");
  72. BaseUtil.FillDgvWithDataTable(CraftInfDgv, dt);
  73. }
  74. }
  75. private void SerialPanel_Paint(object sender, PaintEventArgs e)
  76. {
  77. if (Step != null)
  78. {
  79. //设置一行五个展示数量
  80. int RectangleCountEachRow = 5;
  81. int x = 40;
  82. int y = SerialPanel.Height / 10;
  83. int CurrentIndex = 0;
  84. //根据记录的数量判断行数
  85. int RowCount = (Step.Count % RectangleCountEachRow) == 0 ? (Step.Count / RectangleCountEachRow) : (Step.Count / RectangleCountEachRow) + 1;
  86. //每行的循环
  87. for (int i = 1; i <= RowCount; i++)
  88. {
  89. for (int j = CurrentIndex; j < RectangleCountEachRow * i; j++)
  90. {
  91. //创建画板
  92. Graphics g = e.Graphics;
  93. //途程节点的矩形
  94. Rectangle r;
  95. if (Step[j].Contains("开始") || Step[j].Contains("结束"))
  96. r = new Rectangle(0, 0, 40, 40);
  97. else
  98. r = new Rectangle();
  99. r.Width = SerialPanel.Width / 10;
  100. r.Height = SerialPanel.Height / 8;
  101. //画箭头的Pen
  102. Pen p = new Pen(Color.CadetBlue, 15);
  103. p.StartCap = LineCap.Round;
  104. p.EndCap = LineCap.ArrowAnchor;
  105. //方块内的信息
  106. Label Param = new Label();
  107. Param.Text = j + " " + Step[j];
  108. Param.Name = j + Step[j] + "_label";
  109. Param.AutoSize = true;
  110. Param.Anchor = AnchorStyles.Left;
  111. Param.Anchor = AnchorStyles.Top;
  112. Param.Location = new Point(x + r.Width / 14 * RectangleCountEachRow, y + r.Height / 10 * 4);
  113. //如果在奇数行
  114. if (i % 2 != 0)
  115. {
  116. r.Location = new Point(x, y);
  117. if (PastStep.Contains(Step[j]))
  118. {
  119. g.FillRectangle(Brushes.Green, r);
  120. }
  121. else
  122. {
  123. if (Step[j].Contains("开始") || Step[j].Contains("结束"))
  124. g.FillEllipse(Brushes.Green, r);
  125. else
  126. g.FillRectangle(Brushes.White, r);
  127. }
  128. //填充方块内的信息
  129. if (Controls[Param.Name] == null)
  130. SerialPanel.Controls.Add(Param);
  131. if (j + 1 == Step.Count)
  132. break;
  133. //画箭头
  134. //如果是一行中的箭头
  135. if (j + 1 < RectangleCountEachRow * i)
  136. {
  137. g.DrawLine(p, x + r.Width + 10, y + r.Height / 2, x + ScreenWidth / (RectangleCountEachRow), y + r.Height / 2);
  138. x += ScreenWidth / RectangleCountEachRow;
  139. }
  140. //如果是行的最后一个的箭头
  141. else if (j + 1 == RectangleCountEachRow * i)
  142. {
  143. g.DrawLine(p, x + r.Width / 2, y + r.Height + 10, x + r.Width / 2, y + r.Height + r.Height);
  144. y = y + r.Height + r.Height;
  145. }
  146. }
  147. //如果在偶数行
  148. else
  149. {
  150. r.Location = new Point(x, y);
  151. if (PastStep.Contains(Step[j]))
  152. {
  153. g.FillRectangle(Brushes.Green, r);
  154. }
  155. else
  156. {
  157. if (Step[j].Contains("开始") || Step[j].Contains("结束"))
  158. {
  159. g.FillEllipse(Brushes.Green, r);
  160. }
  161. else
  162. {
  163. g.FillRectangle(Brushes.White, r);
  164. }
  165. }
  166. //填充文字信息
  167. //存在这个名称的则不进行添加
  168. if (Controls[Param.Name] == null)
  169. {
  170. SerialPanel.Controls.Add(Param);
  171. }
  172. //如果最后一个的画则直接Break,不用画箭头了
  173. if (j + 1 == Step.Count)
  174. {
  175. break;
  176. }
  177. //如果不是本行的最后一个画横向的箭头
  178. if (j + 1 < RectangleCountEachRow * i)
  179. {
  180. g.DrawLine(p, (x - 10), (y + r.Height / 2), (x - ScreenWidth / RectangleCountEachRow + r.Width), (y + r.Height / 2));
  181. x -= ScreenWidth / RectangleCountEachRow;
  182. }
  183. //如果是最后一个画纵向的箭头
  184. else if (j + 1 == RectangleCountEachRow * i)
  185. {
  186. g.DrawLine(p, (x + r.Width / 2), (y + r.Height + 10), (x + r.Width / 2), (y + r.Height + r.Height));
  187. y = y + r.Height + r.Height;
  188. }
  189. }
  190. CurrentIndex = CurrentIndex + 1;
  191. }
  192. }
  193. }
  194. }
  195. }
  196. }