MagistrAnatol
Silver Member | Редактировать | Профиль | Сообщение | ICQ | Цитировать | Сообщить модератору
Код: [Application: vdgo.exe]
uTr: [Start transaction](36669)
[Application: vdgo.exe]
tAboOblad: [Prepare] UPDATE ABO_OBORYD SET ABO_ID= ?ABO_ID WHERE ABO_OBORYD_ID =  LD_ABO_OBORYD_ID
Plan: PLAN (ABO_OBORYD INDEX (PK_ABO_OBORYD))
[Application: vdgo.exe]
tAboOblad.: [Execute] UPDATE ABO_OBORYD SET ABO_ID= ?ABO_ID WHERE ABO_OBORYD_ID = LD_ABO_OBORYD_ID
ABO_ID = 3788
OLD_ABO_OBORYD_ID = 392
Rows Affected: 1
Execute tick count 0
[Application: vdgo.exe]
tAboOblad.RefreshQuery: [Execute] SELECT
ao.ABO_ID,
ao.SPR_OBORYD_ID,
ao.LSA_ID,
ao.GP_ID,
ao.KGP,
ao.KOLVO,
ao.KOLVO_VIDKL,
ao.KOLVO_VIDR,
ao.KOLVO_DEMONT,
ao.DATA_VCTANOVLENYA,
ao.DATA_VUGOTOVLENYA,
ao.ZAVOD_NOM,
ao.DATA_ZAKRUTYA,
ao.DATA_POVIRKU,
ao.DATA_NA_POVIRKY,
ao.DATA_PICLYA_POVIRKU,
ao.DATA_NACT_POVIRKU,
ao.IS_VIDKL,
ao.DATA_VIDKL,
ao.AKT_VIDKL_NOM,
ao.PLOMBA_VIDKL,
ao.SPR_XARAKTER_VIDKL_ID,
ao.PRUCHUNA_VIDKL,
ao.DATA_VKL,
ao.N_DOZVIL_VKL,
ao.DATA_DUMOXODA,
ao.DATA_NACT_DUMOXODA,
ao.DATA_PTO,
ao.DATA_NACT_PTO,
ao.DATA_AKTA,
ao.PRUM,
ao.SPR_USER_ID,
ao.OPER_DATA,
ao.IS_ADC,
ao.oper_type,
ao.EDIT_TYPE,
ao.EDIT_USER_ID,
ao.EDIT_DATE,
ao.ABO_OPER_ID,
ao.VKL_VUKL_ID,
ao.ABO_OBORYD_ID
FROM
ABO_OBORYD ao
left outer join spr_oboryd so on AO.spr_oboryd_id=so.spr_oboryd_id
where(
-- відключене обладнання
:is_vidkl_oboryd in(-1,ao.is_vidkl) and
-- Обладнання
:spr_oboryd_id_in in (-1,ao.spr_oboryd_id) and
-- типи обладнання
:spr_oboryd_type_id_in in (-1,so.spr_oboryd_type_id) and
-- строки повірки димоходів
ao.DATA_NACT_DUMOXODA BETWEEN  ND_S and ND_E and
-- строки пто
ao.DATA_NACT_PTO BETWEEN NPTO_S and NPTO_E
) and ( AO.ABO_OBORYD_ID = LD_ABO_OBORYD_ID
)
IS_VIDKL_OBORYD = -1
SPR_OBORYD_ID_IN = -1
SPR_OBORYD_TYPE_ID_IN = -1
DND_S = 01.01.1800
DND_E = 31.12.9999
DNPTO_S = 01.01.1800
DNPTO_E = 31.12.9999
OLD_ABO_OBORYD_ID = 392
Execute tick count 0
[Application: vdgo.exe]
tAboOblad: [Prepare] UPDATE ABO_OBORYD
SET
ABO_ID = :ABO_ID,
SPR_OBORYD_ID = :SPR_OBORYD_ID,
LSA_ID = :LSA_ID,
GP_ID = :GP_ID,
KGP = :KGP,
KOLVO = :KOLVO,
KOLVO_VIDKL = :KOLVO_VIDKL,
KOLVO_VIDR = :KOLVO_VIDR,
KOLVO_DEMONT = :KOLVO_DEMONT,
DATA_VCTANOVLENYA = ATA_VCTANOVLENYA,
DATA_VUGOTOVLENYA = ATA_VUGOTOVLENYA,
ZAVOD_NOM = :ZAVOD_NOM,
DATA_ZAKRUTYA = ATA_ZAKRUTYA,
DATA_POVIRKU = ATA_POVIRKU,
DATA_NA_POVIRKY = ATA_NA_POVIRKY,
DATA_PICLYA_POVIRKU = ATA_PICLYA_POVIRKU,
DATA_NACT_POVIRKU = ATA_NACT_POVIRKU,
IS_VIDKL = :IS_VIDKL,
DATA_VIDKL = ATA_VIDKL,
AKT_VIDKL_NOM = :AKT_VIDKL_NOM,
PLOMBA_VIDKL =  LOMBA_VIDKL,
SPR_XARAKTER_VIDKL_ID = :SPR_XARAKTER_VIDKL_ID,
PRUCHUNA_VIDKL = RUCHUNA_VIDKL,
DATA_VKL = ATA_VKL,
N_DOZVIL_VKL = :N_DOZVIL_VKL,
DATA_DUMOXODA = ATA_DUMOXODA,
DATA_NACT_DUMOXODA = ATA_NACT_DUMOXODA,
DATA_PTO = ATA_PTO,
DATA_NACT_PTO = ATA_NACT_PTO,
DATA_AKTA = ATA_AKTA,
PRUM = RUM,
SPR_USER_ID = :SPR_USER_ID,
OPER_DATA = PER_DATA,
IS_ADC = :IS_ADC,
OPER_TYPE = PER_TYPE,
EDIT_TYPE = :EDIT_TYPE,
EDIT_USER_ID = :EDIT_USER_ID,
EDIT_DATE = :EDIT_DATE,
ABO_OPER_ID = :ABO_OPER_ID,
VKL_VUKL_ID = :VKL_VUKL_ID
WHERE
ABO_OBORYD_ID = LD_ABO_OBORYD_ID
Plan: PLAN (ABO_OBORYD INDEX (PK_ABO_OBORYD))
[Application: vdgo.exe]
tAboOblad.UpdateQuery: [Execute] UPDATE ABO_OBORYD
SET
ABO_ID = :ABO_ID,
SPR_OBORYD_ID = :SPR_OBORYD_ID,
LSA_ID = :LSA_ID,
GP_ID = :GP_ID,
KGP = :KGP,
KOLVO = :KOLVO,
KOLVO_VIDKL = :KOLVO_VIDKL,
KOLVO_VIDR = :KOLVO_VIDR,
KOLVO_DEMONT = :KOLVO_DEMONT,
DATA_VCTANOVLENYA = ATA_VCTANOVLENYA,
DATA_VUGOTOVLENYA = ATA_VUGOTOVLENYA,
ZAVOD_NOM = :ZAVOD_NOM,
DATA_ZAKRUTYA = ATA_ZAKRUTYA,
DATA_POVIRKU = ATA_POVIRKU,
DATA_NA_POVIRKY = ATA_NA_POVIRKY,
DATA_PICLYA_POVIRKU = ATA_PICLYA_POVIRKU,
DATA_NACT_POVIRKU = ATA_NACT_POVIRKU,
IS_VIDKL = :IS_VIDKL,
DATA_VIDKL = ATA_VIDKL,
AKT_VIDKL_NOM = :AKT_VIDKL_NOM,
PLOMBA_VIDKL = LOMBA_VIDKL,
SPR_XARAKTER_VIDKL_ID = :SPR_XARAKTER_VIDKL_ID,
PRUCHUNA_VIDKL = RUCHUNA_VIDKL,
DATA_VKL = ATA_VKL,
N_DOZVIL_VKL = :N_DOZVIL_VKL,
DATA_DUMOXODA = ATA_DUMOXODA,
DATA_NACT_DUMOXODA = ATA_NACT_DUMOXODA,
DATA_PTO = ATA_PTO,
DATA_NACT_PTO = ATA_NACT_PTO,
DATA_AKTA = ATA_AKTA,
PRUM = RUM,
SPR_USER_ID = :SPR_USER_ID,
OPER_DATA = PER_DATA,
IS_ADC = :IS_ADC,
OPER_TYPE = PER_TYPE,
EDIT_TYPE = :EDIT_TYPE,
EDIT_USER_ID = :EDIT_USER_ID,
EDIT_DATE = :EDIT_DATE,
ABO_OPER_ID = :ABO_OPER_ID,
VKL_VUKL_ID = :VKL_VUKL_ID
WHERE
ABO_OBORYD_ID = LD_ABO_OBORYD_ID
ABO_ID = 3788
SPR_OBORYD_ID = 11
LSA_ID = 3782
GP_ID = 12
KGP = 2004
KOLVO = 1
KOLVO_VIDKL = 0
KOLVO_VIDR = 0
KOLVO_DEMONT = 0
DATA_VCTANOVLENYA = 12.12.2007
DATA_VUGOTOVLENYA = 01.01.1800
ZAVOD_NOM = ''
DATA_ZAKRUTYA = 01.01.1800
DATA_POVIRKU = 01.01.1800
DATA_NA_POVIRKY = 01.01.1800
DATA_PICLYA_POVIRKU = 01.01.1800
DATA_NACT_POVIRKU = 01.01.1800
IS_VIDKL = 0
DATA_VIDKL = 01.01.1800
AKT_VIDKL_NOM = ' '
PLOMBA_VIDKL = ''
SPR_XARAKTER_VIDKL_ID = 1
PRUCHUNA_VIDKL
= <BLOB> (BLOB_ID=131,3939)
DATA_VKL = 19.06.2012
N_DOZVIL_VKL = '2000425'
DATA_DUMOXODA = 01.01.1800
DATA_NACT_DUMOXODA = 01.01.1800
DATA_PTO = 01.01.1800
DATA_NACT_PTO = 01.01.1800
DATA_AKTA = 01.01.1800
PRUM = <NULL>
SPR_USER_ID = 0
OPER_DATA = 19.06.2012 10:10:37
IS_ADC = 1
OPER_TYPE = 4
EDIT_TYPE = 0
EDIT_USER_ID = 0
EDIT_DATE = 05.01.2012 13:52:19
ABO_OPER_ID = 43405
VKL_VUKL_ID = 90
OLD_ABO_OBORYD_ID = 392
Rows Affected: 1
Execute tick count 0
[Application: vdgo.exe]
tAboOblad.RefreshQuery: [Execute] SELECT
ao.ABO_ID,
ao.SPR_OBORYD_ID,
ao.LSA_ID,
ao.GP_ID,
ao.KGP,
ao.KOLVO,
ao.KOLVO_VIDKL,
ao.KOLVO_VIDR,
ao.KOLVO_DEMONT,
ao.DATA_VCTANOVLENYA,
ao.DATA_VUGOTOVLENYA,
ao.ZAVOD_NOM,
ao.DATA_ZAKRUTYA,
ao.DATA_POVIRKU,
ao.DATA_NA_POVIRKY,
ao.DATA_PICLYA_POVIRKU,
ao.DATA_NACT_POVIRKU,
ao.IS_VIDKL,
ao.DATA_VIDKL,
ao.AKT_VIDKL_NOM,
ao.PLOMBA_VIDKL,
ao.SPR_XARAKTER_VIDKL_ID,
ao.PRUCHUNA_VIDKL,
ao.DATA_VKL,
ao.N_DOZVIL_VKL,
ao.DATA_DUMOXODA,
ao.DATA_NACT_DUMOXODA,
ao.DATA_PTO,
ao.DATA_NACT_PTO,
ao.DATA_AKTA,
ao.PRUM,
ao.SPR_USER_ID,
ao.OPER_DATA,
ao.IS_ADC,
ao.oper_type,
ao.EDIT_TYPE,
ao.EDIT_USER_ID,
ao.EDIT_DATE,
ao.ABO_OPER_ID,
ao.VKL_VUKL_ID,
ao.ABO_OBORYD_ID
FROM
ABO_OBORYD ao
left outer join spr_oboryd so on AO.spr_oboryd_id=so.spr_oboryd_id
where(
-- відключене обладнання
:is_vidkl_oboryd in(-1,ao.is_vidkl) and
-- Обладнання
:spr_oboryd_id_in in (-1,ao.spr_oboryd_id) and
-- типи обладнання
:spr_oboryd_type_id_in in (-1,so.spr_oboryd_type_id) and
-- строки повірки димоходів
ao.DATA_NACT_DUMOXODA BETWEEN ND_S and ND_E and
-- строки пто
ao.DATA_NACT_PTO BETWEEN NPTO_S and NPTO_E
) and ( AO.ABO_OBORYD_ID = LD_ABO_OBORYD_ID
)
IS_VIDKL_OBORYD = -1
SPR_OBORYD_ID_IN = -1
SPR_OBORYD_TYPE_ID_IN = -1
DND_S = 01.01.1800
DND_E = 31.12.9999
DNPTO_S = 01.01.1800
DNPTO_E = 31.12.9999
OLD_ABO_OBORYD_ID = 392
Execute tick count 0
[Application: vdgo.exe]
uTr: [Commit (Hard commit)](36669)
[Application: vdgo.exe]
tAboOblad.RefreshQuery: [Execute] SELECT
ao.ABO_ID,
ao.SPR_OBORYD_ID,
ao.LSA_ID,
ao.GP_ID,
ao.KGP,
ao.KOLVO,
ao.KOLVO_VIDKL,
ao.KOLVO_VIDR,
ao.KOLVO_DEMONT,
ao.DATA_VCTANOVLENYA,
ao.DATA_VUGOTOVLENYA,
ao.ZAVOD_NOM,
ao.DATA_ZAKRUTYA,
ao.DATA_POVIRKU,
ao.DATA_NA_POVIRKY,
ao.DATA_PICLYA_POVIRKU,
ao.DATA_NACT_POVIRKU,
ao.IS_VIDKL,
ao.DATA_VIDKL,
ao.AKT_VIDKL_NOM,
ao.PLOMBA_VIDKL,
ao.SPR_XARAKTER_VIDKL_ID,
ao.PRUCHUNA_VIDKL,
ao.DATA_VKL,
ao.N_DOZVIL_VKL,
ao.DATA_DUMOXODA,
ao.DATA_NACT_DUMOXODA,
ao.DATA_PTO,
ao.DATA_NACT_PTO,
ao.DATA_AKTA,
ao.PRUM,
ao.SPR_USER_ID,
ao.OPER_DATA,
ao.IS_ADC,
ao.oper_type,
ao.EDIT_TYPE,
ao.EDIT_USER_ID,
ao.EDIT_DATE,
ao.ABO_OPER_ID,
ao.VKL_VUKL_ID,
ao.ABO_OBORYD_ID
FROM
ABO_OBORYD ao
left outer join spr_oboryd so on AO.spr_oboryd_id=so.spr_oboryd_id
where(
-- відключене обладнання
:is_vidkl_oboryd in(-1,ao.is_vidkl) and
-- Обладнання
:spr_oboryd_id_in in (-1,ao.spr_oboryd_id) and
-- типи обладнання
:spr_oboryd_type_id_in in (-1,so.spr_oboryd_type_id) and
-- строки повірки димоходів
ao.DATA_NACT_DUMOXODA BETWEEN ND_S and ND_E and
-- строки пто
ao.DATA_NACT_PTO BETWEEN NPTO_S and NPTO_E
) and ( AO.ABO_OBORYD_ID = LD_ABO_OBORYD_ID
)
IS_VIDKL_OBORYD = -1
SPR_OBORYD_ID_IN = -1
SPR_OBORYD_TYPE_ID_IN = -1
DND_S = 01.01.1800
DND_E = 31.12.9999
DNPTO_S = 01.01.1800
DNPTO_E = 31.12.9999
OLD_ABO_OBORYD_ID = 392
Execute tick count 0
[Application: vdgo.exe]
tRobotaADC.SelectQuery: [Execute] SELECT
o.ABO_ID,
o.ABO_OBORYD_ID,
o.ABO_LICH_ID,
o.ABO_PRUPUCU_ID,
o.DATA_POCT_ZAYAVU,
substring(cast(cast(o.DATA_POCT_ZAYAVU as time) as varchar(13)) from 1 for 5 )as chas,
o.VREMYA,
o.DATA_VUK_ZAYAVU,
o.AVARIYA_REMONT,
iif(o.oper_type=1 and o.abo_id is not null,
(select trim(a.oc_rax)||ascii_char( 10 )||trim(sm.micto_name)||','||trim(sy.yliza)||','||trim(a.bydunok_nom)||','||trim(a.kvartira_nom) from abo a
left join spr_mict sm on sm.spr_mict_id=a.spr_mict_id
left join spr_yliz sy on sy.spr_yliz_id=a.spr_yliz_id
where a.abo_id=o.abo_id)||' - '||o.AVARIYA_REMONT,o.AVARIYA_REMONT) as AVARIYA_REMONT_TEXT,
o.REMONT,
o.CYMA,
o.AKT_NOM,
o.SPR_USER_ID,
o.PRUM,
o.OPER_TYPE,
o.EDIT_USER_ID,
o.EDIT_DATE,
o.ABO_OPER_ID
FROM
ABO_OPER o
where ( DATA_POCT_ZAYAVU>=:d1 and DATA_POCT_ZAYAVU<=:d2) and
( OPER_TYPE>=:OPER_TYPE1 and OPER_TYPE<=:OPER_TYPE2)
order by o.DATA_POCT_ZAYAVU,o.ABO_ID
D1 = 01.01.1800
D2 = 01.01.1800
OPER_TYPE1 = -1
OPER_TYPE2 = -1
Execute tick count 0
[Application: vdgo.exe]
tCtatictika: [Prepare] SELECT
STATNAME,
KOLVO_MONTH,
KOLVO_GOD
FROM
STATISTIKA(:D1,
2)
Plan: PLAN (ABO_OPER NATURAL)(ABO_OPER NATURAL)(ABO NATURAL)(ABO NATURAL)(ABO NATURAL)(ABO NATURAL)(ABO_OBORYD NATURAL)(ABO_OBORYD NATURAL)(ABO_OBORYD INDEX (ABO_OBORYD_IDX1))(ABO NATURAL)(ABO_OBORYD INDEX (ABO_OBORYD_IDX1))(ABO NATURAL)
[Application: vdgo.exe]
tCtatictika.RefreshQuery: [Execute] SELECT
STATNAME,
KOLVO_MONTH,
KOLVO_GOD
FROM
STATISTIKA(:D1,
2)
D1 = 01.06.2012
D2 = 30.06.2012
Execute tick count 0
[Application: vdgo.exe]
tCtatictika.SelectQuery: [Execute] SELECT
STATNAME,
KOLVO_MONTH,
KOLVO_GOD
FROM
STATISTIKA(:D1,
2)
D1 = 01.06.2012
D2 = 30.06.2012
Execute tick count 0
|
|
