public PageStu Show(Stockin person, int CurrentPage = 1, int PageSize = 10)
{
using (IDbConnection connection = new SqlConnection(conn.ConnectionString))
{
var sql = @"select * from Stockin where StockInStatus=" + person.StockInStatus;
if (person.StockInType != "")
{
sql += " and StockInType=@stockInType";
}
if (person.CreateDate != "" && person.ModifiedDate != "")
{
sql += "and CreateDate>=@createDate and ModifiedDate<=@modifiedDate";
}
var list = connection.Query <Stockin>(sql, new { stockInType = person.StockInType, createDate = person.CreateDate, modifiedDate = person.ModifiedDate }).ToList();
PageStu ps = new PageStu(); //实例化
ps.TotalCount = list.Count(); //总记录数
if (ps.TotalCount % PageSize == 0) //计算总页数
{
ps.TotalPage = ps.TotalCount / PageSize;
}
else
{
ps.TotalPage = (ps.TotalCount / PageSize) + 1;
}
//纠正index页
if (CurrentPage < 1)
{
CurrentPage = 1;
}
if (CurrentPage > ps.TotalPage)
{
CurrentPage = ps.TotalPage;
}
//赋值index为当前页
ps.CurrentPage = CurrentPage;
//linq查询
ps.stockins = list.Skip(PageSize * (CurrentPage - 1)).Take(PageSize).ToList();
return(ps);
}
}
// GET: api/Pingjia
public PageStu Get(int CurrentPage = 1, int PageSize = 2)
{
var list = dal.Show();
//if (timeone != null && timetwo != null)
//{
// list = list.Where(s => s.Atime >= timeone && s.Atime <= timetwo).ToList();
//}
//if (!string.IsNullOrEmpty(names))
//{
// list = list.Where(s => s.Apname.Contains(names)).ToList();
//}
//if (xiala != 0 && xiala != null)
//{
// list = list.Where(s => s.Amessage == xiala).ToList();
//}
PageStu ps = new PageStu(); //实例化
ps.TotalCount = list.Count(); //总记录数
if (ps.TotalCount % PageSize == 0) //计算总页数
{
ps.TotalPage = ps.TotalCount / PageSize;
}
else
{
ps.TotalPage = (ps.TotalCount / PageSize) + 1;
}
//纠正index页
if (CurrentPage < 1)
{
CurrentPage = 1;
}
if (CurrentPage > ps.TotalPage)
{
CurrentPage = ps.TotalPage;
}
//赋值index为当前页
ps.CurrentPage = CurrentPage;
//linq查询
ps.Amodels = list.Skip(PageSize * (CurrentPage - 1)).Take(PageSize).ToList();
return(ps);
}
