public SurveyCatalogListVo listSurveyCatalogVo(SurveyCatalogVo surveyCatalogVo)
{
SurveyCatalogListVo surveyCatalogListVo = new SurveyCatalogListVo();
using (SurveyCatalogService surveyCatalogService = new SurveyCatalogService())
{
surveyCatalogListVo = surveyCatalogService.listSurveyCatalogVo(surveyCatalogVo);
}
return(surveyCatalogListVo);
}
public SurveyCatalogListVo listSurveyCatalogVo(SurveyCatalogVo surveyCatalogVo)
{
SurveyCatalogListVo surveyCatalogListVo = new SurveyCatalogListVo();
List <SurveyCatalogVo> surveyCatalogVolist = new List <SurveyCatalogVo>();
using (SurveyCatalogDao surveyCatalogDao = new SurveyCatalogDao())
{
surveyCatalogVolist = surveyCatalogDao.listSurveyCatalogVo(surveyCatalogVo);
}
surveyCatalogListVo.surveyCatalogVolist = surveyCatalogVolist;
return(surveyCatalogListVo);
}
protected void Page_Load(object sender, EventArgs e)
{
showQuestionList = new List <int>();
using (FCdbFacade fcdbFacade = new FCdbFacade())
{
SurveyCatalogVo surveyCatalogVo = new SurveyCatalogVo();
surveyCatalogVo.surveyCatalog.surveyCatalogGroupNo = 1;
SurveyCatalogListVo surveyCatalogListVo = fcdbFacade.listSurveyCatalogVo(surveyCatalogVo);
listResult.DataSource = surveyCatalogListVo.surveyCatalogVolist;
listResult.DataBind();
}
}
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);
}
