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; }