Example #1
0
        public List <UserFamilyRetirementAgeVo> selectlistUserFamilyRetirementAgeVo(UserFamilyRetirementAgeVo userFamilyRetirementAgeVo)
        {
            List <UserFamilyRetirementAgeVo> userFamilyRetirementAgeVoList = new List <UserFamilyRetirementAgeVo>();

            using (SqlCommon sqlCommon = new SqlCommon())
            {
                string procedureName = "UP_USER_FAMILY_RETIREMENT_AGE_LIST";

                DataSet ds = sqlCommon.ExecuteProcedure(procedureName, null);

                if ((ds != null) &&
                    (ds.Tables != null) && (ds.Tables[0] != null) &&
                    (ds.Tables[0].Rows.Count > 0) && (ds.Tables[0].Rows[0] != null))
                {
                    foreach (DataRow dr in ds.Tables[0].Rows)
                    {
                        UserFamilyRetirementAgeVo userFamilyRetirementAgeVoResult = new UserFamilyRetirementAgeVo();

                        userFamilyRetirementAgeVoResult.userFamilyRetirementAge.retirementAge = int.Parse(dr["RETIREMENT_AGE"].ToString());

                        userFamilyRetirementAgeVoList.Add(userFamilyRetirementAgeVoResult);
                    }
                }
            }

            return(userFamilyRetirementAgeVoList);
        }
Example #2
0
        public UserFamilyRetirementAgeListVo selectlistUserFamilyRetirementAgeVo(UserFamilyRetirementAgeVo userFamilyRetirementAgeVo)
        {
            UserFamilyRetirementAgeListVo userFamilyRetirementAgeListVo = new UserFamilyRetirementAgeListVo();

            using (UserFamilyRetirementAgeService userFamilyRetirementAgeService = new UserFamilyRetirementAgeService())
            {
                userFamilyRetirementAgeListVo = userFamilyRetirementAgeService.selectlistUserFamilyRetirementAgeVo(userFamilyRetirementAgeVo);
            }

            return(userFamilyRetirementAgeListVo);
        }
        public UserFamilyRetirementAgeListVo selectlistUserFamilyRetirementAgeVo(UserFamilyRetirementAgeVo userFamilyRetirementAgeVo)
        {
            UserFamilyRetirementAgeListVo userFamilyRetirementAgeListVo = new UserFamilyRetirementAgeListVo();

            using (UserFamilyRetirementAgeDao userFamilyRetirementAgeDao = new UserFamilyRetirementAgeDao())
            {
                userFamilyRetirementAgeListVo.userFamilyRetirementAgeVoList = userFamilyRetirementAgeDao.selectlistUserFamilyRetirementAgeVo(userFamilyRetirementAgeVo);
            }

            return(userFamilyRetirementAgeListVo);
        }