public void Start(GetTime gt)
{
OpenExcel();
today = gt.getDateToday();
yestoday = gt.getDateYestoday();
workface = gt.getWorkFace();
sqlquary_channel = string.Format(@"SELECT DISTINCT MPId, Depth, TunnelName FROM DataInfo
JOIN MeasurePoint ON MPId=Id
WHERE AcquisitionTime BETWEEN '{0} 16:00:00'AND '{1} 16:00:00' ", yestoday, today);
sqlquary_valus = string.Format(@"SELECT CreatTime, Channel, MPId, Location, DataInfo.Value, InitialValue, TunnelName, Depth
FROM MsgForewarn
INNER JOIN DataInfo ON Channel = MPId AND CreatTime = AcquisitionTime
LEFT JOIN MeasurePoint ON Id=Channel
WHERE CreatTime BETWEEN '{0} 16:00:00' AND '{1} 16:00:00' AND Location LIKE '{2}%'", yestoday, today, workface);
string pi7 = sqlquary_channel + " AND Depth=7 AND TunnelName LIKE '皮%'";
string pi12 = sqlquary_channel + " AND Depth=12 AND TunnelName LIKE '皮%'";
string gui7 = sqlquary_channel + " AND Depth=7 AND TunnelName LIKE '轨%'";
string gui12 = sqlquary_channel + " AND Depth=12 AND TunnelName LIKE '轨%'";
string[] sql_quary = new string[] { pi7, pi12, gui7, gui12 };
for (int i = 0; i < sql_quary.Length; i++)
{
//查询后返回 唯一的channel 组成的datatable
DataTable dt = GetDataTable(sql_quary[i]);
//计算
Calculate(dt);
//double[] number = Calculate(ways[i],deeps[i],dt);
}//end ToExcel(...)
Analysis();
AddPictures();
Subsidence();
SaveReportFile();
}
public void Start(GetTime gt, double[,] ava)
{
this.ava = ava;
this.today = gt.getDateToday();
this.yestoday = gt.getDateYestoday();
this.workface = gt.getWorkFace();
openexcel();
ToExcel();
sc.GetChart();
wb.Save(path, SaveFormat.Xlsx);
}
public void Start(GetTime gt, double ava)
{
today = gt.getDateToday();
yestoday = gt.getDateYestoday();
this.ava = ava;
OpenExcel();
Calculate();
ToExcel();
AddPicures();
workBook_excel.Save(excelFilePath, SaveFormat.Xlsx);
sqlConn.Close();
}
