public List <UserFamilySexTypeVo> selectlistUserFamilySexTypeVo(UserFamilySexTypeVo userFamilySexTypeVo) { List <UserFamilySexTypeVo> userFamilySexTypeVoList = new List <UserFamilySexTypeVo>(); using (SqlCommon sqlCommon = new SqlCommon()) { string procedureName = "UP_USER_FAMILY_SEX_TYPE_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) { UserFamilySexTypeVo userFamilySexTypeVoResult = new UserFamilySexTypeVo(); userFamilySexTypeVoResult.userFamilySexType.sexTypeNo = int.Parse(dr["SEX_TYPE_NO"].ToString()); userFamilySexTypeVoResult.userFamilySexType.sexTypeNm = dr["SEX_TYPE_NM"].ToString(); userFamilySexTypeVoList.Add(userFamilySexTypeVoResult); } } } return(userFamilySexTypeVoList); }
public UserFamilySexTypeListVo selectlistUserFamilySexTypeVo(UserFamilySexTypeVo userFamilySexTypeVo) { UserFamilySexTypeListVo userFamilySexTypeListVo = new UserFamilySexTypeListVo(); using (UserFamilySexTypeService userFamilySexTypeService = new UserFamilySexTypeService()) { userFamilySexTypeListVo = userFamilySexTypeService.selectlistUserFamilySexTypeVo(userFamilySexTypeVo); } return(userFamilySexTypeListVo); }
public UserFamilySexTypeListVo selectlistUserFamilySexTypeVo(UserFamilySexTypeVo userFamilySexTypeVo) { UserFamilySexTypeListVo userFamilySexTypeListVo = new UserFamilySexTypeListVo(); using (UserFamilySexTypeDao userFamilySexTypeDao = new UserFamilySexTypeDao()) { userFamilySexTypeListVo.userFamilySexTypeVoList = userFamilySexTypeDao.selectlistUserFamilySexTypeVo(userFamilySexTypeVo); } return(userFamilySexTypeListVo); }