MES_Client/TGMES/Core.StlMes.Client.Judge/Forms/QcmJyThreadReport.cs

using Core.Mes.Client.Comm.Control;
using Core.Mes.Client.Comm.Format;
using Core.Mes.Client.Comm.Server;
using Core.Mes.Client.Comm.Tool;
using Core.StlMes.Client.Judge.Commons;
using Core.StlMes.Client.Judge.Models;
using Core.StlMes.Client.Judge.ViewModels;
using CoreFS.CA06;
using Infragistics.Win;
using Infragistics.Win.UltraWinEditors;
using Infragistics.Win.UltraWinGrid;
using System;
using System.Collections;
using System.Collections.Generic;
using System.Data;
using System.Diagnostics;
using System.Drawing;
using System.Drawing.Printing;
//using Spire.Pdf;
using System.IO;
using System.Linq;
using System.Net;
using System.Windows.Forms;
//using Core.StlMes.Client.ZGMil.Signature;

namespace Core.StlMes.Client.Judge.Forms
{
    public partial class QcmJyThreadReport : FrmBase
    {
        private String  OrderNo;
        public QcmJyThreadReport()
        {
            InitializeComponent();
           
            this.IsLoadUserView = true;
        }

        private void QcmJyQueryFrm_Load(object sender, EventArgs e)
        {
            InitDate();
            EntityHelper.ShowGridCaption<YdmZcOutlistEntity>(ultraGridOrder.DisplayLayout.Bands[0]);
            EntityHelper.ShowGridCaption<QcmJyThreadReportEntity>(ultraGridThread1.DisplayLayout.Bands[0]);
            DoQuery();
            initResult();
           
        }

        private void initResult() {
            //初始化加载设备仪器
            DataTable dt1 = ServerHelper.GetData("com.steering.pss.judge.DAL.QcmJyEquipment.FindEquipmentInResult", new object[] { "螺纹量规" }, ob);
            threadReport1.ultraComboEditor1.DataSource = dt1;
            threadReport1.ultraComboEditor1.DisplayMember = "RESULT";
            threadReport1.ultraComboEditor1.ValueMember = "RESULT";
            DataTable dt2 = ServerHelper.GetData("com.steering.pss.judge.DAL.QcmJyEquipment.FindEquipmentInResult", new object[] { "游标卡尺" }, ob);
            threadReport1.ultraComboEditor2.DataSource = dt2;
            threadReport1.ultraComboEditor2.DisplayMember = "RESULT";
            threadReport1.ultraComboEditor2.ValueMember = "RESULT";
            DataTable dt3 = ServerHelper.GetData("com.steering.pss.judge.DAL.QcmJyEquipment.FindEquipmentInResult", new object[] { "深度卡尺" }, ob);
            threadReport1.ultraComboEditor3.DataSource = dt3;
            threadReport1.ultraComboEditor3.DisplayMember = "RESULT";
            threadReport1.ultraComboEditor3.ValueMember = "RESULT";
            DataTable dt4 = ServerHelper.GetData("com.steering.pss.judge.DAL.QcmJyEquipment.FindEquipmentInResult", new object[] { "测厚仪" }, ob);
            threadReport1.ultraComboEditor4.DataSource = dt4;
            threadReport1.ultraComboEditor4.DisplayMember = "RESULT";
            threadReport1.ultraComboEditor4.ValueMember = "RESULT";
            DataTable dt5 = ServerHelper.GetData("com.steering.pss.judge.DAL.QcmJyEquipment.FindEquipmentInResult", new object[] { "锥度量规" }, ob);
            threadReport1.ultraComboEditor5.DataSource = dt5;
            threadReport1.ultraComboEditor5.DisplayMember = "RESULT";
            threadReport1.ultraComboEditor5.ValueMember = "RESULT";
            DataTable dt6 = ServerHelper.GetData("com.steering.pss.judge.DAL.QcmJyEquipment.FindEquipmentInResult", new object[] { "齿高量规" }, ob);
            threadReport1.ultraComboEditor6.DataSource = dt6;
            threadReport1.ultraComboEditor6.DisplayMember = "RESULT";
            threadReport1.ultraComboEditor6.ValueMember = "RESULT";
            DataTable dt7 = ServerHelper.GetData("com.steering.pss.judge.DAL.QcmJyEquipment.FindEquipmentInResult", new object[] { "齿顶高量规" }, ob);
            threadReport1.ultraComboEditor7.DataSource = dt7;
            threadReport1.ultraComboEditor7.DisplayMember = "RESULT";
            threadReport1.ultraComboEditor7.ValueMember = "RESULT";
            DataTable dt8 = ServerHelper.GetData("com.steering.pss.judge.DAL.QcmJyEquipment.FindEquipmentInResult", new object[] { "顶径量规" }, ob);
            threadReport1.ultraComboEditor8.DataSource = dt8;
            threadReport1.ultraComboEditor8.DisplayMember = "RESULT";
            threadReport1.ultraComboEditor8.ValueMember = "RESULT";
            DataTable dt9 = ServerHelper.GetData("com.steering.pss.judge.DAL.QcmJyEquipment.FindEquipmentInResult", new object[] { "螺距量规" }, ob);
            threadReport1.ultraComboEditor9.DataSource = dt9;
            threadReport1.ultraComboEditor9.DisplayMember = "RESULT";
            threadReport1.ultraComboEditor9.ValueMember = "RESULT";
        
        }
        private void ChcCheckedChanged(object sender, EventArgs e)
        {

            if (ChcOrderNo.Checked)
            {
                TxtOrderNo.Enabled = true;
            }
            else
            {
                TxtOrderNo.Enabled = false;
            }
            if (ChcTime.Checked)
            {
                TimeBegin.Enabled = true;
                TimeEnd.Enabled = true;
            }
            else
            {
                TimeEnd.Enabled = false;
                TimeBegin.Enabled = false;
            }
            if (ChcStatus.Checked) { ComStatus.Enabled = true; } else { ComStatus.Enabled = false; }
        }

        /// <summary>
        /// 初始时间
        /// </summary>
        private void InitDate()
        {
            DateTime now = DateTime.Now;
            DateTime dt1 = new DateTime(now.Year, now.Month, 1);//当月第一天
            DateTime dt2 = dt1.AddMonths(1).AddDays(-1);//当月最后一天
            TimeBegin.Value = DateTime.Parse(dt1.ToString("yyyy-MM-dd") + " 00:00:00");
            TimeEnd.Value = DateTime.Parse(dt2.ToString("yyyy-MM-dd") + " 23:59:59");
        }



        public override void ToolBar_Click(object sender, string ToolbarKey)
        {
            switch (ToolbarKey)
            {
                case "Query":
                    DoQuery();
                    initResult();
                    break;
                case "Update":
                    DoUpdate();
                    break;
                case "Delete":
                    Delete();
                    break;
                case "doAdd":
                    DoAdd();
                    break;
                case "Close":
                    this.Close();
                    break;
            }
        }
        private ArrayList ingname = new ArrayList();

        //新增下表记录
        private void DoAdd() {
            threadReport1.ultraGrid1.UpdateData();
            UltraGridRow ugr = threadReport1.ultraGrid1.ActiveRow;

            ArrayList parmList = new ArrayList();

            QcmJyThreadReportEntity thread = (QcmJyThreadReportEntity)ugr.ListObject;
            string threadTity = JSONFormat.Format(thread);
            parmList.Add(threadTity);

            ArrayList param = new ArrayList();
            param.Add(OrderNo);
            List<QcmJyThreadReportEntity> listSource = EntityHelper.GetData<QcmJyThreadReportEntity>(
            "com.steering.pss.judge.DAL.QcmJyThreadReport.FindThreadReport", new object[] { param }, this.ob);

            if (listSource.Count== 0)
            {
                 int count = ServerHelper.SetData("com.steering.pss.judge.DAL.QcmJyThreadReport.AddThreadReport", new object[] { parmList }, ob);
                if (count > 0)
                {
                    MessageUtil.ShowTips("新增螺纹检验信息成功！");
                    DoQuery();
                }
                else {
                    MessageUtil.ShowTips("新增失败!"); return;
                }
           }else{
                    MessageUtil.ShowTips("新增失败，该合同号已有螺纹检验信息，不可重复添加,请尝试一下修改哦！"); return;
           }
        }

        public string spathName = "";
        private List<Image> ing = new List<Image>();
        private List<FileBean> list = new List<FileBean>();


        /// <summary>
        /// 修改下表记录
        /// </summary>
        private void DoUpdate()
        {
            threadReport1.ultraGrid1.UpdateData();
            UltraGridRow ugr = threadReport1.ultraGrid1.ActiveRow;

            ArrayList parmList = new ArrayList();

            QcmJyThreadReportEntity thread = (QcmJyThreadReportEntity)ugr.ListObject;
            string threadTity = JSONFormat.Format(thread);
            parmList.Add(threadTity);
            int count = ServerHelper.SetData("com.steering.pss.judge.DAL.QcmJyThreadReport.UpdateThreadReport", new object[] { parmList }, ob);
            if (count > 0)
            {
                MessageUtil.ShowTips("修改成功！");
                DoQuery();
            }
            else
            {
                MessageUtil.ShowTips("修改失败！"); return;
            }
        }
        /// <summary>
        /// 删除下表记录
        /// </summary>
        private void Delete()
        {
            ultraGridThread1.UpdateData();
            ArrayList pram1 = new ArrayList();
            //获取已选择的列
            //IQueryable<UltraGridRow> uGrid = ultraGridThread1.Rows.AsQueryable().Where(" CHK = 'True'");
            //if (uGrid.Count() == 0)
            //{
            //    MessageUtil.ShowTips("请选择要删除的数据！");
            //    return;
            //}
            if (MessageUtil.ShowYesNoAndQuestion("是否确认删除该条螺纹检验报告信息？") == System.Windows.Forms.DialogResult.No)
            {
                return;
            }
            //foreach (UltraGridRow ugr in uGrid)
            //{
               ArrayList pram = new ArrayList();
               pram.Add(OrderNo);
               pram1.Add(pram);//由于合同号与螺纹信息 属于一对一关系  合同号为一开始选择的合同号/
            //}

            int countinsert = ServerHelper.SetData("com.steering.pss.judge.DAL.QcmJyThreadReport.deleteThreadReport", new Object[] { pram1 }, this.ob);

            if (countinsert > 0)
            {
                MessageUtil.ShowTips("删除成功！");
            }
            else
            {
                MessageUtil.ShowTips("删除失败！,请联系编程人员"); return;
            }
            DoQuery();
        }
        /// <summary>
        /// 查询上表信息
        /// </summary>
        private void DoQuery()
        {
            ArrayList param = new ArrayList();
            string orderNo = "";
            if (ChcOrderNo.Checked)
            {
                orderNo = TxtOrderNo.Text.Trim();
            }
            string strBegin = "1900-01-01 00:00:00";
            string strEnd = "9900-01-01 00:00:00";
            if (ChcTime.Checked)
            {
                if (TimeBegin.Value == null || TimeEnd.Value == null)
                {
                    MessageUtil.ShowWarning("请选择正确的时间");
                    return;
                }
                strBegin = TimeBegin.Value.ToString();
                strEnd = TimeEnd.Value.ToString();
            }

            param.Add(orderNo);
            param.Add(strBegin);
            param.Add(strEnd);
            if (ultraTabControl2.SelectedTab.Index == 0)
            {
                List<YdmZcOutlistEntity> listSource = EntityHelper.GetData<YdmZcOutlistEntity>(
               "com.steering.pss.judge.DAL.QcmJyQueryFrm.getOrderInfo", new object[] { param }, this.ob);//查找合同信息
                ydmZcOutlistEntityBindingSource1.DataSource = listSource;
            }
           


        }

        /// <summary>
        /// 根据出库表去查询螺纹表信息 多个记录
        /// </summary>
        /// <param name="orderNo"></param>
        private void QueryThreadReportInfobyQcmJyQueryFrm(string orderNo)
        {
            ultraGridThread1.UpdateData();
            ArrayList param = new ArrayList();
            param.Add(orderNo);
            
            List<QcmJyThreadReportEntity> listSource = EntityHelper.GetData<QcmJyThreadReportEntity>(
            "com.steering.pss.judge.DAL.QcmJyThreadReport.FindThreadReport", new object[] { param }, this.ob);

            List<QcmJyThreadReportEntity> listSource2 = EntityHelper.GetData<QcmJyThreadReportEntity>(
            "com.steering.pss.judge.DAL.QcmJyThreadReport.FindThreadReport", new object[] { param }, this.ob);
            //将信息赋值到下表
            QcmJyThreadReportEntityBindingSource1.DataSource = listSource;
            //将信息赋值到中表
            threadReport1.qcmJyThreadReportEntityBindingSource.DataSource = listSource2;

            QcmJyThreadReportEntity thread = new QcmJyThreadReportEntity();
            if (listSource.Count < 1) {//如果数据库中没有螺纹信息记录  则创建合同号 根据上表所选中的合同号
                thread.OrderNo = OrderNo;
                threadReport1.qcmJyThreadReportEntityBindingSource.DataSource = new List<QcmJyThreadReportEntity>() { thread };
            }
               
        }
        DataTable dtzbs = new DataTable();
        //单击上表 行的事件   根据合同号查找螺纹信息
        private void ultraGridOrder_AfterRowActivate_1(object sender, EventArgs e)
        {
            UltraGridRow ugr = ultraGridOrder.ActiveRow;
            if (ugr == null)
            {
                return;
            }
            OrderNo = ugr.Cells["OrderNo"].Text.ToString();
            QueryThreadReportInfobyQcmJyQueryFrm(OrderNo);
        }
        private void ultraGridThread1_AfterRowActivate(object sender, EventArgs e)
        {
            UltraGridRow ug = ultraGridThread1.ActiveRow;
            if (ug == null)
            {
                return;
            }
            //将下表信息选中的信息赋值给中表 编辑
           // threadReport1.qcmJyThreadReportEntityBindingSource.DataSource = new List<QcmJyThreadReportEntity>() { ultraGridThread1.ActiveRow.ListObject as QcmJyThreadReportEntity };
        }

        private void ultraGridThread1_MouseDown(object sender, MouseEventArgs e)
        {
            //UltraGridRow ug = ultraGridThread1.ActiveRow;
            //if (ug == null)
            //{
            //    return;
            //}
            ////将下表信息选中的信息赋值给中表 编辑
            //threadReport1.qcmJyThreadReportEntityBindingSource.DataSource = new List<QcmJyThreadReportEntity>() { ultraGridThread1.ActiveRow.ListObject as QcmJyThreadReportEntity };
      
        }
        /// <summary>
        /// 按回车键触发查询按钮
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void ContPublic_KeyDown(object sender, KeyEventArgs e)
        {
            if (e.KeyCode == Keys.Enter)
            {
                DoQuery();
            }
        }
        private int splitterDistance = 0;
        private void ultraExpandableGroupBox1_ExpandedStateChanged(object sender, EventArgs e)
        {

            if (ultraExpandableGroupBox1.Expanded == false)
            {
                this.splitContainer2.SplitterDistance = splitContainer2.Size.Height - 26;
            }
            else
            {
                this.splitContainer2.SplitterDistance = splitterDistance == 0 ? splitContainer2.Size.Height / 2 : splitterDistance;
            }

        }



        private void threadReport2_Load_1(object sender, EventArgs e)
        {
            GridHelper.SetAllColumnsActive(ultraGridThread1);
        }

 

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


    

        


    }
}