136 lines
4.2 KiB
C#
136 lines
4.2 KiB
C#
using System;
|
|
using System.Collections.Generic;
|
|
using System.Linq;
|
|
using System.Text;
|
|
|
|
namespace BLL
|
|
{
|
|
/// <summary>
|
|
/// 检测单
|
|
/// </summary>
|
|
public static class Batch_NDEService
|
|
{
|
|
/// <summary>
|
|
/// 根据主键获取检测单
|
|
/// </summary>
|
|
/// <param name="NDEID"></param>
|
|
/// <returns></returns>
|
|
public static Model.Batch_NDE GetNDEById(string NDEID)
|
|
{
|
|
return Funs.DB.Batch_NDE.FirstOrDefault(e => e.NDEID == NDEID);
|
|
}
|
|
|
|
/// <summary>
|
|
/// 根据主键获取检测单视图
|
|
/// </summary>
|
|
/// <param name="NDEID"></param>
|
|
/// <returns></returns>
|
|
public static Model.View_Batch_NDE GetNDEViewById(string NDEID)
|
|
{
|
|
return Funs.DB.View_Batch_NDE.FirstOrDefault(e => e.NDEID == NDEID);
|
|
}
|
|
|
|
/// <summary>
|
|
/// 添加检测单
|
|
/// </summary>
|
|
/// <param name="NDE"></param>
|
|
public static void AddNDE(Model.Batch_NDE NDE)
|
|
{
|
|
Model.HJGLDB db = Funs.DB;
|
|
Model.Batch_NDE newNDE = new Model.Batch_NDE();
|
|
newNDE.NDEID = NDE.NDEID;
|
|
newNDE.TrustBatchId = NDE.TrustBatchId;
|
|
newNDE.ProjectId = NDE.ProjectId;
|
|
newNDE.UnitId = NDE.UnitId;
|
|
newNDE.InstallationId = NDE.InstallationId;
|
|
newNDE.NDEUnit = NDE.NDEUnit;
|
|
newNDE.NDECode = NDE.NDECode;
|
|
newNDE.NDEDate = NDE.NDEDate;
|
|
newNDE.NDEMan = NDE.NDEMan;
|
|
newNDE.AuditDate = NDE.AuditDate;
|
|
newNDE.Remark = NDE.Remark;
|
|
|
|
db.Batch_NDE.InsertOnSubmit(newNDE);
|
|
db.SubmitChanges();
|
|
}
|
|
|
|
/// <summary>
|
|
/// 修改检测单
|
|
/// </summary>
|
|
/// <param name="NDE"></param>
|
|
public static void UpdateNDE(Model.Batch_NDE NDE)
|
|
{
|
|
Model.HJGLDB db = Funs.DB;
|
|
Model.Batch_NDE newNDE = db.Batch_NDE.FirstOrDefault(e => e.NDEID == NDE.NDEID);
|
|
if (newNDE != null)
|
|
{
|
|
newNDE.TrustBatchId = NDE.TrustBatchId;
|
|
newNDE.ProjectId = NDE.ProjectId;
|
|
newNDE.UnitId = NDE.UnitId;
|
|
newNDE.InstallationId = NDE.InstallationId;
|
|
newNDE.NDEUnit = NDE.NDEUnit;
|
|
newNDE.NDECode = NDE.NDECode;
|
|
newNDE.NDEDate = NDE.NDEDate;
|
|
newNDE.NDEMan = NDE.NDEMan;
|
|
newNDE.AuditDate = NDE.AuditDate;
|
|
newNDE.Remark = NDE.Remark;
|
|
db.SubmitChanges();
|
|
}
|
|
}
|
|
|
|
/// <summary>
|
|
/// 根据主键删除检测单
|
|
/// </summary>
|
|
/// <param name="NDEID"></param>
|
|
public static void DeleteNDEById(string NDEID)
|
|
{
|
|
Model.HJGLDB db = Funs.DB;
|
|
Model.Batch_NDE NDE = db.Batch_NDE.FirstOrDefault(e => e.NDEID == NDEID);
|
|
if (NDE != null)
|
|
{
|
|
db.Batch_NDE.DeleteOnSubmit(NDE);
|
|
db.SubmitChanges();
|
|
}
|
|
}
|
|
|
|
/// <summary>
|
|
/// 检测单委托单编号是否存在
|
|
/// </summary>
|
|
/// <param name="pointNo"></param>
|
|
/// <param name="pointId"></param>
|
|
/// <returns></returns>
|
|
public static bool IsExistNDECode(string NDECode, string NDEID, string projectId)
|
|
{
|
|
var q = Funs.DB.Batch_NDE.FirstOrDefault(x => x.NDECode == NDECode && x.ProjectId == projectId && x.NDEID != NDEID);
|
|
if (q != null)
|
|
{
|
|
return true;
|
|
}
|
|
else
|
|
{
|
|
return false;
|
|
}
|
|
}
|
|
|
|
/// <summary>
|
|
/// 检测不合格并且还没下返修通知单的检测单
|
|
/// </summary>
|
|
/// <param name="ndeId"></param>
|
|
/// <returns></returns>
|
|
public static bool IsShowNDECode(string ndeId)
|
|
{
|
|
var q = from x in Funs.DB.View_NoReportNdt
|
|
where x.NDEID == ndeId
|
|
select x;
|
|
if (q.Count() > 0)
|
|
{
|
|
return true;
|
|
}
|
|
else
|
|
{
|
|
return false;
|
|
}
|
|
}
|
|
}
|
|
}
|