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