Example #1
0
        /// <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);
        }
Example #2
0
        /// <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);
        }