private void _gridFTHelper_DomainObjectToExportRow(object sender, EventArgs e) { if ((e as DomainObjectToExportRowEventArgs).DomainObject != null) { int electriccount = GetElectricCount(); OQCFuncTestValueDetail testValue = (e as DomainObjectToExportRowEventArgs).DomainObject as OQCFuncTestValueDetail; string[] objs = new string[7 + electriccount]; OQCFuncTestValue FTV = GetFTV(testValue); objs[0] = testValue.RunningCard; objs[1] = testValue.LotNO; objs[2] = testValue.GroupSequence.ToString(); if (FTV != null) { objs[3] = FTV.MinDutyRatoMin.ToString("0.00") + "/" + FTV.MinDutyRatoMax.ToString("0.00") + "/" + FTV.MinDutyRatoValue.ToString("0.00"); objs[4] = FTV.BurstMdFreMin.ToString("0.00") + "/" + FTV.BurstMdFreMax.ToString("0.00") + "/" + FTV.BurstMdFreValue.ToString("0.00"); } else { objs[3] = ""; objs[4] = ""; } objs[5] = testValue.FreMin.ToString("0.00") + "/" + testValue.FreMax.ToString("0.00") + "/" + testValue.FreValue.ToString("0.00"); objs[6] = testValue.ElectricMin.ToString("0.00") + "/" + testValue.ElectricMax.ToString("0.00"); //+"/"+testValue.ElectricValue.ToString("0.00"); object[] details = GetGroupEleDetails(testValue); if (htEleSeq == null) { htEleSeq = new Hashtable(); } string strKey = testValue.RunningCard + ":" + testValue.RunningCardSequence + ":" + testValue.GroupSequence.ToString(); if (htEleSeq.ContainsKey(strKey) == false) { htEleSeq.Add(strKey, 0); } int iStartIdx = Convert.ToInt32(htEleSeq[strKey]); for (int i = 0; i < electriccount; i++) { if (i < details.Length) { OQCFuncTestValueEleDetail d = (OQCFuncTestValueEleDetail)details[i + iStartIdx]; objs[i + 7] = /*d.ElectricMin.ToString("0.00")+"/"+d.ElectricMax.ToString("0.00")+"/"+*/ d.ElectricValue.ToString("0.00"); } else { objs[i + 7] = ""; } } htEleSeq[strKey] = iStartIdx + electriccount; (e as DomainObjectToExportRowEventArgs).ExportRow = objs; } }
private object[] GetGroupEleDetails(OQCFuncTestValueDetail testValue) { ArrayList list = new ArrayList(); foreach (OQCFuncTestValueEleDetail d in this.EleDetails) { if (d.RunningCard == testValue.RunningCard && d.RunningCardSequence == testValue.RunningCardSequence && d.GroupSequence == testValue.GroupSequence) { list.Add(d); } } return(list.ToArray()); }
private OQCFuncTestValue GetFTV(OQCFuncTestValueDetail testValue) { if (this.OQCFuncTestValues == null) { return(null); } foreach (OQCFuncTestValue v in OQCFuncTestValues) { if (testValue.RunningCard == v.RunningCard && testValue.RunningCardSequence == v.RunningCardSequence && testValue.LotNO == v.LotNO && testValue.LotSequence == v.LotSequence) { return(v); } } return(null); }
protected override string[] FormatExportRecord(object obj) { OQCFuncTestValueDetail testValue = obj as OQCFuncTestValueDetail; string[] objs = new string[3 + this.electriccount]; objs[0] = testValue.GroupSequence.ToString(); objs[1] = testValue.FreMin.ToString("0.00") + "/" + testValue.FreMax.ToString("0.00") + "/" + testValue.FreValue.ToString("0.00"); objs[2] = testValue.ElectricMin.ToString("0.00") + "/" + testValue.ElectricMax.ToString("0.00"); //+"/"+testValue.ElectricValue.ToString("0.00"); object[] details = GetGroupEleDetails(testValue); if (htEleSeq == null) { htEleSeq = new Hashtable(); } string strKey = testValue.RunningCard + ":" + testValue.RunningCardSequence + ":" + testValue.GroupSequence.ToString(); if (htEleSeq.ContainsKey(strKey) == false) { htEleSeq.Add(strKey, 0); } int iStartIdx = Convert.ToInt32(htEleSeq[strKey]); for (int i = 0; i < electriccount; i++) { if (i < details.Length) { OQCFuncTestValueEleDetail d = (OQCFuncTestValueEleDetail)details[iStartIdx + i]; objs[i + 3] = /*d.ElectricMin.ToString("0.00")+"/"+d.ElectricMax.ToString("0.00")+"/"+*/ d.ElectricValue.ToString("0.00"); } else { objs[i + 3] = ""; } } htEleSeq[strKey] = iStartIdx + electriccount; return(objs); }
protected override Infragistics.WebUI.UltraWebGrid.UltraGridRow GetGridRow(object obj) { OQCFuncTestValueDetail testValue = obj as OQCFuncTestValueDetail; object[] objs = new object[3 + this.electriccount]; objs[0] = testValue.GroupSequence; objs[1] = testValue.FreMin.ToString("0.00") + "/" + testValue.FreMax.ToString("0.00") + "/" + testValue.FreValue.ToString("0.00"); objs[2] = testValue.ElectricMin.ToString("0.00") + "/" + testValue.ElectricMax.ToString("0.00"); //+"/"+testValue.ElectricValue.ToString("0.00"); object[] details = GetGroupEleDetails(testValue); if (htEleSeq == null) { htEleSeq = new Hashtable(); } string strKey = testValue.RunningCard + ":" + testValue.RunningCardSequence + ":" + testValue.GroupSequence.ToString(); if (htEleSeq.ContainsKey(strKey) == false) { htEleSeq.Add(strKey, 0); } int iStartIdx = Convert.ToInt32(htEleSeq[strKey]); for (int i = 0; i < electriccount; i++) { if (i < details.Length) { OQCFuncTestValueEleDetail d = (OQCFuncTestValueEleDetail)details[iStartIdx + i]; objs[i + 3] = d.ElectricValue.ToString("0.00"); } else { objs[i + 3] = ""; } } htEleSeq[strKey] = iStartIdx + electriccount; /* * BenQGuru.eMES.SPCDataCenter.DataEntry dataEntry = (BenQGuru.eMES.SPCDataCenter.DataEntry)obj; * if (htSpec == null) * { * htSpec = new Hashtable(); * string strSql = "SELECT * FROM tblOQCFuncTestSpec WHERE ItemCode='" + dataEntry.ItemCode + "'"; * object[] objsSpec = this.DataProvider.CustomQuery(typeof(OQCFuncTestSpec), new BenQGuru.eMES.Common.Domain.SQLCondition(strSql)); * if (objsSpec != null) * { * for (int i = 0; i < objsSpec.Length; i++) * { * OQCFuncTestSpec spec = (OQCFuncTestSpec)objsSpec[i]; * if (htSpec.ContainsKey(Convert.ToInt32(spec.GroupSequence)) == false) * { * htSpec.Add(Convert.ToInt32(spec.GroupSequence), spec); * } * } * } * } * int iGroupCount = 0; * for (int i = 0; i < dataEntry.ListTestData.Count; i++) * { * BenQGuru.eMES.SPCDataCenter.DataEntryTestData testData = (BenQGuru.eMES.SPCDataCenter.DataEntryTestData)dataEntry.ListTestData[i]; * if (iGroupCount < testData.GroupSequence) * iGroupCount = Convert.ToInt32(testData.GroupSequence); * } * this.pagerToolBar.RowCount = this.pagerToolBar.RowCount - 1 + iGroupCount; * object[] objs = null; * for (int i = 1; i <= iGroupCount; i++) * { * OQCFuncTestSpec spec = new OQCFuncTestSpec(); * if (htSpec.ContainsKey(i) == true) * spec = (OQCFuncTestSpec)htSpec[i]; * objs = new object[3 + this.electriccount]; * objs[0] = i; * objs[2] = spec.ElectricMin.ToString("0.00") + "/" + spec.ElectricMax.ToString("0.00"); * for (int n = 0; n < dataEntry.ListTestData.Count; n++) * { * BenQGuru.eMES.SPCDataCenter.DataEntryTestData testData = (BenQGuru.eMES.SPCDataCenter.DataEntryTestData)dataEntry.ListTestData[n]; * if (testData.ObjectCode == SPCObjectList.OQC_FT_FREQUENCY && testData.GroupSequence == i) * { * objs[1] = spec.FreMin.ToString("0.00") + "/" + spec.FreMax.ToString("0.00") + "/" + Convert.ToDecimal(testData.Data).ToString("0.00"); * } * if (testData.ObjectCode == SPCObjectList.OQC_FT_ELECTRIC && testData.GroupSequence == i) * { * decimal[] dvalue = (decimal[])testData.Data; * for (int x = 0; x < this.electriccount; x++) * { * objs[3 + x] = dvalue[x].ToString("0.00"); * } * } * } * if (i < iGroupCount) * { * this.gridWebGrid.Rows.Add(new Infragistics.WebUI.UltraWebGrid.UltraGridRow( objs )); * } * } */ return(new Infragistics.WebUI.UltraWebGrid.UltraGridRow(objs)); }