MES_Client/TGMES/Core.StlMes.Client.KaoHe/BaseForm/JHYXingNengQryth.cs

using Core.Mes.Client.Comm.Server;
using Core.Mes.Client.Comm.Tool;
using CoreFS.CA06;
using Infragistics.Win.UltraWinEditors;
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;
using Core.Mes.Client.Comm.Format;
using Core.Mes.Client.Comm.Control;
using com.steering.pss.kaohe.entity;
using System.Text.RegularExpressions;
namespace Core.StlMes.Client.KaoHe.BaseForm
{
    public partial class JHYXingNengQry : FrmBase
    {
        public JHYXingNengQry()
        {
            InitializeComponent();
        }

        string supplyUnit;

        private void JHYXingNengQry_Load(object sender, EventArgs e)
        {
            EntityHelper.ShowGridCaption<VJhyHuaxuefenxiEntity>(ug_HuaXueFenXi.DisplayLayout.Bands[0]);
            EntityHelper.ShowGridCaption<VJhyJinxiangEntity>(ug_JinXiang.DisplayLayout.Bands[0]);
            EntityHelper.ShowGridCaption<VJhyLashenEntity>(ug_LaShen.DisplayLayout.Bands[0]);
            EntityHelper.ShowGridCaption<VJhyPuguanyingduEntity>(ug_PuGuanYD.DisplayLayout.Bands[0]);
            EntityHelper.ShowGridCaption<VJhyChongjiEntity>(ug_ChongJi.DisplayLayout.Bands[0]);
            EntityHelper.ShowGridCaption<VJhyYkbpEntity>(ug_YKBP.DisplayLayout.Bands[0]);
            EntityHelper.ShowGridCaption<VJhySscbEntity>(ug_SCCB.DisplayLayout.Bands[0]);
            EntityHelper.ShowGridCaption<VJhySscdEntity>(ug_SCCD.DisplayLayout.Bands[0]);
            EntityHelper.ShowGridCaption<VJhySscaEntity>(ug_SCCA.DisplayLayout.Bands[0]);
            EntityHelper.ShowGridCaption<VJhyShiyouyingduEntity>(ug_SYYD.DisplayLayout.Bands[0]);
            EntityHelper.ShowGridCaption<VJhyRonglianEntity>(ug_ronglian.DisplayLayout.Bands[0]);

            ud_DATEBEGIN.Value=DateTime.Now.AddYears(-1);

            ud_DATEEND.Value = DateTime.Now;
            supplyUnit = "江苏天淮钢管有限公司";



            //InitForm();
        }
        public override void ToolBar_Click(object sender, string ToolbarKey)
        {
            switch (ToolbarKey)
            {
                case "Query":
                    QueryData();
                    break;
                case "Export":
                    ExportData();
                    break;

              
            }
        }

        private void ExportData()
        {
            switch (ultraTabControl1.SelectedTab.Text)
            {
                case "成品分析":
                    GridHelper.ulGridToExcel(ug_HuaXueFenXi, "成品分析");
                    break;
                case "金相":
                    GridHelper.ulGridToExcel(ug_JinXiang, "金相");
                    break;
                case "拉伸":
                    GridHelper.ulGridToExcel(ug_LaShen, "拉伸");
                    break;
                case "普管硬度":
                    GridHelper.ulGridToExcel(ug_PuGuanYD, "普管硬度");
                    break;
                case "冲击":
                    GridHelper.ulGridToExcel(ug_ChongJi, "冲击");
                    break;
                case "压溃爆破":
                    GridHelper.ulGridToExcel(ug_YKBP, "压溃爆破");
                    break;
                case "硫化氢四点弯曲":
                    GridHelper.ulGridToExcel(ug_SCCB, "硫化氢四点弯曲");
                    break;
                case "硫化氢DCB":
                    GridHelper.ulGridToExcel(ug_SCCD, "硫化氢DCB");
                    break;
                case "硫化氢应力腐蚀":
                    GridHelper.ulGridToExcel(ug_SCCA, "硫化氢应力腐蚀");
                    break;
                case "石油管硬度":
                    GridHelper.ulGridToExcel(ug_SYYD, "石油管硬度");
                    break;
                case "熔炼成分":
                    GridHelper.ulGridToExcel(ug_ronglian, "熔炼成分");
                    break;




                default:
                    break;
            }
        }

        private void QueryData()
        {
            string CHECK_NO = "";
            string STEEL_NO = "";
            string STEEL_GRADE = "";
            string DIMATER1 = "";
            string DIMATER2 = "";
            string HEIGHT1 = "";
            string HEIGHT2 = "";
            string CIC = "";
            string LUHAO1 = "";
            string LUHAO2 = "";
            string DATE_BEGIN = "";
            string DATE_END = "";
            if (ValidInput() == true)
            {
               

                CHECK_NO = tb_CHECK_NO.Text;
                STEEL_NO = tb_STEEL_NO.Text;
                STEEL_GRADE = tb_STEEL_GRADE.Text;
                DIMATER1 = tb_DIMATER1.Text;
                DIMATER2 = tb_DIMATER2.Text;
                HEIGHT1 = tb_HEIGHT1.Text;
                HEIGHT2 = tb_HEIGHT2.Text;
                CIC = tb_CIC.Text;
                LUHAO1 = tb_LuHao1.Text;
                LUHAO2 = tb_LuHao2.Text;

                //if (LUHAO1 == "")
                //{
                //    LUHAO1 = "0";
                //}

                //if (LUHAO2 == "")
                //{
                //    LUHAO2 = "9999999";
                //}

                if (DIMATER1 == "")
                {
                    DIMATER1 = "0";
                }

                if (DIMATER2 == "")
                {
                    DIMATER2 = "999";
                }
                if (HEIGHT1 == "")
                {
                    HEIGHT1 = "0";
                }

                if (HEIGHT2 == "")
                {
                    HEIGHT2 = "999";
                }



                if (ck_Date.Checked == true)
                {
                    DATE_BEGIN = DateTime.Parse(ud_DATEBEGIN.Value.ToString()).ToString("yyyy-MM-dd HH:mm:ss");
                    DATE_END = DateTime.Parse(ud_DATEEND.Value.ToString()).ToString("yyyy-MM-dd HH:mm:ss");
                }
                else
                {
                    DATE_BEGIN = "1900-01-01 00:00:00";
                    DATE_END = "2999-01-01 00:00:00";
                }

              
            }



            switch (ultraTabControl1.SelectedTab.Text)
            {
                case "成品分析":
                    QueryDataHX(CHECK_NO, STEEL_NO, STEEL_GRADE, DIMATER1, DIMATER2, HEIGHT1, HEIGHT2, CIC, LUHAO1, LUHAO2, DATE_BEGIN, DATE_END);
                    break;
                case "金相":
                    QueryDataJX(CHECK_NO, STEEL_NO, STEEL_GRADE, DIMATER1, DIMATER2, HEIGHT1, HEIGHT2, CIC, LUHAO1, LUHAO2, DATE_BEGIN, DATE_END);
                    break;
                case "拉伸":
                    QueryDataLS(CHECK_NO, STEEL_NO, STEEL_GRADE, DIMATER1, DIMATER2, HEIGHT1, HEIGHT2, CIC, LUHAO1, LUHAO2, DATE_BEGIN, DATE_END);
                    break;
                case "普管硬度":
                    QueryDataPUYD(CHECK_NO, STEEL_NO, STEEL_GRADE, DIMATER1, DIMATER2, HEIGHT1, HEIGHT2, CIC, LUHAO1, LUHAO2, DATE_BEGIN, DATE_END);
                    break;
                case "冲击":
                    QueryDataCJ(CHECK_NO, STEEL_NO, STEEL_GRADE, DIMATER1, DIMATER2, HEIGHT1, HEIGHT2, CIC, LUHAO1, LUHAO2, DATE_BEGIN, DATE_END);
                    break;
                case "压溃爆破":
                    QueryDataYKBP(CHECK_NO, STEEL_NO, STEEL_GRADE, DIMATER1, DIMATER2, HEIGHT1, HEIGHT2, CIC, LUHAO1, LUHAO2, DATE_BEGIN, DATE_END);
                    break;
                case "硫化氢四点弯曲":
                    QueryDataSCCB(CHECK_NO, STEEL_NO, STEEL_GRADE, DIMATER1, DIMATER2, HEIGHT1, HEIGHT2, CIC, LUHAO1, LUHAO2, DATE_BEGIN, DATE_END);
                    break;
                case "硫化氢DCB":
                    QueryDataSCCD(CHECK_NO, STEEL_NO, STEEL_GRADE, DIMATER1, DIMATER2, HEIGHT1, HEIGHT2, CIC, LUHAO1, LUHAO2, DATE_BEGIN, DATE_END);
                    break;
                case "硫化氢应力腐蚀":
                    QueryDataSCCA(CHECK_NO, STEEL_NO, STEEL_GRADE, DIMATER1, DIMATER2, HEIGHT1, HEIGHT2, CIC, LUHAO1, LUHAO2, DATE_BEGIN, DATE_END);
                    break;
                case "石油管硬度":
                    QueryDataSYYD(CHECK_NO, STEEL_NO, STEEL_GRADE, DIMATER1, DIMATER2,HEIGHT1,  HEIGHT2, CIC, LUHAO1, LUHAO2, DATE_BEGIN, DATE_END);
                    break;
                case "熔炼成分":
                    QueryDataRL(CHECK_NO, STEEL_NO, STEEL_GRADE, DIMATER1, DIMATER2, HEIGHT1, HEIGHT2, CIC, LUHAO1, LUHAO2, DATE_BEGIN, DATE_END);
                    break;



                    
                default:
                    break;
            }
        }

        private void QueryDataRL(string CHECK_NO, string STEEL_NO, string STEEL_GRADE, string DIMATER1, string DIMATER2, string HEIGHT1, string HEIGHT2, string CIC, string LUHAO1, string LUHAO2, string DATE_BEGIN, string DATE_END)
        {
            List<VJhyRonglianEntity> VJhyRonglianEntity = EntityHelper.GetData<VJhyRonglianEntity>(
             "com.steering.pss.kaohe.server.JHYRongLianQry.Query", new object[] { CHECK_NO, STEEL_NO, STEEL_GRADE, DIMATER1, DIMATER2,HEIGHT1,HEIGHT2, CIC, LUHAO1, LUHAO2, DATE_BEGIN, DATE_END }, this.ob);
            vJhyRonglianEntityBindingSource.DataSource = VJhyRonglianEntity;
        }


        private void QueryDataSYYD(string CHECK_NO, string STEEL_NO, string STEEL_GRADE, string DIMATER1, string DIMATER2, string HEIGHT1, string HEIGHT2, string CIC, string LUHAO1, string LUHAO2, string DATE_BEGIN, string DATE_END)
        {
            List<VJhyShiyouyingduEntity> VJhyShiyouyingduEntity = EntityHelper.GetData<VJhyShiyouyingduEntity>(
            "com.steering.pss.kaohe.server.JHYSYYDQry.Query", new object[] { CHECK_NO, STEEL_NO, STEEL_GRADE, DIMATER1, DIMATER2, HEIGHT1, HEIGHT2, CIC, LUHAO1, LUHAO2, DATE_BEGIN, DATE_END, supplyUnit }, this.ob);
            vJhyShiyouyingduEntityBindingSource.DataSource = VJhyShiyouyingduEntity;
    
        }



        private void QueryDataSCCA(string CHECK_NO, string STEEL_NO, string STEEL_GRADE, string DIMATER1, string DIMATER2, string HEIGHT1, string HEIGHT2, string CIC, string LUHAO1, string LUHAO2, string DATE_BEGIN, string DATE_END)
        {
            List<VJhySscaEntity> VJhySscaEntity = EntityHelper.GetData<VJhySscaEntity>(
            "com.steering.pss.kaohe.server.JHYSCCAQry.Query", new object[] { CHECK_NO, STEEL_NO, STEEL_GRADE, DIMATER1, DIMATER2, HEIGHT1, HEIGHT2, CIC, LUHAO1, LUHAO2, DATE_BEGIN, DATE_END,supplyUnit }, this.ob);
            vJhySscaEntityBindingSource.DataSource = VJhySscaEntity;
        }

        private void QueryDataSCCD(string CHECK_NO, string STEEL_NO, string STEEL_GRADE, string DIMATER1, string DIMATER2, string HEIGHT1, string HEIGHT2, string CIC, string LUHAO1, string LUHAO2, string DATE_BEGIN, string DATE_END)
        {
            List<VJhySscdEntity> VJhySscdEntity = EntityHelper.GetData<VJhySscdEntity>(
            "com.steering.pss.kaohe.server.JHYSCCDQry.Query", new object[] { CHECK_NO, STEEL_NO, STEEL_GRADE, DIMATER1, DIMATER2, HEIGHT1, HEIGHT2, CIC, LUHAO1, LUHAO2, DATE_BEGIN, DATE_END, supplyUnit }, this.ob);
            vJhySscdEntityBindingSource.DataSource = VJhySscdEntity;
        }

        private void QueryDataSCCB(string CHECK_NO, string STEEL_NO, string STEEL_GRADE, string DIMATER1, string DIMATER2, string HEIGHT1, string HEIGHT2, string CIC, string LUHAO1, string LUHAO2, string DATE_BEGIN, string DATE_END)
        {
            List<VJhySscbEntity> VJhySscbEntity = EntityHelper.GetData<VJhySscbEntity>(
             "com.steering.pss.kaohe.server.JHYSCCBQry.Query", new object[] { CHECK_NO, STEEL_NO, STEEL_GRADE, DIMATER1, DIMATER2, HEIGHT1, HEIGHT2, CIC, LUHAO1, LUHAO2, DATE_BEGIN, DATE_END, supplyUnit }, this.ob);
            vJhySscbEntityBindingSource.DataSource = VJhySscbEntity;
        }

        private void QueryDataYKBP(string CHECK_NO, string STEEL_NO, string STEEL_GRADE, string DIMATER1, string DIMATER2, string HEIGHT1, string HEIGHT2, string CIC, string LUHAO1, string LUHAO2, string DATE_BEGIN, string DATE_END)
        {
            List<VJhyYkbpEntity> VJhyYkbpEntity = EntityHelper.GetData<VJhyYkbpEntity>(
             "com.steering.pss.kaohe.server.JHYYKBPQry.Query", new object[] { CHECK_NO, STEEL_NO, STEEL_GRADE, DIMATER1, DIMATER2, HEIGHT1, HEIGHT2, CIC, LUHAO1, LUHAO2, DATE_BEGIN, DATE_END, supplyUnit }, this.ob);
            vJhyYkbpEntityBindingSource.DataSource = VJhyYkbpEntity;
        }

        private void QueryDataCJ(string CHECK_NO, string STEEL_NO, string STEEL_GRADE, string DIMATER1, string DIMATER2, string HEIGHT1, string HEIGHT2, string CIC, string LUHAO1, string LUHAO2, string DATE_BEGIN, string DATE_END)
        {
            List<VJhyChongjiEntity> VJhyChongjiEntity = EntityHelper.GetData<VJhyChongjiEntity>(
            "com.steering.pss.kaohe.server.JHYChongJiQry.Query", new object[] { CHECK_NO, STEEL_NO, STEEL_GRADE, DIMATER1, DIMATER2, HEIGHT1, HEIGHT2, CIC, LUHAO1, LUHAO2, DATE_BEGIN, DATE_END, supplyUnit }, this.ob);
            vJhyChongjiEntityBindingSource.DataSource = VJhyChongjiEntity;
        }

        private void QueryDataPUYD(string CHECK_NO, string STEEL_NO, string STEEL_GRADE, string DIMATER1, string DIMATER2, string HEIGHT1, string HEIGHT2, string CIC, string LUHAO1, string LUHAO2, string DATE_BEGIN, string DATE_END)
        {
            List<VJhyPuguanyingduEntity> VJhyPuguanyingduEntity = EntityHelper.GetData<VJhyPuguanyingduEntity>(
             "com.steering.pss.kaohe.server.JHYPuGuanYDQry.Query", new object[] { CHECK_NO, STEEL_NO, STEEL_GRADE, DIMATER1, DIMATER2, HEIGHT1, HEIGHT2, CIC, LUHAO1, LUHAO2, DATE_BEGIN, DATE_END, supplyUnit }, this.ob);
            vJhyPuguanyingduEntityBindingSource.DataSource = VJhyPuguanyingduEntity;
        }

        private void QueryDataLS(string CHECK_NO, string STEEL_NO, string STEEL_GRADE, string DIMATER1, string DIMATER2, string HEIGHT1, string HEIGHT2, string CIC, string LUHAO1, string LUHAO2, string DATE_BEGIN, string DATE_END)
        {
            List<VJhyLashenEntity> VJhyLashenEntity = EntityHelper.GetData<VJhyLashenEntity>(
              "com.steering.pss.kaohe.server.JHYLaShenQry.Query", new object[] { CHECK_NO, STEEL_NO, STEEL_GRADE, DIMATER1, DIMATER2, HEIGHT1, HEIGHT2, CIC, LUHAO1, LUHAO2, DATE_BEGIN, DATE_END, supplyUnit }, this.ob);
            vJhyLashenEntityBindingSource.DataSource = VJhyLashenEntity;
        }

        private void QueryDataJX(String CHECK_NO, string STEEL_NO, string STEEL_GRADE, string DIMATER1, string DIMATER2, string HEIGHT1, string HEIGHT2, string CIC, string LUHAO1, string LUHAO2, string DATE_BEGIN, string DATE_END)
        {
            List<VJhyJinxiangEntity> VJhyJinxiangEntity = EntityHelper.GetData<VJhyJinxiangEntity>(
              "com.steering.pss.kaohe.server.JHYJinXiangQry.Query", new object[] { CHECK_NO, STEEL_NO, STEEL_GRADE, DIMATER1, DIMATER2, HEIGHT1, HEIGHT2, CIC, LUHAO1, LUHAO2, DATE_BEGIN, DATE_END, supplyUnit }, this.ob);
            vJhyJinxiangEntityBindingSource.DataSource = VJhyJinxiangEntity;
        }
        private void QueryDataHX(String CHECK_NO, string STEEL_NO, string STEEL_GRADE, string DIMATER1, string DIMATER2, string HEIGHT1, string HEIGHT2, string CIC, string LUHAO1, string LUHAO2, string DATE_BEGIN, string DATE_END)
        {
            List<VJhyHuaxuefenxiEntity> VJhyHuaxuefenxiEntity = EntityHelper.GetData<VJhyHuaxuefenxiEntity>(
              "com.steering.pss.kaohe.server.JHYXingNengQry.Query", new object[] { CHECK_NO, STEEL_NO, STEEL_GRADE, DIMATER1, DIMATER2, HEIGHT1, HEIGHT2, CIC, LUHAO1, LUHAO2, DATE_BEGIN, DATE_END , supplyUnit }, this.ob);
            vJhyHuaxuefenxiEntityBindingSource.DataSource = VJhyHuaxuefenxiEntity;
                     
        }

        private bool ValidInput()
        {
            if (tb_LuHao1.Text!="" && KaoHeClass.IsNumeric(tb_LuHao1.Text)==false)
            {
                MessageBox.Show("请输入数字格式的炉号");
                return false;
            }
            else if (tb_LuHao2.Text != "" && KaoHeClass.IsNumeric(tb_LuHao2.Text) == false)
            {
                MessageBox.Show("请输入数字格式的炉号");
                return false;
            }
            else
            {
                return true;
            }         
             
        }

        

       



       
    }
}