public string Add() { var telegraphSendDate = ConvertUtil.ConvertStringToNullableDateTime(Request["TelegraphSendDate"]); var telegraphReceiveDate = ConvertUtil.ConvertStringToNullableDateTime(Request["TelegraphReceiveDate"]); var telegraphNO = Request["TelegraphNO"]; var telegraphName = Request["TelegraphName"]; var trainPostion = Request["TrainPostion"]; var trainType = Request["TrainType"]; var className = Request["ClassName"]; var classBeginDate = ConvertUtil.ConvertStringToNullableDateTime(Request["ClassBeginDate"]); var classEndDate = ConvertUtil.ConvertStringToNullableDateTime(Request["ClassEndDate"]); var classTeacher = Request["ClassTeacher"]; var classRoom = Request["ClassRoom"]; var stuID = Request["StuID"]; var stuName = Request["StuName"]; var sex = Request["Sex"]; var railwayOffice = Request["RailwayOffice"]; var station = Request["Station"]; var iDCardNO = Request["IDCardNO"]; var workID = Request["WorkID"]; var telephoneNO = Request["TelephoneNO"]; var examineProject = Request["ExamineProject"]; var examineDate = ConvertUtil.ConvertStringToNullableDateTime(Request["ExamineDate"]); var invigilator = Request["Invigilator"]; var p1ExamineProjectID = Request["P1ExamineProjectID"]; var p1ExamineProjectName =Request["P1ExamineProjectName"]; var p1ExamineStartTime = Request["P1ExamineStartTime"]; var p1ExamineEndTime = Request["P1ExamineEndTime"]; var p1AssessorOne = Request["P1AssessorOne"]; var p1AssessorTwo = Request["P1AssessorTwo"]; var p1ExamineTimeOffset = Request["P1ExamineTimeOffset"]; var p1Score = ConvertUtil.ConvertStringToNullableDecimal(Request["P1Score"]); var p2ExamineProjectID = Request["P2ExamineProjectID"]; var p2ExamineProjectName = Request["P2ExamineProjectName"]; var p2ExamineStartTime = Request["P2ExamineStartTime"]; var p2ExamineEndTime = Request["P2ExamineEndTime"]; var p2AssessorOne = Request["P2AssessorOne"]; var p2AssessorTwo = Request["P2AssessorTwo"]; var p2ExamineTimeOffset = Request["P2ExamineTimeOffset"]; var p2Score = ConvertUtil.ConvertStringToNullableDecimal(Request["P2Score"]); var p3ExamineProjectID = Request["P3ExamineProjectID"]; var p3ExamineProjectName = Request["P3ExamineProjectName"]; var p3ExamineStartTime = Request["P3ExamineStartTime"]; var p3ExamineEndTime = Request["P3ExamineEndTime"]; var p3AssessorOne = Request["P3AssessorOne"]; var p3AssessorTwo = Request["P3AssessorTwo"]; var p3ExamineTimeOffset = Request["P3ExamineTimeOffset"]; var p3Score = ConvertUtil.ConvertStringToNullableDecimal(Request["P3Score"]); var p4ExamineProjectID = Request["P4ExamineProjectID"]; var p4ExamineProjectName = Request["P4ExamineProjectName"]; var p4ExamineStartTime = Request["P4ExamineStartTime"]; var p4ExamineEndTime = Request["P4ExamineEndTime"]; var p4AssessorOne = Request["P4AssessorOne"]; var p4AssessorTwo = Request["P4AssessorTwo"]; var p4ExamineTimeOffset = Request["P4ExamineTimeOffset"]; var p4Score = ConvertUtil.ConvertStringToNullableDecimal(Request["P4Score"]); var p5ExamineProjectID = Request["P5ExamineProjectID"]; var p5ExamineProjectName = Request["P5ExamineProjectName"]; var p5ExamineStartTime = Request["P5ExamineStartTime"]; var p5ExamineEndTime = Request["P5ExamineEndTime"]; var p5AssessorOne = Request["P5AssessorOne"]; var p5AssessorTwo = Request["P5AssessorTwo"]; var p5ExamineTimeOffset = Request["P5ExamineTimeOffset"]; var p5Score = ConvertUtil.ConvertStringToNullableDecimal(Request["P5Score"]); var p6ExamineProjectID = Request["P6ExamineProjectID"]; var p6ExamineProjectName = Request["P6ExamineProjectName"]; var p6ExamineStartTime = Request["P6ExamineStartTime"]; var p6ExamineEndTime = Request["P6ExamineEndTime"]; var p6AssessorOne = Request["P6AssessorOne"]; var p6AssessorTwo = Request["P6AssessorTwo"]; var p6ExamineTimeOffset = Request["P6ExamineTimeOffset"]; var p6Score = ConvertUtil.ConvertStringToNullableDecimal(Request["P6Score"]); var p7ExamineProjectID = Request["P7ExamineProjectID"]; var p7ExamineProjectName = Request["P7ExamineProjectName"]; var p7ExamineStartTime = Request["P7ExamineStartTime"]; var p7ExamineEndTime = Request["P7ExamineEndTime"]; var p7AssessorOne = Request["P7AssessorOne"]; var p7AssessorTwo = Request["P7AssessorTwo"]; var p7ExamineTimeOffset = Request["P7ExamineTimeOffset"]; var p7Score = ConvertUtil.ConvertStringToNullableDecimal(Request["P7Score"]); var p8ExamineProjectID = Request["P8ExamineProjectID"]; var p8ExamineProjectName = Request["P8ExamineProjectName"]; var p8ExamineStartTime = Request["P8ExamineStartTime"]; var p8ExamineEndTime = Request["P8ExamineEndTime"]; var p8AssessorOne = Request["P8AssessorOne"]; var p8AssessorTwo = Request["P8AssessorTwo"]; var p8ExamineTimeOffset = Request["P8ExamineTimeOffset"]; var p8Score = ConvertUtil.ConvertStringToNullableDecimal(Request["P8Score"]); var p9ExamineProjectID = Request["P9ExamineProjectID"]; var p9ExamineProjectName = Request["P9ExamineProjectName"]; var p9ExamineStartTime = Request["P9ExamineStartTime"]; var p9ExamineEndTime = Request["P9ExamineEndTime"]; var p9AssessorOne = Request["P9AssessorOne"]; var p9AssessorTwo = Request["P9AssessorTwo"]; var p9ExamineTimeOffset = Request["P9ExamineTimeOffset"]; var p9Score = ConvertUtil.ConvertStringToNullableDecimal(Request["P9Score"]); var p10ExamineProjectID = Request["P10ExamineProjectID"]; var p10ExamineProjectName = Request["P10ExamineProjectName"]; var p10ExamineStartTime = Request["P10ExamineStartTime"]; var p10ExamineEndTime = Request["P10ExamineEndTime"]; var p10AssessorOne = Request["P10AssessorOne"]; var p10AssessorTwo = Request["P10AssessorTwo"]; var p10ExamineTimeOffset = Request["P10ExamineTimeOffset"]; var p10Score = ConvertUtil.ConvertStringToNullableDecimal(Request["P10Score"]); var totalTimeOffset = Request["TotalTimeOffset"]; var totalScore = ConvertUtil.ConvertStringToNullableDecimal(Request["TotalScore"]); var makeUpProject = Request["MakeUpProject"]; var makeUpTimes = ConvertUtil.ConvertStringToNullableInt(Request["MakeUpTimes"]); var passed = Request["Passed"]; var model = new ImpBasicTwo(); model.ID = Guid.NewGuid(); model.TelegraphSendDate = telegraphSendDate; model.TelegraphReceiveDate = telegraphReceiveDate; model.TelegraphNO = telegraphNO; model.TelegraphName = telegraphName; model.TrainPostion = trainPostion; model.TrainType = trainType; model.ClassName = className; model.ClassBeginDate = classBeginDate; model.ClassEndDate = classEndDate; model.ClassTeacher = classTeacher; model.ClassRoom = classRoom; model.StuID = stuID; model.StuName = stuName; model.Sex = sex; model.RailwayOffice = railwayOffice; model.Station = station; model.IDCardNO = iDCardNO; model.WorkID = workID; model.TelephoneNO = telephoneNO; model.ExamineProject = examineProject; model.ExamineDate = examineDate; model.Invigilator = invigilator; model.P1ExamineProjectID = p1ExamineProjectID; model.P1ExamineProjectName = p1ExamineProjectName; model.P1ExamineStartTime = p1ExamineStartTime; model.P1ExamineEndTime = p1ExamineEndTime; model.P1AssessorOne = p1AssessorOne; model.P1AssessorTwo = p1AssessorTwo; model.P1ExamineTimeOffset = p1ExamineTimeOffset; model.P1Score = p1Score; model.P2ExamineProjectID = p2ExamineProjectID; model.P2ExamineProjectName = p2ExamineProjectName; model.P2ExamineStartTime = p2ExamineStartTime; model.P2ExamineEndTime = p2ExamineEndTime; model.P2AssessorOne = p2AssessorOne; model.P2AssessorTwo = p2AssessorTwo; model.P2ExamineTimeOffset = p2ExamineTimeOffset; model.P2Score = p2Score; model.P3ExamineProjectID = p3ExamineProjectID; model.P3ExamineProjectName = p3ExamineProjectName; model.P3ExamineStartTime = p3ExamineStartTime; model.P3ExamineEndTime = p3ExamineEndTime; model.P3AssessorOne = p3AssessorOne; model.P3AssessorTwo = p3AssessorTwo; model.P3ExamineTimeOffset = p3ExamineTimeOffset; model.P3Score = p3Score; model.P4ExamineProjectID = p4ExamineProjectID; model.P4ExamineProjectName = p4ExamineProjectName; model.P4ExamineStartTime = p4ExamineStartTime; model.P4ExamineEndTime = p4ExamineEndTime; model.P4AssessorOne = p4AssessorOne; model.P4AssessorTwo = p4AssessorTwo; model.P4ExamineTimeOffset = p4ExamineTimeOffset; model.P4Score = p4Score; model.P5ExamineProjectID = p5ExamineProjectID; model.P5ExamineProjectName = p5ExamineProjectName; model.P5ExamineStartTime = p5ExamineStartTime; model.P5ExamineEndTime = p5ExamineEndTime; model.P5AssessorOne = p5AssessorOne; model.P5AssessorTwo = p5AssessorTwo; model.P5ExamineTimeOffset = p5ExamineTimeOffset; model.P5Score = p5Score; model.P6ExamineProjectID = p6ExamineProjectID; model.P6ExamineProjectName = p6ExamineProjectName; model.P6ExamineStartTime = p6ExamineStartTime; model.P6ExamineEndTime = p6ExamineEndTime; model.P6AssessorOne = p6AssessorOne; model.P6AssessorTwo = p6AssessorTwo; model.P6ExamineTimeOffset = p6ExamineTimeOffset; model.P6Score = p6Score; model.P7ExamineProjectID = p7ExamineProjectID; model.P7ExamineProjectName = p7ExamineProjectName; model.P7ExamineStartTime = p7ExamineStartTime; model.P7ExamineEndTime = p7ExamineEndTime; model.P7AssessorOne = p7AssessorOne; model.P7AssessorTwo = p7AssessorTwo; model.P7ExamineTimeOffset = p7ExamineTimeOffset; model.P7Score = p7Score; model.P8ExamineProjectID = p8ExamineProjectID; model.P8ExamineProjectName = p8ExamineProjectName; model.P8ExamineStartTime = p8ExamineStartTime; model.P8ExamineEndTime = p8ExamineEndTime; model.P8AssessorOne = p8AssessorOne; model.P8AssessorTwo = p8AssessorTwo; model.P8ExamineTimeOffset = p8ExamineTimeOffset; model.P8Score = p8Score; model.P9ExamineProjectID = p9ExamineProjectID; model.P9ExamineProjectName = p9ExamineProjectName; model.P9ExamineStartTime = p9ExamineStartTime; model.P9ExamineEndTime = p9ExamineEndTime; model.P9AssessorOne = p9AssessorOne; model.P9AssessorTwo = p9AssessorTwo; model.P9ExamineTimeOffset = p9ExamineTimeOffset; model.P9Score = p9Score; model.P10ExamineProjectID = p10ExamineProjectID; model.P10ExamineProjectName = p10ExamineProjectName; model.P10ExamineStartTime = p10ExamineStartTime; model.P10ExamineEndTime = p10ExamineEndTime; model.P10AssessorOne = p10AssessorOne; model.P10AssessorTwo = p10AssessorTwo; model.P10ExamineTimeOffset = p10ExamineTimeOffset; model.P10Score = p10Score; model.TotalTimeOffset = totalTimeOffset; model.TotalScore = totalScore; model.MakeUpProject = makeUpProject; model.MakeUpTimes = makeUpTimes; model.Passed = passed; model.CreateTime = System.DateTime.Now; model.CreateID = CurrentUser.UserId; model.CreateName = CurrentUser.UserName; model.IsValid = true; try { unitOfWork.ImpBasicTwoBLL.InsertEntity(model); unitOfWork.Save(); return ""; } catch (Exception ex) { Log.Error("保存认证部反馈实作基本信息异常:" + ex.Message, ex); return "系统异常,请联系管理员!"; } }
private string ImpBasicTwoImport(DataTable dt) { if (dt != null) { foreach (DataRow row in dt.Rows) { //发报时间 收报时间 电报号 电报名称 培训岗位 培训班性质 班级名称 //开班日期 结束日期 班主任 教室 学员编号 姓名 性别 所在路局 所在站段 //身份证号 工作证号 手机号 抽考项目 考评日期 监考员 //考核项目编号 考核项目名称 考试起始时间 考试结束时间 考评员1 考评员2 时长 成绩 //考核项目编号 考核项目名称 考试起始时间 考试结束时间 考评员1 考评员2 时长 成绩 //考核项目编号 考核项目名称 考试起始时间 考试结束时间 考评员1 考评员2 时长 成绩 //考核项目编号 考核项目名称 考试起始时间 考试结束时间 考评员1 考评员2 时长 成绩 //考核项目编号 考核项目名称 考试起始时间 考试结束时间 考评员1 考评员2 时长 成绩 //考核项目编号 考核项目名称 考试起始时间 考试结束时间 考评员1 考评员2 时长 成绩 //考核项目编号 考核项目名称 考试起始时间 考试结束时间 考评员1 考评员2 时长 成绩 //考核项目编号 考核项目名称 考试起始时间 考试结束时间 考评员1 考评员2 时长 成绩 //考核项目编号 考核项目名称 考试起始时间 考试结束时间 考评员1 考评员2 时长 成绩 //考核项目编号 考核项目名称 考试起始时间 考试结束时间 考评员1 考评员2 时长 成绩 //总用时 总成绩 补考项目 补考次数 是否合格 var model = new ImpBasicTwo(); model.ID = Guid.NewGuid(); model.TelegraphSendDate = ConvertUtil.ConvertObjToNullableDateTime(row["发报时间"]); model.TelegraphReceiveDate = ConvertUtil.ConvertObjToNullableDateTime(row["收报时间"]); model.TelegraphNO = row["电报号"].ToString(); model.TelegraphName = row["电报名称"].ToString(); model.TrainPostion = row["培训岗位"].ToString(); model.TrainType = row["培训班性质"].ToString(); model.ClassName = row["班级名称"].ToString(); model.ClassBeginDate = ConvertUtil.ConvertObjToNullableDateTime(row["开班日期"]); model.ClassEndDate = ConvertUtil.ConvertObjToNullableDateTime(row["结束日期"]); model.ClassTeacher = row["班主任"].ToString(); model.ClassRoom = row["教室"].ToString(); model.StuID = row["学员编号"].ToString(); model.StuName = row["姓名"].ToString(); model.Sex = row["性别"].ToString(); model.RailwayOffice = row["所在路局"].ToString(); model.Station = row["所在站段"].ToString(); model.IDCardNO = row["身份证号"].ToString(); model.WorkID = row["工作证号"].ToString(); model.TelephoneNO = row["手机号"].ToString(); model.ExamineProject = row["抽考项目"].ToString(); model.ExamineDate = ConvertUtil.ConvertObjToNullableDateTime(row["考评日期"]); model.Invigilator = row["监考员"].ToString(); model.P1ExamineProjectID = row["考核项目编号(一)"].ToString(); model.P1ExamineProjectName = row["考核项目名称(一)"].ToString(); model.P1ExamineStartTime = row["考试起始时间(一)"].ToString(); model.P1ExamineEndTime = row["考试结束时间(一)"].ToString(); model.P1AssessorOne = row["考评员1(一)"].ToString(); model.P1AssessorTwo = row["考评员2(一)"].ToString(); model.P1ExamineTimeOffset = row["时长(一)"].ToString(); model.P1Score = ConvertUtil.ConvertObjToNullableDecimal(row["成绩(一)"]); model.P2ExamineProjectID = row["考核项目编号(二)"].ToString(); model.P2ExamineProjectName = row["考核项目名称(二)"].ToString(); model.P2ExamineStartTime = row["考试起始时间(二)"].ToString(); model.P2ExamineEndTime = row["考试结束时间(二)"].ToString(); model.P2AssessorOne = row["考评员1(二)"].ToString(); model.P2AssessorTwo = row["考评员2(二)"].ToString(); model.P2ExamineTimeOffset = row["时长(二)"].ToString(); model.P2Score = ConvertUtil.ConvertObjToNullableDecimal(row["成绩(二)"]); model.P3ExamineProjectID = row["考核项目编号(三)"].ToString(); model.P3ExamineProjectName = row["考核项目名称(三)"].ToString(); model.P3ExamineStartTime = row["考试起始时间(三)"].ToString(); model.P3ExamineEndTime = row["考试结束时间(三)"].ToString(); model.P3AssessorOne = row["考评员1(三)"].ToString(); model.P3AssessorTwo = row["考评员2(三)"].ToString(); model.P3ExamineTimeOffset = row["时长(三)"].ToString(); model.P3Score = ConvertUtil.ConvertObjToNullableDecimal(row["成绩(三)"]); model.P4ExamineProjectID = row["考核项目编号(四)"].ToString(); model.P4ExamineProjectName = row["考核项目名称(四)"].ToString(); model.P4ExamineStartTime = row["考试起始时间(四)"].ToString(); model.P4ExamineEndTime = row["考试结束时间(四)"].ToString(); model.P4AssessorOne = row["考评员1(四)"].ToString(); model.P4AssessorTwo = row["考评员2(四)"].ToString(); model.P4ExamineTimeOffset = row["时长(四)"].ToString(); model.P4Score = ConvertUtil.ConvertObjToNullableDecimal(row["成绩(四)"]); model.P5ExamineProjectID = row["考核项目编号(五)"].ToString(); model.P5ExamineProjectName = row["考核项目名称(五)"].ToString(); model.P5ExamineStartTime = row["考试起始时间(五)"].ToString(); model.P5ExamineEndTime = row["考试结束时间(五)"].ToString(); model.P5AssessorOne = row["考评员1(五)"].ToString(); model.P5AssessorTwo = row["考评员2(五)"].ToString(); model.P5ExamineTimeOffset = row["时长(五)"].ToString(); model.P5Score = ConvertUtil.ConvertObjToNullableDecimal(row["成绩(五)"]); model.P6ExamineProjectID = row["考核项目编号(六)"].ToString(); model.P6ExamineProjectName = row["考核项目名称(六)"].ToString(); model.P6ExamineStartTime = row["考试起始时间(六)"].ToString(); model.P6ExamineEndTime = row["考试结束时间(六)"].ToString(); model.P6AssessorOne = row["考评员1(六)"].ToString(); model.P6AssessorTwo = row["考评员2(六)"].ToString(); model.P6ExamineTimeOffset = row["时长(六)"].ToString(); model.P6Score = ConvertUtil.ConvertObjToNullableDecimal(row["成绩(六)"]); model.P7ExamineProjectID = row["考核项目编号(七)"].ToString(); model.P7ExamineProjectName = row["考核项目名称(七)"].ToString(); model.P7ExamineStartTime = row["考试起始时间(七)"].ToString(); model.P7ExamineEndTime = row["考试结束时间(七)"].ToString(); model.P7AssessorOne = row["考评员1(七)"].ToString(); model.P7AssessorTwo = row["考评员2(七)"].ToString(); model.P7ExamineTimeOffset = row["时长(七)"].ToString(); model.P7Score = ConvertUtil.ConvertObjToNullableDecimal(row["成绩(七)"]); model.P8ExamineProjectID = row["考核项目编号(八)"].ToString(); model.P8ExamineProjectName = row["考核项目名称(八)"].ToString(); model.P8ExamineStartTime = row["考试起始时间(八)"].ToString(); model.P8ExamineEndTime = row["考试结束时间(八)"].ToString(); model.P8AssessorOne = row["考评员1(八)"].ToString(); model.P8AssessorTwo = row["考评员2(八)"].ToString(); model.P8ExamineTimeOffset = row["时长(八)"].ToString(); model.P8Score = ConvertUtil.ConvertObjToNullableDecimal(row["成绩(八)"]); model.P9ExamineProjectID = row["考核项目编号(九)"].ToString(); model.P9ExamineProjectName = row["考核项目名称(九)"].ToString(); model.P9ExamineStartTime = row["考试起始时间(九)"].ToString(); model.P9ExamineEndTime = row["考试结束时间(九)"].ToString(); model.P9AssessorOne = row["考评员1(九)"].ToString(); model.P9AssessorTwo = row["考评员2(九)"].ToString(); model.P9ExamineTimeOffset = row["时长(九)"].ToString(); model.P9Score = ConvertUtil.ConvertObjToNullableDecimal(row["成绩(九)"]); model.P10ExamineProjectID = row["考核项目编号(十)"].ToString(); model.P10ExamineProjectName = row["考核项目名称(十)"].ToString(); model.P10ExamineStartTime = row["考试起始时间(十)"].ToString(); model.P10ExamineEndTime = row["考试结束时间(十)"].ToString(); model.P10AssessorOne = row["考评员1(十)"].ToString(); model.P10AssessorTwo = row["考评员2(十)"].ToString(); model.P10ExamineTimeOffset = row["时长(十)"].ToString(); model.P10Score = ConvertUtil.ConvertObjToNullableDecimal(row["成绩(十)"]); model.TotalTimeOffset = row["总用时"].ToString(); model.TotalScore = ConvertUtil.ConvertObjToNullableDecimal(row["总成绩"]); model.MakeUpProject = row["补考项目"].ToString(); model.MakeUpTimes = ConvertUtil.ConvertObjToNullableInt(row["补考次数"]); model.Passed = row["是否合格"].ToString(); model.CreateTime = System.DateTime.Now; model.CreateID = CurrentUser.UserId; model.CreateName = CurrentUser.UserName; model.IsValid = true; unitOfWork.ImpBasicTwoBLL.InsertEntity(model); } unitOfWork.Save(); } return ""; }