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 Core.Mes.Client.Comm.Control;
using Infragistics.Win.UltraWinGrid;
using CoreFS.CA06;
using Core.Mes.Client.Comm.Server;
using Core.StlMes.Client.ZGMil.Common;
namespace Core.StlMes.Client.ZGMil.NodeResultQuery
{
public partial class FrmNodeResultQuery : FrmBase
{
string JudgeStoveNo = "";
string ResultNo = "";
int _ProcessNo = 0;
int FeedNum = 0;
int ScrapFeedNum = 0;
int ScrapNum = 0;
int QANum = 0;
int ChangeNum = 0;
double QYHeight = 0;
double QYLength = 0;
double QAHeight = 0;
OpeBase _ob = null;
int DETECTION_NUM = 0;//检测支数
int SUSPECT_PRODUCT_NUM = 0;//可疑品支数
int REINSPECTION_NUM = 0;//复探支数
int REINSPECTION_QUALIFIED_NUM = 0;//复探合格支数
int SCRAP_NUM = 0;//最终废品支数
int QUALIFIED_NUM = 0;//最终合格支数
int SCRAP_NUM1 = 0;//1‘操作台矫废支数
int QUALIFIED_NUM1 = 0;//1’操作台合格支数
int SCRAP_NUM2 = 0;//2‘操作台矫废支数
int QUALIFIED_NUM2 = 0;//2’操作台合格支数
int SCRAP_NUM3 = 0;//3‘操作台矫废支数
int QUALIFIED_NUM3 = 0;//3’操作台合格支数
int IN_MAT_NUM = 0;//来料支数
// int SCRAP_NUM = 0;//最终废品支数
// int QUALIFIED_NUM = 0;//最终合格支数
///
///
///
///
/// 1-锯切 2-加热炉 3-穿孔 4-连轧 5-再加热炉 6-定径 7-ET探伤 8-人工质检 9-分切 10-矫直 11-MT 12-UT
public FrmNodeResultQuery(DataTable dt, int ProcessNo, string Date, string Shift, string Group, OpeBase ob)
{
DataTable refdt = new DataTable();
InitializeComponent();
_ProcessNo = ProcessNo;
_ob = ob;
switch (Shift)
{
case "0":
Shift = "常白班";
break;
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;
}
switch (ProcessNo)
{
case 1:
refdt = dtFeed;
ultraTabControl1.Tabs[0].Visible = true;
ultraTabControl1.Tabs[1].Visible = false;
ultraTabControl1.Tabs[2].Visible = false;
ultraTabControl1.Tabs[3].Visible = false;
ultraTabControl1.Tabs[4].Visible = false;
ultraTabControl1.Tabs[5].Visible = false;
GridDisplay(ProcessNo - 1);
break;
case 2:
refdt = dtFur;
ultraTabControl1.Tabs[0].Visible = false;
ultraTabControl1.Tabs[1].Visible = true;
ultraTabControl1.Tabs[2].Visible = false;
ultraTabControl1.Tabs[3].Visible = false;
ultraTabControl1.Tabs[4].Visible = false;
ultraTabControl1.Tabs[5].Visible = false;
GridDisplay(ProcessNo - 1);
break;
case 3:
refdt = dtPer;
ultraTabControl1.Tabs[0].Visible = false;
ultraTabControl1.Tabs[1].Visible = true;
ultraTabControl1.Tabs[2].Visible = false;
ultraTabControl1.Tabs[3].Visible = false;
ultraTabControl1.Tabs[4].Visible = false;
ultraTabControl1.Tabs[5].Visible = false;
GridDisplay(ProcessNo - 1);
break;
case 4:
refdt = dtRoll;
ultraTabControl1.Tabs[0].Visible = false;
ultraTabControl1.Tabs[1].Visible = true;
ultraTabControl1.Tabs[2].Visible = false;
ultraTabControl1.Tabs[3].Visible = false;
ultraTabControl1.Tabs[4].Visible = false;
ultraTabControl1.Tabs[5].Visible = false;
GridDisplay(ProcessNo - 1);
break;
case 5:
refdt = dtReFur;
ultraTabControl1.Tabs[0].Visible = false;
ultraTabControl1.Tabs[1].Visible = true;
ultraTabControl1.Tabs[2].Visible = false;
ultraTabControl1.Tabs[3].Visible = false;
ultraTabControl1.Tabs[4].Visible = false;
ultraTabControl1.Tabs[5].Visible = false;
GridDisplay(ProcessNo - 1);
break;
case 6:
refdt = dtSizing;
ultraTabControl1.Tabs[0].Visible = false;
ultraTabControl1.Tabs[1].Visible = true;
ultraTabControl1.Tabs[2].Visible = false;
ultraTabControl1.Tabs[3].Visible = false;
ultraTabControl1.Tabs[4].Visible = false;
ultraTabControl1.Tabs[5].Visible = false;
GridDisplay(ProcessNo - 1);
break;
case 7:
refdt = dtETResult;
ultraTabControl1.Tabs[0].Visible = false;
ultraTabControl1.Tabs[1].Visible = false;
ultraTabControl1.Tabs[2].Visible = false;
ultraTabControl1.Tabs[3].Visible = false;
ultraTabControl1.Tabs[4].Visible = false;
ultraTabControl1.Tabs[5].Visible = true;
GridDisplay(ProcessNo - 1);
break;
case 8:
refdt = dtSurface;
ultraTabControl1.Tabs[0].Visible = false;
ultraTabControl1.Tabs[1].Visible = true;
label16.Text = "废品量";
ultraTabControl1.Tabs[2].Visible = false;
ultraTabControl1.Tabs[3].Visible = false;
ultraTabControl1.Tabs[4].Visible = false;
ultraTabControl1.Tabs[5].Visible = false;
GridDisplay(ProcessNo - 1);
break;
case 9:
refdt = dtSawResult;
ultraTabControl1.Tabs[0].Visible = false;
ultraTabControl1.Tabs[1].Visible = false;
ultraTabControl1.Tabs[2].Visible = false;
ultraTabControl1.Tabs[3].Visible = true;
ultraTabControl1.Tabs[4].Visible = false;
ultraTabControl1.Tabs[5].Visible = false;
GridDisplay(ProcessNo - 1);
break;
case 10:
refdt = dtStraight;
ultraTabControl1.Tabs[0].Visible = false;
ultraTabControl1.Tabs[1].Visible = false;
ultraTabControl1.Tabs[2].Visible = false;
ultraTabControl1.Tabs[3].Visible = false;
ultraTabControl1.Tabs[4].Visible = true;
ultraTabControl1.Tabs[5].Visible = false;
GridDisplay(ProcessNo - 1);
break;
case 11:
refdt = dtMT;
ultraTabControl1.Tabs[0].Visible = false;
ultraTabControl1.Tabs[1].Visible = false;
ultraTabControl1.Tabs[2].Visible = true;
ultraTabControl1.Tabs[3].Visible = false;
ultraTabControl1.Tabs[4].Visible = false;
ultraTabControl1.Tabs[5].Visible = false;
GridDisplay(ProcessNo - 1);
break;
case 12:
refdt = dtUT;
ultraTabControl1.Tabs[0].Visible = false;
ultraTabControl1.Tabs[1].Visible = false;
ultraTabControl1.Tabs[2].Visible = true;
ultraTabControl1.Tabs[3].Visible = false;
ultraTabControl1.Tabs[4].Visible = false;
ultraTabControl1.Tabs[5].Visible = false;
GridDisplay(ProcessNo - 1);
break;
}
txtDate.Text = Date;
txtShift.Text = Shift;
txtGroup.Text = Group;
refdt.Clear();
// ultraGrid1.DataSource = refdt;
GridHelper.CopyDataToDatatable(ref dt, ref refdt, true);
TotalEdit(ProcessNo);
}
public void TotalEdit(int ProcessNo)
{
switch (ProcessNo)
{
case 1:
FeedTotalData();
break;
case 2:
FurTotalData();
break;
case 3:
PerTotalData();
break;
case 4:
RollTotalData();
break;
case 5:
ReFurTotalData();
break;
case 6:
SizingTotalData();
break;
case 7:
ETResultTotalData();
break;
case 8:
SurfaceTotalData();
break;
case 9:
SAWResultTotalData();
break;
case 10:
StraightTotalData();
break;
case 11:
MTandUTTotalData();
break;
case 12:
MTandUTTotalData();
break;
}
}
///
/// 上料数据统计
///
public void FeedTotalData()
{
if (ultraGrid0.Rows.Count > 0)
{
foreach (UltraGridRow ugr in ultraGrid0.Rows)
{
ugr.Cells["JUDGE_NO"].Value = BaseMethod.getJudgeStoveNo(ugr.Cells["JUDGE_STOVE_NO"].Value.ToString());
ScrapFeedNum += Convert.ToInt32(ugr.Cells["BEFORE_SCRAP_NUM"].Value.ToString());
ScrapNum += Convert.ToInt32(ugr.Cells["AFTER_SCRAP_NUM"].Value.ToString());
QANum += Convert.ToInt32(ugr.Cells["CUT_NUM"].Value.ToString());
if (!string.IsNullOrEmpty(ugr.Cells["CHANGE_NUM"].Value.ToString()))
{
ChangeNum += 0;
}
else
{
ChangeNum += Convert.ToInt32(ugr.Cells["CHANGE_NUM"].Value.ToString());
}
if (!string.IsNullOrEmpty(ugr.Cells["CUT_WEIGHT"].Value.ToString()))
{
QYHeight += Convert.ToDouble(ugr.Cells["CUT_WEIGHT"].Value.ToString());
}
else
{
QYHeight += 0;
}
QYLength += Convert.ToDouble(ugr.Cells["CUT_LENGTH"].Value.ToString());
if (!string.IsNullOrEmpty(ugr.Cells["QA_TON"].Value.ToString()))
{
QAHeight += Convert.ToDouble(ugr.Cells["QA_TON"].Value.ToString());
}
else
{
QAHeight += 0;
}
}
//lblFeedNum.Text = FeedNum.ToString();
lblScrapFeedNum.Text = ScrapFeedNum.ToString();
lblScrapNum.Text = ScrapNum.ToString();
lblQANum.Text = (QANum-ChangeNum).ToString();
lblQYHeight.Text = QYHeight.ToString();
lblQYLength.Text = QYLength.ToString();
lblQATons.Text = QAHeight.ToString();
}
}
///
/// 加热炉数据统计
///
public void FurTotalData()
{
if (ultraGrid1.Rows.Count > 0)
{
foreach (UltraGridRow ugr in ultraGrid1.Rows)
{
ScrapNum += Convert.ToInt32(ugr.Cells["SCRAP_NUM"].Value.ToString());
QANum += Convert.ToInt32(ugr.Cells["OUT_FUR_NUM"].Value.ToString());
//QAHeight += Convert.ToDouble(ugr.Cells["CUT_HEIGHT"].Value.ToString());
double BurnningRate = 0;
ugr.Cells["JUDGE_NO"].Value = BaseMethod.getJudgeStoveNo(ugr.Cells["JUDGE_STOVE_NO"].Value.ToString());
ChangeNum += Convert.ToInt32(ugr.Cells["CHANGE_NUM"].Value.ToString());
if (!string.IsNullOrEmpty(ugr.Cells["QA_TON"].Value.ToString()))
{
QAHeight += Convert.ToDouble(ugr.Cells["QA_TON"].Value.ToString());
}
else
{
QAHeight += 0;
}
lblRollScrapNum.Text = ScrapNum.ToString();
lblRollQANum.Text = QANum.ToString();
lblRollTons.Text = QAHeight.ToString();
}
}
}
///
/// 穿孔数据统计
///
public void PerTotalData()
{
if (ultraGrid2.Rows.Count > 0)
{
foreach (UltraGridRow ugr in ultraGrid2.Rows)
{
ugr.Cells["JUDGE_NO"].Value = BaseMethod.getJudgeStoveNo(ugr.Cells["JUDGE_STOVE_NO"].Value.ToString());
ScrapNum += Convert.ToInt32(ugr.Cells["SCRAP_NUM"].Value.ToString());
QANum += Convert.ToInt32(ugr.Cells["PERFORATION_NUM"].Value.ToString());
if (!string.IsNullOrEmpty(ugr.Cells["QA_TON"].Value.ToString()))
{
QAHeight += Convert.ToDouble(ugr.Cells["QA_TON"].Value.ToString());
}
else
{
QAHeight += 0;
}
lblRollScrapNum.Text = ScrapNum.ToString();
lblRollQANum.Text = QANum.ToString();
lblRollTons.Text = QAHeight.ToString();
}
}
}
///
/// 连轧数据统计
///
public void RollTotalData()
{
if (ultraGrid3.Rows.Count > 0)
{
foreach (UltraGridRow ugr in ultraGrid3.Rows)
{
ScrapNum += Convert.ToInt32(ugr.Cells["SCRAP_NUM"].Value.ToString());
QANum += Convert.ToInt32(ugr.Cells["QUALIFIED_NUM"].Value.ToString());
ugr.Cells["JUDGE_NO"].Value = BaseMethod.getJudgeStoveNo(ugr.Cells["JUDGE_STOVE_NO"].Value.ToString());
if (!string.IsNullOrEmpty(ugr.Cells["QA_TON"].Value.ToString()))
{
QAHeight += Convert.ToDouble(ugr.Cells["QA_TON"].Value.ToString());
}
else
{
QAHeight += 0;
}
}
lblRollScrapNum.Text = ScrapNum.ToString();
lblRollQANum.Text = QANum.ToString();
lblRollTons.Text = QAHeight.ToString();
}
}
///
/// 再加热炉数据统计
///
public void ReFurTotalData()
{
if (ultraGrid4.Rows.Count > 0)
{
foreach (UltraGridRow ugr in ultraGrid4.Rows)
{
ScrapNum += Convert.ToInt32(ugr.Cells["SCRAP_NUM"].Value.ToString());
QANum += Convert.ToInt32(ugr.Cells["OUT_FUR_NUM"].Value.ToString());
ugr.Cells["JUDGE_NO"].Value = BaseMethod.getJudgeStoveNo(ugr.Cells["JUDGE_STOVE_NO"].Value.ToString());
if (!string.IsNullOrEmpty(ugr.Cells["QA_TON"].Value.ToString()))
{
QAHeight += Convert.ToDouble(ugr.Cells["QA_TON"].Value.ToString());
}
else
{
QAHeight += 0;
}
}
lblRollScrapNum.Text = ScrapNum.ToString();
lblRollQANum.Text = QANum.ToString();
lblRollTons.Text = QAHeight.ToString();
}
}
///
/// 定径数据统计
///
public void SizingTotalData()
{
if (ultraGrid5.Rows.Count > 0)
{
foreach (UltraGridRow ugr in ultraGrid5.Rows)
{
ScrapNum += Convert.ToInt32(ugr.Cells["SCRAP_NUM"].Value.ToString());
QANum += Convert.ToInt32(ugr.Cells["PRODUCT_NUM"].Value.ToString());
ugr.Cells["JUDGE_NO"].Value = BaseMethod.getJudgeStoveNo(ugr.Cells["JUDGE_STOVE_NO"].Value.ToString());
if (!string.IsNullOrEmpty(ugr.Cells["QA_TON"].Value.ToString()))
{
QAHeight += Convert.ToDouble(ugr.Cells["QA_TON"].Value.ToString());
}
else
{
QAHeight += 0;
}
}
lblRollScrapNum.Text = ScrapNum.ToString();
lblRollQANum.Text = QANum.ToString();
lblRollTons.Text = QAHeight.ToString();
}
}
///
/// 探伤实绩统计
///
public void ETResultTotalData()
{
if (this.ultraGrid6.Rows.Count > 0)
{
int scrap1 = 0; int qu1 = 0; int re1 = 0; int requ1 = 0; int de1 = 0; int su1 = 0;
int scrap2 = 0; int qu2 = 0; int re2 = 0; int requ2 = 0; int de2 = 0; int su2 = 0;
int scrap3 = 0; int qu3 = 0; int re3 = 0; int requ3 = 0; int de3 = 0; int su3 = 0;
foreach (UltraGridRow ugr in ultraGrid6.Rows)
{
scrap1 += Convert.ToInt32(ugr.Cells["SCRAP_NUM1"].Value.ToString());
qu1 += Convert.ToInt32(ugr.Cells["QUALIFIED_NUM1"].Value.ToString());
re1 += Convert.ToInt32(ugr.Cells["REINSPECTION_NUM1"].Value.ToString());
requ1 += Convert.ToInt32(ugr.Cells["REINSPECTION_QUALIFIED_NUM1"].Value.ToString());
de1 += Convert.ToInt32(ugr.Cells["DETECTION_NUM1"].Value.ToString());
su1 += Convert.ToInt32(ugr.Cells["SUSPECT_PRODUCT_NUM1"].Value.ToString());
scrap2 += Convert.ToInt32(ugr.Cells["SCRAP_NUM2"].Value.ToString());
qu2 += Convert.ToInt32(ugr.Cells["QUALIFIED_NUM2"].Value.ToString());
re2 += Convert.ToInt32(ugr.Cells["REINSPECTION_NUM2"].Value.ToString());
requ2 += Convert.ToInt32(ugr.Cells["REINSPECTION_QUALIFIED_NUM2"].Value.ToString());
de2 += Convert.ToInt32(ugr.Cells["DETECTION_NUM2"].Value.ToString());
su2 += Convert.ToInt32(ugr.Cells["SUSPECT_PRODUCT_NUM2"].Value.ToString());
scrap3 += Convert.ToInt32(ugr.Cells["SCRAP_NUM3"].Value.ToString());
qu3 += Convert.ToInt32(ugr.Cells["QUALIFIED_NUM3"].Value.ToString());
re3 += Convert.ToInt32(ugr.Cells["REINSPECTION_NUM3"].Value.ToString());
requ3 += Convert.ToInt32(ugr.Cells["REINSPECTION_QUALIFIED_NUM3"].Value.ToString());
de3 += Convert.ToInt32(ugr.Cells["DETECTION_NUM3"].Value.ToString());
su3 += Convert.ToInt32(ugr.Cells["SUSPECT_PRODUCT_NUM3"].Value.ToString());
}
labetscrp1.Text = scrap1.ToString();
labetqu1.Text = qu1.ToString();
labetre1.Text = re1.ToString();
labetrequ1.Text = requ1.ToString();
labetde1.Text = de1.ToString();
labetsu1.Text = su1.ToString();
labetscrp2.Text = scrap2.ToString();
labetqu2.Text = qu2.ToString();
labetre2.Text = re2.ToString();
labetrequ2.Text = requ2.ToString();
labetde2.Text = de2.ToString();
labetsu2.Text = su2.ToString();
labetscrp3.Text = scrap3.ToString();
labetqu3.Text = qu3.ToString();
labetre3.Text = re3.ToString();
labetrequ3.Text = requ3.ToString();
labetde3.Text = de3.ToString();
labetsu3.Text = su3.ToString();
labetscrptotal.Text = (scrap1 + scrap2 + scrap3).ToString();
labetqutotal.Text = (qu1 + qu2 + qu3).ToString();
labetretotal.Text = (re1 + re2 + re3).ToString();
labetrequtotal.Text = (requ1 + requ2 + requ3).ToString();
labetdetotal.Text = (de1 + de2 + de3).ToString();
labetsutotal.Text = (su1 + su2 + su3).ToString();
}
}
///
/// 分切实绩统计
///
public void SAWResultTotalData()
{
double CUT_HEAD_LENGTH_TOTAL = 0;
double CUT_TRAIL_LENGTH_TOTAL = 0;
double CUT_HEAD_HEIGHT_TOTAL = 0;
double CUT_TRAIL_HEIGTH_TOTAL = 0;
int SCRAP_NUM = 0;
int SCRAP_DBNUM = 0;
int CUT_NUM = 0;
int CUT_DBNUM = 0;
if (this.ultraGrid8.Rows.Count > 0)
{
foreach (UltraGridRow ugr in ultraGrid8.Rows)
{
CUT_HEAD_LENGTH_TOTAL += Convert.ToDouble(ugr.Cells["CUT_HEAD_LENGTH_TOTAL"].Value.ToString()); //切头总长度
CUT_TRAIL_LENGTH_TOTAL += Convert.ToDouble(ugr.Cells["CUT_TRAIL_LENGTH_TOTAL"].Value.ToString());// 切尾总长度
CUT_HEAD_HEIGHT_TOTAL += Convert.ToDouble(ugr.Cells["CUT_HEAD_HEIGHT_TOTAL"].Value.ToString());// 切头总重量
CUT_TRAIL_HEIGTH_TOTAL += Convert.ToDouble(ugr.Cells["CUT_TRAIL_HEIGTH_TOTAL"].Value.ToString());// 切尾总重量
SCRAP_NUM += Convert.ToInt32(ugr.Cells["SCRAP_NUM"].Value.ToString());// 切前剔除支数
SCRAP_DBNUM += Convert.ToInt32(ugr.Cells["SCRAP_DBNUM"].Value.ToString());// 剔除支数
CUT_NUM += Convert.ToInt32(ugr.Cells["CUT_NUM"].Value.ToString());// 切前合格支数
CUT_DBNUM += Convert.ToInt32(ugr.Cells["CUT_DBNUM"].Value.ToString());// 切后支数
}
//lable赋值
labCUT_HEAD_LENGTH_TOTAL.Text = Convert.ToString(CUT_HEAD_LENGTH_TOTAL);
labCUT_TRAIL_LENGTH_TOTAL.Text = Convert.ToString(CUT_TRAIL_LENGTH_TOTAL);
labCUT_HEAD_HEIGHT_TOTAL.Text = Convert.ToString(CUT_HEAD_HEIGHT_TOTAL);
labCUT_TRAIL_HEIGTH_TOTAL.Text = Convert.ToString(CUT_TRAIL_HEIGTH_TOTAL);
labSCRAP_NUM1.Text = Convert.ToString(SCRAP_NUM);
labSCRAP_DBNUM1.Text = Convert.ToString(SCRAP_DBNUM);
labCUT_NUM1.Text = Convert.ToString(CUT_NUM);
labCUT_DBNUM1.Text = Convert.ToString(CUT_DBNUM);
}
}
///
/// 结炉实绩统计
///
public void SurfaceTotalData()
{
if (this.ultraGrid7.Rows.Count > 0)
{
int num_QUALIFIED_BRANCH = 0;//合格支数
double num_QUALIFIED_TONS = 0.0;//合格吨数
double num_WASTE_QUANTITY = 0.0;//废品量
int num = 1;
double wgt = 0.0;
double wasteTon = 0.0;
foreach (UltraGridRow ugr in ultraGrid7.Rows)
{
int.TryParse(ugr.Cells["QUALIFIED_BRANCH"].Value.ToString(), out num);
num_QUALIFIED_BRANCH += num;//合格总支数
double.TryParse(ugr.Cells["QUALIFIED_TONS"].Value.ToString(), out wgt);
num_QUALIFIED_TONS += wgt;//合格总吨数
double.TryParse(ugr.Cells["WASTE_QUANTITY"].Value.ToString(), out wasteTon);
num_WASTE_QUANTITY += wasteTon;//废品总量
}
lblRollScrapNum.Text = num_WASTE_QUANTITY.ToString();
lblRollQANum.Text = num_QUALIFIED_BRANCH.ToString();
lblRollTons.Text = num_QUALIFIED_TONS.ToString();
}
}
///
/// 矫直实绩统计
///
public void StraightTotalData()
{
if (this.ultraGrid9.Rows.Count > 0)
{
foreach (UltraGridRow ugr in ultraGrid9.Rows)
{
SCRAP_NUM1 += Convert.ToInt32(ugr.Cells["SCRAP_NUM1"].Value.ToString()); //1‘操作台矫废支数
QUALIFIED_NUM1 += Convert.ToInt32(ugr.Cells["QUALIFIED_NUM1"].Value.ToString());//1’操作台合格支数
SCRAP_NUM2 += Convert.ToInt32(ugr.Cells["SCRAP_NUM2"].Value.ToString());//2‘操作台矫废支数
QUALIFIED_NUM2 += Convert.ToInt32(ugr.Cells["QUALIFIED_NUM2"].Value.ToString());//2’操作台合格支数
SCRAP_NUM3 += Convert.ToInt32(ugr.Cells["SCRAP_NUM3"].Value.ToString());//3‘操作台矫废支数
QUALIFIED_NUM3 += Convert.ToInt32(ugr.Cells["QUALIFIED_NUM3"].Value.ToString());//3’操作台合格支数
IN_MAT_NUM += Convert.ToInt32(ugr.Cells["IN_MAT_NUM"].Value.ToString());//来料支数
SCRAP_NUM += Convert.ToInt32(ugr.Cells["SCRAP_NUM"].Value.ToString());//来料支数;//最终废品支数
QUALIFIED_NUM += Convert.ToInt32(ugr.Cells["QUALIFIED_NUM"].Value.ToString());//来料支数;//最终合格支数
}
labSCRAP_NUM11.Text = SCRAP_NUM1.ToString();
labQUALIFIED_NUM11.Text = QUALIFIED_NUM1.ToString();
labSCRAP_NUM22.Text = SCRAP_NUM2.ToString();
labQUALIFIED_NUM22.Text = QUALIFIED_NUM2.ToString();
labSCRAP_NUM33.Text = SCRAP_NUM3.ToString();
labQUALIFIED_NUM33.Text = QUALIFIED_NUM3.ToString();
labIN_MAT_NUMs.Text = IN_MAT_NUM.ToString();
labSCRAP_NUMs.Text = SCRAP_NUM.ToString();
labQUALIFIED_NUMs.Text = QUALIFIED_NUM.ToString();
}
}
///
/// MT,UT统计
///
public void MTandUTTotalData()
{
if (ultraGrid11.Rows.Count >0||ultraGrid10.Rows.Count>0)
{
int scrap1 = 0; int qu1 = 0; int re1 = 0; int requ1 = 0; int de1 = 0; int su1 = 0;
int scrap2 = 0; int qu2 = 0; int re2 = 0; int requ2 = 0; int de2 = 0; int su2 = 0;
int scrap = 0; int qu = 0; int re = 0; int requ = 0; int de = 0; int su = 0;
double quweight = 0;
if (ultraGrid11.Rows.Count > 0)
{
foreach (UltraGridRow ugr in ultraGrid11.Rows)
{
scrap1 += Convert.ToInt32(ugr.Cells["SCRAP_NUM1"].Value.ToString());
qu1 += Convert.ToInt32(ugr.Cells["QUALIFIED_NUM1"].Value.ToString());
re1 += Convert.ToInt32(ugr.Cells["REINSPECTION_NUM1"].Value.ToString());
requ1 += Convert.ToInt32(ugr.Cells["REINSPECTION_QUALIFIED_NUM1"].Value.ToString());
de1 += Convert.ToInt32(ugr.Cells["DETECTION_NUM1"].Value.ToString());
su1 += Convert.ToInt32(ugr.Cells["SUSPECT_PRODUCT_NUM1"].Value.ToString());
scrap2 += Convert.ToInt32(ugr.Cells["SCRAP_NUM2"].Value.ToString());
qu2 += Convert.ToInt32(ugr.Cells["QUALIFIED_NUM2"].Value.ToString());
re2 += Convert.ToInt32(ugr.Cells["REINSPECTION_NUM2"].Value.ToString());
requ2 += Convert.ToInt32(ugr.Cells["REINSPECTION_QUALIFIED_NUM2"].Value.ToString());
de2 += Convert.ToInt32(ugr.Cells["DETECTION_NUM2"].Value.ToString());
su2 += Convert.ToInt32(ugr.Cells["SUSPECT_PRODUCT_NUM2"].Value.ToString());
}
}
if (ultraGrid10.Rows.Count > 0)
{
foreach (UltraGridRow ugr in ultraGrid10.Rows)
{
scrap1 += Convert.ToInt32(ugr.Cells["SCRAP_NUM1"].Value.ToString());
qu1 += Convert.ToInt32(ugr.Cells["QUALIFIED_NUM1"].Value.ToString());
re1 += Convert.ToInt32(ugr.Cells["REINSPECTION_NUM1"].Value.ToString());
requ1 += Convert.ToInt32(ugr.Cells["REINSPECTION_QUALIFIED_NUM1"].Value.ToString());
de1 += Convert.ToInt32(ugr.Cells["DETECTION_NUM1"].Value.ToString());
su1 += Convert.ToInt32(ugr.Cells["SUSPECT_PRODUCT_NUM1"].Value.ToString());
scrap2 += Convert.ToInt32(ugr.Cells["SCRAP_NUM2"].Value.ToString());
qu2 += Convert.ToInt32(ugr.Cells["QUALIFIED_NUM2"].Value.ToString());
re2 += Convert.ToInt32(ugr.Cells["REINSPECTION_NUM2"].Value.ToString());
requ2 += Convert.ToInt32(ugr.Cells["REINSPECTION_QUALIFIED_NUM2"].Value.ToString());
de2 += Convert.ToInt32(ugr.Cells["DETECTION_NUM2"].Value.ToString());
su2 += Convert.ToInt32(ugr.Cells["SUSPECT_PRODUCT_NUM2"].Value.ToString());
scrap += Convert.ToInt32(ugr.Cells["SCRAP_NUM"].Value.ToString());
qu += Convert.ToInt32(ugr.Cells["QUALIFIED_NUM"].Value.ToString());
re += Convert.ToInt32(ugr.Cells["REINSPECTION_NUM"].Value.ToString());
requ += Convert.ToInt32(ugr.Cells["REINSPECTION_QUALIFIED_NUM"].Value.ToString());
de += Convert.ToInt32(ugr.Cells["DETECTION_NUM"].Value.ToString());
su += Convert.ToInt32(ugr.Cells["ALARM_NUM"].Value.ToString());
quweight += double.Parse(ugr.Cells["QA_TON"].Value.ToString());
}
}
labmtscrap1.Text = scrap1.ToString();
labmtqu1.Text = qu1.ToString();
labmtre1.Text = re1.ToString();
labmtrequ1.Text = requ1.ToString();
labmtde1.Text = de1.ToString();
labmtsu1.Text = su1.ToString();
labmtscrap2.Text = scrap2.ToString();
labmtqu2.Text = qu2.ToString();
labmtre2.Text = re2.ToString();
labmtrequ2.Text = requ2.ToString();
labmtde2.Text = de2.ToString();
labmtsu2.Text = su2.ToString();
if (ultraGrid10.Rows.Count > 0)
{
labmtscraptotal.Text = (scrap).ToString();
labmtqutotal.Text = (qu).ToString();
labmtretotal.Text = (re).ToString();
labmtrequtotal.Text = (requ).ToString();
labmtdetotal.Text = (de).ToString();
labmtsutotal.Text = (su).ToString();
labmtquweight.Text = quweight.ToString();
}
else if (ultraGrid11.Rows.Count > 0)
{
labmtscraptotal.Text = (scrap1 + scrap2).ToString();
labmtqutotal.Text = (qu1 + qu2).ToString();
labmtretotal.Text = (re1 + re2).ToString();
labmtrequtotal.Text = (requ1 + requ2).ToString();
labmtdetotal.Text = (de1 + de2).ToString();
labmtsutotal.Text = (su1 + su2).ToString();
}
}
}
private void ultraGrid1_AfterCellUpdate(object sender, CellEventArgs e)
{
if (ultraGrid1.ActiveRow == null)
{
return;
}
JudgeStoveNo = ultraGrid1.ActiveRow.Cells["JUDGE_STOVE_NO"].Value.ToString();
ResultNo = ultraGrid1.ActiveRow.Cells["RESULT_NO"].Value.ToString();
string ColumnName = "";
string ColumnValue = "";
int Flag = 0;
if (e.Cell.Column.Key == "JUDGE_NO")
{
return;
}
else if (e.Cell.Column.Style == Infragistics.Win.UltraWinGrid.ColumnStyle.DateTime)
{
Flag = 1;
}
ColumnName = e.Cell.Column.Key;
ColumnValue = e.Cell.Value.ToString();
int count = ServerHelper.SetData("com.steering.mes.zgmil.coup.FeedSawResult.updateResult", new object[] { JudgeStoveNo, ResultNo, ColumnName, ColumnValue, _ProcessNo, Flag }, this._ob);
}
private void FrmNodeResultQuery_FormClosing(object sender, FormClosingEventArgs e)
{
ultraGrid1.UpdateData();
}
///
/// 结炉实绩TAB页显示控制
///
///
private void GridDisplay(int ProcessNo)
{
for (int i = 0; i < 12; i++)
{
ultraTabControl2.Tabs[i].Visible = false;
}
ultraTabControl2.Tabs[ProcessNo].Visible = true;
}
}
}