上传点k3wise数据库语句，留个纪念！

--清空账套管理密码

use KDacctDB

update t_users set FPassword ='' where fname='admin'

--清楚用户缓存

delete from t_userprofile  where fuserid in (select fuserid from t_user where fname like 'administrator')

--异常用户清理

delete from t_UserProfile where 

FCategory='FlowChart_POS' and FKey='LastPos'

and FUserID in(select fuserid from t_user where FName='用户名')

--网上报销隐藏差旅费和出差申请单

update t_dataflowDetailfunc set FShowSysType=0 where fsubfuncid=26202

update t_dataflowDetailfunc set FShowSysType=0 where fsubfuncid=26204

update t_DataFlowSubFunc set FShowSysType=0  where FSubFuncID=26202 

update t_DataFlowSubFunc set FShowSysType=0  where FSubFuncID=26204 

update t_DataFlowTimeStamp set fname=fname

--应收款明细表未设置变量

delete t_userprofile where fuserid =(select fuserid from t_user where fname='administrator');

delete t_LedgerPageSetup where fuserid =(select fuserid from t_user where fname='administrator');

delete icreportprofile where fuserid =(select fuserid from t_user where fname='administrator');

上传个k3wise常用数据库表，目前只会查找、更新

SELECT * FROM ICClassType WHERE FName_CHS LIKE '%供货%' --用此表基本上可以查询到所有的表

--隐藏我的消息广告

UPDATE t_SystemProfile SET FValue='none' where FCategory='BASE' AND FKey='MessageURL'

---固定资产卡片已经删除领用单无法驳回

select * from CIP_AssetsApplication where FBillNo in ('ZCLY-20200617-0000002')

select FFAQty,FFAAmount,FFATaxAmt,* from CIP_AssetsApplicationEntry whe