private Requirement GetRequirementById(int id)
{
IRequirementService rs = new RequirementService(Settings.Default.db);
Requirement requirement = rs.FindById(id);
return(requirement);
}
//Insere um time novo
public void PostRequirement(RequirementService newRequirement)
{
// newRequirement.IdRequirement = _context.Requirement.Max(p => p.IdRequirement) + 1;
// _context.Requirement.Add(newRequirement);
// _context.SaveChanges();
}
public void TestRequirementValidation()
{
EnvironmentInfo.SetVariable("StringParameter", "hello");
var build = new ParameterBuild();
var targets = ExecutableTargetFactory.CreateAll(build, x => ((IParameterInterface)x).HelloWorld);
// must not throw
RequirementService.ValidateRequirements(build, targets);
}
/// <summary>
/// Create and return an instance of IRequirementService.
/// </summary>
/// <returns></returns>
public static IRequirementService createIRequirementService()
{
var requirementService = new RequirementService(createIRequirementsRepository(), createITaskRepository());
requirementService.DbContext = createIDbContext();
requirementService.GlobalResources = createIResource();
requirementService.Hp = createHp();
return(requirementService);
}
//Atualiza um time
public void PutRequirement(int id, RequirementService upRequirement)
{
// var toUpRequirement = _context.Requirement.Find(id);
// toUpRequirement.Name = upRequirement.Name;
// toUpRequirement.NameStadium = upRequirement.NameStadium;
// _context.Requirements.Update(toUpRequirement);
// _context.SaveChanges();
}
public ActionResult Index(int?page)
{
int pageIndex = PagingHelper.GetPageIndex(page);
RequirementSearchModel q = new RequirementSearchModel();
IRequirementService rs = new RequirementService(Settings.Default.db);
IPagedList <Requirement> requirements = rs.Search(q).ToPagedList(pageIndex, Settings.Default.pageSize);
ViewBag.Query = q;
SetRequirementStatusList(null);
return(View(requirements));
}
public ActionResult Edit([Bind(Include = "id,partNr,orderedDate,requiredDate,quantity,status,derivedFrom,derivedType")] Requirement requirement)
{
//try
//{
IRequirementService rs = new RequirementService(Settings.Default.db);
rs.Update(requirement);
return(RedirectToAction("Index"));
//}
//catch
//{
// return View();
//}
}
public ActionResult Statistics([Bind(Include = "StatisticsType")] RequirementStatisticsSearchModel q)
{
if (string.IsNullOrWhiteSpace(q.StatisticsType))
{
q.StatisticsType = "DERIVEDTYPE";
}
IRequirementService rs = new RequirementService(Settings.Default.db);
List <RequirementStatistics> reqs = rs.SearchStatistics(q);
ViewBag.Query = q;
SetSearchTypeList(q.StatisticsType);
return(View(reqs));
}
public ActionResult Delete(int id, FormCollection collection)
{
//try
//{
IRequirementService rs = new RequirementService(Settings.Default.db);
rs.DeleteById(id);
return(RedirectToAction("Index"));
//}
//catch
//{
// return View();
//}
}
public ActionResult Search([Bind(Include = "PartNr,OrderedDateFrom,OrderedDateTo,RequiredTimeFrom,RequiredTimeTo,QuantityFrom,QuantityTo,Status,DerivedFrom,DerivedType,OrderNr")] RequirementSearchModel q)
{
int pageIndex = 0;
int.TryParse(Request.QueryString.Get("page"), out pageIndex);
pageIndex = PagingHelper.GetPageIndex(pageIndex);
IRequirementService rs = new RequirementService(Settings.Default.db);
IPagedList <Requirement> requirements = rs.Search(q).ToPagedList(pageIndex, Settings.Default.pageSize);
ViewBag.Query = q;
SetRequirementStatusList(q.Status);
return(View("Index", requirements));
}
public ActionResult RequirementGroupSelect(string projectId)
{
RequirementService requirementService = new RequirementService();
List <RequirementGroupDto> lst = new List <RequirementGroupDto>();
List <RequirementGroupDto> list = requirementService.RequirementGroupSearch(projectId, UserInfo.UserId);
foreach (RequirementGroupDto dto in list)
{
if (dto.ApplyStatusCode == "完成")
{
lst.Add(dto);
}
}
return(PartialView("_PartialDemandBookGroupSelect", lst));
// return Json(new { List = list });
}
public async Task GetAllAsyncWhenNoRequirementsReturnsEmptyCollection()
{
//Arrange
var mockRequirementRepository = GetDefaultIRequirementRepositoryInstance();
var mockUnitOfWork = GetDefaultIUnitOfWorkInstance();
var requirementId = 200;
mockRequirementRepository.Setup(r => r.FindById(requirementId))
.Returns(Task.FromResult <Requirement>(null));
var service = new RequirementService(mockRequirementRepository.Object, mockUnitOfWork.Object);
//Act
RequirementResponse result = await service.GetByIdAsync(requirementId);
var message = result.Message;
//Assert
message.Should().Be("Requirement not found");
}
/// <summary>
/// 天花烟罩打印JobCard
/// </summary>
/// <param name="tree"></param>
public void ExecPrintCeilingJobCard(Project objProject, string itemNo, string model)
{
Microsoft.Office.Interop.Excel.Application excelApp = new Microsoft.Office.Interop.Excel.Application();
string excelBookPath = Environment.CurrentDirectory + "\\JobCard_Ceiling.xlsx";
excelApp.Workbooks.Add(excelBookPath);
Microsoft.Office.Interop.Excel.Worksheet workSheet = excelApp.Worksheets[1];
//通用信息
workSheet.Cells[3, 3] = objProject.ODPNo;
workSheet.Cells[4, 3] = objProject.BPONo;
workSheet.Cells[5, 3] = objProject.ProjectName;
workSheet.Cells[6, 3] = objProject.CustomerName;
workSheet.Cells[13, 7] = objProject.ShippingTime.ToShortDateString();
//天花烟罩
workSheet.Cells[7, 3] = itemNo;
workSheet.Cells[8, 3] = model;
workSheet.Cells[20, 4] = "";
workSheet.Cells[20, 5] = "";
workSheet.Cells[20, 6] = "";
workSheet.Cells[20, 7] = "";
workSheet.Cells[20, 8] = "";
//特殊要求
List <string> srList = new RequirementService().GetSpecialRequirementList(objProject.ODPNo);
for (int i = 0; i < srList.Count; i++)
{
if (i > 6)
{
continue;
}
workSheet.Cells[23 + i * 2, 3] = srList[i];
}
////预览
//excelApp.Visible = true;
//excelApp.Sheets.PrintPreview(true);
//打印
workSheet.PrintOutEx();
KillProcess(excelApp);
excelApp = null; //对象置空
GC.Collect(); //垃圾回收机制
}
public override void OnActionExecuting(ActionExecutingContext filterContext)
{
string actionName = filterContext.RequestContext.RouteData.Values["action"].ToString();
if (!string.IsNullOrEmpty(actionName) && (actionName.StartsWith("Save") || actionName == "DeleteDtl"))
{
string RequirementGroupId = filterContext.RequestContext.HttpContext.Request.Form["GroupId"];
if (string.IsNullOrEmpty(RequirementGroupId))
{
RequirementGroupId = filterContext.RequestContext.HttpContext.Request.Form["RequirementGroupId"];
}
string ProjectId = filterContext.RequestContext.HttpContext.Request.Form["ProjectId"];
if (!string.IsNullOrEmpty(RequirementGroupId))
{
RequirementService requirementService = new RequirementService();
string username = ((Mst_UserInfo)filterContext.RequestContext.HttpContext.Session["LoginUser"]).UserId;
RequirementGroupDto group = requirementService.RequirementGroupSearchById(ProjectId, RequirementGroupId, username == null ? "" : username).FirstOrDefault();
//if (group !=null && !string.IsNullOrEmpty(group.ApplyStatusCode))
//{
// throw new Exception("已提交审核或者非本人添加的项目");
//}
// 需求书不能修改的条件由提交审核后不能修改变更为 生成确认单后不能修改
// 只有没有生成确认单可以随时修改
if (group != null && !group.UserChk)
{
// 临时开放权限
// throw new Exception("该需求书非本人填写，不能修改");
}
if (group != null && group.QuotationGroupId != 0)
{
// 临时开放权限
// throw new Exception("该需求书已经生成确认单不能进行修改");
}
}
}
}
public void Setup()
{
_mockReferenceGenerator = new Mock<IReferenceGenerator>();
_mockRepository = new Mock<IRequirementRepository>();
_requirementService = new RequirementService(_mockRepository.Object, _mockReferenceGenerator.Object);
}
/// <summary>
/// 标准烟罩打印JobCard
/// </summary>
/// <param name="tree"></param>
public void ExecPrintHoodJobCard(ModuleTree tree)
{
JobCard objJobCard = new JobCardService().GetJobCard(tree);
//核对信息
if (objJobCard.Length == 0)
{
MessageBox.Show("编号" + objJobCard.Item + "中" + objJobCard.Module + "烟罩数据没有填写，请认真检查", "信息核对");
return;
}
if (objJobCard.LabelImage.Length == 0)
{
MessageBox.Show("编号" + objJobCard.Item + "中" + objJobCard.Module + "JobCard标签截图没有上传，请回到模型树中双击Item上传截图，请认真检查", "信息核对");
return;
}
Microsoft.Office.Interop.Excel.Application excelApp = new Microsoft.Office.Interop.Excel.Application();
string excelBookPath = Environment.CurrentDirectory + "\\JobCard.xlsx";
excelApp.Workbooks.Add(excelBookPath);
Microsoft.Office.Interop.Excel.Worksheet workSheet = excelApp.Worksheets[1];
//插入Item图片
if (objJobCard.LabelImage.Length != 0)
{
Image image = (Image) new Common.SerializeObjectToString().DeserializeObject(objJobCard.LabelImage);
string imagePath = Environment.CurrentDirectory + "\\LabelImage.jpg";
if (File.Exists(imagePath))
{
File.Delete(imagePath); //删除图片
}
else
{
//保存图片到系统目录中
image.Save(imagePath);
//将图片插入excel
workSheet.Shapes.AddPicture(imagePath, Microsoft.Office.Core.MsoTriState.msoFalse,
Microsoft.Office.Core.MsoTriState.msoTrue, 5, 157, 580, 225); //左，上，宽度，高度
workSheet.Shapes.AddPicture(imagePath, Microsoft.Office.Core.MsoTriState.msoFalse,
Microsoft.Office.Core.MsoTriState.msoTrue, 5, 545, 580, 225); //左，上，宽度，高度
//使用完毕后删除保存的图片
File.Delete(imagePath);
}
}
//通用信息
workSheet.Cells[48, 3] = objJobCard.ODPNo;
workSheet.Cells[49, 3] = objJobCard.BPONo;
workSheet.Cells[50, 3] = objJobCard.ProjectName;
workSheet.Cells[51, 3] = objJobCard.CustomerName;
workSheet.Cells[58, 7] = objJobCard.ShippingTime.ToShortDateString();
//标准烟罩
if (objJobCard.HoodType == "Hood")
{
workSheet.Cells[52, 3] = objJobCard.Item + "(" + objJobCard.Module + ")";
workSheet.Cells[53, 3] = objJobCard.Model;
workSheet.Cells[65, 4] = objJobCard.Module;
//长度
if (objJobCard.Model == "KVI" || objJobCard.Model == "KVF" || objJobCard.Model == "UVI" || objJobCard.Model == "UVF" ||
objJobCard.Model == "KWI" || objJobCard.Model == "KWF" || objJobCard.Model == "UWI" || objJobCard.Model == "UWF" ||
objJobCard.Model == "CMOD" || objJobCard.Model == "KVIM" || objJobCard.Model == "UVIM")
{
if (objJobCard.Length != 0 && objJobCard.SidePanel == "BOTH")
{
workSheet.Cells[65, 5] = objJobCard.Length + 100;
}
else if (objJobCard.SidePanel == "MIDDLE")
{
workSheet.Cells[65, 5] = objJobCard.Length;
}
else
{
workSheet.Cells[65, 5] = objJobCard.Length + 50;
}
}
else
{
workSheet.Cells[65, 5] = objJobCard.Length;
}
workSheet.Cells[65, 6] = objJobCard.Deepth;
workSheet.Cells[65, 7] = objJobCard.Height;
workSheet.Cells[65, 8] = objJobCard.SidePanel;
}
//天花烟罩
else if (objJobCard.HoodType == "Ceiling")
{
workSheet.Cells[52, 3] = objJobCard.Item;
workSheet.Cells[53, 3] = objJobCard.Model;
workSheet.Cells[65, 4] = "";
workSheet.Cells[65, 5] = "";
workSheet.Cells[65, 6] = "";
workSheet.Cells[65, 7] = "";
workSheet.Cells[65, 8] = "";
}
//UL烟罩
else
{
}
//特殊要求
List <string> srList = new RequirementService().GetSpecialRequirementList(objJobCard.ODPNo);
for (int i = 0; i < srList.Count; i++)
{
if (i > 6)
{
continue;
}
workSheet.Cells[68 + i * 2, 3] = srList[i];
}
//预览
//excelApp.Visible = true;
//excelApp.Sheets.PrintPreview(true);
//打印
workSheet.PrintOutEx();
KillProcess(excelApp);
excelApp = null; //对象置空
GC.Collect(); //垃圾回收机制
}
