public ActionResult TestExeclTemp(int UnitContent)
{
Course_UnitQuestionBLL course_UnitQuestionBLL = new Course_UnitQuestionBLL();
string msg = "";
HttpPostedFileBase excel = Request.Files[0];
string fileName = Server.MapPath(Code.UploadCore.UploadAttach(excel, ref msg));
int GroupId = Code.SiteCache.Instance.GroupId;
int OrganId = Code.SiteCache.Instance.ManageOrganId;
DataTable dt = ReadExcel(fileName);
if (dt.Columns[0].ColumnName.ToString() != "类型" || dt.Columns[1].ColumnName.ToString() != "题目内容" || dt.Columns[2].ColumnName.ToString() != "答案内容" || dt.Columns[3].ColumnName.ToString() != "正确答案序号" || dt.Columns[4].ColumnName.ToString() != "权重")
{
return Content("no:导入的格式不正确!");
}
else
{
List<Course_UnitQuestion> list = new List<Course_UnitQuestion>();
if (dt.Rows.Count == 0)
{
return Content("no:无导入数据!");
}
else
{
for (int i = 0; i < dt.Rows.Count; i++)
{
try
{
for (int k = 0; k < dt.Columns.Count; k++)
{
if (string.IsNullOrEmpty(dt.Rows[i][k].ToString()))
{
return Content("no:导入的数据有空值!");
}
}
Course_UnitQuestion model = new Course_UnitQuestion();
model.UnitContent = UnitContent;
model.Verson = "-1";
if (dt.Rows[i][2].ToString().Trim().IndexOf(',') > 0)
{
string[] Questions = dt.Rows[i][2].ToString().Trim().Split(',');
model.Question = "[";
for (int c = 0; c < Questions.Length; c++)
{
model.Question += "{Id:" + (c + 1) + ",Content:'" + Questions[c] + "'},";
}
model.Question = model.Question.TrimEnd(',') + "]";
}
else
{
model.Question = dt.Rows[i][2].ToString().Trim();
}
switch (dt.Rows[i][0].ToString().Trim())
{
case "单选题":
model.QTtype = 1;
break;
case "多选题":
model.QTtype = 2;
break;
case "判断题":
model.QTtype = 3;
model.Question = "[{Id:1,Content:'1'},{Id:2,Content:'0'}]";
break;
default:
break;
}
model.Content = dt.Rows[i][1].ToString().Trim();
model.Answer = dt.Rows[i][3].ToString().Trim();
if (Regex.IsMatch(dt.Rows[i][4].ToString(), @"^[+-]?\d*[.]?\d*$"))
{
model.Credit = Convert.ToDouble(dt.Rows[i][4]);
}
else
{
return Content("no:权重必须是数字类型!");
}
if (dt.Rows[i][4].ToString().Length > 2)
{
return Content("no:权重数字长度不能超过五位数!");
}
if (dt.Rows[i][4].ToString() == "0")
{
return Content("no:第" + (i + 1) + "行的权重不能为0!");
}
model.Display = true;
model.Delflag = false;
model.CreateDate = DateTime.Now;
list.Add(model);
}
catch (Exception ex)
{
return Content("no:" + ex);
}
}
int count = course_UnitQuestionBLL.AddExem(list);
if (count > 0)
{
return Content("yes:成功导入" + list.Count + "行数据");
}
else
{
return Content("no:导入失败");
}
}
}
}
