public async Task <bool> Remove(RoomClean clean)
{
if (await sql.UniversalSafeNonQueryApiAsync("DELETE FROM m_room_clean WHERE roomid=@rid AND cleanerid=@cid", new[] { new SqlParameter("@cid", clean.cleaner.cleanerid), new SqlParameter("@rid", clean.room.roomid) }) <= 0)
{
return(false);
}
return(true);
}
public async Task <bool> Add(RoomClean clean)
{
if (await sql.UniversalSafeNonQueryApiAsync("INSERT INTO m_room_clean (roomid,cleanerid,wage) WHERE (@rid,@cid,@wage)", new[] {
new SqlParameter("@rid", clean.room.roomid),
new SqlParameter("@cid", clean.cleaner.cleanerid),
new SqlParameter("@wage", clean.wage)
}) <= 0)
{
return(false);
}
return(true);
}
public async Task <IActionResult> Remove([FromQuery] RoomClean cleaner)
{
if (await new CleanRoomRepo().Remove(cleaner))
{
return(Ok(new
{
message = "删除成功"
}));
}
return(BadRequest(new
{
title = "删除失败"
}));
}
public async Task <IActionResult> Add(RoomClean cleaner)
{
var data = await new CleanRoomRepo().Add(cleaner);
if (data != false)
{
return(Ok(new
{
message = "添加成功",
data
}));
}
return(BadRequest(new { title = "添加失败" }));
}
public JsonResult Save(Int64 storeId, string storeName, Int64 roomId, string roomName
, string userName)
{
RoomClean rf = new RoomClean()
{
StoreId = storeId,
StoreName = storeName,
RoomId = roomId,
RoomName = roomName,
UserName = userName,
AddTime = DateTime.Now
};
if (serviceRoom.Add(rf) > 0)
{
result.code = 1;
}
else
{
result.code = 0;
}
return(Json(result));
}
