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 CoreFS.CA06;
using Core.Mes.Client.Comm.Server;
using Core.Mes.Client.Comm.Control;
using com.steering.mes.zgmil.entity;
using Infragistics.Win.UltraWinGrid;
using Core.Mes.Client.Comm.Tool;
using Core.StlMes.Client.ZGMil.NodeResultQuery;
using Core.StlMes.Client.ZGMil.ResultConrtrol;
using Core.StlMes.Client.ZGMil.Entity;
using System.Net;
using Core.StlMes.Client.ZGMil.Common;
using Core.StlMes.Client.ZGMil.Popup;
using CoreFS.SA06;
namespace Core.StlMes.Client.ZGMil.Result
{
public partial class FrmStraighteningResult : FrmBase
{
#region 初始化
private Infragistics.Win.UltraWinGrid.UltraGrid _grid = null;
public Infragistics.Win.UltraWinGrid.UltraGrid Grid
{
get { return _grid; }
}
public FrmStraighteningResult()
{
InitializeComponent();
}
int PanelSizeFlag = 0;
RollingInfomation rf = new RollingInfomation();
FeedRowPlan QuertFeedplan = new FeedRowPlan();
MilPlan QueryMainPlan = new MilPlan();
FeedRowPlan Feedplan = new FeedRowPlan();
MilPlan MainPlan = new MilPlan();
SawResult FeedSawResult = new SawResult();
string PlanStatusQuery = "79";
string PlanStartStatusQuery = "00"; //查询结炉实绩起始状态
MilStraighteningResultEntity StraighteningResult = new MilStraighteningResultEntity();
private string ActiveJUDGE_STOVE_NO = null;//主计划活动行的判定炉号
private string ActiveStatus = null;////主计划活动行的状态
private string proPlanId = null;//轧管订单编号
private string gxPlanNo = null;//工序排产序号
private string lotNo = null;//生产批号
private string ActiveOFFLINE_FLAG = null;
private string ActiveResultNo = null;
private string WorkStand = "";//工作台
private string Departm = "";//部门
private string PlineCode = "";//产线
private string stoveno = "";
private string lotno = "";
private string Flage = "";//
MilStraighteningResultEntity temprstraght = new MilStraighteningResultEntity();//保存当前实绩类
private string offlinenode = "";
private string Shift = "";
private string Group = "";
private string _User = "";
private string _UserName = ""; //签名 姓名
private string _Url = ""; //签名 Url
private string _UserID = ""; //签名 签名ID
private string ChangeUserID = "";
private string beforeQualifiedNum = "";//上道工序合格支数
private string qualifiedNum = "";//该工序合格支数
private string scrapNum = "";//该工序废品支数
private string offineHas = "";//已下线支数
private string offineHead = "";//返线支数
protected override void OnLoad(EventArgs e)
{
base.OnLoad(e);
//取消卡片筛选
rollingInfomation1.UltraGrid4.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
rollingCard1.UltraGrid4.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
straighteningResult1.UltraGrid2.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
frmStraighteningResult11.UltraGrid4.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
frmStraighteningResult21.UltraGrid2.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
ultraGridPlan.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
ultraGrid_GHDL1.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
ultraGrid_GHDL2.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
ultraGrid_GHDL3.DisplayLayout.Override.AllowRowFiltering = Infragistics.Win.DefaultableBoolean.False;
//ChangeGridColor();
InitControl();
//PanelSizeFlag = 0;
//splitContainer2.SplitterDistance = 180;
foreach (UltraGridColumn ugc in ultraGridPlan.DisplayLayout.Bands[0].Columns)
{
ugc.SortIndicator = SortIndicator.Disabled;
}
}
protected override void OnShown(EventArgs e)
{
base.OnShown(e);
string hostname = Dns.GetHostName();
IPAddress ip = Dns.GetHostByName(hostname).AddressList[0];
NativeMethodNew na = new NativeMethodNew(this.ob);
WorkStand = na.GetOperateResult(ip.ToString(), "1");
if (!WorkStand.Contains("矫直"))
{
//MessageBox.Show("提示：该电脑不是矫直操作台电脑，不允许操作改界面", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
//this.Dispose();
//this.Close();
//return;
}
if (WorkStand.Contains("矫直") && WorkStand.Contains("1"))
{
offlinenode = "01";
}
if (WorkStand.Contains("矫直") && WorkStand.Contains("2"))
{
offlinenode = "02";
}
if (WorkStand.Contains("矫直") && WorkStand.Contains("3"))
{
offlinenode = "03";
}
Departm = UserInfo.GetDepartment();
PlineCode = na.GetPCode(Departm);//获取 用户 对应的产线
if (PlineCode.Equals("C009") || PlineCode.Equals("C012") || PlineCode.Equals("C017") || PlineCode.Equals("C072"))
{
this.rollingCard1.ChangCard();
}
PlanQuery();
//foreach (UltraGridRow ugr in ultraGridPlan.Rows)
//{
// ugr.Cells["JUDGE_NO"].Value = BaseMethod.getJudgeStoveNo(ugr.Cells["JUDGE_STOVE_NO"].Value.ToString());
//}
Shift = UserInfo.GetUserOrder();
Group = UserInfo.GetUserGroup();
Sign();
ShowShift();
}
private void ShowShift()
{
colShowShiftGroup1.Ob = this.ob;
colShowShiftGroup1.Group = this.UserInfo.GetUserGroup();
colShowShiftGroup1.Shift = this.UserInfo.GetUserOrder();
colShowShiftGroup1.ShowShift();
colShowShiftGroup1.Timer1.Enabled = true;
}
///
/// 初始化控件
///
public void InitControl()
{
if (chkLotNo.Checked)
{
txtLOT_NO.Enabled = true;
}
else
{
txtLOT_NO.Enabled = false;
}
if (chkHeatNo.Checked)
{
txtJudgeStoveNo.Enabled = true;
}
else
{
txtJudgeStoveNo.Enabled = false;
}
}
#endregion
///
/// 签名
///
private void Sign()
{
ColUserName col = new ColUserName();
col.StationId = "7";
col.PlineCode = PlineCode;
col.ColGroup = Group;
col.Ob = this.ob;
col.ShowDialog();
_UserID = col.getUserId();
_UserName = col.getUserName();
}
///
/// 按钮事件
///
///
///
public override void ToolBar_Click(object sender, string ToolbarKey)
{
switch (ToolbarKey)
{
case "Query":
PlanQuery();
break;
case "Save":
StraighteningSave();
break;
case "Node":
StraighteningNode();
break;
case "DoNodeBack":
NodeBack();
break;
case "NodeQuery":
NodeQuery();
break;
case "colchang":
colchang();
break;
case "DoChangeCancel":
ChangeShiftBack();
break;
case "DoPrint":
PrintResult();
break;
case "Dooffline":
Offline();
break;
case "Doofflinre2":
Offline2();
break;
case "Doofflinre3":
Offline3();
break;
case "ReLine1":
BackLine1();
break;
case "ReLine2":
BackLine2();
break;
case "ReLine3":
BackLine3();
break;
case "DoStart":
DoStart();
break;
case "DoStartBack":
StartBack();
break;
case "DoSign":
Sign();
break;
case "Close":
this.Dispose();
this.Close();
break;
}
}
#region 辅助事件方法及赋值
///
/// 修改IS_START名称
///
public void ChangeCellName()
{
if (ultraGridPlan.Rows.Count > 0)
{
NativeMethodNew na = new NativeMethodNew(this.ob);
foreach (UltraGridRow ugr in ultraGridPlan.Rows)
{
//String Judge_Stove_No = ugr.Cells["JUDGE_DTOVE_NO"].Value.ToString();
//if (na.isBegineNode(Judge_Stove_No, 0))
//{
// ugr.Appearance.BackColor = Color.YellowGreen;
//}
if (ugr.Cells["IS_START"].Value.ToString() != "未开始矫直" && ugr.Cells["IS_START"].Value.ToString() != "已开始矫直" && ugr.Cells["IS_START"].Value.ToString() != "已完成矫直")
{
switch (Convert.ToInt32(ugr.Cells["IS_START"].Value))
{
case 3:
ugr.Cells["IS_START"].Value = "未开始矫直";
break;
case 0:
ugr.Cells["IS_START"].Value = "已开始矫直";
break;
case 1:
ugr.Cells["IS_START"].Value = "已完成矫直";
break;
}
}
}
}
}
public void ChangeGridColor()
{
foreach (UltraGridRow ugr in ultraGridPlan.Rows)
{
if (ugr.Cells["IS_START"].Value.ToString() == "已完成矫直")
{
ugr.Appearance.BackColor = Color.YellowGreen;
}
}
if (ultraGrid_GHDL1.Rows.Count > 0)
{
foreach (UltraGridRow ugr in ultraGrid_GHDL1.Rows)
{
if (ugr != null)
{
switch (ugr.Cells["STATUS"].Value.ToString())
{
case "剔除":
ugr.Appearance.BackColor = Color.Yellow;
break;
}
switch (ugr.Cells["CHANGE_FLAG"].Value.ToString())
{
case "待接班确认":
ugr.Appearance.BackColor = Color.LightGreen;
break;
}
}
}
}
if (ultraGrid_GHDL2.Rows.Count > 0)
{
foreach (UltraGridRow ugr in ultraGrid_GHDL2.Rows)
{
if (ugr != null)
{
switch (ugr.Cells["STATUS"].Value.ToString())
{
case "剔除":
ugr.Appearance.BackColor = Color.Yellow;
break;
}
switch (ugr.Cells["CHANGE_FLAG"].Value.ToString())
{
case "待接班确认":
ugr.Appearance.BackColor = Color.LightGreen;
break;
}
}
}
}
if (ultraGrid_GHDL3.Rows.Count > 0)
{
foreach (UltraGridRow ugr in ultraGrid_GHDL3.Rows)
{
if (ugr != null)
{
switch (ugr.Cells["STATUS"].Value.ToString())
{
case "剔除":
ugr.Appearance.BackColor = Color.Yellow;
break;
}
switch (ugr.Cells["CHANGE_FLAG"].Value.ToString())
{
case "待接班确认":
ugr.Appearance.BackColor = Color.LightGreen;
break;
}
}
}
}
}
private void chkLotNo_CheckedChanged(object sender, EventArgs e)
{
this.txtLOT_NO.Enabled = this.chkLotNo.Checked;
}
private void chkHeatNo_CheckedChanged(object sender, EventArgs e)
{
if (this.chkHeatNo.Checked)
{
this.txtJudgeStoveNo.Enabled = true;
}
else
{
this.txtJudgeStoveNo.Enabled = false;
}
if (chkStatusQuery.Checked)
{
PlanStatusQuery = "99";
PlanStartStatusQuery = "80";
}
else
{
PlanStatusQuery = "79";
PlanStartStatusQuery = "00";
}
}
///
/// 流通卡赋值
///
///
public void RollingCardEditGrid(DataTable dt, string heatno)
{
if (dt.Rows.Count > 0)
{
//上料切前剔除支数
this.rollingCard1.Value.FeedScrapNum = dt.Rows[0]["SCRAP_FEED"].ToString();
//上料切前合格支数
this.rollingCard1.Value.FeedQualifiedNum = dt.Rows[0]["QUALIFIED_FEED"].ToString();
//上料剔除支数
this.rollingCard1.Value.FeedScrapDBNum = dt.Rows[0]["SCRAP_DBFEED"].ToString();
//上料合格支数
this.rollingCard1.Value.FeedQualifiedDBNum = dt.Rows[0]["QUALIFIED_DBFEED"].ToString();
//加热炉剔除支数
this.rollingCard1.Value.FurScrapNum = dt.Rows[0]["SCRAP_FUR"].ToString();
//加热炉合格支数
this.rollingCard1.Value.FurQualifiedNum = dt.Rows[0]["QUALIFIED_FUR"].ToString();
//穿孔剔除支数
this.rollingCard1.Value.PerScrapNum = dt.Rows[0]["SCRAP_PER"].ToString();
//穿孔合格支数
this.rollingCard1.Value.PerQualifiedNum = dt.Rows[0]["QUALIFIED_PER"].ToString();
//连轧剔除支数
this.rollingCard1.Value.RollingScrapNum = dt.Rows[0]["SCRAP_ROLLING"].ToString();
//连轧合格支数
this.rollingCard1.Value.RollingQualifiedNum = dt.Rows[0]["QUALIFIED_ROLLING"].ToString();
//再加热炉剔除支数
this.rollingCard1.Value.RefurScrapNum = dt.Rows[0]["SCRAP_REFUR"].ToString();
//再加热炉合格支数
this.rollingCard1.Value.RefurQualifiedNum = dt.Rows[0]["QUALIFIED_REFUR"].ToString();
//定径剔除支数
this.rollingCard1.Value.SizingScrapNum = dt.Rows[0]["SCRAP_SIZING"].ToString();
//定径合格支数
this.rollingCard1.Value.SizingQualifiedNum = dt.Rows[0]["QUALIFIED_SIZING"].ToString();
//分切前剔除支数
this.rollingCard1.Value.SawScrapNumBE = dt.Rows[0]["SCRAP_SAW_BE"].ToString();
//分切前合格支数
this.rollingCard1.Value.SawQualifiedNumBE = dt.Rows[0]["QUALIFIED_SAW_BE"].ToString();
//分切剔除支数
this.rollingCard1.Value.SawScrapNum = dt.Rows[0]["SCRAP_SAW"].ToString();
//分切合格支数
this.rollingCard1.Value.SawQualifiedNum = dt.Rows[0]["QUALIFIED_SAW"].ToString();
//矫直剔除支数
this.rollingCard1.Value.StraightScrapNum = dt.Rows[0]["SCRAP_STRAIGHT"].ToString();
//矫直合格支数
this.rollingCard1.Value.StraightQualifiedNum = dt.Rows[0]["QUALIFIED_STRAIGHT"].ToString();
//矫直下线支数
this.rollingCard1.Value.OfflineStraight = dt.Rows[0]["OFFLINE_STRAIGHT"].ToString();
//矫直返线支数
this.rollingCard1.Value.BacklineStraight = dt.Rows[0]["BACKLINE_STRAIGHT"].ToString();
//探伤剔除支数
this.rollingCard1.Value.TestingScrapNum = dt.Rows[0]["SCRAP_TESTING"].ToString();
//探伤合格支数
this.rollingCard1.Value.TestingQualifiedNum = dt.Rows[0]["QUALIFIED_TESTING"].ToString();
NativeMethodNew na = new NativeMethodNew(this.ob);
if (na.isBegineNode(heatno, 8) || na.isBegineNode(heatno, 9) || na.isBegineNode(heatno, 10))
{
//探伤下线支数
this.rollingCard1.Value.OfflineTesting = dt.Rows[0]["OFFLINE_TESTING"].ToString();
this.rollingCard1.Value.BacklineTesting = dt.Rows[0]["BACKLINE_TESTING"].ToString();
}
else
{
if (dt.Rows[0]["OFFLINE_TESTING"].ToString() == "0")
{
this.rollingCard1.Value.OfflineTesting = "";
this.rollingCard1.Value.BacklineTesting = "";
}
else
{
//探伤下线支数
this.rollingCard1.Value.OfflineTesting = dt.Rows[0]["OFFLINE_TESTING"].ToString();
this.rollingCard1.Value.BacklineTesting = dt.Rows[0]["BACKLINE_TESTING"].ToString();
}
}
this.rollingCard1.UpdateData();
}
else
{
this.rollingCard1.ClearData();
}
}
///
/// 流通卡赋值
///
///
public void RollingCardEditGrid1(DataTable dt, string heatno)
{
if (dt.Rows.Count > 0)
{
//矫直剔除支数
this.rollingCard1.Value.StraightScrapNum = dt.Rows[0]["SCRAP_STRAIGHT"].ToString();
//矫直合格支数
this.rollingCard1.Value.StraightQualifiedNum = dt.Rows[0]["QUALIFIED_STRAIGHT"].ToString();
//矫直下线支数
this.rollingCard1.Value.OfflineStraight = dt.Rows[0]["OFFLINE_STRAIGHT"].ToString();
//矫直返线支数
this.rollingCard1.Value.BacklineStraight = dt.Rows[0]["BACKLINE_STRAIGHT"].ToString();
//探伤剔除支数
this.rollingCard1.Value.TestingScrapNum = dt.Rows[0]["SCRAP_TESTING"].ToString();
//探伤合格支数
this.rollingCard1.Value.TestingQualifiedNum = dt.Rows[0]["QUALIFIED_TESTING"].ToString();
NativeMethodNew na = new NativeMethodNew(this.ob);
if (na.isBegineNode(heatno, 8) || na.isBegineNode(heatno, 9) || na.isBegineNode(heatno, 10))
{
//探伤下线支数
this.rollingCard1.Value.OfflineTesting = dt.Rows[0]["OFFLINE_TESTING"].ToString();
this.rollingCard1.Value.BacklineTesting = dt.Rows[0]["BACKLINE_TESTING"].ToString();
}
else
{
if (dt.Rows[0]["OFFLINE_TESTING"].ToString() == "0")
{
this.rollingCard1.Value.OfflineTesting = "";
this.rollingCard1.Value.BacklineTesting = "";
}
else
{
//探伤下线支数
this.rollingCard1.Value.OfflineTesting = dt.Rows[0]["OFFLINE_TESTING"].ToString();
this.rollingCard1.Value.BacklineTesting = dt.Rows[0]["BACKLINE_TESTING"].ToString();
}
}
this.rollingCard1.UpdateData();
}
else
{
this.rollingCard1.ClearData();
}
}
public void RollingCardClear()
{
//上料切前剔除支数
this.rollingCard1.Value.FeedScrapNum = "";
//上料切前合格支数
this.rollingCard1.Value.FeedQualifiedNum = "";
//上料剔除支数
this.rollingCard1.Value.FeedScrapDBNum = "";
//上料合格支数
this.rollingCard1.Value.FeedQualifiedDBNum = "";
//加热炉剔除支数
this.rollingCard1.Value.FurScrapNum = "";
//加热炉合格支数
this.rollingCard1.Value.FurQualifiedNum = "";
//穿孔剔除支数
this.rollingCard1.Value.PerScrapNum = "";
//穿孔合格支数
this.rollingCard1.Value.PerQualifiedNum = "";
//连轧剔除支数
this.rollingCard1.Value.RollingScrapNum = "";
//连轧合格支数
this.rollingCard1.Value.RollingQualifiedNum = "";
//再加热炉剔除支数
this.rollingCard1.Value.RefurScrapNum = "";
//再加热炉合格支数
this.rollingCard1.Value.RefurQualifiedNum = "";
//定径剔除支数
this.rollingCard1.Value.SizingScrapNum = "";
//定径合格支数
this.rollingCard1.Value.SizingQualifiedNum = "";
//分切前剔除支数
this.rollingCard1.Value.SawScrapNumBE = "";
//分切前合格支数
this.rollingCard1.Value.SawQualifiedNumBE = "";
//分切剔除支数
this.rollingCard1.Value.SawScrapNum = "";
//分切合格支数
this.rollingCard1.Value.SawQualifiedNum = "";
//矫直剔除支数
this.rollingCard1.Value.StraightScrapNum = "";
//矫直合格支数
this.rollingCard1.Value.StraightQualifiedNum = "";
//矫直下线支数
this.rollingCard1.Value.OfflineStraight = "";
//矫直返线支数
this.rollingCard1.Value.BacklineStraight = "";
//探伤剔除支数
this.rollingCard1.Value.TestingScrapNum = "";
//探伤合格支数
this.rollingCard1.Value.TestingQualifiedNum = "";
//探伤下线支数
this.rollingCard1.Value.OfflineTesting = "";
this.rollingCard1.Value.BacklineTesting = "";
this.rollingCard1.UpdateData();
}
///
/// 轧制信息Grid赋值
///
/// 轧制计划信息datatable
public void GridEdit(DataTable dt)
{
if (dt.Rows.Count > 0)
{
DataRow row1 = dt.Rows[0];
//熔炼炉号
this.rollingInfomation1.Value.StoveNo = row1["stove_no"].ToString();
//炉号
this.rollingInfomation1.Value.JudgeStoveNo = BaseMethod.getJudgeStoveNo(row1["judge_stove_no"].ToString());
//生产批号
this.rollingInfomation1.Value.LotNo = row1["lot_no"].ToString();
//工序合同号
this.rollingInfomation1.Value.ContractNo = row1["contract_no"].ToString();
//执行工艺号
this.rollingInfomation1.Value.ImpProcess = row1["imp_process"].ToString();
//执行工艺号路径
this.rollingInfomation1.Value.ImpProcessPath = row1["imp_process_path"].ToString();
//产线代码
this.rollingInfomation1.Value.PlineCode = row1["pline_code"].ToString();
//状态
this.rollingInfomation1.Value.Status = row1["STATUS"].ToString();
//监制
this.rollingInfomation1.Value.Producer = row1["producer"].ToString();
//工艺状态
this.rollingInfomation1.Value.ProcessStatus = row1["process_status"].ToString();
//单倍长
this.rollingInfomation1.Value.DbLength = row1["db_length"].ToString();
//单倍重
this.rollingInfomation1.Value.DbHeight = row1["db_height"].ToString();
//轧制长度
this.rollingInfomation1.Value.RollLength = row1["roll_length"].ToString();
//分切数
this.rollingInfomation1.Value.SawNum = row1["saw_num"].ToString();
//目标长度
this.rollingInfomation1.Value.TargetLength = row1["target_length"].ToString();
//最终用户
this.rollingInfomation1.Value.FinishUser = row1["finish_user"].ToString();
//目标库
this.rollingInfomation1.Value.TargetLiabrary = row1["target_liabrary"].ToString();
//品种
this.rollingInfomation1.Value.Varieties = row1["varieties"].ToString();
//成品规格
this.rollingInfomation1.Value.PipeSize = row1["pipe_size"].ToString();
//扣型
this.rollingInfomation1.Value.BuckleType = row1["buckle_type"].ToString();
//长度范围
this.rollingInfomation1.Value.LengthRange = row1["length_range"].ToString();
//轧管判定标准
this.rollingInfomation1.Value.RollStandrad = row1["roll_standrad"].ToString();
//断面
this.rollingInfomation1.Value.PipeSection = row1["pipe_section"].ToString();
//钢种代码
this.rollingInfomation1.Value.SteelCode = row1["steelcode"].ToString();
//钢种名称
this.rollingInfomation1.Value.SteelName = row1["steelname"].ToString();
//钢级代码
this.rollingInfomation1.Value.GradeCode = row1["gradecode"].ToString();
//钢级名称
this.rollingInfomation1.Value.GradeName = row1["gradename"].ToString();
//炼钢判定标准
this.rollingInfomation1.Value.SteelStandrad = row1["steel_standrad"].ToString();
//去向
this.rollingInfomation1.Value.Target = row1["target"].ToString();
//支
this.rollingInfomation1.Value.PlanNum = row1["BRANCH"].ToString();
//吨
this.rollingInfomation1.Value.PlanTon = row1["TON"].ToString();
//切损去向
this.rollingInfomation1.Value.CutTarget = row1["cut_target"].ToString();
//切损长度
this.rollingInfomation1.Value.CutLength = row1["cut_length"].ToString();
//切损重量
this.rollingInfomation1.Value.CutHeight = row1["CUT_WEIGHT"].ToString();
//倍尺数
this.rollingInfomation1.Value.DbNum = row1["DB_NUM"].ToString();
//标准类别代码
this.rollingInfomation1.Value.StdStyle = row1["STD_STYLE"].ToString();
//标准类别描述
this.rollingInfomation1.Value.StdStyleDesc = row1["STD_STYLE_DESC"].ToString();
//成品备注
this.rollingInfomation1.Value.ReMark = row1["ReMark"].ToString();
this.rollingInfomation1.UpdateData();
}
}
///
/// 流通卡赋值
///
public void GetRollingCard()
{
UltraGridRow ugr = ultraGridPlan.ActiveRow;
if (ugr != null)
{
string JudgeStoveNo = ugr.Cells["JUDGE_STOVE_NO"].Value.ToString();
DataTable dt = new DataTable();
if (PlineCode.Equals("C009") || PlineCode.Equals("C012") || PlineCode.Equals("C017"))
{
dt = ServerHelper.GetData("com.steering.mes.zgmil.coup.FeedSawResult.getRollingCard1", new object[] { JudgeStoveNo, proPlanId, gxPlanNo }, this.ob);
}
else
{
dt = ServerHelper.GetData("com.steering.mes.zgmil.coup.FeedSawResult.getRollingCard", new object[] { JudgeStoveNo, proPlanId, gxPlanNo }, this.ob);
}
RollingCardEditGrid(dt, JudgeStoveNo);
}
}
///
/// 流通卡赋值
///
public void GetRollingCard1()
{
UltraGridRow ugr = ultraGridPlan.ActiveRow;
if (ugr != null)
{
string JudgeStoveNo = ugr.Cells["JUDGE_STOVE_NO"].Value.ToString();
DataTable dt = new DataTable();
if (PlineCode.Equals("C009") || PlineCode.Equals("C012") || PlineCode.Equals("C017"))
{
dt = ServerHelper.GetData("com.steering.mes.zgmil.coup.FeedSawResult.getRollingCard1BackLine", new object[] { JudgeStoveNo, proPlanId, gxPlanNo }, this.ob);
}
else
{
dt = ServerHelper.GetData("com.steering.mes.zgmil.coup.FeedSawResult.getRollingStaCard1", new object[] { JudgeStoveNo, proPlanId, gxPlanNo }, this.ob);
}
RollingCardClear();
RollingCardEditGrid1(dt, JudgeStoveNo);
}
}
///
/// 查询跟踪记录信息
///
public void ultraGridTC()
{
if (this.dtPlan.Rows.Count > 0)
{
this.dtTC1.Rows.Clear();
this.dtTC2.Rows.Clear();
this.dtTC3.Rows.Clear();
UltraGridRow ugr = ultraGridPlan.ActiveRow;
string flagstatus = "0";
if (this.ActiveStatus.Equals("已完成矫直"))
{
flagstatus = "1";
}
//UltraGridRow ugr = e.Row;
if (ugr != null)
{
string HeatNo = ugr.Cells["JUDGE_STOVE_NO"].Value.ToString();
MainPlan.JudgeStoveNo = HeatNo;
DataTable dtMP1 = ServerHelper.GetData("com.steering.mes.zgmil.coup.FrmStraighteningResult.getSingleMainPlanTC1", new object[] { MainPlan, flagstatus }, this.ob);
DataTable dtMP2 = ServerHelper.GetData("com.steering.mes.zgmil.coup.FrmStraighteningResult.getSingleMainPlanTC2", new object[] { MainPlan, flagstatus }, this.ob);
DataTable dtMP3 = ServerHelper.GetData("com.steering.mes.zgmil.coup.FrmStraighteningResult.getSingleMainPlanTC3", new object[] { MainPlan, flagstatus }, this.ob);
if (dtMP1.Rows.Count > 0)
{
//this.ultraTabControl2
this.ultraTabControl2.Tabs[0].Visible = true;
if (this.ultraTabControl1.Tabs[1].Visible == true)
{
this.frmStraighteningResult11.Using1();
}
GridHelper.CopyDataToDatatable(ref dtMP1, ref this.dtTC1, true);
//ultraGrid_GHDL1.DisplayLayout.Bands[0].PerformAutoResizeColumns(true, PerformAutoSizeType.AllRowsInBand);
if (ultraGrid_GHDL1.Rows.Count > 0)
{
foreach (UltraGridRow ugr1 in ultraGrid_GHDL1.Rows)
{
ugr1.Cells["SCRAP_SLAB"].Value = "剔除钢管";
ugr1.Cells["DELBACK"].Value = "剔料回退";
ugr1.Cells["ChangShift"].Value = "交班操作";
ugr1.Cells["BTNCHANGECOM"].Value = "接班操作";
}
}
}
else
{
this.ultraTabControl2.Tabs[0].Visible = false;
if (this.ultraTabControl1.Tabs[1].Visible == true)
{
this.frmStraighteningResult11.NoUsing1();
}
}
if (dtMP2.Rows.Count > 0)
{
this.ultraTabControl2.Tabs[1].Visible = true;
if (this.ultraTabControl1.Tabs[1].Visible == true)
{
this.frmStraighteningResult11.Using2();
}
GridHelper.CopyDataToDatatable(ref dtMP2, ref this.dtTC2, true);
//ultraGrid_GHDL2.DisplayLayout.Bands[0].PerformAutoResizeColumns(true, PerformAutoSizeType.AllRowsInBand);
if (ultraGrid_GHDL2.Rows.Count > 0)
{
foreach (UltraGridRow ugr1 in ultraGrid_GHDL2.Rows)
{
ugr1.Cells["SCRAP_SLAB"].Value = "剔除钢管";
ugr1.Cells["DELBACK"].Value = "剔料回退";
ugr1.Cells["ChangShift"].Value = "交班操作";
ugr1.Cells["BTNCHANGECOM"].Value = "接班操作";
}
}
}
else
{
this.ultraTabControl2.Tabs[1].Visible = false;
if (this.ultraTabControl1.Tabs[1].Visible == true)
{
this.frmStraighteningResult11.NoUsing2();
}
}
if (dtMP3.Rows.Count > 0)
{
this.ultraTabControl2.Tabs[2].Visible = true;
GridHelper.CopyDataToDatatable(ref dtMP3, ref this.dtTC3, true);
//ultraGrid_GHDL3.DisplayLayout.Bands[0].PerformAutoResizeColumns(true, PerformAutoSizeType.AllRowsInBand);
if (ultraGrid_GHDL3.Rows.Count > 0)
{
foreach (UltraGridRow ugr1 in ultraGrid_GHDL3.Rows)
{
ugr1.Cells["SCRAP_SLAB"].Value = "剔除钢管";
ugr1.Cells["DELBACK"].Value = "剔料回退";
ugr1.Cells["ChangShift"].Value = "交班操作";
ugr1.Cells["BTNCHANGECOM"].Value = "接班操作";
}
}
}
else
{
this.ultraTabControl2.Tabs[2].Visible = false;
}
ChangeGridColor();
}
}
}
///
/// 更新矫直实绩
///
///
///
public void GetStraightResult(string heatNo, string PliceCode)
{
StraighteningResult.Clear();
string strheatno = heatNo;
string factoryId = PliceCode;
DataTable dtResult = ServerHelper.GetData("com.steering.mes.zgmil.coup.FrmStraighteningResult.getPerResult", new object[] { strheatno, proPlanId, gxPlanNo }, this.ob);
if (dtResult.Rows.Count > 0)
{
//获取表里相应的字段值到类中
StraighteningResult = NativeMethod.GetTableToEntity(dtResult, StraighteningResult);
if (factoryId == "C010")//168三个矫直台
{
ultraTabControl1.Tabs[0].Visible = true;
ultraTabControl1.Tabs[1].Visible = false;
ultraTabControl1.Tabs[2].Visible = false;
//ultraTabControl2.Tabs[0].Visible = true;
//ultraTabControl2.Tabs[1].Visible = true;
//ultraTabControl2.Tabs[2].Visible = true;
//设置168机组控件（straighteningResult1）值
this.straighteningResult1.Value = StraighteningResult;
if (WorkStand.Contains("矫直") && WorkStand.Contains("1"))
{
//this.straighteningResult1.NoUsing2();
//this.straighteningResult1.NoUsing3();
Flage = "1";
}
if (WorkStand.Contains("矫直") && WorkStand.Contains("2"))
{
//this.straighteningResult1.NoUsing1();
//this.straighteningResult1.NoUsing3();
Flage = "2";
}
if (WorkStand.Contains("矫直") && WorkStand.Contains("3"))
{
//this.straighteningResult1.NoUsing1();
//this.straighteningResult1.NoUsing2();
Flage = "3";
}
}
else
{
if (factoryId == "C017")//460两个矫直台
{
ultraTabControl1.Tabs[0].Visible = false;
ultraTabControl1.Tabs[1].Visible = false;
ultraTabControl1.Tabs[2].Visible = true;
//ultraTabControl1.Tabs[0].Visible = false;
//ultraTabControl1.Tabs[1].Visible = true;
//ultraTabControl1.Tabs[2].Visible = false;
//ultraTabControl2.Tabs[0].Visible = true;
//ultraTabControl2.Tabs[1].Visible = true;
//ultraTabControl2.Tabs[2].Visible = false;
// 设置460机组控件（frmStraighteningResult21）值
this.frmStraighteningResult21.Value = StraighteningResult;
//this.frmStraighteningResult11.Value = StraighteningResult;
if (WorkStand.Contains("矫直") && WorkStand.Contains("1"))
{
//this.frmStraighteningResult21.NoUsing2();
Flage = "1";
}
if (WorkStand.Contains("矫直") && WorkStand.Contains("2"))
{
//this.frmStraighteningResult21.NoUsing1();
Flage = "2";
}
}
else//2 个矫直台
{
ultraTabControl1.Tabs[0].Visible = false;
ultraTabControl1.Tabs[1].Visible = true;
ultraTabControl1.Tabs[2].Visible = false;
//ultraTabControl2.Tabs[0].Visible = true;
//ultraTabControl2.Tabs[1].Visible = true;
//ultraTabControl2.Tabs[2].Visible = false;
// 设置其他机组控件值
this.frmStraighteningResult11.Value = StraighteningResult;
if (WorkStand.Contains("矫直") && WorkStand.Contains("1"))
{
//this.frmStraighteningResult11.NoUsing2();
Flage = "1";
}
if (WorkStand.Contains("矫直") && WorkStand.Contains("2"))
{
//this.frmStraighteningResult11.NoUsing1();
Flage = "2";
}
}
}
}
else
{
this.straighteningResult1.Value = StraighteningResult;
this.frmStraighteningResult21.Value = StraighteningResult;
this.frmStraighteningResult11.Value = StraighteningResult;
}
}
#endregion
#region 事件方法
///
/// 主计划查询
///
public void PlanQuery()
{
string PrimaKey = "";
UltraGridRow ugr = this.ultraGridPlan.ActiveRow;
if (ugr != null)
{
PrimaKey = ugr.Cells["JUDGE_STOVE_NO"].Value.ToString();
}
if (chkHeatNo.Checked == true)
{
if (this.txtJudgeStoveNo.Text == "")
{
MessageBox.Show("请输入炉号!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
else
{
QueryMainPlan.JudgeStoveNo = this.txtJudgeStoveNo.Text;
}
}
else
{
QueryMainPlan.JudgeStoveNo = "";
}
if (chkLotNo.Checked == true)
{
if (this.txtLOT_NO.Text == "")
{
MessageBox.Show("请输入生产批号!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
else
{
QueryMainPlan.LotNo = this.txtLOT_NO.Text;
}
}
else
{
QueryMainPlan.LotNo = "";
}
dtPlan.Rows.Clear();
//ChangeGridColor();
//查询主表记录
QueryMainPlan.PlineCode = PlineCode;
QueryMainPlan.Status = PlanStatusQuery;
QueryMainPlan.StartStatus = PlanStartStatusQuery;
DataTable dt = ServerHelper.GetData("com.steering.mes.zgmil.coup.FeedSawResult.getSingleMainPlan", new object[] { QueryMainPlan, 8 }, this.ob);
if (dt.Rows.Count == 0)
{
MessageBox.Show("未查询到匹配的数据，请重新查询！", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
else
{
GridHelper.CopyDataToDatatable(ref dt, ref dtPlan, true);
//ultraGridPlan.DisplayLayout.Bands[0].PerformAutoResizeColumns(true, PerformAutoSizeType.AllRowsInBand);
ChangeCellName();
ChangeGridColor();
//this.ultraGridPlan.ActiveRow = null;
if (ugr != null)
{
foreach (UltraGridRow ugr1 in ultraGridPlan.Rows)
{
ugr1.Cells["JUDGE_NO"].Value = BaseMethod.getJudgeStoveNo(ugr1.Cells["JUDGE_STOVE_NO"].Value.ToString());
if (ugr1.Cells["JUDGE_STOVE_NO"].Value.ToString() == PrimaKey)
{
this.ultraGridPlan.ActiveRow = ugr1;
}
}
}
}
}
private String doQueryJugeNoStaus(string resultNo, string jugeNo, string plineCode)
{
string staus = "3";
DataTable ds = ServerHelper.GetData("com.steering.mes.zgmil.coup.EddyCurrentTestingResult.doQueryResultStaus", new object[] { resultNo, jugeNo, plineCode, "6", proPlanId, gxPlanNo }, ob);
if (ds.Rows.Count > 0)
{
staus = ds.Rows[0]["NODE_FUR_FLAG"].ToString();
}
return staus;
}
///
/// 主表单击事件
///
///
///
private void ultraGridPlan_AfterRowActivate(object sender, EventArgs e)
{
if (this.dtPlan.Rows.Count > 0)
{
UltraGridRow ugr = ultraGridPlan.ActiveRow;
//UltraGridRow ugr = e.Row;
if (ugr != null)
{
//查询主计划信息
string HeatNo = ugr.Cells["JUDGE_STOVE_NO"].Value.ToString();
string resultNo = ugr.Cells["ID"].Value.ToString();
proPlanId = ugr.Cells["PRO_PLAN_ID"].Value.ToString();
gxPlanNo = ugr.Cells["GX_PLAN_NO"].Value.ToString();
lotNo = ugr.Cells["LOT_NO"].Value.ToString();
MainPlan.JudgeStoveNo = HeatNo;
MainPlan.ProPlanId = proPlanId;
MainPlan.GxPlanNo = gxPlanNo;
ActiveJUDGE_STOVE_NO = HeatNo;
//string Status = ugr.Cells["IS_START"].Value.ToString();
string Status = doQueryJugeNoStaus(resultNo, HeatNo,PlineCode);
ActiveStatus = Status;
string PCode = ugr.Cells["Pline_Code"].Value.ToString();
PlineCode = PCode;
DataTable dtMP = ServerHelper.GetData("com.steering.mes.zgmil.coup.FeedSawResult.getSingleMainPlanForHeatNo", new object[] { MainPlan }, this.ob);
if (dtMP.Rows.Count > 0)
{
ActiveResultNo = dtMP.Rows[0]["ID"].ToString();
ActiveOFFLINE_FLAG = dtMP.Rows[0]["OFFLINE_FLAG"].ToString();
if (dtMP.Rows[0]["PLINE_CODE"].ToString() == "C010")
{
ultraTabControl1.Tabs[0].Visible = true;
ultraTabControl1.Tabs[1].Visible = false;
ultraTabControl1.Tabs[2].Visible = false;
}
else
{
if (dtMP.Rows[0]["PLINE_CODE"].ToString() == "C017")
{
ultraTabControl1.Tabs[0].Visible = false;
ultraTabControl1.Tabs[1].Visible = false;
ultraTabControl1.Tabs[2].Visible = true;
}
else
{
ultraTabControl1.Tabs[0].Visible = false;
ultraTabControl1.Tabs[1].Visible = true;
ultraTabControl1.Tabs[2].Visible = false;
}
}
PlineCode = dtMP.Rows[0]["PLINE_CODE"].ToString();
GridEdit(dtMP); //轧制计划信息
this.stoveno = dtMP.Rows[0]["STOVE_NO"].ToString();
this.lotno = dtMP.Rows[0]["LOT_NO"].ToString();
}
if (Status != "3")//查询跟踪记录表
{
ultraGridTC();
}
else
{
dtTC1.Rows.Clear();
dtTC2.Rows.Clear();
dtTC3.Rows.Clear();
}
DataTable ds = ServerHelper.GetData("com.steering.mes.zgmil.coup.FrmStraighteningResult.getSingePlanFlag", new object[] { ActiveJUDGE_STOVE_NO, proPlanId, gxPlanNo }, ob);
GetStraightResult(HeatNo, PlineCode);//更新实绩
if (ds.Rows[0]["BACK_PLAN_FLAG"].ToString().Equals("7"))
{
GetRollingCard1();//更新流通卡
}
else
{
GetRollingCard();//更新流通卡
}
ChangeGridColor();
if (Status == "3" || Status == "1")//查询跟踪记录表
{
return;
}
UltraGridRow ugr_plan = this.ultraGridPlan.ActiveRow;
UltraGridRow ugr_roll = this.rollingCard1.UltraGrid4.Rows[0];
string JudgeStoveNo = ugr_plan.Cells["JUDGE_STOVE_NO"].Value.ToString();
Status = ugr_plan.Cells["IS_START"].Value.ToString();
//查看结炉标识
DataTable dtFlag = ServerHelper.GetData("com.steering.mes.zgmil.coup.FrmStraighteningResult.GetSingleJRLResult", new object[] { JudgeStoveNo, proPlanId, gxPlanNo }, this.ob);
if (dtFlag.Rows.Count > 0)
{
if (string.IsNullOrEmpty(dtFlag.Rows[0]["NODE_FUR_FLAG"].ToString()))
{
//MessageBox.Show("炉号【" + JudgeStoveNo + "】未开始分切，不允许结炉", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
if (dtFlag.Rows[0]["NODE_FUR_FLAG"].ToString() != "1")
{
//MessageBox.Show("炉号【" + JudgeStoveNo + "】不能结炉，分切未完成。", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
}
else
{
return;
}
StraighteningResult.Clear();
if (PlineCode == "C010")
{
this.straighteningResult1.UltraGrid2.UpdateData();
StraighteningResult = NativeMethod.GetUltraGridToEntityNEW(this.straighteningResult1.UltraGrid2, StraighteningResult);
int i = 0; int j = 0; int k = 0;
if (ultraGrid_GHDL1.Rows.Count > 0)
{
foreach (UltraGridRow ugr1 in ultraGrid_GHDL1.Rows)
{
if (!string.IsNullOrEmpty(ugr1.Cells["MAT_NO"].Value.ToString()))
{
i = i + 1;
}
}
}
if (ultraGrid_GHDL2.Rows.Count > 0)
{
foreach (UltraGridRow ugr1 in ultraGrid_GHDL2.Rows)
{
if (!string.IsNullOrEmpty(ugr1.Cells["MAT_NO"].Value.ToString()))
{
j = j + 1;
}
}
}
if (ultraGrid_GHDL3.Rows.Count > 0)
{
foreach (UltraGridRow ugr1 in ultraGrid_GHDL3.Rows)
{
if (!string.IsNullOrEmpty(ugr1.Cells["MAT_NO"].Value.ToString()))
{
k = k + 1;
}
}
}
StraighteningResult.QualifiedNum1 = i - int.Parse(StraighteningResult.ScrapNum1.ToString());
StraighteningResult.QualifiedNum2 = j - int.Parse(StraighteningResult.ScrapNum2.ToString());
StraighteningResult.QualifiedNum3 = k - int.Parse(StraighteningResult.ScrapNum3.ToString());
}
else
{
if (PlineCode == "C017")
{
this.frmStraighteningResult21.UltraGrid2.UpdateData();
StraighteningResult = NativeMethod.GetUltraGridToEntityNEW(this.frmStraighteningResult21.UltraGrid2, StraighteningResult);
int i = 0; int j = 0; int k = 0;
if (ultraGrid_GHDL1.Rows.Count > 0)
{
foreach (UltraGridRow ugr1 in ultraGrid_GHDL1.Rows)
{
if (!string.IsNullOrEmpty(ugr1.Cells["MAT_NO"].Value.ToString()))
{
i = i + 1;
}
}
}
if (ultraGrid_GHDL2.Rows.Count > 0)
{
foreach (UltraGridRow ugr1 in ultraGrid_GHDL2.Rows)
{
if (!string.IsNullOrEmpty(ugr1.Cells["MAT_NO"].Value.ToString()))
{
j = j + 1;
}
}
}
StraighteningResult.QualifiedNum1 = i - int.Parse(StraighteningResult.ScrapNum1.ToString());
StraighteningResult.QualifiedNum2 = j - int.Parse(StraighteningResult.ScrapNum2.ToString());
}
else
{
this.frmStraighteningResult11.UltraGrid4.UpdateData();
StraighteningResult = NativeMethod.GetUltraGridToEntityNEW(this.frmStraighteningResult11.UltraGrid4, StraighteningResult);
int i = 0; int j = 0; int k = 0;
if (ultraGrid_GHDL1.Rows.Count > 0)
{
foreach (UltraGridRow ugr1 in ultraGrid_GHDL1.Rows)
{
if (!string.IsNullOrEmpty(ugr1.Cells["MAT_NO"].Value.ToString()))
{
i = i + 1;
}
}
}
if (ultraGrid_GHDL2.Rows.Count > 0)
{
foreach (UltraGridRow ugr1 in ultraGrid_GHDL2.Rows)
{
if (!string.IsNullOrEmpty(ugr1.Cells["MAT_NO"].Value.ToString()))
{
j = j + 1;
}
}
}
StraighteningResult.QualifiedNum1 = i - int.Parse(StraighteningResult.ScrapNum1.ToString());
StraighteningResult.QualifiedNum2 = j - int.Parse(StraighteningResult.ScrapNum2.ToString());
}
}
if (ds.Rows[0]["BACK_PLAN_FLAG"].ToString().Equals("7"))
{
StraighteningResult.InMatNum = ds.Rows[0]["BRANCH"].ToString();
if (int.Parse(StraighteningResult.InMatNum.ToString()) >= int.Parse(ugr_roll.Cells["ScrapNum11"].Value.ToString()))
{
StraighteningResult.QualifiedNum = int.Parse(StraighteningResult.InMatNum.ToString()) - int.Parse(this.rollingCard1.Value.OfflineStraight.ToString2()) - int.Parse(this.rollingCard1.Value.StraightScrapNum.ToString2());
}
}
else
{
if (!string.IsNullOrEmpty(ugr_roll.Cells["QualifiedNum10"].Value.ToString()))
{
//来料支数
StraighteningResult.InMatNum = ugr_roll.Cells["QualifiedNum10"].Value.ToString();
}
if (int.Parse(StraighteningResult.InMatNum.ToString()) > int.Parse(ugr_roll.Cells["ScrapNum11"].Value.ToString()))
{
StraighteningResult.QualifiedNum = int.Parse(StraighteningResult.InMatNum.ToString()) - int.Parse(this.rollingCard1.Value.OfflineStraight.ToString2()) - int.Parse(this.rollingCard1.Value.StraightScrapNum.ToString2());
}
}
//else
//{
// MessageBox.Show("存在上一道工序已经剔除的管坯在本道工序也剔除了，请回退后再进行结炉操作", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
// return;
//}
//合格吨
double DBHeight = 0;
double BurnningRate = 0;
double BurnningRate1 = 0;
double DBNum = 1;
NativeMethodNew na = new NativeMethodNew(this.ob);
string JudgeStoveNotemp = BaseMethod.getJudgeStoveNo(JudgeStoveNo) + "-01";
double percent = na.GetLengthPercent(JudgeStoveNotemp, this.ob, 0);
if (percent == 100.0)
{
MessageBox.Show("炉号：【" + JudgeStoveNo + "】尚未开始分切，不允许结炉", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
DataTable dtDBH = ServerHelper.GetData("com.steering.mes.zgmil.coup.FeedSawResult.getDbHeight", new object[] { JudgeStoveNo, ActiveResultNo, proPlanId, gxPlanNo }, this.ob);
if (dtDBH.Rows.Count > 0)
{
if (!string.IsNullOrEmpty(dtDBH.Rows[0]["DB_HEIGHT"].ToString()))
{
DBHeight = double.Parse(dtDBH.Rows[0]["DB_HEIGHT"].ToString());
}
if (!string.IsNullOrEmpty(dtDBH.Rows[0]["BURNNING_RATE"].ToString()))
{
BurnningRate = double.Parse(dtDBH.Rows[0]["BURNNING_RATE"].ToString());
}
if (!string.IsNullOrEmpty(dtDBH.Rows[0]["BURNINGRATE"].ToString()))
{
BurnningRate1 = double.Parse(dtDBH.Rows[0]["BURNINGRATE"].ToString());
}
if (!string.IsNullOrEmpty(dtDBH.Rows[0]["DB_NUM"].ToString()))
{
DBNum = double.Parse(dtDBH.Rows[0]["DB_NUM"].ToString());
}
}
//分产线 是否经过再加热炉
if (this.PlineCode == "C009" || PlineCode == "C012" || PlineCode == "C017")
{
double temp = DBHeight * (1 - (BurnningRate / 100));
double tempnum = double.Parse(StraighteningResult.QualifiedNum.ToString());
StraighteningResult.QaTon = temp * percent / 100 * tempnum;
}
else
{
double temp = DBHeight * (1 - (BurnningRate / 100)) * (1 - (BurnningRate1 / 100));
double tempnum = double.Parse(StraighteningResult.QualifiedNum.ToString());
StraighteningResult.QaTon = temp * percent / 100 * tempnum;
}
StraighteningResult.JudgeStoveNo = JudgeStoveNo;
StraighteningResult.NodeFurFlag = "1";
StraighteningResult.ColGroup = UserInfo.GetUserGroup();
StraighteningResult.ColShift = UserInfo.GetUserOrder();
StraighteningResult.ColUser = UserInfo.GetUserName();
StraighteningResult.GxPlanNo = gxPlanNo;
StraighteningResult.ProPlanId = proPlanId;
int countafter = ServerHelper.SetData("com.steering.mes.zgmil.coup.FrmStraighteningResult.Qunum", new object[] { StraighteningResult }, this.ob);
}
}
}
///
/// 判断是否能开始当前炉次
///
///
private bool IsStart()
{
bool Start = true;
foreach (UltraGridRow ugr in ultraGridPlan.Rows)
{
if (ugr.Cells["IS_START"].Value.ToString() == "已开始矫直")
{
MessageBox.Show("炉号【" + ugr.Cells["JUDGE_STOVE_NO"].Value.ToString() + "】正在矫直，不能两炉同时开始矫直", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
Start = false;
}
}
return Start;
}
///
/// 双击上料事件
///
///
///
// private void ultraGridPlan_DoubleClickRow(object sender, DoubleClickRowEventArgs e)
private void DoStart()
{
if (ultraGridPlan.Rows.Count > 0)
{
//if (!IsStart())
//{
// return;
//}
UltraGridRow ugr = ultraGridPlan.ActiveRow;
if (ugr != null)
{
string HeatNo = ugr.Cells["JUDGE_STOVE_NO"].Value.ToString();
ActiveJUDGE_STOVE_NO = HeatNo;
MainPlan.JudgeStoveNo = HeatNo;
//string Status = ugr.Cells["IS_START"].Value.ToString();
string ResultNo = ugr.Cells["ID"].Value.ToString();
string Status = doQueryJugeNoStaus(ResultNo, HeatNo,PlineCode);
ActiveStatus = Status;
if (Status == "1")
{
MessageBox.Show("炉号：【" + HeatNo + "】已完成定径，不允许再次开始定径操作！", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
PlineCode = ugr.Cells["Pline_Code"].Value.ToString();
StraighteningResult.Clear();
if (Status == "0")
{
MessageBox.Show("矫直工序正在进行，无法进行再次矫直!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
if (temprstraght != null)
{
StraighteningResult = NativeMethod.GetEntityToEntity(StraighteningResult, temprstraght);
StraighteningResult.ChangeNum = "";
StraighteningResult.InMatNum = "";
StraighteningResult.QualifiedNum = "";
StraighteningResult.QualifiedNum1 = "";
StraighteningResult.QualifiedNum2 = "";
StraighteningResult.QualifiedNum3 = "";
StraighteningResult.Remark = "";
StraighteningResult.ScrapNum = "";
StraighteningResult.ScrapNum1 = "";
StraighteningResult.ScrapNum2 = "";
StraighteningResult.ScrapNum3 = "";
StraighteningResult.SootBlowingTime = "";
StraighteningResult.StartTime = "";
StraighteningResult.EndTime = "";
}
DataTable dtMP = ServerHelper.GetData("com.steering.mes.zgmil.coup.FeedSawResult.getSingleMainPlanForHeatNo", new object[] { MainPlan }, this.ob);
ActiveOFFLINE_FLAG = dtMP.Rows[0]["OFFLINE_FLAG"].ToString();
GridEdit(dtMP); //轧制计划信息
ActiveResultNo = dtMP.Rows[0]["ID"].ToString();
this.stoveno = dtMP.Rows[0]["STOVE_NO"].ToString();
this.lotno = dtMP.Rows[0]["LOT_NO"].ToString();
string PLineCode = dtMP.Rows[0]["PLINE_CODE"].ToString();
string LotNo = dtMP.Rows[0]["LOT_NO"].ToString();
string StoveNo = dtMP.Rows[0]["STOVE_NO"].ToString();
string Judge_stove_no = dtMP.Rows[0]["judge_stove_no"].ToString();
StraighteningResult.LotNo = LotNo;
StraighteningResult.ResultNo = ResultNo;
StraighteningResult.StoveNo = StoveNo;
StraighteningResult.PlineCode = PLineCode;
StraighteningResult.JudgeStoveNo = Judge_stove_no;
StraighteningResult.ColMode = "0";
StraighteningResult.ColGroup = UserInfo.GetUserGroup();
StraighteningResult.ColShift = UserInfo.GetUserOrder();
StraighteningResult.ColUser = UserInfo.GetUserName();
StraighteningResult.ProPlanId = proPlanId;
StraighteningResult.GxPlanNo = gxPlanNo;
//修改主表状态，插入矫直实绩
int count = ServerHelper.SetData("com.steering.mes.zgmil.coup.FrmStraighteningResult.UpdateStraighteningStatue", new object[] { StraighteningResult }, this.ob);
if (count > 0)
{
NativeMethodNew na = new NativeMethodNew(this.ob);
na.InsertSTAferDoubleClick(HeatNo, 7, "0", proPlanId, gxPlanNo);
DataTable dt = ServerHelper.GetData("com.steering.mes.zgmil.coup.FeedSawResult.getSingleMainPlan", new object[] { QueryMainPlan, 8 }, this.ob);
GridHelper.CopyDataToDatatable(ref dt, ref dtPlan, true);
//ultraGridPlan.DisplayLayout.Bands[0].PerformAutoResizeColumns(true, PerformAutoSizeType.AllRowsInBand);
ChangeCellName();
foreach (UltraGridRow ugr1 in this.ultraGridPlan.Rows)
{
ugr1.Cells["JUDGE_NO"].Value = BaseMethod.getJudgeStoveNo(ugr1.Cells["JUDGE_STOVE_NO"].Value.ToString());
if (ugr1.Cells["JUDGE_STOVE_NO"].Value.ToString() == HeatNo)
{
ultraGridPlan.ActiveRow = ugr1;
}
}
}
}
}
}
///
/// 开始回退
///
private void StartBack()
{
if (ultraGridPlan.Rows.Count > 0)
{
if (this.ultraGridPlan.ActiveRow == null)
{
MessageBox.Show("请选择需要回退的炉号！！！");
return;
}
UltraGridRow ugr = ultraGridPlan.ActiveRow;
string JudgeStoveNo = ugr.Cells["JUDGE_STOVE_NO"].Value.ToString();
string ResultNo = ugr.Cells["ID"].Value.ToString();
//string StartStatus = ugr.Cells["IS_START"].Value.ToString();
string StartStatus = doQueryJugeNoStaus(ResultNo, JudgeStoveNo,PlineCode);
if (StartStatus == "1")
{
MessageBox.Show("炉号【" + BaseMethod.getJudgeStoveNo(JudgeStoveNo) + "】已结炉，不能入炉回退！！！！");
return;
}
if (StartStatus == "3")
{
MessageBox.Show("炉号【" + BaseMethod.getJudgeStoveNo(JudgeStoveNo) + "】未开始入炉，不能入炉回退！！！！");
return;
}
int count = ServerHelper.SetData("com.steering.mes.zgmil.coup.FeedSawResult.startBack", new object[] { JudgeStoveNo, ResultNo, 7, PlineCode, proPlanId, gxPlanNo }, this.ob);
ultraGridTC();
ChangeGridColor();
ChangeCellName();
PlanQuery();
}
}
///
/// 保存跟踪记录表备注
///
private void ultraGridMatSeq_AfterCellUpdate(object sender, CellEventArgs e)
{
UltraGridRow ugr = null;
string heatno = "";
int seq = 0;
string remark = "";
if (ultraTabControl2.Tabs[0].Visible == true)
{
ugr = ultraGrid_GHDL1.ActiveRow;
}
if (ultraTabControl2.Tabs[1].Visible == true)
{
ugr = ultraGrid_GHDL2.ActiveRow;
}
if (ultraTabControl2.Tabs[2].Visible == true)
{
ugr = ultraGrid_GHDL3.ActiveRow;
}
if (e.Cell.Column.Key == "REMARK")
{
if (ugr == null)
{
//MessageBox.Show("您未选择任何管号队列数据，请重新选择后再进行保存操作", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
heatno = ugr.Cells["JUDGE_STOVE_NO"].Value.ToString();
seq = Convert.ToInt16(ugr.Cells["SEQ"].Value.ToString());
if (!string.IsNullOrEmpty(ugr.Cells["REMARK"].Value.ToString()))
{
remark = ugr.Cells["REMARK"].Value.ToString();
}
else
{
remark = "";
}
NativeMethodNew na = new NativeMethodNew(this.ob);
na.SaveRackRemark(1, seq, heatno, remark);
}
}
///
/// 保存
///
public void StraighteningSave()
{
StraighteningResult.Clear();
UltraGridRow ugr = ultraGridPlan.ActiveRow;
UltraGridRow ugr1 = straighteningResult1.UltraGrid2.Rows[0];
UltraGridRow ugr11 = frmStraighteningResult11.UltraGrid4.Rows[0];
UltraGridRow ugr21 = frmStraighteningResult21.UltraGrid2.Rows[0];
UltraGridRow ugr2 = this.rollingCard1.UltraGrid4.Rows[0];
string JudgeStoveNo = "";
string saveflag = "0";
if (this.ultraGridPlan.ActiveRow == null && ActiveJUDGE_STOVE_NO == null)
{
MessageBox.Show("未选择任何炉号，请选择炉号后进行保存操作。", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
if (this.ultraGridPlan.ActiveRow == null)
{
JudgeStoveNo = ActiveJUDGE_STOVE_NO;
}
else
{
JudgeStoveNo = this.ultraGridPlan.ActiveRow.Cells["JUDGE_STOVE_NO"].Value.ToString();
}
DataTable dtFlag = ServerHelper.GetData("com.steering.mes.zgmil.coup.FrmStraighteningResult.GetSingleJRLResult", new object[] { JudgeStoveNo, proPlanId, gxPlanNo }, this.ob);
if (PlineCode == "C010")
{
this.straighteningResult1.UltraGrid2.UpdateData();
StraighteningResult = NativeMethod.GetUltraGridToEntityNEW(this.straighteningResult1.UltraGrid2, StraighteningResult);
//StraighteningResult.QualifiedNum1 = "0";
//StraighteningResult.QualifiedNum1 = "0";
//StraighteningResult.QualifiedNum1 = "0";
//StraighteningResult.QualifiedNum1 = this.ultraGrid_GHDL1.Rows.Count - int.Parse(StraighteningResult.ScrapNum1.ToString());
//StraighteningResult.QualifiedNum2 = this.ultraGrid_GHDL2.Rows.Count - int.Parse(StraighteningResult.ScrapNum2.ToString());
//StraighteningResult.QualifiedNum3 = this.ultraGrid_GHDL3.Rows.Count - int.Parse(StraighteningResult.ScrapNum3.ToString());
}
else
{
if (PlineCode == "C017")
{
this.frmStraighteningResult21.UltraGrid2.UpdateData();
StraighteningResult = NativeMethod.GetUltraGridToEntityNEW(this.frmStraighteningResult21.UltraGrid2, StraighteningResult);
//StraighteningResult.QualifiedNum1 = "0";
//StraighteningResult.QualifiedNum1 = "0";
StraighteningResult.QualifiedNum3 = "0";
//StraighteningResult.QualifiedNum1 = this.ultraGrid_GHDL1.Rows.Count - int.Parse(StraighteningResult.ScrapNum1.ToString());
//StraighteningResult.QualifiedNum2 = this.ultraGrid_GHDL2.Rows.Count - int.Parse(StraighteningResult.ScrapNum2.ToString());
}
else
{
this.frmStraighteningResult11.UltraGrid4.UpdateData();
StraighteningResult = NativeMethod.GetUltraGridToEntityNEW(this.frmStraighteningResult11.UltraGrid4, StraighteningResult);
//StraighteningResult.QualifiedNum1 = "0";
//StraighteningResult.QualifiedNum1 = "0";
StraighteningResult.QualifiedNum3 = "0";
//StraighteningResult.QualifiedNum1 = this.ultraGrid_GHDL1.Rows.Count - int.Parse(StraighteningResult.ScrapNum1.ToString());
//StraighteningResult.QualifiedNum2 = this.ultraGrid_GHDL2.Rows.Count - int.Parse(StraighteningResult.ScrapNum2.ToString());
}
}
DataTable ds = ServerHelper.GetData("com.steering.mes.zgmil.coup.FrmStraighteningResult.getSingePlanFlag", new object[] { JudgeStoveNo, proPlanId, gxPlanNo }, ob);//查询计划是否为返线计划
if (dtFlag.Rows.Count > 0)
{
if (!string.IsNullOrEmpty(dtFlag.Rows[0]["NODE_FUR_FLAG"].ToString()))
{
if (dtFlag.Rows[0]["NODE_FUR_FLAG"].ToString() == "1")
{
if (ds.Rows[0]["BACK_PLAN_FLAG"].ToString().Equals("7"))
{
//来料支数
StraighteningResult.InMatNum = ds.Rows[0]["BRANCH"].ToString();
StraighteningResult.QualifiedNum = "0";
}
else
{
if (!string.IsNullOrEmpty(ugr2.Cells["QualifiedNum10"].Value.ToString()))
{
//来料支数
StraighteningResult.InMatNum = ugr2.Cells["QualifiedNum10"].Value.ToString();
StraighteningResult.QualifiedNum = "0";
}
}
//if (int.Parse(StraighteningResult.InMatNum.ToString()) > int.Parse(ugr2.Cells["ScrapNum11"].Value.ToString()))
//{
// //合格支数
// StraighteningResult.QualifiedNum = int.Parse(StraighteningResult.InMatNum.ToString()) - int.Parse(ugr2.Cells["ScrapNum11"].Value.ToString());
//}
}
}
}
if (this.ultraGridPlan.ActiveRow == null && ActiveJUDGE_STOVE_NO == null)
{
MessageBox.Show("未选择任何炉号，请选择炉号后进行保存操作", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
if (this.ultraGridPlan.ActiveRow == null)
{
StraighteningResult.JudgeStoveNo = ActiveJUDGE_STOVE_NO;
}
else
{
StraighteningResult.JudgeStoveNo = this.ultraGridPlan.ActiveRow.Cells["JUDGE_STOVE_NO"].Value.ToString();
}
if (ActiveStatus.Equals("3"))
{
MessageBox.Show("炉号：【" + StraighteningResult.JudgeStoveNo + "】未开始进行矫直，不允许进行保存操作！！！", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
if (ActiveStatus.Equals("1"))
{
saveflag = "1";
//MessageBox.Show("炉号：【" + StraighteningResult.JudgeStoveNo + "】已完成矫直，不允许进行保存操作！！！", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
//return;
}
//if (MessageUtil.ShowYesNoAndQuestion("确认炉号【" + StraighteningResult.JudgeStoveNo + "】保存实绩？") == DialogResult.No)
//{
// return;
//}
////剔除支数
//if (!string.IsNullOrEmpty(ugr1.Cells["ScrapNum"].Value.ToString()))
//{
// StraighteningResult.ScrapNum = ugr1.Cells["ScrapNum"].Value.ToString();
//}
//else
//{
// StraighteningResult.ScrapNum = "0";
//}
//入炉支数
//string lailiao = ugr2.Cells["QualifiedNum10"].Value.ToString();
//int ck = 0;
//if (string.IsNullOrEmpty(lailiao))
//{
// ck = 0;
//}
//else
//{
// ck = int.Parse(lailiao) - int.Parse(StraighteningResult.ScrapNum.ToString());
//}
StraighteningResult.ProPlanId = proPlanId;
StraighteningResult.GxPlanNo = gxPlanNo;
int count = ServerHelper.SetData("com.steering.mes.zgmil.coup.FrmStraighteningResult.saveStraightening", new object[] { StraighteningResult, saveflag }, this.ob);
if (count > 0)
{
MessageBox.Show("炉号【" + StraighteningResult.JudgeStoveNo + "】保存成功！", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
this.straighteningResult1.IsCellSelect = false;
this.frmStraighteningResult11.IsCellSelect = false;
this.frmStraighteningResult21.IsCellSelect = false;
temprstraght = NativeMethod.GetEntityToEntity(temprstraght, StraighteningResult);
GetRollingCard();
}
///
/// 结炉操作
/// 1、判断上一道工序结炉状态，2、更新实绩表（包括结炉时间,结炉状态），3.更新主表NODE_STATUS
///
public void StraighteningNode()
{
StraighteningSave();
StraighteningResult.Clear();
if (this.ultraGridPlan.ActiveRow == null)
{
MessageBox.Show("未选择任何炉号，不允许结炉", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
UltraGridRow ugr_plan = this.ultraGridPlan.ActiveRow;
UltraGridRow ugr_roll = this.rollingCard1.UltraGrid4.Rows[0];
string JudgeStoveNo = ugr_plan.Cells["JUDGE_STOVE_NO"].Value.ToString();
string resultNo = ugr_plan.Cells["ID"].Value.ToString();
//string Status = ugr_plan.Cells["IS_START"].Value.ToString();
string Status = doQueryJugeNoStaus(resultNo, JudgeStoveNo,PlineCode);
NativeMethodNew na = new NativeMethodNew(this.ob);
int WaitChangeSeq1 = na.GetWaitChangeSeq(ActiveJUDGE_STOVE_NO, ActiveResultNo, 0, "1", proPlanId, gxPlanNo);
int WaitChangeSeq2 = na.GetWaitChangeSeq(ActiveJUDGE_STOVE_NO, ActiveResultNo, 0, "2", proPlanId, gxPlanNo);
if (WaitChangeSeq1 > 0)
{
MessageBox.Show("序号：【" + WaitChangeSeq1 + "】子管未接班确认，不能结炉", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
if (WaitChangeSeq2 > 0)
{
MessageBox.Show("序号：【" + WaitChangeSeq2 + "】子管未接班确认，不能结炉", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
if (this.PlineCode.Equals("C010"))
{
int WaitChangeSeq3 = na.GetWaitChangeSeq(ActiveJUDGE_STOVE_NO, ActiveResultNo, 0, "3", proPlanId, gxPlanNo);
if (WaitChangeSeq3 > 0)
{
MessageBox.Show("序号：【" + WaitChangeSeq3 + "】子管未接班确认，不能结炉", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
}
if (Status == "1")
{
MessageBox.Show("炉号：【" + JudgeStoveNo + "】已完成矫直，不允许进行结炉操作！", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
if (Status != "0")
{
MessageBox.Show("炉号【" + JudgeStoveNo + "】未开始矫直，不允许结炉！", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
//查看结炉标识
DataTable dtFlag = ServerHelper.GetData("com.steering.mes.zgmil.coup.FrmStraighteningResult.GetSingleJRLResult", new object[] { JudgeStoveNo, proPlanId, gxPlanNo }, this.ob);
if (dtFlag.Rows.Count > 0)
{
if (string.IsNullOrEmpty(dtFlag.Rows[0]["NODE_FUR_FLAG"].ToString()))
{
MessageBox.Show("炉号【" + JudgeStoveNo + "】未开始分切，不允许结炉", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
if (dtFlag.Rows[0]["NODE_FUR_FLAG"].ToString() != "1")
{
MessageBox.Show("炉号【" + JudgeStoveNo + "】不能结炉，分切未完成。", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
}
if (MessageUtil.ShowYesNoAndQuestion("确认炉号【" + JudgeStoveNo + "】结炉？") == DialogResult.No)
{
return;
}
if (PlineCode == "C010")
{
this.straighteningResult1.UltraGrid2.UpdateData();
StraighteningResult = NativeMethod.GetUltraGridToEntityNEW(this.straighteningResult1.UltraGrid2, StraighteningResult);
int i = 0; int j = 0; int k = 0;
if (ultraGrid_GHDL1.Rows.Count > 0)
{
foreach (UltraGridRow ugr1 in ultraGrid_GHDL1.Rows)
{
if (!string.IsNullOrEmpty(ugr1.Cells["MAT_NO"].Value.ToString()))
{
i = i + 1;
}
}
}
if (ultraGrid_GHDL2.Rows.Count > 0)
{
foreach (UltraGridRow ugr1 in ultraGrid_GHDL2.Rows)
{
if (!string.IsNullOrEmpty(ugr1.Cells["MAT_NO"].Value.ToString()))
{
j = j + 1;
}
}
}
if (ultraGrid_GHDL3.Rows.Count > 0)
{
foreach (UltraGridRow ugr1 in ultraGrid_GHDL3.Rows)
{
if (!string.IsNullOrEmpty(ugr1.Cells["MAT_NO"].Value.ToString()))
{
k = k + 1;
}
}
}
StraighteningResult.QualifiedNum1 = i - int.Parse(StraighteningResult.ScrapNum1.ToString());
StraighteningResult.QualifiedNum2 = j - int.Parse(StraighteningResult.ScrapNum2.ToString());
StraighteningResult.QualifiedNum3 = k - int.Parse(StraighteningResult.ScrapNum3.ToString());
}
else
{
if (PlineCode == "C017")
{
this.frmStraighteningResult21.UltraGrid2.UpdateData();
StraighteningResult = NativeMethod.GetUltraGridToEntityNEW(this.frmStraighteningResult21.UltraGrid2, StraighteningResult);
int i = 0; int j = 0; int k = 0;
if (ultraGrid_GHDL1.Rows.Count > 0)
{
foreach (UltraGridRow ugr1 in ultraGrid_GHDL1.Rows)
{
if (!string.IsNullOrEmpty(ugr1.Cells["MAT_NO"].Value.ToString()))
{
i = i + 1;
}
}
}
if (ultraGrid_GHDL2.Rows.Count > 0)
{
foreach (UltraGridRow ugr1 in ultraGrid_GHDL2.Rows)
{
if (!string.IsNullOrEmpty(ugr1.Cells["MAT_NO"].Value.ToString()))
{
j = j + 1;
}
}
}
StraighteningResult.QualifiedNum1 = i - int.Parse(StraighteningResult.ScrapNum1.ToString());
StraighteningResult.QualifiedNum2 = j - int.Parse(StraighteningResult.ScrapNum2.ToString());
StraighteningResult.QualifiedNum3 = "0";
}
else
{
this.frmStraighteningResult11.UltraGrid4.UpdateData();
StraighteningResult = NativeMethod.GetUltraGridToEntityNEW(this.frmStraighteningResult11.UltraGrid4, StraighteningResult);
int i = 0; int j = 0; int k = 0;
if (ultraGrid_GHDL1.Rows.Count > 0)
{
foreach (UltraGridRow ugr1 in ultraGrid_GHDL1.Rows)
{
if (!string.IsNullOrEmpty(ugr1.Cells["MAT_NO"].Value.ToString()))
{
i = i + 1;
}
}
}
if (ultraGrid_GHDL2.Rows.Count > 0)
{
foreach (UltraGridRow ugr1 in ultraGrid_GHDL2.Rows)
{
if (!string.IsNullOrEmpty(ugr1.Cells["MAT_NO"].Value.ToString()))
{
j = j + 1;
}
}
}
StraighteningResult.QualifiedNum1 = i - int.Parse(StraighteningResult.ScrapNum1.ToString());
StraighteningResult.QualifiedNum2 = j - int.Parse(StraighteningResult.ScrapNum2.ToString());
StraighteningResult.QualifiedNum3 = "0";
}
}
DataTable ds = ServerHelper.GetData("com.steering.mes.zgmil.coup.FrmStraighteningResult.getSingePlanFlag", new object[] { JudgeStoveNo, proPlanId, gxPlanNo }, ob);
if (ds.Rows[0]["BACK_PLAN_FLAG"].ToString().Equals("7"))
{
//来料支数
StraighteningResult.InMatNum = ds.Rows[0]["BRANCH"].ToString();
if (int.Parse(StraighteningResult.InMatNum.ToString3()) >= int.Parse(ugr_roll.Cells["ScrapNum11"].Value.ToString3()))
{
//合格支数
StraighteningResult.QualifiedNum = int.Parse(StraighteningResult.InMatNum.ToString()) - int.Parse(ugr_roll.Cells["ScrapNum11"].Value.ToString3()) - int.Parse(ugr_roll.Cells["Offline11"].Value.ToString3());
}
else
{
MessageBox.Show("存在上一道工序已经剔除的管坯在本道工序也剔除了，请回退后再进行结炉操作", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
}
else
{
if (!string.IsNullOrEmpty(ugr_roll.Cells["QualifiedNum10"].Value.ToString()))
{
//来料支数
StraighteningResult.InMatNum = ugr_roll.Cells["QualifiedNum10"].Value.ToString();
}
if (int.Parse(StraighteningResult.InMatNum.ToString3()) >= int.Parse(ugr_roll.Cells["ScrapNum11"].Value.ToString3()))
{
//合格支数
StraighteningResult.QualifiedNum = int.Parse(StraighteningResult.InMatNum.ToString()) - int.Parse(ugr_roll.Cells["ScrapNum11"].Value.ToString3()) - int.Parse(ugr_roll.Cells["Offline11"].Value.ToString3());
}
else
{
MessageBox.Show("存在上一道工序已经剔除的管坯在本道工序也剔除了，请回退后再进行结炉操作", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
}
//合格吨
double DBHeight = 0;
double BurnningRate = 0;
double BurnningRate1 = 0;
double DBNum = 1;
NativeMethodNew natemp = new NativeMethodNew(this.ob);
string JudgeStoveNotemp = BaseMethod.getJudgeStoveNo(JudgeStoveNo) + "-01";
double percent = natemp.GetLengthPercent(JudgeStoveNotemp, this.ob, 0);
if (percent == 100.0)
{
MessageBox.Show("炉号：【" + JudgeStoveNo + "】尚未开始分切，不允许结炉", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
DataTable dtDBH = ServerHelper.GetData("com.steering.mes.zgmil.coup.FeedSawResult.getDbHeight", new object[] { JudgeStoveNo, ActiveResultNo, proPlanId, gxPlanNo }, this.ob);
if (dtDBH.Rows.Count > 0)
{
if (!string.IsNullOrEmpty(dtDBH.Rows[0]["DB_HEIGHT"].ToString()))
{
DBHeight = double.Parse(dtDBH.Rows[0]["DB_HEIGHT"].ToString());
}
if (!string.IsNullOrEmpty(dtDBH.Rows[0]["BURNNING_RATE"].ToString()))
{
BurnningRate = double.Parse(dtDBH.Rows[0]["BURNNING_RATE"].ToString());
}
if (!string.IsNullOrEmpty(dtDBH.Rows[0]["BURNINGRATE"].ToString()))
{
BurnningRate1 = double.Parse(dtDBH.Rows[0]["BURNINGRATE"].ToString());
}
if (!string.IsNullOrEmpty(dtDBH.Rows[0]["DB_NUM"].ToString()))
{
DBNum = double.Parse(dtDBH.Rows[0]["DB_NUM"].ToString());
}
}
//分产线 是否经过再加热炉
if (this.PlineCode == "C009" || PlineCode == "C012" || PlineCode == "C017")
{
double temp = DBHeight * (1 - (BurnningRate / 100));
double tempnum = double.Parse(StraighteningResult.QualifiedNum.ToString());
StraighteningResult.QaTon = temp * percent / 100 * tempnum;
}
else
{
double temp = DBHeight * (1 - (BurnningRate / 100)) * (1 - (BurnningRate1 / 100));
double tempnum = double.Parse(StraighteningResult.QualifiedNum.ToString());
StraighteningResult.QaTon = temp * percent / 100 * tempnum;
}
StraighteningResult.JudgeStoveNo = JudgeStoveNo;
StraighteningResult.NodeFurFlag = "1";
StraighteningResult.ColGroup = UserInfo.GetUserGroup();
StraighteningResult.ColShift = UserInfo.GetUserOrder();
StraighteningResult.ColUser = UserInfo.GetUserName();
StraighteningResult.UserId = _UserID;
StraighteningResult.ProPlanId = proPlanId;
StraighteningResult.GxPlanNo = gxPlanNo;
StraighteningResult.LotNo = lotNo;
StraighteningResult.PlineCode = PlineCode;
CoreClientParam ccp = new CoreClientParam();
ccp.ServerName = "com.steering.mes.zgmil.coup.FrmStraighteningResult";
ccp.MethodName = "updateMilSlab";
ccp.ServerParams = new object[] { JudgeStoveNo, "9", proPlanId, gxPlanNo };
ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
if (ccp.ReturnCode != -1)
{
if (ccp.ReturnInfo.Equals("修改成功!"))
{
//更新进程表，废品入库存
ccp.ServerName = "com.steering.mes.zgmil.coup.FrmStraighteningResult";
ccp.MethodName = "updateProcessL";
ccp.ServerParams = new object[] { JudgeStoveNo, "9", "9", proPlanId, gxPlanNo, lotNo, PlineCode };
ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
if (ccp.ReturnCode != -1)
{
if (ccp.ReturnInfo.Equals("修改成功!"))
{
//结炉操作：保存实绩，修改结炉状态
int count = ServerHelper.SetData("com.steering.mes.zgmil.coup.FrmStraighteningResult.saveStraighteningNODE", new object[] { StraighteningResult }, this.ob);
//MessageBox.Show("结炉操作完成", "提示 :", MessageBoxButtons.OK, MessageBoxIcon.Information);
if (count > 0)
{
//int count2 = ServerHelper.SetData("com.steering.mes.zgmil.coup.FeedSawResult.scrapNodeMat", new object[] { JudgeStoveNo, 8, 0 }, this.ob);
ccp.ServerName = "com.steering.mes.zgmil.coup.FrmStraighteningResult";
ccp.MethodName = "assignmentMatNo";
ccp.ServerParams = new object[] { JudgeStoveNo, "8", PlineCode, proPlanId, gxPlanNo };
ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
if (ccp.ReturnCode != -1)
{
if (ccp.ReturnInfo.Equals("修改成功!"))
{
//往跟踪记录表插入探伤开始时间
NativeMethodNew nas = new NativeMethodNew(this.ob);
nas.InsertSTAferDoubleClick(JudgeStoveNo, 7, "1", proPlanId, gxPlanNo);
NativeMethod.CheckNodeMatStatus(JudgeStoveNo, proPlanId, gxPlanNo, 7, this.ob);
this.straighteningResult1.IsCellSelect = false;
this.frmStraighteningResult11.IsCellSelect = false;
this.frmStraighteningResult21.IsCellSelect = false;
temprstraght = NativeMethod.GetEntityToEntity(temprstraght, StraighteningResult);
DataTable dt1 = ServerHelper.GetData("com.steering.mes.zgmil.coup.FeedSawResult.getSingleMainPlan", new object[] { QueryMainPlan, 8 }, this.ob);
GridHelper.CopyDataToDatatable(ref dt1, ref dtPlan, true);
//ultraGridPlan.DisplayLayout.Bands[0].PerformAutoResizeColumns(true, PerformAutoSizeType.AllRowsInBand);
ChangeCellName();
foreach (UltraGridRow ugr1 in this.ultraGridPlan.Rows)
{
ugr1.Cells["JUDGE_NO"].Value = BaseMethod.getJudgeStoveNo(ugr1.Cells["JUDGE_STOVE_NO"].Value.ToString());
if (ugr1.Cells["JUDGE_STOVE_NO"].Value.ToString() == JudgeStoveNo)
{
ultraGridPlan.ActiveRow = ugr1;
}
}
this.dataSet2.Clear();
MessageUtil.ShowTips("炉号：【" + JudgeStoveNo + "】结炉成功!");
}
}
else
{
MessageUtil.ShowTips(ccp.ReturnInfo);
}
}
}
else
{
MessageUtil.ShowTips(ccp.ReturnInfo);
}
}
}
}
}
///
///
///
private void NodeBack()
{
if (this.ultraGridPlan.ActiveRow == null)
{
MessageBox.Show("请选择需要回退的炉号！！！", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
UltraGridRow ugr = ultraGridPlan.ActiveRow;
string JudgeStoveNo = ugr.Cells["JUDGE_STOVE_NO"].Value.ToString();
string ResultNo = ugr.Cells["ID"].Value.ToString();
//string NodeFlag = ugr.Cells["IS_START"].Value.ToString();
string NodeFlag = doQueryJugeNoStaus(ResultNo, JudgeStoveNo, PlineCode);
DataTable dtMat = ServerHelper.GetData("com.steering.mes.zgmil.coup.FrmOffLine.doQueryMatScrap", new object[] { JudgeStoveNo, PlineCode, proPlanId, gxPlanNo }, this.ob);
if (dtMat.Rows.Count > 0)
{
if (int.Parse(dtMat.Rows[0][0].ToString()) > 0)
{
MessageBox.Show("炉号【" + BaseMethod.getJudgeStoveNo(JudgeStoveNo) + "】的废品已发运，不能结炉回退！！！！");
return;
}
}
DataTable dtKG_FLAG = ServerHelper.GetData("com.steering.mes.zgmil.coup.FrmStraighteningResult.GetStraightKG_Flag", new object[] { JudgeStoveNo, proPlanId, gxPlanNo }, this.ob);
if (dtKG_FLAG.Rows.Count > 0)
{
string kgflag = dtKG_FLAG.Rows[0]["KG_FLAG"].ToString();
//if (kgflag.Equals("1"))
//{
// MessageBox.Show("炉号【" + BaseMethod.getJudgeStoveNo(JudgeStoveNo) + "】 为探伤返线生成，不允许结炉回退。", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
// return;
//}
}
if (NodeFlag != "1")
{
MessageBox.Show("炉号【" + BaseMethod.getJudgeStoveNo(JudgeStoveNo) + "】未结炉，不能结炉回退！！！！", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
DataTable ds = ServerHelper.GetData("com.steering.mes.zgmil.coup.FrmStraighteningResult.doQueryOffline", new object[] { JudgeStoveNo, proPlanId, gxPlanNo }, ob);
if (ds.Rows.Count > 0)
{
MessageUtil.ShowTips("探伤工序存在下线实绩,不允许结炉回退!");
return;
}
DataTable ds1 = ServerHelper.GetData("com.steering.mes.zgmil.coup.FrmStraighteningResult.doQueryStraighteningOfflineBack", new object[] { JudgeStoveNo, proPlanId, gxPlanNo }, ob);
if (ds1.Rows.Count > 0)
{
string BACKLINE_NUM = ds1.Rows[0]["BACKLINE_NUM"].ToString();
MessageUtil.ShowTips("矫直工序存在离线数据已 返线或者组炉 " + BACKLINE_NUM + "支,不允许结炉回退!");
return;
}
DataTable dt = ServerHelper.GetData("com.steering.mes.zgmil.coup.FeedSawResult.doNodeBackCheck", new object[] { JudgeStoveNo, ResultNo, proPlanId, gxPlanNo }, this.ob);
if (dt.Rows.Count > 0)
{
string NodeProcess = ""; //当前炉次结炉工序
string NodeStatus = dt.Rows[0][0].ToString();
switch (NodeStatus)
{
case "30":
NodeProcess = "穿孔";
break;
case "40":
NodeProcess = "连轧";
break;
case "50":
NodeProcess = "再加热炉";
break;
case "60":
NodeProcess = "定径";
break;
case "70":
NodeProcess = "分切";
break;
case "80":
NodeProcess = "矫直";
break;
case "90":
NodeProcess = "探伤";
break;
case "96":
NodeProcess = "质检";
break;
}
if (NodeStatus != "80")
{
MessageBox.Show("炉号【" + BaseMethod.getJudgeStoveNo(JudgeStoveNo) + "】 " + NodeProcess + "工序已结炉，当前工序不能结炉回退", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
}
////判断当前炉次下道工序是否结炉 下道工序结炉 - 不允许回退
//int Seq = 0;
//DataTable dt2 = ServerHelper.GetData("com.steering.mes.zgmil.coup.FeedSawResult.changeFlagQuery", new object[] { JudgeStoveNo, ResultNo, 7 , proPlanId, gxPlanNo}, this.ob);
//if (dt2.Rows.Count > 0)
//{
// Seq = int.Parse(dt2.Rows[0][0].ToString());
//}
//int count2 = ServerHelper.SetData("com.steering.mes.zgmil.coup.FeedSawResult.nodeBack", new object[] { JudgeStoveNo, ResultNo, 7, PlineCode, Seq, 0 }, this.ob);
string Group = UserInfo.GetUserGroup();
string Shift = UserInfo.GetUserOrder();
//查询结炉班次班组
DataTable dtNodeGroup = ServerHelper.GetData("com.steering.mes.zgmil.coup.FeedSawResult.doNodeBackCheck", new object[] { JudgeStoveNo, ResultNo, 7, proPlanId, gxPlanNo }, this.ob);
if (dtNodeGroup.Rows.Count > 0)
{
string NodeShift = dtNodeGroup.Rows[0][0].ToString();
string NodeGroup = dtNodeGroup.Rows[0][1].ToString();
if (Shift == NodeShift && Group == NodeGroup)
{
NativeMethodNew nas = new NativeMethodNew(this.ob);
if (this.ultraTabControl2.Tabs[0].Visible == true)
{
nas.NodeBack(JudgeStoveNo, ResultNo, this.PlineCode, 0, "1", proPlanId, gxPlanNo, lotNo);
}
if (this.ultraTabControl2.Tabs[1].Visible == true)
{
nas.NodeBack(JudgeStoveNo, ResultNo, this.PlineCode, 0, "2", proPlanId, gxPlanNo, lotNo);
}
if (this.ultraTabControl2.Tabs[2].Visible == true)
{
nas.NodeBack(JudgeStoveNo, ResultNo, this.PlineCode, 0, "3", proPlanId, gxPlanNo, lotNo);
}
CoreClientParam ccp = new CoreClientParam();
ccp.ServerName = "com.steering.mes.zgmil.coup.FrmOffLine";
ccp.MethodName = "insertMatScrapBack";
ccp.ServerParams = new object[] { JudgeStoveNo, proPlanId, gxPlanNo, PlineCode, "9" };
ccp = ob.ExecuteNonQuery(ccp, CoreInvokeType.Internal);
if (ccp.ReturnCode != -1)
{ MessageUtil.ShowTips(ccp.ReturnInfo); }
ChangeGridColor();
PlanQuery();
}
else
{
switch (NodeShift)
{
case "0":
NodeShift = "白班";
break;
case "1":
NodeShift = "早班";
break;
case "2":
NodeShift = "中班";
break;
case "3":
NodeShift = "夜班";
break;
}
switch (NodeGroup)
{
case "1":
NodeGroup = "甲班";
break;
case "2":
NodeGroup = "乙班";
break;
case "3":
NodeGroup = "丙班";
break;
case "4":
NodeGroup = "丁班";
break;
}
switch (this.UserInfo.GetUserOrder())
{
case "0":
Shift = "白班";
break;
case "1":
Shift = "早班";
break;
case "2":
Shift = "中班";
break;
case "3":
Shift = "夜班";
break;
}
switch (this.UserInfo.GetUserGroup())
{
case "1":
Group = "甲班";
break;
case "2":
Group = "乙班";
break;
case "3":
Group = "丙班";
break;
case "4":
Group = "丁班";
break;
}
MessageBox.Show("炉号【" + BaseMethod.getJudgeStoveNo(JudgeStoveNo) + "】已由" + NodeGroup + "，" + NodeShift + "结炉，当班不能结炉回退");
return;
}
}
}
///
/// 1#剔除
///
///
///
private void ultraGrid_GHDL1_ClickCellButton(object sender, CellEventArgs e)
{
int countss = 0;
MilSlabScrapSeqEntity ScrapSlab = new MilSlabScrapSeqEntity();
UltraGridRow ugr = ultraGrid_GHDL1.ActiveRow;
UltraGridRow ugr1 = ultraGridPlan.ActiveRow;
string PlanStatuss = ultraGridPlan.ActiveRow.Cells["IS_START"].Value.ToString();
if (PlanStatuss != "已开始矫直")
{
MessageBox.Show("炉号【" + ultraGridPlan.ActiveRow.Cells["JUDGE_STOVE_NO"].Value.ToString() + "】不是已开始矫直状态，不允许操作", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
string JudgeStoveNo = ugr.Cells["JUDGE_STOVE_NO"].Value.ToString();
String MAT_NO = ugr.Cells["MAT_NO"].Value.ToString();
String Seq = ugr.Cells["seq"].Value.ToString();
int Seq1 = int.Parse(Seq);
string Status = ugr1.Cells["IS_START"].Value.ToString();
string DlSTATUS = ugr.Cells["Status"].Value.ToString();
string plcode = ugr1.Cells["Pline_Code"].Value.ToString();
string offline = ugr.Cells["OFFLINE_FLAG"].Value.ToString();
//if (ActiveOFFLINE_FLAG.Equals("2"))
//{
// if (!offline.Equals("返线"))
// {
// MessageBox.Show("当前为矫直返线，只允许对下线状态为返线的子管进行操作，", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
// return;
// }
//}
string shif = ugr.Cells["COL_SHIFT"].Value.ToString();
string group = ugr.Cells["COL_GROUP"].Value.ToString();
Shift = UserInfo.GetUserOrder();
Group = UserInfo.GetUserGroup();
NativeMethodNew nasssss = new NativeMethodNew(this.ob);
if (nasssss.IsRackOperate(shif, group))
{
MessageBox.Show("序号：【" + Seq + "】子管已由" + shif + "," + group + "操作，不允许再进行操作", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
DataTable ds = new DataTable();
DataTable dd = new DataTable();
if (e.Cell.Column.Key == "SCRAP_SLAB")
{
if (Status != "已开始矫直")
{
MessageBox.Show("炉号【" + JudgeStoveNo + "】未开始矫直，不能剔除", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
if (DlSTATUS == "剔除")
{
MessageBox.Show("序号【" + Seq + "】该条已经剔除，不能重复剔除", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
int ScrapNumBefore = 0;
DataTable dtcountaftersaw = ServerHelper.GetData("com.steering.mes.zgmil.coup.EddyCurrentTestingResult.scrapMatCheckAfterSaw", new object[] { JudgeStoveNo, 8, "1", proPlanId, gxPlanNo }, this.ob);
ScrapNumBefore = int.Parse(dtcountaftersaw.Rows[0]["Countss"].ToString());
DataTable dtcount = ServerHelper.GetData("com.steering.mes.zgmil.coup.FrmStraighteningResult.GetRackCounts", new object[] { JudgeStoveNo, Seq1, "1", proPlanId, gxPlanNo }, this.ob);
if (dtcount.Rows.Count > 0)
{
countss = int.Parse(dtcount.Rows[0]["COUNTSS"].ToString());
}
if (this.ultraGrid_GHDL1.Rows.Count - (countss + 1) < ScrapNumBefore)
{
if (e.Cell.Column.Key == "SCRAP_SLAB")
{
MessageBox.Show("不存在序号为【" + Seq + "】的管号，可能是被前道工序剔除，不能再次剔除！", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
else if (e.Cell.Column.Key == "ChangShift")
{
MessageBox.Show("不存在序号为【" + Seq + "】的管号，可能是被前道工序剔除，不能进行交班操作！", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
}
//if (MessageUtil.ShowYesNoAndQuestion("是否剔除该子管") == DialogResult.No)
//{
// return;
//}
ScrapSlab.JudgeStoveNo = JudgeStoveNo;
ScrapSlab.Seq = Seq;
ScrapSlab.ProcessNo = "9";
ScrapSlab.Flag = "0";
ScrapSlab.ColMode = "1";
ScrapSlab.ColUser = UserInfo.GetUserName();
ScrapSlab.ColGroup = UserInfo.GetUserGroup();
ScrapSlab.ColShift = UserInfo.GetUserOrder();
ScrapSlab.ColNo = "1";
ScrapSlab.ProPlanId = proPlanId;
ScrapSlab.GxPlanNo = gxPlanNo;
//剔管操作，：1、插入MIL_SLAB_SCRAP_SEQ表，2、探伤跟踪记录表状态，3、修改加探伤实绩表剔除支数
int count = ServerHelper.SetData("com.steering.mes.zgmil.coup.FrmStraighteningResult.scrapFurMat", new object[] { ScrapSlab, "1" }, this.ob);
//MessageBox.Show("管序号【" + Seq + "】剔除成功！", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
//CoreClientParam ccp = new CoreClientParam();
//ccp.ServerName = "com.steering.mes.zgmil.coup.FrmStraighteningResult";
//ccp.MethodName = "updatePorcessOcupStaus";
//ccp.ServerParams = new object[] { ScrapSlab, "9" };
//if (ccp.ReturnCode != -1)
//{
// if (ccp.ReturnInfo.Equals("修改成功!"))
// {
ultraGridTC();//查询跟踪记录表
GetStraightResult(JudgeStoveNo, plcode);//更新实绩
ds = ServerHelper.GetData("com.steering.mes.zgmil.coup.FrmStraighteningResult.getSingePlanFlag", new object[] { JudgeStoveNo, proPlanId, gxPlanNo }, ob);
if (ds.Rows[0]["BACK_PLAN_FLAG"].ToString().Equals("7"))
{
GetRollingCard1();
}
else
{
GetRollingCard();//更新流通卡
}
ChangeGridColor();
// }
//}
}
if (e.Cell.Column.Key == "DELBACK")
{
//if (MessageUtil.ShowYesNoAndQuestion("是否回退该剔除的坯料") == DialogResult.No)
//{
// return;
//}
if (!DlSTATUS.Equals("剔除"))
{
MessageBox.Show("该坯料未被剔除，请确认后重新选择！", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
NativeMethodNew na = new NativeMethodNew(this.ob);
int counts = 0;
//if(Flage.Equals("1"))
//{
counts = na.DeleteSlabSeq(JudgeStoveNo, Seq.ToString(), 9, 1, 0, proPlanId, gxPlanNo);
//}
//if (Flage.Equals("2"))
//{
// counts = na.DeleteSlabSeq(JudgeStoveNo, Seq.ToString(), 10,1, 0);
//}
//if (Flage.Equals("3s"))
//{
// counts = na.DeleteSlabSeq(JudgeStoveNo, Seq.ToString(), 11, 1, 0);
//}
if (counts > 0)
{
ultraGridTC();//查询跟踪记录表
GetStraightResult(JudgeStoveNo, plcode);//更新实绩
ds = ServerHelper.GetData("com.steering.mes.zgmil.coup.FrmStraighteningResult.getSingePlanFlag", new object[] { JudgeStoveNo, proPlanId, gxPlanNo }, ob);
if (ds.Rows[0]["BACK_PLAN_FLAG"].ToString().Equals("7"))
{
GetRollingCard1();
}
else
{
GetRollingCard();//更新流通卡
}
ChangeGridColor();
//MessageBox.Show("剔料回退成功", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
MessageBox.Show("剔料回退失败", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
}
if (e.Cell.Column.Key == "ChangShift")
{
string seqlast = "";
int ScrapNumBefore = 0;
DataTable dtcountaftersaw = ServerHelper.GetData("com.steering.mes.zgmil.coup.EddyCurrentTestingResult.scrapMatCheckAfterSaw", new object[] { JudgeStoveNo, 9, "1", proPlanId, gxPlanNo }, this.ob);
ScrapNumBefore = int.Parse(dtcountaftersaw.Rows[0]["Countss"].ToString());
DataTable dtcount = ServerHelper.GetData("com.steering.mes.zgmil.coup.FrmStraighteningResult.GetRackCounts", new object[] { JudgeStoveNo, Seq1, "1", proPlanId, gxPlanNo }, this.ob);
if (dtcount.Rows.Count > 0)
{
countss = int.Parse(dtcount.Rows[0]["COUNTSS"].ToString());
}
if (this.ultraGrid_GHDL1.Rows.Count - (countss + 1) < ScrapNumBefore)
{
MessageBox.Show("不存在序号为【" + Seq + "】的管号，可能是被前道工序剔除，不能再次剔除！", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
if (ugr.Cells["CHANGE_FLAG"].Value.ToString().Equals("确认交班") || ugr.Cells["CHANGE_FLAG"].Value.ToString().Equals("待接班确认"))
{
MessageBox.Show("序号：【" + Seq + "】已进行了交接班操作，不允许再次进行", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
//找到本台交接班的第一只
DataTable dt = ServerHelper.GetData("com.steering.mes.zgmil.coup.EddyCurrentTestingResult.GetRackChangeFlag", new object[] { JudgeStoveNo, ActiveResultNo, Seq.ToString(), 1, "1", Shift, Group, proPlanId, gxPlanNo }, this.ob);
if (dt.Rows.Count > 0)
{
if (!string.IsNullOrEmpty(dt.Rows[0]["SEQ"].ToString()))
{
seqlast = dt.Rows[0]["SEQ"].ToString();
}
else
{
//seqlast = "1";
}
}
else
{
//seqlast = "1";
}
if (int.Parse(seqlast) > int.Parse(Seq))
{
MessageBox.Show("您所选的管号队列交接班支已被上一班操作，不允许进行交接班", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
else
{
//针对矫直探伤需重写
//HOTMethod hm = new HOTMethod(this.ob);
//hm.UpdateChangeFlag(ActiveJUDGE_STOVE_NO, ActiveResultNo, "", 6, int.Parse(Seq), 0);
NativeMethodNew na = new NativeMethodNew(this.ob);
na.UpdateChangeFlag(ActiveJUDGE_STOVE_NO, ActiveResultNo, 0, int.Parse(Seq), "1");
}
}
if (e.Cell.Column.Key == "BTNCHANGECOM")
{
NativeMethodNew na = new NativeMethodNew(this.ob);
int WaitChangeSeq = na.GetWaitChangeSeq(ActiveJUDGE_STOVE_NO, ActiveResultNo, 0, "1", proPlanId, gxPlanNo);
if (WaitChangeSeq == 0)
{
MessageBox.Show("没有待交班确认的管号。");
return;
}
if (WaitChangeSeq != int.Parse(Seq))
{
MessageBox.Show("交班管序号与接班管序号不符，请确认后接班。");
return;
}
if (MessageUtil.ShowYesNoAndQuestion("确认炉号：【" + BaseMethod.getJudgeStoveNo(ActiveJUDGE_STOVE_NO) + "】序号：【" + Seq + "】交班？") == DialogResult.No)
{
return;
}
int count =0;
//if (ChangeUserID == "")
//{
// FrmChangeGroup frmCg = new FrmChangeGroup(this.ob);
// frmCg.ShowDialog();
// if (frmCg.DialogResult == DialogResult.OK)
// {
// ChangeUserID = frmCg._UserID;
// //ChangePassWord = frmCg._PassWord;
// }
if (this.DoRelogin(DoCheck))
{
count = na.ChangeShift(JudgeStoveNo, this.ActiveResultNo, Seq.ToString(), this.PlineCode, Shift, Group, 1, 1, "1", proPlanId, gxPlanNo);
}
//}
//else
//{
// count = na.ChangeShift(JudgeStoveNo, this.ActiveResultNo, Seq.ToString(), this.PlineCode, Shift, Group, 1, 1, "1");
//}
if (count < 1)
{
MessageBox.Show("交接班失败，请查找原因后重新操作。", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
}
//过渡方法，接班后重登陆初始化导致Grid.Row为null
if (ultraGridPlan.Rows == null)
{
return;
}
ultraGridTC();
GetStraightResult(JudgeStoveNo, PlineCode);//更新实绩
ds = ServerHelper.GetData("com.steering.mes.zgmil.coup.FrmStraighteningResult.getSingePlanFlag", new object[] { JudgeStoveNo, proPlanId, gxPlanNo }, ob);
if (ds.Rows[0]["BACK_PLAN_FLAG"].ToString().Equals("7"))
{
GetRollingCard1();
}
else
{
GetRollingCard();//更新流通卡
}
ChangeGridColor();
}
///
/// 2#台剔除
///
///
///
private void ultraGrid_GHDL2_ClickCellButton(object sender, CellEventArgs e)
{
int countss = 0;
MilSlabScrapSeqEntity ScrapSlab = new MilSlabScrapSeqEntity();
UltraGridRow ugr = ultraGrid_GHDL2.ActiveRow;
UltraGridRow ugr1 = ultraGridPlan.ActiveRow;
string PlanStatuss = ultraGridPlan.ActiveRow.Cells["IS_START"].Value.ToString();
if (PlanStatuss != "已开始矫直")
{
MessageBox.Show("炉号【" + ultraGridPlan.ActiveRow.Cells["JUDGE_STOVE_NO"].Value.ToString() + "】不是已开始矫直状态，不能剔除", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
string JudgeStoveNo = ugr.Cells["JUDGE_STOVE_NO"].Value.ToString();
String MAT_NO = ugr.Cells["MAT_NO"].Value.ToString();
String Seq = ugr.Cells["seq"].Value.ToString();
int Seq1 = int.Parse(Seq);
string Status = ugr1.Cells["IS_START"].Value.ToString();
string DlSTATUS = ugr.Cells["Status"].Value.ToString();
string plcode = ugr1.Cells["Pline_Code"].Value.ToString();
string offline = ugr.Cells["OFFLINE_FLAG"].Value.ToString();
if (ActiveOFFLINE_FLAG.Equals("2"))
{
if (!offline.Equals("返线"))
{
MessageBox.Show("当前为矫直返线，只允许对下线状态为返线的子管进行操作，", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
}
string shif = ugr.Cells["COL_SHIFT"].Value.ToString();
string group = ugr.Cells["COL_GROUP"].Value.ToString();
Shift = UserInfo.GetUserOrder();
Group = UserInfo.GetUserGroup();
NativeMethodNew nasssss = new NativeMethodNew(this.ob);
DataTable ds = new DataTable();
if (nasssss.IsRackOperate(shif, group))
{
MessageBox.Show("序号：【" + Seq + "】子管已由" + shif + "," + group + "操作，不允许再进行操作", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
if (e.Cell.Column.Key == "SCRAP_SLAB")
{
if (Status != "已开始矫直")
{
MessageBox.Show("炉号【" + JudgeStoveNo + "】未开始矫直，不能剔除", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
if (DlSTATUS == "剔除")
{
MessageBox.Show("序号【" + Seq + "】该条已经剔除，不能重复剔除", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
int ScrapNumBefore = 0;
DataTable dtcountaftersaw = ServerHelper.GetData("com.steering.mes.zgmil.coup.EddyCurrentTestingResult.scrapMatCheckAfterSaw", new object[] { JudgeStoveNo, 9, "2", proPlanId, gxPlanNo }, this.ob);
ScrapNumBefore = int.Parse(dtcountaftersaw.Rows[0]["Countss"].ToString());
DataTable dtcount = ServerHelper.GetData("com.steering.mes.zgmil.coup.FrmStraighteningResult.GetRackCounts", new object[] { JudgeStoveNo, Seq1, "2", proPlanId, gxPlanNo }, this.ob);
if (dtcount.Rows.Count > 0)
{
countss = int.Parse(dtcount.Rows[0]["COUNTSS"].ToString());
}
if (this.ultraGrid_GHDL2.Rows.Count - (countss + 1) < ScrapNumBefore)
{
MessageBox.Show("不存在序号为【" + Seq + "】的管号，可能是被前道工序剔除，不能再次剔除！", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
//if (MessageUtil.ShowYesNoAndQuestion("是否剔除该子管") == DialogResult.No)
//{
// return;
//}
ScrapSlab.JudgeStoveNo = JudgeStoveNo;
ScrapSlab.Seq = Seq;
ScrapSlab.ProcessNo = "9";
ScrapSlab.Flag = "0";
ScrapSlab.ColMode = "1";
ScrapSlab.ColUser = UserInfo.GetUserName();
ScrapSlab.ColGroup = UserInfo.GetUserGroup();
ScrapSlab.ColShift = UserInfo.GetUserOrder();
ScrapSlab.ColNo = "2";
ScrapSlab.ProPlanId = proPlanId;
ScrapSlab.GxPlanNo = gxPlanNo;
//剔管操作，：1、插入MIL_SLAB_SCRAP_SEQ表，2、探伤跟踪记录表状态，3、修改加探伤实绩表剔除支数
int count = ServerHelper.SetData("com.steering.mes.zgmil.coup.FrmStraighteningResult.scrapFurMat", new object[] { ScrapSlab, "2" }, this.ob);
//MessageBox.Show("管序号【" + Seq + "】剔除成功！", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
ultraGridTC();//查询跟踪记录表
GetStraightResult(JudgeStoveNo, plcode);//更新实绩
ds = ServerHelper.GetData("com.steering.mes.zgmil.coup.FrmStraighteningResult.getSingePlanFlag", new object[] { JudgeStoveNo, proPlanId, gxPlanNo }, ob);
if (ds.Rows[0]["BACK_PLAN_FLAG"].ToString().Equals("7"))
{
GetRollingCard1();
}
else
{
GetRollingCard();//更新流通卡
}
ChangeGridColor();
}
if (e.Cell.Column.Key == "DELBACK")
{
//if (MessageUtil.ShowYesNoAndQuestion("是否回退该剔除的坯料") == DialogResult.No)
//{
// return;
//}
if (!DlSTATUS.Equals("剔除"))
{
MessageBox.Show("该坯料未被剔除，请确认后重新选择！", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
NativeMethodNew na = new NativeMethodNew(this.ob);
int counts = 0;
//if (Flage.Equals("1"))
//{
// counts = na.DeleteSlabSeq(JudgeStoveNo, Seq.ToString(), 9, 1, 0);
//}
//if (Flage.Equals("2"))
//{
counts = na.DeleteSlabSeq(JudgeStoveNo, Seq.ToString(), 10, 1, 0, proPlanId, gxPlanNo);
//}
//if (Flage.Equals("3s"))
//{
// counts = na.DeleteSlabSeq(JudgeStoveNo, Seq.ToString(), 11, 1, 0);
//}
if (counts > 0)
{
ultraGridTC();//查询跟踪记录表
GetStraightResult(JudgeStoveNo, plcode);//更新实绩
ds = ServerHelper.GetData("com.steering.mes.zgmil.coup.FrmStraighteningResult.getSingePlanFlag", new object[] { JudgeStoveNo, proPlanId, gxPlanNo }, ob);
if (ds.Rows[0]["BACK_PLAN_FLAG"].ToString().Equals("7"))
{
GetRollingCard1();
}
else
{
GetRollingCard();//更新流通卡
}
ChangeGridColor();
//MessageBox.Show("剔料回退成功", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
MessageBox.Show("剔料回退失败", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
}
if (e.Cell.Column.Key == "ChangShift")
{
string seqlast = "";
int ScrapNumBefore = 0;
DataTable dtcountaftersaw = ServerHelper.GetData("com.steering.mes.zgmil.coup.EddyCurrentTestingResult.scrapMatCheckAfterSaw", new object[] { JudgeStoveNo, 9, "2", proPlanId, gxPlanNo }, this.ob);
ScrapNumBefore = int.Parse(dtcountaftersaw.Rows[0]["Countss"].ToString());
DataTable dtcount = ServerHelper.GetData("com.steering.mes.zgmil.coup.FrmStraighteningResult.GetRackCounts", new object[] { JudgeStoveNo, Seq1, "2", proPlanId, gxPlanNo }, this.ob);
if (dtcount.Rows.Count > 0)
{
countss = int.Parse(dtcount.Rows[0]["COUNTSS"].ToString());
}
if (this.ultraGrid_GHDL2.Rows.Count - (countss + 1) < ScrapNumBefore)
{
MessageBox.Show("不存在序号为【" + Seq + "】的管号，可能是被前道工序剔除，不能再次剔除！", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
if (ugr.Cells["CHANGE_FLAG"].Value.ToString().Equals("确认交班") || ugr.Cells["CHANGE_FLAG"].Value.ToString().Equals("待接班确认"))
{
MessageBox.Show("序号：【" + Seq + "】已进行了交接班操作，不允许再次进行", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
//找到本台交接班的第一只
DataTable dt = ServerHelper.GetData("com.steering.mes.zgmil.coup.EddyCurrentTestingResult.GetRackChangeFlag", new object[] { JudgeStoveNo, ActiveResultNo, Seq.ToString(), 1, "2", Shift, Group, proPlanId, gxPlanNo }, this.ob);
if (dt.Rows.Count > 0)
{
if (!string.IsNullOrEmpty(dt.Rows[0]["SEQ"].ToString()))
{
seqlast = dt.Rows[0]["SEQ"].ToString();
}
else
{
//seqlast = "1";
}
}
else
{
//seqlast = "1";
}
if (int.Parse(seqlast) > int.Parse(Seq))
{
MessageBox.Show("您所选的管号队列交接班支已被上一班操作，不允许进行交接班", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
else
{
//针对矫直探伤需重写
//HOTMethod hm = new HOTMethod(this.ob);
//hm.UpdateChangeFlag(ActiveJUDGE_STOVE_NO, ActiveResultNo, "", 6, int.Parse(Seq), 0);
NativeMethodNew na = new NativeMethodNew(this.ob);
na.UpdateChangeFlag(ActiveJUDGE_STOVE_NO, ActiveResultNo, 0, int.Parse(Seq), "2");
}
}
if (e.Cell.Column.Key == "BTNCHANGECOM")
{
NativeMethodNew na = new NativeMethodNew(this.ob);
int WaitChangeSeq = na.GetWaitChangeSeq(ActiveJUDGE_STOVE_NO, ActiveResultNo, 0, "2", proPlanId, gxPlanNo);
if (WaitChangeSeq == 0)
{
MessageBox.Show("没有待交班确认的管号。");
return;
}
if (WaitChangeSeq != int.Parse(Seq))
{
MessageBox.Show("交班管序号与接班管序号不符，请确认后接班。");
return;
}
if (MessageUtil.ShowYesNoAndQuestion("确认炉号：【" + BaseMethod.getJudgeStoveNo(ActiveJUDGE_STOVE_NO) + "】序号：【" + Seq + "】交班？") == DialogResult.No)
{
return;
}
int count = 0;
if (this.DoRelogin(DoCheck))
{
count = na.ChangeShift(JudgeStoveNo, this.ActiveResultNo, Seq.ToString(), this.PlineCode, Shift, Group, 1, 1, "2", proPlanId, gxPlanNo);
}
//else
//{
// count = na.ChangeShift(JudgeStoveNo, this.ActiveResultNo, Seq.ToString(), this.PlineCode, Shift, Group, 1, 1, "2");
//}
if (count < 1)
{
MessageBox.Show("交接班失败，请查找原因后重新操作。", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
}
if (this.ultraGridPlan.Rows == null)
{
return;
}
ultraGridTC();
GetStraightResult(JudgeStoveNo, PlineCode);//更新实绩
ds = ServerHelper.GetData("com.steering.mes.zgmil.coup.FrmStraighteningResult.getSingePlanFlag", new object[] { JudgeStoveNo, proPlanId, gxPlanNo }, ob);
if (ds.Rows[0]["BACK_PLAN_FLAG"].ToString().Equals("7"))
{
GetRollingCard1();
}
else
{
GetRollingCard();//更新流通卡
}
ChangeGridColor();
}
///
/// 3#台剔除
///
///
///
private void ultraGrid_GHDL3_ClickCellButton(object sender, CellEventArgs e)
{
int countss = 0;
MilSlabScrapSeqEntity ScrapSlab = new MilSlabScrapSeqEntity();
UltraGridRow ugr = ultraGrid_GHDL3.ActiveRow;
UltraGridRow ugr1 = ultraGridPlan.ActiveRow;
string PlanStatuss = ultraGridPlan.ActiveRow.Cells["IS_START"].Value.ToString();
if (PlanStatuss != "已开始矫直")
{
MessageBox.Show("炉号【" + ultraGridPlan.ActiveRow.Cells["JUDGE_STOVE_NO"].Value.ToString() + "】不是已开始矫直状态，不能剔除", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
string JudgeStoveNo = ugr.Cells["JUDGE_STOVE_NO"].Value.ToString();
String MAT_NO = ugr.Cells["MAT_NO"].Value.ToString();
String Seq = ugr.Cells["seq"].Value.ToString();
int Seq1 = int.Parse(Seq);
string Status = ugr1.Cells["IS_START"].Value.ToString();
string DlSTATUS = ugr.Cells["Status"].Value.ToString();
string plcode = ugr1.Cells["Pline_Code"].Value.ToString();
string offline = ugr.Cells["OFFLINE_FLAG"].Value.ToString();
if (ActiveOFFLINE_FLAG.Equals("2"))
{
if (!offline.Equals("返线"))
{
MessageBox.Show("当前为矫直返线，只允许对下线状态为返线的子管进行操作，", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
}
string shif = ugr.Cells["COL_SHIFT"].Value.ToString();
string group = ugr.Cells["COL_GROUP"].Value.ToString();
Shift = UserInfo.GetUserOrder();
Group = UserInfo.GetUserGroup();
NativeMethodNew nasssss = new NativeMethodNew(this.ob);
DataTable ds = new DataTable();
if (nasssss.IsRackOperate(shif, group))
{
MessageBox.Show("序号：【" + Seq + "】子管已由" + shif + "," + group + "操作，不允许再进行操作", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
if (e.Cell.Column.Key == "SCRAP_SLAB")
{
if (Status != "已开始矫直")
{
MessageBox.Show("炉号【" + JudgeStoveNo + "】未开始矫直，不能剔除", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
if (DlSTATUS == "剔除")
{
MessageBox.Show("序号【" + Seq + "】该条已经剔除，不能重复剔除", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
int ScrapNumBefore = 0;
DataTable dtcountaftersaw = ServerHelper.GetData("com.steering.mes.zgmil.coup.EddyCurrentTestingResult.scrapMatCheckAfterSaw", new object[] { JudgeStoveNo, 9, "3", proPlanId, gxPlanNo }, this.ob);
ScrapNumBefore = int.Parse(dtcountaftersaw.Rows[0]["Countss"].ToString());
DataTable dtcount = ServerHelper.GetData("com.steering.mes.zgmil.coup.FrmStraighteningResult.GetRackCounts", new object[] { JudgeStoveNo, Seq1, "3", proPlanId, gxPlanNo }, this.ob);
if (dtcount.Rows.Count > 0)
{
countss = int.Parse(dtcount.Rows[0]["COUNTSS"].ToString());
}
if (this.ultraGrid_GHDL3.Rows.Count - (countss + 1) < ScrapNumBefore)
{
MessageBox.Show("不存在序号为【" + Seq + "】的管号，可能是被前道工序剔除，不能再次剔除！", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
//if (MessageUtil.ShowYesNoAndQuestion("是否剔除该子管") == DialogResult.No)
//{
// return;
//}
ScrapSlab.JudgeStoveNo = JudgeStoveNo;
ScrapSlab.Seq = Seq;
ScrapSlab.ProcessNo = "9";
ScrapSlab.Flag = "0";
ScrapSlab.ColMode = "1";
ScrapSlab.ColUser = UserInfo.GetUserName();
ScrapSlab.ColGroup = UserInfo.GetUserGroup();
ScrapSlab.ColShift = UserInfo.GetUserOrder();
ScrapSlab.ColNo = "3";
ScrapSlab.ProPlanId = proPlanId;
ScrapSlab.GxPlanNo = gxPlanNo;
//剔管操作，：1、插入MIL_SLAB_SCRAP_SEQ表，2、探伤跟踪记录表状态，3、修改加探伤实绩表剔除支数
int count = ServerHelper.SetData("com.steering.mes.zgmil.coup.FrmStraighteningResult.scrapFurMat", new object[] { ScrapSlab, "3" }, this.ob);
//MessageBox.Show("管序号【" + Seq + "】剔除成功！", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
ultraGridTC();//查询跟踪记录表
GetStraightResult(JudgeStoveNo, plcode);//更新实绩
ds = ServerHelper.GetData("com.steering.mes.zgmil.coup.FrmStraighteningResult.getSingePlanFlag", new object[] { JudgeStoveNo, proPlanId, gxPlanNo }, ob);
if (ds.Rows[0]["BACK_PLAN_FLAG"].ToString().Equals("7"))
{
GetRollingCard1();
}
else
{
GetRollingCard();//更新流通卡
}
ChangeGridColor();
}
if (e.Cell.Column.Key == "DELBACK")
{
//if (MessageUtil.ShowYesNoAndQuestion("是否回退该剔除的坯料") == DialogResult.No)
//{
// return;
//}
if (!DlSTATUS.Equals("剔除"))
{
MessageBox.Show("该坯料未被剔除，请确认后重新选择！", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
NativeMethodNew na = new NativeMethodNew(this.ob);
int counts = 0;
//if (Flage.Equals("1"))
//{
// counts = na.DeleteSlabSeq(JudgeStoveNo, Seq.ToString(), 9, 1, 0);
//}
//if (Flage.Equals("2"))
//{
//counts = na.DeleteSlabSeq(JudgeStoveNo, Seq.ToString(), 10, 1, 0);
//}
//if (Flage.Equals("3s"))
//{
counts = na.DeleteSlabSeq(JudgeStoveNo, Seq.ToString(), 11, 1, 0, proPlanId, gxPlanNo);
//}
if (counts > 0)
{
ultraGridTC();//查询跟踪记录表
GetStraightResult(JudgeStoveNo, plcode);//更新实绩
ds = ServerHelper.GetData("com.steering.mes.zgmil.coup.FrmStraighteningResult.getSingePlanFlag", new object[] { JudgeStoveNo, proPlanId, gxPlanNo }, ob);
if (ds.Rows[0]["BACK_PLAN_FLAG"].ToString().Equals("7"))
{
GetRollingCard1();
}
else
{
GetRollingCard();//更新流通卡
}
ChangeGridColor();
//MessageBox.Show("剔料回退成功", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
MessageBox.Show("剔料回退失败", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
}
#region 原来的交接班方法
//if (e.Cell.Column.Key == "ChangShift")
//{
// int ScrapNumBefore = 0;
// DataTable dtcountaftersaw = ServerHelper.GetData("com.steering.mes.zgmil.coup.EddyCurrentTestingResult.scrapMatCheckAfterSaw", new object[] { JudgeStoveNo, 9, "3" }, this.ob);
// ScrapNumBefore = int.Parse(dtcountaftersaw.Rows[0]["Countss"].ToString());
// DataTable dtcount = ServerHelper.GetData("com.steering.mes.zgmil.coup.FrmStraighteningResult.GetRackCounts", new object[] { JudgeStoveNo, Seq1, "3" }, this.ob);
// if (dtcount.Rows.Count > 0)
// {
// countss = int.Parse(dtcount.Rows[0]["COUNTSS"].ToString());
// }
// if (this.ultraGrid_GHDL3.Rows.Count - (countss + 1) < ScrapNumBefore)
// {
// MessageBox.Show("不存在序号为【" + Seq + "】的管号，可能是被前道工序剔除，不能再次剔除！", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
// return;
// }
// NativeMethodNew nas = new NativeMethodNew(this.ob);
// Shift = UserInfo.GetUserOrder();
// Group = UserInfo.GetUserGroup();
// if (ugr.Cells["CHANGE_FLAG"].Value.ToString().Equals("正常"))
// {
// int count = nas.ChangeShift(JudgeStoveNo, this.ActiveResultNo, Seq.ToString(), this.PlineCode, Shift, Group, 1, 1, "3");
// if (count < 1)
// {
// MessageBox.Show("交接班失败，请查找原因后重新操作。", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
// return;
// }
// }
// if (ugr.Cells["CHANGE_FLAG"].Value.ToString().Equals("交班点"))//回退
// {
// }
//}
#endregion
if (e.Cell.Column.Key == "ChangShift")
{
string seqlast = "";
int ScrapNumBefore = 0;
DataTable dtcountaftersaw = ServerHelper.GetData("com.steering.mes.zgmil.coup.EddyCurrentTestingResult.scrapMatCheckAfterSaw", new object[] { JudgeStoveNo, 9, "3", proPlanId, gxPlanNo }, this.ob);
ScrapNumBefore = int.Parse(dtcountaftersaw.Rows[0]["Countss"].ToString());
DataTable dtcount = ServerHelper.GetData("com.steering.mes.zgmil.coup.FrmStraighteningResult.GetRackCounts", new object[] { JudgeStoveNo, Seq1, "3", proPlanId, gxPlanNo }, this.ob);
if (dtcount.Rows.Count > 0)
{
countss = int.Parse(dtcount.Rows[0]["COUNTSS"].ToString());
}
if (this.ultraGrid_GHDL3.Rows.Count - (countss + 1) < ScrapNumBefore)
{
MessageBox.Show("不存在序号为【" + Seq + "】的管号，可能是被前道工序剔除，不能再次剔除！", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
if (ugr.Cells["CHANGE_FLAG"].Value.ToString().Equals("确认交班") || ugr.Cells["CHANGE_FLAG"].Value.ToString().Equals("待接班确认"))
{
MessageBox.Show("序号：【" + Seq + "】已进行了交接班操作，不允许再次进行", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
//找到本台交接班的第一只
DataTable dt = ServerHelper.GetData("com.steering.mes.zgmil.coup.EddyCurrentTestingResult.GetRackChangeFlag", new object[] { JudgeStoveNo, ActiveResultNo, Seq.ToString(), 1, "3", Shift, Group, proPlanId, gxPlanNo }, this.ob);
if (dt.Rows.Count > 0)
{
if (!string.IsNullOrEmpty(dt.Rows[0]["SEQ"].ToString()))
{
seqlast = dt.Rows[0]["SEQ"].ToString();
}
else
{
//seqlast = "1";
}
}
else
{
//seqlast = "1";
}
if (int.Parse(seqlast) > int.Parse(Seq))
{
MessageBox.Show("您所选的管号队列交接班支已被上一班操作，不允许进行交接班", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
else
{
//针对矫直探伤需重写
//HOTMethod hm = new HOTMethod(this.ob);
//hm.UpdateChangeFlag(ActiveJUDGE_STOVE_NO, ActiveResultNo, "", 6, int.Parse(Seq), 0);
NativeMethodNew na = new NativeMethodNew(this.ob);
na.UpdateChangeFlag(ActiveJUDGE_STOVE_NO, ActiveResultNo, 0, int.Parse(Seq), "3");
}
}
if (e.Cell.Column.Key == "BTNCHANGECOM")
{
NativeMethodNew na = new NativeMethodNew(this.ob);
int WaitChangeSeq = na.GetWaitChangeSeq(ActiveJUDGE_STOVE_NO, ActiveResultNo, 0, "3", proPlanId, gxPlanNo);
if (WaitChangeSeq == 0)
{
MessageBox.Show("没有待交班确认的管号。");
return;
}
if (WaitChangeSeq != int.Parse(Seq))
{
MessageBox.Show("交班管序号与接班管序号不符，请确认后接班。");
return;
}
if (MessageUtil.ShowYesNoAndQuestion("确认炉号：【" + BaseMethod.getJudgeStoveNo(ActiveJUDGE_STOVE_NO) + "】序号：【" + Seq + "】交班？") == DialogResult.No)
{
return;
}
int count = 0;
if (this.DoRelogin(DoCheck))
{
count = na.ChangeShift(JudgeStoveNo, this.ActiveResultNo, Seq.ToString(), this.PlineCode, Shift, Group, 1, 1, "3", proPlanId, gxPlanNo);
}
//else
//{
// count = na.ChangeShift(JudgeStoveNo, this.ActiveResultNo, Seq.ToString(), this.PlineCode, Shift, Group, 1, 1, "3");
//}
if (count < 1)
{
MessageBox.Show("交接班失败，请查找原因后重新操作。", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
}
if (this.ultraGridPlan.Rows == null)
{
return;
}
ultraGridTC();
GetStraightResult(JudgeStoveNo, PlineCode);//更新实绩
ds = ServerHelper.GetData("com.steering.mes.zgmil.coup.FrmStraighteningResult.getSingePlanFlag", new object[] { JudgeStoveNo, proPlanId, gxPlanNo }, ob);
if (ds.Rows[0]["BACK_PLAN_FLAG"].ToString().Equals("7"))
{
GetRollingCard1();
}
else
{
GetRollingCard();//更新流通卡
}
ChangeGridColor();
}
public string DoCheck(CoreUserInfo User)
{
return "";
}
///
/// ///计划表ROW点击变换判断
///
///
///
private void ultraGridPlan_BeforeRowActivate(object sender, RowEventArgs e)
{
if (this.straighteningResult1.IsCellSelect == true)
{
NativeMethodNew na = new NativeMethodNew(this.ob);
if (!na.isBegineNode(ActiveJUDGE_STOVE_NO, 7))
{
this.straighteningResult1.IsCellSelect = false;
return;
}
//if (MessageBox.Show("提示：穿孔实绩可能已修改，是否保存", "提示", MessageBoxButtons.YesNo) == DialogResult.Yes)
//{
this.straighteningResult1.IsCellSelect = false;
//保存探伤实绩
//StraighteningSave();
//}
//else
//{
this.straighteningResult1.IsCellSelect = false;
foreach (UltraGridRow ugr in this.ultraGridPlan.Rows)
{
if (ugr.Cells["JUDGE_STOVE_NO"].Value.ToString() == ActiveJUDGE_STOVE_NO)
{
this.ultraGridPlan.ActiveRow = ugr;
}
}
return;
//}
}
if (this.frmStraighteningResult11.IsCellSelect == true)
{
NativeMethodNew na = new NativeMethodNew(this.ob);
if (!na.isBegineNode(ActiveJUDGE_STOVE_NO, 7))
{
this.frmStraighteningResult11.IsCellSelect = false;
return;
}
//if (MessageBox.Show("提示：穿孔实绩可能已修改，是否保存", "提示", MessageBoxButtons.YesNo) == DialogResult.Yes)
//{
this.frmStraighteningResult11.IsCellSelect = false;
//保存探伤实绩
//StraighteningSave();
//}
//else
//{
this.frmStraighteningResult11.IsCellSelect = false;
foreach (UltraGridRow ugr in this.ultraGridPlan.Rows)
{
if (ugr.Cells["JUDGE_STOVE_NO"].Value.ToString() == ActiveJUDGE_STOVE_NO)
{
this.ultraGridPlan.ActiveRow = ugr;
}
}
return;
//}
}
if (this.frmStraighteningResult21.IsCellSelect == true)
{
NativeMethodNew na = new NativeMethodNew(this.ob);
if (!na.isBegineNode(ActiveJUDGE_STOVE_NO, 7))
{
this.frmStraighteningResult21.IsCellSelect = false;
return;
}
//if (MessageBox.Show("提示：穿孔实绩可能已修改，是否保存", "提示", MessageBoxButtons.YesNo) == DialogResult.Yes)
//{
this.frmStraighteningResult21.IsCellSelect = false;
//保存探伤实绩
//StraighteningSave();
//}
//else
//{
this.frmStraighteningResult21.IsCellSelect = false;
foreach (UltraGridRow ugr in this.ultraGridPlan.Rows)
{
if (ugr.Cells["JUDGE_STOVE_NO"].Value.ToString() == ActiveJUDGE_STOVE_NO)
{
this.ultraGridPlan.ActiveRow = ugr;
}
}
return;
//}
}
}
///
/// 查询结炉实绩
///
public void NodeQuery()
{
string Shift = UserInfo.GetUserOrder();
string Group = UserInfo.GetUserGroup();
string PliceCode = PlineCode;
string StartTime = DateTime.Now.ToString("yyyy-MM-dd");
string EndTime = DateTime.Now.AddDays(1).ToString("yyyy-MM-dd");
string Date = StartTime;
StartTime = StartTime + " 00:00:00";
EndTime = EndTime + " 00:00:00";
DataTable dt = ServerHelper.GetData("com.steering.mes.zgmil.coup.FrmStraighteningResult.GetStraightResultNodeQuery", new object[] { PliceCode, Shift, Group, StartTime, EndTime }, this.ob);
FrmNodeResultQuery frm = new FrmNodeResultQuery(dt, 10, Date, Shift, Group, this.ob);
frm.ShowDialog();
}
///
/// 矫直离线
///
public void Offline()
{
DataTable dtFlag = ServerHelper.GetData("com.steering.mes.zgmil.coup.FrmStraighteningResult.GetSingleJRLResult", new object[] { ActiveJUDGE_STOVE_NO, proPlanId, gxPlanNo }, this.ob);
if (dtFlag.Rows.Count > 0)
{
if (string.IsNullOrEmpty(dtFlag.Rows[0]["NODE_FUR_FLAG"].ToString()))
{
MessageBox.Show("炉号【" + ActiveJUDGE_STOVE_NO + "】未开始分切，不允许下线", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
if (dtFlag.Rows[0]["NODE_FUR_FLAG"].ToString() != "1")
{
MessageBox.Show("炉号【" + ActiveJUDGE_STOVE_NO + "】未完成分切，不允许下线 ", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
}
//工序状态：01-矫直1#,02-矫直2#,03-矫直3#,11-ET探伤，12-MT探伤，13-UT探伤
string Node = "JZ";
beforeQualifiedNum = this.rollingCard1.Value.SawQualifiedNum;
qualifiedNum = string.IsNullOrEmpty(this.rollingCard1.Value.StraightQualifiedNum) ? "0" : this.rollingCard1.Value.StraightQualifiedNum;
scrapNum = string.IsNullOrEmpty(this.rollingCard1.Value.StraightScrapNum) ? "0" : this.rollingCard1.Value.StraightScrapNum;
offineHas = string.IsNullOrEmpty(this.rollingCard1.Value.OfflineStraight) ? "0" : this.rollingCard1.Value.OfflineStraight;
offineHead = string.IsNullOrEmpty(this.rollingCard1.Value.BacklineStraight) ? "0" : this.rollingCard1.Value.BacklineStraight;
string numb = (int.Parse(beforeQualifiedNum.ToString3()) - int.Parse(qualifiedNum.ToString3()) - int.Parse(scrapNum.ToString3()) - int.Parse(offineHas.ToString3()) + int.Parse(offineHead.ToString3())).ToString();
FrmStraighteningOffLine frm = new FrmStraighteningOffLine(Node, this.ob, PlineCode, stoveno, lotno, numb, proPlanId, gxPlanNo);
frm.ShowDialog();
PlanQuery();
}
public void Offline2()
{
DataTable dtFlag = ServerHelper.GetData("com.steering.mes.zgmil.coup.FrmStraighteningResult.GetSingleJRLResult", new object[] { ActiveJUDGE_STOVE_NO, proPlanId, gxPlanNo }, this.ob);
if (dtFlag.Rows.Count > 0)
{
if (string.IsNullOrEmpty(dtFlag.Rows[0]["NODE_FUR_FLAG"].ToString()))
{
MessageBox.Show("炉号【" + ActiveJUDGE_STOVE_NO + "】未开始分切，不允许下线", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
if (dtFlag.Rows[0]["NODE_FUR_FLAG"].ToString() != "1")
{
MessageBox.Show("炉号【" + ActiveJUDGE_STOVE_NO + "】未完成分切，不允许下线 ", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
}
//工序状态：01-矫直1#,02-矫直2#,03-矫直3#,11-ET探伤，12-MT探伤，13-UT探伤
string Node = "02";
//FrmOffLineOperation frm = new FrmOffLineOperation(Node, this.ob, PlineCode, stoveno, lotno);
//if (frm.ShowDialog() == DialogResult.OK)
//{
// ultraGridTC();
//}
}
public void Offline3()
{
if (!PlineCode.Equals("C010"))
{
MessageBox.Show("本产线不是168产线，没有3#矫直台，不允许执行3#台下线操作", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
DataTable dtFlag = ServerHelper.GetData("com.steering.mes.zgmil.coup.FrmStraighteningResult.GetSingleJRLResult", new object[] { ActiveJUDGE_STOVE_NO, proPlanId, gxPlanNo }, this.ob);
if (dtFlag.Rows.Count > 0)
{
if (string.IsNullOrEmpty(dtFlag.Rows[0]["NODE_FUR_FLAG"].ToString()))
{
MessageBox.Show("炉号【" + ActiveJUDGE_STOVE_NO + "】未开始分切，不允许下线", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
if (dtFlag.Rows[0]["NODE_FUR_FLAG"].ToString() != "1")
{
MessageBox.Show("炉号【" + ActiveJUDGE_STOVE_NO + "】未完成分切，不允许下线 ", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
}
//工序状态：01-矫直1#,02-矫直2#,03-矫直3#,11-ET探伤，12-MT探伤，13-UT探伤
string Node = "03";
//FrmOffLineOperation frm = new FrmOffLineOperation(Node, this.ob, PlineCode, stoveno, lotno);
//if (frm.ShowDialog() == DialogResult.OK)
//{
// ultraGridTC();
//}
}
public void BackLine1()
{
//工序状态：01-矫直1#,02-矫直2#,03-矫直3#,11-ET探伤，12-MT探伤，13-UT探伤
string Node = "01";
BackLineOperate frm = new BackLineOperate(Node, this.ob, PlineCode, stoveno, lotno);
if (frm.ShowDialog() == DialogResult.OK)
{
ultraGridTC();
}
}
public void BackLine2()
{
//工序状态：01-矫直1#,02-矫直2#,03-矫直3#,11-ET探伤，12-MT探伤，13-UT探伤
string Node = "02";
BackLineOperate frm = new BackLineOperate(Node, this.ob, PlineCode, stoveno, lotno);
if (frm.ShowDialog() == DialogResult.OK)
{
ultraGridTC();
}
}
public void BackLine3()
{
if (!PlineCode.Equals("C010"))
{
MessageBox.Show("本产线不是168产线，没有3#矫直台，不允许执行3#台下线操作", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
//工序状态：01-矫直1#,02-矫直2#,03-矫直3#,11-ET探伤，12-MT探伤，13-UT探伤
string Node = "03";
BackLineOperate frm = new BackLineOperate(Node, this.ob, PlineCode, stoveno, lotno);
if (frm.ShowDialog() == DialogResult.OK)
{
ultraGridTC();
}
}
private void ChangeShiftBack()
{
if (string.IsNullOrEmpty(this.ActiveJUDGE_STOVE_NO))
{
MessageBox.Show("您未选择任何计划，不允许进行交班回退操作", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
UltraGridRow ugr_plan = this.ultraGridPlan.ActiveRow;
string Status = ugr_plan.Cells["IS_START"].Value.ToString();
if (Status == "已完成矫直")
{
MessageBox.Show("炉号：【" + ActiveJUDGE_STOVE_NO + "】已完成矫直操作，不允许进行交班取消！", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
if (Status == "未开始矫直")
{
MessageBox.Show("炉号：【" + ActiveJUDGE_STOVE_NO + "】未开始矫直操作，不允许进行交班取消！", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
string Shift = UserInfo.GetUserOrder();
string Group = UserInfo.GetUserGroup();
NativeMethodNew na = new NativeMethodNew(this.ob);
if (na.ChangeShiftBackCheck(this.ActiveJUDGE_STOVE_NO, this.ActiveResultNo, this.PlineCode, Shift, Group, 7, "1") || na.ChangeShiftBackCheck(this.ActiveJUDGE_STOVE_NO, this.ActiveResultNo, this.PlineCode, Shift, Group, 7, "2") || na.ChangeShiftBackCheck(this.ActiveJUDGE_STOVE_NO, this.ActiveResultNo, this.PlineCode, Shift, Group, 7, "3") || na.ChangeShiftBackCheckelse(this.ActiveJUDGE_STOVE_NO, this.ActiveResultNo, this.PlineCode, Shift, Group, 7, "1", proPlanId, gxPlanNo) || na.ChangeShiftBackCheckelse(this.ActiveJUDGE_STOVE_NO, this.ActiveResultNo, this.PlineCode, Shift, Group, 7, "2", proPlanId, gxPlanNo) || na.ChangeShiftBackCheckelse(this.ActiveJUDGE_STOVE_NO, this.ActiveResultNo, this.PlineCode, Shift, Group, 7, "3", proPlanId, gxPlanNo))
{
int count = na.ChangeShiftBack(this.ActiveJUDGE_STOVE_NO, this.ActiveResultNo, this.PlineCode, Shift, Group, 7, "1", proPlanId, gxPlanNo);
na.ChangeShiftBack(this.ActiveJUDGE_STOVE_NO, this.ActiveResultNo, this.PlineCode, Shift, Group, 7, "2", proPlanId, gxPlanNo);
if (this.PlineCode.Equals("C010"))
{
na.ChangeShiftBack(this.ActiveJUDGE_STOVE_NO, this.ActiveResultNo, this.PlineCode, Shift, Group, 7, "3", proPlanId, gxPlanNo);
}
if (count < 1)
{
//MessageBox.Show("交班回退失败， 请确认后重新操作", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
else
{
switch (Shift)
{
case "1":
Shift = "早班";
break;
case "2":
Shift = "中班";
break;
case "3":
Shift = "夜班";
break;
}
switch (Group)
{
case "1":
Group = "甲班";
break;
case "2":
Group = "乙班";
break;
case "3":
Group = "丙班";
break;
case "4":
Group = "丁班";
break;
}
MessageBox.Show("炉号【" + BaseMethod.getJudgeStoveNo(ActiveJUDGE_STOVE_NO) + "】未在" + Group + "，" + Shift + "进行交班操作，不允许进行交班取消操作");
return;
}
GetStraightResult(ActiveJUDGE_STOVE_NO, PlineCode);//更新实绩
ultraGridTC();
ChangeGridColor();
}
private void PrintResult()
{
DateTime SeverTime = NativeMethod.GetSeverTime(this.ob);
string Time = SeverTime.ToLongTimeString();
string StartTime = "";
string EndTime = "";
string strurl = "";
switch (PlineCode)
{
case "C008": //250
//晚班
Time = Time.Replace(":", "");
if (int.Parse(Time) < 070000)
{
StartTime = SeverTime.AddDays(-1).ToShortDateString() + " 07:00:00";
EndTime = SeverTime.ToShortDateString() + " 07:00:00";
string Date2 = SeverTime.ToString("yyyy-MM-dd");
strurl = "http://172.54.10.42:8080/webroot/decision/view/report?viewlet=RepMilStraighteningResult250.cpt&format=pdf&SHIFT=" + Shift + "&GROUP=" + Group + "&DATE=" + StartTime + "&PLINECODE=" + PlineCode + "&DATE2=" + EndTime + "&USERID=" + _UserID;
}
else
{
StartTime = SeverTime.ToShortDateString() + " 07:00:00";
EndTime = SeverTime.AddDays(1).ToShortDateString() + " 07:00:00";
strurl = "http://172.54.10.42:8080/webroot/decision/view/report?viewlet=RepMilStraighteningResult250.cpt&format=pdf&SHIFT=" + Shift + "&GROUP=" + Group + "&DATE=" + StartTime + "&PLINECODE=" + PlineCode + "&DATE2=" + EndTime + "&USERID=" + _UserID;
}
break;
case "C009": //258
//晚班
Time = Time.Replace(":", "");
if (int.Parse(Time) < 070000)
{
StartTime = SeverTime.AddDays(-1).ToShortDateString() + " 07:00:00";
EndTime = SeverTime.ToShortDateString() + " 07:00:00";
string Date2 = SeverTime.ToString("yyyy-MM-dd");
strurl = "http://172.54.10.42:8080/webroot/decision/view/report?viewlet=RepMilStraighteningResult258.cpt&format=pdf&SHIFT=" + Shift + "&GROUP=" + Group + "&DATE=" + StartTime + "&PLINECODE=" + PlineCode + "&DATE2=" + EndTime + "&USERID=" + _UserID;
}
else
{
StartTime = SeverTime.ToShortDateString() + " 07:00:00";
EndTime = SeverTime.AddDays(1).ToShortDateString() + " 07:00:00";
strurl = "http://172.54.10.42:8080/webroot/decision/view/report?viewlet=RepMilStraighteningResult258.cpt&format=pdf&SHIFT=" + Shift + "&GROUP=" + Group + "&DATE=" + StartTime + "&PLINECODE=" + PlineCode + "&DATE2=" + EndTime + "&USERID=" + _UserID;
}
break;
case "C010": //168
//晚班
Time = Time.Replace(":", "");
if (int.Parse(Time) < 070000)
{
StartTime = SeverTime.AddDays(-1).ToShortDateString() + " 07:00:00";
EndTime = SeverTime.ToShortDateString() + " 07:00:00";
string Date2 = SeverTime.ToString("yyyy-MM-dd");
strurl = "http://172.54.10.42:8080/webroot/decision/view/report?viewlet=RepMilStraighteningResult168.cpt&format=pdf&SHIFT=" + Shift + "&GROUP=" + Group + "&DATE=" + StartTime + "&PLINECODE=" + PlineCode + "&DATE2=" + EndTime + "&USERID=" + _UserID;
}
else
{
StartTime = SeverTime.ToShortDateString() + " 07:00:00";
EndTime = SeverTime.AddDays(1).ToShortDateString() + " 07:00:00";
strurl = "http://172.54.10.42:8080/webroot/decision/view/report?viewlet=RepMilStraighteningResult168.cpt&format=pdf&SHIFT=" + Shift + "&GROUP=" + Group + "&DATE=" + StartTime + "&PLINECODE=" + PlineCode + "&DATE2=" + EndTime + "&USERID=" + _UserID;
}
break;
case "C012": //Arssel
break;
case "C017": //460
//晚班
Time = Time.Replace(":", "");
if (int.Parse(Time) < 070000)
{
StartTime = SeverTime.AddDays(-1).ToShortDateString() + " 07:00:00";
EndTime = SeverTime.ToShortDateString() + " 07:00:00";
string Date2 = SeverTime.ToString("yyyy-MM-dd");
strurl = "http://172.54.10.42:8080/webroot/decision/view/report?viewlet=RepMilStraighteningResult460.cpt&format=pdf&SHIFT=" + Shift + "&GROUP=" + Group + "&DATE=" + StartTime + "&PLINECODE=" + PlineCode + "&DATE2=" + EndTime + "&USERID=" + _UserID;
}
else
{
StartTime = SeverTime.ToShortDateString() + " 07:00:00";
EndTime = SeverTime.AddDays(1).ToShortDateString() + " 07:00:00";
strurl = "http://172.54.10.42:8080/webroot/decision/view/report?viewlet=RepMilStraighteningResult460.cpt&format=pdf&SHIFT=" + Shift + "&GROUP=" + Group + "&DATE=" + StartTime + "&PLINECODE=" + PlineCode + "&DATE2=" + EndTime + "&USERID=" + _UserID;
}
break;
case "C072": //508
//晚班
Time = Time.Replace(":", "");
if (int.Parse(Time) < 070000)
{
StartTime = SeverTime.AddDays(-1).ToShortDateString() + " 07:00:00";
EndTime = SeverTime.ToShortDateString() + " 07:00:00";
string Date2 = SeverTime.ToString("yyyy-MM-dd");
strurl = "http://172.54.10.42:8080/webroot/decision/view/report?viewlet=RepMilStraighteningResult508.cpt&SHIFT=" + Shift + "&GROUP=" + Group + "&DATE=" + StartTime + "&PLINECODE=" + PlineCode + "&DATE2=" + EndTime + "&USERID=" + _UserID;
}
else
{
StartTime = SeverTime.ToShortDateString() + " 07:00:00";
EndTime = SeverTime.AddDays(1).ToShortDateString() + " 07:00:00";
strurl = "http://172.54.10.42:8080/webroot/decision/view/report?viewlet=RepMilStraighteningResult508.cpt&SHIFT=" + Shift + "&GROUP=" + Group + "&DATE=" + StartTime + "&PLINECODE=" + PlineCode + "&DATE2=" + EndTime + "&USERID=" + _UserID;
}
break;
}
FrmExcel fre = new FrmExcel(this.ob, strurl);
//FrmRepExcel fre = new FrmRepExcel(ob, strurl);
fre.AutoSize = true;
fre.MaximumSize = new Size(Screen.PrimaryScreen.WorkingArea.Width, Screen.PrimaryScreen.WorkingArea.Height);
fre.WindowState = FormWindowState.Maximized;
fre.Show();
}
public void colchang()
{
if (string.IsNullOrEmpty(ActiveJUDGE_STOVE_NO))
{
MessageBox.Show("您未选择任何住计划，不允许执行子管换台操作", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
DataTable ds = ServerHelper.GetData("com.steering.mes.zgmil.coup.FrmStraighteningResult.getSingePlanFlag", new object[] { ActiveJUDGE_STOVE_NO, proPlanId, gxPlanNo }, this.ob);
if (!ds.Rows[0]["BACK_PLAN_FLAG"].ToString().Equals("7"))
{
DataTable dtResult = ServerHelper.GetData("com.steering.mes.zgmil.coup.FrmStraighteningResult.getPerResult", new object[] { ActiveJUDGE_STOVE_NO, proPlanId, gxPlanNo }, this.ob);
DataTable dtFlag = ServerHelper.GetData("com.steering.mes.zgmil.coup.FrmStraighteningResult.GetSingleJRLResult", new object[] { ActiveJUDGE_STOVE_NO, proPlanId, gxPlanNo }, this.ob);
if (dtFlag.Rows.Count == 0)
{
MessageBox.Show("炉号：【" + ActiveJUDGE_STOVE_NO + "】尚开始分切，不允许进行子管换台操作", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
if (string.IsNullOrEmpty(dtFlag.Rows[0]["NODE_FUR_FLAG"].ToString()))
{
MessageBox.Show("炉号：【" + ActiveJUDGE_STOVE_NO + "】尚开始分切，不允许进行子管换台操作", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
if (!dtFlag.Rows[0]["NODE_FUR_FLAG"].ToString().Equals("1"))
{
MessageBox.Show("炉号：【" + ActiveJUDGE_STOVE_NO + "】分切工序尚未结炉，不允许进行子管换台操作", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
if (dtResult.Rows.Count == 0)
{
MessageBox.Show("炉号：【" + ActiveJUDGE_STOVE_NO + "】尚开始矫直，不允许进行子管换台操作", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
if (string.IsNullOrEmpty(dtResult.Rows[0]["NODE_FUR_FLAG"].ToString()))
{
MessageBox.Show("炉号：【" + ActiveJUDGE_STOVE_NO + "】尚开始矫直，不允许进行子管换台操作", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
if (dtResult.Rows[0]["NODE_FUR_FLAG"].ToString().Equals("1"))
{
MessageBox.Show("炉号：【" + ActiveJUDGE_STOVE_NO + "】已完成矫直，不允许进行子管换台操作", "提示：", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
}
ColNoChanges col = new ColNoChanges(this.ob, "00", ActiveJUDGE_STOVE_NO, PlineCode, proPlanId, gxPlanNo);
col.StartPosition = System.Windows.Forms.FormStartPosition.CenterParent;
if (col.ShowDialog() == DialogResult.OK)
{
PlanQuery();
GetStraightResult(ActiveJUDGE_STOVE_NO, PlineCode);//更新实绩
GetRollingCard();//更新流通卡
ChangeGridColor();
//this.ultraGridTC();
//ChangeGridColor();
}
}
#endregion
}
}