XinYu_LG2MES/ClientSolution/Core.LgMes.Client.LgDeviceManager/钢包/frmpotrank.cs

using System;
using System.Data;
using System.Drawing;
using System.Collections;
using System.ComponentModel;
using System.Windows.Forms;
using System.Diagnostics;
using Infragistics.Win.UltraWinGrid;
using CoreFS.CA06;

namespace Core.LgMes.Client.LgDeviceManager
{
    public partial class frmpotrank : FrmLgDevFunctions
    {
        public frmpotrank(OpeBase oba)
        {
            InitializeComponent();
            ob = oba;
        }

        private void checkBox1_CheckedChanged(object sender, EventArgs e)
        {
            this.cmbNoLadle.Enabled = this.chkNoLadle.Checked;
        }

        private void checkBox2_CheckedChanged(object sender, EventArgs e)
        {
            this.cmbLevel.Enabled = this.chkLevel.Checked;
        }

        private void checkBox3_CheckedChanged(object sender, EventArgs e)
        {
            this.uDTEStart.Enabled = this.chkTime.Checked;
            this.udteEnd.Enabled = this.chkTime.Checked;
        }

        public string _strPotNo = "";
        /// <summary>
        /// 记录查询
        /// </summary>
        private void GetData()
        {
           
            try
            {
                string strOut = "";
                string sqlstr = " where SENDTOOLNAME = '钢包' ";
                string strSql = " where 1=1 ";

                if (this.chkNoLadle.Checked)
                {
                    sqlstr += "and SENDTOOLID = '" + this.cmbNoLadle.Text + "'";
                }
                if (this.chkLevel.Checked)
                {
                    sqlstr += "and SENDGRADE ='" + this.cmbLevel.Text + "'";
                }
                if (this.chkTime.Checked)
                {
                    sqlstr += " and to_char(sendtime,'yyyy-MM-dd') between '" + this.uDTEStart.DateTime.ToString("yyyy-MM-dd") + "' and '" + this.udteEnd.DateTime.ToString("yyyy-MM-dd") + "' ";
                    strSql += " and to_char(OPTDATE,'yyyy-MM-dd') between '" + this.uDTEStart.DateTime.ToString("yyyy-MM-dd") + "' and '" + this.udteEnd.DateTime.ToString("yyyy-MM-dd") + "'";
                }
                ArrayList arry = new ArrayList();
                ArrayList sqlList = new ArrayList();
                arry.Add("GetPotRandHis_Query");
                sqlList.Add(sqlstr);
                sqlList.Add(strSql);
                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);
                strOut = CCP_LgEts.ReturnInfo;
                try
                {
                    ((DataSet)uGrdtrank.DataSource).Tables[0].Rows.Clear();
                }
                catch (Exception)
                {
                }
                if (ds.Tables[0].Rows.Count > 0)
                {
                    this.uGrdtrank.DataSource = ds;
                }
            }
            catch { }
        }
        /// <summary>
        /// 查询条件
        /// </summary>
        /// <returns></returns>
        private ArrayList BuildSqlstr()
        {
            ArrayList ar = new ArrayList();
            string sqlstr = " where SENDTOOLNAME = '钢包' ";
            string strSql = " where 1=1 ";

            if (this.chkNoLadle.Checked)
            {
                sqlstr += "and SENDTOOLID = '"+this.cmbNoLadle.Text+"'" ;
            }
            if (this.chkLevel.Checked)
            {
                sqlstr += "and SENDGRADE ='" + this.cmbLevel.Text + "'";
            }
            if (this.chkTime.Checked)
            {
                sqlstr += " and to_char(sendtime,'yyyy-MM-dd') between '" + this.uDTEStart.DateTime.ToString("yyyy-MM-dd") + "' and '" + this.udteEnd.DateTime.ToString("yyyy-MM-dd") + "' ";
                strSql += " and to_char(OPTDATE,'yyyy-MM-dd') between '" + this.uDTEStart.DateTime.ToString("yyyy-MM-dd") + "' and '" + this.udteEnd.DateTime.ToString("yyyy-MM-dd") + "'";
            }
            ar.Add(sqlstr);
            ar.Add(strSql);
            return ar;
        }

        private void frmpotrank_Load(object sender, EventArgs e)
        {
            InitComb();
            GetData();
        }
        /// <summary>
        /// 设置Grid样式
        /// </summary>
        private void InitGrid()
        {
            try
            {
                UltraGridBand band = this.uGrdtrank.DisplayLayout.Bands[0];

                band.Header.Appearance.TextHAlign = Infragistics.Win.HAlign.Center;

                band.Columns["SENDTOOLID"].Header.Caption = "钢包号";
                band.Columns["SENDTOOLID"].Width = 60;

                band.Columns["SENDOVENID"].Header.Caption = "发送炉号";
                band.Columns["SENDOVENID"].Width = 88;
                band.Columns["SENDOVENID"].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit;

                band.Columns["SENDGRADE"].Header.Caption = "钢包等级";
                band.Columns["SENDGRADE"].Width = 60;
                band.Columns["SENDGRADE"].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit;

                band.Columns["SHIFTCODE"].Header.Caption = "班别";
                band.Columns["SHIFTCODE"].Width = 60;
                band.Columns["SHIFTCODE"].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit;

                band.Columns["SENDTIME"].Header.Caption = "发送时刻";
                band.Columns["SENDTIME"].Width = 150;
                band.Columns["SENDTIME"].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit;
                band.Columns["SENDTIME"].Format = "yyyy-MM-dd HH:mm:ss";
            }
            catch { }
        }
        /// <summary>
        /// 钢包号查询
        /// </summary>
        private void InitComb()
        {
            try
            {
                DataSet dr = QueryToFunions("Core.LgMes.Server.LgDeviceManager.potmanger", "GetPotRandComb1", "", ob);
                for (int i = 0; i < dr.Tables[0].DefaultView.Count; i++)
                {
                    cmbNoLadle.Items.Add(dr.Tables[0].Rows[i][0].ToString());
                }

                this.chkTime.Checked = true;
            }
            catch (Exception ex) { Console.WriteLine(ex.Message); }

            if (this._strPotNo != "")
            {
                this.chkNoLadle.Checked = true;
                this.chkTime.Checked = true;
                this.cmbNoLadle.Text = this._strPotNo;
            }
        }
        /// <summary>
        /// 窗体菜单
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void toolStrip1_ItemClicked(object sender, ToolStripItemClickedEventArgs e)
        {
            switch (e.ClickedItem.Name)
            {
                case "QUERY":
                    {
                        GetData();
                        break;
                    }
                case "EXPORT":
                    {
                        try
                        {
                            Core.Mes.Client.Common.Globals.ulGridToExcel(uGrdtrank, Text);
                        }
                        catch (Exception ex)
                        {
                            MessageBox.Show(ex.Message);
                        }
                        break;
                    }
                case "CLOSE":
                    {
                        this.Close();
                        break;
                    }
                default:
                    break;
            }
        }
    }
}