public List <UserFamilyLifeSpanVo> selectlistUserFamilyLifeSpanVo(UserFamilyLifeSpanVo userFamilyLifeSpanVo) { List <UserFamilyLifeSpanVo> userFamilyLifeSpanVoList = new List <UserFamilyLifeSpanVo>(); using (SqlCommon sqlCommon = new SqlCommon()) { string procedureName = "UP_USER_FAMILY_LIFE_SPAN_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) { UserFamilyLifeSpanVo userFamilyLifeSpanVoResult = new UserFamilyLifeSpanVo(); userFamilyLifeSpanVoResult.userFamilyLifeSpan.lifeSpan = int.Parse(dr["LIFE_SPAN"].ToString()); userFamilyLifeSpanVoList.Add(userFamilyLifeSpanVoResult); } } } return(userFamilyLifeSpanVoList); }
public UserFamilyLifeSpanListVo selectlistUserFamilyLifeSpanVo(UserFamilyLifeSpanVo userFamilyLifeSpanVo) { UserFamilyLifeSpanListVo userFamilyLifeSpanListVo = new UserFamilyLifeSpanListVo(); using (UserFamilyLifeSpanService userFamilyLifeSpanService = new UserFamilyLifeSpanService()) { userFamilyLifeSpanListVo = userFamilyLifeSpanService.selectlistUserFamilyLifeSpanVo(userFamilyLifeSpanVo); } return(userFamilyLifeSpanListVo); }
public UserFamilyLifeSpanListVo selectlistUserFamilyLifeSpanVo(UserFamilyLifeSpanVo userFamilyLifeSpanVo) { UserFamilyLifeSpanListVo userFamilyLifeSpanListVo = new UserFamilyLifeSpanListVo(); using (UserFamilyLifeSpanDao userFamilyLifeSpanDao = new UserFamilyLifeSpanDao()) { userFamilyLifeSpanListVo.userFamilyLifeSpanVoList = userFamilyLifeSpanDao.selectlistUserFamilyLifeSpanVo(userFamilyLifeSpanVo); } return(userFamilyLifeSpanListVo); }