/// <summary>
/// 删除
/// </summary>
/// <param name="ThemeActivitiesId"></param>
public static void DeleteThemeActivitiesById(string ThemeActivitiesId)
{
Model.SUBHSSEDB db = Funs.DB;
Model.SafetyActivities_ThemeActivities ThemeActivities = db.SafetyActivities_ThemeActivities.FirstOrDefault(e => e.ThemeActivitiesId == ThemeActivitiesId);
if (ThemeActivities != null)
{
if (!string.IsNullOrEmpty(ThemeActivities.AttachUrl))
{
BLL.UploadAttachmentService.DeleteFile(Funs.RootPath, ThemeActivities.AttachUrl);//删除附件
}
db.SafetyActivities_ThemeActivities.DeleteOnSubmit(ThemeActivities);
db.SubmitChanges();
}
}
/// <summary>
/// 修改
/// </summary>
/// <param name="ThemeActivities"></param>
public static void UpdateThemeActivities(Model.SafetyActivities_ThemeActivities ThemeActivities)
{
Model.SUBHSSEDB db = Funs.DB;
Model.SafetyActivities_ThemeActivities newThemeActivities = db.SafetyActivities_ThemeActivities.FirstOrDefault(e => e.ThemeActivitiesId == ThemeActivities.ThemeActivitiesId);
if (newThemeActivities != null)
{
newThemeActivities.Title = ThemeActivities.Title;
newThemeActivities.CompileDate = ThemeActivities.CompileDate;
newThemeActivities.CompileMan = ThemeActivities.CompileMan;
newThemeActivities.Remark = ThemeActivities.Remark;
newThemeActivities.AttachUrl = ThemeActivities.AttachUrl;
newThemeActivities.SeeFile = ThemeActivities.SeeFile;
db.SubmitChanges();
}
}
/// <summary>
/// 添加主题安全活动
/// </summary>
/// <param name="ThemeActivities"></param>
public static void AddThemeActivities(Model.SafetyActivities_ThemeActivities ThemeActivities)
{
Model.SUBHSSEDB db = Funs.DB;
Model.SafetyActivities_ThemeActivities newThemeActivities = new Model.SafetyActivities_ThemeActivities
{
ThemeActivitiesId = ThemeActivities.ThemeActivitiesId,
ProjectId = ThemeActivities.ProjectId,
Title = ThemeActivities.Title,
CompileDate = ThemeActivities.CompileDate,
CompileMan = ThemeActivities.CompileMan,
Remark = ThemeActivities.Remark,
AttachUrl = ThemeActivities.AttachUrl,
SeeFile = ThemeActivities.SeeFile
};
db.SafetyActivities_ThemeActivities.InsertOnSubmit(newThemeActivities);
db.SubmitChanges();
}
