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