bos过磅导出.sql

这是一个基于金蝶K/3的磅秤插件源代码。安装本差价需要金蝶K/310.0以上的版本。本插件是客户端程序。在车辆过磅时自动产生金蝶K/3的出库单。

GO
INSERT INTO t_ObjectType(FObjectType,FObjectID,FName,FDescription,FName_cht,FName_en,FDescription_cht,FDescription_en) 
VALUES (4100,200000001,'成品车辆出厂登记单',NULL,'單據200000001','Doc200000001',NULL,NULL) 
GO

/****** Object:Data   单据权限表：t_ObjectAccess    Script Date: 2006-07-17 ******/

Delete t_ObjectAccess WHERE FObjectType=4100 And FObjectID =200000001
GO
INSERT INTO t_ObjectAccess(FGroupID,FObjectType,FObjectID,FIndex) 
VALUES (2101,4100,200000001,0) 
GO

INSERT INTO t_ObjectAccess(FGroupID,FObjectType,FObjectID,FIndex) 
VALUES (2101,4100,200000001,1) 
GO

INSERT INTO t_ObjectAccess(FGroupID,FObjectType,FObjectID,FIndex) 
VALUES (2102,4100,200000001,0) 
GO

INSERT INTO t_ObjectAccess(FGroupID,FObjectType,FObjectID,FIndex) 
VALUES (2102,4100,200000001,1) 
GO

INSERT INTO t_ObjectAccess(FGroupID,FObjectType,FObjectID,FIndex) 
VALUES (2102,4100,200000001,2) 
GO

INSERT INTO t_ObjectAccess(FGroupID,FObjectType,FObjectID,FIndex) 
VALUES (2102,4100,200000001,3) 
GO

INSERT INTO t_ObjectAccess(FGroupID,FObjectType,FObjectID,FIndex) 
VALUES (2102,4100,200000001,4) 
GO

INSERT INTO t_ObjectAccess(FGroupID,FObjectType,FObjectID,FIndex) 
VALUES (2102,4100,200000001,5) 
GO

INSERT INTO t_ObjectAccess(FGroupID,FObjectType,FObjectID,FIndex) 
VALUES (2102,4100,200000001,6) 
GO

INSERT INTO t_ObjectAccess(FGroupID,FObjectType,FObjectID,FIndex) 
VALUES (2102,4100,200000001,7) 
GO

/****** Object:Data   选单关联：ICClassLink    Script Date: 2006-07-17 ******/

Delete ICClassLink WHERE FDestClassTypeID=200000001
GO
INSERT INTO ICClassLink(FSourClassTypeID,FDestClassTypeID,FSourBillShowIndex,FAllowCopy,FAllowCheck,FAllowForceCheck,FFlowControl,FDeCondition,FCondition,FDeHCondition,FDeBCondition,FSourBillFID,FSourBillFEntryID,FSourBillFBillNo,FObjectName,FObjectType,FObjectID,FIsUsed,FUsePage,FDefaultPage,FSRCIDKey,FSRCEntryIDKey,FSRCBillNoKey,FSRCClassIDKey,FISUserDefine,FDestTranTypeID,FSourTranTypeID,FSelectListID,FMustSelected,FSystemReserved,FROB,FFieldName,FRemark,FUseSpec,FSrcDestPage,FSrcPage) 
VALUES (200000000,200000001,0,0,0,1,0,NULL,NULL,NULL,NULL,'FID','FEntryID2','FBillNo',NULL,0,0,2,',1,2,',',1,2,','FID_SRC','FEntryID_SRC','FBillNo_SRC','FClassID_SRC',1,0,0,0,1,0,0,'','',-1,0,0) 
GO

/****** Object:Data   选单关联明细：ICClassLinkEntry    Script Date: 2006-07-17 ******/

Delete ICClassLinkEntry WHERE FDestClassTypeID=200000001
GO
INSERT INTO ICClassLinkEntry(FSourClassTypeID,FDestClassTypeID,FSourPage,FSourFKey,FDestPage,FDestFKey,FIsCheck,FIsGroup,FIsFilter,FDoAction,FAllowModified,FCheckStatCol,FHaveCheckCol,FISUserDefine,FControl,FRedNeg,FBeforeFormula,FAfterFormula) 
VALUES (200000000,200000001,2,'FChePaiHao',2,'FChePaiHao',0,0,0,0,0,NULL,NULL,1,0,0,'','') 
GO

INSERT INTO ICClassLinkEntry(FSourClassTypeID,FDestClassTypeID,FSourPage,FSourFKey,FDestPage,FDestFKey,FIsCheck,FIsGroup,FIsFilter,FDoAction,FAllowModified,FCheckStatCol,FHaveCheckCol,FISUserDefine,FControl,FRedNeg,FBeforeFormula,FAfterFormula) 
VALUES (200000000,200000001,2,'FJingChangShiJian',2,'FJingChangShiJian',0,0,0,0,0,NULL,NULL,1,0,0,'','') 
GO

INSERT INTO ICClassLinkEntry(FSourClassTypeID,FDestClassTypeID,FSourPage,FSourFKey,FDestPage,FDestFKey,FIsCheck,FIsGroup,FIsFilter,FDoAction,FAllowModified,FCheckStatCol,FHaveCheckCol,FISUserDefine,FControl,FRedNeg,FBeforeFormula,FAfterFormula) 
VALUES (200000000,200000001,2,'FKeHu',2,'FKeHu',0,0,0,0,0,NULL,NULL,1,0,0,'','') 
GO

INSERT INTO ICClassLinkEntry(FSourClassTypeID,FDestClassTypeID,FSourPage,FSourFKey,FDestPage,FDestFKey,FIsCheck,FIsGroup,FIsFilter,FDoAction,FAllowModified,FCheckStatCol,FHaveCheckCol,FISUserDefine,FControl,FRedNeg,FBeforeFormula,FAfterFormula) 
VALUES (200000000,200000001,2,'FPiZhong',2,'FPiZhong',1,0,0,0,0,NULL,NULL,1,0,0,'','') 
GO

/****** Object:Data   选单钩稽明细：ICClassLinkCommit    Script Date: 2006-07-17 ******/

 DELETE ICClassLinkCommit WHERE FDstClsTypID = 200000001
GO
INSERT INTO ICClassLinkCommit(FSrcClsTypID,FDstClsTypID,FControl,FCheckKey,FCommitKey,FFlagKey,FIsUsrDef,FIsLimit,FControlFormula,FFlagFormula) 
VALUES (200000000,200000001,1,'FPiZhong','FPiZhongGouJi','FGuanBi',0,1,'','') 
GO

/****** Object:Data   选单关联明细：ICClassMutex    Script Date: 2006-07-17 ******/

Delete ICClassMutex WHERE FClassTypeID=200000001
GO
/****** Object:Data   多级审核配置模板数据：ICClassMCFlowInfo    Script Date: 2006-07-17 ******/

DELETE ICClassMCFlowInfo WHERE FID = 200000001
GO
/****** Object:Data   多级审核的工作流任务（各审核级次）模板数据：ICClassMCTasks    Script Date: 2006-07-17 ******/

DELETE ICClassMCTasks WHERE FID = 200000001
GO
/****** Object:Data   多级审核的流程流转和规则模板数据：ICClassMCRule    Script Date: 2006-07-17 ******/

DELETE ICClassMCRule WHERE FID = 200000001
GO
/****** Object:Data   单据操作明细模板数据：ICClassBillAction    Script Date: 2006-07-17 ******/

DELETE ICClassBillAction WHERE FClassTypeID = 200000001
GO