Hero is coming back

风吹呀吹

风会指引你前进的方向

X6 权限过滤

 ActionResultModel<List<X6_V_Personnel_BasicInfo>> model = new ActionResultModel<List<X6_V_Personnel_BasicInfo>>();
       _.apiService.DynamicApi<List<X6_V_Personnel_BasicInfo>>((db,pars)=>{
         var data = db.Queryable<X6_V_Personnel_BasicInfo>()
             .Where(_.apiService.GetFilterQueryWhere())
             .OrderBy(_.apiService.GetOrder());
                if (this.Request.HttpMethod == "POST")
                {
                    data.Where(PostMethodFilterGetTool.GetFilterQueryWhere(pars));
                }
                if (pars.ContainsKey("EmployeeStatus") && pars["EmployeeStatus"].IsValuable())
                {
                    data = data.Where(string.Format("EmployeeStatus in ({0})", pars["EmployeeStatus"]));
                }
                if (pars.ContainsKey("CompanyId") && pars["CompanyId"].IsValuable())
                {
                    //data = data.Where(string.Format(" CompanyId = '{0}'", pars["CompanyId"]));
                    var CompanyId = pars["CompanyId"].TrimEnd(',');
                    data = data.Where(@"DepartmentId in (" + CompanyId + ")");
                }
           
           model.responseInfo = data.ToPageList(pars["pagenum"].TryToInt() + 1, pars["pagesize"].TryToInt());
           model.totalRows = data.Count();
       }, "FilterOrgContainCompanyReturnTreeIds");

 

posted @ 2017-12-13 10:08  风吹呀吹  阅读(349)  评论(0编辑  收藏  举报