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