bos过磅导出.sql

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

DECLARE @MaxID AS INT

SELECT @MaxID = ISNUll(Max(FID),10000) FROM ICClassBillAction

INSERT INTO ICClassBillAction(FID,FClassTypeID,FCode,FName_CHS,FName_CHT,FName_EN,FDescriptions_CHS,FDescriptions_CHT,FDescriptions_EN,FEnvironment,FRightMask,FRightUseMask,FRightGroupMask,FRightControl,FAddLog,FIsPredefine,FIsFirst,FShortCut,FIcon,FIconFile) 
VALUES ( @MaxID + 1,200000001,'mnuEditCopy','复制','複製','Copy','复制','複製','Copy',39,131072,0,7,1,0,1,0,0,NULL,'') 

INSERT INTO ICClassBillAction(FID,FClassTypeID,FCode,FName_CHS,FName_CHT,FName_EN,FDescriptions_CHS,FDescriptions_CHT,FDescriptions_EN,FEnvironment,FRightMask,FRightUseMask,FRightGroupMask,FRightControl,FAddLog,FIsPredefine,FIsFirst,FShortCut,FIcon,FIconFile) 
VALUES ( @MaxID + 2,200000001,'mnuEditCopyDoc','按单复制','按單複製','Copy by Doc','按单复制','按單複製','Copy by Doc',64,131072,0,7,1,0,1,0,0,NULL,'') 

INSERT INTO ICClassBillAction(FID,FClassTypeID,FCode,FName_CHS,FName_CHT,FName_EN,FDescriptions_CHS,FDescriptions_CHT,FDescriptions_EN,FEnvironment,FRightMask,FRightUseMask,FRightGroupMask,FRightControl,FAddLog,FIsPredefine,FIsFirst,FShortCut,FIcon,FIconFile) 
VALUES ( @MaxID + 3,200000001,'mnuEditCopyEntry','按分录合并复制','按分錄合併複製','Consolidation & Copy by Entry','按分录合并复制','按分錄合併複製','Consolidation & Copy by Entry',64,131072,0,7,1,0,1,0,0,NULL,'') 

INSERT INTO ICClassBillAction(FID,FClassTypeID,FCode,FName_CHS,FName_CHT,FName_EN,FDescriptions_CHS,FDescriptions_CHT,FDescriptions_EN,FEnvironment,FRightMask,FRightUseMask,FRightGroupMask,FRightControl,FAddLog,FIsPredefine,FIsFirst,FShortCut,FIcon,FIconFile) 
VALUES ( @MaxID + 4,200000001,'mnuEditDelete','删除','刪除','Del.','删除','刪除','Del.',64,65536,0,7,1,1,1,0,0,NULL,'') 

INSERT INTO ICClassBillAction(FID,FClassTypeID,FCode,FName_CHS,FName_CHT,FName_EN,FDescriptions_CHS,FDescriptions_CHT,FDescriptions_EN,FEnvironment,FRightMask,FRightUseMask,FRightGroupMask,FRightControl,FAddLog,FIsPredefine,FIsFirst,FShortCut,FIcon,FIconFile) 
VALUES ( @MaxID + 5,200000001,'mnuEditModify','修改','修改','Edit','修改','修改','Edit',4160,4194304,0,7,1,0,1,0,0,NULL,'') 

INSERT INTO ICClassBillAction(FID,FClassTypeID,FCode,FName_CHS,FName_CHT,FName_EN,FDescriptions_CHS,FDescriptions_CHT,FDescriptions_EN,FEnvironment,FRightMask,FRightUseMask,FRightGroupMask,FRightControl,FAddLog,FIsPredefine,FIsFirst,FShortCut,FIcon,FIconFile) 
VALUES ( @MaxID + 6,200000001,'mnuExportData','引出内部数据','引出內部資料','Exp Internal Data','引出内部数据','引出內部資料','Exp Internal Data',5056,16,0,7,1,0,1,0,0,NULL,'') 

INSERT INTO ICClassBillAction(FID,FClassTypeID,FCode,FName_CHS,FName_CHT,FName_EN,FDescriptions_CHS,FDescriptions_CHT,FDescriptions_EN,FEnvironment,FRightMask,FRightUseMask,FRightGroupMask,FRightControl,FAddLog,FIsPredefine,FIsFirst,FShortCut,FIcon,FIconFile) 
VALUES ( @MaxID + 7,200000001,'mnuFileNew','新增','新增','New','新增','新增','New',103,131072,0,7,1,0,1,0,0,NULL,'') 

INSERT INTO ICClassBillAction(FID,FClassTypeID,FCode,FName_CHS,FName_CHT,FName_EN,FDescriptions_CHS,FDescriptions_CHT,FDescriptions_EN,FEnvironment,FRightMask,FRightUseMask,FRightGroupMask,FRightControl,FAddLog,FIsPredefine,FIsFirst,FShortCut,FIcon,FIconFile) 
VALUES ( @MaxID + 8,200000001,'mnuFilePrint','打印','列印','Print','打印','列印','Print',5095,32768,0,7,1,0,1,0,0,NULL,'') 

INSERT INTO ICClassBillAction(FID,FClassTypeID,FCode,FName_CHS,FName_CHT,FName_EN,FDescriptions_CHS,FDescriptions_CHT,FDescriptions_EN,FEnvironment,FRightMask,FRightUseMask,FRightGroupMask,FRightControl,FAddLog,FIsPredefine,FIsFirst,FShortCut,FIcon,FIconFile) 
VALUES ( @MaxID + 9,200000001,'mnuFileSave','保存','保存','Save','保存','保存','Save',6,0,0,7,0,1,1,0,0,NULL,'') 

INSERT INTO ICClassBillAction(FID,FClassTypeID,FCode,FName_CHS,FName_CHT,FName_EN,FDescriptions_CHS,FDescriptions_CHT,FDescriptions_EN,FEnvironment,FRightMask,FRightUseMask,FRightGroupMask,FRightControl,FAddLog,FIsPredefine,FIsFirst,FShortCut,FIcon,FIconFile) 
VALUES ( @MaxID + 10,200000001,'mnuFileView','查看','查看','View','查看','查看','View',960,2097152,0,7,1,0,1,0,0,NULL,'') 


UPDATE ICMaxNum SET FMaxNum = @MaxID + 11 WHERE FTableName = 'ICClassBillAction'
GO




/**End  新单据模板数据脚本，名称 成品车辆出厂登记单    Script Date: 2006-07-17 **/


/**Begin 新单据模板数据脚本，名称 成品车辆进厂登记单    Script Date: 2006-07-17 **/


/****** Object:Data   单据描述：ICClassType    Script Date: 2006-07-17 ******/

Delete ICClassType WHERE FID=200000000
GO
INSERT INTO ICClassType(FID,FName_CHS,FName_CHT,FName_EN,FShowIndex,FTableName,FShowType,FTemplateID,FImgID,FModel,FLogic,FBillWidth,FBillHeight,FMenuControl,FFunctionID,FFilter,FBillTypeID,FIsManageBillNo,FBillNoKey,FEntryCount,FLayerCount,FLayerNames,FPrimaryKey,FEPrimaryKey,FClassTypeKey,FIndexKey,FObjectType,FObjectID,FGroupIDView,FGroupIDManage,FComponentExt,FBillNoManageType,FAccessoryTypeID,FControl,FTimeStamp,FExtBaseDataAccess) 
VALUES (200000000,'成品车辆进厂登记单','單據200000000','Doc200000000',0,'t_NHG_CheLiangJingChang',0,200000000,'',2,3,6750,4725,'',8000,'',3,0,'',0,1,'CHS=;CHT=;EN=','FID','FEntryID','FClassTypeID','FIndex',4100,200000000,2101,2102,'FBillevents=BOS_NHG_GBXT.clsCPGB_GPZ|FLstEvents=|FBaseLstEvents=|FBeforeSave=|FAfterSave=|FBeforeDel=|FAfterDel=|FBeforeMultiCheck=|FAfterMultiCheck=|FIsUseProc=|',1,80000001,-1,NULL,'') 
GO

/****** Object:Data   单据分录描述：ICClassTypeEntry    Script Date: 2006-07-17 ******/

Delete ICClassTypeEntry WHERE FParentID=200000000
GO
INSERT INTO ICClassTypeEntry(FIndex,FParentID,FTableName,FLeft,FTop,FWidth,FHeight,FLayer,FEntryType,FTabIndex,FMustInput,FKeyField,FDescription_CHS,FDescription_CHT,FDescription_EN,FFilter,FUserDefine) 
VALUES (1,200000000,'t_NHG_CheLiangJingChang',0,2190,4000,4740,0,0,0,1,'','','','','',1) 
GO

INSERT INTO ICClassTypeEntry(FIndex,FParentID,FTableName,FLeft,FTop,FWidth,FHeight,FLayer,FEntryType,FTabIndex,FMustInput,FKeyField,FDescription_CHS,FDescription_CHT,FDescription_EN,FFilter,FUserDefine) 
VALUES (2,200000000,'t_NHG_CheLiangJingChangEntry',225,1120,6155,3025,0,1,0,1,'','','','','',1) 
GO

/****** Object:Data   单据模板字段描述：ICClassTableInfo    Script Date: 2006-07-17 ******/

Delete ICClassTableInfo WHERE FClassTypeID=200000000
GO
INSERT INTO ICClassTableInfo(FClassTypeID,FPage,FCaption_CHS,FCaption_CHT,FCaption_EN,FKey,FFieldName,FTableName,FTableNameAs,FListIndex,FListClassName,FVisible,FEnable,FNeedSave,FMustInput,FCtlType,FProperty,FLookUpType,FLookUpClassID,FLookUpList,FSRCFieldName,FSRCTableName,FSRCTableNameAs,FDSPFieldName,FFNDFieldName,FValueLocation,FFilter,FFilterGroup,FValueType,FDspColType,FEditlen,FValuePrecision,FSaveRule,FDefValue,FAction,FUserDefine,FNote,FKeyWord,FLeft,FTop,FHeight,FWidth,FCondition,FTabIndex,FLock,FSum,FPrec,FScale,FLayer,FLoadAction,FUnControl,FFont,FSourceType,FSubKey,FParentKey,FConditionExt,FFrameBorder,FFrameBorderColor,FLabelWidth,FLabelColor,FTextColor,FIsF7) 
VALUES (200000000,1,'内码','內碼','ISN','FID','FID','t_NHG_CheLiangJingChang','',1,2,0,1,1,0,3,'',0,0,'','','','','','',1,'','',56,500,255,4,'','','',1,'','PRIMARY',240,120,405,2535,'-1',4,0,0,0,0,0,'',0,'',0,'','',0,0,0,0,0,0,0) 
GO

INSERT INTO ICClassTableInfo(FClassTypeID,FPage,FCaption_CHS,FCaption_CHT,FCaption_EN,FKey,FFieldName,FTableName,FTableNameAs,FListIndex,FListClassName,FVisible,FEnable,FNeedSave,FMustInput,FCtlType,FProperty,FLookUpType,FLookUpClassID,FLookUpList,FSRCFieldName,FSRCTableName,FSRCTableNameAs,FDSPFieldName,FFNDFieldName,FValueLocation,FFilter,FFilterGroup,FValueType,FDspColType,FEditlen,FValuePrecision,FSaveRule,FDefValue,FAction,FUserDefine,FNote,FKeyWord,FLeft,FTop,FHeight,FWidth,FCondition,FTabIndex,FLock,FSum,FPrec,FScale,FLayer,FLoadAction,FUnControl,FFont,FSourceType,FSubKey,FParentKey,FConditionExt,FFrameBorder,FFrameBorderColor,FLabelWidth,FLabelColor,FTextColor,FIsF7) 
VALUES (200000000,1,'事务类型','事務類型','Trans Type','FClassTypeID','FClassTypeID','t_NHG_CheLiangJingChang','',3,2,0,1,1,0,1,'',0,0,'','FID','ICClassType','','FName','FName',1,'','',56,500,255,4,'','','',1,'','CLASSTYPEID',240,120,405,2535,'-1',10,0,0,0,0,0,'',0,'',0,'','',0,0,0,0,0,0,0) 
GO

INSERT INTO ICClassTableInfo(FClassTypeID,FPage,FCaption_CHS,FCaption_CHT,FCaption_EN,FKey,FFieldName,FTableName,FTableNameAs,FListIndex,FListClassName,FVisible,FEnable,FNeedSave,FMustInput,FCtlType,FProperty,FLookUpType,FLookUpClassID,FLookUpList,FSRCFieldName,FSRCTableName,FSRCTableNameAs,FDSPFieldName,FFNDFieldName,FValueLocation,FFilter,FFilterGroup,FValueType,FDspColType,FEditlen,FValuePrecision,FSaveRule,FDefValue,FAction,FUserDefine,FNote,FKeyWord,FLeft,FTop,FHeight,FWidth,FCondition,FTabIndex,FLock,FSum,FPrec,FScale,FLayer,FLoadAction,FUnControl,FFont,FSourceType,FSubKey,FParentKey,FConditionExt,FFrameBorder,FFrameBorderColor,FLabelWidth,FLabelColor,FTextColor,FIsF7) 
VALUES (200000000,1,'单据编号','單據編號','Doc No.','FBillNo','FBillNo','t_NHG_CheLiangJingChang','',1,2,-1,0,1,1,1,'',0,0,'','','','','','',1,'','',167,500,30,30,'','','',1,'','BILLNO',285,825,375,2115,'0',17,0,0,0,0,0,'',0,'',3,'','',0,0,0,0,0,0,0) 
GO

INSERT INTO ICClassTableInfo(FClassTypeID,FPage,FCaption_CHS,FCaption_CHT,FCaption_EN,FKey,FFieldName,FTableName,FTableNameAs,FListIndex,FListClassName,FVisible,FEnable,FNeedSave,FMustInput,FCtlType,FProperty,FLookUpType,FLookUpClassID,FLookUpList,FSRCFieldName,FSRCTableName,FSRCTableNameAs,FDSPFieldName,FFNDFieldName,FValueLocation,FFilter,FFilterGroup,FValueType,FDspColType,FEditlen,FValuePrecision,FSaveRule,FDefValue,FAction,FUserDefine,FNote,FKeyWord,FLeft,FTop,FHeight,FWidth,FCondition,FTabIndex,FLock,FSum,FPrec,FScale,FLayer,FLoadAction,FUnControl,FFont,FSourceType,FSubKey,FParentKey,FConditionExt,FFrameBorder,FFrameBorderColor,FLabelWidth,FLabelColor,FTextColor,FIsF7) 
VALUES (200000000,1,'日期','日期','Date','FDate','FDate','t_NHG_CheLiangJingChang','',1,2,-1,0,1,0,0,'',0,0,'','','','','','',1,'','',61,0,8,8,'','','',1,'','',2865,765,480,2000,'2',18,-1,0,3,23,0,'',0,'',0,'','',0,0,0,0,0,0,0) 
GO

INSERT INTO ICClassTableInfo(FClassTypeID,FPage,FCaption_CHS,FCaption_CHT,FCaption_EN,FKey,FFieldName,FTableName,FTableNameAs,FListIndex,FListClassName,FVisible,FEnable,FNeedSave,FMustInput,FCtlType,FProperty,FLookUpType,FLookUpClassID,FLookUpList,FSRCFieldName,FSRCTableName,FSRCTableNameAs,FDSPFieldName,FFNDFieldName,FValueLocation,FFilter,FFilterGroup,FValueType,FDspColType,FEditlen,FValuePrecision,FSaveRule,FDefValue,FAction,FUserDefine,FNote,FKeyWord,FLeft,FTop,FHeight,FWidth,FCondition,FTabIndex,FLock,FSum,FPrec,FScale,FLayer,FLoadAction,FUnControl,FFont,FSourceType,FSubKey,FParentKey,FConditionExt,FFrameBorder,FFrameBorderColor,FLabelWidth,FLabelColor,FTextColor,FIsF7) 
VALUES (200000000,1,'制单人','制單人','Prep. by','FBiller','FBiller','t_NHG_CheLiangJingChang','',1,2,-1,-1,1,0,1,'',7,9,'','FUserID','t_User','','FName','FName',1,'','',56,500,255,4,'','','',1,'','USER',4395,4140,480,2000,'0,9',19,-1,0,0,6,0,'',0,'',8,'','',0,0,0,0,0,0,0) 
GO

INSERT INTO ICClassTableInfo(FClassTypeID,FPage,FCaption_CHS,FCaption_CHT,FCaption_EN,FKey,FFieldName,FTableName,FTableNameAs,FListIndex,FListClassName,FVisible,FEnable,FNeedSave,FMustInput,FCtlType,FProperty,FLookUpType,FLookUpClassID,FLookUpList,FSRCFieldName,FSRCTableName,FSRCTableNameAs,FDSPFieldName,FFNDFieldName,FValueLocation,FFilter,FFilterGroup,FValueType,FDspColType,FEditlen,FValuePrecision,FSaveRule,FDefValue,FAction,FUserDefine,FNote,FKeyWord,FLeft,FTop,FHeight,FWidth,FCondition,FTabIndex,FLock,FSum,FPrec,FScale,FLayer,FLoadAction,FUnControl,FFont,FSourceType,FSubKey,FParentKey,FConditionExt,FFrameBorder,FFrameBorderColor,FLabelWidth,FLabelColor,FTextColor,FIsF7) 
VALUES (200000000,2,'分录内码','分錄內碼','Entry ISN','FEntryID2','FEntryID','t_NHG_CheLiangJingChangEntry','',101,0,0,1,0,0,3,'',0,0,'','','','','','',1,'','',56,500,255,4,'','','',1,'','ENTRYKEY',240,120,350,1800,'-1',-1,0,0,0,0,0,'',0,'',0,'','',0,0,0,0,0,0,0) 
GO

INSERT INTO ICClassTableInfo(FClassTypeID,FPage,FCaption_CHS,FCaption_CHT,FCaption_EN,FKey,FFieldName,FTableName,FTableNameAs,FListIndex,FListClassName,FVisible,FEnable,FNeedSave,FMustInput,FCtlType,FProperty,FLookUpType,FLookUpClassID,FLookUpList,FSRCFieldName,FSRCTableName,FSRCTableNameAs,FDSPFieldName,FFNDFieldName,FValueLocation,FFilter,FFilterGroup,FValueType,FDspColType,FEditlen,FValuePrecision,FSaveRule,FDefValue,FAction,FUserDefine,FNote,FKeyWord,FLeft,FTop,FHeight,FWidth,FCondition,FTabIndex,FLock,FSum,FPrec,FScale,FLayer,FLoadAction,FUnControl,FFont,FSourceType,FSubKey,FParentKey,FConditionExt,FFrameBorder,FFrameBorderColor,FLabelWidth,FLabelColor,FTextColor,FIsF7) 
VALUES (200000000,2,'单据内码','單據內碼','Doc ISN','FID2','FID','t_NHG_CheLiangJingChangEntry','',102,0,0,1,1,1,3,'',0,0,'','','','','','',1,'','',56,500,255,4,'','','',1,'','PARENTID',240,120,350,1800,'-1',-1,0,0,0,0,0,'',0,'',0,'','',0,0,0,0,0,0,0) 
GO

INSERT INTO ICClassTableInfo(FClassTypeID,FPage,FCaption_CHS,FCaption_CHT,FCaption_EN,FKey,FFieldName,FTableName,FTableNameAs,FListIndex,FListClassName,FVisible,FEnable,FNeedSave,FMustInput,FCtlType,FProperty,FLookUpType,FLookUpClassID,FLookUpList,FSRCFieldName,FSRCTableName,FSRCTableNameAs,FDSPFieldName,FFNDFieldName,FValueLocation,FFilter,FFilterGroup,FValueType,FDspColType,FEditlen,FValuePrecision,FSaveRule,FDefValue,FAction,FUserDefine,FNote,FKeyWord,FLeft,FTop,FHeight,FWidth,FCondition,FTabIndex,FLock,FSum,FPrec,FScale,FLayer,FLoadAction,FUnControl,FFont,FSourceType,FSubKey,FParentKey,FConditionExt,FFrameBorder,FFrameBorderColor,FLabelWidth,FLabelColor,FTextColor,FIsF7) 
VALUES (200000000,2,'行号','行號','Row No.','FIndex2','FIndex','t_NHG_CheLiangJingChangEntry','',103,0,0,1,1,0,3,'',0,0,'','','','','','',1,'','',56,500,255,4,'','','',1,'','INDEX',240,120,350,1800,'-1',-1,-1,0,0,0,0,'',0,'',0,'','',0,0,0,0,0,0,0) 
GO

INSERT INTO ICClassTableInfo(FClassTypeID,FPage,FCaption_CHS,FCaption_CHT,FCaption_EN,FKey,FFieldName,FTableName,FTableNameAs,FListIndex,FListClassName,FVisible,FEnable,FNeedSave,FMustInput,FCtlType,FProperty,FLookUpType,FLookUpClassID,FLookUpList,FSRCFieldName,FSRCTableName,FSRCTableNameAs,FDSPFieldName,FFNDFieldName,FValueLocation,FFilter,FFilterGroup,FValueType,FDspColType,FEditlen,FValuePrecision,FSaveRule,FDefValue,FAction,FUserDefine,FNote,FKeyWord,FLeft,FTop,FHeight,FWidth,FCondition,FTabIndex,FLock,FSum,FPrec,FScale,FLayer,FLoadAction,FUnControl,FFont,FSourceType,FSubKey,FParentKey,FConditionExt,FFrameBorder,FFrameBorderColor,FLabelWidth,FLabelColor,FTextColor,FIsF7) 
VALUES (200000000,2,'车牌号','文本','Text','FChePaiHao','FChePaiHao','t_NHG_CheLiangJingChangEntry','',103,0,-1,0,1,1,1,'',0,0,'','','','','','',1,'','',167,500,50,50,'','','',1,'','',0,0,350,1725,'0',4,0,0,0,0,0,'',18,'',0,'','',0,0,0,0,0,0,0)