public String GetTipo_Cambio_Exportacion(Int64 Perido)
        {
            string respuesta = string.Empty;

            try
            {
                List <BEExportacion> Exportaciones = new List <BEExportacion>();
                BEExportacion        Exportar      = new BEExportacion();
                using (DbCommand dbCmd = dbSQL.GetStoredProcCommand("SP_Exportacion_TC"))
                {
                    dbSQL.AddInParameter(dbCmd, "@Per_empresa", DbType.String, Perido);

                    using (IDataReader dataReader = dbSQL.ExecuteReader(dbCmd))
                    {
                        int Resul = dataReader.GetOrdinal("Sunat");

                        object[] values = new object[dataReader.FieldCount];
                        while (dataReader.Read())
                        {
                            dataReader.GetValues(values);
                            StreamWriter sw = new StreamWriter(Path.GetFullPath(@"C:\20114803228.tc"), true);
                            sw.WriteLine(values[Resul] == DBNull.Value ? string.Empty : values[Resul].ToString());
                            sw.Close();
                        }
                    }
                    return("Exportacion Exitosa");
                }
            }
            catch (Exception ex)
            {
                ExceptionManager.SaveError("Ocurrio un error en el logo", string.Empty, string.Empty, ex, "validateLoginUser", true, false);
                return(null);
            }
            finally
            {
            }
        }
        //
        //Modificaciones realizadas por renzo laureano 29/11/2012
        //

        public String GetHoteles_Exportacion(BEPeriodoEmpresa_Mant Perido)
        {
            string respuesta = string.Empty;

            try
            {
                List <BEExportacion> Exportaciones = new List <BEExportacion>();
                BEExportacion        Exportar      = new BEExportacion();
                using (DbCommand dbCmd = dbSQL.GetStoredProcCommand("SP_Exportacion_Hospedaje"))
                {
                    dbSQL.AddInParameter(dbCmd, "@Per_empresa", DbType.String, Perido.codPeriodo);

                    if (string.IsNullOrEmpty(Perido.codLocal))
                    {
                        dbSQL.AddInParameter(dbCmd, "@codLocal", DbType.String, DBNull.Value);
                    }
                    else
                    {
                        dbSQL.AddInParameter(dbCmd, "@codLocal", DbType.String, Perido.codLocal);
                    }

                    if (string.IsNullOrEmpty(Perido.anioProces))
                    {
                        dbSQL.AddInParameter(dbCmd, "@Anio", DbType.Int32, DBNull.Value);
                    }
                    else
                    {
                        dbSQL.AddInParameter(dbCmd, "@Anio", DbType.Int32, Perido.anioProces);
                    }

                    if (string.IsNullOrEmpty(Perido.anioProces))
                    {
                        dbSQL.AddInParameter(dbCmd, "@Mes", DbType.Int32, DBNull.Value);
                    }
                    else
                    {
                        dbSQL.AddInParameter(dbCmd, "@Mes", DbType.Int32, Perido.mes);
                    }

                    using (IDataReader dataReader = dbSQL.ExecuteReader(dbCmd))
                    {
                        int Resul = dataReader.GetOrdinal("Sunat");

                        object[] values = new object[dataReader.FieldCount];
                        while (dataReader.Read())
                        {
                            dataReader.GetValues(values);

                            StreamWriter sw = new StreamWriter(Path.GetFullPath(@Perido.Ruta), true);
                            //StreamWriter sw = new StreamWriter(Path.GetFullPath(@"d:/20114803228.hos"), true);

                            sw.WriteLine(values[Resul] == DBNull.Value ? string.Empty : values[Resul].ToString());
                            sw.Close();
                        }
                    }
                    return("Exportacion Exitosa");
                }
            }
            catch (Exception ex)
            {
                throw ex;
                //ExceptionManager.SaveError("Ocurrio un error en el logo", string.Empty, string.Empty, ex, "validateLoginUser", true, false);
                //return null;
            }
            finally
            {
            }
        }