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 List <UserFamilyBirthYearVo> selectlistUserFamilyTypeVo(UserFamilyBirthYearVo userFamilyBirthYearVo)
{
List <UserFamilyBirthYearVo> userFamilyBirthYearVoList = new List <UserFamilyBirthYearVo>();
using (SqlCommon sqlCommon = new SqlCommon())
{
string procedureName = "UP_USER_FAMILY_BIRTH_YEAR_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)
{
UserFamilyBirthYearVo userFamilyBirthYearVoResult = new UserFamilyBirthYearVo();
userFamilyBirthYearVoResult.userFamilyBirthYear.birthYear = int.Parse(dr["BIRTH_YEAR"].ToString());
if ((dr["DEFAULT_VAL"] != null) && (dr["DEFAULT_VAL"].ToString() == "Y"))
{
userFamilyBirthYearVoResult.userFamilyBirthYear.defaultVal = true;
}
userFamilyBirthYearVoList.Add(userFamilyBirthYearVoResult);
}
}
}
return(userFamilyBirthYearVoList);
}
public UserVo selectUserVo(UserVo UserVo)
{
UserVo userVo = new UserVo();
using (SqlCommon sqlCommon = new SqlCommon())
{
string procedureName = "UP_USER_SELECT";
List <SqlParameter> sqlParameters = new List <SqlParameter>();
sqlParameters.Add(new SqlParameter("@USER_ID", UserVo.user.userId));
sqlParameters.Add(new SqlParameter("@PWD", UserVo.user.pwd));
DataSet ds = sqlCommon.ExecuteProcedure(procedureName, sqlParameters);
if ((ds != null) &&
(ds.Tables != null) && (ds.Tables[0] != null) &&
(ds.Tables[0].Rows.Count > 0) && (ds.Tables[0].Rows[0] != null))
{
userVo.user.userId = ds.Tables[0].Rows[0]["USER_ID"].ToString();
userVo.user.userNm = ds.Tables[0].Rows[0]["USER_NM"].ToString();
userVo.user.userGradeNo = ds.Tables[0].Rows[0]["USER_GRADE_NO"].ToString();
userVo.userGrade.userGradeNo = ds.Tables[0].Rows[0]["USER_GRADE_NO"].ToString();
userVo.userGrade.userGradeNm = ds.Tables[0].Rows[0]["USER_GRADE_NM"].ToString();
}
}
return(userVo);
}
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 List <UserFamilyRetirementAgeVo> selectlistUserFamilyRetirementAgeVo(UserFamilyRetirementAgeVo userFamilyRetirementAgeVo)
{
List <UserFamilyRetirementAgeVo> userFamilyRetirementAgeVoList = new List <UserFamilyRetirementAgeVo>();
using (SqlCommon sqlCommon = new SqlCommon())
{
string procedureName = "UP_USER_FAMILY_RETIREMENT_AGE_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)
{
UserFamilyRetirementAgeVo userFamilyRetirementAgeVoResult = new UserFamilyRetirementAgeVo();
userFamilyRetirementAgeVoResult.userFamilyRetirementAge.retirementAge = int.Parse(dr["RETIREMENT_AGE"].ToString());
userFamilyRetirementAgeVoList.Add(userFamilyRetirementAgeVoResult);
}
}
}
return(userFamilyRetirementAgeVoList);
}
/// <summary>
/// 구성Vo조회
/// </summary>
/// <param name="configurationVo">구성Vo</param>
/// <returns>구성Vo</returns>
public ConfigurationVo selectConfigurationVo(ConfigurationVo configurationVo)
{
ConfigurationVo rtnConfigurationVo = new ConfigurationVo();
using (SqlCommon sqlCommon = new SqlCommon())
{
string procedureName = "UP_CONFIGURATION_SELECT";
List <SqlParameter> sqlParameters = new List <SqlParameter>();
sqlParameters.Add(new SqlParameter("@CONFIGURATION_ID", configurationVo.configuration.configurationId));
DataSet ds = sqlCommon.ExecuteProcedure(procedureName, sqlParameters);
if ((ds != null) &&
(ds.Tables != null) && (ds.Tables[0] != null) &&
(ds.Tables[0].Rows.Count > 0) && (ds.Tables[0].Rows[0] != null))
{
rtnConfigurationVo.configuration.configurationId = ds.Tables[0].Rows[0]["CONFIGURATION_ID"].ToString();
rtnConfigurationVo.configuration.configurationNm = ds.Tables[0].Rows[0]["CONFIGURATION_NM"].ToString();
rtnConfigurationVo.configuration.configurationVal = ds.Tables[0].Rows[0]["CONFIGURATION_VAL"].ToString();
rtnConfigurationVo.configuration.configurationUsed = bool.Parse(ds.Tables[0].Rows[0]["CONFIGURATION_USED"].ToString());
rtnConfigurationVo.configuration.configurationSubgroupNo = int.Parse(ds.Tables[0].Rows[0]["CONFIGURATION_SUBGROUP_NO"].ToString());
}
}
return(rtnConfigurationVo);
}
/// <summary>
/// 사용자가족Vo추가
/// </summary>
/// <param name="userFamilyVo">사용자가족Vo</param>
/// <returns>사용자가족Vo</returns>
public void insertUserFamilyVo(UserFamilyVo userFamilyVo)
{
using (SqlCommon sqlCommon = new SqlCommon())
{
string procedureName = "UP_USER_FAMILY_INSERT";
List <SqlParameter> sqlParameters = new List <SqlParameter>();
sqlParameters.Add(new SqlParameter("@USER_ID", userFamilyVo.userFamily.userId));
sqlParameters.Add(new SqlParameter("@USER_FAMILY_TYPE_NO", userFamilyVo.userFamily.userFamilyTypeNo));
sqlParameters.Add(new SqlParameter("@USER_FAMILY_NM", userFamilyVo.userFamily.userFamilyNm));
sqlParameters.Add(new SqlParameter("@BIRTH_YEAR", userFamilyVo.userFamily.birthYear));
sqlParameters.Add(new SqlParameter("@SEX_TYPE_NO", userFamilyVo.userFamily.sexTypeNo));
sqlParameters.Add(new SqlParameter("@JOB_TYPE_NO", userFamilyVo.userFamily.jobTypeNo));
if (userFamilyVo.userFamily.retirementAge != null)
{
sqlParameters.Add(new SqlParameter("@RETIREMENT_AGE", userFamilyVo.userFamily.retirementAge));
}
if (userFamilyVo.userFamily.lifeSpan != null)
{
sqlParameters.Add(new SqlParameter("@LIFE_SPAN", userFamilyVo.userFamily.lifeSpan));
}
sqlCommon.ExecuteProcedure(procedureName, sqlParameters);
}
}
public void deleteUserVo(UserVo userVo)
{
using (SqlCommon sqlCommon = new SqlCommon())
{
string procedureName = "UP_USER_DELETE";
List <SqlParameter> sqlParameters = new List <SqlParameter>();
sqlParameters.Add(new SqlParameter("@USER_ID", userVo.user.userId));
DataSet ds = sqlCommon.ExecuteProcedure(procedureName, sqlParameters);
}
}
/// <summary>
/// 사용자가족Vo삭제
/// </summary>
/// <param name="userFamilyVo">사용자가족Vo</param>
public void deleteUserFamilyVo(UserFamilyVo userFamilyVo)
{
using (SqlCommon sqlCommon = new SqlCommon())
{
string procedureName = "UP_USER_FAMILY_DELETE";
List <SqlParameter> sqlParameters = new List <SqlParameter>();
sqlParameters.Add(new SqlParameter("@USER_FAMILY_NO", userFamilyVo.userFamily.userFamilyNo));
sqlCommon.ExecuteProcedure(procedureName, sqlParameters);
}
}
/// <summary>
/// 사용자재무Vo수정
/// </summary>
/// <param name="userFamilyVo">사용자재무Vo</param>
public void updateUserFinanceVo(UserFinanceVo userFinanceVo)
{
using (SqlCommon sqlCommon = new SqlCommon())
{
string procedureName = "UP_USER_FINANCE_UPDATE";
List <SqlParameter> sqlParameters = new List <SqlParameter>();
sqlParameters.Add(new SqlParameter("@USER_ID", userFinanceVo.userFinance.userId));
sqlParameters.Add(new SqlParameter("@USER_FINANCE_CATALOG_ID", userFinanceVo.userFinance.userFinanceCatalogId));
sqlParameters.Add(new SqlParameter("@PRICE", userFinanceVo.userFinance.price));
sqlCommon.ExecuteProcedure(procedureName, sqlParameters);
}
}
public void updateUserVo(UserVo userVo)
{
using (SqlCommon sqlCommon = new SqlCommon())
{
string procedureName = "UP_USER_UPDATE";
List <SqlParameter> sqlParameters = new List <SqlParameter>();
sqlParameters.Add(new SqlParameter("@USER_ID", userVo.user.userId));
sqlParameters.Add(new SqlParameter("@USER_NM", userVo.user.userNm));
sqlParameters.Add(new SqlParameter("@USER_GRADE_NO", userVo.user.userGradeNo));
DataSet ds = sqlCommon.ExecuteProcedure(procedureName, sqlParameters);
}
}
public List <SurveyCatalogVo> listSurveyCatalogVo(SurveyCatalogVo surveyCatalogVo)
{
List <SurveyCatalogVo> surveyCatalogVoList = new List <SurveyCatalogVo>();
using (SqlCommon sqlCommon = new SqlCommon())
{
string procedureName = "UP_SURVEY_CATALOG_LIST";
List <SqlParameter> sqlParameters = new List <SqlParameter>();
sqlParameters.Add(new SqlParameter("@SURVEY_CATALOG_GROUP_NO", surveyCatalogVo.surveyCatalog.surveyCatalogGroupNo));
DataSet ds = sqlCommon.ExecuteProcedure(procedureName, sqlParameters);
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)
{
SurveyCatalogVo surveyCatalogVoResult = new SurveyCatalogVo();
surveyCatalogVoResult.surveyCatalog.surveyCatalogNo = int.Parse(dr["SURVEY_CATALOG_NO"].ToString());
surveyCatalogVoResult.surveyCatalog.surveyCatalogGroupNo = int.Parse(dr["SURVEY_CATALOG_GROUP_NO"].ToString());
surveyCatalogVoResult.surveyCatalogGroup.surveyCatalogGroupNo = int.Parse(dr["SURVEY_CATALOG_GROUP_NO"].ToString());
surveyCatalogVoResult.surveyCatalogGroup.surveyCatalogGroupName = dr["SURVEY_CATALOG_GROUP_NAME"].ToString();
surveyCatalogVoResult.surveyCatalog.surveyCatalogQuestionNo = int.Parse(dr["SURVEY_CATALOG_QUESTION_NO"].ToString());
surveyCatalogVoResult.surveyCatalogQuestion.surveyCatalogQuestionNo = int.Parse(dr["SURVEY_CATALOG_QUESTION_NO"].ToString());
surveyCatalogVoResult.surveyCatalog.surveyCatalogQuestionAlias = dr["SURVEY_CATALOG_QUESTION_ALIAS"].ToString();
surveyCatalogVoResult.surveyCatalogQuestion.surveyCatalogQuestionContents = dr["SURVEY_CATALOG_QUESTION_CONTENTS"].ToString();
surveyCatalogVoResult.surveyCatalog.surveyCatalogAnswerNo = int.Parse(dr["SURVEY_CATALOG_ANSWER_NO"].ToString());
surveyCatalogVoResult.surveyCatalogAnswer.surveyCatalogAnswerNo = int.Parse(dr["SURVEY_CATALOG_ANSWER_NO"].ToString());
surveyCatalogVoResult.surveyCatalog.surveyCatalogAnswerAlias = dr["SURVEY_CATALOG_ANSWER_ALIAS"].ToString();
surveyCatalogVoResult.surveyCatalogAnswer.surveyCatalogAnswerContents = dr["SURVEY_CATALOG_ANSWER_CONTENTS"].ToString();
surveyCatalogVoResult.surveyCatalog.score = float.Parse(dr["SCORE"].ToString());
surveyCatalogVoList.Add(surveyCatalogVoResult);
}
}
}
return(surveyCatalogVoList);
}
/// <summary>
/// 사용자재무VoList조회
/// </summary>
/// <param name="userFinanceVo">사용자재무Vo</param>
/// <returns>사용자재무Vo</returns>
public List <UserFinanceVo> selectListUserFinanceVo(UserFinanceVo userFinanceVo)
{
List <UserFinanceVo> userFinanceVoList = new List <UserFinanceVo>();
using (SqlCommon sqlCommon = new SqlCommon())
{
string procedureName = "UP_USER_FINANCE_LIST";
List <SqlParameter> sqlParameters = new List <SqlParameter>();
sqlParameters.Add(new SqlParameter("@USER_ID", userFinanceVo.userFinance.userId));
DataSet ds = sqlCommon.ExecuteProcedure(procedureName, sqlParameters);
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)
{
UserFinanceVo userFinanceVoResult = new UserFinanceVo();
userFinanceVoResult.userFinance.userId = dr["USER_ID"].ToString();
userFinanceVoResult.userFinance.userFinanceCatalogId = dr["USER_FINANCE_CATALOG_ID"].ToString();
userFinanceVoResult.userFinanceCatalog.userFinanceCatalogId = dr["USER_FINANCE_CATALOG_ID"].ToString();
userFinanceVoResult.userFinanceCatalog.userFinanceCatalogNm = dr["USER_FINANCE_CATALOG_NM"].ToString();
userFinanceVoResult.userFinanceCatalog.userFinanceCatalogSubgroupNo = int.Parse(dr["USER_FINANCE_CATALOG_SUBGROUP_NO"].ToString());
userFinanceVoResult.userFinance.price = int.Parse(dr["PRICE"].ToString());
userFinanceVoList.Add(userFinanceVoResult);
}
}
}
return(userFinanceVoList);
}
/// <summary>
/// 사용자가족Vo조회
/// </summary>
/// <param name="userFamilyVo">사용자가족Vo</param>
/// <returns>사용자가족Vo</returns>
public UserFamilyVo selectUserFamilyVo(UserFamilyVo userFamilyVo)
{
UserFamilyVo rtnUserFamilyVo = new UserFamilyVo();
using (SqlCommon sqlCommon = new SqlCommon())
{
string procedureName = "UP_USER_FAMILY_SELECT";
List <SqlParameter> sqlParameters = new List <SqlParameter>();
if (userFamilyVo.userFamily.userFamilyNo != -1)
{
sqlParameters.Add(new SqlParameter("@USER_FAMILY_NO", userFamilyVo.userFamily.userFamilyNo));
}
if (userFamilyVo.userFamily.userId != null)
{
sqlParameters.Add(new SqlParameter("@USER_ID", userFamilyVo.userFamily.userId));
}
if (userFamilyVo.userFamily.userFamilyTypeNo != -1)
{
sqlParameters.Add(new SqlParameter("@USER_FAMILY_TYPE_NO", userFamilyVo.userFamily.userFamilyTypeNo));
}
DataSet ds = sqlCommon.ExecuteProcedure(procedureName, sqlParameters);
if ((ds != null) &&
(ds.Tables != null) && (ds.Tables[0] != null) &&
(ds.Tables[0].Rows.Count > 0) && (ds.Tables[0].Rows[0] != null))
{
rtnUserFamilyVo.userFamily.userFamilyNo = int.Parse(ds.Tables[0].Rows[0]["USER_FAMILY_NO"].ToString());
rtnUserFamilyVo.userFamily.userId = ds.Tables[0].Rows[0]["USER_ID"].ToString();
rtnUserFamilyVo.userFamily.userFamilyTypeNo = int.Parse(ds.Tables[0].Rows[0]["USER_FAMILY_TYPE_NO"].ToString());
rtnUserFamilyVo.userFamilyType.userFamilyTypeNo = int.Parse(ds.Tables[0].Rows[0]["USER_FAMILY_TYPE_NO"].ToString());
rtnUserFamilyVo.userFamilyType.userFamilyTypeNm = ds.Tables[0].Rows[0]["USER_FAMILY_TYPE_NM"].ToString();
rtnUserFamilyVo.userFamily.userFamilyNm = ds.Tables[0].Rows[0]["USER_FAMILY_NM"].ToString();
rtnUserFamilyVo.userFamily.birthYear = int.Parse(ds.Tables[0].Rows[0]["BIRTH_YEAR"].ToString());
rtnUserFamilyVo.userFamily.sexTypeNo = int.Parse(ds.Tables[0].Rows[0]["SEX_TYPE_NO"].ToString());
rtnUserFamilyVo.userFamilySexType.sexTypeNo = int.Parse(ds.Tables[0].Rows[0]["SEX_TYPE_NO"].ToString());
rtnUserFamilyVo.userFamilySexType.sexTypeNm = ds.Tables[0].Rows[0]["SEX_TYPE_NM"].ToString();
rtnUserFamilyVo.userFamily.jobTypeNo = int.Parse(ds.Tables[0].Rows[0]["JOB_TYPE_NO"].ToString());
rtnUserFamilyVo.userFamilyJobType.jobTypeNo = int.Parse(ds.Tables[0].Rows[0]["JOB_TYPE_NO"].ToString());
rtnUserFamilyVo.userFamilyJobType.jobTypeNm = ds.Tables[0].Rows[0]["JOB_TYPE_NM"].ToString();
if ((ds.Tables[0].Rows[0]["RETIREMENT_AGE"] != null) && (ds.Tables[0].Rows[0]["RETIREMENT_AGE"].ToString() != ""))
{
rtnUserFamilyVo.userFamily.retirementAge = int.Parse(ds.Tables[0].Rows[0]["RETIREMENT_AGE"].ToString());
}
else
{
rtnUserFamilyVo.userFamily.retirementAge = null;
}
if ((ds.Tables[0].Rows[0]["LIFE_SPAN"] != null) && (ds.Tables[0].Rows[0]["LIFE_SPAN"].ToString() != ""))
{
rtnUserFamilyVo.userFamily.lifeSpan = int.Parse(ds.Tables[0].Rows[0]["LIFE_SPAN"].ToString());
}
else
{
rtnUserFamilyVo.userFamily.lifeSpan = null;
}
}
}
return(rtnUserFamilyVo);
}
/// <summary>
/// 사용자가족VoList조회
/// </summary>
/// <param name="userFamilyVo">사용자가족Vo</param>
/// <returns>사용자가족VoList</returns>
public List <UserFamilyVo> selectListUserFamilyVo(UserFamilyVo userFamilyVo)
{
List <UserFamilyVo> userFamilyVoList = new List <UserFamilyVo>();
using (SqlCommon sqlCommon = new SqlCommon())
{
string procedureName = "UP_USER_FAMILY_LIST";
List <SqlParameter> sqlParameters = new List <SqlParameter>();
sqlParameters.Add(new SqlParameter("@USER_ID", userFamilyVo.userFamily.userId));
DataSet ds = sqlCommon.ExecuteProcedure(procedureName, sqlParameters);
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)
{
UserFamilyVo userFamilyVoResult = new UserFamilyVo();
userFamilyVoResult.userFamily.userFamilyNo = int.Parse(dr["USER_FAMILY_NO"].ToString());
userFamilyVoResult.userFamily.userId = dr["USER_ID"].ToString();
userFamilyVoResult.userFamily.userFamilyTypeNo = int.Parse(dr["USER_FAMILY_TYPE_NO"].ToString());
userFamilyVoResult.userFamilyType.userFamilyTypeNo = int.Parse(dr["USER_FAMILY_TYPE_NO"].ToString());
userFamilyVoResult.userFamilyType.userFamilyTypeNm = dr["USER_FAMILY_TYPE_NM"].ToString();
userFamilyVoResult.userFamily.userFamilyNm = dr["USER_FAMILY_NM"].ToString();
userFamilyVoResult.userFamily.birthYear = int.Parse(dr["BIRTH_YEAR"].ToString());
userFamilyVoResult.userFamily.sexTypeNo = int.Parse(dr["SEX_TYPE_NO"].ToString());
userFamilyVoResult.userFamilySexType.sexTypeNo = int.Parse(dr["SEX_TYPE_NO"].ToString());
userFamilyVoResult.userFamilySexType.sexTypeNm = dr["SEX_TYPE_NM"].ToString();
userFamilyVoResult.userFamily.jobTypeNo = int.Parse(dr["JOB_TYPE_NO"].ToString());
userFamilyVoResult.userFamilyJobType.jobTypeNo = int.Parse(dr["JOB_TYPE_NO"].ToString());
userFamilyVoResult.userFamilyJobType.jobTypeNm = dr["JOB_TYPE_NM"].ToString();
if ((dr["RETIREMENT_AGE"] != null) && (dr["RETIREMENT_AGE"].ToString() != ""))
{
userFamilyVoResult.userFamily.retirementAge = int.Parse(dr["RETIREMENT_AGE"].ToString());
}
else
{
userFamilyVoResult.userFamily.retirementAge = null;
}
if ((dr["LIFE_SPAN"] != null) && (dr["LIFE_SPAN"].ToString() != ""))
{
userFamilyVoResult.userFamily.lifeSpan = int.Parse(dr["LIFE_SPAN"].ToString());
}
else
{
userFamilyVoResult.userFamily.lifeSpan = null;
}
userFamilyVoList.Add(userFamilyVoResult);
}
}
}
return(userFamilyVoList);
}