/// <summary>
/// 编辑AGV
/// </summary>
/// <param name="agv"></param>
/// <returns></returns>
public bool editagv(Ga_agv agv)
{
return(MySqlHelper.ExecuteNonQuery("UPDATE `ga_agv`.`ga_agv` SET agvNum=@agvNum,agvSerialNum=@agvSerialNum,agvIp=@agvIp,agvPort=@agvPort WHERE agvId=@agvId", new MySqlParameter[] {
new MySqlParameter("@agvNum", MySqlDbType.Int32, 1000)
{
Value = agv.agvNum
},
new MySqlParameter("@agvSerialNum", MySqlDbType.VarChar, 1000)
{
Value = agv.agvSerialNum
},
new MySqlParameter("@agvIp", MySqlDbType.VarChar, 1000)
{
Value = agv.agvIp
},
new MySqlParameter("@agvPort", MySqlDbType.Int32, 1000)
{
Value = agv.agvPort
},
new MySqlParameter("@agvId", MySqlDbType.Int32, 1000)
{
Value = agv.agvId
}
}) > 0 ? true : false);
}
/// <summary>
/// 复位
/// </summary>
/// <param name="agvdata"></param>
/// <returns></returns>
public JsonResult Restoration([FromBody] Ga_agv agvdata)
{
return(new JsonResult()
{
Message = "模拟测试"
});
}
/// <summary>
/// 删除AGV
/// </summary>
/// <param name="agv"></param>
/// <returns></returns>
public bool agvdelete(Ga_agv agv)
{
return(MySqlHelper.ExecuteNonQuery("DELETE FROM `ga_agv`.`ga_agv` WHERE agvId=@agvId", new MySqlParameter[] { (new MySqlParameter("@agvId", MySqlDbType.Int32, 1000)
{
Value = agv.agvId
}) }) > 0 ? true : false);
}
/// <summary>
/// 手动自动
/// </summary>
/// <param name="agvdata"></param>
/// <returns></returns>
public JsonResult ManualSelfMotion([FromBody] Ga_agv agvdata)
{
return(new JsonResult()
{
Message = "模拟测试"
});
}
/// <summary>
/// 急停
/// </summary>
/// <param name="agvdata"></param>
/// <returns></returns>
public JsonResult Scram([FromBody] Ga_agv agvdata)
{
return(new JsonResult()
{
Message = "模拟测试"
});
}
/// <summary>
/// 云台下降
/// </summary>
/// <param name="agvdata"></param>
/// <returns></returns>
public JsonResult DeckDecline([FromBody] Ga_agv agvdata)
{
return(new JsonResult()
{
Message = "模拟测试"
});
}
public List <Jsontaskinfo> AGVlocation([FromBody] Ga_agv agvdata)
{
List <Jsontaskinfo> list = new List <Jsontaskinfo>
{
new Jsontaskinfo()
{
agvNum = 1, agvIsRunning = "在线", qrcode = "11", PBS = "区域3", agvHolder = "下降", Message = "障碍物检测", agvQR = "56", Task = "运输", taskStartQR = "20", taskEndQR = "50"
},
new Jsontaskinfo()
{
agvNum = 2, agvIsRunning = "在线", qrcode = "11", PBS = "区域3", agvHolder = "下降", Message = "障碍物检测", agvQR = "156", Task = "运输", taskStartQR = "20", taskEndQR = "50"
},
new Jsontaskinfo()
{
agvNum = 3, agvIsRunning = "在线", qrcode = "11", PBS = "区域3", agvHolder = "下降", Message = "障碍物检测", agvQR = "100", Task = "运输", taskStartQR = "20", taskEndQR = "50"
},
new Jsontaskinfo()
{
agvNum = 4, agvIsRunning = "在线", qrcode = "11", PBS = "区域3", agvHolder = "下降", Message = "障碍物检测", agvQR = "78", Task = "运输", taskStartQR = "20", taskEndQR = "50"
},
new Jsontaskinfo()
{
agvNum = 5, agvIsRunning = "在线", qrcode = "11", PBS = "区域3", agvHolder = "下降", Message = "障碍物检测", agvQR = "20", Task = "运输", taskStartQR = "20", taskEndQR = "50"
},
new Jsontaskinfo()
{
agvNum = 6, agvIsRunning = "在线", qrcode = "11", PBS = "区域3", agvHolder = "下降", Message = "障碍物检测", agvQR = "134", Task = "运输", taskStartQR = "20", taskEndQR = "50"
}
};
return(list);
}
/// <summary>
/// AGV状态回读
/// </summary>
/// <returns></returns>
public JsonagvInfo agvState([FromBody] Ga_agv agvdata)
{
if (a > 10)
{
a = 0;
}
a++;
return(new JsonagvInfo()
{
Success = true, agvNum = 1, agvFirmware = "V1.02.3" + a, agvHolder = a > 5 ? "上升" : "下降", agvIsRunning = a > 5 ? "离线" : "在线", Message = a > 5 ? "正常" : "障碍物检测中", qrcode = "003", PBS = "区域" + a, agvspeed = a * 2, voltage = a * 6
});
}
/// <summary>
/// 添加AGV
/// </summary>
/// <param name="agv"></param>
/// <returns></returns>
public bool Addagv(Ga_agv agv)
{
StringBuilder sql = new StringBuilder();
sql.Append("INSERT INTO `ga_agv`.`ga_agv`(`agvNum`, `agvSerialNum`, `agvName`, `agvIp`, `agvPort`, `agvCreateTime`, `agvOffLineTime`, `agvOnLineTime`, `agvFirmware`) VALUES ( @agvNum,@agvSerialNum, @agvName, @agvIp, @agvPort, @agvCreateTime, @agvOffLineTime, @agvOnLineTime,@agvFirmware)");
MySqlParameter[] par =
{
new MySqlParameter("@agvNum", MySqlDbType.Int32, 10000)
{
Value = agv.agvNum
},
new MySqlParameter("@agvSerialNum", MySqlDbType.VarChar, 10000)
{
Value = agv.agvSerialNum
},
new MySqlParameter("@agvName", MySqlDbType.VarChar, 10000)
{
Value = agv.agvName
},
new MySqlParameter("@agvIp", MySqlDbType.VarChar, 10000)
{
Value = agv.agvIp
},
new MySqlParameter("@agvPort", MySqlDbType.Int32, 10000)
{
Value = agv.agvPort
},
new MySqlParameter("@agvCreateTime", MySqlDbType.Int32, 10000)
{
Value = UTC.ConvertDateTimeLong(Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd")))
},
new MySqlParameter("@agvOffLineTime", MySqlDbType.VarChar, 10000)
{
Value = agv.agvOffLineTime
},
new MySqlParameter("@agvOnLineTime", MySqlDbType.VarChar, 10000)
{
Value = agv.agvOnLineTime
},
new MySqlParameter("@agvFirmware", MySqlDbType.VarChar, 10000)
{
Value = agv.agvFirmware
},
};
return(MySqlHelper.ExecuteNonQuery(sql.ToString(), par) > 0 ? true : false);
}
public JsonResult deleteagv([FromBody] Ga_agv agvdata)
{
if (Ga_Agv.delete(agvdata))
{
return(new JsonResult()
{
Message = "删除成功", Success = true
});
}
else
{
return(new JsonResult()
{
Message = "删除失败", Success = false
});
}
}
/// <summary>
/// 编辑AGV
/// </summary>
/// <param name="agvdata"></param>
/// <returns></returns>
public JsonResult editagv([FromBody] Ga_agv agvdata)
{
if (Ga_Agv.edit(agvdata))
{
return(new JsonResult()
{
Message = "修改成功", Success = true
});
}
else
{
return(new JsonResult()
{
Message = "修改失败", Success = false
});
}
}
/// <summary>
/// 添加AGV
/// </summary>
/// <param name="agvdata"></param>
/// <returns></returns>
public JsonResult Addagv([FromBody] Ga_agv agvdata)
{
if (Ga_Agv.agvadd(agvdata))
{
return(new JsonResult()
{
Message = "添加成功", Success = true
});
}
else
{
return(new JsonResult()
{
Message = "添加失败", Success = false
});
}
}
/// <summary>
/// 编辑AGV
/// </summary>
/// <param name="agv"></param>
/// <returns></returns>
public bool edit(Ga_agv agv)
{
return(GeagvtDAL.editagv(agv));
}
/// <summary>
/// 删除agv
/// </summary>
/// <param name="agv"></param>
/// <returns></returns>
public bool delete(Ga_agv agv)
{
return(GeagvtDAL.agvdelete(agv));
}
/// <summary>
/// 添加AGV
/// </summary>
/// <returns></returns>
public bool agvadd(Ga_agv agv)
{
return(GeagvtDAL.Addagv(agv));
}
