public IEnumerable <R_DeliveryReportMessage> GetDeliveryReportMessages() { IEnumerable <R_DeliveryReportMessage> results = null; var sql = PetaPoco.Sql.Builder .Select("*") .From("R_DeliveryReportMessage") .Where("IsDeleted = 0") ; results = R_DeliveryReportMessage.Query(sql); return(results); }
public IEnumerable <R_DeliveryReportMessage> GetDeliveryReportMessageListAdvancedSearch( int?deliveryReportMessageTypeId , string message ) { IEnumerable <R_DeliveryReportMessage> results = null; var sql = PetaPoco.Sql.Builder .Select("*") .From("R_DeliveryReportMessage") .Where("IsDeleted = 0" + (deliveryReportMessageTypeId != null ? " and DeliveryReportMessageTypeId = " + deliveryReportMessageTypeId : "") + (message != null ? " and Message like '%" + message + "%'" : "") ) ; results = R_DeliveryReportMessage.Query(sql); return(results); }