private void cmbType_SelectedIndexChanged(object sender, EventArgs e) { string STEP_PRICE = "0"; if (cmbfree.Text != "" && cmbType.Text != "") { if ("Y".Equals(cmbfree.Text.Substring(0, 1))) { STEP_PRICE = "isnull(STEP_PRICE,0)"; } else if ("N".Equals(cmbfree.Text.Substring(0, 1))) { STEP_PRICE = "0"; } if ("B".Equals(cmbType.Text.Substring(0, 1))) { DataTable dt = FunPublic.GetDt("select null LINE_ID,STEPCode,STEPName,Quantity,WORKSHOP_CODE,STEPSEQ,case STATUS when 'T' then isnull(STEP_PRICE,0) else " + STEP_PRICE + " end as STEP_PRICE,isnull(STEP_PRICE,0) as STEP_PRICE_H,case STATUS when 'T' then 'N' else 'Y' end IsFinish from Doc_Prodcutpackage14 where RFID_ID = '" + txtRFID.Text + "' and EBDOC = '" + txtEBNum.Text + "' and CSKU_CODE = '" + txtCSKU_CODE.Text + "' order by STEPSEQ"); FunPublic.View_ListView(dt, listView1); cmbRejectStationf.Enabled = false; } else if ("A".Equals(cmbType.Text.Substring(0, 1))) { cmbRejectStationf.Enabled = true; listView1.Items.Clear(); } } }
//扫描条码 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); } }
/// <summary> /// 判断RFID卡是否有效 /// </summary> /// <param name="rfid">要校验的RFID</param> public static bool ValidateRFID(String rfid) { DataTable dt = FunPublic.GetDt(string.Format("select * from Tm_RFID where STATUS = 'F' and RFIDLUN = '{0}'", rfid)); if (dt.Rows.Count > 0) { return(true); } return(false); }
private void btnSubmit_Click(object sender, EventArgs e) { if (txtRFID.Text == "") { MessageBox.Show("请刷物料卡!"); return; } if (cmbStatus.Text != "是") { MessageBox.Show("还有未完工工序,卡片不能回收!"); return; } if (FunPublic.GetDt("select * from Tm_RFID where RFIDLUN = '" + txtRFID.Text + "' and [STATUS] <> 'F'").Rows.Count > 0) { MessageBox.Show("卡片状态异常,不能回收!"); return; } //DataTable dt = FunPublic.GetDtSap("select firstName from OHEM where U_rfid = '" + txtRoumap.Text + "'"); //string DeviceName = FunPublic.GetDeviceName(); List <string> strSqls = new List <string>(); strSqls.Add(@" declare @MaxDoc as int select @MaxDoc = isnull(max(DocEntry) + 1,1) from Doc_recRFID INSERT INTO [Doc_recRFID] ([DocEntry] ,[CREATED] ,[DOC_DATE] ,[EBDOC] ,[SN] ,[PackageCode] ,[RFID_ID] ,[roumap]) VALUES(@MaxDoc,'" + FunPublic.CurrentUser + "',getdate(),'" + txtEBNum.Text + "','" + txtSN.Text + "','" + txtPackageCode.Text + "','" + txtRFID.Text + "','" + txtRoumap.Text + "')"); strSqls.Add("update Tm_RFID set STATUS = 'O' where RFIDLUN = '" + txtRFID.Text + "'"); result = FunPublic.RunSqls(strSqls); if (result.Status == 1) { //MessageBox.Show("提交成功!"); txtRoumap.Text = ""; txtRFID.Text = ""; //cmbCardCode.Text = ""; txtEBNum.Text = ""; txtPackageCode.Text = ""; txtSN.Text = ""; txtQuantity.Text = ""; cmbStatus.Text = ""; } else { MessageBox.Show(result.Message); } }
private void FrmRejectPackage_Load(object sender, EventArgs e) { RFID_15693.InitModule(); if (!System.IO.File.Exists(CommonClass.Path))//如果文件不存在,表示首次打开程序,将扫描头未开启的常用条码保存在文件里面 { List <string> listData = new List <string>(); for (int k = 0; k < CommonClass.strCodeType.Length / 3; k++) { if (CommonClass.strCodeType[k, 0, 0] != "Composite CC-A/B")//Composite CC-A/B默认不开启,所以不记录 { listData.Add(CommonClass.strCodeType[k, 0, 0] + "," + CommonClass.strCodeType[k, 0, 1] + ",1"); } } CommonClass.SaveFile(CommonClass.Path, listData); } byte[] by = new byte[6]; List <string> listCodeType = new List <string>();//得到上次保存的条码类型的数据 CommonClass.ReadFile(CommonClass.Path, ref listCodeType); for (int k = 0; k < listCodeType.Count; k++) { byte[] data = BitConverter.GetBytes(Int32.Parse(listCodeType[k].Split(',')[1])); for (int t = 0; t < data.Length; t++) { by[t] = data[t]; } by[4] = 1; by[5] = 1; CommonClass.SoftDecoding_BarcodeType_OnOff(by, by.Length); System.Threading.Thread.Sleep(10); } byte[] data2 = BitConverter.GetBytes(716); byte[] by2 = new byte[] { 0, 0, 0, 0, 1, 0 };//402,2开启 Array.Copy(data2, 0, by2, 0, 4); CommonClass.SoftDecoding_BarcodeType_OnOff(by2, by2.Length); DataTable dt = FunPublic.GetDt("exec [dbo].[PDA_RejectPackageQuery] 'RejectReas','','',''"); if (dt.Rows.Count > 0) { foreach (DataRow dr in dt.Rows) { cmbReason.Items.Add(dr["Code"].ToString() + "-" + dr["Name"].ToString()); } } btnScan.Focus(); }
private void btnSubmit_Click(object sender, EventArgs e) { if (txtStaff.Text == "") { MessageBox.Show("请刷员工卡!"); return; } if (txtRFID.Text == "") { MessageBox.Show("请刷物料卡!"); return; } if (cmbStep.Text == "") { MessageBox.Show("请选择工序!"); return; } DataTable dt = FunPublic.GetDt("select firstName from OHEM where U_rfid = '" + txtStaff.Text + "'"); string DeviceName = FunPublic.GetDeviceName(); List <string> strSqls = new List <string>(); strSqls.Add("insert into Doc_DailyReport([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],[StaffCode],[StationCode],[DOC_DATE],[QtyofReject],[QtyofRepair],[StaffName],[Type],STEP_PRICE,MODEL,C_COLOUR,B_COLOUR,ISFREESTEP,ISOPTION) 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],'" + txtStaff.Text.Substring(6, 4) + "','" + DeviceName.Substring(1, DeviceName.Length - 1) + "',getdate(),0,0,'" + dt.Rows[0][0].ToString() + "',[Type],STEP_PRICE,MODEL,C_COLOUR,B_COLOUR,ISFREESTEP,ISOPTION from Doc_Prodcutpackage13 where RFID_ID = '" + txtRFID.Text + "' and STEPCode = '" + cmbStep.Text.Substring(0, cmbStep.Text.IndexOf('-')) + "'"); strSqls.Add("delete from Doc_Prodcutpackage13 where RFID_ID = '" + txtRFID.Text + "' and STEPCode = '" + cmbStep.Text.Substring(0, cmbStep.Text.IndexOf('-')) + "'"); strSqls.Add("update Doc_Prodcutpackage14 set STATUS = 'F' where RFID_ID = '" + txtRFID.Text + "' and STEPCode = '" + cmbStep.Text.Substring(0, cmbStep.Text.IndexOf('-')) + "'"); result = FunPublic.RunSqls(strSqls); if (result.Status == 1) { //MessageBox.Show("提交成功!"); txtRFID.Text = ""; txtEBNum.Text = ""; txtPackageCode.Text = ""; txtSN.Text = ""; txtQuantity.Text = ""; cmbStep.Items.Clear(); cmbStep.Text = ""; } else { MessageBox.Show(result.Message); } }
//回收卡(暂停使用) private void RecRFID() { DataTable dt2 = FunPublic.GetDt("exec [PDA_RecRFIDQuery] '" + txtRFID.Text + "'"); if (dt2.Rows.Count > 0 && dt2.Rows[0]["Status"] == "是" && (dt2.Rows[0]["name"].ToString().Contains("帽眉") || dt2.Rows[0]["name"].ToString().Contains("后带"))) { //回收卡 List <string> strSqls = new List <string>(); strSqls.Add(@" declare @MaxDoc as int select @MaxDoc = isnull(max(DocEntry) + 1,1) from Doc_recRFID INSERT INTO [Doc_recRFID]([DocEntry],[CREATED],[DOC_DATE],[EBDOC],[SN],[PackageCode],[RFID_ID],[roumap]) VALUES(@MaxDoc,'" + FunPublic.CurrentUser + "',getdate(),'" + txtEBNum.Text + "','" + txtSN.Text + "','" + txtPackageCode.Text + "','" + txtRFID.Text + "','" + dt2.Rows[0]["roumap"] + "')"); strSqls.Add("update Tm_RFID set STATUS = 'O' where RFIDLUN = '" + txtRFID.Text + "'"); result = FunPublic.RunSqls(strSqls); if (result.Status != 1) { throw new Exception("回收卡出错:" + result.Message); } } }
//提交 private bool Submit(string DeviceName) { //获取员工名称 DataTable dt = FunPublic.GetDt("select firstName from OHEM where U_rfid = '" + txtStaff.Text + "'"); //将信息写入车间收货表 List <string> strSqls = new List <string>(); strSqls.Add(@"insert into Doc_WorkshopGR([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],[StaffCode],[StationCode],[DOC_DATE],[QtyofReject],[QtyofRepair],[StaffName],FACTORY_CODE,Type,C_COLOUR,B_COLOUR,QtyofSizePackage) 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],'" + txtStaff.Text.Substring(6, 4) + "','" + DeviceName.Substring(1, DeviceName.Length - 1) + "',getdate(),0,0,'" + dt.Rows[0][0].ToString() + "',FACTORY_CODE,Type,C_COLOUR,B_COLOUR,QtyofSizePackage from Doc_Prodcutpackage13 where RFID_ID = '" + txtRFID.Text + "' and STEPCode = '" + cmbStep.Text.Substring(0, cmbStep.Text.IndexOf('-')) + "'"); strSqls.Add("delete from Doc_Prodcutpackage13 where RFID_ID = '" + txtRFID.Text + "' and STEPCode = '" + cmbStep.Text.Substring(0, cmbStep.Text.IndexOf('-')) + "'"); strSqls.Add("update Doc_Prodcutpackage14 set STATUS = 'F' where RFID_ID = '" + txtRFID.Text + "' and STEPCode = '" + cmbStep.Text.Substring(0, cmbStep.Text.IndexOf('-')) + "'"); //回收卡 if (FunPublic.GetDt("select Value from Ts_Config where [KEY] = 'WorkShopGRHS' and Value like '%" + txtRouMap.Text + "%'").Rows.Count > 0) { string sql = @"if not exists(select DocEntry from Doc_Prodcutpackage13 where RFID_ID = '" + txtRFID.Text + @"') begin update Tm_RFID set STATUS = 'O' where RFIDLUN = '" + txtRFID.Text + @"' declare @MaxDoc as int select @MaxDoc = isnull(max(DocEntry) + 1,1) from Doc_recRFID INSERT INTO [Doc_recRFID]([DocEntry],[CREATED],[DOC_DATE],[EBDOC],[SN],[PackageCode],[RFID_ID],[roumap]) select top 1 @MaxDoc,'" + FunPublic.CurrentUser + "',getdate(),'" + txtEBNum.Text + "','" + txtSN.Text + "','" + txtPackageCode.Text + "','" + txtRFID.Text + "',roumap from Doc_Prodcutpackage14 where RFID_ID='" + txtRFID.Text + "' and EBDOC='" + txtEBNum.Text + @"' end "; strSqls.Add(sql); } result = FunPublic.RunSqls(strSqls); //提交成功 if (result.Status == 1) { return(true); } else { throw new Exception(result.Message); } }
/// <summary> /// 测试服务器端连接 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> //private void button1_Click(object sender, EventArgs e) //{ // System.ServiceModel.Channels.Binding binding = ServiceBaseClient.CreateDefaultBinding(); // string remoteAddress = ServiceBaseClient.EndpointAddress.Uri.ToString(); // // Server IP Address // //remoteAddress = remoteAddress.Replace("localhost", "10.16.172.204"); // EndpointAddress endpoint = new EndpointAddress(remoteAddress); // ServiceBaseClient client = new ServiceBaseClient(binding, endpoint); // try // { // //MessageBox.Show(client.Add(10, 20).ToString()); // DataTable dt = client.GetDt("select * from Ts_Config"); // MessageBox.Show(dt.Rows[0][0].ToString()); // } // catch (Exception ex) // { // MessageBox.Show(ex.Message); // } // //PlatformServer.ServiceBase server = new PDA.PlatformServer.ServiceBase(); // //DataTable dt = server.GetDt("select * from Ts_Config"); //} private void btnLogin_Click(object sender, EventArgs e) { if ((txtUserCode.Text == "" || txtPassword.Text == "")) { MessageBox.Show("请输入用户编号和密码!"); return; } string strSql = string.Format("SELECT OrgId,UserId FROM Core_User WHERE UserId='{0}' and Pwd='{1}' and DropFlag<>1", txtUserCode.Text, txtPassword.Text); DataTable dt = FunPublic.GetDt(strSql); if (dt.TableName == "Error") { MessageBox.Show(dt.Rows[0][0].ToString(), "提示"); return; } if (dt != null && dt.Rows.Count <= 0) { MessageBox.Show("用户错误", "提示"); return; } FunPublic.CurrentUser = txtUserCode.Text; this.DialogResult = DialogResult.OK; this.Close(); }
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 btnSubmit_Click(object sender, EventArgs e) { if (txtRFID.Text == "") { MessageBox.Show("请刷物料卡!"); return; } string sql; //判断是半成品还是产成品 if (Type.Equals("S") || Type.Equals("RS"))//半成品 { sql = "SELECT DocEntry,FACTORY_CODE,STATUS,CREATED,DOC_DATE,PONUM,EBDOC,BaseEntry,PRODOC FROM Doc_SeGoodspackage WHERE DocEntry ='" + BaseEntry + "'"; } else if (Type.Equals("P") || Type.Equals("RP"))//产成品 { sql = "SELECT DocEntry,FACTORY_CODE,STATUS,CREATED,DOC_DATE,PONUM,EBDOC,BaseEntry,PRODOC FROM Doc_Prodcutpackage WHERE DocEntry ='" + BaseEntry + "'"; } else { return; } List <string> strSqls = new List <string>(); DataTable dt = FunPublic.GetDt(sql); strSqls.Add(@"declare @maxDoc as int select @maxDoc=isnull(MAX(DocEntry) +1,1) from [Doc_Stop] INSERT INTO [Doc_Stop] ([DocEntry] ,[FACTORY_CODE] ,[CREATED] ,[DOC_DATE] ,[PONUM] ,[EBDOC] ,[BaseEntry] ,[Type] ,[PRODOC]) VALUES(@maxDoc,'" + dt.Rows[0]["FACTORY_CODE"].ToString() + "','" + FunPublic.CurrentUser + "',getdate(),'" + dt.Rows[0]["PONUM"].ToString() + "','" + txtEBNum.Text + "','" + dt.Rows[0]["DocEntry"].ToString() + "','" + Type + "','" + dt.Rows[0]["PRODOC"].ToString() + "')"); //包号 sql = "SELECT DISTINCT NULL AS LINE_ID,RFID_ID,PackageCode,PackagesQty,QtyinPackage,SN,CSKU_CODE,CSKU_NAME,roumap,QtyofSize FROM Doc_Prodcutpackage13 WHERE RFID_ID='" + txtRFID.Text + "' and Type='" + Type + "' and DocEntry ='" + BaseEntry + "'"; DataTable list1 = FunPublic.GetDt(sql); strSqls.Add(@"declare @maxDoc as int select @maxDoc=isnull(MAX(DocEntry),1) from [Doc_Stop] INSERT INTO [Doc_Stop1] ([DocEntry] ,[LINE_ID] ,[BaseLine] ,[SN] ,[CSKU_CODE] ,[CSKU_NAME] ,[TotalQty] ,[RFID_ID] ,[PackageCode] ,[QtyinPackage],roumap) VALUES(@maxDoc,1,'','" + list1.Rows[0]["SN"].ToString() + "','" + list1.Rows[0]["CSKU_CODE"].ToString() + "','" + list1.Rows[0]["CSKU_NAME"].ToString() + "',null,'" + txtRFID.Text + "','" + list1.Rows[0]["PackageCode"].ToString() + "'," + list1.Rows[0]["QtyinPackage"].ToString() + ",'" + list1.Rows[0]["roumap"].ToString() + "')"); //工序 sql = "SELECT DISTINCT NULL AS LINE_ID,SN,CSKU_CODE,PackageCode,STEPCode,STEPName,Quantity,WORKSHOP_CODE,STEPSEQ AS SNofStep,STEP_PRICE FROM Doc_Prodcutpackage13 WHERE RFID_ID='" + txtRFID.Text + "' and Type='" + Type + "' and DocEntry ='" + BaseEntry + "'"; DataTable list2 = FunPublic.GetDt(sql); for (int i = 0; i < list2.Rows.Count; i++) { strSqls.Add(@"declare @maxDoc as int select @maxDoc=isnull(MAX(DocEntry),1) from [Doc_Stop] INSERT INTO [Doc_Stop2] ([DocEntry] ,[LINE_ID] ,[SN] ,[CSKU_CODE] ,[RFID_ID] ,[PackageCode] ,[STEPCode] ,[STEPName] ,[STEP_PRICE] ,[Quantity] ,[SNofStep] ,[WORKSHOP_CODE]) VALUES(@maxDoc," + (i + 1).ToString() + ",'" + list2.Rows[i]["SN"].ToString() + "','" + list2.Rows[i]["CSKU_CODE"].ToString() + "','" + txtRFID.Text + "','" + list2.Rows[i]["PackageCode"].ToString() + "','" + list2.Rows[i]["STEPCode"].ToString() + "','" + list2.Rows[i]["STEPName"].ToString() + "'," + list2.Rows[i]["STEP_PRICE"].ToString() + "," + list2.Rows[i]["Quantity"].ToString() + ",'" + list2.Rows[i]["SNofStep"].ToString() + "','" + list2.Rows[i]["WORKSHOP_CODE"].ToString() + "')"); } //删除13表中数据 strSqls.Add("DELETE Doc_Prodcutpackage13 WHERE RFID_ID='" + txtRFID.Text + "'"); //更新14表中的状态 strSqls.Add("UPDATE Doc_Prodcutpackage14 SET STATUS ='C' WHERE RFID_ID='" + txtRFID.Text + "' and Type='" + Type + "' and DocEntry ='" + BaseEntry + "' and isnull(STATUS,'T') = 'T'"); //更新RFID卡的状态为O-待分配 strSqls.Add("update Tm_RFID set STATUS = 'O' where RFIDLUN = '" + txtRFID.Text + "'"); result = FunPublic.RunSqls(strSqls); if (result.Status == 1) { //MessageBox.Show("提交成功!"); txtRFID.Text = ""; //cmbCardCode.Text = ""; txtEBNum.Text = ""; txtPackageCode.Text = ""; txtCSKU_CODE.Text = ""; txtQuantity.Text = ""; txtWORKSHOP_CODE.Text = ""; txtLastStep.Text = ""; txtNextStep.Text = ""; Type = ""; BaseEntry = ""; } else { MessageBox.Show(result.Message); } }
/// <summary> /// 扫描条码 /// </summary> private void BarCode_Scan() { try { string RFID_ID = Barcode.scan(); 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 { if (RFID_ID.Substring(0, 1) == "2") {//物料卡 txtRFID.Text = RFID_ID; //查询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 (RFID_ID.Substring(0, 1) == "1") {//员工卡 MessageBox.Show("请刷物料卡!"); return; } CommonClass.PlaySoundBeep(); } } 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 == "") { 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) { 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)) { } 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 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(); }
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); } }
/// <summary> /// 扫描条码 /// </summary> private void BarCode_Scan() { try { string RFID_ID = Barcode.scan(); if (RFID_ID == "") { txtRFID.Text = ""; txtEBNum.Text = ""; txtPackageCode.Text = ""; txtSN.Text = ""; txtQuantity.Text = ""; cmbStep.Items.Clear(); cmbStep.Text = ""; MessageBox.Show("扫描失败!"); } else { if (RFID_ID.Substring(0, 1) == "2") {//物料卡 txtRFID.Text = RFID_ID; 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 (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 BarCode_Scan() { try { string RFID_ID = Barcode.scan(); if (RFID_ID == "") { throw new Exception("扫描失败,RFID号为空!"); } if (RFID_ID.Substring(0, 1) == "2")//物料卡 { 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 (RFID_ID.Substring(0, 1) == "1")//员工卡 { throw new Exception("请刷物料卡!"); } CommonClass.PlaySoundBeep(); } catch (Exception ex) { txtRFID1.Text = ""; txtRFID2.Text = ""; txtRoumap1.Text = ""; txtRoumap2.Text = ""; txtMappingCode.Text = ""; txtEBNum.Text = ""; txtPackageCode.Text = ""; txtSN.Text = ""; txtQuantity.Text = ""; MessageBox.Show("刷卡失败!" + ex.Message); } }
/// <summary> /// 扫描条码 /// </summary> private void BarCode_Scan() { if (cmbCardCode.Text == "") { MessageBox.Show("请先选择供应商!"); return; } try { string RFID_ID = Barcode.scan(); if (RFID_ID == "") { txtRFID.Text = ""; //cmbCardCode.Text = ""; txtEBNum.Text = ""; txtPackageCode.Text = ""; txtSN.Text = ""; txtQuantity.Text = ""; MessageBox.Show("扫描失败!"); } else { if (RFID_ID.Substring(0, 1) == "2") {//物料卡 txtRFID.Text = RFID_ID; 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 (RFID_ID.Substring(0, 1) == "1") {//员工卡 MessageBox.Show("请刷物料卡!"); return; } CommonClass.PlaySoundBeep(); } } catch (Exception ex) { txtRFID.Text = ""; //cmbCardCode.Text = ""; txtEBNum.Text = ""; txtPackageCode.Text = ""; txtSN.Text = ""; txtQuantity.Text = ""; MessageBox.Show("扫描失败!" + ex.Message); } }
private void FrmOSGoodsIssu_Load(object sender, EventArgs e) { RFID_15693.InitModule(); if (!System.IO.File.Exists(CommonClass.Path))//如果文件不存在,表示首次打开程序,将扫描头未开启的常用条码保存在文件里面 { List <string> listData = new List <string>(); for (int k = 0; k < CommonClass.strCodeType.Length / 3; k++) { if (CommonClass.strCodeType[k, 0, 0] != "Composite CC-A/B")//Composite CC-A/B默认不开启,所以不记录 { listData.Add(CommonClass.strCodeType[k, 0, 0] + "," + CommonClass.strCodeType[k, 0, 1] + ",1"); } } CommonClass.SaveFile(CommonClass.Path, listData); } byte[] by = new byte[6]; List <string> listCodeType = new List <string>();//得到上次保存的条码类型的数据 CommonClass.ReadFile(CommonClass.Path, ref listCodeType); for (int k = 0; k < listCodeType.Count; k++) { byte[] data = BitConverter.GetBytes(Int32.Parse(listCodeType[k].Split(',')[1])); for (int t = 0; t < data.Length; t++) { by[t] = data[t]; } by[4] = 1; by[5] = 1; CommonClass.SoftDecoding_BarcodeType_OnOff(by, by.Length); System.Threading.Thread.Sleep(10); } byte[] data2 = BitConverter.GetBytes(716); byte[] by2 = new byte[] { 0, 0, 0, 0, 1, 0 };//402,2开启 Array.Copy(data2, 0, by2, 0, 4); CommonClass.SoftDecoding_BarcodeType_OnOff(by2, by2.Length); DataTable dt = FunPublic.GetDt("exec [dbo].[PDA_OSGoodsIssuQuery] 'Vendor','','',''"); if (dt.Rows.Count > 0) { foreach (DataRow dr in dt.Rows) { cmbCardCode.Items.Add(dr["outsourcBP"].ToString() + "-" + dr["outsourcBPNM"].ToString()); } } ////校正宽度 //int nWidth = 0, nTemp = 0; //Graphics g = cmbCardCode.CreateGraphics(); //for (int i = 0; i < cmbCardCode.Items.Count; i++) //{ // nTemp = (int)g.MeasureString(cmbCardCode.Items[i].ToString(), cmbCardCode.Font).Width; // if (nTemp > nWidth) // nWidth = nTemp; //} //g.Dispose(); //SendMessage(cmbCardCode.Handle, CB_SETDROPPEDWIDTH, nWidth, 0); btnScan.Focus(); }
/// <summary> /// 扫描条码 /// </summary> private void BarCode_Scan() { try { string RFID_ID = Barcode.scan(); if (RFID_ID == "") { txtMappingCode.Text = ""; txtEBNum.Text = ""; txtPackageCode.Text = ""; txtSN.Text = ""; txtQuantity.Text = ""; MessageBox.Show("扫描失败!"); } else { if (RFID_ID.Substring(0, 1) == "2") {//物料卡 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(); return; } } 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 (RFID_ID.Substring(0, 1) == "1") {//员工卡 MessageBox.Show("请刷物料卡!"); return; } CommonClass.PlaySoundBeep(); } } catch (Exception ex) { txtRFID2.Text = ""; txtMappingCode.Text = ""; txtEBNum.Text = ""; txtPackageCode.Text = ""; txtSN.Text = ""; txtQuantity.Text = ""; MessageBox.Show("扫描失败!" + ex.Message); } }
//匹配 private bool Mapping(string DeviceName) { string strsql = string.Empty; string rfid = txtRFID.Text; string mappingcode = txtMappingCode.Text; string roumap = txtRouMap.Text; //判断PDA的车间类型是否满足条件 DataTable workshop = FunPublic.GetDt("select WORKSHOP_CODE from dbo.Tm_Station t0 where ReaderCode = '" + DeviceName + @"' 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) { return(true); } if ("1007".Equals(workshop.Rows[0]["WORKSHOP_CODE"]))//收发室 1:主路线 5:内衬 { if (txtRouMapName.Text == "主路线") { strsql = "select *,roumapName= (select name from Tm_roumap where DocEntry = roumap) from Doc_WorkshopGR where NcMappingStatus ='N' AND STEPCode =(select value from Ts_Config where [KEY]='FMappinNC') AND MappingCode ='" + mappingcode + "' AND roumap ='5'"; } else if (txtRouMapName.Text == "内衬路线") { strsql = "select *,roumapName= (select name from Tm_roumap where DocEntry = roumap) from Doc_WorkshopGR where NcMappingStatus ='N' AND STEPCode =(select value from Ts_Config where [KEY]='FMappingMain') AND MappingCode ='" + mappingcode + "' AND roumap ='1'"; } else { return(false); } } else if ("1005".Equals(workshop.Rows[0]["WORKSHOP_CODE"]))//完成线 { if (txtRouMapName.Text == "主路线") { strsql = @"SELECT *,roumapName= (select name from Tm_roumap where DocEntry = roumap) FROM Doc_WorkshopGR WHERE MappingCode ='" + mappingcode + @"' AND ((MmMappingStatus ='N' AND STEPCode in(select value from Ts_Config where [KEY]='SMappingMM') AND roumap = 2) OR (HdMappingStatus ='N' AND STEPCode in(select value from Ts_Config where [KEY]='SMappingHD') AND roumap = 7))"; } else if (txtRouMapName.Text == "后带路线" || txtRouMapName.Text == "帽眉路线") { strsql = @"SELECT *,roumapName= (select name from Tm_roumap where DocEntry = roumap) FROM Doc_WorkshopGR WHERE MappingCode ='" + mappingcode + @"' AND roumap = 1 AND STEPCode in(select value from Ts_Config where [KEY]='SMappingMain') AND (MmMappingStatus ='N' OR HdMappingStatus ='N')"; } else { return(false); } } DataTable dt = FunPublic.GetDt(strsql); if (dt == null || dt.Rows.Count == 0) { return(false); } #region 关闭扫描 RFID_15693.freeMode(); CommonClass.SoftDecoding_Deinit(); #endregion FrmMapping FrmMapping = new FrmMapping(); FrmMapping.txtRFID1.Text = rfid; FrmMapping.txtRoumap1.Text = txtRouMapName.Text; FrmMapping.txtMappingCode.Text = mappingcode; FrmMapping.txtEBNum.Text = txtEBNum.Text; FrmMapping.txtPackageCode.Text = txtPackageCode.Text; FrmMapping.txtSN.Text = txtSN.Text; FrmMapping.txtQuantity.Text = txtQuantity.Text; FrmMapping.Text = "配货 -" + dt.Rows[0]["roumapName"].ToString(); FrmMapping.model = "弹窗"; FrmMapping.ShowDialog(); #region 开启扫描 CommonClass.SoftDecoding_Init(); CommonClass.SoftDecoding_Select_ScanMode(); CommonClass.CreaterDirectory(CommonClass.Path); CommonClass.Path += "\\2D_S_CodeType.txt";//把保存的文件存放在当前目录的前目录的File文件夹 RFID_15693.InitModule(); if (!System.IO.File.Exists(CommonClass.Path))//如果文件不存在,表示首次打开程序,将扫描头未开启的常用条码保存在文件里面 { List <string> listData = new List <string>(); for (int k = 0; k < CommonClass.strCodeType.Length / 3; k++) { if (CommonClass.strCodeType[k, 0, 0] != "Composite CC-A/B")//Composite CC-A/B默认不开启,所以不记录 { listData.Add(CommonClass.strCodeType[k, 0, 0] + "," + CommonClass.strCodeType[k, 0, 1] + ",1"); } } CommonClass.SaveFile(CommonClass.Path, listData); } byte[] by = new byte[6]; List <string> listCodeType = new List <string>();//得到上次保存的条码类型的数据 CommonClass.ReadFile(CommonClass.Path, ref listCodeType); for (int k = 0; k < listCodeType.Count; k++) { byte[] data = BitConverter.GetBytes(Int32.Parse(listCodeType[k].Split(',')[1])); for (int t = 0; t < data.Length; t++) { by[t] = data[t]; } by[4] = 1; by[5] = 1; CommonClass.SoftDecoding_BarcodeType_OnOff(by, by.Length); System.Threading.Thread.Sleep(10); } byte[] data2 = BitConverter.GetBytes(716); byte[] by2 = new byte[] { 0, 0, 0, 0, 1, 0 };//402,2开启 Array.Copy(data2, 0, by2, 0, 4); CommonClass.SoftDecoding_BarcodeType_OnOff(by2, by2.Length); #endregion return(true); }
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 (txtRFID_New.Focused == true) {//刷新卡 if (RFID_ID == "") { txtRFID_New.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_New.Text = RFID_ID; DataTable dt = FunPublic.GetDt("select * from Tm_RFID WHERE RFIDLUN = '" + RFID_ID + "' and STATUS = 'O'"); if (dt.Rows.Count == 0) { MessageBox.Show("物料卡" + RFID_ID + "状态错误,请换一张卡!", "提示"); return; } string DocEntry = FunPublic.GetDt("select isnull(max(DocEntry)+1,1) DocEntry from Doc_RejectPackage").Rows[0][0].ToString(); DataTable dt1 = new DataTable(); if ("B".Equals(cmbType.Text.Substring(0, 1))) { dt1 = FunPublic.GetDt("select * from Doc_Prodcutpackage14 where RFID_ID = '" + txtRFID.Text + "' and EBDOC = '" + txtEBNum.Text + "' and CSKU_CODE = '" + txtCSKU_CODE.Text + "'"); } else if ("A".Equals(cmbType.Text.Substring(0, 1))) { dt1 = FunPublic.GetDt("select * from Doc_Prodcutpackage14 where RFID_ID = '" + txtRFID.Text + "' and EBDOC = '" + txtEBNum.Text + "' and CSKU_CODE = '" + txtCSKU_CODE.Text + @"' and STEPSEQ >= ( select STEPSEQ from Doc_Prodcutpackage14 where RFID_ID = '" + txtRFID.Text + "' and EBDOC = '" + txtEBNum.Text + "' and CSKU_CODE = '" + txtCSKU_CODE.Text + @"' and STEPCode = '" + cmbRejectStationf.Text.Substring(0, cmbRejectStationf.Text.IndexOf('-')) + "')"); } List <string> sqlstrs = new List <string>(); sqlstrs.Add(@"INSERT INTO [Doc_RejectPackage] ([DocEntry],[DOC_DATE],[CREATED],[RFID_ID],[PackageCode],[CSKU_CODE],[CSKU_NAME],[QtyofReject],[RejectStation],[free],[RejectStationf],[Type],[RejectStaffCo],[RejectReson],[FACTORY_CODE],[EBDOC],[BaseEntry],[RFID_ID1],[STATUS]) VALUES(" + DocEntry + ",getdate(),'" + FunPublic.CurrentUser + "','" + txtRFID.Text + "','" + txtPackageCode.Text + "','" + txtCSKU_CODE.Text + "',''," + txtQuantity.Text + ",'" + cmbRejectStation.Text.Substring(0, cmbRejectStation.Text.IndexOf('-')) + "','" + cmbfree.Text.Substring(0, cmbfree.Text.IndexOf('-')) + "','" + cmbRejectStationf.Text.Substring(0, cmbRejectStationf.Text.IndexOf('-')) + "','" + cmbType.Text.Substring(0, cmbType.Text.IndexOf('-')) + "','','" + cmbReason.Text.Substring(0, cmbReason.Text.IndexOf('-')) + "',(select FACTORY_CODE from Tm_Station where ReaderCode = '" + FunPublic.GetDeviceName() + "'),'" + txtEBNum.Text + "',null,'" + RFID_ID + "','O')"); for (int i = 0; i < dt1.Rows.Count; i++) { ListViewItem ListViewItem = listView1.Items[i]; sqlstrs.Add(@"INSERT INTO [Doc_RejectPackage1]([DocEntry],[LINE_ID],[STEPCode],[STEPName],[STEP_PRICE],[STEP_PRICE_H],[Quantity],[WORKSHOP_CODE],[STEPSEQ],[IsFinish]) VALUES(" + DocEntry + "," + i + ",'" + ListViewItem.SubItems[2].Text + "','" + ListViewItem.SubItems[3].Text + "','" + ListViewItem.SubItems[7].Text + "','" + ListViewItem.SubItems[8].Text + "','" + ListViewItem.SubItems[4].Text + "','" + ListViewItem.SubItems[5].Text + "','" + ListViewItem.SubItems[6].Text + "','" + ListViewItem.SubItems[9].Text + "')"); sqlstrs.Add(@"INSERT INTO [Doc_Prodcutpackage13] ([DocEntry] ,[Doc1_LINE_ID] ,[Doc11_LINE_ID] ,[Doc12_LINE_ID] ,[RFID_ID] ,[MappingCode] ,[PackageCode] ,[PackagesQty] ,[QtyinPackage] ,[ProRtEntry] ,[ProRtLine] ,[SN] ,[CSKU_CODE] ,[CSKU_NAME] ,[STEPCode] ,[STEPName] ,[Quantity] ,[WORKSHOP_CODE] ,[WORKSHOPSEQ] ,[STEPSEQ] ,[roumap] ,[EBDOC] ,[QtyofSize],STEP_PRICE,Type,PLEntry,FACTORY_CODE,MODEL,C_COLOUR,B_COLOUR,QtyofSizePackage,ISFREESTEP,ISOPTION,KEYVALUE,EXPLAIN1,EXPLAIN) VALUES('" + DocEntry + "','" + (i + 1) + "','','','" + RFID_ID + "','" + dt1.Rows[i]["MappingCode"].ToString() + "','" + dt1.Rows[i]["PackageCode"].ToString() + "'," + dt1.Rows[i]["PackagesQty"].ToString() + "," + dt1.Rows[i]["QtyinPackage"].ToString() + ",'" + dt1.Rows[i]["ProRtEntry"].ToString() + "','" + dt1.Rows[i]["ProRtLine"].ToString() + "'," + dt1.Rows[i]["SN"].ToString() + ",'" + dt1.Rows[i]["CSKU_CODE"].ToString() + "','" + dt1.Rows[i]["CSKU_NAME"].ToString() + "','" + dt1.Rows[i]["STEPCode"].ToString() + "','" + dt1.Rows[i]["STEPName"].ToString() + "'," + txtQuantity.Text + ",'" + dt1.Rows[i]["WORKSHOP_CODE"].ToString() + "'," + dt1.Rows[i]["WORKSHOPSEQ"].ToString() + "," + dt1.Rows[i]["STEPSEQ"].ToString() + ",'" + dt1.Rows[i]["roumap"].ToString() + "','" + dt1.Rows[i]["EBDOC"].ToString() + "','" + dt1.Rows[i]["QtyofSize"].ToString() + "'," + ListViewItem.SubItems[7].Text + ",(case when '" + dt1.Rows[i]["Type"].ToString() + "' = 'P' then 'RP' when '" + dt1.Rows[i]["Type"].ToString() + "' = 'S' then 'RS' end),'" + dt1.Rows[i]["PLEntry"].ToString() + "','" + dt1.Rows[i]["FACTORY_CODE"].ToString() + "','" + dt1.Rows[i]["MODEL"].ToString() + "','" + dt1.Rows[i]["C_COLOUR"].ToString() + "','" + dt1.Rows[i]["B_COLOUR"].ToString() + "','" + dt1.Rows[i]["QtyofSizePackage"].ToString() + "','" + dt1.Rows[i]["ISFREESTEP"].ToString() + "','" + dt1.Rows[i]["ISOPTION"].ToString() + "','" + dt1.Rows[i]["KEYVALUE"].ToString() + "','" + dt1.Rows[i]["EXPLAIN1"].ToString() + "','" + dt1.Rows[i]["EXPLAIN"].ToString() + "')"); sqlstrs.Add(@"INSERT INTO [Doc_Prodcutpackage14] ([DocEntry] ,[Doc1_LINE_ID] ,[Doc11_LINE_ID] ,[Doc12_LINE_ID] ,[RFID_ID] ,[MappingCode] ,[PackageCode] ,[PackagesQty] ,[QtyinPackage] ,[ProRtEntry] ,[ProRtLine] ,[SN] ,[CSKU_CODE] ,[CSKU_NAME] ,[STEPCode] ,[STEPName] ,[Quantity] ,[WORKSHOP_CODE] ,[WORKSHOPSEQ] ,[STEPSEQ] ,[roumap] ,[EBDOC] ,[QtyofSize],STEP_PRICE,Type,PLEntry,FACTORY_CODE,MODEL,C_COLOUR,B_COLOUR,QtyofSizePackage,ISFREESTEP,ISOPTION,KEYVALUE,EXPLAIN1,EXPLAIN) VALUES('" + DocEntry + "','" + (i + 1) + "','','','" + RFID_ID + "','" + dt1.Rows[i]["MappingCode"].ToString() + "','" + dt1.Rows[i]["PackageCode"].ToString() + "'," + dt1.Rows[i]["PackagesQty"].ToString() + "," + dt1.Rows[i]["QtyinPackage"].ToString() + ",'" + dt1.Rows[i]["ProRtEntry"].ToString() + "','" + dt1.Rows[i]["ProRtLine"].ToString() + "'," + dt1.Rows[i]["SN"].ToString() + ",'" + dt1.Rows[i]["CSKU_CODE"].ToString() + "','" + dt1.Rows[i]["CSKU_NAME"].ToString() + "','" + dt1.Rows[i]["STEPCode"].ToString() + "','" + dt1.Rows[i]["STEPName"].ToString() + "'," + txtQuantity.Text + ",'" + dt1.Rows[i]["WORKSHOP_CODE"].ToString() + "'," + dt1.Rows[i]["WORKSHOPSEQ"].ToString() + "," + dt1.Rows[i]["STEPSEQ"].ToString() + ",'" + dt1.Rows[i]["roumap"].ToString() + "','" + dt1.Rows[i]["EBDOC"].ToString() + "','" + dt1.Rows[i]["QtyofSize"].ToString() + "'," + ListViewItem.SubItems[7].Text + ",(case when '" + dt1.Rows[i]["Type"].ToString() + "' = 'P' then 'RP' when '" + dt1.Rows[i]["Type"].ToString() + "' = 'S' then 'RS' end),'" + dt1.Rows[i]["PLEntry"].ToString() + "','" + dt1.Rows[i]["FACTORY_CODE"].ToString() + "','" + dt1.Rows[i]["MODEL"].ToString() + "','" + dt1.Rows[i]["C_COLOUR"].ToString() + "','" + dt1.Rows[i]["B_COLOUR"].ToString() + "','" + dt1.Rows[i]["QtyofSizePackage"].ToString() + "','" + dt1.Rows[i]["ISFREESTEP"].ToString() + "','" + dt1.Rows[i]["ISOPTION"].ToString() + "','" + dt1.Rows[i]["KEYVALUE"].ToString() + "','" + dt1.Rows[i]["EXPLAIN1"].ToString() + "','" + dt1.Rows[i]["EXPLAIN"].ToString() + "')"); } //更新RFID卡状态 sqlstrs.Add("update Tm_RFID set STATUS = 'F' where RFIDLUN = '" + RFID_ID + "' "); sqlstrs.Add("update dbo.Doc_RejectPackage set RFID_ID1 = '" + RFID_ID + "',STATUS = 'T' where DocEntry = '" + DocEntry + "'"); //更新原来卡数量 sqlstrs.Add("update Doc_Prodcutpackage13 set QtyinPackage = QtyinPackage - " + txtQuantity.Text + " where RFID_ID = '" + txtRFID.Text + "' and EBDOC = '" + txtEBNum.Text + "' and CSKU_CODE = '" + txtCSKU_CODE.Text + "'"); sqlstrs.Add("delete from Doc_Prodcutpackage13 where RFID_ID = '" + txtRFID.Text + "' and EBDOC = '" + txtEBNum.Text + "' and CSKU_CODE = '" + txtCSKU_CODE.Text + "' and QtyinPackage = 0"); sqlstrs.Add("update Doc_Prodcutpackage14 set QtyinPackage = QtyinPackage - " + txtQuantity.Text + " where cast(DocEntry as nvarchar)+'#'+cast(Doc1_LINE_ID as nvarchar)+'#'+cast(Doc11_LINE_ID as nvarchar)+'#'+cast(Doc12_LINE_ID as nvarchar)+'#'+Type in (select cast(DocEntry as nvarchar)+'#'+cast(Doc1_LINE_ID as nvarchar)+'#'+cast(Doc11_LINE_ID as nvarchar)+'#'+cast(Doc12_LINE_ID as nvarchar)+'#'+Type from Doc_Prodcutpackage13 where RFID_ID = '" + txtRFID.Text + "' and EBDOC = '" + txtEBNum.Text + "' and CSKU_CODE = '" + txtCSKU_CODE.Text + "')"); result = FunPublic.RunSqls(sqlstrs); if (result.Status == 1) { //lueSTATUS.EditValue = "T"; txtRFID_New.Text = RFID_ID; } else { MessageBox.Show(result.Message, "提示"); } } else if (BitConverter.ToString(pszData, 11, 1) == "0D") {//员工卡 MessageBox.Show("请刷物料卡!"); return; } CommonClass.PlaySoundBeep(); } else { txtRFID_New.Text = ""; MessageBox.Show("刷卡失败!"); } } } else {//刷旧卡 if (RFID_ID == "") { txtRFID.Text = ""; cmbType.Text = ""; txtQuantity.Text = ""; cmbfree.Text = ""; cmbRejectStation.Items.Clear(); cmbRejectStation.Text = ""; cmbRejectStationf.Items.Clear(); cmbRejectStationf.Text = ""; cmbReason.Text = ""; txtEBNum.Text = ""; txtCSKU_CODE.Text = ""; txtPackageCode.Text = ""; listView1.Items.Clear(); MessageBox.Show("刷卡失败!"); } else { txtRFID.Text = ""; cmbType.Text = ""; txtQuantity.Text = ""; cmbfree.Text = ""; cmbRejectStation.Items.Clear(); cmbRejectStation.Text = ""; cmbRejectStationf.Items.Clear(); cmbRejectStationf.Text = ""; cmbReason.Text = ""; txtEBNum.Text = ""; txtCSKU_CODE.Text = ""; txtPackageCode.Text = ""; listView1.Items.Clear(); 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; string DeviceName = FunPublic.GetDeviceName(); DataTable dt = FunPublic.GetDt("select top 1 * from Doc_DailyReport where RFID_ID = '" + RFID_ID + "' and DOC_DATE >= DATEADD(YEAR,-1,GETDATE()) order by DOC_DATE desc"); if (dt.Rows.Count > 0) { DataTable dt1 = FunPublic.GetDt("select STEPCode cd,STEPName nm,ID,StaffCode from Doc_DailyReport where RFID_ID = '" + RFID_ID + "' and EBDOC = '" + dt.Rows[0]["EBDOC"].ToString() + "' and SN = '" + dt.Rows[0]["SN"].ToString() + "' and PackageCode = '" + dt.Rows[0]["PackageCode"].ToString() + "'"); for (int i = 0; i < dt1.Rows.Count; i++) { cmbRejectStation.Items.Add(dt1.Rows[i]["cd"].ToString() + "-" + dt1.Rows[i]["nm"].ToString()); cmbRejectStationf.Items.Add(dt1.Rows[i]["cd"].ToString() + "-" + dt1.Rows[i]["nm"].ToString()); } txtPackageCode.Text = dt.Rows[0]["PackageCode"].ToString(); txtCSKU_CODE.Text = dt.Rows[0]["CSKU_CODE"].ToString(); txtEBNum.Text = dt.Rows[0]["EBDOC"].ToString(); } else { MessageBox.Show("此包还没有完工工序!", "提示"); } } else if (BitConverter.ToString(pszData, 11, 1) == "0D") {//员工卡 MessageBox.Show("请刷物料卡!"); return; } CommonClass.PlaySoundBeep(); } else { txtRFID.Text = ""; cmbType.Text = ""; txtQuantity.Text = ""; cmbfree.Text = ""; cmbRejectStation.Items.Clear(); cmbRejectStation.Text = ""; cmbRejectStationf.Items.Clear(); cmbRejectStationf.Text = ""; cmbReason.Text = ""; txtEBNum.Text = ""; txtCSKU_CODE.Text = ""; txtPackageCode.Text = ""; listView1.Items.Clear(); MessageBox.Show("刷卡失败!"); } } } } catch (Exception ex) { txtRFID.Text = ""; cmbType.Text = ""; txtQuantity.Text = ""; cmbfree.Text = ""; cmbRejectStation.Items.Clear(); cmbRejectStation.Text = ""; cmbRejectStationf.Items.Clear(); cmbRejectStationf.Text = ""; cmbReason.Text = ""; txtEBNum.Text = ""; txtCSKU_CODE.Text = ""; txtPackageCode.Text = ""; listView1.Items.Clear(); MessageBox.Show("刷卡失败!" + ex.Message); } }
//提交 private void Submit(string DeviceName, ref List <string> strSqls) { //获取车间类型 DataTable workshop = FunPublic.GetDt("select WORKSHOP_CODE from dbo.Tm_Station t0 where ReaderCode = '" + DeviceName + @"' 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 ("1007".Equals(workshop.Rows[0]["WORKSHOP_CODE"]))//收发室 1:主路线 5:内衬 { if (txtRoumap1.Text == "主路线") { strSqls.Add("update Doc_WorkshopGR set NcMappingStatus ='Y' where NcMappingStatus ='N' AND RFID_ID ='" + txtRFID2.Text + "' AND STEPCode =(select value from Ts_Config where [KEY]='FMappinNC') AND MappingCode ='" + txtMappingCode.Text + "' AND roumap ='5'"); strSqls.Add("update Doc_WorkshopGR set NcMappingStatus ='Y' where NcMappingStatus ='N' AND RFID_ID ='" + txtRFID1.Text + "' AND STEPCode =(select value from Ts_Config where [KEY]='FMappingMain') AND MappingCode ='" + txtMappingCode.Text + "' AND roumap ='1'"); } else if (txtRoumap1.Text == "内衬路线") { strSqls.Add("update Doc_WorkshopGR set NcMappingStatus ='Y' where NcMappingStatus ='N' AND RFID_ID ='" + txtRFID2.Text + "' AND STEPCode =(select value from Ts_Config where [KEY]='FMappingMain') AND MappingCode ='" + txtMappingCode.Text + "' AND roumap ='1'"); strSqls.Add("update Doc_WorkshopGR set NcMappingStatus ='Y' where NcMappingStatus ='N' AND RFID_ID ='" + txtRFID1.Text + "' AND STEPCode =(select value from Ts_Config where [KEY]='FMappinNC') AND MappingCode ='" + txtMappingCode.Text + "' AND roumap ='5'"); } } else if ("1005".Equals(workshop.Rows[0]["WORKSHOP_CODE"]))//完成线 1:主路线 2:帽眉 7:后带 { if (txtRoumap1.Text == "主路线" && txtRoumap2.Text == "后带路线") { strSqls.Add(@"update Doc_WorkshopGR set HdMappingStatus ='Y' WHERE RFID_ID ='" + txtRFID2.Text + "' AND MappingCode ='" + txtMappingCode.Text + @"' AND HdMappingStatus ='N' AND STEPCode in(select value from Ts_Config where [KEY]='SMappingHD') AND roumap = 7"); strSqls.Add(@"update Doc_WorkshopGR set HdMappingStatus ='Y' WHERE RFID_ID ='" + txtRFID1.Text + "' AND MappingCode ='" + txtMappingCode.Text + @"' AND roumap = 1 AND STEPCode in(select value from Ts_Config where [KEY]='SMappingMain') AND HdMappingStatus ='N'"); } else if (txtRoumap1.Text == "主路线" && txtRoumap2.Text == "帽眉路线") { strSqls.Add(@"update Doc_WorkshopGR set MmMappingStatus ='Y' WHERE RFID_ID ='" + txtRFID2.Text + "' AND MappingCode ='" + txtMappingCode.Text + @"' AND MmMappingStatus ='N' AND STEPCode in(select value from Ts_Config where [KEY]='SMappingMM') AND roumap = 2"); strSqls.Add(@"update Doc_WorkshopGR set MmMappingStatus ='Y' WHERE RFID_ID ='" + txtRFID1.Text + "' AND MappingCode ='" + txtMappingCode.Text + @"' AND roumap = 1 AND STEPCode in(select value from Ts_Config where [KEY]='SMappingMain') AND MmMappingStatus ='N'"); } else if (txtRoumap1.Text == "帽眉路线") { strSqls.Add(@"update Doc_WorkshopGR set MmMappingStatus ='Y' WHERE RFID_ID ='" + txtRFID2.Text + "' AND MappingCode ='" + txtMappingCode.Text + @"' AND roumap = 1 AND STEPCode in(select value from Ts_Config where [KEY]='SMappingMain') AND MmMappingStatus ='N'"); strSqls.Add(@"update Doc_WorkshopGR set MmMappingStatus ='Y' WHERE RFID_ID ='" + txtRFID1.Text + "' AND MappingCode ='" + txtMappingCode.Text + @"' AND MmMappingStatus ='N' AND STEPCode in(select value from Ts_Config where [KEY]='SMappingMM') AND roumap = 2"); } else if (txtRoumap1.Text == "后带路线") { strSqls.Add(@"update Doc_WorkshopGR set HdMappingStatus ='Y' WHERE RFID_ID ='" + txtRFID2.Text + "' AND MappingCode ='" + txtMappingCode.Text + @"' AND roumap = 1 AND STEPCode in(select value from Ts_Config where [KEY]='SMappingMain') AND HdMappingStatus ='N'"); strSqls.Add(@"update Doc_WorkshopGR set HdMappingStatus ='Y' WHERE RFID_ID ='" + txtRFID1.Text + "' AND MappingCode ='" + txtMappingCode.Text + @"' AND HdMappingStatus ='N' AND STEPCode in(select value from Ts_Config where [KEY]='SMappingHD') AND roumap = 7"); } } }
private void btnSubmit_Click(object sender, EventArgs e) { if (cmbCardCode.Text == "") { MessageBox.Show("请选择供应商!"); return; } if (txtRFID.Text == "") { MessageBox.Show("请刷物料卡!"); return; } string DeviceName = FunPublic.GetDeviceName(); List <string> strSqls = new List <string>(); strSqls.Add(@"declare @MaxDoc as int declare @DocEntry as int select @MaxDoc = isnull(MAX(DocEntry),0) + 1 from Doc_OSGoodsRec select @DocEntry = MIN(t0.DocEntry) from Doc_OSGoodsIssu t0 inner join Doc_OSGoodsIssu1 t1 on t0.DocEntry = t1.DocEntry and t0.STATUS = 'O' and t1.RFID_ID = '" + txtRFID.Text + @"' and t0.BPCode = '" + cmbCardCode.Text.Substring(0, cmbCardCode.Text.IndexOf('-')) + @"' and t1.LINESTATUS not in ('C','F') insert into Doc_OSGoodsRec(DocEntry,DOC_DATE,BPCode,BPName,CREATED,STATUS,FACTORY_CODE,BaseEntry) select @MaxDoc,getdate(),BPCode,BPName,CREATED,'O',FACTORY_CODE,@DocEntry from Doc_OSGoodsIssu where DocEntry = @DocEntry insert into Doc_OSGoodsRec1(DocEntry,LINE_ID,PONUM,EBDOC,PRODOC,CSKU_CODE,SN,CSKU_NAME,PackageCode,RFID_ID,Quantity,BaseEntry,BaseDoc1_Line,BaseDoc11_Line,BaseDoc12_Line,Type,STEPCode,STEPName,STEPSEQ,EXPLAIN1,GRQtyp,QtyofReject,QtyofRepair,MappingCode) select @MaxDoc,LINE_ID,PONUM,EBDOC,PRODOC,CSKU_CODE,SN,CSKU_NAME,PackageCode,RFID_ID,Quantity,BaseEntry,BaseDoc1_Line,BaseDoc11_Line,BaseDoc12_Line,Type,STEPCode,STEPName,STEPSEQ,EXPLAIN1,GRQtyp,QtyofReject,QtyofRepair,MappingCode from Doc_OSGoodsIssu1 where DocEntry = @DocEntry update Doc_OSGoodsIssu set STATUS = 'F' where DocEntry = @DocEntry update Doc_OSGoodsIssu1 set LINESTATUS = 'F' where DocEntry = @DocEntry if not exists(select * from Ts_Config where [Key] = 'BPCode' and Value = '" + cmbCardCode.Text.Substring(0, cmbCardCode.Text.IndexOf('-')) + @"') begin update Doc_Prodcutpackage14 set STATUS = 'F' where cast(DocEntry as nvarchar)+'#'+cast(Doc1_LINE_ID as nvarchar)+'#'+cast(Doc11_LINE_ID as nvarchar)+'#'+cast(Doc12_LINE_ID as nvarchar)+'#'+cast(Type as nvarchar) in (select cast(BaseEntry as nvarchar)+'#'+cast(BaseDoc1_Line as nvarchar)+'#'+cast(BaseDoc11_Line as nvarchar)+'#'+cast(BaseDoc12_Line as nvarchar)+'#'+cast(Type as nvarchar) from Doc_OSGoodsIssu1 where DocEntry = @DocEntry ) and RFID_ID = '" + txtRFID.Text + @"' end "); result = FunPublic.RunSqls(strSqls); if (result.Status == 1) { string RFID_ID = txtRFID.Text; //MessageBox.Show("提交成功!"); txtRFID.Text = ""; //cmbCardCode.Text = ""; txtEBNum.Text = ""; txtPackageCode.Text = ""; txtSN.Text = ""; txtQuantity.Text = ""; RFID_15693.freeMode(); CommonClass.SoftDecoding_Deinit(); DataTable dt = FunPublic.GetDt("exec [PDA_MappingQuery] '" + RFID_ID + "','4','',''"); if (dt.Rows.Count > 0) { FrmOSMapping FrmMapping = new FrmOSMapping(); FrmMapping.txtRFID1.Text = RFID_ID; FrmMapping.txtMappingCode.Text = dt.Rows[0]["MappingCode"].ToString(); FrmMapping.txtEBNum.Text = dt.Rows[0]["EBDOC"].ToString(); FrmMapping.txtPackageCode.Text = dt.Rows[0]["PackageCode"].ToString(); FrmMapping.txtSN.Text = dt.Rows[0]["SN"].ToString(); FrmMapping.txtQuantity.Text = dt.Rows[0]["Quantity"].ToString(); FrmMapping.model = "弹窗"; FrmMapping.ShowDialog(); FrmMapping.txtRFID2.Focus(); CommonClass.SoftDecoding_Init(); CommonClass.SoftDecoding_Select_ScanMode(); CommonClass.CreaterDirectory(CommonClass.Path); CommonClass.Path += "\\2D_S_CodeType.txt";//把保存的文件存放在当前目录的前目录的File文件夹 RFID_15693.InitModule(); if (!System.IO.File.Exists(CommonClass.Path))//如果文件不存在,表示首次打开程序,将扫描头未开启的常用条码保存在文件里面 { List <string> listData = new List <string>(); for (int k = 0; k < CommonClass.strCodeType.Length / 3; k++) { if (CommonClass.strCodeType[k, 0, 0] != "Composite CC-A/B")//Composite CC-A/B默认不开启,所以不记录 { listData.Add(CommonClass.strCodeType[k, 0, 0] + "," + CommonClass.strCodeType[k, 0, 1] + ",1"); } } CommonClass.SaveFile(CommonClass.Path, listData); } byte[] by = new byte[6]; List <string> listCodeType = new List <string>();//得到上次保存的条码类型的数据 CommonClass.ReadFile(CommonClass.Path, ref listCodeType); for (int k = 0; k < listCodeType.Count; k++) { byte[] data = BitConverter.GetBytes(Int32.Parse(listCodeType[k].Split(',')[1])); for (int t = 0; t < data.Length; t++) { by[t] = data[t]; } by[4] = 1; by[5] = 1; CommonClass.SoftDecoding_BarcodeType_OnOff(by, by.Length); System.Threading.Thread.Sleep(10); } byte[] data2 = BitConverter.GetBytes(716); byte[] by2 = new byte[] { 0, 0, 0, 0, 1, 0 };//402,2开启 Array.Copy(data2, 0, by2, 0, 4); CommonClass.SoftDecoding_BarcodeType_OnOff(by2, by2.Length); } } else { MessageBox.Show(result.Message); } }
private void btnSubmit_Click(object sender, EventArgs e) { if (txtRFID1.Text == "" || txtRFID2.Text == "") { MessageBox.Show("请刷物料卡!"); return; } try { string DeviceName = FunPublic.GetDeviceName(); List <string> strSqls = new List <string>(); //提交 Submit(DeviceName.Substring(1, DeviceName.Length - 1), ref strSqls); //回收卡不包括主路线 string rfid = string.Empty; string roumap = string.Empty; if (txtRoumap1.Text != "主路线") { rfid = txtRFID1.Text; roumap = txtRoumap1.Text; } else { rfid = txtRFID2.Text; roumap = txtRoumap2.Text; } string sql = @"if not exists(select DocEntry from Doc_Prodcutpackage13 where RFID_ID = '" + rfid + @"') begin update Tm_RFID set STATUS = 'O' where RFIDLUN = '" + rfid + @"' declare @MaxDoc as int select @MaxDoc = isnull(max(DocEntry) + 1,1) from Doc_recRFID INSERT INTO [Doc_recRFID]([DocEntry],[CREATED],[DOC_DATE],[EBDOC],[SN],[PackageCode],[RFID_ID],[roumap]) select top 1 @MaxDoc,'" + FunPublic.CurrentUser + "',getdate(),'" + txtEBNum.Text + "','" + txtSN.Text + "','" + txtPackageCode.Text + "','" + rfid + "',roumap from Doc_Prodcutpackage14 where RFID_ID='" + rfid + "' and EBDOC='" + txtEBNum.Text + @"' end"; strSqls.Add(sql); result = FunPublic.RunSqls(strSqls); if (result.Status == 1) { //如果此PDA属于完成线,判断主路线是否还有可以配货的卡片,并且将窗体标题改为对应路线 if (txtRoumap1.Text == "主路线" && (txtRoumap2.Text == "后带路线" || txtRoumap2.Text == "帽眉路线")) { string strsql = @"SELECT *,roumapName= (select name from Tm_roumap where DocEntry = roumap) FROM Doc_WorkshopGR WHERE MappingCode ='" + txtMappingCode.Text + @"' AND ((MmMappingStatus ='N' AND STEPCode in(select value from Ts_Config where [KEY]='SMappingMM') AND roumap = 2) OR (HdMappingStatus ='N' AND STEPCode in(select value from Ts_Config where [KEY]='SMappingHD') AND roumap = 7))"; DataTable dt = FunPublic.GetDt(strsql); if (dt.Rows.Count > 0) { this.Text = "配货 -" + dt.Rows[0]["roumapName"].ToString(); txtRFID2.Text = ""; txtRoumap2.Text = ""; } else { txtRFID2.Text = ""; txtRoumap2.Text = ""; txtRFID1.Text = ""; txtRoumap1.Text = ""; txtMappingCode.Text = ""; txtEBNum.Text = ""; txtPackageCode.Text = ""; txtSN.Text = ""; txtQuantity.Text = ""; } } else { txtRFID2.Text = ""; txtRoumap2.Text = ""; txtRFID1.Text = ""; txtRoumap1.Text = ""; txtMappingCode.Text = ""; txtEBNum.Text = ""; txtPackageCode.Text = ""; txtSN.Text = ""; txtQuantity.Text = ""; if ("弹窗".Equals(model)) { this.Close(); } } } else { MessageBox.Show(result.Message); } this.panel1.Visible = false; } catch (Exception ex) { MessageBox.Show(ex.Message); } }
/// <summary> /// 扫描条码 /// </summary> private void BarCode_Scan() { try { string RFID_ID = Barcode.scan(); 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 { if (RFID_ID.Substring(0, 1) == "2") {//物料卡 txtRFID.Text = RFID_ID; 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 (RFID_ID.Substring(0, 1) == "1") {//员工卡 MessageBox.Show("请刷物料卡!"); return; } CommonClass.PlaySoundBeep(); } } 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 Mapping(string DeviceName) { string strsql = string.Empty; string rfid = txtRFID2.Text; string mappingcode = txtMappingCode.Text; string roumap = txtRoumap1.Text; //判断PDA的车间类型是否满足条件 DataTable workshop = FunPublic.GetDt("select WORKSHOP_CODE from dbo.Tm_Station t0 where ReaderCode = '" + DeviceName + @"' 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) { MessageBox.Show("车间类型不正确"); txtRFID2.Text = ""; return; } if ("1007".Equals(workshop.Rows[0]["WORKSHOP_CODE"]))//收发室 1:主路线 5:内衬 { if (txtRoumap1.Text == "主路线") { strsql = "select *,roumapName= (select name from Tm_roumap where DocEntry = roumap) from Doc_WorkshopGR where NcMappingStatus ='N' AND RFID_ID ='" + txtRFID2.Text + "' AND STEPCode =(select value from Ts_Config where [KEY]='FMappinNC') AND MappingCode ='" + mappingcode + "' AND roumap ='5'"; } else if (txtRoumap1.Text == "内衬路线") { strsql = "select *,roumapName= (select name from Tm_roumap where DocEntry = roumap) from Doc_WorkshopGR where NcMappingStatus ='N' AND RFID_ID ='" + txtRFID2.Text + "' AND STEPCode =(select value from Ts_Config where [KEY]='FMappingMain') AND MappingCode ='" + mappingcode + "' AND roumap ='1'"; } else { MessageBox.Show("路线与收发室不匹配"); txtRFID2.Text = ""; return; } } else if ("1005".Equals(workshop.Rows[0]["WORKSHOP_CODE"]))//完成线 1:主路线 2:帽眉 7:后带 { if (txtRoumap1.Text == "主路线") { strsql = @"SELECT *,roumapName= (select name from Tm_roumap where DocEntry = roumap) FROM Doc_WorkshopGR WHERE RFID_ID ='" + txtRFID2.Text + "' AND MappingCode ='" + mappingcode + @"' AND ((MmMappingStatus ='N' AND STEPCode in(select value from Ts_Config where [KEY]='SMappingMM') AND roumap = 2) OR (HdMappingStatus ='N' AND STEPCode in(select value from Ts_Config where [KEY]='SMappingHD') AND roumap = 7))"; } else if (txtRoumap1.Text == "后带路线" || txtRoumap1.Text == "帽眉路线") { strsql = @"SELECT *,roumapName= (select name from Tm_roumap where DocEntry = roumap) FROM Doc_WorkshopGR WHERE RFID_ID ='" + txtRFID2.Text + "' AND MappingCode ='" + mappingcode + @"' AND roumap = 1 AND STEPCode in(select value from Ts_Config where [KEY]='SMappingMain') AND (MmMappingStatus ='N' OR HdMappingStatus ='N')"; } else { MessageBox.Show("路线与完成线不匹配"); txtRFID2.Text = ""; return; } } DataTable dt = FunPublic.GetDt(strsql); if (dt.Rows.Count == 0) { MessageBox.Show("没有找到对应工序"); txtRFID2.Text = ""; return; } txtRoumap2.Text = dt.Rows[0]["roumapName"].ToString(); this.panel1.Visible = true; }