XinYu_LG2MES/ClientSolution/Core.LgMes.Client.lgGlobalMap/lgAllSiteForms/frmHmpPtIronInfo.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;
using Core.LgMes.Server.lgClassModel;
using Core.Mes.Client.Common;
using Core.LgMes.Client.lgBll;


namespace Core.LgMes.Client.lgGlobalMap
{
    public partial class frmHmpPtIronInfo : Core.LgMes.Client.lgGlobalMap.frmBaseSite
    {

        private DataTable _dtHmpJob;
        private string[] _szJobInfo;
        private string[] _szCaption;
        
        
        public frmHmpPtIronInfo()
        {
            InitializeComponent();          
        }

        private void frmHmpPtIronInfo_Load(object sender, EventArgs e)
        {
            FillData();
           
        }

        protected override void FillData()
        {
            SetJobInfo();
            //SetELementInfo();
        }

        private void SetJobInfo()
        {
            string strErr = "";           

            if (string.IsNullOrEmpty(strIronPotNo))
                return;

           
            try
            {
                ArrayList arry = new ArrayList();
                arry.Add("GetGlobalMapIronPotInfo.Select");
                arry.Add(strIronPotNo);
                CommonClientToServer ccTos = new CommonClientToServer();
                ccTos.ob = ob;

                DataSet ds = ccTos.ExecuteQueryFunctions("Core.LgMes.Server.LgGlobalMap.ClassReadDataMgt",
                                                         "GetGlobalMapPotIronInfo", arry, out strErr);
                if (strErr == "" && ds != null)
                {
                    if (ds.Tables.Count > 0)
                    {
                        DataTable dtJob = ds.Tables[0];
                        if (dtJob.Rows.Count > 0)
                        {
                            ulblTBH.Text = dtJob.Rows[0]["LADLEID"].ToString();
                            lblAge.Text = dtJob.Rows[0]["AGE"].ToString();
                            lblBfTemp.Text = dtJob.Rows[0]["BFIRONTEMTURE"].ToString();
                            ulblTSZL.Text = dtJob.Rows[0]["TFPOTWGT"].ToString();
                            ulblJZSK.Text = !string.IsNullOrEmpty(dtJob.Rows[0]["mistapholestarttime"].ToString()) ? dtJob.Rows[0]["mistapholestarttime"].ToString() : "";
                            ulblTLHWD.Text = dtJob.Rows[0]["SWBTEMPERATURE"].ToString();
                            lblPtTemp.Text = dtJob.Rows[0]["IRONTEMPERATURE"].ToString();
                            lblInHeatWgt.Text = dtJob.Rows[0]["LBLINHEATWGT"].ToString();
                            ulblTLJSSK.Text = !string.IsNullOrEmpty(dtJob.Rows[0]["DFRENDTIME"].ToString()) ? dtJob.Rows[0]["DFRENDTIME"].ToString() : "";
                            lblHmpWgt.Text = dtJob.Rows[0]["LEAVEWGT"].ToString();
                            lblSendHeatNo.Text = dtJob.Rows[0]["MOLIRNLEAVE"].ToString();
                            lblMisId.Text = dtJob.Rows[0]["INNO"].ToString();
                            lblTarWgt.Text = dtJob.Rows[0]["TAREWEIGHT"].ToString();
                            lblNowposition.Text = dtJob.Rows[0]["NOWPOSITION"].ToString();
                            ulblTLCLH.Text = dtJob.Rows[0]["HUDWID"].ToString();                           
                            ulblTLKSSK.Text = !string.IsNullOrEmpty(dtJob.Rows[0]["DFRSTARTTIME"].ToString()) ? dtJob.Rows[0]["DFRSTARTTIME"].ToString() : "";
                            lblFGWeight.Text = dtJob.Rows[0]["FGWEIGHT"].ToString();
                           // SetIronTempTime(dtJob);
                            SetELementInfo(dtJob); //铁水成分
                            MethodCallService();
                        }
                    }
                }
            }
            catch (Exception ex)
            {
            }
        }


        public void MethodCallService()
        {
            try
            {
                DataSet ds = new DataSet();
                string strErr = "";
                    string strSql = string.Format(@"(select to_char(a.hstapholetime,'hh24:mi')hstapholetime ,to_char(a.operationdate,'hh24:mi')operationdate ,to_char(b.swbtemperature_date,'hh24:mi')swbtemperature_date from stl_mis_importiron a ,stl_hmp_optinfo b where a.misid ='" + lblMisId.Text + "'and a.molirnsource =b.hudwid(+) )");
                CommonClientToServer cctos = new CommonClientToServer();
                cctos.ob = this.ob;
                ds = cctos.ExecuteQueryFunctions("Core.LgMes.Server.Common.ComDBExecute",
                                                           "doSimpleQuery", strSql, out strErr);
                if (ds.Tables.Count > 0)
                {
                    label2.Text = ds.Tables[0].Rows[0]["operationdate"].ToString();
                    label3.Text = ds.Tables[0].Rows[0]["swbtemperature_date"].ToString();
                    label1.Text = ds.Tables[0].Rows[0]["hstapholetime"].ToString();
                }
            }
            catch { }
        }
        private void SetELementInfo(DataTable dtIronInfo)
        {
            string strErr = "";
            string strItem = "";
            try
            {
                ArrayList arry = new ArrayList();
                arry.Add("GetGlobalMapIronPotChemInfo.Select");
                arry.Add(dtIronInfo.Rows[0]["INNO"].ToString());
                arry.Add(dtIronInfo.Rows[0]["HMPNO"].ToString());

                CommonClientToServer ccTos = new CommonClientToServer();
                ccTos.ob = ob;
                //,Sn,As,Cu,Cr
                DataSet ds = ccTos.ExecuteQueryFunctions("Core.LgMes.Server.LgGlobalMap.ClassReadDataMgt",
                                                         "GetGlobalMapIronPotChemInfo", arry, out strErr);
                if (strErr == "" && ds != null)
                {
                    ultraDataSource2.Rows.Clear();
                    ultraDataSource2.Rows.Add(new object[] {
                                                               dtIronInfo.Rows[0]["STOVEID"].ToString() + "-"
                                                               + dtIronInfo.Rows[0]["STOVETIME"].ToString() + "-"
                                                               + dtIronInfo.Rows[0]["TFPOTID"].ToString(), 
                                                               "高炉",
                                                               "1",       
                                                               dtIronInfo.Rows[0]["C"].ToString(),
                                                               dtIronInfo.Rows[0]["MN"].ToString(),
                                                               dtIronInfo.Rows[0]["SI"].ToString(),
                                                               dtIronInfo.Rows[0]["P"],
                                                               dtIronInfo.Rows[0]["S"],   
                                                               dtIronInfo.Rows[0]["CU"],   
                                                               dtIronInfo.Rows[0]["CR"],   
                                                               dtIronInfo.Rows[0]["NI"],
                                                               dtIronInfo.Rows[0]["TI"],
                                                               dtIronInfo.Rows[0]["SN"],   
                                                               dtIronInfo.Rows[0]["ASN"],
                                                               dtIronInfo.Rows[0]["HSTAPHOLETIME"],
                                                        });
                    if (ds.Tables.Count > 0)
                    {                        

                        DataTable dtChem = ds.Tables[0];
                        if (dtChem.Rows.Count > 0)
                        {
                            foreach (DataRow dr in dtChem.Rows)
                            {
                                if (dr["HEATNO"].ToString().Substring(2, 1) == "3")
                                    strItem = "平台";
                                else
                                    strItem = "脱硫";
                                ultraDataSource2.Rows.Add(new object[] {
                                                               dr["HEATNO"].ToString(),
                                                               strItem,
                                                               dr["ASSAYTYPECODE"].ToString().Substring(3,1),       
                                                               dr["C"].ToString(),
                                                               dr["MN"].ToString(),
                                                               dr["SI"].ToString(),
                                                               dr["P"],
                                                               dr["S"],   
                                                               dr["CU"],   
                                                               dr["CR"],  
                                                               dr["NI"],
                                                               dr["TI"],
                                                               dr["SN"],   
                                                               dr["ASN"],
                                                               dr["ASSAYDATE"],    
                                                        });
                            }
                        }
                    }
                }
            }
            catch (Exception ex)
            {
            }        
        }
                

        private void SetJobGridData(int row, DataTable obj, ref DataTable dt)
        {
            try
            {

                dt.Rows[row]["SB_FIRST_STARTIME"] = obj.Rows[0]["SB_FIRST_STARTIME"].ToString();
                dt.Rows[row]["SB_FIRST_ENDTIME"] =  obj.Rows[0]["SB_FIRST_ENDTIME"].ToString();
                dt.Rows[row]["SB_FIRST_TIME"] =  obj.Rows[0]["SB_FIRST_TIME"].ToString();
                dt.Rows[row]["FIRSTQUANTITY"] =  obj.Rows[0]["FIRSTQUANTITY"].ToString();
                dt.Rows[row]["SB_SECOND_STARTIME"] = obj.Rows[0]["SB_SECOND_STARTIME"].ToString();
                dt.Rows[row]["SB_SECOND_ENDTIME"] = obj.Rows[0]["SB_SECOND_ENDTIME"].ToString();
                dt.Rows[row]["SB_SECOND_TIME"] = obj.Rows[0]["SB_SECOND_TIME"].ToString();
                dt.Rows[row]["SECONDQUANTITY"] = obj.Rows[0]["SECONDQUANTITY"].ToString();
                dt.Rows[row]["SB_THIRD_STARTIME"] = obj.Rows[0]["SB_THIRD_STARTIME"].ToString();
                dt.Rows[row]["SB_THIRD_ENDTIME"] = obj.Rows[0]["SB_THIRD_ENDTIME"].ToString();
                dt.Rows[row]["SB_THIRD_TIME"] = obj.Rows[0]["SB_THIRD_TIME"].ToString();
                dt.Rows[row]["THIRDQUANTITY"] = obj.Rows[0]["THIRDQUANTITY"].ToString();
                dt.Rows[row]["SWFTEMPERATURE"] = obj.Rows[0]["SWFTEMPERATURE"].ToString();
                dt.Rows[row]["SWBTEMPERATURE"] = obj.Rows[0]["SWBTEMPERATURE"].ToString();
                dt.Rows[row]["IRONWGT"] = obj.Rows[0]["IRONWGT"].ToString();
                dt.Rows[row]["ARRIVEWGT"] = obj.Rows[0]["ARRIVEWGT"].ToString();
                dt.Rows[row]["LEAVEWGT"] = obj.Rows[0]["LEAVEWGT"].ToString();
                dt.Rows[row]["MIX_REALITY_HEIGHT"] = obj.Rows[0]["MIX_REALITY_HEIGHT"].ToString();
            }
            catch { }
        }

        private void frmHmp_Resize(object sender, EventArgs e)
        {
            this.Width = 794;
            this.Height = 593;
        }

        private void label7_Click(object sender, EventArgs e)
        {

        }

           
   
        /// <summary>
        /// 在铁水罐弹出中添加测温时间，值与脱硫实绩中的值一致
        /// </summary>
        /// <param name="vMisId">脱硫处理号</param>
        private void SetIronTempTime(DataTable dtJob)
        {
            string vMisId =  dtJob.Rows[0]["HUDWID"].ToString();
            string vIronSeq = dtJob.Rows[0]["INNO"].ToString();
            try
            {
                //获取测温时间
                string ironItemTime = returnIronTbValue(vMisId, "SWBTEMPERATURE_DATE");
                string ironCreateTime = GetIronCreateDate(vIronSeq);
                // 有测温时间，显示测温时间，没有则显示入厂时间
                if (ironItemTime.Length > 0)
                {
                    //转换
                    this.label1.Text = Convert.ToDateTime(ironItemTime).ToString("HH:mm");
                }
                else
                {
                    this.label1.Text = (ironCreateTime.Length > 0) ? Convert.ToDateTime(ironCreateTime).ToString("HH:mm") : "";
                }
            }
            catch
            { 
            }
 
        }

        /// <summary>
        /// 获取进铁数据录入时间
        /// </summary>
        /// <param name="vMisId"></param>
        /// <returns></returns>
        private string GetIronCreateDate(string vMisId)
        {
            string returnStr = "";
            try
            {
                ClientParamWithSqlConditionAndOpenBase param =                  
                    new ClientParamWithSqlConditionAndOpenBase(string.Format(" and misid = '{0}'", vMisId), this.ob);
                DataSet dsIron = lgBll.lgResMgt.LgStlMisImportironMgt.GetStlMisImportiron(param);
                if (lgCommon.isDataSetDataFoundCheck(dsIron))
                    returnStr = lgCommon.returnColumnValueFromDsByColumnName(dsIron, "ARRIVETIME").ToString();      

            }
            catch
            { 
            }

            return returnStr;
        }


        private string returnIronTbValue(string vMisId,string columnName)
        {
            string returnStr = "";
            //获取脱硫实绩数据
            DataSet ds = null;
            ds = lgBll.lgResMgt.LgStlHmpOptinfoMgt.GetstlHmpOption(new ClientParamWithSqlConditionAndOpenBase(string.Format(" and hudwid = '{0}'", vMisId), this.ob));
            try
            {
                if (lgCommon.isDataSetDataFoundCheck(ds))
                    returnStr = lgCommon.returnColumnValueFromDsByColumnName(ds, columnName).ToString();              
            }
            catch
            {
            }
            return returnStr;
        }

        private void ulgridElement_InitializeRow(object sender, Infragistics.Win.UltraWinGrid.InitializeRowEventArgs e)
        {

            if (Convert.ToDouble(string.IsNullOrEmpty(e.Row.Cells["Cu"].Text.Trim()) ? "0" : e.Row.Cells["Cu"].Text.Trim()) > 0.038)
            {
                e.Row.Cells["Cu"].Appearance.BackColor = Color.Red;
            }
            else if (Convert.ToDouble(string.IsNullOrEmpty(e.Row.Cells["Cr"].Text.Trim()) ? "0" : e.Row.Cells["Cr"].Text.Trim()) > 0.038)
            {
                e.Row.Cells["Cr"].Appearance.BackColor = Color.Red;
            }
            else if (Convert.ToDouble(string.IsNullOrEmpty(e.Row.Cells["NI"].Text.Trim()) ? "0" : e.Row.Cells["NI"].Text.Trim()) > 0.019)
            {
                e.Row.Cells["NI"].Appearance.BackColor = Color.Red;
            }
        }
    }
}