using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.Collections;
using CoreFS.CA06;
using Infragistics.Win.UltraWinGrid;
using System.Threading;
using System.Diagnostics;
using System.IO;
using Core.StlMes.Client.LgCommon;
using Infragistics.Win.UltraWinEditors;
using Infragistics.Win.Misc;
namespace Core.StlMes.Client.LgResMgt
{
public partial class frmScrapSteel : frmStyleBase
{
private System.Threading.Thread myThread_FG;
private ArrayList MaterCode; //物料编码
private ArrayList MaterName; //物料名称
private ArrayList MaterValue; //物料重量
private ArrayList EditorNameList;
private ArrayList EditorValueList;
private string _strSendSucceededForBof1 = "";
private string _strSendSucceededForBof2 = "";
private string _strSendSucceededForBof3 = "";
private string _strSendSucceededForBof4 = "";
private string _strSendSucceededForBof5 = "";
private bool ok_flag = false;
public string workshopNo = "";
public frmScrapSteel()
{
InitializeComponent();
CheckForIllegalCrossThreadCalls = false;
MaterCode = new ArrayList();
MaterName = new ArrayList();
MaterValue = new ArrayList();
EditorNameList = new ArrayList();
EditorValueList = new ArrayList();
}
private void checkBox1_CheckedChanged(object sender, EventArgs e)
{
this.ute_DH.Enabled = checkBox1.Checked;
}
private void frmScrapSteel_Load(object sender, EventArgs e)
{
workshopNo = this.CustomInfo;
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";
ultraTabControl1.Tabs[0].Selected = true;
chkSend.Checked = true;
InitFrm();
GetZL_Thread();
cbb_BC.SelectedIndex = 0;
GetZL_SCJH();
GetConfigMater();
setMaterEnable();
}
// 根据体系显示控件
///
/// 根据体系显示控件
///
private void InitFrm()
{
EditorNameList.Add(materName1);
EditorNameList.Add(materName2);
EditorNameList.Add(materName3);
EditorNameList.Add(materName4);
EditorNameList.Add(materName5);
EditorNameList.Add(materName6);
EditorValueList.Add(materValue1);
EditorValueList.Add(materValue2);
EditorValueList.Add(materValue3);
EditorValueList.Add(materValue4);
EditorValueList.Add(materValue5);
EditorValueList.Add(materValue6);
if (workshopNo == "1")
{
ultraGroupBox2.Text = "1#转炉";
ultraGroupBox3.Text = "2#转炉";
ultraGroupBox4.Visible = false;
splitter2.Visible = false;
label15.Text = "1#转炉";
label16.Text = "2#转炉";
label17.Visible = false;
ute_ZL3.Visible = false;
button3.Visible = false;
utlcbdevNo.Items.Clear();
utlcbdevNo.Items.Add("01","1#转炉");
utlcbdevNo.Items.Add("02","2#转炉");
}
else
{
ultraGroupBox2.Text = "3#转炉";
ultraGroupBox3.Text = "4#转炉";
ultraGroupBox4.Text = "5#转炉";
ultraGroupBox4.Visible = true;
splitter2.Visible = true;
label15.Text = "3#转炉";
label16.Text = "4#转炉";
label17.Text = "5#转炉";
utlcbdevNo.Items.Clear();
utlcbdevNo.Items.Add("03","3#转炉");
utlcbdevNo.Items.Add("04","4#转炉");
utlcbdevNo.Items.Add("05","5#转炉");
}
}
// 获取转炉生产计划记录
///
/// 获取转炉生产计划记录
///
private void GetZL_SCJH()
{
try
{
string szOut = "", strWhere = "";
int RowID_1 = 0, RowID_2 = 0, RowID_3 = 0;
string strStartTime = "";
string strEndTime = "";
this.dataTable2.Rows.Clear();
this.dataTable3.Rows.Clear();
this.dataTable4.Rows.Clear();
if (Convert.ToDateTime(udte_StartTime.Value) > Convert.ToDateTime(udte_EndTime.Value))
{
MessageBox.Show("时间条件的开始时间不能大于结束时间!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
udte_EndTime.Focus();
return;
}
else
{
strStartTime = this.udte_StartTime.DateTime.ToString("yyyy-MM-dd HH:mm:ss");
strEndTime = this.udte_EndTime.DateTime.ToString("yyyy-MM-dd HH:mm:ss");
}
strWhere = " and PLAN_MAKING_TIME between to_date('" + strStartTime + "','yyyy-MM-dd HH24:mi:ss') and to_date('" + strEndTime + "','yyyy-MM-dd HH24:mi:ss') ";
//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.ExecuteSortResultByQueryToDataTable(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 (workshopNo == "1") //1体系 1,2转炉
{
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;
}
}
else //2体系 3,4,5转炉
{
if (ds.Tables[0].Rows[i]["routeline"].ToString().Substring(5, 1) == "3")
{
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) == "4")
{
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) == "5")
{
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;
}
}
}
}
}
PublicMethod.RefreshAndAutoSize(ultraGrid2);
PublicMethod.RefreshAndAutoSize(ultraGrid3);
PublicMethod.RefreshAndAutoSize(ultraGrid4);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
// 获得已经配置的物料
///
/// 获得已经配置的物料
///
public void GetConfigMater()
{
try
{
string strErr = "";
ArrayList arry = new ArrayList();
arry.Add("ScrapSteel.Config");
arry.Add(workshopNo);
CommonClientToServer ccs = new CommonClientToServer();
ccs.ob = this.ob;
DataSet ds = ccs.ExecuteQueryFunctions("Core.LgMes.Server.Common.ComDBQuery", "doSimpleQuery", arry, out strErr);
if (ds != null && ds.Tables[0].Rows.Count > 0)
{
string matercode = "";
string matername = "";
int m = 0;
int count=ds.Tables[0].Rows.Count;
for (int i = 0; i < count; i++)
{
matercode = ds.Tables[0].Rows[i]["SCRAPSTEELCODE"].ToString();
matername = ds.Tables[0].Rows[i]["SCRAPSTEELNAME"].ToString();
try
{
((UltraLabel)EditorNameList[i]).Tag = matercode;
((UltraLabel)EditorNameList[i]).Text = matername;
m++;
}
catch { }
}
for (int j = m; j < EditorNameList.Count; j++)
{
((UltraLabel)EditorNameList[j]).Text = "";
}
for (int n = 0; n < EditorValueList.Count; n++)
{
((UltraTextEditor)EditorValueList[n]).Text = "";
}
}
setMaterEnable();
}
catch { }
}
// 取入炉明细数据主表
///
/// 取入炉明细数据主表
///
private void GetRLMX_Data()
{
try
{
this.ultraDataSource1.Rows.Clear();
this.dataTable1.Rows.Clear();
DataSet SetMain = new DataSet();
string szOut = "", strWhere = "";
string strStartTime = "";
string strEndTime = "";
if (Convert.ToDateTime(udte_StartTime.Value) > Convert.ToDateTime(udte_EndTime.Value))
{
MessageBox.Show("时间条件的开始时间不能大于结束时间!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
udte_EndTime.Focus();
return;
}
else
{
strStartTime = this.udte_StartTime.DateTime.ToString("yyyy-MM-dd HH:mm:ss");
strEndTime = this.udte_EndTime.DateTime.ToString("yyyy-MM-dd HH:mm:ss");
}
strWhere = " where JOBDATE between to_date('" + strStartTime + "','yyyy-MM-dd HH24:mi:ss') and to_date('" + strEndTime + "','yyyy-MM-dd HH24:mi:ss') and WORKSHOPNO='" + workshopNo + "' ";
// 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)
{
strWhere += " and CHARGENO = '" + ute_DH.Text.ToString().Trim() + "' ";
}
if (this.chkSend.Checked)
{
strWhere += " and (heatno is null or stationcode is null) ";
}
//获取主表信息
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.ExecuteSortResultByQueryToDataTable(CCP_LgEts, CoreInvokeType.Internal);
SetMain.Tables.Clear();
SetMain.Tables.Add(dt.Copy());
SetMain.Tables[0].TableName = "Main";
DataSet ds = new DataSet();
ds.Tables.Add(dt.Copy());
szOut = CCP_LgEts.ReturnInfo;
if (szOut != "" || ds.Tables[0].Rows.Count == 0)
{
ultraGrid1.DataSource = this.ultraDataSource1;
return;
}
//获取从表信息
strWhere = " where FEEDINGTIME between to_date('" + strStartTime + "','yyyy-MM-dd HH24:mi:ss') and to_date('" + strEndTime + "','yyyy-MM-dd HH24:mi:ss') and WORKSHOPNO='" + workshopNo + "' ";
if (this.chkSend.Checked)
{
strWhere += " and ISSEND ='0'";
}
ArrayList arry1 = new ArrayList();
ArrayList sqlList1 = new ArrayList();
arry1.Add("ScrapSteelMaterAdd.Query");
sqlList1.Add(strWhere);
CoreClientParam ccp = new CoreClientParam();
DataTable dt1 = new DataTable();
ccp.ServerName = "Core.LgMes.Server.Common.ComDBQuery";
ccp.MethodName = "doQuery";
ccp.ServerParams = new object[] { arry1, sqlList1 };
ccp.SourceDataTable = dt1;
this.ExecuteSortResultByQueryToDataTable(ccp, CoreInvokeType.Internal);
DataSet ds1 = new DataSet();
dt1.TableName = "Child";
ds1.Tables.Add(dt1.Copy());
szOut = CCP_LgEts.ReturnInfo;
if (szOut != "" || ds1.Tables[0].Rows.Count == 0)
{
ultraGrid1.DataSource = this.ultraDataSource1;
return;
}
SetMain.Tables.Add(ds1.Tables[0].Copy());
SetMain.Relations.Clear();
SetMain.Relations.Add("Band 1", SetMain.Tables["Main"].Columns["JOBID"], SetMain.Tables["Child"].Columns["JOBID"]);
this.ultraGrid1.DataSource = SetMain;
foreach (UltraGridRow row in ultraGrid1.Rows)
{
if (row.Cells["HEATNO"].Value.ToString().Trim() == "" && row.Cells["STATIONCODE"].Value.ToString().Trim() == "")
{
row.Appearance.BackColor = Color.LightCyan;//未发送状态
}
else if (row.Cells["HEATNO"].Value.ToString().Trim() != "" && row.Cells["STATIONCODE"].Value.ToString().Trim() != "")
{
row.Appearance.BackColor = Color.LightGreen;//发送状态
}
else
{
row.Appearance.BackColor = Color.White;//未知状态
}
}
SetSteelSum();
PublicMethod.RefreshAndAutoSize(ultraGrid1);
}
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[5]);
summary.SummaryPosition = SummaryPosition.UseSummaryPositionColumn;
summary.DisplayFormat = "合计:";
for (int i = 6; i < 10; 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;
}
// 新增记录
///
/// 新增记录
///
private void AddNewData()
{
try
{
if (ute_DH2.Text.Trim().Length == 0)
{
MessageBox.Show("料斗号不能为空,请输入料斗号!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
ute_DH2.Focus();
return;
}
if (ute_ZZ.Text.Trim().Length == 0)
{
MessageBox.Show("废钢总量不能为空,请输入!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
return;
}
if (ute_ZZ.Text.Trim() == "0")
{
MessageBox.Show("废钢总量不能为零,请输入!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
return;
}
//查询当前班次
string strErr = "";
string m_szCurrClass = "";
ArrayList arry = new ArrayList();
arry.Add("GetClassCode.query"); // 位于 QueryLgIntegration.xml 中
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();
}
GetAllMater();
if (MaterCode.Count==0)
{
MessageBox.Show("没有物料信息!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
return;
}
strErr = "";
string strSqlID = "frmScrapMater.Add";
object[] sArgs = new object[12];
sArgs[0] = MaterCode; //物料编码
sArgs[1] = MaterName; //物料名称
sArgs[2] = MaterValue; //物料重量
sArgs[3] = ute_DH2.Text.Trim(); //料斗号
sArgs[4] = (ute_RLSJ.Text.ToString() == ""?DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"):
(Convert.ToDateTime(ute_RLSJ.Text.Trim())).ToString("yyyy-MM-dd HH:mm:ss")); //入炉时间
sArgs[5] = ute_RLZL.Text.Trim() == "" ? "0" : ute_RLZL.Text.Trim(); //入炉重量
sArgs[6] = ute_DZ.Text.Trim() == "" ? "0" : ute_DZ.Text.Trim(); // 料斗重
sArgs[7] = ute_ZZ.Text.Trim() == "" ? "0" : ute_ZZ.Text.Trim(); //总重
sArgs[8] = this.UserInfo.GetUserName(); //操作人
sArgs[9] = m_szCurrClass.Substring(0,1) + cbb_BC.Value.ToString().Trim(); //班次班组
sArgs[10] = ute_BZ.Text.Trim(); //备注
sArgs[11] = workshopNo;
try
{
CommonClientToServer ccTs = new CommonClientToServer();
ccTs.ob = ob;
string strRCode = ccTs.ExecuteProcedureFunctions("Core.LgMes.Server.Common.ComDBProcedure",
"ExecProcWithCollParam", strSqlID, sArgs, out strErr);
if (strErr != "")
{
ok_flag = false;
MessageBox.Show("新增失败!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
else
{
ok_flag = true;
MessageBox.Show(" 废钢新增成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
}
}
catch { }
}
catch { }
}
// 获取物料值
///
/// 获取物料值
///
private void GetAllMater()
{
try
{
MaterCode.Clear();
MaterName.Clear();
MaterValue.Clear();
GetAllMaterFun(materName1, materValue1);
GetAllMaterFun(materName2, materValue2);
GetAllMaterFun(materName3, materValue3);
GetAllMaterFun(materName4, materValue4);
GetAllMaterFun(materName5, materValue5);
GetAllMaterFun(materName6, materValue6);
}
catch { }
}
private void GetAllMaterFun(UltraLabel editor1,UltraTextEditor editor2)
{
try
{
if (editor1.Text.Trim() != "")
{
MaterCode.Add(editor1.Tag.ToString());
MaterName.Add(editor1.Text.Trim());
MaterValue.Add(editor2.Text.Trim() == "" ? "0" : editor2.Text.Trim());
}
}
catch { }
}
// 删除记录
///
/// 删除记录
///
private void DeleteDataRow()
{
try
{
if (ultraGrid1.Rows.Count == 0 || ultraGrid1.ActiveRow == null)
{
MessageBox.Show("没有有效的废钢信息可删除!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
return;
}
if (ultraGrid1.ActiveRow.Appearance.BackColor == Color.LightGreen || ute_LH.Text.Trim() != "")
{
MessageBox.Show("选取的废钢信息已发送不能删除!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
return;
}
string strXH = ultNo.Text.Trim();
if (strXH == "") return;
DialogResult dr = MessageBox.Show("是否确认删除废钢信息?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Information);
if (dr == DialogResult.No) return;
string strErr = "";
string strSqlID = "frmScrapMater.Delete";
object[] sArgs = new object[1];
sArgs[0] = strXH; //序号
try
{
CommonClientToServer ccTs = new CommonClientToServer();
ccTs.ob = ob;
string strRCode = ccTs.ExecuteProcedureFunctions("Core.LgMes.Server.Common.ComDBProcedure",
"ExecProcWithCollParam", strSqlID, sArgs, out strErr);
if (strErr != "")
{
MessageBox.Show("删除失败!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
}
else
{
MessageBox.Show("删除成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
GetRLMX_Data();
}
}
catch { }
}
catch { }
}
// 清除编辑区内容
///
/// 清除编辑区内容
///
private void ClearData()
{
ute_DH2.Text = "";
materValue1.Text = "";
materValue2.Text = "";
materValue3.Text = "";
materValue4.Text = "";
materValue5.Text = "";
materValue6.Text = "";
utlcbdevNo.SelectedIndex = -1;
ute_RLZL.Text = "";
ute_LH.Text = "";
ute_ZZ.Text = "";
cbb_BC.SelectedIndex=0;
ute_DZ.Text = "";
ute_RLSJ.Text = "";
ute_BZ.Text = "";
}
// 清除编辑区内容
///
/// 清除编辑区内容
///
private void ClearData1()
{
ute_DH2.Text = "";
materValue1.Text = "";
materValue2.Text = "";
materValue3.Text = "";
materValue4.Text = "";
materValue5.Text = "";
materValue6.Text = "";
ute_RLZL.Text = "";
ute_LH.Text = "";
ute_ZZ.Text = "";
cbb_BC.SelectedIndex = 0;
ute_DZ.Text = "";
ute_RLSJ.Text = "";
ute_BZ.Text = "";
}
// 修改记录
///
/// 修改记录
///
///
private void UpdateDataRow(string strXH)
{
try
{
if (ute_DH2.Text.Trim().Length == 0)
{
MessageBox.Show("料斗号不能为空,请输入料斗号!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
ute_DH2.Focus();
return;
}
if (ute_ZZ.Text.Trim().Length == 0)
{
MessageBox.Show("废钢总量不能为空,请输入!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
return;
}
if (ute_ZZ.Text.Trim() == "0")
{
MessageBox.Show("废钢总量不能为零,请输入!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
return;
}
//查询当前班次
string strErr = "";
string m_szCurrClass = "";
ArrayList arry = new ArrayList();
arry.Add("GetClassCode.query"); // 位于 QueryLgIntegration.xml 中
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();
}
GetAllMater();
if (MaterCode.Count == 0)
{
MessageBox.Show("没有物料信息!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
return;
}
strErr = "";
string strSqlID = "frmScrapMater.Update";
object[] sArgs = new object[13];
sArgs[0] = MaterCode; //物料编码
sArgs[1] = MaterName; //物料名称
sArgs[2] = MaterValue; //物料重量
sArgs[3] = ultNo.Text.Trim(); //序号
sArgs[4] = ute_DH2.Text.Trim(); //料斗号
sArgs[5] = (ute_RLSJ.Text.ToString() == "" ? DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") :
(Convert.ToDateTime(ute_RLSJ.Text.Trim())).ToString("yyyy-MM-dd HH:mm:ss")); //入炉时间
sArgs[6] = ute_RLZL.Text.Trim() == "" ? "0" : ute_RLZL.Text.Trim(); //入炉重量
sArgs[7] = ute_DZ.Text.Trim() == "" ? "0" : ute_DZ.Text.Trim(); // 料斗重
sArgs[8] = ute_ZZ.Text.Trim() == "" ? "0" : ute_ZZ.Text.Trim(); //总重
sArgs[9] = this.UserInfo.GetUserName(); //操作人
sArgs[10] = m_szCurrClass.Substring(0, 1) + cbb_BC.Value.ToString().Trim(); //班次班组
sArgs[11] = ute_BZ.Text.Trim(); //备注
sArgs[12] = workshopNo;
try
{
CommonClientToServer ccTs = new CommonClientToServer();
ccTs.ob = ob;
string strRCode = ccTs.ExecuteProcedureFunctions("Core.LgMes.Server.Common.ComDBProcedure",
"ExecProcWithCollParam", strSqlID, sArgs, out strErr);
if (strErr != "")
{
ok_flag = false;
MessageBox.Show("修改失败!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
else
{
ok_flag = true;
MessageBox.Show(" 修改成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
}
}
catch { }
}
catch { }
}
// 取消发送
///
/// 取消发送
///
private void CancelSend()
{
try
{
string strXH = ultNo.Text.Trim();
string strLH = ute_LH.Text.Trim();
string strStation = "01";
try
{
strStation = "0" + utlcbdevNo.Text.Trim().Substring(0, 1);
}
catch { }
if (strLH == "")
{
MessageBox.Show("你选择的废钢信息还未发送!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
return;
}
if (strLH != ute_ZL1.Text.Trim() && strLH != ute_ZL2.Text.Trim() && strLH != ute_ZL3.Text.Trim())
{
MessageBox.Show("该炉次号不在转炉工序,不能取消!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
return;
}
DialogResult dr = MessageBox.Show("确定取消已经发送的废钢信息?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Information);
if (dr == DialogResult.No) return;
String strErr = "";
string strSqlID = "frmScrapMater.Cancel";
object[] sArgs = new object[2];
sArgs[0] = strLH; //炉号
sArgs[1] = strXH; //序号
CommonClientToServer ccTs = new CommonClientToServer();
ccTs.ob = ob;
string strRCode = ccTs.ExecuteProcedureFunctions("Core.LgMes.Server.Common.ComDBProcedure",
"ExecProcWithCollParam", strSqlID, sArgs, out strErr);
if (strErr != "")
{
MessageBox.Show("废钢信息取消发送失败!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
}
else
{
MessageBox.Show("废钢信息取消发送成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
GetRLMX_Data();
HeatNo_HudwId_Exist(strLH, strStation);
}
}
catch { }
}
//实时刷新当前转炉正在冶炼的熔炼号
///
///实时刷新当前转炉正在冶炼的熔炼号
///
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);
}
}
// 取当前转炉正在冶炼熔炼号 C##01_DEVICE
///
/// 取当前转炉正在冶炼熔炼号 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 (workshopNo == "1")
{
if (v_ZLH == "01")
{
this.ute_ZL1.Text = v_LH;
HeatNo_HudwId_Exist(v_LH, "01");
}
if (v_ZLH == "02")
{
this.ute_ZL2.Text = v_LH;
HeatNo_HudwId_Exist(v_LH, "02");
}
}
else
{
if (v_ZLH == "03")
{
this.ute_ZL1.Text = v_LH;
HeatNo_HudwId_Exist(v_LH, "03");
}
if (v_ZLH == "04")
{
this.ute_ZL2.Text = v_LH;
HeatNo_HudwId_Exist(v_LH, "04");
}
if (v_ZLH == "05")
{
this.ute_ZL3.Text = v_LH;
HeatNo_HudwId_Exist(v_LH, "05");
}
}
}
}
}
Thread.Sleep(10000);
}
}
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()=="0"?"N":"Y";
if (_strSendSucceededForBof1 == "N") ute_ZL1.Appearance.BackColor = Color.White;
if (_strSendSucceededForBof1 == "Y") ute_ZL1.Appearance.BackColor = Color.LightBlue;
break;
case "02":
_strSendSucceededForBof2 = ds.Tables[0].Rows[0]["intCount"].ToString() == "0" ? "N" : "Y";
if (_strSendSucceededForBof2 == "N") ute_ZL2.Appearance.BackColor = Color.White;
if (_strSendSucceededForBof2 == "Y") ute_ZL2.Appearance.BackColor = Color.LightBlue;
break;
case "03":
_strSendSucceededForBof3 = ds.Tables[0].Rows[0]["intCount"].ToString() == "0" ? "N" : "Y";
if (_strSendSucceededForBof3 == "N") ute_ZL1.Appearance.BackColor = Color.White;
if (_strSendSucceededForBof3 == "Y") ute_ZL1.Appearance.BackColor = Color.LightBlue;
break;
case "04":
_strSendSucceededForBof4 = ds.Tables[0].Rows[0]["intCount"].ToString() == "0" ? "N" : "Y";
if (_strSendSucceededForBof4 == "N") ute_ZL2.Appearance.BackColor = Color.White;
if (_strSendSucceededForBof4 == "Y") ute_ZL2.Appearance.BackColor = Color.LightBlue;
break;
case "05":
_strSendSucceededForBof5 = ds.Tables[0].Rows[0]["intCount"].ToString() == "0" ? "N" : "Y";
if (_strSendSucceededForBof5 == "N") ute_ZL3.Appearance.BackColor = Color.White;
if (_strSendSucceededForBof5 == "Y") ute_ZL3.Appearance.BackColor = Color.LightBlue;
break;
default:
break;
}
}
}
catch
{
}
}
// 点击修改或删除时显示确认和取消按钮
///
/// 点击修改或删除时显示确认和取消按钮
///
///
private void SetDetailToolBarEnable(bool bEnable,string flag)
{
int count = this.ultraToolbarsManager1.Tools.Count;
for (int i = 0; i < count; i++)
{
this.ultraToolbarsManager1.Tools[i].SharedProps.Enabled = !bEnable;
}
if (bEnable == true && flag == "add")
{
this.ultraToolbarsManager1.Tools["Custom"].SharedProps.Visible = true;
this.ultraToolbarsManager1.Tools["Custom"].SharedProps.Enabled = true;
}
else
{
this.ultraToolbarsManager1.Tools["Custom"].SharedProps.Visible = false;
this.ultraToolbarsManager1.Tools["Custom"].SharedProps.Enabled = false;
}
this.ultraToolbarsManager1.Tools["ok"].SharedProps.Enabled = bEnable;
this.ultraToolbarsManager1.Tools["cancel"].SharedProps.Enabled = bEnable;
this.ultraToolbarsManager1.Tools["ok"].SharedProps.Visible = bEnable;
this.ultraToolbarsManager1.Tools["cancel"].SharedProps.Visible = bEnable;
}
// 设置物料区域是否可编辑
///
/// 设置物料区域是否可编辑
///
///
private void setMaterEnable()
{
try
{
setMaterEnableFun(materName1, materValue1);
setMaterEnableFun(materName2, materValue2);
setMaterEnableFun(materName3, materValue3);
setMaterEnableFun(materName4, materValue4);
setMaterEnableFun(materName5, materValue5);
setMaterEnableFun(materName6, materValue6);
}
catch { }
}
private void setMaterEnableFun(UltraLabel editro1, UltraTextEditor editro2)
{
try
{
if (editro1.Text.Trim() == "")
{
editro1.Enabled = false;
editro2.Enabled = false;
}
else
{
editro1.Enabled = true;
editro2.Enabled = true;
}
}
catch { }
}
// 设置编辑区域是否可编辑
///
/// 设置编辑区域是否可编辑
///
///
private void setToolEnable(bool t_Enable)
{
try
{
ute_DH2.ReadOnly = t_Enable;
materValue1.ReadOnly = t_Enable;
materValue2.ReadOnly = t_Enable;
materValue3.ReadOnly = t_Enable;
materValue4.ReadOnly = t_Enable;
materValue5.ReadOnly = t_Enable;
materValue6.ReadOnly = t_Enable;
ute_RLZL.ReadOnly = t_Enable;
cbb_BC.ReadOnly = t_Enable;
ute_DZ.ReadOnly = t_Enable;
ute_RLSJ.ReadOnly = t_Enable;
ute_BZ.ReadOnly = t_Enable;
}
catch { }
}
// 系统菜单栏
///
/// 系统菜单栏
///
///
///
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();
GetRLMX_Data();
}
}
else
{
MessageBox.Show("请选择要删除的行!", "提示");
}
break;
case "Query":// 查询
if (ultraTabControl1.SelectedTab.Key == "Plan")
{
GetZL_SCJH();
}
else
{
GetRLMX_Data();
}
break;
case "Config":
try
{
frmSteelConfiger config = new frmSteelConfiger(ob);
config.Tag = this;
config.WorkShopNo = workshopNo;
config.ShowDialog();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
break;
case "Export"://导出Excel
try
{
Core.Mes.Client.Comm.Globals.ulGridToExcel(ultraGrid1, Text);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
break;
case "Cancel"://取消发送
try
{
CancelSend();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
break;
case "Exit":
this.Close();
break;
default:
break;
}
}
private void ultraGrid1_AfterRowActivate(object sender, EventArgs e)
{
try
{
if (this.ultraGrid1.Rows.Count == 0 || this.ultraGrid1.ActiveRow == null)
{
return;
}
UltraGridRow row = null;
if (ultraGrid1.ActiveRow.HasParent())
{
row = ultraGrid1.ActiveRow.ParentRow;
}
else
{
row = ultraGrid1.ActiveRow;
}
SetDetailToolBarEnable(false,"");
setToolEnable(true);
ClearData();
ultNo.Text = row.Cells["JOBID"].Value.ToString();
ute_LH.Text = row.Cells["HEATNO"].Value.ToString();
utlcbdevNo.Text = row.Cells["STATIONCODE"].Value.ToString();
ute_DH2.Text = row.Cells["CHARGENO"].Value.ToString();
ute_RLSJ.Text = row.Cells["JOBDATE"].Value.ToString();
ute_RLZL.Text = row.Cells["JOINSTOVEWGT"].Value.ToString();
ute_DZ.Text = row.Cells["CHUTEWGT"].Value.ToString();
ute_ZZ.Text = row.Cells["TOTALWGT"].Value.ToString();
ute_BZ.Text = row.Cells["MEMO"].Value.ToString();
cbb_BC.Text = row.Cells["SHIFTCODE"].Value.ToString();
if (row.HasChild())
{
string matercode = "";
string matername = "";
string matervalue = "";
int m=0;
for (int i = 0; i < row.ChildBands["Band 1"].Rows.Count; i++)
{
matercode = row.ChildBands["Band 1"].Rows[i].Cells["SCRAPSTEELCODE"].Value.ToString();
matername = row.ChildBands["Band 1"].Rows[i].Cells["SCRAPSTEELNAME"].Value.ToString();
matervalue = row.ChildBands["Band 1"].Rows[i].Cells["JMWGT"].Value.ToString();
try
{
((UltraLabel)EditorNameList[i]).Tag = matercode;
((UltraLabel)EditorNameList[i]).Text = matername;
((UltraTextEditor)EditorValueList[i]).Text = matervalue;
m++;
}
catch { }
}
for (int j = m; j < EditorNameList.Count; j++)
{
((UltraLabel)EditorNameList[j]).Text="";
}
setMaterEnable();
}
}
catch { }
}
private void ute_RLSJ_EditorButtonClick(object sender, Infragistics.Win.UltraWinEditors.EditorButtonEventArgs e)
{
try
{
frmSetTime frm = new frmSetTime(e.Context);
//frm.Location = ClsControlPack.GetChildWindowLocation(frm.Size);
frm.Location = new Point(556,376);//ClsControlPack.GetChildWindowLocation(frm.Size);
frm.AutoSize = true;
if (frm.ShowDialog() == DialogResult.OK)
{
ute_RLSJ.Text = (Convert.ToDateTime(frm.SelectDate.ToString())).ToString("yyyy-MM-dd HH:mm:ss");
ute_RLSJ.Update();
}
}
catch{}
}
// 发送废钢到1#或3#转炉
///
/// 发送废钢到1#或3#转炉
///
///
///
private void button1_Click(object sender, EventArgs e)
{
try
{
string v_LH = this.ute_ZL1.Text.Trim().ToString();
if (v_LH.Length == 0)
{
if (workshopNo == "1")
{
MessageBox.Show("1#转炉没有正在冶炼的熔炼号!\n无法发送废钢!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
}
else
{
MessageBox.Show("3#转炉没有正在冶炼的熔炼号!\n无法发送废钢!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
}
return;
}
if (ultraGrid1.Rows.Count == 0 || ultraGrid1.ActiveRow == null)
{
MessageBox.Show("没有有效的废钢信息可发送!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
return;
}
if (ultraGrid1.ActiveRow.Appearance.BackColor == Color.LightGreen)
{
MessageBox.Show("选取的废钢信息已发送,不能重复发送\n如需重新发送,请先取消发送!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
return;
}
if (ute_ZL1.Appearance.BackColor == Color.LightBlue)
{
DialogResult dr = MessageBox.Show("当前炉号已发送过废钢信息,是否替换原来已经发送的废钢信息?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Information);
if (dr == DialogResult.No) return;
}
this.ultraGrid1.DisplayLayout.Bands[0].Override.WrapHeaderText = Infragistics.Win.DefaultableBoolean.True;
string v_XH = this.ultNo.Text.Trim();
string v_RLZL = ute_RLZL.Text.Trim();
string v_ZLH = "";
if (workshopNo == "1")
{
v_ZLH = "01";
}
else
{
v_ZLH = "03";
}
if (v_RLZL == "0" || v_RLZL == "")
{
MessageBox.Show("废钢总重为零,发送无意义!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
return;
}
if (v_XH == "")
{
MessageBox.Show("序号不能为空!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
return;
}
string strErr = "";
string strSqlID = "frmScrapMater.Send";
object[] sArgs = new object[3];
sArgs[0] = v_LH; //炉号
sArgs[1] = v_ZLH; //炉座号
sArgs[2] = v_XH; //序号
CommonClientToServer ccTs = new CommonClientToServer();
ccTs.ob = ob;
string strRCode = ccTs.ExecuteProcedureFunctions("Core.LgMes.Server.Common.ComDBProcedure",
"ExecProcWithCollParam", strSqlID, sArgs, out strErr);
if (strErr != "")
{
MessageBox.Show("废钢发送失败!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
return;
}
else
{
GetRLMX_Data();
if (workshopNo == "1")
{
_strSendSucceededForBof1 = "Y";
HeatNo_HudwId_Exist(v_LH, "01");
}
else
{
_strSendSucceededForBof3 = "Y";
HeatNo_HudwId_Exist(v_LH, "03");
}
MessageBox.Show("废钢发送成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
}
}
catch { }
}
// 发送废钢到2#或4#转炉
///
/// 发送废钢到2#或4#转炉
///
///
///
private void button2_Click(object sender, EventArgs e)
{
try
{
string v_LH = this.ute_ZL2.Text.Trim().ToString();
if (v_LH.Length == 0)
{
if (workshopNo == "1")
{
MessageBox.Show("2#转炉没有正在冶炼的熔炼号!\n无法发送废钢!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
}
else
{
MessageBox.Show("4#转炉没有正在冶炼的熔炼号!\n无法发送废钢!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
}
return;
}
if (ultraGrid1.Rows.Count == 0 || ultraGrid1.ActiveRow == null)
{
MessageBox.Show("没有有效的废钢信息可发送!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
return;
}
if (ultraGrid1.ActiveRow.Appearance.BackColor == Color.LightGreen)
{
MessageBox.Show("选取的废钢信息已发送,不能重复发送\n如需重新发送,请先取消发送!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
return;
}
if (ute_ZL2.Appearance.BackColor == Color.LightBlue)
{
DialogResult dr = MessageBox.Show("当前炉号已发送过废钢信息,是否替换原来已经发送的废钢信息?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Information);
if (dr == DialogResult.No) return;
}
string v_XH = this.ultNo.Text.Trim();
string v_RLZL = ute_RLZL.Text.Trim();
string v_ZLH = "";
if (workshopNo == "1")
{
v_ZLH = "02";
}
else
{
v_ZLH = "04";
}
if (v_RLZL == "0" || v_RLZL == "")
{
MessageBox.Show("废钢总重为零,发送无意义!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
return;
}
if (v_XH == "")
{
MessageBox.Show("序号不能为空!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
return;
}
string strErr = "";
string strSqlID = "frmScrapMater.Send";
object[] sArgs = new object[3];
sArgs[0] = v_LH; //炉号
sArgs[1] = v_ZLH; //炉座号
sArgs[2] = v_XH; //序号
CommonClientToServer ccTs = new CommonClientToServer();
ccTs.ob = ob;
string strRCode = ccTs.ExecuteProcedureFunctions("Core.LgMes.Server.Common.ComDBProcedure",
"ExecProcWithCollParam", strSqlID, sArgs, out strErr);
if (strErr != "")
{
MessageBox.Show("废钢发送失败!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
return;
}
else
{
GetRLMX_Data();
if (workshopNo == "1")
{
_strSendSucceededForBof2 = "Y";
HeatNo_HudwId_Exist(v_LH, "02");
}
else
{
_strSendSucceededForBof4 = "Y";
HeatNo_HudwId_Exist(v_LH, "04");
}
MessageBox.Show("废钢发送成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
}
}
catch { }
}
// 发送废钢到5#转炉
///
/// 发送废钢到5#转炉
///
///
///
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("5#转炉没有正在冶炼的熔炼号!\n无法发送废钢!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
return;
}
if (ultraGrid1.Rows.Count == 0 || ultraGrid1.ActiveRow == null)
{
MessageBox.Show("没有有效的废钢信息可发送!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
return;
}
if (ultraGrid1.ActiveRow.Appearance.BackColor == Color.LightGreen)
{
MessageBox.Show("选取的废钢信息已发送,不能重复发送\n如需重新发送,请先取消发送!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
return;
}
if (ute_ZL3.Appearance.BackColor == Color.LightBlue)
{
DialogResult dr = MessageBox.Show("当前炉号已发送过废钢信息,是否替换原来已经发送的废钢信息?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Information);
if (dr == DialogResult.No) return;
}
string v_XH = this.ultNo.Text.Trim();
string v_RLZL = ute_RLZL.Text.Trim();
string v_ZLH = "05";
if (v_RLZL == "0" || v_RLZL == "")
{
MessageBox.Show("废钢总重为零,发送无意义!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
return;
}
if (v_XH == "")
{
MessageBox.Show("序号不能为空!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
return;
}
string strErr = "";
string strSqlID = "frmScrapMater.Send";
object[] sArgs = new object[3];
sArgs[0] = v_LH; //炉号
sArgs[1] = v_ZLH; //炉座号
sArgs[2] = v_XH; //序号
CommonClientToServer ccTs = new CommonClientToServer();
ccTs.ob = ob;
string strRCode = ccTs.ExecuteProcedureFunctions("Core.LgMes.Server.Common.ComDBProcedure",
"ExecProcWithCollParam", strSqlID, sArgs, out strErr);
if (strErr != "")
{
MessageBox.Show("废钢发送失败!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
return;
}
else
{
GetRLMX_Data();
_strSendSucceededForBof5 = "Y";
HeatNo_HudwId_Exist(v_LH, "05");
MessageBox.Show("废钢发送成功!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
}
}
catch { }
}
// 选择生产计划隐藏相应功能
///
/// 选择生产计划隐藏相应功能
///
///
///
private void ultraTabControl1_SelectedTabChanged(object sender, Infragistics.Win.UltraWinTabControl.SelectedTabChangedEventArgs e)
{
if (e.Tab.Index == 1)
GetZL_SCJH();
if (ultraTabControl1.SelectedTab.Key == "Plan")
{
ultraToolbarsManager1.Enabled = false;
this.ToolBarItemEnable(this, "Cancel", false);
this.ToolBarItemEnable(this, "Export", false);
label28.Text = "计划开始时间";
label2.Text = "计划结束时间";
groupBox6.Size=new System.Drawing.Size(228, 40);
label1.Text = "生产状态";
label1.BackColor = Color.LightGreen;
label18.Text = "计划状态";
label18.BackColor = Color.White;
label3.Text = "结束状态";
label3.Visible = true;
checkBox1.Enabled = false;
chkSend.Enabled = false;
udte_EndTime.Location = new Point(317, 11);
if (Convert.ToDateTime(udte_StartTime.Value) > Convert.ToDateTime(udte_EndTime.Value))
{
//MessageBox.Show("时间条件的开始时间不能大于结束时间!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
udte_EndTime.Focus();
return;
}
GetZL_SCJH();
}
else
{
ultraToolbarsManager1.Enabled = true;
this.ToolBarItemEnable(this, "Cancel", true);
this.ToolBarItemEnable(this, "Export", true);
label28.Text = "入炉时间 从";
label2.Text = "到";
groupBox6.Size = new System.Drawing.Size(163, 40);
label18.Text = "已发送";
label18.BackColor = Color.LightGreen;
label1.Text = "未发送";
label1.BackColor = Color.LightCyan;
label3.Visible = false;
chkSend.Enabled = true;
checkBox1.Enabled = true;
udte_EndTime.Location = new Point(265, 11);
if (Convert.ToDateTime(udte_StartTime.Value) > Convert.ToDateTime(udte_EndTime.Value))
{
// MessageBox.Show("时间条件的开始时间不能大于结束时间!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
udte_EndTime.Focus();
return;
}
GetRLMX_Data();
}
}
private void ultraGrid3_Click(object sender, EventArgs e)
{
}
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_ZZ_ValueChanged(object sender, EventArgs e)
{
Double dRlzl = 0, dDz = 0, dFg = 0; //入炉重量,斗重, 废钢重量
try
{
//废钢重量
if (!string.IsNullOrEmpty(materValue1.Text.Trim()))
{
dFg += Convert.ToDouble(materValue1.Text.Trim());
}
if (!string.IsNullOrEmpty(materValue2.Text.Trim()))
{
dFg += Convert.ToDouble(materValue2.Text.Trim());
}
if (!string.IsNullOrEmpty(materValue3.Text.Trim()))
{
dFg += Convert.ToDouble(materValue3.Text.Trim());
}
if (!string.IsNullOrEmpty(materValue4.Text.Trim()))
{
dFg += Convert.ToDouble(materValue4.Text.Trim());
}
if (!string.IsNullOrEmpty(materValue5.Text.Trim()))
{
dFg += Convert.ToDouble(materValue5.Text.Trim());
}
if (!string.IsNullOrEmpty(materValue6.Text.Trim()))
{
dFg += Convert.ToDouble(materValue6.Text.Trim());
}
if (!string.IsNullOrEmpty(ute_DZ.Text.Trim()))
{
dDz += Convert.ToDouble(ute_DZ.Text.Trim());
}
dRlzl = dFg;//入炉重量
if (dRlzl == 0)
{
if (!string.IsNullOrEmpty(ute_RLZL.Text.Trim()))
{
dRlzl = Convert.ToDouble(ute_RLZL.Text.Trim());
}
}
ute_RLZL.Text = Convert.ToString(dRlzl); //入炉重量
ute_ZZ.Text = Convert.ToString(dRlzl + dDz);//总重量
}
catch
{
}
}
private void ute_RLZL_ValueChanged(object sender, EventArgs e)
{
try
{
string strRlzl = ute_RLZL.Text.Trim();
if (ute_RLZL.Focused)
{
for (int i = 0; i < EditorValueList.Count; i++)
{
((Infragistics.Win.UltraWinEditors.UltraTextEditor)EditorValueList[i]).Text = "0";
}
Double dRlzl = 0, dDz = 0;
if (!string.IsNullOrEmpty(strRlzl))
{
dDz += Convert.ToDouble(strRlzl);
}
if (!string.IsNullOrEmpty(ute_DZ.Text.Trim()))
{
dDz += Convert.ToDouble(ute_DZ.Text.Trim());
}
ute_ZZ.Text = Convert.ToString(dRlzl + dDz);//总重量
}
}
catch { }
}
private void NumberInput_KeyPress(object sender, KeyPressEventArgs e)
{
if (!(Char.IsNumber(e.KeyChar) || e.KeyChar == '\b' || e.KeyChar == '.'))
{
e.Handled = true;
}
char[] arrary = ((UltraTextEditor)sender).Text.ToCharArray();
if (e.KeyChar == '.')
{
if (arrary.Length == 0)
{
((UltraTextEditor)sender).Text = "0.";
((UltraTextEditor)sender).SelectionStart = ((UltraTextEditor)sender).Text.Trim().Length;
e.Handled = true;
}
else
{
for (int i = 0; i < arrary.Length; i++)
{
if (arrary[i] == '.')
e.Handled = true;
}
}
}
if (arrary.Length == 1)
{
if (e.KeyChar == '0')
{
if (arrary[0] == '0')
e.Handled = true;
}
if (arrary[0] == '0' && e.KeyChar != '.' && e.KeyChar != '\b' && e.KeyChar != '0'&&!(Char.IsNumber(e.KeyChar)))
{
((UltraTextEditor)sender).Text = e.KeyChar.ToString();
((UltraTextEditor)sender).SelectionStart = ((UltraTextEditor)sender).Text.Trim().Length;
e.Handled = true;
}
}
}
private void HeatNoInput_KeyPress(object sender, KeyPressEventArgs e)
{
if (!(Char.IsNumber(e.KeyChar) || e.KeyChar == '\b'))
{
e.Handled = true;
}
}
private void ultraToolbarsManager1_ToolClick(object sender, Infragistics.Win.UltraWinToolbars.ToolClickEventArgs e)
{
string Job_ID = ultNo.Text.Trim();
switch (e.Tool.Key)
{
case "add":
// ClearData1();
SetDetailToolBarEnable(true,"add");
setToolEnable(false);
this.uTbMTool.Tools["ok"].Tag = "add";
ultNo.Clear();
ute_LH.Clear();
utlcbdevNo.SelectedIndex = -1;
ute_RLSJ.Text = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
for (int i = 0; i < EditorValueList.Count; i++)
{
((Infragistics.Win.UltraWinEditors.UltraTextEditor)EditorValueList[i]).Text = "0";
}
ute_RLZL.Text = "0";
ute_DZ.Text = "0";
ute_ZZ.Text = "0";
break;
case "edit":
if (ultraGrid1.Rows.Count==0)
{
MessageBox.Show("无有效信息可以修改", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
return;
}
if (ultraGrid1.ActiveRow.Appearance.BackColor == Color.LightGreen || ute_LH.Text.Trim() != "")
{
MessageBox.Show("选取的废钢信息已发送不能修改!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
return;
}
SetDetailToolBarEnable(true,"edit");
setToolEnable(false);
this.uTbMTool.Tools["ok"].Tag = "edit";
break;
case "del":
if (Job_ID.Length == 0)
{
MessageBox.Show("无有效的数据可删除!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
DeleteDataRow();
break;
case "ok":
string flag = this.uTbMTool.Tools["ok"].Tag.ToString();
if (flag == "edit")
{
if (Job_ID.Length == 0)
{
MessageBox.Show("无有效的数据可操作!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
}
if (flag == "add")
{
AddNewData();
}
if (flag == "edit")
{
UpdateDataRow(Job_ID);
}
if (!ok_flag) return;
SetDetailToolBarEnable(false,"");
setToolEnable(true);
GetRLMX_Data();
break;
case "cancel":
SetDetailToolBarEnable(false,"");
setToolEnable(true);
ultraGrid1_AfterRowActivate(null,null);
break;
case "left":
if (ultraGrid1.Rows.Count == 0) return;
//将位置移动到前一条记录
try
{
if (ultraGrid1.ActiveRow == null)
{
ultraGrid1.Rows[0].Activate();
}
else
{
int nIndex = ultraGrid1.ActiveRow.Index;
nIndex = nIndex - 1;
if (nIndex < 0) nIndex = ultraGrid1.Rows.Count-1;
ultraGrid1.Rows[nIndex].Activate();
}
}
catch { }
break;
case "right":
if (ultraGrid1.Rows.Count == 0) return;
//将位置移动到后一条记录
try
{
if (ultraGrid1.ActiveRow == null)
{
ultraGrid1.Rows[0].Activate();
}
else
{
int nIndex = ultraGrid1.ActiveRow.Index;
nIndex = nIndex + 1;
if (nIndex >= ultraGrid1.Rows.Count) nIndex = 0;
ultraGrid1.Rows[nIndex].Activate();
}
}
catch { }
break;
case "Custom": //初始化物料
try
{
GetConfigMater();
materValue1.Text = "";
materValue2.Text = "";
materValue3.Text = "";
materValue4.Text = "";
materValue5.Text = "";
materValue6.Text = "";
}
catch { }
break;
}
}
private void chkSend_CheckedChanged(object sender, EventArgs e)
{
GetRLMX_Data();
}
}
}