private string ImpTeachPlanStatTwoImport(DataTable dt)
{
if (dt != null)
{
foreach (DataRow row in dt.Rows)
{
//学员编号 姓名 培训班名称 考评表编号 抽考项目 考评项目编号 考评项目名称
//考评员1 考评员1-成绩 考评员2 考评员2-成绩 监考员 考评日期 考评开始时间
//考评结束时间 考评时长 项目成绩 考评性质 备注
var model = new ImpTeachPlanStatTwo();
model.ID = Guid.NewGuid();
model.StuID = row["学员编号"].ToString();
model.StuName = row["姓名"].ToString();
model.ClassName = row["培训班名称"].ToString();
model.ExamineTableID = row["考评表编号"].ToString();
model.ExamineProject = row["抽考项目"].ToString();
model.ExamineProjectID = row["考评项目编号"].ToString();
model.ExamineProjectName = row["考评项目名称"].ToString();
model.AssessorOne = row["考评员1"].ToString();
model.AssessorOneScore = ConvertUtil.ConvertObjToNullableDecimal(row["考评员1-成绩"]);
model.AssessorTwo = row["考评员2"].ToString();
model.AssessorTwoScore = ConvertUtil.ConvertObjToNullableDecimal(row["考评员2-成绩"]);
model.Invigilator = row["监考员"].ToString();
model.ExamineDate = ConvertUtil.ConvertObjToNullableDateTime(row["考评日期"].ToString());
model.ExamineStartTime = row["考评开始时间"].ToString();
model.ExamineEndTime = row["考评结束时间"].ToString();
model.ExamineTimeOffset = row["考评时长"].ToString();
model.Score = ConvertUtil.ConvertObjToNullableDecimal(row["项目成绩"]);
model.ExamineType = row["考评性质"].ToString();
model.Remark = row["备注"].ToString();
model.CreateTime = System.DateTime.Now;
model.CreateID = CurrentUser.UserId;
model.CreateName = CurrentUser.UserName;
model.IsValid = true;
unitOfWork.ImpTeachPlanStatTwoBLL.InsertEntity(model);
}
unitOfWork.Save();
}
return "";
}
public string Add()
{
if (string.IsNullOrWhiteSpace(Request["StuID"]))
{
return "学员编号不能为空!";
}
if (string.IsNullOrWhiteSpace(Request["ExamineProjectID"]))
{
return "考评项目编号不能为空!";
}
if (string.IsNullOrWhiteSpace(Request["Score"]))
{
return "项目成绩不能为空!";
}
var stuID = Request["StuID"];
var stuName = Request["StuName"];
var className = Request["ClassName"];
var examineTableID = Request["ExamineTableID"];
var examineProject = Request["ExamineProject"];
var examineProjectID = Request["ExamineProjectID"];
var examineProjectName = Request["ExamineProjectName"];
var assessorOne = Request["AssessorOne"];
var assessorOneScore = ConvertUtil.ConvertStringToNullableDecimal(Request["AssessorOneScore"]);
var assessorTwo = Request["AssessorTwo"];
var assessorTwoScore = ConvertUtil.ConvertStringToNullableDecimal(Request["AssessorTwoScore"]);
var invigilator = Request["Invigilator"];
var examineDate = ConvertUtil.ConvertStringToNullableDateTime(Request["ExamineDate"]);
var examineStartTime = Request["ExamineStartTime"];
var examineEndTime = Request["ExamineEndTime"];
var examineTimeOffset = Request["ExamineTimeOffset"];
var score = ConvertUtil.ConvertStringToNullableDecimal(Request["Score"]);
var examineType = Request["ExamineType"];
var remark = Request["Remark"];
var model = new ImpTeachPlanStatTwo();
model.ID = Guid.NewGuid();
model.StuID = stuID;
model.StuName = stuName;
model.ClassName = className;
model.ExamineTableID = examineTableID;
model.ExamineProject = examineProject;
model.ExamineProjectID = examineProjectID;
model.ExamineProjectName = examineProjectName;
model.AssessorOne = assessorOne;
model.AssessorOneScore = assessorOneScore;
model.AssessorTwo = assessorTwo;
model.AssessorTwoScore = assessorTwoScore;
model.Invigilator = invigilator;
model.ExamineDate = examineDate;
model.ExamineStartTime = examineStartTime;
model.ExamineEndTime = examineEndTime;
model.ExamineTimeOffset = examineTimeOffset;
model.Score = score;
model.ExamineType = examineType;
model.Remark = remark;
model.CreateTime = System.DateTime.Now;
model.CreateID = CurrentUser.UserId;
model.CreateName = CurrentUser.UserName;
model.IsValid = true;
try
{
unitOfWork.ImpTeachPlanStatTwoBLL.InsertEntity(model);
unitOfWork.Save();
return "";
}
catch (Exception ex)
{
Log.Error("保存实作考评成绩登记表信息异常：" + ex.Message, ex);
return "系统异常,请联系管理员！";
}
}