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); }