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