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 "系统异常,请联系管理员!"; } }