MES_Client/TGMES/Core.StlMes.Client.Mcp.Treatment/Report/FrmLoadReport.cs

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;
            }
        }
        /// <summary>
        /// 台账查询
        /// </summary>
        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();
        }
    }
}