protected internal virtual void OnDataResolved(JQGridDataResolvedEventArgs e) { JQGridDataResolvedEventHandler handler = (JQGridDataResolvedEventHandler)this.Events[EventDataResolved]; if (handler != null) { handler(this, e); } }
void RefundsProductLineGroupingGrandTotal_DataResolved(object sender, JQGridDataResolvedEventArgs e) { if (Request.Params["refundsReportDate"] != null) { DateTime reportDate = DateTime.Now; int contractorId = 0; DateTime.TryParse(Request.Params["refundsReportDate"].ToString(), out reportDate); Int32.TryParse(Request.Params["contractorId"].ToString(), out contractorId); if (reportDate != DateTime.Now) { try { JQGridColumn saleSumColumn = e.GridModel.Columns.Find(c => c.DataField == "SaleSum"); JQGridColumn sumColumn = e.GridModel.Columns.Find(c => c.DataField == "Sum"); JQGridColumn quantityColumn = e.GridModel.Columns.Find(c => c.DataField == "Quantity"); // Записывать клиентов от которых были возвраты JQGridColumn commentColumn = e.GridModel.Columns.Find(c => c.DataField == "Comment"); var datacontextModel = new SkladDataContext(); // TODO: Найти все документы возврата за указанный день и выбрать по ним сумму string saleSum = "0", sum = "0", quantity = "0"; List<Document> docs = null; if (contractorId > 0) docs = datacontextModel.Documents.Where(x => x.CreatedOf == reportDate && x.IsCommitted == true && x.DocumentTypeId == (int)EntityEnum.DocumentTypeEnum.Refunds && x.ContractorId == contractorId).ToList(); else docs = datacontextModel.Documents.Where(x => x.CreatedOf == reportDate && x.IsCommitted == true && x.DocumentTypeId == (int)EntityEnum.DocumentTypeEnum.Refunds).ToList(); if (docs != null) { if (docs.Count > 0) { var docIds = docs.Select(x => x.DocumentId).ToArray(); commentColumn.FooterValue = "Возвраты от: " + String.Join(", ",docs.Select(x => x.Contractor.Code).Distinct().ToArray()); // ids.Contains(e.SuchID) saleSum = (from o in datacontextModel.ProductLines where docIds.Contains(o.DocumentId) select o.SaleSum) .Sum().ToString(); sum = (from o in datacontextModel.ProductLines where docIds.Contains(o.DocumentId) select o.Sum) .Sum().ToString(); quantity = (from o in datacontextModel.ProductLines where docIds.Contains(o.DocumentId) select o.Quantity) .Sum().ToString(); } } saleSumColumn.FooterValue = "Итого: " + saleSum; sumColumn.FooterValue = "Итого: " + sum; quantityColumn.FooterValue = "Итого: " + quantity; } catch (Exception ex) { logger.Error("Ошибка при подсчёте итоговых сумм: " + ex.Message); } } } }
void GroupingGrandTotal_DataResolved(object sender, JQGridDataResolvedEventArgs e) { if (Request.Params["documentId"] != null) { int documentId = 0; Int32.TryParse(Request.Params["documentId"].ToString(), out documentId); if (documentId > 0) { try { JQGridColumn saleSumColumn = e.GridModel.Columns.Find(c => c.DataField == "SaleSum"); JQGridColumn sumColumn = e.GridModel.Columns.Find(c => c.DataField == "Sum"); JQGridColumn quantityColumn = e.GridModel.Columns.Find(c => c.DataField == "Quantity"); var datacontextModel = new SkladDataContext(); string saleSum = (from o in datacontextModel.ProductLines where o.DocumentId == documentId select o.SaleSum) .Sum().ToString(); string sum = (from o in datacontextModel.ProductLines where o.DocumentId == documentId select o.Sum) .Sum().ToString(); string quantity = (from o in datacontextModel.ProductLines where o.DocumentId == documentId select o.Quantity) .Sum().ToString(); saleSumColumn.FooterValue = "Итого: " + saleSum; sumColumn.FooterValue = "Итого: " + sum; quantityColumn.FooterValue = "Итого: " + quantity; } catch (Exception ex) { logger.Error("Ошибка при подсчёте итоговых сумм: " + ex.Message); } } //shipCityColumn.FooterValue = "Grand Total: "; } }
protected internal virtual void OnDataResolved(JQGridDataResolvedEventArgs e) { JQGridDataResolvedEventHandler handler = (JQGridDataResolvedEventHandler) this.Events[EventDataResolved]; if (handler != null) { handler(this, e); } }