/// <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;
}
