private string ExamineScoreImport(DataTable dt) { if (dt != null) { foreach (DataRow row in dt.Rows) { //学员编号 姓名 身份证号 班级名称 所在站段 //岗位名称 培训性质 综合得分 安全成绩 理论成绩 实作成绩 培训成绩 //成绩性质 资格审核 证件编号 发证日期 证件性质 备注 var model = new ExamineScore(); model.ID = Guid.NewGuid(); model.StuID = row["学员编号"].ToString(); model.StuName = row["姓名"].ToString(); model.IDCardNO = row["身份证号"].ToString(); model.ClassName = row["班级名称"].ToString(); model.Station = row["所在站段"].ToString(); model.PostionName = row["岗位名称"].ToString(); model.TrainType = row["培训性质"].ToString(); model.TotalScore = row["综合得分"].ToString(); model.SecurityScore = row["安全成绩"].ToString(); model.TheoryScore = row["理论成绩"].ToString(); model.ImpScore = row["实作成绩"].ToString(); model.TrainScore = row["培训成绩"].ToString(); model.ScoreType = row["成绩性质"].ToString(); model.Qualification = row["资格审核"].ToString(); model.PaperID = row["证件编号"].ToString(); model.PaperIssuedDate = ConvertUtil.ConvertObjToNullableDateTime(row["发证日期"]); model.PaperType = row["证件性质"].ToString(); model.Remark = row["备注"].ToString(); model.CreateTime = System.DateTime.Now; model.CreateID = CurrentUser.UserId; model.CreateName = CurrentUser.UserName; model.IsValid = true; unitOfWork.ExamineScoreBLL.InsertEntity(model); } unitOfWork.Save(); } return ""; }
public string Add() { if (string.IsNullOrWhiteSpace(Request["StuID"])) { return "学员编号不能为空!"; } var stuID = Request["StuID"]; var stuName = Request["StuName"]; var iDCardNO = Request["IDCardNO"]; var className = Request["ClassName"]; var station = Request["Station"]; var postionName = Request["PostionName"]; var trainType = Request["TrainType"]; var totalScore = Request["TotalScore"]; var securityScore = Request["SecurityScore"]; var theoryScore = Request["TheoryScore"]; var impScore = Request["ImpScore"]; var trainScore = Request["TrainScore"]; var scoreType = Request["ScoreType"]; var qualification = Request["Qualification"]; var paperID = Request["PaperID"]; var paperIssuedDate = ConvertUtil.ConvertStringToNullableDateTime(Request["PaperIssuedDate"]); var paperType = Request["PaperType"]; var remark = Request["Remark"]; var model = new ExamineScore(); model.ID = Guid.NewGuid(); model.StuID = stuID; model.StuName = stuName; model.IDCardNO = iDCardNO; model.ClassName = className; model.Station = station; model.PostionName = postionName; model.TrainType = trainType; model.TotalScore = totalScore; model.SecurityScore = securityScore; model.TheoryScore = theoryScore; model.ImpScore = impScore; model.TrainScore = trainScore; model.ScoreType = scoreType; model.Qualification = qualification; model.PaperID = paperID; model.PaperIssuedDate = paperIssuedDate; model.PaperType = paperType; model.Remark = remark; model.CreateTime = System.DateTime.Now; model.CreateID = CurrentUser.UserId; model.CreateName = CurrentUser.UserName; model.IsValid = true; try { unitOfWork.ExamineScoreBLL.InsertEntity(model); unitOfWork.Save(); return ""; } catch (Exception ex) { Log.Error("保存学员成绩汇总表信息异常:" + ex.Message, ex); return "系统异常,请联系管理员!"; } }