int C51JobWebPost::GetFirstUsefulKey()
{
int iRet = -1;
CAdoConnection adoConn;
CAdoRecordSet adoRst;
try
{
if ( !adoConn.IsOpen() ) //如果未连接上服务器
{
CString strAppPath = "";
CUserFile::GetInstance()->GetAppPath(strAppPath);
if ( !adoConn.ConnectAccess(strAppPath+"machineInfo.mdb",""))
{
ShowMessage("连接数据库失败");
return -1;
}
adoRst.SetAdoConnection(&adoConn);
adoRst.SetCursorLocation(adUseClient);
}
CString strSQL;
strSQL.Format("select top 1 * from [machine] where datediff('d',lastusetime,now()) > 0 order by [ID] asc");
if(!adoRst.Open(strSQL,adCmdText))
{
iRet = -1;
ShowMessage("读取键值信息失败");
}
else
{
if (!adoRst.IsEOF())
{
adoRst.GetCollect("ID",m_iID);
adoRst.GetCollect("machineserial",m_strMac);
adoRst.GetCollect("transactionid",m_strTrans);
adoRst.GetCollect("verify",m_strVerify);
iRet = 0;
}
else
{
ShowMessage("当天已经没有可用的键值信息，请调用生成程序");
iRet = -1;
}
}
adoRst.Close();
adoConn.Close();
return iRet;
}
catch (...)
{
adoRst.Close();
adoConn.Close();
ShowMessage("读取键值信息异常");
}
return -1;
}
int C51JobWebPost::WriteToBase(RegisterPack rgPack,int iFlag)
{
int iRet = -1;
CAdoConnection adoConn;
CAdoRecordSet adoRst;
try
{
if ( !adoConn.IsOpen() ) //如果未连接上服务器
{
CString strAppPath = "";
CUserFile::GetInstance()->GetAppPath(strAppPath);
if ( !adoConn.ConnectAccess(strAppPath+"7pRegister.mdb",""))
{
ShowMessage("连接数据库失败");
return -1;
}
adoRst.SetAdoConnection(&adoConn);
adoRst.SetCursorLocation(adUseClient);
}
CString strSQL;
strSQL.Format("insert into [Users] ([userid],[userpwd],flag)values('%s','%s',%d,)",rgPack.strAcc,rgPack.strPwd,iFlag);
if( !adoRst.Open(strSQL,adCmdText))
{
iRet = -1;
ShowMessage("保存账号信息失败");
}
else
{
iRet = 0;
}
adoRst.Close();
adoConn.Close();
return iRet;
}
catch (...)
{
adoRst.Close();
adoConn.Close();
ShowMessage("保存账号信息异常");
}
return -1;
}
int C51JobWebPost::DisableKey(int iKeyNum)
{
int iRet = -1;
CAdoConnection adoConn;
CAdoRecordSet adoRst;
try
{
if ( !adoConn.IsOpen() ) //如果未连接上服务器
{
CString strAppPath = "";
CUserFile::GetInstance()->GetAppPath(strAppPath);
if ( !adoConn.ConnectAccess(strAppPath+"machineInfo.mdb",""))
{
ShowMessage("连接数据库失败");
return -1;
}
adoRst.SetAdoConnection(&adoConn);
adoRst.SetCursorLocation(adUseClient);
}
CString strSQL;
strSQL.Format("update [machine] set [lastusetime]=now() where [ID]=%d",iKeyNum);
if(!adoRst.Open(strSQL,adCmdText))
{
iRet = -1;
ShowMessage("删除机器信息失败");
}
else
{
iRet = 0;
}
adoRst.Close();
adoConn.Close();
return iRet;
}
catch (...)
{
adoRst.Close();
adoConn.Close();
ShowMessage("删除机器信息异常");
}
return -1;
}
void CStoredMessage::AddMessage(CString strMessage)
{
if (!strMessage.IsEmpty())
{
CAdoConnection conn;
conn.ConnectAccess(CStoredMember::GetFilePath());
CString szCmdText;
szCmdText.Format("insert into messages(message) values('%s')", strMessage);
conn.Execute(szCmdText);
conn.Close();
}
}
void CStoredMessage::ClearMessage()
{
CAdoConnection conn;
conn.ConnectAccess(CStoredMember::GetFilePath());
CString szCmdText;
szCmdText.Format("drop table messages");
conn.Execute(szCmdText);
szCmdText.Format("create table messages(id autoincrement, message Memo)");
conn.Execute(szCmdText);
conn.Close();
}
void CStoredAccount::AddAccount(CString strUserName, CString pwd)
{
if (!strUserName.IsEmpty())
{
CAdoConnection conn;
conn.ConnectAccess(CStoredMember::GetFilePath());
CString szCmdText;
szCmdText.Format("insert into accounts(uid, pwd) values('%s', '%s')", strUserName, pwd);
conn.Execute(szCmdText);
conn.Close();
}
}
void CStoredAccount::ClearAccount()
{
CAdoConnection conn;
conn.ConnectAccess(CStoredMember::GetFilePath());
CString szCmdText;
szCmdText.Format("drop table accounts");
conn.Execute(szCmdText);
szCmdText.Format("create table accounts(id autoincrement, uid varchar(50), pwd varchar(50))");
conn.Execute(szCmdText);
conn.Close();
}
int CStoredMessage::GetNextMessage(int startId, CString& szMessage)
{
long id = -1;
CString szCmdText;
szCmdText.Format("select top 1 id, message from messages where id > %d", startId);
CAdoConnection conn;
if (conn.ConnectAccess(CStoredMember::GetFilePath()))
{
CAdoRecordSet rs(&conn);
if (rs.Open(szCmdText) && rs.MoveFirst())
{
rs.GetCollect(0L, id);
rs.GetCollect(1L, szMessage);
}
conn.Close();
}
return id;
}
int CStoredAccount::GetNextAccount(int startId, CString& strUserName, CString& pwd)
{
long id = -1;
CString szCmdText;
szCmdText.Format("select top 1 id, uid, pwd from accounts where id > %d", startId);
CAdoConnection conn;
if (conn.ConnectAccess(CStoredMember::GetFilePath()))
{
CAdoRecordSet rs(&conn);
if (rs.Open(szCmdText) && rs.MoveFirst())
{
rs.GetCollect(0L, id);
rs.GetCollect(1L, strUserName);
rs.GetCollect(2L, pwd);
}
conn.Close();
}
return id;
}
