FrmMilCheckDeatilSimple.cs 6.7 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192
  1. using com.steering.mes.zgmil.entity;
  2. using Core.Mes.Client.Comm.Control;
  3. using Core.Mes.Client.Comm.Format;
  4. using Core.Mes.Client.Comm.Server;
  5. using Core.Mes.Client.Comm.Tool;
  6. using Core.StlMes.Client.ZGMil.Common;
  7. using Core.StlMes.Client.ZGMil.Entity;
  8. using CoreFS.CA06;
  9. using Infragistics.Win.UltraWinGrid;
  10. using System;
  11. using System.Collections;
  12. using System.Collections.Generic;
  13. using System.ComponentModel;
  14. using System.Data;
  15. using System.Drawing;
  16. using System.Linq;
  17. using System.Text;
  18. using System.Windows.Forms;
  19. namespace Core.StlMes.Client.ZGMil.Report
  20. {
  21. public partial class FrmMilCheckDeatilSimple : FrmBase
  22. {
  23. private string departm = "";
  24. private string plineCode = "";
  25. private string[] plineCodes = { };
  26. public FrmMilCheckDeatilSimple()
  27. {
  28. InitializeComponent();
  29. this.IsLoadUserView = true;
  30. }
  31. private void FrmMilCheckDeatilSimple_Load(object sender, EventArgs e)
  32. {
  33. cmbDate.Value = DateTime.Parse(DateTime.Today.ToString());
  34. NativeMethodNew na = new NativeMethodNew(this.ob);
  35. departm = UserInfo.GetDepartment();
  36. //plineCode = na.GetPCode(departm);//获取 用户 对应的产线
  37. plineCodes = BaseMethod.GetPlineCode(ValidDataPurviewIds, ob);
  38. EntityHelper.ShowGridCaption<MilCheckDeatilSimpleEntity>(ultraGrid1.DisplayLayout.Bands[0]);
  39. DateTime now = DateTime.Now;
  40. DateTime date = new DateTime(now.Year, now.Month, 1);
  41. cmbDate.Value = DateTime.Parse(date.ToString("yyyy-MM-dd"));
  42. cmbEndDate.Value = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd 23:59:59"));
  43. //cmbEndDate.Value = DateTime.Parse(DateTime.Now.AddDays(1).ToString("yyyy-MM-dd 06:59:59"));
  44. //cmbDate.Value = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd 07:00:00"));
  45. //TubeRoll.SetComboItemHeight(uteLotNo);
  46. //TubeRoll.SetComboItemHeight(cmbBz);
  47. //加载产线
  48. //DataTable dt = ServerHelper.GetData("com.steering.mes.zgmil.report.FrmMilDateStatistics.getPlineNameZG", new object[] { plineCodes }, ob);
  49. //if (dt != null && dt.Rows.Count > 0)
  50. //{
  51. // txt_PlinCode.DataSource = dt;
  52. // txt_PlinCode.ValueMember = "PLINE_CODE";
  53. // txt_PlinCode.DisplayMember = "PLINE_NAME";
  54. //}
  55. }
  56. /// <summary>
  57. /// 重写基类方法
  58. /// </summary>
  59. /// <param name="sender"></param>
  60. /// <param name="ToolbarKey"></param>
  61. public override void ToolBar_Click(object sender, string ToolbarKey)
  62. {
  63. switch (ToolbarKey)
  64. {
  65. case "Query":
  66. doQuery();
  67. break;
  68. case "Export":
  69. ExportData();
  70. break;
  71. case "Update":
  72. doUpdate();
  73. break;
  74. case "Close":
  75. this.Close();
  76. break;
  77. }
  78. }
  79. /// <summary>
  80. /// 查询
  81. /// </summary>
  82. private void doQuery()
  83. {
  84. string date = "";
  85. string endDate = "";
  86. string judgeStoveNo = "";
  87. string LotNo = "";
  88. string ContractNo = "";
  89. if (chkDate.Checked)
  90. {
  91. if (DataTimeUtil.JudgeTime(DateTime.Parse(cmbDate.Value.ToString()), DateTime.Parse(cmbEndDate.Value.ToString())) == 0)
  92. {
  93. MessageUtil.ShowTips("您所选择的日期区域不对,请重新选择!");
  94. return;
  95. }
  96. else
  97. {
  98. date = cmbDate.Value.ToString("yyyyMMdd0000");
  99. endDate = cmbEndDate.Value.ToString("yyyyMMdd2359");
  100. }
  101. }
  102. if (chkjudgeStoveNo.Checked)
  103. {
  104. judgeStoveNo = txtjudgeStoveNo.Text.ToString();
  105. }
  106. List<MilCheckDeatilSimpleEntity> listSource = EntityHelper.GetData<MilCheckDeatilSimpleEntity>(
  107. "com.steering.mes.zgmil.report.FrmMilDateStatistics.getMilCheckDeatilSimple", new object[] { judgeStoveNo }, this.ob);
  108. bindingSource1.DataSource = listSource;
  109. GridHelper.RefreshAndAutoSize(this.ultraGrid1);
  110. }
  111. /// <summary>
  112. /// 查询条件
  113. /// </summary>
  114. /// <param name="sender"></param>
  115. /// <param name="e"></param>
  116. private void chkDate_CheckedChanged(object sender, EventArgs e)
  117. {
  118. if (chkDate.Checked) { cmbDate.Enabled = true; } else { cmbDate.Enabled = false; }
  119. if (chkjudgeStoveNo.Checked) { txtjudgeStoveNo.Enabled = true; } else { txtjudgeStoveNo.Enabled = false; }
  120. }
  121. /// <summary>
  122. /// 导出
  123. /// </summary>
  124. private void ExportData()
  125. {
  126. GridHelper.ulGridToExcel(ultraGrid1, "调度停机统计");
  127. }
  128. private void doUpdate()
  129. {
  130. this.ultraGrid1.UpdateData();
  131. ArrayList list = new ArrayList();
  132. IQueryable<UltraGridRow> checkRows = this.ultraGrid1.Rows.AsQueryable().Where(" CHK = 'True'");
  133. if (checkRows.Count() == 0)
  134. {
  135. MessageUtil.ShowTips("请勾选要修改的信息");
  136. return;
  137. }
  138. foreach (UltraGridRow row in checkRows)
  139. {
  140. MilCheckDeatilSimpleEntity hsEntity = (MilCheckDeatilSimpleEntity)row.ListObject;
  141. if (hsEntity.Validflag.Equals("有效"))
  142. {
  143. hsEntity.Validflag = "1";
  144. }
  145. else if (hsEntity.Validflag.Equals("无效"))
  146. {
  147. hsEntity.Validflag = "0";
  148. }
  149. string httEntity = JSONFormat.Format(hsEntity);
  150. list.Add(httEntity);
  151. }
  152. CoreClientParam ccp = new CoreClientParam();
  153. ccp.ServerName = "com.steering.mes.zgmil.report.FrmMilDateStatistics";
  154. ccp.MethodName = "doUpdateMilCheckDeatilSimple";
  155. ccp.ServerParams = new object[] { list };
  156. ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
  157. if (ccp.ReturnCode != -1)
  158. {
  159. if (ccp.ReturnInfo.Equals("修改成功!"))
  160. {
  161. doQuery();
  162. MessageUtil.ShowTips(ccp.ReturnInfo);
  163. }
  164. else
  165. {
  166. MessageUtil.ShowTips(ccp.ReturnInfo);
  167. }
  168. }
  169. }
  170. }
  171. }