//fOLIOS
public void cargarFolios()
{
DB.Conectar();
DB.CrearComando(@"delete from Folios");
DB.EjecutarConsulta2(ref error);
DB.Desconectar();
DB.Conectar();
DB.CrearComando(@"DBCC CHECKIDENT (Folios, RESEED, 0)");
DB.EjecutarConsulta2(ref error);
DB.Desconectar();
objReaderFolios = new StreamReader(System.AppDomain.CurrentDomain.BaseDirectory + "FoliosCFD.txt");
string strLinea = "";
try
{
while (strLinea != null)
{
strLinea = objReaderFolios.ReadLine();
String[] val = strLinea.Split('|');
DB.Conectar();
DB.CrearComando(@"insert into Folios (RFC,noAprobacion,anoAprobacion,serie,folioInicial,folioFinal) values (@RFC,@noAprobacion,@anoAprobacion,@serie,@folioInicial,@folioFinal)");
DB.AsignarParametroCadena("@RFC", val[0]);
DB.AsignarParametroCadena("@noAprobacion", val[1]);
DB.AsignarParametroCadena("@anoAprobacion", val[2]);
DB.AsignarParametroCadena("@serie", val[3]);
DB.AsignarParametroCadena("@folioInicial", val[4]);
DB.AsignarParametroCadena("@folioFinal", val[5]);
DB.EjecutarConsulta2(ref error);
msj = error;
DB.Desconectar();
}
objReaderFolios.Close();
objReaderFolios.Dispose();
}
catch (Exception e)
{
msj = e.Message;
}
}
