|
楼主 |
发表于 2018-11-19 23:19:48
|
显示全部楼层
本帖最后由 metatron 于 2018-11-19 23:31 编辑
打开sql监视的结果,如下,出问题的两个字段是SinglePrice和Type。我在表单里写了数据,但是存储的时候就写成了null,而且编辑的时候这两个字段修改完成后确定,保存的按钮是无法操作的,只有其他字段的值发生变化才可以
2018-11-19 23:23:23 [SQL Time]sql 执行时间:43ms, exec KSQL: INSERT INTO HU_CarInfo HU_CarInfo(HU_CarInfo, HU_CarInfo.version, HU_CarInfo.CarNo, HU_CarInfo.CarStatus, HU_CarInfo.EqName, HU_CarInfo.InGarage, HU_CarInfo.Maintenance, HU_CarInfo.SinglePrice, HU_CarInfo.Specification, HU_CarInfo.Type, HU_CarInfo.UpdateTime) VALUES (:HU_CarInfo, :version, :CarNo, :CarStatus, :EqName, :InGarage, :Maintenance, :SinglePrice, :Specification, :Type, :UpdateTime)
--> sql:INSERT INTO HU_CARINFO (HU_CARINFO.fID, HU_CARINFO.VERSION, HU_CARINFO.CARNO, HU_CARINFO.CARSTATUS, HU_CARINFO.EQNAME, HU_CARINFO.INGARAGE, HU_CARINFO.MAINTENANCE, HU_CARINFO.SINGLEPRICE, HU_CARINFO.SPECIFICATION, HU_CARINFO.TYPE, HU_CARINFO.UPDATETIME) VALUES ( ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? )
--> binds:[D9A58BEFFB304591B7D10C1A50E02190, 0, 123, 可预约, 3123, null, system, null, 23, null, 2018-11-19]
2018-11-19 23:23:25 [SQL Time]sql 执行时间:20ms, exec KSQL: SELECT HU_CarInfo.* FROM HU_CarInfo HU_CarInfo WHERE ((HU_CarInfo='D9A58BEFFB304591B7D10C1A50E02190')) LIMIT 0, 20
--> sql:SELECT HU_CarInfo.CARNO AS CarNo, HU_CarInfo.CARSTATUS AS CarStatus, HU_CarInfo.EQNAME AS EqName, HU_CarInfo.fID AS HU_CarInfo, HU_CarInfo.INGARAGE AS InGarage, HU_CarInfo.MAINTENANCE AS Maintenance, HU_CarInfo.SINGLEPRICE AS SinglePrice, HU_CarInfo.SPECIFICATION AS Specification, HU_CarInfo.TYPE AS Type, HU_CarInfo.UPDATETIME AS UpdateTime FROM HU_CARINFO HU_CarInfo WHERE HU_CarInfo.fID = ?
--> binds:[D9A58BEFFB304591B7D10C1A50E02190]
2018-11-19 23:23:26 [SQL Time]sql 执行时间:20ms, exec KSQL:
--> sql:SELECT count(*) FROM HU_CARINFO HU_CarInfo WHERE HU_CarInfo.fID = ?
--> binds:[D9A58BEFFB304591B7D10C1A50E02190]
|
|