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"); }
public string SaveAnswer(string answerPK, string detailPK, string answerMasterPK, string answerValue, string answerText) { QuestionnaireAnswerManager qam = new QuestionnaireAnswerManager(); int aPK, dPK, amPK; int.TryParse(answerPK, out aPK); int.TryParse(detailPK, out dPK); int.TryParse(answerMasterPK, out amPK); if (answerPK == "0") { answerPK = qam.Insert(new QuestionnaireAnswerData { AnswerValue = answerValue, AnswerText = answerText, DetailId = dPK, CreateDate = DateTime.Now, QAMId = amPK }); } else { qam.Update(new QuestionnaireAnswerData { Id = aPK, AnswerValue = answerValue, AnswerText = answerText, DetailId = dPK, CreateDate = DateTime.Now, QAMId = amPK }); } return(answerPK); }
/// <summary> /// 刪除 /// </summary> /// <param name="pk"></param> public void Delete(string pk) { string sqlStr; SqlCommand cmd; QuestionnaireAnswerManager qam = new QuestionnaireAnswerManager(); qam.DeleteByDetailId(pk); sqlStr = "Delete From QuestionnaireDetail Where id= @id"; using (cmd = new SqlCommand(sqlStr, this.mCon)) { cmd.Parameters.AddWithValue("@id", pk); this.mCon.Open(); cmd.ExecuteNonQuery(); this.mCon.Close(); } }