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