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