MES_Client/TGMES/Core.StlMes.Client.Mcp/CollarLibrary/FrmCollarInBound.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.CollarMaterial;
using Core.StlMes.Client.Mcp.Common;
using Core.StlMes.Client.Mcp.Control;
using Core.StlMes.Client.Mcp.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.Threading;
using System.Windows.Forms;

namespace Core.StlMes.Client.Mcp.CollarLibrary
{
    public partial class FrmCollarInBound : FrmBase
    {
        private string strOutbound = "800703";//入库类型编码
        private string strOutname = "";//入库类型名称

        private TalentICTGXControl.TalentICTGXClass icClass;

        public FrmCollarInBound()
        {
            this.IsLoadUserView = true;
            InitializeComponent();
            try
            {
                string[] portnames = System.IO.Ports.SerialPort.GetPortNames();      //获取计算机串口数组

                if (portnames is Infragistics.Win.UltraWinGrid.Nullable || portnames.Length < 1)
                {
                    portnames = new string[10] { "COM1", "COM2", "COM3", "COM4", "COM5", "COM6", "COM7", "COM8", "COM9", "COM10" };
                }
                txtCom.DataSource = portnames;
            }
            catch (Exception eex3)
            {
                MessageBox.Show(eex3.Message);
            }

        }

        private void FrmCollarInBound_Load(object sender, EventArgs e)
        {
            StorInfo();
            getStoreAll();
            RegStartTime.Value = DateTime.Parse(DateTime.Today.ToString("yyyy-MM-dd") + " 00:00:00");
            RegEndTime.Value = DateTime.Parse(DateTime.Today.AddDays(1).AddSeconds(-1).ToString("yyyy-MM-dd") + " 23:59:59");
            EntityHelper.ShowGridCaption<CouplingMatDealEntity>(ultraGrid2.DisplayLayout.Bands[0]);

            DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.common.WarehousePermissions.getKepNo", null, this.ob);
            cmbMaterial.DataSource = dt;
            cmbMaterial.DisplayMember = "KEP_NO";
            PipeManageClass.SetComboItemHeight(cmbMaterial);

            PipeManageClass.setUltraGridColumnInput(ultraGrid2, new string[] { "DealNum" });//支数
            PipeManageClass.setUltraGridColumnMaxInput(ultraGrid2, new string[] { "DealWt" });//重量
        }
        /// <summary>
        /// 重写基类方法
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="ToolbarKey"></param>
        public override void ToolBar_Click(object sender, string ToolbarKey)
        {
            switch (ToolbarKey)
            {
                case "Query":            
                    doQuery();
                    break;
                case "Add":
                    doAdd();
                    break;
                case "Delete":
                    doDelete();
                    break;
                //case "Refresh":
                //    doRefresh();
                //    break;
                case "Export":
                        GridHelper.ulGridToExcel(ultraGrid2, "交易实绩表");   
                    break;
                case "ReadCard":
                    readData();
                    break;
                case "Close":
                    this.Close();
                    break;
                case "clearCard":
                    clearCard();
                    break;
            }
        }


        void icClass_OnFindCard()
        {

            icClass.OnFindCard -= new TalentICTGXControl.ITalentICTGXEvents_OnFindCardEventHandler(icClass_OnFindCard);
            icClass.OnDropCard += new TalentICTGXControl.ITalentICTGXEvents_OnDropCardEventHandler(icClass_OnDropCard);
        }

        void icClass_OnDropCard()
        {

            //将OnDropCard事件从委托链中删除，并加入OnFindCard事件到委托链中。
            //这样就实现了程序中自动寻卡的功能。
            icClass.OnDropCard -= new TalentICTGXControl.ITalentICTGXEvents_OnDropCardEventHandler(icClass_OnDropCard);
            icClass.OnFindCard += new TalentICTGXControl.ITalentICTGXEvents_OnFindCardEventHandler(icClass_OnFindCard);
        }

        /// <summary>
        /// 读卡
        /// </summary>
        private void readData()
        {
            WaitingForm2 wf = new WaitingForm2("正在加载,请稍候....");
            try
            {
                string outdoc = "";
                if (!ConnectCard(wf))
                {
                    disConnect();
                    wf.Close();
                    return;
                }
                icClass.PrepareReadTemp();
                //bool b = icClass.DoReadTemp(1, 39);
                if (icClass.DoReadTemp(1, 39))
                {
                    int count = icClass.RecordCount;
                    if (count == 0) //判断卡上的记录数
                    {
                        wf.Close();
                        MessageUtil.ShowTips("IC卡无记录，请核实!");
                        disConnect();
                        return;
                    }
                    else
                    {
                        outdoc = icClass.taskid.ToString2();
                    }
                    //disConnect();
                }
                else
                {
                    wf.Close();
                    MessageUtil.ShowTips("读取IC卡出现错误!");
                    disConnect();
                    return;
                }

                doQueryOutList(outdoc);
            }
            catch (Exception e)
            {
                MessageUtil.ShowTips(e.Message);
            }
            finally
            {
                disConnect();
                wf.Close();
            }
        }

        ///<summary>
        /// 关闭连接
        /// </summary>
        /// <returns></returns>
        private bool disConnect()
        {
            try
            {
                if (icClass.Active)
                {
                    icClass.AlarmBeep(1);
                    //设置Active属性为false，则断开与读卡器的连接。
                    icClass.ToFindCard = false;
                    icClass.Active = false;
                    return true;
                }
                else
                {
                    return true;
                }
            }
            catch (Exception e)
            {
                return true;
            }
        }


        /// <summary>
        /// 连接读卡器
        /// </summary>
        /// <returns></returns>
        private bool ConnectCard(WaitingForm2 wf)
        {
            try
            {
                //if (icClass == null)
                //{
                //    icClass = new TalentICTGXControl.TalentICTGXClass();
                //    //委托OnFindCard事件,icClass_OnFindCard是该事件要执行的方法。
                //    //此事件在当IC卡放到读卡器上时触发。
                //    icClass.OnFindCard += new TalentICTGXControl.ITalentICTGXEvents_OnFindCardEventHandler(icClass_OnFindCard);
                //}
                icClass = IcReadWrite.getIcClass();
                int comNum = (short)(short.Parse(txtCom.Text.Replace("COM", "")) - 1);
                icClass.CommPort = comNum;
                if (!icClass.Active)
                {
                    //利用ToFindCard属性连接读卡器，启动OnFindCard事件。
                    icClass.ToFindCard = true;
                    if (icClass.Active)
                    {
                        //AlarmBeep(int times)方法实现了让IC卡读卡器发出警示音，
                        //参数为发出几次警示音。
                        icClass.AlarmBeep(2);
                        Thread.Sleep(500);
                        return true;
                    }
                    else
                    {
                        wf.Close();
                        MessageUtil.ShowTips("读卡器连接失败!或请切换端口尝试!");
                        return false;
                    }
                }
            }
            catch (Exception e)
            {
                wf.Close();
                MessageUtil.ShowTips("读卡器连接失败!或请切换端口尝试!");
                return false;
            }
            finally
            {
                wf.Close();
            }

            return true;
        }
        /// <summary>
        /// 清卡
        /// </summary>
        private void clearCard()
        {
            string dealOrde = "";
            WaitingForm2 wf = new WaitingForm2("正在加载,请稍候....");
            try
            {
                if (ConnectCard(wf) == false)
                {
                    return;
                }
                else
                {
                    icClass.PrepareReadTemp();
                    if (icClass.DoReadTemp(1, 39))
                    {


                        dealOrde = icClass.taskid.ToString2();
                        if (dealOrde != "")
                        {
                            //DataTable ds = ServerHelper.GetData("com.steering.ydm.bc.FrmFilpOutStorage.doQueryCount", new object[] { outDoc }, ob);
                            DataTable ds = ServerHelper.GetData("com.steering.mes.mcp.CollarLibrary.FrmCollarInBound.doQueryCount", new object[] { dealOrde }, ob);
                            if (int.Parse(ds.Rows[0][0].ToString2()) > 0)
                            {
                                MessageUtil.ShowTips("此卡有未接收倒运记录,不允许清卡!");
                                return;
                            }
                        }



                    }
                    else
                    {
                        wf.Close();
                        MessageUtil.ShowTips("读取IC卡出现错误,请联系相关部门!");
                    }
                }
                icClass.ClearCard();
                icClass.AlarmBeep(1);

            }
            catch
            {

            }
            finally
            {
                disConnect();
                wf.Close();
            }
        }


        public void doQueryOutList(string dealOrde)
        {
            List<CouplingMatDealEntity> listSource = EntityHelper.GetData<CouplingMatDealEntity>
                    ("com.steering.mes.mcp.CollarLibrary.FrmCollarInBound.queryOutPerfo", new object[] { dealOrde }, this.ob);
            couplingMatDealEntityBindingSource.DataSource = listSource;
        }


        private void doQuery()
        {
            string strRegStart = "";
            string strRegEnd = "";
            string strWare = "";//仓库号
            string strMat = "";//框号
            string strFurnace = "";
            if (!CheckQuery()) return;
            ArrayList pram = new ArrayList();
            if (chkWarehous.Checked)
            {
                    strWare = cmbWarehous.Value.ToString();                
            }
            if (chkMaterial.Checked)
            {
                
                strMat = cmbMaterial.Value.ToString();
            }
            if (chkRegTime.Checked)
            {
                strRegStart = RegStartTime.Value.ToString();
                strRegEnd = RegEndTime.Value.ToString();
            }

            if (chkFurnace.Checked)
            {
                    strFurnace = txtFurnace.Text.Trim(); 
            }
            pram.Clear();
            pram.Add(strWare);
            pram.Add(strMat);
            pram.Add(strFurnace);
            pram.Add(strRegStart);
            pram.Add(strRegStart);
            pram.Add(strRegStart);
            pram.Add(strRegEnd);
            pram.Add(strRegEnd);

            string[] str = this.ValidDataPurviewIds;

            //获取用户对应科室ID
            string User = this.UserInfo.GetDeptid();
            string StorageType = "";//根据传递的参数获取仓库类别
            string StorageAttr = "";////根据传递的参数获取仓库类型
            if (CustomInfo != "")
            {
                string[] strflg = CustomInfo.ToString().Split(new char[] { ',' });
                StorageType = strflg[0];
                StorageAttr = strflg[1];
            }
            string[] arr = null;
            DataTable ds = ServerHelper.GetData("com.steering.mes.mcp.common.WarehousePermissions.getStoreNo", new object[] { StorageType, StorageAttr, str }, this.ob);
            if (ds.Rows.Count > 0)
            {
                arr = new string[ds.Rows.Count];
                for (int i = 0; i < ds.Rows.Count; i++)
                {
                    arr[i] = ds.Rows[i][0].ToString();
                }
            }
            if (arr == null)
            {
                MessageUtil.ShowTips("无仓库权限!");
                return;
            }
            if (arr.Length < 1)
            {
                return;
            }
            if (ChkOut.Checked)
            {
                List<CouplingMatDealEntity> listSource = EntityHelper.GetData<CouplingMatDealEntity>
                    ("com.steering.mes.mcp.CollarLibrary.FrmCollarInBound.queryOutPerfo", new object[] { pram, arr }, this.ob);
                couplingMatDealEntityBindingSource.DataSource = listSource;
                //GridHelper.RefreshAndAutoSize(ultraGrid2);
            }
            else
            {
                List<CouplingMatDealEntity> listSource = EntityHelper.GetData<CouplingMatDealEntity>
                    ("com.steering.mes.mcp.CollarLibrary.FrmCollarInBound.queryInPerfo", new object[] { pram, arr }, this.ob);
                couplingMatDealEntityBindingSource.DataSource = listSource;
                //GridHelper.RefreshAndAutoSize(ultraGrid2);
                
            }

        }
        /// <summary>
        /// 获取仓库
        /// </summary>
        private void StorInfo()
        {
            string[] str = this.ValidDataPurviewIds;
            ArrayList arList = new ArrayList();
            //获取用户对应科室ID
            string User = this.UserInfo.GetDeptid();
            string StorageType = "";//根据传递的参数获取仓库类别
            string StorageAttr = "";////根据传递的参数获取仓库类型
            if (CustomInfo != "")
            {
                string[] strflg = CustomInfo.ToString().Split(new char[] { ',' });
                StorageType = strflg[0];
                StorageAttr = strflg[1];
            }
            DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.common.WarehousePermissions.getStoreNo", new object[] { StorageType, StorageAttr, str }, this.ob);
            mbStorage.DataSource = dt;
            mbStorage.DisplayMember = "STORAGE_NAME";
            mbStorage.ValueMember = "STORAGE_NO";
            PipeManageClass.SetComboItemHeight(mbStorage);

            cmbWarehous.DataSource = dt;
            cmbWarehous.DisplayMember = "STORAGE_NAME";
            cmbWarehous.ValueMember = "STORAGE_NO";
            PipeManageClass.SetComboItemHeight(cmbWarehous);

        }
        /// <summary>
        /// 获取所有的目标库
        /// </summary>
        private void getStoreAll()
        {
            string StorageType = "";//根据传递的参数获取仓库类别
            string StorageAttr = "";////根据传递的参数获取仓库类型
            //if (CustomInfo != "")
            //{
            //    string[] strflg = CustomInfo.ToString().Split(new char[] { ',' });
            //    StorageType = strflg[0];
            //    StorageAttr = strflg[1];
            //}
            string[] arr = McpBaseHelper.WarehousePermissions(this.CustomInfo, this.ValidDataPurviewIds, this.ob);
            DataTable dt = ServerHelper.GetData("com.steering.mes.mcp.common.WarehousePermissions.getStoreAll", new object[] { "800206", arr }, this.ob);
            //cmbWarehous.DataSource = dt;
            //cmbWarehous.DisplayMember = "STORAGE_NAME";
            //cmbWarehous.ValueMember = "STORAGE_NO";
            //PipeManageClass.SetComboItemHeight(cmbWarehous);

            CKstorage.DataSource = dt;
            CKstorage.DisplayMember = "STORAGE_NAME";
            CKstorage.ValueMember = "STORAGE_NO";
            PipeManageClass.SetComboItemHeight(CKstorage);
        }
        ///查询时验证必填项      
        private bool CheckQuery()
        {
            if (DataTimeUtil.JudgeTime(DateTime.Parse(RegStartTime.Value.ToString()), DateTime.Parse(RegEndTime.Value.ToString())) == 0)
            {
                MessageUtil.ShowTips("开始时间不能大于结束时间！");
                return false;
            }
            if (chkWarehous.Checked && string.IsNullOrEmpty(cmbWarehous.Text.Trim()))
            {
                MessageBox.Show("请选择仓库号！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                return false;
            }
            //if (chkMaterial.Checked && string.IsNullOrEmpty(cmbMaterial.Text.Trim()))
            //{
            //    MessageBox.Show("请选择料位号！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
            //    return false;
            //}
            if (chkFurnace.Checked && string.IsNullOrEmpty(txtFurnace.Text.Trim()))
            {
                MessageBox.Show("请输入炉号！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                return false;
            }
            return true;
        }
        /// <summary>
        /// 验证Checked是否勾选，显示控件可编辑 打勾表示可编辑，不打勾表示不可编辑
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void chk_CheckedChanged(object sender, EventArgs e)
        {
            if (chkWarehous.Checked) { cmbWarehous.Enabled = true; } else { cmbWarehous.Enabled = false; }
            if (chkMaterial.Checked) { cmbMaterial.Enabled = true; } else { cmbMaterial.Enabled = false; }
            if (chkFurnace.Checked) { txtFurnace.Enabled = true; } else { txtFurnace.Enabled = false; }
            if (chkRegTime.Checked) { RegStartTime.Enabled = true; RegEndTime.Enabled = true; } else { RegStartTime.Enabled = false; RegEndTime.Enabled = false; }
        }

        private void FrmCollarInBound_Shown(object sender, EventArgs e)
        {
            toolMenu.Toolbars[0].Tools["Delete"].InstanceProps.Visible = DefaultableBoolean.False;
        }

        /// <summary>
        /// 回车键查询
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void txtFurnace_KeyDown(object sender, KeyEventArgs e)
        {
            if (e.KeyValue == 13)
            {
                doQuery();
            }
        }
       /// <summary>
       /// 新增
       /// </summary>
        private void doAdd()
        {
            this.ultraGrid2.UpdateData();
            ArrayList list = new ArrayList();
            //查询入库类型
            DataTable dt = PipeManageClass.getComTypeInfo(strOutbound, ob);
            if (dt.Rows.Count >= 1)
            {
                strOutname = dt.Rows[0]["BASENAME"].ToString();
            }
            else
            {
                MessageUtil.ShowTips("入库类型不能为空，请确认基础信息是否有对应出库类型信息！");
                return;
            }
            int num = 0;
        
            ArrayList List = new ArrayList();
            foreach (Infragistics.Win.UltraWinGrid.UltraGridRow uRow in ultraGrid2.Rows)
            {
                if (Convert.ToBoolean(uRow.Cells["CHOOSE"].Text) == true)
                {
                    num++;
                    ArrayList pram = new ArrayList();
                    pram.Add(uRow.Cells["resultNo"].Text.ToString());
                    pram.Add(uRow.Cells["zyPlanId"].Text.ToString());
                    pram.Add(uRow.Cells["matNo"].Text.ToString());
                    pram.Add(uRow.Cells["tarKepNo"].Text.ToString());
                    pram.Add(uRow.Cells["tarStorageNo"].Value.ToString());
                    pram.Add(uRow.Cells["DealOrde"].Text.ToString());
                    pram.Add(this.UserInfo.GetUserName());
                    pram.Add(strOutbound);
                    pram.Add(strOutname);
                    pram.Add(uRow.Cells["WoId"].Text.ToString());
                    List.Add(pram);
                }
            } 
            if (num == 0)
            {
                MessageUtil.ShowTips("请选择需要操作的数据!");
                return;
            }
            if (MessageUtil.ShowYesNoAndQuestion("是否确认收料？") == DialogResult.No) return;
            CoreClientParam ccp = new CoreClientParam();
            try
            {
                this.Cursor = Cursors.WaitCursor;          //控制鼠标的样式为等待
                if (Constant.WaitingForm == null)
                {
                    Constant.WaitingForm = new WaitingForm();
                }
                Constant.WaitingForm.ShowToUser = true;
                Constant.WaitingForm.Show();
                Constant.WaitingForm.Update();

                ccp.ServerName = "com.steering.mes.mcp.CollarLibrary.FrmCollarInBound";
                ccp.MethodName = "addOutLibResult";
                ccp.ServerParams = new object[] { List };
                ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);

                this.Cursor = Cursors.Default;
                Constant.WaitingForm.ShowToUser = false;
                Constant.WaitingForm.Close();
                Constant.WaitingForm = null;
            }
            catch (Exception ex)
            {
                this.Cursor = Cursors.Default;
                Constant.WaitingForm.ShowToUser = false;
                Constant.WaitingForm.Close();
                Constant.WaitingForm = null;
            }

            if (ccp.ReturnCode == -1) return;
            MessageUtil.ShowTips(ccp.ReturnInfo);
            if (ccp.ReturnInfo.Equals("收料成功！"))
            {
                clearCard();
                doQuery();
            }
        }

        /// <summary>
        /// 作废
        /// </summary>
        private void doDelete()
        {
            UltraGridRow ugr = this.ultraGrid2.ActiveRow;
            int count = 0;
            if (ugr == null) return;
            ArrayList list = new ArrayList();
            foreach (Infragistics.Win.UltraWinGrid.UltraGridRow uRow in ultraGrid2.Rows)
            {
                if (Convert.ToBoolean(uRow.Cells["CHOOSE"].Text) == true)
                {
                    count += 1;
                    ArrayList pram = new ArrayList();
                    pram.Add(uRow.Cells["resultNo"].Text.Trim());
                    pram.Add(uRow.Cells["zyPlanId"].Text.Trim());
                    pram.Add(uRow.Cells["matNo"].Text.Trim());
                    pram.Add(uRow.Cells["tarKepNo"].Value.ToString());
                    pram.Add(uRow.Cells["tarStorageNo"].Value.ToString());
                    pram.Add(this.UserInfo.GetUserName());
                    pram.Add(uRow.Cells["dealOrde"].Text.ToString());
                    list.Add(pram);
                }
            }
            if (count == 0) { MessageUtil.ShowTips("请选择要撤销的数据"); return; }
            if (MessageUtil.ShowYesNoAndQuestion("是否确认撤销？") == DialogResult.No) return;
            CoreClientParam ccp = new CoreClientParam();
            try
            {
                this.Cursor = Cursors.WaitCursor;          //控制鼠标的样式为等待
                if (Constant.WaitingForm == null)
                {
                    Constant.WaitingForm = new WaitingForm();
                }
                Constant.WaitingForm.ShowToUser = true;
                Constant.WaitingForm.Show();
                Constant.WaitingForm.Update();

                ccp.ServerName = "com.steering.mes.mcp.CollarLibrary.FrmCollarInBound";
                ccp.MethodName = "deleteOutLibResult";
                ccp.ServerParams = new object[] { list };
                ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);

                this.Cursor = Cursors.Default;
                Constant.WaitingForm.ShowToUser = false;
                Constant.WaitingForm.Close();
                Constant.WaitingForm = null;
            }
            catch (Exception ex)
            {
                this.Cursor = Cursors.Default;
                Constant.WaitingForm.ShowToUser = false;
                Constant.WaitingForm.Close();
                Constant.WaitingForm = null;
            }

            if (ccp.ReturnCode == -1) return;
            MessageUtil.ShowTips(ccp.ReturnInfo);
            if (ccp.ReturnInfo.Equals("撤销收料成功！"))
            {
                doQuery();
            }
        }

        private void ultraGrid2_AfterSelectChange(object sender, AfterSelectChangeEventArgs e)
        {
            foreach (UltraGridRow uRow in ultraGrid2.Selected.Rows)
            {
                if (uRow.GetType() != typeof(Infragistics.Win.UltraWinGrid.UltraGridGroupByRow))
                {
                    uRow.Cells["CHOOSE"].Value = true;
                }
            }
        }

        private void ChkOut_CheckedChanged(object sender, EventArgs e)
        {
            if (ChkOut.Checked)
            {
                ChkIn.Checked = false;
                ultraTabControl1.Tabs[0].Text = "倒库实绩";
                //this.ultraGrid2.DisplayLayout.Bands[0].Columns["TarRecFlag"].Hidden = false;
                toolMenu.Toolbars[0].Tools["Delete"].InstanceProps.Visible = DefaultableBoolean.False;
                toolMenu.Toolbars[0].Tools["Add"].InstanceProps.Visible = DefaultableBoolean.True;
                toolMenu.Toolbars[0].Tools["ReadCard"].InstanceProps.Visible = DefaultableBoolean.True;
            }
            else
            {
                ultraTabControl1.Tabs[0].Text = "收料实绩";
                //this.ultraGrid2.DisplayLayout.Bands[0].Columns["TarRecFlag"].Hidden = true;
                toolMenu.Toolbars[0].Tools["Add"].InstanceProps.Visible = DefaultableBoolean.False;
                toolMenu.Toolbars[0].Tools["Delete"].InstanceProps.Visible = DefaultableBoolean.True;
                toolMenu.Toolbars[0].Tools["ReadCard"].InstanceProps.Visible = DefaultableBoolean.False;
            }
        }

        private void ChkIn_CheckedChanged(object sender, EventArgs e)
        {
            if (ChkIn.Checked)
            {
                ChkOut.Checked = false;
            }
        }

       
    }
}