/*生成客户
*/
INSERT INTO t_Item(FItemClassID, FParentID, FLevel, FName, FNumber, FShortNumber, FFullNumber,FFullName, FDetail, FDeleted)
VALUES(1, 0, 1, '张三经济', '张三经济', '张三经济', '张三经济','张三经济', 1, 0);

INSERT INTO dbo.t_Organization(FShortNumber,FNumber,FName,FParentID,FItemID,FProvinceID,FCityID,FStatus,FSaleID,FValueAddRate,FminForeReceiveRate,
 FminReserverate,FCyID,FSetID,FRegionID,FTrade,FRegion,FPayCondition)
SELECT FShortNumber,FNumber,FName,FParentID,FItemID,0,0,1072,0,17,1,1,0,0,0,0,0,0 FROM dbo.t_Item WHERE FItemClassID=1 AND FNumber='张三经济'

【emoji】