/// <summary> /// 輸入單位代碼,查詢相關資訊 /// </summary> /// <param name="DPT_CD"></param> /// <returns></returns> public VW_OA_DEPT qryByDptCd(String DPT_CD) { DB_INTRAEntities context = new DB_INTRAEntities(); VW_OA_DEPT oaDept = context.VW_OA_DEPT .Where(x => x.DPT_CD == DPT_CD).FirstOrDefault(); return(oaDept); }
/// <summary> /// 回傳 部門 資料 /// </summary> /// <param name="DPT_CD"></param> /// <returns></returns> public VW_OA_DEPT getDept(string DPT_CD) { var result = new VW_OA_DEPT(); using (DB_INTRAEntities db = new DB_INTRAEntities()) { result = db.VW_OA_DEPT.FirstOrDefault(x => x.DPT_CD == DPT_CD); } return(result); }