public string SaveDataUI(string value)
{
DefinedFormAnswerManager dfm = new DefinedFormAnswerManager();
List <DefinedFormAnswerData> datas = new List <DefinedFormAnswerData>();
DefinedFormAnswerData data;
string[] values = value.Split(new string[] { ";" }, StringSplitOptions.RemoveEmptyEntries);
foreach (string val in values)
{
data = new DefinedFormAnswerData();
data = Element.ToElement(data, val);
data.CreateDate = DateTime.Now;
if (data.AnswerValue == null)
{
data.AnswerValue = string.Empty;
}
datas.Add(data);
}
foreach (var item in datas)
{
dfm.Insert(item);
}
return("Y");
}
private DefinedFormAnswerData GetDefinedFormAnswer(SqlDataReader dr)
{
DefinedFormAnswerData data = new DefinedFormAnswerData();
data.PK = ((int)(dr["PK"]));
data.DetailPK = ((int)(dr["DetailPK"]));
data.AnswerValue = dr["AnswerValue"].ToString();
data.AnswerText = dr["AnswerText"].ToString();
data.CreateDate = ((System.DateTime)(dr["CreateDate"]));
return(data);
}
public virtual void Insert(DefinedFormAnswerData data)
{
string sqlStr;
SqlCommand cmd;
sqlStr = "Insert Into DefinedFormAnswer(DetailPK,AnswerValue,AnswerText,CreateDate) Valu" +
"es(@DetailPK,@AnswerValue,@AnswerText,@CreateDate)";
cmd = new SqlCommand(sqlStr, this.mCon);
cmd.Parameters.AddWithValue("@DetailPK", data.DetailPK);
cmd.Parameters.AddWithValue("@AnswerValue", data.AnswerValue);
cmd.Parameters.AddWithValue("@AnswerText", data.AnswerText);
cmd.Parameters.AddWithValue("@CreateDate", data.CreateDate);
this.mCon.Open();
cmd.ExecuteNonQuery();
this.mCon.Close();
cmd.Dispose();
}
