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