畅捷通T+ 往来单位编码问题,项目编码和名称字符，往来单位名称，长度改到500字符.

畅捷通T+ 往来单位编码错乱，使用人换了几个，编码就加的乱的很，需要重新整理一下编码。 批量整理
将客户账套中往来单位编码进行批量修改，统一改成“000”+ 1、2、3。。。这种形式，
请执行下面的脚本之前，先备份客户账套，备份以后再执行下面的sql，然后重启服务即可

DECLARE @index INT SET @index = 1 DECLARE @partnerid INT DECLARE My_Cursor CURSOR FOR (SELECT id FROM dbo.AA_PartnerEntity) OPEN My_Cursor FETCH NEXT FROM My_Cursor INTO @partnerid WHILE @@FETCH_STATUS = 0 BEGIN UPDATE dbo.AA_PartnerEntity SET code = '000' + CAST(@index AS VARCHAR(5)) WHERE id = @partnerid SET @index = @index + 1 FETCH NEXT FROM My_Cursor INTO @partnerid END CLOSE My_Cursor DEALLOCATE My_Cursor
————由李高深编写

项目编码和名称字符，往来单位名称，长度改到500字符.
在客户账套数据库执行下面的脚本，然后重启服务即可
UPDATE dbo.eap_DTOProperty SET FieldLength = 500 WHERE idDTO = (SELECT id FROM dbo.eap_DTO WHERE Name = 'ProjectDTO') AND Name IN ('Name','Code') UPDATE dbo.eap_VoucherControls SET MaxLength = 500 WHERE VoucherID = (SELECT ID FROM dbo.eap_Voucher WHERE Name = 'Project') AND Name IN ('Code','Name') UPDATE dbo.eap_DTOProperty SET FieldLength = 500 WHERE idDTO = (SELECT id FROM dbo.eap_DTO WHERE Name = 'PartnerDTO') AND Name = 'Name' UPDATE dbo.eap_VoucherControls SET MaxLength = 500 WHERE VoucherID = (SELECT ID FROM dbo.eap_Voucher WHERE Name = 'Partner') AND Name = 'Name' ALTER TABLE dbo.AA_Project ALTER COLUMN Code NVARCHAR(500) ALTER TABLE dbo.AA_Project ALTER COLUMN Name NVARCHAR(500) ALTER TABLE dbo.AA_PartnerEntity ALTER COLUMN name NVARCHAR(500)
————由李高深编写