private void CarregarListaClientes() { Gradual.Utils.Logger.Log("Suitability", Gradual.Utils.LoggingLevel.Info, Gradual.Utils.MethodHelper.GetCurrentMethod(), new { User = Gradual.Utils.Settings.User, Environment = Gradual.Utils.Settings.Environment }); Gradual.Generico.Dados.AcessaDados lAcessaDados = new Gradual.Generico.Dados.AcessaDados(); string lCommand = "SELECT DISTINCT ID_CLIENTE FROM TB_SUITA_REL ORDER BY ID_CLIENTE"; lAcessaDados.ConnectionStringName = "Cadastro"; using (System.Data.Common.DbCommand lDbCommand = lAcessaDados.CreateCommand(System.Data.CommandType.Text, lCommand)) { System.Data.DataTable lDataTable = lAcessaDados.ExecuteDbDataTable(lDbCommand); if (null != lDataTable && lDataTable.Rows.Count > 0) { for (int i = 0; i <= lDataTable.Rows.Count - 1; i++) { if (!gListaClientes.Contains((lDataTable.Rows[i]["id_cliente"]).DBToString())) { gListaClientes.Add((lDataTable.Rows[i]["id_cliente"]).DBToString()); } } } } }
public string GetCpf(string Codigo) { using (var acessaDados = new Gradual.Generico.Dados.AcessaDados()) { acessaDados.ConnectionStringName = base.ConexaoTrade; try { using (DbCommand dbCommand = acessaDados.CreateCommand(CommandType.StoredProcedure, "prc_get_cpf_by_codigo")) { acessaDados.AddInParameter(dbCommand, "pCodigo", DbType.Int64, Codigo.DBToInt64()); acessaDados.AddOutParameter(dbCommand, "pCPF", DbType.Int64, 8); acessaDados.ExecuteNonQuery(dbCommand); return(dbCommand.Parameters["pCPF"].Value.ToString()); } } catch (System.Data.OracleClient.OracleException) { return("00000"); } } }
private void CarregarListaClientePerfil() { try { Gradual.Utils.Logger.Log("Suitability", Gradual.Utils.LoggingLevel.Info, Gradual.Utils.MethodHelper.GetCurrentMethod(), new { User = Gradual.Utils.Settings.User, Environment = Gradual.Utils.Settings.Environment }); Gradual.Generico.Dados.AcessaDados lAcessaDados = new Gradual.Generico.Dados.AcessaDados(); //string lCommand = "SELECT * FROM TB_SUITA_REL where dt_realizacao is not null"; string lCommand = "select id_cliente, ds_nome, ds_cpfcnpj, ds_fonte, cd_codigo, ds_perfil, CONVERT(DATETIME, ISNULL(dt_realizacao, '1900-01-01')) as dt_realizacao from tb_suita_rel"; lAcessaDados.ConnectionStringName = "Cadastro"; using (System.Data.Common.DbCommand lDbCommand = lAcessaDados.CreateCommand(System.Data.CommandType.Text, lCommand)) { System.Data.DataTable lDataTable = lAcessaDados.ExecuteDbDataTable(lDbCommand); if (null != lDataTable && lDataTable.Rows.Count > 0) { for (int i = 0; i <= lDataTable.Rows.Count - 1; i++) { //id_cliente, ds_nome, ds_cpfcnpj, cd_codigo, ds_perfil, dt_realizacao ClientePerfil lClientePerfil = new ClientePerfil(); lClientePerfil.id_cliente = (lDataTable.Rows[i]["id_cliente"]).DBToString(); lClientePerfil.ds_nome = (lDataTable.Rows[i]["ds_nome"]).DBToString(); lClientePerfil.ds_cpfcnpj = (lDataTable.Rows[i]["ds_cpfcnpj"]).DBToString(); lClientePerfil.cd_codigo = (lDataTable.Rows[i]["cd_codigo"]).DBToString(); lClientePerfil.ds_fonte = (lDataTable.Rows[i]["ds_fonte"]).DBToString(); lClientePerfil.ds_perfil = (lDataTable.Rows[i]["ds_perfil"]).DBToString(); lClientePerfil.dt_realizacao = Convert.ToDateTime((lDataTable.Rows[i]["dt_realizacao"]).DBToString()); gListaCLientePerfil.Add(lClientePerfil); } } } } catch (Exception ex) { Gradual.Utils.Logger.Log("Suitability", Gradual.Utils.LoggingLevel.Error, Gradual.Utils.MethodHelper.GetCurrentMethod(), new { User = Gradual.Utils.Settings.User, Environment = Gradual.Utils.Settings.Environment }, ex); } }