SiteAdmin/Aspx/SDTJManage.aspx.cs

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

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

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

public partial class SiteAdmin_Aspx_SDTJManage : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Request.Cookies["roleid"] != null)
        {
            if (!IsPostBack)
            {
                Bank myu = new Bank();
                DataTable dt = myu.GetList("1=1 order by hot ").Tables[0];
                ListItem newItem = new ListItem("----全 部----", "");
                this.DropDownList_JRJG.Items.Add(newItem);
                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    newItem = new ListItem(dt.Rows[i]["Name"].ToString(), dt.Rows[i]["ID"].ToString());
                    this.DropDownList_JRJG.Items.Add(newItem);
                }

                binddr();
            }
        }
        else
        {
            MessageBox.ShowAndRedirect(this.Page, "对不起！您还没有登录系统。", "../Logout.aspx");
        }
    }
    //绑定记录
    public void binddr()
    {
        ShenTab myn = new ShenTab();

        string start_time = "1900-01-01";
        if (Request["txtFindDate1"] != null && Request["txtFindDate1"] != "")
        {
            start_time = Request["txtFindDate1"].ToString();
        }
        string stop_time = "2099-01-01";
        if (Request["txtFindDate2"] != null && Request["txtFindDate2"] != "")
        {
            stop_time = Request["txtFindDate2"].ToString();
        }

        string sqlstr = "select  b.[ID] as QID,a.[ID],a.Company,a.RZXS,a.RZED,a.[Name],a.Mobile,a.SQTime,b.CJJE,b.SLTime,b.CJTime,b.ISCJ ,b.ISWJ   from ShenTab as a, ShenTabQK as b  where  a.ID=b.SID  ";
        sqlstr = sqlstr + " and  a.SQTime  between  '" + DateTime.Parse(start_time) + "' and '" + DateTime.Parse(stop_time + " 23:59:59") + "' ";
        if (this.DropDownList_JRJG.SelectedValue != "")
        {
            sqlstr = sqlstr + " and b.JSID = " + Convert.ToInt16(this.DropDownList_JRJG.SelectedValue) + "";
        }

        sqlstr = sqlstr + " order by a.[ID] desc ";
        DataSet dv = myn.GetListSql(sqlstr);
        PagedDataSource pds = new PagedDataSource();
        AspNetPager1.RecordCount = dv.Tables[0].DefaultView.Count;
        pds.DataSource = dv.Tables[0].DefaultView;
        pds.AllowPaging = true;
        pds.CurrentPageIndex = AspNetPager1.CurrentPageIndex - 1;