public async Task <ActionResult <ApiResult> > GetPageList([FromQuery] ConstructionPlanParm parm) { ApiResult ret = new ApiResult { code = Code.Failure }; try { ret = await _service.GetPageList(parm); } catch (System.Exception ex) { ret.msg = string.Format( "获取分页数据ConstructionPlan失败, 异常信息:{0}", ex.Message); } return(ret); }
public async Task <ApiResult> GetPageList(ConstructionPlanParm parm) { ApiResult ret = new ApiResult(); try { parm.userId = _userID; //parm.UserID = 40; parm.processGUID = "c4c03c5e-63a3-47d6-913f-b8e08a51f5f8"; var data = await _repo.GetPageList(parm); ret.code = Code.Success; ret.data = data; } catch (Exception ex) { ret.code = Code.Failure; ret.msg = ex.Message; } return(ret); }
public async Task <ConstructionPlanPageView> GetPageList(ConstructionPlanParm parm) { return(await WithConnection(async c => { StringBuilder sql = new StringBuilder(); sql.Append($@" SELECT a.id, a.line_id, a.area_id, a.area_typename, a.plan_name, a.plan_type, a.plan_number, a.important_level, a.plan_level, a.apply_company_org_id, a.construction_company_org_id, a.start_time, a.end_time, a.register_station_id, a.device_num, a.trouble_num, a.operation_address, a.construction_content, a.construction_detail, a.coordination_request, a.coordination_audit, a.stop_electric, a.traction_power, a.traction_train_num, a.traction_start_time, a.traction_time, a.use_laddercar, a.electric_range, a.traction_car_route, a.effect_area, a.effect_explain, a.safe_measure, a.force_unlock_key, a.other_request, a.memo, a.created_time, a.created_by, a.updated_time, a.updated_by,a.is_del,b.processstate,a.con_plan_type FROM construction_plan a LEFT JOIN wfprocessinstance b ON a.id = b.AppInstanceID AND b.ProcessGUID = '" + parm.processGUID + "'"); StringBuilder whereSql = new StringBuilder(); whereSql.Append(" WHERE a.is_del = 0 "); if (parm.planName != null) { whereSql.Append(" and a.plan_name like '%" + parm.planName.Trim() + "%'"); } if (parm.userId != 0) { whereSql.Append(" and a.created_by = '" + parm.userId + "' "); } if (parm.conplantype != 0) { whereSql.Append(" and a.con_plan_type = '" + parm.conplantype + "' "); } sql.Append(whereSql); //验证是否有参与到流程中 //string sqlcheck = sql.ToString(); //sqlcheck += ("AND ai.CreatedByUserID = '" + parm.UserID + "'"); //var checkdata = await c.QueryFirstOrDefaultAsync<TaskViewModel>(sqlcheck); //if (checkdata == null) //{ // return null; //} var data = await c.QueryAsync <ConstructionPlan>(sql.ToString()); var total = data.ToList().Count; sql.Append(" order by " + parm.sort + " " + parm.order) .Append(" limit " + (parm.page - 1) * parm.rows + "," + parm.rows); var ets = await c.QueryAsync <ConstructionPlan>(sql.ToString()); ConstructionPlanPageView ret = new ConstructionPlanPageView(); ret.rows = ets.ToList(); ret.total = total; return ret; })); }