新增文章

文章标题 分类 C# 云星空 K3 BOS K3 功能 用友 Oracle python SQL MySql PHP HTML script windows Access 影视后期 财务 服务 生活 内容 ------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -- 用户配置：单据体设置 SELECT * FROM t_User WHERE FName LIKE '%郭少锋%' SELECT * FROM t_UserProfile WHERE FUserID =16398 SELECT * FROM ICUserTemplateEntry WHERE FUserID =16398 AND FTemplateID = 'S01' /* DELETE FROM ICUserTemplateEntry WHERE FTemplateID = 'S01' AND FUserID = 16399 -- 删除 单据体设置：销售订单 */ ------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -- 用户配置：过滤方案 SELECT * FROM ICSchemeProfile WHERE FUserID = 16398 AND FTranType = 32 -- 销售订单 SELECT * FROM ICSchemeProfileEntry WHERE FSchemeID IN ( 1,2 ) /* DELETE FROM ICSchemeProfile WHERE FSchemeID IN ( 1,2 ) -- 删除 过滤方案 DELETE FROM ICSchemeProfileEntry WHERE FSchemeID IN ( 1,2 ) -- 删除 过滤方案 */ 返回 保存