public void LoadData() { string where = " 1=1 "; if (ddlLang.SelectedIndex > 0) { where += string.Format(" AND Lang_ID = {0}", ddlLang.SelectedValue); } if (ddlType.SelectedIndex > 0) { where += string.Format(" AND IsType = {0}", ddlType.SelectedValue); } if (!String.IsNullOrEmpty(this.txtSearch_Cate.Text.Trim())) { where += string.Format(" AND URL like N'%{0}%'", UltilFunc.SqlFormatText(this.txtSearch_Cate.Text.Trim())); } where += " Order by ID DESC"; pages.PageSize = Global.MembersPerPage; HPCBusinessLogic.DAL.T_WebLinksDAL _cateDAL = new HPCBusinessLogic.DAL.T_WebLinksDAL(); DataSet _ds; _ds = _cateDAL.Bind_T_WebLinksDynamic(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_WebLinksDynamic(pages.PageIndex - 1, pages.PageSize, where); } grdListCate.DataSource = _ds; grdListCate.DataBind(); _ds.Clear(); pages.TotalRecords = curentPages.TotalRecords = TotalRecords; curentPages.TotalPages = pages.CalculateTotalPages(); curentPages.PageIndex = pages.PageIndex; }
protected void btnLinkDelete_Click(object sender, EventArgs e) { ArrayList ar = new ArrayList(); foreach (DataGridItem m_Item in grdListCate.Items) { CheckBox chk_Select = (CheckBox)m_Item.FindControl("optSelect"); if (chk_Select != null && chk_Select.Checked) { ar.Add(int.Parse(grdListCate.DataKeys[int.Parse(m_Item.ItemIndex.ToString())].ToString())); } } LoadData(); for (int i = 0; i < ar.Count; i++) { int News_ID = int.Parse(ar[i].ToString()); string _Url = ""; HPCBusinessLogic.DAL.T_WebLinksDAL tt = new HPCBusinessLogic.DAL.T_WebLinksDAL(); _Url = tt.load_T_WebLinks(News_ID).URL; tt.DeleteFrom_T_WebLinks(News_ID); string strLog = "[Danh sách liên kết website:]-->[Xóa liên kết] [URL:" + _Url + ""; WriteLogHistory2Database.WriteHistory2Database(_user.UserID, _user.UserFullName, "[Xóa]", Request["Menu_ID"].ToString(), strLog, 0, 0); } LoadData(); }
public void grdListCategory_EditCommand(object source, DataGridCommandEventArgs e) { HPCBusinessLogic.DAL.T_WebLinksDAL obj_Cate = new HPCBusinessLogic.DAL.T_WebLinksDAL(); if (e.CommandArgument.ToString().ToLower() == "edit") { int catID = Convert.ToInt32(this.grdListCate.DataKeys[e.Item.ItemIndex].ToString()); Response.Redirect("~/Quangcao/WebLinksEdit.aspx?Menu_ID=" + Page.Request["Menu_ID"].ToString() + "&ID=" + catID); } }