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