SiteAdmin/Aspx/JRSDTJManage.aspx.cs

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

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

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

public partial class SiteAdmin_Aspx_JRSDTJManage : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Request.Cookies["roleid"] != null)
        {
            if (!IsPostBack)
            {
                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   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") + "' ";

        sqlstr = sqlstr + " and  a.XZBank like '%|" + Server.HtmlEncode(Request.Cookies["dwid"].Value) + "|%'  and b.JSID=" + Convert.ToInt16(Server.HtmlEncode(Request.Cookies["dwid"].Value));
        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;
        pds.PageSize = AspNetPager1.PageSize;
        myrepeater.DataSource = pds;
        myrepeater.DataBind();

        Literal1.Text = dv.Tables[0].DefaultView.Count.ToString();

    
        double LR = 0.00;//成交总额
        int cjs=0;//成交数
        for (int i = 0; i < dv.Tables[0].DefaultView.Count; i++)
        {
        
            LR = LR + Convert.ToDouble(dv.Tables[0].Rows[i]["CJJE"].ToString());