public List<Processo> Select() { ClienteModel clienteModel = new ClienteModel(); List<string> sqlLista = new List<string>(); foreach (string cliente in new List<string>() { "VERBALEGISINFO" }) { sqlLista.Add("SELECT *,'" + cliente + "' as cliente FROM " + cliente.Replace(" ", "") + ".dbo.PROCESSO_CADASTRO_AGENDADO " + Environment.NewLine); } string sql = String.Join(" UNION ", sqlLista); SqlDataReader reader = bd.select(sql); DataTable dt = new DataTable(); List<Processo> lista_registros = new List<Processo>(); while (reader.Read()) { Processo processo = new Processo(); processo.idProcesso = reader[0].ToString(); processo.emails = reader[1].ToString(); processo.numProcesso = reader[2].ToString(); processo.codUnicoProcesso = reader[3].ToString(); processo.uf = reader[4].ToString(); processo.comarca = reader[5].ToString(); processo.tribunal = reader[6].ToString(); processo.dataCadastro = DateTime.Parse(reader[7].ToString()); processo.codEscritorio = int.Parse(reader[8].ToString()); processo.tentativas = int.Parse(reader[9].ToString()); processo.partes = reader[10].ToString(); //if(!reader[11].ToString().Equals("")) // processo.dataUltTentativa = DateTime.Parse(reader[11].ToString()); processo.cliente = reader[12].ToString(); lista_registros.Add(processo); } return lista_registros; }
public List<string> listaComboboxCliente() { ClienteModel clienteModel = new ClienteModel(); try { return clienteModel.getClientes(); } catch (Exception ex) { MessageBox.Show(ex.Message); return new List<string>(); } }
public List<Processo> Select(string where, string valorRecorte) { ClienteModel clienteModel = new ClienteModel(); List<string> sqlLista = new List<string>(); List<string> clientes = new List<string>(); if(valorRecorte != null) { clientes.Add(valorRecorte); } else { clientes.Add("NELSONWILLIANS"); } try { foreach (string cliente in clientes ) { sqlLista.Add( "SELECT " + " ID_PROCESSO_CADASTRO" + ", CODIGO, N_PROCESSO" + ", N_PROCESSO_ANTIGO" + ", CODIGO_UNICO_PROCESSO" + ", UF" + ", COMARCA" + ", DATA_CADASTRO" + ", ULT_ANDAMENTO" + ", ULT_ANDAMENTO_ENVIADO" + ", ULT_ENVIO" + ", ULT_ATUALIZACAO_PROCESSO" + ", ULT_ATUALIZACAO_SISTEMA" + ", EMAIL" + ", ANDAMENTO_COMPLETO" + ", REU" + ", FORUM" + ", AUTOR" + ", VARA" + ", TRIBUNAL" + ", PARTES" + ", AUTOR_ADV" + ", DIGITAL" + ", ENCERRADO" + ", REU_ADV" + ", VALOR" + ", SISTEMA" + ", SEGREDO" + ",'" + cliente + "' as cliente " + " FROM " + cliente.Replace(" ", "") + ".dbo.PROCESSO_CADASTRO " + where + " ORDER BY ID_PROCESSO_CADASTRO "); } string sql = String.Join(" UNION ", sqlLista); SqlDataReader reader = bd.select(sql); List<Processo> lista_registros = new List<Processo>(); while (reader.Read()) { Processo processo = new Processo(); processo.idProcessoCadastro = int.Parse(reader[0].ToString()); processo.codEscritorio = int.Parse(reader[1].ToString()); processo.numProcesso = reader[2].ToString(); processo.numProcessoAntigo = reader[3].ToString(); processo.codUnicoProcesso = reader[4].ToString(); processo.uf = reader[5].ToString(); processo.comarca = reader[6].ToString(); processo.dataCadastro = DateTime.Parse(reader[7].ToString()); processo.ultAndamento = reader[8].ToString(); processo.ultAndamentoEnviado = reader[9].ToString(); if (!reader[10].ToString().Equals("")) processo.ultEnvio = DateTime.Parse(reader[10].ToString()); if (!reader[11].ToString().Equals("")) processo.ultAtualizacaoProcesso = DateTime.Parse(reader[11].ToString()); if (!reader[12].ToString().Equals("")) processo.ultAtualizacaoSistema = DateTime.Parse(reader[12].ToString()); processo.emails = reader[13].ToString(); processo.andamentoCompleto = reader[14].ToString(); processo.reu = reader[15].ToString(); processo.forum = reader[16].ToString(); processo.autor = reader[17].ToString(); processo.vara = reader[18].ToString(); processo.tribunal = reader[19].ToString(); processo.partes = reader[20].ToString(); processo.autor_adv = reader[21].ToString(); if (!reader[22].ToString().Equals("")) processo.digital = int.Parse(reader[22].ToString()); if (!reader[23].ToString().Equals("")) processo.encerrado = int.Parse(reader[23].ToString()); processo.reu_adv = reader[24].ToString(); if (!reader[25].ToString().Equals("")) processo.valor = reader[25].ToString(); processo.sistema = reader[26].ToString(); processo.segredo = 0; if (bool.Parse(reader[27].ToString())) processo.segredo = 1; processo.cliente = reader[28].ToString(); lista_registros.Add(processo); } return lista_registros; } catch (Exception ex) { MessageBox.Show(ex.Message); return new List<Processo>(); } }