/// <summary>
/// 添加项目文件
/// </summary>
/// <param name="SafetyDataItem"></param>
public static void AddSafetyDataItem(Model.SafetyData_SafetyDataItem SafetyDataItem)
{
Model.SUBHSSEDB db = Funs.DB;
Model.SafetyData_SafetyDataItem newSafetyDataItem = new Model.SafetyData_SafetyDataItem
{
SafetyDataItemId = SafetyDataItem.SafetyDataItemId,
SafetyDataId = SafetyDataItem.SafetyDataId,
ProjectId = SafetyDataItem.ProjectId,
Code = SafetyDataItem.Code,
SortIndex = SafetyDataItem.SortIndex,
Title = SafetyDataItem.Title,
FileContent = SafetyDataItem.FileContent,
CompileMan = SafetyDataItem.CompileMan,
CompileDate = SafetyDataItem.CompileDate,
SubmitDate = SafetyDataItem.SubmitDate,
Remark = SafetyDataItem.Remark,
AttachUrl = SafetyDataItem.AttachUrl,
IsMenu = SafetyDataItem.IsMenu,
Url = SafetyDataItem.Url
};
db.SafetyData_SafetyDataItem.InsertOnSubmit(newSafetyDataItem);
db.SubmitChanges();
/// 更新考核计划 单据提交时间
AddSafetyDataItemSubmit(newSafetyDataItem);
}
/// <summary>
/// 单据 更新考核计划 单据提交时间
/// </summary>
/// <param name="safetyDataItem"></param>
public static void AddSafetyDataItemSubmit(Model.SafetyData_SafetyDataItem safetyDataItem)
{
var safetyDataPlan = from x in Funs.DB.SafetyData_SafetyDataPlan
where x.ProjectId == safetyDataItem.ProjectId && x.SafetyDataId == safetyDataItem.SafetyDataId &&
safetyDataItem.CompileDate >= x.RealStartDate && safetyDataItem.CompileDate <= x.RealEndDate &&
!x.SubmitDate.HasValue
select x;
if (safetyDataPlan.Count() > 0)
{
foreach (var item in safetyDataPlan)
{
item.SubmitDate = safetyDataItem.SubmitDate;
if (item.SubmitDate <= item.CheckDate) ///准时提交
{
item.RealScore = item.ShouldScore;
}
else ///超期提交
{
item.RealScore = 0;
}
BLL.SafetyDataPlanService.UpdateSafetyDataPlan(item);
}
}
}
/// <summary>
/// 根据主键删除信息
/// </summary>
/// <param name="safetyDataItemId"></param>
public static void DeleteSafetyDataItemByID(string safetyDataItemId)
{
Model.SUBHSSEDB db = Funs.DB;
Model.SafetyData_SafetyDataItem SafetyDataItem = db.SafetyData_SafetyDataItem.FirstOrDefault(e => e.SafetyDataItemId == safetyDataItemId);
if (SafetyDataItem != null)
{
////删除附件表
BLL.CommonService.DeleteAttachFileById(SafetyDataItem.SafetyDataItemId);
db.SafetyData_SafetyDataItem.DeleteOnSubmit(SafetyDataItem);
db.SubmitChanges();
}
}
/// <summary>
/// 修改项目文件
/// </summary>
/// <param name="SafetyDataItem"></param>
public static void UpdateSafetyDataItem(Model.SafetyData_SafetyDataItem SafetyDataItem)
{
Model.SUBHSSEDB db = Funs.DB;
Model.SafetyData_SafetyDataItem newSafetyDataItem = db.SafetyData_SafetyDataItem.FirstOrDefault(e => e.SafetyDataItemId == SafetyDataItem.SafetyDataItemId);
if (newSafetyDataItem != null)
{
newSafetyDataItem.Code = SafetyDataItem.Code;
newSafetyDataItem.SortIndex = SafetyDataItem.SortIndex;
newSafetyDataItem.Title = SafetyDataItem.Title;
newSafetyDataItem.FileContent = SafetyDataItem.FileContent;
newSafetyDataItem.CompileMan = SafetyDataItem.CompileMan;
newSafetyDataItem.CompileDate = SafetyDataItem.CompileDate;
//newSafetyDataItem.SubmitDate = SafetyDataItem.SubmitDate;
newSafetyDataItem.Remark = SafetyDataItem.Remark;
newSafetyDataItem.AttachUrl = SafetyDataItem.AttachUrl;
db.SubmitChanges();
/// 更新考核计划 单据提交时间
AddSafetyDataItemSubmit(newSafetyDataItem);
}
}
/// <summary>
/// 增加企业管理资料明细
/// </summary>
public static void AddDataToSafetyDataItem(string dataId, string content, string safetyDataId, string url, string projectId)
{
var safetyDataItem = BLL.SafetyDataItemService.GetSafetyDataItemByID(dataId); ///明细是否存在
if (safetyDataItem != null)
{
safetyDataItem.Title = content;
BLL.SafetyDataItemService.UpdateSafetyDataItem(safetyDataItem);
}
else
{
Model.SafetyData_SafetyDataItem newSafetyDataItem = new Model.SafetyData_SafetyDataItem
{
SafetyDataItemId = dataId,
SafetyDataId = safetyDataId,
ProjectId = projectId
};
string newCode = BLL.SafetyDataItemService.GetNewSafetyDataItemCode(projectId, safetyDataId);
newSafetyDataItem.SortIndex = Funs.GetNewInt(newCode);
var safeData = BLL.SafetyDataService.GetSafetyDataBySafetyDataId(safetyDataId);
if (safeData != null && !string.IsNullOrEmpty(safeData.Code))
{
newCode = safeData.Code + "-" + newCode;
}
var project = BLL.ProjectService.GetProjectByProjectId(projectId);
if (project != null)
{
newCode = project.ProjectCode + "-" + newCode;
}
newSafetyDataItem.Code = newCode;
newSafetyDataItem.Title = content;
newSafetyDataItem.CompileDate = System.DateTime.Now; ////单据时间 【todo：要从页面处理】
newSafetyDataItem.SubmitDate = System.DateTime.Now; ////单据提交时间
newSafetyDataItem.IsMenu = true;
newSafetyDataItem.Url = url;
BLL.SafetyDataItemService.AddSafetyDataItem(newSafetyDataItem);
}
}
