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