//查看詳細違規紀錄 public ActionResult InquireDetail(string memID = "M000000003") { var activityVio = (from a in db.Join_Fun_Activities join b in db.Violation on a.actId equals b.CorrespondingEventID where a.hostId == memID select b).ToList(); var RemarkVio = (from a in db.Member_Remarks join b in db.Violation on a.remarkSerial equals b.CorrespondingEventID where a.FromMemId == memID select b).ToList(); var BoardVio = (from a in db.Message_Board join b in db.Violation on a.mboardSerial equals b.CorrespondingEventID where a.memId == memID select b).ToList(); var MemberVio = db.Violation.Where(m => m.CorrespondingEventID == memID).ToList(); //將會員、留言板、評價、揪團違規查詢結果合併 var AllVio = activityVio.Union(RemarkVio).Union(BoardVio).Union(MemberVio); MemberInquireVM detail = new MemberInquireVM() { Violation = AllVio.OrderByDescending(m => m.vioId).Where(m => m.implement_admId != null), }; ViewBag.nick = db.Member.Where(m => m.memId == memID).Select(m => m.memNick).FirstOrDefault(); return(View(detail)); }
//編輯違規項目 public ActionResult InquireEdit(string vioId, string memId) { MemberInquireVM edit = new MemberInquireVM() { Member = db.Member.ToList(), Violation = db.Violation.Where(m => m.vioId == vioId), punishment = db.Punishment.ToList() }; ViewBag.vioId = db.Violation.Where(m => m.vioId == vioId).Select(m => m.vioId).FirstOrDefault(); ViewBag.oldpunid = db.Violation.Where(m => m.vioId == vioId).FirstOrDefault().punishId; ViewBag.sus = db.Member.Where(m => m.memId == memId).FirstOrDefault().Suspend; return(View(edit)); }