/// <summary>
/// 获取HSE日志信息
/// </summary>
/// <param name="projectId"></param>
/// <param name="userId"></param>
/// <param name="diaryDate"></param>
/// <returns></returns>
public static Model.HSEDiaryItem getHSEDiary(string projectId, string userId, string diaryDate)
{
DateTime?getDiaryDate = Funs.GetNewDateTime(diaryDate);
Model.HSEDiaryItem getItem = new Model.HSEDiaryItem();
if (getDiaryDate.HasValue && !string.IsNullOrEmpty(projectId) && !string.IsNullOrEmpty(userId))
{
var getFlowOperteList = ReturnFlowOperteList(projectId, userId, getDiaryDate.Value);
getItem.ProjectId = projectId;
getItem.UserId = userId;
getItem.UserName = UserService.GetUserNameByUserId(userId);
getItem.DiaryDate = diaryDate;
getItem.HSEDiaryId = SQLHelper.GetNewID();
getItem.Value1 = getValues1(getFlowOperteList, projectId, userId, getDiaryDate.Value);
getItem.Value2 = getValues2(getFlowOperteList, projectId, userId, getDiaryDate.Value);
getItem.Value3 = getValues3(getFlowOperteList, projectId, userId, getDiaryDate.Value);
getItem.Value4 = getValues4(getFlowOperteList, projectId, userId, getDiaryDate.Value);
getItem.Value5 = getValues5(getFlowOperteList, projectId, userId, getDiaryDate.Value);
getItem.Value6 = getValues6(getFlowOperteList, projectId, userId, getDiaryDate.Value);
getItem.Value7 = getValues7(getFlowOperteList, projectId, userId, getDiaryDate.Value);
getItem.Value8 = getValues8(getFlowOperteList, projectId, userId, getDiaryDate.Value);
getItem.Value9 = getValues9(getFlowOperteList, projectId, userId, getDiaryDate.Value);
getItem.Value10 = getValues10(getFlowOperteList, projectId, userId, getDiaryDate.Value);
var getInfo = Funs.DB.Project_HSEDiary.FirstOrDefault(x => x.UserId == userId && x.DiaryDate == getDiaryDate);
if (getInfo != null)
{
getItem.HSEDiaryId = getInfo.HSEDiaryId;
getItem.DailySummary = getInfo.DailySummary;
getItem.TomorrowPlan = getInfo.TomorrowPlan;
}
}
return(getItem);
}
/// <summary>
/// 保存HSE日志
/// </summary>
/// <param name="item"></param>
public static void SaveHSEDiary(Model.HSEDiaryItem item)
{
DeleteHSEDiary(item.HSEDiaryId);
using (Model.SUBHSSEDB db = new Model.SUBHSSEDB(Funs.ConnString))
{
Model.Project_HSEDiary newHSEDiary = new Model.Project_HSEDiary
{
HSEDiaryId = item.HSEDiaryId,
ProjectId = item.ProjectId,
DiaryDate = Funs.GetNewDateTime(item.DiaryDate),
UserId = item.UserId,
DailySummary = item.DailySummary,
TomorrowPlan = item.TomorrowPlan,
Value1 = item.Value1,
Value2 = item.Value2,
Value3 = item.Value3,
Value4 = item.Value4,
Value5 = item.Value5,
Value6 = item.Value6,
Value7 = item.Value7,
Value8 = item.Value8,
Value9 = item.Value9,
Value10 = item.Value10,
};
if (string.IsNullOrEmpty(newHSEDiary.HSEDiaryId))
{
newHSEDiary.HSEDiaryId = SQLHelper.GetNewID();
}
db.Project_HSEDiary.InsertOnSubmit(newHSEDiary);
db.SubmitChanges();
}
}
