manipulate.cpp

这是我给一个做射频卡的公司做的小程序

//	UpdateData(FALSE);

}
else
{
	AfxMessageBox("没有检测到标签%d",LableNum);
}


	CString str,strSQL;
	CRecordset rs(&db); // 数据集
	UpdateData(); // 更新数据
		if(m_pro.IsEmpty()) // 制造商为空则返回
	{
		AfxMessageBox("制造商不能为空!");
		return;
	}
		//UpdateData(TRUE);
			if(m_name.IsEmpty()) // 产品名称为空则返回
	{
		AfxMessageBox("产品名称不能为空!");
		return;
	}


	rs.Open(CRecordset::forwardOnly,
	"select 分类码 from  产品分类表 where 产品名称='" + m_ctypecode +"'");
	rs.GetFieldValue("分类码", typecodeID);
	rs.Close();



	rs.Open(CRecordset::forwardOnly,
	"select 部件类型码 from  部件类型表 where 部件名称='" + m_cpartscode +"'");
	rs.GetFieldValue("部件类型码", partscodeID);
	rs.Close();


	rs.Open(CRecordset::forwardOnly,
	"select 年号 from  年份表 where 年='" + m_cyear +"'");
	rs.GetFieldValue("年号", yearID);
	rs.Close();



	rs.Open(CRecordset::forwardOnly,
	"select 月号 from  月份表 where 月份='" + m_cmanth +"'");
	rs.GetFieldValue("月号", monthID);
	rs.Close();



	rs.Open(CRecordset::forwardOnly,
	"select 保修号 from  保修期 where 时间='" + m_crepaire +"'");
	rs.GetFieldValue("保修号", repaireID);
	rs.Close();

	code.Format("%s%s%s%s%s",m_ctype,typecodeID,partscodeID,yearID,monthID);
	



	//生成序列号
	CString temp;
	CString strtype,strtypecode,strpartscode,stryear,strmanth;

	int shujuliang=0;			//数据库中的总的数据量
	
	int num=1;				//数据库中的重复的数据量

	rs.Open(CRecordset::forwardOnly, "select * from 产品表");

	while(!rs.IsEOF())
	{
		rs.GetFieldValue("产品类别", strtype);
		rs.GetFieldValue("分类码",strtypecode);
		rs.GetFieldValue("部件类型码",strpartscode);
		rs.GetFieldValue("年",stryear);
		rs.GetFieldValue("月",strmanth);
		str=str.Left(13);
		//AfxMessageBox(str);
		if(strtype==m_ctype&&strtypecode==m_ctypecode&&strpartscode==m_cpartscode&&stryear==m_cyear&&strmanth==m_cmanth)
				num++;

		rs.MoveNext();
		shujuliang++;
	}
	rs.Close();


	if(num<=9)
	{
	temp.Format("00%d",num);
	}
	else if(num<=99)
	{
		temp.Format("0%d%d",num/10,num%10);

	}
	else
	{
		temp.Format("%d%d%d",num/100,(num%10)/10,num%100%10);
	
	}
//	CString str1;
//	str1.Format("请在编号后输入序号%s",temp);
	code.Format("%s%s%s%s%s%s",m_ctype,typecodeID,partscodeID,yearID,monthID,temp);


	m_sequence.Format("%s",temp);
	UpdateData(FALSE);

	
////////////////////////////////////////////////////////////////////////////////////
////////////////////////////////向芯片中写入数据////////////////////////////////////
	//写制造商
	char writedata[4];
	writepro();

	//写产品名称到标签
	writename();

	//写产品编码到标签
	writecode();

	//写生产日期到标签
	for(int i24=0;i24<4;i24++)
	writedata[i24]=date[i24];
	if(!WriteSingleBlock(hCom, 0x00, 0x00,NULL,25, writedata))
	{
		flag=false;
		AfxMessageBox("写入标签第25块失败");
	}

	for(int i25=4;i25<8;i25++)
	writedata[i25-4]=date[i25];
	if(!WriteSingleBlock(hCom, 0x00, 0x00,NULL,26, writedata))
	{
		flag=false;
		AfxMessageBox("写入标签第26块失败");
	}

	//写保修期到标签
	int charnum;
	charnum=strlen(m_crepaire)%4;
	if(strlen(m_crepaire)<4)
	{
		for(int i26=0;i26<charnum;i26++)
		writedata[i26]=m_crepaire[i26];
		if(!WriteSingleBlock(hCom, 0x00, 0x00,NULL,27, writedata))
		{
		flag=false;
		AfxMessageBox("写入标签第27块失败");
		}
	}
	else
	{
		for(int i26=0;i26<4;i26++)
					writedata[i26]=m_crepaire[i26];
		if(!WriteSingleBlock(hCom, 0x00, 0x00,NULL,27, writedata))
		{
		flag=false;
		AfxMessageBox("写入标签第27块失败");
		}
	}
	
	//写用户单位到标签
	writeuser();

	//写维修记录到标签
	writerecord();
	
	UpdateData(FALSE);
	//读出标签UID

////////////////////////////////////////////////////////////////////////////////////
////////////////////////写芯片成功，写如数据库 /////////////////////////////////////
			if(flag==true)
		{
			CString str,strSQL;
			strSQL="insert into 产品表 (芯片号,制造商,产品名称\
			产品类别,分类码,部件类型码,年,月,序列号,\
			出厂日期,保修期,用户单位,维修记录)\
			values('"
			+ m_xinpian + "','" // UID
			+ m_pro + "','" // 制造商
			+ m_name + "','" // 产品名称
			+ m_ctype + "','" // 产品编码
			+ typecodeID + "','" // 产品编码
			+ partscodeID + "','" // 产品编码
			+ yearID + "','" // 产品编码+ m_ctype + "','" // 产品编码
			+ monthID + "','" // 产品编码
			+ temp +"','"//序列号
			+ repaireID + "','" // 产品编码
			+ date + "','" // 出厂日期
			+ m_user + "','" // 用户单位
			+ m_record + "')"; // 维修记录
			db.ExecuteSQL(strSQL); // 执行
			AfxMessageBox("添加并复制成功");
			m_name=_T("广汉科峰电子有限责任公司");
 			m_xinpian=_T("");
			m_pro=_T("");
			m_user=_T("");
			m_record=_T("");
			UpdateData(FALSE);
		}

	
	
}

bool Manipulate::writepro()
{


	CString notice;
	char writedata[4];
	int codlen;
	codlen=strlen(m_pro);
	int blocknum;
	int blockth;
	int charnum;
	if(codlen%4==0)
	{
		blocknum=codlen/4+3;
			for(blockth=3;blockth<blocknum;blockth++)
		{
		for(charnum=0;charnum<4;charnum++)
			writedata[charnum]=m_pro[charnum+4*(blockth-3)];
			if(!WriteSingleBlock(hCom, 0x00, 0x08,NULL,blockth, writedata))
			{
				flag=false;
				notice.Format("写入标签第%d块失败",blockth);
				AfxMessageBox(notice);
			}
		}
	}
	else
	{
		blocknum=codlen/4+1+2;

		for(blockth=3;blockth<blocknum-1;blockth++)
		{
		for(charnum=0;charnum<4;charnum++)
			writedata[charnum]=m_pro[charnum+4*(blockth-3)];
			if(!WriteSingleBlock(hCom, 0x00, 0x08,NULL,blockth, writedata))
			{
				flag=false;
				notice.Format("写入标签第%d块失败",blockth);
				AfxMessageBox(notice);
			}
		}
		
		for(charnum=0;charnum<codlen%4;charnum++)
		{
			writedata[charnum]=m_pro[charnum+(blocknum-3)*4];
		}
		if(!WriteSingleBlock(hCom, 0x00, 0x00,NULL,blockth, writedata))
		{
			flag=false;
			notice.Format("写入标签第%d块失败",blockth);
			AfxMessageBox(notice);
		}
	}


	return flag;

}

bool Manipulate::writename()
{

	
	CString notice;
	char writedata[4];
	int codlen;
	codlen=strlen(m_name);
	int blocknum;
	int blockth;
	int charnum;
	if(codlen%4==0)
	{
		blocknum=codlen/4+11;
			for(blockth=11;blockth<blocknum;blockth++)
		{
		for(charnum=0;charnum<4;charnum++)
			writedata[charnum]=m_name[charnum+4*(blockth-11)];
			if(!WriteSingleBlock(hCom, 0x00, 0x08,NULL,blockth, writedata))
			{
				flag=false;
				notice.Format("写入标签第%d块失败",blockth);
				AfxMessageBox(notice);
			}
		}
	}
	else
	{
		blocknum=codlen/4+1+11;

		for(blockth=11;blockth<blocknum-1;blockth++)
		{
		for(charnum=0;charnum<4;charnum++)
			writedata[charnum]=m_name[charnum+4*(blockth-11)];
			if(!WriteSingleBlock(hCom, 0x00, 0x08,NULL,blockth, writedata))
			{
				flag=false;
				notice.Format("写入标签第%d块失败",blockth);
				AfxMessageBox(notice);
			}
		}
		
		for(charnum=0;charnum<codlen%4;charnum++)
		{
			writedata[charnum]=m_name[charnum+(blocknum-12-1)*4];
		}
		if(!WriteSingleBlock(hCom, 0x00, 0x00,NULL,blocknum-1, writedata))
		{
			flag=false;
			notice.Format("写入标签第%d块失败",blockth);
			AfxMessageBox(notice);
		}
	}


	return flag;
}

bool Manipulate::writecode()
{

	CString notice;
	char writedata[4];
	int codlen;
	codlen=strlen(code);
	int blocknum;
	int blockth;
	int charnum;
	if(codlen%4==0)
	{
		blocknum=strlen(code)/4+21;
		for(blockth=21;blockth<blocknum;blockth++)
		{
			for(charnum=0;charnum<4;charnum++)
			writedata[charnum]=code[charnum+4*(blockth-21)];
			if(!WriteSingleBlock(hCom, 0x00, 0x00,NULL,blockth, writedata))
			{
				flag=false;
				notice.Format("写入标签第%d块失败",blockth);
				AfxMessageBox(notice);
			}
		}
	}
	else
	{
		blocknum=strlen(code)/4+1+21;
			blocknum=strlen(code)/4+21;
		for(blockth=21;blockth<blocknum-1;blockth++)
		{
			for(charnum=0;charnum<4;charnum++)
			writedata[charnum]=code[charnum+4*(blockth-21)];
			if(!WriteSingleBlock(hCom, 0x00, 0x00,NULL,blockth, writedata))
			{
				flag=false;
				notice.Format("写入标签第%d块失败",blockth);
				AfxMessageBox(notice);
			}
		}
		
		for(charnum=0;charnum<codlen%4;charnum++)
		{
		writedata[charnum]=code[charnum+(blocknum-22)*4];
		}
		if(!WriteSingleBlock(hCom, 0x00, 0x00,NULL,blockth, writedata))
		{
		flag=false;
		notice.Format("写入标签第%d块失败",blockth);
		AfxMessageBox(notice);
		}
	}
	return flag;
}
bool Manipulate::writeuser()
{
	CString notice;
	char writedata[4];
	int codlen;
	codlen=strlen(m_user);
	int blocknum;
	int blockth;
	int charnum;
	if(codlen%4==0)
	{
		blocknum=codlen/4+28;
			
		for(blockth=28;blockth<blocknum;blockth++)
		{
		for(charnum=0;charnum<4;charnum++)
			writedata[charnum]=m_user[charnum+4*(blockth-28)];
			if(!WriteSingleBlock(hCom, 0x00, 0x00,NULL,blockth, writedata))
			{
				flag=false;
				notice.Format("写入标签第%d块失败",blockth);
				AfxMessageBox(notice);
			}
		}
	}
	else
	{
		blocknum=codlen/4+1+28;

		for(blockth=28;blockth<blocknum-1;blockth++)
		{
		for(charnum=0;charnum<4;charnum++)
			writedata[charnum]=m_user[charnum+4*(blockth-28)];
			if(!WriteSingleBlock(hCom, 0x00, 0x00,NULL,blockth, writedata))
			{
				flag=false;
				notice.Format("写入标签第%d块失败",blockth);
				AfxMessageBox(notice);
			}
		}
		
		for(charnum=0;charnum<codlen%4;charnum++)
		{
			writedata[charnum]=m_user[charnum+(blocknum-29)*4];
		}
		if(!WriteSingleBlock(hCom, 0x00, 0x00,NULL,blockth, writedata))
		{
			flag=false;
			notice.Format("写入标签第%d块失败",blockth);
			AfxMessageBox(notice);
		}
	}
	return flag;

}

bool Manipulate::writerecord()
{
	
	CString notice;
	char writedata[4];
	int codlen;
	codlen=strlen(m_record);
	int blocknum;
	int blockth;
	int charnum;
	if(codlen%4==0)
	{
		blocknum=codlen/4+41;
			for(blockth=41;blockth<blocknum;blockth++)
		{
		for(charnum=0;charnum<4;charnum++)
			writedata[charnum]=m_record[charnum+4*(blockth-41)];
			if(!WriteSingleBlock(hCom, 0x00, 0,NULL,blockth, writedata))
			{
				flag=false;
				notice.Format("写入标签第%d块失败",blockth);
				AfxMessageBox(notice);
			}
		}
	}
		
	else
		
	{
		blocknum=codlen/4+1+41;

		for(blockth=41;blockth<blocknum-1;blockth++)
		{
			for(charnum=0;charnum<4;charnum++)
				writedata[charnum]=m_record[charnum+4*(blockth-41)];
			if(!WriteSingleBlock(hCom, 0x00, 0,NULL,blockth, writedata))
			{
				flag=false;
				notice.Format("写入标签第%d块失败",blockth);
				AfxMessageBox(notice);
			}
		}
			
		for(charnum=0;charnum<codlen%4;charnum++)
		{
			writedata[charnum]=m_record[charnum+(blocknum-42)*4];
			}
			if(!WriteSingleBlock(hCom, 0x00, 0x00,NULL,blockth, writedata))
			{
			flag=false;
				notice.Format("写入标签第%d块失败",blockth);
			AfxMessageBox(notice);
		}
	}


	return flag;

}


////////////////////////////////////////////////////////////////////////////////////
////////////////////////////////修改芯片中数据////////////////////////////////////
void Manipulate::OnChange() 
{
		UpdateData(TRUE);
	//AfxMessageBox("只能修改用户单位和维修记录");
	/////////////////////////////////////////////////////////////修改标签数据
	//写用户单位到标签
	writeuser();
	//写维修记录到标签
	writerecord();
	/////////////////////////////////////////////////////////////修改数据库数据
	if(flag==true)
	{
		CString str,strSQL;
		strSQL="update 产品表 set 用户单位=" + m_user+ " where  产品编码=m_code"; // 设置SQL语句
		db.ExecuteSQL(strSQL); // 执行
		strSQL="update 产品表 set 维修记录=" + m_record+ " where  产品编码=m_code"; // 设置SQL语句
		db.ExecuteSQL(strSQL); 
		AfxMessageBox("修改成功");
	}
}

void Manipulate::OnRead() 
{

	int k=0;
CString strUID = _T("");

int LableNum = 0;
char UIDBuf[600];

memset(UIDBuf, 0, 600);


if(DetectTagUID(hCom, 0x00,UIDBuf,LableNum))
{
	m_xinpian.Format(UIDBuf);

//	UpdateData(FALSE);

}
else
{
	AfxMessageBox("没有检测到标签%d",LableNum);
}


	rdata.Format("");
	Manipulate::readdata(3,8);
	m_pro.Format("%s",rdata);


	rdata.Format("");
	Manipulate::readdata(11,10);
	m_name.Format("%s",rdata);

	rdata.Format("");
	Manipulate::readdata(21,4);
	m_ctype=rdata.Mid(0,1);
	m_ctypecode=rdata.Mid(1,2);
	m_cpartscode=rdata.Mid(3,4);
	m_cyear=rdata.Mid(7,4);
	m_cmanth=rdata.Mid(11,2);
	m_sequence=rdata.Mid(13,3);

    /////读取日历数据并转换成字符串
	rdata.Format("");
	CString cyear,cmonth,cday;
	Manipulate::readdata(25,2);
	cyear=rdata.Mid(0,4);
	cmonth=rdata.Mid(4,2);
	cday=rdata.Mid(6,2);
	char y1=cyear.GetAt(0);
	char y2=cyear.GetAt(1);
	char y3=cyear.GetAt(2);
	char y4=cyear.GetAt(3);
	char m1=cmonth.GetAt(0);
	char m2=cmonth.GetAt(1);
	char d1=cday.GetAt(0);
	char d2=cday.GetAt(1);
	int year1=((int)y1-48)*1000+((int)y2-48)*100+((int)y3-48)*10+((int)y4-48);
	int month1=((int)m1-48)*10+((int)m2-48);
	int day1=((int)d1-48)*10+((int)d2-48);


    m_date.SetTime(COleDateTime(year1,month1,day1,0,0,0));

	rdata.Format("");
	Manipulate::readdata(27,1);
	m_crepaire=rdata.Left(3);

	rdata.Format("");
	Manipulate::readdata(28,10);
	m_user.Format("%s",rdata);
	


	rdata.Format("");
	Manipulate::readdata(41,10);
	m_record.Format("%s",rdata);

	UpdateData(FALSE);	
}

////////////////////////////////////////////////////////////////////////////////////
////////////////////////////////从芯片中读取数据////////////////////////////////////
char* Manipulate::readdata(int beginblock,int blocks)
{
	
	CString ss, ss1[100];
	CString *pss1;
	pss1=ss1;
	 BYTE bRecDataBuf[10000];
	BYTE bRecDataBuf1[10000];
	char *UData,RecDataBuf1[600];
	CString sData;
	UData = RecDataBuf1;
	BYTE Single[5];
	 BYTE *pSingle = Single;
//*******************************字符存储类型的转换函数**********************************//
	if(ReadTagData(hCom,0x00,0x08,NULL,beginblock,blocks,UData))
		{

			sData.Format("%s",UData);
			//AfxMessageBox(sData);
			char cTmp[3];
			char *pCTmp = cTmp;
			//将得到的字符串转换为二进制数组
			int len = sData.GetLength();

			for(int k=0; k<len/2; k++)
			{
				sprintf(pCTmp,"%s",sData.Mid(k*2,2));
				sscanf(pCTmp,"%02X",&bRecDataBuf[k]);
			}
			//转换完毕!
			
			for(int j=0; j<blocks; j++)
			{
			
				ss.Format("块地址:[%02d]  数据: [ %c%c%c%c%c%c%c%c ]",21+j,
					UData[j*8+0],UData[j*8+1],UData[j*8+2],UData[j*8+3],UData[j*8+4],
					UData[j*8+5],UData[j*8+6],UData[j*8+7]);
				///目的：显示二进制数组中所表示的字符串(以字符方式显示)

				Single[0] = bRecDataBuf[j*4+0];
				Single[1] = bRecDataBuf[j*4+1];
				Single[2] = bRecDataBuf[j*4+2];
				Single[3] = bRecDataBuf[j*4+3];
				Single[4] = '\0';
				
				ss.Format("%s",(char*)pSingle);
				*ss1+=ss;
			
              }	
			rdata.Format("%s",*ss1);

			return (char*)pss1;
  }
}