/// <summary>
/// 修改教育培训信息
/// </summary>
/// <param name="training">教育培训实体</param>
public static void UpdateTraining(Model.EduTrain_TrainRecord training)
{
Model.SUBHSSEDB db = Funs.DB;
Model.EduTrain_TrainRecord newTraining = db.EduTrain_TrainRecord.FirstOrDefault(e => e.TrainingId == training.TrainingId);
if (newTraining != null)
{
newTraining.TrainingCode = training.TrainingCode;
newTraining.TrainTitle = training.TrainTitle;
newTraining.TrainContent = training.TrainContent;
newTraining.TrainStartDate = training.TrainStartDate;
if (training.TrainEndDate.HasValue)
{
newTraining.TrainEndDate = training.TrainEndDate;
}
else
{
newTraining.TrainEndDate = training.TrainStartDate;
}
newTraining.TeachHour = training.TeachHour;
newTraining.TeachMan = training.TeachMan;
newTraining.TeachAddress = training.TeachAddress;
newTraining.Remark = training.Remark;
newTraining.AttachUrl = training.AttachUrl;
newTraining.TrainTypeId = training.TrainTypeId;
newTraining.TrainLevelId = training.TrainLevelId;
newTraining.UnitIds = training.UnitIds;
newTraining.States = training.States;
newTraining.TrainPersonNum = training.TrainPersonNum;
newTraining.FromRecordId = training.FromRecordId;
newTraining.WorkPostIds = training.WorkPostIds;
db.SubmitChanges();
}
}
/// <summary>
/// 根据教育培训主键删除一个教育培训信息
/// </summary>
/// <param name="trainingId">教育培训主键</param>
public static void DeleteTrainingByTrainingId(string trainingId)
{
Model.SUBHSSEDB db = Funs.DB;
Model.EduTrain_TrainRecord training = db.EduTrain_TrainRecord.FirstOrDefault(e => e.TrainingId == trainingId);
if (training != null)
{
///删除培训明细
EduTrain_TrainRecordDetailService.DeleteTrainDetailByTrainingId(trainingId);
///删除编码表记录
CodeRecordsService.DeleteCodeRecordsByDataId(training.TrainingId);
////删除附件表
CommonService.DeleteAttachFileById(training.TrainingId);
///删除工程师日志收集记录
var flowOperate = from x in db.Sys_FlowOperate where x.DataId == training.TrainingId select x;
if (flowOperate.Count() > 0)
{
var details = BLL.EduTrain_TrainRecordDetailService.GetTrainRecordDetailByTrainingId(training.TrainingId);
foreach (var item in flowOperate)
{
BLL.HSSELogService.CollectHSSELog(training.ProjectId, item.OperaterId, item.OperaterTime, "27", training.TrainContent, Const.BtnDelete, details.Count());
}
////删除流程表
BLL.CommonService.DeleteFlowOperateByID(training.TrainingId);
}
///删除培训试卷
EduTrain_TrainTestService.DeleteTrainTestByTrainingId(training.TrainingId);
db.EduTrain_TrainRecord.DeleteOnSubmit(training);
db.SubmitChanges();
}
}
/// <summary>
/// 增加教育培训信息
/// </summary>
/// <param name="training">教育培训实体</param>
public static void AddTraining(Model.EduTrain_TrainRecord training)
{
Model.SUBHSSEDB db = Funs.DB;
Model.EduTrain_TrainRecord newTraining = new Model.EduTrain_TrainRecord
{
TrainingId = training.TrainingId,
TrainingCode = training.TrainingCode,
ProjectId = training.ProjectId,
TrainTitle = training.TrainTitle,
TrainContent = training.TrainContent,
TrainStartDate = training.TrainStartDate,
TeachHour = training.TeachHour,
TeachMan = training.TeachMan,
TeachAddress = training.TeachAddress,
Remark = training.Remark,
AttachUrl = training.AttachUrl,
TrainTypeId = training.TrainTypeId,
TrainLevelId = training.TrainLevelId,
UnitIds = training.UnitIds,
States = training.States,
CompileMan = training.CompileMan,
TrainPersonNum = training.TrainPersonNum,
FromRecordId = training.FromRecordId,
WorkPostIds = training.WorkPostIds,
PlanId = training.PlanId,
};
if (training.TrainEndDate.HasValue)
{
newTraining.TrainEndDate = training.TrainEndDate;
}
else
{
newTraining.TrainEndDate = training.TrainStartDate;
}
db.EduTrain_TrainRecord.InsertOnSubmit(newTraining);
db.SubmitChanges();
////增加一条编码记录
BLL.CodeRecordsService.InsertCodeRecordsByMenuIdProjectIdUnitId(Const.ProjectTrainRecordMenuId, training.ProjectId, null, training.TrainingId, training.TrainStartDate);
}
/// <summary>
/// 插入培训记录 2
/// </summary>
/// <param name="projectId"></param>
/// <param name="arr"></param>
public static bool AddTrainRecord(string projectId, JArray arr, Model.Sys_User user)
{
Model.SUBHSSEDB db = Funs.DB;
bool isOk = true;
try
{
foreach (var item in arr)
{
string fromRecordId = item["ID"].ToString();
string trainTypeId = null; ////培训类型
var getTrainType = db.Base_TrainType.FirstOrDefault(x => x.TrainTypeName == item["TrainType"].ToString());
if (getTrainType != null)
{
trainTypeId = getTrainType.TrainTypeId;
}
string unitId = null;
if (!string.IsNullOrEmpty(item["TrainDepart"].ToString()))
{
var lists = Funs.GetStrListByStr(item["TrainDepart"].ToString(), ',');
if (lists.Count() > 0)
{
foreach (var itemList in lists)
{
var getUnit = db.Base_Unit.FirstOrDefault(x => x.UnitName == itemList);
if (getUnit != null)
{
if (string.IsNullOrEmpty(unitId))
{
unitId = getUnit.UnitId;
}
else
{
unitId += ("," + getUnit.UnitId);
}
}
}
}
}
if (!string.IsNullOrEmpty(unitId) && !string.IsNullOrEmpty(fromRecordId))
{
Model.EduTrain_TrainRecord newTrainRecord = new Model.EduTrain_TrainRecord
{
FromRecordId = fromRecordId,
ProjectId = projectId,
TrainTitle = item["RecordName"].ToString(),
TrainContent = item["TrainContent"].ToString(),
TrainStartDate = Funs.GetNewDateTime(item["TrainStartDate"].ToString()),
TrainEndDate = Funs.GetNewDateTime(item["TrainEndDate"].ToString()),
TeachHour = Funs.GetNewDecimalOrZero(item["TrainPeriod"].ToString()),
TeachMan = item["TrainPrincipal"].ToString(),
Remark = item["TrainDescript"].ToString(),
TrainTypeId = trainTypeId,
UnitIds = unitId,
States = Const.State_0,
CompileMan = item["CreateUser"].ToString(),
TrainPersonNum = Funs.GetNewInt(item["PersonCount"].ToString()),
};
newTrainRecord.TrainingCode = Funs.GetNewFileName(newTrainRecord.TrainStartDate);
var getTrainRecord = Funs.DB.EduTrain_TrainRecord.FirstOrDefault(x => x.FromRecordId == fromRecordId);
if (getTrainRecord == null)
{
newTrainRecord.TrainingId = SQLHelper.GetNewID(typeof(Model.EduTrain_TrainRecord));
EduTrain_TrainRecordService.AddTraining(newTrainRecord);
BLL.LogService.AddSys_Log(user, newTrainRecord.TrainingCode, newTrainRecord.TrainingId, BLL.Const.ProjectTrainRecordMenuId, BLL.Const.BtnAdd);
}
else
{
getTrainRecord.TrainingCode = newTrainRecord.TrainingCode;
getTrainRecord.TrainTitle = newTrainRecord.TrainTitle;
getTrainRecord.TrainContent = newTrainRecord.TrainContent;
getTrainRecord.UnitIds = newTrainRecord.UnitIds;
getTrainRecord.TrainStartDate = newTrainRecord.TrainStartDate;
if (newTrainRecord.TrainEndDate.HasValue)
{
getTrainRecord.TrainEndDate = newTrainRecord.TrainEndDate;
}
else
{
getTrainRecord.TrainEndDate = newTrainRecord.TrainStartDate;
}
getTrainRecord.TeachHour = newTrainRecord.TeachHour;
getTrainRecord.TeachMan = newTrainRecord.TeachMan;
getTrainRecord.TeachAddress = newTrainRecord.TeachAddress;
getTrainRecord.Remark = newTrainRecord.Remark;
EduTrain_TrainRecordService.UpdateTraining(getTrainRecord);
BLL.LogService.AddSys_Log(user, getTrainRecord.TrainingCode, getTrainRecord.TrainingId, BLL.Const.ProjectTrainRecordMenuId, BLL.Const.BtnModify);
}
}
else
{
isOk = false;
}
}
}
catch (Exception ex)
{
isOk = false;
ErrLogInfo.WriteLog(string.Empty, ex);
}
return(isOk);
}
/// <summary>
/// 根据考生计划结束时 将相关培训考生内容 写培训记录归档
/// </summary>
/// <param name="getTestPlan"></param>
public static void InsertTrainRecord(Model.Training_TestPlan getTestPlan)
{
using (Model.SUBHSSEDB db = new Model.SUBHSSEDB(Funs.ConnString))
{
////获取培训计划
var getTrainingPlan = db.Training_Plan.FirstOrDefault(e => e.PlanId == getTestPlan.PlanId);
var getTrainRecord = db.EduTrain_TrainRecord.FirstOrDefault(x => x.PlanId == getTestPlan.PlanId);
if (getTrainingPlan != null && getTrainRecord == null)
{
getTrainingPlan.States = "3";
db.SubmitChanges();
Model.EduTrain_TrainRecord newTrainRecord = new Model.EduTrain_TrainRecord
{
TrainingId = SQLHelper.GetNewID(),
TrainingCode = getTrainingPlan.PlanCode,
ProjectId = getTrainingPlan.ProjectId,
TrainTitle = getTrainingPlan.PlanName,
TrainContent = getTrainingPlan.TrainContent,
TrainStartDate = getTrainingPlan.TrainStartDate,
TeachHour = getTrainingPlan.TeachHour,
TrainEndDate = getTrainingPlan.TrainEndDate,
TeachMan = getTrainingPlan.TeachMan,
TeachAddress = getTrainingPlan.TeachAddress,
Remark = "来源：培训计划",
TrainTypeId = getTrainingPlan.TrainTypeId,
TrainLevelId = getTrainingPlan.TrainLevelId,
UnitIds = getTrainingPlan.UnitIds,
States = Const.State_2,
WorkPostIds = getTrainingPlan.WorkPostId,
PlanId = getTrainingPlan.PlanId,
};
newTrainRecord.CompileMan = UserService.GetUserNameByUserId(getTrainingPlan.DesignerId);
///获取培训人员
var getTrainingTasks = from x in db.Training_Task where x.PlanId == getTrainingPlan.PlanId
select x;
newTrainRecord.TrainPersonNum = getTrainingTasks.Count();
///新增培训记录
db.EduTrain_TrainRecord.InsertOnSubmit(newTrainRecord);
db.SubmitChanges();
////及格分数
int passScore = 80;
var testRule = db.Sys_TestRule.FirstOrDefault();
if (testRule != null)
{
passScore = testRule.PassingScore;
}
foreach (var item in getTrainingTasks)
{
decimal gScores = 0;
bool result = false;
////获取 考生试卷
var getTestRecord = db.Training_TestRecord.Where(x => x.TestPlanId == getTestPlan.TestPlanId && x.TestManId == item.UserId);
foreach (var itemR in getTestRecord)
{
if (itemR.TestScores > gScores)
{
gScores = itemR.TestScores ?? 0;
}
}
if (gScores >= passScore)
{
result = true;
}
Model.EduTrain_TrainRecordDetail newDetail = new Model.EduTrain_TrainRecordDetail
{
TrainDetailId = SQLHelper.GetNewID(),
TrainingId = newTrainRecord.TrainingId,
PersonId = item.UserId,
CheckScore = gScores,
CheckResult = result,
};
db.EduTrain_TrainRecordDetail.InsertOnSubmit(newDetail);
db.SubmitChanges();
///// 培训考试 通过 更新卡号
if (result)
{
var getPerson = db.SitePerson_Person.FirstOrDefault(e => e.PersonId == newDetail.PersonId);
if (getPerson != null && string.IsNullOrEmpty(getPerson.CardNo))
{
getPerson.CardNo = SQLHelper.RunProcNewId("SpGetNewNumber", "SitePerson_Person", "CardNo", getPerson.ProjectId, UnitService.GetUnitCodeByUnitId(getPerson.UnitId));
db.SubmitChanges();
}
}
}
////增加一条编码记录
CodeRecordsService.InsertCodeRecordsByMenuIdProjectIdUnitId(Const.ProjectTrainRecordMenuId, newTrainRecord.ProjectId, null, newTrainRecord.TrainingId, newTrainRecord.TrainStartDate);
CommonService.btnSaveData(newTrainRecord.ProjectId, Const.ProjectTrainRecordMenuId, newTrainRecord.TrainingId, getTrainingPlan.DesignerId, true, newTrainRecord.TrainTitle, "../EduTrain/TrainRecordView.aspx?TrainingId={0}");
}
}
}
