/// <summary> /// 生成培训人员的培训教材明细 /// </summary> /// <param name="taskId"></param> public static void CreateTrainingTaskItemByTaskId(string taskId) { using (Model.SUBHSSEDB db = new Model.SUBHSSEDB(Funs.ConnString)) { /////查找未生成教材明细的 培训任务 var getTasks = from x in db.Training_Task where x.States == Const.State_0 && (x.TaskId == taskId || taskId == null) select x; if (getTasks.Count() > 0) { foreach (var item in getTasks) { var getPerson = db.SitePerson_Person.FirstOrDefault(e => e.PersonId == item.UserId); if (getPerson != null) { ////获取计划下 人员培训教材明细 var getDataList = db.Sp_GetTraining_TaskItemTraining(item.PlanId, getPerson.WorkPostId); foreach (var dataItem in getDataList) { Model.Training_TaskItem newTaskItem = new Model.Training_TaskItem { TaskId = item.TaskId, PlanId = item.PlanId, PersonId = item.UserId, TrainingItemCode = dataItem.TrainingItemCode, TrainingItemName = dataItem.TrainingItemName, AttachUrl = dataItem.AttachUrl, }; var getTaskItem = db.Training_TaskItem.FirstOrDefault(x => x.TaskId == item.TaskId && x.TrainingItemName == newTaskItem.TrainingItemName && x.AttachUrl == newTaskItem.AttachUrl); if (getTaskItem == null) { newTaskItem.TaskItemId = SQLHelper.GetNewID(); db.Training_TaskItem.InsertOnSubmit(newTaskItem); db.SubmitChanges(); } } } ////更新培训任务 item.States = Const.State_1; db.SubmitChanges(); } } } }