/// <summary> /// 判断是否存在 /// </summary> /// <param name="model">数据</param> /// <returns></returns> private bool IsExist(SampleItemsIqcRecordModel model) { return(irep.Entities.Where(e => e.OrderID == model.OrderID & e.SampleMaterial == model.SampleMaterial & e.SampleItem == model.SampleItem ).ToList().Count > 0); }
/// <summary> /// 得到IQC抽样项次 (单身) /// </summary> /// <param name="orderId">ERP单号</param> /// <param name="sampleMaterial">物料料号</param> /// <returns></returns> public List <SampleItemsIqcRecordModel> GetPringSampleItemBy(string orderId, string sampleMaterial) { List <SampleItemsIqcRecordModel> models = irep.Entities.Where(e => e.OrderID == orderId & e.SampleMaterial == sampleMaterial).ToList(); if (models == null || models.Count <= 0) { // 记录测试方法 正常 放宽 加严 string CheckWay = SampleManger.SampleItermLawManger.GetCheckWayBy(sampleMaterial, "IQC"); SampleItemsIqcRecordModel model = null; //单子的物料信息 var productInfo = GetPuroductSupplierInfo(orderId).Where(e => e.ProductID == sampleMaterial).FirstOrDefault(); var SampleItem = SampleManger.MaterialSampleItemsManager.GetMaterilalSampleItemBy(productInfo.ProductID); foreach (var f in SampleItem) { //productInfo.ProduceNumber var mm = SampleManger.SampleRuleTableManger.getSampleNumberBy(f.CheckWay, f.CheckLevel, f.Grade, 0); if (f.SampleItem.Contains("盐雾")) { if (!JudgeYwTest(productInfo.ProductID, productInfo.ProduceInDate)) { if (JudgeMaterialTwoYearIsRecord(f.SampleMaterial)) { continue; } } } if (f.SampleItem.Contains("全尺寸")) { if (JudgeMaterialTwoYearIsRecord(f.SampleMaterial)) { continue; } } model = new SampleItemsIqcRecordModel() { OrderID = productInfo.OrderID, SampleMaterial = productInfo.ProductID, SampleMaterialDrawID = productInfo.ProductDrawID, SampleMaterialName = productInfo.ProductName, SampleMaterialInDate = productInfo.ProduceInDate, SampleMaterialSpec = productInfo.ProductStandard, SampleMaterialNumber = productInfo.ProduceNumber, SampleMaterialSupplier = productInfo.ProductSupplier, CheckLevel = f.CheckLevel, CheckMethod = f.CheckMethod, CheckWay = CheckWay, EquipmentID = f.EquipmetnID, Grade = f.Grade, SampleItem = f.SampleItem, SizeSpec = f.SizeSpec, SizeSpecDown = f.SizeSpecDown, SizeSpecUP = f.SizeSpecUP, AcceptGradeNumber = mm.AcceptGradeNumber.ToDouble(), CheckNumber = mm.CheckNumber.ToDouble(), RefuseGradeNumber = mm.RefuseGradeNumber.ToDouble(), PrintCount = 1, }; models.Add(model); } } return(models); }
/// <summary> /// 填充上下差值 /// </summary> /// <param name="xlsSheet"></param> /// <param name="IdNumStartRowIndex"></param> /// <param name="rowIndeX"></param> /// <param name="model"></param> private void SetMaterialInfoToXlsCell(Excel.Worksheet xlsSheet, int IdNumStartRowIndex, int rowIndeX, SampleItemsIqcRecordModel model) { int IdNumStopRowIndex = IdNumStartRowIndex + rowIndeX - 1; setValueToXlsCell(xlsSheet, IdNumStartRowIndex, IdNumStopRowIndex, "A", model.SampleItem); setValueToXlsCell(xlsSheet, IdNumStartRowIndex, IdNumStopRowIndex, "D", model.CheckLevel); if (model.Grade.Contains("=")) { setValueToXlsCell(xlsSheet, IdNumStartRowIndex, IdNumStopRowIndex, "E", model.Grade + ""); } else { setValueToXlsCell(xlsSheet, IdNumStartRowIndex, IdNumStopRowIndex, "E", "AQL=" + model.Grade + ""); } setDEmethod(xlsSheet, IdNumStartRowIndex, IdNumStopRowIndex); if (model.CheckNumber == 0) { setValueToXlsCell(xlsSheet, IdNumStartRowIndex, IdNumStopRowIndex, "F", ""); } else { string mm = model.CheckNumber.ToString() + "/" + model.AcceptGradeNumber.ToString() + "/" + model.RefuseGradeNumber.ToString(); setValueToXlsCell(xlsSheet, IdNumStartRowIndex, IdNumStopRowIndex, "F", mm); } string CheckMethod = ""; if (model.CheckMethod != null) { CheckMethod = model.CheckMethod.ToString(); } setValueToXlsCell(xlsSheet, IdNumStartRowIndex, IdNumStopRowIndex, "G", CheckMethod); string EquipmetID = ""; if (model.EquipmentID != null) { EquipmetID = model.EquipmentID.ToString(); } setValueToXlsCell(xlsSheet, IdNumStartRowIndex, IdNumStopRowIndex, "H", EquipmetID); setValueToXlsCell(xlsSheet, IdNumStartRowIndex, IdNumStopRowIndex, "I", ""); ResetXlsCellStatus(xlsSheet, IdNumStartRowIndex, rowIndeX - 1, "A", "J", "V"); xlEdgeLeftLine(xlsSheet, IdNumStartRowIndex, IdNumStopRowIndex, 13, 'J'); }
private List <SampleItemsIqcRecordModel> GetFQCPritnItem(long Nunmber, string orderId, string oldorderId) { List <SampleItemsIqcRecordModel> models = irep.Entities.Where(e => e.OrderID == orderId).ToList(); if (models == null || models.Count() <= 0) { if (oldorderId != "") { oldorderId = "上次检验文号:" + oldorderId; } ; // 制令单对应一个物料料号 var productInfo = GetPuroductSupplierInfo(orderId).FirstOrDefault(); var SampleMaterialParmaterS = SampleManger.MaterialSampleItemsManager.GetMaterilalSampleItemBy(productInfo.ProductID) .Where(e => e.SampleClass.Contains("FQC") & e.MateriaAttribute == "成品"); if (SampleMaterialParmaterS == null || SampleMaterialParmaterS.Count() == 0) { return(null); } foreach (var Parmater in SampleMaterialParmaterS) { // productInfo.ProduceNumber var SampleNumber = SampleManger.SampleRuleTableManger.getSampleNumberBy(Parmater.CheckWay, Parmater.CheckLevel, Parmater.Grade, 0); string ProductName = productInfo.ProductName; if (!(JudgeMaterialTwoYearIsRecord(Parmater.SampleMaterial))) { //如果第一次检验抽样数理加大一倍 double i = SampleNumber.CheckNumber.ToDouble(); i = i * 2; ProductName += "/第一次检验"; //抽样数量不能超过购入数量 if (i > Nunmber) { i = Nunmber; } } SampleItemsIqcRecordModel model = new SampleItemsIqcRecordModel { OrderID = orderId, SampleMaterialName = ProductName, SampleMaterialSpec = productInfo.ProductStandard, SampleMaterialSupplier = Parmater.Department, SampleMaterialDrawID = productInfo.ProductDrawID + "/" + Parmater.CheckStandard, SampleMaterialNumber = Nunmber, SampleMaterialInDate = Convert.ToDateTime(productInfo.ProduceInDate), SampleMaterial = Parmater.SampleMaterial, SampleItem = Parmater.SampleItem, EquipmentID = Parmater.EquipmetnID, CheckMethod = Parmater.CheckMethod, CheckLevel = Parmater.CheckLevel, Grade = Parmater.Grade, CheckWay = Parmater.CheckWay, SizeSpec = "缺点类别:" + Parmater.SizeSpec, SizeSpecUP = oldorderId, SizeSpecDown = productInfo.ProductSupplier, CheckNumber = SampleNumber.CheckNumber.ToDouble(), AcceptGradeNumber = SampleNumber.AcceptGradeNumber.ToDouble(), RefuseGradeNumber = SampleNumber.RefuseGradeNumber.ToDouble(), PrintCount = 1 }; models.Add(model); } } return(models); //QCMS_IQCSampleRecordTable addmodelssss = new QCMS_IQCSampleRecordTable //{ // OrderID = orderid, // SampleMaterial = qqq.ProductID, // SampleMaterialName = qqq.ProductName, // SampleMaterialSpec = qqq.ProductStandard, // SampleMaterialSupplier = Department[0], // SampleMaterialDrawID = qqq.ProductDrawID, // SampleMaterialNumber = Nunmber, // SampleMaterialInDate = Convert.ToDateTime(qqq.ProduceInDate), // CheckWay = CheckWays[0], // InPutDate = DateTime.Now, // SampleNumber = Convert.ToInt16(CheckNumbers.Max()) //}; //SpamleRecordDal mmmm = new SpamleRecordDal(); //mmmm.Addmodel(addmodelssss); //return 0; }