public void Koeff(Dictionary<double, List<double>> dict, Word.Table oTable)
{
int i = 2;
foreach (var coh in dict)
{
int m = 0;
double alg_2_4 = 0;
double alg_2_5 = 0;
double alg_2_6 = 0;
double alg_3_4 = 0;
double alg_3_5 = 0;
double alg_3_6 = 0;
double alg_12_4 = 0;
double alg_12_5 = 0;
double alg_12_6 = 0;
List<double> list_Keap = coh.Value;
for (int j = 0; j < list_Keap.Count; j += 9)
{
alg_2_4 += list_Keap[j];
alg_2_5 += list_Keap[j + 1];
alg_2_6 += list_Keap[j + 2];
alg_3_4 += list_Keap[j + 3];
alg_3_5 += list_Keap[j + 4];
alg_3_6 += list_Keap[j + 5];
alg_12_4 += list_Keap[j + 6];
alg_12_5 += list_Keap[j + 7];
alg_12_6 += list_Keap[j + 8];
m++;
}
alg_2_4 = alg_2_4 / m;
alg_2_5 = alg_2_5 / m;
alg_2_6 = alg_2_6 / m;
alg_3_4 = alg_2_4 / m;
alg_3_5 = alg_2_5 / m;
alg_3_6 = alg_2_6 / m;
alg_12_4 = alg_2_4 / m;
alg_12_5 = alg_2_5 / m;
alg_12_6 = alg_2_6 / m;
oTable.Rows.Add();
oTable.Cell(i, 1).Range.Text = (i - 1).ToString();
oTable.Cell(i, 2).Range.Text = coh.Key.ToString();
oTable.Cell(i, 3).Range.Text = alg_2_4.ToString("N2");
oTable.Cell(i, 4).Range.Text = alg_2_5.ToString("N2");
oTable.Cell(i, 5).Range.Text = alg_2_6.ToString("N2");
oTable.Cell(i, 6).Range.Text = alg_3_4.ToString("N2");
oTable.Cell(i, 7).Range.Text = alg_3_5.ToString("N2");
oTable.Cell(i, 8).Range.Text = alg_3_6.ToString("N2");
oTable.Cell(i, 9).Range.Text = alg_12_4.ToString("N2");
oTable.Cell(i, 10).Range.Text = alg_12_5.ToString("N2");
oTable.Cell(i, 11).Range.Text = alg_12_6.ToString("N2");
oTable.Cell(i, 1).Range.ParagraphFormat.Alignment = Word.WdParagraphAlignment.wdAlignParagraphLeft;
oTable.Cell(i, 2).Range.ParagraphFormat.Alignment = Word.WdParagraphAlignment.wdAlignParagraphLeft;
i++;
}
try
{
oTable.Rows[i + 1].Delete();
}
catch (Exception ex) { }
}
public void KoeffLink(Dictionary<int, List<double>> dict, double coherence, Word.Table oTable)
{
int i = 2;
for (int k = 0; k < dict.Keys.Count; k++)
{
int m = 0;
double alg_2_5 = 0;
double alg_2_6 = 0;
List<double> list_Keap;
dict.TryGetValue(dict.Keys.ElementAt(k), out list_Keap);
for (int j = 0; j < list_Keap.Count; j += 2)
{
alg_2_5 += list_Keap[j];
alg_2_6 += list_Keap[j + 1];
m++;
}
alg_2_5 = alg_2_5 / m;
alg_2_6 = alg_2_6 / m;
oTable.Rows.Add();
oTable.Cell(i, 1).Range.Text = coherence.ToString();
oTable.Cell(i, 2).Range.Text = dict.Keys.ElementAt(k).ToString();
oTable.Cell(i, 3).Range.Text = alg_2_5.ToString("N2");
oTable.Cell(i, 4).Range.Text = alg_2_6.ToString("N2");
oTable.Cell(i, 1).Range.ParagraphFormat.Alignment = Word.WdParagraphAlignment.wdAlignParagraphLeft;
oTable.Cell(i, 2).Range.ParagraphFormat.Alignment = Word.WdParagraphAlignment.wdAlignParagraphLeft;
i++;
}
oTable.Rows[i].Delete();
}
private void ExeTableInfo(Word.Table pTable, FASTrack.ViewModel.FARReportGeneratorViewModel master)
{
for (int iRow = 1; iRow <= pTable.Rows.Count; iRow++)
{
for (int iCol = 1; iCol <= 2; iCol++)
{
Word.Cell wCell = pTable.Cell(iRow, iCol);
string sValue = wCell.Range.Text;
//[Analyst/User who will generate the Report]
if (sValue.Contains(KeyWord.USER_GEN_RE))
{
wCell.Range.Text = wCell.Range.Text.Replace(KeyWord.USER_GEN_RE, User1.FullName);//Get full name of user login current
continue;
}
//Phone number of Analyst
if (sValue.Contains(KeyWord.PHONE_1))
{
wCell.Range.Text = wCell.Range.Text.Replace(KeyWord.PHONE_1, User1.Phone);
continue;
}
//[FA Overall Incharge]
if (sValue.Contains(KeyWord.FA_OVERALL_INCHARGE))
{
wCell.Range.Text = wCell.Range.Text.Replace(KeyWord.FA_OVERALL_INCHARGE, User2.FullName);
continue;
}
//Phone number of Reviewed by
if (sValue.Contains(KeyWord.PHONE_2))
{
wCell.Range.Text = wCell.Range.Text.Replace(KeyWord.PHONE_2, User2.Phone);
continue;
}
}
}
}
private void AddPicture(Word.Table wTable, System.Collections.Generic.List<string> photos, ref int row)
{
int iCountImage = (int)Math.Ceiling(photos.Count / 2d);
int iRowImage = row;
int iColImage = 1;
foreach (var photo in photos)
{
int iCol = (iColImage % 2) == 0 ? 2 : 1;
if (iCol == 1)
iRowImage++;
Word.Cell wCell = wTable.Cell(iRowImage, iCol);
wCell.BottomPadding = 5;
wCell.TopPadding = 5;
wCell.RightPadding = 5;
wCell.LeftPadding = 5;
wCell.VerticalAlignment = Word.WdCellVerticalAlignment.wdCellAlignVerticalCenter;
wCell.Shading.BackgroundPatternColorIndex = Word.WdColorIndex.wdWhite;
Word.Range range = wCell.Range;
range.Borders[Word.WdBorderType.wdBorderLeft].LineStyle = Word.WdLineStyle.wdLineStyleSingle;
range.Borders[Word.WdBorderType.wdBorderRight].LineStyle = Word.WdLineStyle.wdLineStyleSingle;
range.Borders[Word.WdBorderType.wdBorderBottom].LineStyle = Word.WdLineStyle.wdLineStyleSingle;
range.ParagraphFormat.Alignment = Word.WdParagraphAlignment.wdAlignParagraphCenter;
Word.InlineShape pic = range.InlineShapes.AddPicture(photo);
pic.Width = wCell.Width - 10;
//range.InsertAfter("SN1");
iColImage++;
}
if (photos.Count % 2 == 1)
{
Word.Cell wCell = wTable.Cell(iRowImage, 2);
wCell.VerticalAlignment = Word.WdCellVerticalAlignment.wdCellAlignVerticalCenter;
wCell.Shading.BackgroundPatternColorIndex = Word.WdColorIndex.wdWhite;
Word.Range range = wCell.Range;
range.Borders[Word.WdBorderType.wdBorderLeft].LineStyle = Word.WdLineStyle.wdLineStyleSingle;
range.Borders[Word.WdBorderType.wdBorderRight].LineStyle = Word.WdLineStyle.wdLineStyleSingle;
range.Borders[Word.WdBorderType.wdBorderBottom].LineStyle = Word.WdLineStyle.wdLineStyleSingle;
}
row += iCountImage;
}
private void ExeTableDetail(Word.Table pTable, FASTrack.Model.DTO.FARDeviceDetailsDto device)
{
for (int iRow = 1; iRow <= pTable.Rows.Count; iRow++)
{
Word.Cell wCell = pTable.Cell(iRow, 1);
string sValue = wCell.Range.Text;
if (sValue.Contains(KeyWord.FA_DETAILS_DESCRIPTION))
{
wCell.Range.Text = device.Master.FailureDesc;
continue;
}
if (sValue.Contains(KeyWord.PROCESSES) && exportType == ExportType.TEMP1)
{
if (ProcessTypes == null)
continue;
int iCount = ProcessTypes.Count;
int iNumRowOfProcess = (int)Math.Ceiling(iCount / 2d);
Word.Table wParent = wCell.Range.Tables.Add(wCell.Range, 1, 2);
Word.Cell wCell1 = wParent.Cell(1, 1);
Word.Cell wCell2 = wParent.Cell(1, 2);
ReportProcessTypeCell(wCell1, (iCount % 2 == 1) ? iNumRowOfProcess - 1 : iNumRowOfProcess, 1, device.ProcessHis);
ReportProcessTypeCell(wCell2, iNumRowOfProcess, 2, device.ProcessHis);
////Word.Table wTableProcess = wCell.Range.Tables.Add(wCell.Range, iNumRowOfProcess, 2);
//Word.Table wTableProcess = wCell.Range.Tables.Add(wCell.Range, iCount, 1);
//wTableProcess.BottomPadding = 1;
//wTableProcess.TopPadding = 1;
//wTableProcess.LeftPadding = 5;
//wTableProcess.RightPadding = 5;
//wTableProcess.Spacing = 10;
////for (int i = 1; i <= iNumRowOfProcess; i++)
//for (int i = 1; i <= iCount; i++)
//{
// //for (int j = 1; j <= 2; j++)
// //{
// //Word.Range range = wTableProcess.Cell(i, j).Range;
// Word.Range range = wTableProcess.Cell(i, 1).Range;
// range.Font.Name = "Verdana";
// range.Font.Size = 10;
// //Word.FormField checkBox = range.FormFields.Add(wTableProcess.Cell(i, j).Range, Word.WdFieldType.wdFieldFormCheckBox);
// Word.FormField checkBox = range.FormFields.Add(wTableProcess.Cell(i, 1).Range, Word.WdFieldType.wdFieldFormCheckBox);
// //checkBox.CheckBox.Default = false;
// //checkBox.CheckBox.Size = 15;
// //checkBox.CalculateOnExit = true;
// //checkBox.Enabled = true;
// //checkBox.OwnHelp = false;
// //checkBox.OwnStatus = false;
// //var pro = ProcessTypes[(i * 2) - j];
// var pro = ProcessTypes[i - 1];
// if (device.ProcessHis.FirstOrDefault(x => x.ProcessTypeId == pro.Id) != null)
// {
// //checkBox.CheckBox.Default = true;
// checkBox.CheckBox.Value = true;
// }
// else
// {
// //checkBox.CheckBox.Default = false;
// checkBox.CheckBox.Value = false;
// }
// checkBox.Enabled = false;
// range.InsertAfter(pro.Name);
// //}
//}
continue;
}
if (sValue.Contains(KeyWord.PROCESSES_COMMENT) && exportType == ExportType.TEMP1)
{
int wCount = device.ProcessHis.Count;
object missing = Type.Missing;
wCell.Range.Text = String.Empty;
Word.Paragraph pText = null;
for (int i = 0; i < device.ProcessHis.Count; i++)
{
var item = device.ProcessHis[i];
if (i == 0)
{
wCell.Range.Bold = 1;
wCell.Range.Text = item.ProcessType.Name;
}
else
{
pText = wCell.Range.Paragraphs.Add(missing);
pText.Range.Bold = 1;
pText.Range.Text = item.ProcessType.Name;
}
pText = wCell.Range.Paragraphs.Add(missing);
pText.Range.Bold = 0;
pText.Range.Text = item.Comment;
wCell.Range.InsertParagraphAfter();
}
}
}
}
private void ExeFullGenerate(Word.Table pTable, FASTrack.Model.DTO.FARDeviceDetailsDto device)
{
int iMaxRow = 6; int iMaxXol = 3;
for (int iRow = 1; iRow <= iMaxRow; iRow++)
{
for (int iCol = 1; iCol <= iMaxXol; iCol++)
{
Word.Cell wCell = pTable.Cell(iRow, iCol);
string sValue = wCell.Range.Text;
if (sValue.Contains(KeyWord.FAR_REF))
{
wCell.Range.Text = wCell.Range.Text.Replace(KeyWord.FAR_REF, device.Master.Number);
continue;
}
if (sValue.Contains(KeyWord.CUSTOMER))
{
wCell.Range.Text = wCell.Range.Text.Replace(KeyWord.CUSTOMER, device.Master.Customer);
continue;
}
if (sValue.Contains(KeyWord.FAILURE_RATE))
{
wCell.Range.Text = wCell.Range.Text.Replace(KeyWord.FAILURE_RATE, device.Master.FailureRate + "");
continue;
}
if (sValue.Contains(KeyWord.REQUEST_DATE))
{
wCell.Range.Text = wCell.Range.Text.Replace(KeyWord.REQUEST_DATE, device.Master.RequestDate.ToString("dd MMM yyyy"));
continue;
}
if (sValue.Contains(KeyWord.REQUESTOR))
{
wCell.Range.Text = wCell.Range.Text.Replace(KeyWord.REQUESTOR, Requestor.FullName);//TODO:get full name
continue;
}
if (sValue.Contains(KeyWord.PRODUCT_LINE))
{
wCell.Range.Text = wCell.Range.Text.Replace(KeyWord.PRODUCT_LINE, device.Master.Product);
continue;
}
if (sValue.Contains(KeyWord.REQUESTOR_EMAIL))
{
wCell.Range.Text = wCell.Range.Text.Replace(KeyWord.REQUESTOR_EMAIL, Requestor.Email);
continue;
}
if (exportType == ExportType.TEMP1)
{
if (sValue.Contains(KeyWord.DATE_CODE))
{
wCell.Range.Text = wCell.Range.Text.Replace(KeyWord.DATE_CODE, device.DateCode);
continue;
}
if (sValue.Contains(KeyWord.PART_NUMBER))
{
wCell.Range.Text = wCell.Range.Text.Replace(KeyWord.PART_NUMBER, device.MfgPartNo);
continue;
}
if (sValue.Contains(KeyWord.PACK_TYPE))
{
wCell.Range.Text = wCell.Range.Text.Replace(KeyWord.PACK_TYPE, device.PackageType.Name);
continue;
}
if (sValue.Contains(KeyWord.ASSEMBLY_SITE))
{
wCell.Range.Text = wCell.Range.Text.Replace(KeyWord.ASSEMBLY_SITE, device.AssemblySites.Name);
continue;
}
if (sValue.Contains(KeyWord.LOT_NUMBER))
{
wCell.Range.Text = wCell.Range.Text.Replace(KeyWord.LOT_NUMBER, device.LotNo);
continue;
}
if (sValue.Contains(KeyWord.SAMPLES_QTY))
{
wCell.Range.Text = wCell.Range.Text.Replace(KeyWord.SAMPLES_QTY, device.Quantity + "");
continue;
}
}
}
}
}
public void llenaTablaCalidad(Word.Table tabla, EntidadNoConformidad[] conf1)
{
tabla.Borders.InsideLineStyle = Word.WdLineStyle.wdLineStyleSingle;
tabla.Borders.InsideColor = Word.WdColor.wdColorBlack;
tabla.Borders.OutsideLineStyle = Word.WdLineStyle.wdLineStyleSingle;
tabla.Borders.OutsideColor = Word.WdColor.wdColorBlack;
tabla.Rows[1].Range.Shading.BackgroundPatternColor = Word.WdColor.wdColorOrange;
tabla.Rows[1].Range.Font.Bold = 1;
tabla.Range.ParagraphFormat.Alignment = Word.WdParagraphAlignment.wdAlignParagraphCenter;
tabla.Range.Cells.VerticalAlignment = Word.WdCellVerticalAlignment.wdCellAlignVerticalCenter;
tabla.Cell(1, 1).Range.Text = "Estado";
tabla.Cell(1, 2).Range.Text = "Casos";
tabla.Cell(1, 3).Range.Text = "Cantidad";
tabla.Cell(1, 4).Range.Text = "Porcentaje";
tabla.Cell(2, 1).Range.Text = "Satisfactoria";
tabla.Cell(3, 1).Range.Text = "Fallida";
tabla.Cell(4, 1).Range.Text = "Cancelada";
tabla.Cell(5, 1).Range.Text = "Pendiente";
string[] ncs = new string[4]; ncs[0] = ""; ncs[1] = ""; ncs[2] = ""; ncs[3] = "";
float[] acums = new float[4]; acums[0] = 0; acums[1] = 0; acums[2] = 0; acums[3] = 0;
foreach (EntidadNoConformidad nc in conf1)
{
switch (nc.Estado)
{
case "Satisfactoria":
acums[0]++;
ncs[0] += nc.IdCaso + " - Tipo: " + nc.Tipo + "\n";
break;
case "Fallida":
acums[1]++;
ncs[1] += nc.IdCaso + " - Tipo: " + nc.Tipo + "\n";
break;
case "Cancelada":
acums[2]++;
ncs[2] += nc.IdCaso + " - Tipo: " + nc.Tipo + "\n";
break;
case "Pendiente":
acums[3]++;
ncs[3] += nc.IdCaso + " - Tipo: " + nc.Tipo + "\n";
break;
}
}
for (int i = 0; i < 4; i++)
{
if (acums[i] == 0)
{
ncs[i] = " ";
}
ncs[i] = ncs[i].Remove(ncs[i].Length - 1, 1);
tabla.Cell(i + 2, 2).Range.Text = ncs[i];
tabla.Cell(i + 2, 3).Range.Text = "" + acums[i];
tabla.Cell(i + 2, 4).Range.Text = (acums[i] / conf1.Length) * 100 + "%";
}
}
public void llenaTablaNoConf(Word.Table tabla, EntidadNoConformidad[] conf1)
{
tabla.Borders.InsideLineStyle = Word.WdLineStyle.wdLineStyleSingle;
tabla.Borders.InsideColor = Word.WdColor.wdColorBlack;
tabla.Borders.OutsideLineStyle = Word.WdLineStyle.wdLineStyleSingle;
tabla.Borders.OutsideColor = Word.WdColor.wdColorBlack;
tabla.Rows[1].Range.Shading.BackgroundPatternColor = Word.WdColor.wdColorOrange;
tabla.Rows[1].Range.Font.Bold = 1;
tabla.Range.ParagraphFormat.Alignment = Word.WdParagraphAlignment.wdAlignParagraphCenter;
tabla.Range.Cells.VerticalAlignment = Word.WdCellVerticalAlignment.wdCellAlignVerticalCenter;
tabla.Cell(1, 1).Range.Text = "No Conformidad";
tabla.Cell(1, 2).Range.Text = "Casos";
tabla.Cell(1, 3).Range.Text = "Cantidad";
tabla.Cell(1, 4).Range.Text = "Porcentaje";
tabla.Cell(2, 1).Range.Text = "Funcionalidad";
tabla.Cell(3, 1).Range.Text = "Validación";
tabla.Cell(4, 1).Range.Text = "Opciones que no funcionaban";
tabla.Cell(5, 1).Range.Text = "Error de usabilidad";
tabla.Cell(6, 1).Range.Text = "Excepciones";
tabla.Cell(7, 1).Range.Text = "No correspondencia";
tabla.Cell(8, 1).Range.Text = "Ortografía";
string[] ncs = new string[7]; ncs[0] = ""; ncs[1] = ""; ncs[2] = ""; ncs[3] = ""; ncs[4] = ""; ncs[5] = ""; ncs[6] = "";
float[] acums = new float[7]; acums[0] = 0; acums[1] = 0; acums[2] = 0; acums[3] = 0; acums[4] = 0; acums[5] = 0; acums[6] = 0;
foreach (EntidadNoConformidad nc in conf1)
{
switch (nc.Tipo)
{
case "Funcionalidad":
acums[0]++;
ncs[0] += nc.IdCaso + " - Estado: " + nc.Estado + "\n";
break;
case "Validación":
acums[1]++;
ncs[1] += nc.IdCaso + " - Estado: " + nc.Estado + "\n";
break;
case "Opciones que no funcionaban":
acums[2]++;
ncs[2] += nc.IdCaso + " - Estado: " + nc.Estado + "\n";
break;
case "Error de usabilidad":
acums[3]++;
ncs[3] += nc.IdCaso + " - Estado: " + nc.Estado + "\n";
break;
case "Excepciones":
acums[4]++;
ncs[4] += nc.IdCaso + " - Estado: " + nc.Estado + "\n";
break;
case "No correspondencia":
acums[5]++;
ncs[5] += nc.IdCaso + " - Estado: " + nc.Estado + "\n";
break;
case "Ortografía":
acums[6]++;
ncs[6] += nc.IdCaso + " - Estado: " + nc.Estado + "\n";
break;
}
}
for (int i = 0; i < acums.Length; i++)
{
if (acums[i] == 0)
{
ncs[i] = " ";
}
ncs[i] = ncs[i].Remove(ncs[i].Length - 1, 1);
tabla.Cell(i + 2, 2).Range.Text = ncs[i];
tabla.Cell(i + 2, 3).Range.Text = "" + acums[i];
tabla.Cell(i + 2, 4).Range.Text = (acums[i] / conf1.Length) * 100 + "%";
}
}
public void llenaTablaEstado(Word.Table tabla, EntidadNoConformidad[] conf1)
{
tabla.Borders.InsideLineStyle = Word.WdLineStyle.wdLineStyleSingle;
tabla.Borders.InsideColor = Word.WdColor.wdColorBlack;
tabla.Borders.OutsideLineStyle = Word.WdLineStyle.wdLineStyleSingle;
tabla.Borders.OutsideColor = Word.WdColor.wdColorBlack;
tabla.Rows[1].Range.Shading.BackgroundPatternColor = Word.WdColor.wdColorOrange;
tabla.Rows[1].Range.Font.Bold = 1;
tabla.Rows[1].Range.ParagraphFormat.Alignment = Word.WdParagraphAlignment.wdAlignParagraphCenter;
tabla.Range.Cells.VerticalAlignment = Word.WdCellVerticalAlignment.wdCellAlignVerticalCenter;
tabla.Cell(1, 1).Range.Text = "Caso";
tabla.Cell(1, 2).Range.Text = "Tipo";
tabla.Cell(1, 3).Range.Text = "Descripción";
tabla.Cell(1, 4).Range.Text = "Justificación";
tabla.Cell(1, 5).Range.Text = "Estado";
for (int i = 0; i < conf1.Length; i++)
{
tabla.Cell(2 + (i), 1).Range.Text = conf1[i].IdCaso;
tabla.Cell(2 + (i), 2).Range.Text = conf1[i].Tipo;
tabla.Cell(2 + (i), 3).Range.Text = conf1[i].Descripcion;
tabla.Cell(2 + (i), 4).Range.Text = conf1[i].Justificacion;
tabla.Cell(2 + (i), 5).Range.Text = conf1[i].Estado;
//tabla.Cell(2 + (i * 2), 1).Range.Text = conf1[i].IdCaso;
//tabla.Cell(2 + (i * 2), 2).Range.Text = conf1[i].Tipo;
//tabla.Cell(2 + (i * 2), 3).Range.Text = conf1[i].Descripcion;
//tabla.Cell(2 + (i * 2), 4).Range.Text = conf1[i].Justificacion;
//tabla.Cell(2 + (i * 2), 5).Range.Text = conf1[i].Estado;
//tabla.Cell(3 + (i * 2), 1).Range.Text = "Imagen"; tabla.Cell(3 + (i * 2), 1).Range.Shading.BackgroundPatternColor = Word.WdColor.wdColorOrange;
//tabla.Cell(3 + (i * 2), 1).Range.ParagraphFormat.Alignment = Word.WdParagraphAlignment.wdAlignParagraphRight;
//tabla.Cell(3 + (i * 2), 1).Range.Font.Bold = 1;
//tabla.Cell(3 + (i * 2), 5).Merge(tabla.Cell(3 + (i * 2), 4));
//tabla.Cell(3 + (i * 2), 4).Merge(tabla.Cell(3 + (i * 2), 3));
//tabla.Cell(3 + (i * 2), 3).Merge(tabla.Cell(3 + (i * 2), 2));
//var img = creaImagen(conf1[i].Imagen);
//img.Save(HttpRuntime.AppDomainAppPath + "ReportesTMP\\chtemp.jpg");
//tabla.Cell(3 + (i * 2), 5).Range.InlineShapes.AddPicture(HttpRuntime.AppDomainAppPath + "ReportesTMP\\chtemp.jpg");
//tabla.Cell(3 + (i * 2), 5).Range.ParagraphFormat.Alignment = Word.WdParagraphAlignment.wdAlignParagraphCenter;
}
}
