/// <summary>
/// 根据报告号获取附件
/// </summary>
/// <param name="reportId">报告号</param>
/// <returns>附件列表</returns>
public List<Attachment> GetAttachmentById(Guid reportId)
{
using (IUnitOfWork unitwork = MSSqlHelper.DataContext())
{
IAttachmentRepository reportAttachRep = new AttachmentRepository(unitwork);
List<Attachment> attaches = reportAttachRep.GetByMasterNR(reportId.ToString());
return attaches;
}
}
/// <summary>
/// 根据模具号、操作员号、起止日期、页码信息获得模具放行信息
/// </summary>
/// <param name="moldNR">模具号</param>
/// <param name="pageIndex">页码</param>
/// <param name="pageSize">页码数量</param>
/// <returns>模具放行信息列表</returns>
public List<MoldReleaseInfo> GetMoldReleaseInfoByMoldNRInPage(string moldNR, int pageIndex, int pageSize, string operatorId, DateTime? startDate, DateTime? endDate)
{
using (IUnitOfWork unitwork = MSSqlHelper.DataContext())
{
IReportRepository reportRep = new ReportRepository(unitwork);
List<ReportView> reports = reportRep.GetReportViewByMoldNR(moldNR, pageIndex, pageSize, operatorId, startDate, endDate);
IAttachmentRepository attachRep = new AttachmentRepository(unitwork);
List<MoldReleaseInfo> moldReleaseInfos = new List<MoldReleaseInfo>();
foreach (ReportView r in reports)
{
MoldReleaseInfo moldReleaseInfo = new MoldReleaseInfo()
{
TesterName = r.Name,
TesterNR = r.OperatorID,
Date = r.Date,
TargetNR = r.MoldID,
ReportType = r.ReportType,
ReportTypeCN = r.ReportTypeCN,
Attach = attachRep.GetByMasterNR(r.ReportId.ToString())
};
moldReleaseInfos.Add(moldReleaseInfo);
}
return moldReleaseInfos;
}
}
/// <summary>
/// 根据模具号获得模具基本信息
/// </summary>
/// <param name="moldNR">模具号</param>
/// <returns>模具基本信息</returns>
public MoldBaseInfo GetMoldBaseInfoByNR(string moldNR)
{
using (IUnitOfWork unitwork = MSSqlHelper.DataContext())
{
IMoldRepository moldRepostitory = new MoldRepository(unitwork);
IAttachmentRepository attachRep = new AttachmentRepository(unitwork);
IPositionRepository posiRep = new PositionRepository(unitwork);
MoldView m = moldRepostitory.GetMoldViewByMoldNR(moldNR);
if (m != null)
{
MoldBaseInfo mb = new MoldBaseInfo()
{
MoldNR = m.MoldNR,
Name = m.Name,
Type = m.TypeName,
Position = posiRep.GetByFacilictyNR(moldNR).PositionNR,
Producer = m.Producer,
Material = m.Material,
Weight = m.Weight == null ? string.Empty : m.Weight.ToString(),
State = m.State,
StateCN = m.StateCN,
ProjectId = m.ProjectID,
ProjectName = m.ProjectName,
Attach = attachRep.GetByMasterNR(moldNR)
};
return mb;
}
return null;
}
}
