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