using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using CoreFS.CA06;
using System.Threading;
using System.Diagnostics;
using System.IO;
using Infragistics.Win.UltraWinGrid;
using System.Collections;
using Core.Mes.Client.Common;
namespace Core.LgMes.Client.LgResMgt
{
public partial class FrmScrapSteel : Core.Mes.Client.Common.frmStyleBase
{
private System.Threading.Thread myThread_FG;
private string _strSendSucceededForBof1 = "";
private string _strSendSucceededForBof2 = "";
private string _strSendSucceededForBof3 = "";
public FrmScrapSteel()
{
InitializeComponent();
CheckForIllegalCrossThreadCalls = false;
}
private void checkBox2_CheckedChanged(object sender, EventArgs e)
{
if (this.checkBox2.Checked == true)
{
this.udte_StartTime.Enabled = true;
this.udte_EndTime.Enabled = true;
}
else
{
this.udte_StartTime.Enabled = false;
this.udte_EndTime.Enabled = false;
}
}
private void checkBox1_CheckedChanged(object sender, EventArgs e)
{
if (this.checkBox1.Checked == true)
{
this.ute_DH.Enabled = true;
}
else
{
this.ute_DH.Enabled = false;
}
}
private void FrmScrapSteel_Load(object sender, EventArgs e)
{
label1.BackColor = Color.LightGreen;
label3.BackColor = Color.LightCyan;
label18.BackColor = Color.White;
this.udte_StartTime.Text = System.DateTime.Now.AddDays(-2).ToString("yyyy-MM-dd")+" 00:00:00";
this.udte_EndTime.Text = System.DateTime.Now.ToString("yyyy-MM-dd")+" 23:59:59";
GetRLMX_Data();
GetZL_SCJH();
GetZL_Thread();
this.utlcbdevNo.SelectedIndex = 3;
cbb_FGZL.SelectedIndex = 0;
}
///
/// 获取转炉生产计划记录
///
private void GetZL_SCJH()
{
try
{
string szOut = "",strWhere = "";
int RowID_1 = 0, RowID_2 = 0, RowID_3 = 0;
this.dataTable2.Rows.Clear();
this.dataTable3.Rows.Clear();
this.dataTable4.Rows.Clear();
if (this.checkBox2.Checked == true)
{
strWhere = " and PLAN_MAKING_TIME between to_date('" + this.udte_StartTime.Value + "','yyyy-MM-dd HH24:mi:ss') and to_date('" + this.udte_EndTime.Value + "','yyyy-MM-dd HH24:mi:ss') ";
}
else
{
//strWhere = " and a.aim_grade_code=b.steelcode and (heat_state='03' or heat_state='04') and PLAN_MAKING_TIME between to_date('" + this.udte_StartTime.Value + "','yyyy-MM-dd HH24:mi:ss') and to_date('" + this.udte_EndTime.Value + "','yyyy-MM-dd HH24:mi:ss') ";
strWhere = " and PLAN_MAKING_TIME between to_date('" + System.DateTime.Now.ToString("yyyy-MM-dd") + " 00:00:00','yyyy-MM-dd HH24:mi:ss') and to_date('" + System.DateTime.Now.ToString("yyyy-MM-dd") + " 23:59:59','yyyy-MM-dd HH24:mi:ss')";
}
ArrayList arry = new ArrayList();
ArrayList sqlList = new ArrayList();
arry.Add("GetZL_SCJH.query");
sqlList.Add(strWhere);
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);
szOut = CCP_LgEts.ReturnInfo;
//DataSet ds = null;// (DataSet)Core.Mes.ClientFrameWork.ClientCommon._RemotingHelp.ExecuteMethod("lgResMgt", "Core.LgMes.Server.LgResMgt.LfsCollect", "GetZYJH_Data", new object[] { strWhere }, out szOut);
if (szOut == "")
{
if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
if (ds.Tables[0].Rows[i]["routeline"].ToString().Substring(5, 1) == "1")
{
DataRow dr = this.dataTable2.NewRow();
for (int j = 0; j < this.dataTable2.Columns.Count; j++)
{
dr[this.dataTable2.Columns[j].ColumnName.ToString()] = ds.Tables[0].Rows[i][this.dataTable2.Columns[j].ColumnName.ToString()].ToString();
}
this.dataTable2.Rows.Add(dr);
if (ds.Tables[0].Rows[i]["PlanExecuteStatus"].ToString() == "计划状态") //计划状态
{
foreach (UltraGridCell cell in ultraGrid2.Rows[RowID_1].Cells)
{
cell.Appearance.BackColor = Color.White;//计划状态
}
}
else if (ds.Tables[0].Rows[i]["PlanExecuteStatus"].ToString() == "生产状态")
{
foreach (UltraGridCell cell in ultraGrid2.Rows[RowID_1].Cells)
cell.Appearance.BackColor = Color.LightGreen;//生产状态
}
else if (ds.Tables[0].Rows[i]["PlanExecuteStatus"].ToString() == "生产完成")
{
foreach (UltraGridCell cell in ultraGrid2.Rows[RowID_1].Cells)
cell.Appearance.BackColor = Color.LightCyan;//生产完成
}
RowID_1 += 1;
}
if (ds.Tables[0].Rows[i]["routeline"].ToString().Substring(5, 1) == "2")
{
DataRow dr = this.dataTable3.NewRow();
for (int j = 0; j < this.dataTable3.Columns.Count; j++)
{
dr[this.dataTable3.Columns[j].ColumnName.ToString()] = ds.Tables[0].Rows[i][this.dataTable3.Columns[j].ColumnName.ToString()].ToString();
}
this.dataTable3.Rows.Add(dr);
if (ds.Tables[0].Rows[i]["PlanExecuteStatus"].ToString() == "计划状态") //计划状态
{
foreach (UltraGridCell cell in ultraGrid3.Rows[RowID_2].Cells)
{
cell.Appearance.BackColor = Color.White;//计划状态
}
}
else if (ds.Tables[0].Rows[i]["PlanExecuteStatus"].ToString() == "生产状态")
{
foreach (UltraGridCell cell in ultraGrid3.Rows[RowID_2].Cells)
cell.Appearance.BackColor = Color.LightGreen;//生产状态
}
else if (ds.Tables[0].Rows[i]["PlanExecuteStatus"].ToString() == "生产完成")
{
foreach (UltraGridCell cell in ultraGrid3.Rows[RowID_2].Cells)
cell.Appearance.BackColor = Color.LightCyan;//生产状态
}
RowID_2 += 1;
}
if (ds.Tables[0].Rows[i]["routeline"].ToString().Substring(5, 1) == "3")
{
DataRow dr = this.dataTable4.NewRow();
for (int j = 0; j < this.dataTable4.Columns.Count; j++)
{
dr[this.dataTable4.Columns[j].ColumnName.ToString()] = ds.Tables[0].Rows[i][this.dataTable4.Columns[j].ColumnName.ToString()].ToString();
}
this.dataTable4.Rows.Add(dr);
if (ds.Tables[0].Rows[i]["PlanExecuteStatus"].ToString() == "计划状态") //计划状态
{
foreach (UltraGridCell cell in ultraGrid4.Rows[RowID_3].Cells)
{
cell.Appearance.BackColor = Color.White;//计划状态
}
}
else if (ds.Tables[0].Rows[i]["PlanExecuteStatus"].ToString() == "生产状态")
{
foreach (UltraGridCell cell in ultraGrid4.Rows[RowID_3].Cells)
cell.Appearance.BackColor = Color.LightGreen;//计划状态
}
else if (ds.Tables[0].Rows[i]["PlanExecuteStatus"].ToString() == "生产完成")
{
foreach (UltraGridCell cell in ultraGrid4.Rows[RowID_3].Cells)
cell.Appearance.BackColor = Color.LightCyan;//生成完成
}
RowID_3 += 1;
}
}
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
///
/// 打开窗体时自动取入炉明细数据
///
private void GetRLMX_Data()
{
try
{
this.dataTable1.Rows.Clear();
string szOut = "", strWhere = "";
if (this.checkBox2.Checked == true)
{
strWhere = " where JOBDATE between to_date('" + this.udte_StartTime.Value + "','yyyy-MM-dd HH24:mi:ss') and to_date('" + this.udte_EndTime.Value + "','yyyy-MM-dd HH24:mi:ss') ";
}
else
{
strWhere = " where JOBDATE between to_date('" + System.DateTime.Now.ToString("yyyy-MM-dd") + " 00:00:00','yyyy-MM-dd HH24:mi:ss') and to_date('" + System.DateTime.Now.ToString("yyyy-MM-dd") + " 23:59:59','yyyy-MM-dd HH24:mi:ss')";
}
if (this.checkBox1.Checked == true)
{
strWhere += " and CHARGENO = '" + ute_DH.Text.ToString().Trim() + "' ";
}
ArrayList arry = new ArrayList();
ArrayList sqlList = new ArrayList();
arry.Add("GetRLMX_Data.query");
sqlList.Add(strWhere);
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);
szOut = CCP_LgEts.ReturnInfo;
//DataSet ds = null;// (DataSet)Core.Mes.ClientFrameWork.ClientCommon._RemotingHelp.ExecuteMethod("lgResMgt", "Core.LgMes.Server.LgResMgt.LfsCollect", "GetRLMX_Data", new object[] { strWhere }, out szOut);
if (szOut == "")
{
if (ds.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
DataRow dr = this.dataTable1.NewRow();
for (int j = 0; j < this.dataTable1.Columns.Count; j++)
{
if (dataTable1.Columns[j].ColumnName == "BC")
{
string v_BC = "";
if (ds.Tables[0].Rows[i]["BC"].ToString().Length > 1)
v_BC = ds.Tables[0].Rows[i]["BC"].ToString().Trim().Substring(1, 1);
if (v_BC == "1")
dr[dataTable1.Columns[j].ColumnName] = "甲班";
if (v_BC == "2")
dr[dataTable1.Columns[j].ColumnName] = "乙班";
if (v_BC == "3")
dr[dataTable1.Columns[j].ColumnName] = "丙班";
if (v_BC == "4")
dr[dataTable1.Columns[j].ColumnName] = "丁班";
}
else if (dataTable1.Columns[j].ColumnName == "ZYSJ")
{
dr["ZYSJ"] = Convert.ToDateTime(ds.Tables[0].Rows[i]["ZYSJ"].ToString()).ToString("yyyy-MM-dd HH:mm:ss");
}
else
{
if (ds.Tables[0].Columns.Contains(dataTable1.Columns[j].ColumnName) && !string.IsNullOrEmpty(ds.Tables[0].Rows[i][dataTable1.Columns[j].ColumnName].ToString()))
dr[dataTable1.Columns[j].ColumnName] = ds.Tables[0].Rows[i][dataTable1.Columns[j].ColumnName].ToString();
}
}
this.dataTable1.Rows.Add(dr);
}
this.dataTable1.AcceptChanges();
SetSteelSum();
}
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
///
/// 统计废钢重量
///
private void SetSteelSum()
{
UltraGridBand band = this.ultraGrid1.DisplayLayout.Bands[0];
band.Summaries.Clear();
SummarySettings summary = band.Summaries.Add(SummaryType.Count, band.Columns[1]);
summary.SummaryPosition = SummaryPosition.UseSummaryPositionColumn;
summary.DisplayFormat = "合计:";
for (int i = 7; i < 14; i++)
{
summary = band.Summaries.Add(SummaryType.Sum, band.Columns[i]);
summary.SummaryPosition = SummaryPosition.UseSummaryPositionColumn;
summary.DisplayFormat = " {0:#####.00}";
summary.Appearance.TextHAlign = Infragistics.Win.HAlign.Center;
summary.Appearance.ForeColor = Color.DarkBlue;
summary.Appearance.BackColor = Color.White;
}
band.Override.SummaryFooterCaptionVisible = Infragistics.Win.DefaultableBoolean.False;
}
///
/// 菜单栏
///
///
///
public override void ToolBar_Click(object sender, string ToolbarKey)
{
base.ToolBar_Click(sender, ToolbarKey);
switch (ToolbarKey)
{
case "Add"://新增
try
{
ute_RLSJ.Text = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
}
catch
{
return;
}
AddNewData();
GetRLMX_Data();
break;
case "Update"://修改
if (!string.IsNullOrEmpty(ute_DH2.Text.Trim()) && !string.IsNullOrEmpty(ultNo.Text.Trim()))
{
DialogResult result;
string mk = "确实要修改吗?";
result = MessageBox.Show(this, mk, "提示", MessageBoxButtons.YesNo,
MessageBoxIcon.Question);
if (result == DialogResult.Yes)
{
if (ultraGrid1.ActiveRow != null)
{
try
{
DateTime aa = Convert.ToDateTime(ute_RLSJ.Text.ToString());
string strXH = this.ultraGrid1.ActiveRow.Cells["ZYXH"].Value.ToString().Trim();
UpdateDataRow(strXH);
GetRLMX_Data();
}
catch
{
MessageBox.Show("入炉时间 不是合法的日期时间!\n\n请重新选择入炉时间!", "提示");
}
}
else
{
MessageBox.Show("请选择需要修改的记录!", "提示");
}
}
}
else
MessageBox.Show("请选择需要修改的记录!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
break;
case "Delete"://删除
if (!string.IsNullOrEmpty(ute_DH2.Text.Trim()) && !string.IsNullOrEmpty(this.ultNo.Text.Trim()))
{
DialogResult result;
string mk = "确实要删除吗?";
result = MessageBox.Show(this, mk, "提示", MessageBoxButtons.YesNo,
MessageBoxIcon.Question);
if (result == DialogResult.Yes)
{
string strXH = this.ultraGrid1.ActiveRow.Cells["ZYXH"].Value.ToString().Trim();
DeleteDataRow(strXH);
GetRLMX_Data();
}
}
else
{
MessageBox.Show("请选择要删除的行!", "提示");
}
break;
case "Query":// 查询
GetRLMX_Data();
GetZL_SCJH();
break;
case "Export"://导Excel
try
{
if (ultraTabControl1.SelectedTab.Text.Trim() != "入炉明细") return;
if (ultraGrid1.ActiveRow != null)
{
string StrfileName = string.Format(System.Windows.Forms.Application.StartupPath + "\\Report\\{0}.xls", "废钢配斗信息");
this.ultraGridExcelExporter1.Export(this.ultraGrid1, StrfileName);
ProcessStartInfo p = new ProcessStartInfo(StrfileName);
p.WorkingDirectory = Path.GetDirectoryName(StrfileName);
Process.Start(p);
}
else
{
MessageBox.Show("入炉明细信息不能为空!", "提示");
return;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
break;
case "Exit":
this.Close();
break;
default:
break;
}
}
///
/// 新增记录
///
private void AddNewData()
{
try
{
if (ute_DH2.Text.Trim().Length == 0)
{
MessageBox.Show("溜槽号不能为空,请输入溜槽号!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
return;
}
if (ute_ZZ.Text.Trim().Length == 0)
{
MessageBox.Show("没有废钢信息,请输入!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
return;
}
string strErr = "";
string m_szCurrClass = "";
ArrayList arry = new ArrayList();
arry.Add("GetClassCode.query");
CommonClientToServer ccs = new CommonClientToServer();
ccs.ob = this.ob;
DataSet ds = ccs.ExecuteQueryFunctions("Core.LgMes.Server.Common.ComDBQuery", "doSimpleQuery", arry, out strErr);
if (ds.Tables[0].Rows.Count > 0)
{
m_szCurrClass = ds.Tables[0].Rows[0]["mes"].ToString(); // +Convert.ToString(cbb_BC.SelectedIndex + 1);
}
string[] ArrayCZXX = new string[21] { "", "", "", "", "", "", "", "", "", "", "", "", "","","","","","","","",""}; //保存信息
ArrayCZXX[0] = ute_DH2.Text.Trim();
ArrayCZXX[1] = ute_STZL.Text.Trim();
ArrayCZXX[2] = ute_RLZL.Text.Trim();
ArrayCZXX[3] = ute_LH.Text.Trim();
ArrayCZXX[4] = ute_CLZ.Text.Trim();
ArrayCZXX[5] = ute_ZZ.Text.Trim();
int v_BC = this.cbb_BC.SelectedIndex + 1;
//ArrayCZXX[6] = Core.LgMes.Client.LgResMgt.StaticFunction.GetClassCode() + Convert.ToString(v_BC); //班次
ArrayCZXX[6] = m_szCurrClass; //班次
ArrayCZXX[7] = ute_HGLZ.Text.Trim();
ArrayCZXX[8] = ute_DZ.Text.Trim();
ArrayCZXX[9] = cbb_FGZL.Text.Trim();
ArrayCZXX[10] = ute_ZGZL.Text.Trim();
ArrayCZXX[11] = Convert.ToDateTime(ute_RLSJ.Text.Trim().ToString()).ToString("yyyy-MM-dd HH:mm:ss");
ArrayCZXX[12] = ute_BZ.Text.Trim();
ArrayCZXX[13] = this.UserInfo.GetUserName();
if (this.utlcbdevNo.SelectedItem != null)
ArrayCZXX[14] = this.utlcbdevNo.SelectedItem.DataValue.ToString();
else
ArrayCZXX[14] = "";
ArrayCZXX[15] = ute_C.Text.Trim();
ArrayCZXX[16] = ute_Si.Text.Trim();
ArrayCZXX[17] = ute_Mn.Text.Trim();
ArrayCZXX[18] = ute_P.Text.Trim();
ArrayCZXX[19] = ute_S.Text.Trim();
ArrayCZXX[20] = ute_As.Text.Trim();
string strError = "";
string SQLid="AddNewData.Add";
//if (ute_LH.Text.Trim().Length > 0)
//{
Cursor oldCursor = this.Cursor;
this.Cursor = Cursors.WaitCursor;//等待光标
try
{
CoreClientParam ccp = new CoreClientParam();
ccp.ServerName = "Core.LgMes.Server.DEV.Methods.DEVPublicMethods";
ccp.MethodName = "procedure_A";
ccp.ServerParams = new object[] { "res_lg_lfsmanage.InsertFG ", ArrayCZXX };
ExecuteNonQuery(ccp, CoreInvokeType.Internal);
strError = ccp.ReturnInfo;
if (strError != "")
{
this.Cursor = oldCursor;
MessageBox.Show("新增不成功,查看输入的熔炼号废钢是否已添加!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
else
{
MessageBox.Show(" 废钢新增成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
this.Cursor = oldCursor;
}
}
catch (System.Exception exp)
{
this.Cursor = oldCursor;
MessageBox.Show("新增不成功!\n" + exp.ToString(), "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
//}
}
catch(Exception ex)
{
MessageBox.Show(ex.Message);
}
}
///
/// 删除记录
///
private void DeleteDataRow(string strXH)
{
try
{
string szOut = "";
string[] strParams = new string[1] { strXH };
CoreClientParam ccp = new CoreClientParam();
ccp.ServerName = "Core.LgMes.Server.DEV.Methods.DEVPublicMethods";
ccp.MethodName = "procedure_A";
ccp.ServerParams = new object[] { "RES_LG_LFSMANAGE.DeleteFG", strParams };
ExecuteNonQuery(ccp, CoreInvokeType.Internal);
szOut = ccp.ReturnInfo;
if (szOut != "")
{
MessageBox.Show(szOut, "删除失败!");
}
else
{
MessageBox.Show("废钢信息删除成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
ClearData();//清除控件内容
}
}
catch(Exception ex)
{
MessageBox.Show(ex.Message);
}
}
///
/// 清除内容
///
private void ClearData()
{
ute_DH2.Text = "";
ute_STZL.Text = "";
ute_RLZL.Text = "";
ute_LH.Text = "";
ute_CLZ.Text = "";
ute_ZZ.Text = "";
cbb_BC.Text = "";
ute_HGLZ.Text = "";
ute_DZ.Text = "";
cbb_FGZL.Text = "";
ute_ZGZL.Text = "";
ute_RLSJ.Text = "";
ute_BZ.Text = "";
ute_C.Text = "";
ute_Si.Text = "";
ute_Mn.Text = "";
ute_P.Text = "";
ute_S.Text = "";
ute_As.Text = "";
}
private void ultraGrid1_Click(object sender, EventArgs e)
{
if (this.ultraGrid1.ActiveRow != null)
{
#region 先清除控件内的信息
ClearData();
#endregion
#region 选中ultragrid中一行时,自动将对应的值赋给下面的控件
ute_DH2.Text = this.ultraGrid1.ActiveRow.Cells["ZDDH"].Value.ToString();
ute_STZL.Text = this.ultraGrid1.ActiveRow.Cells["STZL"].Value.ToString();
ute_RLZL.Text = this.ultraGrid1.ActiveRow.Cells["RLZL"].Value.ToString();
ute_LH.Text = this.ultraGrid1.ActiveRow.Cells["LH"].Value.ToString();
ute_CLZ.Text = this.ultraGrid1.ActiveRow.Cells["CLZL"].Value.ToString();
ute_ZZ.Text = this.ultraGrid1.ActiveRow.Cells["ZZ"].Value.ToString();
cbb_BC.Text = this.ultraGrid1.ActiveRow.Cells["BC"].Value.ToString();
ute_HGLZ.Text = this.ultraGrid1.ActiveRow.Cells["HGZL"].Value.ToString();
ute_DZ.Text = this.ultraGrid1.ActiveRow.Cells["DZ"].Value.ToString();
cbb_FGZL.Text = this.ultraGrid1.ActiveRow.Cells["FGZL"].Value.ToString();
ute_ZGZL.Text = this.ultraGrid1.ActiveRow.Cells["ZGZL"].Value.ToString();
ute_RLSJ.Text = Convert.ToDateTime(this.ultraGrid1.ActiveRow.Cells["ZYSJ"].Value.ToString()).ToString("yyyy-MM-dd HH:mm:ss");
ute_BZ.Text = this.ultraGrid1.ActiveRow.Cells["BZ"].Value.ToString();
ultNo.Text = this.ultraGrid1.ActiveRow.Cells["ZYXH"].Value.ToString();
if (!string.IsNullOrEmpty(this.ultraGrid1.ActiveRow.Cells["GWBH"].Value.ToString()))
utlcbdevNo.Text = this.ultraGrid1.ActiveRow.Cells["GWBH"].Value.ToString();
ute_C.Text = this.ultraGrid1.ActiveRow.Cells["C"].Value.ToString();
ute_Mn.Text = this.ultraGrid1.ActiveRow.Cells["Mn"].Value.ToString();
ute_P.Text = this.ultraGrid1.ActiveRow.Cells["P"].Value.ToString();
ute_S.Text = this.ultraGrid1.ActiveRow.Cells["S"].Value.ToString();
ute_As.Text = this.ultraGrid1.ActiveRow.Cells["Asn"].Value.ToString();
#endregion
}
}
///
/// 修改废钢配斗记录
///
///
private void UpdateDataRow(string strXH)
{
try
{
string[] ArrayCZXX = new string[22] { "","", "", "", "", "", "", "", "", "", "", "", "", "", "" ,"","","","","","",""}; //保存信息
string strErr = "";
string m_szCurrClass = "";
ArrayList arry = new ArrayList();
arry.Add("GetClassCode.query");
CommonClientToServer ccs = new CommonClientToServer();
ccs.ob = this.ob;
//arry.Add("");
DataSet ds = ccs.ExecuteQueryFunctions("Core.LgMes.Server.Common.ComDBQuery", "doSimpleQuery", arry, out strErr);
if (ds.Tables[0].Rows.Count > 0)
{
m_szCurrClass = ds.Tables[0].Rows[0]["mes"].ToString();
}
ArrayCZXX[0] = ute_DH2.Text.Trim();
ArrayCZXX[1] = ute_STZL.Text.Trim();
ArrayCZXX[2] = ute_RLZL.Text.Trim();
ArrayCZXX[3] = ute_LH.Text.Trim();
ArrayCZXX[4] = ute_CLZ.Text.Trim();
ArrayCZXX[5] = ute_ZZ.Text.Trim();
ArrayCZXX[6] = m_szCurrClass;
ArrayCZXX[7] = ute_HGLZ.Text.Trim();
ArrayCZXX[8] = ute_DZ.Text.Trim();
ArrayCZXX[9] = cbb_FGZL.Text.Trim();
ArrayCZXX[10] = ute_ZGZL.Text.Trim();
ArrayCZXX[11] = ute_RLSJ.Text.Trim();
ArrayCZXX[12] = ute_BZ.Text.Trim();
ArrayCZXX[13] = this.UserInfo.GetUserName();
ArrayCZXX[14] = strXH.ToString().Trim();
if (this.utlcbdevNo.SelectedItem != null)
ArrayCZXX[15] = this.utlcbdevNo.SelectedItem.DataValue.ToString();
else
ArrayCZXX[15] = "";
ArrayCZXX[16] = ute_C.Text.Trim();
ArrayCZXX[17] = ute_Si.Text.Trim();
ArrayCZXX[18] = ute_Mn.Text.Trim();
ArrayCZXX[19] = ute_P.Text.Trim();
ArrayCZXX[20] = ute_S.Text.Trim();
ArrayCZXX[21] = ute_As.Text.Trim();
Cursor oldCursor = this.Cursor;
this.Cursor = Cursors.WaitCursor;//等待光标
try
{
string strError = "";
CoreClientParam ccp = new CoreClientParam();
ccp.ServerName = "Core.LgMes.Server.DEV.Methods.DEVPublicMethods";
ccp.MethodName = "procedure_A";
ccp.ServerParams = new object[] { "RES_LG_LFSMANAGE.UpdateFG", ArrayCZXX };
ExecuteNonQuery(ccp, CoreInvokeType.Internal);
strError = ccp.ReturnInfo;
if (strError != "")
{
this.Cursor = oldCursor;
MessageBox.Show("保存不成功!\n" + strError, "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
else
{
this.Cursor = oldCursor;
}
}
catch (System.Exception exp)
{
this.Cursor = oldCursor;
MessageBox.Show("保存不成功!\n" + exp.ToString(), "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
//
//实时刷新当前转炉正在冶炼的熔炼号
//
private void GetZL_Thread()
{
try
{
myThread_FG = new Thread(new ThreadStart(getZLCurrentLH));
myThread_FG.Priority = ThreadPriority.Normal;
myThread_FG.Start();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
///
/// 取当前转炉正在冶炼熔炼号 CVT01_DEVICE
///
private void getZLCurrentLH()
{
try
{
System.Windows.Forms.Control.CheckForIllegalCrossThreadCalls = false;
while (true)
{
if (!this.On_Off_Thread)
{
System.Threading.Thread.Sleep(500);
continue;
}
this.ute_ZL1.Text = "";
this.ute_ZL2.Text = "";
this.ute_ZL3.Text = "";
//初始化颜色
ute_ZL1.Appearance.BackColor = Color.White;//.Gainsboro;
ute_ZL2.Appearance.BackColor = Color.White;
ute_ZL3.Appearance.BackColor = Color.White;
string strError = "";
ArrayList arry = new ArrayList();
arry.Clear();
arry.Add("getZLCurrentLH.query");
CommonClientToServer ccs = new CommonClientToServer();
ccs.ob = this.ob;
DataSet ds = ccs.ExecuteQueryFunctions("Core.LgMes.Server.Common.ComDBQuery", "doSimpleQuery", arry, out strError);
if (strError == "")
{
if (ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
//初始化颜色
ute_ZL1.Appearance.BackColor = Color.White;
ute_ZL2.Appearance.BackColor = Color.White;
ute_ZL3.Appearance.BackColor = Color.White;
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
string v_ZLH = ds.Tables[0].Rows[i]["objectpos"].ToString().Substring(3, 2);
string v_LH = (ds.Tables[0].Rows[i]["objectid"].ToString().Substring(5, ds.Tables[0].Rows[i]["objectid"].ToString().Length - 5));
if (ds.Tables[0].Rows[i]["objectid"].ToString().Substring(0, 1) == "V") v_LH = "V" + v_LH;
if (v_ZLH == "01")
{
this.ute_ZL1.Text = v_LH;
if (_strSendSucceededForBof1 == "N") ute_ZL1.Appearance.BackColor = Color.White;
if (_strSendSucceededForBof1 == "" || _strSendSucceededForBof1 == "N") HeatNo_HudwId_Exist(v_LH,"01");
if (_strSendSucceededForBof1 == "Y") ute_ZL1.Appearance.BackColor = Color.LightBlue;
}
if (v_ZLH == "02")
{
this.ute_ZL2.Text = v_LH;
if (_strSendSucceededForBof2 == "N") ute_ZL2.Appearance.BackColor = Color.White;
if (_strSendSucceededForBof2 == "" || _strSendSucceededForBof2 == "N") HeatNo_HudwId_Exist(v_LH,"02");
if (_strSendSucceededForBof2 == "Y") ute_ZL2.Appearance.BackColor = Color.LightBlue;
}
if (v_ZLH == "03")
{
this.ute_ZL3.Text = v_LH;
if (_strSendSucceededForBof3 == "N") ute_ZL3.Appearance.BackColor = Color.White;
if (_strSendSucceededForBof3 == "" || _strSendSucceededForBof3 == "N") HeatNo_HudwId_Exist(v_LH,"03");
if (_strSendSucceededForBof3 == "Y") ute_ZL3.Appearance.BackColor = Color.LightBlue;
}
}
}
if (ute_ZL1.Text.Trim().Length == 0) _strSendSucceededForBof1 = "N";
if (ute_ZL2.Text.Trim().Length == 0) _strSendSucceededForBof2 = "N";
if (ute_ZL3.Text.Trim().Length == 0) _strSendSucceededForBof3 = "N";
}
Thread.Sleep(10000);
}
}
catch
{
}
}
private void ute_RLSJ_EditorButtonClick(object sender, Infragistics.Win.UltraWinEditors.EditorButtonEventArgs e)
{
FrmSetTime frm = new FrmSetTime(null);
frm.Location = StaticFunction.GetChildWindowLocation(frm.Size);
frm.AutoSize = true;
if (frm.ShowDialog() == DialogResult.OK)
{ }
if(Convert.ToString(frm._returnTime).Substring(0,8)!="2000-1-1")
ute_RLSJ.Text = Convert.ToDateTime(frm._returnTime).ToString("yyyy-MM-dd HH:mm:ss");
}
///
/// 发送废钢到1#转炉
///
///
///
private void button1_Click(object sender, EventArgs e)
{
try
{
this.ultraGrid1.DisplayLayout.Bands[0].Override.WrapHeaderText = Infragistics.Win.DefaultableBoolean.True;
string v_LH = this.ute_ZL1.Text.Trim().ToString();
if (v_LH.Length == 0)
{
MessageBox.Show("1#转炉没有正在冶炼的熔炼号!\n无法发送废钢!", "提示",MessageBoxButtons.OK,MessageBoxIcon.Asterisk);
return;
}
string v_FGZL = this.ute_RLZL.Text.Trim().ToString();
string v_STZL = this.ute_STZL.Text.Trim().ToString();
string v_ZLH = "01";
string szOut = "";
string v_XH = this.ultNo.Text.Trim();
string[] strParams = new string[7] { v_LH, v_FGZL, v_STZL, v_ZLH, v_XH,"",""};
if (!string.IsNullOrEmpty(v_XH) && !string.IsNullOrEmpty(v_FGZL.Trim()) && !string.IsNullOrEmpty(v_STZL.Trim()) && !string.IsNullOrEmpty(v_LH.Trim()) )
{
CoreClientParam ccp = new CoreClientParam();
ccp.ServerName = "Core.LgMes.Server.DEV.Methods.DEVPublicMethods";
ccp.MethodName = "procedure_A";
ccp.ServerParams = new object[] { "res_lg_lfsmanage.SendFG_ZL ", strParams };
ExecuteNonQuery(ccp, CoreInvokeType.Internal);
szOut = ccp.ReturnInfo;
if (szOut != "")
{
MessageBox.Show(szOut);
}
else
{
GetRLMX_Data();
_strSendSucceededForBof1 = "Y";
MessageBox.Show("废钢发送成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
}
}
else
MessageBox.Show("序号,废钢重量,生铁重量不能为空值!\n 选择的废钢实绩与目标熔炼号不一样!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
///
/// 发送废钢到2#转炉
///
///
///
private void button2_Click(object sender, EventArgs e)
{
try
{
string v_LH = this.ute_ZL2.Text.Trim().ToString();
if (v_LH.Length == 0)
{
MessageBox.Show("2#转炉没有正在冶炼的熔炼号!\n无法发送废钢!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
return;
}
string v_FGZL = this.ute_RLZL.Text.Trim().ToString();
string v_STZL = this.ute_STZL.Text.Trim().ToString();
string v_ZLH = "02";
string szOut = "";
string v_XH = this.ultNo.Text.Trim();
string[] strParams = new string[7] { v_LH, v_FGZL, v_STZL, v_ZLH, v_XH, "", "" };
if (!string.IsNullOrEmpty(v_XH) && !string.IsNullOrEmpty(v_FGZL.Trim()) && !string.IsNullOrEmpty(v_STZL.Trim()) && !string.IsNullOrEmpty(v_LH.Trim()))
{
CoreClientParam ccp = new CoreClientParam();
ccp.ServerName = "Core.LgMes.Server.DEV.Methods.DEVPublicMethods";
ccp.MethodName = "procedure_A";
ccp.ServerParams = new object[] { "res_lg_lfsmanage.SendFG_ZL ", strParams };
ExecuteNonQuery(ccp, CoreInvokeType.Internal);
szOut = ccp.ReturnInfo;
if (szOut != "")
{
MessageBox.Show(szOut);
}
else
{
GetRLMX_Data();
_strSendSucceededForBof2 = "Y";
MessageBox.Show("废钢发送成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
}
}
else
MessageBox.Show("熔炼号,废钢重量,生铁重量不能为空值!\n 选择的废钢实绩与目标熔炼号不一样!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
///
/// 发送废钢到3#转炉
///
///
///
private void button3_Click(object sender, EventArgs e)
{
try
{
string v_LH = this.ute_ZL3.Text.Trim().ToString();
if (v_LH.Length == 0)
{
MessageBox.Show("3#转炉没有正在冶炼的熔炼号!\n无法发送废钢!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
return;
}
string v_FGZL = this.ute_RLZL.Text.Trim().ToString();
string v_STZL = this.ute_STZL.Text.Trim().ToString();
string v_ZLH = "3";
string szOut = "";
string v_XH = this.ultNo.Text.Trim();
if (!string.IsNullOrEmpty(v_XH) && !string.IsNullOrEmpty(v_FGZL.Trim()) && !string.IsNullOrEmpty(v_STZL.Trim()) && !string.IsNullOrEmpty(v_LH.Trim()))
{
//hengxing Core.Mes.ClientFrameWork.ClientCommon._RemotingHelp.ExecuteMethod("lgResMgt", "Core.LgMes.Server.LgResMgt.LfsCollect", "SendZL1_FG", new object[] { v_LH, v_FGZL, v_STZL, v_ZLH, v_XH }, out szOut);
if (szOut != "")
{
MessageBox.Show(szOut);
}
else
{
GetRLMX_Data();
_strSendSucceededForBof3 = "Y";
MessageBox.Show("废钢发送成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
}
}
else
MessageBox.Show("熔炼号,废钢重量,生铁重量不能为空值!\n 选择的废钢实绩与目标熔炼号不一样!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void ute_CLZ_KeyPress(object sender, KeyPressEventArgs e)
{
if (!(Char.IsNumber(e.KeyChar) || e.KeyChar == '.' || e.KeyChar == '\b' || e.KeyChar == '-'))
{
e.Handled = true;
}
}
private void ultraGrid2_InitializeLayout(object sender, Infragistics.Win.UltraWinGrid.InitializeLayoutEventArgs e)
{
}
private void ultraTabControl1_SelectedTabChanged(object sender, Infragistics.Win.UltraWinTabControl.SelectedTabChangedEventArgs e)
{
if (e.Tab.Index == 1)
GetZL_SCJH();
}
private void ultraGrid3_Click(object sender, EventArgs e)
{
DialogResult dgr = new DialogResult();
if (ultraGrid3.ActiveRow != null)
{
ute_LH.Text = ultraGrid3.ActiveRow.Cells["StoveID"].Value.ToString();
utlcbdevNo.SelectedIndex = 1;
string ShiftCode = "", str = "";
if (dgr != DialogResult.Cancel)
{
//ShiftCode = "";//hengxing ((string)ClientCommon._RemotingHelp.ExecuteMethod("lgResMgt", "Core.LgMes.Server.LgResMgt.Iron", "BanCiBanBie", null, out str)).Trim().ToString();
ArrayList arry = new ArrayList();
arry.Add("GetClassCode.query");
CommonClientToServer ccs = new CommonClientToServer();
ccs.ob = this.ob;
//arry.Add("");
DataSet ds = ccs.ExecuteQueryFunctions("Core.LgMes.Server.Common.ComDBQuery", "doSimpleQuery", arry, out str);
if (ds.Tables[0].Rows.Count > 0)
{
ShiftCode = ds.Tables[0].Rows[0]["mes"].ToString(); // +Convert.ToString(cbb_BC.SelectedIndex + 1);
}
if (!string.IsNullOrEmpty(ShiftCode))
{
cbb_BC.SelectedIndex = Convert.ToInt16(ShiftCode.Substring(1, 1)) - 1;
}
}
}
}
private void ultraGrid2_Click(object sender, EventArgs e)
{
DialogResult dgr = new DialogResult();
if (ultraGrid2.ActiveRow != null)
{
ute_LH.Text = ultraGrid2.ActiveRow.Cells["StoveID"].Value.ToString();
utlcbdevNo.SelectedIndex = 0;
string ShiftCode = "", str = "";
if (dgr != DialogResult.Cancel)
{
//ShiftCode = "";//hengxing ((string)ClientCommon._RemotingHelp.ExecuteMethod("lgResMgt", "Core.LgMes.Server.LgResMgt.Iron", "BanCiBanBie", null, out str)).Trim().ToString();
ArrayList arry = new ArrayList();
arry.Add("GetClassCode.query");
CommonClientToServer ccs = new CommonClientToServer();
ccs.ob = this.ob;
//arry.Add("");
DataSet ds = ccs.ExecuteQueryFunctions("Core.LgMes.Server.Common.ComDBQuery", "doSimpleQuery", arry, out str);
if (ds.Tables[0].Rows.Count > 0)
{
ShiftCode = ds.Tables[0].Rows[0]["mes"].ToString(); // +Convert.ToString(cbb_BC.SelectedIndex + 1);
}
if (!string.IsNullOrEmpty(ShiftCode))
{
cbb_BC.SelectedIndex = Convert.ToInt16(ShiftCode.Substring(1, 1)) - 1;
}
}
}
}
private void ultraGrid4_Click(object sender, EventArgs e)
{
DialogResult dgr = new DialogResult();
if (ultraGrid4.ActiveRow != null)
{
ute_LH.Text = ultraGrid4.ActiveRow.Cells["StoveID"].Value.ToString();
utlcbdevNo.SelectedIndex = 2;
string ShiftCode = "", str = "";
if (dgr != DialogResult.Cancel)
{
//ShiftCode = "";//hengxing ((string)ClientCommon._RemotingHelp.ExecuteMethod("lgResMgt", "Core.LgMes.Server.LgResMgt.Iron", "BanCiBanBie", null, out str)).Trim().ToString();
ArrayList arry = new ArrayList();
arry.Add("GetClassCode.query");
CommonClientToServer ccs = new CommonClientToServer();
ccs.ob = this.ob;
//arry.Add("");
DataSet ds = ccs.ExecuteQueryFunctions("Core.LgMes.Server.Common.ComDBQuery", "doSimpleQuery", arry, out str);
if (ds.Tables[0].Rows.Count > 0)
{
ShiftCode = ds.Tables[0].Rows[0]["mes"].ToString(); // +Convert.ToString(cbb_BC.SelectedIndex + 1);
}
if (!string.IsNullOrEmpty(ShiftCode))
{
cbb_BC.SelectedIndex = Convert.ToInt16(ShiftCode.Substring(1, 1)) - 1;
}
}
}
}
private void ute_RLSJ_KeyPress(object sender, KeyPressEventArgs e)
{
if (!(Char.IsNumber(e.KeyChar) || e.KeyChar == '.' || e.KeyChar == '\b'))
{
e.Handled = true;
}
}
private void ute_RLZL_ValueChanged(object sender, EventArgs e)
{
Double dRlzl = 0, dDz = 0, dStzl = 0, dZlz = 0, dHgzl = 0, dZgzl = 0; //入炉重量,斗重,生铁重量,重料重,合格料重,渣钢重量
try
{
//生铁重量
if (!string.IsNullOrEmpty(ute_STZL.Text.Trim()))
dStzl = Convert.ToDouble(ute_STZL.Text.Trim());
//重料重
if (!string.IsNullOrEmpty(ute_CLZ.Text.Trim()))
dZlz = Convert.ToDouble(ute_CLZ.Text.Trim());
//合格料重
if (!string.IsNullOrEmpty(ute_HGLZ.Text.Trim()))
dHgzl = Convert.ToDouble(ute_HGLZ.Text.Trim());
//渣钢重量
if (!string.IsNullOrEmpty(ute_ZGZL.Text.Trim()))
dZgzl = Convert.ToDouble(ute_ZGZL.Text.Trim());
//斗重
if (!string.IsNullOrEmpty(ute_DZ.Text.Trim()))
dDz = Convert.ToDouble(ute_DZ.Text.Trim());
dRlzl = dStzl + dZlz + dHgzl + dZgzl;//入炉重量
ute_RLZL.Text = Convert.ToString(dRlzl); //入炉重量
ute_ZZ.Text = Convert.ToString(dRlzl + dDz);//总重量
}
catch
{
}
}
///
/// 判断是否已经发送废钢
///
/// <熔炼号="strID">
/// <炉座号="strGw">
private void HeatNo_HudwId_Exist(string strID, string strGw)
{
string strErr = "";
try
{
ArrayList arry = new ArrayList();
arry.Add("HeatNo_HudwId_Exist.query");
CommonClientToServer ccs = new CommonClientToServer();
ccs.ob = this.ob;
arry.Add(strID);
arry.Add(strID);
DataSet ds = ccs.ExecuteQueryFunctions("Core.LgMes.Server.Common.ComDBQuery", "doSimpleQuery", arry, out strErr);
if (strErr == "")
{
switch (strGw)
{
case "01":
_strSendSucceededForBof1 = ds.Tables[0].Rows[0]["intCount"].ToString();
break;
case "02":
_strSendSucceededForBof2 = ds.Tables[0].Rows[0]["intCount"].ToString();
break;
case "03":
_strSendSucceededForBof3 = ds.Tables[0].Rows[0]["intCount"].ToString();
break;
default:
break;
}
}
}
catch
{
}
}
}
}