private static ProductoRecetaLineaTarea SetObject(MySqlDataReader reader)
{
return(new ProductoRecetaLineaTarea
{
n_idpro = Genericas.GetInt(reader, "n_idpro"),
n_idrec = Genericas.GetInt(reader, "n_idrec"),
n_idlin = Genericas.GetInt(reader, "n_idlin"),
n_idtar = Genericas.GetInt(reader, "n_idtar"),
n_porefi = reader.GetDouble("n_porefi"),
n_cankilpro = reader.GetDouble("n_cankilpro"),
n_numpertar = Genericas.GetInt(reader, "n_numpertar"),
n_idequipo = Genericas.GetInt(reader, "n_idequipo"),
n_canequi = Genericas.GetInt(reader, "n_canequi"),
n_numpertarequ = Genericas.GetInt(reader, "n_numpertarequ"),
n_capkilporper = reader.GetDouble("n_capkilporper"),
n_capkilporhorlin = reader.GetDouble("n_capkilporhorlin"),
n_capkilporlintietra = reader.GetDouble("n_capkilporlintietra"),
n_numpercal = reader.GetDouble("n_numpercal"),
n_totprotietra = reader.GetDouble("n_totprotietra"),
n_porefiuni = reader.GetDouble("n_porefiuni"),
n_porefitot = reader.GetDouble("n_porefitot"),
n_costar = reader.GetDouble("n_costar"),
n_ord = Genericas.GetInt(reader, "n_ord"),
n_kghper = reader.GetDouble("n_kghper"),
c_destar = Genericas.GetString(reader, "c_destar")
});
}
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")
});
}
private static ProductoReceta SetObject(MySqlDataReader reader)
{
return(new ProductoReceta
{
n_id = Genericas.GetInt(reader, "n_id"),
n_idpro = Genericas.GetInt(reader, "n_idpro"),
c_codrec = Genericas.GetString(reader, "c_codrec"),
c_des = Genericas.GetString(reader, "c_des"),
n_idunimed = Genericas.GetInt(reader, "n_idunimed"),
n_can = reader.GetDouble("n_can"),
n_prirec = Genericas.GetInt(reader, "n_prirec"),
c_obs = Genericas.GetString(reader, "c_obs"),
n_act = Genericas.GetInt(reader, "n_act")
});
}
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 Producto SetObject(MySqlDataReader reader)
{
return(new Producto
{
n_id = Genericas.GetInt(reader, "n_id"),
n_idemp = Genericas.GetInt(reader, "n_idemp"),
c_cod = Genericas.GetString(reader, "c_cod"),
c_despro = Genericas.GetString(reader, "c_despro"),
n_idunimed = Genericas.GetInt(reader, "n_idunimed"),
n_idfam = Genericas.GetInt(reader, "n_idfam"),
n_idcla = Genericas.GetInt(reader, "n_idcla"),
n_idsubcla = Genericas.GetInt(reader, "n_idsubcla"),
n_idtip = Genericas.GetInt(reader, "n_idtip"),
c_obs = Genericas.GetString(reader, "c_obs"),
n_act = Genericas.GetInt(reader, "n_act"),
n_kilhor = reader.GetDouble("n_kilhor"),
n_idmatpri = Genericas.GetInt(reader, "n_idmatpri")
});
}
private static ProductoRecetaLinea SetObject(MySqlDataReader reader)
{
return(new ProductoRecetaLinea
{
n_id = Genericas.GetInt(reader, "n_id"),
n_idpro = Genericas.GetInt(reader, "n_idpro"),
n_idrec = Genericas.GetInt(reader, "n_idrec"),
c_codlin = Genericas.GetString(reader, "c_codlin"),
c_deslin = Genericas.GetString(reader, "c_deslin"),
n_idunimed = Genericas.GetInt(reader, "n_idunimed"),
n_idite = Genericas.GetInt(reader, "n_idite"),
n_can = reader.GetDouble("n_can"),
n_numope = reader.GetDouble("n_numope"),
n_efi = reader.GetDouble("n_efi"),
n_tiepro = reader.GetDouble("n_tiepro"),
n_prehorjor = reader.GetDouble("n_prehorjor"),
n_act = Genericas.GetInt(reader, "n_act"),
c_obs = Genericas.GetString(reader, "c_obs")
});
}
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")
});
}
