MES_Client/TGMES/Core.StlMes.Client.Judge/Forms/QcmJyTestReport.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;

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

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

            //初始化加载项目列
            DataTable dt3 = ServerHelper.GetData("com.steering.pss.judge.DAL.QcmZbsQueryFrm.querySendPlan", new object[] { "4112" }, ob);
            // TubeRoll.InitCombo(Items, "com.steering.pss.judge.DAL.QcmJyTestReport.FindItemsList", "ITEMS", this.ob, false);
            //TubeRoll.BindColumnComb(Items, "ITEMS", this.Controls, this.ultraGridJustNo, 0);
            ultraComboEditor1.DataSource = dt3;
            ultraComboEditor1.DisplayMember = "BASENAME";
            ultraComboEditor1.ValueMember = "BASENAME";
        }
        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();
                    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() {
            ultraGridJustNo.UpdateData();
            ArrayList list1 = new ArrayList();
            String orderno = "";
            String items = "";
            String standard = "";
            String result = "";
            String instrumentmodel = "";
            String createname = "";
            String REPORTED = this.textBox1.Text;
            String APPROVED = this.textBox2.Text;
            String REMARKS =  this.textBox3.Text;
            IQueryable<UltraGridRow> uGrid = ultraGridJustNo.Rows.AsQueryable().Where(" CHK = 'True'");
            if(uGrid.Count() == 0){
                MessageUtil.ShowTips("请选择要新增的数据！");
                return;
            }
            foreach(UltraGridRow ugr in uGrid){
                ArrayList list = new ArrayList();
                orderno = ugr.Cells["ORDER_NO"].Value.ToString();
                items = ugr.Cells["ITEMS"].Value.ToString();
                standard = ugr.Cells["STANDARD"].Value.ToString();
                result = ugr.Cells["RESULT"].Value.ToString();
                instrumentmodel = ugr.Cells["INSTRUMENT_MODEL"].Value.ToString();
                if (orderno == "") { MessageUtil.ShowTips("合同号不能为空！"); return; }
                if (items == "") { MessageUtil.ShowTips("项目不能为空！"); return; }
                if (standard == "") { MessageUtil.ShowTips("标准值不能为空！"); return; }
                if (result == "") { MessageUtil.ShowTips("检测值不能为空！"); return; }
                if (instrumentmodel == "") { MessageUtil.ShowTips("设备名称及型号不能为空！"); return; }
                String  username = UserInfo.GetUserName();
               // String nowtime = DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss");
                list.Add(orderno);
                list.Add(items);
                list.Add(standard);
                list.Add(result);
                list.Add(instrumentmodel);
                createname = username;
                list.Add(createname);
                list.Add(REPORTED);
                list.Add(APPROVED);
                list.Add(REMARKS);
                list1.Add(list);
            }
            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.pss.judge.DAL.QcmJyTestReport";
            ccp.MethodName = "AddTestReport";
            ccp.ServerParams = new object[] { list1 };
            ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            if (ccp.ReturnCode != -1)
            {
                MessageUtil.ShowTips(ccp.ReturnInfo);
                if (ccp.ReturnInfo.Equals("新增成功！"))
                {
                    DoQuery();
                }
            }
        }

        public string spathName = "";
        private List<Image> ing = new List<Image>();
        private List<FileBean> list = new List<FileBean>();
        /// <summary>
        /// 修改记录
        /// </summary>
        private void DoUpdate()
        {
            ultraGridJustNo.UpdateData();
            ArrayList list1 = new ArrayList();
            String orderno = "";
            String items = "";
            String standard = "";
            String result = "";
            String instrumentmodel = "";
            String REPORTED = this.textBox1.Text;
            String APPROVED = this.textBox2.Text;
            String REMARKS = this.textBox3.Text;
            ArrayList pram1 = new ArrayList();
            IQueryable<UltraGridRow> uGrid = ultraGridJustNo.Rows.AsQueryable().Where(" CHK = 'True'");
            if (uGrid.Count() == 0)
            {
                MessageUtil.ShowTips("请选择修改的数据！");
                return;
            }

            foreach (UltraGridRow ugr in uGrid)
            {
                orderno = ugr.Cells["ORDER_NO"].Value.ToString();
                items = ugr.Cells["ITEMS"].Value.ToString();
                standard = ugr.Cells["STANDARD"].Value.ToString();
                result = ugr.Cells["RESULT"].Value.ToString();
                instrumentmodel = ugr.Cells["INSTRUMENT_MODEL"].Value.ToString();

                if (orderno == "") { MessageUtil.ShowTips("合同号不能为空！"); return; }
                if (items == "") { MessageUtil.ShowTips("项目不能为空！"); return; }
                if (standard == "") { MessageUtil.ShowTips("标准值不能为空！"); return; }
                if (result == "") { MessageUtil.ShowTips("检测值不能为空！"); return; }
                if (instrumentmodel == "") { MessageUtil.ShowTips("设备名称及型号不能为空！"); return; }

                ArrayList list = new ArrayList();
                list.Add(standard);
                list.Add(result);
                list.Add(instrumentmodel);
                list.Add(UserInfo.GetUserName());
                list.Add(orderno);
                list.Add(items);
                list.Add(REPORTED);
                list.Add(APPROVED);
                list.Add(REMARKS);
                pram1.Add(list);

            }

            CoreClientParam ccp = new CoreClientParam();
            ccp.ServerName = "com.steering.pss.judge.DAL.QcmJyTestReport";
            ccp.MethodName = "UpdateTestReport";
            ccp.ServerParams = new object[] { pram1 };
            ccp = this.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
            if (ccp.ReturnCode != -1)
            {
                MessageUtil.ShowTips(ccp.ReturnInfo);
                if (ccp.ReturnInfo.Equals("修改成功！"))
                {
                    DoQuery();
                }
            }
            
        }
        /// <summary>
        /// 删除检验报告记录
        /// </summary>
        private void Delete()
        {
            ultraGridJustNo.UpdateData();
            ArrayList pram1 = new ArrayList();

            IQueryable<UltraGridRow> uGrid = ultraGridJustNo.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(ugr.Cells["ORDER_NO"].Value.ToString());
                pram.Add(ugr.Cells["ITEMS"].Value.ToString());
                pram1.Add(pram);
            }

            int countinsert = ServerHelper.SetData("com.steering.pss.judge.DAL.QcmJyTestReport.deleteTestReport", 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;
            }
           


        }

        //根据合同号去查询检验报告
        private void QueryJustStoveInfo(string orderNo)
        {
            ultraGridJustNo.UpdateData();
            ArrayList param = new ArrayList();
            param.Add(orderNo);
            //查找testreport
            DataTable dt = ServerHelper.GetData("com.steering.pss.judge.DAL.QcmJyTestReport.FindTestReport", new Object[] { param }, ob);
            GridHelper.CopyDataToDatatable(dt, this.dataTable1, true);

            //判断  中部新增的三个字段的内容
            if (dt.Rows.Count >= 1)
            {
                for (int i = 0; i < dt.Rows.Count;i++ ) {
                    if (dt.Rows[i]["REPORTED"].ToString() != null || dt.Rows[i]["REPORTED"].ToString() != "")
                    {
                        this.textBox1.Text = dt.Rows[i]["REPORTED"].ToString();
                    }
                    if (dt.Rows[i]["APPROVED"].ToString() != null || dt.Rows[i]["APPROVED"].ToString() != "")
                    {
                        this.textBox2.Text = dt.Rows[i]["APPROVED"].ToString();
                    }
                    if (dt.Rows[i]["REMARKS"].ToString() != null || dt.Rows[i]["REMARKS"].ToString() != "")
                    {
                        this.textBox3.Text = dt.Rows[i]["REMARKS"].ToString();
                    }
                }
               
            }
            else {
                this.textBox1.Text = null;
                this.textBox2.Text = null;
                this.textBox3.Text = null;
            }
        }
        DataTable dtzbs = new DataTable();
        
        
        //单击上表 行的事件   根据合同号查找下表的信息
        private void ultraGridOrder_AfterRowActivate(object sender, EventArgs e)
        {
            UltraGridRow ugr = ultraGridOrder.ActiveRow;
            if (ugr == null)
            {
                return;
            }
            QueryJustStoveInfo(ugr.Cells["OrderNo"].Text.ToString());
        }

        /// <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 ultraGridOrder_AfterSelectChange(object sender, AfterSelectChangeEventArgs e)
        {
            foreach (UltraGridRow uRow in ultraGridOrder.Selected.Rows)
            {
                if (uRow.GetType() != typeof(Infragistics.Win.UltraWinGrid.UltraGridGroupByRow))
                {
                    uRow.Cells["CHC"].Value = true;
                }
            }
        }

        //下表新增一行触发事件  默认合同号为当前上表选中的合同号
        private void ultraGridJustNo_AfterRowInsert(object sender, RowEventArgs e)
        {
            UltraGridRow ugr = ultraGridOrder.ActiveRow;
            if (ugr == null)
            {
                return;
            }
            String oldOrder = ugr.Cells["OrderNo"].Text.ToString();
            this.ultraGridJustNo.ActiveRow.Cells["ORDER_NO"].Value = oldOrder;

        }

        private void ultraComboEditor1_ValueChanged(object sender, EventArgs e)
        {

        }
    }
}