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;
}));
}
