public async Task <ApiResult> ListPage(ConstructionPlanImportParm parm)
{
ApiResult ret = new ApiResult();
try
{
ret.data = await _repo.ListPage(parm);
}
catch (Exception ex)
{
ret.code = Code.Failure;
ret.msg = ex.Message;
}
return(ret);
}
public async Task <object> ListPage(ConstructionPlanImportParm parm)
{
return(await WithConnection(async c =>
{
object ret = null;
IEnumerable <object> retTmp;
StringBuilder sql = new StringBuilder();
sql.Append("SELECT id FROM construction_plan_import_common ")
.Append(" where year=" + parm.SearchYear)
.Append(" and company='" + parm.SearchCompany + "'");
var ids = await c.QueryAsync <int>(sql.ToString());
if (ids.Count() <= 0)
{
return ret;
}
string tableName = parm.IsYear ? "construction_plan_year" : "construction_plan_month";
sql.Clear();
sql.Append("SELECT * FROM " + tableName)
.Append(" where query in @ids ")
//.Append(" order by a." + parm.sort + " " + parm.order)
.Append(" limit " + (parm.page - 1) * parm.rows + "," + parm.rows);
if (parm.IsYear)
{
retTmp = await c.QueryAsync <ConstructionPlanYear>(sql.ToString(), new { ids });
}
else
{
retTmp = await c.QueryAsync <ConstructionPlanMonth>(sql.ToString(), new { ids });
}
if (retTmp.Count() > 0)
{
sql.Clear();
sql.Append("select count(*) FROM " + tableName + " where query in @ids ");
int total = await c.QueryFirstOrDefaultAsync <int>(
sql.ToString(), new { ids });
ret = new { rows = retTmp.ToList(), total };
}
return ret;
}));
}
public ActionResult ListPage([FromQuery] ConstructionPlanImportParm parm)
{
var resp = _service.ListPage(parm);
return(Ok(resp.Result));
}
