/// <summary>
/// 添加项目文件
/// </summary>
/// <param name="SafetyDataEItem"></param>
public static void AddSafetyDataEItem(Model.SafetyDataE_SafetyDataEItem SafetyDataEItem)
{
Model.SUBHSSEDB db = Funs.DB;
Model.SafetyDataE_SafetyDataEItem newSafetyDataEItem = new Model.SafetyDataE_SafetyDataEItem
{
SafetyDataEItemId = SafetyDataEItem.SafetyDataEItemId,
SafetyDataEId = SafetyDataEItem.SafetyDataEId,
ProjectId = SafetyDataEItem.ProjectId,
Code = SafetyDataEItem.Code,
SortIndex = SafetyDataEItem.SortIndex,
Title = SafetyDataEItem.Title,
FileContent = SafetyDataEItem.FileContent,
CompileMan = SafetyDataEItem.CompileMan,
CompileDate = SafetyDataEItem.CompileDate,
SubmitDate = SafetyDataEItem.SubmitDate,
Remark = SafetyDataEItem.Remark,
AttachUrl = SafetyDataEItem.AttachUrl,
IsMenu = SafetyDataEItem.IsMenu,
Url = SafetyDataEItem.Url
};
db.SafetyDataE_SafetyDataEItem.InsertOnSubmit(newSafetyDataEItem);
db.SubmitChanges();
/// 更新考核计划 单据提交时间
AddSafetyDataEItemSubmit(newSafetyDataEItem);
}
/// <summary>
/// 单据 更新考核计划 单据提交时间
/// </summary>
/// <param name="SafetyDataEItem"></param>
public static void AddSafetyDataEItemSubmit(Model.SafetyDataE_SafetyDataEItem SafetyDataEItem)
{
var SafetyDataEPlan = from x in Funs.DB.SafetyDataE_SafetyDataEPlan
where x.ProjectId == SafetyDataEItem.ProjectId && x.SafetyDataEId == SafetyDataEItem.SafetyDataEId &&
!x.SubmitDate.HasValue
select x;
if (SafetyDataEPlan.Count() > 0)
{
foreach (var item in SafetyDataEPlan)
{
item.SubmitDate = SafetyDataEItem.SubmitDate;
if (item.SubmitDate <= item.CheckDate) ///准时提交
{
item.RealScore = item.ShouldScore;
}
else ///超期提交
{
item.RealScore = 0;
}
BLL.SafetyDataEPlanService.UpdateSafetyDataEPlan(item);
}
}
}
/// <summary>
/// 根据主键删除信息
/// </summary>
/// <param name="SafetyDataEItemId"></param>
public static void DeleteSafetyDataEItemByID(string SafetyDataEItemId)
{
Model.SUBHSSEDB db = Funs.DB;
Model.SafetyDataE_SafetyDataEItem SafetyDataEItem = db.SafetyDataE_SafetyDataEItem.FirstOrDefault(e => e.SafetyDataEItemId == SafetyDataEItemId);
if (SafetyDataEItem != null)
{
////删除附件表
BLL.CommonService.DeleteAttachFileById(SafetyDataEItem.SafetyDataEItemId);
db.SafetyDataE_SafetyDataEItem.DeleteOnSubmit(SafetyDataEItem);
db.SubmitChanges();
}
}
/// <summary>
/// 修改项目文件
/// </summary>
/// <param name="SafetyDataEItem"></param>
public static void UpdateSafetyDataEItem(Model.SafetyDataE_SafetyDataEItem SafetyDataEItem)
{
Model.SUBHSSEDB db = Funs.DB;
Model.SafetyDataE_SafetyDataEItem newSafetyDataEItem = db.SafetyDataE_SafetyDataEItem.FirstOrDefault(e => e.SafetyDataEItemId == SafetyDataEItem.SafetyDataEItemId);
if (newSafetyDataEItem != null)
{
newSafetyDataEItem.Code = SafetyDataEItem.Code;
newSafetyDataEItem.SortIndex = SafetyDataEItem.SortIndex;
newSafetyDataEItem.Title = SafetyDataEItem.Title;
newSafetyDataEItem.FileContent = SafetyDataEItem.FileContent;
newSafetyDataEItem.CompileMan = SafetyDataEItem.CompileMan;
newSafetyDataEItem.CompileDate = SafetyDataEItem.CompileDate;
//newSafetyDataEItem.SubmitDate = SafetyDataEItem.SubmitDate;
newSafetyDataEItem.Remark = SafetyDataEItem.Remark;
newSafetyDataEItem.AttachUrl = SafetyDataEItem.AttachUrl;
db.SubmitChanges();
/// 更新考核计划 单据提交时间
AddSafetyDataEItemSubmit(newSafetyDataEItem);
}
}
/// <summary>
/// 增加企业管理资料明细
/// </summary>
public static void AddDataToSafetyDataEItem(string dataId, string content, string SafetyDataEId, string url, string projectId)
{
var SafetyDataEItem = BLL.SafetyDataEItemService.GetSafetyDataEItemByID(dataId); ///明细是否存在
if (SafetyDataEItem != null)
{
SafetyDataEItem.Title = content;
BLL.SafetyDataEItemService.UpdateSafetyDataEItem(SafetyDataEItem);
}
else
{
Model.SafetyDataE_SafetyDataEItem newSafetyDataEItem = new Model.SafetyDataE_SafetyDataEItem
{
SafetyDataEItemId = dataId,
SafetyDataEId = SafetyDataEId,
ProjectId = projectId
};
string newCode = BLL.SafetyDataEItemService.GetNewSafetyDataEItemCode(projectId, SafetyDataEId);
newSafetyDataEItem.SortIndex = Funs.GetNewInt(newCode);
var safeData = BLL.SafetyDataEService.GetSafetyDataEBySafetyDataEId(SafetyDataEId);
if (safeData != null && !string.IsNullOrEmpty(safeData.Code))
{
newCode = safeData.Code + "-" + newCode;
}
var project = BLL.ProjectService.GetProjectByProjectId(projectId);
if (project != null)
{
newCode = project.ProjectCode + "-" + newCode;
}
newSafetyDataEItem.Code = newCode;
newSafetyDataEItem.Title = content;
newSafetyDataEItem.CompileDate = System.DateTime.Now; ////单据时间 【todo：要从页面处理】
newSafetyDataEItem.SubmitDate = System.DateTime.Now; ////单据提交时间
newSafetyDataEItem.IsMenu = true;
newSafetyDataEItem.Url = url;
BLL.SafetyDataEItemService.AddSafetyDataEItem(newSafetyDataEItem);
}
}
