public RoomCheckIn UpdateSingle(int id, RoomCheckInReq data)
{
RoomCheckIn model = db.RoomCheckIn.Find(id);
SetRoomCheckIn(model, data);
db.SaveChanges();
return(model);
}
/// <summary>
/// 设置model，如果不为空就设置,如果为空则和之前一样
/// </summary>
/// <param name="target"></param>
/// <param name="source"></param>
/// <returns></returns>
public RoomCheckIn SetRoomCheckIn(RoomCheckIn model, RoomCheckInReq data)
{
if (data.RoomId != null)
{
model.RoomId = data.RoomId.Value;
}
if (data.StartDate != null && data.StartDate != DateTime.MinValue &&
data.StartDate != SqlDateTime.MinValue.Value)
{
model.StartDate = data.StartDate.Value;
}
if (data.EndDate != null && data.EndDate != DateTime.MinValue && data.EndDate != SqlDateTime.MinValue.Value)
{
model.EndDate = data.EndDate.Value;
}
if (!string.IsNullOrEmpty(data.State))
{
model.State = data.State;
}
if (data.KeHuId != null)
{
model.KeHuId = data.KeHuId.Value;
}
if (!string.IsNullOrEmpty(data.KeHuName))
{
model.KeHuName = data.KeHuName;
}
if (!string.IsNullOrEmpty(data.RoomDesc))
{
model.RoomDesc = data.RoomDesc;
}
if (!string.IsNullOrEmpty(data.OptName))
{
model.OptName = data.OptName;
}
if (data.OptId != null)
{
model.OptId = data.OptId.Value;
}
if (data.CreateDate != null && data.CreateDate != DateTime.MinValue &&
data.CreateDate != SqlDateTime.MinValue.Value)
{
model.CreateDate = data.CreateDate.Value;
}
if (!string.IsNullOrEmpty(data.Remark))
{
model.Remark = data.Remark;
}
if (data.FloorId != null)
{
model.FloorId = data.FloorId.Value;
}
if (!string.IsNullOrEmpty(data.SwitchRoomTag))
{
model.SwitchRoomTag = data.SwitchRoomTag;
}
if (data.PreRoomCheckInId != null)
{
model.PreRoomCheckInId = data.PreRoomCheckInId.Value;
}
if (data.InitialHeTongId != null)
{
model.InitialHeTongId = data.InitialHeTongId.Value;
}
if (!string.IsNullOrEmpty(data.SwitchRoomDesc))
{
model.SwitchRoomDesc = data.SwitchRoomDesc;
}
return(model);
}
/// <summary>
/// 查询RoomCheckIn
/// </summary>
/// <param name="req"></param>
/// <returns></returns>
public SearchListResult <RoomCheckIn> SearchList(RoomCheckInReq req)
{
var query = from source in db.RoomCheckIn select source;
if (req.RoomId != null)
{
query = query.Where(d => d.RoomId == req.RoomId);
}
if (req.StartDateStart != DateTime.MinValue && req.StartDateStart != SqlDateTime.MinValue.Value)
{
query = query.Where(d => d.StartDate >= req.StartDateStart);
}
if (req.StartDateEnd != DateTime.MinValue && req.StartDateEnd != SqlDateTime.MinValue.Value)
{
query = query.Where(d => d.StartDate >= req.StartDateEnd);
}
if (req.EndDateStart != DateTime.MinValue && req.EndDateStart != SqlDateTime.MinValue.Value)
{
query = query.Where(d => d.EndDate >= req.EndDateStart);
}
if (req.EndDateEnd != DateTime.MinValue && req.EndDateEnd != SqlDateTime.MinValue.Value)
{
query = query.Where(d => d.EndDate >= req.EndDateEnd);
}
if (!string.IsNullOrEmpty(req.State))
{
query = query.Where(d => d.State.Contains(req.State));
}
if (req.KeHuId != null)
{
query = query.Where(d => d.KeHuId == req.KeHuId);
}
if (!string.IsNullOrEmpty(req.KeHuName))
{
query = query.Where(d => d.KeHuName.Contains(req.KeHuName));
}
if (!string.IsNullOrEmpty(req.RoomDesc))
{
query = query.Where(d => d.RoomDesc.Contains(req.RoomDesc));
}
if (!string.IsNullOrEmpty(req.OptName))
{
query = query.Where(d => d.OptName.Contains(req.OptName));
}
if (req.OptId != null)
{
query = query.Where(d => d.OptId == req.OptId);
}
if (req.CreateDateStart != DateTime.MinValue && req.CreateDateStart != SqlDateTime.MinValue.Value)
{
query = query.Where(d => d.CreateDate >= req.CreateDateStart);
}
if (req.CreateDateEnd != DateTime.MinValue && req.CreateDateEnd != SqlDateTime.MinValue.Value)
{
query = query.Where(d => d.CreateDate >= req.CreateDateEnd);
}
if (!string.IsNullOrEmpty(req.Remark))
{
query = query.Where(d => d.Remark.Contains(req.Remark));
}
if (req.FloorId != null)
{
query = query.Where(d => d.FloorId == req.FloorId);
}
if (!string.IsNullOrEmpty(req.SwitchRoomDesc))
{
query = query.Where(d => d.SwitchRoomDesc.Contains(req.SwitchRoomDesc));
}
if (string.IsNullOrEmpty(req.sidx))
{
req.sidx = "id";
req.sord = "desc";
}
SearchListResult <RoomCheckIn> retListResult = query.ToSearchList(req);
return(retListResult);
}
