public async Task <IActionResult> Search(ViewModel.SearchModel model) { var result = await _context.Pharmacy.ToListAsync(); if ((model.PharmacyName ?? "") != "") { result = result.Where(b => b.PharmacyName.ToLower().Contains(model.PharmacyName.ToLower())).ToList(); } result = result.Where(b => b.PharmacyLocation == model.PharmacyLocation).ToList(); model.pharmacies = result; return(View(model)); }
public ActionResult ViewList(ViewModel.SearchModel model) { if (ModelState.IsValid) { try { StringBuilder sql = new StringBuilder(); StringBuilder sql2 = new StringBuilder(); sql2.Append("select id,name,sex,school,grade from("); sql.Append("select stu_id as 'id',stu_name as 'name',stu_sex as 'sex',school_name as 'school',grade_name as 'grade' from Student_Info"); sql.Append(" left join Dic_School on school_id=stu_school_id"); sql.Append(" left join Dic_Grade on grade_id=stu_grade_id"); sql.Append(" left join User_vs_Student on uvs_stu_id=stu_id"); sql.Append(" left join User_Info on user_id=uvs_user_id"); sql.Append(" where 1=1"); if (model.school != null && model.school > 0) { sql.Append(" and stu_school_id=").Append(model.school); } if (model.grade != null && model.grade > 0) { sql.Append(" and stu_grade_id=").Append(model.grade); } if (!string.IsNullOrEmpty(model.sex)) { sql.Append(" and stu_sex='").Append(model.sex).Append("'"); } if (model.course != null && model.course > 0) { sql.Append(" and exists(select 1 from Student_vs_Course where svc_course_id=").Append(model.course).Append(" and svc_stu_id=stu_id)"); } sql2.Append(sql); if (!string.IsNullOrEmpty(model.keyword)) { sql2.Append(" and stu_name like '%").Append(model.keyword).Append("%'"); sql2.Append(" union ").Append(sql).Append(" and stu_name like '%").Append(model.keyword).Append("%'"); sql2.Append(" union ").Append(sql).Append(" and stu_id like '%").Append(model.keyword).Append("%'"); sql2.Append(" union ").Append(sql).Append(" and stu_idCard like '%").Append(model.keyword).Append("%'"); sql2.Append(" union ").Append(sql).Append(" and user_name like '%").Append(model.keyword).Append("%'"); } sql2.Append(") t group by id,name,sex,school,grade"); var list = db.Database.SqlQuery <ViewModel.ViewStudent>(sql2.ToString()); ViewData["stu_list"] = list.ToList(); } catch (Exception e) { ViewBag.msg = e.ToString(); } } StringBuilder sbmsg = new StringBuilder(); foreach (var value in ModelState.Values) { if (value.Errors.Count() > 0) { foreach (var err in value.Errors) { sbmsg.Append(err.ErrorMessage); } ViewBag.msg = sbmsg.ToString();; } } CreateSelect(); CreateSelect2(); return(View(model)); }
public ActionResult ViewList() { ViewModel.SearchModel model = new ViewModel.SearchModel(); return(ViewList(model)); //return View(model); }