联系方式
精品展示

停车场管理软件发卡授权程序1

2012/6/28 19:19:48      点击:

  begin
            with qryComm do
            begin
                Close;
                SQL.Clear;
                if cbRepop.Checked then
                begin
                    SQL.Add('DELETE JY_Park_Card_Info WHERE 卡号 = ''' + lblPopCont.Caption + '''');
                    try
                        ExecSQL;
                    except
                        ;
                    end;
                end;
                qryCard.Close;
                qryCard.SQL.Clear;
                qryCard.SQL.Add('SELECT * FROM JY_Card_Infomation WHERE 卡号= ''' + lblPopCont.Caption + '''');
                qryCard.Open;
                qryCard.First;

                //ShowMessage(IntToStr(qryCard.RecordCount));
                pb.Max := qryCard.RecordCount;

                while not qryCard.Eof do
                begin
                    qryComm.Close;
                    qryComm.SQL.Clear;
                    qryComm.SQL.Add('INSERT JY_Park_Card_Info (卡号,用户编号,收费类型,组号,有效期起日期,有效期止日期,时间A,时间A1,时间B,时间B1,时间C,时间C1,时间D,时间D1,卡内金额,卡类,车牌号码,进出限制,安全级别,非时段收费,进出周时)');
                    qryComm.SQL.Add('VALUES (''' + qryCard.FieldByName('卡号').AsString + ''','''
                                + qryCard.FieldByName('持卡人编号').AsString+ ''','
                                + tt1 + ','
                                + qryCard.FieldByName('持卡人编号').AsString+ ','''
                                + DateToStr(dtppopf.Date) + ''','''
                                + DateToStr(dtppopt.Date) + ''','''
                                +  timeTostr(dtp_Ent_Timeslice1.Time)+ ''','''
                                +  timeTostr(dtp_Ent_Timeslice2.Time)+ ''','''
                                +  timeTostr(dtp_Ent_Timeslice3.Time)+ ''','''
                                +  timeTostr(dtp_Ent_Timeslice4.Time)+ ''','''
                                +  timeTostr(dtp_Ent_Timeslice5.Time)+ ''','''
                                +  timeTostr(dtp_Ent_Timeslice6.Time)+ ''','''
                                +  timeTostr(dtp_Ent_Timeslice7.Time)+ ''','''
                                +  timeTostr(dtp_Ent_Timeslice8.Time)+ ''','
                                + EditAcount.Text + ','''
                                + IntToStr(cmbCardType.ItemIndex + 1)+''','''
                                + ttsrt +''','''
                                + quanxian +''','''+ anquanjibi+''','''+sflxA +''','''+xingqi+''')');
                    try
                        qryComm.execsql;
                    except
                        ShowMessage('授权失败,请确定该卡的授权信息是否已经存在!');
                        Exit;
                    end;
                    dm.WriteLog(qryCard.FieldByName('卡号').AsString,
                                '停车场','授权',now, fee, LocalUser.Name);
                    pb.Position := pb.Position + 1;
                    qryCard.Next;
                end;
            end;
        end;
    end;
    tvCardOwnerChange(nil, tvCardOwner.Selected);
    RefreshCard;
   // ShowMessage('注意:如果采用了主控制器,授权完毕后,请在”停车场服务器“软件上对主控制器资料更新!');
    pb.Position := 0;

关键词: 军车车牌识别 部队门禁系统 智慧军营 数字军营 营区出入管理系统 部队请销假系统 部队派车系统 数字营区 智慧营区 智慧军营整体解决方案 智慧部队 智慧军队 数字部队 智能化营区 部队人脸识别系统 涉密管理系统 营房管理系统 维修管理系统 营区访客系统 离位报警系统 车辆维修系统 上海车牌识别系统 部队停车场管理系统

电话: 18117117761(24小时)    021-59786133  邮箱:yuchengzhineng@qq.com  QQ: 9223677   9603426   529131638

Copyright 2019 www.multi-parking.com 上海誉澄智能科技有限公司 版权所有 All Rights Reserved   网站移动版入口

沪公网安备 31011402002854号 沪ICP备10219392号-1