protected void ASPxGridView1_CustomUnboundColumnData(object sender, DevExpress.Web.ASPxGridView.ASPxGridViewColumnDataEventArgs e) { if (e.Column.FieldName == "Total") { decimal price1 = (decimal)e.GetListSourceFieldValue("KCF"); decimal price2 = (decimal)e.GetListSourceFieldValue("ZCF"); e.Value = price1 + price2; } }
protected void grid_CustomUnboundColumnData(object sender, DevExpress.Web.ASPxGridView.ASPxGridViewColumnDataEventArgs e) { if (e.Column.FieldName == "Total") { decimal price = (decimal)e.GetListSourceFieldValue("UnitPrice"); int quantity = Convert.ToInt32(e.GetListSourceFieldValue("Quantity")); e.Value = price * quantity; } }
protected void grid_CustomUnboundColumnData(object sender, DevExpress.Web.ASPxGridView.ASPxGridViewColumnDataEventArgs e) { if (e.Column.FieldName == "Variance") { decimal unitPrice = Convert.ToDecimal(e.GetListSourceFieldValue("UnitPrice")); decimal unitsInStock = Convert.ToDecimal(e.GetListSourceFieldValue("UnitsInStock")); if (unitPrice != 0) { e.Value = (unitPrice - unitsInStock) / unitPrice; } else { e.Value = 0; } } }
// Fetch unbound data here protected void ASPxGridView1_CustomUnboundColumnData(object sender, DevExpress.Web.ASPxGridView.ASPxGridViewColumnDataEventArgs e) { if (e.IsGetData && e.Column.FieldName == "Comment") { object key = e.GetListSourceFieldValue(e.ListSourceRowIndex, ASPxGridView1.KeyFieldName); e.Value = MyComments.GetComment(key); } }
protected void grid_CustomUnboundColumnData(object sender, DevExpress.Web.ASPxGridView.ASPxGridViewColumnDataEventArgs e) { if (e.Column.FieldName == "percent") { if ((grid.GroupCount > 0)) { string itemKeyValue = e.GetListSourceFieldValue("ProductID").ToString(); object summaryValue = grid.GetGroupSummaryValue(GetGroupIndex(itemKeyValue), grid.GroupSummary[0]); if (summaryValue != null) { e.Value = (decimal)e.GetListSourceFieldValue("UnitPrice") / (decimal)summaryValue; } } else { e.Value = (decimal)e.GetListSourceFieldValue("UnitPrice") / (decimal)grid.GetTotalSummaryValue(grid.TotalSummary[0]); } } }
protected void grdInventoryCommand_CustomUnboundColumnData(object sender, DevExpress.Web.ASPxGridView.ASPxGridViewColumnDataEventArgs e) { if (e.Column.FieldName == "PersonName") { InventoryAuditArtifact _inventoryAuditArtifact = session.GetObjectByKey <InventoryAuditArtifact>(e.GetListSourceFieldValue("InventoryCommandId")); if (_inventoryAuditArtifact != null) { foreach (InventoryCommandActor ica in _inventoryAuditArtifact.InventoryCommandActors) { if (ica.InventoryCommandActorTypeId.Name == "CHIEFCHECKING") { if (ica.PersonId != null) { e.Value = ica.PersonId.Name; break; } } } } } }