//人事---------------------------------------------------------------------------------------
public ActionResult employeeMaster() //人事資料主頁
{
var query = from o in db.WorkInfo
select o;
var query1 = from x in db.Factory
select x;
var query2 = from o in db.VW_EmpWorkInfo
where o.employee_workNumber == null
select o;
basicDataEmployeeMaster data = new basicDataEmployeeMaster();
data.workInfo = query.ToList();
data.factory = query1.ToList();
data.vW_EmpWorkInfo = query2.ToList();
return(View(data));
}
public ActionResult employeeMaster(Factory factory, Employee employee, WorkInfo workInfo) //人事資料主頁
{
//若沒有輸入post回去會是null值,把它改成""去做模糊查詢
if (string.IsNullOrEmpty(employee.employee_name))
{
employee.employee_name = "";
}
if (string.IsNullOrEmpty(employee.employee_workNumber))
{
employee.employee_workNumber = "";
}
if (string.IsNullOrEmpty(employee.employee_identityCard))
{
employee.employee_identityCard = "";
}
if (string.IsNullOrEmpty(employee.employee_isDisabled))
{
employee.employee_isDisabled = "";
}
if (string.IsNullOrEmpty(workInfo.work_name))
{
workInfo.work_name = "";
}
//先將工廠名稱轉換成工廠ID
var query = from f in db.Factory
where f.factory_name == factory.factory_name
select f.factory_id;
string factoryID = query.First();
//工種名稱轉換成工種ID
var query1 = from w in db.WorkInfo
where w.work_name.Contains(workInfo.work_name)
select w.work_id;
int workID = 0; //當workID等於0就是查詢全部
string workname = "";
if (query1.Count() == 1)
{
workID = query1.First();
}
if (workID == 3)
{
workname = "一般人員";
}
if (workID == 4)
{
workname = "高階主管";
}
//轉換完畢
var query2 = from e in db.VW_EmpWorkInfo
where (e.employee_Workid == workID &&
e.employee_name.Contains(employee.employee_name) &&
e.employee_workNumber.Contains(employee.employee_workNumber) &&
e.employee_factoryId == factoryID &&
e.employee_identityCard.Contains(employee.employee_identityCard) &&
e.employee_isDisabled.Contains(employee.employee_isDisabled))
||
(e.work_name == workname &&
e.employee_name.Contains(employee.employee_name) &&
e.employee_workNumber.Contains(employee.employee_workNumber) &&
e.employee_factoryId == factoryID &&
e.employee_identityCard.Contains(employee.employee_identityCard) &&
e.employee_isDisabled.Contains(employee.employee_isDisabled))
||
(workID == 0 &&
e.employee_name.Contains(employee.employee_name) &&
e.employee_workNumber.Contains(employee.employee_workNumber) &&
e.employee_factoryId == factoryID &&
e.employee_identityCard.Contains(employee.employee_identityCard) &&
e.employee_isDisabled.Contains(employee.employee_isDisabled))
select e;
//var query2 = from e in db.Employee
// where (e.employee_workId == workID &&
// e.employee_name.Contains(employee.employee_name) &&
// e.employee_workNumber.Contains(employee.employee_workNumber) &&
// e.employee_factoryId == factoryID &&
// e.employee_identityCard.Contains(employee.employee_identityCard) &&
// e.employee_isDisabled.Contains(employee.employee_isDisabled))
// ||
// (workID == 0 &&
// e.employee_name.Contains(employee.employee_name) &&
// e.employee_workNumber.Contains(employee.employee_workNumber) &&
// e.employee_factoryId == factoryID &&
// e.employee_identityCard.Contains(employee.employee_identityCard) &&
// e.employee_isDisabled.Contains(employee.employee_isDisabled))
// select e;
var query3 = from o in db.WorkInfo
select o;
var query4 = from x in db.Factory
select x;
basicDataEmployeeMaster data = new basicDataEmployeeMaster();
data.vW_EmpWorkInfo = query2.ToList();
data.workInfo = query3.ToList();
data.factory = query4.ToList();
return(View(data));
}
