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)
{
}
///
/// 在铁水罐弹出中添加测温时间，值与脱硫实绩中的值一致
///
/// 脱硫处理号
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
{
}
}
///
/// 获取进铁数据录入时间
///
///
///
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;
}
}
}
}