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