MES_Client/TGMES/Core.StlMes.Client.YdmStuffManage/锻坯下线管理/FrmForgingStockInstore.cs

using Core.Mes.Client.Comm.Format;
using Core.Mes.Client.Comm.Server;
using Core.Mes.Client.Comm.Tool;
using Core.StlMes.Client.YdmStuffManage.Entity;
using CoreFS.CA06;
using Infragistics.Win;
using Infragistics.Win.UltraWinGrid;
using System;
using System.Collections;
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.YdmStuffManage
{
    public partial class FrmForgingStockInstore : FrmBase
    {
        public FrmForgingStockInstore()
        {
            InitializeComponent();
        }
        private string[] arr = null;
        private void FrmForgingStockInstore_Load(object sender, EventArgs e)
        {
            DateTime now = DateTime.Now;
            DateTime dt1 = new DateTime(now.Year, now.Month, 1);//当月第一天
            DateTime dt2 = dt1.AddMonths(1).AddDays(-1);//当月最后一天
            this.StartTime.Value = DateTime.Parse(dt1.ToString("yyyy-MM-dd") + " 00:00:00");
            this.EndTime.Value = DateTime.Parse(dt2.ToString("yyyy-MM-dd") + " 23:59:59");
            EntityHelper.ShowGridCaption<PlnZyDzMEntity>(ultraGrid1.DisplayLayout.Bands[0]);
            EntityHelper.ShowGridCaption<PlnZyDzCEntity>(ultraGrid1.DisplayLayout.Bands[1]);
            EntityHelper.ShowGridCaption<FrgLoadingResultEntity>(ultraGrid3.DisplayLayout.Bands[0]);
            EntityHelper.ShowGridCaption<YdmGpInlistEntity>(ultraGrid4.DisplayLayout.Bands[0]);
            arr = BaseMethod.InitLgPermissions(this.ValidDataPurviewIds,"C",this.ob);
        }
        /// <summary>
        /// 重写基类方法
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="ToolbarKey"></param>
        public override void ToolBar_Click(object sender, string ToolbarKey)
        {
            switch (ToolbarKey)
            {
                case "Query":
                    doQueryPlan();
                    break;
                case"doQueryInList":
                    doQueryInList();
                    break;
                case "EnsureInPut":
                    EnsureInPutData();
                    break;
                case "CancelInPut":
                    CancelInPutData();
                    break;
                case "DoBeside":
                    doBeside();
                    break;
                case"cancelDoBeside":
                    cancelDoBeside();
                    break;
                case "Close":
                    this.Close();
                    break;
            }
        }
        
        
        /// <summary>
        /// 查询炉计划
        /// </summary>
        private void doQueryPlan()
        {
            string[] L1 = new string[] { "HeatPlanNo", "StoveNo" };
            string[] L2 = new string[] { "HeatPlanNo", "StoveNo" };
            string stoveNo = "";
            string startTim = "";
            string endTim = "";
            if (!CheckQuery()) return;
            if (this.chkTim.Checked)
            {
                startTim = this.StartTime.Value.ToString("yyyy-MM-dd HH:mm:ss");
                endTim = this.EndTime.Value.ToString("yyyy-MM-dd HH:mm:ss");
            }
            if (this.chkStoveNo.Checked)
            {
                stoveNo = this.txtStoveNo.Text.Trim();
            }

            ArrayList parm = new ArrayList();
            parm.Add(stoveNo);

            List<PlnZyDzMEntity> listSource = EntityHelper.GetData<PlnZyDzMEntity>(
           "Core.LgMes.Server.Stuffmanage.FrmForgingStockInstore.doQueryPlnZyM", new object[] { parm, startTim, endTim, arr, ultraOptionSet2.CheckedItem.DataValue.ToString() }, this.ob);
            FrgLoadingResultEntitybindingSource.Clear();
            List<PlnZyDzCEntity> listSource2 = EntityHelper.GetData<PlnZyDzCEntity>(
           "Core.LgMes.Server.Stuffmanage.FrmForgingStockInstore.doQueryPlnZyC", new object[] { parm }, this.ob);
            EntityHelper.AddEntityRelation(listSource, listSource2, L1, L2);
            PlnZyDzMEntitybindingSource.DataSource = listSource;
           
        }
        /// <summary>
        /// 查询交库实绩
        /// </summary>
        private void doQueryInList()
        {
            string stoveNo = "";
            string startTim = "";
            string endTim = "";
            if (!CheckQuery()) return;
            if (this.chkTim.Checked)
            {
                startTim = this.StartTime.Value.ToString("yyyy-MM-dd HH:mm:ss");
                endTim = this.EndTime.Value.ToString("yyyy-MM-dd HH:mm:ss");
            }
            if (this.chkStoveNo.Checked)
            {
                stoveNo = this.txtStoveNo.Text.Trim();
            }

            ArrayList parm = new ArrayList();
            parm.Add(stoveNo);

            List<YdmGpInlistEntity> listSource = EntityHelper.GetData<YdmGpInlistEntity>(
           "Core.LgMes.Server.Stuffmanage.FrmForgingStockInstore.doQueryInList", new object[] { parm, startTim, endTim,arr }, this.ob);
            YdmGpInlistEntitybindingSource.DataSource = listSource;
        }
        /// <summary>
        /// 数据验证
        /// </summary>
        /// <returns></returns>
        private bool CheckQuery()
        {
            if (this.chkStoveNo.Checked && string.IsNullOrEmpty(this.txtStoveNo.Text.Trim()))
            {
                MessageUtil.ShowWarning("请输入判定炉号!");
                return false;
            }
            return true;
        }
        /// <summary>
        /// 交库
        /// </summary>
        private void EnsureInPutData()
        {
            this.ultraGrid3.UpdateData();
            UltraGridRow uRow = this.ultraGrid1.ActiveRow;
            string storeNo = "";
            string strInBound = "800701";
            string departId = ClsLoad.GetDepartIdBySectionId(this.UserInfo.GetDeptid(), this.ob);
            string departMent = ClsLoad.GetDepartBySectionId(this.UserInfo.GetDeptid(), this.ob);
            string[] storeType = new string[4];
            IQueryable<UltraGridRow> checkMagRows = this.ultraGrid3.Rows.AsQueryable().Where(" CHK = 'True'");
            if (checkMagRows.Count() == 0)
            {
                MessageUtil.ShowTips("请勾选可交库信息!");
                return;
            }
            if (uRow.Cells["PlineCode"].Text.Equals("C005"))
            {
                storeNo = "XED1";
            }
            else
            {
                MessageUtil.ShowTips("未获取到所在科室,无法交库!");
                return;
            }
            storeType = getStoreType(storeNo);
            ArrayList parmList = new ArrayList();
            foreach(UltraGridRow row in checkMagRows)
            {
                FrgLoadingResultEntity frgLoadingEntity = (FrgLoadingResultEntity)row.ListObject;
                string frgLoadingTity = JSONFormat.Format(frgLoadingEntity);
                parmList.Add(frgLoadingTity);
            }
            if (MessageUtil.ShowYesNoAndQuestion("是否入库?") == DialogResult.No)
            {
                return;
            }
            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "Core.LgMes.Server.Stuffmanage.FrmForgingStockInstore";
            ccp.MethodName = "ensureInPutData";
            ccp.ServerParams = new object[] { parmList, storeNo, strInBound, storeType, this.UserInfo.GetUserName(), this.UserInfo.GetDeptid(), this.UserInfo.GetDepartment(), departId, departMent };
            ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            if (ccp.ReturnCode != -1)
            {
                if (ccp.ReturnInfo.Equals("入库成功!"))
                {
                    doQueryPlan();
                    MessageUtil.ShowTips(ccp.ReturnInfo);
                }
                else
                {
                    MessageUtil.ShowTips(ccp.ReturnInfo);
                }
            }
        }

        /// <summary>
        /// 查询仓库类型
        /// </summary>
        /// <param name="storeNo"></param>
        /// <returns></returns>
        private string[] getStoreType(string storeNo)
        {
            string[] storeType = new string[4];
            DataTable dt = ServerHelper.GetData("Core.LgMes.Server.Stuffmanage.FrmStuffInputStore.getStoreType", new object[] { storeNo }, ob);
            if (dt.Rows.Count > 0)
            {
                storeType[0] = dt.Rows[0]["STORAGE_ATTR"].ToString();
                storeType[1] = dt.Rows[0]["STORAGE_ATTR_NAME"].ToString();
                storeType[2] = dt.Rows[0]["STORAGE_TYPE_NO"].ToString();
                storeType[3] = dt.Rows[0]["STORAGE_TYPE_NAME"].ToString();
            }
            return storeType;
        }
        /// <summary>
        /// 撤销交库
        /// </summary>
        private void CancelInPutData()
        {
            this.ultraGrid4.UpdateData();
            IQueryable<UltraGridRow> checkMagRows = this.ultraGrid4.Rows.AsQueryable().Where(" CHK = 'True'");
            if (checkMagRows.Count() == 0)
            {
                MessageUtil.ShowTips("请勾选需要撤销的入库实绩!");
                return;
            }
            ArrayList parm = new ArrayList();
            foreach (UltraGridRow uRow in checkMagRows)
            {
                YdmGpInlistEntity ydmGpInListEntity = (YdmGpInlistEntity)uRow.ListObject;
                string inListTity = JSONFormat.Format(ydmGpInListEntity);
                parm.Add(inListTity);
            }
            if (MessageUtil.ShowYesNoAndQuestion("是否撤销入库?") == DialogResult.No)
            {
                return;
            }
            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "Core.LgMes.Server.Stuffmanage.FrmForgingStockInstore";
            ccp.MethodName = "cancelInPutData";
            ccp.ServerParams = new object[] { parm };
            ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            if (ccp.ReturnCode != -1)
            {
                if (ccp.ReturnInfo.Equals("撤销入库成功!"))
                {
                    doQueryInList();
                    MessageUtil.ShowTips(ccp.ReturnInfo);
                }
                else
                {
                    MessageUtil.ShowTips(ccp.ReturnInfo);
                }
            }
        }
        /// <summary>
        /// 结炉
        /// </summary>
        private void doBeside()
        {
            this.ultraGrid1.UpdateData();
            UltraGridRow uRow = this.ultraGrid1.ActiveRow;
            if (uRow == null || uRow.HasParent())
            {
                return;
            }
            if (!uRow.Cells["NodeEstatus"].Text.Equals("上料完成"))
            {
                MessageUtil.ShowTips("上料未结炉,不允许结炉!");
                return;
            }
            DataTable ds = ServerHelper.GetData("Core.LgMes.Server.Stuffmanage.FrmForgingStockInstore.doQueryLoading", new object[] { uRow.Cells["HeatPlanNo"].Text }, ob);
            if (int.Parse(ds.Rows[0][0].ToString()) > 0)
            {
                MessageUtil.ShowTips("还有未入库的管坯，不允许结炉!");
                return;
            }
            PlnZyDzMEntity plnZyC = (PlnZyDzMEntity)uRow.ListObject;
            string plnZyTity = JSONFormat.Format(plnZyC);
            ServerHelper.SetData("Core.LgMes.Server.Stuffmanage.FrmForgingStockInstore.doBeside", new object[] { plnZyTity }, ob);
            doQueryPlan();
            MessageUtil.ShowTips("结炉成功!");
        }

        /// <summary>
        /// 撤销结炉
        /// </summary>
        private void cancelDoBeside()
        {
            this.ultraGrid1.UpdateData();
            UltraGridRow uRow = this.ultraGrid1.ActiveRow;
            if (uRow == null || uRow.HasParent())
            {
                return;
            }
            if (!uRow.Cells["NodeEstatus"].Text.Equals("下线完成"))
            {
                MessageUtil.ShowTips("下线未结炉,不允许结炉回退!");
                return;
            }
            ArrayList parmList = new ArrayList();
            parmList.Add(uRow.Cells["StoveNo"].Text);
            parmList.Add(uRow.Cells["JudgeStoveNo"].Text);
            parmList.Add(uRow.Cells["ProPlanId"].Text);
            parmList.Add(uRow.Cells["GxPlanNo"].Text);
            DataTable ds = ServerHelper.GetData("Core.LgMes.Server.Stuffmanage.FrmForgingStockInstore.doQueryJudgeApply", new object[] { parmList }, ob);
            if (int.Parse(ds.Rows[0][0].ToString()) > 0)
            {
                MessageUtil.ShowTips("该熔炼炉已有申请判定，不允许结炉回退!");
                return;
            }
            PlnZyDzMEntity plnZyC = (PlnZyDzMEntity)uRow.ListObject;
            string plnZyTity = JSONFormat.Format(plnZyC);
            ServerHelper.SetData("Core.LgMes.Server.Stuffmanage.FrmForgingStockInstore.cancelDoBeside", new object[] { plnZyTity }, ob);
            doQueryPlan();
            MessageUtil.ShowTips("结炉回退成功!");
        }


        private void chkTim_CheckedChanged(object sender, EventArgs e)
        {
            this.StartTime.Enabled = this.EndTime.Enabled = this.chkTim.Checked;
        }

        private void chkStoveNo_CheckedChanged(object sender, EventArgs e)
        {
            this.txtStoveNo.Enabled = this.chkStoveNo.Checked;
        }

        private void ultraTabControl1_SelectedTabChanged(object sender, Infragistics.Win.UltraWinTabControl.SelectedTabChangedEventArgs e)
        {
            if (toolMenu == null) return;
            if(ultraTabControl1.SelectedTab.Key == "0")
            {
                if (toolMenu.Toolbars[0].Tools.Exists("Query"))
                {
                    toolMenu.Toolbars[0].Tools["Query"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("doQueryInList"))
                {
                    toolMenu.Toolbars[0].Tools["doQueryInList"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("EnsureInPut"))
                {
                    toolMenu.Toolbars[0].Tools["EnsureInPut"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("DoBeside"))
                {
                    toolMenu.Toolbars[0].Tools["DoBeside"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("CancelInPut"))
                {
                    toolMenu.Toolbars[0].Tools["CancelInPut"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("cancelDoBeside"))
                {
                    toolMenu.Toolbars[0].Tools["cancelDoBeside"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                this.chkTim.Text = "计划日期";
                ultraOptionSet2.Visible = true;
            }
            else if (ultraTabControl1.SelectedTab.Key == "1")
            {
                if (toolMenu.Toolbars[0].Tools.Exists("Query"))
                {
                    toolMenu.Toolbars[0].Tools["Query"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("doQueryInList"))
                {
                    toolMenu.Toolbars[0].Tools["doQueryInList"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("EnsureInPut"))
                {
                    toolMenu.Toolbars[0].Tools["EnsureInPut"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("DoBeside"))
                {
                    toolMenu.Toolbars[0].Tools["DoBeside"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("CancelInPut"))
                {
                    toolMenu.Toolbars[0].Tools["CancelInPut"].InstanceProps.Visible = DefaultableBoolean.True;
                }
                if (toolMenu.Toolbars[0].Tools.Exists("cancelDoBeside"))
                {
                    toolMenu.Toolbars[0].Tools["cancelDoBeside"].InstanceProps.Visible = DefaultableBoolean.False;
                }
                this.chkTim.Text = "入库日期";
                ultraOptionSet2.Visible = false;
            }
        }
        private void FrmForgingStockInstore_Shown(object sender, EventArgs e)
        {
            if (toolMenu == null) return;
            if (toolMenu.Toolbars[0].Tools.Exists("doQueryInList"))
            {
                toolMenu.Toolbars[0].Tools["doQueryInList"].InstanceProps.Visible = DefaultableBoolean.False;
            }
            if (toolMenu.Toolbars[0].Tools.Exists("CancelInPut"))
            {
                toolMenu.Toolbars[0].Tools["CancelInPut"].InstanceProps.Visible = DefaultableBoolean.False;
            }
        }

        private void ultraGrid1_AfterRowActivate(object sender, EventArgs e)
        {
            UltraGridRow row = this.ultraGrid1.ActiveRow;
            if (row == null)
            {
                return;
            }
            if (row.HasChild())
            {
                return;
            }
            List<FrgLoadingResultEntity> listSource = EntityHelper.GetData<FrgLoadingResultEntity>(
           "Core.LgMes.Server.Stuffmanage.FrmForgingStockInstore.doQueryLoadResult", new object[] { row.Cells["HeatPlanNo"].Text, row.Cells["StoveNo"].Text, row.Cells["JudgeStoveNo"].Text }, this.ob);
            FrgLoadingResultEntitybindingSource.DataSource = listSource;
            foreach(UltraGridRow uRow in this.ultraGrid3.Rows)
            {
                uRow.Cells["CHK"].Value = "True";
            }
        }

    }
}