Exemplo n.º 1
0
        private EXC001DTO GetQueryAllVal(EXC001DTO dto)
        {
            dto.Models = (
                from a in _DBManger.VSMS_EXCEL_DETAIL
                join b in _DBManger.VSMS_EXCEL on new { a.COM_CODE, a.PRG_CODE } equals new { b.COM_CODE, b.PRG_CODE }
                where ((dto.Model.COM_CODE == null || string.IsNullOrEmpty(dto.Model.COM_CODE)) || a.COM_CODE == dto.Model.COM_CODE) &&
                ((dto.Model.PRG_CODE == null || string.IsNullOrEmpty(dto.Model.PRG_CODE)) || a.PRG_CODE == dto.Model.PRG_CODE)
                orderby a.LIST_NO
                select new EXC001Model
            {
                COM_CODE = a.COM_CODE,
                PRG_CODE = a.PRG_CODE,
                COL_NAME = a.COL_NAME,
                LIST_NO = a.LIST_NO,
                COL_TYPE = a.COL_TYPE,
                RATIO = a.RATIO,
                FLG_USE = a.FLG_USE,
                ISNULL = a.ISNULL,
                FORMAT_STYLE = a.FORMAT_STYLE,
                CULTULE_STYLE = a.CULTULE_STYLE,
                CRET_BY = a.CRET_BY,
                CRET_DATE = a.CRET_DATE,
                IS_VALIDATE = a.IS_VALIDATE,
                IS_SAVE = a.IS_SAVE,
                DB_COLUMN = a.DB_COLUMN,
                MAX_LENGTH = a.MAX_LENGTH
            }).ToList();

            return(dto);
        }
Exemplo n.º 2
0
 public EXC001DA()
 {
     DTO = new EXC001DTO();
 }