private SEC001P001DTO GetByID(SEC001P001DTO dto) { dto.Model = _DBManger.VSMS_CTRLLOG .Where(m => m.TBL_NAME == dto.Model.TBL_NAME) .FirstOrDefault().ToNewObject(new SEC001P001Model()); dto.Model.TBL_NAME = dto.Model.TBL_NAME; return(dto); }
private SEC001P001DTO GetAll(SEC001P001DTO dto) { dto.Models = _DBManger.VSMS_CTRLLOG .Where((m => ((dto.Model.TBL_NAME == null || dto.Model.TBL_NAME == string.Empty) || m.TBL_NAME.Contains(dto.Model.TBL_NAME)) && ((dto.Model.TBL_TYPE == null || dto.Model.TBL_TYPE == string.Empty) || m.TBL_TYPE.Contains(dto.Model.TBL_TYPE)) && ((dto.Model.LOG_STATUS == null || dto.Model.LOG_STATUS == string.Empty) || m.LOG_STATUS.Contains(dto.Model.LOG_STATUS)) )) //.OrderBy(m => new { m.COM_CODE, m.COM_CODE }) .Select(m => new SEC001P001Model { COM_CODE = m.COM_CODE, TBL_NAME = m.TBL_NAME, TBL_TYPE = m.TBL_TYPE, LOG_STATUS = m.LOG_STATUS }).ToList(); return(dto); }
public SEC001P001DA() { DTO = new SEC001P001DTO(); }