protected void kysGecikmePivot_NeedDataSource(object sender, PivotGridNeedDataSourceEventArgs e) { //EFDal ed = new EFDal(); //kysGecikmePivot.DataSource = ed.vKYSGecikme(); //kysGecikmePivot.DataBind(); (sender as RadPivotGrid).DataSource = GetDataTable("SELECT * FROM vKYSGecikme"); }
protected void pgDetallada_NeedDataSource(object sender, PivotGridNeedDataSourceEventArgs e) { //ConsultaPersonalNegocio neg = new ConsultaPersonalNegocio(); //List<E_CONSULTA_DETALLE> lstConsulta = neg.obtieneConsultaPersonalDetallada(vIdBateria).Select(s => new E_CONSULTA_DETALLE { //CL_CLASIFICACION = s.CL_CLASIFICACION, //CL_COLOR = s.CL_COLOR, //CL_FACTOR = s.CL_FACTOR, //CL_TIPO_COMPETENCIA = s.CL_TIPO_COMPETENCIA, //CL_VARIABLE = s.CL_VARIABLE, //DS_COMPETENCIA = s.DS_COMPETENCIA, //DS_FACTOR = s.DS_FACTOR, //ICONO = ObtenerIconoDetalle(s.NO_VALOR), //ID_FACTOR = s.ID_FACTOR, //ID_COMPETENCIA = s.ID_COMPETENCIA, //ID_VARIABLE = s.ID_VARIABLE, //NO_VALOR= s.NO_VALOR, //NB_FACTOR = s.NB_FACTOR, //NB_ABREVIATURA = s.NB_ABREVIATURA, //NB_COMPETENCIA = s.NB_COMPETENCIA, //NB_PRUEBA = s.NB_PRUEBA, //NB_CLASIFICACION_COMPETENCIA = s.NB_CLASIFICACION_COMPETENCIA //}).ToList(); //pgDetallada.DataSource = lstConsulta; }
protected void grdCliente_NeedDataSource(object sender, PivotGridNeedDataSourceEventArgs e) { try { grdCliente.DataSource = JsonHelper.JsonDeserialize <List <gsDocVenta_ReporteVenta_ClienteResult> >((string)ViewState["lstVendedor"]); } catch (Exception ex) { lblMensaje.Text = ex.Message; lblMensaje.CssClass = "mensajeError"; } }
protected void grdPresupuesto_NeedDataSource(object sender, PivotGridNeedDataSourceEventArgs e) { if (Session["Usuario"] == null) { Response.Redirect("~/Security/frmCerrar.aspx"); } try { grdPresupuesto.DataSource = JsonHelper.JsonDeserialize <List <gsPresupuesto_Reporte_MarcaResult> >((string)ViewState["lstPresupuesto"]); } catch (Exception ex) { rwmReporte.RadAlert(ex.Message, 500, 100, "Error al descargar el excel", ""); } }
protected void RadPivotGrid1_NeedDataSource(object sender, PivotGridNeedDataSourceEventArgs e) { var orderDetails = from o in DbContext.Orders join od in DbContext.Order_Details on o.OrderID equals od.OrderID join p in DbContext.Products on od.ProductID equals p.ProductID where o.OrderDate.Value.Year >= 1997 select new { Year = o.OrderDate.Value.Year, Quarter = "Quarter " + ((o.OrderDate.Value.Month / 4) + 1), ProductName = p.ProductName, Category = p.Category.CategoryName, TotalPrice = od.UnitPrice * od.Quantity, Quantity = od.Quantity }; RadPivotGrid1.DataSource = orderDetails; }
protected void rpgResumenZona_NeedDataSource(object sender, PivotGridNeedDataSourceEventArgs e) { if (Session["Usuario"] == null) { ScriptManager.RegisterStartupScript(Page, this.GetType(), "mykey", "CancelEdit();", true); } try { if (Session["lstPresupuestoResumen"] != null) { rpgResumenZona.DataSource = JsonHelper.JsonDeserialize <List <USP_SEL_VENTA_POR_VENDEDOR2> >((string)Session["lstPresupuestoResumen"]); } } catch (Exception ex) { rwmPre.RadAlert(ex.Message, 400, null, "Mensaje de error", null); } }
protected void grdIndicadores_OnNeedDataSource(object sender, PivotGridNeedDataSourceEventArgs e) { if (Session["Usuario"] == null) { Response.Redirect("~/Security/frmCerrar.aspx"); } try { if (lblDate2.Text == "2") { grdIndicadores.DataSource = JsonHelper.JsonDeserialize <List <gsReporte_IndicadoresCreditosResult> >((string)ViewState["lstIndicadores"]); } } catch (Exception ex) { rwmVidaLey.RadAlert(ex.Message, 500, 100, "Error al consultar el archivo", ""); } }
protected void gsReporteVentas_Item_NeedDataSource(object sender, PivotGridNeedDataSourceEventArgs e) { if (Session["Usuario"] == null) { Response.Redirect("~/Security/frmCerrar.aspx"); } try { if (lblReporte.Value == "1") { gsReporteVentas_Item.DataSource = JsonHelper.JsonDeserialize <List <ReporteVentas_ItemsResult> >((string)ViewState["ListaReporteItem"]); } } catch (Exception ex) { rwmReporte.RadAlert(ex.Message, 500, 100, "Error al consultar NeedDataSource", ""); } }
protected void gsContadorSinAccesos_NeedDataSource(object sender, PivotGridNeedDataSourceEventArgs e) { if (Session["Usuario"] == null) { Response.Redirect("~/Security/frmCerrar.aspx"); } try { if (lblReporteS.Value == "1") { this.gsContadorSinAccesos.DataSource = JsonHelper.JsonDeserialize <List <usp_Sel_MenusNoAccedidosResult> >((string)ViewState["ListaMenusS"]); } } catch (Exception ex) { rwmReporte.RadAlert(ex.Message, 500, 100, "Error al consultar NeedDataSource", ""); } }
protected void grdComparativoPivot_NeedDataSource(object sender, PivotGridNeedDataSourceEventArgs e) { if (Session["Usuario"] == null) { Response.Redirect("~/Security/frmCerrar.aspx"); } try { if (ViewState["lstPlaneamiento"] != null) { grdComparativoPivot.DataSource = JsonHelper.JsonDeserialize <List <gsPronostico_vs_RealResult> >((string)ViewState["lstPlaneamiento"]); //grdProducto.DataBind(); } } catch (Exception ex) { lblMensaje.Text = ex.Message; lblMensaje.CssClass = "mensajeError"; } }
protected void rpgResumenZona_NeedDataSource(object sender, PivotGridNeedDataSourceEventArgs e) { //if (Session["Usuario"] == null) // Response.Redirect("~/Security/frmCerrar.aspx"); //try //{ // //CargarPresupuestoPendiente(); // //CargarPresupuestoPromotor(); // rpgResumenZona.DataSource = JsonHelper.JsonDeserialize<List<USP_Sel_MetaPresupuestoPromotorResult>>((string)Session["lstpromotor"]); //} //catch (Exception ex) //{ // lblMensaje.Text = ex.Message; // lblMensaje.CssClass = "mensajeError"; //} }
protected void rpgResumenZona_NeedDataSource(object sender, PivotGridNeedDataSourceEventArgs e) { if (Session["Usuario"] == null) { Response.Redirect("~/Security/frmCerrar.aspx"); } try { List <USP_SEL_LetrasSinCanjeV2Result> lstletras = new List <USP_SEL_LetrasSinCanjeV2Result>(); lstletras = JsonHelper.JsonDeserialize <List <USP_SEL_LetrasSinCanjeV2Result> >((string)Session["lstletrasresumen"]); if (lstletras.Any()) { rpgResumenZona.DataSource = lstletras; } } catch (Exception ex) { lblMensaje.Text = "ERROR: " + ex.Message; lblMensaje.CssClass = "mensajeError"; } }
protected void pgDetalleCompetencia_NeedDataSource(object sender, PivotGridNeedDataSourceEventArgs e) { pgDetalleCompetencia.DataSource = vPuestoCandidatos; }
protected void RadPivotGrid1_NeedDataSource(object sender, PivotGridNeedDataSourceEventArgs e) { (sender as RadPivotGrid).DataSource = GetDataTable("SELECT * FROM Transportation"); }
/// <summary> /// داده های پایوت گیرید از طریق این متد فراهم می گردد /// </summary> /// <param name="sender">The source of the event.</param> /// <param name="e">The <see cref="PivotGridNeedDataSourceEventArgs"/> instance containing the event data.</param> protected void RadPivotGrid1_NeedDataSource(object sender, PivotGridNeedDataSourceEventArgs e) { (sender as RadPivotGrid).DataSource = ExamBusiness.GetAllSansCoutCity(term, Session["UserId"].ToString()); }
protected void RadPivotGrid1_NeedDataSource(object sender, PivotGridNeedDataSourceEventArgs e) { }