public DataTable GetExpenseDetailList(int approvalStatus)
{
var query = _dbView.vwExpenseHqDetailDownloadLists
.Where(w => w.ApprovalStatus >= Convert.ToInt32(approvalStatus))
.Select(w => w);
var tempDt = CGlobal.ConvertToDataTable(query);
return(tempDt);
}
public DataTable GetVwCreditMemoExcel(StringBuilder filterExpressionSb)
{
var tempDt = _dbView.ExecuteQuery <vwCreditMemoExcel>("SELECT * FROM " + nameof(vwCreditMemoExcel) + (filterExpressionSb.Length == 0 ? string.Empty : " WHERE " + filterExpressionSb));
return(CGlobal.ConvertToDataTable(tempDt));
}