--子功能SETNOCOUNTONGOIFNotEXISTS(SELECT1FROMt_DataFlowSubFuncWHEREFSubFuncID=705704)BEGININSERTINTO[dbo].[t_DataFlowSubFunc]([FSubFuncID],[FSubSysID],[FIndex],[FFuncName],[FFuncName_CHT],[FFuncName_EN],[FClassName],[FClassParam],[FVisible],[FAcctType],[FFuncType],[FRefresh],[FSetEnable],[FSubID],[FIsEdit],[FShowSysType],[FUrl],[FUrlType])VALUES(705704,7057,4,'二维码管理','二維碼管理','Qrcodemanagement','','',1,',1,2,5,6,7,8,9,10,11,12,13,14,',-1,0,0,'AIn',0,0,'','')EndGO--3级菜单，显示“二维码管理”最前(--之前的方式如果打了两次补丁会出现问题)UPDATEt_DataFlowSubFuncSETFIndex=1whereFSubFuncID=705704UPDATEt_DataFlowSubFuncSETFIndex=2whereFSubFuncID=705701UPDATEt_DataFlowSubFuncSETFIndex=3whereFSubFuncID=705702UPDATEt_DataFlowSubFuncSETFIndex=4whereFSubFuncID=705703GO--新增各项子功能的明細SETNOCOUNTONGO--基础设置IFNotEXISTS(SELECT1FROMt_DataFlowDetailFuncWHEREFSubFuncID=705704)BEGININSERTINTO[dbo].[t_DataFlowDetailFunc]([FDetailFuncID],[FFuncName],[FFuncName_CHT],[FFuncName_EN],[FSubFuncID],[FIndex],[FClassName],[FClassParam],[FIsNormal],[FHelpCode],[FVisible],[FAcctType],[FFuncType],[FEnable],[FShowName],[FShowName_CHT],[FShowName_EN],[FIsEdit],[FShowSysType],[FUrl],[FUrlType],[FFuncType_Ex])VALUES(70570501,'二维码标签设置','二維碼標籤設置','Qrcodelabelsetting',705704,1,'K3AInMain.Application','',0,'770309',1,',1,2,5,6,7,8,9,10,11,12,13,14,',-1,1,'','','',0,0,'','','')INSERTINTO[dbo].[t_DataFlowDetailFunc]([FDetailFuncID],[FFuncName],[FFuncName_CHT],[FFuncName_EN],[FSubFuncID],[FIndex],[FClassName],[FClassParam],[FIsNormal],[FHelpCode],[FVisible],[FAcctType],[FFuncType],[FEnable],[FShowName],[FShowName_CHT],[FShowName_EN],[FIsEdit],[FShowSysType],[FUrl],[FUrlType],[FFuncType_Ex])VALUES(70570502,'二维码标签打印','二維碼標籤打印','Qrcodelabelprinting',705704,2,'K3AInMain.Application','',0,'770310',1,',1,2,5,6,7,8,9,10,11,12,13,14,',-1,1,'','','',0,0,'','','')INSERTINTO[dbo].[t_DataFlowDetailFunc]([FDetailFuncID],[FFuncName],[FFuncName_CHT],[FFuncName_EN],[FSubFuncID],[FIndex],[FClassName],[FClassParam],[FIsNormal],[FHelpCode],[FVisible],[FAcctType],[FFuncType],[FEnable],[FShowName],[FShowName_CHT],[FShowName_EN],[FIsEdit],[FShowSysType],[FUrl],[FUrlType],[FFuncType_Ex])VALUES(70570503,'二维码扫描登陆','二維碼掃描登陸','Qrcodescanning',705704,3,'K3AInMain.Application','',0,'770311',1,',1,2,5,6,7,8,9,10,11,12,13,14,',-1,1,'','','',0,0,'','','')updatet_DataFlowTimeStampsetFName=FNameEndGO--添加需要的固定资产字段IFOBJECT_ID('t_AssetBarCodeFields')isNullBegincreatetablet_AssetBarCodeFields(FIDintidentity(1,1)primarykey,FKeyvarchar(50),FName_CHSnvarchar(30),FName_CHTnvarchar(30),FName_ENnvarchar(50),FMustFieldbitdefault(0))InsertIntot_AssetBarCodeFields(FKey,FName_CHS,FName_CHT,FName_EN,FMustField)Values('FAssetNumber','资产编码','資產編碼','AssetsCode',1)InsertIntot_AssetBarCodeFields(FKey,FName_CHS,FName_CHT,FName_EN,FMustField)Values('FAssetName','资产名称','資產名稱','AssetsName',1)InsertIntot_AssetBarCodeFields(FKey,FName_CHS,FName_CHT,FName_EN,FMustField)Values('FDate','入账日期','入賬日期','EntryDate',1)InsertIntot_AssetBarCodeFields(FKey,FName_CHS,FName_CHT,FName_EN,FMustField)Values('FNum','数量','數量','Qty',1)InsertIntot_AssetBarCodeFields(FKey,FName_CHS,FName_CHT,FName_EN,FMustField)Values('FGroupName','资产类别','資產類別','AssetCategory',0)InsertIntot_AssetBarCodeFields(FKey,FName_CHS,FName_CHT,FName_EN,FMustField)Values('FUnit','计量单位','計量單位','UoM',0)InsertIntot_AssetBarCodeFields(FKey,FName_CHS,FName_CHT,FName_EN,FMustField)Values('FLocationName','存放地点','存放地點','Location',0)InsertIntot_AssetBarCodeFields(FKey,FName_CHS,FName_CHT,FName_EN,FMustField)Values('FEconomyUseName','经济用途','經濟用途','EconomicPurpose',0)InsertIntot_AssetBarCodeFields(FKey,FName_CHS,FName_CHT,FName_EN,FMustField)Values('FStatusName','使用状况','使用狀況','UseStatus',0)InsertIntot_AssetBarCodeFields(FKey,FName_CHS,FName_CHT,FName_EN,FMustField)Values('FAlterModeName','变动方式','變動方式','Transition',0)InsertIntot_AssetBarCodeFields(FKey,FName_CHS,FName_CHT,FName_EN,FMustField)Values('FWorkCenter','工作中心','工作中心','WorkCenter',0)InsertIntot_AssetBarCodeFields(FKey,FName_CHS,FName_CHT,FName_EN,FMustField)Values('FCostCenter','成本中心','成本中心','CostCenter',0)InsertIntot_AssetBarCodeFields(FKey,FName_CHS,FName_CHT,FName_EN,FMustField)Values('FModel','规格型号','規格型號','Specification',0)InsertIntot_AssetBarCodeFields(FKey,FName_CHS,FName_CHT,FName_EN,FMustField)Values('FProductingArea','产地','產地','Origin',0)InsertIntot_AssetBarCodeFields(FKey,FName_CHS,FName_CHT,FName_EN,FMustField)Values('FVender','供应商','供應商','Supplier',0)InsertIntot_AssetBarCodeFields(FKey,FName_CHS,FName_CHT,FName_EN,FMustField)Values('FManufacturer','制造商','製造商','Manufacturer',0)InsertIntot_AssetBarCodeFields(FKey,FName_CHS,FName_CHT,FName_EN,FMustField)Values('FDeptName','使用部门','使用部門','UserDept',0)InsertIntot_AssetBarCodeFields(FKey,FName_CHS,FName_CHT,FName_EN,FMustField)Values('FOrgVal','原值本币','原值本幣','OriginalValue(ReportingCurrency)',0)InsertIntot_AssetBarCodeFields(FKey,FName_CHS,FName_CHT,FName_EN,FMustField)Values('FLifePeriods','预计使用期间','預計使用期間','EstimatedUseSession',0)EndGOIFNotEXISTS(SELECT1FROMt_AssetBarCodeFieldsWHEREFKey='FBeginUseDate')BEGINInsertIntot_AssetBarCodeFields(FKey,FName_CHS,FName_CHT,FName_EN,FMustField)Values('FBeginUseDate','开始使用日期','開始使用日期','BeginUseDate',0)ENDGOIFNotEXISTS(SELECT1FROMt_AssetBarCodeFieldsWHEREFKey='FAccountName')BEGINInsertIntot_AssetBarCodeFields(FKey,FName_CHS,FName_CHT,FName_EN,FMustField)Values('FAccountName','单位名称','單位名稱','Nameoforganization',0)ENDGOupdatet_AssetBarCodeFieldssetFMustField=0whereFKey='FDate'--添加固定资产默认方案IFNotEXISTS(SELECT1FROMICBarCodeProjectWHEREFClassTypeID=1014400andFIsSystem=1)BEGINdeclare@ProjectIDINTInsertIntoICBarCodeProject([FProjectName],[FSupplyID],[FUserID],[FClassTypeID],[FIsDefault],[FShowText],[FUID],[FLogo],[FMustType],[FIsSystem],[FFormatType],[FSplitChar],[FRowSplitChar])Values('默认方案',-1,16394,1014400,1,1,1,Null,0,1,0,'','')Select@ProjectID=SCOPE_IDENTITY()InsertIntoICBarCodeFieldMapping([FProjectID],[FEntryID],[FKey],[FBarCodeName],[FTableName],[FListTableAlias],[FListColName],[FMustField],[FRelTableName],[FRelPrimaryField],[FRelDisplayField],[FCtlType],[FBarCodeKey])Values(@ProjectID,1,'FAssetNumber','资产编码','','','',1,'','','','0','')InsertIntoICBarCodeFieldMapping([FProjectID],[FEntryID],[FKey],[FBarCodeName],[FTableName],[FListTableAlias],[FListColName],[FMustField],[FRelTableName],[FRelPrimaryField],[FRelDisplayField],[FCtlType],[FBarCodeKey])Values(@ProjectID,2,'FAssetName','资产名称','','','',1,'','','','0','')InsertIntoICBarCodeFieldMapping([FProjectID],[FEntryID],[FKey],[FBarCodeName],[FTableName],[FListTableAlias],[FListColName],[FMustField],[FRelTableName],[FRelPrimaryField],[FRelDisplayField],[FCtlType],[FBarCodeKey])Values(@ProjectID,3,'FDate','入账日期','','','',1,'','','','0','')InsertIntoICBarCodeFieldMapping([FProjectID],[FEntryID],[FKey],[FBarCodeName],[FTableName],[FListTableAlias],[FListColName],[FMustField],[FRelTableName],[FRelPrimaryField],[FRelDisplayField],[FCtlType],[FBarCodeKey])Values(@ProjectID,4,'FNum','数量','','','',1,'','','','0','')END--为了满足调整显示顺序的问题,新增一个排序的字段IFNOTEXISTS(SELECT1FROMSYSOBJECTST1INNERJOINSYSCOLUMNST2ONT1.ID=T2.IDWHERET1.NAME='ICBarCodeFieldMapping'ANDT2.NAME='FIndex')ALTERTABLEICBarCodeFieldMappingaddFIndexintGOGOIFOBJECT_ID('ICBarCodeRuleMapping')isNullBegincreatetableICBarCodeRuleMapping(FProjectIDint,FEntryIDint,FCtlTypesmallintdefault(0),FBarCodeNamenvarchar(255),FKeynvarchar(510),FBarCodeKeynvarchar(255),FTableNamenvarchar(510),FRelTableNamenvarchar(510),FRelPrimaryFieldnvarchar(510),FRelDisplayFieldnvarchar(510),FListTableAliasnvarchar(510),FListColNamenvarchar(510),FMustRulebitdefault(0),FDeletedintdefault(0))--把从ICBarCodeProject表中的二维码方案都插入进规则表中InsertIntoICBarCodeRuleMapping([FProjectID],[FEntryID],[FKey],[FBarCodeName],[FTableName],[FListTableAlias],[FListColName],[FMustRule],[FRelTableName],[FRelPrimaryField],[FRelDisplayField],[FCtlType],[FBarCodeKey],[FDeleted])selectFProjectID,1,'FAssetNumber','资产编码','','','',1,'','','','0','',0fromICBarCodeProjectwhereFClassTypeID=1014400andFDelete=0ENDGOdeleteICBarCodeFieldMappingwhereFKey='FDate'andFMustField=1--添加二维码打印明细数据IFOBJECT_ID('t_FaCardDetail')isNullBegincreatetablet_FaCardDetail(FIDintidentity(1,1)primarykey,FAssetIDint,FStatebitdefault(1),--1代表可使用0代表作废FIDentificationint--标识号也是流水号)End--添加资产盘点单表体提交状况IFOBJECT_ID('t_AssetInvPut')isNullBegincreatetablet_AssetInvPut(FIDintidentity(1,1)primarykey,FProjectIDint,FAssetIDint,FSerialNumvarchar(1000),--初盘的流水号FReSerialNumvarchar(1000)--复盘的流水号)EndDeclare@FTableID1intDeclare@FTableID2intDeclare@FTableID3int--把增加的表填入到描述表中IFNOTEXISTS(SELECT1FROMt_TableDescriptionWHEREFTableName='t_AssetBarCodeFields')BEGINSelect@FTableID1=MAX(FTableID)+1Fromt_TableDescriptioninsertintot_TableDescriptionvalues(7057,@FTableID1,'t_AssetBarCodeFields','固定资产字段','固定资产字段',0,1,'固定資產字段','Fixedassetsfield','固定資產字段','Fixedassetsfield')ENDELSESELECT@FTableID1=MAX(FTableID)FROMt_TableDescriptionWHEREFTableName='t_AssetBarCodeFields'IFNOTEXISTS(SELECT1FROMt_TableDescriptionWHEREFTableName='t_FaCardDetail')BEGINSelect@FTableID2=MAX(FTableID)+1Fromt_TableDescriptioninsertintot_TableDescriptionvalues(7057,@FTableID2,'t_FaCardDetail','二维码打印明细数据','二维码打印明细数据',0,1,'二維碼打印明細數據','QRcodeprintthedetaildata','二維碼打印明細數據','QRcodeprintthedetaildata')ENDELSESELECT@FTableID2=MAX(FTableID)FROMt_TableDescriptionWHEREFTableName='t_FaCardDetail'IFNOTEXISTS(SELECT1FROMt_TableDescriptionWHEREFTableName='t_AssetInvPut')BEGINSelect@FTableID3=MAX(FTableID)+1Fromt_TableDescriptioninsertintot_TableDescriptionvalues(7057,@FTableID3,'t_AssetInvPut','资产盘点单表体提交状况','资产盘点单表体提交状况',0,1,'資產盤點單表體提交狀況','TablebodyofAssetCountingDocSubmitthecase','資產盤點單表體提交狀況','TablebodyofAssetCountingDocSubmitthecase')ENDELSESELECT@FTableID3=MAX(FTableID)FROMt_TableDescriptionWHEREFTableName='t_AssetInvPut'--把增加的字段填入到字段描述表中IFNOTEXISTS(SELECT1FROMt_FieldDescriptionwhereFTableID=@FTableID1)BEGINinsertintot_FieldDescription(FTableID,FFieldName,FFieldType,FDescription,FFieldNote,FDescription_Cht,FDescription_En,FFieldNote_Cht,FFieldNote_En)values(@FTableID1,'FID','INTEGER','字段编号','字段编号','字段編號','FieldID','字段編號','FieldID')insertintot_FieldDescription(FTableID,FFieldName,FFieldType,FDescription,FFieldNote,FDescription_Cht,FDescription_En,FFieldNote_Cht,FFieldNote_En)values(@FTableID1,'FKey','STRING','字段主键','字段主键','字段主鍵','FieldKey','字段主鍵','FieldKey')insertintot_FieldDescription(FTableID,FFieldName,FFieldType,FDescription,FFieldNote,FDescription_Cht,FDescription_En,FFieldNote_Cht,FFieldNote_En)values(@FTableID1,'FName_CHS','STRING','字段简体名称','字段简体名称','字段簡體名稱','Fieldnameofsimplified','字段簡體名稱','Fieldnameofsimplified')insertintot_FieldDescription(FTableID,FFieldName,FFieldType,FDescription,FFieldNote,FDescription_Cht,FDescription_En,FFieldNote_Cht,FFieldNote_En)values(@FTableID1,'FName_CHT','STRING','字段繁体名称','字段繁体名称','字段繁體名稱','Traditionalnamefield','字段繁體名稱','Traditionalnamefield')insertintot_FieldDescription(FTableID,FFieldName,FFieldType,FDescription,FFieldNote,FDescription_Cht,FDescription_En,FFieldNote_Cht,FFieldNote_En)values(@FTableID1,'FName_EN','STRING','字段英文名称','字段英文名称','字段英文名稱','ThefieldnameinEnglish','字段英文名稱','ThefieldnameinEnglish')insertintot_FieldDescription(FTableID,FFieldName,FFieldType,FDescription,FFieldNote,FDescription_Cht,FDescription_En,FFieldNote_Cht,FFieldNote_En)values(@FTableID1,'FMustField','STRING','必须字段','必须字段','必須字段','MustField','必須字段','MustField')ENDIFNOTEXISTS(SELECT1FROMt_FieldDescriptionwhereFTableID=@FTableID2)BEGINinsertintot_FieldDescription(FTableID,FFieldName,FFieldType,FDescription,FFieldNote,FDescription_Cht,FDescription_En,FFieldNote_Cht,FFieldNote_En)values(@FTableID2,'FID','INTEGER','明细数据编号','明细数据编号','明細數據編號','DetaildataID','明細數據編號','DetaildataID')insertintot_FieldDescription(FTableID,FFieldName,FFieldType,FDescription,FFieldNote,FDescription_Cht,FDescription_En,FFieldNote_Cht,FFieldNote_En)values(@FTableID2,'FAssetID','INTEGER','资产编码','资产编码','資產編碼','AssetID','資產編碼','AssetID')insertintot_FieldDescription(FTableID,FFieldName,FFieldType,FDescription,FFieldNote,FDescription_Cht,FDescription_En,FFieldNote_Cht,FFieldNote_En)values(@FTableID2,'FState','Bit','流水状态','流水状态','流水狀態','SerialNumberState','流水狀態','SerialNumberState')insertintot_FieldDescription(FTableID,FFieldName,FFieldType,FDescription,FFieldNote,FDescription_Cht,FDescription_En,FFieldNote_Cht,FFieldNote_En)values(@FTableID2,'FIDentification','INTEGER','标识号','标识号','標識號','Identificationnumber','標識號','Identificationnumber')ENDIFNOTEXISTS(SELECT1FROMt_FieldDescriptionwhereFTableID=@FTableID3)BEGINinsertintot_FieldDescription(FTableID,FFieldName,FFieldType,FDescription,FFieldNote,FDescription_Cht,FDescription_En,FFieldNote_Cht,FFieldNote_En)values(@FTableID3,'FID','INTEGER','表体编号','表体编号','表體編號','TablebodyID','表體編號','TablebodyID')insertintot_FieldDescription(FTableID,FFieldName,FFieldType,FDescription,FFieldNote,FDescription_Cht,FDescription_En,FFieldNote_Cht,FFieldNote_En)values(@FTableID3,'FProjectID','INTEGER','盘点方案ID','盘点方案ID','盤點方案ID','PhysicalCountingSchemeID','盤點方案ID','PhysicalCountingSchemeID')insertintot_FieldDescription(FTableID,FFieldName,FFieldType,FDescription,FFieldNote,FDescription_Cht,FDescription_En,FFieldNote_Cht,FFieldNote_En)values(@FTableID3,'FAssetID','INTEGER','资产编码','资产编码','資產編碼','AssetID','資產編碼','AssetID')insertintot_FieldDescription(FTableID,FFieldName,FFieldType,FDescription,FFieldNote,FDescription_Cht,FDescription_En,FFieldNote_Cht,FFieldNote_En)values(@FTableID3,'FSerialNum','STRING','初盘流水号','初盘流水号','初盤流水號','Firstcountofserialnumber','初盤流水號','Firstcountofserialnumber')insertintot_FieldDescription(FTableID,FFieldName,FFieldType,FDescription,FFieldNote,FDescription_Cht,FDescription_En,FFieldNote_Cht,FFieldNote_En)values(@FTableID3,'FReSerialNum','STRING','复盘流水号','复盘流水号','複盤流水號','Secondcountofserialnumber','複盤流水號','Secondcountofserialnumber')END--添加方案的流水号下载日志IFNOTEXISTS(SELECT1FROMt_LogFunctionwhereFFunctionID='AIn0059')BEGINinsertintot_LogFunctionvalues('AIn0059','资产条码盘点-PDA-下载方案流水号',7057,'資產條碼盤點-PDA-下載方案流水號','AssetsInventorybyBarcode-PDA-DownloadSerialnumber')END--添加资产条码盘点中二维码的日志IFNOTEXISTS(SELECT1FROMt_LogFunctionwhereFFunctionIDlike'%AssetBarCode001%')BEGINinsertintot_LogFunctionvalues('AssetBarCode001-New','资产条码盘点-二维码标签设置-新建',7057,'資產條碼盤點-二維碼標籤設置-新建','AssetsInventorybyBarcode-QRCodelabelsetting-Newlabel')insertintot_LogFunctionvalues('AssetBarCode001-Copy','资产条码盘点-二维码标签设置-复制',7057,'資產條碼盤點-二維碼標籤設置-複製','AssetsInventorybyBarcode-QRCodelabelsetting-Copylabel')insertintot_LogFunctionvalues('AssetBarCode001-Save','资产条码盘点-二维码标签设置-保存',7057,'資產條碼盤點-二維碼標籤設置-保存','AssetsInventorybyBarcode-QRCodelabelsetting-Savelabel')insertintot_LogFunctionvalues('AssetBarCode001-Delete','资产条码盘点-二维码标签设置-删除',7057,'資產條碼盤點-二維碼標籤設置-刪除','AssetsInventorybyBarcode-QRCodelabelsetting-Deletelabel')insertintot_LogFunctionvalues('AssetBarCode001-Rename','资产条码盘点-二维码标签设置-重命名',7057,'資產條碼盤點-二維碼標籤設置-重命名','AssetsInventorybyBarcode-QRCodelabelsetting-Renamelabel')insertintot_LogFunctionvalues('AssetBarCode001-Browse','资产条码盘点-二维码标签设置-浏览',7057,'資產條碼盤點-二維碼標籤設置-瀏覽','AssetsInventorybyBarcode-QRCodelabelsetting-BrwoseIco')insertintot_LogFunctionvalues('AssetBarCode001-Clear','资产条码盘点-二维码标签设置-清除',7057,'資產條碼盤點-二維碼標籤設置-清除','AssetsInventorybyBarcode-QRCodelabelsetting-ClearIco')ENDIFNOTEXISTS(SELECT1FROMt_LogFunctionwhereFFunctionIDlike'%AssetBarCode002%')BEGINinsertintot_LogFunctionvalues('AssetBarCode002-Design','资产条码盘点-二维码标签打印-布局设计',7057,'資產條碼盤點-二維碼標籤打印-佈局設計','AssetsInventorybyBarcode-QRCodelabelprintting-LayoutDesign')insertintot_LogFunctionvalues('AssetBarCode002-Preview','资产条码盘点-二维码标签打印-打印预览',7057,'資產條碼盤點-二維碼標籤打印-打印預覽','AssetsInventorybyBarcode-QRCodeprinttingsetting-Printpreview')insertintot_LogFunctionvalues('AssetBarCode002-Print','资产条码盘点-二维码标签打印-打印',7057,'資產條碼盤點-二維碼標籤打印-打印','AssetsInventorybyBarcode-QRCodelabelprintting-Print')insertintot_LogFunctionvalues('AssetBarCode002-Filter','资产条码盘点-二维码标签打印-过滤',7057,'資產條碼盤點-二維碼標籤打印-過濾','AssetsInventorybyBarcode-QRCodelabelprintting-Filter')insertintot_LogFunctionvalues('AssetBarCode002-Cancel','资产条码盘点-二维码标签打印-作废',7057,'資產條碼盤點-二維碼標籤打印-作廢','AssetsInventorybyBarcode-QRCodelabelprintting-Cancel')END/***************************************************************************************BUG/REQUIREMENTID:资产盘点--二维码**DESCRIPTION:权限类别表:资产条码盘点-二维码管理***BY:dayang_deng**DATE:2016-02-01***************************************************************************************/IFNOTEXISTS(SELECT1FROMt_ObjectTypeWHEREFObjectType=72573)BeginINSERTINTOt_ObjectType(FObjectType,FObjectID,FName,FDescription,FName_cht,FName_en,FDescription_cht,FDescription_en)VALUES(72573,0,N'资产条码盘点-二维码管理','',N'資產條碼盤點-二維碼管理','AssetsInventorybyQRcode-QRcodeManagement',NULL,NULL)INSERTINTOt_ObjectType(FObjectType,FObjectID,FName,FDescription,FName_cht,FName_en,FDescription_cht,FDescription_en)VALUES(72573,70570501,N'二维码标签设置','',N'二維碼標籤設置','LabelSettingsofQRCode',NULL,NULL)INSERTINTOt_ObjectType(FObjectType,FObjectID,FName,FDescription,FName_cht,FName_en,FDescription_cht,FDescription_en)VALUES(72573,70570502,N'二维码标签打印','',N'二維碼標籤打印','LabelSettingsofQRCode',NULL,NULL)INSERTINTOt_ObjectType(FObjectType,FObjectID,FName,FDescription,FName_cht,FName_en,FDescription_cht,FDescription_en)VALUES(72573,70570503,N'二维码扫描登陆','',N'二維碼掃描登陸','LabelSettingsofQRCode',NULL,NULL)EndGO/************权限明细************/IFNOTEXISTS(SELECT1FROMt_ObjectAccessTypeWHEREFObjectType=72573)BeginINSERTINTOt_ObjectAccessType(FObjectType,FObjectID,Findex,FAccessMask,FAccessUse,Fname,Fdescription,FName_cht,FName_en,FDescription_cht,FDescription_en)VALUES(72573,70570501,1,2097152,1012028,N'查看',N'查看',N'查看',N'View',N'查看',N'View')INSERTINTOt_ObjectAccessType(FObjectType,FObjectID,Findex,FAccessMask,FAccessUse,Fname,Fdescription,FName_cht,FName_en,FDescription_cht,FDescription_en)VALUES(72573,70570501,2,4194304,3145728,N'设置',N'设置',N'設置',N'View',N'設置',N'View')INSERTINTOt_ObjectAccessType(FObjectType,FObjectID,Findex,FAccessMask,FAccessUse,Fname,Fdescription,FName_cht,FName_en,FDescription_cht,FDescription_en)VALUES(72573,70570502,1,2097152,1012028,N'查看',N'查看',N'查看',N'View',N'查看',N'View')INSERTINTOt_ObjectAccessType(FObjectType,FObjectID,Findex,FAccessMask,FAccessUse,Fname,Fdescription,FName_cht,FName_en,FDescription_cht,FDescription_en)VALUES(72573,70570502,2,4194304,3145728,N'设置',N'设置',N'設置',N'View',N'設置',N'View')INSERTINTOt_ObjectAccessType(FObjectType,FObjectID,Findex,FAccessMask,FAccessUse,Fname,Fdescription,FName_cht,FName_en,FDescription_cht,FDescription_en)VALUES(72573,70570503,1,2097152,1012028,N'查看',N'查看',N'查看',N'View',N'查看',N'View')INSERTINTOt_ObjectAccessType(FObjectType,FObjectID,Findex,FAccessMask,FAccessUse,Fname,Fdescription,FName_cht,FName_en,FDescription_cht,FDescription_en)VALUES(72573,70570503,2,4194304,3145728,N'设置',N'设置',N'設置',N'View',N'設置',N'View')updatet_ObjectAccessTypesetFAccessUse=3145744whereFObjectType=72571andFObjectID=70570203andFIndex=11updatet_ObjectAccessTypesetFAccessUse=3145728whereFObjectType=72571andFObjectID=70570203andFIndex=10End/**********************权限分组：查询权，管理权**********************/IFNOTEXISTS(SELECT1FROMt_ObjectAccessWHEREFObjectType=72573)BeginINSERTINTOt_ObjectAccess(FGroupID,FObjectType,FObjectID,FIndex)VALUES(70571,72573,0,0)--二维码标签设置：查询权INSERTINTOt_ObjectAccess(FGroupID,FObjectType,FObjectID,FIndex)VALUES(70571,72573,70570501,0)INSERTINTOt_ObjectAccess(FGroupID,FObjectType,FObjectID,FIndex)VALUES(70571,72573,70570501,1)--二维码标签设置：管理权INSERTINTOt_ObjectAccess(FGroupID,FObjectType,FObjectID,FIndex)VALUES(70572,72573,70570501,0)INSERTINTOt_ObjectAccess(FGroupID,FObjectType,FObjectID,FIndex)VALUES(70572,72573,70570501,2)--二维码标签打印：查询权INSERTINTOt_ObjectAccess(FGroupID,FObjectType,FObjectID,FIndex)VALUES(70571,72573,70570502,0)INSERTINTOt_ObjectAccess(FGroupID,FObjectType,FObjectID,FIndex)VALUES(70571,72573,70570502,1)--二维码标签打印：管理权INSERTINTOt_ObjectAccess(FGroupID,FObjectType,FObjectID,FIndex)VALUES(70572,72573,70570502,0)INSERTINTOt_ObjectAccess(FGroupID,FObjectType,FObjectID,FIndex)VALUES(70572,72573,70570502,2)--二维码扫描登陆:查询权INSERTINTOt_ObjectAccess(FGroupID,FObjectType,FObjectID,FIndex)VALUES(70571,72573,70570503,0)INSERTINTOt_ObjectAccess(FGroupID,FObjectType,FObjectID,FIndex)VALUES(70571,72573,70570503,1)--二维码扫描登陆:管理权INSERTINTOt_ObjectAccess(FGroupID,FObjectType,FObjectID,FIndex)VALUES(70572,72573,70570503,0)INSERTINTOt_ObjectAccess(FGroupID,FObjectType,FObjectID,FIndex)VALUES(70572,72573,70570503,2)End--提交盘点数据IFNOTEXISTS(SELECT1FROMt_ObjectAccesswhereFGroupID=70572andFObjectType=72571andFObjectID=70570203andFIndex=11)BEGININSERTINTOt_ObjectAccess(FGroupID,FObjectType,FObjectID,FIndex)VALUES(70572,72571,70570203,11)EndGO/*套打模板按方案保存表*/IFNOTEXISTS(SELECT*FROMsys.objectsWHEREobject_id=OBJECT_ID(N'[dbo].[t_ICBarCodePrintWithTemplate]')ANDtypein(N'U'))BEGINCREATETABLE[dbo].[t_ICBarCodePrintWithTemplate]([FID][bigint]IDENTITY(1,1)NOTNULL,[FProjectID][varchar](50)NULL,[FUserID][int]NOTNULL,[FUserName][varchar](50)NULL,[FWidth][varchar](50)notNULL,[FHeight][varchar](50)notNULL,[FLeft][varchar](50)notNULL,[FTop][varchar](50)notNULL,[FTemplateHead][nvarchar](Max)null,[FTemplateEntry][nvarchar](Max)null,[FDate][datetime]NOTNULL,[FDeleted][int]NOTNULL)ON[PRIMARY]SETANSI_PADDINGOFFALTERTABLE[dbo].[t_ICBarCodePrintWithTemplate]ADDDEFAULT(getdate())FOR[FDate]ALTERTABLE[dbo].[t_ICBarCodePrintWithTemplate]ADDDEFAULT((0))FOR[FDeleted]ENDExecutep_AlterTableAddColumns@tablename='t_ICBarCodePrintWithTemplate',@Fields='FTemplateNamenvarchar(250)NULLDEFAULT('''')|',@Delimeter='|'GO--为方案添加宽度默认值execp_altertableaddcolumns@TableName='ICBarCodeFieldMapping',@Fields='FWidthintnotnulldefault(100)',@Delimeter='|'GO--增加是否显示序列号列参数execp_altertableaddcolumns@TableName='ICBarCodeProject',@Fields='FShowSerialColintnotnulldefault(0)',@Delimeter='|'GO--添加二维码标识字段EXECUTEp_AlterTableAddColumns@TableName='t_AssetBarCodeFields',@Fields='FMustRulebitnotnulldefault(0)',@Delimeter='|'GO--添加资产编码字段execp_altertableaddcolumns@TableName='t_FAcarddetail',@Fields='FAssetNumbervarchar(100)notnulldefault('''')',@Delimeter='|'GO--更新数据updatet_AssetBarCodeFieldssetFMustRule='true'whereFKey='FAssetNumber'GO--添加一个系统参数,来决定数量的显示类型IFNOTEXISTS(SELECT1FROMt_SystemProfilewhereFCategory='Code'andFKey='NumberType')BEGININSERTINTOt_SystemProfile([FCategory],[FKey],[FValue],[FReadonly],[FDescription],[FLevel],[FExplanation],[FFormat],[FSort],[FDescription_cht],[FDescription_en])VALUES('Code','NumberType','整数',0,'数量的显示类型',1,'','',0.01,'條碼','Code')EndGO
