public List <UserFamilyLifeSpanVo> selectlistUserFamilyLifeSpanVo(UserFamilyLifeSpanVo userFamilyLifeSpanVo)
{
List <UserFamilyLifeSpanVo> userFamilyLifeSpanVoList = new List <UserFamilyLifeSpanVo>();
using (SqlCommon sqlCommon = new SqlCommon())
{
string procedureName = "UP_USER_FAMILY_LIFE_SPAN_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)
{
UserFamilyLifeSpanVo userFamilyLifeSpanVoResult = new UserFamilyLifeSpanVo();
userFamilyLifeSpanVoResult.userFamilyLifeSpan.lifeSpan = int.Parse(dr["LIFE_SPAN"].ToString());
userFamilyLifeSpanVoList.Add(userFamilyLifeSpanVoResult);
}
}
}
return(userFamilyLifeSpanVoList);
}
public UserFamilyLifeSpanListVo selectlistUserFamilyLifeSpanVo(UserFamilyLifeSpanVo userFamilyLifeSpanVo)
{
UserFamilyLifeSpanListVo userFamilyLifeSpanListVo = new UserFamilyLifeSpanListVo();
using (UserFamilyLifeSpanService userFamilyLifeSpanService = new UserFamilyLifeSpanService())
{
userFamilyLifeSpanListVo = userFamilyLifeSpanService.selectlistUserFamilyLifeSpanVo(userFamilyLifeSpanVo);
}
return(userFamilyLifeSpanListVo);
}
public UserFamilyLifeSpanListVo selectlistUserFamilyLifeSpanVo(UserFamilyLifeSpanVo userFamilyLifeSpanVo)
{
UserFamilyLifeSpanListVo userFamilyLifeSpanListVo = new UserFamilyLifeSpanListVo();
using (UserFamilyLifeSpanDao userFamilyLifeSpanDao = new UserFamilyLifeSpanDao())
{
userFamilyLifeSpanListVo.userFamilyLifeSpanVoList = userFamilyLifeSpanDao.selectlistUserFamilyLifeSpanVo(userFamilyLifeSpanVo);
}
return(userFamilyLifeSpanListVo);
}
