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