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

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

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

        private void FrmPotSendSuccesful_Load(object sender, EventArgs e)
        {
            GetData();
        }
        /// <summary>
        /// 查询条件
        /// </summary>
        /// <returns></returns>
        private string[] BuildSQL()
        {
            string strSqlA = " where SENDTOOLNAME = '钢包' and length(SENDOVENID) > 0 ";
            strSqlA += string.Format(" and to_char(sendtime,'yyyy-MM-dd') between '{0}' and '{1}'", this.udteStart.DateTime.ToString("yyyy-MM-dd"), this.udteEnd.DateTime.ToString("yyyy-MM-dd"));
            string strSqlB = string.Format(" where to_char(OPTDATE,'yyyy-MM-dd') between '{0}' and '{1}'", this.udteStart.DateTime.ToString("yyyy-MM-dd"), this.udteEnd.DateTime.ToString("yyyy-MM-dd"));

            return new string[] { strSqlA, strSqlB };
        }
        /// <summary>
        /// 查询
        /// </summary>
        private void GetData()
        {
            try
            {
               string[] numbers =BuildSQL() ;
               string strsql = "select SENDTOOLID, SENDOVENID, SENDGRADE, SHIFTCODE, to_char(sendtime,'yyyy-mm-dd HH24:mi:ss')SENDTIME "
                    + ",(select  t.skatefactory1 "
                    + " from (select t.*,(select t2.basename from scm_base_info t2 where t2.basecode=t.skatefactory) skatefactory1 from dev_gb_use_detail t) t "
                    + "where t.heatno = sendovenid "
                    + " and rownum = 1) SKATEFACTORY "
                    + "from (select x.*, "
                    + "row_number() over(partition by x.SENDOVENID order by x.sendtime desc) xh from "
                    + "(select a.SENDTOOLID, a.SENDOVENID, a.SENDGRADE, b.SHIFTCODE, a.sendtime "
                    + "from "
                    + "(select * from DEV_TOOLSENDDETAIL " + numbers[0] + ") a, "
                    + "(select x.HEATNO, max(x.SHIFTCODE) over (partition by x.HEATNO) SHIFTCODE from "
                    + "(select HEATNO, decode(substr(SHIFTCODE,2,1),'1','甲','2','乙','3','丙','4','丁') SHIFTCODE from STL_BOF_OPTINFO " + numbers[1] + " union all "
                    + " select HEATNO, decode(substr(SHIFTCODE,2,1),'1','甲','2','乙','3','丙','4','丁') SHIFTCODE from J#STL_BOF_OPTINFO " + numbers[1] + ") x) b "
                    + "where a.SENDOVENID = b.HEATNO(+)) x) where xh = 1";
                DataSet ds = QueryFixedFunions(strsql, ob);
                try
                {
                    ((DataSet)uGrdSendHiy.DataSource).Tables[0].Rows.Clear();
                }
                catch (Exception)
                {
                }
                if (ds.Tables[0].Rows.Count > 0)
                {
                    this.uGrdSendHiy.DataSource = ds;
                }
                
            }
            catch { }

        }
        /// <summary>
        /// 设置Grid样式
        /// </summary>
        private void InitData()
        {
            try
            {
                UltraGridBand band = this.uGrdSendHiy.DisplayLayout.Bands[6];

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

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

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

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

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

                band.Columns[4].Header.Caption = "发送时刻";
                band.Columns[4].Width = 150;
                band.Columns[4].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit;
                band.Columns[4].Format = "yyyy-MM-dd HH:mm:ss";

                band.Columns[5].Header.Caption = "滑板厂家";
                band.Columns[5].Width = 60;
                band.Columns[5].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit;

            }
            catch
            { }
        }

        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(uGrdSendHiy, Text);
                        }
                        catch (Exception ex)
                        {
                            MessageBox.Show(ex.Message);
                        }
                        break;
                    }
                case "CLOSE":
                    {
                        this.Close();
                        break;
                    }
                default:
                    break;
            }
        }


    }
}