WebUI/reports/memberarea.aspx.cs

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

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

namespace hyst.reports
{
    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 memberarea : Page
    {
        private BaseClass bc = new BaseClass();
        public string cmbArea = "全部";
        public string cmbCity = "";
        public string cmbProvince = "";
        private string dianpu;
        private string ed;
        protected HtmlForm form1;
        protected HtmlHead Head1;
        protected HiddenField HiddenField1;
        private string sd;
        protected WebChartControl WebChartControl1;

        private void DrawPie()
        {
            string title = "区域会员统计树形图";
            ChartServices.SetChartTitle(this.WebChartControl1, true, title, StringAlignment.Center, ChartTitleDockStyle.Top, true, new Font("宋体", 12f, FontStyle.Bold), Color.Red, 10);
            ChartServices.DrawChart(this.WebChartControl1, "人数", ViewType.Bar, this.load(), "mTown", "cout");
        }

        public DataTable load()
        {
            string sqll = "select mTown,count(*) as cout from membersinfo where 1=1 ";
            if (this.cmbProvince != "")
            {
                sqll = sqll + "and  charindex('" + this.cmbProvince + "', mProvince)>0";
            }
            if (this.cmbCity != "")
            {
                sqll = sqll + "and  charindex('" + this.cmbCity + "',mCity)>0";
            }
            if (this.cmbArea != "全部")
            {
                sqll = sqll + "and  charindex('" + this.cmbArea + "', mTown)>0";
            }
            if (this.dianpu != "NONE")
            {
                sqll = sqll + "  and mShopNum='" + this.dianpu + "'";
            }
            if ((this.sd != "") && (this.ed != ""))
            {
                string name5 = sqll;
                sqll = name5 + " and mMakedate between '" + this.sd + "' and '" + this.ed + "'";
            }
            sqll = sqll + "group by mTown";
            return this.bc.ReadTable(sqll);
        }