/// <summary>
/// 详细信息
/// </summary>
/// <param name="TitleListID">题目ID</param>
/// <returns></returns>
public List <Model.OptionsList> Details(int TitleListID)
{
string strSql = "";
strSql = "Select * FROM [OptionsList] Where [TitleListID]='" + TitleListID + "'";
List <Model.OptionsList> List = new List <Model.OptionsList>();
SqlParameter[] parameters =
{
};
SqlDataReader DR;
DR = ExamSys.ExecuteReader(strSql.ToString(), parameters);
using (DR)
{
while (DR.Read())
{
Model.OptionsList model = new Model.OptionsList();
model.Name = DR["Name"].ToString();
model.T_F = DR["T_F"].ToString();
model.ID = int.Parse(DR["ID"].ToString());
List.Add(model);
}
DR.Close();
DR.Dispose();
}
return(List);
}
protected void bt_Yes_Click(object sender, EventArgs e)
{
try
{
BLL.TitleList bll = new BLL.TitleList();
Model.TitleList model = new Model.TitleList();
model.CourseID = int.Parse(Request.QueryString["CourseID"]);
model.Type = Request.QueryString["TitleType"];
model.Title = Common.Function.StringEncode(tb_Title.Text.Trim());
model.Analysis = Common.Function.StringEncode(tb_Analysis.Text.Trim());
model.Extent = rbl_Extent.SelectedValue.ToString();
int TitleListID = bll.Add(model);
if (TitleListID > 0)
{
int k = 0;
int l = 0;
string del_Work = "";
del_Work = Request.Form["del_Work"].ToString();
int num = int.Parse(Request.Form["WorkExpNum"].ToString());
for (int i = 1; i <= num; i++)
{
if (del_Work.IndexOf(i.ToString()) <= 0)
{
//Response.Write(i + "：" + Request.Form["Name" + i] + Request.Form["radio" + i] + "<br/>");
string radio = Request.Form["radio" + i];
string Name = Request.Form["Name" + i];
if (Name == "")
{
}
else
{
BLL.OptionsList bll1 = new BLL.OptionsList();
Model.OptionsList model1 = new Model.OptionsList();
model1.TitleListID = TitleListID;
model1.Name = Common.Function.StringEncode(Name);
model1.T_F = radio;
if (bll1.Add(model1) > 0)
{
k = k + 1;
}
else
{
l = l + 1;
}
}
}
}
lb_msg.Text = "题目添加成功，选择成功添加[" + k + "]条,失败[" + l + "]条！";
}
else
{
lb_msg.Text = "题目添加失败！";
//Common.Function.AlertRedirect("系统繁忙请稍后再试！", "/I-B/List" + Request.QueryString["TitleType"] + "-" + Request.QueryString["CourseID"] + ".html", "Iframe_Div_Mid_Mid");
}
}
catch
{
lb_msg.Text = "系统繁忙请稍后再试！";
}
}
/// <summary>
/// 更新
/// </summary>
/// <param name="model"></param>
public void Updata(Model.OptionsList model)
{
if (dal.Updata(model) > 0)
{
Common.Function.AlertRedirect("成功！", "/Aspx/Success.htm");
}
else
{
Common.Function.AlertRedirect("失败！", "/Aspx/Failure.htm");
}
}
/// <summary>
/// 添加
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int Add(Model.OptionsList 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),
};
parameters[0].Direction = ParameterDirection.Output;
parameters[1].Value = model.TitleListID;
parameters[2].Value = model.Name;
parameters[3].Value = model.T_F;
ExamSys.RunProcedure("OptionsList_Add", parameters, out rowsAffected);
return((int)parameters[0].Value);
}
/// <summary>
/// 添加
/// </summary>
public int Add(Model.OptionsList model)
{
return(dal.Add(model));
}
