新增文章

文章标题 分类 C# 云星空 K3 BOS K3 功能 用友 Oracle python SQL MySql PHP HTML script windows Access 影视后期 财务 服务 生活 内容 SELECT * FROM ICClassWorkFlow WHERE FID = 1001 SELECT * FROM ICClassWorkFlowBill WHERE FID = 1001 SELECT * FROM ICClassWorkFlowJoin WHERE FID = 1001 set implicit_transactions on DELETE ICClassWorkFlow WHERE FID = 1001 INSERT ICClassWorkFlow ( FID, FName_CHS, FName_CHT,FName_EN, FSubSysID ) VALUES ( 1001, '销售流程图', '销售流程图', '销售流程图', 23 ) DELETE ICClassWorkFlowBill WHERE FID = 1001 INSERT ICClassWorkFlowBill (FID, FClassTypeID, FTop, FLeft, FWidth, FHeight, FTypeID ) VALUES ( 1001, -81, 1500, 1500, 2500, 2000, 0 ) ; INSERT ICClassWorkFlowBill (FID, FClassTypeID, FTop, FLeft, FWidth, FHeight, FTypeID ) VALUES ( 1001, -21, 1500, 6000, 2500, 2000, 0 ) ; INSERT ICClassWorkFlowBill (FID, FClassTypeID, FTop, FLeft, FWidth, FHeight, FTypeID ) VALUES ( 1001, -21, 5000, 1500, 2500, 2000, 1 ) ; INSERT ICClassWorkFlowBill (FID, FClassTypeID, FTop, FLeft, FWidth, FHeight, FTypeID ) VALUES ( 1001, -21, 5000, 6000, 2500, 2000, -1 ) ; DELETE ICClassWorkFlowJoin WHERE FID = 1001 INSERT ICClassWorkFlowJoin (FID, FSourClassTypeID, FDestClassTypeID, FSourTypeID, FDestTypeID ) VALUES ( 1001, -81, -21, 0, 0 ) ; INSERT ICClassWorkFlowJoin (FID, FSourClassTypeID, FDestClassTypeID, FSourTypeID, FDestTypeID ) VALUES ( 1001, -21, -21, 1, -1 ) ; UPDATE ICClassType SET FID = FID IF @@TRANCOUNT > 0 COMMIT TRAN set implicit_transactions off 返回 保存