public void AddCell(int position, Schedule_SapTable row) { position += 2; XlsxInput.Cells[position, 1].Value = row.ORDERID; XlsxInput.Cells[position, 2].Value = row.ACTIVITY; XlsxInput.Cells[position, 3].Value = row.SUB_ACTIVITY; XlsxInput.Cells[position, 4].Value = row.CONTROL_KEY; XlsxInput.Cells[position, 5].Value = row.WORK_CNTR; XlsxInput.Cells[position, 6].Value = row.PLANT; XlsxInput.Cells[position, 7].Value = row.DESCRIPTION; XlsxInput.Cells[position, 8].Value = row.SYSTCOND; XlsxInput.Cells[position, 9].Value = row.FUNCLOC; XlsxInput.Cells[position, 10].Value = row.EQUIPMENT; XlsxInput.Cells[position, 11].Value = row.EARL_SCH_START_D; XlsxInput.Cells[position, 12].Value = row.EARL_SCH_START_T; }
public void AddCell(int position, Schedule_SapTable row) { position += 2; XlsxInput.Cells[position, 1].Value = row.USERID; XlsxInput.Cells[position, 2].Value = row.PLANT; var rowPlanilha = new List <string>(); for (int rw = 1; rw <= XlsxInput.Dimension.End.Row; rw++) { if (XlsxInput.Cells[position, 2].Value != null) { rowPlanilha.Add(XlsxInput.Cells[position, 2].Value.ToString()); } } List <string> distinct = rowPlanilha.Distinct().ToList(); foreach (string linha in distinct) { plants.Add("'" + linha + "'"); } }
public void AddCell(int position, Schedule_SapTable row) { string dataInicial = row.DATA_INICIAL; string dataFinal = row.DATA_FINAL; string validadeDe = row.VALIDADE_DE; string validadeAte = row.VALIDADE_ATE; string converteDataInicial = dataInicial.Substring(0, 4).ToString() + '/' + dataInicial.Substring(4, 2).ToString() + '/' + dataInicial.Substring(6, 2); string converteDataFinal = dataFinal.Substring(0, 4).ToString() + '/' + dataFinal.Substring(4, 2).ToString() + '/' + dataFinal.Substring(6, 2); string converteValidadeDe = validadeDe.Substring(0, 4).ToString() + '/' + validadeDe.Substring(4, 2).ToString() + '/' + validadeDe.Substring(6, 2); string converteValidadeAte = validadeAte.Substring(0, 4).ToString() + '/' + validadeAte.Substring(4, 2).ToString() + '/' + validadeAte.Substring(6, 2); string convertidoDataInicial = DateTime.Parse(converteDataInicial).ToString("dd/MM/yyyy"); string convertidoDataFinal = DateTime.Parse(converteDataFinal).ToString("dd/MM/yyyy"); string convertidoValidadeDe = DateTime.Parse(converteValidadeDe).ToString("dd/MM/yyyy"); string convertidoValidadeAte = DateTime.Parse(converteValidadeAte).ToString("dd/MM/yyyy"); position += 2; XlsxInput.Cells[position, 1].Value = row.PLANNING_ID; XlsxInput.Cells[position, 2].Value = row.DESCRICAO; XlsxInput.Cells[position, 3].Value = convertidoDataInicial; XlsxInput.Cells[position, 4].Value = convertidoDataFinal; XlsxInput.Cells[position, 5].Value = convertidoValidadeDe; XlsxInput.Cells[position, 6].Value = convertidoValidadeAte; }
public void AddCell(int position, Schedule_SapTable row) { position += 2; XlsxInput.Cells[position, 1].Value = row.MANDT; XlsxInput.Cells[position, 2].Value = row.CENTRO; XlsxInput.Cells[position, 3].Value = row.COD_ITEM; XlsxInput.Cells[position, 4].Value = row.NOME_LISTA; XlsxInput.Cells[position, 5].Value = row.IDIOMA; XlsxInput.Cells[position, 6].Value = row.TIPONOTAORDEM; XlsxInput.Cells[position, 7].Value = row.LIST_LEVEL; XlsxInput.Cells[position, 8].Value = row.ITEM_PARENT; XlsxInput.Cells[position, 9].Value = row.EXTRA_FLD1; XlsxInput.Cells[position, 10].Value = row.EXTRA_FLD2; XlsxInput.Cells[position, 11].Value = row.EXTRA_FLD3; XlsxInput.Cells[position, 12].Value = row.EXTRA_FLD4; XlsxInput.Cells[position, 13].Value = row.DESCRICAO; XlsxInput.Cells[position, 14].Value = row.ITEM_HASH; XlsxInput.Cells[position, 15].Value = row.DATA_UPD_CDS; XlsxInput.Cells[position, 16].Value = row.HORA_UPD_CDS; XlsxInput.Cells[position, 17].Value = row.USUARIO; XlsxInput.Cells[position, 18].Value = row.CDS_CHANGE_DATE; XlsxInput.Cells[position, 19].Value = row.CDS_KEY; }
public void AddCell(int position, Schedule_SapTable row) { position += 2; XlsxInput.Cells[position, 1].Value = row.ORDERID; XlsxInput.Cells[position, 2].Value = row.ACTIVITY; XlsxInput.Cells[position, 3].Value = row.SUB_ACTIVITY; XlsxInput.Cells[position, 4].Value = row.CONTROL_KEY; XlsxInput.Cells[position, 5].Value = row.WORK_CNTR; XlsxInput.Cells[position, 6].Value = row.PLANT; XlsxInput.Cells[position, 7].Value = row.DESCRIPTION; XlsxInput.Cells[position, 8].Value = row.SYSTCOND; XlsxInput.Cells[position, 9].Value = row.FUNCLOC; XlsxInput.Cells[position, 10].Value = row.EQUIPMENT; if (FeatureContext.Current.FeatureInfo.Title.Equals("Schedule - Move_Operations")) { XlsxInput.Cells[position, 11].Value = convertData(row.EARL_SCH_START_D); XlsxInput.Cells[position, 12].Value = convertTime(row.EARL_SCH_START_T); } else { XlsxInput.Cells[position, 11].Value = row.EARL_SCH_START_D; XlsxInput.Cells[position, 12].Value = row.EARL_SCH_START_T; } }
public void AddCell(int position, Schedule_SapTable row) { position += 2; XlsxInput.Cells[position, 1].Value = row.FIRST_DAY_WEEK; XlsxInput.Cells[position, 2].Value = row.SCHED_VALID_TIME; }
public void AddCell(int position, Schedule_SapTable row) { position += 2; XlsxInput.Cells[position, 1].Value = row.PLANNING_ID; XlsxInput.Cells[position, 2].Value = row.CENTRO_TRAB; }
public void AddCell(int position, Schedule_SapTable row) { position += 2; XlsxInput.Cells[position, 1].Value = row.PERNR; XlsxInput.Cells[position, 2].Value = row.ENDDA; }