//添加题目
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>");
}
}
}
