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