public List <NeiKeOptionModel> GetListByCode(string code)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 50 * from GP_NeiKeOption");
strSql.Append(" where SubjectCode=@SubjectCode ORDER BY NEWID()");
SqlParameter[] parameters =
{
new SqlParameter("@SubjectCode", SqlDbType.NVarChar, 50)
};
parameters[0].Value = code;
DataTable dt = db.RunDataTable(strSql.ToString(), parameters);
List <NeiKeOptionModel> list = null;
if (dt.Rows.Count > 0)
{
NeiKeOptionModel model = null;
list = new List <NeiKeOptionModel>();
foreach (DataRow row in dt.Rows)
{
model = new NeiKeOptionModel();
model = DataRowToModel(row);
list.Add(model);
}
}
return(list);
}
public NeiKeOptionModel DataRowToModel(DataRow row)
{
NeiKeOptionModel model = new NeiKeOptionModel();
if (row != null)
{
if (row["Id"] != null)
{
model.Id = row["Id"].ToString();
}
if (row["SubjectName"] != null)
{
model.SubjectName = row["SubjectName"].ToString();
}
if (row["SubjectCode"] != null)
{
model.SubjectCode = row["SubjectCode"].ToString();
}
if (row["Question"] != null)
{
model.Question = row["Question"].ToString();
}
if (row["QuestionType"] != null)
{
model.QuestionType = row["QuestionType"].ToString();
}
if (row["OptionA"] != null)
{
model.OptionA = row["OptionA"].ToString();
}
if (row["OptionB"] != null)
{
model.OptionB = row["OptionB"].ToString();
}
if (row["OptionC"] != null)
{
model.OptionC = row["OptionC"].ToString();
}
if (row["OptionD"] != null)
{
model.OptionD = row["OptionD"].ToString();
}
if (row["OptionE"] != null)
{
model.OptionE = row["OptionE"].ToString();
}
if (row["CorrectAnswer"] != null)
{
model.CorrectAnswer = row["CorrectAnswer"].ToString();
}
if (row["Tag1"] != null)
{
model.Tag1 = row["Tag1"].ToString();
}
if (row["Tag2"] != null)
{
model.Tag2 = row["Tag2"].ToString();
}
if (row["Tag3"] != null)
{
model.Tag3 = row["Tag3"].ToString();
}
}
return(model);
}
