oa/rwgl/wddbrws.aspx.cs

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

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

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using haoke365;

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

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

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

                //txtbegintime.Text = System.DateTime.Now.AddDays(-30).ToString("yyyy-MM-dd");
                txtbegintime.Text = Request.Cookies["haoke"].Values["sdate"].ToString();
                txtendtime.Text = System.DateTime.Now.AddDays(1).ToString("yyyy-MM-dd");
                //页面绑定 
                GridViewBind();
            }
        }

        //查询 
        public void Query_Click(object sender, EventArgs e)
        {
            GridViewBind();
        }

        //gv绑定 
        public void GridViewBind()
        {
            string Str1 = " where b.rwzt='已发布' and jsr='" + this.Session["userid"] + "'and jszt='送审中' ";
            System.DateTime sdateStr = Convert.ToDateTime(txtbegintime.Text);
            System.DateTime edateStr = Convert.ToDateTime(txtendtime.Text);
            Str1 = Str1 + " and fbsj>='" + sdateStr + "' and fbsj<='" + edateStr + "'";

            if (!string.IsNullOrEmpty(rysq.Text))
            {
                Str1 = Str1 + " and fbr = '" + rysq.Text + "' ";
            }

            if (!string.IsNullOrEmpty(rwbt.Text))
            {
                 
                Str1 = Str1 + " and " + query_tj.SelectedItem.Value + " like '%" + rwbt.Text + "%'";
            }