--把增加表属性的SQL放在最前面，以免后面因为缺少属性报错GO--添加需要的固定资产字段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)EndGO--在属性表中新增加一行标识一维码还是二维码execp_altertableaddcolumns@TableName='t_AssetBarCodeFields',@Fields='FBarCodeClassvarchar(100)notnulldefault("二维码")',@Delimeter='|'GO--在方案表中新增加一行标识一维码还是二维码execp_altertableaddcolumns@TableName='ICBarCodeProject',@Fields='FBarCodeClassvarchar(100)notnulldefault("二维码")',@Delimeter='|'GO--为方案添加宽度默认值execp_altertableaddcolumns@TableName='ICBarCodeFieldMapping',@Fields='FWidthintnotnulldefault(100)',@Delimeter='|'GO--增加是否显示序列号列参数execp_altertableaddcolumns@TableName='ICBarCodeProject',@Fields='FShowSerialColintnotnulldefault(0)',@Delimeter='|'GO--添加资产编码字段execp_altertableaddcolumns@TableName='t_FAcarddetail',@Fields='FAssetNumbervarchar(100)notnulldefault('''')',@Delimeter='|'GO--新增一个属性记录条码规则execp_altertableaddcolumns@TableName='t_FAcarddetail',@Fields='FCodeRulevarchar(100)',@Delimeter='|'GO--添加必须字段标识execp_altertableaddcolumns@TableName='t_AssetBarCodeFields',@Fields='FMustRulebitnotnulldefault(0)',@Delimeter='|'GO--在标签设置中添加识别二维码和一维码的的属性字段IFNotEXISTS(SELECT1FROMt_SystemProfileWHEREFKey='FCodeClass'andFCategory='FA')BEGINInsertIntot_SystemProfile(FCategory,FKey,FValue,FReadonly,FDescription,FLevel,FExplanation,FFormat,FSort,FDescription_cht,FDescription_en)Values('FA','FCodeClass','二维码',0,'条码类型',NULL,'一维码或是二维码',NULL,NULL,'條碼類型','Codeclass')EndGO--在标签打印中添加识别二维码和一维码的的属性字段IFNotEXISTS(SELECT1FROMt_SystemProfileWHEREFKey='FPrintCodeClass'andFCategory='FA')BEGINInsertIntot_SystemProfile(FCategory,FKey,FValue,FReadonly,FDescription,FLevel,FExplanation,FFormat,FSort,FDescription_cht,FDescription_en)Values('FA','FPrintCodeClass','二维码',0,'条码类型',NULL,'一维码或是二维码',NULL,NULL,'條碼類型','Codeclass')EndGO--子功能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=FNameEndGOIFNotEXISTS(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)ENDGOIFNotEXISTS(SELECT1FROMt_AssetBarCodeFieldsWHEREFKey='FAssetNumber'andFBarCodeClass='一维码')BEGINInsertIntot_AssetBarCodeFields(FKey,FName_CHS,FName_CHT,FName_EN,FMustField,FBarCodeClass,FMustRule)Values('FAssetNumber','资产编码','壹維碼資產編碼','1DAssetsCode',1,'一维码','false')ENDGOIFNotEXISTS(SELECT1FROMt_AssetBarCodeFieldsWHEREFKey='FAssetName'andFBarCodeClass='一维码')BEGINInsertIntot_AssetBarCodeFields(FKey,FName_CHS,FName_CHT,FName_EN,FMustField,FBarCodeClass,FMustRule)Values('FAssetName','资产名称','壹維碼資產名稱','1DAssetsName','true','一维码','false')ENDIFNotEXISTS(SELECT1FROMt_AssetBarCodeFieldsWHEREFKey='FCodeRule'andFBarCodeClass='一维码')BEGINInsertIntot_AssetBarCodeFields(FKey,FName_CHS,FName_CHT,FName_EN,FMustField,FBarCodeClass,FMustRule)Values('FCodeRule','条码规则','壹維碼條碼規則','1DCodeRule','false','一维码','true')ENDGOIFNotEXISTS(SELECT1FROMt_AssetBarCodeFieldsWHEREFKey='FRuleAssetNumber'andFBarCodeClass='一维码')BEGINInsertIntot_AssetBarCodeFields(FKey,FName_CHS,FName_CHT,FName_EN,FMustField,FBarCodeClass,FMustRule)Values('FRuleAssetNumber','资产编码','規則資產編碼','1DRuleAssetsCode','false','一维码','true')ENDGOIFNotEXISTS(SELECT1FROMt_AssetBarCodeFieldsWHEREFKey='FRuleBreak'andFBarCodeClass='一维码')BEGINInsertIntot_AssetBarCodeFields(FKey,FName_CHS,FName_CHT,FName_EN,FMustField,FBarCodeClass,FMustRule)Values('FRuleBreak','分隔符','規則分隔符','1DRuleBreak','false','一维码','true')ENDGOIFNotEXISTS(SELECT1FROMt_AssetBarCodeFieldsWHEREFKey='FRuleSerialNum'andFBarCodeClass='一维码')BEGINInsertIntot_AssetBarCodeFields(FKey,FName_CHS,FName_CHT,FName_EN,FMustField,FBarCodeClass,FMustRule)Values('FRuleSerialNum','流水号','規則流水號','1DRuleSerialNumber','false','一维码','true')ENDGOupdatet_AssetBarCodeFieldssetFMustField=0whereFKey='FDate'--为二维码添加固定资产默认方案IFNotEXISTS(SELECT1FROMICBarCodeProjectWHEREFClassTypeID=1014400andFIsSystem=1andFBarCodeClass='二维码')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','')ENDGOIFOBJECT_ID('ICBarCodeRuleMapping')isNullBegindeclare@ProjectIDINT,@CodeProjectIDintselect@ProjectID=(selectMAX(FProjectID)fromICBarCodeProjectwhereFBarCodeClass='二维码')select@CodeProjectID=(selectMAX(FProjectID)fromICBarCodeProjectwhereFBarCodeClass='一维码')createtableICBarCodeRuleMapping(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))InsertIntoICBarCodeRuleMapping([FProjectID],[FEntryID],[FKey],[FBarCodeName],[FTableName],[FListTableAlias],[FListColName],[FMustRule],[FRelTableName],[FRelPrimaryField],[FRelDisplayField],[FCtlType],[FBarCodeKey],[FDeleted])Values(@ProjectID,1,'FAssetNumber','资产编码','','','',1,'','','','0','',0)--InsertIntoICBarCodeRuleMapping--([FProjectID],[FEntryID],[FKey],[FBarCodeName],[FTableName],[FListTableAlias],[FListColName],[FMustRule],[FRelTableName],[FRelPrimaryField],[FRelDisplayField],[FCtlType],[FBarCodeKey],[FDeleted])--Values--(@ProjectID,1,'FCodeRule','条码规则','','','',1,'','','','0','',0)--InsertIntoICBarCodeRuleMapping--([FProjectID],[FEntryID],[FKey],[FBarCodeName],[FTableName],[FListTableAlias],[FListColName],[FMustRule],[FRelTableName],[FRelPrimaryField],[FRelDisplayField],[FCtlType],[FBarCodeKey],[FDeleted])--Values--(@ProjectID,1,'FAssetName','资产名称','','','',1,'','','','0','',0)InsertIntoICBarCodeRuleMapping([FProjectID],[FEntryID],[FKey],[FBarCodeName],[FTableName],[FListTableAlias],[FListColName],[FMustRule],[FRelTableName],[FRelPrimaryField],[FRelDisplayField],[FCtlType],[FBarCodeKey],[FDeleted])Values(@CodeProjectID,1,'FRuleAssetNumber','资产编码','','','',1,'','','','0','|',0)InsertIntoICBarCodeRuleMapping([FProjectID],[FEntryID],[FKey],[FBarCodeName],[FTableName],[FListTableAlias],[FListColName],[FMustRule],[FRelTableName],[FRelPrimaryField],[FRelDisplayField],[FCtlType],[FBarCodeKey],[FDeleted])Values(@CodeProjectID,1,'FRuleBreak','分隔符','','','',1,'','','','0','|',0)InsertIntoICBarCodeRuleMapping([FProjectID],[FEntryID],[FKey],[FBarCodeName],[FTableName],[FListTableAlias],[FListColName],[FMustRule],[FRelTableName],[FRelPrimaryField],[FRelDisplayField],[FCtlType],[FBarCodeKey],[FDeleted])Values(@CodeProjectID,1,'FRuleSerialNum','流水号','','','',1,'','','','0','|',0)ENDGO--为一维码添加默认方案IFNotEXISTS(SELECT1FROMICBarCodeProjectWHEREFClassTypeID=1014400andFIsSystem=1andFBarCodeClass='一维码')BEGIN--一维码默认的只有资产编码和资产名称declare@1DProjectIDINTSelect@1DProjectID=SCOPE_IDENTITY()--向显示内容添加默认方案的idInsertIntoICBarCodeProject([FProjectName],[FSupplyID],[FUserID],[FClassTypeID],[FIsDefault],[FShowText],[FUID],[FLogo],[FMustType],[FIsSystem],[FFormatType],[FSplitChar],[FRowSplitChar],[FBarCodeClass])Values('默认方案',-1,16394,1014400,1,1,1,Null,0,1,0,'','','一维码')Select@1DProjectID=SCOPE_IDENTITY()InsertIntoICBarCodeFieldMapping([FProjectID],[FEntryID],[FKey],[FBarCodeName],[FTableName],[FListTableAlias],[FListColName],[FMustField],[FRelTableName],[FRelPrimaryField],[FRelDisplayField],[FCtlType],[FBarCodeKey])Values(@1DProjectID,1,'FAssetNumber','资产编码','','','',1,'','','','0','')InsertIntoICBarCodeFieldMapping([FProjectID],[FEntryID],[FKey],[FBarCodeName],[FTableName],[FListTableAlias],[FListColName],[FMustField],[FRelTableName],[FRelPrimaryField],[FRelDisplayField],[FCtlType],[FBarCodeKey])Values(@1DProjectID,2,'FAssetName','资产名称','','','',1,'','','','0','')InsertIntoICBarCodeFieldMapping([FProjectID],[FEntryID],[FKey],[FBarCodeName],[FTableName],[FListTableAlias],[FListColName],[FMustField],[FRelTableName],[FRelPrimaryField],[FRelDisplayField],[FCtlType],[FBarCodeKey])Values(@1DProjectID,3,'FNum','数量','','','',1,'','','','0','')--向规则内容添加默认方案的idInsertIntoICBarCodeRuleMapping([FProjectID],[FEntryID],[FKey],[FBarCodeName],[FTableName],[FListTableAlias],[FListColName],[FMustRule],[FRelTableName],[FRelPrimaryField],[FRelDisplayField],[FCtlType],[FBarCodeKey],[FDeleted])Values(@1DProjectID,1,'FAssetNumber','资产编码','','','',1,'','','','0','',0)ENDGOdeleteICBarCodeFieldMappingwhereFKey='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...
