private string ExamineStatImport(DataTable dt)
{
if (dt != null)
{
foreach (DataRow row in dt.Rows)
{
//收报时间 电报号 岗位名称 培训班性质 班级名称 班主任
//开班日期 结束日期 参培人数 考试人数 安全补考人数
//理论补考人数 实作补考人数 一次通过人数 一次通过率 补考不合格人数
//培训合格率 优秀人数 优秀率 备注
var model = new ExamineStat();
model.ID = Guid.NewGuid();
model.TelegraphReceiveDate = ConvertUtil.ConvertObjToNullableDateTime(row["收报时间"]);
model.TelegraphNO = row["电报号"].ToString();
model.TrainPostion = row["岗位名称"].ToString();
model.TrainType = row["培训班性质"].ToString();
model.ClassName = row["班级名称"].ToString();
model.ClassTeacher = row["班主任"].ToString();
model.ClassBeginDate = ConvertUtil.ConvertObjToNullableDateTime(row["开班日期"]);
model.ClassEndDate = ConvertUtil.ConvertObjToNullableDateTime(row["结束日期"]);
model.TrainerNum = ConvertUtil.ConvertObjToNullableInt(row["参培人数"]);
model.ExamineNum = ConvertUtil.ConvertObjToNullableInt(row["考试人数"]);
model.SecurityMakeupNum = ConvertUtil.ConvertObjToNullableInt(row["安全补考人数"]);
model.TheoryMakeupNum = ConvertUtil.ConvertObjToNullableInt(row["理论补考人数"]);
model.ImpMakeupNum = ConvertUtil.ConvertObjToNullableInt(row["实作补考人数"]);
model.OneTimePassNum = ConvertUtil.ConvertObjToNullableInt(row["一次通过人数"]);
model.OneTimePassRate = row["一次通过率"].ToString();
model.MakeupFailNum = ConvertUtil.ConvertObjToNullableInt(row["补考不合格人数"]);
model.PassRate = row["培训合格率"].ToString();
model.ExcellentNum = ConvertUtil.ConvertObjToNullableInt(row["优秀人数"].ToString());
model.ExcellentRate = row["优秀率"].ToString();
model.Remark = row["备注"].ToString();
model.CreateTime = System.DateTime.Now;
model.CreateID = CurrentUser.UserId;
model.CreateName = CurrentUser.UserName;
model.IsValid = true;
unitOfWork.ExamineStatBLL.InsertEntity(model);
}
unitOfWork.Save();
}
return "";
}
public string Add()
{
if (string.IsNullOrWhiteSpace(Request["ClassName"]))
{
return "班级名称不能为空!";
}
var telegraphReceiveDate = ConvertUtil.ConvertStringToNullableDateTime(Request["TelegraphReceiveDate"]);
var telegraphNO = Request["TelegraphNO"];
var trainPostion = Request["TrainPostion"];
var trainType = Request["TrainType"];
var className = Request["ClassName"];
var classTeacher = Request["ClassTeacher"];
var classBeginDate = ConvertUtil.ConvertStringToNullableDateTime(Request["ClassBeginDate"]);
var classEndDate = ConvertUtil.ConvertStringToNullableDateTime(Request["ClassEndDate"]);
var trainerNum = ConvertUtil.ConvertStringToNullableInt(Request["TrainerNum"]);
var examineNum = ConvertUtil.ConvertStringToNullableInt(Request["ExamineNum"]);
var securityMakeupNum = ConvertUtil.ConvertStringToNullableInt(Request["SecurityMakeupNum"]);
var theoryMakeupNum = ConvertUtil.ConvertStringToNullableInt(Request["TheoryMakeupNum"]);
var impMakeupNum = ConvertUtil.ConvertStringToNullableInt(Request["ImpMakeupNum"]);
var oneTimePassNum = ConvertUtil.ConvertStringToNullableInt(Request["OneTimePassNum"]);
var oneTimePassRate = ConvertUtil.ConvertStringToNullableDecimal(Request["OneTimePassRate"]) == null
? null
: (Request["OneTimePassRate"] + "%");
var makeupFailNum = ConvertUtil.ConvertStringToNullableInt(Request["MakeupFailNum"]);
var passRate = ConvertUtil.ConvertStringToNullableDecimal(Request["PassRate"]) == null
? null
: (Request["PassRate"] + "%");
var excellentNum = ConvertUtil.ConvertStringToNullableInt(Request["ExcellentNum"]);
var excellentRate = ConvertUtil.ConvertStringToNullableDecimal(Request["ExcellentRate"]) == null
? null
: (Request["ExcellentRate"] + "%");
var remark = Request["Remark"];
var model = new ExamineStat();
model.ID = Guid.NewGuid();
model.TelegraphReceiveDate = telegraphReceiveDate;
model.TelegraphNO = telegraphNO;
model.TrainPostion = trainPostion;
model.TrainType = trainType;
model.ClassName = className;
model.ClassTeacher = classTeacher;
model.ClassBeginDate = classBeginDate;
model.ClassEndDate = classEndDate;
model.TrainerNum = trainerNum;
model.ExamineNum = examineNum;
model.SecurityMakeupNum = securityMakeupNum;
model.TheoryMakeupNum = theoryMakeupNum;
model.ImpMakeupNum = impMakeupNum;
model.OneTimePassNum = oneTimePassNum;
model.OneTimePassRate = oneTimePassRate;
model.OneTimePassRate = oneTimePassRate;
model.MakeupFailNum = makeupFailNum;
model.PassRate = passRate;
model.ExcellentNum = excellentNum;
model.ExcellentRate = excellentRate;
model.Remark = remark;
model.CreateTime = System.DateTime.Now;
model.CreateID = CurrentUser.UserId;
model.CreateName = CurrentUser.UserName;
model.IsValid = true;
try
{
unitOfWork.ExamineStatBLL.InsertEntity(model);
unitOfWork.Save();
return "";
}
catch (Exception ex)
{
Log.Error("保存培训通过率报表信息异常：" + ex.Message, ex);
return "系统异常,请联系管理员！";
}
}