Exemple #1
0
        public List <UserFamilyTypeVo> selectlistUserFamilyTypeVo(UserFamilyTypeVo userFamilyTypeVo)
        {
            List <UserFamilyTypeVo> userFamilyTypeVoList = new List <UserFamilyTypeVo>();

            using (SqlCommon sqlCommon = new SqlCommon())
            {
                string procedureName = "UP_USER_FAMILY_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)
                    {
                        UserFamilyTypeVo userFamilyTypeVoResult = new UserFamilyTypeVo();

                        userFamilyTypeVoResult.userFamilyType.userFamilyTypeNo = int.Parse(dr["USER_FAMILY_TYPE_NO"].ToString());
                        userFamilyTypeVoResult.userFamilyType.userFamilyTypeNm = dr["USER_FAMILY_TYPE_NM"].ToString();

                        userFamilyTypeVoList.Add(userFamilyTypeVoResult);
                    }
                }
            }

            return(userFamilyTypeVoList);
        }
Exemple #2
0
        public UserFamilyTypeListVo selectlistUserFamilyTypeVo(UserFamilyTypeVo userFamilyTypeVo)
        {
            UserFamilyTypeListVo userFamilyTypeListVo = new UserFamilyTypeListVo();

            using (UserFamilyTypeService userFamilyTypeService = new UserFamilyTypeService())
            {
                userFamilyTypeListVo = userFamilyTypeService.selectlistUserFamilyTypeVo(userFamilyTypeVo);
            }

            return(userFamilyTypeListVo);
        }
Exemple #3
0
        public UserFamilyTypeListVo selectlistUserFamilyTypeVo(UserFamilyTypeVo userFamilyTypeVo)
        {
            UserFamilyTypeListVo userFamilyTypeListVo = new UserFamilyTypeListVo();

            using (UserFamilyTypeDao userFamilyTypeDao = new UserFamilyTypeDao())
            {
                userFamilyTypeListVo.userFamilyTypeVolist = userFamilyTypeDao.selectlistUserFamilyTypeVo(userFamilyTypeVo);
            }

            return(userFamilyTypeListVo);
        }