//扫描条码 private void BarCode_Scan() { try { string RFID_ID = Barcode.scan(); if (RFID_ID == "") { throw new Exception("扫描失败,RFID号为空!"); } if (RFID_ID.Substring(0, 1) == "2")//物料卡 { if (!CommonClass.ValidateRFID(RFID_ID)) { throw new Exception("此卡已经被回收!"); } txtRFID.Text = RFID_ID; string DeviceName = FunPublic.GetDeviceName(); DataTable dt = FunPublic.GetDt("exec [PDA_WorkshopGRQuery] '" + RFID_ID + "','" + DeviceName.Substring(1, DeviceName.Length - 1) + "'"); if (dt.Rows.Count > 0) { foreach (DataRow dr in dt.Rows) { txtEBNum.Text = dr["EBDOC"].ToString(); txtPackageCode.Text = dr["PackageCode"].ToString(); txtSN.Text = dr["SN"].ToString(); txtQuantity.Text = dr["QtyinPackage"].ToString(); cmbStep.Items.Add(dr["STEPCode"].ToString() + "-" + dr["STEPName"].ToString()); cmbStep.Text = dr["STEPCode"].ToString() + "-" + dr["STEPName"].ToString(); txtMappingCode.Text = dr["MappingCode"].ToString(); txtRouMap.Text = dr["roumap"].ToString(); txtRouMapName.Text = dr["roumapName"].ToString(); } } else { throw new Exception("此车间已收货!"); } } else if (RFID_ID.Substring(0, 1) == "1") {//员工卡 txtStaff.Text = RFID_ID; } CommonClass.PlaySoundBeep(); } catch (Exception ex) { txtRFID.Text = ""; txtEBNum.Text = ""; txtPackageCode.Text = ""; txtSN.Text = ""; txtQuantity.Text = ""; cmbStep.Items.Clear(); cmbStep.Text = ""; MessageBox.Show(ex.Message); } }
//刷卡 private void Scan() { byte[] pszData = new byte[25]; byte[] data = new byte[1]; if (RFID_15693.ScanSingleTag(ref data)) { } else { throw new Exception("扫描失败,请确认是否是15693标签,并确认标签是否处于RFID感应区!"); } string RFID_ID = RFID_15693.RFID_ID(); if (RFID_ID == "") { throw new Exception("扫描失败,RFID号为空!"); } int res = RFID_15693.RF_ISO15693_getSystemInformation(0, data, 0, pszData); if (res != 0) { throw new Exception("扫描失败,获取卡类型时出错!"); } if (BitConverter.ToString(pszData, 11, 1) == "0B")//物料卡 { txtRFID.Text = RFID_ID; if (!CommonClass.ValidateRFID(RFID_ID)) { throw new Exception("此卡已经被回收!"); } string DeviceName = FunPublic.GetDeviceName(); DataTable dt = FunPublic.GetDt("exec [PDA_WorkshopGRQuery] '" + RFID_ID + "','" + DeviceName.Substring(1, DeviceName.Length - 1) + "'"); if (dt.Rows.Count > 0) { foreach (DataRow dr in dt.Rows) { if (FunPublic.GetDt(string.Format("select STEPCODE from Doc_prodcutPackage13 where EBDOC='{0}' and RFID_ID = '{1}' AND STEPSEQ <{2} ", dr["EBDOC"], RFID_ID, dr["STEPSEQ"])).Rows.Count > 1) { throw new Exception("此卡片还有没有完工的工序,不能收货!"); } txtEBNum.Text = dr["EBDOC"].ToString(); txtPackageCode.Text = dr["PackageCode"].ToString(); txtSN.Text = dr["SN"].ToString(); txtQuantity.Text = dr["QtyinPackage"].ToString(); cmbStep.Items.Add(dr["STEPCode"].ToString() + "-" + dr["STEPName"].ToString()); cmbStep.Text = dr["STEPCode"].ToString() + "-" + dr["STEPName"].ToString(); txtMappingCode.Text = dr["MappingCode"].ToString(); txtRouMap.Text = dr["roumap"].ToString(); txtRouMapName.Text = dr["roumapName"].ToString(); } } else { throw new Exception("此车间已收货!"); } } else if (BitConverter.ToString(pszData, 11, 1) == "0D")//员工卡 { txtStaff.Text = RFID_ID; } CommonClass.PlaySoundBeep(); }
private void btnScan_Click(object sender, EventArgs e) { byte[] pszData = new byte[25]; byte[] data = new byte[1]; try { if (RFID_15693.ScanSingleTag(ref data)) { //CommonClass.PlaySound(); } else { MessageBox.Show("扫描失败,请确认是否是15693标签,并确认标签是否处于RFID感应区"); return; } string RFID_ID = RFID_15693.RFID_ID(); if (RFID_ID == "") { txtMappingCode.Text = ""; txtEBNum.Text = ""; txtPackageCode.Text = ""; txtSN.Text = ""; txtQuantity.Text = ""; MessageBox.Show("刷卡失败!"); } else { int res = RFID_15693.RF_ISO15693_getSystemInformation(0, data, 0, pszData); if (res == 0) { if (BitConverter.ToString(pszData, 11, 1) == "0B") {//物料卡 if (!CommonClass.ValidateRFID(RFID_ID)) { throw new Exception("此卡已经被回收!"); } if (txtRFID1.Focused) { DataTable dt = FunPublic.GetDt("exec [PDA_MappingQuery] '" + RFID_ID + "','4','',''"); if (dt.Rows.Count > 0) { DataRow[] dr = dt.Select("MappingCode='" + txtMappingCode.Text + "'"); if (dr.Length > 0) { txtRFID1.Text = RFID_ID; if (txtRFID2.Text != "") { this.panel1.Visible = true; } else { txtRFID2.Focus(); return; } } else if (dr.Length == 0 && txtMappingCode.Text == "") { txtRFID1.Text = RFID_ID; txtMappingCode.Text = dt.Rows[0]["MappingCode"].ToString(); txtEBNum.Text = dt.Rows[0]["EBDOC"].ToString(); txtPackageCode.Text = dt.Rows[0]["PackageCode"].ToString(); txtSN.Text = dt.Rows[0]["SN"].ToString(); txtQuantity.Text = dt.Rows[0]["Quantity"].ToString(); if (txtRFID2.Text != "") { this.panel1.Visible = true; } else { txtRFID2.Focus(); return; } } else { MessageBox.Show("无匹配!"); return; } } else { MessageBox.Show("未做收货!"); return; } } if (txtRFID2.Focused) { DataTable dt = FunPublic.GetDt("exec [PDA_MappingQuery] '" + RFID_ID + "','5','',''"); if (dt.Rows.Count > 0) { DataRow[] dr = dt.Select("MappingCode='" + txtMappingCode.Text + "'"); if (dr.Length > 0) { txtRFID2.Text = RFID_ID; if (txtRFID1.Text != "") { this.panel1.Visible = true; } else { txtRFID1.Focus(); } } else if (dr.Length == 0 && txtMappingCode.Text == "") { txtRFID2.Text = RFID_ID; txtMappingCode.Text = dt.Rows[0]["MappingCode"].ToString(); txtEBNum.Text = dt.Rows[0]["EBDOC"].ToString(); txtPackageCode.Text = dt.Rows[0]["PackageCode"].ToString(); txtSN.Text = dt.Rows[0]["SN"].ToString(); txtQuantity.Text = dt.Rows[0]["Quantity"].ToString(); if (txtRFID1.Text != "") { this.panel1.Visible = true; } else { txtRFID1.Focus(); return; } } else { MessageBox.Show("无匹配!"); return; } } else { MessageBox.Show("未做收货!"); return; } } } else if (BitConverter.ToString(pszData, 11, 1) == "0D") {//员工卡 MessageBox.Show("请刷物料卡!"); return; } CommonClass.PlaySoundBeep(); } else { txtRFID2.Text = ""; txtMappingCode.Text = ""; txtEBNum.Text = ""; txtPackageCode.Text = ""; txtSN.Text = ""; txtQuantity.Text = ""; MessageBox.Show("刷卡失败!"); } } } catch (Exception ex) { txtRFID2.Text = ""; txtMappingCode.Text = ""; txtEBNum.Text = ""; txtPackageCode.Text = ""; txtSN.Text = ""; txtQuantity.Text = ""; MessageBox.Show("刷卡失败!" + ex.Message); } }
private void btnScan_Click(object sender, EventArgs e) { byte[] pszData = new byte[25]; byte[] data = new byte[1]; try { if (RFID_15693.ScanSingleTag(ref data)) { //CommonClass.PlaySound(); } else { MessageBox.Show("扫描失败,请确认是否是15693标签,并确认标签是否处于RFID感应区"); return; } string RFID_ID = RFID_15693.RFID_ID(); if (RFID_ID == "") { txtRFID.Text = ""; //cmbCardCode.Text = ""; txtEBNum.Text = ""; txtPackageCode.Text = ""; txtCSKU_CODE.Text = ""; txtQuantity.Text = ""; txtWORKSHOP_CODE.Text = ""; txtLastStep.Text = ""; txtNextStep.Text = ""; Type = ""; BaseEntry = ""; MessageBox.Show("刷卡失败!"); } else { int res = RFID_15693.RF_ISO15693_getSystemInformation(0, data, 0, pszData); if (res == 0) { if (BitConverter.ToString(pszData, 11, 1) == "0B") {//物料卡 txtRFID.Text = RFID_ID; if (!CommonClass.ValidateRFID(RFID_ID)) { throw new Exception("此卡已经被回收!"); } //查询13表 string sql = @"SELECT DocEntry,Doc1_LINE_ID,Doc11_LINE_ID,Doc12_LINE_ID,EBDOC,RFID_ID,MappingCode,PackageCode,PackagesQty,QtyinPackage,ProRtEntry,ProRtLine,SN,CSKU_CODE,CSKU_NAME,STEPCode,STEPName,Quantity,WORKSHOP_CODE,WORKSHOPSEQ,STEPSEQ,roumap,QtyofSize,Type,STEP_PRICE FROM Doc_Prodcutpackage13 T WHERE T.RFID_ID='" + RFID_ID + "' order by STEPSEQ"; DataTable dt = FunPublic.GetDt(sql); if (dt.Rows.Count > 0) { Type = dt.Rows[0]["Type"].ToString(); BaseEntry = dt.Rows[0]["DocEntry"].ToString(); txtEBNum.Text = dt.Rows[0]["EBDOC"].ToString(); txtPackageCode.Text = dt.Rows[0]["PackageCode"].ToString(); txtCSKU_CODE.Text = dt.Rows[0]["CSKU_CODE"].ToString(); txtQuantity.Text = dt.Rows[0]["QtyinPackage"].ToString(); txtWORKSHOP_CODE.Text = dt.Rows[0]["WORKSHOP_CODE"].ToString(); txtLastStep.Text = dt.Rows[0]["STEPCode"].ToString(); DataTable dt1 = FunPublic.GetDt("select STEPCode from Doc_Prodcutpackage14 where RFID_ID='" + RFID_ID + "' and EBDOC = '" + dt.Rows[0]["EBDOC"].ToString() + "' and SN = '" + dt.Rows[0]["SN"].ToString() + "' order by STEPSEQ desc"); if (dt1.Rows.Count > 0) { txtNextStep.Text = dt1.Rows[0]["STEPCode"].ToString(); } } else { txtEBNum.Text = ""; txtPackageCode.Text = ""; txtCSKU_CODE.Text = ""; txtQuantity.Text = ""; txtWORKSHOP_CODE.Text = ""; txtLastStep.Text = ""; txtNextStep.Text = ""; Type = ""; BaseEntry = ""; MessageBox.Show("查不到明细!"); return; } } else if (BitConverter.ToString(pszData, 11, 1) == "0D") {//员工卡 MessageBox.Show("请刷物料卡!"); return; } CommonClass.PlaySoundBeep(); } else { txtRFID.Text = ""; //cmbCardCode.Text = ""; txtEBNum.Text = ""; txtPackageCode.Text = ""; txtCSKU_CODE.Text = ""; txtQuantity.Text = ""; txtWORKSHOP_CODE.Text = ""; txtLastStep.Text = ""; txtNextStep.Text = ""; Type = ""; BaseEntry = ""; MessageBox.Show("刷卡失败!"); } } } catch (Exception ex) { txtRFID.Text = ""; //cmbCardCode.Text = ""; txtEBNum.Text = ""; txtPackageCode.Text = ""; txtCSKU_CODE.Text = ""; txtQuantity.Text = ""; txtWORKSHOP_CODE.Text = ""; txtLastStep.Text = ""; txtNextStep.Text = ""; Type = ""; BaseEntry = ""; MessageBox.Show("刷卡失败!" + ex.Message); } }
private void btnScan_Click(object sender, EventArgs e) { byte[] pszData = new byte[25]; byte[] data = new byte[1]; try { if (RFID_15693.ScanSingleTag(ref data)) { //CommonClass.PlaySound(); } else { MessageBox.Show("扫描失败,请确认是否是15693标签,并确认标签是否处于RFID感应区"); return; } string RFID_ID = RFID_15693.RFID_ID(); if (RFID_ID == "") { txtWORKSHOP_CODE.Text = ""; txtRFID.Text = ""; //cmbCardCode.Text = ""; txtEBNum.Text = ""; txtPackageCode.Text = ""; txtCSKU_CODE.Text = ""; txtQuantity.Text = ""; txtLastStep.Text = ""; txtNextStep.Text = ""; MessageBox.Show("刷卡失败!"); } else { int res = RFID_15693.RF_ISO15693_getSystemInformation(0, data, 0, pszData); if (res == 0) { if (BitConverter.ToString(pszData, 11, 1) == "0B") {//物料卡 txtRFID.Text = RFID_ID; if (!CommonClass.ValidateRFID(RFID_ID)) { throw new Exception("此卡已经被回收!"); } string DeviceName = FunPublic.GetDeviceName(); DataTable dt = FunPublic.GetDt("exec [PDA_SearchPDAQuery] '" + RFID_ID + "'"); if (dt.Rows.Count > 0) { foreach (DataRow dr in dt.Rows) { txtWORKSHOP_CODE.Text = dr["roumap"].ToString(); txtEBNum.Text = dr["EBDOC"].ToString(); txtPackageCode.Text = dr["PackageCode"].ToString(); txtCSKU_CODE.Text = dr["CSKU_CODE"].ToString(); txtQuantity.Text = dr["QtyinPackage"].ToString(); txtLastStep.Text = dr["txtLastStep"].ToString(); txtNextStep.Text = dr["txtNextStep"].ToString(); } } else { txtWORKSHOP_CODE.Text = ""; txtEBNum.Text = ""; txtPackageCode.Text = ""; txtCSKU_CODE.Text = ""; txtQuantity.Text = ""; txtLastStep.Text = ""; txtNextStep.Text = ""; //MessageBox.Show("此车间上无此包收货!"); } } else if (BitConverter.ToString(pszData, 11, 1) == "0D") {//员工卡 MessageBox.Show("请刷物料卡!"); return; } CommonClass.PlaySoundBeep(); } else { txtWORKSHOP_CODE.Text = ""; txtRFID.Text = ""; //cmbCardCode.Text = ""; txtEBNum.Text = ""; txtPackageCode.Text = ""; txtCSKU_CODE.Text = ""; txtQuantity.Text = ""; txtLastStep.Text = ""; txtNextStep.Text = ""; MessageBox.Show("刷卡失败!"); } } } catch (Exception ex) { txtWORKSHOP_CODE.Text = ""; txtRFID.Text = ""; //cmbCardCode.Text = ""; txtEBNum.Text = ""; txtPackageCode.Text = ""; txtCSKU_CODE.Text = ""; txtQuantity.Text = ""; txtLastStep.Text = ""; txtNextStep.Text = ""; MessageBox.Show("刷卡失败!" + ex.Message); } }
private void btnScan_Click(object sender, EventArgs e) { byte[] pszData = new byte[25]; byte[] data = new byte[1]; try { if (RFID_15693.ScanSingleTag(ref data)) { //CommonClass.PlaySound(); } else { MessageBox.Show("扫描失败,请确认是否是15693标签,并确认标签是否处于RFID感应区"); return; } string RFID_ID = RFID_15693.RFID_ID(); if (RFID_ID == "") { txtRFID.Text = ""; txtEBNum.Text = ""; txtPackageCode.Text = ""; txtSN.Text = ""; txtQuantity.Text = ""; cmbStep.Items.Clear(); cmbStep.Text = ""; MessageBox.Show("刷卡失败!"); } else { int res = RFID_15693.RF_ISO15693_getSystemInformation(0, data, 0, pszData); if (res == 0) { if (BitConverter.ToString(pszData, 11, 1) == "0B") {//物料卡 txtRFID.Text = RFID_ID; if (!CommonClass.ValidateRFID(RFID_ID)) { throw new Exception("此卡已经被回收!"); } if (Convert.ToInt32(FunPublic.GetDt("select COUNT(distinct EBDOC) from Doc_Prodcutpackage13 where RFID_ID='" + RFID_ID + "'").Rows[0][0]) > 1) { MessageBox.Show("此卡存在多个EB单号,不能刷卡!"); return; } string DeviceName = FunPublic.GetDeviceName(); DataTable dt = FunPublic.GetDt("exec [PDA_DailyReportQuery] '" + RFID_ID + "','" + DeviceName.Substring(1, DeviceName.Length - 1) + "'"); if (dt.Rows.Count > 0) { cmbStep.Items.Clear(); foreach (DataRow dr in dt.Rows) { txtEBNum.Text = dr["EBDOC"].ToString(); txtPackageCode.Text = dr["PackageCode"].ToString(); txtSN.Text = dr["SN"].ToString(); txtQuantity.Text = dr["QtyinPackage"].ToString(); cmbStep.Items.Add(dr["STEPCode"].ToString() + "-" + dr["STEPName"].ToString()); cmbStep.Text = dr["STEPCode"].ToString() + "-" + dr["STEPName"].ToString(); } } else { MessageBox.Show("此设备上无可选工序!"); } } else if (BitConverter.ToString(pszData, 11, 1) == "0D") {//员工卡 txtStaff.Text = RFID_ID; } CommonClass.PlaySoundBeep(); } else { txtRFID.Text = ""; txtEBNum.Text = ""; txtPackageCode.Text = ""; txtSN.Text = ""; txtQuantity.Text = ""; cmbStep.Items.Clear(); cmbStep.Text = ""; MessageBox.Show("刷卡失败!"); } } } catch (Exception ex) { txtRFID.Text = ""; txtEBNum.Text = ""; txtPackageCode.Text = ""; txtSN.Text = ""; txtQuantity.Text = ""; cmbStep.Items.Clear(); cmbStep.Text = ""; MessageBox.Show("刷卡失败!" + ex.Message); } }
private void btnScan_Click(object sender, EventArgs e) { if (cmbCardCode.Text == "") { MessageBox.Show("请先选择供应商!"); return; } byte[] pszData = new byte[25]; byte[] data = new byte[1]; try { if (RFID_15693.ScanSingleTag(ref data)) { //CommonClass.PlaySound(); } else { MessageBox.Show("扫描失败,请确认是否是15693标签,并确认标签是否处于RFID感应区"); return; } string RFID_ID = RFID_15693.RFID_ID(); if (RFID_ID == "") { txtRFID.Text = ""; //cmbCardCode.Text = ""; txtEBNum.Text = ""; txtPackageCode.Text = ""; txtSN.Text = ""; txtQuantity.Text = ""; MessageBox.Show("刷卡失败!"); } else { int res = RFID_15693.RF_ISO15693_getSystemInformation(0, data, 0, pszData); if (res == 0) { if (BitConverter.ToString(pszData, 11, 1) == "0B") {//物料卡 txtRFID.Text = RFID_ID; if (!CommonClass.ValidateRFID(RFID_ID)) { throw new Exception("此卡已经被回收!"); } string DeviceName = FunPublic.GetDeviceName(); DataTable dt = FunPublic.GetDt("exec [PDA_OSGoodsIssuQuery] 'RFID','" + RFID_ID + "','" + cmbCardCode.Text.Substring(0, cmbCardCode.Text.IndexOf('-')) + "',''"); if (dt.Rows.Count > 0) { foreach (DataRow dr in dt.Rows) { txtEBNum.Text = dr["EBDOC"].ToString(); txtPackageCode.Text = dr["PackageCode"].ToString(); txtSN.Text = dr["SN"].ToString(); txtQuantity.Text = dr["QtyinPackage"].ToString(); } } else { txtEBNum.Text = ""; txtPackageCode.Text = ""; txtSN.Text = ""; txtQuantity.Text = ""; MessageBox.Show("此供应商下无此包外发!"); } } else if (BitConverter.ToString(pszData, 11, 1) == "0D") {//员工卡 MessageBox.Show("请刷物料卡!"); return; } CommonClass.PlaySoundBeep(); } else { txtRFID.Text = ""; //cmbCardCode.Text = ""; txtEBNum.Text = ""; txtPackageCode.Text = ""; txtSN.Text = ""; txtQuantity.Text = ""; MessageBox.Show("刷卡失败!"); } } } catch (Exception ex) { txtRFID.Text = ""; //cmbCardCode.Text = ""; txtEBNum.Text = ""; txtPackageCode.Text = ""; txtSN.Text = ""; txtQuantity.Text = ""; MessageBox.Show("刷卡失败!" + ex.Message); } }
//刷卡 private void Scan() { byte[] pszData = new byte[25]; byte[] data = new byte[1]; if (RFID_15693.ScanSingleTag(ref data)) { //CommonClass.PlaySound(); } else { throw new Exception("扫描失败,请确认是否是15693标签,并确认标签是否处于RFID感应区!"); } string RFID_ID = RFID_15693.RFID_ID(); if (RFID_ID == "") { throw new Exception("扫描失败,RFID号为空!"); } int res = RFID_15693.RF_ISO15693_getSystemInformation(0, data, 0, pszData); if (res != 0) { throw new Exception("扫描失败,获取卡类型时出错!"); } if (BitConverter.ToString(pszData, 11, 1) == "0B")//物料卡 { if (!CommonClass.ValidateRFID(RFID_ID)) { throw new Exception("此卡已经被回收!"); } string DeviceName = FunPublic.GetDeviceName(); //判断PDA的车间类型是否满足条件 DataTable workshop = FunPublic.GetDt("select WORKSHOP_CODE from dbo.Tm_Station t0 where ReaderCode = '" + DeviceName.Substring(1, DeviceName.Length - 1) + @"' and TYPE ='P' AND WORKSHOP_CODE in (select * from dbo.Fun_SplitStr((select value from Ts_Config where [key] = 'MapingWorkShop'),'#'))"); if (workshop.Rows.Count == 0) { throw new Exception("车间不符,无法匹配"); } if (txtRFID1.Text == "") { txtRFID1.Text = RFID_ID; DataTable dt = FunPublic.GetDt("exec [PDA_MappingQuery] '" + RFID_ID + "','1','',''"); if (dt.Rows.Count > 0) { foreach (DataRow dr in dt.Rows) { txtRoumap1.Text = dr["roumap"].ToString(); txtMappingCode.Text = dr["MappingCode"].ToString(); txtEBNum.Text = dr["EBDOC"].ToString(); txtPackageCode.Text = dr["PackageCode"].ToString(); txtSN.Text = dr["SN"].ToString(); txtQuantity.Text = dr["QtyinPackage"].ToString(); } } else { throw new Exception("卡片没有可匹配的工序!"); } } else { txtRFID2.Text = RFID_ID; if (txtRFID1.Text == txtRFID2.Text) { txtRFID2.Text = ""; MessageBox.Show("相同卡不能匹配!"); return; } Mapping(DeviceName.Substring(1, DeviceName.Length - 1)); } } else if (BitConverter.ToString(pszData, 11, 1) == "0D")//员工卡 { throw new Exception("请刷物料卡!"); } CommonClass.PlaySoundBeep(); }