/// <summary>
/// 根据主键删除培训任务
/// </summary>
/// <param name="taskId"></param>
public static void DeleteTaskById(string taskId)
{
Model.Training_Task task = db.Training_Task.FirstOrDefault(e => e.TaskId == taskId);
if (task != null)
{
db.Training_Task.DeleteOnSubmit(task);
db.SubmitChanges();
}
}
/// <summary>
/// 修改培训任务
/// </summary>
/// <param name="task"></param>
public static void UpdateTask(Model.Training_Task task)
{
Model.Training_Task newTask = Funs.DB.Training_Task.FirstOrDefault(e => e.TaskId == task.TaskId);
if (newTask != null && !string.IsNullOrEmpty(task.UserId))
{
newTask.PlanId = task.PlanId;
newTask.UserId = task.UserId;
newTask.TaskDate = task.TaskDate;
//newTask.States = task.States;
Funs.DB.SubmitChanges();
}
}
/// <summary>
/// 添加培训任务
/// </summary>
/// <param name="task"></param>
public static void AddTask(Model.Training_Task task)
{
Model.Training_Task newTask = new Model.Training_Task
{
TaskId = task.TaskId,
PlanId = task.PlanId,
UserId = task.UserId,
TaskDate = task.TaskDate,
States = task.States
};
db.Training_Task.InsertOnSubmit(newTask);
db.SubmitChanges();
}
/// <summary>
/// 新增 培训人员明细
/// </summary>
public static void AddTraining_Task(List <Model.TrainingTaskItem> trainingTasks, string planId, string projectId)
{
foreach (var item in trainingTasks)
{
if (!string.IsNullOrEmpty(item.PersonId))
{
Model.Training_Task newTrainDetail = new Model.Training_Task
{
TaskId = SQLHelper.GetNewID(),
ProjectId = projectId,
PlanId = planId,
UserId = item.PersonId,
TaskDate = DateTime.Now,
States = Const.State_0, ////未生成培训教材明细
};
Funs.DB.Training_Task.InsertOnSubmit(newTrainDetail);
Funs.SubmitChanges();
}
}
}
/// <summary>
/// 根据PlanId、PersonId将人员加入培训任务
/// </summary>
/// <param name="planId">培训计划ID</param>
/// <param name="personId">人员ID</param>
/// <returns></returns>
public static void getTrainingTaskByPlanIdPersonId(string planId, string personId)
{
using (Model.SUBHSSEDB db = new Model.SUBHSSEDB(Funs.ConnString))
{
var plan = db.Training_Plan.FirstOrDefault(e => e.PlanId == planId);
Model.Training_Task newTask = new Model.Training_Task
{
TaskId = SQLHelper.GetNewID(),
PlanId = planId,
UserId = personId,
TaskDate = DateTime.Now,
States = "0",
};
if (plan != null)
{
newTask.ProjectId = plan.ProjectId;
db.Training_Task.InsertOnSubmit(newTask);
db.SubmitChanges();
////生成培训任务下培训明细
GetDataService.CreateTrainingTaskItemByTaskId(newTask.TaskId);
}
}
}
/// <summary>
/// 保存TrainingPlan
/// </summary>
/// <param name="trainingPlan">培训计划记录</param>
/// <param name="trainingTasks">培训人员list</param>
/// <param name="trainingPlanItems">培训教材类型list</param>
public static void SaveTrainingPlan(Model.TrainingPlanItem trainingPlan)
{
using (Model.SUBHSSEDB db = new Model.SUBHSSEDB(Funs.ConnString))
{
Model.Training_Plan newTrainingPlan = new Model.Training_Plan
{
PlanId = trainingPlan.PlanId,
PlanCode = trainingPlan.PlanCode,
ProjectId = trainingPlan.ProjectId,
DesignerId = trainingPlan.DesignerId,
PlanName = trainingPlan.PlanName,
TrainContent = trainingPlan.TrainContent,
TrainStartDate = Funs.GetNewDateTime(trainingPlan.TrainStartDate),
TeachHour = trainingPlan.TeachHour,
TeachMan = trainingPlan.TeachMan,
TeachAddress = trainingPlan.TeachAddress,
TrainTypeId = trainingPlan.TrainTypeId,
UnitIds = trainingPlan.UnitIds,
WorkPostId = trainingPlan.WorkPostId,
States = trainingPlan.States,
};
if (!string.IsNullOrEmpty(trainingPlan.TrainLevelId))
{
newTrainingPlan.TrainLevelId = trainingPlan.TrainLevelId;
}
if (newTrainingPlan.TrainStartDate.HasValue && newTrainingPlan.TeachHour.HasValue)
{
double dd = (double)((decimal)newTrainingPlan.TeachHour.Value);
newTrainingPlan.TrainEndDate = newTrainingPlan.TrainStartDate.Value.AddHours(dd);
}
List <Model.TrainingTaskItem> trainingTasks = trainingPlan.TrainingTasks;
List <Model.TrainingPlanItemItem> trainingPlanItems = trainingPlan.TrainingPlanItems;
var isUpdate = db.Training_Plan.FirstOrDefault(x => x.PlanId == newTrainingPlan.PlanId);
if (isUpdate == null)
{
newTrainingPlan.DesignerDate = DateTime.Now;
string unitId = string.Empty;
var user = UserService.GetUserByUserId(newTrainingPlan.DesignerId);
if (user != null)
{
unitId = user.UnitId;
}
newTrainingPlan.PlanCode = CodeRecordsService.ReturnCodeByMenuIdProjectId(Const.ProjectTrainingPlanMenuId, newTrainingPlan.ProjectId, unitId);
if (string.IsNullOrEmpty(newTrainingPlan.PlanId))
{
newTrainingPlan.PlanId = SQLHelper.GetNewID();
}
db.Training_Plan.InsertOnSubmit(newTrainingPlan);
db.SubmitChanges();
CodeRecordsService.InsertCodeRecordsByMenuIdProjectIdUnitId(Const.ProjectTrainingPlanMenuId, newTrainingPlan.ProjectId, null, newTrainingPlan.PlanId, newTrainingPlan.DesignerDate);
}
else
{
if (newTrainingPlan.States == "0" || newTrainingPlan.States == "1")
{
isUpdate.PlanName = newTrainingPlan.PlanName;
isUpdate.TrainContent = newTrainingPlan.TrainContent;
isUpdate.TrainStartDate = newTrainingPlan.TrainStartDate;
isUpdate.TeachHour = newTrainingPlan.TeachHour;
isUpdate.TrainEndDate = newTrainingPlan.TrainEndDate;
isUpdate.TeachMan = newTrainingPlan.TeachMan;
isUpdate.TeachAddress = newTrainingPlan.TeachAddress;
isUpdate.TrainTypeId = newTrainingPlan.TrainTypeId;
isUpdate.TrainLevelId = newTrainingPlan.TrainLevelId;
isUpdate.UnitIds = newTrainingPlan.UnitIds;
isUpdate.WorkPostId = newTrainingPlan.WorkPostId;
isUpdate.States = newTrainingPlan.States;
db.SubmitChanges();
}
////删除培训任务
var tasks = from x in db.Training_Task where x.PlanId == newTrainingPlan.PlanId select x;
if (tasks.Count() > 0)
{
var taskItems = from x in db.Training_TaskItem where x.PlanId == newTrainingPlan.PlanId select x;
if (tasks.Count() > 0)
{
db.Training_TaskItem.DeleteAllOnSubmit(taskItems);
db.SubmitChanges();
}
db.Training_Task.DeleteAllOnSubmit(tasks);
db.SubmitChanges();
}
////删除培训教材类型
var planItem = (from x in db.Training_PlanItem where x.PlanId == newTrainingPlan.PlanId select x).ToList();
if (planItem.Count() > 0)
{
db.Training_PlanItem.DeleteAllOnSubmit(planItem);
db.SubmitChanges();
}
}
if (trainingTasks.Count() > 0)
{
////新增培训人员明细
foreach (var item in trainingTasks)
{
if (!string.IsNullOrEmpty(item.PersonId))
{
Model.Training_Task newTrainDetail = new Model.Training_Task
{
TaskId = SQLHelper.GetNewID(),
ProjectId = newTrainingPlan.ProjectId,
PlanId = newTrainingPlan.PlanId,
UserId = item.PersonId,
TaskDate = DateTime.Now,
States = Const.State_0, ////未生成培训教材明细
};
db.Training_Task.InsertOnSubmit(newTrainDetail);
db.SubmitChanges();
}
}
}
if (trainingPlanItems.Count() > 0)
{
////新增培训教材类型明细
foreach (var item in trainingPlanItems)
{
if (!string.IsNullOrEmpty(item.CompanyTrainingId) || !string.IsNullOrEmpty(item.CompanyTrainingItemId))
{
Model.Training_PlanItem newPlanItem = new Model.Training_PlanItem
{
PlanItemId = SQLHelper.GetNewID(),
PlanId = newTrainingPlan.PlanId,
};
if (!string.IsNullOrEmpty(item.CompanyTrainingId))
{
newPlanItem.CompanyTrainingId = item.CompanyTrainingId;
}
if (!string.IsNullOrEmpty(item.CompanyTrainingItemId))
{
newPlanItem.CompanyTrainingItemId = item.CompanyTrainingItemId;
}
db.Training_PlanItem.InsertOnSubmit(newPlanItem);
db.SubmitChanges();
}
}
}
}
}
