/// <summary>
/// 修改安全监督检查整改
/// </summary>
/// <param name="checkRectify"></param>
public static void UpdateCheckRectify(Model.Check_CheckRectify checkRectify)
{
Model.SUBHSSEDB db = Funs.DB;
Model.Check_CheckRectify newCheckRectify = db.Check_CheckRectify.FirstOrDefault(e => e.CheckRectifyId == checkRectify.CheckRectifyId);
if (newCheckRectify != null)
{
newCheckRectify.CheckRectifyCode = checkRectify.CheckRectifyCode;
newCheckRectify.ProjectId = checkRectify.ProjectId;
newCheckRectify.UnitId = checkRectify.UnitId;
newCheckRectify.CheckDate = checkRectify.CheckDate;
newCheckRectify.IssueMan = checkRectify.IssueMan;
newCheckRectify.IssueDate = checkRectify.IssueDate;
newCheckRectify.HandleState = checkRectify.HandleState;
db.SubmitChanges();
}
}
/// <summary>
/// 添加安全监督检查整改
/// </summary>
/// <param name="checkRectify"></param>
public static void AddCheckRectify(Model.Check_CheckRectify checkRectify)
{
Model.SUBHSSEDB db = Funs.DB;
Model.Check_CheckRectify newCheckRectify = new Model.Check_CheckRectify
{
CheckRectifyId = checkRectify.CheckRectifyId,
CheckRectifyCode = checkRectify.CheckRectifyCode,
ProjectId = checkRectify.ProjectId,
UnitId = checkRectify.UnitId,
CheckDate = checkRectify.CheckDate,
IssueMan = checkRectify.IssueMan,
IssueDate = checkRectify.IssueDate,
HandleState = checkRectify.HandleState
};
db.Check_CheckRectify.InsertOnSubmit(newCheckRectify);
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();
}
}
}
}
}
}
}
}
