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