/// <summary> /// 根据主键删除信息 /// </summary> /// <param name="personalFolderItemId"></param> public static void DeletePersonalFolderItemByID(string personalFolderItemId) { Model.SUBHSSEDB db = Funs.DB; Model.Personal_PersonalFolderItem personalFolderItem = db.Personal_PersonalFolderItem.FirstOrDefault(e => e.PersonalFolderItemId == personalFolderItemId); { ////删除附件表 BLL.CommonService.DeleteAttachFileById(personalFolderItem.PersonalFolderItemId); db.Personal_PersonalFolderItem.DeleteOnSubmit(personalFolderItem); db.SubmitChanges(); } }
/// <summary> /// 修改个人文件 /// </summary> /// <param name="personalFolderItem"></param> public static void UpdatePersonalFolderItem(Model.Personal_PersonalFolderItem personalFolderItem) { Model.SUBHSSEDB db = Funs.DB; Model.Personal_PersonalFolderItem newPersonalFolderItem = db.Personal_PersonalFolderItem.FirstOrDefault(e => e.PersonalFolderItemId == personalFolderItem.PersonalFolderItemId); if (newPersonalFolderItem != null) { newPersonalFolderItem.Code = personalFolderItem.Code; newPersonalFolderItem.Title = personalFolderItem.Title; newPersonalFolderItem.FileContent = personalFolderItem.FileContent; newPersonalFolderItem.CompileDate = personalFolderItem.CompileDate; newPersonalFolderItem.AttachUrl = personalFolderItem.AttachUrl; db.SubmitChanges(); } }
/// <summary> /// 添加个人文件 /// </summary> /// <param name="personalFolderItem"></param> public static void AddPersonalFolderItem(Model.Personal_PersonalFolderItem personalFolderItem) { Model.SUBHSSEDB db = Funs.DB; Model.Personal_PersonalFolderItem newPersonalFolderItem = new Model.Personal_PersonalFolderItem { PersonalFolderItemId = personalFolderItem.PersonalFolderItemId, PersonalFolderId = personalFolderItem.PersonalFolderId, Code = personalFolderItem.Code, Title = personalFolderItem.Title, FileContent = personalFolderItem.FileContent, CompileDate = personalFolderItem.CompileDate, AttachUrl = personalFolderItem.AttachUrl }; db.Personal_PersonalFolderItem.InsertOnSubmit(newPersonalFolderItem); db.SubmitChanges(); }