/// <summary> /// 获取HSE日志信息 /// </summary> /// <param name="projectId"></param> /// <param name="userId"></param> /// <param name="diaryDate"></param> /// <returns></returns> public static Model.HSEDiaryItem getHSEDiary(string projectId, string userId, string diaryDate) { DateTime?getDiaryDate = Funs.GetNewDateTime(diaryDate); Model.HSEDiaryItem getItem = new Model.HSEDiaryItem(); if (getDiaryDate.HasValue && !string.IsNullOrEmpty(projectId) && !string.IsNullOrEmpty(userId)) { var getFlowOperteList = ReturnFlowOperteList(projectId, userId, getDiaryDate.Value); getItem.ProjectId = projectId; getItem.UserId = userId; getItem.UserName = UserService.GetUserNameByUserId(userId); getItem.DiaryDate = diaryDate; getItem.HSEDiaryId = SQLHelper.GetNewID(); getItem.Value1 = getValues1(getFlowOperteList, projectId, userId, getDiaryDate.Value); getItem.Value2 = getValues2(getFlowOperteList, projectId, userId, getDiaryDate.Value); getItem.Value3 = getValues3(getFlowOperteList, projectId, userId, getDiaryDate.Value); getItem.Value4 = getValues4(getFlowOperteList, projectId, userId, getDiaryDate.Value); getItem.Value5 = getValues5(getFlowOperteList, projectId, userId, getDiaryDate.Value); getItem.Value6 = getValues6(getFlowOperteList, projectId, userId, getDiaryDate.Value); getItem.Value7 = getValues7(getFlowOperteList, projectId, userId, getDiaryDate.Value); getItem.Value8 = getValues8(getFlowOperteList, projectId, userId, getDiaryDate.Value); getItem.Value9 = getValues9(getFlowOperteList, projectId, userId, getDiaryDate.Value); getItem.Value10 = getValues10(getFlowOperteList, projectId, userId, getDiaryDate.Value); var getInfo = Funs.DB.Project_HSEDiary.FirstOrDefault(x => x.UserId == userId && x.DiaryDate == getDiaryDate); if (getInfo != null) { getItem.HSEDiaryId = getInfo.HSEDiaryId; getItem.DailySummary = getInfo.DailySummary; getItem.TomorrowPlan = getInfo.TomorrowPlan; } } return(getItem); }
/// <summary> /// 保存ReceiveFileManager /// </summary> /// <param name="newItem">来文信息</param> /// <returns></returns> public static void SaveReceiveFileManager(Model.ReceiveFileManagerItem newItem) { Model.SUBHSSEDB db = Funs.DB; string menuId = string.Empty; Model.InformationProject_ReceiveFileManager newReceiveFile = new Model.InformationProject_ReceiveFileManager { FileType = newItem.FileType, ReceiveFileManagerId = newItem.ReceiveFileManagerId, ProjectId = newItem.ProjectId, ReceiveFileCode = newItem.ReceiveFileCode, ReceiveFileName = newItem.ReceiveFileName, Version = newItem.Version, FileCode = newItem.FileCode, FilePageNum = newItem.FilePageNum, GetFileDate = Funs.GetNewDateTime(newItem.GetFileDate), MainContent = System.Web.HttpUtility.HtmlEncode(newItem.MainContent), UnitIds = newItem.UnitIds, States = Const.State_2, }; if (!string.IsNullOrEmpty(newItem.FileUnitId)) { newReceiveFile.FileUnitId = newItem.FileUnitId; } if (!string.IsNullOrEmpty(newItem.SendPersonId)) { newReceiveFile.SendPersonId = newItem.SendPersonId; } if (newItem.States != "1") { newReceiveFile.States = Const.State_0; } var updateFile = Funs.DB.InformationProject_ReceiveFileManager.FirstOrDefault(x => x.ReceiveFileManagerId == newItem.ReceiveFileManagerId); if (updateFile == null) { newItem.ReceiveFileManagerId = newReceiveFile.ReceiveFileManagerId = SQLHelper.GetNewID(); newReceiveFile.ReceiveFileCode = CodeRecordsService.ReturnCodeByMenuIdProjectId(Const.ReceiveFileManagerMenuId, newReceiveFile.ProjectId, null); ReceiveFileManagerService.AddReceiveFileManager(newReceiveFile); } else { ReceiveFileManagerService.UpdateReceiveFileManager(newReceiveFile); } if (newItem.States == "1") { CommonService.btnSaveData(newItem.ProjectId, Const.ReceiveFileManagerMenuId, newReceiveFile.ReceiveFileManagerId, newReceiveFile.SendPersonId, true, newReceiveFile.ReceiveFileName, "../ReceiveFileManager/ReceiveFileManagerView.aspx?ReceiveFileManagerId={0}"); } ////保存附件 if (!string.IsNullOrEmpty(newItem.FileAttachUrl)) { UploadFileService.SaveAttachUrl(UploadFileService.GetSourceByAttachUrl(newItem.FileAttachUrl, 10, null), newItem.FileAttachUrl, Const.ReceiveFileManagerMenuId, newItem.ReceiveFileManagerId); } else { CommonService.DeleteAttachFileById(Const.ReceiveFileManagerMenuId, newItem.ReceiveFileManagerId); } }
/// <summary> /// 保存HSE日志 /// </summary> /// <param name="item"></param> public static void SaveHSEDiary(Model.HSEDiaryItem item) { DeleteHSEDiary(item.HSEDiaryId); using (Model.SUBHSSEDB db = new Model.SUBHSSEDB(Funs.ConnString)) { Model.Project_HSEDiary newHSEDiary = new Model.Project_HSEDiary { HSEDiaryId = item.HSEDiaryId, ProjectId = item.ProjectId, DiaryDate = Funs.GetNewDateTime(item.DiaryDate), UserId = item.UserId, DailySummary = item.DailySummary, TomorrowPlan = item.TomorrowPlan, Value1 = item.Value1, Value2 = item.Value2, Value3 = item.Value3, Value4 = item.Value4, Value5 = item.Value5, Value6 = item.Value6, Value7 = item.Value7, Value8 = item.Value8, Value9 = item.Value9, Value10 = item.Value10, }; if (string.IsNullOrEmpty(newHSEDiary.HSEDiaryId)) { newHSEDiary.HSEDiaryId = SQLHelper.GetNewID(); } db.Project_HSEDiary.InsertOnSubmit(newHSEDiary); db.SubmitChanges(); } }
/// <summary> /// 根据类型获取图型数据 /// </summary> /// <param name="type"></param> /// <returns></returns> public static List <Model.ChartAnalysisItem> getChartAnalysisByType(string projectId, string type, string startDate, string endDate) { List <Model.ChartAnalysisItem> getDataLists = new List <Model.ChartAnalysisItem>(); var getHazardRegister = from x in Funs.DB.HSSE_Hazard_HazardRegister where x.ProjectId == projectId select x; if (!string.IsNullOrEmpty(startDate)) { var sDate = Funs.GetNewDateTime(startDate); getHazardRegister = getHazardRegister.Where(x => x.RegisterDate >= sDate); } if (!string.IsNullOrEmpty(endDate)) { var eDate = Funs.GetNewDateTime(endDate); getHazardRegister = getHazardRegister.Where(x => x.RegisterDate <= eDate); } if (type == "1") { var getUnitlistIds = getHazardRegister.Select(x => x.ResponsibleUnit).Distinct().ToList(); foreach (var unitItem in getUnitlistIds) { var getUnitRegister = getHazardRegister.Where(x => x.ResponsibleUnit == unitItem); Model.ChartAnalysisItem newItem = new Model.ChartAnalysisItem { DataId = unitItem, Type = type, DataName = UnitService.GetUnitCodeByUnitId(unitItem), DataSumCount = getUnitRegister.Count(), DataCount1 = getUnitRegister.Where(x => x.States == "2" || x.States == "3").Count(), }; getDataLists.Add(newItem); } } else if (type == "2") { var getRegisterTypesIds = getHazardRegister.Select(x => x.RegisterTypesId).Distinct().ToList(); foreach (var typeItem in getRegisterTypesIds) { var getUnitRegister = getHazardRegister.Where(x => x.RegisterTypesId == typeItem); Model.ChartAnalysisItem newItem = new Model.ChartAnalysisItem { DataId = typeItem, Type = type, DataName = Funs.DB.HSSE_Hazard_HazardRegisterTypes.First(y => y.RegisterTypesId == typeItem).RegisterTypesName, DataSumCount = getUnitRegister.Count(), DataCount1 = getUnitRegister.Where(x => x.States == "2" || x.States == "3").Count(), }; getDataLists.Add(newItem); } } return(getDataLists); }
/// <summary> /// 保存Check_IncentiveNotice /// </summary> /// <param name="newItem">奖励通知单</param> /// <returns></returns> public static void SaveIncentiveNotice(Model.IncentiveNoticeItem newItem) { Model.SUBHSSEDB db = Funs.DB; Model.Check_IncentiveNotice newIncentiveNotice = new Model.Check_IncentiveNotice { IncentiveNoticeId = newItem.IncentiveNoticeId, IncentiveNoticeCode = newItem.IncentiveNoticeCode, ProjectId = newItem.ProjectId, IncentiveDate = Funs.GetNewDateTime(newItem.IncentiveDate), UnitId = newItem.UnitId, PersonId = newItem.PersonId, RewardType = newItem.RewardTypeId, BasicItem = newItem.BasicItem, IncentiveMoney = newItem.IncentiveMoney, Currency = newItem.Currency, TitleReward = newItem.TitleReward, MattleReward = newItem.MattleReward, SignMan = newItem.SignManId, ApproveMan = newItem.ApproveManId, FileContents = System.Web.HttpUtility.HtmlEncode(newItem.FileContents), CompileMan = newItem.CompileManId, AttachUrl = newItem.AttachUrl, States = Const.State_2, }; if (!string.IsNullOrEmpty(newItem.TeamGroupId)) { newIncentiveNotice.TeamGroupId = newItem.TeamGroupId; } if (newItem.States != "1") { newIncentiveNotice.States = Const.State_0; } var updateIncentiveNotice = Funs.DB.Check_IncentiveNotice.FirstOrDefault(x => x.IncentiveNoticeId == newItem.IncentiveNoticeId); if (updateIncentiveNotice == null) { newIncentiveNotice.CompileDate = DateTime.Now; newIncentiveNotice.IncentiveNoticeId = SQLHelper.GetNewID(); newIncentiveNotice.IncentiveNoticeCode = CodeRecordsService.ReturnCodeByMenuIdProjectId(Const.ProjectIncentiveNoticeMenuId, newIncentiveNotice.ProjectId, newIncentiveNotice.UnitId); IncentiveNoticeService.AddIncentiveNotice(newIncentiveNotice); } else { IncentiveNoticeService.UpdateIncentiveNotice(newIncentiveNotice); } if (newIncentiveNotice.States == "1") { CommonService.btnSaveData(newIncentiveNotice.ProjectId, Const.ProjectIncentiveNoticeMenuId, newIncentiveNotice.IncentiveNoticeId, newIncentiveNotice.CompileMan, true, newIncentiveNotice.IncentiveNoticeCode, "../Check/IncentiveNoticeView.aspx?IncentiveNoticeId={0}"); } }
/// <summary> /// 保存QualityAudit_EquipmentQuality /// </summary> /// <param name="newItem">机具设备资质</param> /// <returns></returns> public static void SaveEquipmentQuality(Model.EquipmentQualityItem newItem) { Model.SUBHSSEDB db = Funs.DB; Model.QualityAudit_EquipmentQuality newEquipmentQuality = new Model.QualityAudit_EquipmentQuality { EquipmentQualityId = newItem.EquipmentQualityId, ProjectId = newItem.ProjectId, EquipmentQualityCode = newItem.EquipmentQualityCode, UnitId = newItem.UnitId, SpecialEquipmentId = newItem.SpecialEquipmentId, EquipmentQualityName = newItem.EquipmentQualityName, SizeModel = newItem.SizeModel, FactoryCode = newItem.FactoryCode, CertificateCode = newItem.CertificateCode, CheckDate = Funs.GetNewDateTime(newItem.CheckDate), LimitDate = Funs.GetNewDateTimeOrNow(newItem.LimitDate), InDate = Funs.GetNewDateTime(newItem.InDate), OutDate = Funs.GetNewDateTime(newItem.OutDate), ApprovalPerson = newItem.ApprovalPerson, CarNum = newItem.CarNum, Remark = newItem.Remark, CompileMan = newItem.CompileManId, }; var updateEquipmentQuality = Funs.DB.QualityAudit_EquipmentQuality.FirstOrDefault(x => x.EquipmentQualityId == newItem.EquipmentQualityId); if (updateEquipmentQuality == null) { newEquipmentQuality.CompileDate = DateTime.Now; newEquipmentQuality.EquipmentQualityId = SQLHelper.GetNewID(); newEquipmentQuality.EquipmentQualityCode = CodeRecordsService.ReturnCodeByMenuIdProjectId(Const.EquipmentQualityMenuId, newEquipmentQuality.ProjectId, newEquipmentQuality.UnitId); EquipmentQualityService.AddEquipmentQuality(newEquipmentQuality); } else { EquipmentQualityService.UpdateEquipmentQuality(newEquipmentQuality); } if (!string.IsNullOrEmpty(newItem.AttachUrl)) { ////保存附件 UploadFileService.SaveAttachUrl(UploadFileService.GetSourceByAttachUrl(newItem.AttachUrl, 10, null), newItem.AttachUrl, Const.EquipmentQualityMenuId, newEquipmentQuality.EquipmentQualityId); } else { CommonService.DeleteAttachFileById(newEquipmentQuality.EquipmentQualityId); } }
/// <summary> /// 获取HSE日志列表信息 /// </summary> /// <param name="projectId"></param> /// <param name="userId"></param> /// <param name="diaryDate"></param> /// <returns></returns> public static List <Model.HSEDiaryItem> getHSEDiaryList(string projectId, string userId, string diaryDate) { DateTime?getDiaryDate = Funs.GetNewDateTime(diaryDate); var getDataList = from x in Funs.DB.Project_HSEDiary where x.ProjectId == projectId && (userId == null || x.UserId == userId) && (diaryDate == null || x.DiaryDate == getDiaryDate) orderby x.DiaryDate descending select new Model.HSEDiaryItem { HSEDiaryId = x.HSEDiaryId, ProjectId = x.ProjectId, DiaryDate = string.Format("{0:yyyy-MM-dd}", x.DiaryDate), UserId = x.UserId, UserName = Funs.DB.Sys_User.First(u => u.UserId == x.UserId).UserName, DailySummary = x.DailySummary, TomorrowPlan = x.TomorrowPlan, }; return(getDataList.ToList()); }
/// <summary> /// 获取HSE管理月报列表信息 /// </summary> /// <param name="projectId"></param> /// <param name="reportMonths"></param> /// <returns></returns> public static List <Model.HSEMonthItem> getHSEMonthList(string projectId, string reportMonths) { DateTime?getMonthDate = Funs.GetNewDateTime(reportMonths); var getDataList = from x in Funs.DB.Manager_MonthReport where x.ProjectId == projectId && (!getMonthDate.HasValue || x.ReportMonths == getMonthDate) orderby x.ReportMonths descending select new Model.HSEMonthItem { MonthReportId = x.MonthReportId, ProjectId = x.ProjectId, ReportManId = x.ReportMan, ReportManName = Funs.DB.Sys_User.First(u => u.UserId == x.ReportMan).UserName, ReportMonths = string.Format("{0:yyyy-MM}", x.ReportMonths), ReportStartDate = string.Format("{0:yyyy-MM}", x.MonthReportStartDate), ReportEndDate = string.Format("{0:yyyy-MM}", x.MonthReportDate), AllManhoursData = x.AllManhoursData, }; return(getDataList.ToList()); }
/// <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> /// 插入人员信息 0 /// </summary> /// <param name="projectId"></param> /// <param name="arr"></param> public static bool AddPerson(string projectId, JArray arr, Model.Sys_User user) { Model.SUBHSSEDB db = Funs.DB; bool isOk = true; try { foreach (var item in arr) { ////单位 string unitId = null; var getUnit = db.Base_Unit.FirstOrDefault(x => x.FromUnitId == item["DepartId"].ToString()); if (getUnit != null) { unitId = getUnit.UnitId; } ///区域 string workAreaId = null; var getWorkArea = db.ProjectData_WorkArea.FirstOrDefault(x => x.ProjectId == projectId && x.WorkAreaName == item["BuildArea"].ToString()); if (getWorkArea != null) { workAreaId = getWorkArea.WorkAreaId; } ///岗位 string workPostId = null; var getWorkPost = db.Base_WorkPost.FirstOrDefault(x => x.WorkPostName == item["Station"].ToString()); if (getWorkPost != null) { workPostId = getWorkPost.WorkPostId; } DateTime?inTime = Funs.GetNewDateTime(item["EntranceDate"].ToString()); DateTime?outTime = Funs.GetNewDateTime(item["LeaveDate"].ToString()); if (outTime < inTime) { outTime = null; } string IdentifyID = item["IdentifyID"].ToString(); if (!string.IsNullOrEmpty(IdentifyID)) { Model.SitePerson_Person newPerson = new Model.SitePerson_Person { FromPersonId = item["ID"].ToString(), CardNo = item["JobNumber"].ToString(), PersonName = item["Name"].ToString(), Sex = item["Sex"].ToString(), IdentityCard = IdentifyID, Address = item["Address"].ToString(), ProjectId = projectId, UnitId = unitId, /////映射取值 //TeamGroupId = person.TeamGroupId, WorkAreaId = workAreaId, /////关联映射取值 WorkPostId = workPostId, /////关联映射取值 InTime = inTime, OutTime = outTime, Telephone = item["ContactTel"].ToString(), IsUsed = true, IsCardUsed = true, }; var getPerson = db.SitePerson_Person.FirstOrDefault(x => x.ProjectId == projectId && x.IdentityCard == IdentifyID); if (getPerson == null) { newPerson.PersonId = SQLHelper.GetNewID(typeof(Model.SitePerson_Person)); PersonService.AddPerson(newPerson); BLL.LogService.AddSys_Log(user, newPerson.PersonName, newPerson.PersonId, BLL.Const.PersonListMenuId, BLL.Const.BtnAdd); } else { getPerson.FromPersonId = newPerson.FromPersonId; getPerson.InTime = newPerson.InTime; getPerson.OutTime = newPerson.OutTime; getPerson.Telephone = newPerson.Telephone; if (!string.IsNullOrEmpty(unitId)) { getPerson.UnitId = unitId; } if (!string.IsNullOrEmpty(workAreaId)) { getPerson.WorkAreaId = workAreaId; } if (!string.IsNullOrEmpty(workPostId)) { getPerson.WorkPostId = workPostId; } PersonService.UpdatePerson(getPerson); BLL.LogService.AddSys_Log(user, getPerson.PersonName, getPerson.PersonId, BLL.Const.PersonListMenuId, BLL.Const.BtnModify); } } } } catch (Exception ex) { isOk = false; ErrLogInfo.WriteLog(string.Empty, ex); } return(isOk); }
/// <summary> /// 保存TestPlan /// </summary> /// <param name="getTestPlan">考试计划记录</param> public static string SaveTestPlan(Model.TestPlanItem getTestPlan) { string alterStr = string.Empty; using (Model.SUBHSSEDB db = new Model.SUBHSSEDB(Funs.ConnString)) { Model.Training_TestPlan newTestPlan = new Model.Training_TestPlan { TestPlanId = getTestPlan.TestPlanId, ProjectId = getTestPlan.ProjectId, PlanCode = getTestPlan.TestPlanCode, PlanName = getTestPlan.TestPlanName, PlanManId = getTestPlan.TestPlanManId, //PlanDate= getTestPlan.TestPlanDate, TestStartTime = Funs.GetNewDateTimeOrNow(getTestPlan.TestStartTime), TestEndTime = Funs.GetNewDateTimeOrNow(getTestPlan.TestEndTime), Duration = getTestPlan.Duration, SValue = getTestPlan.SValue, MValue = getTestPlan.MValue, JValue = getTestPlan.JValue, TotalScore = getTestPlan.TotalScore, QuestionCount = getTestPlan.QuestionCount, TestPalce = getTestPlan.TestPalce, UnitIds = getTestPlan.UnitIds, WorkPostIds = getTestPlan.WorkPostIds, States = getTestPlan.States, PlanDate = DateTime.Now, }; if (!string.IsNullOrEmpty(getTestPlan.TrainingPlanId)) { newTestPlan.PlanId = getTestPlan.TrainingPlanId; } var isUpdate = db.Training_TestPlan.FirstOrDefault(x => x.TestPlanId == newTestPlan.TestPlanId); if (isUpdate == null) { string unitId = string.Empty; var user = db.Sys_User.FirstOrDefault(e => e.UserId == newTestPlan.PlanManId); if (user != null) { unitId = user.UnitId; } newTestPlan.PlanCode = CodeRecordsService.ReturnCodeByMenuIdProjectId(Const.ProjectTestPlanMenuId, newTestPlan.ProjectId, unitId); if (string.IsNullOrEmpty(newTestPlan.TestPlanId)) { newTestPlan.TestPlanId = SQLHelper.GetNewID(); } db.Training_TestPlan.InsertOnSubmit(newTestPlan); db.SubmitChanges(); CodeRecordsService.InsertCodeRecordsByMenuIdProjectIdUnitId(Const.ProjectTestPlanMenuId, newTestPlan.ProjectId, null, newTestPlan.TestPlanId, newTestPlan.PlanDate); } else { isUpdate.States = newTestPlan.States; if (isUpdate.States == "0" || isUpdate.States == "1") { isUpdate.PlanName = newTestPlan.PlanName; isUpdate.PlanManId = newTestPlan.PlanManId; isUpdate.PlanDate = newTestPlan.PlanDate; isUpdate.TestStartTime = newTestPlan.TestStartTime; isUpdate.TestEndTime = newTestPlan.TestEndTime; isUpdate.Duration = newTestPlan.Duration; isUpdate.TotalScore = newTestPlan.TotalScore; isUpdate.QuestionCount = newTestPlan.QuestionCount; isUpdate.TestPalce = newTestPlan.TestPalce; isUpdate.UnitIds = newTestPlan.UnitIds; isUpdate.WorkPostIds = newTestPlan.WorkPostIds; ////删除 考生记录 var deleteRecords = from x in db.Training_TestRecord where x.TestPlanId == isUpdate.TestPlanId select x; if (deleteRecords.Count() > 0) { foreach (var item in deleteRecords) { var testRecordItem = from x in db.Training_TestRecordItem where x.TestRecordId == item.TestRecordId select x; if (testRecordItem.Count() > 0) { db.Training_TestRecordItem.DeleteAllOnSubmit(testRecordItem); db.SubmitChanges(); } } db.Training_TestRecord.DeleteAllOnSubmit(deleteRecords); db.SubmitChanges(); } ////删除 考试题目类型 var deleteTestPlanTrainings = from x in db.Training_TestPlanTraining where x.TestPlanId == isUpdate.TestPlanId select x; if (deleteTestPlanTrainings.Count() > 0) { db.Training_TestPlanTraining.DeleteAllOnSubmit(deleteTestPlanTrainings); db.SubmitChanges(); } } else if (isUpdate.States == "3") ////考试状态3时 更新培训计划状态 把培训计划写入培训记录中 { DateTime?endTime = Funs.GetNewDateTime(getTestPlan.TestEndTime); ////判断是否有未考完的考生 var getTrainingTestRecords = db.Training_TestRecord.FirstOrDefault(x => x.TestPlanId == isUpdate.TestPlanId && (!x.TestStartTime.HasValue || ((!x.TestEndTime.HasValue || !x.TestScores.HasValue) && x.TestStartTime.Value.AddMinutes(isUpdate.Duration) >= DateTime.Now))); if (getTrainingTestRecords != null && endTime.HasValue && endTime.Value.AddMinutes(isUpdate.Duration) < DateTime.Now) { alterStr = "当前存在未交卷考生,不能提前结束考试!"; isUpdate.States = "2"; } else { SubmitTest(isUpdate); } } else if (newTestPlan.States == "2") ////开始考试 只更新考试计划状态为考试中。 { if (isUpdate.TestStartTime > DateTime.Now) { isUpdate.States = "1"; alterStr = "未到考试扫码开始时间,不能开始考试!"; } } if (string.IsNullOrEmpty(alterStr)) { db.SubmitChanges(); } } if (newTestPlan.States == "0" || newTestPlan.States == "1") { if (getTestPlan.TestRecordItems.Count() > 0) { ////新增考试人员明细 foreach (var item in getTestPlan.TestRecordItems) { var person = db.SitePerson_Person.FirstOrDefault(e => e.PersonId == item.TestManId); if (person != null) { Model.Training_TestRecord newTrainDetail = new Model.Training_TestRecord { TestRecordId = SQLHelper.GetNewID(), ProjectId = newTestPlan.ProjectId, TestPlanId = newTestPlan.TestPlanId, TestManId = item.TestManId, TestType = item.TestType, Duration = newTestPlan.Duration, }; db.Training_TestRecord.InsertOnSubmit(newTrainDetail); db.SubmitChanges(); } } } if (getTestPlan.TestPlanTrainingItems.Count() > 0) { foreach (var item in getTestPlan.TestPlanTrainingItems) { var trainingType = TestTrainingService.GetTestTrainingById(item.TrainingTypeId); if (trainingType != null) { Model.Training_TestPlanTraining newPlanItem = new Model.Training_TestPlanTraining { TestPlanTrainingId = SQLHelper.GetNewID(), TestPlanId = newTestPlan.TestPlanId, TrainingId = item.TrainingTypeId, TestType1Count = item.TestType1Count, TestType2Count = item.TestType2Count, TestType3Count = item.TestType3Count, }; db.Training_TestPlanTraining.InsertOnSubmit(newPlanItem); db.SubmitChanges(); } } } } } return(alterStr); }
/// <summary> /// 增加人员信息 /// </summary> /// <param name="person">人员实体</param> public static void AddPerson(Model.SitePerson_Person person) { Model.SUBHSSEDB db = Funs.DB; Model.SitePerson_Person newPerson = new Model.SitePerson_Person { PersonId = person.PersonId, CardNo = person.CardNo, PersonName = person.PersonName, Sex = person.Sex, IdentityCard = person.IdentityCard, Address = person.Address, ProjectId = person.ProjectId, UnitId = person.UnitId, TeamGroupId = person.TeamGroupId, WorkAreaId = person.WorkAreaId, WorkPostId = person.WorkPostId, OutTime = person.OutTime, OutResult = person.OutResult, Telephone = person.Telephone, PositionId = person.PositionId, PostTitleId = person.PostTitleId, PhotoUrl = person.PhotoUrl, IsUsed = person.IsUsed, IsCardUsed = person.IsCardUsed, DepartId = person.DepartId, FromPersonId = person.FromPersonId, Password = GetPersonPassWord(person.IdentityCard), AuditorId = person.AuditorId, AuditorDate = person.AuditorDate, IsForeign = person.IsForeign, IsOutside = person.IsOutside, Isprint = "0", }; if (person.InTime.HasValue) { newPerson.InTime = person.InTime; } else { newPerson.InTime = Funs.GetNewDateTime(DateTime.Now.ToShortDateString()); } db.SitePerson_Person.InsertOnSubmit(newPerson); db.SubmitChanges(); if (!CommonService.GetIsThisUnit(Const.UnitId_SEDIN)) { ///写入人员出入场时间表 Model.SitePerson_PersonInOut newPersonInOut = new Model.SitePerson_PersonInOut { ProjectId = person.ProjectId, UnitId = person.UnitId, PersonId = person.PersonId }; if (newPerson.InTime.HasValue) { newPersonInOut.ChangeTime = person.InTime; newPersonInOut.IsIn = true; BLL.PersonInOutService.AddPersonInOut(newPersonInOut); } if (newPerson.OutTime.HasValue) { newPersonInOut.ChangeTime = person.OutTime; newPersonInOut.IsIn = false; BLL.PersonInOutService.AddPersonInOut(newPersonInOut); } } ////增加一条编码记录 BLL.CodeRecordsService.InsertCodeRecordsByMenuIdProjectIdUnitId(BLL.Const.PersonListMenuId, person.ProjectId, person.UnitId, person.PersonId, person.InTime); }
/// <summary> /// 生成安全资料计划总表 方法 /// </summary> /// <param name="project"></param> /// <param name="safetyDataEnd"></param> public static void GetSafetyDataPlanMethod(Model.Base_Project project, List <Model.SafetyData_SafetyData> safetyDataEnd, DateTime?startTime, DateTime?endTime) { ////第一步 判断是否存在此项目的计划表 ////第二步 不存在增加这个项目时间范围内的 存在取不存在时间段 ////第三步 项目时间 是否为空? 现在默认都不能为空 Model.SUBHSSEDB db = Funs.DB; string projectId = project.ProjectId; DateTime startDatep = project.StartDate.HasValue ? project.StartDate.Value : System.DateTime.Now; if (startTime.HasValue) { startDatep = startTime.Value; } DateTime startDate = startDatep; DateTime endDate = project.EndDate.HasValue ? project.EndDate.Value : System.DateTime.Now.AddMonths(6); if (endTime.HasValue) { endDate = endTime.Value; } DeleteSafetyDataPlanByProjectDateId(projectId, endDate); ///删除竣工后的考核计划 foreach (var item in safetyDataEnd) { var safetyDataPlan = db.SafetyData_SafetyDataPlan.FirstOrDefault(x => x.ProjectId == project.ProjectId && x.SafetyDataId == item.SafetyDataId && (x.IsManual == null || x.IsManual == false)); if (safetyDataPlan != null) { ///取结束时间 最大值作为开始时间 DateTime maxEndDate = Funs.DB.SafetyData_SafetyDataPlan.Where(x => x.ProjectId == projectId && x.RealEndDate.HasValue && x.SafetyDataId == item.SafetyDataId).Select(x => x.RealEndDate.Value).Max(); if (endDate > maxEndDate) ////如果计划单最大时间小于项目结束时间 则追加时间 否则删去 { startDate = maxEndDate; } else { ///项目提前结束 则删除计划时间 var delSafetyDataPlan = from x in db.SafetyData_SafetyDataPlan where x.RealEndDate > endDate && x.SafetyDataId == item.SafetyDataId select x; if (delSafetyDataPlan.Count() > 0) { db.SafetyData_SafetyDataPlan.DeleteAllOnSubmit(delSafetyDataPlan); } } } ////算出 开始、结束时间跨度 然后循环增加一个月 并把在此时间段的 考核项写入计划表 for (int i = 0; startDate.AddMonths(i) <= endDate; i++) { Model.SafetyData_SafetyDataPlan newSafetyDataPlan = new Model.SafetyData_SafetyDataPlan { SafetyDataPlanId = SQLHelper.GetNewID(typeof(Model.SafetyData_SafetyDataPlan)), ProjectId = projectId, SafetyDataId = item.SafetyDataId, Score = item.Score, ShouldScore = item.Score, Remark = item.Remark, }; int monthValue = 0; ///设置月数 if (item.CheckTypeValue1.HasValue) { monthValue = item.CheckTypeValue1.Value; } int dateValue = 1; ///设置天 if (item.CheckTypeValue2.HasValue) { dateValue = item.CheckTypeValue2.Value; if (dateValue > 30) { dateValue = 30; } } ////TODO:通过判断是月报、季报、定时报等情况 是否落在 当前时间范围内 写入到计划总表 if (item.CheckType == BLL.Const.SafetyDataCheckType_1) /// 月报 { if (startDate.AddMonths(i + monthValue).Month == 2 && dateValue > 28) { dateValue = 28; } DateTime?checkDate = Funs.GetNewDateTime(startDate.AddMonths(i + monthValue).Year + "-" + startDate.AddMonths(i + monthValue).Month + "-" + dateValue); if (checkDate.HasValue && checkDate <= endDate && checkDate >= startDatep) { newSafetyDataPlan.CheckDate = checkDate; newSafetyDataPlan.RealStartDate = checkDate.Value.AddMonths(-1); ///月报开始日期 newSafetyDataPlan.RealStartDate = new DateTime(newSafetyDataPlan.RealStartDate.Value.Year, newSafetyDataPlan.RealStartDate.Value.Month, 1); newSafetyDataPlan.RealEndDate = newSafetyDataPlan.RealStartDate.Value.AddMonths(1).AddDays(-1); } } else if (item.CheckType == BLL.Const.SafetyDataCheckType_2) /// 季报 { int month = startDate.AddMonths(i).Month; ///当前月份 if ((month == 3 + monthValue) || (month == 6 + monthValue) || (month == 9 + monthValue) || (month == monthValue) || (month == 12 && monthValue == 0)) ///考核季度时间 { if (startDate.AddMonths(i + monthValue).Month == 2 && dateValue > 28) { dateValue = 28; } DateTime?checkDate = Funs.GetNewDateTime(startDate.AddMonths(i).Year + "-" + startDate.AddMonths(i).Month + "-" + dateValue); if ((month == monthValue) && monthValue != 0) { checkDate = checkDate.Value.AddYears(1); } if (checkDate.HasValue && checkDate <= endDate && checkDate >= startDatep) { newSafetyDataPlan.CheckDate = checkDate; newSafetyDataPlan.RealStartDate = checkDate.Value.AddMonths(-3); ///开始日期 newSafetyDataPlan.RealStartDate = new DateTime(newSafetyDataPlan.RealStartDate.Value.Year, newSafetyDataPlan.RealStartDate.Value.Month, 1); newSafetyDataPlan.RealEndDate = newSafetyDataPlan.RealStartDate.Value.AddMonths(3).AddDays(-1); } } } else if (item.CheckType == BLL.Const.SafetyDataCheckType_3) /// 定时 { if (startDate.AddMonths(i).Month == monthValue) ///定时月份 { if (startDate.AddMonths(i + monthValue).Month == 2 && dateValue > 28) { dateValue = 28; } DateTime?checkDate = Funs.GetNewDateTime(startDate.AddMonths(i).Year + "-" + startDate.AddMonths(i).Month + "-" + dateValue); if (checkDate.HasValue && checkDate <= endDate && checkDate >= startDatep) { newSafetyDataPlan.CheckDate = checkDate; newSafetyDataPlan.RealStartDate = checkDate.Value.AddMonths(-12); ///开始日期 newSafetyDataPlan.RealStartDate = new DateTime(newSafetyDataPlan.RealStartDate.Value.Year, newSafetyDataPlan.RealStartDate.Value.Month, 1); newSafetyDataPlan.RealEndDate = checkDate.Value; } } } else if (item.CheckType == BLL.Const.SafetyDataCheckType_4) /// 开工后报 { DateTime?checkDate = startDate.AddMonths(i); if (checkDate.HasValue && checkDate <= endDate && BLL.Funs.CompareMonths(startDatep, checkDate.Value) == monthValue && checkDate >= startDatep) { newSafetyDataPlan.CheckDate = checkDate; newSafetyDataPlan.RealStartDate = startDate; ///开始日期 newSafetyDataPlan.RealEndDate = checkDate.Value; } } else if (item.CheckType == BLL.Const.SafetyDataCheckType_5) /// 半年报 { if (startDate.AddMonths(i).Month == monthValue || startDate.AddMonths(i).Month == monthValue + 6) { if (startDate.AddMonths(i + monthValue).Month == 2 && dateValue > 28) { dateValue = 28; } DateTime?checkDate = Funs.GetNewDateTime(startDate.AddMonths(i).Year + "-" + startDate.AddMonths(i).Month + "-" + dateValue); if (checkDate.HasValue && checkDate <= endDate && checkDate >= startDatep) { newSafetyDataPlan.CheckDate = checkDate; newSafetyDataPlan.RealStartDate = checkDate.Value.AddMonths(-6); ///开始日期 newSafetyDataPlan.RealStartDate = new DateTime(newSafetyDataPlan.RealStartDate.Value.Year, newSafetyDataPlan.RealStartDate.Value.Month, 1); newSafetyDataPlan.RealEndDate = newSafetyDataPlan.RealStartDate.Value.AddMonths(6).AddDays(-1); } } } else /// 其他 { if (monthValue > 0 && startDate.AddMonths(i).Year == System.DateTime.Now.Year && startDate.AddMonths(i).Month == monthValue) { if (startDate.AddMonths(i + monthValue).Month == 2 && dateValue > 28) { dateValue = 28; } DateTime?checkDate = Funs.GetNewDateTime(startDate.AddMonths(i).Year + "-" + startDate.AddMonths(i).Month + "-" + dateValue); if (checkDate.HasValue && checkDate <= endDate && checkDate >= startDatep) { newSafetyDataPlan.CheckDate = checkDate; newSafetyDataPlan.RealStartDate = startDate; ///开始日期 newSafetyDataPlan.RealStartDate = new DateTime(newSafetyDataPlan.RealStartDate.Value.Year, newSafetyDataPlan.RealStartDate.Value.Month, 1); newSafetyDataPlan.RealEndDate = checkDate.Value; } } } if (newSafetyDataPlan.RealEndDate.HasValue) { newSafetyDataPlan.ReminderDate = newSafetyDataPlan.CheckDate.Value.AddDays(-7); AddSafetyDataPlan(newSafetyDataPlan); } } } }
/// <summary> /// 保存Check_CheckSpecial /// </summary> /// <param name="newItem">处罚通知单</param> /// <returns></returns> public static string SaveCheckSpecial(Model.CheckSpecialItem newItem) { using (Model.SUBHSSEDB db = new Model.SUBHSSEDB(Funs.ConnString)) { string message = string.Empty; Model.Check_CheckSpecial newCheckSpecial = new Model.Check_CheckSpecial { CheckSpecialId = newItem.CheckSpecialId, CheckSpecialCode = newItem.CheckSpecialCode, CheckItemSetId = newItem.CheckItemSetId, CheckType = newItem.CheckType, ProjectId = newItem.ProjectId, CheckPerson = newItem.CheckPersonId, CheckTime = Funs.GetNewDateTime(newItem.CheckTime), DaySummary = System.Web.HttpUtility.HtmlEncode(newItem.DaySummary), PartInUnits = newItem.PartInUnitIds, PartInPersonIds = newItem.PartInPersonIds, PartInPersons = UserService.getUserNamesUserIds(newItem.PartInPersonIds), PartInPersonNames = newItem.PartInPersonNames2, CompileMan = newItem.CompileManId, States = Const.State_2, }; if (newItem.States != "1") { newCheckSpecial.States = Const.State_0; } var updateCheckSpecial = db.Check_CheckSpecial.FirstOrDefault(x => x.CheckSpecialId == newItem.CheckSpecialId); if (updateCheckSpecial == null) { newCheckSpecial.CheckSpecialId = SQLHelper.GetNewID(); newCheckSpecial.CheckSpecialCode = CodeRecordsService.ReturnCodeByMenuIdProjectId(Const.ProjectCheckSpecialMenuId, newCheckSpecial.ProjectId, string.Empty); db.Check_CheckSpecial.InsertOnSubmit(newCheckSpecial); db.SubmitChanges(); ////增加一条编码记录 BLL.CodeRecordsService.InsertCodeRecordsByMenuIdProjectIdUnitId(BLL.Const.ProjectCheckSpecialMenuId, newCheckSpecial.ProjectId, null, newCheckSpecial.CheckSpecialId, newCheckSpecial.CheckTime); } else { Check_CheckSpecialService.UpdateCheckSpecial(newCheckSpecial); //// 删除专项检查明细项 Check_CheckSpecialDetailService.DeleteCheckSpecialDetails(newCheckSpecial.CheckSpecialId); } if (newCheckSpecial.States == "1") { CommonService.btnSaveData(newCheckSpecial.ProjectId, Const.ProjectCheckSpecialMenuId, newCheckSpecial.CheckSpecialId, newCheckSpecial.CompileMan, true, newCheckSpecial.CheckSpecialCode, "../Check/CheckSpecialView.aspx?CheckSpecialId={0}"); } ////保存附件 if (!string.IsNullOrEmpty(newItem.AttachUrl1)) { UploadFileService.SaveAttachUrl(UploadFileService.GetSourceByAttachUrl(newItem.AttachUrl1, 10, null), newItem.AttachUrl1, Const.ProjectCheckSpecialMenuId, newCheckSpecial.CheckSpecialId); } else { CommonService.DeleteAttachFileById(Const.ProjectCheckSpecialMenuId, newCheckSpecial.CheckSpecialId); } ///// 新增检查项 if (newItem.CheckSpecialDetailItems != null && newItem.CheckSpecialDetailItems.Count() > 0) { foreach (var item in newItem.CheckSpecialDetailItems) { item.CheckSpecialId = newCheckSpecial.CheckSpecialId; SaveCheckSpecialDetail(item); } //// 单据完成后 系统自动按照单位 整改要求生成隐患整改单 if (newCheckSpecial.States == Const.State_2) { SaveNewRectifyNotices(newItem); message = "已生成整改单,请在隐患整改单待提交中签发!"; } } return(message); } }
/// <summary> /// 根据安全工作总结Id获取安全工作总结信息 /// </summary> /// <param name="ManagerTotalId"></param> /// <returns></returns> public static List <Model.SpManagerTotalMonthSafetyDataDItem> GetManager_SafetyDataD(string date) { List <Model.SpManagerTotalMonthSafetyDataDItem> reportSafetyDataD = new List <Model.SpManagerTotalMonthSafetyDataDItem>(); DateTime?monthTime = Funs.GetNewDateTime(date); var projectList = BLL.ProjectService.GetTotalMonthProjectWorkList(monthTime); int sortIndex = 1; Model.SpManagerTotalMonthSafetyDataDItem sunmPart = new Model.SpManagerTotalMonthSafetyDataDItem { ID = SQLHelper.GetNewID(typeof(Model.Manager_ManagerTotalMonth)), ProjectName = "合计", ThisUnitPersonNum = "0", ThisUnitHSEPersonNum = "0", SubUnitPersonNum = "0", SubUnitHSEPersonNum = "0", ManHours = "0", HSEManHours = "0" }; foreach (var projectItem in projectList) { Model.SpManagerTotalMonthSafetyDataDItem part = new Model.SpManagerTotalMonthSafetyDataDItem { ID = projectItem.ProjectId, ProjectName = projectItem.ProjectName, SortIndex = sortIndex, ThisUnitPersonNum = "/", ThisUnitHSEPersonNum = "/", SubUnitPersonNum = "/", SubUnitHSEPersonNum = "/", ManHours = "/", HSEManHours = "/" }; var projectMontReportD = Funs.DB.Manager_MonthReportD.FirstOrDefault(x => x.ProjectId == projectItem.ProjectId && (x.Months.Value.Year == monthTime.Value.Year && x.Months.Value.Month == monthTime.Value.Month)); if (projectMontReportD != null) { var safetyDataD = Funs.DB.Manager_SafetyDataD.FirstOrDefault(x => x.MonthReportId == projectMontReportD.MonthReportId); if (safetyDataD != null) { part.ThisUnitPersonNum = safetyDataD.ThisUnitPersonNum.ToString(); part.ThisUnitHSEPersonNum = safetyDataD.ThisUnitHSEPersonNum.ToString(); part.SubUnitPersonNum = safetyDataD.SubUnitPersonNum.ToString(); part.SubUnitHSEPersonNum = safetyDataD.SubUnitHSEPersonNum.ToString(); part.ManHours = safetyDataD.ManHours.ToString(); part.HSEManHours = safetyDataD.HSEManHours.ToString(); sunmPart.ThisUnitPersonNum = (Funs.GetNewIntOrZero(sunmPart.ThisUnitPersonNum) + Funs.GetNewIntOrZero(part.ThisUnitPersonNum)).ToString(); sunmPart.ThisUnitHSEPersonNum = (Funs.GetNewIntOrZero(sunmPart.ThisUnitHSEPersonNum) + Funs.GetNewIntOrZero(part.ThisUnitHSEPersonNum)).ToString(); sunmPart.SubUnitPersonNum = (Funs.GetNewIntOrZero(sunmPart.SubUnitPersonNum) + Funs.GetNewIntOrZero(part.SubUnitPersonNum)).ToString(); sunmPart.SubUnitHSEPersonNum = (Funs.GetNewIntOrZero(sunmPart.SubUnitHSEPersonNum) + Funs.GetNewIntOrZero(part.SubUnitHSEPersonNum)).ToString(); sunmPart.ManHours = (Funs.GetNewIntOrZero(sunmPart.ManHours) + Funs.GetNewIntOrZero(part.ManHours)).ToString(); sunmPart.HSEManHours = (Funs.GetNewIntOrZero(sunmPart.HSEManHours) + Funs.GetNewIntOrZero(part.HSEManHours)).ToString(); } } reportSafetyDataD.Add(part); sortIndex++; } sunmPart.SortIndex = projectList.Count() + 1; reportSafetyDataD.Add(sunmPart); return(reportSafetyDataD); }
/// <summary> /// 保存Meeting /// </summary> /// <param name="meeting">会议信息</param> /// <returns></returns> public static void SaveMeeting(Model.MeetingItem meeting) { Model.SUBHSSEDB db = Funs.DB; string menuId = string.Empty; if (meeting.MeetingType == "C") { Model.Meeting_ClassMeeting newClassMeeting = new Model.Meeting_ClassMeeting { ClassMeetingId = meeting.MeetingId, ProjectId = meeting.ProjectId, UnitId = meeting.UnitId == "" ? null : meeting.UnitId, TeamGroupId = meeting.TeamGroupId == "" ? null : meeting.TeamGroupId, ClassMeetingCode = meeting.MeetingCode, ClassMeetingName = meeting.MeetingName, ClassMeetingDate = Funs.GetNewDateTime(meeting.MeetingDate), ClassMeetingContents = meeting.MeetingContents, CompileMan = meeting.CompileManId, MeetingPlace = meeting.MeetingPlace, MeetingHours = meeting.MeetingHours, MeetingHostMan = meeting.MeetingHostMan, AttentPerson = meeting.AttentPerson, AttentPersonNum = meeting.AttentPersonNum, States = Const.State_2, }; if (meeting.States != "1") { newClassMeeting.States = Const.State_0; } var updateMeet = Funs.DB.Meeting_ClassMeeting.FirstOrDefault(x => x.ClassMeetingId == meeting.MeetingId); if (updateMeet == null) { newClassMeeting.CompileDate = DateTime.Now; meeting.MeetingId = newClassMeeting.ClassMeetingId = SQLHelper.GetNewID(); newClassMeeting.ClassMeetingCode = CodeRecordsService.ReturnCodeByMenuIdProjectId(Const.ProjectClassMeetingMenuId, newClassMeeting.ProjectId, null); ClassMeetingService.AddClassMeeting(newClassMeeting); } else { ClassMeetingService.UpdateClassMeeting(newClassMeeting); } if (meeting.States == "1") { CommonService.btnSaveData(meeting.ProjectId, Const.ProjectClassMeetingMenuId, newClassMeeting.ClassMeetingId, newClassMeeting.CompileMan, true, newClassMeeting.ClassMeetingName, "../Meeting/ClassMeetingView.aspx?ClassMeetingId={0}"); } menuId = Const.ProjectClassMeetingMenuId; } else if (meeting.MeetingType == "W") { Model.Meeting_WeekMeeting newWeekMeeting = new Model.Meeting_WeekMeeting { WeekMeetingId = meeting.MeetingId, ProjectId = meeting.ProjectId, UnitId = meeting.UnitId == "" ? null : meeting.UnitId, WeekMeetingCode = meeting.MeetingCode, WeekMeetingName = meeting.MeetingName, WeekMeetingDate = Funs.GetNewDateTime(meeting.MeetingDate), WeekMeetingContents = meeting.MeetingContents, CompileMan = meeting.CompileManId, CompileDate = Funs.GetNewDateTime(meeting.CompileDate), MeetingPlace = meeting.MeetingPlace, MeetingHours = meeting.MeetingHours, MeetingHostMan = meeting.MeetingHostMan, AttentPerson = meeting.AttentPerson, AttentPersonNum = meeting.AttentPersonNum, States = Const.State_2, AttentPersonIds = meeting.AttentPersonIds, }; if (meeting.States != "1") { newWeekMeeting.States = Const.State_0; } if (!string.IsNullOrEmpty(meeting.MeetingHostManId)) { newWeekMeeting.MeetingHostManId = meeting.MeetingHostManId; } var updateMeet = Funs.DB.Meeting_WeekMeeting.FirstOrDefault(x => x.WeekMeetingId == meeting.MeetingId); if (updateMeet == null) { newWeekMeeting.CompileDate = DateTime.Now; meeting.MeetingId = newWeekMeeting.WeekMeetingId = SQLHelper.GetNewID(); newWeekMeeting.WeekMeetingCode = CodeRecordsService.ReturnCodeByMenuIdProjectId(Const.ProjectWeekMeetingMenuId, newWeekMeeting.ProjectId, null); WeekMeetingService.AddWeekMeeting(newWeekMeeting); } else { WeekMeetingService.UpdateWeekMeeting(newWeekMeeting); } if (meeting.States == "1") { CommonService.btnSaveData(meeting.ProjectId, Const.ProjectWeekMeetingMenuId, newWeekMeeting.WeekMeetingId, newWeekMeeting.CompileMan, true, newWeekMeeting.WeekMeetingName, "../Meeting/WeekMeetingView.aspx?WeekMeetingId={0}"); } menuId = Const.ProjectWeekMeetingMenuId; } else if (meeting.MeetingType == "M") { Model.Meeting_MonthMeeting newMonthMeeting = new Model.Meeting_MonthMeeting { MonthMeetingId = meeting.MeetingId, ProjectId = meeting.ProjectId, UnitId = meeting.UnitId == "" ? null : meeting.UnitId, MonthMeetingCode = meeting.MeetingCode, MonthMeetingName = meeting.MeetingName, MonthMeetingDate = Funs.GetNewDateTime(meeting.MeetingDate), MonthMeetingContents = meeting.MeetingContents, CompileMan = meeting.CompileManId, CompileDate = Funs.GetNewDateTime(meeting.CompileDate), MeetingPlace = meeting.MeetingPlace, MeetingHours = meeting.MeetingHours, MeetingHostMan = meeting.MeetingHostMan, AttentPerson = meeting.AttentPerson, AttentPersonNum = meeting.AttentPersonNum, States = Const.State_2, AttentPersonIds = meeting.AttentPersonIds, }; if (meeting.States != "1") { newMonthMeeting.States = Const.State_0; } if (!string.IsNullOrEmpty(meeting.MeetingHostManId)) { newMonthMeeting.MeetingHostManId = meeting.MeetingHostManId; } var updateMeet = Funs.DB.Meeting_MonthMeeting.FirstOrDefault(x => x.MonthMeetingId == meeting.MeetingId); if (updateMeet == null) { newMonthMeeting.CompileDate = DateTime.Now; meeting.MeetingId = newMonthMeeting.MonthMeetingId = SQLHelper.GetNewID(); newMonthMeeting.MonthMeetingCode = CodeRecordsService.ReturnCodeByMenuIdProjectId(Const.ProjectMonthMeetingMenuId, newMonthMeeting.ProjectId, null); MonthMeetingService.AddMonthMeeting(newMonthMeeting); } else { MonthMeetingService.UpdateMonthMeeting(newMonthMeeting); } if (meeting.States == "1") { CommonService.btnSaveData(meeting.ProjectId, Const.ProjectMonthMeetingMenuId, newMonthMeeting.MonthMeetingId, newMonthMeeting.CompileMan, true, newMonthMeeting.MonthMeetingName, "../Meeting/MonthMeetingView.aspx?MonthMeetingId={0}"); } menuId = Const.ProjectMonthMeetingMenuId; } else if (meeting.MeetingType == "S") { Model.Meeting_SpecialMeeting newSpecialMeeting = new Model.Meeting_SpecialMeeting { SpecialMeetingId = meeting.MeetingId, ProjectId = meeting.ProjectId, UnitId = meeting.UnitId == "" ? null : meeting.UnitId, SpecialMeetingCode = meeting.MeetingCode, SpecialMeetingName = meeting.MeetingName, SpecialMeetingDate = Funs.GetNewDateTime(meeting.MeetingDate), SpecialMeetingContents = meeting.MeetingContents, CompileMan = meeting.CompileManId, CompileDate = Funs.GetNewDateTime(meeting.CompileDate), MeetingPlace = meeting.MeetingPlace, MeetingHours = meeting.MeetingHours, MeetingHostMan = meeting.MeetingHostMan, AttentPerson = meeting.AttentPerson, AttentPersonNum = meeting.AttentPersonNum, States = Const.State_2, //MeetingHostManId = meeting.MeetingHostManId, AttentPersonIds = meeting.AttentPersonIds, }; if (meeting.States != "1") { newSpecialMeeting.States = Const.State_0; } if (!string.IsNullOrEmpty(meeting.MeetingHostManId)) { newSpecialMeeting.MeetingHostManId = meeting.MeetingHostManId; } var updateMeet = Funs.DB.Meeting_SpecialMeeting.FirstOrDefault(x => x.SpecialMeetingId == meeting.MeetingId); if (updateMeet == null) { newSpecialMeeting.CompileDate = DateTime.Now; meeting.MeetingId = newSpecialMeeting.SpecialMeetingId = SQLHelper.GetNewID(); newSpecialMeeting.SpecialMeetingCode = CodeRecordsService.ReturnCodeByMenuIdProjectId(Const.ProjectSpecialMeetingMenuId, newSpecialMeeting.ProjectId, null); SpecialMeetingService.AddSpecialMeeting(newSpecialMeeting); } else { SpecialMeetingService.UpdateSpecialMeeting(newSpecialMeeting); } if (meeting.States == "1") { CommonService.btnSaveData(meeting.ProjectId, Const.ProjectSpecialMeetingMenuId, newSpecialMeeting.SpecialMeetingId, newSpecialMeeting.CompileMan, true, newSpecialMeeting.SpecialMeetingName, "../Meeting/SpecialMeetingView.aspx?SpecialMeetingId={0}"); } menuId = Const.ProjectSpecialMeetingMenuId; } else { Model.Meeting_AttendMeeting newAttendMeeting = new Model.Meeting_AttendMeeting { AttendMeetingId = meeting.MeetingId, ProjectId = meeting.ProjectId, UnitId = meeting.UnitId == "" ? null : meeting.UnitId, AttendMeetingCode = meeting.MeetingCode, AttendMeetingName = meeting.MeetingName, AttendMeetingDate = Funs.GetNewDateTime(meeting.MeetingDate), AttendMeetingContents = meeting.MeetingContents, CompileMan = meeting.CompileManId, CompileDate = Funs.GetNewDateTime(meeting.CompileDate), MeetingPlace = meeting.MeetingPlace, MeetingHours = meeting.MeetingHours, MeetingHostMan = meeting.MeetingHostMan, AttentPerson = meeting.AttentPerson, AttentPersonNum = meeting.AttentPersonNum, States = Const.State_2, //MeetingHostManId = meeting.MeetingHostManId, AttentPersonIds = meeting.AttentPersonIds, }; if (meeting.States != "1") { newAttendMeeting.States = Const.State_0; } if (!string.IsNullOrEmpty(meeting.MeetingHostManId)) { newAttendMeeting.MeetingHostManId = meeting.MeetingHostManId; } var updateMeet = Funs.DB.Meeting_AttendMeeting.FirstOrDefault(x => x.AttendMeetingId == meeting.MeetingId); if (updateMeet == null) { newAttendMeeting.CompileDate = DateTime.Now; meeting.MeetingId = newAttendMeeting.AttendMeetingId = SQLHelper.GetNewID(); newAttendMeeting.AttendMeetingCode = CodeRecordsService.ReturnCodeByMenuIdProjectId(Const.ProjectAttendMeetingMenuId, newAttendMeeting.ProjectId, null); AttendMeetingService.AddAttendMeeting(newAttendMeeting); } else { AttendMeetingService.UpdateAttendMeeting(newAttendMeeting); } if (meeting.States == "1") { CommonService.btnSaveData(meeting.ProjectId, Const.ProjectAttendMeetingMenuId, newAttendMeeting.AttendMeetingId, newAttendMeeting.CompileMan, true, newAttendMeeting.AttendMeetingName, "../Meeting/AttendMeetingView.aspx?AttendMeetingId={0}"); } menuId = Const.ProjectAttendMeetingMenuId; } if (!string.IsNullOrEmpty(menuId) && !string.IsNullOrEmpty(meeting.MeetingId)) { SaveMeetUrl(meeting.MeetingId, menuId, meeting.AttachUrl, meeting.AttachUrl1, meeting.AttachUrl2); } }
/// <summary> /// 保存Check_PauseNotice /// </summary> /// <param name="newItem">工程暂停令</param> /// <returns></returns> public static void SavePauseNotice(Model.PauseNoticeItem newItem) { using (Model.SUBHSSEDB db = new Model.SUBHSSEDB(Funs.ConnString)) { Model.Check_PauseNotice newPauseNotice = new Model.Check_PauseNotice { PauseNoticeId = newItem.PauseNoticeId, PauseNoticeCode = newItem.PauseNoticeCode, ProjectId = newItem.ProjectId, UnitId = newItem.UnitId, ProjectPlace = newItem.ProjectPlace, WrongContent = newItem.WrongContent, PauseTime = Funs.GetNewDateTime(newItem.PauseTime), PauseContent = newItem.PauseContent, OneContent = newItem.OneContent, SecondContent = newItem.SecondContent, ThirdContent = newItem.ThirdContent, States = Const.State_0, PauseStates = newItem.PauseStates, }; var getUpdate = db.Check_PauseNotice.FirstOrDefault(x => x.PauseNoticeId == newItem.PauseNoticeId); if (getUpdate == null) { newPauseNotice.CompileDate = DateTime.Now; newPauseNotice.PauseNoticeId = SQLHelper.GetNewID(); newPauseNotice.PauseNoticeCode = CodeRecordsService.ReturnCodeByMenuIdProjectId(Const.ProjectPauseNoticeMenuId, newPauseNotice.ProjectId, newPauseNotice.UnitId); db.Check_PauseNotice.InsertOnSubmit(newPauseNotice); db.SubmitChanges(); CodeRecordsService.InsertCodeRecordsByMenuIdProjectIdUnitId(Const.ProjectPauseNoticeMenuId, newPauseNotice.ProjectId, newPauseNotice.UnitId, newPauseNotice.PauseNoticeId, newPauseNotice.CompileDate); //// 回写巡检记录表 if (!string.IsNullOrEmpty(newItem.HazardRegisterId)) { List <string> listIds = Funs.GetStrListByStr(newItem.HazardRegisterId, ','); foreach (var item in listIds) { var getHazardRegister = Funs.DB.HSSE_Hazard_HazardRegister.FirstOrDefault(x => x.HazardRegisterId == item); if (getHazardRegister != null) { getHazardRegister.States = "3"; getHazardRegister.HandleIdea += "已下发工程暂停令:" + newPauseNotice.PauseNoticeCode; getHazardRegister.ResultId = newPauseNotice.PauseNoticeId; getHazardRegister.ResultType = "3"; Funs.SubmitChanges(); } } } //// 回写专项检查明细表 if (!string.IsNullOrEmpty(newItem.CheckSpecialDetailId)) { List <string> listIds = Funs.GetStrListByStr(newItem.CheckSpecialDetailId, ','); foreach (var item in listIds) { var getCheckSpecialDetail = db.Check_CheckSpecialDetail.FirstOrDefault(x => x.CheckSpecialDetailId == item); if (getCheckSpecialDetail != null) { getCheckSpecialDetail.DataType = "3"; getCheckSpecialDetail.DataId = newPauseNotice.PauseNoticeId; db.SubmitChanges(); } } } } else { newPauseNotice.PauseNoticeId = getUpdate.PauseNoticeId; getUpdate.PauseStates = newItem.PauseStates; if (newPauseNotice.PauseStates == "0" || newPauseNotice.PauseStates == "1") ////编制人 修改或提交 { getUpdate.UnitId = newPauseNotice.UnitId; getUpdate.ProjectPlace = newPauseNotice.ProjectPlace; getUpdate.WrongContent = newPauseNotice.WrongContent; getUpdate.PauseTime = newPauseNotice.PauseTime; getUpdate.PauseContent = newPauseNotice.PauseContent; getUpdate.OneContent = newPauseNotice.OneContent; getUpdate.SecondContent = newPauseNotice.SecondContent; getUpdate.ThirdContent = newPauseNotice.ThirdContent; if (newPauseNotice.PauseStates == "1" && !string.IsNullOrEmpty(newItem.SignManId)) { getUpdate.SignManId = newItem.SignManId; } else { newPauseNotice.PauseStates = getUpdate.PauseStates = "0"; } } else if (newPauseNotice.PauseStates == "2") ////【签发】总包安全经理 { /// 不同意 打回 同意抄送专业工程师、施工经理、相关施工分包单位并提交【批准】总包项目经理 if (newItem.IsAgree == false) { newPauseNotice.PauseStates = getUpdate.PauseStates = "0"; } else { if (!string.IsNullOrEmpty(newItem.ProfessionalEngineerId)) { getUpdate.ProfessionalEngineerId = newItem.ProfessionalEngineerId; } if (!string.IsNullOrEmpty(newItem.ConstructionManagerId)) { getUpdate.ConstructionManagerId = newItem.ConstructionManagerId; } if (!string.IsNullOrEmpty(newItem.UnitHeadManId)) { getUpdate.UnitHeadManId = newItem.UnitHeadManId; } if (!string.IsNullOrEmpty(newItem.SupervisorManId)) { getUpdate.SupervisorManId = newItem.SupervisorManId; } if (!string.IsNullOrEmpty(newItem.OwnerId)) { getUpdate.OwnerId = newItem.OwnerId; } if (!string.IsNullOrEmpty(newItem.ApproveManId)) { getUpdate.ApproveManId = newItem.ApproveManId; getUpdate.SignDate = DateTime.Now; } else { newPauseNotice.PauseStates = getUpdate.States = "1"; } } } else if (newPauseNotice.PauseStates == "3") ////【批准】总包项目经理 { /// 不同意 打回 同意下发【回执】施工分包单位 if (newItem.IsAgree == false || string.IsNullOrEmpty(newItem.DutyPersonId)) { newPauseNotice.PauseStates = getUpdate.PauseStates = "1"; } else { getUpdate.DutyPersonId = newItem.DutyPersonId; getUpdate.ApproveDate = DateTime.Now; getUpdate.IsConfirm = true; } } else if (newPauseNotice.PauseStates == "4") ////【批准】总包项目经理 { getUpdate.DutyPersonDate = DateTime.Now; getUpdate.States = Const.State_2; } db.SubmitChanges(); } if (newItem.PauseStates == Const.State_0 || newItem.PauseStates == Const.State_1) { //// 通知单附件 UploadFileService.SaveAttachUrl(UploadFileService.GetSourceByAttachUrl(newItem.PauseNoticeAttachUrl, 10, null), newItem.PauseNoticeAttachUrl, Const.ProjectPauseNoticeMenuId, newPauseNotice.PauseNoticeId); } if (getUpdate != null && getUpdate.States == Const.State_2) { CommonService.btnSaveData(newPauseNotice.ProjectId, Const.ProjectPauseNoticeMenuId, newPauseNotice.PauseNoticeId, newPauseNotice.CompileManId, true, newPauseNotice.PauseContent, "../Check/PauseNoticeView.aspx?PauseNoticeId={0}"); var getcheck = from x in db.Check_CheckSpecialDetail where x.DataId == getUpdate.PauseNoticeId select x; if (getcheck.Count() > 0) { foreach (var item in getcheck) { item.CompleteStatus = true; item.CompletedDate = DateTime.Now; db.SubmitChanges(); } } } } }
/// <summary> /// 保存RectifyNotices /// </summary> /// <param name="userInfo"></param> /// <returns></returns> public static void SaveRectifyNotices(Model.RectifyNoticesItem rectifyNotices) { using (Model.SUBHSSEDB db = new Model.SUBHSSEDB(Funs.ConnString)) { bool insertRectifyNoticesItemItem = false; Model.Check_RectifyNotices newRectifyNotices = new Model.Check_RectifyNotices { RectifyNoticesId = rectifyNotices.RectifyNoticesId, ProjectId = rectifyNotices.ProjectId, RectifyNoticesCode = rectifyNotices.RectifyNoticesCode, UnitId = rectifyNotices.UnitId, CheckManNames = rectifyNotices.CheckManNames, CheckManIds = rectifyNotices.CheckManIds, CheckedDate = Funs.GetNewDateTime(rectifyNotices.CheckedDate), HiddenHazardType = rectifyNotices.HiddenHazardType, States = rectifyNotices.States, }; if (!string.IsNullOrEmpty(rectifyNotices.WorkAreaId)) { newRectifyNotices.WorkAreaId = rectifyNotices.WorkAreaId; } if (!string.IsNullOrEmpty(rectifyNotices.CompleteManId)) { newRectifyNotices.CompleteManId = rectifyNotices.CompleteManId; } if (newRectifyNotices.States == Const.State_1) { newRectifyNotices.SignPerson = rectifyNotices.SignPersonId; } //// 新增整改单 var isUpdate = db.Check_RectifyNotices.FirstOrDefault(x => x.RectifyNoticesId == newRectifyNotices.RectifyNoticesId); if (isUpdate == null) { newRectifyNotices.RectifyNoticesId = SQLHelper.GetNewID(); newRectifyNotices.Isprint = "0"; newRectifyNotices.Isprintf = "0"; newRectifyNotices.RectifyNoticesCode = CodeRecordsService.ReturnCodeByMenuIdProjectId(Const.ProjectRectifyNoticesMenuId, newRectifyNotices.ProjectId, newRectifyNotices.UnitId); db.Check_RectifyNotices.InsertOnSubmit(newRectifyNotices); db.SubmitChanges(); CodeRecordsService.InsertCodeRecordsByMenuIdProjectIdUnitId(Const.ProjectRectifyNoticesMenuId, newRectifyNotices.ProjectId, newRectifyNotices.UnitId, newRectifyNotices.RectifyNoticesId, newRectifyNotices.CheckedDate); //// 整改单附件 if (!string.IsNullOrEmpty(rectifyNotices.BeAttachUrl)) { APIUpLoadFileService.SaveAttachUrl(Const.ProjectRectifyNoticesMenuId, newRectifyNotices.RectifyNoticesId + "#0", rectifyNotices.BeAttachUrl, "0"); } //// 反馈单附件 if (!string.IsNullOrEmpty(rectifyNotices.AfAttachUrl)) { APIUpLoadFileService.SaveAttachUrl(Const.ProjectRectifyNoticesMenuId, newRectifyNotices.RectifyNoticesId + "#1", rectifyNotices.AfAttachUrl, "0"); } //// 整个单据附件 if (!string.IsNullOrEmpty(rectifyNotices.AttachUrl)) { APIUpLoadFileService.SaveAttachUrl(Const.ProjectRectifyNoticesMenuId, newRectifyNotices.RectifyNoticesId, rectifyNotices.AttachUrl, "0"); } insertRectifyNoticesItemItem = true; //// 回写巡检记录表 if (!string.IsNullOrEmpty(rectifyNotices.HazardRegisterId)) { List <string> listIds = Funs.GetStrListByStr(rectifyNotices.HazardRegisterId, ','); foreach (var item in listIds) { var getHazardRegister = db.HSSE_Hazard_HazardRegister.FirstOrDefault(x => x.HazardRegisterId == item); if (getHazardRegister != null) { getHazardRegister.States = "3"; getHazardRegister.HandleIdea += "已升级为隐患整改单:" + newRectifyNotices.RectifyNoticesCode; getHazardRegister.ResultId = newRectifyNotices.RectifyNoticesId; getHazardRegister.ResultType = "1"; db.SubmitChanges(); } } } //// 回写专项检查明细表 if (!string.IsNullOrEmpty(rectifyNotices.CheckSpecialDetailId)) { List <string> listIds = Funs.GetStrListByStr(rectifyNotices.CheckSpecialDetailId, ','); foreach (var item in listIds) { var getCheckSpecialDetail = db.Check_CheckSpecialDetail.FirstOrDefault(x => x.CheckSpecialDetailId == item); if (getCheckSpecialDetail != null) { getCheckSpecialDetail.DataType = "1"; getCheckSpecialDetail.DataId = newRectifyNotices.RectifyNoticesId; db.SubmitChanges(); } } } } else { newRectifyNotices.RectifyNoticesId = isUpdate.RectifyNoticesId; isUpdate.States = rectifyNotices.States; if (newRectifyNotices.States == "0" || newRectifyNotices.States == "1") ////编制人 修改或提交 { isUpdate.UnitId = rectifyNotices.UnitId; isUpdate.WorkAreaId = rectifyNotices.WorkAreaId; isUpdate.CheckManNames = rectifyNotices.CheckManNames; isUpdate.CheckManIds = rectifyNotices.CheckManIds; isUpdate.CheckedDate = Funs.GetNewDateTime(rectifyNotices.CheckedDate); isUpdate.HiddenHazardType = rectifyNotices.HiddenHazardType; if (newRectifyNotices.States == "1" && !string.IsNullOrEmpty(rectifyNotices.SignPersonId)) { isUpdate.SignPerson = rectifyNotices.SignPersonId; } else { newRectifyNotices.States = isUpdate.States = "0"; } db.SubmitChanges(); //// 删除明细表 var deleteItem = from x in db.Check_RectifyNoticesItem where x.RectifyNoticesId == isUpdate.RectifyNoticesId select x; if (deleteItem.Count() > 0) { foreach (var cdeleteItem in deleteItem) { CommonService.DeleteAttachFileById(cdeleteItem.RectifyNoticesItemId); } db.Check_RectifyNoticesItem.DeleteAllOnSubmit(deleteItem); } insertRectifyNoticesItemItem = true; } else if (newRectifyNotices.States == "2") ////总包单位项目安全经理 审核 { /// 不同意 打回 同意抄送专业工程师、施工经理、项目经理 并下发分包接收人(也就是施工单位项目安全经理) if (rectifyNotices.IsAgree == false) { newRectifyNotices.States = isUpdate.States = "0"; } else { if (!string.IsNullOrEmpty(rectifyNotices.ProfessionalEngineerId)) { isUpdate.ProfessionalEngineerId = rectifyNotices.ProfessionalEngineerId; } if (!string.IsNullOrEmpty(rectifyNotices.ConstructionManagerId)) { isUpdate.ConstructionManagerId = rectifyNotices.ConstructionManagerId; } if (!string.IsNullOrEmpty(rectifyNotices.ProjectManagerId)) { isUpdate.ProjectManagerId = rectifyNotices.ProjectManagerId; } if (!string.IsNullOrEmpty(rectifyNotices.DutyPersonId)) { isUpdate.DutyPersonId = rectifyNotices.DutyPersonId; isUpdate.SignDate = DateTime.Now; } else { newRectifyNotices.States = isUpdate.States = "1"; } } db.SubmitChanges(); } else if (newRectifyNotices.States == "3") /// 施工单位项目安全经理 整改 提交施工单位项目负责人 { //// 整改明细反馈 if (rectifyNotices.RectifyNoticesItemItem != null && rectifyNotices.RectifyNoticesItemItem.Count() > 0) { foreach (var rItem in rectifyNotices.RectifyNoticesItemItem) { var getUpdateItem = db.Check_RectifyNoticesItem.FirstOrDefault(x => x.RectifyNoticesItemId == rItem.RectifyNoticesItemId); if (getUpdateItem != null) { getUpdateItem.RectifyResults = rItem.RectifyResults; if (getUpdateItem.IsRectify != true) { getUpdateItem.IsRectify = null; } db.SubmitChanges(); } if (!string.IsNullOrEmpty(rItem.PhotoAfterUrl)) { APIUpLoadFileService.SaveAttachUrl(Const.ProjectRectifyNoticesMenuId, rItem.RectifyNoticesItemId + "#2", rItem.PhotoAfterUrl, "0"); } } } if (!string.IsNullOrEmpty(rectifyNotices.UnitHeadManId)) { isUpdate.UnitHeadManId = rectifyNotices.UnitHeadManId; isUpdate.CompleteDate = DateTime.Now; } else { newRectifyNotices.States = isUpdate.States = "2"; } db.SubmitChanges(); } else if (newRectifyNotices.States == "4") { /// 施工单位项目负责人不同意 打回施工单位项目安全经理,同意提交安全经理/安全工程师复查 if (rectifyNotices.IsAgree == false) { newRectifyNotices.States = isUpdate.States = "2"; isUpdate.CompleteDate = null; } else { if (!string.IsNullOrEmpty(rectifyNotices.CheckPersonId)) { isUpdate.UnitHeadManDate = DateTime.Now; isUpdate.CheckPerson = rectifyNotices.CheckPersonId; } else { newRectifyNotices.States = isUpdate.States = "3"; } } db.SubmitChanges(); } else if (newRectifyNotices.States == "5") { //// 整改明细反馈 复查 是否合格 if (rectifyNotices.RectifyNoticesItemItem != null && rectifyNotices.RectifyNoticesItemItem.Count() > 0) { foreach (var rItem in rectifyNotices.RectifyNoticesItemItem) { var getUpdateItem = db.Check_RectifyNoticesItem.FirstOrDefault(x => x.RectifyNoticesItemId == rItem.RectifyNoticesItemId); if (getUpdateItem != null) { getUpdateItem.IsRectify = rItem.IsRectify; db.SubmitChanges(); //// 存在不合格 意见自动不同意 if (!getUpdateItem.IsRectify.HasValue || getUpdateItem.IsRectify == false) { rectifyNotices.IsAgree = false; } } } } ////安全经理/安全工程师 同意关闭,不同意打回施工单位项目安全经理 isUpdate.ReCheckOpinion = rectifyNotices.ReCheckOpinion; if (rectifyNotices.IsAgree == false) { newRectifyNotices.States = isUpdate.States = "2"; isUpdate.UnitHeadManDate = null; isUpdate.CompleteDate = null; isUpdate.ProfessionalEngineerTime2 = null; isUpdate.ConstructionManagerTime2 = null; isUpdate.ProjectManagerTime2 = null; } else { isUpdate.ReCheckDate = DateTime.Now; //// 回写专项检查明细表 var getcheck = from x in db.Check_CheckSpecialDetail where x.DataId == isUpdate.RectifyNoticesId select x; if (getcheck.Count() > 0) { foreach (var item in getcheck) { item.CompleteStatus = true; item.CompletedDate = DateTime.Now; db.SubmitChanges(); } } } db.SubmitChanges(); } } if (insertRectifyNoticesItemItem) { //// 新增明细 if (rectifyNotices.RectifyNoticesItemItem != null && rectifyNotices.RectifyNoticesItemItem.Count() > 0) { foreach (var rItem in rectifyNotices.RectifyNoticesItemItem) { Model.Check_RectifyNoticesItem newItem = new Model.Check_RectifyNoticesItem { RectifyNoticesItemId = SQLHelper.GetNewID(), RectifyNoticesId = newRectifyNotices.RectifyNoticesId, WrongContent = rItem.WrongContent, Requirement = rItem.Requirement, LimitTime = Funs.GetNewDateTime(rItem.LimitTime), RectifyResults = null, IsRectify = null, }; db.Check_RectifyNoticesItem.InsertOnSubmit(newItem); db.SubmitChanges(); if (!string.IsNullOrEmpty(rItem.PhotoBeforeUrl)) { APIUpLoadFileService.SaveAttachUrl(Const.ProjectRectifyNoticesMenuId, newItem.RectifyNoticesItemId + "#1", rItem.PhotoBeforeUrl, "0"); } } } } //// 增加审核记录 if (rectifyNotices.RectifyNoticesFlowOperateItem != null && rectifyNotices.RectifyNoticesFlowOperateItem.Count() > 0) { var getOperate = rectifyNotices.RectifyNoticesFlowOperateItem.FirstOrDefault(); if (getOperate != null && !string.IsNullOrEmpty(getOperate.OperateManId)) { Model.Check_RectifyNoticesFlowOperate newOItem = new Model.Check_RectifyNoticesFlowOperate { FlowOperateId = SQLHelper.GetNewID(), RectifyNoticesId = newRectifyNotices.RectifyNoticesId, OperateName = getOperate.OperateName, OperateManId = getOperate.OperateManId, OperateTime = DateTime.Now, IsAgree = getOperate.IsAgree, Opinion = getOperate.Opinion, }; db.Check_RectifyNoticesFlowOperate.InsertOnSubmit(newOItem); db.SubmitChanges(); } } if (newRectifyNotices.States == Const.State_1) { APICommonService.SendSubscribeMessage(newRectifyNotices.SignPerson, "隐患整改单" + newRectifyNotices.RectifyNoticesCode + "待您签发", rectifyNotices.CheckManNames, string.Format("{0:yyyy-MM-dd HH:mm:ss}", DateTime.Now)); } else if (newRectifyNotices.States == Const.State_2) { APICommonService.SendSubscribeMessage(newRectifyNotices.DutyPersonId, "隐患整改单" + newRectifyNotices.RectifyNoticesCode + "待您整改", rectifyNotices.SignPersonName, string.Format("{0:yyyy-MM-dd HH:mm:ss}", DateTime.Now)); } else if (newRectifyNotices.States == Const.State_3) { APICommonService.SendSubscribeMessage(newRectifyNotices.UnitHeadManId, "隐患整改单" + newRectifyNotices.RectifyNoticesCode + "待您审核", rectifyNotices.DutyPersonName, string.Format("{0:yyyy-MM-dd HH:mm:ss}", DateTime.Now)); } else if (newRectifyNotices.States == Const.State_4) { APICommonService.SendSubscribeMessage(newRectifyNotices.CheckPerson, "隐患整改单" + newRectifyNotices.RectifyNoticesCode + "待您复查", rectifyNotices.UnitHeadManName, string.Format("{0:yyyy-MM-dd HH:mm:ss}", DateTime.Now)); } } }
/// <summary> /// 保存emergencyInfo /// </summary> /// <param name="emergencyInfo">会议信息</param> /// <returns></returns> public static void SaveEmergency(Model.FileInfoItem emergencyInfo) { using (Model.SUBHSSEDB db = new Model.SUBHSSEDB(Funs.ConnString)) { string menuId = string.Empty; if (emergencyInfo.MenuType == "1") { Model.Emergency_EmergencyList newEmergency = new Model.Emergency_EmergencyList { EmergencyListId = emergencyInfo.FileId, ProjectId = emergencyInfo.ProjectId, UnitId = emergencyInfo.UnitId == "" ? null : emergencyInfo.UnitId, EmergencyTypeId = emergencyInfo.FileType == "" ? null : emergencyInfo.FileType, EmergencyCode = emergencyInfo.FileCode, EmergencyName = emergencyInfo.FileName, EmergencyContents = emergencyInfo.FileContent, CompileMan = emergencyInfo.CompileManId, CompileDate = Funs.GetNewDateTime(emergencyInfo.CompileDate), States = Const.State_2, }; if (!string.IsNullOrEmpty(emergencyInfo.AuditManId)) { newEmergency.AuditMan = emergencyInfo.AuditManId; } if (!string.IsNullOrEmpty(emergencyInfo.ApproveManId)) { newEmergency.ApproveMan = emergencyInfo.ApproveManId; } if (emergencyInfo.States != Const.State_1) { newEmergency.States = Const.State_0; } var updateEmergency = db.Emergency_EmergencyList.FirstOrDefault(x => x.EmergencyListId == emergencyInfo.FileId); if (updateEmergency == null) { newEmergency.CompileDate = DateTime.Now; emergencyInfo.FileId = newEmergency.EmergencyListId = SQLHelper.GetNewID(); newEmergency.EmergencyCode = CodeRecordsService.ReturnCodeByMenuIdProjectId(Const.ProjectClassMeetingMenuId, newEmergency.ProjectId, null); db.Emergency_EmergencyList.InsertOnSubmit(newEmergency); db.SubmitChanges(); ////增加一条编码记录 CodeRecordsService.InsertCodeRecordsByMenuIdProjectIdUnitId(Const.ProjectEmergencyListMenuId, newEmergency.ProjectId, null, newEmergency.EmergencyListId, newEmergency.CompileDate); } else { updateEmergency.EmergencyName = newEmergency.EmergencyName; updateEmergency.UnitId = newEmergency.UnitId; updateEmergency.EmergencyTypeId = newEmergency.EmergencyTypeId; updateEmergency.EmergencyContents = newEmergency.EmergencyContents; updateEmergency.AuditMan = newEmergency.AuditMan; updateEmergency.ApproveMan = newEmergency.ApproveMan; db.SubmitChanges(); } if (emergencyInfo.States == Const.State_1) { CommonService.btnSaveData(newEmergency.ProjectId, Const.ProjectEmergencyListMenuId, newEmergency.EmergencyListId, newEmergency.CompileMan, true, newEmergency.EmergencyName, "../Emergency/EmergencyListView.aspx?EmergencyListId={0}"); } menuId = Const.ProjectEmergencyListMenuId; } else if (emergencyInfo.MenuType == "2") { Model.Emergency_EmergencySupply newEmergency = new Model.Emergency_EmergencySupply { FileId = emergencyInfo.FileId, ProjectId = emergencyInfo.ProjectId, UnitId = emergencyInfo.UnitId == "" ? null : emergencyInfo.UnitId, FileCode = emergencyInfo.FileCode, FileName = emergencyInfo.FileName, FileContent = emergencyInfo.FileContent, CompileMan = emergencyInfo.CompileManId, CompileDate = Funs.GetNewDateTime(emergencyInfo.CompileDate), States = Const.State_2, }; if (emergencyInfo.States != Const.State_1) { newEmergency.States = Const.State_0; } var updateEmergency = db.Emergency_EmergencySupply.FirstOrDefault(x => x.FileId == emergencyInfo.FileId); if (updateEmergency == null) { newEmergency.CompileDate = DateTime.Now; emergencyInfo.FileId = newEmergency.FileId = SQLHelper.GetNewID(); newEmergency.FileCode = CodeRecordsService.ReturnCodeByMenuIdProjectId(Const.ProjectEmergencySupplyMenuId, newEmergency.ProjectId, null); db.Emergency_EmergencySupply.InsertOnSubmit(newEmergency); } else { updateEmergency.UnitId = newEmergency.UnitId; updateEmergency.FileCode = newEmergency.FileCode; updateEmergency.FileName = newEmergency.FileName; updateEmergency.FileContent = newEmergency.FileContent; db.SubmitChanges(); } if (emergencyInfo.States == Const.State_1) { CommonService.btnSaveData(newEmergency.ProjectId, Const.ProjectEmergencySupplyMenuId, newEmergency.FileId, newEmergency.CompileMan, true, newEmergency.FileName, "../Emergency/EmergencySupplyView.aspx?FileId={0}"); } menuId = Const.ProjectEmergencySupplyMenuId; } else if (emergencyInfo.MenuType == "3") { Model.Emergency_EmergencyTeamAndTrain newEmergency = new Model.Emergency_EmergencyTeamAndTrain { FileId = emergencyInfo.FileId, ProjectId = emergencyInfo.ProjectId, UnitId = emergencyInfo.UnitId == "" ? null : emergencyInfo.UnitId, FileCode = emergencyInfo.FileCode, FileName = emergencyInfo.FileName, FileContent = emergencyInfo.FileContent, CompileMan = emergencyInfo.CompileManId, CompileDate = Funs.GetNewDateTime(emergencyInfo.CompileDate), States = Const.State_2, }; if (emergencyInfo.States != Const.State_1) { newEmergency.States = Const.State_0; } var updateEmergency = db.Emergency_EmergencyTeamAndTrain.FirstOrDefault(x => x.FileId == emergencyInfo.FileId); if (updateEmergency == null) { newEmergency.CompileDate = DateTime.Now; emergencyInfo.FileId = newEmergency.FileId = SQLHelper.GetNewID(); newEmergency.FileCode = CodeRecordsService.ReturnCodeByMenuIdProjectId(Const.ProjectEmergencyTeamAndTrainMenuId, newEmergency.ProjectId, null); db.Emergency_EmergencyTeamAndTrain.InsertOnSubmit(newEmergency); } else { updateEmergency.UnitId = newEmergency.UnitId; updateEmergency.FileCode = newEmergency.FileCode; updateEmergency.FileName = newEmergency.FileName; updateEmergency.FileContent = newEmergency.FileContent; db.SubmitChanges(); var delItem = from x in db.Emergency_EmergencyTeamItem where x.FileId == updateEmergency.FileId select x; if (delItem.Count() > 0) { db.Emergency_EmergencyTeamItem.DeleteAllOnSubmit(delItem); db.SubmitChanges(); } } if (emergencyInfo.EmergencyTeamItem != null && emergencyInfo.EmergencyTeamItem.Count() > 0) { var getItems = from x in emergencyInfo.EmergencyTeamItem select new Model.Emergency_EmergencyTeamItem { EmergencyTeamItemId = x.EmergencyTeamItemId, FileId = x.FileId, PersonId = x.PersonId, Job = x.Job, Tel = x.Tel, }; if (getItems.Count() > 0) { Funs.DB.Emergency_EmergencyTeamItem.InsertAllOnSubmit(getItems); Funs.DB.SubmitChanges(); } } if (emergencyInfo.States == Const.State_1) { CommonService.btnSaveData(newEmergency.ProjectId, Const.ProjectEmergencyTeamAndTrainMenuId, newEmergency.FileId, newEmergency.CompileMan, true, newEmergency.FileName, "../Emergency/EmergencyTeamAndTrainView.aspx?FileId={0}"); } menuId = Const.ProjectEmergencyTeamAndTrainMenuId; } else { } ///// 附件保存 if (!string.IsNullOrEmpty(menuId) && !string.IsNullOrEmpty(emergencyInfo.FileId)) { APIUpLoadFileService.SaveAttachUrl(menuId, emergencyInfo.FileId, emergencyInfo.AttachUrl, "0"); } } }
/// <summary> /// 根据安全工作总结Id获取安全工作总结信息 /// </summary> /// <param name="ManagerTotalId"></param> /// <returns></returns> public static List <Model.SpManagerTotalMonthItem> GetManager_ManagerTotalMonthItem(string date) { DateTime?monthTime = Funs.GetNewDateTime(date); var managerTotalList = BLL.ManagerTotalMonthService.GetManagerTotalByDate(monthTime.Value); var projectList = BLL.ProjectService.GetTotalMonthProjectWorkList(monthTime); List <Model.SpManagerTotalMonthItem> reportItemPartList = new List <Model.SpManagerTotalMonthItem>(); int projectCount = projectList.Count(); int rows = 1; int sortIndex = 1; foreach (var projectItem in projectList) { var managerTotalProject = managerTotalList.FirstOrDefault(x => x.ProjectId == projectItem.ProjectId); if (managerTotalProject != null) { var managerTotalItems = from x in Funs.DB.Manager_ManagerTotalMonthItem where x.ManagerTotalMonthId == managerTotalProject.ManagerTotalMonthId select x; if (managerTotalItems.Count() > 0) { foreach (var item in managerTotalItems) { Model.SpManagerTotalMonthItem part = new Model.SpManagerTotalMonthItem { ID = SQLHelper.GetNewID(typeof(Model.Manager_ManagerTotalMonthItem)), ProjectName = projectItem.ProjectName, ExistenceHiddenDanger = item.ExistenceHiddenDanger, CorrectiveActions = item.CorrectiveActions, PlanCompletedDate = string.Format("{0:yyyy-MM-dd}", item.PlanCompletedDate), ResponsiMan = item.ResponsiMan, ActualCompledDate = string.Format("{0:yyyy-MM-dd}", item.ActualCompledDate), Remark = item.Remark, SortIndex = sortIndex }; reportItemPartList.Add(part); sortIndex++; } } else { Model.SpManagerTotalMonthItem part = new Model.SpManagerTotalMonthItem { ID = SQLHelper.GetNewID(typeof(Model.Manager_ManagerTotalMonthItem)), ProjectName = projectItem.ProjectName, ExistenceHiddenDanger = "/", CorrectiveActions = "/", PlanCompletedDate = null, ResponsiMan = "/", ActualCompledDate = null, Remark = "/", SortIndex = sortIndex }; reportItemPartList.Add(part); sortIndex++; } } else { Model.SpManagerTotalMonthItem part = new Model.SpManagerTotalMonthItem { ID = SQLHelper.GetNewID(typeof(Model.Manager_ManagerTotalMonthItem)), ProjectName = projectItem.ProjectName, ExistenceHiddenDanger = "/", CorrectiveActions = "/", PlanCompletedDate = "/", ResponsiMan = "/", ActualCompledDate = "/", Remark = "/", SortIndex = sortIndex }; reportItemPartList.Add(part); sortIndex++; } if (projectCount > rows) { Model.SpManagerTotalMonthItem partNull = new Model.SpManagerTotalMonthItem { ID = SQLHelper.GetNewID(typeof(Model.Manager_ManagerTotalMonthItem)), ProjectName = "项目名称", ExistenceHiddenDanger = "存在隐患", CorrectiveActions = "整改措施", PlanCompletedDate = "计划完成时间", ResponsiMan = "责任人", ActualCompledDate = "实际完成时间", Remark = "备注", SortIndex = sortIndex }; reportItemPartList.Add(partNull); sortIndex++; } rows++; } return(reportItemPartList); }
/// <summary> /// 插入试卷 4 /// </summary> /// <param name="projectId"></param> /// <param name="arr"></param> public static bool AddEduTrain_TrainTest(string projectId, JArray arr, Model.Sys_User user) { Model.SUBHSSEDB db = Funs.DB; bool isOk = true; try { foreach (var item in arr) { string trainingId = null; ////培训记录ID var getTrainRecord = db.EduTrain_TrainRecord.FirstOrDefault(x => x.FromRecordId == item["RecordId"].ToString()); if (getTrainRecord != null) { trainingId = getTrainRecord.TrainingId; } string trainTestId = item["ID"].ToString(); if (!string.IsNullOrEmpty(trainingId) && !string.IsNullOrEmpty(trainTestId)) { Model.EduTrain_TrainTest newTrainTest = new Model.EduTrain_TrainTest { TrainTestId = trainTestId, TrainingId = trainingId, ExamNo = item["ExamNo"].ToString(), GroupNo = item["GroupNo"].ToString(), CourseID = item["CourseID"].ToString(), COrder = Funs.GetNewInt(item["COrder"].ToString()), QsnCode = item["QsnCode"].ToString(), QsnId = item["QsnId"].ToString(), QsnContent = item["QsnContent"].ToString(), QsnFileName = item["QsnFileName"].ToString(), QsnAnswer = item["QsnAnswer"].ToString(), QsnCategory = item["QsnCategory"].ToString(), QsnKind = item["QsnKind"].ToString(), Description = item["Description"].ToString(), QsnImportant = item["QsnImportant"].ToString(), Analysis = item["Analysis"].ToString(), UploadTime = Funs.GetNewDateTime(item["UploadTime"].ToString()), }; var getTrainRecordDetail = db.EduTrain_TrainTest.FirstOrDefault(x => x.TrainTestId == trainTestId); if (getTrainRecordDetail == null) { EduTrain_TrainTestService.AddTrainTest(newTrainTest); } else { newTrainTest.ExamNo = newTrainTest.ExamNo; newTrainTest.GroupNo = newTrainTest.GroupNo; newTrainTest.CourseID = newTrainTest.CourseID; newTrainTest.COrder = newTrainTest.COrder; newTrainTest.QsnCode = newTrainTest.QsnCode; newTrainTest.QsnId = newTrainTest.QsnId; newTrainTest.QsnContent = newTrainTest.QsnContent; newTrainTest.QsnFileName = newTrainTest.QsnFileName; newTrainTest.QsnAnswer = newTrainTest.QsnAnswer; newTrainTest.QsnCategory = newTrainTest.QsnCategory; newTrainTest.QsnKind = newTrainTest.QsnKind; newTrainTest.Description = newTrainTest.Description; newTrainTest.QsnImportant = newTrainTest.QsnImportant; newTrainTest.Analysis = newTrainTest.Analysis; newTrainTest.UploadTime = newTrainTest.UploadTime; db.SubmitChanges(); } } else { isOk = false; } } } catch (Exception ex) { isOk = false; ErrLogInfo.WriteLog(string.Empty, ex); } return(isOk); }
/// <summary> /// 保存专项检查明细项 /// </summary> /// <param name="newDetail"></param> public static void SaveCheckSpecialDetail(Model.CheckSpecialDetailItem newDetail) { if (!string.IsNullOrEmpty(newDetail.CheckSpecialId)) { Model.Check_CheckSpecialDetail newCheckSpecialDetail = new Model.Check_CheckSpecialDetail { CheckSpecialId = newDetail.CheckSpecialId, CheckItem = newDetail.CheckItemSetId, CheckItemType = newDetail.CheckItemSetName, Unqualified = newDetail.Unqualified, UnitId = newDetail.UnitId, HandleStep = newDetail.HandleStep, CompleteStatus = newDetail.CompleteStatus, RectifyNoticeId = newDetail.RectifyNoticeId, LimitedDate = Funs.GetNewDateTime(newDetail.LimitedDate), CompletedDate = Funs.GetNewDateTime(newDetail.CompletedDate), Suggestions = newDetail.Suggestions, WorkArea = newDetail.WorkArea, CheckArea = newDetail.WorkAreaId, CheckContent = newDetail.CheckContent, }; var getUnit = UnitService.GetUnitByUnitId(newDetail.UnitId); if (getUnit != null) { newCheckSpecialDetail.UnitId = newDetail.UnitId; } var updateDetail = Funs.DB.Check_CheckSpecialDetail.FirstOrDefault(x => x.CheckSpecialDetailId == newDetail.CheckSpecialDetailId); if (updateDetail == null) { newCheckSpecialDetail.CheckSpecialDetailId = SQLHelper.GetNewID(); Funs.DB.Check_CheckSpecialDetail.InsertOnSubmit(newCheckSpecialDetail); Funs.DB.SubmitChanges(); } else { newCheckSpecialDetail.CheckSpecialDetailId = updateDetail.CheckSpecialDetailId; updateDetail.CheckItem = newCheckSpecialDetail.CheckItem; updateDetail.CheckItemType = newCheckSpecialDetail.CheckItemType; updateDetail.Unqualified = newCheckSpecialDetail.Unqualified; updateDetail.UnitId = newCheckSpecialDetail.UnitId; updateDetail.HandleStep = newCheckSpecialDetail.HandleStep; updateDetail.CompleteStatus = newCheckSpecialDetail.CompleteStatus; updateDetail.RectifyNoticeId = newCheckSpecialDetail.RectifyNoticeId; updateDetail.LimitedDate = newCheckSpecialDetail.LimitedDate; updateDetail.CompletedDate = newCheckSpecialDetail.CompletedDate; updateDetail.Suggestions = newCheckSpecialDetail.Suggestions; updateDetail.WorkArea = newCheckSpecialDetail.WorkArea; updateDetail.CheckContent = newCheckSpecialDetail.CheckContent; Funs.DB.SubmitChanges(); } ////保存附件 if (!string.IsNullOrEmpty(newDetail.AttachUrl1)) { UploadFileService.SaveAttachUrl(UploadFileService.GetSourceByAttachUrl(newDetail.AttachUrl1, 10, null), newDetail.AttachUrl1, Const.ProjectCheckSpecialMenuId, newCheckSpecialDetail.CheckSpecialDetailId); } else { CommonService.DeleteAttachFileById(Const.ProjectCheckSpecialMenuId, newCheckSpecialDetail.CheckSpecialDetailId); } } }
/// <summary> /// 插入人员培训记录 5 /// </summary> /// <param name="projectId"></param> /// <param name="arr"></param> public static bool AddPersonTrainRecord(string projectId, JArray arr, Model.Sys_User user) { Model.SUBHSSEDB db = Funs.DB; bool isOk = true; try { foreach (var item in arr) { string id = item["ID"].ToString(); if (!string.IsNullOrEmpty(id)) { bool isPass = false; if (item["IsPass"].ToString() == "1") { isPass = true; } Model.EduTrain_TrainPersonRecord newTrainPersonRecord = new Model.EduTrain_TrainPersonRecord { ID = id, ProjectId = projectId, EmpName = item["EmpName"].ToString(), IdentifyId = item["IdentifyId"].ToString(), CategoryName = item["CategoryName"].ToString(), RecordId = item["RecordId"].ToString(), DepartId = item["DepartId"].ToString(), DepartName = item["DepartName"].ToString(), TrainPeriod = item["TrainPeriod"].ToString(), TotalScore = item["TotalScore"].ToString(), PassScore = item["PassScore"].ToString(), Score = item["Score"].ToString(), IsPass = isPass, GroupNo = item["GroupNo"].ToString(), ExamNo = item["ExamNo"].ToString(), ExamCount = item["ExamCount"].ToString(), DeviceNo = item["DeviceNo"].ToString(), OwnerDepartId = item["OwnerDepartId"].ToString(), Answers = item["Answers"].ToString(), RecordName = item["RecordName"].ToString(), TrainType = item["TrainType"].ToString(), PaperMode = item["PaperMode"].ToString(), TrainMode = item["TrainMode"].ToString(), TrainPrincipal = item["TrainPrincipal"].ToString(), TrainStartDate = Funs.GetNewDateTime(item["TrainStartDate"].ToString()), TrainEndDate = Funs.GetNewDateTime(item["TrainEndDate"].ToString()), TrainContent = item["TrainContent"].ToString(), TrainDescript = item["TrainDescript"].ToString(), }; var getnewTrainPersonRecord = db.EduTrain_TrainPersonRecord.FirstOrDefault(x => x.ID == id); if (getnewTrainPersonRecord == null) { db.EduTrain_TrainPersonRecord.InsertOnSubmit(newTrainPersonRecord); db.SubmitChanges(); } else { db.SubmitChanges(); } } else { isOk = false; } } } catch (Exception ex) { isOk = false; ErrLogInfo.WriteLog(string.Empty, ex); } return(isOk); }
/// <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(); } } } } }
/// <summary> /// 保存Check_PunishNotice /// </summary> /// <param name="newItem">处罚通知单</param> /// <returns></returns> public static void SavePunishNotice(Model.PunishNoticeItem newItem) { using (Model.SUBHSSEDB db = new Model.SUBHSSEDB(Funs.ConnString)) { Model.Check_PunishNotice newPunishNotice = new Model.Check_PunishNotice { PunishNoticeId = newItem.PunishNoticeId, PunishNoticeCode = newItem.PunishNoticeCode, ProjectId = newItem.ProjectId, PunishNoticeDate = Funs.GetNewDateTime(newItem.PunishNoticeDate), UnitId = newItem.UnitId, ContractNum = newItem.ContractNum, IncentiveReason = newItem.IncentiveReason, BasicItem = newItem.BasicItem, PunishMoney = newItem.PunishMoney, Currency = newItem.Currency, FileContents = System.Web.HttpUtility.HtmlEncode(newItem.FileContents), States = Const.State_0, PunishStates = newItem.PunishStates, }; if (!string.IsNullOrEmpty(newItem.CompileManId)) { newPunishNotice.CompileMan = newItem.CompileManId; } if (newPunishNotice.PunishStates == Const.State_1) { newPunishNotice.SignMan = newItem.SignManId; } var getUpdate = db.Check_PunishNotice.FirstOrDefault(x => x.PunishNoticeId == newItem.PunishNoticeId); if (getUpdate == null) { newPunishNotice.CompileDate = DateTime.Now; newPunishNotice.PunishNoticeId = SQLHelper.GetNewID(); newPunishNotice.PunishNoticeCode = CodeRecordsService.ReturnCodeByMenuIdProjectId(Const.ProjectPunishNoticeMenuId, newPunishNotice.ProjectId, newPunishNotice.UnitId); db.Check_PunishNotice.InsertOnSubmit(newPunishNotice); db.SubmitChanges(); CodeRecordsService.InsertCodeRecordsByMenuIdProjectIdUnitId(Const.ProjectPunishNoticeMenuId, newPunishNotice.ProjectId, newPunishNotice.UnitId, newPunishNotice.PunishNoticeId, newPunishNotice.CompileDate); //// 回写巡检记录表 if (!string.IsNullOrEmpty(newItem.HazardRegisterId)) { List <string> listIds = Funs.GetStrListByStr(newItem.HazardRegisterId, ','); foreach (var item in listIds) { var getHazardRegister = db.HSSE_Hazard_HazardRegister.FirstOrDefault(x => x.HazardRegisterId == item); if (getHazardRegister != null) { getHazardRegister.States = "3"; getHazardRegister.HandleIdea += "已下发处罚通知单:" + newPunishNotice.PunishNoticeCode; getHazardRegister.ResultId = newPunishNotice.PunishNoticeId; getHazardRegister.ResultType = "2"; db.SubmitChanges(); } } } //// 回写专项检查明细表 if (!string.IsNullOrEmpty(newItem.CheckSpecialDetailId)) { List <string> listIds = Funs.GetStrListByStr(newItem.CheckSpecialDetailId, ','); foreach (var item in listIds) { var getCheckSpecialDetail = db.Check_CheckSpecialDetail.FirstOrDefault(x => x.CheckSpecialDetailId == item); if (getCheckSpecialDetail != null) { getCheckSpecialDetail.DataType = "2"; getCheckSpecialDetail.DataId = newPunishNotice.PunishNoticeId; db.SubmitChanges(); } } } } else { newPunishNotice.PunishNoticeId = getUpdate.PunishNoticeId; getUpdate.PunishStates = newItem.PunishStates; if (newPunishNotice.PunishStates == "0" || newPunishNotice.PunishStates == "1") ////编制人 修改或提交 { getUpdate.PunishNoticeDate = newPunishNotice.PunishNoticeDate; getUpdate.UnitId = newPunishNotice.UnitId; getUpdate.ContractNum = newPunishNotice.ContractNum; getUpdate.IncentiveReason = newPunishNotice.IncentiveReason; getUpdate.BasicItem = newPunishNotice.BasicItem; getUpdate.PunishMoney = newPunishNotice.PunishMoney; getUpdate.Currency = newPunishNotice.Currency; getUpdate.FileContents = newPunishNotice.FileContents; if (newPunishNotice.PunishStates == "1" && !string.IsNullOrEmpty(newItem.SignManId)) { getUpdate.SignMan = newItem.SignManId; } else { newPunishNotice.PunishStates = getUpdate.PunishStates = "0"; } db.SubmitChanges(); } else if (newPunishNotice.PunishStates == "2") ////【签发】总包安全经理 { /// 不同意 打回 同意抄送专业工程师、施工经理、相关施工分包单位并提交【批准】总包项目经理 if (newItem.IsAgree == false) { newPunishNotice.PunishStates = getUpdate.PunishStates = "0"; } else { if (!string.IsNullOrEmpty(newItem.ProfessionalEngineerId)) { getUpdate.ProfessionalEngineerId = newItem.ProfessionalEngineerId; } if (!string.IsNullOrEmpty(newItem.ConstructionManagerId)) { getUpdate.ConstructionManagerId = newItem.ConstructionManagerId; } if (!string.IsNullOrEmpty(newItem.UnitHeadManId)) { getUpdate.UnitHeadManId = newItem.UnitHeadManId; } if (!string.IsNullOrEmpty(newItem.ApproveManId)) { getUpdate.ApproveMan = newItem.ApproveManId; getUpdate.SignDate = DateTime.Now; } else { newPunishNotice.PunishStates = getUpdate.States = "1"; } } db.SubmitChanges(); } else if (newPunishNotice.PunishStates == "3") ////【批准】总包项目经理 { /// 不同意 打回 同意下发【回执】施工分包单位 if (newItem.IsAgree == false || string.IsNullOrEmpty(newItem.DutyPersonId)) { newPunishNotice.PunishStates = getUpdate.PunishStates = "1"; } else { getUpdate.DutyPersonId = newItem.DutyPersonId; getUpdate.ApproveDate = DateTime.Now; } db.SubmitChanges(); } else if (newPunishNotice.PunishStates == "4") ////【批准】总包项目经理 { /// 不同意 打回 同意下发【回执】施工分包单位 if (string.IsNullOrEmpty(newItem.ReceiptUrl)) { newPunishNotice.PunishStates = getUpdate.PunishStates = "3"; } else { getUpdate.DutyPersonDate = DateTime.Now; getUpdate.States = Const.State_2; } db.SubmitChanges(); } } if (newItem.PunishStates == Const.State_0 || newItem.PunishStates == Const.State_1) { //// 通知单附件 APIUpLoadFileService.SaveAttachUrl(Const.ProjectPunishNoticeStatisticsMenuId, newPunishNotice.PunishNoticeId, newItem.PunishUrl, "0"); } if (newItem.PunishStates == Const.State_4) { //// 回执单附件 APIUpLoadFileService.SaveAttachUrl(Const.ProjectPunishNoticeMenuId, newPunishNotice.PunishNoticeId, newItem.ReceiptUrl, "0"); } if (getUpdate != null && getUpdate.States == Const.State_2) { CommonService.btnSaveData(newPunishNotice.ProjectId, Const.ProjectPunishNoticeMenuId, newPunishNotice.PunishNoticeId, newPunishNotice.CompileMan, true, newPunishNotice.PunishNoticeCode, "../Check/PunishNoticeView.aspx?PunishNoticeId={0}"); var getcheck = from x in db.Check_CheckSpecialDetail where x.DataId == getUpdate.PunishNoticeId select x; if (getcheck.Count() > 0) { foreach (var item in getcheck) { item.CompleteStatus = true; item.CompletedDate = DateTime.Now; db.SubmitChanges(); } } } } }
/// <summary> /// 人员资质信息保存方法 /// </summary> /// <param name="personQuality">人员信息</param> public static void SavePersonQuality(Model.PersonQualityItem personQuality) { using (Model.SUBHSSEDB db = new Model.SUBHSSEDB(Funs.ConnString)) { if (personQuality.QualityType == "1") { Model.QualityAudit_PersonQuality newPersonQuality = new Model.QualityAudit_PersonQuality { PersonQualityId = personQuality.PersonQualityId, PersonId = personQuality.PersonId, CertificateNo = personQuality.CertificateNo, CertificateName = personQuality.CertificateName, Grade = personQuality.Grade, SendUnit = personQuality.SendUnit, SendDate = Funs.GetNewDateTime(personQuality.SendDate), LimitDate = Funs.GetNewDateTime(personQuality.LimitDate), LateCheckDate = Funs.GetNewDateTime(personQuality.LateCheckDate), ApprovalPerson = personQuality.ApprovalPerson, Remark = personQuality.Remark, CompileDate = Funs.GetNewDateTime(personQuality.CompileDate), AuditOpinion = personQuality.AuditOpinion, States = personQuality.States, }; if (newPersonQuality.States == Const.State_2 || newPersonQuality.States == Const.State_R) { newPersonQuality.AuditDate = DateTime.Now; } else { newPersonQuality.AuditDate = null; } if (!string.IsNullOrEmpty(personQuality.CertificateId)) { newPersonQuality.CertificateId = personQuality.CertificateId; } if (!string.IsNullOrEmpty(personQuality.CompileMan)) { newPersonQuality.CompileMan = personQuality.CompileMan; } if (!string.IsNullOrEmpty(personQuality.AuditorId)) { newPersonQuality.AuditorId = personQuality.AuditorId; } var getPersonQuality = db.QualityAudit_PersonQuality.FirstOrDefault(x => x.PersonQualityId == newPersonQuality.PersonQualityId || x.PersonId == newPersonQuality.PersonId); if (getPersonQuality == null) { newPersonQuality.PersonQualityId = SQLHelper.GetNewID(); newPersonQuality.CompileDate = DateTime.Now; db.QualityAudit_PersonQuality.InsertOnSubmit(newPersonQuality); db.SubmitChanges(); } else { newPersonQuality.PersonQualityId = getPersonQuality.PersonQualityId; getPersonQuality.CertificateId = newPersonQuality.CertificateId; getPersonQuality.CertificateNo = newPersonQuality.CertificateNo; getPersonQuality.CertificateName = newPersonQuality.CertificateName; getPersonQuality.Grade = newPersonQuality.Grade; getPersonQuality.SendUnit = newPersonQuality.SendUnit; getPersonQuality.SendDate = newPersonQuality.SendDate; getPersonQuality.LimitDate = newPersonQuality.LimitDate; getPersonQuality.LateCheckDate = newPersonQuality.LateCheckDate; getPersonQuality.Remark = newPersonQuality.Remark; getPersonQuality.AuditDate = newPersonQuality.AuditDate; getPersonQuality.AuditorId = newPersonQuality.AuditorId; getPersonQuality.States = newPersonQuality.States; db.SubmitChanges(); } if (!string.IsNullOrEmpty(newPersonQuality.PersonQualityId)) { APIUpLoadFileService.SaveAttachUrl(Const.PersonQualityMenuId, newPersonQuality.PersonQualityId, personQuality.AttachUrl, "0"); } } else if (personQuality.QualityType == "2") { Model.QualityAudit_SafePersonQuality newSafeQuality = new Model.QualityAudit_SafePersonQuality { SafePersonQualityId = personQuality.PersonQualityId, PersonId = personQuality.PersonId, CertificateNo = personQuality.CertificateNo, CertificateName = personQuality.CertificateName, Grade = personQuality.Grade, SendUnit = personQuality.SendUnit, SendDate = Funs.GetNewDateTime(personQuality.SendDate), LimitDate = Funs.GetNewDateTime(personQuality.LimitDate), LateCheckDate = Funs.GetNewDateTime(personQuality.LateCheckDate), ApprovalPerson = personQuality.ApprovalPerson, Remark = personQuality.Remark, CompileDate = Funs.GetNewDateTime(personQuality.CompileDate), AuditDate = Funs.GetNewDateTime(personQuality.AuditDate), AuditOpinion = personQuality.AuditOpinion, States = personQuality.States, }; if (newSafeQuality.States == Const.State_2 || newSafeQuality.States == Const.State_R) { newSafeQuality.AuditDate = DateTime.Now; } else { newSafeQuality.AuditDate = null; } //if (!string.IsNullOrEmpty(personQuality.CertificateId)) //{ // newSafeQuality.CertificateId = personQuality.CertificateId; //} if (!string.IsNullOrEmpty(personQuality.CompileMan)) { newSafeQuality.CompileMan = personQuality.CompileMan; } if (!string.IsNullOrEmpty(personQuality.AuditorId)) { newSafeQuality.AuditorId = personQuality.AuditorId; } var getSafePersonQuality = db.QualityAudit_SafePersonQuality.FirstOrDefault(x => x.SafePersonQualityId == newSafeQuality.SafePersonQualityId || x.PersonId == newSafeQuality.PersonId); if (getSafePersonQuality == null) { newSafeQuality.SafePersonQualityId = SQLHelper.GetNewID(); newSafeQuality.CompileDate = DateTime.Now; db.QualityAudit_SafePersonQuality.InsertOnSubmit(newSafeQuality); db.SubmitChanges(); } else { newSafeQuality.SafePersonQualityId = getSafePersonQuality.SafePersonQualityId; //getPersonQuality.CertificateId = newSafeQuality.CertificateId; getSafePersonQuality.CertificateNo = newSafeQuality.CertificateNo; getSafePersonQuality.CertificateName = newSafeQuality.CertificateName; getSafePersonQuality.Grade = newSafeQuality.Grade; getSafePersonQuality.SendUnit = newSafeQuality.SendUnit; getSafePersonQuality.SendDate = newSafeQuality.SendDate; getSafePersonQuality.LimitDate = newSafeQuality.LimitDate; getSafePersonQuality.LateCheckDate = newSafeQuality.LateCheckDate; getSafePersonQuality.Remark = newSafeQuality.Remark; getSafePersonQuality.AuditDate = newSafeQuality.AuditDate; getSafePersonQuality.AuditorId = newSafeQuality.AuditorId; getSafePersonQuality.States = newSafeQuality.States; db.SubmitChanges(); } if (!string.IsNullOrEmpty(newSafeQuality.SafePersonQualityId)) { APIUpLoadFileService.SaveAttachUrl(Const.SafePersonQualityMenuId, newSafeQuality.SafePersonQualityId, personQuality.AttachUrl, "0"); } } //// 特种设备作业人员 if (personQuality.QualityType == "3") { Model.QualityAudit_EquipmentPersonQuality newEquipmentPersonQuality = new Model.QualityAudit_EquipmentPersonQuality { EquipmentPersonQualityId = personQuality.PersonQualityId, PersonId = personQuality.PersonId, CertificateNo = personQuality.CertificateNo, CertificateName = personQuality.CertificateName, Grade = personQuality.Grade, SendUnit = personQuality.SendUnit, SendDate = Funs.GetNewDateTime(personQuality.SendDate), LimitDate = Funs.GetNewDateTime(personQuality.LimitDate), LateCheckDate = Funs.GetNewDateTime(personQuality.LateCheckDate), ApprovalPerson = personQuality.ApprovalPerson, Remark = personQuality.Remark, CompileDate = Funs.GetNewDateTime(personQuality.CompileDate), AuditDate = Funs.GetNewDateTime(personQuality.AuditDate), AuditOpinion = personQuality.AuditOpinion, States = personQuality.States, }; if (newEquipmentPersonQuality.States == Const.State_2 || newEquipmentPersonQuality.States == Const.State_R) { newEquipmentPersonQuality.AuditDate = DateTime.Now; } else { newEquipmentPersonQuality.AuditDate = null; } if (!string.IsNullOrEmpty(personQuality.CertificateId)) { newEquipmentPersonQuality.CertificateId = personQuality.CertificateId; } if (!string.IsNullOrEmpty(personQuality.CompileMan)) { newEquipmentPersonQuality.CompileMan = personQuality.CompileMan; } if (!string.IsNullOrEmpty(personQuality.AuditorId)) { newEquipmentPersonQuality.AuditorId = personQuality.AuditorId; } var getEquipmentPersonQuality = db.QualityAudit_EquipmentPersonQuality.FirstOrDefault(x => x.EquipmentPersonQualityId == newEquipmentPersonQuality.EquipmentPersonQualityId || x.PersonId == newEquipmentPersonQuality.PersonId); if (getEquipmentPersonQuality == null) { newEquipmentPersonQuality.EquipmentPersonQualityId = SQLHelper.GetNewID(); newEquipmentPersonQuality.CompileDate = DateTime.Now; db.QualityAudit_EquipmentPersonQuality.InsertOnSubmit(newEquipmentPersonQuality); db.SubmitChanges(); } else { newEquipmentPersonQuality.EquipmentPersonQualityId = getEquipmentPersonQuality.EquipmentPersonQualityId; getEquipmentPersonQuality.CertificateId = newEquipmentPersonQuality.CertificateId; getEquipmentPersonQuality.CertificateNo = newEquipmentPersonQuality.CertificateNo; getEquipmentPersonQuality.CertificateName = newEquipmentPersonQuality.CertificateName; getEquipmentPersonQuality.Grade = newEquipmentPersonQuality.Grade; getEquipmentPersonQuality.SendUnit = newEquipmentPersonQuality.SendUnit; getEquipmentPersonQuality.SendDate = newEquipmentPersonQuality.SendDate; getEquipmentPersonQuality.LimitDate = newEquipmentPersonQuality.LimitDate; getEquipmentPersonQuality.LateCheckDate = newEquipmentPersonQuality.LateCheckDate; getEquipmentPersonQuality.Remark = newEquipmentPersonQuality.Remark; getEquipmentPersonQuality.AuditDate = newEquipmentPersonQuality.AuditDate; getEquipmentPersonQuality.AuditorId = newEquipmentPersonQuality.AuditorId; getEquipmentPersonQuality.States = newEquipmentPersonQuality.States; db.SubmitChanges(); } if (!string.IsNullOrEmpty(newEquipmentPersonQuality.EquipmentPersonQualityId)) { APIUpLoadFileService.SaveAttachUrl(Const.EquipmentPersonQualityMenuId, newEquipmentPersonQuality.EquipmentPersonQualityId, personQuality.AttachUrl, "0"); } } if (!string.IsNullOrEmpty(personQuality.AuditDate) && string.IsNullOrEmpty(personQuality.AuditorId)) { APICommonService.SendSubscribeMessage(personQuality.AuditorId, "人员资质" + personQuality.PersonName + "待您审核", personQuality.CompileManName, string.Format("{0:yyyy-MM-dd HH:mm:ss}", DateTime.Now)); } } }