kisallinone数据恢复分享贴

hp惠普硕放店

我用了kis10专业版，用的是kisallinone2.6，昨天开始新建账套，从4月份做到12月底账一共是130多账凭证，今天突然跳出kisallinone 数据损坏，要恢复联系qqxxxxxxx。账套任然能进，但是凭证内容均变成了空白，科目余额表和报表均是空白。
后再网上找到方法，成功恢复账套，不敢独享，贴出来给需要的人。

恢复KISAllInOne破坏的数据方法



--本语句用来恢复金蝶破解版删除的数据 ,需按要求一步一步操作


--第一步,设置允许特殊更新
exec sp_configure 'allow updates',1
reconfigure with override


--第二步,设置存货分录表为非标识
update syscolumns set colstat = 0 where id = object_id('t_cc_stockbillentry') and colstat = 1


--第三步,恢复各表数据
insert into t_cc_stockbillentry   select * from  t_usercc   --恢复存货分录表 即进货销售的明细项
insert into t_voucherentry   select * from  t_userd         --恢复凭证分录表
insert into t_balance  select * from  t_userm               --恢复科目余额表


update t_cc_stockbillentry set fqty=fqty/fitemid            --修正汇总数量
update t_voucherentry set famountfor=famountfor/faccountid,famount=famount/faccountid  --修正凭证金额




--第四步,恢复设置存货分录表为标识
update syscolumns set colstat = 1 where id = object_id('t_cc_stockbillentry') and name = 'fentryid'


--第五步,恢复设置不允许特殊更新
exec sp_configure 'allow updates',0
reconfigure with override

这是原帖地址   http://hi.baidu.com/tips1127/item/890fc2ee0c9630236cabb86e

it100200

顶楼主一个，顶楼主一个，
本文来自:阳光网驿_企业信息化专家 详细出处请参考：http://bbs.sunwy.org/forum.php?m ... 6orderby%3Ddateline顶楼主一个，
本文来自:阳光网驿_企业信息化专家 详细出处请参考：http://bbs.sunwy.org/forum.php?m ... 6orderby%3Ddateline

动物凶猛

看不懂，但要顶起来让需要的人看到。

colour250

没有遇到这些问题，一直在用标准版8.1 ，几年了，挺好的

情归何处

这些不是之前有人贴过出来了吗？

5  专业V12.0、V12.1
以下代码仅用于“金 KIS 专业版V12.0、V12.1”的账套：
SET IDENTITY_INSERT ICStockBillEntry ON
/**还原出入库单据**/
insert ICStockBillEntry
(FBrNo,FInterID,FEntryID,FItemID,FQtyMust,FQty,FPrice,FBatchNo,FAmount,FNote,FSCBillInterID,FSCBillNo,FUnitID,FAuxPrice,
FAuxQty,FAuxQtyMust,FQtyActual,FAuxQtyActual,FPlanPrice,FAuxPlanPrice,FSourceEntryID,FCommitQty,FAuxCommitQty,FKFDate,FKFPeriod,FDCSPID,FSCSPID,FConsignPrice,FConsignAmount,FProcessCost,FMaterialCost,FTaxAmount,FMapNumber,FMapName,FOrgBillEntryID,FOperID,FPlanAmount,FProcessPrice,FTaxRate,FSnListID,FAmtRef,FAuxPropID,FCost,FPriceRef,FAuxPriceRef,FFetchDate,FQtyInvoice,FQtyInvoiceBase,FUnitCost,FSecCoefficient,FSecQty,FSecCommitQty,FSourceTranType,FSourceInterId,FSourceBillNo,FContractInterID,FContractEntryID,FContractBillNo,FICMOBillNo,FICMOInterID,FPPBomEntryID,FOrderInterID,FOrderEntryID,FOrderBillNo,FAllHookQTY,FAllHookAmount,FCurrentHookQTY,FCurrentHookAmount,FStdAllHookAmount,FStdCurrentHookAmount,FSCStockID,FDCStockID,FPeriodDate,FCostObjGroupID,FCostOBJID,FDetailID,FMaterialCostPrice,FReProduceType,FBomInterID,FDiscountRate,FDiscountAmount,FSepcialSaleId,FOutCommitQty,FOutSecCommitQty,FDBCommitQty,FDBSecCommitQty,FAuxQtyInvoice,FOperSN,FCheckStatus,FSplitSecQty,FDVStockID,FHookInterID,FHookStatus,FAFBillNO,FMOInterID,FMOEntryID,FMOBillNo)
select * from t_usercc
/**修正出入库单据上的数量**/
update ICStockBillEntry set fqty=fshowqty
/**还原会计凭证**/
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 ICStockBillEntry OFF

hp惠普硕放店

我这个是用在kis10.0专业版上的，成功恢复了，所以贴出来和大家分享一下