public void BindDataLichSuThanhToanPhatHanh()
{
string where = "Loai=2 and HOPDONG_SO=" + ViewState["ID"];
HPCBusinessLogic.DAL.LichsuthanhtoanDAL dal = new HPCBusinessLogic.DAL.LichsuthanhtoanDAL();
Pager1.PageSize = Global.MembersPerPage;
DataSet _ds;
_ds = dal.BindGridT_LichsuThanhtoan(Pager1.PageIndex, Pager1.PageSize, where);
int TotalRecords = Convert.ToInt32(_ds.Tables[1].Rows[0].ItemArray[0].ToString());
int TotalRecord = Convert.ToInt32(_ds.Tables[0].Rows.Count);
if (TotalRecord == 0)
{
_ds = dal.BindGridT_LichsuThanhtoan(Pager1.PageIndex - 1, Pager1.PageSize, where);
}
if (_ds.Tables[0].Rows.Count > 0)
{
_DataTableThanhtoan = _ds.Tables[0];
GVThanhtoanHD.DataSource = _ds;
GVThanhtoanHD.DataBind();
GVThanhtoanHD.ShowFooter = false;
}
else
{
_ds.Tables[0].Rows.Add(_ds.Tables[0].NewRow());
GVThanhtoanHD.DataSource = _ds;
GVThanhtoanHD.DataBind();
int columncount = GVThanhtoanHD.Rows[0].Cells.Count;
GVThanhtoanHD.Rows[0].Cells.Clear();
GVThanhtoanHD.Rows[0].Cells.Add(new TableCell());
GVThanhtoanHD.Rows[0].Cells[0].ColumnSpan = columncount;
GVThanhtoanHD.Rows[0].Cells[0].Text = "Không có bản ghi nào";
GVThanhtoanHD.ShowFooter = false;
_DataTableThanhtoan = null;
}
Pager1.TotalRecords = CurrentPage1.TotalRecords = TotalRecords;
CurrentPage1.TotalPages = Pager1.CalculateTotalPages();
CurrentPage1.PageIndex = Pager1.PageIndex;
}
public void Bind_AnphamMau_Layout()
{
string where = " Ma_Mau = " + EID.ToString();
AnPhamMau_LayoutDAL _DAL = new AnPhamMau_LayoutDAL();
DataSet _ds;
Pager1.PageSize = 10;
_ds = _DAL.BindGridT_AnPhamLayout(Pager1.PageIndex, Pager1.PageSize, where);
int TotalRecords = Convert.ToInt32(_ds.Tables[1].Rows[0].ItemArray[0].ToString());
int TotalRecord = Convert.ToInt32(_ds.Tables[0].Rows.Count);
if (TotalRecord == 0)
{
_ds = _DAL.BindGridT_AnPhamLayout(pages.PageIndex - 1, pages.PageSize, where);
}
if (_ds.Tables[0].Rows.Count > 0)
{
GVAnPhamLayout.DataSource = _ds;
GVAnPhamLayout.DataBind();
GVAnPhamLayout.ShowFooter = false;
}
else
{
_ds.Tables[0].Rows.Add(_ds.Tables[0].NewRow());
GVAnPhamLayout.DataSource = _ds;
GVAnPhamLayout.DataBind();
int columncount = GVAnphamMau.Rows[0].Cells.Count;
GVAnPhamLayout.Rows[0].Cells.Clear();
GVAnPhamLayout.Rows[0].Cells.Add(new TableCell());
GVAnPhamLayout.Rows[0].Cells[0].ColumnSpan = columncount;
GVAnPhamLayout.Rows[0].Cells[0].Text = "Không có bản ghi nào";
GVAnPhamLayout.ShowFooter = false;
}
Pager1.TotalRecords = CurrentPage1.TotalRecords = TotalRecords;
CurrentPage1.TotalPages = Pager1.CalculateTotalPages();
CurrentPage1.PageIndex = Pager1.PageIndex;
}
