private void FrmExportHistory_Load(object sender, EventArgs e)
{
string str = new IniConfigHelper().ReadIniData("已选曲线", "selectTrend", "", CommonMethods.FilePath);
sqlArray = str.Split(',');
if (sqlArray.Length == 1 && sqlArray[0] == "@")
{
return;
}
HeaderTextList.Add("日期时间");
sqlString.Add("InsertTime");
for (int i = 0; i < sqlArray.Length; i++)
{
HeaderTextList.Add(CommonMethods.TrendName[sqlArray[i]].Description);
sqlString.Add((CommonMethods.TrendName[sqlArray[i]].Name));
}
for (int i = 0; i < HeaderTextList.Count; i++)
{
DataGridViewTextBoxColumn dgvc = new DataGridViewTextBoxColumn();
dgvc.HeaderText = HeaderTextList[i];
dgvc.ReadOnly = true;
dgvc.Width = 150;
dgvc.SortMode = System.Windows.Forms.DataGridViewColumnSortMode.NotSortable;
dgvc.DataPropertyName = sqlString[i];
dgvc.Name = sqlString[i];
this.DgvExport.Columns.Add(dgvc);
}
//拼接SQL语句
StringBuilder sb = new StringBuilder();
sb.Append("select ");
string str1 = string.Join(",", sqlString.ToArray());
sb.Append(str1);
sb.Append(" from TemperaTureMeasure where 1=1 and InsertTime between '{0}' and '{1}'");
string sql = string.Format(sb.ToString(), dtpStart.Text.Trim(), dtpEnd.Text.Trim());
DataTable dt = SQLHelper.GetDataSet(sql).Tables[0];
//如何把DataTable赋值到DataGridView
int index = this.DgvExport.Rows.Add();
DgvExport.DataSource = null;
DgvExport.DataSource = dt;
}
private void FrmHistoryTrend_Load(object sender, EventArgs e)
{
chartHistory.AxisX.MajorGridCount = 4;
string str = new IniConfigHelper().ReadIniData("已选曲线", "selectTrend", "", CommonMethods.FilePath);
chartHistory.DisplayPoints = Convert.ToInt32(new IniConfigHelper().ReadIniData("历史显示点数", "Points", "", CommonMethods.FilePath));
sqlArray = str.Split(',');
if (sqlArray.Length == 1 && sqlArray[0] == "@")
{
return;
}
for (int i = 0; i < sqlArray.Length; i++)
{
listParameter.Add(CommonMethods.TrendName[sqlArray[i]].Name);
}
}