static void Main1(string[] args)
{
try
{
// string key = "设备1";
// Dictionary<string, string> CoorDic = new Dictionary<string, string>();
//List<String> list= RedisList.Get ("robotCoordinate");
// WriteListToTextFile(list, "111.txt");
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
//AutoTaskServer at= new AutoTaskServer();
//// Console.WriteLine(r.DeviceErrDailyRpt("2018-06-25", "1, 2" ,null));
//at.TaskExec("2018-12-31");
Console.ReadKey();
ReportServer r = new ReportServer();
// Console.WriteLine(r.DeviceErrDailyRpt("2018-06-25", "1, 2" ,null));
// Console.WriteLine(r.DeviceErrDailyRpt("2018-06-25", "1, 2", "HNC-808A",0));
//Console.WriteLine(r.DeviceErrPhaseRpt("2018-06-25", "2018-06-26","1, 2", "HNC-808A", 0));
Console.WriteLine(r.DeviceErrYearRpt("2018", "1, 2", "HNC-808A", 0));
Console.WriteLine(r.DeviceErrYearRpt("2018", "1, 2", "HNC-808A", 1));
Console.ReadKey();
ReportServer ats = new ReportServer();
WorkSataionsServer ws = new WorkSataionsServer();
Console.WriteLine(ats.DeviceDailyRpt("2018-06-25", "1,2", "HNC-808A"));
Console.WriteLine(ats.DevicePhaseRpt("2018-06-25", "2018-06-25", "1,2", "HNC-808A"));
Console.WriteLine(ats.DeviceMonthRpt("2018-06", "1,2", "HNC-808A"));
Console.WriteLine(ats.DeviceYearRpt("2018", "1,2", "HNC-808A"));
DevicesServer ds = new DevicesServer();
Console.WriteLine(ds.DeviceModelList());
Console.ReadKey();
string connstr = @"Host=47.96.172.122;UserName=huabao;Password=huabao2025;Database=huabao;Port=3306;CharSet=utf8;Allow Zero Datetime=true";
using (MySqlConnection connection = new MySqlConnection(connstr))
{
if (connection.State != ConnectionState.Open)
{
connection.Open();
}
string sql = "update getpics set getpicstime=@getpicstime where id=260";
MySqlCommand cmd = new MySqlCommand(sql, connection);
cmd.Parameters.AddWithValue("@getpicstime", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
cmd.ExecuteNonQuery();
}
}
public string GetLocationList(int lineid = 1)
{
WorkSataionsServer wServer = new WorkSataionsServer();
return(wServer.GetLocationList(lineid));
}
//test: /WorkStations/GetWorkStationList?orderid=99-1-18-1&lineid=1
public string GetWorkStationList(string orderid, int lineid = 1)
{
WorkSataionsServer wServer = new WorkSataionsServer();
return(wServer.GetWorkStationList(orderid, lineid));
}
//test: /WorkStations/GetArtificialInfo?artificialid=24
public string GetArtificialInfo(int artificialid)
{
WorkSataionsServer wServer = new WorkSataionsServer();
return(wServer.GetArtificialInfo(artificialid));
}
/// <summary>
/// 工位读取接口
/// </summary>
/// <returns></returns>
/// 测试数据 WorkStations/GetWorkSataionsInfo
public string GetWorkSataionsInfo()
{
WorkSataionsServer wServer = new WorkSataionsServer();
return(JsonConvert.SerializeObject(wServer.GetWorkStationInfo()));
}