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