protected void grdLinkWeb_ItemCommand(object source, DataGridCommandEventArgs e) { string strCA = e.CommandArgument.ToString(); switch (e.CommandName) { case "Edit": Insert = false; Id = strCA; dt = LinkWebService.LinkWeb_GetByTop("1", "Id=" + Id, ""); txtName.Text = dt.Rows[0]["Name"].ToString(); txtLink.Text = dt.Rows[0]["Link"].ToString(); PageHelper.LoadDropDownListLanguage(ddlLanguage); ddlLanguage.SelectedValue = dt.Rows[0]["Lang"].ToString(); txtOrd.Text = dt.Rows[0]["Ord"].ToString(); chkActive.Checked = dt.Rows[0]["Active"].ToString() == "1" || dt.Rows[0]["Active"].ToString() == "True"; pnView.Visible = false; pnUpdate.Visible = true; break; case "Active": string strA = ""; string str = e.Item.Cells[2].Text; strA = str == "1" ? "0" : "1"; SqlDataProvider sql = new SqlDataProvider(); sql.ExecuteNonQuery("Update [LinkWeb] set Active=" + strA + " Where Id='" + strCA + "'"); BindGrid(); break; case "Delete": LinkWebService.LinkWeb_Delete(strCA); BindGrid(); break; } }
private void BindGrid() { grdLinkWeb.DataSource = LinkWebService.LinkWeb_GetByTop("", "", "Ord"); grdLinkWeb.DataBind(); if (grdLinkWeb.PageCount <= 1) { grdLinkWeb.PagerStyle.Visible = false; } else { grdLinkWeb.PagerStyle.Visible = true; } }
protected void Page_Load(object sender, EventArgs e) { try { if (!IsPostBack) { if (Request.Cookies["CurrentLanguage"] != null) { Lang = Request.Cookies["CurrentLanguage"].Value; } DataTable dtVanBan = NewsService.News_GetByTop("", "Active=1 AND GroupNewsId IN (Select Id from GroupNews where Active=1 AND [Index]=1 AND Language='" + Lang + "') AND Language='" + Lang + "'", "Date DESC"); if (dtVanBan.Rows.Count > 0) { rptVanBan.DataSource = PageHelper.ModifyData(dtVanBan, Consts.CON_VAN_BAN); rptVanBan.DataBind(); rptVanBan01.DataSource = dtVanBan; rptVanBan01.DataBind(); } dtVanBan.Clear(); dtVanBan.Dispose(); DataTable dtVideo = VideosService.Videos_GetByTop("10", "Active=1 AND Language='" + Lang + "'", "Ord"); if (dtVideo.Rows.Count > 0) { vId = dtVideo.Rows[0]["Link"].ToString(); VideoName = dtVideo.Rows[0]["Name"].ToString(); rptVideo.DataSource = dtVideo; rptVideo.DataBind(); } DataTable dtNews = NewsService.News_GetByTop("10", "Active=1 AND GroupNewsId IN (Select Id from GroupNews where Active=1 AND [Index]=0) AND Language='" + Lang + "'", "Views DESC"); rptReadMost.DataSource = PageHelper.ModifyData(dtNews, Consts.CON_TIN_TUC); rptReadMost.DataBind(); DataTable dtLink = LinkWebService.LinkWeb_GetByTop("", "Active=1 AND Lang='" + Lang + "'", "Ord"); rptLinkWeb.DataSource = dtLink; rptLinkWeb.DataBind(); } } catch (Exception ex) { MailSender.SendMail("", "", "Error System", ex.Message); } }