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; } } }