📄 过磅系统.txt
字号:
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 (200000001,2,'客户','客户','客户','FKeHu','FKeHu','t_NHG_CheLiangChuChangEntry1','',103,0,-1,0,1,0,1,'',1,1,'','FItemID','t_Organization','','FName','FNumber',1,'','',56,500,255,4,'','','',1,'','',5158,7738,346,2955,'0',8,0,0,0,10,0,'',16,'',1,'','',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 (200000001,2,'皮重','小數','Decimal Fraction','FPiZhong','FPiZhong','t_NHG_CheLiangChuChangEntry1','',103,0,-1,0,1,0,2,'',0,0,'','','','','','',1,'','',106,9,20,13,'','','',1,'','',0,0,350,1755,'1',9,0,1,28,3,0,'',16,'',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 (200000001,2,'毛重','小數7','Decimal Fraction7','FMaoZhong','FMaoZhong','t_NHG_CheLiangChuChangEntry1','',101,0,-1,0,1,0,2,'',0,0,'','','','','','',1,'','',106,9,20,13,'','','',1,'','',0,0,350,1830,'1',10,0,1,28,3,0,'',16,'',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 (200000001,2,'净重','小數6','Decimal Fraction6','FJingZhong','FJingZhong','t_NHG_CheLiangChuChangEntry1','',101,0,-1,0,1,0,2,'',0,0,'','','','','','',1,'','',106,9,20,13,'','','',1,'','',0,0,350,2145,'1',11,0,1,28,3,0,'',16,'',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 (200000001,2,'进厂时间','長日期','Long date','FJingChangShiJian','FJingChangShiJian','t_NHG_CheLiangChuChangEntry1','',103,0,-1,0,1,0,0,'',0,0,'','','','','','',0,'','',61,502,50,8,'','','',1,'','',0,0,0,2760,'2',12,0,0,0,0,0,'',55,'',13,'','',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 (200000001,2,'出厂时间','長日期1','Long date1','FChuChangShiJian','FChuChangShiJian','t_NHG_CheLiangChuChangEntry1','',101,0,-1,0,1,0,0,'',0,0,'','','','','','',0,'','',61,502,50,8,'','','',1,'','',0,0,0,2625,'2',13,0,0,0,0,0,'',55,'',13,'','',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 (200000001,3,'分录内码','分錄內碼','Entry ISN','FEntryID3','FEntryID','t_NHG_CheLiangChuChangEntry2','',101,0,0,1,0,0,3,'',0,0,'','','','','','',1,'','',56,500,255,4,'','','',0,'','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 (200000001,3,'行号','行號','Row No.','FIndex3','FIndex','t_NHG_CheLiangChuChangEntry2','',103,0,0,1,1,0,3,'',0,0,'','','','','','',1,'','',56,500,255,4,'','','',0,'','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 (200000001,3,'单据内码','單據內碼','Doc ISN','FID3','FID','t_NHG_CheLiangChuChangEntry2','',102,0,0,1,1,1,3,'',0,0,'','','','','','',1,'','',56,500,255,4,'','','',0,'','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 (200000001,3,'发票号码','文本1','Text1','FFaPiaoHao','FFaPiaoHao','t_NHG_CheLiangChuChangEntry2','',103,0,-1,0,1,1,1,'',0,0,'','','','','','',1,'','',167,500,50,50,'','','',1,'','',0,0,350,1695,'0',3,-1,0,0,0,0,'',18,'',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 (200000001,3,'客户','基礎資料','Master Data','FKeHu1','FKeHu1','t_NHG_CheLiangChuChangEntry2','',101,0,-1,0,1,0,1,'',1,1,'','FItemID','t_Organization','','FName','FNumber',1,'','',56,10,10,4,'','','',1,'','',5158,7738,346,2500,'0',4,-1,0,0,10,0,'',16,'',1,'','',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 (200000001,3,'票重','小數8','Decimal Fraction8','FPiaoZhong','FPiaoZhong','t_NHG_CheLiangChuChangEntry2','',103,0,-1,0,1,0,2,'',0,0,'','','','','','',1,'','',106,9,20,13,'','','',1,'','',0,0,350,1410,'1',5,-1,1,28,3,0,'',16,'',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 (200000001,3,'袋重','小數4','Decimal Fraction4','FDaiZhong','FDaiZhong','t_NHG_CheLiangChuChangEntry2','',101,0,-1,0,1,0,2,'',0,0,'','','','','','',1,'','',106,9,20,13,'','','',1,'','',0,0,350,1275,'1',6,-1,1,28,3,0,'',16,'',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 (200000001,3,'总重','小數5','Decimal Fraction5','FZhongZhong','FZhongZhong','t_NHG_CheLiangChuChangEntry2','',101,0,-1,0,1,0,2,'',0,0,'','','','','','',1,'','',106,9,20,13,'','','',1,'','',0,0,350,1260,'1',7,-1,1,28,3,0,'',16,'',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 (200000001,3,'发票内码','整數','Integer','FFaPiao','FFaPiao','t_NHG_CheLiangChuChangEntry2','',101,0,12,0,1,0,3,'',0,0,'','','','','','',1,'','',56,10,10,4,'','','',1,'','',0,0,350,0,'1',8,0,0,0,0,0,'',16,'',0,'','',0,0,0,0,0,0,0)
GO
/****** Object:Data 单据编号:ICBillNo Script Date: 2006-07-17 ******/
if not exists (SELECT * FROM ICBillNo WHERE FBillID=200000001)
begin
INSERT INTO ICBillNo(FBillID,FBillName,FPreLetter,FSufLetter,FCurNo,FBillName_CHT,FBillName_EN,FFormat,FPos,FCanAlterBillNo,FCheckAfterSave,FUseBillCodeRule,FDesc)
VALUES (200000001,'成品车辆出厂登记单_BOS',NULL,NULL,3,'單據200000001_BOS','Doc200000001_BOS','00000000',200000001,0,0,1,'00000003')
end
GO
/****** Object:Data 单据权限类弄表:t_ObjectAccessType Script Date: 2006-07-17 ******/
Delete t_ObjectAccessType WHERE FObjectType=4100 And FObjectID =200000001
GO
INSERT INTO t_ObjectAccessType(FObjectType,FObjectID,FIndex,FAccessMask,FAccessUse,FName,FDescription,FName_cht,FName_en,FDescription_cht,FDescription_en)
VALUES (4100,200000001,1,2097152,1048576,'查看','查看','查看','Search','查看','Search')
GO
INSERT INTO t_ObjectAccessType(FObjectType,FObjectID,FIndex,FAccessMask,FAccessUse,FName,FDescription,FName_cht,FName_en,FDescription_cht,FDescription_en)
VALUES (4100,200000001,2,131072,3145728,'新增','新增','新增','New','新增','New')
GO
INSERT INTO t_ObjectAccessType(FObjectType,FObjectID,FIndex,FAccessMask,FAccessUse,FName,FDescription,FName_cht,FName_en,FDescription_cht,FDescription_en)
VALUES (4100,200000001,3,65536,3145728,'删除','删除','刪除','Del.','刪除','Del.')
GO
INSERT INTO t_ObjectAccessType(FObjectType,FObjectID,FIndex,FAccessMask,FAccessUse,FName,FDescription,FName_cht,FName_en,FDescription_cht,FDescription_en)
VALUES (4100,200000001,4,4194304,3145728,'修改','修改','修改','Edit','修改','Edit')
GO
INSERT INTO t_ObjectAccessType(FObjectType,FObjectID,FIndex,FAccessMask,FAccessUse,FName,FDescription,FName_cht,FName_en,FDescription_cht,FDescription_en)
VALUES (4100,200000001,5,16,3145728,'引出内部数据','引出内部数据','引出內部資料','Exp Internal Data','引出內部資料','Exp Internal Data')
GO
INSERT INTO t_ObjectAccessType(FObjectType,FObjectID,FIndex,FAccessMask,FAccessUse,FName,FDescription,FName_cht,FName_en,FDescription_cht,FDescription_en)
VALUES (4100,200000001,6,32768,3145728,'打印','打印','列印','Print','列印','Print')
GO
INSERT INTO t_ObjectAccessType(FObjectType,FObjectID,FIndex,FAccessMask,FAccessUse,FName,FDescription,FName_cht,FName_en,FDescription_cht,FDescription_en)
VALUES (4100,200000001,7,64,3145728,'禁用','禁用','禁用','Disable','禁用','Disable')
GO
/****** Object:Data 单据权限对象表:t_ObjectType Script Date: 2006-07-17 ******/
Delete t_ObjectType WHERE FObjectType=4100 And FObjectID =200000001
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -