private static Movimiento SetObject(MySqlDataReader reader)
{
return(new Movimiento
{
n_id = reader.GetInt32("n_id"),
n_idemp = reader.GetInt32("n_idemp"),
n_idtipmov = reader.GetInt32("n_idtipmov"),
n_idclipro = reader.GetInt32("n_idclipro"),
d_fchdoc = Genericas.GetDateTime(reader, "d_fchdoc"),
d_fching = Genericas.GetDateTime(reader, "d_fching"),
n_idtipdoc = Genericas.GetInt(reader, "n_idtipdoc"),
c_numser = Genericas.GetString(reader, "c_numser"),
c_numdoc = Genericas.GetString(reader, "c_numdoc"),
n_idalm = Genericas.GetInt(reader, "n_idalm"),
n_anotra = Genericas.GetInt(reader, "n_anotra"),
n_idmes = Genericas.GetInt(reader, "n_idmes"),
c_obs = Genericas.GetString(reader, "c_obs"),
n_idtipope = Genericas.GetInt(reader, "n_idtipope"),
n_tipite = Genericas.GetInt(reader, "n_tipite"),
n_docrefidtipdoc = Genericas.GetInt(reader, "n_docrefidtipdoc"),
c_docrefnumser = Genericas.GetString(reader, "c_docrefnumser"),
c_docrefnumdoc = Genericas.GetString(reader, "c_docrefnumdoc"),
n_docrefiddocref = Genericas.GetInt(reader, "n_docrefiddocref"),
n_perid = Genericas.GetInt(reader, "n_perid"),
n_prolog = Genericas.GetInt(reader, "n_prolog"),
n_iddoclog = Genericas.GetInt(reader, "n_iddoclog")
});
}
private static MovimientoDet SetObject(MySqlDataReader reader)
{
return(new MovimientoDet
{
n_idmov = reader.GetInt32("n_id"),
n_idite = reader.GetInt32("n_idite"),
n_idpre = reader.GetInt32("n_idpre"),
n_can = reader.GetDouble("n_can"),
n_idalm = reader.GetInt32("n_idalm"),
c_numlot = Genericas.GetString(reader, "c_numlot"),
n_idtippro = reader.GetInt32("n_idtippro"),
d_fchpro = Genericas.GetDateTime(reader, "d_fchpro"),
d_fchven = Genericas.GetDateTime(reader, "d_fchven"),
n_iddep = reader.GetInt32("n_iddep"),
n_idpro = reader.GetInt32("n_idpro"),
n_iddis = reader.GetInt32("n_iddis"),
c_desori = Genericas.GetString(reader, "c_desori"),
c_marca = Genericas.GetString(reader, "c_marca"),
h_horing = Genericas.GetDateTime(reader, "h_horing"),
h_horsal = Genericas.GetDateTime(reader, "h_horsal"),
n_estpro = reader.GetInt32("n_estpro"),
n_preuni = reader.GetDouble("n_preuni"),
n_pretot = reader.GetDouble("n_pretot")
});
}
public static List <EmpleadoAvance> FetchEmpleadosAvance(int n_idpro
, int n_idemp
, string n_idtraIn
, int n_idtar
, DateTime d_fchini
, DateTime d_fchfin)
{
string c_fchini = d_fchini.ToString("yyyy-MM-dd");
string c_fchfin = d_fchfin.ToString("yyyy-MM-dd");
List <EmpleadoAvance> m_listaentidad = new List <EmpleadoAvance>();
using (MySqlConnection connection
= new MySqlConnection(
ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString))
{
using (MySqlCommand command = new MySqlCommand())
{
command.Connection = connection;
command.CommandType = System.Data.CommandType.StoredProcedure;
command.CommandText = "pla_empleados_listaravance";
command.Parameters.Add(new MySqlParameter("@n_idpro", n_idpro));
command.Parameters.Add(new MySqlParameter("@n_idemp", n_idemp));
command.Parameters.Add(new MySqlParameter("@n_idtraIn", n_idtraIn));
command.Parameters.Add(new MySqlParameter("@n_idtar", n_idtar));
command.Parameters.Add(new MySqlParameter("@c_fchini", c_fchini));
command.Parameters.Add(new MySqlParameter("@c_fchfin", c_fchfin));
connection.Open();
using (MySqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
m_listaentidad.Add(new EmpleadoAvance
{
n_idper = Genericas.GetInt(reader, "n_idper"),
c_apenom = Genericas.GetString(reader, "c_apenom"),
d_fchtra = Genericas.GetDateTime(reader, "d_fchtra"),
n_can = Genericas.GetDouble(reader, "n_can"),
c_horini = Genericas.GetString(reader, "c_horini"),
c_horter = Genericas.GetString(reader, "c_horter")
});
}
}
}
}
return(m_listaentidad);
}
private static Empleado SetObject(MySqlDataReader reader)
{
return(new Empleado
{
n_id = reader.GetInt32("n_id"),
n_idemp = reader.GetInt32("n_idemp"),
n_idtipdocide = reader.GetInt32("n_idtipdocide"),
c_numdocide = reader.GetString("c_numdocide"),
c_ape1 = Genericas.GetString(reader, "c_ape1"),
c_ape2 = Genericas.GetString(reader, "c_ape2"),
c_nom1 = Genericas.GetString(reader, "c_nom1"),
c_nom2 = Genericas.GetString(reader, "c_nom2"),
d_fchnac = Genericas.GetDateTime(reader, "d_fchnac"),
n_idsex = Genericas.GetInt(reader, "n_idsex"),
c_numtel = Genericas.GetString(reader, "c_numtel"),
c_numesa = Genericas.GetString(reader, "c_numesa"),
d_fching = Genericas.GetDateTime(reader, "d_fching"),
n_asigfam = Genericas.GetInt(reader, "n_asigfam"),
n_suebas = Genericas.GetDouble(reader, "n_suebas"),
n_bon = Genericas.GetInt(reader, "n_bon"),
n_imphornor = Genericas.GetDouble(reader, "n_imphornor"),
n_imphorext = Genericas.GetDouble(reader, "n_imphorext"),
n_activo = Genericas.GetInt(reader, "n_activo"),
n_destajo = Genericas.GetInt(reader, "n_destajo"),
c_dir = Genericas.GetString(reader, "c_dir"),
c_email = Genericas.GetString(reader, "c_email"),
n_idnacpro = Genericas.GetInt(reader, "n_idnacpro"),
n_idnacdep = Genericas.GetInt(reader, "n_idnacdep"),
n_idnacdis = Genericas.GetInt(reader, "n_idnacdis"),
n_idrespro = Genericas.GetInt(reader, "n_idrespro"),
n_idresdep = Genericas.GetInt(reader, "n_idresdep"),
n_idresdis = Genericas.GetInt(reader, "n_idresdis"),
n_destacado = Genericas.GetInt(reader, "n_destacado"),
d_fchbaj = Genericas.GetDateTime(reader, "d_fchbaj")
});
}
