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);
}
}