FrmMchWasterAuditReport.cs 11 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287
  1. using com.steering.mes.mcp.entity;
  2. using Core.Mes.Client.Comm.Control;
  3. using Core.Mes.Client.Comm.Server;
  4. using Core.Mes.Client.Comm.Tool;
  5. using Core.StlMes.Client.Mcp.Control;
  6. using CoreFS.CA06;
  7. using System;
  8. using System.Collections.Generic;
  9. using System.ComponentModel;
  10. using System.Data;
  11. using System.Drawing;
  12. using System.Linq;
  13. using System.Text;
  14. using System.Windows.Forms;
  15. using Infragistics.Win.UltraWinEditors;
  16. using Core.StlMes.Client.Mcp.Mch.Entity;
  17. using Infragistics.Win;
  18. using Infragistics.Win.UltraWinGrid;
  19. using Core.Mes.Client.Comm.Format;
  20. using System.Collections;
  21. namespace Core.StlMes.Client.Mcp.Mch.Report
  22. {
  23. public partial class FrmMchWasterAuditReport : FrmBase
  24. {
  25. //private string SlGx = "";//工序代码
  26. //private string SlGxname = "";//工序名称
  27. private string departm = "";
  28. private string plineCode = "";
  29. private string Process = "";//参数
  30. private string[] plineCodes = new string[] { };
  31. public FrmMchWasterAuditReport()
  32. {
  33. InitializeComponent();
  34. this.IsLoadUserView = true;
  35. }
  36. public override void ToolBar_Click(object sender, string ToolbarKey)
  37. {
  38. switch (ToolbarKey)
  39. {
  40. case "DoQuery":
  41. QuerySinglePlan();
  42. break;
  43. case "Audit":
  44. Audit();
  45. break;
  46. case "CancelAudit":
  47. CancelAudit();
  48. break;
  49. case "DoClose":
  50. this.Close();
  51. break;
  52. }
  53. }
  54. /// <summary>
  55. /// 审核
  56. /// </summary>
  57. private void Audit()
  58. {
  59. CrackDetectGrid.UpdateData();
  60. IQueryable<UltraGridRow> checkMagRows = this.CrackDetectGrid.Rows.AsQueryable().Where(" CHK = 'True'");
  61. if (checkMagRows.Count() == 0)
  62. {
  63. MessageUtil.ShowTips("请选择需要申请判定的主信息!");
  64. return;
  65. }
  66. ArrayList parm = new ArrayList();
  67. foreach (UltraGridRow uRow in checkMagRows)
  68. {
  69. MatBcMEntity matBcEntity = (MatBcMEntity)uRow.ListObject;
  70. string matBcTity = JSONFormat.Format(matBcEntity);
  71. parm.Add(matBcTity);
  72. }
  73. CoreClientParam ccp = new CoreClientParam();
  74. ccp.ServerName = "com.steering.mes.mcp.Mch.FrmJgxReport";
  75. ccp.MethodName = "Audit";
  76. ccp.ServerParams = new object[] { parm, UserInfo.GetUserName() };
  77. ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
  78. if (ccp.ReturnCode != -1)
  79. {
  80. MessageUtil.ShowTips("审核成功!");
  81. QuerySinglePlan();
  82. }
  83. else
  84. {
  85. MessageUtil.ShowTips(ccp.ReturnInfo);
  86. }
  87. }
  88. /// <summary>
  89. /// 取消审核
  90. /// </summary>
  91. private void CancelAudit()
  92. {
  93. ultraGrid2.UpdateData();
  94. ultraGrid1.UpdateData();
  95. UltraGridRow row = this.ultraGrid2.ActiveRow;
  96. IQueryable<UltraGridRow> checkMagRows = this.ultraGrid1.Rows.AsQueryable().Where(" CHK = 'True'");
  97. if (checkMagRows.Count() == 0)
  98. {
  99. MessageUtil.ShowTips("请选择需要申请判定的主信息!");
  100. return;
  101. }
  102. ArrayList parm = new ArrayList();
  103. foreach (UltraGridRow uRow in checkMagRows)
  104. {
  105. MatBcMEntity matBcEntity = (MatBcMEntity)uRow.ListObject;
  106. string matBcTity = JSONFormat.Format(matBcEntity);
  107. parm.Add(matBcTity);
  108. }
  109. CoreClientParam ccp = new CoreClientParam();
  110. ccp.ServerName = "com.steering.mes.mcp.Mch.FrmJgxReport";
  111. ccp.MethodName = "CancelAudit";
  112. ccp.ServerParams = new object[] { parm, row.Cells["FAIL_APPROVAL_CODE"].Text.Trim() };
  113. ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
  114. if (ccp.ReturnCode != -1)
  115. {
  116. MessageUtil.ShowTips("取消审核成功!");
  117. QuerySinglePlan();
  118. }
  119. else
  120. {
  121. MessageUtil.ShowTips(ccp.ReturnInfo);
  122. }
  123. }
  124. /// <summary>
  125. /// 台账查询
  126. /// </summary>
  127. private void QuerySinglePlan()
  128. {
  129. MatBcMEntitybindingSource2.Clear();
  130. var startTim = "";
  131. var endTim = "";
  132. var shift = ""; //班次
  133. var group = ""; //班组
  134. var OrderNo = "";
  135. var JudgeStoveNo = "";
  136. #region
  137. if (chkTim.Checked)
  138. {
  139. if (DateTime.Parse(RegStartTime.Value.ToString()) > DateTime.Parse(RegEndTime.Value.ToString()))
  140. {
  141. MessageUtil.ShowTips("选择时间区间错误,请重新选择!");
  142. return;
  143. }
  144. startTim = RegStartTime.Value.ToString("yyyy-MM-dd HH:mm:ss");
  145. endTim = RegEndTime.Value.ToString("yyyy-MM-dd HH:mm:ss");
  146. }
  147. if (chkOrderNo.Checked)
  148. OrderNo = txtOrderNo.Text;
  149. if (chkJudgeStove.Checked)
  150. JudgeStoveNo = txtJudgeStove.Text;
  151. #endregion
  152. if (ultraTabControl1.SelectedTab.Index == 0)
  153. {
  154. MatBcMEntitybindingSource1.DataSource = EntityHelper.GetData<MatBcMEntity>(
  155. "com.steering.mes.mcp.Mch.FrmJgxReport.doQueryWasterAudit",
  156. new object[] { plineCode == "" ? plineCodes : new string[] { plineCode }, startTim, endTim, OrderNo, JudgeStoveNo },
  157. ob);
  158. GridHelper.RefreshAndAutoSizeExceptColumns(CrackDetectGrid);
  159. }
  160. else if (ultraTabControl1.SelectedTab.Index == 1)
  161. {
  162. DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.Mch.FrmJgxReport.doQueryWasterAuditRecords", new Object[] { plineCode == "" ? plineCodes : new string[] { plineCode }, startTim, endTim, OrderNo, JudgeStoveNo }, this.ob);
  163. GridHelper.CopyDataToDatatable(dt, this.dataTable1, true);
  164. GridHelper.RefreshAndAutoSize(this.ultraGrid2);
  165. }
  166. }
  167. private void FrmMchWasterAuditReport_Load(object sender, EventArgs e)
  168. { Process = this.CustomInfo.ToString();//参数
  169. plineCodes = comm.InitDropPlineCodePower(Process, txt_PlinCode, this.ValidDataPurviewIds, this.ob);
  170. if (plineCodes.Length > 1 && (plineCodes[1] == "C038" || plineCodes[1] == "C039" || plineCodes[1] == "C049" || plineCodes[1] == "C050" ||
  171. plineCodes[1] == "C051" || plineCodes[1] == "C057"))
  172. {
  173. RegStartTime.Value = DateTime.Parse(DateTime.Now.AddDays(-1).ToString("yyyy-MM-dd 20:00"));
  174. RegEndTime.Value = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd 19:59"));
  175. }
  176. else
  177. {
  178. RegStartTime.Value = DateTime.Parse(DateTime.Now.AddDays(-1).ToString("yyyy-MM-dd 21:00"));
  179. RegEndTime.Value = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd 20:59"));
  180. }
  181. departm = UserInfo.GetDepartment();
  182. //plineCode = YdmBaseClass.GetPCode(departm, this.ob);//获取 用户 对应的产线
  183. txt_PlinCode.SelectedIndex = 0;
  184. //YdmBaseClass.SetComboItemHeight(cmbOrder);
  185. //YdmBaseClass.SetComboItemHeight(cmbGroup);
  186. EntityHelper.ShowGridCaption<MatBcMEntity>(CrackDetectGrid.DisplayLayout.Bands[0]);
  187. EntityHelper.ShowGridCaption<MatBcMEntity>(ultraGrid1.DisplayLayout.Bands[0]);
  188. QuerySinglePlan();
  189. }
  190. private void chkStarts_CheckedChanged(object sender, EventArgs e)
  191. {
  192. if (chkTim.Checked)
  193. {
  194. RegStartTime.Enabled = true;
  195. RegEndTime.Enabled = true;
  196. }
  197. else
  198. {
  199. RegStartTime.Enabled = false;
  200. RegEndTime.Enabled = false;
  201. }
  202. //cmbOrder.Enabled = chkOrder.Checked;
  203. //cmbGroup.Enabled = chkGroup.Checked;
  204. txtOrderNo.Enabled = chkOrderNo.Checked;
  205. txtJudgeStove.Enabled = chkJudgeStove.Checked;
  206. }
  207. private void txt_PlinCode_TextChanged(object sender, EventArgs e)
  208. {
  209. plineCode = txt_PlinCode.SelectedItem.DataValue.ToString();
  210. }
  211. private void ultraTabControl1_SelectedTabChanged(object sender, Infragistics.Win.UltraWinTabControl.SelectedTabChangedEventArgs e)
  212. {
  213. if (toolMenu == null) return;
  214. if (ultraTabControl1.SelectedTab.Index == 0)
  215. {
  216. if (toolMenu.Toolbars[0].Tools.Exists("Audit"))
  217. {
  218. toolMenu.Toolbars[0].Tools["Audit"].InstanceProps.Visible = DefaultableBoolean.True;
  219. }
  220. if (toolMenu.Toolbars[0].Tools.Exists("CancelAudit"))
  221. {
  222. this.toolMenu.Toolbars[0].Tools["CancelAudit"].InstanceProps.Visible = DefaultableBoolean.False;
  223. }
  224. chkTim.Text = "入库时间";
  225. chkOrderNo.Visible = true;
  226. txtOrderNo.Visible = true;
  227. chkJudgeStove.Visible = true;
  228. txtJudgeStove.Visible = true;
  229. }
  230. else if (ultraTabControl1.SelectedTab.Index == 1)
  231. {
  232. if (toolMenu.Toolbars[0].Tools.Exists("Audit"))
  233. {
  234. toolMenu.Toolbars[0].Tools["Audit"].InstanceProps.Visible = DefaultableBoolean.False;
  235. }
  236. if (toolMenu.Toolbars[0].Tools.Exists("CancelAudit"))
  237. {
  238. this.toolMenu.Toolbars[0].Tools["CancelAudit"].InstanceProps.Visible = DefaultableBoolean.True;
  239. }
  240. chkTim.Text = "审核时间";
  241. chkOrderNo.Visible = false;
  242. txtOrderNo.Visible = false;
  243. chkJudgeStove.Visible = false;
  244. txtJudgeStove.Visible = false;
  245. }
  246. }
  247. private void ultraGrid2_AfterRowActivate(object sender, EventArgs e)
  248. {
  249. UltraGridRow uRow = this.ultraGrid2.ActiveRow;
  250. MatBcMEntitybindingSource2.DataSource = EntityHelper.GetData<MatBcMEntity>(
  251. "com.steering.mes.mcp.Mch.FrmJgxReport.doQueryWasterAuditRecordsByID",
  252. new object[] { uRow.Cells["FAIL_APPROVAL_CODE"].Value.ToString() },
  253. ob);
  254. GridHelper.RefreshAndAutoSizeExceptColumns(ultraGrid1);
  255. }
  256. private void FrmMchWasterAuditReport_Shown(object sender, EventArgs e)
  257. {
  258. this.toolMenu.Toolbars[0].Tools["CancelAudit"].InstanceProps.Visible = DefaultableBoolean.False;
  259. }
  260. }
  261. }