73 lines
2.6 KiB
C#
73 lines
2.6 KiB
C#
using System;
|
|
using System.Collections.Generic;
|
|
using System.Linq;
|
|
using System.Text;
|
|
|
|
namespace BLL
|
|
{
|
|
public static class AttachFileService
|
|
{
|
|
/// <summary>
|
|
/// 添加附件存储信息
|
|
/// </summary>
|
|
/// <param name="workArea"></param>
|
|
public static void AddAttachFile(Model.AttachFile attachFile)
|
|
{
|
|
Model.HJGLDB db = Funs.DB;
|
|
string newKeyID = SQLHelper.GetNewID(typeof(Model.AttachFile));
|
|
Model.AttachFile newAttachFile = new Model.AttachFile();
|
|
newAttachFile.AttachFileId = newKeyID;
|
|
newAttachFile.ToKeyId = attachFile.ToKeyId;
|
|
newAttachFile.AttachSource = attachFile.AttachSource;
|
|
newAttachFile.AttachUrl = attachFile.AttachUrl;
|
|
newAttachFile.MenuId = attachFile.MenuId;
|
|
|
|
db.AttachFile.InsertOnSubmit(newAttachFile);
|
|
db.SubmitChanges();
|
|
}
|
|
|
|
/// <summary>
|
|
/// 修改附件存储信息
|
|
/// </summary>
|
|
/// <param name="workArea"></param>
|
|
public static void updateAttachFile(Model.AttachFile attachFile)
|
|
{
|
|
Model.HJGLDB db = Funs.DB;
|
|
Model.AttachFile newAttachFile = db.AttachFile.FirstOrDefault(x => x.AttachFileId == attachFile.AttachFileId);
|
|
newAttachFile.ToKeyId = attachFile.ToKeyId;
|
|
newAttachFile.AttachSource = attachFile.AttachSource;
|
|
newAttachFile.AttachUrl = attachFile.AttachUrl;
|
|
newAttachFile.MenuId = attachFile.MenuId;
|
|
Funs.DB.SubmitChanges();
|
|
|
|
}
|
|
|
|
/// <summary>
|
|
/// 根据对应Id删除附件信息及文件存放的物理位置
|
|
/// </summary>
|
|
/// <param name="workAreaId"></param>
|
|
public static void DeleteAttachFile(string rootPath, string toKeyId, string menuId)
|
|
{
|
|
Model.HJGLDB db = Funs.DB;
|
|
Model.AttachFile att = db.AttachFile.FirstOrDefault(e => e.ToKeyId == toKeyId && e.MenuId == menuId);
|
|
if (att != null)
|
|
{
|
|
BLL.UploadFileService.DeleteFile(rootPath, att.AttachUrl);
|
|
db.AttachFile.DeleteOnSubmit(att);
|
|
db.SubmitChanges();
|
|
}
|
|
}
|
|
|
|
/// <summary>
|
|
/// 根据对应主键和菜单获取文件信息
|
|
/// </summary>
|
|
/// <param name="toKey">对应主键</param>
|
|
/// <param name="menuId">对应菜单</param>
|
|
/// <returns>文件信息</returns>
|
|
public static Model.AttachFile GetAttachFile(string toKey,string menuId)
|
|
{
|
|
return Funs.DB.AttachFile.FirstOrDefault(e => e.ToKeyId == toKey && e.MenuId == menuId);
|
|
}
|
|
}
|
|
}
|