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