MES_Client/TGMES/Core.StlMes.Client.LgCommon/公共自定义控件/实绩管理/ucResElectricity.cs

using System;
using System.Data;
using System.Windows.Forms;
using CoreFS.CA06;

namespace Core.StlMes.Client.LgCommon
{
    public partial class ucResElectricity : UserControl
    {
        public ucResElectricity()
        {
            InitializeComponent();
            ClsControlPack.SetUltraGridAppearance(this);
        }

        public void ResetData()
        {
            try
            {
                this.dataTable1.Rows.Clear();
                ClsControlPack.RefreshAndAutoSize(ultraGrid1);
            }
            catch { }
        }
        //查询精炼炉送电档位
        public void SetData(string HeatNo, string StationCode, string DisposalTime, OpeBase ob)
        {
            try
            {
                string strMsg = "";
                bool bSuccess = false;
                string strSql = "";
                strSql += Convert.ToString("SELECT SELENUMID,").Trim() + " ";
                strSql += Convert.ToString("       SELESTATE,").Trim() + " ";
                strSql += Convert.ToString("       SELETIME,").Trim() + " ";
                strSql += Convert.ToString("       TO_CHAR(SELESTARTTIME, 'HH24:MI:SS') SELESTARTTIME,").Trim() + " ";
                strSql += Convert.ToString("       TO_CHAR(SELEENDTIME, 'HH24:MI:SS') SELEENDTIME").Trim() + " ";
                strSql += Convert.ToString("  FROM (SELECT *").Trim() + " ";
                strSql += Convert.ToString("          FROM STL_LFS_ELECTRICITY").Trim() + " ";
                strSql += Convert.ToString("         WHERE STOVE_NO = '" + HeatNo + "'").Trim() + " ";
                strSql += Convert.ToString("           AND STATIONCODE = '" + StationCode + "'").Trim() + " ";
                strSql += Convert.ToString("           AND DISPOSALTIME = '" + DisposalTime + "'").Trim() + " ";
                strSql += Convert.ToString("        UNION").Trim() + " ";
                strSql += Convert.ToString("        SELECT *").Trim() + " ";
                strSql += Convert.ToString("          FROM J#STL_LFS_ELECTRICITY").Trim() + " ";
                strSql += Convert.ToString("         WHERE STOVE_NO = '" + HeatNo + "'").Trim() + " ";
                strSql += Convert.ToString("           AND STATIONCODE = '" + StationCode + "'").Trim() + " ";
                strSql += Convert.ToString("           AND DISPOSALTIME = '" + DisposalTime + "')").Trim() + " ";
                strSql += Convert.ToString(" ORDER BY SELENUMID").Trim();

                DataSet ds = ClsDataAccessPack.GetData(strSql, out bSuccess, out strMsg, ob);

                if (ds != null && ds.Tables.Count > 0)
                {
                    DataTable table = ds.Tables[0];
                    if (table != null)
                    {
                        for (int i = 0; i < table.Rows.Count; i++)
                        {
                            try
                            {
                                table.Rows[i]["SELETIME"] = ClsDataAccessPack.GetTimeSpan(Convert.ToString(table.Rows[i]["SELETIME"]));
                            }
                            catch { }
                        }
                    }
                    ClsControlPack.CopyDataToDatatable(ref table, ref this.dataTable1, true);
                }
            }
            catch { }
            finally
            {
                ClsControlPack.RefreshAndAutoSize(ultraGrid1);
            }
        }

    }
}