public string Insert(QuestionnaireAnswerData data) { string sqlStr, answerPK; SqlCommand cmd; SqlParameter paramAnswer; sqlStr = "Insert Into QuestionnaireAnswer(detailId,QAMId,answerValue,answerText,createDa" + "te) Values(@detailId,@QAMId,@answerValue,@answerText,@createDate) SET @AnswerPK = SCOPE_IDENTITY()"; cmd = new SqlCommand(sqlStr, this.mCon); cmd.Parameters.AddWithValue("@detailId", data.DetailId); cmd.Parameters.AddWithValue("@QAMId", data.QAMId); cmd.Parameters.AddWithValue("@answerValue", data.AnswerValue); cmd.Parameters.AddWithValue("@answerText", data.AnswerText); cmd.Parameters.AddWithValue("@createDate", data.CreateDate); paramAnswer = new SqlParameter("@AnswerPK", System.Data.SqlDbType.Int) { Direction = System.Data.ParameterDirection.Output }; cmd.Parameters.Add(paramAnswer); this.mCon.Open(); cmd.ExecuteNonQuery(); this.mCon.Close(); cmd.Dispose(); answerPK = paramAnswer.Value.ToString(); return(answerPK); }
public string SaveAnswerGroup(string value) { List <QuestionnaireAnswerData> qads = new List <QuestionnaireAnswerData>(); QuestionnaireAnswerManager qam = new QuestionnaireAnswerManager(); QuestionnaireAnswerData qad; string[] values = value.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries); foreach (var val in values) { qad = new QuestionnaireAnswerData(); qad = Element.ToElement(qad, val); //設定其餘屬性 qad.CreateDate = DateTime.Now; if (qad.AnswerValue.IndexOf("$&") != -1) { qad.AnswerValue = qad.AnswerValue.Replace("$&", ","); } if (qad.AnswerText.IndexOf("$&") != -1) { qad.AnswerText = qad.AnswerText.Replace("$&", ","); } if (qad.AnswerText.IndexOf("$#") != -1) { qad.AnswerText = qad.AnswerText.Replace("$#", ":"); } qads.Add(qad); } qam.InsertGroups(qads); return("Y"); }
/// <summary> /// Method for deserialization of a XML-String to the coressponding QuestionnaireAnswerData. /// </summary> /// /// <param name="str"> String containing the XML-QuestionnaireAnswerData for deserialization. </param> /// /// <returns> /// QuestionnaireAnswerData-type coressponding to the parameter "str" after deserialization. /// </returns> internal QuestionnaireAnswerData getQuestionnaireAnswerDataFromXmlString(String str) { XmlSerializer serializer = new XmlSerializer(typeof(QuestionnaireAnswerData)); using (TextReader reader = new StringReader(str)) { QuestionnaireAnswerData result = (QuestionnaireAnswerData)serializer.Deserialize(reader); return(result); } }
private QuestionnaireAnswerData GetQuestionnaireAnswer(SqlDataReader dr) { QuestionnaireAnswerData data = new QuestionnaireAnswerData(); data.Id = ((int)(dr["id"])); data.DetailId = ((int)(dr["detailId"])); data.QAMId = (int)dr["QAMId"]; data.AnswerValue = dr["answerValue"].ToString(); data.AnswerText = dr["answerText"].ToString(); data.CreateDate = ((System.DateTime)(dr["createDate"])); return(data); }
public virtual void Update(QuestionnaireAnswerData data) { string sqlStr; SqlCommand cmd; sqlStr = "Update QuestionnaireAnswer Set detailId= @detailId,QAMId= @QAMId,answerValue= @an" + "swerValue,answerText= @answerText,createDate= @createDate Where id =@id"; cmd = new SqlCommand(sqlStr, this.mCon); cmd.Parameters.AddWithValue("@detailId", data.DetailId); cmd.Parameters.AddWithValue("@QAMId", data.QAMId); cmd.Parameters.AddWithValue("@answerValue", data.AnswerValue); cmd.Parameters.AddWithValue("@answerText", data.AnswerText); cmd.Parameters.AddWithValue("@createDate", data.CreateDate); cmd.Parameters.AddWithValue("@id", data.Id); this.mCon.Open(); cmd.ExecuteNonQuery(); this.mCon.Close(); cmd.Dispose(); }
/// <summary> /// Method for testing answer-xml deserilization. /// </summary> internal void performTest3() { log("Start Test 3"); String xmlAnswer = @"<?xml version=""1.0"" encoding=""utf-16""?><questionnaireanswers xmlns:xsi=""http://www.w3.org/2001/XMLSchema-instance"" xmlns:xsd=""http://www.w3.org/2001/XMLSchema"">"; xmlAnswer += "<groups><group><name>A</name><rating>7</rating></group><group><name>B</name><rating>8</rating></group></groups>"; xmlAnswer += "<questionnaireid>testid</questionnaireid></questionnaireanswers>"; QuestionnaireAnswerData qad = this.getQuestionnaireAnswerDataFromXmlString(xmlAnswer); if (qad.toXmlString().Equals(xmlAnswer)) { log("Serilization and deserilization successful!"); } else { log("Serilization and deserilization failed!"); log(qad.toXmlString()); log(xmlAnswer); } log("End test 3"); }