/// <summary>
/// 得到一个对象实体
/// </summary>
public SHMetroTestSysModel.jc_Unit DataRowToModel(DataRow row)
{
SHMetroTestSysModel.jc_Unit model = new SHMetroTestSysModel.jc_Unit();
if (row != null)
{
if (row["UnitId"] != null && row["UnitId"].ToString() != "")
{
model.UnitId = int.Parse(row["UnitId"].ToString());
}
if (row["UnitSubject"] != null)
{
model.UnitSubject = row["UnitSubject"].ToString();
}
if (row["UnitName"] != null)
{
model.UnitName = row["UnitName"].ToString();
}
if (row["UnitFullSequence"] != null)
{
model.UnitFullSequence = row["UnitFullSequence"].ToString();
}
if (row["UnitTypeCode"] != null && row["UnitTypeCode"].ToString() != "")
{
model.UnitTypeCode = int.Parse(row["UnitTypeCode"].ToString());
}
if (row["UnitTypeName"] != null)
{
model.UnitTypeName = row["UnitTypeName"].ToString();
}
}
return model;
}
protected void ibnt_addok_Click(object sender, ImageClickEventArgs e)
{
SHMetroTestSysModel.jc_Unit model = new SHMetroTestSysModel.jc_Unit();
model.UnitName = this.txt_UnitName.Text.Trim();
model.UnitSubject = this.ddl_Subject.SelectedItem.Value.ToString();
model.UnitTypeCode = 3;
model.UnitFullSequence = txt_unitFullSequence.Text;
if (jcUnitBF.AddUnit(model, int.Parse(ddl_unit2.SelectedValue)))
{
this.Page.ClientScript.RegisterStartupScript(base.GetType(), "startscript",
"<script text=\"text/javascript\" defer=\"defer\">Dialog.alert('添加完成！');</script>");
}
else
{
this.Page.ClientScript.RegisterStartupScript(base.GetType(), "startscript", "<script text=\"text/javascript\" defer=\"defer\">Dialog.alert('添加失败！');</script>");
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public SHMetroTestSysModel.jc_Unit GetModel(int UnitId)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 UnitId,UnitSubject,UnitName,UnitFullSequence,UnitTypeCode,UnitTypeName from jc_Unit ");
strSql.Append(" where UnitId=@UnitId");
SqlParameter[] parameters = {
new SqlParameter("@UnitId", SqlDbType.Int,4)
};
parameters[0].Value = UnitId;
SHMetroTestSysModel.jc_Unit model = new SHMetroTestSysModel.jc_Unit();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return DataRowToModel(ds.Tables[0].Rows[0]);
}
else
{
return null;
}
}
protected void Ibtn_StartLoad_Click(object sender, ImageClickEventArgs e)
{
var sheetName = GetExcelSheet();
string xmlfilePath = base.Server.MapPath("../../webConfig/Paper.xls");
string selectConnectionString = "Provider=Microsoft.Jet.Oledb.4.0;Data Source=" + xmlfilePath + ";Extended Properties='Excel 8.0;HDR=NO;IMEX=1;'";
string strsql = "select * from [" + sheetName + "] where F1 is not null and F1 not like '%知识试题%' and F1<>'试题代码';";
try
{
//获取章节信息
DataSet dataSet = new DataSet();
new OleDbDataAdapter(strsql, selectConnectionString).Fill(dataSet);
this.db_0.CnClose();
int count = dataSet.Tables[0].Rows.Count;
SHMetroTestSysModel.jc_Unit model = new SHMetroTestSysModel.jc_Unit();
for (int i = 0; i < count; i++)
{
model.UnitName = dataSet.Tables[0].Rows[i][1].ToString();
model.UnitSubject = this.ddl_Subject.SelectedItem.Value.ToString();
model.UnitTypeCode = dataSet.Tables[0].Rows[i][0].ToString().Split('.').Length;
model.UnitFullSequence = dataSet.Tables[0].Rows[i][0].ToString();
jcUnitBF.MergeUnit(model);
}
//获取试题信息
string UnitFullSequence = "";
string PaperType = "";
string PaperText = "";
string PaperAnswer = "";
string Answer = "";
DataSet dataSet2 = new DataSet();
strsql = "select * from [" + sheetName + "] where F2 is not null";
new OleDbDataAdapter(strsql, selectConnectionString).Fill(dataSet2);
for (int i = 0; i < dataSet2.Tables[0].Rows.Count; i++)
{
if (dataSet2.Tables[0].Rows[i]["F1"].ToString().Split('.').Length != 4 && !string.IsNullOrEmpty(dataSet2.Tables[0].Rows[i]["F1"].ToString()))
{
continue;
}
if (dataSet2.Tables[0].Rows[i]["F1"].ToString().Split('.').Length == 4)
{
UnitFullSequence = dataSet2.Tables[0].Rows[i]["F1"].ToString();
continue;
}
if (dataSet2.Tables[0].Rows[i]["F2"].ToString().Contains("判断题"))
{
PaperType = "判断";
continue;
}
else if (dataSet2.Tables[0].Rows[i]["F2"].ToString().Contains("单选题"))
{
PaperType = "单选";
continue;
}
else if (dataSet2.Tables[0].Rows[i]["F2"].ToString().Contains("多选题"))
{
PaperType = "多选";
continue;
}
if (PaperType == "判断")
{
PaperText = dataSet2.Tables[0].Rows[i]["F2"].ToString().Replace("（√）", "").Replace("（×）", "").Replace("(√)", "").Replace("(×)", "");
if (dataSet2.Tables[0].Rows[i]["F2"].ToString().Contains("√"))
{
Answer = "A";
}
else
{
Answer = "B";
}
jcPaperBF.ImportPaper(this.ddl_Subject.SelectedItem.Value.ToString(), UnitFullSequence,
PaperType, PaperText, "", Answer,true);
continue;
}
else if (PaperType == "单选" || PaperType == "多选")
{
PaperText = dataSet2.Tables[0].Rows[i]["F2"].ToString();
PaperAnswer = dataSet2.Tables[0].Rows[i + 1]["F2"].ToString();
i = i + 1;
jcPaperBF.ImportPaper(this.ddl_Subject.SelectedItem.Value.ToString(), UnitFullSequence,
PaperType, PaperText, PaperAnswer, Answer, true);
continue;
}
}
this.Page.ClientScript.RegisterStartupScript(base.GetType(), "startscriaapt", "<script text=\"text/javascript\" defer=\"defer\">Dialog.alert('导入成功！',null,400,200);</script>");
}
catch (Exception ex)
{
this.lbl_xlsinfo.Text = "";
this.Page.ClientScript.RegisterStartupScript(base.GetType(), "startscriaapt", "<script text=\"text/javascript\" defer=\"defer\">Dialog.alert('Excel文件出错，原因可能是：<br /><br /><span style=\"color:red;\">1、没有题库模板工作表</span><br /><br /><span style=\"color:red;\">2、您擅自修改、增加或删除了EXCEL模板文件中的列</span><br /><br />请检查！',null,400,200);</script>");
}
}