/// <summary> /// 通过RoomId删除房间 /// </summary> public int DeleteRoomInfoByRoomId(int id) { var sql = "update RoomInfo set Delflag=1 where RoomId=" + id; return(SqliteHelper.ExecuteNonQuery(sql)); }
/// <summary> /// 添加一个中间表的数据 /// </summary> public int AddROrderDesk(R_Order_Desk rod) { var sql = "insert into R_Order_Desk(OrderId,DeskId) values(@OrderId,@DeskId)"; return(SqliteHelper.ExecuteNonQuery(sql, new SQLiteParameter("@OrderId", rod.OrderId), new SQLiteParameter("@DeskId", rod.DeskId))); }
/// <summary> /// 删除该房间 /// </summary> /// <param name="roomId"></param> /// <returns></returns> public int DeleteRoomById(int roomId) { string sql = "update RoomInfo set DelFlag=1 where RoomId=@RoomId"; return(SqliteHelper.ExecuteNonQuery(sql, new SQLiteParameter("@RoomId", roomId))); }
/// <summary> /// 通过OrderId保存订单总消费 /// </summary> public int UpdateMoneyByOrderId(int orderId, int money) { var sql = "update OrderInfo set OrderMoney=@OrderMoney where OrderId=@OrderId"; return(SqliteHelper.ExecuteNonQuery(sql, new SQLiteParameter("@OrderMoney", money), new SQLiteParameter("@OrderId", orderId))); }
/// <summary> /// 更新订单表中的金额 /// </summary> /// <param name="orderId">订单id</param> /// <returns></returns> public int UpdateOrderMoney(int orderId, decimal money) { string sql = "update OrderInfo set OrderMoney=@OrderMoney,BeginTime=SubTime where DelFlag=0 and OrderId=@OrderId"; return(SqliteHelper.ExecuteNonQuery(sql, new SQLiteParameter("@OrderId", orderId), new SQLiteParameter("@OrderMoney", money))); }
/// <summary> /// 退菜 /// </summary> /// <param name="rOrderId"></param> /// <returns></returns> public int DeleteROrderProductById(int rOrderId) { var sql = "update R_OrderInfo_Product set DelFlag=1 where ROrderProId=@ROrderProId"; return(SqliteHelper.ExecuteNonQuery(sql, new SQLiteParameter("@ROrderProId", rOrderId))); }