예제 #1
0
        /// <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);
        }
예제 #2
0
        /// <summary>
        /// 新增一条接口表重量记录
        /// </summary>
        /// <param name="qcRecord">MATERIAL_QC_INTERFACE实体</param>
        /// <param name="rint">新增后自动增长编号</param>
        /// <returns></returns>
        public static bool InsertOneMATERIAL_QC_INTERFACE(MATERIAL_QC_INTERFACE qcRecord, out int rint)
        {
            rint = 0;
            bool rbool = true;

            using (DCQUALITYDataContext db = new DCQUALITYDataContext())
            {
                try
                {
                    db.MATERIAL_QC_INTERFACE.InsertOnSubmit(qcRecord);
                    db.SubmitChanges();
                    rbool = true;
                }
                catch
                {
                    rbool = false;
                }
                finally { db.Connection.Close(); }
            }
            return(rbool);
        }