SETQUOTED_IDENTIFIEROFFGOSETANSI_NULLSONGOALTERPROCEDUREMy_TIEMS(@vt_nameasnvarchar(100),--单据模板名称@siyearasnvarchar(4),--标准帐套年度@iiyearasnvarchar(4),--导入帐套年度@scacc_idasnvarchar(3),--标准帐套号@icacc_idasnvarchar(3)--导入帐套号)ASdeclare@vt_IDasnvarchar(8)--单据模板号declare@SDATEBASEasnvarchar(4000)--标准数据库名称declare@iDATEBASEasnvarchar(4000)--导入数据库名称declare@insert0asnvarchar(4000)declare@insert1asnvarchar(4000)declare@insert2asnvarchar(4000)declare@insert3asnvarchar(4000)declare@insert4asnvarchar(4000)declare@insert5asnvarchar(4000)SET@vt_ID=(selectVT_IDfromVoucherTemplates_langwherevt_name=@vt_name)SET@SDATEBASE='UFDATA_'+@siyear+'_'+@scacc_idSET@iDATEBASE='UFDATA_'+@iiyear+'_'+@icacc_idif@vt_ID=isnull(@vt_ID,'''')begin--（显示）set@insert0='INSERTINTO'+@iDATEBASE+'..voucheritems_base(VT_ID,CardNum,CardItemNum,CanNotSelect,ShowIt,LinkIt,LinkTbl,LinkField,TableName,FieldName,FieldType,ReferType,ReferTable,CardSection,CanModify,MaxLength,MaxShowLen,NumPoint,IsNull,CanDelete,UserCheck,UserPrompt,FormatChar,IsMain,NeedSum,CalcField,AliasNum,isSelfDef,COX,COY,Width,Height,TabIndex,DefaultValue,IsFixedLenght,FormatData,PrintCaption,PrintUpcase,PrintInterval,DataSource,EnterType,DataRule,ValidityCheck,ReserveSegTitlePos,BuildArchives,ReferReturnField,cmemo,nBorder,EnumType,IsEnum,EnumTypeString,bZeroAllowable,iFlags,vValueDefault)selectVT_ID,CardNum,CardItemNum,CanNotSelect,ShowIt,LinkIt,LinkTbl,LinkField,TableName,FieldName,FieldType,ReferType,ReferTable,CardSection,CanModify,MaxLength,MaxShowLen,NumPoint,IsNull,CanDelete,UserCheck,UserPrompt,FormatChar,IsMain,NeedSum,CalcField,AliasNum,isSelfDef,COX,COY,Width,Height,TabIndex,DefaultValue,IsFixedLenght,FormatData,PrintCaption,PrintUpcase,PrintInterval,DataSource,EnterType,DataRule,ValidityCheck,ReserveSegTitlePos,BuildArchives,ReferReturnField,cmemo,nBorder,EnumType,IsEnum,EnumTypeString,bZeroAllowable,iFlags,vValueDefaultfrom'+@sDATEBASE+'..voucheritems_basewherevt_id=@vt_ID'exec(@insert0)--（显示）set@insert1='INSERTINTO'+@iDATEBASE+'..vouchertemplates_lang(vt_id,localeid,vt_cardnumber,vt_name,vt_titlename,vt_titlefontstate,vt_foot,vt_gridstylehead,vt_gridstylebody,vt_gridstyletotal,vt_footheaderfont,vt_header)selectvt_id,localeid,vt_cardnumber,vt_name,vt_titlename,vt_titlefontstate,vt_foot,vt_gridstylehead,vt_gridstylebody,vt_gridstyletotal,vt_footheaderfont,vt_headerfrom'+@sDATEBASE+'..VoucherTemplates_langwherevt_id=@vt_ID'exec(@insert1)--（显示）set@insert2='INSERTINTO'+@iDATEBASE+'..vouchertemplates_base(VT_ID,VT_CardNumber,VT_TemplateMode,VT_Width,VT_Height,VT_BodyTop,VT_BodyLeft,VT_BodyWidth,VT_BodyHeight,VT_SelfDef1,VT_SelfDef2,VT_SelfDef3,VT_Memo,VT_Lock,VT_TitleTop,VT_TitleLeft,VT_PageHeader,VT_BodyFixedCols,VT_BodyMaxRows,VT_GridStyle,VT_WorkAreaColor,VT_FiexdColor,VT_TotalColor,VT_ControlStyle,VT_GridPrnRows,VT_GridPrnRowHeight,VT_PrintTemplID,VT_AutoCalc,VT_PageSubTotal,VT_PageTotal,VT_PrintGrid,nAutoCalcWidth,nPrintSeril,nPrintGridLine,varPrintSetting,VT_PRN_DEF_LANDID)selectVT_ID,VT_CardNumber,VT_TemplateMode,VT_Width,VT_Height,VT_BodyTop,VT_BodyLeft,VT_BodyWidth,VT_BodyHeight,VT_SelfDef1,VT_SelfDef2,VT_SelfDef3,VT_Memo,VT_Lock,VT_TitleTop,VT_TitleLeft,VT_PageHeader,VT_BodyFixedCols,VT_BodyMaxRows,VT_GridStyle,VT_WorkAreaColor,VT_FiexdColor,VT_TotalColor,VT_ControlStyle,VT_GridPrnRows,VT_GridPrnRowHeight,VT_PrintTemplID,VT_AutoCalc,VT_PageSubTotal,VT_PageTotal,VT_PrintGrid,nAutoCalcWidth,nPrintSeril,nPrintGridLine,varPrintSetting,VT_PRN_DEF_LANDIDfrom'+@SDATEBASE+'..vouchertemplates_basewherevt_id=@vt_ID'exec(@insert2)--(打印)set@insert3='INSERTINTO'+@iDATEBASE+'..voucheritems_lang(guid,localeid,vt_id,fieldname,cardsection,cardnum,carditemname,cardformula1,cardformula2,fontstate)selectguid,localeid,vt_id,fieldname,cardsection,cardnum,carditemname,cardformula1,cardformula2,fontstatefrom'+@sDATEBASE+'..voucheritems_langwherevt_id=@vt_ID'exec(@insert3)--(打印)set@insert4='INSERTINTO'+@iDATEBASE+'..voucheritems_prn_lang(guid,localeid,vt_id,fieldname,cardsection,cardnum,carditemname,cardformula1,cardformula2,fontstate)selectguid,localeid,vt_id,fieldname,cardsection,cardnum,carditemname,cardformula1,cardformula2,fontstatefrom'+@sDATEBASE+'..voucheritems_prn_langwherevt_id=@vt_ID'exec(@insert4)--(打印)set@insert5='INSERTINTO'+@iDATEBASE+'..voucheritems_prn_base(VT_ID,CardNum,CardItemNum,CanNotSelect,ShowIt,LinkIt,LinkTbl,LinkField,TableName,FieldName,FieldType,ReferType,ReferTable,CardSection,CanModify,MaxLength,MaxShowLen,NumPoint,IsNull,CanDelete,UserCheck,UserPrompt,FormatChar,IsMain,NeedSum,CalcField,AliasNum,isSelfDef,COX,COY,Width,Height,TabIndex,DefaultValue,IsFixedLenght,FormatData,PrintCaption,PrintUpcase,PrintInterval,DataSource,EnterType,DataRule,ValidityCheck,ReserveSegTitlePos,BuildArchives,nBorder,ReferReturnField,cmemo,EnumType,IsEnum,EnumTypeString,bZeroAllowable,iFlags,vValueDefault)selectVT_ID,CardNum,CardItemNum,CanNotSelect,ShowIt,LinkIt,LinkTbl,LinkField,TableName,FieldName,FieldType,ReferType,ReferTable,CardSection,CanModify,MaxLength,MaxShowLen,NumPoint,IsNull,CanDelete,UserCheck,UserPrompt,FormatChar,IsMain,NeedSum,CalcField,AliasNum,isSelfDef,COX,COY,Width,Height,TabIndex,DefaultValue,IsFixedLenght,FormatData,PrintCaption,PrintUpcase,PrintInterval,DataSource,EnterType,DataRule,ValidityCheck,ReserveSegTitlePos,BuildArchives,nBorder,ReferReturnField,cmemo,EnumType,IsEnum,EnumTypeString,bZeroAllowable,iFlags,vValueDefaultfrom'+@sDATEBASE+'..voucheritems_prn_basewherevt_id=@vt_ID'exec(@insert5)endGOSETQUOTED_IDENTIFIEROFFGOSETANSI_NULLSONGO
