XinYu_LG2MES/ClientSolution/Core.LgMes.Client.LgDeviceManager/真空槽/FrmVTHotDetail.cs

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Collections;
using CoreFS.CA06;
using Core.Mes.Client.Common;

namespace Core.LgMes.Client.LgDeviceManager
{
    public partial class FrmVTHotDetail : Core.Mes.Client.Common.frmStyleBase//frmModelFormStyle
    {
        public FrmVTHotDetail(OpeBase oba)
        {
            InitializeComponent();
            ob = oba;
        }

        private void FrmVTHotDetail_Load(object sender, EventArgs e)
        {
            udteStart.DateTime = DateTime.Today;
            udteEnd.DateTime = DateTime.Today;

            GetDeviceID();
            proc_Query();
        }

        private void btnselect_Click(object sender, EventArgs e)
        {
            proc_Query();
        }

        private void proc_Query()
        {
            try
            {
                string strErr = "";
                string str = "where t1.TOOLTYPE = '4' and t1.FIRINGTOOLID = t2.ID(+) ";

                string str1 = "";
                if (chkCCM.Checked && cmbCCM.Text.Trim().Length > 0)
                {
                    str1 = "RHS_ID = '" + cmbCCM.Text.Trim() + "'";
                }
                if (chkQLadleName.Checked && cmbID.Text.Trim().Length > 0)
                {
                    if (str1.Length == 0)
                        str1 = "TANKCARID = '" + cmbID.Text.Trim() + "'";
                    else
                        str1 += " and TANKCARID = '" + cmbID.Text.Trim() + "'";
                }

                if (str1.Length > 0)
                {
                    str += "and t1.FIRINGTOOLID in (select ID from DEV_ZKC_BASE_INFO where " + str1 + ") ";
                }

                if (chkQStartTime.Checked)
                    str += "and to_char(t1.BEGINTIME,'yyyy-MM-dd') >= '" + udteStart.DateTime.ToString("yyyy-MM-dd") + "'";

                if (chkQEndTime.Checked)
                    str += "and to_char(t1.ENDTIME,'yyyy-MM-dd') <= '" + udteEnd.DateTime.ToString("yyyy-MM-dd") + "'";

                ArrayList arry = new ArrayList();
                ArrayList sqlList = new ArrayList();
                arry.Add("FrmVTHotDetail_Query2");
                sqlList.Add(str);

                CoreClientParam CCP_LgEts = new CoreClientParam();
                DataTable dt = new DataTable();
                CCP_LgEts.ServerName = "Core.LgMes.Server.Common.ComDBQuery";
                CCP_LgEts.MethodName = "doQuery";
                CCP_LgEts.ServerParams = new object[] { arry, sqlList };
                CCP_LgEts.SourceDataTable = dt;
                this.ExecuteQueryToDataTable(CCP_LgEts, CoreInvokeType.Internal);
                DataSet ds = new DataSet();
                ds.Tables.Add(dt);
                try
                {
                    ((DataTable)ulgridBaseInfo.DataSource).Rows.Clear();
                }
                catch (Exception)
                {
                }
                if (ds != null && ds.Tables[0].Rows.Count > 0)
                {
                    ulgridBaseInfo.DataSource = ds.Tables[0];
                }
                if (strErr != "" || !(ds != null && ds.Tables.Count > 0))
                {
                    MessageBox.Show("真空槽烘烤信息查询失败！\r\n" + strErr, "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    return;
                }

                
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, "提示");
            }
        }
        /// <summary>
        /// 槽车号加载
        /// </summary>
        private void GetDeviceID()
        {
            try
            {
                string strErr = "";
                ArrayList arry = new ArrayList();
                arry.Add("FrmVTHotDetail_Query1");
                CommonClientToServer ccs = new CommonClientToServer();
                ccs.ob = this.ob;
                DataSet ds = ccs.ExecuteQueryFunctions("Core.LgMes.Server.Common.ComDBQuery", "doSimpleQuery", arry, out strErr);
                if (strErr != "" || !(ds != null && ds.Tables.Count > 0))
                {
                    MessageBox.Show("槽车号加载失败！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    if (MessageBox.Show("是否重新加载槽车号？", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
                        GetDeviceID();
                    return;
                }

                cmbID.DataSource = ds.Tables[0];
                cmbID.DisplayMember = "TANKCARID";
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
            }
        }

        private void chkQLadleName_CheckedChanged(object sender, EventArgs e)
        {
            cmbID.Enabled = chkQLadleName.Checked;
        }

        private void chkQStartTime_CheckedChanged(object sender, EventArgs e)
        {
            udteStart.Enabled = chkQStartTime.Checked;
        }

        private void chkQEndTime_CheckedChanged(object sender, EventArgs e)
        {
            udteEnd.Enabled = chkQEndTime.Checked;
        }

        private void cbCCM_CheckedChanged(object sender, EventArgs e)
        {
            cmbCCM.Enabled = chkCCM.Checked;
        }
    }
}