XinYu_LG2MES/ClientSolution/Core.LgMes.Client.LgDeviceManager/铁包/FrmILFireDetail.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;
namespace Core.LgMes.Client.LgDeviceManager
{
    public partial class FrmILFireDetail : frmModelFormStyle
    {
        public FrmILFireDetail()
        {
            InitializeComponent();
        }

        private void btnClose_Click(object sender, EventArgs e)
        {
            this.Close();
        }

        private void FrmILFireDetail_Load(object sender, EventArgs e)
        {
            this.dtpQStartTime.Text = System.DateTime.Now.ToString("yyyy-MM-dd") + " 00:00:00";
            this.dtpQEndTime.Text = System.DateTime.Now.ToString("yyyy-MM-dd") + " 23:59:59";
            this.chkQLadleName.Checked = true;
            //Core.Mes.IBaseInterface.CallingMessage par = new Core.Mes.IBaseInterface.CallingMessage();
            //par.ServerName = "LgDeviceManager";
            //par.MethodName = "GetCmbData";
            //par.ClassName = "Core.LgMes.Server.LgDeviceManager.LadleManager";
            //par.AssemblyName = "Core.LgMes.Server.LgDeviceManager";
            //par.args = new object[] { "LadleID", "DEV_TB_Base_Info", "", "", "", "", "LadleID" };
            //string err = "";
            object ob = null;//  Core.Mes.ClientFrameWork.ClientCommon._RemotingHelp.ExecuteMethod(par, out err);
            System.Data.DataSet ds = (DataSet)ob;
            this.cmbQLadleName.DataSource = ds.Tables[0];
            this.cmbQLadleName.DisplayMember = "LadleID";
            FrmIronLadleManage frm = (FrmIronLadleManage)this.Tag;

            if (frm.ugrdTBinfo.ActiveRow != null)
            {
                this.cmbQLadleName.Text = frm.ugrdTBinfo.ActiveRow.Cells["铁包编号"].Value.ToString();
            }
            this.QueryData();
        }
        private void QueryData()
        {
            bool setTime = true;
            string strSQL = " SELECT firingid AS 烘烤记录编号, firingtoolid AS 铁包编号, cycid AS 周期编号, ovenid AS 烘烤站号," +
                " firetype AS 烘烤方式, to_char(begintime,'yyyy-MM-dd HH24:mi:ss') AS 烘烤开始时间, to_char(endtime,'yyyy-MM-dd HH24:mi:ss') AS 烘烤结束时间, temperaturebeforefiring AS 烤前温度," + 
                " temperaturebehindfiring AS 烤后温度, memo AS 备注 " +
                " FROM DEV_ToolFiringDetail WHERE tooltype='铁包' ";
            if (this.chkQLadleName.Checked)
            {
                strSQL = strSQL + " AND firingtoolid='" + this.cmbQLadleName.Text.Replace("'", "''") + "'";
            }
            if (this.chkQStartTime.Checked)
            {
                strSQL = strSQL + " AND begintime>=To_date('" + this.dtpQStartTime.Value.ToString() + "','yyyy-MM-dd HH24:mi:ss')";
            }
            if (this.chkQEndTime.Checked)
            {
                strSQL = strSQL + " AND begintime<=To_date('" + this.dtpQEndTime.Value.ToString() + "','yyyy-MM-dd HH24:mi:ss')";
            }

             if (chkQStartTime.Checked && this.chkQEndTime.Checked)
            {
                if (dtpQStartTime.Value > dtpQEndTime.Value)
                {
                    setTime = false;
                    MessageBox.Show("起始时间应该小于结束时间!\n请重新选择日期段","提示");
                }
                else
                {
                    setTime = true;
                }
            }
            if (setTime)
            {
                strSQL = strSQL + " ORDER BY ovenid,firingid desc ";

                //Core.Mes.IBaseInterface.CallingMessage par = new Core.Mes.IBaseInterface.CallingMessage();
                //par.ServerName = "LgDeviceManager";
                //par.MethodName = "ReturnTable";
                //par.ClassName = "Core.LgMes.Server.LgDeviceManager.LadleManager";
                //par.AssemblyName = "Core.LgMes.Server.LgDeviceManager";
                //par.args = new object[] { strSQL };
                //string err = "";
                object ob = null;// Core.Mes.ClientFrameWork.ClientCommon._RemotingHelp.ExecuteMethod(par, out err);
                System.Data.DataSet ds = (DataSet)ob;
                this.ulgrid.DataSource = ds;
                this.ulgrid.DataBind();
                //Core.CgMes.Client.JJQManager.FrmCLRepairDetail fcc = new Core.CgMes.Client.JJQManager.FrmCLRepairDetail();
                //fcc.SetColumnWidth(ds, ulgrid, this.label1);

                Hashtable htOperate = new Hashtable();
                htOperate.Add("提钒转炉", Color.White);
                htOperate.Add("铁水站", Color.FromArgb(247, 251, 255));
                htOperate.Add("脱硫站", Color.FromArgb(239, 255, 232));

                LadleCommonClass.SetGridBackColor(ulgrid, htOperate, "烘烤站号", true);
       
            }
        }

        private void btnselect_Click(object sender, EventArgs e)
        {
            this.QueryData();
        }

        private void chkQLadleName_CheckedChanged(object sender, EventArgs e)
        {
            if (chkQLadleName.Checked)
            {
                cmbQLadleName.Enabled = true;
            }
            else
            {
                cmbQLadleName.Enabled = false;
            }
            
        }

        private void chkQStartTime_CheckedChanged(object sender, EventArgs e)
        {
            if (chkQStartTime.Checked)
            {
                dtpQStartTime.Enabled = true;
            }
            else
            {
                dtpQStartTime.Enabled = false;
            }
        }

        private void chkQEndTime_CheckedChanged(object sender, EventArgs e)
        {
            if (chkQEndTime.Checked)
            {
                dtpQEndTime.Enabled = true;
            }
            else
            {
                dtpQEndTime.Enabled = false;
            }
        }

    }
}