public ActionResult Create()
{
SymptomDepartment sd = new SymptomDepartment()
{
bodypartList = db.bodypart.ToList(),
symptomList = db.symptom.ToList(),
departmentList = db.department.ToList()
};
return(View(sd));
}
// GET: SymptomDepartment
public ActionResult Index(int page = 1)
{
List <dep_sym_ref> dsRefLis = db.dep_sym_ref.ToList();
//回傳分頁過的list回前端---------------------------------------
int pageDataSize = 20;
int pageCurrent = page < 1 ? 1 : page;
IPagedList <dep_sym_ref> pagedlist = dsRefLis.ToPagedList(pageCurrent, pageDataSize);
SymptomDepartment sd = new SymptomDepartment()
{
bodypartList = db.bodypart.ToList(),
symptomList = db.symptom.ToList(),
departmentList = db.department.ToList(),
depSymRefPagedList = pagedlist
};
return(View(sd));
}
public ActionResult Index(int page = 1, string pId = "", string sId = "", string dId = "")
{
IQueryable <dep_sym_ref> dsRefLis;
dsRefLis = from m in db.dep_sym_ref
select m;
if (pId != "")
{
dsRefLis = dsRefLis.Where(m => m.part_id == pId);
}
if (sId != "")
{
dsRefLis = dsRefLis.Where(m => m.sym_id == sId);
}
if (dId != "")
{
dsRefLis = dsRefLis.Where(m => m.dep_id == dId);
}
//回傳分頁過的list回前端---------------------------------------
int pageDataSize = 20;
int pageCurrent = page < 1 ? 1 : page;
IPagedList <dep_sym_ref> pagedlist = dsRefLis.ToList().ToPagedList(pageCurrent, pageDataSize);
SymptomDepartment sd = new SymptomDepartment()
{
bodypartList = db.bodypart.ToList(),
symptomList = db.symptom.ToList(),
departmentList = db.department.ToList(),
depSymRefPagedList = pagedlist
};
ViewBag.pId = pId;
ViewBag.sId = sId;
ViewBag.dId = dId;
return(View(sd));
}
public ActionResult Edit(int?sn, string pId, string sId, string dId)
{
if (sn == null || pId == null || sId == null || dId == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
dep_sym_ref data = (from m in db.dep_sym_ref
where m.dep_sym_sn == sn && m.part_id == pId && m.sym_id == sId && m.dep_id == dId
select m).FirstOrDefault();
if (data == null)
{
return(HttpNotFound());
}
SymptomDepartment sd = new SymptomDepartment()
{
bodypartList = db.bodypart.ToList(),
symptomList = db.symptom.ToList(),
departmentList = db.department.ToList(),
depSymRef = data
};
return(View(sd));
}
