83 lines
3.4 KiB
C#
83 lines
3.4 KiB
C#
using System;
|
|
using System.Collections.Generic;
|
|
using System.Linq;
|
|
using System.Text;
|
|
|
|
namespace BLL
|
|
{
|
|
/// <summary>
|
|
/// 项目图片
|
|
/// </summary>
|
|
public static class Project_ProjectPictureService
|
|
{
|
|
/// <summary>
|
|
/// 根据主键获取项目图片
|
|
/// </summary>
|
|
/// <param name="projectPictureId"></param>
|
|
/// <returns></returns>
|
|
public static Model.Project_ProjectPicture GetProjectPictureById(string projectPictureId)
|
|
{
|
|
Model.HJGLDB db = Funs.DB;
|
|
return db.Project_ProjectPicture.FirstOrDefault(e => e.ProjectPictureId == projectPictureId);
|
|
}
|
|
|
|
/// <summary>
|
|
/// 添加项目图片
|
|
/// </summary>
|
|
/// <param name="projectPicture"></param>
|
|
public static void AddProjectPicture(Model.Project_ProjectPicture projectPicture)
|
|
{
|
|
Model.HJGLDB db = Funs.DB;
|
|
Model.Project_ProjectPicture newProjectPicture = new Model.Project_ProjectPicture();
|
|
newProjectPicture.ProjectPictureId = projectPicture.ProjectPictureId;
|
|
newProjectPicture.ProjectPictureCode = projectPicture.ProjectPictureCode;
|
|
newProjectPicture.ProjectPictureName = projectPicture.ProjectPictureName;
|
|
newProjectPicture.AttachUrl = projectPicture.AttachUrl;
|
|
newProjectPicture.Remark = projectPicture.Remark;
|
|
newProjectPicture.CreateDate = projectPicture.CreateDate;
|
|
newProjectPicture.IsShow = projectPicture.IsShow;
|
|
db.Project_ProjectPicture.InsertOnSubmit(newProjectPicture);
|
|
db.SubmitChanges();
|
|
}
|
|
|
|
/// <summary>
|
|
/// 修改项目图片
|
|
/// </summary>
|
|
/// <param name="projectPicture"></param>
|
|
public static void UpdateProjectPicture(Model.Project_ProjectPicture projectPicture)
|
|
{
|
|
Model.HJGLDB db = Funs.DB;
|
|
Model.Project_ProjectPicture newProjectPicture = db.Project_ProjectPicture.FirstOrDefault(e => e.ProjectPictureId == projectPicture.ProjectPictureId);
|
|
if (newProjectPicture != null)
|
|
{
|
|
newProjectPicture.ProjectPictureCode = projectPicture.ProjectPictureCode;
|
|
newProjectPicture.ProjectPictureName = projectPicture.ProjectPictureName;
|
|
newProjectPicture.AttachUrl = projectPicture.AttachUrl;
|
|
newProjectPicture.Remark = projectPicture.Remark;
|
|
newProjectPicture.CreateDate = projectPicture.CreateDate;
|
|
newProjectPicture.IsShow = projectPicture.IsShow;
|
|
db.SubmitChanges();
|
|
}
|
|
}
|
|
|
|
/// <summary>
|
|
/// 根据主键删除项目图片
|
|
/// </summary>
|
|
/// <param name="projectPictureId"></param>
|
|
public static void DeleteProjectPictureById(string projectPictureId)
|
|
{
|
|
Model.HJGLDB db = Funs.DB;
|
|
Model.Project_ProjectPicture projectPicture = db.Project_ProjectPicture.FirstOrDefault(e => e.ProjectPictureId == projectPictureId);
|
|
if (projectPicture != null)
|
|
{
|
|
if (!string.IsNullOrEmpty(projectPicture.AttachUrl))
|
|
{
|
|
BLL.UploadFileService.DeleteFile(Funs.RootPath, projectPicture.AttachUrl);//删除附件
|
|
}
|
|
db.Project_ProjectPicture.DeleteOnSubmit(projectPicture);
|
|
db.SubmitChanges();
|
|
}
|
|
}
|
|
}
|
|
}
|