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