/// <summary>
/// 添加Excel的数据
/// </summary>
/// <param name="xmlDate"></param>
private string AddExcelData(DataTable xmlDate, string testLimit, int testSetID, string testTeacher, string testAddress, string testBeginDate, string testBeginWeek, string testBeginTime, string testGroup, string groupCount, string testType, string NK)
{
//还原分组和分配老师
dTestAllotBll.DelDStudentTestAllotByTestSetID(Convert.ToInt32(testSetID), CookieHelper.GetCookie("NK"));
string errorMsg = "";
int errorcount = 0; //错误的个数
int sumcount = xmlDate.Rows.Count; //导入数据的总个数
int rowindex = 1; //行标
string comname = string.Empty;
int i = 1;
foreach (DataRow excelRow in xmlDate.Rows)
{
DStudent_Test testModel = null;
bool flg = true;//可添加入库的标识
rowindex++;
try
{
comname = excelRow[0].ToString().Trim();
DStudent_Infos model = dInfoBll.GetDStudentInfosModel(excelRow[0].ToString().Trim(), NK);
if (model.SchoolCode == "" || model == null || model.StudentCode == null)
{
if (flg)
{
errorcount++;
}
errorMsg = errorMsg + ErrorMsgTitle(rowindex, comname) + ",添加失败;失败原因:库中不存在该学生，添加测试失败！ <br/>";
flg = false;
}
else if (model.StudentSex != excelRow[1].ToString().Trim())
{
if (flg)
{
errorcount++;
}
errorMsg = errorMsg + ErrorMsgTitle(rowindex, comname) + ",添加失败;失败原因:学生性别和该条测试信息性别不相同，添加测试失败！<br/>";
flg = false;
}
else
{
if (model.GradeCode != "40")
{
if (model.GradeCode == testLimit)
{
}
else
{
testModel = new DStudent_Test
{
StudentCode = model.StudentCode,
GradeCode = model.GradeCode,
SchoolCode = model.SchoolCode,
SchoolName = model.SchoolName,
ClassCode = model.ClassCode,
ClassName = model.ClassName,
TestSetID = testSetID,
StudentName = model.StudentName,
StudentSex = model.StudentSex,
TestTeacher = testTeacher,
TestAddress = testAddress,
BeginPraDate = testBeginDate,
BeginWeek = testBeginWeek,
BeginPraTime = testBeginTime,
ApplyFor = "1",
TestGroup = testGroup,
TestGroupCode = groupCount == "" ? "" : (Convert.ToInt32(groupCount) + 1).ToString(),
TestType = testType,
CreateTime = System.DateTime.Now.ToString(),
UpdateTime = System.DateTime.Now.ToString(),
Remark = ""
};
}
}
else
{
testModel = new DStudent_Test
{
StudentCode = model.StudentCode,
GradeCode = model.GradeCode,
SchoolCode = model.SchoolCode,
SchoolName = model.SchoolName,
ClassCode = model.ClassCode,
ClassName = model.ClassName,
TestSetID = testSetID,
StudentName = model.StudentName,
StudentSex = model.StudentSex,
TestTeacher = testTeacher,
TestAddress = testAddress,
BeginPraDate = testBeginDate,
BeginWeek = testBeginWeek,
BeginPraTime = testBeginTime,
ApplyFor = "1",
TestGroup = testGroup,
TestGroupCode = groupCount == "" ? "" : (Convert.ToInt32(groupCount) + 1).ToString(),
TestType = testType,
CreateTime = System.DateTime.Now.ToString(),
UpdateTime = System.DateTime.Now.ToString(),
Remark = ""
};
}
}
}
catch (Exception ex)
{
if (flg)
{
errorcount++;
}
errorMsg = errorMsg + ErrorMsgTitle(rowindex, comname) + ",添加失败;失败原因:" + ex.Message + "<br/>";
flg = false;
}
if (flg)
{
int result = 1;
try
{
//导入信息返回的结果
result = dTestBll.AddDStudentTestAdmin(testModel, CookieHelper.GetCookie("NK"));
if (result == 2)
{
if (flg)
{
errorcount++;
}
errorMsg = errorMsg + ErrorMsgTitle(rowindex, comname) + "(数据库已经存在),添加失败" + "<br/>";
}
else if (result <= 0)
{
if (flg)
{
errorcount++;
}
errorMsg = errorMsg + ErrorMsgTitle(rowindex, comname) + "添加失败(原因:数据库可能存在)" + "<br/>";
}
}
catch (Exception ex)
{
errorcount++;
errorMsg = errorMsg + ErrorMsgTitle(rowindex, comname) + "添加失败;失败原因:" + ex.Message + "<br/>";
}
}
i++;
}
string importMsg = "共导入【" + sumcount + "】条记录<br/>" +
"导入成功【" + (sumcount - errorcount) + "】条记录<br/>" +
"导入失败【" + (errorcount) + "】条记录<br/>";
return(importMsg + "<br><div style='color:blue' id='errorMsg'>" + errorMsg + "</div>");
}
//添加学生测试
public ActionResult AddTestStudent(string studentCode, int testSetID, string studentSex, string testBeginDate, string testBeginWeek, string testBeginTime, string testAddress, string testGroup, string groupCount, string testTeacher, string testType, string testLimit)
{
try
{
DStudent_Infos model = dInfoBll.GetDStudentInfosModel(studentCode, CookieHelper.GetCookie("NK"));
if (model.SchoolCode == "" || model == null || model.StudentCode == null)
{
return(Content(new JsonMessage {
Success = false, Code = "0", Message = "库中不存在该学生，添加测试失败！"
}.ToString()));
}
else if (model.StudentSex != studentSex)
{
return(Content(new JsonMessage {
Success = false, Code = "0", Message = "学生性别和该条测试信息性别不相同，添加测试失败！"
}.ToString()));
}
else
{
if (testLimit != "40")
{
//如果学生不符合测试限制，则无法测试
if (model.GradeCode != testLimit)
{
return(Content(new JsonMessage {
Success = false, Code = "0", Message = "该学生不符合测试限制！"
}.ToString()));
}
else
{
DStudent_Test testModel = new DStudent_Test
{
StudentCode = model.StudentCode,
GradeCode = model.GradeCode,
SchoolCode = model.SchoolCode,
SchoolName = model.SchoolName,
ClassCode = model.ClassCode,
ClassName = model.ClassName,
TestSetID = testSetID,
StudentName = model.StudentName,
StudentSex = model.StudentSex,
TestTeacher = testTeacher,
TestAddress = testAddress,
BeginPraDate = testBeginDate,
BeginWeek = testBeginWeek,
BeginPraTime = testBeginTime,
ApplyFor = "1",
TestGroup = testGroup,
TestGroupCode = groupCount == "" ? "" : (Convert.ToInt32(groupCount) + 1).ToString(),
TestType = testType,
CreateTime = System.DateTime.Now.ToString(),
UpdateTime = System.DateTime.Now.ToString(),
Remark = ""
};
int n = dTestBll.AddDStudentTestAdmin(testModel, CookieHelper.GetCookie("NK"));
if (n == 1)
{
return(Content(new JsonMessage {
Success = true, Code = "1", Message = "添加成功！"
}.ToString()));
}
else
{
return(Content(new JsonMessage {
Success = true, Code = "0", Message = "该学生已经约考，不能重复添加！"
}.ToString()));
}
}
}
else
{
DStudent_Test testModel = new DStudent_Test
{
StudentCode = model.StudentCode,
GradeCode = model.GradeCode,
SchoolCode = model.SchoolCode,
SchoolName = model.SchoolName,
ClassCode = model.ClassCode,
ClassName = model.ClassName,
TestSetID = testSetID,
StudentName = model.StudentName,
StudentSex = model.StudentSex,
TestTeacher = testTeacher,
TestAddress = testAddress,
BeginPraDate = testBeginDate,
BeginWeek = testBeginWeek,
BeginPraTime = testBeginTime,
ApplyFor = "1",
TestGroup = testGroup,
TestGroupCode = groupCount == "" ? "" : (Convert.ToInt32(groupCount) + 1).ToString(),
TestType = testType,
CreateTime = System.DateTime.Now.ToString(),
UpdateTime = System.DateTime.Now.ToString(),
Remark = ""
};
int n = dTestBll.AddDStudentTestAdmin(testModel, CookieHelper.GetCookie("NK"));
if (n == 1)
{
return(Content(new JsonMessage {
Success = true, Code = "1", Message = "添加成功！"
}.ToString()));
}
else
{
return(Content(new JsonMessage {
Success = true, Code = "0", Message = "该学生已经约考，不能重复添加！"
}.ToString()));
}
}
}
}
catch (Exception ex)
{
Base_SysLogBll.Instance.WriteLog("", OperationType.Add, "-1", "异常错误：" + ex.Message);
return(null);
}
}
