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