/// <summary>
/// 添加试卷选项表
/// </summary>
/// <param name="PapersID">PapersID</param>
/// <param name="TitleListID">TitleListID</param>
/// <param name="Score">Score</param>
/// <param name="Type">Type</param>
private void AddPapersOptionsList(int PapersID, int TitleListID, int Score, string Type)
{
BLL.OptionsList bll = new BLL.OptionsList();
List <Model.OptionsList> list = new List <Model.OptionsList>();
list = bll.Details(TitleListID);
for (int i = 0; i < list.Count; i++)
{
BLL.PapersOptionsList Pbll = new BLL.PapersOptionsList();
Model.PapersOptionsList model = new Model.PapersOptionsList();
model.ID = list[i].ID;
model.TitleListID = TitleListID;
model.Name = list[i].Name;
model.T_F = list[i].T_F;
model.PapersID = PapersID;
if (Type == "值选项")
{
model.Score = Score - i;
}
else
{
model.Score = 0;
}
Pbll.Add(model);
}
}
/// <summary>
/// 显示所有
/// </summary>
/// <param name="TitleListID">题目ID</param>
/// <returns></returns>
public List <Model.PapersOptionsList> GetList(int TitleListID, int PapersID)
{
string strSql = "";
//strSql = "Select * FROM [PapersOptionsList] Where [TitleListID]='" + TitleListID + "' and [PapersID]='" + PapersID + "' order by newid()";
strSql = "Select * FROM [PapersOptionsList] Where [TitleListID]='" + TitleListID + "' and [PapersID]='" + PapersID + "' order by ID";
List <Model.PapersOptionsList> List = new List <Model.PapersOptionsList>();
SqlParameter[] parameters =
{
};
SqlDataReader DR;
DR = ExamSys.ExecuteReader(strSql.ToString(), parameters);
using (DR)
{
while (DR.Read())
{
Model.PapersOptionsList model = new Model.PapersOptionsList();
model.Name = DR["Name"].ToString();
model.T_F = DR["T_F"].ToString();
model.PapersID = int.Parse(DR["PapersID"].ToString());
model.TitleListID = int.Parse(DR["TitleListID"].ToString());
model.ID = int.Parse(DR["ID"].ToString());
model.Score = int.Parse(DR["Score"].ToString());
List.Add(model);
}
DR.Close();
DR.Dispose();
}
return(List);
}
/// <summary>
/// 添加试卷选项表
/// </summary>
/// <param name="TitleListID">TitleListID</param>
private void AddgvPapersOptionsList(int TitleListID, int PapersID)
{
try
{
BLL.OptionsList bll = new BLL.OptionsList();
List <Model.OptionsList> list = new List <Model.OptionsList>();
list = bll.Details(TitleListID);
for (int i = 0; i < list.Count; i++)
{
BLL.PapersOptionsList Pbll = new BLL.PapersOptionsList();
Model.PapersOptionsList model = new Model.PapersOptionsList();
model.ID = list[i].ID;
model.TitleListID = TitleListID;
model.Name = list[i].Name;
model.T_F = list[i].T_F;
model.PapersID = PapersID;
model.Score = 0;
Pbll.Add(model);
}
}
catch (Exception)
{
throw;
}
}
/// <summary>
/// 添加
/// </summary>
public void Add(Model.PapersOptionsList model)
{
if (dal.Add(model) > 0)
{
}
else
{
}
}
/// <summary>
/// 添加试卷选项表
/// </summary>
/// <param name="TitleListID">TitleListID</param>
private void AddgvPapersOptionsList(int TitleListID, int PapersID, GridView gv)
{
BLL.OptionsList bll = new BLL.OptionsList();
List <Model.OptionsList> list = new List <Model.OptionsList>();
list = bll.Details(TitleListID);
for (int i = 0; i < list.Count; i++)
{
BLL.PapersOptionsList Pbll = new BLL.PapersOptionsList();
Model.PapersOptionsList model = new Model.PapersOptionsList();
model.ID = list[i].ID;
model.TitleListID = TitleListID;
model.Name = list[i].Name;
model.T_F = list[i].T_F;
model.PapersID = PapersID;
model.Score = ScoreOptionsList(gv, list[i].ID);
Pbll.Add(model);
}
}
/// <summary>
/// 添加
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int Add(Model.PapersOptionsList model)
{
int rowsAffected;
SqlParameter[] parameters =
{
new SqlParameter("@ReturnValue", SqlDbType.Int),
new SqlParameter("@TitleListID", SqlDbType.Int),
new SqlParameter("@Name", SqlDbType.NVarChar,500),
new SqlParameter("@T_F", SqlDbType.NVarChar, 50),
new SqlParameter("@ID", SqlDbType.Int),
new SqlParameter("@PapersID", SqlDbType.Int),
new SqlParameter("@Score", SqlDbType.Int),
};
parameters[0].Direction = ParameterDirection.Output;
parameters[1].Value = model.TitleListID;
parameters[2].Value = model.Name;
parameters[3].Value = model.T_F;
parameters[4].Value = model.ID;
parameters[5].Value = model.PapersID;
parameters[6].Value = model.Score;
ExamSys.RunProcedure("PapersOptionsList_Add", parameters, out rowsAffected);
return((int)parameters[0].Value);
}
