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