//扫描条码
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();
}
