T+软件账号已被删除，不允许操作！

【问题现象】

费用单现结金额中无法选择现金的现结方式，【基础设置】-【结算方式】现金点进去，提示“账号已被删除，不允许操作！账号的id为1！请重新选择修改的账号。

【操作步骤】

1、在账套维护工具中备份好账套数据。

2、在数据库中执行语句，把现金账号补回。

SET IDENTITY_INSERT dbo.AA_BankAccount ON

IF NOT EXISTS(SELECT 1 FROM dbo.AA_BankAccount WHERE id = 1)

INSERT INTO dbo.AA_BankAccount(

id,code,name,bankNo,disabled,updatedBy,

isusingdeficitcontrol,isusingbankcheck,NewBalance_Abandon,VirtualPay,idcurrency,

iddepartment,idMarketingOrgan,balancedirection,bankName,bankNoType,

madeDate,updated,dateofusingbankcheck,createdTime,WeixinAppID,

WeixinPayKey,AlipayServiceNo,AlipayAppID,WeiXinMerchantNo,WeiXinServiceNo,

WeiXinServiceAPPID,AlipayPublicKey,MerchantPublicKey,MerchantPrivateKey,EncryptionMethod,

imageFile,AlipayServiceAppID)

VALUES(

1,'现金','现金','现金',0,NULL,

0,0,0,0,4,

NULL,1,NULL,NULL,309,

'2009-03-31 17:37:06.000','2009-03-31 17:37:06.000',NULL,'2009-03-31 17:37:06.000',NULL,

NULL,NULL,NULL,NULL,NULL,

NULL,NULL,NULL,NULL,NULL,

NULL,NULL)

IF NOT EXISTS(SELECT 1 FROM dbo.AA_BankAccount_Balance WHERE idBankAccount = 1)

INSERT INTO dbo.AA_BankAccount_Balance(

idBankAccount,NewBalance,updatedBy,updated,Creater,createdTime)

VALUES(

1,0,NULL,dbo.getdate(),NULL,dbo.getdate()

)

SET IDENTITY_INSERT dbo.AA_BankAccount OFF