public void pj專案規劃(pjTeam formdata)
{
var x = db.pjTeam.FirstOrDefault(m => m.pjTeamId == formdata.pjTeamId);
//db.Entry<pjTeam>(x).State = EntityState.Modified;
x.pjMember部門 = formdata.pjMember部門;
x.pjTask = formdata.pjTask;
x.pjTaskStartDate = formdata.pjTaskStartDate;
x.pjTaskEndDate = formdata.pjTaskEndDate;
x.pjFixedDuration = formdata.pjFixedDuration;
db.SaveChanges();
}
public JsonResult pj成員搜尋專案列表(string searchVal, pjTeam data)
{
var pjTeamData = from m in db.pjTeam
where m.pjMemberName == data.pjMemberName && m.pjProject.pj初審結果 == "通過" && m.pjProject.pj複審結果 == "通過" && m.pjProject.pjName.Contains(searchVal) ||
m.pjMemberName == data.pjMemberName && m.pjProject.pj初審結果 == "通過" && m.pjProject.pj複審結果 == "通過" && m.pjProject.pjManager.Contains(searchVal) ||
m.pjMemberName == data.pjMemberName && m.pjProject.pj初審結果 == "通過" && m.pjProject.pj複審結果 == "通過" && m.pjProject.pjIntroduction.Contains(searchVal) ||
m.pjMemberName == data.pjMemberName && m.pjProject.pj初審結果 == "通過" && m.pjProject.pj複審結果 == "通過" && m.pjProject.pjManager.Contains(searchVal)
|| m.pjProject.pjManager == data.pjMemberName && m.pjProject.pj初審結果 == "通過" && m.pjProject.pj複審結果 == "通過" && m.pjProject.pjName.Contains(searchVal) ||
m.pjProject.pjManager == data.pjMemberName && m.pjProject.pj初審結果 == "通過" && m.pjProject.pj複審結果 == "通過" && m.pjProject.pjManager.Contains(searchVal) ||
m.pjProject.pjManager == data.pjMemberName && m.pjProject.pj初審結果 == "通過" && m.pjProject.pj複審結果 == "通過" && m.pjProject.pjIntroduction.Contains(searchVal) ||
m.pjProject.pjManager == data.pjMemberName && m.pjProject.pj初審結果 == "通過" && m.pjProject.pj複審結果 == "通過" && m.pjProject.pjManager.Contains(searchVal)
select new
{
pjId = m.pjProject.pjId,
pjName = m.pjProject.pjName,
pjManager = m.pjProject.pjManager,
pjIntroduction = m.pjProject.pjIntroduction,
};
return(Json(pjTeamData, JsonRequestBehavior.AllowGet));
}
public void savePreview2FormData(pjTeam formdata)
{
db.pjTeam.Add(formdata);
db.SaveChanges();
}
