public IModelResult <IndexVM> SelectStudent(IndexVM vm = null)
{
IModelResult <IndexVM> modelResult;
try
{
doEventLog($"查詢資料:input=>{JsonConvert.SerializeObject(vm)}");
doLog($"查詢資料:input=>{JsonConvert.SerializeObject(vm)}");
selectStudentModel = null;
if (vm != null)
{
selectStudentModel = AutoMapper.Mapper.Map <SelectStudentDaoReqModel>(vm);
}
dao = GetDao();
IModelResult <IList <SelectStudentDaoResModel> > dbResult = dao.StudentSelect(selectStudentModel);
if (dbResult.IsOk)
{
modelResult = new ModelResult <IndexVM>();
if (dbResult.ResultData.Any())
{
modelResult.ResultData = new IndexVM();
modelResult.ResultData.lstStudentInfo = dbResult.ResultData.Select(x =>
{
IndexStudentItem item = AutoMapper.Mapper.Map <IndexStudentItem>(x);
return(item);
}).ToList();
}
else
{
modelResult.ResultData = new IndexVM();
}
}
else
{
modelResult = new ModelResult <IndexVM>(dbResult.ErrorCode.Value)
{
SystemMessage = dbResult.SystemMessage
};
}
doEventLog($"查詢結果:input=>{JsonConvert.SerializeObject(vm)},result=>{JsonConvert.SerializeObject(modelResult)}");
doLog($"查詢結果:input=>{JsonConvert.SerializeObject(vm)},result=>{JsonConvert.SerializeObject(modelResult)}");
}
catch (Exception ex)
{
modelResult = new ModelResult <IndexVM>(SystemCodes.Codes.ApplicationError01)
{
SystemMessage = ex.Message
};
}
return(modelResult);
}
/// <summary>
/// 查詢學生資料
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public IModelResult <IList <SelectStudentDaoResModel> > StudentSelect(SelectStudentDaoReqModel model = null)
{
IModelResult <IList <SelectStudentDaoResModel> > modelResult;
try
{
IEnumerable <Student> dbModel = entities.Student;
if (model != null)
{
if (!string.IsNullOrEmpty(model.studentId))
{
dbModel = dbModel.Where(x => x.studentId.Equals(model.studentId));
}
if (!string.IsNullOrEmpty(model.studentName))
{
dbModel = dbModel.Where(x => x.studentName.Contains(model.studentName));
}
}
//實際查詢
dbModel = dbModel.ToList();
if (dbModel.Any())
{
IList <SelectStudentDaoResModel> dbResult = dbModel.Select(x =>
{
SelectStudentDaoResModel item = AutoMapper.Mapper.Map <SelectStudentDaoResModel>(x);
return(item);
}).ToList();
modelResult = new ModelResult <IList <SelectStudentDaoResModel> >()
{
ResultData = dbResult
};
}
else
{
modelResult = new ModelResult <IList <SelectStudentDaoResModel> >()
{
ResultData = new List <SelectStudentDaoResModel>()
};
}
}
catch (Exception ex)
{
modelResult = new ModelResult <IList <SelectStudentDaoResModel> >(SystemCodes.Codes.DBError)
{
SystemMessage = ex.Message
};
}
return(modelResult);
}
