/// <summary>
        /// 获取候选人推荐的分页数据
        /// </summary>
        /// <param name="page"></param>
        /// <param name="pageSize"></param>
        /// <param name="candidateName"></param>
        /// <param name="allRowsCount"></param>
        /// <returns></returns>
        public List<dynamic> GetCandidateRecommendPage(int page, int pageSize, string candidateName, out long allRowsCount)
        {
            var sql = @"SELECT  c.Name,c.birthday,c.CVId FROM dbo.Candidate c ";
            var allRowsCountSql = @"SELECT COUNT(0) FROM dbo.Candidate";

            var ret = base.DBSession.Connection.GetPage<dynamic>(page, pageSize, out allRowsCount, sql, null, allRowsCountSql).ToList();
            return ret;
        }

        public JsonResult GetRecommends(int page, int pageSize, string candidatename)
        {
            var allRowsCount = 0L;

            var list = RpoJobRepository.NewInstance.GetCandidateRecommendPage(page, pageSize, candidatename, out allRowsCount);

            return base.NewtonsoftJson(new { total = allRowsCount, rows = list }, JsonRequestBehavior.AllowGet);
        }

   protected JsonResult NewtonsoftJson(object data, JsonRequestBehavior behavior)
        {
            return new NewtonsoftJsonResult
            {
                Data = data,
                JsonRequestBehavior = behavior,
            };
        }

 /// <summary>
    /// Newtonsoft序列化方式
    /// </summary>
    public class NewtonsoftJsonResult : JsonResult
    {
        /// <summary>
        /// 重写执行视图
        /// </summary>
        /// <param name="context">上下文</param>
        public override void ExecuteResult(ControllerContext context)
        {
            if (context == null)
            {
                throw new ArgumentNullException("context");
            }

            HttpResponseBase response = context.HttpContext.Response;

            if (string.IsNullOrEmpty(this.ContentType))
            {
                response.ContentType = this.ContentType;
            }
            else
            {
                response.ContentType = "application/json";
            }

            if (this.ContentEncoding != null)
            {
                response.ContentEncoding = this.ContentEncoding;
            }

            if (this.Data != null)
            {
                var jsonString = JsonConvert.SerializeObject(this.Data);
                response.Write(jsonString);
            }
        }

 columns: [{
                checkbox: true
            },
             {
                 field: 'Name',
                 title: '姓名',
                 formatter: this.nameFormatter

             }]