/// <summary>
/// 添加安全监督检查整改明细信息
/// </summary>
/// <param name="CheckRectifyItem"></param>
public static void UpdateCheckRectifyItem(Model.Check_CheckRectifyItem CheckRectifyItem)
{
Model.SUBHSSEDB db = Funs.DB;
var newCheckRectifyItem = db.Check_CheckRectifyItem.FirstOrDefault(x => x.CheckRectifyItemId == CheckRectifyItem.CheckRectifyItemId);
if (newCheckRectifyItem != null)
{
newCheckRectifyItem.OrderEndPerson = CheckRectifyItem.OrderEndPerson;
newCheckRectifyItem.RealEndDate = CheckRectifyItem.RealEndDate;
newCheckRectifyItem.Verification = CheckRectifyItem.Verification;
db.SubmitChanges();
}
}
/// <summary>
/// 安全监督检查整改从集团公司提取
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private static void poxy_GetCheck_CheckRectifyListToSUBCompleted(object sender, HSSEService.GetCheck_CheckRectifyListToSUBCompletedEventArgs e)
{
int count = 0;
if (e.Error == null && e.Result != null)
{
List <string> ids = new List <string>();
var items = e.Result;
if (items.Count() > 0)
{
count = items.Count();
foreach (var item in items)
{
if (!ids.Contains(item.CheckRectifyId))
{
var newRectify = BLL.CheckRectifyService.GetCheckRectifyByCheckRectifyId(item.CheckRectifyId);
if (newRectify == null)
{
ids.Add(item.CheckRectifyId);
Model.Check_CheckRectify newCheckRectify = new Model.Check_CheckRectify
{
CheckRectifyId = item.CheckRectifyId,
CheckRectifyCode = item.CheckRectifyCode,
ProjectId = item.ProjectId,
UnitId = item.UnitId,
CheckDate = item.CheckDate,
IssueMan = item.IssueMan,
IssueDate = item.IssueDate,
HandleState = item.HandleState
};
Funs.DB.Check_CheckRectify.InsertOnSubmit(newCheckRectify);
Funs.DB.SubmitChanges();
//获取对应主表主键的明细集合
var table5Items = items.Where(x => x.CheckRectifyId == item.CheckRectifyId);
foreach (var newItem in table5Items)
{
var oldItem5 = Funs.DB.Check_CheckInfo_Table5Item.FirstOrDefault(x => x.ID == newItem.Table5ItemId);
if (oldItem5 == null)
{
Model.Check_CheckInfo_Table5Item newCheckRectifyItem = new Model.Check_CheckInfo_Table5Item
{
ID = newItem.Table5ItemId,
SortIndex = newItem.SortIndex,
WorkType = newItem.WorkType,
DangerPoint = newItem.DangerPoint,
RiskExists = newItem.RiskExists,
IsProject = newItem.IsProject,
CheckMan = newItem.CheckMan,
SubjectUnitMan = newItem.SubjectUnitMan
};
Funs.DB.Check_CheckInfo_Table5Item.InsertOnSubmit(newCheckRectifyItem);
Funs.DB.SubmitChanges();
////上传附件
if (!string.IsNullOrEmpty(newItem.AttachFileId))
{
BLL.FileInsertService.InsertAttachFile(newItem.AttachFileId, newItem.Table5ItemId, newItem.AttachSource, newItem.AttachUrl, newItem.FileContext);
}
}
var oldItem = BLL.CheckRectifyItemService.GetCheckRectifyItemByCheckRectifyItemId(newItem.CheckRectifyItemId);
if (oldItem == null)
{
Model.Check_CheckRectifyItem newCheckRectifyItem = new Model.Check_CheckRectifyItem
{
CheckRectifyItemId = newItem.CheckRectifyItemId,
CheckRectifyId = newItem.CheckRectifyId,
Table5ItemId = newItem.Table5ItemId,
ConfirmMan = newItem.ConfirmMan,
ConfirmDate = newItem.ConfirmDate,
OrderEndDate = newItem.OrderEndDate,
OrderEndPerson = newItem.OrderEndPerson,
RealEndDate = newItem.RealEndDate
};
Funs.DB.Check_CheckRectifyItem.InsertOnSubmit(newCheckRectifyItem);
Funs.DB.SubmitChanges();
}
}
}
}
}
}
}
}
