WebUI/peoplerate/comweek.aspx.cs

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

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

namespace hyst.peoplerate
{
    using DBUtility;
    using DevExpress.XtraCharts;
    using DevExpress.XtraCharts.Web;
    using System;
    using System.Data;
    using System.Drawing;
    using System.Web.UI;
    using System.Web.UI.HtmlControls;
    using System.Web.UI.WebControls;

    public class comweek : Page
    {
        private BaseClass bc = new BaseClass();
        protected HtmlForm form1;
        protected HtmlHead Head1;
        protected HiddenField HiddenField1;
        private ViewType types = ViewType.Bar;
        protected WebChartControl WebChartControl1;
        public string week = DateTime.Now.ToString("yyyy-MM-dd");

        private void DrawPie()
        {
            string ttt = string.Concat(new object[] { "第", this.WeekOfYear(DateTime.Parse(this.week).AddDays(-7.0)), "周与第", this.WeekOfYear(DateTime.Parse(this.week)), "周的人流统计分析图-周图表" });
            ChartServices.SetChartTitle(this.WebChartControl1, true, ttt, StringAlignment.Center, ChartTitleDockStyle.Top, true, new Font("宋体", 12f, FontStyle.Bold), Color.Red, 10);
            ChartServices.DrawChart(this.WebChartControl1, "人数", this.types, this.loadz(), "类型", "人数");
        }

        public DataTable loadz()
        {
            string sql = "select count(distinct case DATEDIFF(week,Addtime,'" + this.week + "') when 0 then Card_Id else null end) as '本周', count(distinct case DATEDIFF(week,Addtime,'" + this.week + "') when 1 then Card_Id else null end) as '上周' from Consumption_Back_select where shopId='" + PublicMethod.GetSessionValue("shopnum").ToString() + "'";
            DataTable dt = this.bc.ReadTable(sql);
            DataTable dtz = new DataTable();
            dtz.Columns.Add("类型", typeof(string));
            dtz.Columns.Add("人数", typeof(decimal));
            dtz.Rows.Add(new object[] { dt.Columns[1].ColumnName, dt.Rows[0][1].ToString() });
            dtz.Rows.Add(new object[] { dt.Columns[0].ColumnName, dt.Rows[0][0].ToString() });
            return dtz;
        }

        protected void Page_Load(object sender, EventArgs e)
        {
            if (!base.IsPostBack)
            {
                try
                {
                    this.week = DateTime.Parse(base.Request.QueryString["week"].ToString()).ToString("yyyy-MM-dd");
                    if (base.Server.UrlDecode(base.Request.QueryString["type"].ToString()) == "树状图")
                    {
                        this.types = ViewType.Bar;
                    }
                    else
                    {
                        this.types = ViewType.Pie;
                    }
                }
                catch
                {
                }