datatables列表的数据一刷新就没了。

liuqiang221

datatables列表的数据添加成功后，再一刷新界面表列的数据就没了。这怎么回事呢？

jishuang

新增的数据要保存后再刷新

liuqiang221

jishuang 发表于 2017-4-21 10:19
新增的数据要保存后再刷新

能说的具体点吗？我点新增按钮，然后填完数据，保存了，保存后列表显示了数据，然后我再一刷新列表数据就没了。

jishuang

数据库中数据保存进行了吗？


http://bbs.wex5.com/forum.php?mo ... 4&pid=165004035把sql打出来，看看刷新的时候执行的sql是什么

liuqiang221

jishuang 发表于 2017-4-21 13:37
数据库中数据保存进行了吗？

  执行了一下代码：但是查不出数据。 SELECT Basic_childproject.ID AS Basic_childproject,
     Basic_childproject.COMPLETENODE AS CompleteNode,
      Basic_childproject.CREATEDATE AS CreateDate,
      Basic_childproject.CREATEUSER AS CreateUser,
       Basic_childproject.MODIFYDATE AS ModifyDate,
       Basic_childproject.MODIFYUSER AS ModifyUser,
       Basic_totalproject.PROJECTYEAR AS ProjectYear,
       Basic_totalproject.THEBUDGET AS TheBudget,
        Basic_totalproject.TOTALBUDGET AS TotalBudget,
         Basic_childproject.CHILDPROJECTNAME AS childprojectname,
          Basic_totalproject.TOTALPROJECTNAME AS totalprojectname
           FROM basic_childproject Basic_childproject
           JOIN basic_totalproject Basic_totalproject ON Basic_childproject.TOTALPROJECTID = Basic_totalproject.ID
           JOIN basic_employee Basic_employee ON Basic_childproject.PROJECTLEADERID = Basic_employee.ID
           JOIN basic_employee Basic_employee_3 ON Basic_childproject.OPERATIONALTASKFORCEID = Basic_employee_3.ID
           JOIN basic_employee Basic_employee_4 ON Basic_childproject.HEADQUARTERSPARTYACONTROLPMID = Basic_employee_4.ID
           JOIN basic_employee Basic_employee_5 ON Basic_childproject.HEADQUARTERSPARTYBCONTROLPMID = Basic_employee_5.ID

jishuang

那是sql拼的不正确

确认
     FROM basic_childproject Basic_childproject
           JOIN basic_totalproject Basic_totalproject ON Basic_childproject.TOTALPROJECTID = Basic_totalproject.ID
           JOIN basic_employee Basic_employee ON Basic_childproject.PROJECTLEADERID = Basic_employee.ID
           JOIN basic_employee Basic_employee_3 ON Basic_childproject.OPERATIONALTASKFORCEID = Basic_employee_3.ID
           JOIN basic_employee Basic_employee_4 ON Basic_childproject.HEADQUARTERSPARTYACONTROLPMID = Basic_employee_4.ID
           JOIN basic_employee Basic_employee_5 ON Basic_childproject.HEADQUARTERSPARTYBCONTROLPMID = Basic_employee_5.ID

这些关联查询设置的都这个正确吗？


http://docs.wex5.com/bex5-server-question-list-10011/