----------------------建表------------------------------- If exists (select 1 from sysobjects where name='DJ_BZWQK' and xtype='u') drop table DJ_BZWQK go CREATE TABLE DJ_BZWQK ( [DJBH] [VARCHAR](50) NOT NULL PRIMARY KEY, [RQ] [DATETIME] , KCWH CHAR(1), [ZDR] [VARCHAR](20) , [RQ_4] [DATETIME] , [JZ] [CHAR](1), [JZRQ] [DATETIME] , [JZR] [VARCHAR](20), [BZ] [VARCHAR](500) ) go IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[DJ_BZWQKMX]') AND type in (N'U')) DROP TABLE [dbo].[DJ_BZWQKMX] GO CREATE TABLE [dbo].[DJ_BZWQKMX]( [DJBH] [varchar](50) NOT NULL, [MXBH] [int] IDENTITY(1,1) NOT NULL, DJLX varchar(20), DJH VARCHAR(50), BJ_1 CHAR(1), BJ_2 CHAR(1), BJ_3 CHAR(1), BJ_4 CHAR(1), BJ_5 CHAR(1), BJ_6 CHAR(1), BJ_ALL CHAR(1), BZ varchar(500) CONSTRAINT [PK_DJ_BZWQKMX] PRIMARY KEY NONCLUSTERED ( [DJBH] ASC, [MXBH] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY] GO ----------------------------------单据审批节点------------------------------------------- IF EXISTS (SELECT 1 FROM SYSOBJECTS WHERE NAME='P_DJ_BZWQK_JZOpt') DROP PROCEDURE [dbo].[P_DJ_BZWQK_JZOpt] GO CREATE PROC [dbo].[P_DJ_BZWQK_JZOpt] @TABLENAME VARCHAR(30), @KEYID VARCHAR(50), @USER VARCHAR(20), @QD VARCHAR(20), @Opt char(2) AS DECLARE @Errs INT , @sql varchar(8000), @dj_table varchar(20),--单据表名 @dj_djbh varchar(50), --单据编号 @ck_info varchar(100), @sp_info varchar(100), @bj_1 char(1), @bj_2 char(1), @bj_3 char(1), @bj_4 char(1), @bj_5 char(1), @bj_6 char(1), @bj_all char(1), @kcwh char(1), @set varchar(500) BEGIN TRAN SET @Errs=0 set @set='' set @sql='update '+@TABLENAME +' set '+@Opt+'=1 ,'+@Opt+'R='''+@USER+''','+@Opt+'RQ='''+@qd+''' where djbh='''+@KEYID+'''' print(@sql) exec (@sql) SET @Errs=@Errs+@@ERROR select @kcwh = kcwh from DJ_BZWQK where djbh=@KEYID declare cur_bzwqk_opt cursor for select djlx,djh,bj_1,bj_2,bj_3,bj_4,bj_5,bj_6,bj_all from DJ_BZWQKMX where djbh=@KEYID open cur_bzwqk_opt fetch next from cur_bzwqk_opt into @dj_table,@dj_djbh,@bj_1,@bj_2,@bj_3,@bj_4,@bj_5,@bj_6,@bj_all while @@FETCH_STATUS=0 BEGIN if @bj_all='1' set @set=', ys=0, sh=0, jz=0, js=0, sp=0, zs=0 ' else begin IF @bj_1='1' SET @set=@set+' , ys=0 ' IF @bj_2 ='1' SET @set=@set+' , sh=0 ' IF @bj_3='1' SET @set=@set+' , jz=0 ' IF @bj_4='1' SET @set=@set+' , js=0 ' IF @bj_5='1' SET @set=@set+' , sp=0 ' IF @bj_6='1' SET @set=@set+' , zs=0 ' end SET @set=SUBSTRING(@set,CHARINDEX(',',@set)+1,len(@set)-CHARINDEX(',',@set)) set @sql='update '+@dj_table+' set '+@set+' where djbh='''+@dj_djbh+'''' print(@sql) exec(@sql) --库存维护 if @kcwh='1' begin if @dj_table in ('jhjrd','jsend','spjhd','jtsqd','jtsnd','spthd','phjrd','psend','sdphd','ptsqd','ptsnd', 'sdthd','pfjrd','fsend','pfxhd','ftsqd','ftsnd','pfthd','spycd','lsxhd','lsthd','cktzd','dbjrd','dsend','qddbd','dtsqd','dtsnd','qdthd') begin set @ck_info = 'cangku.ckdm in (select dm1 from '+@dj_table+' union all select dm2 from '+@dj_table+' )' set @sp_info = 'shangpin.spdm in (select spdm from '+@dj_table+'mx where djbh='''+@dj_djbh+''')' EXEC p_SpkcWh_SP_ERP @ck_info,@sp_info,'0' end end fetch next from cur_bzwqk_opt into @dj_table,@dj_djbh,@bj_1,@bj_2,@bj_3,@bj_4,@bj_5,@bj_6,@bj_all END CLOSE cur_bzwqk_opt DEALLOCATE cur_bzwqk_opt SET @Errs=@Errs+@@ERROR --应收维护 EXEC p_KHYSWh_ERP 9,'' --应付维护 EXEC p_ghsyfwh 9,'' if @Errs=0 BEGIN COMMIT TRAN SELECT 1 END ELSE BEGIN ROLLBACK TRAN SELECT 0 END RETURN GO ---------------------------单据前方法节点---------------------------------------- if exists(select 1 from dbo.sysobjects where id = object_id(N'[dbo].[P_DJ_BZWQK_QFF]') and OBJECTPROPERTY(id,N'IsProcedure') = 1) drop procedure [dbo].[P_DJ_BZWQK_QFF] GO CREATE proc [dbo].[P_DJ_BZWQK_QFF] @TABLENAME varchar(20), @DJBH varchar(20), @USER varchar(50), @QUDAO varchar(20) as declare @sql varchar(8000), @dj_table varchar(20),--单据表名 @dj_mc varchar(20), --单据名称 @dj_djbh varchar(50), --单据编号 @bj_1 char(1), @bj_2 char(1), @bj_3 char(1), @bj_4 char(1), @bj_5 char(1), @bj_6 char(1), @bj_all char(1) create table #tmp_bzwqk (dj_mcdh varchar(100),--单据信息 dj_info varchar(200)) --提示信息 begin declare cur_bzwqk cursor for select djlx,djh,bj_1,bj_2,bj_3,bj_4,bj_5,bj_6,bj_all from DJ_BZWQKMX where djbh=@DJBH open cur_bzwqk fetch next from cur_bzwqk into @dj_table,@dj_djbh,@bj_1,@bj_2,@bj_3,@bj_4,@bj_5,@bj_6,@bj_all while @@FETCH_STATUS=0 BEGIN select @dj_mc = xsmc from djset where mc=@dj_table set @sql=' if '''+@bj_1+'''=''0'' and '''+@bj_2+'''=''0'' and '''+@bj_3+'''=''0'' and '''+@bj_4+'''=''0'' and '''+@bj_5+'''=''0'' and '''+@bj_6+'''=''0'' and '''+@bj_all+'''=''0'' insert into #tmp_bzwqk(dj_mcdh,dj_info) values('''+@dj_mc+'：'+@dj_djbh+''',''请至少选择一项标志位'') else begin if not exists(select 1 from '+@dj_table+' where djbh='''+@dj_djbh+''') insert into #tmp_bzwqk(dj_mcdh,dj_info) values('''+@dj_mc+'：'+@dj_djbh+''',''无对应单据'') ---月结 else if exists(select 1 from '+@dj_table+' dj where dj.djbh='''+@dj_djbh+''' and exists(select 1 from qudao_a where dj.qddm=qudao_a.qddm and dj.rq''1''],[View]','5A65AE91-60F3-4557-8448-9765764F617E',NULL,'1','P_DJ_BZWQK_QFF','5A65AE91-60F3-4557-8448-9765764F617E','0',NULL,'5A65AE91-60F3-4557-8448-9765764F617E',NULL,NULL,'1',NULL,'0') ---------- /*=========【明细表：单据标志位清空明细表】=========*/ DELETE BS_SYS_SQLBUILDER WHERE FMID='e3f4de63-5583-499e-b3f7-1e6b3d5bd3a9' INSERT INTO BS_SYS_SQLBUILDER (FMID,FPID,FCODE,FNAME,FPCODE,FSTATE,FUPDATETIME,FCREATETIME,FOPERATORID,FOPERATOR,FVERSION,FINDEX,FDBID,FTABLENAME,FSQL_SELECT,FSQL_EXECUTE,FREMARK,DJLX,CYInformation,RKMX,PMSR,ZXQD,PMRKMX,PJSR,KZMX,PLXG,FTABMAIN1,FTABMAIN2,FTABMAIN3,FTABMAIN4,FTABMX1,FTABMX2,FTABMX3,FTABMX4,FTABMX5,FTABMX6,FTABMX7,FTABMX8,FTABMX9,FTABMX10,FMXCONTROL,FKEYFIELDS,FCOLUMN,FLABELLEN,FDLLNAME,FCLASSNAME,FTAG,FBHCODE,FPIPNAME,SYDJFMID,XYDJFMID) VALUES ('e3f4de63-5583-499e-b3f7-1e6b3d5bd3a9','3f330533-c916-4085-aa1d-c8e85313ba27','BZWQK0102','单据标志位清空明细表',NULL,NULL,'2024-02-20 17:16:04','2024-02-19 18:05:57',NULL,'ADMIN',NULL,3,'{D03E4B5D-ACA0-4772-82C2-C74B1B2E596F}','DJ_BZWQKMX','SELECT DJBH,MXBH,DJLX,DJH,BJ_1,BJ_2,BJ_3,BJ_4,BJ_5,BJ_6,BJ_ALL,BZ FROM DJ_BZWQKMX',NULL,NULL,1,0,0,0,0,0,0,0,0,'基本信息','附件信息','','','单据明细','','','','','','','','','',1,'DJBH',3,60,NULL,NULL,'','','','','') ---------- /*=========【字段配置】=========*/ DELETE BS_SYS_SQLBUILDERFIELDS WHERE FPID='e3f4de63-5583-499e-b3f7-1e6b3d5bd3a9' AND FFIELDNAME='DJBH' INSERT INTO BS_SYS_SQLBUILDERFIELDS (FMID,FPID,FFIELDNAME,FFIELDTYPE,FFIELDLENGTH,FDEFAULTNAME,FDISPLYNAME,FEDITTYPE,FDEFAULT,FNEED,LOCATION_X,LOCATION_Y,SIZE_W,SIZE_H,FPKFLD,FISEDIT,FISVIEW,FEDITORDER,FLAYOUT,FISFIND,FISGRIDVIEW,GRIDVIEWSIZE_W,FGRIDVIEWORDER,FACTION,FACTIONTYPE,FISAMOUNT,FFORMAT,FISLOCK,FISKZ,FFINDTYPE,FISSHOWTREE,FISSUPERIOR,FISLAST,FISSAVESUPERIOR,FISEXPANDVIEW,FXML) VALUES ('b342f422-4c42-4f9b-bfc3-3f66c645f671','e3f4de63-5583-499e-b3f7-1e6b3d5bd3a9','DJBH',0,50,'单据编号','单据编号',0,'DJBH','0',110,30,180,23,'1','0','0',1,4,'0','1',100,1,'0',0,'0','0000d587-26c7-4ec0-968f-6f53573ad2be','0','0',0,'0','0','0','0','0',NULL) ---------- DELETE BS_SYS_SQLBUILDERFIELDS WHERE FPID='e3f4de63-5583-499e-b3f7-1e6b3d5bd3a9' AND FFIELDNAME='MXBH' INSERT INTO BS_SYS_SQLBUILDERFIELDS (FMID,FPID,FFIELDNAME,FFIELDTYPE,FFIELDLENGTH,FDEFAULTNAME,FDISPLYNAME,FEDITTYPE,FDEFAULT,FNEED,LOCATION_X,LOCATION_Y,SIZE_W,SIZE_H,FPKFLD,FISEDIT,FISVIEW,FEDITORDER,FLAYOUT,FISFIND,FISGRIDVIEW,GRIDVIEWSIZE_W,FGRIDVIEWORDER,FACTION,FACTIONTYPE,FISAMOUNT,FFORMAT,FISLOCK,FISKZ,FFINDTYPE,FISSHOWTREE,FISSUPERIOR,FISLAST,FISSAVESUPERIOR,FISEXPANDVIEW,FXML) VALUES ('94a464e2-06b5-46af-8b30-8d7d4d8479cd','e3f4de63-5583-499e-b3f7-1e6b3d5bd3a9','MXBH',1,10,'MXBH','MXBH',0,'MXBH','0',400,30,180,23,'1','0','0',2,4,'0','1',100,2,'0',0,'0','0000d587-26c7-4ec0-968f-6f53573ad2be','0','0',0,'0','0','0','0','0',NULL) ---------- DELETE BS_SYS_SQLBUILDERFIELDS WHERE FPID='e3f4de63-5583-499e-b3f7-1e6b3d5bd3a9' AND FFIELDNAME='DJLX' INSERT INTO BS_SYS_SQLBUILDERFIELDS (FMID,FPID,FFIELDNAME,FFIELDTYPE,FFIELDLENGTH,FDEFAULTNAME,FDISPLYNAME,FEDITTYPE,FDEFAULT,FNEED,LOCATION_X,LOCATION_Y,SIZE_W,SIZE_H,FPKFLD,FISEDIT,FISVIEW,FEDITORDER,FLAYOUT,FISFIND,FISGRIDVIEW,GRIDVIEWSIZE_W,FGRIDVIEWORDER,FACTION,FACTIONTYPE,FISAMOUNT,FFORMAT,FISLOCK,FISKZ,FFINDTYPE,FISSHOWTREE,FISSUPERIOR,FISLAST,FISSAVESUPERIOR,FISEXPANDVIEW,FXML) VALUES ('f57cf706-646c-444f-9bf4-23f0e07e5a40','e3f4de63-5583-499e-b3f7-1e6b3d5bd3a9','DJLX',0,20,'单据类型','单据类型',1,'','1',690,30,180,23,'1','1','1',3,4,'1','1',100,3,'e483c2fe-cf12-414e-8e7b-46ec4027f202',0,'0','0000d587-26c7-4ec0-968f-6f53573ad2be','0','0',0,'0','0','0','0','0',NULL) ---------- DELETE BS_SYS_SQLBUILDERFIELDS WHERE FPID='e3f4de63-5583-499e-b3f7-1e6b3d5bd3a9' AND FFIELDNAME='DJH' INSERT INTO BS_SYS_SQLBUILDERFIELDS (FMID,FPID,FFIELDNAME,FFIELDTYPE,FFIELDLENGTH,FDEFAULTNAME,FDISPLYNAME,FEDITTYPE,FDEFAULT,FNEED,LOCATION_X,LOCATION_Y,SIZE_W,SIZE_H,FPKFLD,FISEDIT,FISVIEW,FEDITORDER,FLAYOUT,FISFIND,FISGRIDVIEW,GRIDVIEWSIZE_W,FGRIDVIEWORDER,FACTION,FACTIONTYPE,FISAMOUNT,FFORMAT,FISLOCK,FISKZ,FFINDTYPE,FISSHOWTREE,FISSUPERIOR,FISLAST,FISSAVESUPERIOR,FISEXPANDVIEW,FXML) VALUES ('f61e35ec-228c-4344-9e7f-9c04f86f3adb','e3f4de63-5583-499e-b3f7-1e6b3d5bd3a9','DJH',0,50,'单据号','单据号',0,'','1',110,60,180,23,'1','1','1',4,4,'1','1',100,4,'0',0,'0','0000d587-26c7-4ec0-968f-6f53573ad2be','0','0',0,'0','0','0','0','0',NULL) ---------- DELETE BS_SYS_SQLBUILDERFIELDS WHERE FPID='e3f4de63-5583-499e-b3f7-1e6b3d5bd3a9' AND FFIELDNAME='BJ_1' INSERT INTO BS_SYS_SQLBUILDERFIELDS (FMID,FPID,FFIELDNAME,FFIELDTYPE,FFIELDLENGTH,FDEFAULTNAME,FDISPLYNAME,FEDITTYPE,FDEFAULT,FNEED,LOCATION_X,LOCATION_Y,SIZE_W,SIZE_H,FPKFLD,FISEDIT,FISVIEW,FEDITORDER,FLAYOUT,FISFIND,FISGRIDVIEW,GRIDVIEWSIZE_W,FGRIDVIEWORDER,FACTION,FACTIONTYPE,FISAMOUNT,FFORMAT,FISLOCK,FISKZ,FFINDTYPE,FISSHOWTREE,FISSUPERIOR,FISLAST,FISSAVESUPERIOR,FISEXPANDVIEW,FXML) VALUES ('325602da-ef86-49db-ae53-3ae5ccae8d33','e3f4de63-5583-499e-b3f7-1e6b3d5bd3a9','BJ_1',0,1,'发出/验收','发出/验收',2,'0','0',400,60,180,23,'0','1','1',5,4,'0','1',100,5,'0',0,'0','0000d587-26c7-4ec0-968f-6f53573ad2be','0','0',0,'0','0','0','0','0',NULL) ---------- DELETE BS_SYS_SQLBUILDERFIELDS WHERE FPID='e3f4de63-5583-499e-b3f7-1e6b3d5bd3a9' AND FFIELDNAME='BJ_2' INSERT INTO BS_SYS_SQLBUILDERFIELDS (FMID,FPID,FFIELDNAME,FFIELDTYPE,FFIELDLENGTH,FDEFAULTNAME,FDISPLYNAME,FEDITTYPE,FDEFAULT,FNEED,LOCATION_X,LOCATION_Y,SIZE_W,SIZE_H,FPKFLD,FISEDIT,FISVIEW,FEDITORDER,FLAYOUT,FISFIND,FISGRIDVIEW,GRIDVIEWSIZE_W,FGRIDVIEWORDER,FACTION,FACTIONTYPE,FISAMOUNT,FFORMAT,FISLOCK,FISKZ,FFINDTYPE,FISSHOWTREE,FISSUPERIOR,FISLAST,FISSAVESUPERIOR,FISEXPANDVIEW,FXML) VALUES ('587b9352-961b-4b81-93e6-5d1c1cc133e3','e3f4de63-5583-499e-b3f7-1e6b3d5bd3a9','BJ_2',0,1,'入库','入库',2,'0','0',690,60,180,23,'0','1','1',6,4,'0','1',100,6,'0',0,'0','0000d587-26c7-4ec0-968f-6f53573ad2be','0','0',0,'0','0','0','0','0',NULL) ---------- DELETE BS_SYS_SQLBUILDERFIELDS WHERE FPID='e3f4de63-5583-499e-b3f7-1e6b3d5bd3a9' AND FFIELDNAME='BJ_3' INSERT INTO BS_SYS_SQLBUILDERFIELDS (FMID,FPID,FFIELDNAME,FFIELDTYPE,FFIELDLENGTH,FDEFAULTNAME,FDISPLYNAME,FEDITTYPE,FDEFAULT,FNEED,LOCATION_X,LOCATION_Y,SIZE_W,SIZE_H,FPKFLD,FISEDIT,FISVIEW,FEDITORDER,FLAYOUT,FISFIND,FISGRIDVIEW,GRIDVIEWSIZE_W,FGRIDVIEWORDER,FACTION,FACTIONTYPE,FISAMOUNT,FFORMAT,FISLOCK,FISKZ,FFINDTYPE,FISSHOWTREE,FISSUPERIOR,FISLAST,FISSAVESUPERIOR,FISEXPANDVIEW,FXML) VALUES ('4142db1d-6f7a-4179-bb66-6e0b8a924169','e3f4de63-5583-499e-b3f7-1e6b3d5bd3a9','BJ_3',0,1,'审核/记账','审核/记账',2,'0','0',110,90,180,23,'0','1','1',7,4,'0','1',100,7,'0',0,'0','0000d587-26c7-4ec0-968f-6f53573ad2be','0','0',0,'0','0','0','0','0',NULL) ---------- DELETE BS_SYS_SQLBUILDERFIELDS WHERE FPID='e3f4de63-5583-499e-b3f7-1e6b3d5bd3a9' AND FFIELDNAME='BJ_4' INSERT INTO BS_SYS_SQLBUILDERFIELDS (FMID,FPID,FFIELDNAME,FFIELDTYPE,FFIELDLENGTH,FDEFAULTNAME,FDISPLYNAME,FEDITTYPE,FDEFAULT,FNEED,LOCATION_X,LOCATION_Y,SIZE_W,SIZE_H,FPKFLD,FISEDIT,FISVIEW,FEDITORDER,FLAYOUT,FISFIND,FISGRIDVIEW,GRIDVIEWSIZE_W,FGRIDVIEWORDER,FACTION,FACTIONTYPE,FISAMOUNT,FFORMAT,FISLOCK,FISKZ,FFINDTYPE,FISSHOWTREE,FISSUPERIOR,FISLAST,FISSAVESUPERIOR,FISEXPANDVIEW,FXML) VALUES ('2e43359c-6125-4dec-bf59-4420f43212ec','e3f4de63-5583-499e-b3f7-1e6b3d5bd3a9','BJ_4',0,1,'执行/结算','执行/结算',2,'0','0',400,90,180,23,'0','1','1',8,4,'0','1',100,8,'0',0,'0','0000d587-26c7-4ec0-968f-6f53573ad2be','0','0',0,'0','0','0','0','0',NULL) ---------- DELETE BS_SYS_SQLBUILDERFIELDS WHERE FPID='e3f4de63-5583-499e-b3f7-1e6b3d5bd3a9' AND FFIELDNAME='BJ_5' INSERT INTO BS_SYS_SQLBUILDERFIELDS (FMID,FPID,FFIELDNAME,FFIELDTYPE,FFIELDLENGTH,FDEFAULTNAME,FDISPLYNAME,FEDITTYPE,FDEFAULT,FNEED,LOCATION_X,LOCATION_Y,SIZE_W,SIZE_H,FPKFLD,FISEDIT,FISVIEW,FEDITORDER,FLAYOUT,FISFIND,FISGRIDVIEW,GRIDVIEWSIZE_W,FGRIDVIEWORDER,FACTION,FACTIONTYPE,FISAMOUNT,FFORMAT,FISLOCK,FISKZ,FFINDTYPE,FISSHOWTREE,FISSUPERIOR,FISLAST,FISSAVESUPERIOR,FISEXPANDVIEW,FXML) VALUES ('a1bafe65-de13-4462-b732-ea19a354ca2b','e3f4de63-5583-499e-b3f7-1e6b3d5bd3a9','BJ_5',0,1,'终止','终止',2,'0','0',690,90,180,23,'0','1','1',9,4,'0','1',100,9,'0',0,'0','0000d587-26c7-4ec0-968f-6f53573ad2be','0','0',0,'0','0','0','0','0',NULL) ---------- DELETE BS_SYS_SQLBUILDERFIELDS WHERE FPID='e3f4de63-5583-499e-b3f7-1e6b3d5bd3a9' AND FFIELDNAME='BJ_6' INSERT INTO BS_SYS_SQLBUILDERFIELDS (FMID,FPID,FFIELDNAME,FFIELDTYPE,FFIELDLENGTH,FDEFAULTNAME,FDISPLYNAME,FEDITTYPE,FDEFAULT,FNEED,LOCATION_X,LOCATION_Y,SIZE_W,SIZE_H,FPKFLD,FISEDIT,FISVIEW,FEDITORDER,FLAYOUT,FISFIND,FISGRIDVIEW,GRIDVIEWSIZE_W,FGRIDVIEWORDER,FACTION,FACTIONTYPE,FISAMOUNT,FFORMAT,FISLOCK,FISKZ,FFINDTYPE,FISSHOWTREE,FISSUPERIOR,FISLAST,FISSAVESUPERIOR,FISEXPANDVIEW,FXML) VALUES ('d7baccb8-c973-4435-98d5-8fe05de8ec49','e3f4de63-5583-499e-b3f7-1e6b3d5bd3a9','BJ_6',0,1,'终审','终审',2,'0','0',110,120,180,23,'0','1','1',10,4,'0','1',100,10,'0',0,'0','0000d587-26c7-4ec0-968f-6f53573ad2be','0','0',0,'0','0','0','0','0',NULL) ---------- DELETE BS_SYS_SQLBUILDERFIELDS WHERE FPID='e3f4de63-5583-499e-b3f7-1e6b3d5bd3a9' AND FFIELDNAME='BJ_ALL' INSERT INTO BS_SYS_SQLBUILDERFIELDS (FMID,FPID,FFIELDNAME,FFIELDTYPE,FFIELDLENGTH,FDEFAULTNAME,FDISPLYNAME,FEDITTYPE,FDEFAULT,FNEED,LOCATION_X,LOCATION_Y,SIZE_W,SIZE_H,FPKFLD,FISEDIT,FISVIEW,FEDITORDER,FLAYOUT,FISFIND,FISGRIDVIEW,GRIDVIEWSIZE_W,FGRIDVIEWORDER,FACTION,FACTIONTYPE,FISAMOUNT,FFORMAT,FISLOCK,FISKZ,FFINDTYPE,FISSHOWTREE,FISSUPERIOR,FISLAST,FISSAVESUPERIOR,FISEXPANDVIEW,FXML) VALUES ('b169cc54-3d35-4b31-854c-b06f54ead982','e3f4de63-5583-499e-b3f7-1e6b3d5bd3a9','BJ_ALL',0,1,'全清','全清',2,'0','0',400,120,180,23,'0','1','1',11,4,'0','1',100,10,'0',0,'0','0000d587-26c7-4ec0-968f-6f53573ad2be','0','0',0,'0','0','0','0','0',NULL) ---------- DELETE BS_SYS_SQLBUILDERFIELDS WHERE FPID='e3f4de63-5583-499e-b3f7-1e6b3d5bd3a9' AND FFIELDNAME='BZ' INSERT INTO BS_SYS_SQLBUILDERFIELDS (FMID,FPID,FFIELDNAME,FFIELDTYPE,FFIELDLENGTH,FDEFAULTNAME,FDISPLYNAME,FEDITTYPE,FDEFAULT,FNEED,LOCATION_X,LOCATION_Y,SIZE_W,SIZE_H,FPKFLD,FISEDIT,FISVIEW,FEDITORDER,FLAYOUT,FISFIND,FISGRIDVIEW,GRIDVIEWSIZE_W,FGRIDVIEWORDER,FACTION,FACTIONTYPE,FISAMOUNT,FFORMAT,FISLOCK,FISKZ,FFINDTYPE,FISSHOWTREE,FISSUPERIOR,FISLAST,FISSAVESUPERIOR,FISEXPANDVIEW,FXML) VALUES ('800dee83-0db3-4296-843f-9cc5909c07cf','e3f4de63-5583-499e-b3f7-1e6b3d5bd3a9','BZ',0,500,'备注','备注',0,'','0',690,120,180,23,'0','1','1',12,4,'0','1',100,11,'0',0,'0','0000d587-26c7-4ec0-968f-6f53573ad2be','0','0',0,'0','0','0','0','0',NULL) ---------- /*=========【扩展字段】=========*/ DELETE BS_SYS_SQLBUILDERFIELDS_KZ WHERE FMID='cbee595d-ade8-4836-a0c4-45938061bf81' INSERT INTO BS_SYS_SQLBUILDERFIELDS_KZ (FMID,FPID,KCODE,KNAME,KTYPE,KISVIEW,KLOOKUPBILL,KLOOKUPKEYFIELD,KLOOKUPRESULDFIELD,KKEYFIELD,KWZ,KZ_FLAYOUT,KFORMAT,KCALCULCATE) VALUES ('cbee595d-ade8-4836-a0c4-45938061bf81','e3f4de63-5583-499e-b3f7-1e6b3d5bd3a9','DJMC','单据名称',0,'1','dxBS_GET_DJLX','MC','XSMC','DJLX',1,4,'0000d587-26c7-4ec0-968f-6f53573ad2be',NULL) ---------- /*==============================【End】=================================*/ go ----------------------------------------功能菜单---------------------------------------------------------------- /*==============================【Begin】===============================*/ /*=========【目录：单据标志位清空】=========*/ DELETE BS_SYS_Funcs WHERE FMID='3a57dc7a-dcd3-40c3-9bc8-9d0b6dde3897' INSERT INTO BS_SYS_Funcs (FMID,FPID,FuncName,DLLName,ClassName,FuncNo,FuncType,SortOrder,InitParams,TblName,FuncModule,FModuleID,FuncRun,BZ,FuncMode) VALUES ('3a57dc7a-dcd3-40c3-9bc8-9d0b6dde3897','-1','单据标志位清空',NULL,NULL,NULL,0,999999,NULL,NULL,NULL,NULL,'show',NULL,NULL) ---------- /*=========【功能：单据标志位清空】=========*/ DELETE BS_SYS_Funcs WHERE FMID='d1b0f87c-3327-4b94-92ea-02cf58b30d3d' INSERT INTO BS_SYS_Funcs (FMID,FPID,FuncName,DLLName,ClassName,FuncNo,FuncType,SortOrder,InitParams,TblName,FuncModule,FModuleID,FuncRun,BZ,FuncMode) VALUES ('d1b0f87c-3327-4b94-92ea-02cf58b30d3d','3a57dc7a-dcd3-40c3-9bc8-9d0b6dde3897','单据标志位清空','BaisonClient.BaseModule.DLL','BaisonClient.BaseModule.frmWNBILL',NULL,1,1,NULL,NULL,'10080','3f330533-c916-4085-aa1d-c8e85313ba27','show',NULL,NULL) ---------- /*==============================【End】=================================*/ go