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);
}
