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