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(); }