public void BindList_Doituong() { string where = " 1=1 "; DoituongDAL _DAL = new DoituongDAL(); DataSet _ds; pages.PageSize = 10;//Global.MembersPerPage; _ds = _DAL.BindGridT_Doituong(pages.PageIndex, pages.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_Doituong(pages.PageIndex - 1, pages.PageSize, where); } if (_ds.Tables[0].Rows.Count > 0) { DataView _dv = _ds.Tables[0].DefaultView; if (SortExtension.Length > 1) { _dv.Sort = SortExtension + " " + SortOrder; } GVDoituong.DataSource = _dv; GVDoituong.DataBind(); GVDoituong.ShowFooter = false; } else { _ds.Tables[0].Rows.Add(_ds.Tables[0].NewRow()); GVDoituong.DataSource = _ds; GVDoituong.DataBind(); int columncount = GVDoituong.Rows[0].Cells.Count; GVDoituong.Rows[0].Cells.Clear(); GVDoituong.Rows[0].Cells.Add(new TableCell()); GVDoituong.Rows[0].Cells[0].ColumnSpan = columncount; GVDoituong.Rows[0].Cells[0].Text = "Không có bản ghi nào"; GVDoituong.ShowFooter = false; } pages.TotalRecords = curentPages.TotalRecords = TotalRecords; curentPages.TotalPages = pages.CalculateTotalPages(); curentPages.PageIndex = pages.PageIndex; Session["CurrentPage"] = pages.PageIndex; }
public void BindList_Doituong() { string where = " T_Doituong.Ma_Doituong not in (select T_Doituong_Anpham.Ma_Doituong from T_Doituong_Anpham where T_Doituong_Anpham.Ma_AnPham = " + maanpham + ") "; DoituongDAL _DAL = new DoituongDAL(); DataSet _ds; pages.PageSize = Global.MembersPerPage; _ds = _DAL.BindGridT_Doituong(pages.PageIndex, pages.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_Doituong(pages.PageIndex - 1, pages.PageSize, where); } if (_ds.Tables[0].Rows.Count > 0) { DataView _dv = _ds.Tables[0].DefaultView; GVDoituong.DataSource = _dv; GVDoituong.DataBind(); GVDoituong.ShowFooter = false; } else { _ds.Tables[0].Rows.Add(_ds.Tables[0].NewRow()); GVDoituong.DataSource = _ds; GVDoituong.DataBind(); int columncount = GVDoituong.Rows[0].Cells.Count; GVDoituong.Rows[0].Cells.Clear(); GVDoituong.Rows[0].Cells.Add(new TableCell()); GVDoituong.Rows[0].Cells[0].ColumnSpan = columncount; GVDoituong.Rows[0].Cells[0].Text = "Không có bản ghi nào"; GVDoituong.ShowFooter = false; } pages.TotalRecords = curentPages.TotalRecords = TotalRecords; curentPages.TotalPages = pages.CalculateTotalPages(); curentPages.PageIndex = pages.PageIndex; Session["CurrentPage"] = pages.PageIndex; }