insert单条与多条时,datetime处理问题 返回

SqlSugar 老数据
1 1487
该叫什么 Rookie 发布于2020/9/28
悬赏:5 飞吻

单条代码:StoreDb.Insert(storeEntities[0])

批量代码:StoreDb.AsInsertable(storeEntities).ExecuteCommand();


单条的sql:

INSERT INTO "TSTORE"
           ("SORTNAME","MODEL","NO","PRICE","XTIME","YTIME","CONTRACTNO","ROOMNO","RUSERID","RTIME","IP","SCRAPPED","TOOK","ID","MODIFYUSERID","MODIFYTIME","CREATORID","CREATETIME")
     VALUES
           (:SortName,:Model,:No,:Price,:XTime,:YTime,:ContractNo,:RoomNo,:RUserId,:RTime,:Ip,:Scrapped,:Took,:Id,:ModifyUserId,:ModifyTime,:CreatorId,:CreateTime)
{":SortName":"台式计算机",":Model":"fe1",":No":"xxxxx",":Price":2000,":XTime":"2020-09-01T00:00:00",":YTime":"2020-10-07T00:00:00",":ContractNo":"fr",":RoomNo":null,":RUserId":null,":RTime":null,":Ip":null,":Scrapped":0,":Took":0,":Id":"5d3838cf-4bfc-42a6-92d4-2b36a79a9663",":ModifyUserId":null,":ModifyTime":null,":CreatorId":"335",":CreateTime":"2020-09-28T11:24:38.9435269+08:00"}



批量的sql:

INTO "TSTORE"  ("SORTNAME","MODEL","NO","PRICE","XTIME","YTIME","CONTRACTNO","ROOMNO","RUSERID","RTIME","IP","SCRAPPED","TOOK","ID","MODIFYUSERID","MODIFYTIME","CREATORID","CREATETIME") VALUES(N'台式计算机',N'fe1',N'xxxxx',N'2000',to_date('2020-09-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS') ,to_date('2020-10-07 00:00:00', 'YYYY-MM-DD HH24:MI:SS') ,N'fr',NULL,NULL,NULL,NULL,N'0',N'0',N'0fcdf895-4c76-4008-b658-ab934c8b52e5',NULL,NULL,N'335',to_date('2020-09-28 11:26:11', 'YYYY-MM-DD HH24:MI:SS') )
INTO "TSTORE"  ("SORTNAME","MODEL","NO","PRICE","XTIME","YTIME","CONTRACTNO","ROOMNO","RUSERID","RTIME","IP","SCRAPPED","TOOK","ID","MODIFYUSERID","MODIFYTIME","CREATORID","CREATETIME") VALUES(N'台式计算机',N'fe1',N'fe1-20200928112543-1',N'2000',to_date('2020-09-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS') ,to_date('2020-10-07 00:00:00', 'YYYY-MM-DD HH24:MI:SS') ,N'fr',NULL,NULL,NULL,NULL,N'0',N'0',N'248a88f4-eb6c-4511-8013-d463ef1891d5',NULL,NULL,N'335',to_date('2020-09-28 11:26:11', 'YYYY-MM-DD HH24:MI:SS') )
SELECT 1 FROM DUAL


热忱回答1

  • 生成的SQL都没有问题,你可以给出具体的DEMO给我,你用CODEFIRST建表写个控制台的CS文件给我

    0 回复