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); }
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); }