public DataTable GetChoiceList(long QuestionID, DbTrans trans) {
QuestionnaireQuestionsChoiceLinq lnq = new QuestionnaireQuestionsChoiceLinq();
return lnq.GetDataList("questionnaire_questions_id = " + QuestionID, "id", trans.Trans);
}
public QuestionnaireQuestionsChoicePara GetQuestionnaireQuestionChoicePara(long vID, DbTrans trans) {
QuestionnaireQuestionsChoiceLinq lnq = new QuestionnaireQuestionsChoiceLinq();
return lnq.GetParameter(vID, trans.Trans);
}
public bool SaveQuestionChoice(DataTable dt, DbTrans trans, string LoginName,long QuestionID) {
bool ret = false;
if (dt.Rows.Count > 0) {
foreach (DataRow dr in dt.Rows) {
QuestionnaireQuestionsChoiceLinq lnq = new QuestionnaireQuestionsChoiceLinq();
if (Convert.ToInt64(dr["id"]) != 0)
lnq.GetDataByPK(Convert.ToInt64(dr["id"]),trans.Trans);
lnq.QUESTIONNAIRE_QUESTIONS_ID = QuestionID;
lnq.CHOICE_NAME = dr["choice_name"].ToString();
lnq.IS_DEFAULT = Convert.ToChar(dr["is_default"]);
lnq.POINT = Convert.ToDouble(dr["point"]);
lnq.IS_OTHER = Convert.ToChar(dr["is_other"]);
if (lnq.ID != 0)
ret = lnq.UpdateByPK(LoginName, trans.Trans);
else
ret = lnq.InsertData(LoginName, trans.Trans);
if (ret == false)
{
_err = lnq.ErrorMessage;
break;
}
}
}
return ret;
}
