private void btnSubmit_Click(object sender, EventArgs e) { if (cmbCardCode.Text == "") { MessageBox.Show("请选择供应商!"); return; } if (txtRFID.Text == "") { MessageBox.Show("请刷物料卡!"); return; } if (txtEBNum.Text == "") { MessageBox.Show("此供应商下无此包外发!"); return; } string DeviceName = FunPublic.GetDeviceName(); List <string> strSqls = new List <string>(); strSqls.Add(@"declare @MaxDoc as int select @MaxDoc = isnull(MAX(DocEntry),0) + 1 from Doc_OSGoodsIssu select t1.FACTORY_CODE,t1.PONUM,t1.EBDOC,t1.PRODOC,t0.CSKU_CODE,t0.SN,t0.CSKU_NAME,t0.PackageCode,t0.RFID_ID,t0.QtyinPackage,t0.DocEntry,t0.Doc1_LINE_ID,t0.Doc11_LINE_ID,t0.Doc12_LINE_ID,t0.STEPCode,t0.STEPName,t0.STEPSEQ,t4.EXPLAIN1,t0.MappingCode,t0.C_COLOUR,t0.B_COLOUR,t0.STEP_PRICE,t0.PackagesQty,t0.Type,t0.MODEL into #t1 from Doc_Prodcutpackage13 t0 inner join Doc_Prodcutpackage t1 on t0.DocEntry = t1.DocEntry inner join Doc_Osplanning t2 on t0.PLEntry = t2.BaseEntry inner join Doc_Osplanning1 t3 on t2.DocEntry = t3.DocEntry and t0.CSKU_CODE = t3.CSKU_CODE inner join Doc_Osplanning11 t4 on t3.DocEntry = t4.DocEntry and t3.LINE_ID = t4.Doc1_LINE_ID and t4.STEPCode = t0.STEPCode where t0.RFID_ID = '" + txtRFID.Text + @"' and t4.outsourcBP = '" + cmbCardCode.Text.Substring(0, cmbCardCode.Text.IndexOf('-')) + @"' insert into Doc_OSGoodsIssu(DocEntry,DOC_DATE,BPCode,BPName,CREATED,STATUS,FACTORY_CODE) values(@MaxDoc,GETDATE(),'" + cmbCardCode.Text.Substring(0, cmbCardCode.Text.IndexOf('-')) + "','" + cmbCardCode.Text.Substring(cmbCardCode.Text.LastIndexOf("-") + 1) + "'," + FunPublic.CurrentUser + @",'O',(select distinct FACTORY_CODE from #t1)) insert into Doc_OSGoodsIssu1(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,C_COLOUR,B_COLOUR,STEP_PRICE,PackagesQty,MODEL) select @MaxDoc,ROW_NUMBER() over(order by SN),PONUM,EBDOC,PRODOC,CSKU_CODE,SN,CSKU_NAME,PackageCode,RFID_ID,QtyinPackage,DocEntry,Doc1_LINE_ID,Doc11_LINE_ID,Doc12_LINE_ID,Type,STEPCode,STEPName,STEPSEQ,EXPLAIN1,0,0,0,MappingCode,C_COLOUR,B_COLOUR,STEP_PRICE,PackagesQty,MODEL from #t1 where STEPSEQ = (select MIN(STEPSEQ) from #t1) delete from Doc_Prodcutpackage13 where RFID_ID = '" + txtRFID.Text + @"' and cast(DocEntry as nvarchar(30))+'#'+cast(Doc1_LINE_ID as nvarchar(30))+'#'+cast(Doc11_LINE_ID as nvarchar(30))+cast(Doc12_LINE_ID as nvarchar(30)) in (select cast(DocEntry as nvarchar(30))+'#'+cast(Doc1_LINE_ID as nvarchar(30))+'#'+cast(Doc11_LINE_ID as nvarchar(30))+cast(Doc12_LINE_ID as nvarchar(30)) from #t1) drop table #t1 "); strSqls.Add(@"declare @MaxDoc as int select @MaxDoc = isnull(MAX(DocEntry),0) from Doc_OSGoodsIssu declare @PlanningDoc as int select @PlanningDoc = BaseEntry from Doc_Prodcutpackage where DocEntry = (select top 1 BaseEntry from Doc_OSGoodsIssu1 where DocEntry = @MaxDoc) update Doc_Osplanning1 set FHQty = FHQty + " + txtQuantity.Text + " where DocEntry in (select DocEntry from Doc_Osplanning where BaseEntry = @PlanningDoc) and SN = '" + txtSN.Text + "'"); result = FunPublic.RunSqls(strSqls); if (result.Status == 1) { //MessageBox.Show("提交成功!"); txtRFID.Text = ""; //cmbCardCode.Text = ""; txtEBNum.Text = ""; txtPackageCode.Text = ""; txtSN.Text = ""; txtQuantity.Text = ""; } else { MessageBox.Show(result.Message); } }
private void btnSubmit_Click(object sender, EventArgs e) { if (txtRFID1.Text == "" || txtRFID2.Text == "") { MessageBox.Show("请刷物料卡!"); return; } List <string> strSqls = new List <string>(); strSqls.Add(@"update t0 set t0.OsMappingStatus='Y' from Doc_WorkshopGR t0 inner join ( select Result as STEPCode from dbo.Fun_SplitStr((select Value from Ts_Config where [Key] = 'MappingOs'),'#') ) t1 on t0.STEPCode = t1.STEPCode where t0.MappingCode = '" + txtMappingCode.Text + "' and t0.RFID_ID='" + txtRFID1.Text + "'"); strSqls.Add(@"update t0 set t0.OsMappingStatus='Y' from Doc_WorkshopGR t0 inner join ( select Result as STEPCode from dbo.Fun_SplitStr((select Value from Ts_Config where [Key] = 'MappingOs'),'#') ) t1 on t0.STEPCode = t1.STEPCode where t0.MappingCode = '" + txtMappingCode.Text + "' and t0.RFID_ID='" + txtRFID2.Text + "'"); strSqls.Add(@"update t0 set MappingStatus = 'Y' from Doc_OSGoodsIssu1 t0 where DocEntry =(SELECT MAX(DocEntry) FROM Doc_OSGoodsIssu1 WHERE LINESTATUS='F' AND RFID_ID='" + txtRFID1.Text + "')"); strSqls.Add(@"update t0 set MappingStatus = 'Y' from Doc_OSGoodsIssu1 t0 where DocEntry =(SELECT MAX(DocEntry) FROM Doc_OSGoodsIssu1 WHERE LINESTATUS='F' AND RFID_ID='" + txtRFID2.Text + "')"); //回收卡 string sql = @"if not exists(select count(1) from Doc_Prodcutpackage13 where RFID_ID = '" + txtRFID1.Text + @"' and not exists(select count(1) from Doc_OSGoodsIssu1 where RFID_ID='" + txtRFID1.Text + @"' and LINESTATUS ='O') and NOT EXISTS( select count(1) from Doc_OSGoodsIssu1 where LINESTATUS = 'F' AND ISNULL(MappingStatus,'N')='N' AND RFID_ID ='" + txtRFID1.Text + @"')) begin update Tm_RFID set STATUS = 'O' where RFIDLUN = '" + txtRFID1.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 + "','" + txtRFID1.Text + "',roumap from Doc_Prodcutpackage14 where RFID_ID='" + txtRFID1.Text + "' and EBDOC='" + txtEBNum.Text + @"' and MappingCode = '" + txtMappingCode.Text + @"' end"; strSqls.Add(sql); result = FunPublic.RunSqls(strSqls); if (result.Status == 1) { txtRFID1.Text = ""; txtRFID2.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; }
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 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); } }
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); } }
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); } }
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 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); } }