FrmFinalCheck.cs 16 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425
  1. using System;
  2. using System.Collections.Generic;
  3. using System.ComponentModel;
  4. using System.Data;
  5. using System.Drawing;
  6. using System.Linq;
  7. using System.Text;
  8. using System.Windows.Forms;
  9. using com.steering.mes.mcp.entity;
  10. using Core.Mes.Client.Comm.Format;
  11. using Core.Mes.Client.Comm.Server;
  12. using Core.Mes.Client.Comm.Tool;
  13. using Core.StlMes.Client.Mcp.Control;
  14. using Core.StlMes.Client.Mcp.Control.Common;
  15. using Core.StlMes.Client.Mcp.Control.Entity;
  16. using Core.StlMes.Client.Mcp.Control.Machining;
  17. using Core.StlMes.Client.Mcp.Mch.Entity;
  18. using Core.StlMes.Client.Mcp.Mch.MchResult;
  19. using CoreFS.CA06;
  20. using Infragistics.Win;
  21. using Infragistics.Win.UltraWinGrid;
  22. using PortMchBatchSampleResultEntity = Core.StlMes.Client.Mcp.Control.Entity.PortMchBatchSampleResultEntity;
  23. namespace Core.StlMes.Client.Mcp.Mch
  24. {
  25. public partial class FrmFinalCheck : FrmMchBase
  26. {
  27. public FrmFinalCheck()
  28. {
  29. InitializeComponent();
  30. DefaultGx = "701313";
  31. }
  32. protected override UltraGridRow ActitveResultRow { get { return CrackDetectGrid.ActiveRow; } }
  33. protected override object Value { get { return finalCheckControl1.GetData(); } }
  34. protected override void OnLoad(EventArgs e)
  35. {
  36. base.OnLoad(e);
  37. EntityHelper.ShowGridCaption<MchFinalCheckResultEntity>(CrackDetectGrid.DisplayLayout.Bands[0]);
  38. EntityHelper.ShowGridCaption<MchFinalCheckTreatmentEntityAll>(ultraGrid2.DisplayLayout.Bands[0]);
  39. EntityHelper.ShowGridCaption<MchFinalCheckResultDEntity>(ultraGrid2.DisplayLayout.Bands[1]);
  40. EntityHelper.ShowGridCaption<MchBug>(ultraGrid3.DisplayLayout.Bands[0]);
  41. base.ultraGrid1.DisplayLayout.Bands[0].Columns["ActCount"].Hidden = true;
  42. base.ultraGrid1.DisplayLayout.Bands[0].Columns["ActWeight"].Hidden = true;
  43. base.ultraGrid1.DisplayLayout.Bands[0].Columns["ProCount"].Header.Caption = "测量点支";
  44. base.ultraGrid1.DisplayLayout.Bands[0].Columns["ProWeight"].Header.Caption = "测量点吨";
  45. ultraGrid1.DisplayLayout.Bands[0].Columns["ProCount"].EditorComponent = null;
  46. base.ultraGrid1.DisplayLayout.Bands[0].Columns["OperateCount"].Header.Caption = "检验支";
  47. base.ultraGrid1.DisplayLayout.Bands[0].Columns["OperateWeight"].Header.Caption = "检验吨";
  48. base.ultraGrid1.DisplayLayout.Bands[0].Columns["PerStatus"].Header.Caption = "处置单状态";
  49. base.ultraGrid1.DisplayLayout.Bands[0].Columns["BesideStatus"].Header.Caption = "终检结果";
  50. ultraGrid1.DisplayLayout.Bands[0].Columns["ProDate"].Hidden = false;
  51. ultraGrid1.DisplayLayout.Bands[0].Columns["CurrentStatus"].Hidden = false;
  52. ultraGrid1.DisplayLayout.Bands[0].Columns["BesideDate"].Hidden = false;
  53. // base.ultraGrid1.DisplayLayout.Bands[0].Columns["BesideStatus"].RowLayoutColumnInfo.OriginX = 22;
  54. // base.ultraGrid1.DisplayLayout.Bands[0].Columns["PerStatus"].RowLayoutColumnInfo.OriginX = 24;
  55. base.ultraGrid1.DisplayLayout.Bands[0].Columns["BatchGroudNo"].Hidden = true;
  56. CrackDetectGrid.DisplayLayout.Override.AllowRowFiltering = DefaultableBoolean.False;
  57. CrackDetectGrid.DisplayLayout.Override.HeaderClickAction = HeaderClickAction.Default;
  58. ultraGrid2.DisplayLayout.Override.AllowRowFiltering = DefaultableBoolean.False;
  59. ultraGrid2.DisplayLayout.Override.HeaderClickAction = HeaderClickAction.Default;
  60. ultraOptionSet2.Visible = true;
  61. ultraExpandableGroupBox3.Expanded = false;
  62. finalCheckControl1.Init(ob);
  63. ultraGrid1.DisplayLayout.Override.AllowRowFiltering = DefaultableBoolean.True;
  64. ultraGrid1.DisplayLayout.Override.HeaderClickAction = HeaderClickAction.SortSingle;
  65. ultraGrid1.DisplayLayout.Bands[0].Override.HeaderClickAction = HeaderClickAction.SortSingle;
  66. }
  67. protected override void ResetUI()
  68. {
  69. mchFinalCheckResultEntityBindingSource.Clear();
  70. mchFinalCheckTotalBindingSource.Clear();
  71. mchBugBindingSource.Clear();
  72. }
  73. protected override void DoAdd()
  74. {
  75. if (ActiveRow != null)
  76. {
  77. MchFinalCheckResultEntity data = finalCheckControl1.GetData();
  78. if (double.Parse(data.CheckNum.ToString3())/double.Parse(data.ProNum.ToString3()) <=(data.PlineCode=="C036"?0.05: 0.09))
  79. {
  80. if (MessageUtil.ShowYesNoAndQuestion("抽检率不足" + (data.PlineCode == "C036" ? "5%" : "9%") + ",是否依然新增") == DialogResult.No)
  81. return;
  82. /* MessageBox.Show("抽检率不足" + (data.PlineCode == "C036" ? "5%" : "9%") + ",不允许新增");
  83. return;*/
  84. }
  85. else
  86. if (MessageUtil.ShowYesNoAndQuestion("是否增加抽检记录?") == DialogResult.No)
  87. return;
  88. var listDetail = finalCheckControl1.Detail.SelectMany(p =>
  89. p.UnPassData == null || !p.UnPassData.Any() ?
  90. new List<MchFinalCheckResultDEntity>() { p } :
  91. p.UnPassData).ToList();
  92. List<MchFinalCheckTreatmentEntity> ListTreatMent = new List<MchFinalCheckTreatmentEntity>();
  93. listDetail.Where(p=>p.Station=="1").GroupBy(p =>
  94. new
  95. {
  96. p.TreatmentCode,
  97. p.ResponsibleCode,
  98. p.TreatmentName,
  99. p.ResponsibleName
  100. }).ToList().ForEach(p =>
  101. {
  102. ListTreatMent.Add(new MchFinalCheckTreatmentEntity()
  103. {
  104. ResponsibleCode =p.Key.ResponsibleCode,
  105. ResponsibleName = p.Key.ResponsibleName,
  106. TreatmentCode = p.Key.TreatmentCode,
  107. TreatmentName = p.Key.TreatmentName,
  108. UnqualifiedNum = p.Where(q=>q.Station=="1").Select(q=>q.MatNo).Distinct().Count(),
  109. });
  110. }
  111. );
  112. var ccp = new CoreClientParam();
  113. ccp.ServerName = "com.steering.mes.mcp.Mch.FrmFinalCheck";
  114. ccp.MethodName = "DoAdd";
  115. ccp.ServerParams = new object[]
  116. {
  117. JSONFormat.Format(Value),
  118. finalCheckControl1.ProMchPort.Select(JSONFormat.Format).ToList(),
  119. listDetail.Select(JSONFormat.Format).ToList(),
  120. ListTreatMent.Select(JSONFormat.Format).ToList(),
  121. Gx,
  122. finalCheckControl1.GetFailList().Select(JSONFormat.Format).ToList(),
  123. };
  124. ccp = ExecuteNonQuery(ccp, CoreInvokeType.Internal);
  125. if (ccp.ReturnCode != -1)
  126. {
  127. MessageUtil.ShowTips(ccp.ReturnInfo);
  128. if (ccp.ReturnInfo.Equals("新增成功!"))
  129. {
  130. //doOver();
  131. Query();
  132. }
  133. }
  134. }
  135. }
  136. protected override void DoDelete()
  137. {
  138. {
  139. if (ActiveRow != null && ActitveResultRow != null)
  140. {
  141. if (MessageUtil.ShowYesNoAndQuestion("是否删除抽检记录?") == DialogResult.No)
  142. return;
  143. var ccp = new CoreClientParam();
  144. ccp.ServerName = "com.steering.mes.mcp.Mch.FrmFinalCheck";
  145. ccp.MethodName = "DoDelete";
  146. ccp.ServerParams = new object[]
  147. {
  148. JSONFormat.Format(ActitveResultRow.ListObject), Gx
  149. };
  150. ccp = ExecuteNonQuery(ccp, CoreInvokeType.Internal);
  151. if (ccp.ReturnCode != -1)
  152. {
  153. MessageUtil.ShowTips(ccp.ReturnInfo);
  154. if (ccp.ReturnInfo.Equals("删除成功!"))
  155. {
  156. /* if (!string.IsNullOrEmpty(ActitveResultRow.Cells["ReportPath"].Value.ToString2()))
  157. {
  158. try
  159. {
  160. FileHelper.Delete(ActitveResultRow.Cells["ReportPath"].Value.ToString2());
  161. }
  162. catch (Exception)
  163. {
  164. MessageUtil.ShowTips("报告删除失败!");
  165. }
  166. }*/
  167. Query();
  168. }
  169. }
  170. }
  171. }
  172. }
  173. protected override void DoApproval()
  174. {
  175. if (ActiveRow != null)
  176. {
  177. if (ultraGrid2.ActiveRow == null)
  178. {
  179. MessageBox.Show("请选择需要验证通过的处置单");
  180. return;
  181. }
  182. MchFinalCheckTreatmentEntityAll list = null;
  183. if (ultraGrid2.ActiveRow.HasParent())
  184. {
  185. list = ultraGrid2.ActiveRow.ParentRow.ListObject as MchFinalCheckTreatmentEntityAll;
  186. }
  187. else
  188. {
  189. list = ultraGrid2.ActiveRow.ListObject as MchFinalCheckTreatmentEntityAll;
  190. }
  191. if (list==null) return;
  192. /* if (MessageUtil.ShowYesNoAndQuestion("是否确认验证通过?") == DialogResult.No)
  193. return;*/
  194. using (FrmApprovalData data = new FrmApprovalData(ob, ActiveRow.HeatPlanNo, list.TreatmentNo,this.UserInfo.GetUserName()))
  195. {
  196. data.ShowDialog();
  197. if (data.DialogResult == DialogResult.OK)
  198. {
  199. // doOver();
  200. Query();
  201. }
  202. }
  203. }
  204. }
  205. protected override void DoCancleApproval()
  206. {
  207. if (ActiveRow != null)
  208. {
  209. if (ultraGrid2.ActiveRow == null)
  210. {
  211. MessageBox.Show("请选择需要撤销验证通过的处置单");
  212. return;
  213. }
  214. MchFinalCheckTreatmentEntityAll list = null;
  215. if (ultraGrid2.ActiveRow.HasParent())
  216. {
  217. list = ultraGrid2.ActiveRow.ParentRow.ListObject as MchFinalCheckTreatmentEntityAll;
  218. }
  219. else
  220. {
  221. list = ultraGrid2.ActiveRow.ListObject as MchFinalCheckTreatmentEntityAll;
  222. }
  223. if (list == null) return;
  224. if (MessageUtil.ShowYesNoAndQuestion("是否确认撤销验证通过?") == DialogResult.No)
  225. return;
  226. var ccp = new CoreClientParam();
  227. ccp.ServerName = "com.steering.mes.mcp.Mch.FrmFinalCheck";
  228. ccp.MethodName = "DoCancleApproval";
  229. ccp.ServerParams = new object[]
  230. {
  231. list.TreatmentNo,
  232. };
  233. ccp = ExecuteNonQuery(ccp, CoreInvokeType.Internal);
  234. if (ccp.ReturnCode != -1)
  235. {
  236. MessageUtil.ShowTips(ccp.ReturnInfo);
  237. if (ccp.ReturnInfo.Equals("撤销成功!"))
  238. {
  239. Query();
  240. }
  241. }
  242. }
  243. }
  244. public void doOver()
  245. {
  246. if (ActiveRow == null) return;
  247. var dt1 = ServerHelper.GetData("com.steering.mes.mcp.Mch.FrmFinalCheck.CheckStatus",
  248. new object[] { ActiveRow.HeatPlanNo, ActiveRow.BatchNo }, ob);
  249. if ((dt1.Rows[0]["NUM"].ToString() == "0"))
  250. DoBeside(true);
  251. }
  252. protected override void GetResultData()
  253. {
  254. // base.GetResultData(); mchFinalCheckResultEntityBindingSource.DataSource =
  255. var List= EntityHelper.GetData<MchFinalCheckResultEntity>(
  256. "com.steering.mes.mcp.Mch.FrmFinalCheck.getQueryExpandResult",
  257. new object[] { ActiveRow.HeatPlanNo, ActiveRow.BatchNo },
  258. ob);
  259. mchFinalCheckResultEntityBindingSource.DataSource = List;
  260. commHelper.RefreshAndAutoSizeExceptColumns(CrackDetectGrid, "ReportPath");
  261. List<MchFinalCheckTreatmentEntityAll> ListTreatMent =
  262. EntityHelper.GetData<MchFinalCheckTreatmentEntityAll>(
  263. "com.steering.mes.mcp.Mch.FrmFinalCheck.getQueryTreatment",
  264. new object[] { List.Select(p=>p.ResultNo).ToArray() },
  265. ob);
  266. List<MchFinalCheckResultDEntity> listDetail = EntityHelper.GetData<MchFinalCheckResultDEntity>(
  267. "com.steering.mes.mcp.Mch.FrmFinalCheck.getQueryDetail",
  268. new object[] { List.Select(p=>p.ResultNo).ToArray() },
  269. ob);
  270. ListTreatMent.ForEach(p => p.UnPassData = listDetail.Where(q => q.ResultNo == p.ResultNo && p.TreatmentNo == q.TreatmentNo).ToList());
  271. mchFinalCheckTotalBindingSource.DataSource = ListTreatMent;
  272. commHelper.RefreshAndAutoSizeExceptColumns(ultraGrid2, "ReportPath");
  273. List<MchBug> listFailDetail = EntityHelper.GetData<MchBug>(
  274. "com.steering.mes.mcp.Mch.FrmFinalCheck.getFailDetail",
  275. new object[] { ListTreatMent.Select(p=>p.TreatmentNo).ToArray() },
  276. ob);
  277. mchBugBindingSource.DataSource = listFailDetail;
  278. commHelper.RefreshAndAutoSizeExceptColumns(ultraGrid3, "ReportPath");
  279. ultraExpandableGroupBox3.Expanded = listFailDetail.Any();
  280. // ultraGrid2.Rows.ExpandAll(true);
  281. if (ActiveRow == null) return;
  282. var result = new MchFinalCheckResultEntity
  283. {
  284. HeatPlanNo = ActiveRow.HeatPlanNo,
  285. JudgeStoveNo = ActiveRow.JudgeStoveNo,
  286. BatchNo = ActiveRow.BatchNo,
  287. PlineCode = ActiveRow.PlineCode,
  288. PlineName = ActiveRow.PlineName,
  289. ProShift = UserInfo.GetUserOrder(),
  290. ProGroup = UserInfo.GetUserGroup(),
  291. ProUser = UserInfo.GetUserName(),
  292. Departid = UserInfo.GetDeptid(),
  293. Departname = UserInfo.GetDepartment()
  294. };
  295. List<PortMchBatchSampleResultEntity> portList = portMchBatchControl1.Data;
  296. if (ActiveRow.ProCount <= 0 || ActiveRow.ProCount == null)
  297. {
  298. portList = new List<PortMchBatchSampleResultEntity>();
  299. }
  300. finalCheckControl1.SetValue(result, portList);
  301. }
  302. private void uteViewer_EditorButtonClick(object sender, Infragistics.Win.UltraWinEditors.EditorButtonEventArgs e)
  303. {
  304. if(CrackDetectGrid.ActiveRow==null) return;
  305. var matfrm = new FinalCheckData(ob, CrackDetectGrid.ActiveRow.Cells["ResultNo"].Value.ToString2());
  306. matfrm.ShowDialog();
  307. }
  308. protected override void Print()
  309. {
  310. if (ultraGrid2.ActiveRow == null) return;
  311. MchFinalCheckTreatmentEntityAll MchFinalCheckTreatmentEntityAll = ultraGrid2.ActiveRow.ListObject as MchFinalCheckTreatmentEntityAll;
  312. string strurl = "";
  313. strurl =
  314. "http://172.54.10.42:8080/webroot/decision/view/report?viewlet=RepMchNoticeOfQualityDisposal.cpt&__embed__=true" +
  315. "&TREATMENT_NO=" + MchFinalCheckTreatmentEntityAll.TreatmentNo;
  316. FrmRepExcel fBug = new FrmRepExcel(ob, strurl);
  317. fBug.AutoSize = true;
  318. fBug.MaximumSize = new Size(Screen.PrimaryScreen.WorkingArea.Width, Screen.PrimaryScreen.WorkingArea.Height);
  319. fBug.WindowState = FormWindowState.Maximized;
  320. fBug.Text = "处置单";
  321. fBug.Show();
  322. }
  323. private void ultraGrid1_BeforeCellDeactivate(object sender, CancelEventArgs e)
  324. {
  325. if (finalCheckControl1.Detail.Any())
  326. {
  327. if (MessageUtil.ShowYesNoAndQuestion("抽检管号未新增!! 是否继续此操作?") == DialogResult.No)
  328. e.Cancel = true;
  329. }
  330. }
  331. }
  332. }