using com.steering.mes.mcp.entity; using Core.Mes.Client.Comm.Control; using Core.Mes.Client.Comm.Server; using Core.Mes.Client.Comm.Tool; using Core.StlMes.Client.Mcp.Control; using CoreFS.CA06; using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; namespace Core.StlMes.Client.Mcp.Treatment.Report { public partial class FrmLoadReport : FrmBase { private string SlGx = "";//工序代码 private string SlGxname = "";//工序名称 private string departm = ""; private string plineCode = ""; private string[] plineCodes = new string[] { }; public FrmLoadReport() { InitializeComponent(); this.IsLoadUserView = true; } public override void ToolBar_Click(object sender, string ToolbarKey) { switch (ToolbarKey) { case "DoQuery": QuerySinglePlan();//外观检验 break; case "Export": GridHelper.ulGridToExcel(ultraGrid4, "热处理上料台账"); break; case "ChangePline": ChangePline(); break; case "DoUpdate": DoUpdate(); break; case "DoClose": this.Close(); break; } } /// /// 台账查询 /// private void QuerySinglePlan() { string startTim = ""; string endTim = ""; string shift = ""; //班次 string group = ""; //班组 var JudgeStoveNo = ""; #region if (this.chkOrder.Checked && this.cmbOrder.Text.Trim() != "") { shift = this.cmbOrder.Value.ToString(); } if (chkTim.Checked) { if (DateTime.Parse(RegStartTime.Value.ToString()) > DateTime.Parse(RegEndTime.Value.ToString())) { MessageUtil.ShowTips("选择时间区间错误,请重新选择!"); return; } else { startTim = this.RegStartTime.Value.ToString("yyyy-MM-dd HH:mm:ss"); endTim = this.RegEndTime.Value.ToString("yyyy-MM-dd HH:mm:ss"); } } if (this.chkGroup.Checked && this.cmbGroup.Text.Trim() != "") { group = this.cmbGroup.Value.ToString(); } if (chkJudgeStove.Checked) JudgeStoveNo = txtJudgeStove.Text; #endregion DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.Report.FrmRclReport.doQueryLoadResult", new object[] { shift, group, plineCode == "" ? plineCodes : new string[] { plineCode }, startTim, endTim, JudgeStoveNo }, this.ob); GridHelper.CopyDataToDatatable(ref dt, ref dataTable1, true); } private void ChangePline() { ultraGrid4.UpdateData(); string[] LoadInfo = ultraGrid4.Rows.Where(p => (bool)p.Cells["CHK"].Value) . Select(p => p.Cells["HEAT_PLAN_NO"].Value.ToString2() + "," + p.Cells["PLINE_CODE"].Value.ToString2()).Distinct().ToArray(); if (!LoadInfo.Any()) { MessageBox.Show("请选择需要调整产线的上料信息"); return; } var ccp = new CoreClientParam(); ccp.ServerName = "com.steering.mes.mcp.Report.FrmRclReport"; ccp.MethodName = "ChangePline"; ccp.ServerParams = new object[] { LoadInfo }; ccp = ExecuteNonQuery(ccp, CoreInvokeType.Internal); if (ccp.ReturnCode != -1) { MessageUtil.ShowTips(ccp.ReturnInfo); if (ccp.ReturnInfo.Equals("修改成功!")) QuerySinglePlan(); } } private void DoUpdate() { ultraGrid4.UpdateData(); string[] ResultNo = ultraGrid4.Rows.Where(p => (bool)p.Cells["CHK"].Value).Select(p => p.Cells["RESULT_NO"].Value.ToString2()).ToArray(); if (!ResultNo.Any()) { MessageBox.Show("请选择需要修改来源的实绩"); return; } using (FrmMatSource fm = new FrmMatSource()) { if (fm.ShowDialog() == DialogResult.OK) { var ccp = new CoreClientParam(); ccp.ServerName = "com.steering.mes.mcp.Report.FrmRclReport"; ccp.MethodName = "updateSource"; ccp.ServerParams = new object[] { ResultNo, fm.Source }; ccp = ExecuteNonQuery(ccp, CoreInvokeType.Internal); if (ccp.ReturnCode != -1) { MessageUtil.ShowTips(ccp.ReturnInfo); if (ccp.ReturnInfo.Equals("修改成功!")) QuerySinglePlan(); } } } } private void FrmLoadReport_Load(object sender, EventArgs e) { RegStartTime.Value = DateTime.Parse(DateTime.Now.AddDays(-1).ToString("yyyy-MM-dd 21:00")); RegEndTime.Value = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd 20:59")); departm = UserInfo.GetDepartment(); //plineCode = YdmBaseClass.GetPCode(departm, this.ob);//获取 用户 对应的产线 plineCodes= comm.InitDropPlineCodePower("F", txt_PlinCode, this.ValidDataPurviewIds, this.ob); txt_PlinCode.SelectedIndex = 0; YdmBaseClass.SetComboItemHeight(cmbOrder); YdmBaseClass.SetComboItemHeight(cmbGroup); //获取工序 DataTable dt2 = ServerHelper.GetData("com.steering.mes.mcp.common.PlanService.getQueryGX", new object[] { "600201" }, this.ob); if (dt2.Rows.Count > 0) { SlGx = dt2.Rows[0]["BASECODE"].ToString(); SlGxname = dt2.Rows[0]["BASENAME"].ToString(); } QuerySinglePlan(); } private void chkStarts_CheckedChanged(object sender, EventArgs e) { if (chkTim.Checked) { RegStartTime.Enabled = true; RegEndTime.Enabled = true; } else { RegStartTime.Enabled = false; RegEndTime.Enabled = false; } if (chkOrder.Checked) { cmbOrder.Enabled = true; } else { cmbOrder.Enabled = false; } if (chkGroup.Checked) { cmbGroup.Enabled = true; } else { cmbGroup.Enabled = false; } txtJudgeStove.Enabled = chkJudgeStove.Checked; } private void txt_PlinCode_TextChanged(object sender, EventArgs e) { plineCode = txt_PlinCode.SelectedItem.DataValue.ToString(); } } }