public ActionResult code_position(code_position doc, int?idx, int?company_idx) { ViewBag.타이틀 = "직책 코드"; //======================================================================================================================================================== var Code_company = db.company.Where(p => p.use_yn == "Y").OrderBy(o => o.index_order).Select( c => new { 값 = c.idx, 이름 = c.company_name }); ViewBag.회사 = new SelectList(Code_company.AsEnumerable(), "값", "이름"); //======================================================================================================================================================== if (idx != null) { doc = db.code_position.Single(x => x.code_id == idx); } var _list = db.code_position.Include(p => p.company_idxNavigation).Where(p => p.use_yn != "N").OrderBy(o => o.index_order); if (company_idx != null) { _list = _list.Where(p => p.company_idx == company_idx).OrderBy(o => o.index_order); } ViewBag.리스트 = _list; return(View(doc)); }
/// <summary> /// 코드 표준 : 직책 /// </summary> /// <param name="doc"></param> /// <param name="mode_type"></param> /// <param name="idx"></param> /// <returns></returns> public ActionResult code_position_action(code_position doc, string mode_type, int?idx, string re_url) { if (idx == null) { #region 저장 doc.use_yn = "Y"; db.code_position.Add(doc); db.SaveChanges(); // 실제로 저장 #endregion } else { if (mode_type == "D") { #region 사용안함 int _idx_ = Convert.ToInt32(idx); var _data = (from a in db.code_position where a.code_id == idx select a).Single(); _data.use_yn = "N"; db.SaveChanges(); #endregion } else { #region 수정 doc.use_yn = "Y"; db.Entry(doc).State = EntityState.Modified; db.SaveChanges(); #endregion } } return(Redirect(re_url)); }