public void LoadData() { //string where = " 1=1 AND Lang_ID IN (SELECT T_UserLanguages.Languages_ID FROM T_UserLanguages WHERE T_UserLanguages.[User_ID] = " + _user.UserID + ")"; string where = " 1=1 "; if (cbo_lanquage.SelectedIndex > 0) { where += " AND Lang_ID=" + cbo_lanquage.SelectedValue.ToString(); } if (cbo_Khachhang.SelectedIndex > 0) { where += " AND Cust_ID=" + cbo_Khachhang.SelectedValue.ToString(); } where += " Order by Order_Number ASC"; pages.PageSize = Global.MembersPerPage; HPCBusinessLogic.DAL.T_Customer_AdsDAL _cateDAL = new HPCBusinessLogic.DAL.T_Customer_AdsDAL(); DataSet _ds; _ds = _cateDAL.Bind_T_Customer_AdsDynamic(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 = _cateDAL.Bind_T_Customer_AdsDynamic(pages.PageIndex - 1, pages.PageSize, where); } // DataView _dv = _cateDAL.BindGridCagegorys(_ds.Tables[0]); grdListCate.DataSource = _ds; grdListCate.DataBind(); _ds.Clear(); pages.TotalRecords = curentPages.TotalRecords = TotalRecords; curentPages.TotalPages = pages.CalculateTotalPages(); curentPages.PageIndex = pages.PageIndex; Session["PageIndex"] = pages.PageIndex; }
public void LoadData() { string where = " 1=1 AND Possittion = 1"; if (txt_tieude.Text.Trim().Length > 0) { where += " AND DisplayType LIKE " + string.Format("N'%{0}%'", UltilFunc.SqlFormatText(txt_tieude.Text.Trim())); } where += " Order by Order_Number ASC"; pages.PageSize = Global.MembersPerPage; HPCBusinessLogic.DAL.T_Customer_AdsDAL _cateDAL = new HPCBusinessLogic.DAL.T_Customer_AdsDAL(); DataSet _ds; _ds = _cateDAL.Bind_T_Customer_AdsDynamic(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 = _cateDAL.Bind_T_Customer_AdsDynamic(pages.PageIndex - 1, pages.PageSize, where); } // DataView _dv = _cateDAL.BindGridCagegorys(_ds.Tables[0]); grdListCate.DataSource = _ds; grdListCate.DataBind(); _ds.Clear(); pages.TotalRecords = curentPages.TotalRecords = TotalRecords; curentPages.TotalPages = pages.CalculateTotalPages(); curentPages.PageIndex = pages.PageIndex; Session["PageIndex"] = pages.PageIndex; }