public List <AssessmentOverviewModel> GetAssessmentOverview(string assessment_name, string assessment_sponsor, int?assessment_statue, Pagination pagination, int assessment_type, string organize_id = "")
{
StringBuilder sqlBuilder = new StringBuilder();
sqlBuilder.Append("select a.id,a.assessment_name,a.filing_people,b.templete_name,a.start_time,a.end_time,c.F_RealName as assessment_sponsor_name,a.assessment_sponsor as assessment_sponsor_id,a.assessment_count,a.assessment_statue,a.create_time ");
sqlBuilder.Append("from t_kpi_launch a left join t_kpi_templete b on a.templete_id = b.id left join sys_user c on a.assessment_sponsor = c.F_Id ");
sqlBuilder.Append("LEFT JOIN sys_organize d ON c.F_OrganizeId = d.F_Id ");
sqlBuilder.AppendFormat("where assessment_type = {0} ", assessment_type);
if (!string.IsNullOrEmpty(assessment_name))
{
sqlBuilder.AppendFormat(" and a.assessment_name like '%{0}%' ", assessment_name);
}
if (!string.IsNullOrEmpty(assessment_sponsor))
{
sqlBuilder.AppendFormat(" and c.F_RealName ='{0}'", assessment_sponsor);
}
if (assessment_statue.HasValue)
{
sqlBuilder.AppendFormat(" and a.assessment_statue ={0} ", assessment_statue.Value);
}
if (!string.IsNullOrEmpty(organize_id))
{
sqlBuilder.AppendFormat(" AND d.F_Id = '{0}' ", organize_id);
}
IEnumerable <AssessmentOverviewModel> retData = null;
if (pagination == null || pagination.rows == 0)
{
retData = service.BasicQueryListT <AssessmentOverviewModel>(sqlBuilder.ToString());
}
else
{
retData = service.FindListBySql <AssessmentOverviewModel>(sqlBuilder.ToString(), pagination);
}
return(retData.ToList());
}