public bool SetTarget()
{
for (int i = 0; i < CurrentEvent.Count; i++)
{
//二次检测能否移动以防万一
if (CurrentEvent[i].EventActive == true)
{
return(false);
}
//再次检测是否需要移动
else if (CurrentEvent[i].HaveTarget == false)
{
CurrentEvent[i].EventActive = true;
canMove = false;
return(false);
}
else
{
TargetEmp = CurrentEvent[i].Target;
Destination = TargetEmp.transform.position;
canMove = true;
return(false);
}
}
FindWorkPos();
return(true);
}
void GetAll()
{
using (SqlConnection conn = new SqlConnection(strConn))//使用using的方式系统自动关闭连接
{
conn.Open();
string sql = string.Format("select e.empId,e.password,e.name,e.phone,e.isMgr,d.deptName " +
"from department d, employee e " +
"where d.deptId = e.deptId");
SqlCommand cmd = new SqlCommand(sql, conn);
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
EmpEntity empEntity = new EmpEntity();
for (int i = 0; i < dr.FieldCount; i++)
{
empEntity.EmpId = int.Parse(dr[0].ToString());
empEntity.Password = dr[1].ToString();
empEntity.Name = dr[2].ToString();
empEntity.Phone = dr[3].ToString();
empEntity.IsMgr = dr[4].ToString() == "True" ? "是" : "否";
empEntity.Dept = dr[5].ToString();
}
emplist.Add(empEntity);
}
}
}
/// <summary>
/// 新增
/// </summary>
/// <returns></returns>
public ActionResult Creat()
{
EmpEntity emp = new EmpEntity();
EmpViewModel empcreat = new EmpViewModel();
empcreat.EmpNumber = emp.EmpPersonal.Select(x => x.EmpNumber).Max(); //找出編號最大，並加1
empcreat.EmpNumber++;
return(View(empcreat));
}
public JsonResult Creat(EmpPersonal Pdatacreat, EmpUnit Udatacreat)
{
using (EmpEntity db = new EmpEntity())
{
db.EmpPersonal.Add(Pdatacreat);
db.EmpUnit.Add(Udatacreat);
db.SaveChanges();
}
return(Json(JsonRequestBehavior.AllowGet));
}
public bool FindTarget()
{
if (Self.InfoDetail.GC.CurrentEmployees.Count > 1)
{
while (Target == null || Target == Self)
{
int r = Random.Range(0, Self.InfoDetail.GC.CurrentEmployees.Count);
Target = Self.InfoDetail.GC.CurrentEmployees[r].InfoDetail.Entity;
}
return(true);
}
return(false);
}
private void OnTriggerEnter2D(Collider2D collision)
{
if (collision.gameObject.tag == "EmpEntity")
{
EmpEntity Et = collision.gameObject.GetComponent <EmpEntity>();
float posb = Random.Range(0.0f, 1.0f);
if (posb < 0.3f)
{
ShowMarker(0);
Employee Es = InfoDetail.emp;
Es.ChangeRelation(Et.InfoDetail.emp, 1);
Et.InfoDetail.emp.ChangeRelation(Es, 1);
}
}
}
private void OnTriggerStay2D(Collider2D collision)
{
//接触目标
if (TargetEmp != null && WorkShift == false)
{
EmpEntity Et = collision.gameObject.GetComponent <EmpEntity>();
if (TargetEmp == Et)
{
for (int i = 0; i < CurrentEvent.Count; i++)
{
if (CurrentEvent[i].Target == TargetEmp)
{
CurrentEvent[i].EventActive = true;
canMove = false;
TargetEmp.canMove = false;
}
}
}
}
}
public JsonResult Edit(EmpViewModel datasava)
{
using (EmpEntity db = new EmpEntity())
{
EmpPersonal P = db.EmpPersonal.Where(x => x.EmpNumber == datasava.EmpNumber).FirstOrDefault();
P.EmpName = datasava.EmpName;
P.EmpSex = datasava.EmpSex;
P.EmpBirthday = datasava.EmpBirthday;
P.CreationDate = datasava.CreationDate;
P.LastloginDate = datasava.LastloginDate;
P.Seniority = datasava.Seniority;
EmpUnit U = db.EmpUnit.Where(x => x.EmpNumber == datasava.EmpNumber).FirstOrDefault();
U.UnitName = datasava.UnitName;
U.UnitNumber = datasava.UnitNumber;
U.JobTitle = datasava.JobTitle;
db.SaveChanges();
}
return(Json(JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 修改
/// </summary>
/// <returns></returns>
public ActionResult Edit(int empnumber)
{
EmpEntity objEmpList = new EmpEntity();
var emplist = (from P in objEmpList.EmpPersonal
join U in objEmpList.EmpUnit on P.EmpNumber equals U.EmpNumber
where P.EmpNumber == empnumber
select new EmpViewModel
{
EmpNumber = P.EmpNumber,
EmpName = P.EmpName,
EmpSex = P.EmpSex,
EmpBirthday = P.EmpBirthday,
CreationDate = P.CreationDate,
LastloginDate = P.LastloginDate,
Seniority = P.Seniority,
UnitNumber = U.UnitNumber,
UnitName = U.UnitName,
JobTitle = U.JobTitle
}).FirstOrDefault();
return(View(emplist));
}
public void FindWorkPos()
{
//从当前部门转为待命或者从待命移动到某部门时都要调用
//此处检测主要为了防止在下班时安排工作导致移动
if (canChangePos == true)
{
if (InfoDetail.emp.CurrentDep != null)
{
Destination = InfoDetail.emp.CurrentDep.building.WorkPos[InfoDetail.emp.CurrentDep.CurrentEmps.IndexOf(InfoDetail.emp)].position;
}
else if (InfoDetail.emp.CurrentOffice != null)
{
Destination = InfoDetail.emp.CurrentOffice.building.WorkPos[0].position;
}
else
{
float x = Random.Range(BM.MinPos.position.x, BM.MaxPos.position.x);
float y = Random.Range(BM.MinPos.position.y, BM.MaxPos.position.y);
Destination = new Vector2(x, y);
}
}
canMove = true;
TargetEmp = null;
}
public bool updateEmp(EmpEntity.Employee e)
{
ed = new EmpDalLayer();
ed.updateEmp(e);
return true;
//throw new NotImplementedException();
}
public bool insertNewEmployee(EmpEntity.Employee e)
{
ed = new EmpDalLayer();
ed.insertNewEmployee(e);
return true;
}
/// <summary>
/// partail view
/// </summary>
/// <returns></returns>
public PartialViewResult ShowData(string empnumber = "")
{
EmpEntity objEmpList = new EmpEntity();
FormViewModel formvm = new FormViewModel();
//表單檢核
if (!string.IsNullOrWhiteSpace(empnumber))
{
//撈輸入empnumber的那筆資料
int empid = int.Parse(empnumber);
formvm.empdata = (from P in objEmpList.EmpPersonal
join U in objEmpList.EmpUnit on P.EmpNumber equals U.EmpNumber
where P.EmpNumber == empid
select new EmpViewModel
{
EmpNumber = P.EmpNumber,
EmpName = P.EmpName,
EmpSex = P.EmpSex,
EmpBirthday = P.EmpBirthday,
CreationDate = P.CreationDate,
LastloginDate = P.LastloginDate,
Seniority = P.Seniority,
UnitNumber = U.UnitNumber,
UnitName = U.UnitName,
JobTitle = U.JobTitle
}).ToList();
if (formvm.empdata.Count == 0)
{
formvm.IsSuccess = false;
formvm.Msg = "No Data.";
}
else
{
formvm.IsSuccess = true;
formvm.Msg = "搜尋成功";
}
}
else
{
formvm.IsSuccess = true; //第一次，未有動作，顯示未搜尋
formvm.Msg = "未搜尋";
formvm.empdata = (from P in objEmpList.EmpPersonal
join U in objEmpList.EmpUnit on P.EmpNumber equals U.EmpNumber
select new EmpViewModel
{
EmpNumber = P.EmpNumber,
EmpName = P.EmpName,
EmpSex = P.EmpSex,
EmpBirthday = P.EmpBirthday,
CreationDate = P.CreationDate,
LastloginDate = P.LastloginDate,
Seniority = P.Seniority,
UnitNumber = U.UnitNumber,
UnitName = U.UnitName,
JobTitle = U.JobTitle
}).ToList();
}
return(PartialView(formvm));
}
public bool updateEmp(EmpEntity.Employee e)
{
eDataContext = new EmpDalDataContext();
eDataContext.UpdateEmp(e.EmpId,e.FirstName, e.MiddleName, e.LastName, e.Addreee, e.City, e.ZipCode, e.State, e.PhoneNumber, e.EmailId, e.Department, e.Picture, e.Salary, e.Leaves, e.Position);
eDataContext.SubmitChanges();
return true;
//throw new NotImplementedException();
}
