param.cpp

停车场用

  SetFieldDouble("SECONDPRICE",t->fSecondPrice);
  SetFieldDouble("NIGHTPRICE",t->fNightPrice);

  SetFieldText("USERSTR",t->szUserType);
  SetFieldText("CHARGESTR",GetChargeType(t->nChargeType));

  return(TRUE);
 }
//读取车主用户资料
int ReadUserRecord(TDataSet *pQuery,void *pText)
 {
  USERDATA *t;
  TDateTime d1,d2;

  t = (USERDATA *)pText;
  ZeroMemory(t,sizeof(USERDATA));
  SetCurTable(pQuery);

  t->nHolderNo=GetFieldInt("HOLDERNO");
  t->nCardNo=GetFieldInt("CARDNO");
  t->nUserType=GetFieldInt("USERTYPE");
  t->nStatus=GetFieldInt("STATUS");

  t->fMoney=GetFieldDouble("MONEY");

  d1=GetFieldDouble("BEGINDATE");
  d2=GetFieldDouble("ENDDATE");
  t->nBeginDate = TDateToDWORD(d1);
  t->nEndDate = TDateToDWORD(d2);

  GetFieldText("USERNAME",t->szUserName,sizeof(t->szUserName));
  GetFieldText("CARTAG",t->szCarTag,sizeof(t->szCarTag));
  GetFieldText("CARTYPE",t->szCarType,sizeof(t->szCarType));
  GetFieldText("CARCOLOR",t->szCarColor,sizeof(t->szCarColor));
  GetFieldText("PHONE",t->szPhone,sizeof(t->szPhone));
  GetFieldText("ADDRESS",t->szAddress,sizeof(t->szAddress));
  GetFieldText("REMARK",t->szRemark,sizeof(t->szRemark));
  return(TRUE);
 }
//保存车主用户资料
int SaveUserRecord(TDataSet *pQuery,void *pText)
 {
  USERDATA *t;
  PRICEDATA *pPrice;
  TDateTime d1,d2;
  char *p;

  SetCurTable(pQuery);
  t = (USERDATA *)pText;

  SetFieldInt("HOLDERNO",t->nHolderNo);
  SetFieldInt("CARDNO",t->nCardNo);
  SetFieldInt("USERTYPE",t->nUserType);
  SetFieldInt("STATUS",t->nStatus);

  t->fMoney=SetFieldDouble("MONEY",t->fMoney);

  d1=DWORDToTDate(t->nBeginDate);
  d2=DWORDToTDate(t->nEndDate);
  SetFieldDouble("BEGINDATE",d1);
  SetFieldDouble("ENDDATE",d2);

  SetFieldText("USERNAME",t->szUserName);
  SetFieldText("CARTAG",t->szCarTag);
  SetFieldText("CARTYPE",t->szCarType);
  SetFieldText("CARCOLOR",t->szCarColor);
  SetFieldText("PHONE",t->szPhone);
  SetFieldText("ADDRESS",t->szAddress);
  SetFieldText("REMARK",t->szRemark);

  pPrice = (PRICEDATA *)GetPriceWithID(t->nUserType);
  if(pPrice!=NULL)p=pPrice->szUserType;
  else p=NULL;
  SetFieldText("USERSTR",p);

  return(TRUE);
 }
//读取持卡者资料
int ReadHolderRecord(TDataSet *pQuery,void *pText)
 {
  HOLDERDATA *t;
  char szBuf[50];

  t = (HOLDERDATA *)pText;
  ZeroMemory(t,sizeof(HOLDERDATA));
  SetCurTable(pQuery);

  t->nHolderNo=GetFieldInt("RECORDID");
  t->nStatus=GetFieldInt("STATUS");

  GetFieldText("HOLDERNAME",t->szHolderName,sizeof(t->szHolderName));
  GetFieldText("PASSWORD",szBuf,sizeof(szBuf));
  PasswordToAscii(szBuf);//将密码转化为Ascii
  lstrcpyn(t->szPassword,szBuf,sizeof(t->szPassword));
  return(TRUE);
 }
//保存持卡者资料
int SaveHolderRecord(TDataSet *pQuery,void *pText)
 {
  HOLDERDATA *t;
  char szBuf[50];
  int n;

  SetCurTable(pQuery);
  t = (HOLDERDATA *)pText;

  n = t->nStatus;
  SetFieldInt("STATUS",n);
  SetFieldInt("GETCARDFLAG",n&0x01);
  SetFieldInt("DISABLED",n&0x02);

  SetFieldText("HOLDERNAME",t->szHolderName);
  lstrcpyn(szBuf,t->szPassword,sizeof(szBuf));
  AsciiToPassword(szBuf);//将Ascii转化为密码
  SetFieldText("PASSWORD",szBuf);

  return(TRUE);
 }
//读取车道资料
int ReadRoadwayRecord(TDataSet *pQuery,void *pText)
 {
  ROADWAY *t;

  t = (ROADWAY *)pText;
  ZeroMemory(t,sizeof(ROADWAY));
  SetCurTable(pQuery);

  t->nNo=GetFieldInt("ROADNO");
  t->nType=GetFieldInt("ROADTYPE");
  t->nGroup=GetFieldInt("GROUPNO");
  t->nAPB=GetFieldInt("APB");
  t->nReaderID=GetFieldInt("READERID");
  t->nReaderType=GetFieldInt("READERTYPE");
  t->nCRNo=GetFieldInt("CRNO");
  t->nStatus=GetFieldInt("STATUS");
  t->nParkNo=GetFieldInt("PARKNO");

  t->nPhotoDeal=GetFieldInt("PHOTOPROC"); //图片处理
  t->nVideoID=GetFieldInt("VIDEOID"); //摄像机通道
  t->nVideoType=GetFieldInt("VIDEOTYPE");//摄象机类型
  t->nLEDType=GetFieldInt("LEDTYPE");  //显示屏类型
  t->nLEDNetID=GetFieldInt("LEDNETID");//显示屏网络地址(IP或COM端口)
  t->nLEDIPPort=GetFieldInt("LEDIPPORT"); //显示屏IP网监听端口

  GetFieldText("ROADNAME",t->szName,sizeof(t->szName));
  return(TRUE);
 }
//保存车道资料
int SaveRoadwayRecord(TDataSet *pQuery,void *pText)
 {
  ROADWAY *t;

  SetCurTable(pQuery);
  t = (ROADWAY *)pText;

  SetFieldInt("ROADNO",t->nNo);
  SetFieldInt("ROADTYPE",t->nType);
  SetFieldInt("GROUPNO",t->nGroup);
  SetFieldInt("APB",t->nAPB);
  SetFieldInt("READERID",t->nReaderID);
  SetFieldInt("READERTYPE",t->nReaderType);
  SetFieldInt("CRNO",t->nCRNo);
  SetFieldInt("STATUS",t->nStatus);
  SetFieldInt("PARKNO",t->nParkNo);

  SetFieldInt("PHOTOPROC",t->nPhotoDeal); //图片处理
  SetFieldInt("VIDEOID",t->nVideoID); //摄像机通道
  SetFieldInt("VIDEOTYPE",t->nVideoType);//摄象机类型
  SetFieldInt("LEDTYPE",t->nLEDType);  //显示屏类型
  SetFieldInt("LEDNETID",t->nLEDNetID);//显示屏网络地址(IP或COM端口)
  SetFieldInt("LEDIPPORT",t->nLEDIPPort); //显示屏IP网监听端口

  SetFieldText("ROADNAME",t->szName);
  SetFieldText("ROADSTR",GetRoadwayType(t->nType));//获取Roadway类型串

  return(TRUE);
 }
//读取控制器资料
int ReadControlerRecord(TDataSet *pQuery,void *pText)
 {
  CONTROLER *t;

  t = (CONTROLER *)pText;
  ZeroMemory(t,sizeof(CONTROLER));
  SetCurTable(pQuery);

  t->nCRNo=GetFieldInt("CRNO");
  t->nType=GetFieldInt("CRTYPE");
  t->nAddrID=GetFieldInt("ADDRID");
  t->nNetID=GetFieldInt("NETID");
  t->nIPPort=GetFieldInt("IPPORT");
  t->nStatus=GetFieldInt("STATUS");

  GetFieldText("CRNAME",t->szName,sizeof(t->szName));
  GetFieldText("HOSTNAME",t->szHostName,sizeof(t->szHostName));
  return(TRUE);
 }
//保存控制器资料
int SaveControlerRecord(TDataSet *pQuery,void *pText)
 {
  CONTROLER *t;

  SetCurTable(pQuery);
  t = (CONTROLER *)pText;

  SetFieldInt("CRNO",t->nCRNo);
  SetFieldInt("CRTYPE",t->nType);
  SetFieldInt("ADDRID",t->nAddrID);
  SetFieldInt("NETID",t->nNetID);
  SetFieldInt("IPPORT",t->nIPPort);
  SetFieldInt("STATUS",t->nStatus);

  SetFieldText("CRNAME",t->szName);
  SetFieldText("HOSTNAME",t->szHostName);

  return(TRUE);
 }
//读取场内车辆资料
int ReadParkinRecord(TDataSet *pQuery,void *pText)
 {
  PARKREC *t;
  TDateTime d;

  t = (PARKREC *)pText;
  ZeroMemory(t,sizeof(PARKREC));
  SetCurTable(pQuery);

  t->nHolderNo=GetFieldInt("HOLDERNO");
  t->nCardNo=GetFieldInt("CARDNO");
  t->nUserType=GetFieldInt("USERTYPE");
  t->nInRoadNo=GetFieldInt("INROADNO");
  t->nParkNo=GetFieldInt("PARKNO");
  t->nStatus=GetFieldInt("STATUS");

  d=GetFieldDouble("INTIME");
  t->nInDate = TDateToDWORD(d);
  t->nInTime = TTimeToDWORD(d);

  GetFieldText("USERNAME",t->szUserName,sizeof(t->szUserName));
  GetFieldText("CARTAG",t->szCarTag,sizeof(t->szCarTag));
  GetFieldText("CARTYPE",t->szCarType,sizeof(t->szCarType));
  GetFieldText("CARCOLOR",t->szCarColor,sizeof(t->szCarColor));
  return(TRUE);
 }
//保存场内车辆资料
int SaveParkinRecord(TDataSet *pQuery,void *pText)
 {
  PARKREC *t;
  TDateTime d;

  t = (PARKREC *)pText;
  SetCurTable(pQuery);

  SetFieldInt("HOLDERNO",t->nHolderNo);
  SetFieldInt("CARDNO",t->nCardNo);
  SetFieldInt("USERTYPE",t->nUserType);
  SetFieldInt("INROADNO",t->nInRoadNo);
  SetFieldInt("PARKNO",t->nParkNo);
  SetFieldInt("STATUS",t->nStatus);

  d = DWORDToTDateTime(t->nInDate,t->nInTime);
  SetFieldDouble("INTIME",d);

  SetFieldText("USERNAME",t->szUserName);
  SetFieldText("CARTAG",t->szCarTag);
  SetFieldText("CARTYPE",t->szCarType);
  SetFieldText("CARCOLOR",t->szCarColor);
  return(TRUE);
 }
//读取停车记录资料
int ReadParkrecRecord(TDataSet *pQuery,void *pText)
 {
  PARKREC *t;
  TDateTime d;

  t = (PARKREC *)pText;
  ZeroMemory(t,sizeof(PARKREC));
  SetCurTable(pQuery);

  t->nHolderNo=GetFieldInt("HOLDERNO");
  t->nCardNo=GetFieldInt("CARDNO");
  t->nUserType=GetFieldInt("USERTYPE");
  t->nInRoadNo=GetFieldInt("INROADNO");
  t->nOutRoadNo=GetFieldInt("OUTROADNO");
  t->nParkTime=GetFieldInt("PARKTIME");
  t->fParkPrice=GetFieldDouble("PARKPRICE");
  t->nParkNo=GetFieldInt("PARKNO");
  t->nStatus=GetFieldInt("STATUS");

  d=GetFieldDouble("INTIME");
  t->nInDate = TDateToDWORD(d);
  t->nInTime = TTimeToDWORD(d);
  d=GetFieldDouble("OUTTIME");
  t->nOutDate = TDateToDWORD(d);
  t->nOutTime = TTimeToDWORD(d);

  GetFieldText("USERNAME",t->szUserName,sizeof(t->szUserName));
  GetFieldText("CARTAG",t->szCarTag,sizeof(t->szCarTag));
  GetFieldText("CARTYPE",t->szCarType,sizeof(t->szCarType));
  GetFieldText("CARCOLOR",t->szCarColor,sizeof(t->szCarColor));
  return(TRUE);
 }
//保存停车记录资料
int SaveParkrecRecord(TDataSet *pQuery,void *pText)
 {
  PARKREC *t;
  TDateTime d;

  t = (PARKREC *)pText;
  SetCurTable(pQuery);

  SetFieldInt("HOLDERNO",t->nHolderNo);
  SetFieldInt("CARDNO",t->nCardNo);
  SetFieldInt("USERTYPE",t->nUserType);
  SetFieldInt("INROADNO",t->nInRoadNo);
  SetFieldInt("OUTROADNO",t->nOutRoadNo);
  SetFieldInt("PARKTIME",t->nParkTime);
  SetFieldInt("PARKNO",t->nParkNo);
  SetFieldDouble("PARKPRICE",t->fParkPrice);
  SetFieldInt("STATUS",t->nStatus);

  d = DWORDToTDateTime(t->nInDate,t->nInTime);
  SetFieldDouble("INTIME",d);
  d = DWORDToTDateTime(t->nOutDate,t->nOutTime);
  d=SetFieldDouble("OUTTIME",d);

  SetFieldText("USERNAME",t->szUserName);
  SetFieldText("CARTAG",t->szCarTag);
  SetFieldText("CARTYPE",t->szCarType);
  SetFieldText("CARCOLOR",t->szCarColor);
  return(TRUE);
 }
//读取IOData记录资料
int ReadIODataRecord(TDataSet *pQuery,void *pText)
 {
  IODATA *t;
  TDateTime d;

  t = (IODATA *)pText;
  ZeroMemory(t,sizeof(IODATA));
  SetCurTable(pQuery);


  t->nCardNo=GetFieldInt("CARDNO");
  t->nCardID=GetFieldInt("CARDID");
  t->nCardHI=GetFieldInt("CARDHI");
  t->nCRNo=GetFieldInt("CRNO");
  t->nRoadNo=GetFieldInt("ROADNO");
  t->nCRID=GetFieldInt("CRID");
  t->nReaderID=GetFieldInt("READERID");
  t->nStatus=GetFieldInt("STATUS");

  d=GetFieldDouble("IODate");
  t->nDate = TDateToDWORD(d);
  t->nTime = TTimeToDWORD(d);
  return(TRUE);
 }
//保存IOData记录资料
int SaveIODataRecord(TDataSet *pQuery,void *pText)
 {
  IODATA *t;
  TDateTime d;

  t = (IODATA *)pText;
  SetCurTable(pQuery);

  SetFieldInt("CARDNO",t->nCardNo);
  SetFieldInt("CARDID",t->nCardID);
  SetFieldInt("CARDHI",t->nCardHI);
  SetFieldInt("CRNO",t->nCRNo);
  SetFieldInt("ROADNO",t->nRoadNo);
  SetFieldInt("CRID",t->nCRID);
  SetFieldInt("READERID",t->nReaderID);
  SetFieldInt("STATUS",t->nStatus);

  d = DWORDToTDateTime(t->nDate,t->nTime);
  SetFieldDouble("IODATE",d);

  return(TRUE);
 }
//读取停车场资料
int ReadParkRecord(TDataSet *pQuery,void *pText)
 {
  PARKDATA *t;

  t = (PARKDATA *)pText;
  ZeroMemory(t,sizeof(PARKDATA));
  SetCurTable(pQuery);

  t->nParkNo=GetFieldInt("PARKNO");
  t->nSpace=GetFieldInt("PARKSPACE");
  t->nUsed=GetFieldInt("PARKUSED");

  GetFieldText("PARKNAME",t->szName,sizeof(t->szName));
  return(TRUE);
 }
//保存停车场资料
int SaveParkRecord(TDataSet *pQuery,void *pText)
 {
  PARKDATA *t;

  t = (PARKDATA *)pText;
  SetCurTable(pQuery);

  SetFieldInt("PARKNO",t->nParkNo);
  SetFieldInt("PARKSPACE",t->nSpace);

  SetFieldText("PARKNAME",t->szName);
  return(TRUE);
 }