/// <summary>
/// 保存Check_PauseNotice
/// </summary>
/// <param name="newItem">工程暂停令</param>
/// <returns></returns>
public static void SavePauseNotice(Model.PauseNoticeItem newItem)
{
using (Model.SUBHSSEDB db = new Model.SUBHSSEDB(Funs.ConnString))
{
Model.Check_PauseNotice newPauseNotice = new Model.Check_PauseNotice
{
PauseNoticeId = newItem.PauseNoticeId,
PauseNoticeCode = newItem.PauseNoticeCode,
ProjectId = newItem.ProjectId,
UnitId = newItem.UnitId,
ProjectPlace = newItem.ProjectPlace,
WrongContent = newItem.WrongContent,
PauseTime = Funs.GetNewDateTime(newItem.PauseTime),
PauseContent = newItem.PauseContent,
OneContent = newItem.OneContent,
SecondContent = newItem.SecondContent,
ThirdContent = newItem.ThirdContent,
States = Const.State_0,
PauseStates = newItem.PauseStates,
};
var getUpdate = db.Check_PauseNotice.FirstOrDefault(x => x.PauseNoticeId == newItem.PauseNoticeId);
if (getUpdate == null)
{
newPauseNotice.CompileDate = DateTime.Now;
newPauseNotice.PauseNoticeId = SQLHelper.GetNewID();
newPauseNotice.PauseNoticeCode = CodeRecordsService.ReturnCodeByMenuIdProjectId(Const.ProjectPauseNoticeMenuId, newPauseNotice.ProjectId, newPauseNotice.UnitId);
db.Check_PauseNotice.InsertOnSubmit(newPauseNotice);
db.SubmitChanges();
CodeRecordsService.InsertCodeRecordsByMenuIdProjectIdUnitId(Const.ProjectPauseNoticeMenuId, newPauseNotice.ProjectId, newPauseNotice.UnitId, newPauseNotice.PauseNoticeId, newPauseNotice.CompileDate);
//// 回写巡检记录表
if (!string.IsNullOrEmpty(newItem.HazardRegisterId))
{
List <string> listIds = Funs.GetStrListByStr(newItem.HazardRegisterId, ',');
foreach (var item in listIds)
{
var getHazardRegister = Funs.DB.HSSE_Hazard_HazardRegister.FirstOrDefault(x => x.HazardRegisterId == item);
if (getHazardRegister != null)
{
getHazardRegister.States = "3";
getHazardRegister.HandleIdea += "已下发工程暂停令：" + newPauseNotice.PauseNoticeCode;
getHazardRegister.ResultId = newPauseNotice.PauseNoticeId;
getHazardRegister.ResultType = "3";
Funs.SubmitChanges();
}
}
}
//// 回写专项检查明细表
if (!string.IsNullOrEmpty(newItem.CheckSpecialDetailId))
{
List <string> listIds = Funs.GetStrListByStr(newItem.CheckSpecialDetailId, ',');
foreach (var item in listIds)
{
var getCheckSpecialDetail = db.Check_CheckSpecialDetail.FirstOrDefault(x => x.CheckSpecialDetailId == item);
if (getCheckSpecialDetail != null)
{
getCheckSpecialDetail.DataType = "3";
getCheckSpecialDetail.DataId = newPauseNotice.PauseNoticeId;
db.SubmitChanges();
}
}
}
}
else
{
newPauseNotice.PauseNoticeId = getUpdate.PauseNoticeId;
getUpdate.PauseStates = newItem.PauseStates;
if (newPauseNotice.PauseStates == "0" || newPauseNotice.PauseStates == "1") ////编制人 修改或提交
{
getUpdate.UnitId = newPauseNotice.UnitId;
getUpdate.ProjectPlace = newPauseNotice.ProjectPlace;
getUpdate.WrongContent = newPauseNotice.WrongContent;
getUpdate.PauseTime = newPauseNotice.PauseTime;
getUpdate.PauseContent = newPauseNotice.PauseContent;
getUpdate.OneContent = newPauseNotice.OneContent;
getUpdate.SecondContent = newPauseNotice.SecondContent;
getUpdate.ThirdContent = newPauseNotice.ThirdContent;
if (newPauseNotice.PauseStates == "1" && !string.IsNullOrEmpty(newItem.SignManId))
{
getUpdate.SignManId = newItem.SignManId;
}
else
{
newPauseNotice.PauseStates = getUpdate.PauseStates = "0";
}
}
else if (newPauseNotice.PauseStates == "2") ////【签发】总包安全经理
{
/// 不同意 打回 同意抄送专业工程师、施工经理、相关施工分包单位并提交【批准】总包项目经理
if (newItem.IsAgree == false)
{
newPauseNotice.PauseStates = getUpdate.PauseStates = "0";
}
else
{
if (!string.IsNullOrEmpty(newItem.ProfessionalEngineerId))
{
getUpdate.ProfessionalEngineerId = newItem.ProfessionalEngineerId;
}
if (!string.IsNullOrEmpty(newItem.ConstructionManagerId))
{
getUpdate.ConstructionManagerId = newItem.ConstructionManagerId;
}
if (!string.IsNullOrEmpty(newItem.UnitHeadManId))
{
getUpdate.UnitHeadManId = newItem.UnitHeadManId;
}
if (!string.IsNullOrEmpty(newItem.SupervisorManId))
{
getUpdate.SupervisorManId = newItem.SupervisorManId;
}
if (!string.IsNullOrEmpty(newItem.OwnerId))
{
getUpdate.OwnerId = newItem.OwnerId;
}
if (!string.IsNullOrEmpty(newItem.ApproveManId))
{
getUpdate.ApproveManId = newItem.ApproveManId;
getUpdate.SignDate = DateTime.Now;
}
else
{
newPauseNotice.PauseStates = getUpdate.States = "1";
}
}
}
else if (newPauseNotice.PauseStates == "3") ////【批准】总包项目经理
{
/// 不同意 打回 同意下发【回执】施工分包单位
if (newItem.IsAgree == false || string.IsNullOrEmpty(newItem.DutyPersonId))
{
newPauseNotice.PauseStates = getUpdate.PauseStates = "1";
}
else
{
getUpdate.DutyPersonId = newItem.DutyPersonId;
getUpdate.ApproveDate = DateTime.Now;
getUpdate.IsConfirm = true;
}
}
else if (newPauseNotice.PauseStates == "4") ////【批准】总包项目经理
{
getUpdate.DutyPersonDate = DateTime.Now;
getUpdate.States = Const.State_2;
}
db.SubmitChanges();
}
if (newItem.PauseStates == Const.State_0 || newItem.PauseStates == Const.State_1)
{ //// 通知单附件
UploadFileService.SaveAttachUrl(UploadFileService.GetSourceByAttachUrl(newItem.PauseNoticeAttachUrl, 10, null), newItem.PauseNoticeAttachUrl, Const.ProjectPauseNoticeMenuId, newPauseNotice.PauseNoticeId);
}
if (getUpdate != null && getUpdate.States == Const.State_2)
{
CommonService.btnSaveData(newPauseNotice.ProjectId, Const.ProjectPauseNoticeMenuId, newPauseNotice.PauseNoticeId, newPauseNotice.CompileManId, true, newPauseNotice.PauseContent, "../Check/PauseNoticeView.aspx?PauseNoticeId={0}");
var getcheck = from x in db.Check_CheckSpecialDetail where x.DataId == getUpdate.PauseNoticeId select x;
if (getcheck.Count() > 0)
{
foreach (var item in getcheck)
{
item.CompleteStatus = true;
item.CompletedDate = DateTime.Now;
db.SubmitChanges();
}
}
}
}
}
/// <summary>
/// 保存明细项
/// </summary>
private void SaveDetail(string type, Model.Check_CheckSpecial checkSpecial)
{
List <Model.Check_CheckSpecialDetail> detailLists = new List <Model.Check_CheckSpecialDetail>();
JArray teamGroupData = Grid1.GetMergedData();
foreach (JObject teamGroupRow in teamGroupData)
{
JObject values = teamGroupRow.Value <JObject>("values");
Model.Check_CheckSpecialDetail newDetail = new Model.Check_CheckSpecialDetail
{
CheckSpecialDetailId = SQLHelper.GetNewID(),
CheckSpecialId = this.CheckSpecialId,
CheckContent = values.Value <string>("CheckItemName"),
Unqualified = values.Value <string>("Unqualified"),
WorkArea = values.Value <string>("WorkArea"),
};
var getUnit = Funs.DB.Base_Unit.FirstOrDefault(x => x.UnitName == values.Value <string>("UnitName"));
if (getUnit != null)
{
newDetail.UnitId = getUnit.UnitId;
}
var getHandleStep = Funs.DB.Sys_Const.FirstOrDefault(x => x.GroupId == ConstValue.Group_HandleStep && x.ConstText == values.Value <string>("HandleStepStr"));
if (getHandleStep != null)
{
newDetail.HandleStep = getHandleStep.ConstValue;
}
if (values.Value <string>("CompleteStatusName") == "已整改")
{
newDetail.CompleteStatus = true;
newDetail.CompletedDate = DateTime.Now;
}
else
{
newDetail.CompleteStatus = false;
}
var getCheckItem = Funs.DB.Technique_CheckItemSet.FirstOrDefault(x => x.SupCheckItem == this.drpSupCheckItemSet.SelectedValue && x.CheckItemName == newDetail.CheckContent);
if (getCheckItem != null)
{
newDetail.CheckItem = getCheckItem.CheckItemSetId;
}
Check_CheckSpecialDetailService.AddCheckSpecialDetail(newDetail);
if (type == Const.BtnSubmit)
{
if (newDetail.CompleteStatus == false)
{
detailLists.Add(newDetail);
}
}
}
if (detailLists.Count() > 0)
{
////隐患整改单
var getDetail1 = detailLists.Where(x => x.HandleStep == "1");
if (getDetail1.Count() > 0)
{
var getUnitList = getDetail1.Select(x => x.UnitId).Distinct();
foreach (var unitItem in getUnitList)
{
Model.RectifyNoticesItem rectifyNotices = new Model.RectifyNoticesItem
{
ProjectId = checkSpecial.ProjectId,
UnitId = unitItem,
CompleteManId = this.CurrUser.UserId,
CheckManNames = checkSpecial.PartInPersons,
CheckManIds = checkSpecial.PartInPersonIds,
CheckedDate = string.Format("{0:yyyy-MM-dd HH:mm:ss}", checkSpecial.CheckTime),
States = Const.State_0,
};
rectifyNotices.RectifyNoticesItemItem = new List <Model.RectifyNoticesItemItem>();
var getUnitDItem = getDetail1.Where(x => x.UnitId == unitItem);
foreach (var item in getUnitDItem)
{
Model.RectifyNoticesItemItem newRItem = new Model.RectifyNoticesItemItem();
if (!string.IsNullOrEmpty(item.WorkArea))
{
newRItem.WrongContent = item.WorkArea + item.Unqualified;
}
else
{
newRItem.WrongContent = item.Unqualified;
}
if (string.IsNullOrEmpty(rectifyNotices.CheckSpecialDetailId))
{
rectifyNotices.CheckSpecialDetailId = item.CheckSpecialDetailId;
}
else
{
rectifyNotices.CheckSpecialDetailId += "," + item.CheckSpecialDetailId;
}
var getAtt = Funs.DB.AttachFile.FirstOrDefault(x => x.ToKeyId == item.CheckSpecialDetailId);
if (getAtt != null && !string.IsNullOrEmpty(getAtt.AttachUrl))
{
newRItem.PhotoBeforeUrl = getAtt.AttachUrl;
}
rectifyNotices.RectifyNoticesItemItem.Add(newRItem);
}
APIRectifyNoticesService.SaveRectifyNotices(rectifyNotices);
}
}
///处罚单
var getDetail2 = detailLists.Where(x => x.HandleStep == "2");
if (getDetail2.Count() > 0)
{
var getUnitList = getDetail2.Select(x => x.UnitId).Distinct();
foreach (var unitItem in getUnitList)
{
Model.PunishNoticeItem punishNotice = new Model.PunishNoticeItem
{
ProjectId = checkSpecial.ProjectId,
PunishNoticeDate = string.Format("{0:yyyy-MM-dd HH:mm:ss}", checkSpecial.CheckTime),
UnitId = unitItem,
CompileManId = this.CurrUser.UserId,
PunishStates = Const.State_0,
};
var getUnitDItem = getDetail2.Where(x => x.UnitId == unitItem);
foreach (var item in getUnitDItem)
{
Model.RectifyNoticesItemItem newRItem = new Model.RectifyNoticesItemItem();
punishNotice.IncentiveReason += item.Unqualified;
if (string.IsNullOrEmpty(punishNotice.CheckSpecialDetailId))
{
punishNotice.CheckSpecialDetailId = item.CheckSpecialDetailId;
}
else
{
punishNotice.CheckSpecialDetailId += "," + item.CheckSpecialDetailId;
}
var getAtt = Funs.DB.AttachFile.FirstOrDefault(x => x.ToKeyId == item.CheckSpecialDetailId);
if (getAtt != null && !string.IsNullOrEmpty(getAtt.AttachUrl))
{
punishNotice.PunishUrl = getAtt.AttachUrl;
}
}
APIPunishNoticeService.SavePunishNotice(punishNotice);
}
}
///暂停令
var getDetail3 = detailLists.Where(x => x.HandleStep == "3");
if (getDetail3.Count() > 0)
{
var getUnitList = getDetail3.Select(x => x.UnitId).Distinct();
foreach (var unitItem in getUnitList)
{
Model.PauseNoticeItem pauseNotice = new Model.PauseNoticeItem
{
ProjectId = checkSpecial.ProjectId,
UnitId = unitItem,
PauseTime = string.Format("{0:yyyy-MM-dd HH:mm:ss}", checkSpecial.CheckTime),
PauseStates = Const.State_0,
};
var getUnitDItem = getDetail3.Where(x => x.UnitId == unitItem);
foreach (var item in getUnitDItem)
{
Model.RectifyNoticesItemItem newRItem = new Model.RectifyNoticesItemItem();
pauseNotice.ThirdContent += item.Unqualified;
if (string.IsNullOrEmpty(pauseNotice.ProjectPlace))
{
pauseNotice.ProjectPlace = item.WorkArea;
}
else
{
if (!pauseNotice.ProjectPlace.Contains(item.WorkArea))
{
pauseNotice.ProjectPlace += "," + item.WorkArea;
}
}
if (string.IsNullOrEmpty(pauseNotice.CheckSpecialDetailId))
{
pauseNotice.CheckSpecialDetailId = item.CheckSpecialDetailId;
}
else
{
pauseNotice.CheckSpecialDetailId += "," + item.CheckSpecialDetailId;
}
var getAtt = Funs.DB.AttachFile.FirstOrDefault(x => x.ToKeyId == item.CheckSpecialDetailId);
if (getAtt != null && !string.IsNullOrEmpty(getAtt.AttachUrl))
{
pauseNotice.PauseNoticeAttachUrl = getAtt.AttachUrl;
}
}
APIPauseNoticeService.SavePauseNotice(pauseNotice);
}
}
}
}
