public void TestPaginateOrderFirstColumnWithSkip()
{
var paging = new Paging2 {
Take = 2
};
var list = this.DbContext.Users.Paginate(paging).ToList();
list.Should().HaveCount(2);
}
public void TestPaginateSkipOrder()
{
var paging = new Paging2 {
Take = 2
};
var list = this.DbContext.Users.OrderBy(p => p.Age).Paginate(paging).ToList();
list.Should().HaveCount(2);
}
private void BindData()
{
ePower.Core.PagingInfo paging = new ePower.Core.PagingInfo(PageSize, CurrentPage);
//if (m_UserValidation.OrgId > 0)
//{
int AuditYear = 0;
if (ddlYear.SelectedIndex > 0)
{
AuditYear = Convert.ToInt32(ddlYear.SelectedValue);
}
int AreaId = 0;
if (ddlArea.SelectedIndex > 0)
{
AreaId = Convert.ToInt32(ddlArea.SelectedValue);
}
int DistrictId = 0;
//if (ddlDistrict.SelectedIndex > 0)
// DistrictId = Convert.ToInt32(ddlDistrict.SelectedValue);
DataTable list = new AuditReportService().FindList(AreaId, 0, 0, 0, 0, DistrictId, Convert.ToInt32(AuditReportStatus.CONFIRMED), AuditYear, txtKeyword.Text.Trim(), paging);
rptAuditReport.DataSource = list;
rptAuditReport.DataBind();
if (list != null && list.Rows.Count > 0)
{
Paging.TotalRecord = Convert.ToInt32(list.Rows[0]["Total"]);
Paging.PageSize = PageSize;
Paging.DataLoad();
Paging2.TotalRecord = Convert.ToInt32(list.Rows[0]["Total"]);
Paging2.PageSize = PageSize;
Paging2.DataLoad();
if (Paging.TotalPages > 1)
{
ltTotal.Text = "Có " + list.Rows.Count + " trong tổng số " + list.Rows[0]["Total"] + " báo cáo";
Paging2.Visible = Paging.Visible = true;
}
else
{
ltTotal.Text = "Có tổng số " + list.Rows[0]["Total"] + " báo cáo";
Paging2.Visible = Paging.Visible = false;
}
}
else
{
Paging2.Visible = Paging.Visible = false;
}
//}
}
private void BindData()
{
IList <Fuel> listFuel = new List <Fuel>();
if (!AspNetCache.CheckCache(Constants.Cache_ReportFuel_Fuel_All))
{
listFuel = new FuelService().FindAll();
AspNetCache.SetCache(Constants.Cache_ReportFuel_Fuel_All, listFuel);
}
else
{
listFuel = (IList <Fuel>)AspNetCache.GetCache(Constants.Cache_ReportFuel_Fuel_All);
}
foreach (Fuel fuel in listFuel)
{
ltHeaderFuel.Text = ltHeaderFuel.Text + "<th>" + fuel.FuelName + "</th>";
}
ePower.Core.PagingInfo paging = new ePower.Core.PagingInfo(PageSize, CurrentPage);
//if (m_UserValidation.OrgId > 0)
//{
int AuditYear = 0;
if (ddlYear.SelectedIndex > 0)
{
AuditYear = Convert.ToInt32(ddlYear.SelectedValue);
}
int AreaId = 0;
if (ddlArea.SelectedIndex > 0)
{
AreaId = Convert.ToInt32(ddlArea.SelectedValue);
}
int DistrictId = 0;
//if (ddlDistrict.SelectedIndex > 0)
// DistrictId = Convert.ToInt32(ddlDistrict.SelectedValue);
DataTable list = new AuditReportService().FindList(AreaId, 0, 0, 0, 0, DistrictId, Convert.ToInt32(AuditReportStatus.CONFIRMED), AuditYear, txtKeyword.Text.Trim(), paging);
rptAuditReport.DataSource = list;
rptAuditReport.DataBind();
if (list != null && list.Rows.Count > 0)
{
Paging.TotalRecord = Convert.ToInt32(list.Rows[0]["Total"]);
Paging.PageSize = PageSize;
Paging.DataLoad();
Paging2.TotalRecord = Convert.ToInt32(list.Rows[0]["Total"]);
Paging2.PageSize = PageSize;
Paging2.DataLoad();
if (Paging.TotalPages > 1)
{
ltTotal.Text = "Có " + list.Rows.Count + " trong tổng số " + list.Rows[0]["Total"] + " báo cáo";
Paging2.Visible = Paging.Visible = true;
}
else
{
ltTotal.Text = "Có tổng số " + list.Rows[0]["Total"] + " báo cáo";
Paging2.Visible = Paging.Visible = false;
}
}
else
{
Paging2.Visible = Paging.Visible = false;
}
//}
}
