public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { CsrExpense rpt = new CsrExpense(); rpt.Site = this.Site; return(rpt); }
private void RefreshDailyExpenseReport() { if (!UserService.AllowToPerform(Resources.PermissionViewExpenseReport)) { const string briefMsg = "អំពីសិទ្ឋិប្រើប្រាស់"; var detailMsg = Resources.MsgUserPermissionDeny; using (var frmMessageBox = new FrmExtendedMessageBox()) { frmMessageBox.BriefMsgStr = briefMsg; frmMessageBox.DetailMsgStr = detailMsg; frmMessageBox.IsCanceledOnly = true; frmMessageBox.ShowDialog(this); return; } } var searchCriteria = new List<string> { "CONVERT(DATETIME, ExpenseDate, 103) BETWEEN CONVERT(DATETIME, '" + dtpStartDate.Value.ToString("dd/MM/yyyy", AppContext.CultureInfo) + "', 103) AND CONVERT(DATETIME, '" + dtpStopDate.Value.ToString("dd/MM/yyyy", AppContext.CultureInfo) + " 23:59', 103)" }; var expenseList = _ExpenseService.GetExpenses(searchCriteria); DataSet dtsProduct = new DtsModels(); var propertyInfos = typeof (Expense).GetProperties(); foreach (var objInstance in expenseList) { var dataRow = dtsProduct.Tables["DtbExpenses"].NewRow(); foreach (var propertyInfo in propertyInfos) dataRow[propertyInfo.Name] = propertyInfo.GetValue(objInstance, null); dtsProduct.Tables["DtbExpenses"].Rows.Add(dataRow); } var csrExpense = new CsrExpense(); csrExpense.SetDataSource(dtsProduct); crvReport.ReportSource = csrExpense; }
public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport() { CsrExpense rpt = new CsrExpense(); rpt.Site = this.Site; return rpt; }