private string ImpTeachPlanStatOneImport(DataTable dt) { if (dt != null) { foreach (DataRow row in dt.Rows) { //岗位名称 岗位编号 班级名称 开班日期 结束日期 //课程计划编号 实训项目编号 实训项目名称 实作指导书名称 实作指导书编号 //实作考评表名称 实作考评表编号 评审情况 评审结果 审定日期 考评日期 //课程计划链接 实作考评表链接 实作指导书链接 备注 var model = new ImpTeachPlanStatOne(); model.ID = Guid.NewGuid(); model.PositionName = row["岗位名称"].ToString(); model.PositionID = row["岗位编号"].ToString(); model.ClassName = row["班级名称"].ToString(); model.ClassBeginDate = ConvertUtil.ConvertObjToNullableDateTime(row["开班日期"]); model.ClassEndDate = ConvertUtil.ConvertObjToNullableDateTime(row["结束日期"]); model.CoursePlanID = row["课程计划编号"].ToString(); model.ProjectID = row["实训项目编号"].ToString(); model.ProjectName = row["实训项目名称"].ToString(); model.ImpInstructionBookName = row["实作指导书名称"].ToString(); model.ImpInstructionBookID = row["实作指导书编号"].ToString(); model.ImpExamineTableName = row["实作考评表名称"].ToString(); model.ImpExamineTableID = row["实作考评表编号"].ToString(); model.ExamineSituation = row["评审情况"].ToString(); model.ExamineResult = row["评审结果"].ToString(); model.CheckDate = ConvertUtil.ConvertObjToNullableDateTime(row["审定日期"]); model.ExamineDate = ConvertUtil.ConvertObjToNullableDateTime(row["考评日期"]); model.CoursePlanLink = row["课程计划链接"].ToString(); model.ImpExamineTableLink = row["实作考评表链接"].ToString(); model.ImpInstructionBookLink = row["实作指导书链接"].ToString(); model.Remark = row["岗位名称"].ToString(); model.CreateTime = System.DateTime.Now; model.CreateID = CurrentUser.UserId; model.CreateName = CurrentUser.UserName; model.IsValid = true; unitOfWork.ImpTeachPlanStatOneBLL.InsertEntity(model); } unitOfWork.Save(); } return ""; }
public string Add() { if (string.IsNullOrWhiteSpace(Request["ClassName"])) { return "班级名称不能为空!"; } if (string.IsNullOrWhiteSpace(Request["ProjectID"])) { return "实训项目编号不能为空!"; } var positionName = Request["PositionName"]; var positionID = Request["PositionID"]; var className = Request["ClassName"]; var classBeginDate = ConvertUtil.ConvertStringToNullableDateTime(Request["ClassBeginDate"]); var classEndDate = ConvertUtil.ConvertStringToNullableDateTime(Request["ClassEndDate"]); var coursePlanID = Request["CoursePlanID"]; var projectID = Request["ProjectID"]; var projectName = Request["ProjectName"]; var impInstructionBookName = Request["ImpInstructionBookName"]; var impInstructionBookID = Request["ImpInstructionBookID"]; var impExamineTableName = Request["ImpExamineTableName"]; var impExamineTableID = Request["ImpExamineTableID"]; var examineSituation = Request["ExamineSituation"]; var examineResult = Request["ExamineResult"]; var checkDate = ConvertUtil.ConvertStringToNullableDateTime(Request["CheckDate"]); var examineDate = ConvertUtil.ConvertStringToNullableDateTime(Request["ExamineDate"]); var coursePlanLink = Request["CoursePlanLink"]; var impExamineTableLink = Request["ImpExamineTableLink"]; var impInstructionBookLink = Request["ImpInstructionBookLink"]; var remark = Request["Remark"]; var model = new ImpTeachPlanStatOne(); model.ID = Guid.NewGuid(); model.PositionName = positionName; model.PositionID = positionID; model.ClassName = className; model.ClassBeginDate = classBeginDate; model.ClassEndDate = classEndDate; model.CoursePlanID = coursePlanID; model.ProjectID = projectID; model.ProjectName = projectName; model.ImpInstructionBookName = impInstructionBookName; model.ImpInstructionBookID = impInstructionBookID; model.ImpExamineTableName = impExamineTableName; model.ImpExamineTableID = impExamineTableID; model.ExamineSituation = examineSituation; model.ExamineResult = examineResult; model.CheckDate = checkDate; model.ExamineDate = examineDate; model.CoursePlanLink = coursePlanLink; model.ImpExamineTableLink = impExamineTableLink; model.ImpInstructionBookLink = impInstructionBookLink; model.Remark = remark; model.CreateTime = System.DateTime.Now; model.CreateID = CurrentUser.UserId; model.CreateName = CurrentUser.UserName; model.IsValid = true; try { unitOfWork.ImpTeachPlanStatOneBLL.InsertEntity(model); unitOfWork.Save(); return ""; } catch (Exception ex) { Log.Error("保存实作考评信息统计表信息异常:" + ex.Message, ex); return "系统异常,请联系管理员!"; } }