oa/zsgl/wdsc.aspx.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using haoke365;
using System.Data;

namespace hkoa.oa.zsgl
{
    public partial class wdsc : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            mydb hkdb = new mydb();
            hkdb.VeriSess("4");
            
            if (!Page.IsPostBack)
            {
                hkdb.PassTo("10111", "0");

                AspNetPager1.PageSize = int.Parse(Request.Cookies["haoke"].Values["pagecount"]);

                //页面绑定 
                GridViewBind();
            }
        }

        public void GridViewBind()
        {
            AspNetPager1.RecordCount = (int)SqlHelper.ExecuteScalar("SELECT COUNT(*)AS NUMS FROM hk_KnowLedge where (CHARINDEX('," + this.Session["userid"].ToString() + ",',','+ScUsername+',') > 0 )");
            DataSet ds = SqlHelper.ExecuteDs("SELECT * FROM hk_KnowLedge  where (CHARINDEX('," + this.Session["userid"].ToString() + ",',','+ScUsername+',') > 0 ) order by LastTime desc", AspNetPager1.PageSize * (AspNetPager1.CurrentPageIndex - 1), AspNetPager1.PageSize);
            GridView1.DataSource = ds;
            GridView1.DataBind();
        }
 
        public void OnRow_Bound(object sender, GridViewRowEventArgs e)
        {
            if (e.Row.RowType == DataControlRowType.DataRow)
            {
                e.Row.Attributes["onclick"] = "javascript:changeBg(this)";      //单击变色
            }

            if (e.Row.RowType == DataControlRowType.DataRow)
            {

                LinkButton lbtn1 = (LinkButton)e.Row.FindControl("tuijian");
                LinkButton lbtn2 = (LinkButton)e.Row.FindControl("dingyue");
                LinkButton lbtn3 = (LinkButton)e.Row.FindControl("quxiaoshoucang");
                lbtn1.Attributes.Add("onclick", "javascript:return confirm('确认推荐知识[" + e.Row.Cells[1].Text.ToString() + "]吗？每天只能推荐3次')");
                lbtn2.Attributes.Add("onclick", "javascript:return confirm('确认订阅知识[" + e.Row.Cells[1].Text.ToString() + "]吗？')");
                lbtn3.Attributes.Add("onclick", "javascript:return confirm('确认取消收藏知识[" + e.Row.Cells[1].Text.ToString() + "]吗？')");

            }
        }

        protected void AspNetPager1_PageChanged(object sender, System.EventArgs e)
        {