XinYu_LG2MES/ClientSolution/Core.LgMes.Client.LgDeviceManager/扇形段/FrmSGRepairDetail.cs

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

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

        private void FrmSGRepairDetail_Load(object sender, EventArgs e)
        {
            udteQStartTime.DateTime = DateTime.Now;
            udteQEndTime.DateTime = DateTime.Now;

            GetDeviceID();
            proc_Query();
        }

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

        private void btnselect_Click(object sender, EventArgs e)
        {
            proc_Query();
        }
        /// <summary>
        /// 扇形段修改记录查询
        /// </summary>
        private void proc_Query()
        {
            try
            {
                string strErr = "";
                string str = "where t1.TOOLTYPEID = '3' and t1.REPAIRTOOLID = t2.ID(+) ";

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

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

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

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

                ArrayList arry = new ArrayList();
                ArrayList sqlList = new ArrayList();
                arry.Add("FrmSGRepairDetail_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);
                strErr = CCP_LgEts.ReturnInfo;
                if (strErr != "" || !(ds != null && ds.Tables.Count > 0))
                {
                    MessageBox.Show("扇形段维修信息查询失败！\r\n" + strErr, "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
                    return;
                } 
                try
                {
                    ((DataTable)ulgridBaseInfo.DataSource).Rows.Clear();
                }
                catch (Exception)
                {
                }
                if (ds != null && ds.Tables[0].Rows.Count > 0)
                {
                    ulgridBaseInfo.DataSource = ds.Tables[0];
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message, "提示");
            }
        }
        /// <summary>
        /// 扇形段号加载
        /// </summary>
        private void GetDeviceID()
        {
            try
            {
                string strErr = "";
                ArrayList arry = new ArrayList();
                arry.Add("FrmSGRepairDetail_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 = "SEGMENTID";
            }
            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)
        {
            udteQStartTime.Enabled = chkQStartTime.Checked;
        }

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

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