/// <summary> /// 添加货架 /// </summary> /// <param name="rack"></param> /// <returns></returns> public bool Addrack(Ga_rack rack) { StringBuilder sql = new StringBuilder(); sql.Append("INSERT INTO `ga_agv`.`ga_rack`(`rackSerialNum`, `rack_qrInfo`, `rackStatus`, `rack_agvSerailNum`) VALUES ( @rackSerialNum,@rack_qrInfo, @rackStatus, @rack_agvSerailNum)"); MySqlParameter[] par = { new MySqlParameter("@rackSerialNum", MySqlDbType.VarChar, 10000) { Value = rack.rackSerialNum }, new MySqlParameter("@rack_qrInfo", MySqlDbType.VarChar, 10000) { Value = rack.rack_qrInfo }, new MySqlParameter("@rackStatus", MySqlDbType.Int32, 10000) { Value = rack.rackStatus }, new MySqlParameter("@rack_agvSerailNum", MySqlDbType.Int32, 10000) { Value = rack.rack_agvSerailNum } }; return(MySqlHelper.ExecuteNonQuery(sql.ToString(), par) > 0 ? true : false); }
/// <summary> /// 编辑货架 /// </summary> /// <param name="rack"></param> /// <returns></returns> public bool editrack(Ga_rack rack) { return(MySqlHelper.ExecuteNonQuery("UPDATE `ga_agv`.`ga_rack` SET rackSerialNum=@rackSerialNum,rack_qrInfo=@rack_qrInfo,rackStatus=@rackStatus,rack_agvSerailNum =@rack_agvSerailNum WHERE rackId=@rackId", new MySqlParameter[] { new MySqlParameter("@rackSerialNum", MySqlDbType.VarChar, 10000) { Value = rack.rackSerialNum }, new MySqlParameter("@rack_qrInfo", MySqlDbType.VarChar, 10000) { Value = rack.rack_qrInfo }, new MySqlParameter("@rackStatus", MySqlDbType.Int32, 10000) { Value = rack.rackStatus }, new MySqlParameter("@rack_agvSerailNum", MySqlDbType.Int32, 10000) { Value = rack.rack_agvSerailNum }, new MySqlParameter("@rackId", MySqlDbType.Int32, 1000) { Value = rack.rackId } }) > 0 ? true : false); }
/// <summary> /// 删除货架 /// </summary> /// <param name="rack"></param> /// <returns></returns> public bool rackdelete(Ga_rack rack) { return(MySqlHelper.ExecuteNonQuery("DELETE FROM `ga_agv`.`ga_rack` WHERE rackId=@rackId", new MySqlParameter[] { (new MySqlParameter("@rackId", MySqlDbType.Int32, 1000) { Value = rack.rackId }) }) > 0 ? true : false); }
public JsonResult deleterack([FromBody] Ga_rack rackdata) { if (ga_RackBLL.delete(rackdata)) { return(new JsonResult() { Message = "删除成功", Success = true }); } else { return(new JsonResult() { Message = "删除失败", Success = false }); } }
/// <summary> /// 编辑货架 /// </summary> /// <param name="Rack"></param> /// <returns></returns> public JsonResult editrack([FromBody] Ga_rack rackdata) { if (ga_RackBLL.edit(rackdata)) { return(new JsonResult() { Message = "修改成功", Success = true }); } else { return(new JsonResult() { Message = "修改失败", Success = false }); } }
/// <summary> /// 添加货架 /// </summary> /// <param name="Rack"></param> /// <returns></returns> public JsonResult Rackadd([FromBody] Ga_rack Rackadd) { if (ga_RackBLL.rackadd(Rackadd)) { return(new JsonResult() { Message = "添加成功", Success = true }); } else { return(new JsonResult() { Message = "添加失败", Success = false }); } }