public void Limite04(string source, string arquivoSalvar, int agregadorCliente, char tipoCarga)
{
Excel.Application xlApp = new Excel.Application();
Excel.Workbook xlWorkbook = xlApp.Workbooks.Open(source);
Excel._Worksheet xlWorksheet = xlWorkbook.Sheets[1];
Excel.Range xlRange = xlWorksheet.UsedRange;
int rowCount = xlRange.Rows.Count;
using (StreamWriter writer = new StreamWriter(arquivoSalvar))
{
for (int i = 1; i < rowCount + 1; i++)
{
LeituraGravacao format = new LeituraGravacao();
writer.Write("{0,2}", format.Truncate(xlRange.Cells[i, 1].Text, 2));
writer.Write("{0,1}", format.Truncate(xlRange.Cells[i, 2].Text, 1));
writer.Write("{0,6}", format.Truncate(xlRange.Cells[i, 3].Text, 6));
writer.Write("{0,-20}", format.Truncate(xlRange.Cells[i, 4].Text, 20));
writer.Write("{0,17}", format.Truncate(xlRange.Cells[i, 5].Text.ToString("00000000000000000"), 17));
writer.Write("{0,-50}", format.Truncate(xlRange.Cells[i, 6].Text, 10));
writer.Write("{0,288}", format.Truncate(xlRange.Cells[i, 7].Text, 288));
writer.WriteLine("{0}", (i + 1).ToString("000000"));
}
}
xlWorkbook.Close();
}
public string Inclusao01(string[] source, int rowCount)
{
string linha = "";
LeituraGravacao format = new LeituraGravacao();
linha += format.Truncate(source[0], 2);
linha += format.Truncate(source[1], 1);
linha += format.Truncate(source[2], 6);
linha += format.Truncate(source[3], 19);
linha += format.Truncate(source[4], 19);
linha += format.Truncate(source[5], 50);
linha += format.Truncate(source[6], 30);
linha += format.Truncate(source[7], 10);
linha += format.Truncate(source[8], 1);
linha += format.Truncate(source[9], 15);
linha += format.Truncate(source[10], 10);
linha += format.Truncate(source[11], 11);
linha += format.Truncate(source[12], 40);
linha += format.Truncate(source[13], 5);
linha += format.Truncate(source[14], 10);
linha += format.Truncate(source[15], 20);
linha += format.Truncate(source[16], 30);
linha += format.Truncate(source[17], 2);
linha += format.Truncate(source[0], 8);
linha += format.Truncate(source[0], 10);
linha += format.Truncate(source[0], 10);
linha += format.Truncate(source[0], 1);
linha += format.Truncate(source[0], 4);
linha += rowCount.ToString("000000");
return(linha);
}
public void Layout300(string source, string arquivoSalvar, int agregadorCliente, char tipoCarga)
{
Excel.Application xlApp = new Excel.Application();
Excel.Workbook xlWorkbook = xlApp.Workbooks.Open(source);
Excel._Worksheet xlWorksheet = xlWorkbook.Sheets[1];
Excel.Range xlRange = xlWorksheet.UsedRange;
int rowCount = xlRange.Rows.Count;
using (StreamWriter writer = new StreamWriter(arquivoSalvar))
{
DateTime data = DateTime.Now;
string filler = " ";
int tamanhoFiller = 330;
string layout = "0300";
writer.WriteLine("00{0}{1}000000{2}{3}{4," + tamanhoFiller + "}" + "000001", layout,
agregadorCliente.ToString("000000"), data.ToString("dd/MM/yyyyHH:mm"), tipoCarga, filler);
for (int i = 1; i < rowCount + 1; i++)
{
LeituraGravacao format = new LeituraGravacao();
writer.Write("{0,2}", format.Truncate(xlRange.Cells[i, 1].Text, 2));
writer.Write("{0,1}", format.Truncate(xlRange.Cells[i, 2].Text, 1));
writer.Write("{0,6}", format.Truncate(xlRange.Cells[i, 3].Text, 6));
writer.Write("{0,-19}", format.Truncate(xlRange.Cells[i, 4].Text, 19));
writer.Write("{0,-19}", format.Truncate(xlRange.Cells[i, 5].Text, 19));
writer.Write("{0,-50}", format.Truncate(xlRange.Cells[i, 6].Text, 50));
writer.Write("{0,-30}", format.Truncate(xlRange.Cells[i, 7].Text, 30));
writer.Write("{0,10}", format.Truncate(xlRange.Cells[i, 8].Text, 10));
writer.Write("{0,1}", format.Truncate(xlRange.Cells[i, 9].Text, 1));
writer.Write("{0,15}", format.Truncate(xlRange.Cells[i, 10].Text, 15));
writer.Write("{0,10}", format.Truncate(xlRange.Cells[i, 11].Text, 10));
writer.Write("{0,11}", format.Truncate(xlRange.Cells[i, 12].Text, 11));
writer.Write("{0,40}", format.Truncate(xlRange.Cells[i, 13].Text, 40));
writer.Write("{0,5}", format.Truncate(xlRange.Cells[i, 14].Text, 5));
writer.Write("{0,10}", format.Truncate(xlRange.Cells[i, 15].Text, 10));
writer.Write("{0,20}", format.Truncate(xlRange.Cells[i, 16].Text, 20));
writer.Write("{0,30}", format.Truncate(xlRange.Cells[i, 17].Text, 30));
writer.Write("{0,2}", format.Truncate(xlRange.Cells[i, 18].Text, 2));
writer.Write("{0,8}", format.Truncate(xlRange.Cells[i, 19].Text, 8));
writer.Write("{0,10}", format.Truncate(xlRange.Cells[i, 20].Text, 10));
writer.Write("{0,10}", format.Truncate(xlRange.Cells[i, 21].Text, 10));
writer.Write("{0,1}", format.Truncate(xlRange.Cells[i, 22].Text, 1));
writer.Write("{0,-20}", format.Truncate(xlRange.Cells[i, 23].Text, 20));
writer.Write("{0,1}", format.Truncate(xlRange.Cells[i, 24].Text, 1));
writer.Write("{0,9}", format.Truncate(xlRange.Cells[i, 25].Text.ToString("000000000"), 9));
writer.Write("{0,18}", format.Truncate(xlRange.Cells[i, 26].Text, 18));
writer.WriteLine("{0}", (i + 1).ToString("000000"));
}
tamanhoFiller = 356;
writer.Write("99{0}{1," + tamanhoFiller + "}" + "{2}", (rowCount + 2).ToString("000000"),
filler, (rowCount + 2).ToString("000000"));
}
xlWorkbook.Close();
}
public void Inclusao01(string source, string arquivoSalvar, int agregadorCliente, char tipoCarga)
{
Excel.Application xlApp = new Excel.Application();
Excel.Workbook xlWorkbook = xlApp.Workbooks.Open(source);
Excel._Worksheet xlWorksheet = xlWorkbook.Sheets[1];
Excel.Range xlRange = xlWorksheet.UsedRange;
int rowCount = xlRange.Rows.Count;
using (StreamWriter writer = new StreamWriter(arquivoSalvar))
{
for (int i = 1; i < rowCount + 1; i++)
{
LeituraGravacao format = new LeituraGravacao();
writer.Write("{0,2}", format.Truncate(xlRange.Cells[i, 1].Text, 2));
writer.Write("{0,1}", format.Truncate(xlRange.Cells[i, 2].Text, 1));
writer.Write("{0,6}", format.Truncate(xlRange.Cells[i, 3].Text, 6));
writer.Write("{0,-19}", format.Truncate(xlRange.Cells[i, 4].Text, 19));
writer.Write("{0,-19}", format.Truncate(xlRange.Cells[i, 5].Text, 19));
writer.Write("{0,-50}", format.Truncate(xlRange.Cells[i, 6].Text, 50));
writer.Write("{0,-30}", format.Truncate(xlRange.Cells[i, 7].Text, 30));
writer.Write("{0,10}", format.Truncate(xlRange.Cells[i, 8].Text, 10));
writer.Write("{0,1}", format.Truncate(xlRange.Cells[i, 9].Text, 1));
writer.Write("{0,15}", format.Truncate(xlRange.Cells[i, 10].Text, 15));
writer.Write("{0,10}", format.Truncate(xlRange.Cells[i, 11].Text, 10));
writer.Write("{0,11}", format.Truncate(xlRange.Cells[i, 12].Text, 11));
writer.Write("{0,40}", format.Truncate(xlRange.Cells[i, 13].Text, 40));
writer.Write("{0,5}", format.Truncate(xlRange.Cells[i, 14].Text, 5));
writer.Write("{0,10}", format.Truncate(xlRange.Cells[i, 15].Text, 10));
writer.Write("{0,20}", format.Truncate(xlRange.Cells[i, 16].Text, 20));
writer.Write("{0,30}", format.Truncate(xlRange.Cells[i, 17].Text, 30));
writer.Write("{0,2}", format.Truncate(xlRange.Cells[i, 18].Text, 2));
writer.Write("{0,8}", format.Truncate(xlRange.Cells[i, 19].Text, 8));
writer.Write("{0,10}", format.Truncate(xlRange.Cells[i, 20].Text, 10));
writer.Write("{0,10}", format.Truncate(xlRange.Cells[i, 21].Text, 10));
writer.Write("{0,1}", format.Truncate(xlRange.Cells[i, 22].Text, 1));
writer.Write("{0,-20}", format.Truncate(xlRange.Cells[i, 23].Text, 20));
writer.Write("{0,14}", format.Truncate(xlRange.Cells[i, 24].Text, 14));
writer.WriteLine("{0}", (i + 1).ToString("000000"));
}
}
xlWorkbook.Close();
}
private void converterButton_Click(object sender, EventArgs e)
{
if (arquivo.Text != "")
{
LeituraGravacao leitura = new LeituraGravacao();
SalvaLayout.ShowDialog();
if (SalvaLayout.FileName != "")
{
leitura.GravarArquivo(layout, Convert.ToInt32(agregadorTB.Text), acao,
tipoCarga, arquivo.Text, SalvaLayout.FileName);
MessageBox.Show("O arquivo foi salvo com sucesso!", "Processo concluído");
}
}
else
{
MessageBox.Show("Acho que esqueceu de selecionar um arquivo para ser convertido...", "Ops... =(", MessageBoxButtons.OK);
}
}
public void Demissao06(string source, string arquivoSalvar, int agregadorCliente, char tipoCarga)
{
Excel.Application xlApp = new Excel.Application();
Excel.Workbook xlWorkbook = xlApp.Workbooks.Open(source);
Excel._Worksheet xlWorksheet = xlWorkbook.Sheets[1];
Excel.Range xlRange = xlWorksheet.UsedRange;
int rowCount = xlRange.Rows.Count;
using (StreamWriter writer = new StreamWriter(arquivoSalvar))
{
DateTime data = DateTime.Now;
string filler = " ";
int tamanhoFiller = 120;
string layout = "0310";
writer.WriteLine("00{0}{1}000000{2}{3}{4," + tamanhoFiller + "}" + "000001", layout,
agregadorCliente.ToString("000000"), data.ToString("dd/MM/yyyyHH:mm"), tipoCarga, filler);
for (int i = 1; i < rowCount + 1; i++)
{
LeituraGravacao format = new LeituraGravacao();
writer.Write("{0,2}", format.Truncate(xlRange.Cells[i, 1].Text, 2));
writer.Write("{0,6}", format.Truncate(xlRange.Cells[i, 2].Text, 6));
writer.Write("{0,6}", format.Truncate(xlRange.Cells[i, 3].Text, 6));
writer.Write("{0,-20}", format.Truncate(xlRange.Cells[i, 4].Text, 20));
writer.Write("{0,10}", format.Truncate(xlRange.Cells[i, 5].Text, 10));
writer.Write("{0,110}", format.Truncate(xlRange.Cells[i, 6].Text, 110));
writer.WriteLine("{0}", (i + 1).ToString("000000"));
}
tamanhoFiller = 146;
writer.Write("99{0}{1," + tamanhoFiller + "}" + "{2}", (rowCount + 2).ToString("000000"),
filler, (rowCount + 2).ToString("000000"));
}
xlWorkbook.Close();
}
