public bool ImportaDados(DataTable dt)
{
bool ret = false;
using (OracleBulkCopy bulkCopy = new OracleBulkCopy(ConfigAplication.GetConnectString().Replace(";Unicode=True", "")))
{
bulkCopy.DestinationTableName = "OWN_FUNCESP.FUN_TBL_AD_USUARIO";
bulkCopy.ColumnMappings.Add("Nome", "nome");
bulkCopy.ColumnMappings.Add("Usuario", "login");
bulkCopy.ColumnMappings.Add("Email", "email");
bulkCopy.ColumnMappings.Add("Departamento", "departamento");
bulkCopy.ColumnMappings.Add("Data", "dt_inclusao");
try
{
bulkCopy.WriteToServer(dt);
ret = true;
}
catch (Exception ex)
{
throw new Exception("Problemas contate o administrador do sistema: \\n" + ex.Message);
}
finally
{
bulkCopy.Close();
}
return(ret);
}
}
protected void MostraTelaConformeLogin(Boolean blnLogado)
{
string[] username;
if (Context.User.Identity.IsAuthenticated)
{
username = Context.User.Identity.Name.Split(char.Parse(@"\"));
}
divLogado.Visible = blnLogado;
divNLogado.Visible = !blnLogado;
txtSenha.Focus();
if (blnLogado)
{
lbNome.Text = objBLL.nome;
lbDepartamento.Text = objBLL.departamento;
if (ConfigAplication.GetOwner().Equals("D"))
{
lblambiente.Text = "Ambiente de Desenvolvimento";
}
else if (ConfigAplication.GetOwner().Equals("T"))
{
lblambiente.Text = "Ambiente de Homologação";
}
else //P
{
lblambiente.Text = "Ambiente de Produção";
}
}
}
public void GeraRelatorio()
{
//Session[RelatorioID] = _relatorio;
Session[RelatorioID + "cache"] = _relatorio;
// Abrir relatorio
relatorio = new ReportDocument();
List <Parametro> parametros = _relatorio.parametros;
String Relatorio_caminho = _relatorio.arquivo;
Relatorio_caminho = Server.MapPath(@Relatorio_caminho);
//relatorio.Load(Relatorio_caminho);
NomeRelatorio.Text = "Relatorio " + _relatorio.titulo;
CrystalReportViewer1.ReportSource = null;
TableLogOnInfo tableLogOnInfo = null;
relatorio.FileName = Relatorio_caminho;
if (builder == null)
{
builder = new SqlConnectionStringBuilder(ConfigAplication.GetConnectString().ToString().Replace(";Unicode=True", ""));
}
foreach (CrystalDecisions.CrystalReports.Engine.Table tbl in relatorio.Database.Tables)
{
tableLogOnInfo = tbl.LogOnInfo;
tableLogOnInfo.ConnectionInfo.ServerName = builder.DataSource;
tableLogOnInfo.ConnectionInfo.DatabaseName = "";
tableLogOnInfo.ConnectionInfo.UserID = builder.UserID;
tableLogOnInfo.ConnectionInfo.Password = builder.Password;
tbl.ApplyLogOnInfo(tableLogOnInfo);
}
relatorio.SetDatabaseLogon(builder.UserID, builder.Password, builder.DataSource, "");
//CrystalReportViewer1.ReportSource = relatorio;
// Passar os parametros para o relatorio
CrystalReportViewer1.RefreshReport();
ParameterFields paramFields = new ParameterFields();
foreach (var p in parametros)
{
ParameterField pfItemYr = new ParameterField();
pfItemYr.ParameterFieldName = p.parametro;
ParameterDiscreteValue dcItemYr = new ParameterDiscreteValue();
dcItemYr.Value = p.valor;
pfItemYr.CurrentValues.Add(dcItemYr);
paramFields.Add(pfItemYr);
CrystalReportViewer1.ParameterFieldInfo = paramFields;
}
//CrystalReportSource1.Report.FileName = objrel.relatorio;
CrystalReportViewer1.ReportSource = relatorio;
//Session[Request.QueryString["Param"]+"rel"] = relatorio;
}
private ReportDocument MontaCrystal(ParameterFields parametros)
{
string caminho = Server.MapPath(@"Relatorios/AvisoPagamentoAbono.rpt");
ReportDocument relatorio = new ReportDocument();
//relatorio.Load(caminho);
relatorio.FileName = caminho;
SqlConnectionStringBuilder conString = new SqlConnectionStringBuilder(ConfigAplication.GetConnectString().ToString().Replace(";Unicode=True", ""));
TableLogOnInfo tableLogOnInfo = null;
foreach (CrystalDecisions.CrystalReports.Engine.Table tbl in relatorio.Database.Tables)
{
tableLogOnInfo = tbl.LogOnInfo;
tableLogOnInfo.ConnectionInfo.ServerName = conString.DataSource;
tableLogOnInfo.ConnectionInfo.DatabaseName = "";
tableLogOnInfo.ConnectionInfo.UserID = conString.UserID;
tableLogOnInfo.ConnectionInfo.Password = conString.Password;
tbl.ApplyLogOnInfo(tableLogOnInfo);
}
foreach (ReportDocument sub in relatorio.Subreports)
{
foreach (CrystalDecisions.CrystalReports.Engine.Table tbl in sub.Database.Tables)
{
tableLogOnInfo = tbl.LogOnInfo;
tableLogOnInfo.ConnectionInfo.ServerName = conString.DataSource;
tableLogOnInfo.ConnectionInfo.DatabaseName = "";
tableLogOnInfo.ConnectionInfo.UserID = conString.UserID;
tableLogOnInfo.ConnectionInfo.Password = conString.Password;
tbl.ApplyLogOnInfo(tableLogOnInfo);
}
}
relatorio.SetDatabaseLogon(conString.UserID, conString.Password, conString.DataSource, "");
//Parâmetros
foreach (ParameterField pField in parametros)
{
relatorio.SetParameterValue(pField.Name, ((ParameterDiscreteValue)(pField.CurrentValues[0])).Value);
}
return(relatorio);
}
public void InicializaRpt()
{
Session[RelatorioID + "cache"] = _relatorio;
relatorio = new ReportDocument();
String Relatorio_caminho = _relatorio.arquivo;
Relatorio_caminho = Server.MapPath(@Relatorio_caminho);
TableLogOnInfo tableLogOnInfo = null;
relatorio.FileName = Relatorio_caminho;
if (builder == null)
{
builder = new SqlConnectionStringBuilder(ConfigAplication.GetConnectString().ToString().Replace(";Unicode=True", ""));
}
foreach (CrystalDecisions.CrystalReports.Engine.Table tbl in relatorio.Database.Tables)
{
tableLogOnInfo = tbl.LogOnInfo;
tableLogOnInfo.ConnectionInfo.ServerName = builder.DataSource;
tableLogOnInfo.ConnectionInfo.DatabaseName = "";
tableLogOnInfo.ConnectionInfo.UserID = builder.UserID;
tableLogOnInfo.ConnectionInfo.Password = builder.Password;
tbl.ApplyLogOnInfo(tableLogOnInfo);
}
//foreach (ReportDocument rdSub in relatorio.Subreports)
//{
// foreach (CrystalDecisions.CrystalReports.Engine.Table tbl in rdSub.Database.Tables)
// {
// tableLogOnInfo = tbl.LogOnInfo;
// tableLogOnInfo.ConnectionInfo.ServerName = builder.DataSource;
// tableLogOnInfo.ConnectionInfo.DatabaseName = "";
// tableLogOnInfo.ConnectionInfo.UserID = builder.UserID;
// tableLogOnInfo.ConnectionInfo.Password = builder.Password;
// tbl.ApplyLogOnInfo(tableLogOnInfo);
// }
// rdSub.VerifyDatabase();
//}
relatorio.SetDatabaseLogon(builder.UserID, builder.Password, builder.DataSource, "");
}
public bool ImportaDados(DataTable dt)
{
bool ret = false;
using (OracleBulkCopy bulkCopy = new OracleBulkCopy(ConfigAplication.GetConnectString().Replace(";Unicode=True", "")))
{
bulkCopy.DestinationTableName = "OWN_FUNCESP.AAT_TBL_SERASA_PEFIN";
bulkCopy.ColumnMappings.Add("EMPRESA", "COD_EMPRS");
bulkCopy.ColumnMappings.Add("MATRICULA", "NUM_RGTRO_EMPRG");
bulkCopy.ColumnMappings.Add("CONTRATO", "NUM_CONTRATO");
bulkCopy.ColumnMappings.Add("NOME", "NOM_NOME");
bulkCopy.ColumnMappings.Add("CPF", "NUM_CPF");
bulkCopy.ColumnMappings.Add("VALOR", "VLR_VALOR");
bulkCopy.ColumnMappings.Add("DT_COMPROMIS_DEV", "DAT_COMPROMIS_DEV");
bulkCopy.ColumnMappings.Add("DAT_IMPORTACAO", "DAT_IMPORTACAO");
bulkCopy.ColumnMappings.Add("TIPO", "COD_OPERACAO");
bulkCopy.ColumnMappings.Add("DESC_USER", "DESC_USER");
//bulkCopy.ColumnMappings.Add("COD_REMESSA_SERASA_PEFIN", "COD_REMESSA_SERASA_PEFIN");
try
{
bulkCopy.WriteToServer(dt);
ret = true;
}
catch (Exception ex)
{
ret = false;
throw new Exception(ex.Message + "\\n\\nVerique se a planinha contém as colunas (EMPRESA, MATRICULA, NOME, CPF, CONTRATO, DT_COMPROMIS_DEV, VALOR, TIPO)");
}
finally
{
bulkCopy.Close();
}
}
return(ret);
}
public bool ImportaDados(CargaDados carga, DataTable dt)
{
bool ret = false;
using (Oracle.DataAccess.Client.OracleBulkCopy bulkCopy = new Oracle.DataAccess.Client.OracleBulkCopy(ConfigAplication.GetConnectString().Replace(";Unicode=True", "")))
{
bulkCopy.DestinationTableName = carga.de_para[0].tabela_destino;
string strColunas = "";
foreach (CargaDadosDePara cddBulkCol in carga.de_para)
{
bulkCopy.ColumnMappings.Add(cddBulkCol.origem_campo, cddBulkCol.destino_campo);
strColunas += cddBulkCol.origem_campo + ", ";
}
strColunas = strColunas.Substring(0, strColunas.Length - 2);
try
{
bulkCopy.WriteToServer(dt);
ret = true;
}
catch (Exception ex)
{
ret = false;
throw new Exception(ex.Message + "\\n\\nVerique se a planinha contém as colunas (" + strColunas + ")");
}
finally
{
bulkCopy.Close();
}
}
return(ret);
}
