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);
}
public UserFamilyTypeListVo selectlistUserFamilyTypeVo(UserFamilyTypeVo userFamilyTypeVo)
{
UserFamilyTypeListVo userFamilyTypeListVo = new UserFamilyTypeListVo();
using (UserFamilyTypeService userFamilyTypeService = new UserFamilyTypeService())
{
userFamilyTypeListVo = userFamilyTypeService.selectlistUserFamilyTypeVo(userFamilyTypeVo);
}
return(userFamilyTypeListVo);
}
public UserFamilyTypeListVo selectlistUserFamilyTypeVo(UserFamilyTypeVo userFamilyTypeVo)
{
UserFamilyTypeListVo userFamilyTypeListVo = new UserFamilyTypeListVo();
using (UserFamilyTypeDao userFamilyTypeDao = new UserFamilyTypeDao())
{
userFamilyTypeListVo.userFamilyTypeVolist = userFamilyTypeDao.selectlistUserFamilyTypeVo(userFamilyTypeVo);
}
return(userFamilyTypeListVo);
}