Пример #1
0
        public FolioModel getFolio(int tDte, String rutEmisor)
        {
            FolioModel f = new FolioModel();

            try
            {
                SQLiteConnection myConn = bd.ConnectSqlite();
                myConn.Open();

                string           sql     = "select * from folio where tipoDte = " + tDte + " and rut ='" + rutEmisor + "' order by fch;";
                SQLiteCommand    command = new SQLiteCommand(sql, myConn);
                SQLiteDataReader reader  = command.ExecuteReader();
                while (reader.Read())
                {
                    f.rut = reader["rut"].ToString();
                }
                f.rsnsocial = reader["rsnsocial"].ToString();
                f.tipoDte   = Int32.Parse(reader["tipoDte"].ToString());
                f.folioIni  = Int32.Parse(reader["folioIni"].ToString());
                f.folioFin  = Int32.Parse(reader["folioFin"].ToString());
                f.folioSgte = Int32.Parse(reader["folioSgte"].ToString());
                f.fecha     = reader["fecha"].ToString();
                f.rango     = reader["rango"].ToString();
                myConn.Close();
                return(f);
            }
            catch (Exception e)
            {
                Console.WriteLine("ERROR: {0}", e.ToString());
                return(f);
            }
        }
Пример #2
0
        public void save(FolioModel foliomodel)


        {
            try
            {
                BaseDato       con      = new BaseDato();
                OdbcConnection conexion = con.ConnectPostgres();

                OdbcCommand select = new OdbcCommand();
                select.Connection  = conexion;
                select.CommandText = "INSERT INTO folio("
                                     + "folio, estado, idcaf, \"codSucSii\")"
                                     + " VALUES ("
                                     + foliomodel.folio + ",'"
                                     + "DISPONIBLE" + "',"
                                     + foliomodel.idcaf + ",'"
                                     + foliomodel.codSucSii + "'"
                                     + ");";
                OdbcDataReader reader = select.ExecuteReader();
            }
            catch (Exception ex)
            {
                throw new Exception("Error" + ex.Message);
            }
        }
Пример #3
0
        public FolioModel getCaf(String rut, String tipoDte)
        {
            XmlDocument xDoc  = new XmlDocument();
            FolioModel  folio = new FolioModel();

            //La ruta del documento XML permite rutas relativas
            //respecto del ejecutable!

            xDoc.Load(@"C:/AdmToSii/cafs/77398570-7/notacredito/FoliosSII77398570611382015691252.xml");

            XmlNodeList lista = xDoc.GetElementsByTagName("AUTORIZACION");

            XmlNodeList lista1 = ((XmlElement)lista[0]).GetElementsByTagName("CAF");

            XmlNodeList lista2 = ((XmlElement)lista1[0]).GetElementsByTagName("DA");

            XmlNodeList lista3 = ((XmlElement)lista2[0]).GetElementsByTagName("RNG");

            foreach (XmlElement nodo in lista)
            {
                int i = 0;

                XmlNodeList rutCaf =
                    nodo.GetElementsByTagName("RE");

                XmlNodeList rzSoc =
                    nodo.GetElementsByTagName("RS");

                XmlNodeList tpoDte =
                    nodo.GetElementsByTagName("TD");

                XmlNodeList folioIni =
                    nodo.GetElementsByTagName("D");

                XmlNodeList folioFinal =
                    nodo.GetElementsByTagName("H");

                folio.rut       = rutCaf[i].InnerText;
                folio.rsnsocial = rzSoc[i].InnerText;
                //  folio.tipoDte = tipoDte[i].InnerText;
                //  folio.folioIni = folioIni[i].InnerText;
                //  folio.folioFin = folioFinal[i].InnerText;
                int final   = Convert.ToInt32(folioFinal[i].InnerText);
                int inicial = Convert.ToInt32(folioIni[i].InnerText);
                //  folio.rango = final - inicial + 1;

                Console.WriteLine(" Rut: {0} Razon Social: {1} Tipo Dte {2} Folio Inicial: {3} Folio Final {4} Rango {5}",
                                  folio.rut,
                                  folio.rsnsocial,
                                  //    folio.tpoDte,
                                  folio.folioIni,
                                  folio.folioFin,
                                  folio.rango);;
            }

            return(folio);
        }