static public void SetChartDataColor(string chartName, object[,] datas, Excel.ChartObjects chObjs, int colIdx)
{
foreach (Excel.ChartObject chObj in chObjs)
{
if (chObj.Name.Equals(chartName))
{
Excel.Series oSeries = chObj.Chart.SeriesCollection(1);
for (int i = 1; i <= datas.GetLength(0); i++)
{
object oVal = datas.GetValue(i, colIdx);
double val = Convert.ToDouble(oVal);
Excel.Point oPoint = oSeries.Points(i);
if (val >= 1)
{
oPoint.Format.Fill.ForeColor.RGB = 0x0000FF;
}
else if ((val < 1) && (val >= 0.5))
{
oPoint.Format.Fill.ForeColor.RGB = 0xCC99FF;
}
}
return;
}
}
}
public void Rolling(DateTime dateThisDay)
{
object lockobject = new object();
lock (lockobject)
{
UInt16 RegionsCount = this.F_Regions.Count;
if (RegionsCount > 0)
{
this.Application.ScreenUpdating = false; //禁用excel界面
Series series_Depth = this.F_Series_Depth;
clsData_ProcessRegionData Region = default(clsData_ProcessRegionData);
Microsoft.Office.Interop.Excel.Point Pt = default(Microsoft.Office.Interop.Excel.Point);
float[] Depths = new float[RegionsCount - 1 + 1];
for (UInt16 i = 0; i <= RegionsCount - 1; i++)
{
Region = this.F_Regions.Item(i);
Pt = series_Depth.Points().item(i + 1);
if (Region.HasBottomDate)
{
if (dateThisDay.CompareTo(Region.BottomDate) > 0) //说明已经开挖到基坑底，并在向上进行结构物的施工
{
Pt.Format.Fill.ForeColor.RGB = Information.RGB(255, 0, 0);
}
else //说明还未开挖到基坑底，并在向下开挖
{
Pt.Format.Fill.ForeColor.RGB = Information.RGB(0, 0, 255);
}
}
try
{
Depths[i] = System.Convert.ToSingle(Region.Date_Elevation[dateThisDay]);
}
catch (KeyNotFoundException)
{
DateTime ClosestDate = ClsData_DataBase.FindTheClosestDateInSortedList(Region.Date_Elevation.Keys, dateThisDay);
Depths[i] = System.Convert.ToSingle(Region.Date_Elevation[ClosestDate]);
}
}
series_Depth.Values = Depths;
//刷新日期放置在最后，以免由于耗时过长而出现误判
this.F_textbox_Info.TextRange.Text = dateThisDay.ToString(AMEApplication.DateFormat);
}
this.Application.ScreenUpdating = true; //刷新excel界面
}
}