grid组件

MENG1 · 发表于 2020-4-2 15:34:39

本帖最后由 MENG1 于 2020-4-20 14:09 编辑

jishuang · 发表于 2020-4-2 16:41:54

data中的数据是怎么来的？标准的queryAction查询的？

MENG1 · 发表于 2020-4-2 16:47:30

select TALENT_PLAN.*,TALENT_FILLIN,TALENT_FILLIN.version as version,TALENT_FILLIN.DEPT as DEPT,TALENT_FILLIN.FINISHTIME as FINISHTIME,TALENT_FILLIN.IMPLEMENTATION_PLAN as IMPLEMENTATION_PLAN,TALENT_FILLIN.PROGRESS1 as PROGRESS1,TALENT_FILLIN.PROGRESS2 as PROGRESS2,TALENT_FILLIN.PROGRESS3 as PROGRESS3,TALENT_FILLIN.PROGRESS4 as PROGRESS4,TALENT_FILLIN.PROGRESS5 as PROGRESS5,TALENT_FILLIN.PROGRESS6 as PROGRESS6,TALENT_FILLIN.YEAR as YEAR
from TALENT_PLAN TALENT_PLAN
optional join TALENT_FILLIN TALENT_FILLIN on TALENT_PLAN.PCODE = TALENT_FILLIN.PCODE
关联查询的两个表的内容

jishuang · 发表于 2020-4-2 17:24:39

确认主键值是不是重复了，先把sql打印出来到数据库中执行看结果

http://bbs.wex5.com/forum.php?mo ... 4&pid=165004035

MENG1 · 发表于 2020-4-6 15:08:15

SELECT  TALENT_FILLIN.DEPT AS DEPT, TALENT_FILLIN.FINISHTIME AS FINISHTIME, TALENT_PLAN.ID AS ID, TALENT_FILLIN.IMPLEMENTATION_PLAN AS IMPLEMENTATION_PLAN,
TALENT_PLAN.KEYWORK AS KEYWORK, TALENT_PLAN.MAINPLAN AS MAINPLAN, TALENT_PLAN.MAIN_MEASURE AS MAIN_MEASURE, TALENT_PLAN.NEXTYEAR_ARRANGEMENT AS NEXTYEAR_ARRANGEMENT,
TALENT_PLAN.PCODE AS PCODE, TALENT_PLAN.PROGRAMME AS PROGRAMME, TALENT_FILLIN.PROGRESS1 AS PROGRESS1, TALENT_FILLIN.PROGRESS2 AS PROGRESS2, TALENT_FILLIN.PROGRESS3 AS PROGRESS3,
TALENT_FILLIN.PROGRESS4 AS PROGRESS4, TALENT_FILLIN.PROGRESS5 AS PROGRESS5, TALENT_FILLIN.PROGRESS6 AS PROGRESS6, TALENT_PLAN.PTYPE AS PTYPE, TALENT_PLAN.RESPDEPT AS RESPDEPT,
TALENT_PLAN.RESPTYPE AS RESPTYPE, TALENT_FILLIN.RCODE, TALENT_PLAN.fID AS TALENT_PLAN, TALENT_FILLIN.YEAR AS YEAR, TALENT_PLAN.YEARS AS YEARS, TALENT_PLAN.FCURDEPT AS fCurdept,
TALENT_PLAN.VERSION AS version FROM TALENT_PLAN TALENT_PLAN LEFT JOIN TALENT_FILLIN TALENT_FILLIN ON  (TALENT_PLAN.PCODE = TALENT_FILLIN.PCODE) AND (TALENT_PLAN.FCURDEPT = TALENT_FILLIN.DEPT)
WHERE TALENT_PLAN.PTYPE =  ? ORDER BY PCODE ASC, ID ASC
用这个查出来的就是正确的
SELECT  TALENT_FILLIN.DEPT AS DEPT, TALENT_FILLIN.FINISHTIME AS FINISHTIME, TALENT_PLAN.ID AS ID, TALENT_FILLIN.IMPLEMENTATION_PLAN AS IMPLEMENTATION_PLAN,
TALENT_PLAN.KEYWORK AS KEYWORK, TALENT_PLAN.MAINPLAN AS MAINPLAN, TALENT_PLAN.MAIN_MEASURE AS MAIN_MEASURE, TALENT_PLAN.NEXTYEAR_ARRANGEMENT AS NEXTYEAR_ARRANGEMENT,
TALENT_PLAN.PCODE AS PCODE, TALENT_PLAN.PROGRAMME AS PROGRAMME, TALENT_FILLIN.PROGRESS1 AS PROGRESS1, TALENT_FILLIN.PROGRESS2 AS PROGRESS2, TALENT_FILLIN.PROGRESS3 AS PROGRESS3,
TALENT_FILLIN.PROGRESS4 AS PROGRESS4, TALENT_FILLIN.PROGRESS5 AS PROGRESS5, TALENT_FILLIN.PROGRESS6 AS PROGRESS6, TALENT_PLAN.PTYPE AS PTYPE, TALENT_PLAN.RESPDEPT AS RESPDEPT,
TALENT_PLAN.RESPTYPE AS RESPTYPE, TALENT_FILLIN.RCODE, TALENT_PLAN.fID AS TALENT_PLAN, TALENT_FILLIN.YEAR AS YEAR, TALENT_PLAN.YEARS AS YEARS, TALENT_PLAN.FCURDEPT AS fCurdept,
TALENT_PLAN.VERSION AS version FROM TALENT_PLAN TALENT_PLAN LEFT JOIN TALENT_FILLIN TALENT_FILLIN ON TALENT_PLAN.PCODE = TALENT_FILLIN.PCODE  WHERE  (TALENT_PLAN.PTYPE =  ? )
AND (TALENT_FILLIN.DEPT LIKE ?) AND (TALENT_FILLIN.YEAR =  ? ) ORDER BY PCODE ASC, ID ASC
这个查出来就是乱的

jishuang · 发表于 2020-4-7 09:48:58

确认主键值是不是重复了

MENG1 · 发表于 2020-4-8 11:21:20

没有重复，一个是fID,一个是RCODE

jishuang · 发表于 2020-4-8 11:41:27

把table的内容输出发一下
http://bbs.wex5.com/forum.php?mo ... 6&pid=165049439

MENG1 · 发表于 2020-4-8 14:24:37

什么意思啊，看不明白，
这种错误可能是什么原因呢，我都试一下

jishuang · 发表于 2020-4-8 16:17:09

把查询出来的数据发一下啊，很有可能就是关联查询导致的主键值重复了
不是你是的fid和code重复

是一个fid的值出现了多次

		自动登录	找回密码
密码			注册

[处理中3] grid组件