回复:有关数据归档文件*.csv的问题

游过

  • 帖子

    30
  • 精华

    0
  • 被关注

    0

论坛等级:新手

注册时间:2005-05-23

普通 普通 如何晋级?

发布于 2005-07-05 10:53:56

0楼

不好意思,斑竹大哥,我不太明白您说的这个应该怎么加,下面是动作的源程序
有select关键字的是 TLG_IO_BACKUP_SELECT ibs;这一行

您说加一个Order By T该怎么写?

谢谢,麻烦您了
void ActionForExportingArchive (LPTSTR lpszArchivNameReturn, LPTSTR lpszVariablenName , DWORD dwNumberOfRecords)
{

BOOL fRet;
int iTlgCon = 0;
CMN_ERROR Error;
char szProj[MAX_PATH];
char szFile[MAX_PATH];
LPTSTR lpszArchivName = "PDE#HD#ZK_ProcessValueArchive_04#G64i_ex_tlg_04";
char szFileName[MAX_PATH] = "";
LPTSTR lpszFileName;
TLG_IO_BACKUP_SELECT ibs;
DWORD dwSize;
time_t Time;
struct tm* TimeStruct;
int nPathLen,nFileLen;

time(&Time);
TimeStruct = localtime(&Time);

DMGetRuntimeProject( szProj, MAX_PATH, &Error);

nPathLen=strlen(szProj);
nFileLen=strlen((strrchr(szProj,'\\')+1));

strncat(szFile,szProj,nPathLen-nFileLen);
sprintf(szFileName,"%s%s",szFile,"ArchiveBackUp.CSV");
lpszFileName=&szFileName[0];

ibs.sysFrom.wYear = 1997;
ibs.sysFrom.wMonth = 1;
ibs.sysFrom.wDay = 1;
ibs.sysFrom.wHour = 0;
ibs.sysFrom.wMinute = 0;
ibs.sysFrom.wSecond = 0;

ibs.sysTo.wYear = (WORD)(TimeStruct->tm_year+1900);
ibs.sysTo.wMonth = (WORD)(TimeStruct->tm_mon+1);
ibs.sysTo.wDay = (WORD)(TimeStruct->tm_mday);
ibs.sysTo.wHour = (WORD)(TimeStruct->tm_hour);
ibs.sysTo.wMinute = (WORD)(TimeStruct->tm_min);
ibs.sysTo.wSecond = (WORD)(TimeStruct->tm_sec);

fRet = TLGConnect( NULL, &Error );
if (fRet==FALSE) printf("Error in TLGConect(...)\r\n");

fRet=TLGGetBackupSize (lpszArchivName,&dwSize,&ibs,TLG_BACKUP_EVACUATE,TLG_BAKFMT_CSV,&Error);
if (fRet==FALSE) printf("Error in TLGGetBackupSize(...) [%s]\r\n",Error.szErrorText);
else SetTagWord("U16i_ex_tlg_00",(WORD)dwSize);

printf("executedr\n");

fRet=TLGBackup (lpszArchivName,lpszFileName,&ibs,TLG_BACKUP_EXPORT,TLG_BAKFMT_CSV,&Error);
if (fRet==FALSE) printf("Error in TLGBackup(...) [%s]\r\n",Error.szErrorText);
else SetTagBit("BINi_ex_tlg_09",TRUE);

TLGDisconnect( NULL );

}
评论
编辑推荐: 关闭

请填写推广理由:

本版热门话题

SIMATIC WinCC / Panel

共有32660条技术帖

相关推荐

热门标签

相关帖子推荐

guzhang

恭喜,你发布的帖子

评为精华帖!

快扫描右侧二维码晒一晒吧!

再发帖或跟帖交流2条,就能晋升VIP啦!开启更多专属权限!

  • 分享

  • 只看
    楼主

top
X 图片
您收到0封站内信:
×
×
信息提示
很抱歉!您所访问的页面不存在,或网址发生了变化,请稍后再试。