Exemplo n.º 1
0
        private void button1_Click(object sender, EventArgs e)
        {
            string newitemcode    = txtItemCode.Text;
            string newvendorcode1 = txtVendorCode.Text;
            string newitemsn1     = txtBatchCode.Text;
            string barcode1       = newBarcode;// newitemcode + "^" + newvendorcode1 + "^" + newitemsn1;

            dataConn.ExeSql("insert into data_sn_bom_log select rmes_id,sn,t.company_code,t.plan_code,t.pline_code,t.location_code,t.process_code,t.process_seq,t.item_code,t.item_name,'" + newitemsn1 + "',t.item_qty,t.item_class,t.item_type,'" + newvendorcode1 + "',t.complete_qty,t.confirm_flag,sysdate,t.create_userid,t.replace_flag,t.station_code,t.station_name,'" + barcode1 + "','" + LoginInfo.UserInfo.USER_CODE + "'||'新增批次' from data_sn_bom_temp t where rmes_id='" + BomRmesID + "'");
            dataConnVb dcVb = new dataConnVb();

            if (Type2 == "B")
            {
                dataConn.ExeSql("insert into data_sn_bom_itembatch(rmes_id,bom_rmes_id,item_sn,barcode,item_vendor) values(seq_rmes_id.nextval,'" + BomRmesID + "','" + newitemsn1 + "','" + barcode1 + "','" + newvendorcode1 + "') ");
                try
                {
                    dcVb.ExeSql("update sjsmljb set GYSDM='" + newvendorcode1 + "', LJLSH='" + newitemsn1 + "',GZRQ=TO_DATE(TO_CHAR(SYSDATE,'YYYY-MM-DD'),'YYYY-MM-DD'),rqsj=sysdate,  BCMC='" + LoginInfo.ShiftInfo.SHIFT_NAME + "',   BZMC='" + LoginInfo.TeamInfo.TEAM_NAME + "', YGMC='" + LoginInfo.UserInfo.USER_NAME + "', BARCODE='" + barcode1 + "' where ghtm='" + ProductSn + "' and gzdd='" + PlineCode + "' and ljdm='" + newitemcode + "' and  zdmc='" + LoginInfo.StationInfo.STATION_NAME + "'  ");
                }
                catch { }
            }
            dcVb.CloseConn();
            string gcXlh1      = dataConn.GetValue("select product_series from data_product where sn='" + ProductSn + "' and rownum=1");
            string gcSaveData1 = ProductSn + ";" + "0" + ";" + "AB类零件防错" + ";" + newitemcode + "^" + newvendorcode1 + "^" + newitemsn1 + ";" + " " + ";" + LoginInfo.StationInfo.STATION_NAME + ";" + " " + ";" + PlineCode + ";" + gcXlh1 + ";" + "AB";

            PublicClass.Output_DayData(LoginInfo.StationInfo.STATION_NAME, ProductSn, "sjclb", gcSaveData1);
            (Parent as frmBomItemEdit).Close();
        }
Exemplo n.º 2
0
        private void btnOK_Click(object sender, EventArgs e)
        {
            if (lstSn.SelectedItems.Count != 1)
            {
                MessageBox.Show("请选择要替换的零件", "提示");
                return;
            }
            string oldsn = "";

            try
            {
                oldsn = lstSn.SelectedItem.ToString();
            }
            catch { }
            if (oldsn == "")
            {
                MessageBox.Show("请选择要替换的零件", "提示");
                return;
            }
            DialogResult drt = MessageBox.Show("确认替换?", "提示", MessageBoxButtons.YesNo);

            if (drt == DialogResult.No)
            {
                return;
            }
            //替换旧的数据

            string[] msgbody     = oldsn.Split('^');
            string   itemcode1   = msgbody[0];
            string   vendorcode1 = msgbody[1];
            string   itemsn1     = msgbody[2];

            string newitemcode    = txtItemCode.Text;
            string newvendorcode1 = txtVendorCode.Text;
            string newitemsn1     = txtBatchCode.Text;
            string barcode1       = newBarcode;// newitemcode + "^" + newvendorcode1 + "^" + newitemsn1;

            dataConn.ExeSql("insert into data_sn_bom_log select rmes_id,sn,t.company_code,t.plan_code,t.pline_code,t.location_code,t.process_code,t.process_seq,t.item_code,t.item_name,'" + itemsn1 + "',t.item_qty,t.item_class,t.item_type,'" + vendorcode1 + "',t.complete_qty,t.confirm_flag,sysdate,t.create_userid,t.replace_flag,t.station_code,t.station_name,'" + barcode1 + "','" + LoginInfo.UserInfo.USER_CODE + "'||'替换' from data_sn_bom_temp t where rmes_id='" + BomRmesID + "'");
            dataConnVb dcVb = new dataConnVb();

            if (Type2 == "A" || Type2 == "D")
            {
                dataConn.ExeSql("update data_sn_bom_itemsn set item_sn='" + newitemsn1 + "' , item_vendor='" + newvendorcode1 + "' ,barcode='" + barcode1 + "', work_time=sysdate  where bom_rmes_id='" + BomRmesID + "' and item_sn='" + itemsn1 + "' and item_vendor='" + vendorcode1 + "'  ");
                try
                {
                    dcVb.ExeSql("update sjsmljb set GYSDM='" + newvendorcode1 + "', LJLSH='" + newitemsn1 + "',GZRQ=TO_DATE(TO_CHAR(SYSDATE,'YYYY-MM-DD'),'YYYY-MM-DD'),rqsj=sysdate,  BCMC='" + LoginInfo.ShiftInfo.SHIFT_NAME + "',   BZMC='" + LoginInfo.TeamInfo.TEAM_NAME + "', YGMC='" + LoginInfo.UserInfo.USER_NAME + "', BARCODE='" + barcode1 + "' where ghtm='" + ProductSn + "' and gzdd='" + PlineCode + "' and ljdm='" + newitemcode + "' and  zdmc='" + LoginInfo.StationInfo.STATION_NAME + "'  ");
                }
                catch { }
            }
            else if (Type2 == "B")
            {
                dataConn.ExeSql("update DATA_SN_BOM_ITEMBATCH set item_sn='" + newitemsn1 + "' , item_vendor='" + newvendorcode1 + "' ,barcode='" + barcode1 + "', work_time=sysdate  where bom_rmes_id='" + BomRmesID + "' and item_sn='" + itemsn1 + "' and item_vendor='" + vendorcode1 + "'  ");
                try
                {
                    dcVb.ExeSql("update sjsmljb set GYSDM='" + newvendorcode1 + "', LJLSH='" + newitemsn1 + "',GZRQ=TO_DATE(TO_CHAR(SYSDATE,'YYYY-MM-DD'),'YYYY-MM-DD'),rqsj=sysdate,  BCMC='" + LoginInfo.ShiftInfo.SHIFT_NAME + "',   BZMC='" + LoginInfo.TeamInfo.TEAM_NAME + "', YGMC='" + LoginInfo.UserInfo.USER_NAME + "', BARCODE='" + barcode1 + "' where ghtm='" + ProductSn + "' and gzdd='" + PlineCode + "' and ljdm='" + newitemcode + "' and  zdmc='" + LoginInfo.StationInfo.STATION_NAME + "'  ");
                }
                catch { }
            }
            dcVb.CloseConn();
            string gcXlh1      = dataConn.GetValue("select product_series from data_product where sn='" + ProductSn + "' and rownum=1");
            string gcSaveData1 = ProductSn + ";" + "0" + ";" + "AB类零件防错" + ";" + newitemcode + "^" + newvendorcode1 + "^" + newitemsn1 + ";" + " " + ";" + LoginInfo.StationInfo.STATION_NAME + ";" + " " + ";" + PlineCode + ";" + gcXlh1 + ";" + "AB";

            PublicClass.Output_DayData(LoginInfo.StationInfo.STATION_NAME, ProductSn, "sjclb", gcSaveData1);
            //if (ConfirmBomItem())
            //{
            //    RMESEventArgs thisEventArg = new RMESEventArgs();
            //    thisEventArg.MessageHead = "BOM";
            //    thisEventArg.MessageBody = ProductSn;
            //    SendDataChangeMessage(thisEventArg);
            //    (Parent as frmBomItemEdit).Close();
            //}
            (Parent as frmBomItemEdit).Close();
        }