/// <summary> /// 取得員工資料 /// </summary> public JsonResult GetContactTitleList() { try { Service.CodeService codeService = new Service.CodeService(); JsonResult result = this.Json(codeService.GetTitle(), JsonRequestBehavior.AllowGet); return(result); } catch (Exception) { return(this.Json(false)); } }
/// <summary> /// 取得職稱資料 /// </summary> /// <returns></returns> public List <SelectListItem> GetVal() { DataTable dt = new DataTable(); string sql = @"select CodeVal,CodeId from dbo.CodeTable where CodeType='TITLE'"; using (SqlConnection conn = new SqlConnection(this.GetDBConnectionString())) { conn.Open(); SqlCommand cmd = new SqlCommand(sql, conn); SqlDataAdapter sqlAdapter = new SqlDataAdapter(cmd); sqlAdapter.Fill(dt); conn.Close(); } Service.CodeService codeservice = new Service.CodeService(); return(codeservice.MapCustomerData(dt)); }