MES_Client/TGMES/Core.StlMes.Client.Judge/Controls/QcmGpPassApplyCtrl.cs

using Core.Mes.Client.Comm.Control;
using Core.StlMes.Client.Judge.Commons;
using CoreFS.CA06;
using CoreFS.SA06;
using Infragistics.Win.UltraWinGrid;
using System;
using System.Data;
using System.Drawing;
using System.Windows.Forms;

namespace Core.StlMes.Client.Judge.Controls
{
    public partial class QcmGpPassApplyCtrl : UserControl
    {
        private Dal _d;
        private OpeBase ob;
        private string[] _validDataPurviewIds;
        public QcmGpPassApplyCtrl(Control container, OpeBase ob, string[] validDataPurviewIds)
        {
            InitializeComponent();
            _d = new Dal(ob);
            this.ob = ob;
            _validDataPurviewIds = validDataPurviewIds;
            container.Controls.Add(this);
            this.Dock = DockStyle.Fill;
            this.BringToFront();
        }

        public void Query(string stoveNo, string judgeStoveNo, string timeB, string timeE, string validflag)
        {
            DataTable dt = _d.GetTableByXmlId("QcmGpPassApplyDAL.query", stoveNo, judgeStoveNo, timeB, timeE, validflag);
            GridHelper.CopyDataToDatatable(dt, dataTable1, true);
            GridHelper.RefreshAndAutoSize(ultraGrid1);
        }

        public void AuditeQuery(string stoveNo, string judgeStoveNo, string timeB, string timeE, string customInfo,
            string auditState, string validflag,string supplyUnit)
        {
            DataTable dt;
            dt = _d.GetTableByXmlId("QcmGpPassApplyDAL.auditeQuery", stoveNo, judgeStoveNo, timeB, timeE, auditState,
                    customInfo, validflag, CoreUserInfo.UserInfo.GetUserName(), _validDataPurviewIds, supplyUnit);
            GridHelper.CopyDataToDatatable(dt, dataTable1, true);
            GridHelper.RefreshAndAutoSize(ultraGrid1);

            // if (customInfo == "Quality1")
            // {
            //     //string[] zgProPlanId = GetZgPlanId();
            //     //string designKey = QueryDesignKey(zgProPlanId[0], zgProPlanId[1]);

            // }
            // else if (customInfo == "Quality2")
            // {
            //     dt = _d.GetTableByXmlId("QcmGpPassApplyDAL.auditeQuery2", stoveNo, judgeStoveNo, timeB, timeE, auditState, "0", "1");
            //     GridHelper.CopyDataToDatatable(dt, dataTable1, true);
            // }else if (customInfo == "Urgent1")
            //{
            //     string[] zgProPlanId = GetZgPlanId();
            //     string designKey = QueryDesignKey(zgProPlanId[0], zgProPlanId[1]);
            //     dt = _d.GetTableByXmlId("QcmGpPassApplyDAL.auditeQuery", stoveNo, judgeStoveNo, timeB, timeE, auditState,
            //         CoreUserInfo.UserInfo.GetUserName(), _validDataPurviewIds.Length, _validDataPurviewIds, "1", "1");
            //     GridHelper.CopyDataToDatatable(dt, dataTable1, true);
            // }
            // else if (customInfo == "Urgent2")
            // {
            //     dt = _d.GetTableByXmlId("QcmGpPassApplyDAL.auditeQuery2", stoveNo, judgeStoveNo, timeB, timeE, auditState, "1", "1");
            //     GridHelper.CopyDataToDatatable(dt, dataTable1, true);
            // }
        }

        private string[] GetZgPlanId()
        {
            var row = ultraGrid1.ActiveRow;
            if (row == null) return new string[] { "", "" };
            DataRow drGpApply = _d.GetRowByXmlId("QcmGpJugdeApplyDAL.QueryByPk", row.GetValue("jugdeApplyCode"), row.GetValue("jugdeApplySqe"),
                row.GetValue("multipleNum"), row.GetValue("JudgeStoveNo"));
            if (drGpApply == null) return new string[] { "", "" };
            string zgProPlanId = "";
            string zgGxPlanNo = "";
            if (drGpApply["proPlanIdNext"].ToString() != "" && drGpApply["proPlanIdNext"].ToString().StartsWith("ZG"))
            {
                zgProPlanId = drGpApply["proPlanIdNext"].ToString();
                zgGxPlanNo = drGpApply["gxPlanNoNext"].ToString();
            }
            else
            {
                string zzProPlanId = "";
                if (drGpApply["proPlanIdNext"].ToString() != "")
                {
                    zzProPlanId = drGpApply["proPlanIdNext"].ToString();
                }
                else
                {
                    zzProPlanId = drGpApply["proPlanId"].ToString();
                }
                DataRow drOrderZgS = _d.GetRowByXmlId("JdgPlnOrderZgS.queryByGpreqId", zzProPlanId);
                if (drOrderZgS == null) return new string[] { "", "" };
                zgProPlanId = drOrderZgS["proPlanId"].ToString();
                zgGxPlanNo = drOrderZgS["gxPlanNo"].ToString();
            }

            return new string[] { zgProPlanId, zgGxPlanNo };
        }

        private string QueryDesignKey(string zgProPlanId, string zgGxPlanNo)
        {
            DataRow drDesignKey = _d.GetRowByXmlId("QcmGpJugdeApplyDAL.queryCraftDesignKey", zgProPlanId, zgGxPlanNo);
            if (drDesignKey == null)
            {
                return "";
            }
            else
            {
                return drDesignKey["desginKey"].ToString();
            }
        }

        private void ultraGrid1_CellChange(object sender, Infragistics.Win.UltraWinGrid.CellEventArgs e)
        {
            e.Cell.Row.Update();
        }

        private void ultraGrid1_InitializeRow(object sender, Infragistics.Win.UltraWinGrid.InitializeRowEventArgs e)
        {
            Color yellow = Color.FromArgb(238, 238, 0);
            Color red = Color.FromArgb(255, 106, 106);
            Color green = Color.FromArgb(60, 179, 113);

            if (e.Row.GetValue("validflag") == "0")
            {
                e.Row.RowSelectorAppearance.BackColor = Color.Red;
            }
            if (e.Row.GetValue("auditResult") == "审核通过" && e.Row.GetValue("auditResult2") == "审核通过")
            {
                e.Row.RowSelectorAppearance.BackColor = green;
            }
            else if (e.Row.GetValue("auditResult") == "审核通过" && e.Row.GetValue("auditResult2") == "")
            {
                e.Row.RowSelectorAppearance.BackColor = yellow;
            }
            else if (e.Row.GetValue("auditResult") == "审核不通过" || e.Row.GetValue("auditResult2") == "审核不通过")
            {
                e.Row.RowSelectorAppearance.BackColor = red;
            }
        }

        FormFileDown askDown;
        private void ultraTextEditor1_EditorButtonClick(object sender, Infragistics.Win.UltraWinEditors.EditorButtonEventArgs e)
        {
            string filePath = ultraGrid1.ActiveRow.GetValue("craftPath");
            askDown = new FormFileDown(ob, filePath);
            askDown.DeleteButton.Visible = false;
            askDown.Show();
        }

        private void ultraGrid1_MouseUp(object sender, MouseEventArgs e)
        {
            foreach (UltraGridRow row in ultraGrid1.Rows)
            {
                if (row.Selected)
                {
                    row.Cells["CHK"].Value = true;
                }
            }
            ultraGrid1.UpdateData();
        }
    }
}