Ejemplo n.º 1
0
        public IEnumerable <R_Expense> GetExpenses()
        {
            IEnumerable <R_Expense> results = null;

            var sql = PetaPoco.Sql.Builder
                      .Select("*")
                      .From("R_Expense")
                      .Where("IsDeleted = 0")

            ;

            results = R_Expense.Query(sql);

            return(results);
        }
Ejemplo n.º 2
0
        public IEnumerable <R_Expense> GetExpenseListAdvancedSearch(
            int?nucleoId
            , string name
            , string description
            , int?responsiblePersonId
            , int?executerPersonId
            , int?documentId
            , int?partnerId
            , System.DateTime?invoiceDateFrom
            , System.DateTime?invoiceDateTo
            , double?amount
            )
        {
            IEnumerable <R_Expense> results = null;

            var sql = PetaPoco.Sql.Builder
                      .Select("*")
                      .From("R_Expense")
                      .Where("IsDeleted = 0"
                             + (nucleoId != null ? " and NucleoId like '%" + nucleoId + "%'" : "")
                             + (name != null ? " and Name like '%" + name + "%'" : "")
                             + (description != null ? " and Description like '%" + description + "%'" : "")
                             + (responsiblePersonId != null ? " and ResponsiblePersonId like '%" + responsiblePersonId + "%'" : "")
                             + (executerPersonId != null ? " and ExecuterPersonId like '%" + executerPersonId + "%'" : "")
                             + (documentId != null ? " and DocumentId like '%" + documentId + "%'" : "")
                             + (partnerId != null ? " and PartnerId like '%" + partnerId + "%'" : "")
                             + (invoiceDateFrom != null ? " and InvoiceDate >= '" + invoiceDateFrom.Value.ToShortDateString() + "'" : "")
                             + (invoiceDateTo != null ? " and InvoiceDate <= '" + invoiceDateTo.Value.ToShortDateString() + "'" : "")
                             + (amount != null ? " and Amount like '%" + amount + "%'" : "")
                             )
            ;

            results = R_Expense.Query(sql);

            return(results);
        }