Admin/FenXi.aspx.cs

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

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

using System;
using System.Collections.Generic;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Collections;
using System.Drawing;

public partial class FenXi : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            string SQl = "delete from TB_TJ; Insert into TB_TJ(GoodSName, ShuLiang, ShiJian) select GoodsName,ShuLiang,ShiJian from TB_XiaoShou ; Insert into TB_TJ(GoodSName, ShuLiang, ShiJian) select GoodsName,Num,OrderDate from View_2 where OrderDate is not null ";
            DBHelper.ExecSql(SQl);
            SQl = "select GoodSName, sum(QianShu) as QianShu from View_3 group by GoodSName";
            DataSet ds = DBHelper.GetDataSet(SQl);
            ArrayList XTitle = new ArrayList();
            ArrayList[] ChartData = new ArrayList[1];
            ChartData[0] = new ArrayList();
            for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
            {


                XTitle.Add(ds.Tables[0].Rows[i]["GoodsName"].ToString());


                //图表数据（1组）
                //Chart Data


                ChartData[0].Add(ds.Tables[0].Rows[i]["QianShu"].ToString());

            }

            Chartlet1.InitializeData(ChartData, XTitle, null);
         
       
        }
    }
    protected void Button1_Click(object sender, EventArgs e)
    {
        string SQL = "select GoodSName, sum(QianShu) as QianShu from View_3 where ShiJian between '" + this.YYSimpleCalendar1.Text + "' and '" + this.YYSimpleCalendar2.Text + "' group by GoodSName ";
        DataSet ds = DBHelper.GetDataSet(SQL);
        ArrayList XTitle = new ArrayList();
        ArrayList[] ChartData = new ArrayList[1];
        ChartData[0] = new ArrayList();
        for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
        {


            XTitle.Add(ds.Tables[0].Rows[i]["GoodsName"].ToString());


            //图表数据（1组）
            //Chart Data