//添加题目 public int AddTopic(ImputTopic topic) { int res = 0; try { DateTime time = DateTime.Now.ToLocalTime(); int topicSourceId = GetTopicSourceIdByName(topic.TopicSourceName); Topic newTopic = new Topic() { SortId = decimal.Parse(GetSortId(topic.SortName)), SecondPointId = new PointService().GetSeccondIdByName(topic.SecondPointName), TopicTitle = Public.Convert(topic.TopicTitle), OptionA = Public.Convert(topic.OptionA.Trim()), OptionB = Public.Convert(topic.OptionB.Trim()), OptionC = Public.Convert(topic.OptionC.Trim()), OptionD = Public.Convert(topic.OptionD.Trim()), TitleAnswer = new StuExamBLL().FormatAnswer(topic.TitleAnswer.Trim()), TopicCreateDate = time, TopicType = topic.TopicType.Trim(), TopicState = (int)TopicBLL.TopicState.PassAudit, //待审核 TopicSourceId = topicSourceId }; db.Topic.InsertOnSubmit(newTopic); db.SubmitChanges(); res = 1; } catch (Exception e) { res = 0; } return(res); }
protected void btnImport_Click(object sender, EventArgs e) { string fileUrl = SaveFile(); string connstr = ""; int warning = 0; if (fileUrl == "") { return; } string extention = Path.GetExtension(fileUrl); if (extention == ".xls") { connstr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath(fileUrl) + ";Extended Properties='Excel 8.0;HDR=YES;IMEX=2'"; } else { connstr = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + Server.MapPath(fileUrl) + ";Extended Properties='Excel 12.0 Xml;HDR=YES;IMEX=2'"; } OleDbConnection conn = new OleDbConnection(connstr); if (imputTopics != null) { imputTopics.Clear(); //清空题目集合 } //if (sameTopic != null) // sameTopic.Clear(); try { conn.Open(); OleDbCommand cmd = new OleDbCommand("select * from [Sheet1$]", conn); OleDbDataReader dr = cmd.ExecuteReader(); int index = 0; while (dr.Read()) { index++; if (dr["题目"].ToString().Trim() == "") { break; } //if (dr["题目"].ToString().Trim() == "" || dr["选项A"].ToString().Trim() == "" // || dr["选项B"].ToString().Trim() == "" || dr["答案"].ToString().Trim() == "" // || dr["一级知识点"].ToString().Trim() == "" || dr["二级知识点"].ToString().Trim() == "" // || dr["题目类别"].ToString().Trim() == "" || dr["题目类型"].ToString().Trim() == "" // || dr["题库名称"].ToString().Trim() == "") //{ // warning = 1; // break; // //continue; //} if (dr["题目"].ToString().Trim() == "") { infoAlert("请将第" + index + "题的题目标题信息填写完整"); return; } if (dr["选项A"].ToString().Trim() == "") { infoAlert("请将第" + index + "题的选项A信息填写完整"); return; } if (dr["选项B"].ToString().Trim() == "") { infoAlert("请将第" + index + "题的选项B信息填写完整"); return; } if (dr["选项C"].ToString().Trim() == "") { infoAlert("请将第" + index + "题的选项C信息填写完整"); return; } if (dr["选项D"].ToString().Trim() == "") { infoAlert("请将第" + index + "题的选项D信息填写完整"); return; } if (dr["答案"].ToString().Trim() == "") { infoAlert("请将第" + index + "题的答案信息填写完整"); return; } if (dr["一级知识点"].ToString().Trim() == "") { infoAlert("请将第" + index + "题的一级知识点信息填写完整"); return; } if (dr["二级知识点"].ToString().Trim() == "") { infoAlert("请将第" + index + "题的二级知识点填写完整"); return; } if (dr["题目类别"].ToString().Trim() == "") { infoAlert("请将第" + index + "题的题目类别信息填写完整"); return; } if (dr["题目类型"].ToString().Trim() == "") { infoAlert("请将第" + index + "题的题目类型信息填写完整"); return; } if (dr["题库名称"].ToString().Trim() == "") { infoAlert("请将第" + index + "题的题库名称信息填写完整"); return; } int sortid = 1; if (Request.QueryString["sortid"] != null) { sortid = Convert.ToInt16(Request.QueryString["sortid"].ToString()); } ImputTopic impupt = new ImputTopic() { TopicTitle = dr["题目"].ToString().Trim(), OptionA = dr["选项A"].ToString().Trim(), OptionB = dr["选项B"].ToString().Trim(), OptionC = dr["选项C"].ToString().Trim(), OptionD = dr["选项D"].ToString().Trim(), TitleAnswer = dr["答案"].ToString().Trim(), FirstPointName = dr["一级知识点"].ToString().Trim(), SecondPointName = dr["二级知识点"].ToString().Trim(), SortName = dr["题目类别"].ToString().Trim(), TopicType = dr["题目类型"].ToString().Trim(), TopicSourceName = dr["题库名称"].ToString().Trim() }; imputTopics.Add(impupt); } CheckTopic(); //CheckExxcelRepeat(); } catch (Exception ex) { ClientScript.RegisterStartupScript(this.GetType(), "error", "<script>window.alert('" + ex.Message + "');</script>"); } finally { conn.Close(); File.Delete(Server.MapPath(fileUrl)); if (warning != 0) { Response.Write("<script>alert('请将所有数据项补全后重新导入!');window.location.href='InputTopic.aspx';</script>"); } else { // Response.Write("<script>window.location.href='ManageJudge.aspx?';</script>"); } } }