bas/dxgl/Dxczjl.aspx.cs

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

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

using System;
using System.Data;
using System.Web.UI.WebControls;
using haoke365;

namespace hkoa.oa.dxgl
{
    public partial class Dxczjl : System.Web.UI.Page
    {
        mydb hkdb = new mydb();
        protected void Page_Load(object Sender, EventArgs E)
        {
            hkdb.VeriSess("3");

            if (!IsPostBack)
            {
                hkdb.PassTo("11004", "11004");

                OperQx();

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

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

        //操作权限
        public void OperQx()
        {
            hkdb.QxValid(AddBtn, "11004a", Session["roleqx"].ToString());
            hkdb.QxValid(QueBtn, "11004q", Session["roleqx"].ToString());
            hkdb.QxValid(DelBtn, "11004d", Session["roleqx"].ToString());
        }

        //gv绑定 
        public void GridViewBind()
        {
            string sql = " WHERE 1=1";
            if (!string.IsNullOrEmpty(query_content.Text))
            {
                sql = sql + " AND " + query_tj.Text + " like '%" + query_content.Text + "%'";
            }

            AspNetPager1.RecordCount = (int)SqlHelper.ExecuteScalar("SELECT COUNT(*) AS NUMS FROM HK_DXCZD A" + sql);
            DataSet ds = SqlHelper.ExecuteDs("SELECT A.*,B.UI_DESC FROM HK_DXCZD A LEFT OUTER JOIN YH B ON (A.CZR=B.UI_ID)" + sql, AspNetPager1.PageSize * (AspNetPager1.CurrentPageIndex - 1), AspNetPager1.PageSize);
            GridView1.DataSource = ds;
            GridView1.DataBind();
        }

        //删除 
        public void Del_Click(object Sender, EventArgs E)
        {
            string cal = "";
            int i = 0;
            for (i = 0; i <= GridView1.Rows.Count - 1; i++)
            {
                CheckBox cb = (CheckBox)GridView1.Rows[i].Cells[1].FindControl("del");
                if (cb.Checked == true)
                {