SiteAdmin/Main.aspx.cs

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

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

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

 public partial class SiteAdmin_Main : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            if (Request.Cookies["roleid"] != null)
            {
                if (!IsPostBack)
                {
                    int userid = Convert.ToInt16(Server.HtmlEncode(Request.Cookies["userid"].Value));
                    LoginAnnal myl = new LoginAnnal();
                    myl.GetModelEND(userid);

                    Literal_date.Text = myl.LogTime.ToString();
                    Literal_ip.Text = myl.LogContent;

                    int roleid = Convert.ToInt16(Server.HtmlEncode(Request.Cookies["roleid"].Value));
                    if (roleid == 3)
                    {
                        Panel1.Visible = true;
                  
                    ShenTab myn = new ShenTab();
                    string sqlstr = "select 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.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);

                    string sqlstr1 = "select [ID] from ShenTab  where  ";

                    sqlstr1 = sqlstr1 + "  XZBank like '%|" + Server.HtmlEncode(Request.Cookies["dwid"].Value) + "|%' ";
    
                    DataSet dv1 = myn.GetListSql(sqlstr1);

                    Literal_wsl.Text = (dv1.Tables[0].DefaultView.Count - dv.Tables[0].DefaultView.Count).ToString();

                    Literal_ysl.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());
                        if (Convert.ToInt16(dv.Tables[0].Rows[i]["ISCJ"].ToString()) == 1)
                        {
                            cjs = cjs + 1;
                        }
                    }

                    Literal_cjze.Text = LR.ToString();
                    Literal_cjs.Text = cjs.ToString();

                    }
                }