85 lines
3.5 KiB
C#
85 lines
3.5 KiB
C#
using System.Linq;
|
|
|
|
namespace BLL
|
|
{
|
|
/// <summary>
|
|
/// 分析取样管理
|
|
/// </summary>
|
|
public static class AnalySampService
|
|
{
|
|
/// <summary>
|
|
/// 根据主键获取分析取样管理信息
|
|
/// </summary>
|
|
/// <param name="AnalySampId"></param>
|
|
/// <returns></returns>
|
|
public static Model.ProduceProperty_AnalySamp GetAnalySampById(string AnalySampId)
|
|
{
|
|
return Funs.DB.ProduceProperty_AnalySamp.FirstOrDefault(e => e.AnalySampId == AnalySampId);
|
|
}
|
|
|
|
/// <summary>
|
|
/// 添加分析取样管理信息
|
|
/// </summary>
|
|
/// <param name="AnalySamp"></param>
|
|
public static void AddAnalySamp(Model.ProduceProperty_AnalySamp AnalySamp)
|
|
{
|
|
Model.ProduceProperty_AnalySamp newAnalySamp = new Model.ProduceProperty_AnalySamp();
|
|
newAnalySamp.AnalySampId = AnalySamp.AnalySampId;
|
|
newAnalySamp.ProjectId = AnalySamp.ProjectId;
|
|
newAnalySamp.Code = AnalySamp.Code;
|
|
newAnalySamp.UnitWorkId = AnalySamp.UnitWorkId;
|
|
newAnalySamp.InstallationMan = AnalySamp.InstallationMan;
|
|
newAnalySamp.AnalySampDate = AnalySamp.AnalySampDate;
|
|
newAnalySamp.AnalyRecord = AnalySamp.AnalyRecord;
|
|
newAnalySamp.AnalyCode = AnalySamp.AnalyCode;
|
|
newAnalySamp.TrackingMan = AnalySamp.TrackingMan;
|
|
newAnalySamp.AnalyData = AnalySamp.AnalyData;
|
|
newAnalySamp.AttachUrl = AnalySamp.AttachUrl;
|
|
newAnalySamp.Remark = AnalySamp.Remark;
|
|
Funs.DB.ProduceProperty_AnalySamp.InsertOnSubmit(newAnalySamp);
|
|
Funs.DB.SubmitChanges();
|
|
}
|
|
|
|
/// <summary>
|
|
/// 修改分析取样管理
|
|
/// </summary>
|
|
/// <param name="AnalySamp"></param>
|
|
public static void UpdateAnalySamp(Model.ProduceProperty_AnalySamp AnalySamp)
|
|
{
|
|
Model.ProduceProperty_AnalySamp newAnalySamp = Funs.DB.ProduceProperty_AnalySamp.FirstOrDefault(e => e.AnalySampId == AnalySamp.AnalySampId);
|
|
if (newAnalySamp != null)
|
|
{
|
|
newAnalySamp.Code = AnalySamp.Code;
|
|
newAnalySamp.UnitWorkId = AnalySamp.UnitWorkId;
|
|
newAnalySamp.InstallationMan = AnalySamp.InstallationMan;
|
|
newAnalySamp.AnalySampDate = AnalySamp.AnalySampDate;
|
|
newAnalySamp.AnalyRecord = AnalySamp.AnalyRecord;
|
|
newAnalySamp.AnalyCode = AnalySamp.AnalyCode;
|
|
//newAnalySamp.TrackingMan = AnalySamp.TrackingMan;
|
|
newAnalySamp.AnalyData = AnalySamp.AnalyData;
|
|
newAnalySamp.AttachUrl = AnalySamp.AttachUrl;
|
|
newAnalySamp.Remark = AnalySamp.Remark;
|
|
Funs.DB.SubmitChanges();
|
|
}
|
|
}
|
|
|
|
/// <summary>
|
|
/// 根据主键删除分析取样管理
|
|
/// </summary>
|
|
/// <param name="AnalySampId"></param>
|
|
public static void DeleteAnalySamp(string AnalySampId)
|
|
{
|
|
Model.ProduceProperty_AnalySamp AnalySamp = Funs.DB.ProduceProperty_AnalySamp.FirstOrDefault(e => e.AnalySampId == AnalySampId);
|
|
if (AnalySamp != null)
|
|
{
|
|
if (!string.IsNullOrEmpty(AnalySamp.AttachUrl))
|
|
{
|
|
BLL.UploadAttachmentService.DeleteFile(Funs.RootPath, AnalySamp.AttachUrl);//删除附件
|
|
}
|
|
Funs.DB.ProduceProperty_AnalySamp.DeleteOnSubmit(AnalySamp);
|
|
Funs.DB.SubmitChanges();
|
|
}
|
|
}
|
|
}
|
|
}
|