public void LoadCM() { string where = " Ma_Chuyenmuc_Cha = 0 AND HienThi_BDT = 1 and HienThi_BDT = 1 "; if (!String.IsNullOrEmpty(this.txtSearch_name.Text.Trim())) { where += " AND Ten_ChuyenMuc like N'%" + UltilFunc.SqlFormatText(this.txtSearch_name.Text.Trim()) + "%'"; } if (ddlLang.SelectedIndex > 0) { where += " AND Ma_AnPham =" + UltilFunc.SqlFormatText(ddlLang.SelectedValue); } //where += " Order by T_ChuyenMuc.ThuTuHienThi ASC"; ChuyenmucDAL _cateDAL = new ChuyenmucDAL(); DataSet _ds; _ds = _cateDAL.BindGridT_Cagegorys(0, 5000, where); int TotalRecords = Convert.ToInt32(_ds.Tables[1].Rows[0].ItemArray[0].ToString()); int TotalRecord = Convert.ToInt32(_ds.Tables[0].Rows.Count); DataTable _dv = _cateDAL.BindGridCategory(_ds.Tables[0]); _ds.Clear(); dgCategorysCopy.DataSource = _dv; dgCategorysCopy.DataBind(); }
public void Danhsach_ChuyenMuc() { string where = " Ma_Chuyenmuc_Cha=0"; if (cbo_Anpham.SelectedIndex > 0) { where += " and Ma_AnPham=" + cbo_Anpham.SelectedValue.ToString(); } if (!String.IsNullOrEmpty(this.txtSearch_ChuyenMuc.Text.Trim())) { where += " and " + string.Format(" Ten_ChuyenMuc like N'%{0}%'", UltilFunc.SqlFormatText(this.txtSearch_ChuyenMuc.Text.Trim())) + " or Ma_ChuyenMuc in( select Ma_Chuyenmuc_Cha from T_ChuyenMuc where Ma_ChuyenMuc in (select Ma_ChuyenMuc from T_ChuyenMuc where " + string.Format(" Ten_ChuyenMuc like N'%{0}%'", UltilFunc.SqlFormatText(this.txtSearch_ChuyenMuc.Text.Trim())) + "))"; } if (chk_Hoatdong.Checked) { where += " and Hoatdong=1"; } if (!chk_Hoatdong.Checked) { where += " and Hoatdong=0"; } if (CheckBoxBaoDT.Checked) { where += " and HienThi_BDT=1"; } if (CheckBoxBaoIn.Checked) { where += " and HienThi_BaoIn=1"; } pages.PageSize = Global.MembersPerPage; ChuyenmucDAL _chuyenmucDAL = new ChuyenmucDAL(); DataSet _ds; if (Session["where_chuyenmuc"] != null) { _ds = _chuyenmucDAL.BindGridT_Cagegorys(pages.PageIndex, pages.PageSize, Session["where_chuyenmuc"].ToString()); } else { _ds = _chuyenmucDAL.BindGridT_Cagegorys(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) { if (Session["where_chuyenmuc"] != null) { _ds = _chuyenmucDAL.BindGridT_Cagegorys(pages.PageIndex - 1, pages.PageSize, Session["where_chuyenmuc"].ToString()); } else { _ds = _chuyenmucDAL.BindGridT_Cagegorys(pages.PageIndex - 1, pages.PageSize, where); } } DataTable dt = _chuyenmucDAL.BindGridCategory(_ds.Tables[0]); grdListCate.DataSource = dt; grdListCate.DataBind(); _ds.Clear(); pages.TotalRecords = curentPages.TotalRecords = TotalRecords; curentPages.TotalPages = pages.CalculateTotalPages(); curentPages.PageIndex = pages.PageIndex; Session["PageIndex"] = pages.PageIndex; }