InsertOrUpdate操作失败,因为表CustomerCarData中不存在主键 返回
SqlSugar
老数据
1
3472
悬赏:5 飞吻
如题 , body中为插入数据
请求参数:{"body":{"Sysno":0,"CustomerID":1,"BrandID":8,"BrandName":"本田","PlateNum":"京C123","ColorCode":"#800080","ColorName":"紫色","Models":1,"Status":1,"InDate":"2017-04-10T23:07:51.0378253+08:00","EditDate":"2017-04-10T23:07:51.0378253+08:00"},"header":{"uid":1,"device":0}}下面是生成的表sql语句,不知道为什么报错
CREATE TABLE [dbo].[T_Cutomer_Car]( [Sysno] [bigint] IDENTITY(1,1) NOT NULL, [CustomerID] [bigint] NOT NULL, [BrandID] [int] NOT NULL, [PlateNum] [nchar](10) NOT NULL, [ColorCode] [varchar](7) NOT NULL, [ColorName] [nvarchar](10) NOT NULL, [Models] [tinyint] NOT NULL, [LastServiceDate] [datetime] NULL, [Status] [tinyint] NOT NULL, [InDate] [datetime] NOT NULL, [InUser] [nvarchar](50) NOT NULL, [EditDate] [datetime] NOT NULL, [EditUser] [nvarchar](50) NOT NULL, CONSTRAINT [PK_T_Cutomer_Car] PRIMARY KEY CLUSTERED ( [Sysno] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] ) ON [PRIMARY]
热忱回答(1)
-
小杰 VIP0
2017/4/13该方法需要主键
0 回复