金蝶KIS迷你版V9.1带加密狗的数据被刷

kejianhua

请看附近，金蝶KIS迷你版V9.1带加密狗的数据被刷，是盗版的，不知道有哪位朋友知道原因，有没有碰到这情况 。数据如何恢复。因为账套被删除了，备份文件自动被删除

sukingmoo

又是KISALLONE作者火鸟惹得祸，用数据恢复软件试试吧，别哭啊

荷塘月色

请问是使用YT-88的加密狗还是与金蝶正版同样的加密锁，如果是域天88的加密狗我会恢复

吾爱

看了楼主发的图片，觉得很奇怪，你自己不是发了次  金蝶KIS商贸版 专业版 KISAllInOne数据恢复成功，
求金蝶KIS专业版 KISAllInOne数据恢复SQL语句  这些文章吗？？？？？？？？

莫甲文

带了加密卡,这情况不晓得是不是中了马,表示同情

qq178218241

哈哈。这个我刚刚碰到。刚把客户数据恢复。 写个语句就OK了


这个是代码：
use ais20130111103157

select * from t_usercc
select * from t_userm
select * from t_userd

select * from t_VoucherEntry

SET IDENTITY_INSERT T_CC_StockBillEntry ON

insert T_CC_StockBillEntry
(FEntryID,FID,FIndex,FItemID,FBarCode,FAuxPropID,FBatchNo,FDCStockID,FSCStockID,FUnitID,FQty,FSecUnitID,FSecCoefficient,FSecQty,FPrice,FAmount,FDiscountRate,FPriceDiscount,FDiscountAmount,FTaxRate,FTaxPrice,FTaxAmount,FInTaxAmount,FCostPrice,FCostAmount,FKFDate,FKFPeriod,FPeriodDate,FOrderQty,FSettleQty,FSettleAuxQty,FRejectQty,FRejectAuxQty,FProfitLossQty,FProfitLossSecQty,FUnSettleQty,FUnSettleAuxQty,FUnRejectQty,FUnRejectAuxQty,FAccountQty,FAccountSecQty,FBeforePrice,FBeforeAmount,FRefAmount,FAdjustRate,FRate,FOrderBillNo,FBillNo_Order,FID_SRC,FEntryID_SRC,FBillNo_SRC,FClassID_SRC,FBillUserText1,FBillUserText2,FBillUserText3,FUserDefine1,FUserDefine2,FUserDefine3,FNote,FSecPrice,FDate_SRC,FAfterPrice,FAfterAmount,FBatchNoIndex,FNetAmount,FShowQty,FShowUnitID,FCoefficient,FClientItemID,FUserFormula1,FUserFormula2,FUserFormula3,FNoDiscAmount)
(select*from t_usercc)



insert t_VoucherEntry(FBrNo,FVoucherID,FEntryID,FExplanation,FAccountID,FDetailID,FCurrencyID,FExchangeRate,FDC,FAmountFor,FAmount,FQuantity,FMeasureUnitID,FUnitPrice,FInternalInd,FAccountID2,FSettleTypeID,FSettleNo,FTransNo,FCashFlowItem,FTaskID,FResourceID)
(select*from T_userd)

update t_VoucherEntry set
FAmountFor=FAmountFor/FAccountID,FAmount=FAmount/FAccountID



insert t_Balance
(FYear,FPeriod,FAccountID,FDetailID,FCurrencyID,FBeginBalanceFor,FDebitFor,FCreditFor,FYtdDebitFor,FYtdCreditFor,FEndBalanceFor,FBeginBalance,FDebit,FCredit,FYtdDebit,FYtdCredit,FEndBalance,FFrameWorkID)
(select * from t_userm)
SET IDENTITY_INSERT T_CC_StockBillEntry OFF



select count(FEntryID)from T_CC_StockBillEntry; select count(FEntryID)
from t_usercc
select count(FEntryID)from t_VoucherEntry; select count(FEntryID)from
T_userd
select count(FAccountID) from t_Balance; select count(FAccountID)from
t_userm

火狐1

楼上这种情神很好哇。。。。。。。。。。。。。。。。。。。。。。。。。。。。。

colour250

又是KISALLONE作者火鸟惹得祸，用数据恢复软件试试吧，别哭啊

xjvy

7楼的，问一下，那个语句怎么用。本人菜鸟一枚。

kfdnnljat

7楼的，上面的语句写在哪儿 ，真的可以实现吗