public List <UserFamilyJobTypeVo> selectlistUserFamilyJobTypeVo(UserFamilyJobTypeVo userFamilyJobTypeVo)
{
List <UserFamilyJobTypeVo> userFamilyJobTypeVoList = new List <UserFamilyJobTypeVo>();
using (SqlCommon sqlCommon = new SqlCommon())
{
string procedureName = "UP_USER_FAMILY_JOB_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)
{
UserFamilyJobTypeVo userFamilyJobTypeVoResult = new UserFamilyJobTypeVo();
userFamilyJobTypeVoResult.userFamilyJobType.jobTypeNo = int.Parse(dr["JOB_TYPE_NO"].ToString());
userFamilyJobTypeVoResult.userFamilyJobType.jobTypeNm = dr["JOB_TYPE_NM"].ToString();
userFamilyJobTypeVoList.Add(userFamilyJobTypeVoResult);
}
}
}
return(userFamilyJobTypeVoList);
}
public UserFamilyJobTypeListVo selectlistUserFamilyJobTypeVo(UserFamilyJobTypeVo userFamilyJobTypeVo)
{
UserFamilyJobTypeListVo userFamilyJobTypeListVo = new UserFamilyJobTypeListVo();
using (UserFamilyJobTypeService userFamilyJobTypeService = new UserFamilyJobTypeService())
{
userFamilyJobTypeListVo = userFamilyJobTypeService.selectlistUserFamilyJobTypeVo(userFamilyJobTypeVo);
}
return(userFamilyJobTypeListVo);
}
public UserFamilyJobTypeListVo selectlistUserFamilyJobTypeVo(UserFamilyJobTypeVo userFamilyJobTypeVo)
{
UserFamilyJobTypeListVo userFamilyJobTypeListVo = new UserFamilyJobTypeListVo();
using (UserFamilyJobTypeDao userFamilyJobTypeDao = new UserFamilyJobTypeDao())
{
userFamilyJobTypeListVo.userFamilyJobTypeVoList = userFamilyJobTypeDao.selectlistUserFamilyJobTypeVo(userFamilyJobTypeVo);
}
return(userFamilyJobTypeListVo);
}
