using System;
using System.Drawing;
using System.Data;
using System.Windows.Forms;
using System.Collections;
using Infragistics.Win.UltraWinGrid;
using Core.LgMes.Client.Comm;
namespace Core.LgMes.Client.LgJobMgt
{
public partial class FrmProductQuery : UserControl
{
public delegate void ReportSelect(string strCastNo, string strBlockNo);
public ReportSelect reportSelect;
public delegate void ReportHandSet(string strHeatID, int nBegin, int nEnd);
public ReportHandSet reportHandSet;
public int intCcm = -1;
public FrmProductQuery()
{
InitializeComponent();
}
private DataTable steelSchTable, cutSchTable;//调度、切割指示表
private Hashtable routeHash = new Hashtable();//存放工艺路径
public FrmCutBilletDetail FrmMain;
//public Core.Mes.ClientFrameWork.RemotingHelp;
private void FrmProductQuery_Load(object sender, EventArgs e)
{
dtpCutTime.Value = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") ;
steelSchTable = new DataTable("steelSchTable");
cutSchTable = new DataTable("cutSchTable");
createTable();
this.ultraGrid1.DataSource = steelSchTable;
this.uGrdCutInfo.DataSource = cutSchTable;
setGrid1View();
InitComboBoxSource();
this.combConNo.SelectedIndex = 0;
//分铸机
if (intCcm == -1)
{
this.ccmNumCobo.SelectedIndex = 0;
}
else
{
this.ccmNumCobo.SelectedIndex = intCcm;
chkCcmNo.Checked = true;
chkCcmNo.Enabled = false;
comboBox3.SelectedIndex = intCcm;
comboBox3.Enabled = false;
}
this.ccmNumCobo.Enabled = false;
this.combConNo.Enabled = false;
this.queryBtn_Click(null, new EventArgs());
}
private void InitComboBoxSource()
{
this.ccmNumCobo.DataSource = GetCcmData();
this.ccmNumCobo.DisplayMember = "name";
this.ccmNumCobo.ValueMember = "id";
this.combConNo.DataSource = GetConData();
this.combConNo.DisplayMember = "name";
this.combConNo.ValueMember = "id";
this.cboFlowNo.DataSource = GetFlowData();
this.cboFlowNo.DisplayMember = "name";
this.cboFlowNo.ValueMember = "id";
}
private void createTable()//----创建对应表
{
try
{
//炼钢指示表
DataColumn myDataColumn = new DataColumn();
myDataColumn = new DataColumn();
myDataColumn.DataType = System.Type.GetType("System.String");
myDataColumn.ColumnName = "HEATNO";
myDataColumn.Caption = "炉号";
steelSchTable.Columns.Add(myDataColumn);
myDataColumn = new DataColumn();
myDataColumn.DataType = System.Type.GetType("System.String");
myDataColumn.ColumnName = "AIM_GRADE_CODE";
myDataColumn.Caption = "目标钢号";
steelSchTable.Columns.Add(myDataColumn);
myDataColumn = new DataColumn();
myDataColumn.DataType = System.Type.GetType("System.String");
myDataColumn.ColumnName = "CAST_ID";
myDataColumn.Caption = "铸机";
steelSchTable.Columns.Add(myDataColumn);
myDataColumn = new DataColumn();
myDataColumn.DataType = System.Type.GetType("System.String");
myDataColumn.ColumnName = "CAST_NO";
myDataColumn.Caption = "浇次号";
steelSchTable.Columns.Add(myDataColumn);
myDataColumn = new DataColumn();
myDataColumn.DataType = System.Type.GetType("System.String");
myDataColumn.ColumnName = "HEAT_NUM";
myDataColumn.Caption = "炉数";
steelSchTable.Columns.Add(myDataColumn);
myDataColumn = new DataColumn();
myDataColumn.DataType = System.Type.GetType("System.String");
myDataColumn.ColumnName = "CAST_SEQ";
myDataColumn.Caption = "顺序";
steelSchTable.Columns.Add(myDataColumn);
myDataColumn = new DataColumn();
myDataColumn.DataType = System.Type.GetType("System.String");
myDataColumn.ColumnName = "PLAN_ROUTE";
myDataColumn.Caption = "工艺路径";
steelSchTable.Columns.Add(myDataColumn);
myDataColumn = new DataColumn();
myDataColumn.DataType = System.Type.GetType("System.String");
myDataColumn.ColumnName = "BILLETQTY";
myDataColumn.Caption = "方坯数";
steelSchTable.Columns.Add(myDataColumn);
//myDataColumn = new DataColumn();
//myDataColumn.DataType = System.Type.GetType("System.String");
//myDataColumn.ColumnName = "AIM_S";
//myDataColumn.Caption = "目标含硫量";
//steelSchTable.Columns.Add(myDataColumn);
myDataColumn = new DataColumn();
myDataColumn.DataType = System.Type.GetType("System.String");
myDataColumn.ColumnName = "PLAN_IRON_QTY";
myDataColumn.Caption = "计划铁水量";
steelSchTable.Columns.Add(myDataColumn);
//myDataColumn = new DataColumn();
//myDataColumn.DataType = System.Type.GetType("System.String");
//myDataColumn.ColumnName = "AIM_MIF_STR_TIME";
//myDataColumn.Caption = "计划出铁开始时刻";
//steelSchTable.Columns.Add(myDataColumn);
//myDataColumn = new DataColumn();
//myDataColumn.DataType = System.Type.GetType("System.String");
//myDataColumn.ColumnName = "AIM_MIF_END_TIME";
//myDataColumn.Caption = "计划出铁结束时刻";
//steelSchTable.Columns.Add(myDataColumn);
myDataColumn = new DataColumn();
myDataColumn.DataType = System.Type.GetType("System.String");
myDataColumn.ColumnName = "PLAN_HMP_STR_TIME";
myDataColumn.Caption = "计划脱硫开始时刻";
steelSchTable.Columns.Add(myDataColumn);
myDataColumn = new DataColumn();
myDataColumn.DataType = System.Type.GetType("System.String");
myDataColumn.ColumnName = "PLAN_HMP_END_TIME";
myDataColumn.Caption = "计划脱硫结束时刻";
steelSchTable.Columns.Add(myDataColumn);
//myDataColumn = new DataColumn();
//myDataColumn.DataType = System.Type.GetType("System.String");
//myDataColumn.ColumnName = "AIM_HM_STR_TIME";
//myDataColumn.Caption = "计划装料开始时刻";
//steelSchTable.Columns.Add(myDataColumn);
myDataColumn = new DataColumn();
myDataColumn.DataType = System.Type.GetType("System.String");
myDataColumn.ColumnName = "PLAN_BOF_STR_TIME";
myDataColumn.Caption = "计划吹炼开始时刻";
steelSchTable.Columns.Add(myDataColumn);
myDataColumn = new DataColumn();
myDataColumn.DataType = System.Type.GetType("System.String");
myDataColumn.ColumnName = "PLAN_BOF_END_TIME";
myDataColumn.Caption = "计划吹炼结束时刻";
steelSchTable.Columns.Add(myDataColumn);
//myDataColumn = new DataColumn();
//myDataColumn.DataType = System.Type.GetType("System.String");
//myDataColumn.ColumnName = "AIM_TAP_END_TIME";
//myDataColumn.Caption = "计划出钢结束时刻";
//steelSchTable.Columns.Add(myDataColumn);
myDataColumn = new DataColumn();
myDataColumn.DataType = System.Type.GetType("System.String");
myDataColumn.ColumnName = "AIM_STEEL_QTY";
myDataColumn.Caption = "目标出钢量";
steelSchTable.Columns.Add(myDataColumn);
//myDataColumn = new DataColumn();
//myDataColumn.DataType = System.Type.GetType("System.String");
//myDataColumn.ColumnName = "AIM_STEEL_QTY";
//myDataColumn.Caption = "出钢目标温度";
//steelSchTable.Columns.Add(myDataColumn);
myDataColumn = new DataColumn();
myDataColumn.DataType = System.Type.GetType("System.String");
myDataColumn.ColumnName = "PLAN_AR_STR_TIME";
myDataColumn.Caption = "计划AR开始时刻";
steelSchTable.Columns.Add(myDataColumn);
myDataColumn = new DataColumn();
myDataColumn.DataType = System.Type.GetType("System.String");
myDataColumn.ColumnName = "PLAN_AR_END_TIME";
myDataColumn.Caption = "计划AR结束时刻";
steelSchTable.Columns.Add(myDataColumn);
//myDataColumn = new DataColumn();
//myDataColumn.DataType = System.Type.GetType("System.String");
//myDataColumn.ColumnName = "AIM_AR_TEMP";
//myDataColumn.Caption = "AR目标温度";
//steelSchTable.Columns.Add(myDataColumn);
myDataColumn = new DataColumn();
myDataColumn.DataType = System.Type.GetType("System.String");
myDataColumn.ColumnName = "PLAN_LF_STR_TIME";
myDataColumn.Caption = "计划LF开始时刻";
steelSchTable.Columns.Add(myDataColumn);
myDataColumn = new DataColumn();
myDataColumn.DataType = System.Type.GetType("System.String");
myDataColumn.ColumnName = "PLAN_LF_END_TIME";
myDataColumn.Caption = "计划LF结束时刻";
steelSchTable.Columns.Add(myDataColumn);
//myDataColumn = new DataColumn();
//myDataColumn.DataType = System.Type.GetType("System.String");
//myDataColumn.ColumnName = "AIM_LF_TEMP";
//myDataColumn.Caption = "LF目标温度";
//steelSchTable.Columns.Add(myDataColumn);
myDataColumn = new DataColumn();
myDataColumn.DataType = System.Type.GetType("System.String");
myDataColumn.ColumnName = "PLAN_RH_STR_TIME";
myDataColumn.Caption = "计划RH开始时刻";
steelSchTable.Columns.Add(myDataColumn);
myDataColumn = new DataColumn();
myDataColumn.DataType = System.Type.GetType("System.String");
myDataColumn.ColumnName = "PLAN_RH_ENT_TIME";
myDataColumn.Caption = "计划RH结束时刻";
steelSchTable.Columns.Add(myDataColumn);
//myDataColumn = new DataColumn();
//myDataColumn.DataType = System.Type.GetType("System.String");
//myDataColumn.ColumnName = "AIM_VD_TEMP";
//myDataColumn.Caption = "RH目标温度";
//steelSchTable.Columns.Add(myDataColumn);
myDataColumn = new DataColumn();
myDataColumn.DataType = System.Type.GetType("System.String");
myDataColumn.ColumnName = "PLAN_CCM_STR_TIME";
myDataColumn.Caption = "计划浇注开始时刻";
steelSchTable.Columns.Add(myDataColumn);
myDataColumn = new DataColumn();
myDataColumn.DataType = System.Type.GetType("System.String");
myDataColumn.ColumnName = "PLAN_CCM_END_TIME";
myDataColumn.Caption = "计划浇注结束时刻";
steelSchTable.Columns.Add(myDataColumn);
//myDataColumn = new DataColumn();
//myDataColumn.DataType = System.Type.GetType("System.String");
//myDataColumn.ColumnName = "AIM_TD_TEMP";
//myDataColumn.Caption = "浇注温度";
//steelSchTable.Columns.Add(myDataColumn);
myDataColumn = new DataColumn();
myDataColumn.DataType = System.Type.GetType("System.String");
myDataColumn.ColumnName = "HEAT_STATE";
myDataColumn.Caption = "生产状态";
steelSchTable.Columns.Add(myDataColumn);
myDataColumn = new DataColumn();
myDataColumn.DataType = System.Type.GetType("System.String");
myDataColumn.ColumnName = "v_heat_ID";
myDataColumn.Caption = "虚拟炉号";
steelSchTable.Columns.Add(myDataColumn);
myDataColumn = new DataColumn();
myDataColumn.DataType = System.Type.GetType("System.String");
myDataColumn.ColumnName = "STEELCODE";
myDataColumn.Caption = "牌号编码";
steelSchTable.Columns.Add(myDataColumn);
//切割指示表
myDataColumn = new DataColumn();
myDataColumn = new DataColumn();
myDataColumn.DataType = System.Type.GetType("System.String");
myDataColumn.ColumnName = "heatno";
myDataColumn.Caption = "炉号";
cutSchTable.Columns.Add(myDataColumn);
myDataColumn = new DataColumn();
myDataColumn.DataType = System.Type.GetType("System.String");
myDataColumn.ColumnName = "BILLET_XN";
myDataColumn.Caption = "计划坯号";
cutSchTable.Columns.Add(myDataColumn);
myDataColumn = new DataColumn();
myDataColumn.DataType = System.Type.GetType("System.String");
myDataColumn.ColumnName = "SLABLENGTH";
myDataColumn.Caption = "目标长度";
cutSchTable.Columns.Add(myDataColumn);
myDataColumn = new DataColumn();
myDataColumn.DataType = System.Type.GetType("System.String");
myDataColumn.ColumnName = "DIRECTIONTYPE";
myDataColumn.Caption = "计划去向";
cutSchTable.Columns.Add(myDataColumn);
myDataColumn = new DataColumn();
myDataColumn.DataType = System.Type.GetType("System.String");
myDataColumn.ColumnName = "CUTTASKCODE";
myDataColumn.Caption = "铸机号";
cutSchTable.Columns.Add(myDataColumn);
myDataColumn = new DataColumn();
myDataColumn.DataType = System.Type.GetType("System.String");
myDataColumn.ColumnName = "CAST_NO";
myDataColumn.Caption = "浇次号";
cutSchTable.Columns.Add(myDataColumn);
myDataColumn = new DataColumn();
myDataColumn.DataType = System.Type.GetType("System.String");
myDataColumn.ColumnName = "SEQUENCENO";
myDataColumn.Caption = "炉内顺序号";
cutSchTable.Columns.Add(myDataColumn);
myDataColumn = new DataColumn();
myDataColumn.DataType = System.Type.GetType("System.String");
myDataColumn.ColumnName = "SEQUENCEINCAST";
myDataColumn.Caption = "浇次内炉序";
cutSchTable.Columns.Add(myDataColumn);
myDataColumn = new DataColumn();
myDataColumn.DataType = System.Type.GetType("System.String");
myDataColumn.ColumnName = "CUTSTARTTIME";
myDataColumn.Caption = "计划切割时间";
cutSchTable.Columns.Add(myDataColumn);
myDataColumn = new DataColumn();
myDataColumn.DataType = System.Type.GetType("System.String");
myDataColumn.ColumnName = "SLABHEIGHT";
myDataColumn.Caption = "目标厚度";
cutSchTable.Columns.Add(myDataColumn);
myDataColumn = new DataColumn();
myDataColumn.DataType = System.Type.GetType("System.String");
myDataColumn.ColumnName = "SLABWIDTH";
myDataColumn.Caption = "目标宽度";
cutSchTable.Columns.Add(myDataColumn);
myDataColumn = new DataColumn();
myDataColumn.DataType = System.Type.GetType("System.String");
myDataColumn.ColumnName = "THEROYWEIGHT";
myDataColumn.Caption = "坯料重量";
cutSchTable.Columns.Add(myDataColumn);
myDataColumn = new DataColumn();
myDataColumn.DataType = System.Type.GetType("System.String");
myDataColumn.ColumnName = "BILLETQTY";
myDataColumn.Caption = "方坯数";
cutSchTable.Columns.Add(myDataColumn);
myDataColumn = new DataColumn();
myDataColumn.DataType = System.Type.GetType("System.String");
myDataColumn.ColumnName = "BILLETWEIGHT";
myDataColumn.Caption = "坯料单重";
cutSchTable.Columns.Add(myDataColumn);
myDataColumn = new DataColumn();
myDataColumn.DataType = System.Type.GetType("System.String");
myDataColumn.ColumnName = "FURNACENO";
myDataColumn.Caption = "虚拟炉号";
cutSchTable.Columns.Add(myDataColumn);
myDataColumn = new DataColumn();
myDataColumn.DataType = System.Type.GetType("System.String");
myDataColumn.ColumnName = "PRODORDERNO";
myDataColumn.Caption = "生产订单号";
cutSchTable.Columns.Add(myDataColumn);
myDataColumn = new DataColumn();
myDataColumn.DataType = System.Type.GetType("System.String");
myDataColumn.ColumnName = "ORDERNO";
myDataColumn.Caption = "订单行号";
cutSchTable.Columns.Add(myDataColumn);
myDataColumn = new DataColumn();
myDataColumn.DataType = System.Type.GetType("System.String");
myDataColumn.ColumnName = "BATCHPLANNO";
myDataColumn.Caption = "批量计划号";
cutSchTable.Columns.Add(myDataColumn);
myDataColumn = new DataColumn();
myDataColumn.DataType = System.Type.GetType("System.String");
myDataColumn.ColumnName = "SEQUENCEINBATCH";
myDataColumn.Caption = "批量计划内序号";
cutSchTable.Columns.Add(myDataColumn);
myDataColumn = new DataColumn();
myDataColumn.DataType = System.Type.GetType("System.String");
myDataColumn.ColumnName = "CUSTOMER_KEY";
myDataColumn.Caption = "客户参数号";
cutSchTable.Columns.Add(myDataColumn);
myDataColumn = new DataColumn();
myDataColumn.DataType = System.Type.GetType("System.String");
myDataColumn.ColumnName = "SURPLUSFLAG";
myDataColumn.Caption = "是否余材";
cutSchTable.Columns.Add(myDataColumn);
myDataColumn = new DataColumn();
myDataColumn.DataType = System.Type.GetType("System.String");
myDataColumn.ColumnName = "STANDARDSCODE";
myDataColumn.Caption = "内控标准";
cutSchTable.Columns.Add(myDataColumn);
myDataColumn = new DataColumn();
myDataColumn.DataType = System.Type.GetType("System.String");
myDataColumn.ColumnName = "STANDARDREMAK";
myDataColumn.Caption = "标准描述";
cutSchTable.Columns.Add(myDataColumn);
myDataColumn = new DataColumn();
myDataColumn.DataType = System.Type.GetType("System.String");
myDataColumn.ColumnName = "PDTSTYLE";
myDataColumn.Caption = "产品类型";
cutSchTable.Columns.Add(myDataColumn);
myDataColumn = new DataColumn();
myDataColumn.DataType = System.Type.GetType("System.String");
myDataColumn.ColumnName = "SPECDESCRIPTION";
myDataColumn.Caption = "成品规格描述";
cutSchTable.Columns.Add(myDataColumn);
myDataColumn = new DataColumn();
myDataColumn.DataType = System.Type.GetType("System.String");
myDataColumn.ColumnName = "FOREIGN_TRADE";
myDataColumn.Caption = "是否出口";
cutSchTable.Columns.Add(myDataColumn);
}
catch (Exception ex)
{
string msg = ex.Message;
}
}
private void setGrid1View()//----设置grid外观
{
try
{
ultraGrid1.DisplayLayout.Appearance.BackColor = Color.FromArgb(245, 250, 254);
ultraGrid1.DisplayLayout.Override.HeaderAppearance.BackColor = Color.FromArgb(158, 191, 231);// System.Drawing.Color.FromArgb(205, 228, 225);
ultraGrid1.DisplayLayout.Override.RowSelectorAppearance.BackColor = System.Drawing.Color.FromArgb(205, 228, 225);
ultraGrid1.DisplayLayout.Override.RowAlternateAppearance.BackColor = Color.GhostWhite;
ultraGrid1.DisplayLayout.Bands[0].Columns["HEAT_STATE"].Hidden = true;
ultraGrid1.DisplayLayout.Bands[0].Columns["v_heat_ID"].Hidden = true;
ultraGrid1.DisplayLayout.Bands[0].Columns["PLAN_RH_STR_TIME"].Hidden = true;
ultraGrid1.DisplayLayout.Bands[0].Columns["PLAN_RH_ENT_TIME"].Hidden = true;
ultraGrid1.DisplayLayout.Bands[0].Columns["PLAN_HMP_STR_TIME"].Hidden = true;
ultraGrid1.DisplayLayout.Bands[0].Columns["PLAN_HMP_END_TIME"].Hidden = true;
ultraGrid1.DisplayLayout.Bands[0].Columns["PLAN_IRON_QTY"].Hidden = true;
ultraGrid1.DisplayLayout.Bands[0].Columns["HEAT_NUM"].Hidden = true;
ultraGrid1.DisplayLayout.Bands[0].Columns["STEELCODE"].Hidden = true;
ultraGrid1.DisplayLayout.Bands[0].Columns[0].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit;
ultraGrid1.DisplayLayout.Bands[0].Columns[1].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit;
ultraGrid1.DisplayLayout.Bands[0].Columns[2].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit;
ultraGrid1.DisplayLayout.Bands[0].Columns[3].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit;
ultraGrid1.DisplayLayout.Bands[0].Columns[4].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit;
ultraGrid1.DisplayLayout.Bands[0].Columns[5].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit;
ultraGrid1.DisplayLayout.Bands[0].Columns[6].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit;
ultraGrid1.DisplayLayout.Bands[0].Columns[7].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit;
ultraGrid1.DisplayLayout.Bands[0].Columns[8].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit;
ultraGrid1.DisplayLayout.Bands[0].Columns[9].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit;
ultraGrid1.DisplayLayout.Bands[0].Columns[10].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit;
ultraGrid1.DisplayLayout.Bands[0].Columns[11].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit;
ultraGrid1.DisplayLayout.Bands[0].Columns[12].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit;
ultraGrid1.DisplayLayout.Bands[0].Columns[13].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit;
ultraGrid1.DisplayLayout.Bands[0].Columns[14].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit;
ultraGrid1.DisplayLayout.Bands[0].Columns[15].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit;
ultraGrid1.DisplayLayout.Bands[0].Columns[16].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit;
ultraGrid1.DisplayLayout.Bands[0].Columns[17].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit;
ultraGrid1.DisplayLayout.Bands[0].Columns[18].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit;
ultraGrid1.DisplayLayout.Bands[0].Columns[19].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit;
ultraGrid1.DisplayLayout.Bands[0].Columns[20].CellActivation = Infragistics.Win.UltraWinGrid.Activation.NoEdit;
ultraGrid1.DisplayLayout.Bands[0].Columns[15].Format = "yy-MM-dd HH:mm";
ultraGrid1.DisplayLayout.Bands[0].Columns[16].Format = "yy-MM-dd HH:mm";
ultraGrid1.DisplayLayout.Bands[0].Columns[17].Format = "yy-MM-dd HH:mm";
ultraGrid1.DisplayLayout.Bands[0].Columns[18].Format = "yy-MM-dd HH:mm";
ultraGrid1.DisplayLayout.Bands[0].Columns[19].Format = "yy-MM-dd HH:mm";
ultraGrid1.DisplayLayout.Bands[0].Columns[20].Format = "yy-MM-dd HH:mm";
ultraGrid1.DisplayLayout.Bands[0].Columns[21].Format = "yy-MM-dd HH:mm";
ultraGrid1.DisplayLayout.Bands[0].Columns["HEATNO"].Width = 80;
ultraGrid1.DisplayLayout.Bands[0].Columns["AIM_GRADE_CODE"].Width = 60;
ultraGrid1.DisplayLayout.Bands[0].Columns["CAST_ID"].Width = 50;
ultraGrid1.DisplayLayout.Bands[0].Columns["CAST_NO"].Width = 70;
ultraGrid1.DisplayLayout.Bands[0].Columns["HEAT_NUM"].Width = 50;
ultraGrid1.DisplayLayout.Bands[0].Columns["CAST_SEQ"].Width = 50;
//ultraGrid1.DisplayLayout.Bands[0].Columns["AIM_S"].Width = 50;
ultraGrid1.DisplayLayout.Bands[0].Columns["PLAN_ROUTE"].Width = 230;
ultraGrid1.DisplayLayout.Bands[0].Columns["BILLETQTY"].Width = 38;
ultraGrid1.DisplayLayout.Bands[0].Columns[8].Width = 60;
ultraGrid1.DisplayLayout.Bands[0].Columns[10].Width = 130;
ultraGrid1.DisplayLayout.Bands[0].Columns[11].Width = 130;
ultraGrid1.DisplayLayout.Bands[0].Columns[12].Width = 130;
ultraGrid1.DisplayLayout.Bands[0].Columns[13].Width = 60;
ultraGrid1.DisplayLayout.Bands[0].Columns[14].Width = 130;
ultraGrid1.DisplayLayout.Bands[0].Columns[15].Width = 130;
ultraGrid1.DisplayLayout.Bands[0].Columns[16].Width = 130;
ultraGrid1.DisplayLayout.Bands[0].Columns[17].Width = 130;
// ultraGrid1.DisplayLayout.Bands[0].Columns["AIM_TD_TEMP"].Width = 50;
ultraGrid1.DisplayLayout.Bands[0].Columns[1].CellAppearance.BackColor = Color.GhostWhite;
ultraGrid1.DisplayLayout.Bands[0].Columns[2].CellAppearance.BackColor = Color.GhostWhite;
ultraGrid1.DisplayLayout.Bands[0].Columns[3].CellAppearance.BackColor = Color.GhostWhite;
ultraGrid1.DisplayLayout.Bands[0].Columns[4].CellAppearance.BackColor = Color.GhostWhite;
ultraGrid1.DisplayLayout.Bands[0].Columns[5].CellAppearance.BackColor = Color.GhostWhite;
ultraGrid1.DisplayLayout.Bands[0].Columns[6].CellAppearance.BackColor = Color.GhostWhite;
ultraGrid1.DisplayLayout.Bands[0].Columns[7].CellAppearance.BackColor = Color.GhostWhite;
ultraGrid1.DisplayLayout.Bands[0].Columns[8].CellAppearance.BackColor = Color.GhostWhite;
ultraGrid1.DisplayLayout.Bands[0].Columns[9].CellAppearance.BackColor = Color.GhostWhite;
ultraGrid1.DisplayLayout.Bands[0].Columns[10].CellAppearance.BackColor = Color.GhostWhite;
ultraGrid1.DisplayLayout.Bands[0].Columns[11].CellAppearance.BackColor = Color.GhostWhite;
ultraGrid1.DisplayLayout.Bands[0].Columns[12].CellAppearance.BackColor = Color.GhostWhite;
ultraGrid1.DisplayLayout.Bands[0].Columns[13].CellAppearance.BackColor = Color.GhostWhite;
ultraGrid1.DisplayLayout.Bands[0].Columns[14].CellAppearance.BackColor = Color.GhostWhite;
ultraGrid1.DisplayLayout.Bands[0].Columns[15].CellAppearance.BackColor = Color.GhostWhite;
ultraGrid1.DisplayLayout.Bands[0].Columns[16].CellAppearance.BackColor = Color.GhostWhite;
ultraGrid1.DisplayLayout.Bands[0].Columns[17].CellAppearance.BackColor = Color.GhostWhite;
ultraGrid1.DisplayLayout.Bands[0].Columns[18].CellAppearance.BackColor = Color.GhostWhite;
ultraGrid1.DisplayLayout.Bands[0].Columns[19].CellAppearance.BackColor = Color.LightGoldenrodYellow;
ultraGrid1.DisplayLayout.Bands[0].Columns[20].CellAppearance.BackColor = Color.LightGoldenrodYellow;
ultraGrid1.DisplayLayout.Bands[0].Columns[21].CellAppearance.BackColor = Color.LightGoldenrodYellow;
ultraGrid1.DisplayLayout.Bands[0].Columns[22].CellAppearance.BackColor = Color.LightPink;
ultraGrid1.DisplayLayout.Bands[0].Columns[23].CellAppearance.BackColor = Color.LightPink;
uGrdCutInfo.DisplayLayout.Appearance.BackColor = Color.FromArgb(245, 250, 254);
uGrdCutInfo.DisplayLayout.Override.HeaderAppearance.BackColor = Color.FromArgb(158, 191, 231);// System.Drawing.Color.FromArgb(205, 228, 225);
uGrdCutInfo.DisplayLayout.Override.RowSelectorAppearance.BackColor = System.Drawing.Color.FromArgb(205, 228, 225);
uGrdCutInfo.DisplayLayout.Override.RowAlternateAppearance.BackColor = Color.GhostWhite;
uGrdCutInfo.DisplayLayout.Bands[0].Columns["FURNACENO"].Hidden = true;
// ultraGrid2.DisplayLayout.Bands[0].Columns["STANDARDSCODE"].Hidden = true;
uGrdCutInfo.DisplayLayout.Bands[0].Columns["HeatNo"].Width = 60;
uGrdCutInfo.DisplayLayout.Bands[0].Columns["STANDARDREMAK"].Width = 90;
uGrdCutInfo.DisplayLayout.Bands[0].Columns["BILLET_XN"].Width = 80;
uGrdCutInfo.DisplayLayout.Bands[0].Columns["SLABLENGTH"].Width = 50;
uGrdCutInfo.DisplayLayout.Bands[0].Columns["CUTTASKCODE"].Width = 50;
uGrdCutInfo.DisplayLayout.Bands[0].Columns["CAST_NO"].Width = 50;
uGrdCutInfo.DisplayLayout.Bands[0].Columns["SEQUENCEINCAST"].Width = 50;
uGrdCutInfo.DisplayLayout.Bands[0].Columns["DIRECTIONTYPE"].Width = 70;
uGrdCutInfo.DisplayLayout.Bands[0].Columns["BILLETQTY"].Width = 60;
uGrdCutInfo.DisplayLayout.Bands[0].Columns["BILLETWEIGHT"].Width = 60;
uGrdCutInfo.DisplayLayout.Bands[0].Columns[7].Width = 60;
uGrdCutInfo.DisplayLayout.Bands[0].Columns[8].Width = 120;
uGrdCutInfo.DisplayLayout.Bands[0].Columns[9].Width = 70;
uGrdCutInfo.DisplayLayout.Bands[0].Columns[10].Width = 70;
uGrdCutInfo.DisplayLayout.Bands[0].Columns[11].Width = 70;
uGrdCutInfo.DisplayLayout.Bands[0].Columns[12].Width = 70;
}
catch (Exception ex)
{
string msg = ex.Message;
}
}
private string analysPath(string craftPath)//----路径解析
{
string path = "";
try
{
if (craftPath.Length > 14)
{
string str = "", route = "";
if (craftPath.Length >= 2)
{
str = craftPath.Substring(0, 2);
switch (str)
{
case "A0":
route = "";
break;
case "A1":
route = "1#混铁炉";
break;
case "A2":
route = "2#混铁炉";
break;
}
path = path + route;
}
else
return path;
if (craftPath.Length >= 4)
{
str = craftPath.Substring(2, 2);
switch (str)
{
case "B0":
route = "";
break;
case "B1":
route = "->1#铁水预处理";
break;
case "B2":
route = "->2#铁水预处理";
break;
}
path = path + route;
}
else
return path;
if (craftPath.Length >= 6)
{
str = craftPath.Substring(4, 2);
switch (str)
{
case "C0":
route = "";
break;
case "C1":
route = "->1#转炉";
break;
case "C2":
route = "->2#转炉";
break;
case "C3":
route = "->3#转炉";
break;
}
path = path + route;
}
else
return path;
if (craftPath.Length >= 8)
{
str = craftPath.Substring(6, 2);
switch (str)
{
case "D0":
route = "";
break;
case "D1":
route = "->1#吹氩站";
break;
case "D2":
route = "->2#吹氩站";
break;
case "D3":
route = "->3#吹氩站";
break;
}
path = path + route;
}
else
return path;
///2008-02-28 刘现
if (craftPath.Length >= 10)
{
str = craftPath.Substring(8, 2);
switch (str)
{
case "F0":
route = "";
break;
case "F1":
route = "->1#RH炉";
break;
}
path = path + route;
}
else
return path;
if (craftPath.Length >= 12)
{
str = craftPath.Substring(10, 2);
switch (str)
{
case "E0":
route = "";
break;
case "E1":
route = "->1#精练";
break;
case "E2":
route = "->2#精练";
break;
}
path = path + route;
}
else
return path;
if (craftPath.Length >= 14)
{
str = craftPath.Substring(12, 2);
switch (str)
{
case "F0":
route = "";
break;
case "F1":
route = "->1#RH炉";
break;
}
path = path + route;
}
else
return path;
if (craftPath.Length >= 14)
{
str = craftPath.Substring(14, 2);
switch (str)
{
case "G0":
route = "";
break;
case "G1":
route = "->1#连铸机";
break;
case "G2":
route = "->2#连铸机";
break;
case "G3":
route = "->3#连铸机";
break;
case "G4":
route = "->0#连铸机";
break;
}
path = path + route;
}
else
return path;
if (path.Length < 2)
return "";
if (path.IndexOf("->", 0) == 0)
{
int len = path.Length;
path = path.Substring(2, len - 2);
}
}
else
{
string str = "", route = "";
if (craftPath.Length >= 2)
{
str = craftPath.Substring(0, 2);
switch (str)
{
case "A0":
route = "";
break;
case "A1":
route = "1#混铁炉";
break;
case "A2":
route = "2#混铁炉";
break;
}
path = path + route;
}
else
return path;
if (craftPath.Length >= 4)
{
str = craftPath.Substring(2, 2);
switch (str)
{
case "B0":
route = "";
break;
case "B1":
route = "->1#铁水预处理";
break;
case "B2":
route = "->2#铁水预处理";
break;
}
path = path + route;
}
else
return path;
if (craftPath.Length >= 6)
{
str = craftPath.Substring(4, 2);
switch (str)
{
case "C0":
route = "";
break;
case "C1":
route = "->1#转炉";
break;
case "C2":
route = "->2#转炉";
break;
case "C3":
route = "->3#转炉";
break;
}
path = path + route;
}
else
return path;
if (craftPath.Length >= 8)
{
str = craftPath.Substring(6, 2);
switch (str)
{
case "D0":
route = "";
break;
case "D1":
route = "->1#吹氩站";
break;
case "D2":
route = "->2#吹氩站";
break;
case "D3":
route = "->3#吹氩站";
break;
}
path = path + route;
}
else
return path;
if (craftPath.Length >= 10)
{
str = craftPath.Substring(8, 2);
switch (str)
{
case "E0":
route = "";
break;
case "E1":
route = "->1#精练";
break;
case "E2":
route = "->2#精练";
break;
}
path = path + route;
}
else
return path;
if (craftPath.Length >= 12)
{
str = craftPath.Substring(10, 2);
switch (str)
{
case "F0":
route = "";
break;
case "F1":
route = "->1#RH炉";
break;
case "F2":
route = "->2#RH炉";
break;
}
path = path + route;
}
else
return path;
if (craftPath.Length >= 14)
{
str = craftPath.Substring(12, 2);
switch (str)
{
case "G0":
route = "";
break;
case "G1":
route = "->1#连铸机";
break;
case "G2":
route = "->2#连铸机";
break;
case "G3":
route = "->3#连铸机";
break;
case "G4":
route = "->0#连铸机";
break;
}
path = path + route;
}
else
return path;
if (path.Length < 2)
return "";
if (path.IndexOf("->", 0) == 0)
{
int len = path.Length;
path = path.Substring(2, len - 2);
}
}
return path;
}
catch (Exception ex)
{
string msg = ex.Message;
return path;
}
}
private DataTable GetCcmData()
{
DataTable dt = new DataTable();
dt.Columns.Add("id", typeof(System.String));
dt.Columns.Add("name", typeof(System.String));
//dt.Rows.Add(new object[] { "0", "0#铸机" });
dt.Rows.Add(new object[] { "1", "1#铸机" });
dt.Rows.Add(new object[] { "2", "2#铸机" });
dt.Rows.Add(new object[] { "3", "3#铸机" });
// dt.Rows.Add(new object[] { "4", "4#铸机" });
dt.AcceptChanges();
return dt;
}
private DataTable GetConData()
{
DataTable dt = new DataTable();
dt.Columns.Add("id", typeof(System.String));
dt.Columns.Add("name", typeof(System.String));
dt.Rows.Add(new object[] { "1", "1#转炉" });
dt.Rows.Add(new object[] { "2", "2#转炉" });
dt.Rows.Add(new object[] { "3", "3#转炉" });
dt.AcceptChanges();
return dt;
}
private DataTable GetFlowData()
{
DataTable dt = new DataTable();
dt.Columns.Add("id", typeof(System.String));
dt.Columns.Add("name", typeof(System.String));
if (intCcm == 2 || intCcm == 3)
{
dt.Rows.Add(new object[] { "1", "0流" });
dt.Rows.Add(new object[] { "2", "1流" });
dt.Rows.Add(new object[] { "3", "2流" });
dt.Rows.Add(new object[] { "4", "3流" });
dt.Rows.Add(new object[] { "5", "4流" });
}
else
{
dt.Rows.Add(new object[] { "1", "1流" });
dt.Rows.Add(new object[] { "2", "2流" });
dt.Rows.Add(new object[] { "3", "3流" });
dt.Rows.Add(new object[] { "4", "4流" });
dt.Rows.Add(new object[] { "5", "5流" });
}
dt.AcceptChanges();
return dt;
}
private void queryBtn_Click(object sender, EventArgs e)
{
try
{
string startTime = FrmMain.dateTimePicker3.Value.ToString();
string endTime = FrmMain.dateTimePicker4.Value.ToString();
string strWhere = string.Format(" WHERE PLAN_MAKING_TIME>=to_date('{0}','yyyy-MM-dd HH24:Mi:ss') AND PLAN_MAKING_TIME<=to_date('{1}','yyyy-MM-dd HH24:Mi:ss') ", startTime, endTime);
if (this.chkCcmNo.Checked)
{ //this.combCcmNo.SelectedItem
//string ccmN0 = this.combCcmNo.SelectedValue.ToString();
strWhere += string.Format(" AND CAST_ID='{0}' ", this.ccmNumCobo.SelectedValue);
}
//以下是转炉查询
if (this.chkConNo.Checked)
{
//string conN0 = this.combConNo.SelectedValue.ToString();
strWhere += string.Format(" AND substr(heatno,3,1)='{0}'", this.combConNo.SelectedValue);
}//转炉
//strWhere += " order by AIM_CAST_STR_TIME desc " ;
strWhere += " and heatno is not null ";//order by CAST_NO desc,to_number(CAST_SEQ) desc ";
string err = "";
this.steelSchTable.Clear();
routeHash.Clear();
// DataSet ds = (DataSet)ClientCommon._RemotingHelp.ExecuteMethod("DataHandle", "Core.Sglg.DataHandle", "Core.Sglg.DataHandle.BSA_ISTLSCH", "SelectToDataSet", new object[] { strWhere }, out err);
DataSet ds = null;// (DataSet)ClientCommon._RemotingHelp.ExecuteMethod("lgIntegrationQuery", "Core.LgMes.Server.lgIntegrationQuery.LgGeneralInfo", "GetAllJobPlan_Cut", new object[] { strWhere }, out err);
if (err != "" && ds.Tables[0].Rows.Count <= 0)
{
//MessageBox.Show("炼钢数据查询错误："+err,"提示");
return;
}
//this.steelSchTable = ds.Tables[0];
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
this.ultraGrid1.BeginUpdate();
this.cutSchTable.Clear();
int rowCount = ds.Tables[0].Rows.Count;
DataRow row;
string name = "";
for (int i = 0; i < rowCount; i++)
{
row = this.steelSchTable.NewRow();
foreach (DataColumn column in steelSchTable.Columns)
{
name = column.ColumnName;
if (name != "PLAN_ROUTE")
row[name] = ds.Tables[0].Rows[i][name].ToString();
else
{
routeHash.Add(ds.Tables[0].Rows[i]["HEATNO"].ToString(), ds.Tables[0].Rows[i]["PLAN_ROUTE"].ToString());
row[name] = analysPath(ds.Tables[0].Rows[i][name].ToString());
}
}
this.steelSchTable.Rows.Add(row);
string status = row["HEAT_STATE"].ToString();
if (status == "03")
{
foreach (UltraGridCell cell in ultraGrid1.Rows[i].Cells)
cell.Appearance.BackColor = Color.White;//计划状态
}
else if (status == "09")
{
foreach (UltraGridCell cell in ultraGrid1.Rows[i].Cells)
cell.Appearance.BackColor = Color.LightCyan; //Color.MintCream;//连铸结束
}
else
{
foreach (UltraGridCell cell in ultraGrid1.Rows[i].Cells)
cell.Appearance.BackColor = Color.LightGreen;//在生产用颜色区分
}
}
this.ultraGrid1.EndUpdate();
}
}
catch { }
}
private void combCcmNo_ValueMemberChanged(object sender, EventArgs e)
{
FrmMain.CCMN0 = ccmNumCobo.Text;
}
private void chkCcmNo_CheckedChanged(object sender, EventArgs e)
{
if (this.chkCcmNo.Checked)
{
this.ccmNumCobo.Enabled = true;
this.ccmNumCobo.BackColor = Color.White;
}
else
{
this.ccmNumCobo.Enabled = false;
this.ccmNumCobo.BackColor = Color.Gainsboro;
}
}
private void chkConNo_CheckedChanged(object sender, EventArgs e)
{
if (this.chkConNo.Checked)
{
this.combConNo.Enabled = true;
this.combConNo.BackColor = Color.White;
}
else
{
this.combConNo.Enabled = false;
this.combConNo.BackColor = Color.Gainsboro;
}
}
private void button3_Click(object sender, EventArgs e)
{
string yncheck = "";
yncheck = this.FrmMain.yncheck();
//只有在连铸机生产或已生产完的
if (!GetHeatState(textBox1.Text))
{
MessageBox.Show("炉号【" + textBox1.Text + "】没有上连铸机生产，不能生成坯料！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
return;
}
if (yncheck == "Y")
{
MessageBox.Show("请将本炉最后一块置成否后再增加支数");
return;
}
if (this.ultraGrid1.ActiveRow == null || this.uGrdCutInfo.Rows.Count == 0)
{
return;
}
if (this.uGrdCutInfo.ActiveRow == null)
{
MessageBox.Show("没有选择切割计划，请选择!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
return;
}
if (this.cboFlowNo.Text.Trim().Length == 0)
{
MessageBox.Show("请输入铸流号!");
return;
}
if (this.textBox2.Text.Trim().Length == 0)
this.textBox2.Text = "1";
int intIndex = 1;
try
{
intIndex = Convert.ToInt32(this.textBox2.Text.Trim());
}
catch
{
MessageBox.Show("起始序号请输入数字!");
return;
}
//检查一下数量
string strInputSmeltID = textBox1.Text;
//通过计划查找其铸机号
int nCCMNo = FindCCMNoInPlan(strInputSmeltID);
if (nCCMNo == -1)
{
MessageBox.Show("不存在指定的计划，或者数据查询错误，请重试!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Stop);
return;
}
//对比现在选择的铸机
//int nSelectCCMNo = Convert.ToInt32(comboBox3.SelectedItem) ;
int nSelectCCMNo = Convert.ToInt32(comboBox3.SelectedItem.ToString());
if (nCCMNo != nSelectCCMNo)
{
if (DialogResult.No == MessageBox.Show("您选择的铸机号和计划要去的连铸机号不同。确实要继续吗？", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Warning))
return;
}
InsertAllData(GetCurrValue());
////提示用户修改班次信息
//MessageBox.Show("该炉号所有坯子重量不能大于140,请修改手动生成记录的班次信息！", "插入记录成功！", MessageBoxButtons.OK, MessageBoxIcon.Warning);
this.FrmMain.Query();
}
private ArrayList GetCurrValue()
{
ArrayList ar = new ArrayList();
UltraGridRow ugr = this.ultraGrid1.ActiveRow;
UltraGridRow ugr2 = this.uGrdCutInfo.ActiveRow;
try
{
ar.Add(ugr.Cells["HEATNO"].Value.ToString());
ar.Add(this.comboBox3.Text);
ar.Add(this.cboFlowNo.SelectedValue);
ar.Add(Convert.ToInt32(this.textBox2.Text.Trim()));
ar.Add(ugr.Cells["CAST_NO"].Value.ToString());
ar.Add(ugr.Cells["CAST_SEQ"].Value.ToString());
ar.Add(ugr.Cells["HEAT_NUM"].Value.ToString());
ar.Add(tbxLength.Text);
ar.Add(tbxWidth.Text);
ar.Add(tbxThick.Text);
ar.Add(tbxWeight.Text);
ar.Add(Convert.ToDateTime(dtpCutTime.Value).ToString("yyyy-MM-dd HH:mm:ss"));
ar.Add(Convert.ToInt32(this.textBox3.Text.Trim()));
ar.Add(FrmMain.UserInfo.GetUserName()); //add on 2009-04-23 记录操作人员
ar.Add(ugr2.Cells["FURNACENO"].Value.ToString());
ar.Add(ugr2.Cells["BILLET_XN"].Value.ToString());
ar.Add(txtOrderNO.Text);
ar.Add(txtProdorderNO.Text);
ar.Add((txtSurplusFlag.Text == "是" ? "1" : "0"));
ar.Add(ugr.Cells["SteelCode"].Value.ToString());
ar.Add((ugr2.Cells["DIRECTIONTYPE"].Value.ToString())=="弹扁"?"0":(ugr2.Cells["DIRECTIONTYPE"].Value.ToString())=="棒材"?"1":"2");
ar.Add(ugr2.Cells["STANDARDSCODE"].Value.ToString());
ar.Add(ugr2.Cells["STANDARDREMAK"].Value.ToString());
ar.Add(ugr2.Cells["CUSTOMER_KEY"].Value.ToString());
return ar;
}
catch
{
return null;
}
}
private int FindCCMNoInPlan(string strSmeltID)
{
string err = "";
DataSet ds = null;// (DataSet)ClientCommon._RemotingHelp.ExecuteMethod("lgJobMgt",
// "Core.LgMes.Server.lgJobMgt.classCutJob",
// "SelectQueryCCMNo", new object[] { strSmeltID }, out err);
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
return Convert.ToInt32(ds.Tables[0].Rows[0][0].ToString());
}
return -1;
}
private void InsertAllData(ArrayList ar)
{
try
{
//hengxing
//CallingMessage par = new CallingMessage();
//par.ServerName = "lgJobMgt";
//par.AssemblyName = "Core.LgMes.Server.lgJobMgt";
//par.ClassName = "Core.LgMes.Server.lgJobMgt.classCutJob";
//par.MethodName = "InsetCutBilletPlan";
//par.args = new object[] { ar, this.ultraGrid2.DataSource as DataTable };
string strOut = "";
object obj = null;// ClientCommon._RemotingHelp.ExecuteMethod(par, out strOut);
if (Convert.ToInt32(obj) < 1)
{
MessageBox.Show("数据提交失败！\n" + strOut);
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
private void ultraGrid2_AfterRowActivate(object sender, EventArgs e)
{
try
{
if (this.uGrdCutInfo.Rows.Count < 1)
return;
if (this.uGrdCutInfo.ActiveRow == null)
return;
UltraGridRow ultraRow = this.uGrdCutInfo.ActiveRow;
string strCastNo = ultraRow.Cells[0].Value.ToString();
string strBlockNo = ultraRow.Cells[1].Value.ToString();
FrmMain.strV_BilletID = ultraRow.Cells["BILLET_XN"].Value.ToString();
FrmMain.strV_Heat_ID = ultraRow.Cells["FURNACENO"].Value.ToString();
FrmMain.strOrderNO = ultraRow.Cells["ORDERNO"].Value.ToString();
FrmMain.strProdOrderNO = ultraRow.Cells["PRODORDERNO"].Value.ToString();
FrmMain.strSurplusFlag = (ultraRow.Cells["SURPLUSFLAG"].Value.ToString() == "是" ? "1" : "0");
FrmMain.strProductline = (ultraRow.Cells["DIRECTIONTYPE"].Value.ToString()) == "弹扁" ? "0" : (ultraRow.Cells["DIRECTIONTYPE"].Value.ToString()) == "棒材" ? "1" : "2";
FrmMain.strStandardsCode = ultraRow.Cells["STANDARDSCODE"].Value.ToString();
FrmMain.strStandardRemak = ultraRow.Cells["STANDARDREMAK"].Value.ToString();
FrmMain.strCustomer_Key = ultraRow.Cells["CUSTOMER_KEY"].Value.ToString();
this.textBox1.Text = ultraRow.Cells["HeatNo"].Value.ToString();
this.comboBox3.Text = ultraRow.Cells["CAST_No"].Value.ToString();
this.textBox3.Text = ultraRow.Cells["BILLETQTY"].Value.ToString();
this.tbxLength.Text = ultraRow.Cells["SLABLENGTH"].Value.ToString();
this.tbxWidth.Text = ultraRow.Cells["SLABWIDTH"].Value.ToString();
this.tbxThick.Text = ultraRow.Cells["SLABHEIGHT"].Value.ToString();
this.txtProdorderNO.Text = ultraRow.Cells["ProdorderNo"].Value.ToString();
txtOrderNO.Text = ultraRow.Cells["OrderNo"].Value.ToString();
txtSurplusFlag.Text = ultraRow.Cells["SurplusFlag"].Value.ToString();
float a = Convert.ToSingle(this.tbxLength.Text.Trim());
float b = Convert.ToSingle(this.tbxWidth.Text.Trim());
float c = Convert.ToSingle(this.tbxThick.Text.Trim());
if (ultraRow.Cells["BILLETWEIGHT"].Value != null && ultraRow.Cells["BILLETWEIGHT"].Value.ToString().Length > 0)
tbxWeight.Text = ultraRow.Cells["BILLETWEIGHT"].Value.ToString();
else
{
if (ultraRow.Cells["BILLETQTY"].Value != null && !string.IsNullOrEmpty(ultraRow.Cells["BILLETQTY"].Value.ToString()) && Convert.ToDouble(ultraRow.Cells["BILLETQTY"].Value) > 0)
this.tbxWeight.Text = Convert.ToString(Convert.ToDouble(ultraRow.Cells["THEROYWEIGHT"].Value) / Convert.ToDouble(ultraRow.Cells["BILLETQTY"].Value));
else
tbxWeight.Text = Convert.ToString(Convert.ToDouble(ultraRow.Cells["THEROYWEIGHT"].Value) / Math.Round(a * b * c * 7.82 / 1000000000, 3));
}
//选择行进行了改变
if (reportSelect != null)
reportSelect(strCastNo, strBlockNo);
}
catch (Exception ex)
{
string msg = ex.Message;
}
}
private void ultraGrid1_AfterRowActivate(object sender, EventArgs e)
{
try
{
if (this.ultraGrid1.Rows.Count < 1)
return;
if (this.ultraGrid1.ActiveRow == null)
return;
UltraGridRow ultraRow = this.ultraGrid1.ActiveRow;
string castNo = ultraRow.Cells["heatNo"].Value.ToString();
string strV_HeatID = ultraRow.Cells["v_heat_ID"].Value.ToString();
string strWhere = string.Format(" WHERE FURNACENO='{0}' ", strV_HeatID); // ORDER BY decode(substr(BILLET_XN,1,1),'A','',to_number(substr(BILLET_XN, 3, 8))) asc,to_number(SEQUENCENO) asc
FrmMain.strSteelCode = ultraRow.Cells["SteelCode"].Value.ToString();
string err = "";
DataSet ds = null;// (DataSet)ClientCommon._RemotingHelp.ExecuteMethod("lgIntegrationQuery", "Core.LgMes.Server.lgIntegrationQuery.LgGeneralInfo", "GetCutingData", new object[] { strWhere }, out err);
if (err != "" && ds.Tables[0].Rows.Count <= 0)
{
//MessageBox.Show("切割数据查询错误："+err,"提示");
this.groupBox1.Text = "切割信息";
return;
}
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
string strMsg = "切割信息 块数:";
strMsg = strMsg + ds.Tables[0].Rows.Count.ToString();
this.groupBox1.Text = strMsg;
this.cutSchTable.Clear();
uGrdCutInfo.UpdateData();
int rowCount = ds.Tables[0].Rows.Count;
DataRow row;
for (int i = 0; i < rowCount; i++)
{
row = this.cutSchTable.NewRow();
foreach (DataColumn column in cutSchTable.Columns)
{
if (column.ColumnName.ToUpper() == "DIRECTIONTYPE") //坯料去向
row[column.ColumnName] = (ds.Tables[0].Rows[i][column.ColumnName].ToString() == "0" ? "弹扁" : (ds.Tables[0].Rows[i][column.ColumnName].ToString() == "1" ? "棒材" : "高线"));
else if (column.ColumnName.ToUpper() == "SURPLUSFLAG") //是否余材
row[column.ColumnName] = (ds.Tables[0].Rows[i][column.ColumnName].ToString() == "1" ? "是" : "否");
else
row[column.ColumnName] = ds.Tables[0].Rows[i][column.ColumnName].ToString();
}
this.cutSchTable.Rows.Add(row);
if (i > 0)
{
Color color1;
Color color2;
if (ds.Tables[0].Rows[i]["SLABLENGTH"].ToString() != ds.Tables[0].Rows[i - 1]["SLABLENGTH"].ToString())
{
color1 = (Color)uGrdCutInfo.Rows[i - 1].Cells["SLABLENGTH"].Appearance.BackColor;
if (color1 == Color.LightGreen)//Color.FromArgb(205, 228, 225))
color2 = Color.MintCream;// Color.FromArgb(0, 0, 0, 0);
else
color2 = Color.LightGreen;//Color.FromArgb(205, 228, 225);
}
else
color2 = (Color)uGrdCutInfo.Rows[i - 1].Cells["SLABLENGTH"].Appearance.BackColor;
foreach (UltraGridCell cell in uGrdCutInfo.Rows[i].Cells)
cell.Appearance.BackColor = color2;//在生产用颜色区分
}
}
}
this.textBox1.Text = castNo;
this.comboBox3.Text = ultraRow.Cells["CAST_ID"].Value.ToString();
this.textBox3.Text = this.uGrdCutInfo.Rows.Count.ToString();
this.tbxLength.Text = this.uGrdCutInfo.Rows[0].Cells["SLABLENGTH"].Value.ToString();
this.tbxWidth.Text = this.uGrdCutInfo.Rows[0].Cells["SLABWIDTH"].Value.ToString();
this.tbxThick.Text = this.uGrdCutInfo.Rows[0].Cells["SLABHEIGHT"].Value.ToString();
float a = Convert.ToSingle(this.tbxLength.Text.Trim());
float b = Convert.ToSingle(this.tbxWidth.Text.Trim());
float c = Convert.ToSingle(this.tbxThick.Text.Trim());
if (this.uGrdCutInfo.Rows[0].Cells["BILLETQTY"].Value != null && Convert.ToDouble(this.uGrdCutInfo.Rows[0].Cells["BILLETQTY"].Value) > 0)
this.tbxWeight.Text = Convert.ToString(Convert.ToDouble(this.uGrdCutInfo.Rows[0].Cells["THEROYWEIGHT"].Value) / Convert.ToDouble(this.uGrdCutInfo.Rows[0].Cells["BILLETQTY"].Value));
else
tbxWeight.Text = Convert.ToString(Convert.ToDouble(this.uGrdCutInfo.Rows[0].Cells["THEROYWEIGHT"].Value) / Math.Round(a * b * c * 7.82 / 1000000000, 3));
}
catch (Exception ex)
{
string msg = ex.Message;
}
}
private void comboBox3_ValueMemberChanged(object sender, EventArgs e)
{
FrmMain.CCMN0 = comboBox3.Text;
}
private void comboBox3_TextChanged(object sender, EventArgs e)
{
//改变选定的铸机号
FrmMain.CCMN0 = comboBox3.Text;
}
///
/// 获取指定炉号的生产状态
///
///
///
private bool GetHeatState(string strHeatNo)
{
string strErr = "";
string strState = "";
bool blState = false;
DataSet ds = null;// (DataSet)ClientCommon._RemotingHelp.ExecuteMethod("lgJobMgt",
// "Core.LgMes.Server.lgJobMgt.classCutJob",
// "GetHeatState", new object[] { strHeatNo }, out strErr);
if (strErr == "")
{
if (ds != null && ds.Tables[0].Rows.Count > 0)
strState = ds.Tables[0].Rows[0]["Heat_state"].ToString();
if (strState == "08" || strState == "09")
blState = true;
}
return blState;
}
private void tbxLength_TextChanged(object sender, EventArgs e)
{
try
{
float a = Convert.ToSingle(this.tbxLength.Text.Trim());
float b = Convert.ToSingle(this.tbxWidth.Text.Trim());
float c = Convert.ToSingle(this.tbxThick.Text.Trim());
this.tbxWeight.Text = Convert.ToString(Math.Round(a * b * c * 7.82 / 1000000000, 3));
}
catch { }
}
private void bntSend_Click(object sender, EventArgs e)
{
UltraGridRow ultraRow = this.ultraGrid1.ActiveRow;
if (ultraRow == null)
MessageBox.Show("请选择做金相试样的炉号！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
else
{
frmSendJXY frmJxy = new frmSendJXY();
frmJxy.strHeatNO = ultraRow.Cells["HeatNo"].Value.ToString();
frmJxy.strSteelCode = ultraRow.Cells["SteelCode"].Value.ToString();
frmJxy.strSteel = ultraRow.Cells["AIM_GRADE_CODE"].Value.ToString();
frmJxy.strStationCode = ultraRow.Cells["CAST_ID"].Value.ToString();
frmJxy.strOptName = FrmMain.UserInfo.GetUserName();
frmJxy.Location = CStaticMethod.GetChildWindowLocation(frmJxy.Size);
frmJxy.ShowDialog();
}
}
}
}