static void Main()
{
Application.EnableVisualStyles();
Application.SetCompatibleTextRenderingDefault(false);
ITextRepository textRepo = new TxtRepository();
var form1 = new Form1();
var presenter = new Form1Presenter(form1, textRepo);
form1.SetPresenter(presenter);
Application.Run(form1);
}
public void ListarTxt()
{
Sped sped = new Sped();
TxtRepository TxtRepo = new TxtRepository();
var spedFiles = Directory.EnumerateFiles(sped.SourcePath, "*.txt*", SearchOption.AllDirectories);
foreach (string arquivoTxt in spedFiles)
{
sped = TxtRepo.ObterInfoSped(arquivoTxt);
sped.SourceFileName = Path.GetFullPath(arquivoTxt);
sped.NomeDoArquivo = Path.GetFileName(arquivoTxt);
//System.Console.WriteLine(sped.CNPJ);
//System.Console.WriteLine(sped.Status);
_org.MoverSped(sped);
}
}
private static IUnityContainer RegisterComponents()
{
IUnityContainer container = new UnityContainer();
var txtRepo = new TxtRepository();
var htmlRepo = new HTMLRepository(txtRepo);
Dictionary <string, IDocumentRepository <TextsDocument> > repos =
new Dictionary <string, IDocumentRepository <TextsDocument> > {
{ ".wtxt", new BinaryRepository(new BinaryFormatter()) },
{ ".txt", txtRepo },
{ ".html", htmlRepo },
{ ".htm", htmlRepo }
};
container.RegisterType <IDocumentRepository <TextsDocument>,
DocumentRepository <TextsDocument> >()
.RegisterInstance(typeof(SingleInstanceApplication <TextsDocument>), new SingleInstanceApplication <TextsDocument>(container))
.RegisterType <TopLevelForm <TextsDocument>, FormMain>()
.RegisterInstance(typeof(IDictionary <string, IDocumentRepository <TextsDocument> >), repos);
return(container);
}
public void GerarLog()
{
Sped sped = new Sped();
TxtRepository TxtRepo = new TxtRepository();
var caminhoNomeArquivo = File.Create(@"C:\MoverSped\Log\" + DateTime.Now.ToString("dd-MM-yyy HHmmss") + " Auditoria.xlsx");
ExcelPackage package = new ExcelPackage(caminhoNomeArquivo);
ExcelWorkbook workbook = package.Workbook;
ExcelWorksheet sheet = workbook.Worksheets.Add("AuditoriaFiscal");
var row = 2;
for (int i = 1; i <= 10; i++)
{
sheet.Cells[1, i].Style.Fill.PatternType = OfficeOpenXml.Style.ExcelFillStyle.Solid;
sheet.Cells[1, i].Style.Fill.BackgroundColor.SetColor(System.Drawing.Color.Red);
sheet.Cells[1, i].Style.Font.Bold = true;
sheet.Cells[1, i].Style.Border.BorderAround(OfficeOpenXml.Style.ExcelBorderStyle.Thin);
sheet.Cells[1, i].Style.Font.Color.SetColor(System.Drawing.Color.White);
}
sheet.Cells[1, 1].Value = "CodCliente";
sheet.Cells[1, 2].Value = "RazaoSocial";
sheet.Cells[1, 3].Value = "Grupo";
sheet.Cells[1, 4].Value = "CNPJ";
sheet.Cells[1, 5].Value = "InicioVigencia";
sheet.Cells[1, 6].Value = "MesCompetencia";
sheet.Cells[1, 7].Value = "AnoCompetencia";
sheet.Cells[1, 8].Value = "Status";
sheet.Cells[1, 9].Value = "Movimento";
sheet.Cells[1, 10].Value = "Tipo";
var spedFiles = Directory.EnumerateFiles(sped.SourcePath, "*.txt*", SearchOption.AllDirectories);
foreach (string arquivoTxt in spedFiles)
{
Encoding utf8 = Encoding.UTF8;
sped = TxtRepo.ObterInfoSped(arquivoTxt);
if (sped != null)
{
sheet.Cells[row, 1].Value = "Inacessível";
sheet.Cells[row, 2].Value = sped.RazaoSocial;
sheet.Cells[row, 3].Value = "Inacessível";
sheet.Cells[row, 4].Value = sped.CNPJ;
sheet.Cells[row, 5].Value = "Inacessível";
sheet.Cells[row, 6].Value = sped.MesCompetencia;
sheet.Cells[row, 7].Value = sped.AnoCompetencia;
sheet.Cells[row, 8].Value = sped.Status;
sheet.Cells[row, 9].Value = "Validando...";
sheet.Cells[row, 10].Value = sped.TipoSped;
for (int i = 1; i <= 10; i++)
{
sheet.Cells[row, i].Style.Border.BorderAround(OfficeOpenXml.Style.ExcelBorderStyle.Thin);
}
row++;
}
}
package.Save();
}
