/// <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>
/// <returns></returns>
public static List <Model.SpSysUserItem> GetProjectRoleUserListByProjectId(string projectId, string unitId)
{
IQueryable <Model.SpSysUserItem> users = null;
if (!string.IsNullOrEmpty(projectId))
{
List <Model.SpSysUserItem> returUsers = new List <Model.SpSysUserItem>();
List <Model.Project_ProjectUser> getPUser = new List <Model.Project_ProjectUser>();
if (!string.IsNullOrEmpty(unitId))
{
getPUser = (from x in Funs.DB.Project_ProjectUser
join u in Funs.DB.Project_ProjectUnit on new { x.ProjectId, x.UnitId } equals new { u.ProjectId, u.UnitId }
where x.ProjectId == projectId && (u.UnitId == unitId || u.UnitType == BLL.Const.ProjectUnitType_1 || u.UnitType == BLL.Const.ProjectUnitType_3 || u.UnitType == BLL.Const.ProjectUnitType_4)
select x).ToList();
}
else
{
getPUser = (from x in Funs.DB.Project_ProjectUser
where x.ProjectId == projectId
select x).ToList();
}
if (getPUser.Count() > 0)
{
foreach (var item in getPUser)
{
List <string> roleIdList = Funs.GetStrListByStr(item.RoleId, ',');
var getRoles = Funs.DB.Sys_Role.FirstOrDefault(x => x.IsAuditFlow == true && roleIdList.Contains(x.RoleId));
if (getRoles != null)
{
string userName = RoleService.getRoleNamesRoleIds(item.RoleId) + "-" + UserService.GetUserNameByUserId(item.UserId);
Model.SpSysUserItem newsysUser = new Model.SpSysUserItem
{
UserId = item.UserId,
UserName = userName,
};
returUsers.Add(newsysUser);
}
}
}
return(returUsers);
}
else
{
if (!string.IsNullOrEmpty(unitId))
{
users = (from x in Funs.DB.Sys_User
join z in Funs.DB.Sys_Role on x.RoleId equals z.RoleId
where x.IsPost == true && z.IsAuditFlow == true && x.UnitId == unitId
orderby x.UserCode
select new Model.SpSysUserItem
{
UserName = z.RoleName + "- " + x.UserName,
UserId = x.UserId,
});
}
else
{
users = (from x in Funs.DB.Sys_User
join z in Funs.DB.Sys_Role on x.RoleId equals z.RoleId
where x.IsPost == true && z.IsAuditFlow == true
orderby x.UserCode
select new Model.SpSysUserItem
{
UserName = z.RoleName + "- " + x.UserName,
UserId = x.UserId,
});
}
}
return(users.ToList());
}
/// <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="userId">用户id</param>
/// <param name="menuId">按钮id</param>
/// <param name="buttonName">按钮名称</param>
/// <returns>是否具有权限</returns>
public static bool GetAllButtonPowerList(string projectId, string userId, string menuId, string buttonName)
{
Model.SUBHSSEDB db = Funs.DB;
bool isPower = false; ////定义是否具备按钮权限
if (userId == Const.sedinId)
{
return(isPower);
}
if (!isPower && (userId == Const.sysglyId || userId == Const.hfnbdId))
{
isPower = true;
}
// 根据角色判断是否有按钮权限
if (!isPower)
{
if (string.IsNullOrEmpty(projectId))
{
var user = UserService.GetUserByUserId(userId); ////用户
if (user != null)
{
if (!string.IsNullOrEmpty(user.RoleId))
{
var buttonToMenu = from x in db.Sys_ButtonToMenu
join y in db.Sys_ButtonPower on x.ButtonToMenuId equals y.ButtonToMenuId
join z in db.Sys_Menu on x.MenuId equals z.MenuId
where y.RoleId == user.RoleId && y.MenuId == menuId &&
x.ButtonName == buttonName && x.MenuId == menuId
select x;
if (buttonToMenu.Count() > 0)
{
isPower = true;
}
}
}
}
else
{
var pUser = BLL.ProjectUserService.GetProjectUserByUserIdProjectId(projectId, userId); ///项目用户
if (pUser != null)
{
if (!string.IsNullOrEmpty(pUser.RoleId))
{
List <string> roleIdList = Funs.GetStrListByStr(pUser.RoleId, ',');
var buttonToMenu = from x in db.Sys_ButtonToMenu
join y in db.Sys_ButtonPower on x.ButtonToMenuId equals y.ButtonToMenuId
join z in db.Sys_Menu on x.MenuId equals z.MenuId
where roleIdList.Contains(y.RoleId) && y.MenuId == menuId &&
x.ButtonName == buttonName && x.MenuId == menuId
select x;
if (buttonToMenu.Count() > 0)
{
isPower = true;
}
}
}
}
}
if (isPower && !String.IsNullOrEmpty(projectId) && menuId != BLL.Const.ProjectShutdownMenuId)
{
var porject = BLL.ProjectService.GetProjectByProjectId(projectId);
if (porject != null && (porject.ProjectState == BLL.Const.ProjectState_2 || porject.ProjectState == BLL.Const.ProjectState_3))
{
isPower = false;
}
}
if (!CommonService.GetIsBuildUnit())
{
var menu = BLL.SysMenuService.GetSysMenuByMenuId(menuId);
if (menu != null && menu.MenuType == BLL.Const.Menu_Resource)
{
if (buttonName == BLL.Const.BtnSaveUp || buttonName == BLL.Const.BtnUploadResources || buttonName == BLL.Const.BtnAuditing)
{
isPower = false;
}
}
}
return(isPower);
}
/// <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>
/// 插入培训人员 3
/// </summary>
/// <param name="projectId"></param>
/// <param name="arr"></param>
public static bool AddTrainRecordPerson(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 personId = null; ///人员信息ID
var getPerson = db.SitePerson_Person.FirstOrDefault(x => x.IdentityCard == item["IdentifyId"].ToString());
if (getPerson != null)
{
personId = getPerson.PersonId;
}
bool checkResult = false;
if (item["IsPass"].ToString() == "1")
{
checkResult = true;
}
if (!string.IsNullOrEmpty(trainingId) && !string.IsNullOrEmpty(personId))
{
Model.EduTrain_TrainRecordDetail newTrainRecordDetail = new Model.EduTrain_TrainRecordDetail
{
TrainingId = trainingId,
PersonId = personId,
CheckScore = Funs.GetNewDecimal(item["Score"].ToString()),
CheckResult = checkResult,
};
var getTrainRecordDetail = db.EduTrain_TrainRecordDetail.FirstOrDefault(x => x.TrainingId == trainingId && x.PersonId == personId);
if (getTrainRecordDetail == null)
{
EduTrain_TrainRecordDetailService.AddTrainDetail(newTrainRecordDetail);
}
else
{
getTrainRecordDetail.CheckScore = newTrainRecordDetail.CheckScore;
getTrainRecordDetail.CheckResult = newTrainRecordDetail.CheckResult;
EduTrain_TrainRecordDetailService.UpdateTrainDetail(getTrainRecordDetail);
}
}
else
{
isOk = false;
}
}
}
catch (Exception ex)
{
isOk = false;
ErrLogInfo.WriteLog(string.Empty, ex);
}
return(isOk);
}
/// <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>
/// 根据安全工作总结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>
/// 根据安全工作总结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>
/// 保存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>
/// 保存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>
/// 保存HazardRegister
/// </summary>
/// <param name="userInfo"></param>
/// <returns></returns>
public static void SaveHazardRegister(Model.HazardRegisterItem hazardRegister)
{
Model.HSSE_Hazard_HazardRegister newHazardRegister = new Model.HSSE_Hazard_HazardRegister
{
HazardRegisterId = hazardRegister.HazardRegisterId,
HazardCode = hazardRegister.HazardCode,
RegisterDef = hazardRegister.RegisterDef,
Rectification = hazardRegister.Rectification,
Place = hazardRegister.Place,
ResponsibleUnit = hazardRegister.ResponsibleUnit,
ProjectId = hazardRegister.ProjectId,
States = hazardRegister.States,
IsEffective = "1",
ResponsibleMan = hazardRegister.ResponsibleMan,
CheckManId = hazardRegister.CheckManId,
CheckTime = hazardRegister.CheckTime,
RectificationPeriod = hazardRegister.RectificationPeriod,
ImageUrl = hazardRegister.ImageUrl,
RectificationImageUrl = hazardRegister.RectificationImageUrl,
RectificationTime = hazardRegister.RectificationTime,
ConfirmMan = hazardRegister.ConfirmMan,
ConfirmDate = hazardRegister.ConfirmDate,
HandleIdea = hazardRegister.HandleIdea,
CutPayment = hazardRegister.CutPayment,
ProblemTypes = hazardRegister.ProblemTypes,
RegisterTypesId = hazardRegister.RegisterTypesId,
CheckCycle = hazardRegister.CheckCycle,
SafeSupervisionIsOK = hazardRegister.SafeSupervisionIsOK,
IsWx = "Y",
CCManIds = hazardRegister.CCManIds,
Requirements = hazardRegister.Requirements,
};
var isUpdate = Funs.DB.HSSE_Hazard_HazardRegister.FirstOrDefault(x => x.HazardRegisterId == newHazardRegister.HazardRegisterId);
if (isUpdate == null)
{
newHazardRegister.RegisterDate = DateTime.Now;
newHazardRegister.CheckTime = DateTime.Now;
if (string.IsNullOrEmpty(newHazardRegister.HazardRegisterId))
{
newHazardRegister.HazardRegisterId = SQLHelper.GetNewID();
}
Funs.DB.HSSE_Hazard_HazardRegister.InsertOnSubmit(newHazardRegister);
}
else
{
if (newHazardRegister.States == "2")
{
isUpdate.RectificationTime = DateTime.Now;
isUpdate.Rectification = newHazardRegister.Rectification;
isUpdate.RectificationImageUrl = newHazardRegister.RectificationImageUrl;
}
else
{
isUpdate.ConfirmDate = DateTime.Now;
isUpdate.ConfirmMan = newHazardRegister.ConfirmMan;
isUpdate.HandleIdea = newHazardRegister.HandleIdea;
isUpdate.SafeSupervisionIsOK = newHazardRegister.SafeSupervisionIsOK;
}
isUpdate.States = newHazardRegister.States;
}
Funs.SubmitChanges();
if (hazardRegister.States == Const.State_1)
{
APICommonService.SendSubscribeMessage(hazardRegister.ResponsibleMan, "安全巡检问题待整改", hazardRegister.CheckManName, string.Format("{0:yyyy-MM-dd HH:mm:ss}", hazardRegister.CheckTime));
}
else if (hazardRegister.States == Const.State_2)
{
APICommonService.SendSubscribeMessage(hazardRegister.CheckManId, "安全巡检待复查验收", hazardRegister.ResponsibilityManName, string.Format("{0:yyyy-MM-dd HH:mm:ss}", hazardRegister.RectificationTime));
}
}
/// <summary>
/// 获取用户登录信息
/// </summary>
/// <param name="userInfo"></param>
/// <returns></returns>
public static Model.UserItem UserLogOn(Model.UserItem userInfo)
{
var getUser = Funs.DB.View_Sys_User.FirstOrDefault(x => (x.Account == userInfo.Account || x.Telephone == userInfo.Telephone) && x.IsPost == true && x.Password == Funs.EncryptionPassword(userInfo.Password));
return(ObjectMapperManager.DefaultInstance.GetMapper <Model.View_Sys_User, Model.UserItem>().Map(getUser));
}
/// <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>
/// 插入人员信息 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>
/// 根据时间段和类型获取事故损失金额
/// </summary>
/// <param name="startTime"></param>
/// <param name="endTime"></param>
/// <param name="accidentType"></param>
/// <param name="projectId"></param>
/// <returns></returns>
public static decimal GetSumLosMoneyByAccidentTimeAndAccidentType(DateTime startTime, DateTime endTime, string accidentType, string projectId)
{
decimal loseMoney = 0;
var q = from x in Funs.DB.Accident_AccidentReport where x.AccidentDate >= startTime && x.AccidentDate < endTime && x.AccidentTypeId == accidentType && x.ProjectId == projectId && x.States == BLL.Const.State_2 select x.EconomicLoss;
foreach (var item in q)
{
if (item != null)
{
loseMoney += Funs.GetNewDecimalOrZero(item.ToString());
}
}
var c = from x in Funs.DB.Accident_AccidentReport where x.AccidentDate >= startTime && x.AccidentDate < endTime && x.AccidentTypeId == accidentType && x.ProjectId == projectId && x.States == BLL.Const.State_2 select x.EconomicOtherLoss;
foreach (var item in c)
{
if (item != null)
{
loseMoney += Funs.GetNewDecimalOrZero(item.ToString());
}
}
//if (accidentType == "1" || accidentType == "2" || accidentType == "3") //轻重死事故按审批完成时间
//{
// var a = from x in Funs.DB.Accident_AccidentReport
// join y in Funs.DB.Sys_FlowOperate
// on x.AccidentReportId equals y.DataId
// where x.AccidentTypeId == accidentType && x.ProjectId == projectId && x.States == BLL.Const.State_2
// && y.State == BLL.Const.State_2 && y.OperaterTime >= startTime && y.OperaterTime < endTime
// select x.EconomicLoss;
// foreach (var item in a)
// {
// if (item != null)
// {
// loseMoney += Funs.GetNewDecimal(item.ToString());
// }
// }
// var b = from x in Funs.DB.Accident_AccidentReport
// join y in Funs.DB.Sys_FlowOperate
// on x.AccidentReportId equals y.DataId
// where x.AccidentTypeId == accidentType && x.ProjectId == projectId && x.States == BLL.Const.State_2
// && y.State == BLL.Const.State_2 && y.OperaterTime >= startTime && y.OperaterTime < endTime
// select x.EconomicOtherLoss;
// foreach (var item in b)
// {
// if (item != null)
// {
// loseMoney += Funs.GetNewDecimal(item.ToString());
// }
// }
//}
//else
//{
// var q = from x in Funs.DB.Accident_AccidentReport where x.AccidentDate >= startTime && x.AccidentDate < endTime && x.AccidentTypeId == accidentType && x.ProjectId == projectId && x.States == BLL.Const.State_2 select x.EconomicLoss;
// foreach (var item in q)
// {
// if (item != null)
// {
// loseMoney += Funs.GetNewDecimal(item.ToString());
// }
// }
// var c = from x in Funs.DB.Accident_AccidentReport where x.AccidentDate >= startTime && x.AccidentDate < endTime && x.AccidentTypeId == accidentType && x.ProjectId == projectId && x.States == BLL.Const.State_2 select x.EconomicOtherLoss;
// foreach (var item in c)
// {
// if (item != null)
// {
// loseMoney += Funs.GetNewDecimal(item.ToString());
// }
// }
//}
return(loseMoney);
}
/// <summary>
/// 插入培训记录 2
/// </summary>
/// <param name="projectId"></param>
/// <param name="arr"></param>
public static bool AddTrainRecord(string projectId, JArray arr, Model.Sys_User user)
{
Model.SUBHSSEDB db = Funs.DB;
bool isOk = true;
try
{
foreach (var item in arr)
{
string fromRecordId = item["ID"].ToString();
string trainTypeId = null; ////培训类型
var getTrainType = db.Base_TrainType.FirstOrDefault(x => x.TrainTypeName == item["TrainType"].ToString());
if (getTrainType != null)
{
trainTypeId = getTrainType.TrainTypeId;
}
string unitId = null;
if (!string.IsNullOrEmpty(item["TrainDepart"].ToString()))
{
var lists = Funs.GetStrListByStr(item["TrainDepart"].ToString(), ',');
if (lists.Count() > 0)
{
foreach (var itemList in lists)
{
var getUnit = db.Base_Unit.FirstOrDefault(x => x.UnitName == itemList);
if (getUnit != null)
{
if (string.IsNullOrEmpty(unitId))
{
unitId = getUnit.UnitId;
}
else
{
unitId += ("," + getUnit.UnitId);
}
}
}
}
}
if (!string.IsNullOrEmpty(unitId) && !string.IsNullOrEmpty(fromRecordId))
{
Model.EduTrain_TrainRecord newTrainRecord = new Model.EduTrain_TrainRecord
{
FromRecordId = fromRecordId,
ProjectId = projectId,
TrainTitle = item["RecordName"].ToString(),
TrainContent = item["TrainContent"].ToString(),
TrainStartDate = Funs.GetNewDateTime(item["TrainStartDate"].ToString()),
TrainEndDate = Funs.GetNewDateTime(item["TrainEndDate"].ToString()),
TeachHour = Funs.GetNewDecimalOrZero(item["TrainPeriod"].ToString()),
TeachMan = item["TrainPrincipal"].ToString(),
Remark = item["TrainDescript"].ToString(),
TrainTypeId = trainTypeId,
UnitIds = unitId,
States = Const.State_0,
CompileMan = item["CreateUser"].ToString(),
TrainPersonNum = Funs.GetNewInt(item["PersonCount"].ToString()),
};
newTrainRecord.TrainingCode = Funs.GetNewFileName(newTrainRecord.TrainStartDate);
var getTrainRecord = Funs.DB.EduTrain_TrainRecord.FirstOrDefault(x => x.FromRecordId == fromRecordId);
if (getTrainRecord == null)
{
newTrainRecord.TrainingId = SQLHelper.GetNewID(typeof(Model.EduTrain_TrainRecord));
EduTrain_TrainRecordService.AddTraining(newTrainRecord);
BLL.LogService.AddSys_Log(user, newTrainRecord.TrainingCode, newTrainRecord.TrainingId, BLL.Const.ProjectTrainRecordMenuId, BLL.Const.BtnAdd);
}
else
{
getTrainRecord.TrainingCode = newTrainRecord.TrainingCode;
getTrainRecord.TrainTitle = newTrainRecord.TrainTitle;
getTrainRecord.TrainContent = newTrainRecord.TrainContent;
getTrainRecord.UnitIds = newTrainRecord.UnitIds;
getTrainRecord.TrainStartDate = newTrainRecord.TrainStartDate;
if (newTrainRecord.TrainEndDate.HasValue)
{
getTrainRecord.TrainEndDate = newTrainRecord.TrainEndDate;
}
else
{
getTrainRecord.TrainEndDate = newTrainRecord.TrainStartDate;
}
getTrainRecord.TeachHour = newTrainRecord.TeachHour;
getTrainRecord.TeachMan = newTrainRecord.TeachMan;
getTrainRecord.TeachAddress = newTrainRecord.TeachAddress;
getTrainRecord.Remark = newTrainRecord.Remark;
EduTrain_TrainRecordService.UpdateTraining(getTrainRecord);
BLL.LogService.AddSys_Log(user, getTrainRecord.TrainingCode, getTrainRecord.TrainingId, BLL.Const.ProjectTrainRecordMenuId, BLL.Const.BtnModify);
}
}
else
{
isOk = false;
}
}
}
catch (Exception ex)
{
isOk = false;
ErrLogInfo.WriteLog(string.Empty, ex);
}
return(isOk);
}
/// <summary>
/// 人员资质信息保存方法
/// </summary>
/// <param name="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));
}
}
}
/// <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>
/// 获取当前人按钮集合
/// </summary>
/// <param name="userId">用户id</param>
/// <param name="menuId">按钮id</param>
/// <returns>是否具有权限</returns>
public static List <string> GetAllButtonList(string projectId, string userId, string menuId)
{
Model.SUBHSSEDB db = Funs.DB;
List <string> buttonList = new List <string>();
List <Model.Sys_ButtonToMenu> buttons = new List <Model.Sys_ButtonToMenu>();
if (userId == Const.sedinId)
{
return(buttonList);
}
if (userId == Const.sysglyId || userId == Const.hfnbdId)
{
buttons = (from x in db.Sys_ButtonToMenu
where x.MenuId == menuId
select x).ToList();
}
else
{
if (string.IsNullOrEmpty(projectId))
{
var user = BLL.UserService.GetUserByUserId(userId); ////用户
if (user != null)
{
buttons = (from x in db.Sys_ButtonToMenu
join y in db.Sys_ButtonPower on x.ButtonToMenuId equals y.ButtonToMenuId
where y.RoleId == user.RoleId && y.MenuId == menuId && x.MenuId == menuId
select x).ToList();
}
}
else
{
var pUser = BLL.ProjectUserService.GetProjectUserByUserIdProjectId(projectId, userId); ///项目用户
if (pUser != null)
{
List <string> roleIdList = Funs.GetStrListByStr(pUser.RoleId, ',');
buttons = (from x in db.Sys_ButtonToMenu
join y in db.Sys_ButtonPower on x.ButtonToMenuId equals y.ButtonToMenuId
where roleIdList.Contains(y.RoleId) && y.MenuId == menuId && x.MenuId == menuId
select x).ToList();
}
}
}
if (buttons.Count() > 0)
{
if (!CommonService.GetIsBuildUnit())
{
var menu = BLL.SysMenuService.GetSysMenuByMenuId(menuId);
if (menu != null && menu.MenuType == BLL.Const.Menu_Resource)
{
for (int p = buttons.Count - 1; p > -1; p--)
{
if (buttons[p].ButtonName == BLL.Const.BtnSaveUp || buttons[p].ButtonName == BLL.Const.BtnUploadResources || buttons[p].ButtonName == BLL.Const.BtnAuditing)
{
buttons.Remove(buttons[p]);
}
}
}
}
buttonList = buttons.Select(x => x.ButtonName).ToList();
}
if (!String.IsNullOrEmpty(projectId) && menuId != BLL.Const.ProjectShutdownMenuId)
{
var porject = BLL.ProjectService.GetProjectByProjectId(projectId);
if (porject != null && (porject.ProjectState == BLL.Const.ProjectState_2 || porject.ProjectState == BLL.Const.ProjectState_3))
{
buttonList.Clear();
}
}
return(buttonList);
}
/// <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>
/// 收集工程师日志记录
/// </summary>
/// <param name="projectId">项目id</param>
/// <param name="menuId">菜单id</param>
/// <param name="dataId">单据id</param>
/// <param name="operaterId">操作人id</param>
/// <param name="date">日期</param>
public static void CollectHSSELogByData(string projectId, string menuId, string dataId)
{
switch (menuId)
{
case BLL.Const.ProjectCheckDayMenuId:
var checkDay = BLL.Check_CheckDayService.GetCheckDayByCheckDayId(dataId);
if (checkDay != null)
{
BLL.HSSELogService.CollectHSSELog(projectId, checkDay.CheckPerson, checkDay.CheckTime, "21", "日常巡检", Const.BtnAdd, 1);
}
break;
case BLL.Const.ProjectCheckSpecialMenuId:
var checkSpecial = BLL.Check_CheckSpecialService.GetCheckSpecialByCheckSpecialId(dataId);
if (checkSpecial != null)
{
BLL.HSSELogService.CollectHSSELog(projectId, checkSpecial.CheckPerson, checkSpecial.CheckTime, "21", "专项检查", Const.BtnAdd, 1);
if (!string.IsNullOrEmpty(checkSpecial.PartInPersonIds))
{
List <string> partInPersonIds = Funs.GetStrListByStr(checkSpecial.PartInPersonIds, ',');
foreach (var item in partInPersonIds)
{
BLL.HSSELogService.CollectHSSELog(projectId, item, checkSpecial.CheckTime, "21", "专项检查", Const.BtnAdd, 1);
}
}
}
break;
case BLL.Const.ProjectCheckColligationMenuId:
var checkColligation = BLL.Check_CheckColligationService.GetCheckColligationByCheckColligationId(dataId);
if (checkColligation != null)
{
BLL.HSSELogService.CollectHSSELog(projectId, checkColligation.CheckPerson, checkColligation.CheckTime, "21", "综合检查", Const.BtnAdd, 1);
if (!string.IsNullOrEmpty(checkColligation.PartInPersonIds))
{
List <string> partInPersonIds = Funs.GetStrListByStr(checkColligation.PartInPersonIds, ',');
foreach (var item in partInPersonIds)
{
BLL.HSSELogService.CollectHSSELog(projectId, item, checkColligation.CheckTime, "21", "综合检查", Const.BtnAdd, 1);
}
}
}
break;
case BLL.Const.ProjectCheckWorkMenuId:
var checkWork = BLL.Check_CheckWorkService.GetCheckWorkByCheckWorkId(dataId);
if (checkWork != null)
{
if (!string.IsNullOrEmpty(checkWork.MainUnitPerson))
{
List <string> mainUnitPersonIds = Funs.GetStrListByStr(checkWork.MainUnitPerson, ',');
foreach (var item in mainUnitPersonIds)
{
BLL.HSSELogService.CollectHSSELog(projectId, item, checkWork.CheckTime, "21", "开工前HSE检查", Const.BtnAdd, 1);
}
}
if (!string.IsNullOrEmpty(checkWork.SubUnitPerson))
{
List <string> subUnitPersonIds = Funs.GetStrListByStr(checkWork.SubUnitPerson, ',');
foreach (var item in subUnitPersonIds)
{
BLL.HSSELogService.CollectHSSELog(projectId, item, checkWork.CheckTime, "21", "开工前HSE检查", Const.BtnAdd, 1);
}
}
}
break;
case BLL.Const.ProjectCheckHolidayMenuId:
var checkHoliday = BLL.Check_CheckHolidayService.GetCheckHolidayByCheckHolidayId(dataId);
if (checkHoliday != null)
{
if (!string.IsNullOrEmpty(checkHoliday.MainUnitPerson))
{
List <string> mainUnitPersonIds = Funs.GetStrListByStr(checkHoliday.MainUnitPerson, ',');
foreach (var item in mainUnitPersonIds)
{
BLL.HSSELogService.CollectHSSELog(projectId, item, checkHoliday.CheckTime, "21", "季节性和节假日前HSE检查", Const.BtnAdd, 1);
}
}
if (!string.IsNullOrEmpty(checkHoliday.SubUnitPerson))
{
List <string> subUnitPersonIds = Funs.GetStrListByStr(checkHoliday.SubUnitPerson, ',');
foreach (var item in subUnitPersonIds)
{
BLL.HSSELogService.CollectHSSELog(projectId, item, checkHoliday.CheckTime, "21", "季节性和节假日前HSE检查", Const.BtnAdd, 1);
}
}
}
break;
}
}
/// <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>
/// 用户登录成功方法
/// </summary>
/// <param name="loginname">登录成功名</param>
/// <param name="password">未加密密码</param>
/// <param name="rememberMe">记住我开关</param>
/// <param name="page">调用页面</param>
/// <returns>是否登录成功</returns>
public static bool UserLogOn(string account, string password, bool rememberMe, System.Web.UI.Page page)
{
var getUser = from x in Funs.DB.Sys_User where x.Account == account && x.IsPost == true && x.Password == Funs.EncryptionPassword(password)
select new { x.UserId, x.UserName, x.Account, x.Password, SystemType = string.Empty, x.IsPost, x.LoginProjectId, LoginSystemType = string.Empty };
///安全登录
if (getUser.Count() == 0)
{
getUser = from x in FunsHSSE.DB.Sys_User
where x.Account == account && x.IsPost == true && x.Password == Funs.EncryptionPassword(password)
select new { x.UserId, x.UserName, x.Account, x.Password, SystemType = string.Empty, x.IsPost, x.LoginProjectId, LoginSystemType = string.Empty };
///焊接登录
if (getUser.Count() == 0)
{
getUser = from x in FunsHJGL.DB.Sys_User
where x.Account == account && x.IsPost == true && x.Password == Funs.EncryptionPassword(password)
select new { x.UserId, x.UserName, x.Account, x.Password, SystemType = string.Empty, x.IsPost, LoginProjectId = string.Empty, LoginSystemType = string.Empty };
///质量登录
if (getUser.Count() == 0)
{
getUser = from x in FunsCQMS.DB.Sys_User
where x.Account == account && x.IsPost == true && x.Password == Funs.EncryptionPassword(password)
select new { x.UserId, x.UserName, x.Account, x.Password, SystemType = string.Empty, x.IsPost, LoginProjectId = string.Empty, LoginSystemType = string.Empty };
///施工技术登录
if (getUser.Count() == 0)
{
getUser = from x in FunsSGJS.DB.Sys_User
where x.Account == account && x.IsPost == true && x.Password == Funs.EncryptionPassword(password)
select new { x.UserId, x.UserName, x.Account, x.Password, SystemType = string.Empty, x.IsPost, LoginProjectId = string.Empty, LoginSystemType = string.Empty };
///施工综合登录
if (getUser.Count() == 0)
{
getUser = from x in FunsZHGL.DB.Sys_User
where x.Account == account && x.IsPost == true && x.Password == Funs.EncryptionPassword(password)
select new { x.UserId, x.UserName, x.Account, x.Password, SystemType = string.Empty, x.IsPost, LoginProjectId = string.Empty, LoginSystemType = string.Empty };
}
}
}
}
}
var firstUser = getUser.FirstOrDefault();
if (firstUser != null)
{
Model.SpSysUserItem userItem = new Model.SpSysUserItem
{
UserId = firstUser.UserId,
UserName = firstUser.UserName,
Account = firstUser.Account,
Password = firstUser.Password,
};
FormsAuthentication.SetAuthCookie(account, false);
page.Session[SessionName.CurrUser] = userItem;
if (rememberMe)
{
System.Web.HttpCookie u = new System.Web.HttpCookie("UserInfo");
u["username"] = account;
u["password"] = password;
// Cookies过期时间设置为一年.
u.Expires = DateTime.Now.AddYears(1);
page.Response.Cookies.Add(u);
}
else
{
// 当选择不保存用户名时,Cookies过期时间设置为昨天.
page.Response.Cookies["UserInfo"].Expires = DateTime.Now.AddDays(-1);
}
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 附件上传 同时上传到服务器端
/// </summary>
/// <param name="fileUpload">上传控件</param>
/// <param name="fileUrl">上传路径</param>
/// <param name="constUrl">定义路径</param>
/// <param name="serverUrl">服务端地址</param>
/// <returns></returns>
public static string UploadAttachmentAndServer(string rootPath, FileUpload fileUpload, string fileUrl, string constUrl, string serverUrl)
{
string initFullPath = rootPath + constUrl;
if (!Directory.Exists(initFullPath))
{
Directory.CreateDirectory(initFullPath);
}
string initFullPathServer = serverUrl + constUrl;
if (!Directory.Exists(initFullPathServer))
{
Directory.CreateDirectory(initFullPathServer);
}
string filePath = fileUpload.PostedFile.FileName;
string fileName = Funs.GetNewFileName() + "~" + Path.GetFileName(filePath);
int count = fileUpload.PostedFile.ContentLength;
string savePath = constUrl + fileName;
string fullPath = initFullPath + fileName;
string fullPathServer = initFullPathServer + fileName;
if (!File.Exists(fullPath))
{
byte[] buffer = new byte[count];
Stream stream = fileUpload.PostedFile.InputStream;
stream.Read(buffer, 0, count);
MemoryStream memoryStream = new MemoryStream(buffer);
FileStream fs = new FileStream(fullPath, FileMode.Create, FileAccess.Write);
memoryStream.WriteTo(fs);
memoryStream.Flush();
memoryStream.Close();
fs.Flush();
fs.Close();
memoryStream = null;
fs = null;
if (!string.IsNullOrEmpty(fileUrl))
{
fileUrl += "," + savePath;
}
else
{
fileUrl += savePath;
}
MemoryStream memoryStreamEng = new MemoryStream(buffer);
FileStream fsServer = new FileStream(fullPathServer, FileMode.Create, FileAccess.Write);
memoryStreamEng.WriteTo(fsServer);
memoryStreamEng.Flush();
memoryStreamEng.Close();
fsServer.Flush();
fsServer.Close();
memoryStreamEng = null;
fsServer = null;
}
else
{
fileUrl = string.Empty;
}
return(fileUrl);
}
/// <summary>
/// 用户登录成功方法
/// </summary>
/// <param name="loginname">登录成功名</param>
/// <param name="password">未加密密码</param>
/// <param name="rememberMe">记住我开关</param>
/// <param name="page">调用页面</param>
/// <returns>是否登录成功</returns>
public static bool UserLogOn(string account, string password, bool rememberMe, System.Web.UI.Page page)
{
List <Model.Sys_User> x = (from y in Funs.DB.Sys_User
where y.Account == account && y.IsPost == true && y.Password == Funs.EncryptionPassword(password)
select y).ToList();
if (x.Any())
{
string accValue = HttpUtility.UrlEncode(account);
FormsAuthentication.SetAuthCookie(accValue, false);
page.Session[SessionName.CurrUser] = x.First();
if (rememberMe)
{
System.Web.HttpCookie u = new System.Web.HttpCookie("UserInfo");
u["username"] = accValue;
u["password"] = password;
// Cookies过期时间设置为一月.
u.Expires = DateTime.Now.AddMonths(1);
page.Response.Cookies.Add(u);
}
else
{
// 当选择不保存用户名时,Cookies过期时间设置为昨天.
page.Response.Cookies["UserInfo"].Expires = DateTime.Now.AddDays(-1);
}
return(true);
}
else
{
return(false);
}
}
/// <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();
}
}
}
}
}
