/// <summary> /// 设置并新增一条重量检测信息到接口表 /// </summary> /// <returns></returns> public static bool SetAndInsertMATERIAL_QC_INTERFACE(View_QCInfo vqcinfo, out int rint) { bool rbool = false; rint = 0; try { // MATERIAL_QC_INTERFACE qInfo = db.MATERIAL_QC_INTERFACE.First(c => c.CNTR_NO == qc.QCInfo_ID); MATERIAL_QC_INTERFACE entity = new MATERIAL_QC_INTERFACE(); entity.MATERIAL_QC_INTERFACE_ID = vqcinfo.QCInfo_ID; //entity.ALUMINIUM_FOIL=//铝箔纸 (kg) //entity.BITUMEN_PAPER//沥青纸 (kg) entity.CNTR_NO = vqcinfo.CNTR_NO; entity.COMPANY_ID = vqcinfo.COMPANY_ID; // entity.DOUBLE_WAXED_PAPER = //双面蜡纸 (kg) // entity.DRAW_NO==//包号抽样包号码 //entity.GRAY_PAPER=//灰咭涂布纸 (kg) //entity.ITEM_NO//序号 entity.NET_WEIGHT = vqcinfo.QCInfo_BAGWeight; //重量 entity.NET_WEIGHT_UOM = "KG"; //重量单位 entity.OTHER_MATERIAL = vqcinfo.QCInfo_MATERIAL_WEIGHT; //暂时将杂质重量 设置为其它杂质(kg) entity.OTHER_OUTTHROW = vqcinfo.QCInfo_PAPER_WEIGHT; //暂时将杂纸重量 其它杂纸 (kg) entity.PO_NO = vqcinfo.PO_NO; entity.PROD_EXAMINER = vqcinfo.QCInfo_PAPER_EXAMINER; entity.PROD_ID = vqcinfo.PROD_ID; entity.QC_RPT_NO = vqcinfo.QC_PRINTNUM;//化验单(打印编号) entity.REF_NO = vqcinfo.REF_NO; entity.SHIPMENT_NO = vqcinfo.SHIPMENT_NO; //entity.SINGLE_WAXED_PAPER//单面蜡纸 (kg) //entity.SUPPLIER_ID//供货商 // entity.TRANS_TO_DTS_DTTM //entity.TRANS_TO_DTS_FLAG //entity.TRANS_TO_WPIS_DTTM // entity.TRANS_TO_WPIS_FLAG entity.TTL_BALES = vqcinfo.NO_OF_BALES; //总包数 entity.TTL_SAMPLE = vqcinfo.QCInfo_PumpingPackets; //总抽样数 entity.VERSION_NO = "1"; entity.WEIGHT = vqcinfo.QCInfo_BAGWeight; //抽样捆重量 entity.WEIGHT_TICKET_NO = vqcinfo.WEIGHT_TICKET_NO; //TRANS_TO_WPIS_FLAG="Y"DTS过数到废纸检测系统时,该值为“Y”,废纸检测系统不需理会。 TRANS_TO_DTS_FLAG="Y"当质检完成时,DTS会把数据抄走,同时把该字段设为“Y”,废纸检测系统不需理会。 rbool = InsertOneMATERIAL_QC_INTERFACE(entity, out rint); } catch (Exception ex) { } return(rbool); }
/// <summary> /// 设置并新增一条水分检测信息到接口表 /// </summary> /// <returns></returns> public static bool SetAndInsertOCC_MOIST_INTERFACE(View_QCInfo vqcinfo, out int rint) { bool rbool = false; rint = 0; try { OCC_MOIST_INTERFACE entity = new OCC_MOIST_INTERFACE(); decimal wateValue = 0; if (vqcinfo.QCInfo_MOIST_PER_SAMPLE != null) { wateValue = vqcinfo.QCInfo_MOIST_PER_SAMPLE.Value;//水分百分比 } entity.OCC_MOIST_INTERFACE_ID = vqcinfo.QCInfo_ID; entity.REF_NO = "";//REF_NO抽包 entity.CNTR_NO = vqcinfo.CNTR_NO; entity.COMPANY_ID = vqcinfo.COMPANY_ID; // entity.DRAW_NO=//包号 // entity.ITEM_NO=//序号 entity.MOIST_EXAMINER = vqcinfo.QCInfo_MOIST_EXAMINER; entity.MOIST_PER_SAMPLE = vqcinfo.QCInfo_MOIST_PER_SAMPLE; entity.PO_NO = vqcinfo.PO_NO; entity.PRE_DRY_WT = 100; entity.POST_DRY_WT = 100 * (1 - wateValue / 100); entity.PROD_ID = vqcinfo.PROD_ID; entity.QC_RPT_NO = vqcinfo.QC_PRINTNUM;//化验单 entity.REF_NO = vqcinfo.REF_NO; entity.SHIPMENT_NO = vqcinfo.SHIPMENT_NO; //entity.SUPPLIER_ID//供应商编号; //entity.TRANS_TO_DTS_DTTM = vqcinfo.TRANS_TO_DTS_DTTM; // entity.TRANS_TO_DTS_FLAG = vqcinfo.TRANS_TO_DTS_FLAG; // entity.TRANS_TO_WPIS_DTTM = vqcinfo.TRANS_TO_WPIS_DTTM; // entity.TRANS_TO_WPIS_FLAG = vqcinfo.TRANS_TO_WPIS_FLAG; entity.TTL_BALES = vqcinfo.NO_OF_BALES; entity.TTL_SAMPLE = vqcinfo.QCInfo_PumpingPackets; entity.VERSION_NO = "1"; entity.WEIGHT_TICKET_NO = vqcinfo.WEIGHT_TICKET_NO; //TRANS_TO_WPIS_FLAG="Y"DTS过数到废纸检测系统时,该值为“Y”,废纸检测系统不需理会。 TRANS_TO_DTS_FLAG="Y"当质检完成时,DTS会把数据抄走,同时把该字段设为“Y”,废纸检测系统不需理会。 rbool = InsertOneOCC_MOIST_INTERFACE(entity, out rint); } catch (Exception ex) { } return(rbool); }