public static REL_Protocolo getProtocolo(REL_Protocolo objRelProt, string con)
{
DB_Funcoes.DesmontaConexao(con);
CONEXAO = montaDAO(CONEXAO);
Conn = new NpgsqlConnection(CONEXAO);
string sql = "SELECT emp_nome, emp_end, emp_nr, emp_bairro, emp_cida, emp_est, emp_cep, emp_comend, emp_cgc, emp_fone, emp_foto," +
" p_nome, p_ende, p_nr, p_comend, p_bairro, p_cida, p_est, p_cep, p_cgc, p_fone," +
" o_cod, o_emis, o_obs, e_marca, e_modelo, e_nserie, e_descri, e_patrimon, mec_nome, mec_cod " +
" FROM empresa, particip, oserv, mecanico, equipamento WHERE p_cod=o_clicod AND o_mecanic=mec_cod AND o_equipcod=e_cod AND o_cod=" + objRelProt.o_cod;
NpgsqlCommand comand = new NpgsqlCommand(sql, Conn);
NpgsqlDataReader dr;
try
{
Conn.Open();
dr = comand.ExecuteReader();
if (dr.HasRows)
{
if (dr.Read())
{
objRelProt.emp_nome = dr["emp_nome"].ToString().Trim();
objRelProt.emp_ende = dr["emp_end"].ToString().Trim();
objRelProt.emp_nr = Convert.ToInt32(dr["emp_nr"]);
objRelProt.emp_bairro = dr["emp_bairro"].ToString().Trim();
objRelProt.emp_cida = dr["emp_cida"].ToString().Trim();
objRelProt.emp_est = dr["emp_est"].ToString().Trim();
objRelProt.emp_cep = dr["emp_cep"].ToString().Trim();
objRelProt.emp_comend = dr["emp_comend"].ToString().Trim();
objRelProt.emp_cgc = dr["emp_cgc"].ToString().Trim();
objRelProt.emp_fone = dr["emp_fone"].ToString().Trim();
objRelProt.emp_foto = dr["emp_foto"].ToString().Trim();
objRelProt.p_nome = dr["p_nome"].ToString().Trim();
objRelProt.p_ende = dr["p_ende"].ToString().Trim();
objRelProt.p_nr = dr["p_nr"].ToString().Trim();
objRelProt.p_comend = dr["p_comend"].ToString().Trim();
objRelProt.p_bairro = dr["p_bairro"].ToString().Trim();
objRelProt.p_cida = dr["p_cida"].ToString().Trim();
objRelProt.p_est = dr["p_est"].ToString().Trim();
objRelProt.p_cep = dr["p_cep"].ToString().Trim();
objRelProt.p_cgc = dr["p_cgc"].ToString().Trim();
objRelProt.p_fone = dr["p_fone"].ToString().Trim();
objRelProt.o_emis = Convert.ToDateTime(dr["o_emis"]);
objRelProt.o_obs = dr["o_obs"].ToString().Trim();
objRelProt.e_marca = dr["e_marca"].ToString().Trim();
objRelProt.e_modelo = dr["e_modelo"].ToString().Trim();
objRelProt.e_serie = dr["e_nserie"].ToString().Trim();
objRelProt.e_descri = dr["e_descri"].ToString().Trim();
objRelProt.e_patrimon = dr["e_patrimon"].ToString().Trim();
objRelProt.mec_nome = dr["mec_nome"].ToString().Trim();
return(objRelProt);
}
else
{
objRelProt = null;
return(objRelProt);
}
}
else
{
objRelProt = null;
return(objRelProt);
}
}
catch (Exception ex)
{
ex.ToString();
objRelProt = null;
return(objRelProt);
}
finally
{
if (Conn.State == ConnectionState.Open)
{
Conn.Close();
}
}
}
public static REL_Protocolo getProtocolo(REL_Protocolo objRelProtocolo, string con)
{
return(DB_Relatorios.getProtocolo(objRelProtocolo, con));
}
