public IEnumerable <Model.WorkInfoNo> GetFindPage(Model.WorkFindPage 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,'%'))";
return(cn.Query <Model.WorkInfoNo>(sql, page));
}
}
public IEnumerable <Model.WorkInfoNo> GetMyPage(Model.WorkFindPage 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 ActionResult getFindPage([FromBody] Model.WorkFindPage page)
{
if (page.workName == null) page.workName = "";
var result = DAL.WorkInfo.Instance.GetFindPage(page);
if (result.Count() == 0)
return Json(Result.Err("返回记录数为0"));
else
return Json(Result.Ok(result));
}
public ActionResult getMyPage([FromBody] Model.WorkFindPage page)
{
if (getPage.userName == null)
{
page.userName = "";
}
var result = DAL.WorkInfo.Intance.GetMyPage(page);
if (result.Count() == 0)
{
return(Json(Result.Err("返回记录书为0")));
}
else
{
return(Json(Result.Ok("result")));
}
}
public ActionResult getfindPage([FromBody] Model.WorkFindPage page)
{
if (page.workName == null)
{
page.workName = "";
}
var result = DAL.WorkInfo.Instance.GetFindPage(page);
if (result.Count() == 0)
{
return(Json(Result.Err("返回记录数位0")));
}
else
{
return(Json(Result.Ok(result)));
}
}
