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") }); }