wsh5485/SQL
Archived
1
0
Fork 0
Code Issues Pull Requests Actions Packages Projects Releases Wiki Activity
This repository has been archived on 2026-06-20. You can view files and clone it. You cannot open issues or pull requests or push a commit.
Files
main
SQL/E3单据标志位清空【整合脚本】.sql
T
wsh5485 9688eb58a5 上传文件至 /
2025-01-14 01:53:00 +08:00

491 lines
36 KiB
Transact-SQL
Raw Permalink Blame History

This file contains ambiguous Unicode characters
This file contains Unicode characters that might be confused with other characters. If you think that this is intentional, you can safely ignore this warning. Use the Escape button to reveal them.
----------------------建表-------------------------------
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<dateadd(mm,1,qudao_a.lastyj+''-01'')))
insert into #tmp_bzwqk(dj_mcdh,dj_info) values('''+@dj_mc+'：'+@dj_djbh+''',''该单据日期已月结'')
else if '''+@dj_table+'''=''spjhd'' or '''+@dj_table+'''=''spthd''
begin
if exists(select 1 from jhjsd where ydjh='''+@dj_djbh+''')
insert into #tmp_bzwqk(dj_mcdh,dj_info) values('''+@dj_mc+'：'+@dj_djbh+''',''该单据存在相应结算单'')
end
else if '''+@dj_table+'''=''sdphd'' or '''+@dj_table+'''=''sdthd'' or '''+@dj_table+'''=''pfxhd'' or '''+@dj_table+'''=''pfthd'' or '''+@dj_table+'''=''lsxhd'' or '''+@dj_table+'''=''lsthd''
begin
if exists(select 1 from xhjsd where ydjh='''+@dj_djbh+''')
insert into #tmp_bzwqk(dj_mcdh,dj_info) values('''+@dj_mc+'：'+@dj_djbh+''',''该单据存在相应结算单'')
end
else if '''+@dj_table+'''=''ckpdd''
begin
if exists(select 1 from ckpdd where djbh='''+@dj_djbh+''' and isnull(js,''0'')=1)
insert into #tmp_bzwqk(dj_mcdh,dj_info) values('''+@dj_mc+'：'+@dj_djbh+''',''该单据已被盈亏'')
end
----进货
else if '''+@dj_table+'''=''jorder''
begin
if exists(select 1 from jsend where isnull(lxdj,'''')='''+@dj_djbh+''' )
insert into #tmp_bzwqk(dj_mcdh,dj_info) values('''+@dj_mc+'：'+@dj_djbh+''',''该订单存在下游单据'')
end
else if '''+@dj_table+'''=''jsend''
begin
if exists(select 1 from spjhd where isnull(byzd3,'''')='''+@dj_djbh+''' )
insert into #tmp_bzwqk(dj_mcdh,dj_info) values('''+@dj_mc+'：'+@dj_djbh+''',''该通知单存在下游单据'')
end
else if '''+@dj_table+'''=''jtsqd''
begin
if exists(select 1 from jtsnd where isnull(lxdj,'''')='''+@dj_djbh+''' )
insert into #tmp_bzwqk(dj_mcdh,dj_info) values('''+@dj_mc+'：'+@dj_djbh+''',''该申请单存在下游单据'')
end
else if '''+@dj_table+'''=''jtsnd''
begin
if exists(select 1 from spthd where isnull(byzd3,'''')='''+@dj_djbh+''' )
insert into #tmp_bzwqk(dj_mcdh,dj_info) values('''+@dj_mc+'：'+@dj_djbh+''',''该通知单存在下游单据'')
end
----配货
else if '''+@dj_table+'''=''phjrd''
begin
if exists(select 1 from psend where isnull(lxdj,'''')='''+@dj_djbh+''' )
insert into #tmp_bzwqk(dj_mcdh,dj_info) values('''+@dj_mc+'：'+@dj_djbh+''',''该订单存在下游单据'')
end
else if '''+@dj_table+'''=''psend''
begin
if exists(select 1 from sdphd where isnull(byzd3,'''')='''+@dj_djbh+''' )
insert into #tmp_bzwqk(dj_mcdh,dj_info) values('''+@dj_mc+'：'+@dj_djbh+''',''该通知单存在下游单据'')
end
else if '''+@dj_table+'''=''ptsqd''
begin
if exists(select 1 from ptsnd where isnull(lxdj,'''')='''+@dj_djbh+''' )
insert into #tmp_bzwqk(dj_mcdh,dj_info) values('''+@dj_mc+'：'+@dj_djbh+''',''该申请单存在下游单据'')
end
else if '''+@dj_table+'''=''ptsnd''
begin
if exists(select 1 from sdthd where isnull(byzd3,'''')='''+@dj_djbh+''' )
insert into #tmp_bzwqk(dj_mcdh,dj_info) values('''+@dj_mc+'：'+@dj_djbh+''',''该通知单存在下游单据'')
end
----批发
else if '''+@dj_table+'''=''pfjrd''
begin
if exists(select 1 from fsend where isnull(lxdj,'''')='''+@dj_djbh+''' )
insert into #tmp_bzwqk(dj_mcdh,dj_info) values('''+@dj_mc+'：'+@dj_djbh+''',''该订单存在下游单据'')
end
else if '''+@dj_table+'''=''fsend''
begin
if exists(select 1 from pfxhd where isnull(byzd3,'''')='''+@dj_djbh+''' )
insert into #tmp_bzwqk(dj_mcdh,dj_info) values('''+@dj_mc+'：'+@dj_djbh+''',''该通知单存在下游单据'')
end
else if '''+@dj_table+'''=''ftsqd''
begin
if exists(select 1 from ftsnd where isnull(lxdj,'''')='''+@dj_djbh+''' )
insert into #tmp_bzwqk(dj_mcdh,dj_info) values('''+@dj_mc+'：'+@dj_djbh+''',''该申请单存在下游单据'')
end
else if '''+@dj_table+'''=''ftsnd''
begin
if exists(select 1 from pfthd where isnull(byzd3,'''')='''+@dj_djbh+''' )
insert into #tmp_bzwqk(dj_mcdh,dj_info) values('''+@dj_mc+'：'+@dj_djbh+''',''该通知单存在下游单据'')
end
----调拨
else if '''+@dj_table+'''=''dbjrd''
begin
if exists(select 1 from dsend where isnull(lxdj,'''')='''+@dj_djbh+''' )
insert into #tmp_bzwqk(dj_mcdh,dj_info) values('''+@dj_mc+'：'+@dj_djbh+''',''该订单存在下游单据'')
end
else if '''+@dj_table+'''=''dsend''
begin
if exists(select 1 from qddbd where isnull(byzd3,'''')='''+@dj_djbh+''' )
insert into #tmp_bzwqk(dj_mcdh,dj_info) values('''+@dj_mc+'：'+@dj_djbh+''',''该通知单存在下游单据'')
end
else if '''+@dj_table+'''=''dtsqd''
begin
if exists(select 1 from dtsnd where isnull(lxdj,'''')='''+@dj_djbh+''' )
insert into #tmp_bzwqk(dj_mcdh,dj_info) values('''+@dj_mc+'：'+@dj_djbh+''',''该申请单存在下游单据'')
end
else if '''+@dj_table+'''=''dtsnd''
begin
if exists(select 1 from qdthd where isnull(byzd3,'''')='''+@dj_djbh+''' )
insert into #tmp_bzwqk(dj_mcdh,dj_info) values('''+@dj_mc+'：'+@dj_djbh+''',''该通知单存在下游单据'')
end
end
'
print(@sql)
exec(@sql)
fetch next from cur_bzwqk into @dj_table,@dj_djbh,@bj_1,@bj_2,@bj_3,@bj_4,@bj_5,@bj_6,@bj_all
END
CLOSE cur_bzwqk
DEALLOCATE cur_bzwqk
if exists(select 1 from #tmp_bzwqk)
select dj_mcdh as '单据信息',dj_info as '错误信息' from #tmp_bzwqk
else
select 0
drop table #tmp_bzwqk
end
go
------------------------------------------缓存模型-----------------------------------------------------
/*==============================【Begin】===============================*/
/*=========【缓存：单据类型缓存】=========*/
DELETE BS_SYS_Cache WHERE FMID='fb8a9233-9125-4197-8669-cf7e220de1ec'
go
INSERT INTO BS_SYS_Cache (FMID,FCACHENAME,FSQL_EXECUTE,FKEYFIELD,FVIEWNAME,AUTOTIME,FDBID,NOTOC)
VALUES ('fb8a9233-9125-4197-8669-cf7e220de1ec','dxBS_GET_DJLX','SELECT MC,XSMC FROM DJSET','MC','单据类型缓存',0,'{D03E4B5D-ACA0-4772-82C2-C74B1B2E596F}','1')
----------
/*==============================【End】=================================*/
go
----------------------------------------------控件模型---------------------------------------------------
/*==============================【Begin】===============================*/
/*=========【控件模型：单据类型获取XJ】=========*/
DELETE BS_SYS_CONTROLS WHERE FMID='e483c2fe-cf12-414e-8e7b-46ec4027f202'
INSERT INTO BS_SYS_CONTROLS (FMID,FNAME,FSTATE,FSOURCE,FCACHE,FEXESQL,FBILL)
VALUES ('e483c2fe-cf12-414e-8e7b-46ec4027f202','单据类型获取XJ',0,0,'dxMAIN','SELECT MC,XSMC FROM DJSET ','')
----------
/*=========【字段配置】=========*/
DELETE BS_SYS_CONTROLFIELDS WHERE FMID='026A369C-5CC6-4138-8F81-1AF59D88A3C7'
INSERT INTO BS_SYS_CONTROLFIELDS (FMID,FPID,FFIELDNAME,FDEFAULTNAME,FDISPLYNAME,FEDITORDER,FEDITTYPE,SIZE_W,FISVIEW)
VALUES ('026A369C-5CC6-4138-8F81-1AF59D88A3C7','e483c2fe-cf12-414e-8e7b-46ec4027f202','MC','代码','代码',1,0,100,'1')
----------
DELETE BS_SYS_CONTROLFIELDS WHERE FMID='DE7EFF98-8B7F-4EB3-B097-08FE1FCC9B03'
INSERT INTO BS_SYS_CONTROLFIELDS (FMID,FPID,FFIELDNAME,FDEFAULTNAME,FDISPLYNAME,FEDITORDER,FEDITTYPE,SIZE_W,FISVIEW)
VALUES ('DE7EFF98-8B7F-4EB3-B097-08FE1FCC9B03','e483c2fe-cf12-414e-8e7b-46ec4027f202','XSMC','名称','名称',2,0,100,'1')
----------
/*==============================【End】=================================*/
go
------------------------------------------数据模型-------------------------------------------------------------
/*==============================【Begin】===============================*/
/*=========【类别：单据标志位清空】=========*/
DELETE BS_SYS_SQLBUILDER WHERE FMID='e0f6cad9-44cd-4eef-bf62-164e2f70128e'
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 ('e0f6cad9-44cd-4eef-bf62-164e2f70128e','-1','BZWQK','单据标志位清空',NULL,NULL,'2024-02-19 17:44:39','2024-02-19 17:44:18',NULL,'ADMIN',NULL,0,NULL,'','',NULL,NULL,-1,0,0,0,0,0,0,0,0,'基本信息','','','','','','','','','','','','','',0,'',3,60,NULL,NULL,'','','','','')
----------
/*=========【模型：单据标志位清空】=========*/
DELETE BS_SYS_SQLBUILDER WHERE FMID='3f330533-c916-4085-aa1d-c8e85313ba27'
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 ('3f330533-c916-4085-aa1d-c8e85313ba27','e0f6cad9-44cd-4eef-bf62-164e2f70128e','BZWQK01','单据标志位清空',NULL,NULL,'2024-02-19 17:46:33','2024-02-19 17:45:03',NULL,'ADMIN',NULL,1,NULL,'','',NULL,NULL,1,0,0,0,0,0,0,0,0,'基本信息','附件信息','','','单据明细','','','','','','','','','',0,'',3,60,NULL,NULL,'','','','','')
----------
/*=========【主表：单据标志位清空主表】=========*/
DELETE BS_SYS_SQLBUILDER WHERE FMID='54d8fa23-b0d1-4ed2-9e75-8913e14bbf3c'
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 ('54d8fa23-b0d1-4ed2-9e75-8913e14bbf3c','3f330533-c916-4085-aa1d-c8e85313ba27','BZWQK0101','单据标志位清空主表',NULL,NULL,'2024-02-20 17:34:26','2024-02-19 17:47:45',NULL,'ADMIN',NULL,2,'{D03E4B5D-ACA0-4772-82C2-C74B1B2E596F}','DJ_BZWQK','SELECT DJBH,RQ,KCWH,ZDR,RQ_4,JZ,JZRQ,JZR,BZ FROM DJ_BZWQK',NULL,NULL,1,0,0,0,0,0,0,0,0,'基本信息','附件信息','','','单据明细','','','','','','','','','',0,'DJBH',3,60,NULL,NULL,'BZWQK','','','','')
----------
/*=========【字段配置】=========*/
DELETE BS_SYS_SQLBUILDERFIELDS WHERE FPID='54d8fa23-b0d1-4ed2-9e75-8913e14bbf3c' 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 ('f07f7914-5ea2-47b7-81fa-439cb6d0ebce','54d8fa23-b0d1-4ed2-9e75-8913e14bbf3c','DJBH',0,50,'单据编号','单据编号',0,'DJBH','1',110,30,180,23,'1','0','1',1,0,'1','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='54d8fa23-b0d1-4ed2-9e75-8913e14bbf3c' AND FFIELDNAME='RQ'
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 ('7b851932-2f13-4699-9fa4-8364ce34e57c','54d8fa23-b0d1-4ed2-9e75-8913e14bbf3c','RQ',3,23,'日期','日期',3,'date','1',400,30,180,23,'0','1','1',2,0,'1','1',100,2,'0',0,'0','503ccb71-d62e-4ec5-b6e7-efb858c10813','0','0',0,'0','0','0','0','0',NULL)
----------
DELETE BS_SYS_SQLBUILDERFIELDS WHERE FPID='54d8fa23-b0d1-4ed2-9e75-8913e14bbf3c' AND FFIELDNAME='ZDR'
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 ('1ac24b46-9c91-4bd3-9b63-540ad4e3d00a','54d8fa23-b0d1-4ed2-9e75-8913e14bbf3c','ZDR',0,20,'制单人','制单人',0,'username','0',110,60,180,23,'0','0','1',3,1,'0','1',100,3,'0',0,'0','0000d587-26c7-4ec0-968f-6f53573ad2be','0','0',0,'0','0','0','0','0',NULL)
----------
DELETE BS_SYS_SQLBUILDERFIELDS WHERE FPID='54d8fa23-b0d1-4ed2-9e75-8913e14bbf3c' AND FFIELDNAME='KCWH'
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 ('3339c14d-749a-4288-96de-5b72f013627c','54d8fa23-b0d1-4ed2-9e75-8913e14bbf3c','KCWH',0,1,'库存维护','库存维护',2,'1','0',690,30,180,23,'0','1','1',3,0,'0','1',100,3,'0',0,'0','0000d587-26c7-4ec0-968f-6f53573ad2be','0','0',0,'0','0','0','0','0',NULL)
----------
DELETE BS_SYS_SQLBUILDERFIELDS WHERE FPID='54d8fa23-b0d1-4ed2-9e75-8913e14bbf3c' AND FFIELDNAME='RQ_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 ('da078e93-6d3c-4111-9301-94a60b17279f','54d8fa23-b0d1-4ed2-9e75-8913e14bbf3c','RQ_4',3,23,'制单日期','制单日期',3,'date','0',400,60,180,23,'0','0','1',4,1,'0','1',100,4,'0',0,'0','503ccb71-d62e-4ec5-b6e7-efb858c10813','0','0',0,'0','0','0','0','0',NULL)
----------
DELETE BS_SYS_SQLBUILDERFIELDS WHERE FPID='54d8fa23-b0d1-4ed2-9e75-8913e14bbf3c' AND FFIELDNAME='JZ'
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 ('70f0ea21-05ac-4012-92d0-d9619f5ba623','54d8fa23-b0d1-4ed2-9e75-8913e14bbf3c','JZ',0,1,'审批','审批',2,'0','0',690,60,180,23,'0','0','1',5,1,'1','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='54d8fa23-b0d1-4ed2-9e75-8913e14bbf3c' AND FFIELDNAME='JZRQ'
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 ('11fbdd90-c424-4808-bdbf-b7528f8329ec','54d8fa23-b0d1-4ed2-9e75-8913e14bbf3c','JZRQ',3,23,'审批日期','审批日期',3,'','0',110,90,180,23,'0','0','1',6,1,'0','1',100,6,'0',0,'0','503ccb71-d62e-4ec5-b6e7-efb858c10813','0','0',0,'0','0','0','0','0',NULL)
----------
DELETE BS_SYS_SQLBUILDERFIELDS WHERE FPID='54d8fa23-b0d1-4ed2-9e75-8913e14bbf3c' AND FFIELDNAME='JZR'
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 ('b6adeaf5-83ea-4645-8c3e-5d79da2476cc','54d8fa23-b0d1-4ed2-9e75-8913e14bbf3c','JZR',0,20,'审批人','审批人',0,'','0',400,90,180,23,'0','0','1',7,1,'1','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='54d8fa23-b0d1-4ed2-9e75-8913e14bbf3c' 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 ('1521a972-70fd-4255-a2a6-8be1bffd9201','54d8fa23-b0d1-4ed2-9e75-8913e14bbf3c','BZ',0,500,'备注','备注',0,'','0',690,90,180,23,'0','1','1',8,0,'0','1',100,8,'0',0,'0','0000d587-26c7-4ec0-968f-6f53573ad2be','0','0',0,'0','0','0','0','0',NULL)
----------
/*=========【节点事件】=========*/
DELETE BS_SYS_TOOLACTIONS WHERE FMID='cb3e466d-8bae-4952-a033-f000e6add371'
INSERT INTO BS_SYS_TOOLACTIONS (FMID,FPID,FJDCODE,FJDNAME,FJDWZ,FJDICO,FISVIEW,FJDTYPE,FJDVALUE,FJDSTATE,FMETHODNAME,FJDDEPICT,FQJDTYPE,FQJDVALUE,FQMETHODNAME,FHJDTYPE,FHJDVALUE,FHMETHODNAME,FJKJDVALUE,FITEMNAME,ISBATCH,FMODEL,FREFRESHMX)
VALUES ('cb3e466d-8bae-4952-a033-f000e6add371','54d8fa23-b0d1-4ed2-9e75-8913e14bbf3c','JzOpt','审批',1,'审批.png','1','1','P_DJ_BZWQK_JZOpt @TABLENAME,@DJBH,@ZDR,@RQ,''JZ''','[JZ<>''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
Reference in New Issue View Git Blame Copy Permalink