MES_Client/TGMES/Core.StlMes.Client.Mcp.Mch/Report/FrmMeasureDetailsReport.cs

using System;
using System.Linq;
using System.Windows.Forms;
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;

namespace Core.StlMes.Client.Mcp.Mch.Report
{
    public partial class FrmMeasureDetailsReport : FrmBase
    {
        private string plineCode = "";
        private string[] plineCodes = {};

        public FrmMeasureDetailsReport()
        {
            InitializeComponent();
            IsLoadUserView = true;
        }

        public override void ToolBar_Click(object sender, string ToolbarKey)
        {
            switch (ToolbarKey)
            {
                case "DoQuery":
                    Query();
                    break;
                case "Export":
                    GridHelper.ulGridToExcel(CrackDetectGrid, "测量点明细");
                    break;
                case "DoClose":
                    Close();
                    break;
                case "ChangePline":
                    ChangePline();
                    break;
            }
        }

        private void Query()
        {
            var Message = "";
            var wf = new WaitingForm2("正在查询，请稍候....");
            try
            {
                Cursor = Cursors.WaitCursor;
                QuerySinglePlan();
                GridHelper.RefreshAndAutoSizeExceptColumns(CrackDetectGrid, "ReportPath");
            }
            catch (Exception ex)
            {
                if (ex.Message.ToString2() != "")
                    Message = ex.Message;
            }
            finally
            {
                wf.Close();
                Cursor = Cursors.Default;
            }

            if (!string.IsNullOrWhiteSpace(Message))
                MessageBox.Show(Message);
        }

        /// <summary>
        ///     测量点明细查询
        /// </summary>
        private void QuerySinglePlan()
        {
            var startTim = "";
            var endTim = "";
            var shift = ""; //班次
            var group = ""; //班组
            var OrderNo = "";
            var JudgeStoveNo = "";
            var BatchNo = "";

            #region

            if (chkOrder.Checked && (cmbOrder.Text.Trim() != ""))
                shift = cmbOrder.Value.ToString();
            if (chkTim.Checked)
            {
                if (DateTime.Parse(RegStartTime.Value.ToString()) > DateTime.Parse(RegEndTime.Value.ToString()))
                {
                    MessageUtil.ShowTips("选择时间区间错误,请重新选择!");
                    return;
                }
                startTim = RegStartTime.Value.ToString("yyyy-MM-dd HH:mm:ss");
                endTim = RegEndTime.Value.ToString("yyyy-MM-dd HH:mm:ss");
            }
            if (chkGroup.Checked && (cmbGroup.Text.Trim() != ""))
                group = cmbGroup.Value.ToString();

            if (chkOrderNo.Checked)
                OrderNo = txtOrderNo.Text;

            if (chkJudgeStove.Checked)
                JudgeStoveNo = txtJudgeStove.Text;

            if (chkBatchNo.Checked)
                BatchNo = txtBatchNo.Text;

            #endregion

            var dt = ServerHelper.GetData("com.steering.mes.mcp.Mch.FrmJgxReport.doQueryMeasureDetailsResult",
                new object[]
                {
                    shift, group,
                    chkPlineCode.Checked && !string.IsNullOrWhiteSpace(plineCode) ? new[] {plineCode} : plineCodes,
                    startTim, endTim, OrderNo, JudgeStoveNo, BatchNo, chkShow.Checked ? "1" : "0",
                    chkFlag.Checked ? "1" : "0"
                }, ob);


            GridHelper.CopyDataToDatatable(ref dt, ref dataTable1, true);
            GridHelper.RefreshAndAutoSize(CrackDetectGrid);
            //mchMeasureResultEntityBindingSource.DataSource = EntityHelper.GetData<MchMeasureResultEntity>(
            //    "com.steering.mes.mcp.Mch.FrmJgxReport.doQueryMeasureResult",
            //    new object[] { shift, group, plineCode == "" ? plineCodes : new[] { plineCode }, startTim, endTim, OrderNo, JudgeStoveNo },
            //    ob);
            //GridHelper.RefreshAndAutoSize(CrackDetectGrid);
        }

        private void FrmMeasureDetailsReport_Load(object sender, EventArgs e)
        {
            plineCodes = comm.InitDropPlineCodePower("G", txt_PlinCode, ValidDataPurviewIds, ob);


            if ((plineCodes.Length > 1) &&
                ((plineCodes[1] == "C038") || (plineCodes[1] == "C039") || (plineCodes[1] == "C049") ||
                 (plineCodes[1] == "C050") ||
                 (plineCodes[1] == "C051") || (plineCodes[1] == "C057")))
            {
                RegStartTime.Value = DateTime.Parse(DateTime.Now.AddDays(-1).ToString("yyyy-MM-dd 20:00"));
                RegEndTime.Value = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd 19:59"));
            }
            else
            {
                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"));
            }


            txt_PlinCode.SelectedIndex = 0;
            YdmBaseClass.SetComboItemHeight(cmbOrder);
            YdmBaseClass.SetComboItemHeight(cmbGroup);
            EntityHelper.ShowGridCaption<MchMeasureResultEntity>(CrackDetectGrid.DisplayLayout.Bands[0]);

            QuerySinglePlan();
        }

        private void chkStarts_CheckedChanged(object sender, EventArgs e)
        {
            if (chkTim.Checked)
            {
                RegStartTime.Enabled = true;
                RegEndTime.Enabled = true;
                RegStartTime.Visible = true;
                RegEndTime.Visible = true;
                label1.Visible = true;
            }
            else
            {
                RegStartTime.Enabled = false;
                RegEndTime.Enabled = false;
                RegStartTime.Visible = false;
                RegEndTime.Visible = false;
                label1.Visible = false;
            }
            cmbOrder.Enabled = chkOrder.Checked;
            cmbGroup.Enabled = chkGroup.Checked;
            txtOrderNo.Enabled = chkOrderNo.Checked;
            txtJudgeStove.Enabled = chkJudgeStove.Checked;
            txtBatchNo.Enabled = chkBatchNo.Checked;

            cmbOrder.Visible = chkOrder.Checked;
            cmbGroup.Visible = chkGroup.Checked;
            txtOrderNo.Visible = chkOrderNo.Checked;
            txtJudgeStove.Visible = chkJudgeStove.Checked;
            txtBatchNo.Visible = chkBatchNo.Checked;
            txt_PlinCode.Visible = chkPlineCode.Checked;
        }

        private void txt_PlinCode_TextChanged(object sender, EventArgs e)
        {
            plineCode = txt_PlinCode.SelectedItem.DataValue.ToString();
        }


        private void ChangePline()
        {
            CrackDetectGrid.UpdateData();
            var ids = CrackDetectGrid.Rows.Where(p => (bool) p.Cells["CHK"].Value)
                .
                Select(p => p.Cells["KEY_ID"].Value.ToString2()).Distinct().ToArray();


            var FrmPlineChoose = new FrmPlineChoose(ob, ids);
            if (FrmPlineChoose.ShowDialog() == DialogResult.OK)
                Query();
        }
    }
}