public IEnumerable <Model.WorkInfoNo> WorkInfoNo(Model.WorkMyPage page)
{
using (IDbConnection cn = new MySqlConnection(cns))
{
string sql = "with a as(select row_number() over(order by uploadTime desc) as num, workinfo.*,activityName from workinfo join activity on workinfo.activityId=activity.activityId where workinfo.userName=@userName)";
sql += "select* from a where num between (@pageIndex-1)*pageSize+1 and @pageIndex*@pageSize;";
return(cn.Query <Model.WorkInfoNo>(sql, page));
}
}
public IEnumerable <Model.WorkInfoNo> GetFindPage(Model.WorkMyPage page)
{
using (IDbConnection cn = new MySqlConnection(cns))
{
string sql = "with a as(select row_number() over(order by uploadTime desc) as num, workinfo.*,activityName from workinfo join activity on workinfo.activityId=activity.activityId where workverify='审核通过' and workName like concat('%',@workName,'%'))";
sql += "select * from a where num between (@pageIndex-1)*@pageSize+1 and @pageIndex*@pageSize;";
return(cn.Query <Model.WorkInfoNo>(sql, page));
}
}
public ActionResult getMyPage([FromBody] Model.WorkMyPage page)
{
if (page.userName == null) page.userName = "";
var result = DAL.WorkInfo.Instance.GetMyPage(page);
if (result.Count() == 0)
return Json(Result.Err("返回记录数为0"));
else
return Json(Result.Ok(result));
}
