private string ImpBasicOneImport(DataTable dt)
{
if (dt != null)
{
foreach (DataRow row in dt.Rows)
{
//抽考项目 考评日期 建议考评日期（从课程计划表中抓取，） 实训项目编号
//实训项目名称 实训教案编号 实训教案名称 实训教案挂网时间 实训教案评审时间
//实训教案评审结果 实作考核评分表编号 实作考核评分表名称 实作考核评分表挂网时间
//考核时段 考核项目编号 考核项目名称 学员签认 监考员 考评员1 考评员2
//考试起始时间 考试结束时间 时长 成绩 考核项目成绩性质 考核项目是否合格
//是否补考 补考成绩 总时长 总成绩 考核结果 参加实作考核人数 一次通过率 合格人数 不合格人数 合格率（%） 备注
var model = new ImpBasicOne();
model.ID = Guid.NewGuid();
model.ExamineProject = row["抽考项目"].ToString();
model.ExamineDate = ConvertUtil.ConvertObjToNullableDateTime(row["考评日期"]);
model.SuggestExamineDate = ConvertUtil.ConvertObjToNullableDateTime(row["建议考评日期"]);
model.ProjectID = row["实训项目编号"].ToString();
model.ProjectName = row["实训项目名称"].ToString();
model.TeachPlanID = row["实训教案编号"].ToString();
model.TeachPlanName = row["实训教案名称"].ToString();
model.TeachPlanOnlineDate = ConvertUtil.ConvertObjToNullableDateTime(row["实训教案挂网时间"]);
model.TeachPlanEvaluateDate = ConvertUtil.ConvertObjToNullableDateTime(row["实训教案评审时间"]);
model.TeachPlanEvaluateResult = row["实训教案评审结果"].ToString();
model.ExamineRateID = row["实作考核评分表编号"].ToString();
model.ExamineRateName = row["实作考核评分表名称"].ToString();
model.ExamineRateOnlinDate = ConvertUtil.ConvertObjToNullableDateTime(row["实作考核评分表挂网时间"]);
model.ExaminePeriod = row["考核时段"].ToString();
model.ExamineProjectID = row["考核项目编号"].ToString();
model.ExamineProjectName = row["考核项目名称"].ToString();
model.Signed = row["学员签认"].ToString();
model.Invigilator = row["监考员"].ToString();
model.AssessorOne = row["考评员1"].ToString();
model.AssessorTwo = row["考评员2"].ToString();
model.ExamineStartTime = row["考试起始时间"].ToString();
model.ExamineEndTime = row["考试结束时间"].ToString();
model.ExamineTimeOffset = row["时长"].ToString();
model.Score = ConvertUtil.ConvertObjToNullableDecimal(row["成绩"]);
model.ExamineScoreType = row["考核项目成绩性质"].ToString();
model.Passed = row["考核项目是否合格"].ToString();
model.MakeUp = row["是否补考"].ToString();
model.MakeUpScore = ConvertUtil.ConvertObjToNullableDecimal(row["补考成绩"]);
model.TotalTimeOffset = row["总时长"].ToString();
model.TotalScore = ConvertUtil.ConvertObjToNullableDecimal(row["总成绩"]);
model.ExamineResult = row["考核结果"].ToString();
model.ImpExamineNum = ConvertUtil.ConvertObjToNullableInt(row["参加实作考核人数"]);
model.OneTimeRate = row["一次通过率"].ToString();
model.QualifiedNum = ConvertUtil.ConvertObjToNullableInt(row["合格人数"]);
model.UnqualifiedNum = ConvertUtil.ConvertObjToNullableInt(row["不合格人数"]);
model.QualifiedRate = row["合格率"].ToString();
model.Remark = row["备注"].ToString();
model.CreateTime = System.DateTime.Now;
model.CreateID = CurrentUser.UserId;
model.CreateName = CurrentUser.UserName;
model.IsValid = true;
unitOfWork.ImpBasicOneBLL.InsertEntity(model);
}
unitOfWork.Save();
}
return "";
}
public string Add()
{
var examineProject = Request["ExamineProject"];
var examineDate = ConvertUtil.ConvertStringToNullableDateTime(Request["ExamineDate"]);
var suggestExamineDate = ConvertUtil.ConvertStringToNullableDateTime(Request["SuggestExamineDate"]);
var projectID = Request["ProjectID"];
var projectName = Request["ProjectName"];
var teachPlanID = Request["TeachPlanID"];
var teachPlanName = Request["TeachPlanName"];
var teachPlanOnlineDate = ConvertUtil.ConvertStringToNullableDateTime(Request["TeachPlanOnlineDate"]);
var teachPlanEvaluateDate = ConvertUtil.ConvertStringToNullableDateTime(Request["TeachPlanEvaluateDate"]);
var teachPlanEvaluateResult = Request["TeachPlanEvaluateResult"];
var examineRateID = Request["ExamineRateID"];
var examineRateName = Request["ExamineRateName"];
var examineRateOnlinDate = ConvertUtil.ConvertStringToNullableDateTime(Request["ExamineRateOnlinDate"]);
var examinePeriod = Request["ExaminePeriod"];
var examineProjectID = Request["ExamineProjectID"];
var examineProjectName = Request["ExamineProjectName"];
var signed = Request["Signed"];
var invigilator = Request["Invigilator"];
var assessorOne = Request["AssessorOne"];
var assessorTwo = Request["AssessorTwo"];
var examineStartTime = Request["ExamineStartTime"];
var examineEndTime = Request["ExamineEndTime"];
var examineTimeOffset = Request["ExamineTimeOffset"];
var score = ConvertUtil.ConvertStringToNullableDecimal(Request["Score"]);
var examineScoreType = Request["ExamineScoreType"];
var passed = Request["Passed"];
var makeUp = Request["MakeUp"];
var makeUpScore = ConvertUtil.ConvertStringToNullableDecimal(Request["MakeUpScore"]);
var totalTimeOffset = Request["TotalTimeOffset"];
var totalScore = ConvertUtil.ConvertStringToNullableDecimal(Request["TotalScore"]);
var examineResult = Request["ExamineResult"];
var impExamineNum = ConvertUtil.ConvertStringToNullableInt(Request["ImpExamineNum"]);
var oneTimeRate = string.IsNullOrWhiteSpace(Request["OneTimeRate"])
? string.Empty
: (Request["OneTimeRate"] + "%");
var qualifiedNum = ConvertUtil.ConvertStringToNullableInt(Request["QualifiedNum"]);
var unqualifiedNum = ConvertUtil.ConvertStringToNullableInt(Request["UnqualifiedNum"]);
var qualifiedRate = string.IsNullOrWhiteSpace(Request["QualifiedRate"])
? string.Empty
: (Request["QualifiedRate"] + "%");
var remark = Request["Remark"];
var model = new ImpBasicOne();
model.ID = Guid.NewGuid();
model.ExamineProject = examineProject;
model.ExamineDate = examineDate;
model.SuggestExamineDate = suggestExamineDate;
model.ProjectID = projectID;
model.ProjectName = projectName;
model.TeachPlanID = teachPlanID;
model.TeachPlanName = teachPlanName;
model.TeachPlanOnlineDate = teachPlanOnlineDate;
model.TeachPlanEvaluateDate = teachPlanEvaluateDate;
model.TeachPlanEvaluateResult = teachPlanEvaluateResult;
model.ExamineRateID = examineRateID;
model.ExamineRateName = examineRateName;
model.ExamineRateOnlinDate = examineRateOnlinDate;
model.ExaminePeriod = examinePeriod;
model.ExamineProjectID = examineProjectID;
model.ExamineProjectName = examineProjectName;
model.Signed = signed;
model.Invigilator = invigilator;
model.AssessorOne = assessorOne;
model.AssessorTwo = assessorTwo;
model.ExamineStartTime = examineStartTime;
model.ExamineEndTime = examineEndTime;
model.ExamineTimeOffset = examineTimeOffset;
model.Score = score;
model.ExamineScoreType = examineScoreType;
model.Passed = passed;
model.MakeUp = makeUp;
model.MakeUpScore = makeUpScore;
model.TotalTimeOffset = totalTimeOffset;
model.TotalScore = totalScore;
model.ExamineResult = examineResult;
model.ImpExamineNum = impExamineNum;
model.OneTimeRate = oneTimeRate;
model.QualifiedNum = qualifiedNum;
model.UnqualifiedNum = unqualifiedNum;
model.QualifiedRate = qualifiedRate;
model.Remark = remark;
model.CreateTime = System.DateTime.Now;
model.CreateID = CurrentUser.UserId;
model.CreateName = CurrentUser.UserName;
model.IsValid = true;
try
{
unitOfWork.ImpBasicOneBLL.InsertEntity(model);
unitOfWork.Save();
return "";
}
catch (Exception ex)
{
Log.Error("保存认证部反馈实作基本信息异常：" + ex.Message, ex);
return "系统异常,请联系管理员！";
}
}
