public static int UpdateRoomInfoDataAccess(RoomTask roomTask) { var sql = $"update {TABLENAME} set roomstate = '{roomTask.RoomState}', roomconsume = '{roomTask.RoomConsume}'," + $" starttime = '{roomTask.StartTime}', endtime = '{roomTask.EndTime}', customerid = '{roomTask.CustomerId}'" + $" where roomid = '{roomTask.RoomId}'"; return(SqlServerHelper.ExecuteNonQuery(CommandType.Text, sql, 30, null)); }
/// <summary> /// 获取当前时间房间单价 /// </summary> /// <param name="roomTask"></param> /// <returns></returns> public static int GetAccentRoomConsumeDataAccess(RoomTask roomTask) { if (roomTask.StartTime == null || roomTask.EndTime == null) { return(0); } //获取单价 var sql = $"select roomprice from roompriceinfo where roomtype in (select roomtype from roominfo where roomid = '{roomTask.RoomId}' and starttime <= {roomTask.StartTime.Hour} and endtime > {roomTask.StartTime.Hour})"; int price = int.Parse(SqlServerHelper.GetDataFromKtvdb(sql).Rows[0][0].ToString()); int hours = (int)((roomTask.EndTime - roomTask.StartTime).TotalHours + 0.1); return(hours * price); }
public int AddConsumeLog(RoomTask roomTask) { return(RoomTaskManagementDataAccess.AddConsumeLogDataAccess(roomTask)); }
public int GetAccentRoomConsume(RoomTask roomTask) { return(RoomTaskManagementDataAccess.GetAccentRoomConsumeDataAccess(roomTask)); }
int IRoomTaskManagement.UpdateRoomInfo(RoomTask roomTask) { return(RoomTaskManagementDataAccess.UpdateRoomInfoDataAccess(roomTask)); }
/// <summary> /// 添加流水日志 /// </summary> /// <param name="roomTask"></param> /// <returns></returns> public static int AddConsumeLogDataAccess(RoomTask roomTask) { var sql = $"insert into {CONSUMELOGTABLENAME}({CONSUMELOGFIELDNAME}) values('{roomTask.RoomId}', '{roomTask.CustomerId}', '{roomTask.RoomConsume}', '{roomTask.StartTime}', '{roomTask.EndTime}')"; return(SqlServerHelper.ExecuteNonQuery(CommandType.Text, sql, 30, null)); }