//导入全部数据到datatable中，用于以后使用
private void ImportTxt()
{
if (File.Exists(filepath))
{
dt_Data = new DataTable();
dt_Data.Columns.Add("id", typeof(string));
dt_Data.Columns.Add("time", typeof(string));
dt_Data.Columns.Add("dxq", typeof(string));
dt_Data.Columns.Add("rxq", typeof(string));
dt_Data.Columns.Add("fnjcdl", typeof(string));
dt_Data.Columns.Add("fnjcrl", typeof(string));
dt_Data.Columns.Add("fnjxhrql", typeof(string));
dt_Data.Columns.Add("brglcrl", typeof(string));
dt_Data.Columns.Add("brglxhrql", typeof(string));
dt_Data.Columns.Add("fnjdxl", typeof(string));
dt_Data.Columns.Add("fnjrxl", typeof(string));
dt_Data.Columns.Add("brglrxl", typeof(string));
dt_Data.Columns.Add("sd", typeof(string));
dt_Data.Columns.Add("sr", typeof(string));
dt_Data.Columns.Add("gfxh", typeof(string));
dt_Data.Columns.Add("gfcc", typeof(string));
dt_Data.Columns.Add("gfcdl", typeof(string));
dt_Data.Columns.Add("grxh", typeof(string));
dt_Data.Columns.Add("grcc", typeof(string));
dt_Data.Columns.Add("grcrl", typeof(string));
dt_Data.Columns.Add("cdl", typeof(string));
dt_Data.Columns.Add("crl", typeof(string));
var file = File.Open(filepath, FileMode.Open);
List<string> txt = new List<string>();
using (var stream = new StreamReader(file, Encoding.GetEncoding("GB2312")))
{
while (!stream.EndOfStream)
{
string strdata = stream.ReadLine();
DataRow dr = dt_Data.NewRow();
for (int i = 0; i < strdata.Split('\t').Count(); i++)
{
dr[i] = strdata.Split('\t')[i];
}
dt_Data.Rows.Add(dr);
}
}
file.Close();
this.Dispatcher.Invoke(new Action(() =>
{
ChartLineYearUC cyu = new ChartLineYearUC("全年能耗需求");
this.grid_xq.Children.Add(cyu);
DataTable dt_e = ImportDatatable(0, 2, 1);
DataTable dt_h = ImportDatatable(0, 3, 1);
if (dt_e != null)
{
cyu.AddLineData(dt_e, "电需求(kW)", "#FF0000FF");
}
if (dt_h != null)
{
cyu.AddLineData(dt_h, "热需求(kW)", "#FFFF0000");
}
int j = Int32.Parse(mComboBox.SelectedValue.ToString().Trim());
cyu_down = new ChartLineYearUC(mComboBox.Text + "全年数据");
this.grid_fnj.Children.Add(cyu_down);
DataTable dt = ImportDatatable(0, j, 1);
cyu_down.AddLineData(dt, mComboBox.SelectedItem.ToString(), "#FF0DA4DC");
}));
}
}
//点击确定更改下方展示曲线数据源
private void Button_Click(object sender, RoutedEventArgs e)
{
int i = Int32.Parse(mComboBox.SelectedValue.ToString().Trim());
this.grid_fnj.Children.Clear();
cyu_down = new ChartLineYearUC(mComboBox.Text + "全年数据");
this.grid_fnj.Children.Add(cyu_down);
DataTable dt = ImportDatatable(0, i, 1);
cyu_down.AddLineData(dt, mComboBox.SelectedItem.ToString(), "#FF5B9BD5");
}