/// <summary> /// 删除数据 /// </summary> /// <param name="id"></param> /// <returns></returns> public int DeleteMsg(int id) { string sql = "delete from BookMsg where id=@id"; SqlParameter[] pars = { new SqlParameter("@id", id), }; return(SqlHelp.ExecuteNonquery(sql, CommandType.Text, pars)); }
/// <summary> /// 添加预定信息 /// </summary> /// <param name="userName"></param> /// <param name="roomNum"></param> /// <param name="tableNum"></param> /// <param name="bookTime"></param> /// <returns></returns> public int AddMsg(string userName, int roomNum, int tableNum, DateTime bookTime, DateTime startTime, DateTime endTime) { string sql = "insert int BookMsg values(@userName,@roomNum,@tableNum,@bookTime,@starTime,@endTime)"; SqlParameter[] pars = { new SqlParameter("@userName", userName), new SqlParameter("@roomNum", roomNum), new SqlParameter("@tableNum", tableNum), new SqlParameter("@bookTime", bookTime), new SqlParameter("@starTime", startTime), new SqlParameter("@endTime", endTime), }; return(SqlHelp.ExecuteNonquery(sql, CommandType.Text, pars)); }