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