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; }
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); }
protected void gvModelo_PageIndexChanging(object sender, GridViewPageEventArgs e) { oModelosBEList = (ModeloBEList)ViewState["oModelosBEList"]; this.gvModelo.DataSource = oModelosBEList; this.gvModelo.PageIndex = e.NewPageIndex; this.gvModelo.DataBind(); this.txhIdModelo.Value = String.Empty; }
private void InicializaModelo() { this.oModelosBEList = new ModeloBEList(); this.oModelosBEList.Add(new ModeloBE()); ViewState["oModelosBEList"] = this.oModelosBEList; this.gvModelo.DataSource = this.oModelosBEList; this.gvModelo.DataBind(); this.cboEstadoModelo.SelectedValue = ConstanteBE.FL_ESTADO_ACTIVO; }
protected void btnExcel_Click(object sender, ImageClickEventArgs e) { try { ModeloBL oMaestroModeloBL = new ModeloBL(); oMaestroModeloBL.ErrorEvent += new ModeloBL.ErrorDelegate(Master.Transaction_ErrorEvent); 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(); this.oMaestroModeloBEList = oMaestroModeloBL.GETListarModelos(objEnt); const string RUTA_DOCUMENTOS = ConstanteBE.RUTA_MANTENIMIENTO_SRC; String carpeta = String.Empty, nombre = String.Empty, RutaFinal = String.Empty; String ruta = Convert.ToString(ConfigurationManager.AppSettings["FileServerPath"]) + RUTA_DOCUMENTOS; ruta = Utility.CrearCarpetaFileServer(ruta); String fl_Ruta = ConstanteBE.FLAT_EXCEL_SRC; ExportarExcelXml oExportarExcelXml = new ExportarExcelXml(); String archivo = oExportarExcelXml.GenerarExcelExportarModelo(this.oMaestroModeloBEList, ruta); if (!archivo.Equals("-1")) { nombre = archivo; carpeta = Utility.ObtenerCarpetaFileServer(nombre); archivo = Convert.ToString(ConfigurationManager.AppSettings["FileServerPath"]) + RUTA_DOCUMENTOS + carpeta + @"\" + Convert.ToString(nombre.Trim()); if (File.Exists(archivo)) { this.Page.ClientScript.RegisterStartupScript(this.Page.GetType(), String.Empty, "<script> window.open('../SGS_Comunes/SGS_VerExcelExpotable.aspx?nombreArchivo=" + nombre + "&flatRuta=" + fl_Ruta + "')</script>"); } } else { JavaScriptHelper.Alert(this, "'Problemas al generar el excel, consulte con el administrador.'", String.Empty); } } catch (Exception ex) { Master.Web_ErrorEvent(this, ex); JavaScriptHelper.Alert(this, ex.Message.ToString(), String.Empty); } }
private void CargarEntidad() { ModeloBEList objBEList = new ModeloBEList(); objBEList = (ModeloBEList)(Session["ModeloBEList"]); if (objBEList != null) { for (int i = 0; i < objBEList.Count; i++) { if (objBEList[i].nid_modelo.ToString().Trim().Equals(Session["txh_nid_modelo"].ToString().Trim())) { objEnt = objBEList[i]; } } } }
private void Inicializa() { CargarEstados(); CargarMarcas(); CargarNegocios(ddl_marca.SelectedValue.ToString().Trim()); objEnt.co_negocio = ddl_negocio.SelectedValue.ToString().Trim(); CargarFamiliaByNegocio(objEnt); //------------------------------------------------------------- //INICIALIZANDO EL GRIDVIEW this.oMaestroModeloBEList = new ModeloBEList(); this.oMaestroModeloBEList.Add(new ModeloBE()); Session["ModeloBEList"] = oMaestroModeloBEList; this.gdModelos.DataSource = this.oMaestroModeloBEList; this.gdModelos.DataBind(); }
protected void btnBuscarModelo_Click(object sender, ImageClickEventArgs e) { ModeloBL oModelosBL = new ModeloBL(); oModelosBL.ErrorEvent += new ModeloBL.ErrorDelegate(Master.Transaction_ErrorEvent); String codModelo = this.txtCodModelo.Text; String nomModelo = this.txtNomModelo.Text; String codEstado = this.cboEstadoModelo.SelectedValue; this.oModelosBEList = oModelosBL.GetAllBandeja(this.idMarca, codModelo, nomModelo, codEstado, Profile.Usuario.Nid_usuario); if (this.oModelosBEList == null || this.oModelosBEList.Count == 0) { JavaScriptHelper.Alert(this, Message.keyNoRegistros, ""); this.oModelosBEList.Add(new ModeloBE()); } this.gvModelo.DataSource = this.oModelosBEList; this.gvModelo.DataBind(); ViewState["oModelosBEList"] = this.oModelosBEList; this.txhIdModelo.Value = String.Empty; }
protected void gvModelo_Sorting(object sender, GridViewSortEventArgs e) { this.oModelosBEList = (ModeloBEList)ViewState["oModelosBEList"]; SortDirection indOrden = (SortDirection)ViewState["ordenLista"]; if (oModelosBEList != null) { if (indOrden == SortDirection.Ascending) { oModelosBEList.Ordenar(e.SortExpression, direccionOrden.Descending); ViewState["ordenLista"] = SortDirection.Descending; } else { oModelosBEList.Ordenar(e.SortExpression, direccionOrden.Ascending); ViewState["ordenLista"] = SortDirection.Ascending; } } this.gvModelo.DataSource = oModelosBEList; this.gvModelo.DataBind(); ViewState["oModelosBEList"] = oModelosBEList; this.txhIdModelo.Value = String.Empty; }
protected void gdModelos_Sorting(object sender, GridViewSortEventArgs e) { ModeloBEList oMaestroModeloBEList = (ModeloBEList)(Session["ModeloBEList"]); SortDirection indOrden = (SortDirection)(Session["ordenGridTalleres"]); txh_nid_modelo.Value = String.Empty; if (oMaestroModeloBEList != null) { if (indOrden == SortDirection.Ascending) { oMaestroModeloBEList.Ordenar(e.SortExpression, direccionOrden.Descending); Session["ordenGridTalleres"] = SortDirection.Descending; } else { oMaestroModeloBEList.Ordenar(e.SortExpression, direccionOrden.Ascending); Session["ordenGridTalleres"] = SortDirection.Ascending; } } gdModelos.DataSource = oMaestroModeloBEList; gdModelos.DataBind(); Session["ModeloBEList"] = oMaestroModeloBEList; }
protected void Page_PreRender(object sender, EventArgs e) { //Bandeja de perfiles ModeloBEList oMaestroModeloBEList = (ModeloBEList)(Session["ModeloBEList"]); if (oMaestroModeloBEList != null && this.gdModelos != null && this.gdModelos.Rows.Count > 0 && this.gdModelos.PageCount > 1) { GridViewRow oRow = this.gdModelos.BottomPagerRow; if (oRow != null) { Label oTotalReg = new Label(); oTotalReg.Text = String.Format("Total Reg. {0}", (oMaestroModeloBEList.Count)); oRow.Cells[0].Controls.AddAt(0, oTotalReg); Table oTablaPaginacion = (Table)oRow.Cells[0].Controls[1]; oTablaPaginacion.CellPadding = 0; oTablaPaginacion.CellSpacing = 0; } } }