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