Example #1
0
        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);
        }
Example #2
0
        public UserFamilySexTypeListVo selectlistUserFamilySexTypeVo(UserFamilySexTypeVo userFamilySexTypeVo)
        {
            UserFamilySexTypeListVo userFamilySexTypeListVo = new UserFamilySexTypeListVo();

            using (UserFamilySexTypeService userFamilySexTypeService = new UserFamilySexTypeService())
            {
                userFamilySexTypeListVo = userFamilySexTypeService.selectlistUserFamilySexTypeVo(userFamilySexTypeVo);
            }

            return(userFamilySexTypeListVo);
        }
Example #3
0
        public UserFamilySexTypeListVo selectlistUserFamilySexTypeVo(UserFamilySexTypeVo userFamilySexTypeVo)
        {
            UserFamilySexTypeListVo userFamilySexTypeListVo = new UserFamilySexTypeListVo();

            using (UserFamilySexTypeDao userFamilySexTypeDao = new UserFamilySexTypeDao())
            {
                userFamilySexTypeListVo.userFamilySexTypeVoList = userFamilySexTypeDao.selectlistUserFamilySexTypeVo(userFamilySexTypeVo);
            }

            return(userFamilySexTypeListVo);
        }