public Student UpdateSingle(int id, StudentReq data)
{
Student model = db.Student.Find(id);
SetStudent(model, data);
db.SaveChanges();
return(model);
}
/// <summary>
/// 设置model，如果不为空就设置,如果为空则和之前一样
/// </summary>
/// <param name="target"></param>
/// <param name="source"></param>
/// <returns></returns>
public Student SetStudent(Student model, StudentReq data)
{
if (!string.IsNullOrEmpty(data.Name))
{
model.Name = data.Name;
}
if (!string.IsNullOrEmpty(data.Phone))
{
model.Phone = data.Phone;
}
if (!string.IsNullOrEmpty(data.JobPosition))
{
model.JobPosition = data.JobPosition;
}
if (data.JmsId != null)
{
model.JmsId = data.JmsId.Value;
}
if (!string.IsNullOrEmpty(data.JmsName))
{
model.JmsName = data.JmsName;
}
if (data.TrainingStart != null && data.TrainingStart != DateTime.MinValue && data.TrainingStart != SqlDateTime.MinValue.Value)
{
model.TrainingStart = data.TrainingStart.Value;
}
if (data.TrainingFinish != null && data.TrainingFinish != DateTime.MinValue && data.TrainingFinish != SqlDateTime.MinValue.Value)
{
model.TrainingFinish = data.TrainingFinish.Value;
}
if (!string.IsNullOrEmpty(data.State))
{
model.State = data.State;
}
if (data.OptId != null)
{
model.OptId = data.OptId.Value;
}
if (!string.IsNullOrEmpty(data.OptName))
{
model.OptName = data.OptName;
}
if (data.CreateDate != null && data.CreateDate != DateTime.MinValue && data.CreateDate != SqlDateTime.MinValue.Value)
{
model.CreateDate = data.CreateDate.Value;
}
if (data.UpdateDate != null && data.UpdateDate != DateTime.MinValue && data.UpdateDate != SqlDateTime.MinValue.Value)
{
model.UpdateDate = data.UpdateDate.Value;
}
if (!string.IsNullOrEmpty(data.Note))
{
model.Note = data.Note;
}
return(model);
}
/// <summary>
/// 查询Student
/// </summary>
/// <param name="req"></param>
/// <returns></returns>
public SearchListResult <Student> SearchList(StudentReq req)
{
var query = from source in db.Student select source;
if (!string.IsNullOrEmpty(req.Name))
{
query = query.Where(d => d.Name.Contains(req.Name));
}
if (!string.IsNullOrEmpty(req.Phone))
{
query = query.Where(d => d.Phone.Contains(req.Phone));
}
if (!string.IsNullOrEmpty(req.JobPosition))
{
query = query.Where(d => d.JobPosition.Contains(req.JobPosition));
}
if (req.JmsId != null)
{
query = query.Where(d => d.JmsId == req.JmsId);
}
if (!string.IsNullOrEmpty(req.JmsName))
{
query = query.Where(d => d.JmsName.Contains(req.JmsName));
}
if (req.TrainingStartStart != DateTime.MinValue && req.TrainingStartStart != SqlDateTime.MinValue.Value)
{
query = query.Where(d => d.TrainingStart >= req.TrainingStartStart);
}
if (req.TrainingStartEnd != DateTime.MinValue && req.TrainingStartEnd != SqlDateTime.MinValue.Value)
{
query = query.Where(d => d.TrainingStart >= req.TrainingStartEnd);
}
if (req.TrainingFinishStart != DateTime.MinValue && req.TrainingFinishStart != SqlDateTime.MinValue.Value)
{
query = query.Where(d => d.TrainingFinish >= req.TrainingFinishStart);
}
if (req.TrainingFinishEnd != DateTime.MinValue && req.TrainingFinishEnd != SqlDateTime.MinValue.Value)
{
query = query.Where(d => d.TrainingFinish >= req.TrainingFinishEnd);
}
if (!string.IsNullOrEmpty(req.State))
{
query = query.Where(d => d.State.Contains(req.State));
}
if (req.OptId != null)
{
query = query.Where(d => d.OptId == req.OptId);
}
if (!string.IsNullOrEmpty(req.OptName))
{
query = query.Where(d => d.OptName.Contains(req.OptName));
}
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 (req.UpdateDateStart != DateTime.MinValue && req.UpdateDateStart != SqlDateTime.MinValue.Value)
{
query = query.Where(d => d.UpdateDate >= req.UpdateDateStart);
}
if (req.UpdateDateEnd != DateTime.MinValue && req.UpdateDateEnd != SqlDateTime.MinValue.Value)
{
query = query.Where(d => d.UpdateDate >= req.UpdateDateEnd);
}
if (!string.IsNullOrEmpty(req.Note))
{
query = query.Where(d => d.Note.Contains(req.Note));
}
if (string.IsNullOrEmpty(req.sidx))
{
req.sidx = "id";
req.sord = "desc";
}
SearchListResult <Student> retListResult = query.ToSearchList(req);
return(retListResult);
}