main.aspx.cs

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

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

using System;
using System.Collections.Generic;

using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.OleDb;
namespace khglcrm
{
    public partial class main : System.Web.UI.Page
    {
       public string qydt="";
       public string kehu="";
       public string tixing="";
       public string richeng = "";
       public int xinga = 0;
       public int xingb = 0;
       public int xingc = 0;
       public int xingd = 0;
       public int xinge = 0;
       public int xingf = 0;
       public int gena = 0;
       public int genb = 0;
       public int genc = 0;
       public int gend = 0;
       public int gene = 0;
       public int yuyue = 0;
        protected void Page_Load(object sender, EventArgs e)
        {
            if (Session["admin"] == null)
            {
                Response.Write("<script language='javascript'>alert('登录超时');top.location.href='login.aspx';<" + "/script>");
            }
            else
            {
                if (!Page.IsPostBack)
                {
                    DB mydb = new DB();
                    gena = mydb.zongji("SELECT count(*) FROM (select DISTINCT customer.id from yuyue,customer where biaoshi='gs' and yyren='" + Session["admin"].ToString() + "' and int(yuyue.gongsi)=customer.id and DateDiff('d',Now(),yusj)<=0 and DateDiff('d',Now(),yusj)>=-30)");
                    genb = mydb.zongji("SELECT count(*) FROM (select DISTINCT customer.id from yuyue,customer where biaoshi='gs' and yyren='" + Session["admin"].ToString() + "' and int(yuyue.gongsi)=customer.id and DateDiff('d',Now(),yusj)<=-30 and DateDiff('d',Now(),yusj)>=-90)");
                    genc = mydb.zongji("SELECT count(*) FROM (select DISTINCT customer.id from yuyue,customer where biaoshi='gs' and yyren='" + Session["admin"].ToString() + "' and int(yuyue.gongsi)=customer.id and DateDiff('d',Now(),yusj)<=-90 and DateDiff('d',Now(),yusj)>=-360)");
                    gend = mydb.zongji("SELECT count(*) FROM (select DISTINCT customer.id from yuyue,customer where biaoshi='gs' and yyren='" + Session["admin"].ToString() + "' and int(yuyue.gongsi)=customer.id and DateDiff('d',Now(),yusj)<=-360)");
                    gene = mydb.zongji("SELECT count(*) FROM customer WHERE tjren='" + Session["admin"].ToString() + "' and id not in (SELECT DISTINCT customer.id FROM yuyue, customer WHERE biaoshi='gs' and yyren='" + Session["admin"].ToString() + "' and int(yuyue.gongsi)=customer.id)");
                    yuyue = mydb.zongji("select count(*) from yuyue,customer where biaoshi='gs' and yyren='" + Session["admin"].ToString() + "' and int(yuyue.gongsi)=customer.id and DateDiff('d',Now(),yusj)>=0");

                    xinga = mydb.zongji("select count(*) from customer where xingp='★' and tjren='" + Session["admin"].ToString() + "'");
                    xingb = mydb.zongji("select count(*) from customer where xingp='★★' and tjren='" + Session["admin"].ToString() + "'");
                    xingc = mydb.zongji("select count(*) from customer where xingp='★★★' and tjren='" + Session["admin"].ToString() + "'");
                    xingd = mydb.zongji("select count(*) from customer where xingp='★★★★' and tjren='" + Session["admin"].ToString() + "'");
                    xinge = mydb.zongji("select count(*) from customer where xingp='★★★★★' and tjren='" + Session["admin"].ToString() + "'");
                    xingf = mydb.zongji("select count(*) from customer where xingp='VIP' and tjren='" + Session["admin"].ToString() + "'");
                    mydb.close();
                    this.show();
                    this.showkh();
                    this.showyu();
                    this.showric();
                    this.banquan();
                    this.Label4.Text = "今天日期是：" + DateTime.Now.ToShortDateString();
                }
            }