/// <summary> /// 地图导出 /// </summary> /// <param name="MapTime">UTCTime</param> /// <param name="FileName">保存路径</param> /// <returns></returns> public bool Export_Map(long MapTime, string FileName) { try { string sql = IO_AGVMapService.ExportSettings(MapTime, "agv") + IO_AGVMapService.ExportMySqlTables("tag" + MapTime, "agv") + IO_AGVMapService.ExportMySqlTables("line" + MapTime, "agv") + IO_AGVMapService.ExportMySqlTables("device" + MapTime, "agv") + IO_AGVMapService.ExportMySqlTables("widget" + MapTime, "agv") + IO_AGVMapService.ExportMySqlTables("route" + MapTime, "agv"); sql = sql + IO_AGVMapService.ExportTableContents("map", "agv", MapTime.ToString()); File.WriteAllText(FileName, sql); return(true); } catch (Exception ex) { throw new Exception(ex.Message); } }
/// <summary> /// 导出日志 /// </summary> /// <param name="path"></param> /// <param name="DateTime"></param> public void LogWrite(string path, string DateTime) { try { string Tableresult = OperateIniTool.OperateIniRead("Table", "Name"); List <string> Table = !string.IsNullOrEmpty(Tableresult) ? Tableresult.Split(',').ToList() : new List <string>(); StringBuilder builder = new StringBuilder(); foreach (var item in Table) { if (MapBLL.TableNotexistBLL($"{item}{DateTime}")) { builder.Append(MapBLL.ExportMySqlTables($"{item}{DateTime}", "agv")); } } File.WriteAllText(path, builder.ToString()); } catch (Exception ex) { throw new Exception(ex.ToString()); } }