WPF UIE 3D Chart -2- (Wpf Toolkit)

Site Index

private void proc_C_SdName_Like_drawChart()

{

    int w_int_seriesLimit = Convert.ToInt16(this.textBox_seriesLimit.Text);

    string w_seriesFrom = this.textBox_seriesFrom.Text;

    string w_seriesLimit = this.textBox_seriesLimit.Text;

    DataSet[] w_dsSeries = new DataSet[w_int_seriesLimit + 1];

    LineSeries[] w_lineSeries = new LineSeries[w_int_seriesLimit + 1];
    for (int idx2 = 0; idx2 <= w_int_seriesLimit; idx2++)

    {

        w_lineSeries[idx2] = new LineSeries();

        w_lineSeries[idx2].IndependentValuePath = "month";

        w_lineSeries[idx2].DependentValuePath = "kingak";

        tab_C_chart1.Series.Add(w_lineSeries[idx2]);

    }

    String w_SQL = null;
    w_SQL += "select round(sum(kingak/1000)) as kingak,sum(suuryo) as suuryo";

    w_SQL += ",SdNam1,max(G3Code) as G3Code,max(G4Code) as G4Code,max(G5Code) as G5Code";

    w_SQL += " from tb_urdata";

    w_SQL += " where (dkubun = '01' or dkubun = '02')";

    w_SQL += " and   TkCode  = '" + this.main_TkCode.Text + "'";

    w_SQL += " and   UrDate >= '" + this.main_textBox_date1.Text + "'";

    w_SQL += " and   UrDate <= '" + this.main_textBox_date2.Text + "'";

    w_SQL += " group by SdNam1";

    w_SQL += " order by kingak desc";

    w_SQL += " limit " + w_seriesFrom + "," + w_seriesLimit;
    z_CMD_YSYS.Connection = z_DB_YSYS;

    z_CMD_YSYS.CommandText = w_SQL;

    System.Data.Odbc.OdbcDataReader w_Reader = z_CMD_YSYS.ExecuteReader();
    DataTable w_dataTable = new System.Data.DataTable();

    w_dataTable.Columns.Add("金額");

    w_dataTable.Columns.Add("名称");

    w_dataTable.Columns.Add("G3");

    w_dataTable.Columns.Add("G4");

    w_dataTable.Columns.Add("G5");

    DataRow w_DataRow;

    

    w_dsSeries[0] = proc_C_transition_Base_dataSet();

    w_lineSeries[0].ItemsSource = w_dsSeries[0].Tables[0].DefaultView;

    w_lineSeries[0].Title = "Total/万単位";

    w_lineSeries[0].ToolTip = "Total";

    w_lineSeries[0].PolylineStyle = (Style)(this.Resources["xaml_PolylineStyle_7"]);
    int idx = 1;

    while (w_Reader.Read())

    {

        w_DataRow = w_dataTable.Rows.Add();

        String w_kingak = Convert.ToString(w_Reader["kingak"]);

        String w_G5Name = Convert.ToString(w_Reader["SdNam1"]);

        String w_G3Code = Convert.ToString(w_Reader["G3Code"]);

        String w_G4Code = Convert.ToString(w_Reader["G4Code"]);

        String w_G5Code = Convert.ToString(w_Reader["G5Code"]);

        w_DataRow["金額"] = w_kingak;

        w_DataRow["名称"] = w_G5Name;

        w_DataRow["G3"] = w_G3Code;

        w_DataRow["G4"] = w_G4Code;

        w_DataRow["G5"] = w_G5Code;

        //*******************************

        //  Chart series

        //*******************************

        w_dsSeries[idx] = proc_C_transition_sdname_dataSet(w_G5Name);

        w_lineSeries[idx].ItemsSource = w_dsSeries[idx].Tables[0].DefaultView;

        w_lineSeries[idx].Title = w_G3Code + "-" + w_G4Code + "-" + w_G5Code;

        w_lineSeries[idx].ToolTip = w_G3Code + "-" + w_G4Code + "-" + w_G5Code + ":" + w_G5Name;
        w_lineSeries[idx].PolylineStyle = (Style)(this.Resources["xaml_PolylineStyle_3"]);

        w_lineSeries[idx].MouseEnter += new MouseEventHandler(tab_C_MainWindow_MouseEnter);

        w_lineSeries[idx].MouseLeave += new MouseEventHandler(tab_C_MainWindow_MouseLeave);

        w_lineSeries[idx].PreviewMouseDown += new MouseButtonEventHandler(tab_C_MainWindow_PreviewMouseDown);

        idx++;

    }

    w_Reader.Close();

    this.tab_C_dataGrid_chart.ItemsSource = w_dataTable.DefaultView;

    this.tab_C_dataGrid_chart.FontSize = 12;

    this.tab_C_dataGrid_chart.SelectedIndex = 0;
    this.tab_C_chart1.Title = this.main_TkCode.Text + ":" + this.main_TkName.Text;

}