/// <summary> /// 获取列表 /// </summary> /// <param name="pagination">分页参数</param> /// <param name="queryJson">查询参数</param> /// <returns>返回分页列表Json</returns> //[HandlerMonitor(3, "分页查询用户信息!")] public ActionResult GetPageListJson(Pagination pagination, string queryJson) { queryJson = queryJson ?? ""; pagination.p_kid = "ID"; pagination.p_fields = "IsSubmit,CREATEUSERID,WSSJNAME, WSSJTYPENAME,HAPPENTIME,AREANAME,WSSJBGUSERNAME,CREATEUSERDEPTCODE as departmentcode,CREATEUSERORGCODE as organizecode"; pagination.p_tablename = "V_AEM_WSSJBG_Order t"; pagination.conditionJson = "1=1"; Operator user = ERCHTMS.Code.OperatorProvider.Provider.Current(); if (user.IsSystem) { pagination.conditionJson = "1=1"; } else { string where = new AuthorizeBLL().GetModuleDataAuthority(ERCHTMS.Code.OperatorProvider.Provider.Current(), HttpContext.Request.Cookies["currentmoduleId"].Value, "CREATEUSERDEPTCODE", "CREATEUSERORGCODE"); if (!string.IsNullOrEmpty(where)) { pagination.conditionJson += " and " + where; } } var watch = CommonHelper.TimerStart(); var data = wssjbgbll.GetPageList(pagination, queryJson); var JsonData = new { rows = data, total = pagination.total, page = pagination.page, records = pagination.records, costtime = CommonHelper.TimerEnd(watch) }; return(Content(JsonData.ToJson())); }
public object GetWssjBgList([FromBody] JObject json) { string res = json.Value <string>("json"); dynamic dy = JsonConvert.DeserializeObject <ExpandoObject>(res); string userid = dy.userid; string wssjName = dy.WssjName ?? ""; //事故名称 string wssjType = dy.WssjType ?? ""; //事故类型 string happenTimeStart = dy.HappenTimeStart ?? ""; //发生时间 string happenTimeEnd = dy.HappenTimeEnd ?? ""; //发生时间 string wssjbgUserId = dy.WssjbgUserId ?? ""; //报告人 //获取用户基本信息 OperatorProvider.AppUserId = userid; //设置当前用户 Operator curUser = OperatorProvider.Provider.Current(); if (null == curUser) { return(new { code = -1, count = 0, info = "请求失败,请登录!" }); } //分页获取数据 Pagination pagination = new Pagination(); pagination.page = int.Parse(dy.page ?? "1"); pagination.rows = int.Parse(dy.rows ?? "1"); pagination.p_kid = "ID"; pagination.p_fields = "WssjName,HappenTime,AreaName,AreaId,WSSJTPSP"; pagination.p_tablename = "V_AEM_WSSJBG t"; pagination.sidx = "HappenTime"; pagination.sord = "desc"; pagination.conditionJson = "CREATEUSERORGCODE='" + curUser.OrganizeCode + "'"; //查询条件 if (happenTimeStart.Length > 0) { pagination.conditionJson += string.Format(" and happentime >= (select to_date('{0}', 'yyyy-MM-dd HH24:mi:ss') from dual)", happenTimeStart); } if (happenTimeEnd.Length > 0) { pagination.conditionJson += string.Format(" and happentime <= (select to_date('{0}', 'yyyy-MM-dd HH24:mi:ss') from dual)", happenTimeEnd); } if (wssjType.Length > 0) { pagination.conditionJson += string.Format(" and WSSJTYPE = '{0}'", wssjType); } if (wssjName.Length > 0) { pagination.conditionJson += string.Format(" and WSSJNAME like '%{0}%'", wssjName); } if (wssjbgUserId.Length > 0) { pagination.conditionJson += string.Format(" and WSSJBGUSERID = '{0}'", wssjbgUserId); } //获取数据 var data = wssjbgbll.GetPageList(pagination, ""); var JsonData = new { rows = data, total = pagination.total, page = pagination.page, records = pagination.records, }; return(new { code = 0, info = "获取数据成功", data = JsonData }); }