private void frmCharting_Load(object sender, EventArgs e)

        {

            ConfChart();



        }



         private DataTable CreateDataTable()

        {

            DataTable dt = new DataTable();

            SqlConnection conn = new SqlConnection(frmMain.GetConnString());

            SqlDataAdapter adapter = new SqlDataAdapter();

            string selectQuery = "select COUNT(*) as 案件数量, department.deptname as 部门名称 from cases, department where cases.departid = department.deptid group by department.deptname";

            

            adapter.SelectCommand = new SqlCommand(selectQuery, conn);

            adapter.Fill(dt);

            return dt;

        }



         private void ConfChart()

         {

             chart1.Debug = false;

             chart1.Mentor = false;

             chart1.Title = "部门诉求统计图";

             //Chart1.XAxis.Label.Text="日期";

             chart1.YAxis.Label.Text = "诉求案件数";

             //chart1.TempDirectory = "C:\\";

             chart1.ShadingEffect = true;

             chart1.Use3D = true;

             chart1.Width = 600;

             chart1.Height = 350;

             chart1.Series.Name = "客户反馈次数";

             chart1.Series.Data = CreateDataTable();

             chart1.SeriesCollection.Add();

             chart1.DefaultSeries.DefaultElement.ShowValue = true;

             chart1.Refresh();

             chart1.RefreshChart();

         }