后台删除掉t_rp_contact表中的数据后前台依然存在数据

栏目：k3wise知识作者：金蝶来源：金蝶云社区发布：2024-09-16浏览：1

我现在要删除掉

这里面的数据在后台删掉t_rp_contact表中的数据后发现前台仍然能查到那条数据后台已经查不到了。。在其他账套正常但是就是在这个账套里面有这种异常。。搞了好久了有谁知道是哪的问题么~~求解
采购发票除了存在往来单据表t_rp_contact中，还存在在采购发票表头icpurchase和采购发票表体icpurchaseentry及付款计划表t_rp_plan_ap中，查看一下是否单据没删干净

SET TRANSACTION ISOLATION LEVEL READ COMMITTED
go
insert into #TmpBillCheckList(FExchangeRateType,FID,FClassTypeID, FCurrencyID ,FCustomer,FDepartment,FEmployee,FItemClassID,
FInterID,FPre,FIsinit,FK3Import,FStatus,FCheckType,FInvoice,
FRPBillID , FBillID, FType , FNumber , FDate , FFincDate , FExchangeRate,FNoteContract,FExplanation,FCurrencyName ,FScaleFor ,
FBillTypeName, FCustomerNo,FCustomerName, FDepartmentName, FEmployeeName,
FPrepareName,FCheckName,FVoucherNumber,FReceiveTypeName,FSettleName,FSettleNo,FOrgNumber,FARNumber,
FBankName,FBankAccount, FContractNo ,FOrderNo, FReceiveBillID ,FRemainAmount, FRemainAmountFor,
FCheckStatus,FRemainAmount1,FRemainAmountFor1,FAmount ,FAmountFor ,FReceiveAmount ,FReceiveAmountFor,FDiscountAmount ,
FDiscountAmountFor,FSettleAmount,FSettleAmountFor,FSettleDiscount, FSettleDiscountFor,FSourceClassTypeID)
select a.FExchangeRateType,b.FID,a.FClassTypeID,a.FCurrencyID,a.FCustomer,a.FDepartment ,a.FEmployee,a.FItemClassID,a.FBillID FInterID,0 FPre,
0 FIsInit,b.FK3Import,b.FStatus,b.FCheckType, 0 FInvoiceID,a.FBillID FRPBillID,0 FBillID,b.FType,
a.FNumber,a.FDate,a.FFIncDate,a.FAdjustExchangeRate FExchangeRate,a.fcontractno,a.FExplanation,cur.FName FCurrencyName,cur.FScale FScaleFor,
(case b.FType when 1 then '其他应收单'when 2 then '其他应付单' end) FBillTypeName,
i.FNumber FCustomerNo,i.FName FCustomerName,ii.FName FDepartmentName,iii.FName FEmployeeName,
s.FName FPrepareName,t.FName FCheckName,
v.FName+'-'+cast(v.FNumber as Varchar) FVoucherNumber ,''FReceiveTypeName,''FSettleName,''FSettleNo,
'' FOrgNumber,'' FARNumber,''FBankName,'' FBankAccount,
'' FContractNo,''FOrderNo,
0 FReceiveBillID, (case when abs(c.FRemainAmount)>=abs(c.FAmount_commit-c.FLinkCheckAmount-c.FInvoiceAmount-c.FInvLinkCheckAmount) then (c.FRemainAmount-c.FAmount_commit+c.FLinkCheckAmount+c.FInvoiceAmount+c.FInvLinkCheckAmount) else 0 end)FRemainAmount,
(case when abs(c.FRemainAmountFor)>=abs(c.FAmountFor_commit-c.FLinkCheckAmountFor-c.FInvoiceAmountFor-c.FInvLinkCheckAmountFor) then (c.FRemainAmountFor-c.FAmountFor_commit+c.FLinkCheckAmountFor+c.FInvoiceAmountFor+c.FInvLinkCheckAmountFor) else 0 end)FRemainAmountFor,
a.FCheckStatus,c.FRemainAmount,c.FRemainAmountFor,c.FAmount,c.FAmountFor,
0 FReceiveAmountFor,0 FReceiveAmount,0 FDiscountAmount,0 FDiscountAmountFor,
0 FSettleAmount,0 FSettleAmountFor,0 FSettleDiscount,0 FSettleDiscountfor,
0 FClassTypeID from t_rp_arpbill a
inner join t_rp_arpbillEntry c on a.FBillID=c.FBillID join t_rp_contact b on a.FBillID=b.FRPBillID
left join t_currency cur on a.FCurrencyID=cur.FCurrencyID
left join t_item i on a.FCustomer=i.FItemID
left join t_item ii on a.FDepartment=ii.FItemID
left join t_item iii on a.FEmployee=iii.FItemID
left join t_user s on a.FPreParer=s.FUserID
left join t_user t on a.FChecker=t.FUserID
Left join (select v1.FVoucherID,v1.FNumber,v2.Fname FName from t_voucher v1
inner join t_vouchergroup v2 on v1.FGroupid=v2.fgroupid)v on b.FVoucherID=v.FVoucherID
where a.FRP=0
and c.FClassID_Src not in (1000021,1000022,1000520,1000521)
and b.FType not in(8,9) and a.FCheckStatus<>1
and a.FDate>= '1900/1/1'
and a.FDate<= '2017/4/7'
and a.FItemClassID=8
and (b.FStatus & 1)=1
and (b.FStatus & 16)=0
and a.FCurrencyID=1

and a.FFIncDate>= '1900/1/1'
and a.FFIncDate<= '2017/4/7'

go
SET TRANSACTION ISOLATION LEVEL READ COMMITTED
go
insert into #TmpBillCheckList(FExchangeRateType,FID,FClassTypeID, FCurrencyID ,FCustomer,FDepartment,FEmployee,FItemClassID,
FInterID,FPre,FIsinit,FK3Import,FStatus,FCheckType,FInvoice,
FRPBillID , FBillID, FType , FNumber , FDate , FFincDate , FExchangeRate,FNoteContract,FExplanation,FCurrencyName ,FScaleFor ,
FBillTypeName, FCustomerNo,FCustomerName, FDepartmentName, FEmployeeName,FPrepareName,
FCheckName,FVoucherNumber,FReceiveTypeName,FSettleName,FSettleNo,FOrgNumber,FARNumber,
FBankName,FBankAccount, FContractNo ,FOrderNo, FReceiveBillID ,FRemainAmount, FRemainAmountFor,
FCheckStatus,FRemainAmount1,FRemainAmountFor1, FAmount ,FAmountFor ,FReceiveAmount ,FReceiveAmountFor,FDiscountAmount ,
FDiscountAmountFor,FSettleAmount,FSettleAmountFor,FSettleDiscount, FSettleDiscountFor,FSourceClassTypeID)
select a.FExchangeRateType,b.FID, a.FClassTypeID,
a.FCurrencyID,a.FSupplyID FCustomer,a.FDeptID FDepartment,a.FEmpID FEmployee,a.FItemClassID,a.FInterID,0 FPre,
0 FIsInit,b.FK3Import,b.FStatus,b.FCheckType, a.FInterID FInvoiceID,0 FRPBillID,0 FBillID,4 FType,
a.FbillNo FNumber,a.FDate,a.FFIncDate,a.FAdjustExchangeRate FExchangeRate,a.fcompactno,a.FNote FExplanation,cur.FName,cur.FScale FScaleFor,
'采购发票' FBillTypeName,
i.FNumber FCustomerNo,i.FName FCustomerName,ii.FName FDepartmentName,iii.FName FEmployeeName,
s.FName FPrepareName,t.FName FCheckName,
v.FName+'-'+cast(v.FNumber as Varchar) FVoucherNumber ,''FReceiveTypeName,''FSettleName,''FSettleNo,
'' FOrgNumber,'' FARNumber,''FBankName,'' FBankAccount,
'' FContractNo,''FOrderNo,
0 FReceiveBillID, (case when abs(c.FRemainAmount)>=abs(c.FAmount_commit-c.FLinkCheckAmount-c.FInvoiceAmount-c.FInvLinkCheckAmount) then (c.FRemainAmount-c.FAmount_commit+c.FLinkCheckAmount+c.FInvoiceAmount+c.FInvLinkCheckAmount) else 0 end)FRemainAmount,
(case when abs(c.FRemainAmountFor)>=abs(c.FAmountFor_commit-c.FLinkCheckAmountFor-c.FInvoiceAmountFor-c.FInvLinkCheckAmountFor) then (c.FRemainAmountFor-c.FAmountFor_commit+c.FLinkCheckAmountFor+c.FInvoiceAmountFor+c.FInvLinkCheckAmountFor) else 0 end)FRemainAmountFor,
a.FCheckStatus,c.FRemainAmount,c.FRemainAmountFor,
(case a.FClassTypeID when 1000004 then c.FStdAmountIncludeTax else c.FStdAmount end)FAmount,
(case a.FClassTypeID when 1000004 then c.FAmountIncludeTax else c.FAmount end)FAmountFor,
0 FReceiveAmountFor,0 FReceiveAmount,0 FDiscountAmount,0 FDiscountAmountFor,
0 FSettleAmount,0 FSettleAmountFor,0 FSettleDiscount,0 FSettleDiscountfor,
0 FClassTypeID

select
(case when abs(c.FRemainAmount)>=abs(c.FAmount_commit-c.FLinkCheckAmount-c.FInvoiceAmount-c.FInvLinkCheckAmount) then (c.FRemainAmount-c.FAmount_commit+c.FLinkCheckAmount+c.FInvoiceAmount+c.FInvLinkCheckAmount) else 0 end)FRemainAmount,
(case when abs(c.FRemainAmountFor)>=abs(c.FAmountFor_commit-c.FLinkCheckAmountFor-c.FInvoiceAmountFor-c.FInvLinkCheckAmountFor) then (c.FRemainAmountFor-c.FAmountFor_commit+c.FLinkCheckAmountFor+c.FInvoiceAmountFor+c.FInvLinkCheckAmountFor) else 0 end)FRemainAmountFor

from IcPurchase a
inner join icpurchaseEntry c on a.FInterID=c.FInterID join t_rp_contact b on a.FInterID=b.FInvoiceID
left join t_currency cur on a.FCurrencyID=cur.FCurrencyID
left join t_item i on a.FSupplyID=i.FItemID
left join t_item ii on a.FDeptID=ii.FItemID
left join t_item iii on a.FEmPID=iii.FItemID
left join t_user s on a.FBillerID=s.FUserID
left join t_user t on a.FCheckerID=t.FUserID
Left join (select v1.FVoucherID,v1.FNumber,v2.Fname FName from t_voucher v1
inner join t_vouchergroup v2 on v1.FGroupid=v2.fgroupid)v on a.FVchInterID=v.FVoucherID
where b.FType=4 and b.FInvoiceType<>4
and c.FClassID_Src not in (1000003,1000004,75,76,1000500,1000501,1000502,1000503)
and b.FType not in(8,9) and a.FCheckStatus<>1
and a.FDate>= '1900/3/1'
and a.FDate<= '2017/4/7'
and a.FItemClassID=8
and (b.FStatus & 1)=1
and (b.FStatus & 16)=0
and a.FCurrencyID=1
and a.FFIncDate>= '1900/3/1'
and a.FFIncDate<= '2017/4/7'

go
select c.FExchangeRateType,c.FID,c.FType,c.FClassTypeID,c.FCurrencyID,c.FCustomer,c.FDepartment,c.FEmployee,c.FItemClassID,c.FInterID,c.FPre,
c.FIsInit,c.FK3Import,c.FStatus,c.FCheckType, c.FInvoice,c.FRPBillID,c.FBillID,
c.FNumber,c.FDate,c.FFIncDate,c.FExchangeRate,c.FCheckStatus,
c.FNoteContract, c.FExplanation,c.FCurrencyName,c.FScaleFor,c.FBillTypeName,
c.FCustomerNo,c.FCustomerName,c.FDepartmentName,c.FEmployeeName,
c.FPrepareName,c.FCheckName,c.FVoucherNumber,c.FReceiveTypeName,c.FSettleName,c.FSettleNo,
c.FOrgNumber,c.FARNumber,c.FBankName,c.FBankAccount,
c.FContractNo,c.FOrderNo,c.FReceiveBillID,c.FSourceClassTypeID, sum(c.FAmount)FAmount,sum(c.FAmountFor)FAmountFor,sum(c.FRemainAmount)FRemainAmount,sum(c.FRemainAmountFor)FRemainAmountFor,sum(c.FRemainAmount)FRemainAmount1,sum(c.FRemainAmountFor)FRemainAmountFor1,
sum(c.FReceiveAmountFor)FReceiveAmountFor,sum(c.FReceiveAmount)FReceiveAmount,sum(c.FDiscountAmountFor)FDiscountAmountFor,sum(c.FDiscountAmount) FDiscountAmount,
sum(c.FSettleAmount)FSettleAmount,sum(c.FSettleAmountFor)FSettleAmountFor,sum(FSettleDiscount)FSettleDiscount,sum(FSettleDiscountFor)FSettleDiscountFor
into #SumTmpBillCheckList
from #TmpBillCheckList c
where 1=1
group by c.FExchangeRateType,c.FID,c.FType,c.FClassTypeID,c.FCurrencyID,c.FCustomer,c.FDepartment,c.FEmployee,c.FItemClassID,c.FInterID,c.FPre,
c.FIsInit,c.FK3Import,c.FStatus,c.FCheckType, c.FInvoice,c.FRPBillID,c.FBillID,
c.FNumber,c.FDate,c.FFIncDate,c.FExchangeRate,c.FCheckStatus,
c.FNoteContract,c.FExplanation,c.FCurrencyName,c.FScaleFor,FBillTypeName,
c.FCustomerNo,c.FCustomerName,c.FDepartmentName,c.FEmployeeName,
c.FPrepareName,c.FCheckName,c.FVoucherNumber,c.FReceiveTypeName,c.FSettleName,c.FSettleNo,
c.FContractNo,c.FOrderNo,c.FReceiveBillID, c.FOrgNumber,c.FARNumber,c.FBankName,c.FBankAccount,c.FSourceClassTypeID

go
update a set a.FAmountFor=b.FAmountFor,a.FAmount=b.FAmount from #SumTmpBillCheckList a join t_rp_contact b on a.FID=b.FID where not exists(select 1 from t_rp_begData c where B.FbegID=C.Finterid)
go
select c.* from #SumTmpBillCheckList c where c.FRemainAmountFor<>0 order by c.FCustomerNo,c.FDate,c.FNumber,c.FIsinit Desc,c.FType,c.FBillTypeName
go
select sum(c.FAmount) FAmount,sum(c.FAmountFor) FAmountFor,sum(c.FRemainAmount)FRemainAmount,sum(c.FRemainAmountFor)FRemainAmountFor from #SumTmpBillCheckList c where c.FRemainAmountFor<>0
go
drop table #TmpBillCheckList
go
drop table #SumTmpBillCheckList
go
SET TRANSACTION ISOLATION LEVEL READ COMMITTED
go
select * from t_RP_SystemProfile where UPPER(FCategory)='ARP'
go
SET TRANSACTION ISOLATION LEVEL READ COMMITTED
go
select * from t_RP_SystemProfile where UPPER(FCategory)='ARP'
go
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
go
select FUserID from t_Group where FUserID = 16394 and FGroupID = 1
go
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
go
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
go
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
go
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
go
select FUserID from t_Group where FUserID = 16394 and FGroupID = 1
go
SET TRANSACTION ISOLATION LEVEL READ COMMITTED
go
SET TRANSACTION ISOLATION LEVEL READ COMMITTED
go
SET TRANSACTION ISOLATION LEVEL READ COMMITTED
go
SET TRANSACTION ISOLATION LEVEL READ COMMITTED
go
Select FValue from t_SystemProfile where FCategory='BOS' and FKey='AccessDataUsed'
go
SET TRANSACTION ISOLATION LEVEL READ COMMITTED
go
select FUserID from t_Group where FUserID = 16394 and FGroupID = 1
go
SET TRANSACTION ISOLATION LEVEL READ COMMITTED
go
Create Table #TmpBillCheckList(
FID int default(0),
FClassTypeID int default(0),
FSourceClassTypeID int default(0),
FCurrencyID int default(0),
FCustomer int default(0),
FDepartment int default(0),
FEmployee int default(0),
FItemClassID int default(0),
FInterID int default(0),
FPre int default(0),
FIsinit int default(0),
FK3Import int default(0),
FStatus int default(0),
FCheckType int default(0),
FInvoice int default(0),
FRPBillID int default(0),
FBillID int default(0),
FType int default(0),
FNumber varchar(255) default(' '),
FDate DateTime,
FFincDate DateTime,
FExchangeRate decimal(28,10),
FNoteContract varchar(255) default(' '),
FExplanation varchar(255) default(' '),
FCurrencyName varchar(255) default(' '),
FScaleFor int default(0),
FBillTypeName nvarchar(255) default(' '),
FCustomerNo varchar(255) default(' '),
FCustomerName varchar(255) default(' '),
FDepartmentNo varchar(255) default(' '),
FDepartmentName varchar(255) default(' '),
FEmployeeNo varchar(255) default(' '),
FEmployeeName varchar(255) default(' '),
FPrePareName varchar(255) default(' '),
FCheckName varchar(255) default(' '),
FVoucherNumber varchar(255) default(' '),
FReceiveTypeName varchar(255) default(' '),
FSettleName varchar(255) default(' '),
FSettleNo varchar(255) default(' '),
FOrgNumber varchar(255) default(' '),
FARNumber varchar(255) default(' '),
FBankName varchar(255) default(' '),
FBankAccount varchar(255) default(' '),
FContractNo varchar(255) default(' '),
FOrderNo varchar(255) default(' '),
FReceiveBillID int default(0),
FRemainAmount money default(0),
FRemainAmountFor money default(0),
FCheckStatus int default(0),
FRemainAmount1 money default(0),
FRemainAmountFor1 money default(0),
FAmount money default(0),
FAmountFor money default(0),
FReceiveAmount money default(0),
FReceiveAmountFor money default(0),
FDiscountAmount money default(0),
FDiscountAmountFor money default(0),
FSettleAmount money default(0),
FSettleAmountFor money default(0),
FSettleDiscount money default(0),
FSettleDiscountFor money default(0),
FExchangeRateType int default(1))

go
SET TRANSACTION ISOLATION LEVEL READ COMMITTED
go
insert into #TmpBillCheckList(FExchangeRateType,FID,FClassTypeID, FCurrencyID ,FCustomer,FDepartment,FEmployee,FItemClassID,
FInterID,FPre,FIsinit,FK3Import,FStatus,FCheckType,FInvoice,
FRPBillID , FBillID, FType , FNumber , FDate , FFincDate ,FExchangeRate, FNoteContract,FExplanation,FCurrencyName ,FScaleFor ,
FBillTypeName, FCustomerNo,FCustomerName, FDepartmentName, FEmployeeName,
FPrepareName,FCheckName,FVoucherNumber,FReceiveTypeName,FSettleName,FSettleNo,FOrgNumber,FARNumber,
FBankName,FBankAccount, FContractNo ,FOrderNo, FReceiveBillID ,FRemainAmount, FRemainAmountFor,
FCheckStatus ,FRemainAmount1,FRemainAmountFor1, FAmount ,FAmountFor ,FReceiveAmountFor, FReceiveAmount,FDiscountAmount ,
FDiscountAmountFor,FSettleAmount,FSettleAmountFor,FSettleDiscount, FSettleDiscountFor,FSourceClassTypeID)
select a.FExchangeRateType,b.FID,a.FClassTypeID,a.FCurrencyID,a.FCustomer,a.FDepartment,a.FEmployee,a.FItemClassID,a.FBillID FInterID,a.FPre,
0 FIsInit,b.FK3Import,b.FStatus,b.FCheckType, b.FInvoiceID,b.FRPBillID,b.FBillID,b.FType,
a.FNumber,a.FDate,a.FFIncDate,a.FAdjustExchangeRate FExchangeRate,a.fcontractno,a.FExplanation,cur.FName FCurrencyName,cur.FScale FScaleFor,
(case a.FRP when 1 then (case a.FPre when 1 then '预收单'when 0 then '收款单'when -1 then '退款单' end) when 0 then (case a.FPre when 1 then '预付单'when 0 then '付款单'when -1 then '退款单' end) end)FBillTypeName,
i.FNumber FCustomerNo,i.FName FCustomerName,ii.FName FDepartmentName,iii.FName FEmployeeName,
s.FName FPrepareName,t.FName FCheckName,
v.FName+'-'+cast(v.FNumber as Varchar) FVoucherNumber ,x2.FName FReceiveTypeName,x1.FName FSettleName,a.FSettleNo,
a.FOrgNumber,a.FARNumber,
(case when a.FClassTypeID in (1000005 ,1000014 ,1000017) then a.FRPbank when a.fclasstypeid in (1000016 ,1000018, 1000015) then a.FRPBank_Pay end ) FBankName,
(case when a.FClassTypeID in (1000005 ,1000014 ,1000017) then a.FBankAcct when a.fclasstypeid in (1000016 ,1000018, 1000015) then FBankAcct_Pay end ) FBankAccount,
'' FContractNo,''FOrderNo, 0 FReceiveBillID, (case when abs(c.FRemainAmount)>=abs(c.FBackAmount_relative-c.FLinkCheckAmount) then (c.FRemainAmount-c.FBackAmount_relative+c.FLinkCheckAmount) else c.FRemainAmount end) *(case a.FPre when -1 then -1 else 1 end)FRemainAmount,
(case when abs(c.FRemainAmountFor)>=abs(c.FBackAmountFor_relative-c.FLinkCheckAmountFor) then (c.FRemainAmountFor-c.FBackAmountFor_relative+c.FLinkCheckAmountFor) else c.FRemainAmountFor end)*(case a.FPre when -1 then -1 else 1 end)FRemainAmountFor,
a.FCheckStatus, (case a.FPre when -1 then c.FRemainAmount*(-1) else c.FRemainAmount end)FRemainAmount1, (case a.FPre when -1 then c.FRemainAmountFor*(-1) else c.FRemainAmountFor end)FRemainAmountFor1,
(case a.FPre when -1 then c.FSettleAmount*(-1)+c.FDiscount*(-1) else c.FSettleAmount+c.FDiscount end) FAmount,(case a.FPre when -1 then c.FSettleAmountFor*(-1)+c.FDiscountFor*(-1) else c.FSettleAmountFor+c.FDiscountFor end) FAmountFor,
(case a.FPre when -1 then c.FReceiveAmountFor*(-1) else c.FReceiveAmountFor end) FReceiveAmountFor,(case a.FPre when -1 then c.FReceiveAmount*(-1) else c.FReceiveAmount end) FReceiveAmount,
(case a.FPre when -1 then c.FDiscount*(-1) else c.FDiscount end) FDiscountAmount,(case a.FPre when -1 then c.FDiscountFor*(-1) else c.FDiscountFor end) FDiscountAmountFor,
(case a.FPre when -1 then c.FSettleAmount*(-1) else c.FSettleAmount end)FSettleAmount,(case a.FPre when -1 then c.FSettleAmountFor*(-1) else c.FSettleAmountFor end) FSettleAmountFor,0 FSettleDiscount,0 FSettleDiscountfor,0 FClassTypeID
select
(case when abs(c.FRemainAmount)>=abs(c.FAmount_commit-c.FLinkCheckAmount-c.FInvoiceAmount-c.FInvLinkCheckAmount) then (c.FRemainAmount-c.FAmount_commit+c.FLinkCheckAmount+c.FInvoiceAmount+c.FInvLinkCheckAmount) else 0 end)FRemainAmount,
(case when abs(c.FRemainAmountFor)>=abs(c.FAmountFor_commit-c.FLinkCheckAmountFor-c.FInvoiceAmountFor-c.FInvLinkCheckAmountFor) then (c.FRemainAmountFor-c.FAmountFor_commit+c.FLinkCheckAmountFor+c.FInvoiceAmountFor+c.FInvLinkCheckAmountFor) else 0 end)FRemainAmountFor

from t_rp_newReceiveBill a
inner join t_rp_arbillofsh c on a.FBillID=c.FBillID
join t_rp_contact b on a.FBillID=b.FBillID
left join t_currency cur on a.FCurrencyID=cur.FCurrencyID
left join t_item i on a.FCustomer=i.FItemID
left join t_item ii on a.FDepartment=ii.FItemID
left join t_item iii on a.FEmployee=iii.FItemID
left join t_user s on a.FPreParer=s.FUserID
left join t_user t on a.FChecker=t.FUserID
Left join t_settle x1 on a.FSettle=x1.FItemID
Left join t_rp_systemenum x2 on a.FBillType=x2.FItemID
Left join (select v1.FVoucherID,v1.FNumber,v2.Fname FName from t_voucher v1
inner join t_vouchergroup v2 on v1.FGroupid=v2.fgroupid)v on b.FVoucherID=v.FVoucherID
where 1=1 and (c.FID_SRC=0 or c.FClassID_SRC not in (1000000,1000002,1000003,1000004,1000005,1000014,1000021,1000022,1000500,1000501,1000502,1000503,1000520,1000521,1007140,1000016,1000018,1000511,1000510)) and a.FRp=0 and a.FPre in(0,-1)
and b.FType not in(8,9) and a.FCheckStatus<>1
and a.FDate>= '2017/3/1'
and a.FDate<= '2017/4/7'
and a.FItemClassID=8
and (b.FStatus & 1)=1
and (b.FStatus & 16)=0
and a.FCurrencyID=1
and a.FFIncDate>= '2017/3/1'
and a.FFIncDate<= '2017/4/7'

go
select a.FAmountFor,b.FAmountFor,a.FAmount,b.FAmount from #SumTmpBillCheckList a join t_rp_contact b on a.FID=b.FID where not exists(select 1 from t_rp_begData c where B.FbegID=C.Finterid)
go
update a set a.FDiscountAmountFor=b.FDiscountAmountFor,a.FDiscountAmount=b.FDiscountAmount,
a.FReceiveAmountFor=b.FReceiveAmountFor,a.FReceiveAmount=b.FReceiveAmount
from #SumTmpBillCheckList a inner join(select a.FBillID,(case a.FPre when -1 then b.FDiscountAmountFor*(-1) else b.FDiscountAmountFor end)FDiscountAmountFor,
(case a.FPre when -1 then b.FDiscountAmount*(-1) else b.FDiscountAmount end) FDiscountAmount,
(case a.FPre when -1 then b.FReceiveAmount*(-1) else b.FReceiveAmount end) FReceiveAmount,
(case a.FPre when -1 then b.FReceiveAmountFor*(-1)else b.FReceiveAmountFor end) FReceiveAmountFor
from(select t1.FBillID,sum(FDiscountFor)FDiscountAmountFor,sum(FDiscount)FDiscountAmount,
(case t2.Fmulcy when 1 then sum(t1.FSettleAmountFor) else sum(t1.FReceiveAmountFor) end ) FReceiveAmountFor,
(case t2.Fmulcy when 1 then sum(t1.FSettleAmount) else sum(t1.FReceiveAmount) end ) FReceiveAmount
from t_rp_arbillofsh t1 inner join t_rp_newreceivebill t2 on (t1.fbillid=t2.fbillid ) group by t1.FBillID,t2.FMulcy)b
inner join t_rp_newreceivebill a on b.FBIlliD=a.fBIllID)b on a.FInterID=b.FBIllID and a.FIsInit=0

go
select c.* from #SumTmpBillCheckList c where c.FRemainAmountFor<>0 order by c.FCustomerNo,c.FDate,c.FNumber,c.FIsinit Desc,c.FType,c.FBillTypeName
go
select sum(c.FAmount) FAmount,sum(c.FAmountFor) FAmountFor,sum(c.FRemainAmount)FRemainAmount,sum(c.FRemainAmountFor)FRemainAmountFor from #SumTmpBillCheckList c where c.FRemainAmountFor<>0
go
drop table #TmpBillCheckList
go
drop table #SumTmpBillCheckList
go
SET TRANSACTION ISOLATION LEVEL READ COMMITTED
go
select * from t_RP_SystemProfile where UPPER(FCategory)='ARP'
go
SELECT COUNT(T1.FDataCenterID) fcount, MAX(T1.FCREATEDATE) fcreatedate FROM T_BAS_DATACENTER T1 WHERE FISCLOUDDB = '1'
go
SET FMTONLY OFF; SET NO_BROWSETABLE ON;SELECT T_BOS_COMPUTETASK.FExecutorType, T_BOS_COMPUTETASK.FProperties, T_BOS_COMPUTETASK.FBOSContext, T_BOS_COMPUTETASK.FLog, T_BOS_COMPUTETASK.FComputeId, T_BOS_COMPUTETASK.FTitle, T_BOS_COMPUTETASK.FPriority, T_BOS_COMPUTETASK.FStatus, T_BOS_COMPUTETASK.FProgress, T_BOS_COMPUTETASK.FOriginatorId, T_BOS_COMPUTETASK.FComputeSource FROM T_BOS_COMPUTETASK WHERE (T_BOS_COMPUTETASK.FSTATUS = 1 AND T_BOS_COMPUTETASK.FCOMPUTESOURCE = 'DESKTOP-UTPV32M') SET NO_BROWSETABLE OFF;
go
SET FMTONLY OFF; SET NO_BROWSETABLE ON;SELECT T_BOS_COMPUTETASK.FExecutorType, T_BOS_COMPUTETASK.FProperties, T_BOS_COMPUTETASK.FBOSContext, T_BOS_COMPUTETASK.FLog, T_BOS_COMPUTETASK.FComputeId, T_BOS_COMPUTETASK.FTitle, T_BOS_COMPUTETASK.FPriority, T_BOS_COMPUTETASK.FStatus, T_BOS_COMPUTETASK.FProgress, T_BOS_COMPUTETASK.FOriginatorId, T_BOS_COMPUTETASK.FComputeSource FROM T_BOS_COMPUTETASK WHERE (T_BOS_COMPUTETASK.FSTATUS = 1 AND T_BOS_COMPUTETASK.FCOMPUTESOURCE = 'DESKTOP-UTPV32M') SET NO_BROWSETABLE OFF;
go
SET FMTONLY OFF; SET NO_BROWSETABLE ON;SELECT T_BOS_COMPUTETASK.FExecutorType, T_BOS_COMPUTETASK.FProperties, T_BOS_COMPUTETASK.FBOSContext, T_BOS_COMPUTETASK.FLog, T_BOS_COMPUTETASK.FComputeId, T_BOS_COMPUTETASK.FTitle, T_BOS_COMPUTETASK.FPriority, T_BOS_COMPUTETASK.FStatus, T_BOS_COMPUTETASK.FProgress, T_BOS_COMPUTETASK.FOriginatorId, T_BOS_COMPUTETASK.FComputeSource FROM T_BOS_COMPUTETASK WHERE (T_BOS_COMPUTETASK.FSTATUS = 1 AND T_BOS_COMPUTETASK.FCOMPUTESOURCE = 'DESKTOP-UTPV32M') SET NO_BROWSETABLE OFF;
go

FAmount

INSERT INTO ICReportProfile(FuserID,FRptID,FPlan,FKey,FValue,FStatus) VALUES(16394,'5888810'
,N'默认方案','Contract'
,'',1)

go
INSERT INTO ICReportProfile(FuserID,FRptID,FPlan,FKey,FValue,FStatus) VALUES(16394,'5888810'
,N'默认方案','OrderNo'
,'',1)

go
INSERT INTO ICReportProfile(FuserID,FRptID,FPlan,FKey,FValue,FStatus) VALUES(16394,'5888810'
,N'默认方案','Connext'
,'',1)

go
INSERT INTO ICReportProfile(FuserID,FRptID,FPlan,FKey,FValue,FStatus) VALUES(16394,'5888810'
,N'默认方案','Contract1'
,'',1)

go
INSERT INTO ICReportProfile(FuserID,FRptID,FPlan,FKey,FValue,FStatus) VALUES(16394,'5888810'
,N'默认方案','ItemClassAP'
,'客户',1)

go
INSERT INTO ICReportProfile(FuserID,FRptID,FPlan,FKey,FValue,FStatus) VALUES(16394,'5888810'
,N'默认方案','CurrencyAp'
,'人民币',1)

go
INSERT INTO ICReportProfile(FuserID,FRptID,FPlan,FKey,FValue,FStatus) VALUES(16394,'5888810'
,N'默认方案','CustomerAPFrom'
,'',1)

go
INSERT INTO ICReportProfile(FuserID,FRptID,FPlan,FKey,FValue,FStatus) VALUES(16394,'5888810'
,N'默认方案','CustomerAPTo'
,'',1)

go
INSERT INTO ICReportProfile(FuserID,FRptID,FPlan,FKey,FValue,FStatus) VALUES(16394,'5888810'
,N'默认方案','DepartmentAP'
,'',1)

go
INSERT INTO ICReportProfile(FuserID,FRptID,FPlan,FKey,FValue,FStatus) VALUES(16394,'5888810'
,N'默认方案','EmployeeAP'
,'',1)

go
INSERT INTO ICReportProfile(FuserID,FRptID,FPlan,FKey,FValue,FStatus) VALUES(16394,'5888810'
,N'默认方案','AmountFromAp'
,'0',1)

go
INSERT INTO ICReportProfile(FuserID,FRptID,FPlan,FKey,FValue,FStatus) VALUES(16394,'5888810'
,N'默认方案','AmountToAp'
,'0',1)

go
INSERT INTO ICReportProfile(FuserID,FRptID,FPlan,FKey,FValue,FStatus) VALUES(16394,'5888810'
,N'默认方案','DateFromAp'
,'1900/1/1',1)

go
INSERT INTO ICReportProfile(FuserID,FRptID,FPlan,FKey,FValue,FStatus) VALUES(16394,'5888810'
,N'默认方案','DateToAp'
,'2017/4/7',1)

go
INSERT INTO ICReportProfile(FuserID,FRptID,FPlan,FKey,FValue,FStatus) VALUES(16394,'5888810'
,N'默认方案','MoneyDateFromAp'
,'1900/1/1',1)

go
INSERT INTO ICReportProfile(FuserID,FRptID,FPlan,FKey,FValue,FStatus) VALUES(16394,'5888810'
,N'默认方案','MoneyDateToAp'
,'2017/4/7',1)

go
INSERT INTO ICReportProfile(FuserID,FRptID,FPlan,FKey,FValue,FStatus) VALUES(16394,'5888810'
,N'默认方案','Contract1Ap'
,'',1)

go
INSERT INTO ICReportProfile(FuserID,FRptID,FPlan,FKey,FValue,FStatus) VALUES(16394,'5888810'
,N'默认方案','ConnextAp'
,'',1)

go
INSERT INTO ICReportProfile(FuserID,FRptID,FPlan,FKey,FValue,FStatus) VALUES(16394,'5888810'
,N'默认方案','ContractAp'
,'',1)

go
INSERT INTO ICReportProfile(FuserID,FRptID,FPlan,FKey,FValue,FStatus) VALUES(16394,'5888810'
,N'默认方案','OrderNoAp'
,'',1)

go
INSERT INTO ICReportProfile(FuserID,FRptID,FPlan,FKey,FValue,FStatus) VALUES(16394,'5888810'
,N'默认方案','Order'
,'1',1)

go
INSERT INTO ICReportProfile(FuserID,FRptID,FPlan,FKey,FValue,FStatus) VALUES(16394,'5888810'
,N'默认方案','OrderName'
,'0',1)

go
INSERT INTO ICReportProfile(FuserID,FRptID,FPlan,FKey,FValue,FStatus) VALUES(16394,'5888810'
,N'默认方案','Relative'
,'0',1)

go
INSERT INTO ICReportProfile(FuserID,FRptID,FPlan,FKey,FValue,FStatus) VALUES(16394,'5888810'
,N'默认方案','Rate'
,'0',1)

go
INSERT INTO ICReportProfile(FuserID,FRptID,FPlan,FKey,FValue,FStatus) VALUES(16394,'5888810'
,N'默认方案','IncludeArBill'
,'0',1)

go
INSERT INTO ICReportProfile(FuserID,FRptID,FPlan,FKey,FValue,FStatus) VALUES(16394,'5888810'
,N'默认方案','IncludeIcItem'
,'0',1)

go
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
go
select FUserID from t_Group where FUserID = 16394 and FGroupID = 1
go
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
go
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
go
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
go
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
go
select FUserID from t_Group where FUserID = 16394 and FGroupID = 1
go
SET TRANSACTION ISOLATION LEVEL READ COMMITTED
go
SET TRANSACTION ISOLATION LEVEL READ COMMITTED
go
SET TRANSACTION ISOLATION LEVEL READ COMMITTED
go
SET TRANSACTION ISOLATION LEVEL READ COMMITTED
go
Select FValue from t_SystemProfile where FCategory='BOS' and FKey='AccessDataUsed'
go
SET TRANSACTION ISOLATION LEVEL READ COMMITTED
go
select FUserID from t_Group where FUserID = 16394 and FGroupID = 1
go
SET TRANSACTION ISOLATION LEVEL READ COMMITTED
go
Create Table #TmpBillCheckList(
FID int default(0),
FClassTypeID int default(0),
FSourceClassTypeID int default(0),
FCurrencyID int default(0),
FCustomer int default(0),
FDepartment int default(0),
FEmployee int default(0),
FItemClassID int default(0),
FInterID int default(0),
FPre int default(0),
FIsinit int default(0),
FK3Import int default(0),
FStatus int default(0),
FCheckType int default(0),
FInvoice int default(0),
FRPBillID int default(0),
FBillID int default(0),
FType int default(0),
FNumber varchar(255) default(' '),
FDate DateTime,
FFincDate DateTime,
FExchangeRate decimal(28,10),
FNoteContract varchar(255) default(' '),
FExplanation varchar(255) default(' '),
FCurrencyName varchar(255) default(' '),
FScaleFor int default(0),
FBillTypeName nvarchar(255) default(' '),
FCustomerNo varchar(255) default(' '),
FCustomerName varchar(255) default(' '),
FDepartmentNo varchar(255) default(' '),
FDepartmentName varchar(255) default(' '),
FEmployeeNo varchar(255) default(' '),
FEmployeeName varchar(255) default(' '),
FPrePareName varchar(255) default(' '),
FCheckName varchar(255) default(' '),
FVoucherNumber varchar(255) default(' '),
FReceiveTypeName varchar(255) default(' '),
FSettleName varchar(255) default(' '),
FSettleNo varchar(255) default(' '),
FOrgNumber varchar(255) default(' '),
FARNumber varchar(255) default(' '),
FBankName varchar(255) default(' '),
FBankAccount varchar(255) default(' '),
FContractNo varchar(255) default(' '),
FOrderNo varchar(255) default(' '),
FReceiveBillID int default(0),
FRemainAmount money default(0),
FRemainAmountFor money default(0),
FCheckStatus int default(0),
FRemainAmount1 money default(0),
FRemainAmountFor1 money default(0),
FAmount money default(0),
FAmountFor money default(0),
FReceiveAmount money default(0),
FReceiveAmountFor money default(0),
FDiscountAmount money default(0),
FDiscountAmountFor money default(0),
FSettleAmount money default(0),
FSettleAmountFor money default(0),
FSettleDiscount money default(0),
FSettleDiscountFor money default(0),
FExchangeRateType int default(1))

and a.FFIncDate>= '1900/1/1'
and a.FFIncDate<= '2017/4/7'

这是后台追踪的代码

exec sp_reset_connection icpu
go
/*dialect*/select 100- cast(cast(available_physical_memory_kb as numeric(23,10))*100/total_physical_memory_kb as numeric(23,2)) from sys.dm_os_sys_memory
go
/*dialect*/
SELECT [divfs].[database_id] ,
[divfs].[file_id] ,
[divfs].[sample_ms] ,
[divfs].[num_of_reads] ,
[divfs].[num_of_bytes_read] ,
[divfs].[io_stall_read_ms] ,
[divfs].[num_of_writes] ,
[divfs].[num_of_bytes_written] ,
[divfs].[io_stall_write_ms] ,
[divfs].[io_stall] ,
[divfs].[size_on_disk_bytes] ,
[divfs].[file_handle] into TMP43C0A1671B6011E79BD468F7280
FROM [sys].[dm_io_virtual_file_stats](NULL, NULL) AS divfs
go
SELECT COUNT(T1.FDataCenterID) fcount, MAX(T1.FCREATEDATE) fcreatedate FROM T_BAS_DATACENTER T1 WHERE FISCLOUDDB = '1'
go
SET FMTONLY OFF; SET NO_BROWSETABLE ON;SELECT T_BOS_COMPUTETASK.FExecutorType, T_BOS_COMPUTETASK.FProperties, T_BOS_COMPUTETASK.FBOSContext, T_BOS_COMPUTETASK.FLog, T_BOS_COMPUTETASK.FComputeId, T_BOS_COMPUTETASK.FTitle, T_BOS_COMPUTETASK.FPriority, T_BOS_COMPUTETASK.FStatus, T_BOS_COMPUTETASK.FProgress, T_BOS_COMPUTETASK.FOriginatorId, T_BOS_COMPUTETASK.FComputeSource FROM T_BOS_COMPUTETASK WHERE (T_BOS_COMPUTETASK.FSTATUS = 1 AND T_BOS_COMPUTETASK.FCOMPUTESOURCE = 'DESKTOP-UTPV32M') SET NO_BROWSETABLE OFF;
go
SET FMTONLY OFF; SET NO_BROWSETABLE ON;SELECT T_BOS_COMPUTETASK.FExecutorType, T_BOS_COMPUTETASK.FProperties, T_BOS_COMPUTETASK.FBOSContext, T_BOS_COMPUTETASK.FLog, T_BOS_COMPUTETASK.FComputeId, T_BOS_COMPUTETASK.FTitle, T_BOS_COMPUTETASK.FPriority, T_BOS_COMPUTETASK.FStatus, T_BOS_COMPUTETASK.FProgress, T_BOS_COMPUTETASK.FOriginatorId, T_BOS_COMPUTETASK.FComputeSource FROM T_BOS_COMPUTETASK WHERE (T_BOS_COMPUTETASK.FSTATUS = 1 AND T_BOS_COMPUTETASK.FCOMPUTESOURCE = 'DESKTOP-UTPV32M') SET NO_BROWSETABLE OFF;
go
SET FMTONLY OFF; SET NO_BROWSETABLE ON;SELECT T_BOS_COMPUTETASK.FExecutorType, T_BOS_COMPUTETASK.FProperties, T_BOS_COMPUTETASK.FBOSContext, T_BOS_COMPUTETASK.FLog, T_BOS_COMPUTETASK.FComputeId, T_BOS_COMPUTETASK.FTitle, T_BOS_COMPUTETASK.FPriority, T_BOS_COMPUTETASK.FStatus, T_BOS_COMPUTETASK.FProgress, T_BOS_COMPUTETASK.FOriginatorId, T_BOS_COMPUTETASK.FComputeSource FROM T_BOS_COMPUTETASK WHERE (T_BOS_COMPUTETASK.FSTATUS = 1 AND T_BOS_COMPUTETASK.FCOMPUTESOURCE = 'DESKTOP-UTPV32M') SET NO_BROWSETABLE OFF;
go
SET FMTONLY OFF; SET NO_BROWSETABLE ON;SELECT FID, FEXECUTETIME, FPARAMETER, FFAILEDTIMES, FMAXFAILEDTIMES, FBILLTYPE, FBILLID, FSERVICECLASS, FCONTEXT FROM T_HR_BACKGROUNDTASK WHERE ((FFAILEDTIMES < FMAXFAILEDTIMES) AND (FEXECUTETIME IS NOT NULL)) SET NO_BROWSETABLE OFF;
go
SET FMTONLY OFF; SET NO_BROWSETABLE ON;SELECT FID, FEXECUTETIME, FPARAMETER, FFAILEDTIMES, FMAXFAILEDTIMES, FBILLTYPE, FBILLID, FSERVICECLASS, FCONTEXT FROM T_HR_BACKGROUNDTASK WHERE ((FFAILEDTIMES < FMAXFAILEDTIMES) AND (FEXECUTETIME IS NOT NULL)) SET NO_BROWSETABLE OFF;
go
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
go
select FSubSysID from t_DataFlowSubFunc where FSubFuncID=609
go
SET NOCount on
select a.FConnectString,a.FDBType,a.FServer,a.FSysUser,a.FSysPwd,a.FNodeID,d.FDBMSName,d.FVersion from T_AD_KDACCOUNT_GL a,t_ad_dbtype d where a.FDBType = d.FTypeID and a.FAcctID = 1
go
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
go
SET NOCount on
set transaction isolation level read uncommitted SELECT * FROM t_ad_UsingRec where fsubid in ('ap','ar','bb','cn','cs','fa','fygl','gl','pa','wb') and fworkstation='192.168.1.113'
go
SET NOCount on
set transaction isolation level read uncommitted SELECT * FROM t_ad_UsingRec
go
SET NOCount on
set transaction isolation level read uncommitted SELECT * FROM t_ad_UsingRec
go
SET TRANSACTION ISOLATION LEVEL READ COMMITTED
go
SELECT FValue FROM t_SystemProfile WHERE FKey='AcctType'
go
SET TRANSACTION ISOLATION LEVEL READ COMMITTED
go
select FValue from t_RP_SystemProfile where FKey='FFinishSPV102'
go
SET TRANSACTION ISOLATION LEVEL READ COMMITTED
go
select count(1) as recordcount from syscolumns where id=(select id from sysobjects where name='t_log')
go
INSERT INTO t_Log (FDate,FUserID,FFunctionID,FStatement,FDescription,FMachineName,FIPAddress) VALUES (getdate(),16394,'E00202',1,'','DESKTOP-UTPV32M','192.168.1.113')
go
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
go
SET TRANSACTION ISOLATION LEVEL READ COMMITTED
go
select count(1) as recordcount from syscolumns where id=(select id from sysobjects where name='t_log')
go
INSERT INTO t_Log (FDate,FUserID,FFunctionID,FStatement,FDescription,FMachineName,FIPAddress) VALUES (getdate(),16394,'E00202',3,'','DESKTOP-UTPV32M','192.168.1.113')
go
SET TRANSACTION ISOLATION LEVEL READ COMMITTED
go
UPDATE t_NormalFunc SET FClickNumber = FClickNumber + 1 WHERE FUserID=16394 AND FDetailFuncID=60901
go
/*dialect*/
select [elapsed time s], sum([bytes read])/ [elapsed time s]/1024 as [read Kbytes per s],sum([bytes write])/[elapsed time s]/1024 as [write Kbytes per s] from(
SELECT
DB_NAME([divfs].[database_id]) AS [database] ,
[mf].[type_desc] AS [file type] ,
mf.[name] AS [file name] ,
CONVERT(DECIMAL(16, 3), CONVERT(BIGINT, [mf].[size]) / 128.0) AS [size_mb] ,
CONVERT(DECIMAL(10, 2), ( [divfs].[sample_ms] - [t].[sample_ms] ) / 1000.0) AS [elapsed time s] ,
[divfs].[num_of_reads] - [t].[num_of_reads] AS [reads] ,
[divfs].[num_of_bytes_read] - [t].[num_of_bytes_read] AS [bytes read] ,
[divfs].[io_stall_read_ms] - [t].[io_stall_read_ms] AS [stall read] ,
CASE WHEN ( [divfs].[io_stall_read_ms] - [t].[io_stall_read_ms] )
- ( [divfs].[io_stall_write_ms] - [t].[io_stall_write_ms] ) > 0
THEN '<< Read Bias'
WHEN ( [divfs].[io_stall_read_ms] - [t].[io_stall_read_ms] )
- ( [divfs].[io_stall_write_ms] - [t].[io_stall_write_ms] ) < 0
THEN 'Write Bias >>'
ELSE ''
END AS [Stall Balance] ,
CASE WHEN ( [divfs].[num_of_bytes_read] - [t].[num_of_bytes_read] )
- ( [divfs].[num_of_bytes_written] - [t].[num_of_bytes_written] ) > 0
THEN '<< Read Bias'
WHEN ( [divfs].[num_of_bytes_read] - [t].[num_of_bytes_read] )
- ( [divfs].[num_of_bytes_written] - [t].[num_of_bytes_written] ) < 0
THEN 'Write Bias >>'
ELSE ''
END AS [Read/Write Balance] ,
[divfs].[num_of_writes] - [t].[num_of_writes] AS [writes] ,
[divfs].[num_of_bytes_written] - [t].[num_of_bytes_written] AS [bytes write] ,
[divfs].[io_stall_write_ms] - [t].[io_stall_write_ms] AS [stall write] ,
[divfs].[io_stall] - [t].[io_stall] AS [stall] ,
[divfs].[size_on_disk_bytes] - [t].[size_on_disk_bytes] AS [size change]
FROM
[sys].[dm_io_virtual_file_stats](NULL, NULL) AS divfs
INNER JOIN TMP43C0A1671B6011E79BD468F7280 AS t
ON
[divfs].[database_id] = [t].[database_id]
AND [divfs].[file_handle] = [t].[file_handle]
INNER JOIN [sys].[master_files] AS mf
ON
[t].[database_id] = [mf].[database_id]
AND [t].[file_id] = [mf].[file_id]
)t0 group by [elapsed time s]
go
drop table TMP43C0A1671B6011E79BD468F7280
go
SET TRANSACTION ISOLATION LEVEL READ COMMITTED
go
SELECT FValue FROM t_SystemProfile WHERE FKey='AcctType'
go
SET TRANSACTION ISOLATION LEVEL READ COMMITTED
go
select FValue from t_RP_SystemProfile where FKey='FAPCurPeriod'
go
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
go
SELECT FIsNeedOffline FROM T_OfflineInfo WHERE FUserID = 16394 AND FWorkStation = 'DESKTOP-UTPV32M'
go
SELECT FValue FROM T_SystemProfile WHERE FKey='NeedOfflineQuery' and FCategory='LX'
go
SELECT FValue FROM T_SystemProfile WHERE FKey='NeedOfflineQuery' and FCategory='LX'
go
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
go
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
go
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
go
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
go
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
go
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
go
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
go
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
go
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
go
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
go
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
go
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
go
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
go
SET TRANSACTION ISOLATION LEVEL READ COMMITTED
go
SELECT FValue FROM t_SystemProfile WHERE FKey='AcctType'
go
SET TRANSACTION ISOLATION LEVEL READ COMMITTED
go
select FValue from t_RP_SystemProfile where FKey='FAPCurYear'
go
select FStartDate,FEndDate from T_PeriodDate where FPeriod=2 and fyear=2014
go
SET TRANSACTION ISOLATION LEVEL READ COMMITTED
go
SELECT FValue FROM t_SystemProfile WHERE FKey='AcctType'
go
SET TRANSACTION ISOLATION LEVEL READ COMMITTED
go
select FValue from t_RP_SystemProfile where FKey='FAPCurPeriod'
go
SET TRANSACTION ISOLATION LEVEL READ COMMITTED
go
SELECT FValue FROM t_SystemProfile WHERE FKey='AcctType'
go
SET TRANSACTION ISOLATION LEVEL READ COMMITTED
go
select FValue from t_RP_SystemProfile where FKey='FAPCurYear'
go
select FStartDate,FEndDate from T_PeriodDate where FPeriod=2 and fyear=2014
go
SET FMTONLY OFF; SET NO_BROWSETABLE ON;SELECT FID, FEXECUTETIME, FPARAMETER, FFAILEDTIMES, FMAXFAILEDTIMES, FBILLTYPE, FBILLID, FSERVICECLASS, FCONTEXT FROM T_HR_BACKGROUNDTASK WHERE ((FFAILEDTIMES < FMAXFAILEDTIMES) AND (FEXECUTETIME IS NOT NULL)) SET NO_BROWSETABLE OFF;
go
SET TRANSACTION ISOLATION LEVEL READ COMMITTED
go
SET TRANSACTION ISOLATION LEVEL READ COMMITTED
go
Select FValue from t_SystemProfile where FCategory='BOS' and FKey='AccessDataUsed'
go
SET TRANSACTION ISOLATION LEVEL READ COMMITTED
go
select FUserID from t_Group where FUserID = 16394 and FGroupID = 1
go
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
go
SELECT * FROM t_Currency t1 WHERE t1.FDeleted=0 AND t1.FCurrencyID <> 0 ORDER BY t1.FCurrencyID
go
SET TRANSACTION ISOLATION LEVEL READ UnCOMMITTED
go
SELECT Distinct FPlan,FStatus FROM ICReportProfile WHERE FRptID= '5888810'
AND FUserID=16394
go
SET TRANSACTION ISOLATION LEVEL READ UnCOMMITTED
go
select * from ICReportProfile where FRptid= '5888810' and FPlan=N'默认方案'
AND FUserID=16394
go
SET TRANSACTION ISOLATION LEVEL READ COMMITTED
go
select * from t_RP_SystemProfile where UPPER(FCategory)='ARP' and FKey like 'FItemClassAP%'
go
SET TRANSACTION ISOLATION LEVEL READ COMMITTED
go
select * from t_RP_SystemProfile where UPPER(FCategory)='ARP' and FKey like 'FItemClassAR%'
go
SET TRANSACTION ISOLATION LEVEL READ UnCOMMITTED
go
SELECT Distinct FPlan,FStatus FROM ICReportProfile WHERE FRptID= '5888810'
AND FUserID=16394
go
SET TRANSACTION ISOLATION LEVEL READ UnCOMMITTED
go
select * from ICReportProfile where FRptid= '5888810' and FPlan=N'默认方案'
AND FUserID=16394
go
SET TRANSACTION ISOLATION LEVEL READ COMMITTED
go
select * from t_RP_SystemProfile where UPPER(FCategory)='ARP' and FKey like 'FItemClassAP%'
go
SET TRANSACTION ISOLATION LEVEL READ COMMITTED
go
select * from t_RP_SystemProfile where UPPER(FCategory)='ARP' and FKey like 'FItemClassAR%'
go
SET TRANSACTION ISOLATION LEVEL READ UnCOMMITTED
go
SELECT Distinct FPlan,FStatus FROM ICReportProfile WHERE FRptID= '5888810'
AND FUserID=16394
go
SET TRANSACTION ISOLATION LEVEL READ UnCOMMITTED
go
select * from ICReportProfile where FRptid= '5888810' and FPlan=N'默认方案'
AND FUserID=16394
go
SET TRANSACTION ISOLATION LEVEL READ UnCOMMITTED
go
SELECT Distinct FPlan,FStatus FROM ICReportProfile WHERE FRptID= '5888810'
AND FUserID=16394
go
SET TRANSACTION ISOLATION LEVEL READ UnCOMMITTED
go
select * from ICReportProfile where FRptid= '5888810' and FPlan=N'默认方案'
AND FUserID=16394
go
SET TRANSACTION ISOLATION LEVEL READ COMMITTED
go
SET NO_BROWSETABLE ON
go
SELECT FStatus FROM ICReportProfile WHERE FUserID=16394
AND FRptID= '5888810'

go
SET NO_BROWSETABLE OFF
go
Delete from ICReportProfile WHERE FUserID=16394
AND FRptID= '5888810'
AND Fplan=N'默认方案'
go
INSERT INTO ICReportProfile(FuserID,FRptID,FPlan,FKey,FValue,FStatus) VALUES(16394,'5888810'
,N'默认方案','CheckType'
,'付款结算',1)

go
INSERT INTO ICReportProfile(FuserID,FRptID,FPlan,FKey,FValue,FStatus) VALUES(16394,'5888810'
,N'默认方案','ItemClass'
,'供应商',1)

go
INSERT INTO ICReportProfile(FuserID,FRptID,FPlan,FKey,FValue,FStatus) VALUES(16394,'5888810'
,N'默认方案','Currency'
,'人民币',1)

go
INSERT INTO ICReportProfile(FuserID,FRptID,FPlan,FKey,FValue,FStatus) VALUES(16394,'5888810'
,N'默认方案','CustomerFrom'
,'',1)

go
INSERT INTO ICReportProfile(FuserID,FRptID,FPlan,FKey,FValue,FStatus) VALUES(16394,'5888810'
,N'默认方案','CustomerTo'
,'',1)

go
INSERT INTO ICReportProfile(FuserID,FRptID,FPlan,FKey,FValue,FStatus) VALUES(16394,'5888810'
,N'默认方案','Department'
,'',1)

go
INSERT INTO ICReportProfile(FuserID,FRptID,FPlan,FKey,FValue,FStatus) VALUES(16394,'5888810'
,N'默认方案','Employee'
,'',1)

go
INSERT INTO ICReportProfile(FuserID,FRptID,FPlan,FKey,FValue,FStatus) VALUES(16394,'5888810'
,N'默认方案','AmountFrom'
,'0',1)

go
INSERT INTO ICReportProfile(FuserID,FRptID,FPlan,FKey,FValue,FStatus) VALUES(16394,'5888810'
,N'默认方案','AmountTo'
,'0',1)

go
INSERT INTO ICReportProfile(FuserID,FRptID,FPlan,FKey,FValue,FStatus) VALUES(16394,'5888810'
,N'默认方案','DateFrom'
,'1900/1/1',1)

go
INSERT INTO ICReportProfile(FuserID,FRptID,FPlan,FKey,FValue,FStatus) VALUES(16394,'5888810'
,N'默认方案','DateTo'
,'2017/4/7',1)

go
INSERT INTO ICReportProfile(FuserID,FRptID,FPlan,FKey,FValue,FStatus) VALUES(16394,'5888810'
,N'默认方案','MoneyDateFrom'
,'1900/1/1',1)

go
INSERT INTO ICReportProfile(FuserID,FRptID,FPlan,FKey,FValue,FStatus) VALUES(16394,'5888810'
,N'默认方案','MoneyDateTo'
,'2017/4/7',1)

后台删除掉t_rp_contact表中的数据后前台依然存在数据

我现在要删除掉这里面的数据在后台删掉t_rp_contact表中的数据后发现前台仍然能查到那条数据后台已经查不到了。。在其...

点击下载文档

上一篇：14.2物料配套查询表引出Excel下一篇：kis标准版7.5/8.1如何升级到k3 wise 14.2

本文2024-09-16 17:03:08发表“k3wise知识”栏目。
本文链接：https://wenku.my7c.com/article/kingdee-k3wise-13209.html

后台删除掉t_rp_contact表中的数据后前台依然存在数据

后台删除掉t_rp_contact表中的数据后前台依然存在数据

管理会计—副产品核算不到成本

标准成本存货收发存汇总表和存货明细账数据不一致

【U8+】管理会计-分步分项结转-分项成本核算流程

【U8+】管理会计-成本管理-联副产品核算流程

【U8+】供应链-委外管理-委外总体-委外业务流程

【U8+】供应链-合同管理-合同期初录入

【U8+】供应链-质量管理-来料检验流程

成本管理-存货数据来源设置-计入直接材料和入库数量的出入库类别设置及作用

成本管理-期末处理自动生成的调整单计入成本

成本管理-系统出库调整单对照表的应用和设置

阅读排行

后台删除掉t_rp_contact表中的数据后前台依然存在数据

后台删除掉t_rp_contact表中的数据后前台依然存在数据

相关文章

阅读排行