public ModeloBEList GetAllBandejas(Int32 idMarca, String codModelo, String nomModelo, String codEstado, Int32 idUsuario) { ModeloBEList lista = new ModeloBEList(); IDataReader DReader = null; try { using (Database db = new Database()) { db.ProcedureName = "sgsnet_sps_bandeja_modelo"; db.AddParameter("@vi_in_id_marca", DbType.Int32, ParameterDirection.Input, idMarca); db.AddParameter("@vi_ch_cod_modelo", DbType.String, ParameterDirection.Input, codModelo); db.AddParameter("@vi_va_nom_modelo", DbType.String, ParameterDirection.Input, nomModelo); db.AddParameter("@vi_ch_cod_estado", DbType.String, ParameterDirection.Input, codEstado); DReader = db.GetDataReader(); } while (DReader.Read()) { lista.Add(CrearEntidadBandeja(DReader)); } DReader.Close(); } catch { if (DReader != null && !DReader.IsClosed) { DReader.Close(); } throw; } return(lista); }
public ModeloBEList GETListarModelos(ModeloBE ent) { ModeloBEList lista = new ModeloBEList(); IDataReader DReader = null; try { using (Database db = new Database()) { db.ProcedureName = "SRC_SPS_SEL_MODELO"; db.AddParameter("@co_modelo", DbType.String, ParameterDirection.Input, ent.co_modelo); db.AddParameter("@no_modelo", DbType.String, ParameterDirection.Input, ent.no_modelo); db.AddParameter("@nid_marca", DbType.String, ParameterDirection.Input, int.Parse(ent.nid_marca.ToString().Trim())); db.AddParameter("@co_negocio", DbType.String, ParameterDirection.Input, ent.co_negocio); db.AddParameter("@co_familia", DbType.String, ParameterDirection.Input, ent.co_familia); db.AddParameter("@Estado", DbType.String, ParameterDirection.Input, ent.estado); DReader = db.GetDataReader(); } while (DReader.Read()) { lista.Add(CrearEntidad_Parametros(DReader)); } DReader.Close(); } catch (Exception) { if (DReader != null && !DReader.IsClosed) { DReader.Close(); } throw; } return(lista); }
protected void btnBuscarWarrant_Click(object sender, ImageClickEventArgs e) { hf_exportaexcel.Value = ""; objEnt.co_modelo = txt_codmodelo.Text.Trim(); objEnt.no_modelo = txt_nommodelo.Text.Trim(); objEnt.nid_marca = int.Parse(ddl_marca.SelectedValue.ToString().Trim()); objEnt.co_negocio = ddl_negocio.SelectedValue.ToString().Trim(); objEnt.co_familia = ddl_familia.SelectedValue.ToString(); objEnt.estado = cboEstado.SelectedValue.ToString().Trim(); Session["MaestroModeloBE_FILTRO"] = objEnt; Session["objEnt_bus"] = objEnt; //--------- this.oMaestroModeloBEList = objNeg.GETListarModelos(objEnt); if (oMaestroModeloBEList == null || oMaestroModeloBEList.Count == 0) { Session["MaestroModeloBE_FILTRO"] = null; objEnt = null; objEnt = new ModeloBE(); oMaestroModeloBEList.Add(objEnt); } else { hf_exportaexcel.Value = "1"; } this.gdModelos.DataSource = oMaestroModeloBEList; this.gdModelos.DataBind(); Session["ModeloBEList"] = oMaestroModeloBEList; }