/// <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)); }