public IEnumerable <R_ProjectPartner> GetProjectPartners()
{
IEnumerable <R_ProjectPartner> results = null;
var sql = PetaPoco.Sql.Builder
.Select("*")
.From("R_ProjectPartner")
.Where("IsDeleted = 0")
;
results = R_ProjectPartner.Query(sql);
return(results);
}
public IEnumerable <R_ProjectPartner> GetProjectPartnerListAdvancedSearch(
int?projectId
, int?partnerId
, double?grantValue
)
{
IEnumerable <R_ProjectPartner> results = null;
var sql = PetaPoco.Sql.Builder
.Select("*")
.From("R_ProjectPartner")
.Where("IsDeleted = 0"
+ (projectId != null ? " and ProjectId = " + projectId : "")
+ (partnerId != null ? " and PartnerId = " + partnerId : "")
+ (grantValue != null ? " and GrantValue like '%" + grantValue + "%'" : "")
)
;
results = R_ProjectPartner.Query(sql);
return(results);
}