public ActionResult employeeMain(VW_EmpWorkInfo employee) //人事資料主檔,明細檔-工種,明細檔-健檢記錄(查詢完成按下放大鏡後使用的ActionResult) { var query = from o in db.Employee where o.employee_workNumber == employee.employee_workNumber select o; var query1 = from x in db.WorkInfo where x.work_id == employee.employee_Workid select x; var query2 = from z in db.ReportManage where z.ReportManage_workNumber == employee.employee_workNumber select z; var query3 = from a in db.VW_EmpWorkInfo where a.employee_workNumber == employee.employee_workNumber select a; basicDataEmpolyeeMain data = new basicDataEmpolyeeMain(); data.employee = query.ToList(); data.workInfo = query1.ToList(); data.reportManage = query2.ToList(); data.vW_EmpWorkInfo = query3.ToList(); Session["workNumber"] = employee.employee_workNumber; Session["workId"] = employee.employee_Workid; return(View(data)); }
public ActionResult employeeMain() //人事資料主檔,明細檔-工種,明細檔-健檢記錄(編輯完成後使用的ActionResult) { string workNumber = Session["workNumber"].ToString(); int workId = Convert.ToInt32(Session["workId"]); var query = from o in db.Employee where o.employee_workNumber == workNumber select o; var query1 = from x in db.WorkInfo where x.work_id == workId select x; var query2 = from z in db.ReportManage where z.ReportManage_workNumber == workNumber select z; var query3 = from a in db.VW_EmpWorkInfo where a.employee_workNumber == workNumber select a; basicDataEmpolyeeMain data = new basicDataEmpolyeeMain(); data.employee = query.ToList(); data.workInfo = query1.ToList(); data.reportManage = query2.ToList(); data.vW_EmpWorkInfo = query3.ToList(); return(View(data)); }