} //users Edit
public string Edit(Model.Machine machine)
{
string sqlStr = "update Machine set seatID=@seatID,device=@device,state=@state,useInfo=@useInfo where roomID=@roomID";
SqlParameter[] paras = new SqlParameter[] {
new SqlParameter("@roomID", machine.RoomID),
new SqlParameter("@seatID", machine.SeatID),
new SqlParameter("@device", machine.State),
new SqlParameter("@state", machine.State),
new SqlParameter("@useInfo", machine.UseInfo)
};
if (userDao.Edit(sqlStr, paras))
{
return("Success");
}
else
{
return("Fail");
}
} //machine Edit
} //Delete
public string Insert(Model.Machine machine)
{
string sqlStr = "insert into Machine(roomID,seatID,device,state,useInfo) values(@roomID,@seatID,@device,@state,@useInfo)";
SqlParameter[] paras = new SqlParameter[] {
new SqlParameter("@roomID", machine.RoomID),
new SqlParameter("@seatID", machine.SeatID),
new SqlParameter("@device", machine.State),
new SqlParameter("@state", machine.State),
new SqlParameter("@useInfo", machine.UseInfo)
};
if (userDao.Insert(sqlStr, paras))
{
return("Success");
}
else
{
return("Fail");
}
} //machine Insert
