public static ArrayList List(int qid)
{
/*
AnswerList
* @qid int
*/
//[Id],QuestionId, Title, Data, WithInput, Excludes, SkipType, [Skip], SortNum
ArrayList list = new ArrayList();
SqlDataReader reader = null;
try
{
reader = Database.ExecuteReader(CommandType.StoredProcedure, "AnswerList",
new SqlParameter[] { Database.MakeInParam("@qid", SqlDbType.Int, qid) });
while (reader.Read())
{
Answer a = new Answer();
a.id = reader.GetInt32(0);
a.questionId = reader.GetInt32(1);
a.title = reader.GetString(2);
a.data = reader.GetString(3);
a.withInput = reader.GetString(4) == "1";
a.excludes = reader.GetString(5);
a.skipType = (AnswerSkipType)(reader.GetInt16(6));
a.skip = reader.GetString(7);
a.sortNum = reader.GetInt16(8);
list.Add(a);
}
reader.Close();
}
catch
{
throw;
}
finally
{
if (reader != null)
{
reader.Close();
}
}
return list;
}
private void SaveAnswer()
{
Response.Clear();
if (Request.Form["aId"] != null &&
Request.Form["qId"] != null &&
Request.Form["aSort"] != null &&
Request.Form["aTitle"] != null &&
Request.Form["aData"] != null &&
Request.Form["aExcludes"] != null)
{
try
{
Answer a = new Answer(Convert.ToInt32(Request.Form["qId"]));
a.SortNum = Convert.ToInt16(Request.Form["aSort"]);
a.Title = Request.Form["aTitle"].Trim();
a.Data = Request.Form["aData"].Trim();
a.Excludes = Request.Form["aExcludes"].Trim();
a.WithInput = Request.Form["aWithInput"] != null;
a.SkipType = AnswerSkipType.None;
if (Request.Form["aSkipType"] != "0" && Request.Form["aSkip"] != null)
{
if (!String.IsNullOrEmpty(Request.Form["aSkip"].Trim()))
{
a.SkipType = (AnswerSkipType)(Convert.ToInt16(Request.Form["aSkipType"]));
a.Skip = Request.Form["aSkip"].Trim();
}
}
int newId = a.Save(Convert.ToInt32(Request.Form["aId"]));
Response.Write(newId);
}
catch
{
//
}
}
Response.End();
}
public static Answer Get(int aid)
{
/*
AnswerGet
@id int
*/
//QuestionId, Title, Data, WithInput, Excludes, SkipType, [Skip], SortNum
Answer a = new Answer();
SqlDataReader reader = null;
try
{
reader = Database.ExecuteReader(CommandType.StoredProcedure, "AnswerGet",
new SqlParameter[] { Database.MakeInParam("@id", SqlDbType.Int, aid) });
if (reader.Read())
{
a = new Answer();
a.id = aid;
a.questionId = reader.GetInt32(0);
a.title = reader.GetString(1);
a.data = reader.GetString(2);
a.withInput = reader.GetString(3) == "1";
a.excludes = reader.GetString(4);
a.skipType=(AnswerSkipType)(reader.GetInt16(5));
a.skip = reader.GetString(6);
a.sortNum = reader.GetInt16(7);
}
reader.Close();
}
catch
{
//
}
finally
{
if (reader != null)
{
reader.Close();
}
}
return a;
}