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

        private void FrmILRepairDetail_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.cboQLadleName.DataSource = ds.Tables[0];
            this.cboQLadleName.DisplayMember = "LadleID";
            FrmIronLadleManage frm = (FrmIronLadleManage)this.Tag;

            if (frm.ugrdTBinfo.ActiveRow != null)
            {
                this.cboQLadleName.Text = frm.ugrdTBinfo.ActiveRow.Cells["铁包编号"].Value.ToString();
            }
            this.QueryData();
        }

        private void QueryData()
        {
            bool setTime = true;
            string strSQL = " SELECT repairid AS 维修记录编号,  repairtoolid AS 铁包编号, repairpart AS 维修位置, repairtype AS 维修类别, " +
                " materialreplacing AS 材料更换, repaircost AS 维修成本,to_char(repairtime,'yyyy-MM-dd HH24:mi:ss') AS 送修时间, reason AS 维修原因, cycid AS 周期编号," +
                " to_char(repairedtime,'yyyy-MM-dd HH24:mi:ss') AS 修复时间, recorder AS 记录人,memo AS 备注 " +
                " FROM DEV_Tool_Repair WHERE tooltypeid='铁包' ";
            if (this.chkQLadleName.Checked)
            {
                strSQL = strSQL + " AND repairtoolid='" + this.cboQLadleName.Text.Replace("'", "''") + "'";
            }
            if (this.chkQStartTime.Checked)
            {
                strSQL = strSQL + " AND repairtime>=To_date('" + this.dtpQStartTime.Value.ToString() + "','yyyy-MM-dd HH24:mi:ss')";
            }
            if (this.chkQEndTime.Checked)
            {
                strSQL = strSQL + " AND repairedtime<=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 repairtype,repairid 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.FromArgb(255, 255, 200));
                htOperate.Add("中修", Color.FromArgb(255, 237, 210));
                htOperate.Add("大修", Color.FromArgb(247, 251, 255));

            LadleCommonClass.SetGridBackColor(ulgrid, htOperate, "维修类别", true);
            }

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

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

        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;
            }
        }

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