综合AV图片国产区_国产成人精品2021国产欧美日韩_成人三级片在线观看_日韩黄色免费毛片_國產成人綜合視頻_合家欢下册公交车_女明星换脸自慰网站_国产夜趣福利第一视频_中文精品北条麻妃中文_日韩精品无码专区国产A∨

停車場管理軟件發(fā)卡授權(quán)程序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,卡內(nèi)金額,卡類,車牌號碼,進(jìn)出限制,安全級別,非時段收費,進(jìn)出周時)');
                    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('授權(quán)失敗,請確定該卡的授權(quán)信息是否已經(jīng)存在!');
                        Exit;
                    end;
                    dm.WriteLog(qryCard.FieldByName('卡號').AsString,
                                '停車場','授權(quán)',now, fee, LocalUser.Name);
                    pb.Position := pb.Position + 1;
                    qryCard.Next;
                end;
            end;
        end;
    end;
    tvCardOwnerChange(nil, tvCardOwner.Selected);
    RefreshCard;
   // ShowMessage('注意:如果采用了主控制器,授權(quán)完畢后,請在”停車場服務(wù)器“軟件上對主控制器資料更新!');
    pb.Position := 0;