Ejemplo n.º 1
0
 private SECS01P002DTO GetByID(SECS01P002DTO dto)
 {
     dto.Model = _DBManger.VSMS_CONFIG_GENERAL
                 .Where(m => m.NAME == dto.Model.NAME)
                 .FirstOrDefault().ToNewObject(new SECS01P002Model());
     return(dto);
 }
Ejemplo n.º 2
0
        private SECS01P002DTO GetSystemDetail(SECS01P002DTO dto)
        {
            var cmd        = @"select t1.SYS_CODE,
                               t1.SYS_NAME_TH,
                               t1.SYS_NAME_EN,
                               case
                                 when t2.SYS_CODE is not null then
                                  1
                                 else
                                  0
                               end SELECTED,
	                           ROW_NUMBER() OVER(order by SYS_NAME_EN,SYS_NAME_TH) ROW_NO
                          from VSMS_SYSTEM t1
                          left join (select * from VSMS_CONFIG_GENERAL where NAME = @NAME) t2
                            on t1.COM_CODE = t2.COM_CODE
                           and t1.SYS_CODE = t2.SYS_CODE
                           order by SYS_NAME_EN,SYS_NAME_TH
                        ";
            var parameters = CreateParameter();

            parameters.AddParameter("NAME", dto.Model.NAME);
            var result = _DBMangerNoEF.ExecuteDataSet(cmd, parameters, CommandType.Text);

            if (result.Success(dto))
            {
                dto.Model.SystemModels = result.OutputDataSet.Tables[0].ToList <SECS01P002_SystemModel>();
            }
            return(dto);
        }
Ejemplo n.º 3
0
 private SECS01P002DTO GetAll(SECS01P002DTO dto)
 {
     dto.Models = _DBManger.VSMS_CONFIG_GENERAL
                  .Where(m => ((dto.Model.NAME == null || dto.Model.NAME == string.Empty) || m.NAME.Contains(dto.Model.NAME)))
                  .OrderBy(m => new { m.NAME })
                  .Select(m => new
     {
         NAME     = m.NAME,
         SEQUENCE = m.SEQUENCE
     }).Distinct().Select(m => new SECS01P002Model {
         NAME = m.NAME, SEQUENCE = m.SEQUENCE
     }).ToList();
     return(dto);
 }
Ejemplo n.º 4
0
 public SECS01P002DA()
 {
     DTO = new SECS01P002DTO();
 }