页面新增保存记录，点击刷新按钮，记录没了。数据库里有

一诺佳人

您好！页面新增保存记录，点击刷新按钮，记录没了。数据库里有。这个是哪里没有处理到。请指导下
同时，新增记录时，为什么总是从第一行记录开始新增？

一诺佳人

新增记录时，为什么总是从第一行开始？怎么样让接在最后一行新增？

jishuang

1.把sql语句打出来看看语句正确吗？
http://bbs.wex5.com/forum.php?mo ... 4&pid=165004035
2.平台默认是新增的最后的没如果是新增到第一个应该是自己在新增的时候设置了index为0 ，看新增相关的设置

一诺佳人

1. 2017-05-24 14:10:39 [SQL Time]sql 执行时间：1ms, exec KSQL: SELECT articleInfor.*  FROM articleInfor articleInfor LIMIT 0, 20
   
2.   --> sql:SELECT  articleInfor.fID AS articleInfor, articleInfor.FARTICLENAME AS fArticleName, articleInfor.FARTICLETYPE AS fArticleType, articleInfor.FPRICE AS fPrice, articleInfor.FREMARK AS fRemark, articleInfor.FUNIT AS fUnit, articleInfor.VERSION AS version FROM ARTICLEINFOR articleInfor
   
3. --> binds:[]
   
4. 2017-05-24 14:10:39 [SQL Time]sql 执行时间：1ms, exec KSQL:
   
5.   --> sql:SELECT count(*) FROM ARTICLEINFOR articleInfor
   
6. --> binds:[]
   
7. 2017-05-24 14:10:39 [SQL Time]sql 执行时间：3ms, exec KSQL: SELECT basicDetail.*,basicMain.fBasicType as fBasicType  FROM basicDetail basicDetail  join basicMain basicMain on basicDetail.fMainID = basicMain WHERE ((basicMain.fBasicType ='物品类别')) LIMIT 0, 20
   
8.   --> sql:SELECT  basicDetail.fID AS basicDetail, basicDetail.FBASICNAME AS fBasicName, basicMain.FBASICTYPE AS fBasicType, basicDetail.FMAINID AS fMainID, basicDetail.FNO AS fNo, basicDetail.FREMARK AS fRemark, basicDetail.VERSION AS version FROM BASICDETAIL basicDetail JOIN BASICMAIN basicMain ON basicDetail.FMAINID = basicMain.fID  WHERE basicMain.FBASICTYPE = ?
   
9. --> binds:[物品类别]
   
10. 2017-05-24 14:10:39 [SQL Time]sql 执行时间：3ms, exec KSQL:
    
11.   --> sql:SELECT count(*) FROM BASICDETAIL basicDetail JOIN BASICMAIN basicMain ON basicDetail.FMAINID = basicMain.fID  WHERE basicMain.FBASICTYPE = ?
    
12. --> binds:[物品类别]
    
13. 2017-05-24 14:10:39 [SQL Time]sql 执行时间：1ms, exec KSQL: SELECT basicDetail.*,basicMain.fBasicType as fBasicType  FROM basicDetail basicDetail  join basicMain basicMain on basicDetail.fMainID = basicMain WHERE ((basicMain.fBasicType ='计量单位')) LIMIT 0, 20
    
14.   --> sql:SELECT  basicDetail.fID AS basicDetail, basicDetail.FBASICNAME AS fBasicName, basicMain.FBASICTYPE AS fBasicType, basicDetail.FMAINID AS fMainID, basicDetail.FNO AS fNo, basicDetail.FREMARK AS fRemark, basicDetail.VERSION AS version FROM BASICDETAIL basicDetail JOIN BASICMAIN basicMain ON basicDetail.FMAINID = basicMain.fID  WHERE basicMain.FBASICTYPE = ?
    
15. --> binds:[计量单位]
    
16. 2017-05-24 14:10:39 [SQL Time]sql 执行时间：0ms, exec KSQL:
    
17.   --> sql:SELECT count(*) FROM BASICDETAIL basicDetail JOIN BASICMAIN basicMain ON basicDetail.FMAINID = basicMain.fID  WHERE basicMain.FBASICTYPE = ?
    
18. --> binds:[计量单位]
    
19. 2017-05-24 14:11:19 [SQL Time]sql 执行时间：1ms, exec KSQL: INSERT INTO partnerCompany partnerCompany(partnerCompany, partnerCompany.version, partnerCompany.fpartnerArea, partnerCompany.fpartnerGrade, partnerCompany.fpartnerName, partnerCompany.fpartnerType) VALUES (:partnerCompany, :version, :fpartnerArea, :fpartnerGrade, :fpartnerName, :fpartnerType)
    
20.   --> sql:INSERT INTO PARTNERCOMPANY (PARTNERCOMPANY.fID, PARTNERCOMPANY.VERSION, PARTNERCOMPANY.FPARTNERAREA, PARTNERCOMPANY.FPARTNERGRADE, PARTNERCOMPANY.FPARTNERNAME, PARTNERCOMPANY.FPARTNERTYPE) VALUES ( ? ,  ? ,  ? ,  ? ,  ? ,  ? )
    
21. --> binds:[06264F9884184D59A70C6439CF3006F9, 0, 蜀国, B级伙伴, 一汽大众, 供应商]
    
22. 2017-05-24 14:11:20 [SQL Time]sql 执行时间：2ms, exec KSQL: SELECT partnerCompany.*  FROM partnerCompany partnerCompany WHERE (partnerCompany.fpartnerType ='客户') LIMIT 0, 20
    
23.   --> sql:SELECT  partnerCompany.FPARTNERAREA AS fpartnerArea, partnerCompany.FPARTNERGRADE AS fpartnerGrade, partnerCompany.FPARTNERNAME AS fpartnerName, partnerCompany.FPARTNERTYPE AS fpartnerType, partnerCompany.fID AS partnerCompany, partnerCompany.VERSION AS version FROM PARTNERCOMPANY partnerCompany  WHERE partnerCompany.FPARTNERTYPE = ?
    
24. --> binds:[客户]
    
25. 2017-05-24 14:11:20 [SQL Time]sql 执行时间：4ms, exec KSQL:
    
26.   --> sql:SELECT count(*) FROM PARTNERCOMPANY partnerCompany  WHERE partnerCompany.FPARTNERTYPE = ?
    
27. --> binds:[客户]

复制代码

第一个问题。执行KSQL描述
第二个问题，请问INDEX在哪里设置？我没有设置过index。怎么修改默认index

jishuang

SELECT  partnerCompany.FPARTNERAREA AS fpartnerArea, partnerCompany.FPARTNERGRADE AS fpartnerGrade, partnerCompany.FPARTNERNAME AS fpartnerName, partnerCompany.FPARTNERTYPE AS fpartnerType, partnerCompany.fID AS partnerCompany, partnerCompany.VERSION AS version FROM PARTNERCOMPANY partnerCompany  WHERE partnerCompany.FPARTNERTYPE = '客户'
到数据库中执行看看查出几条数据


在.w和js中搜一下newData看看什么地方设置的

一诺佳人

1、执行查询语句的结果，都有。就是也页面不显示。奇怪。我的概念里面，客商类型增加了个默认值。应该没有问题的才对。
2、w和JS里，我没有新增newData,找不到这个东东。

jishuang

1.WHERE partnerCompany.FPARTNERTYPE = '客户'就2条数据啊，页面中显示的也是两条数据啊

2.肯定有没有新增怎么执行的

一诺佳人

问题1.我找到问题解决了。
问题2.怎么检查，我真没有修改INDEX值。

jishuang

把.w和js文件发一下

一诺佳人

1. <?xml version="1.0" encoding="utf-8"?>
   
2. 
   
3. <div xmlns="http://www.w3.org/1999/xhtml" component="$UI/system/components/justep/window/window" xid="window" design="device:pc;">  
   
4.   <div component="$UI/system/components/justep/model/model" xid="model" style="height:auto;top:185px;left:372px;">
   
5.     <div component="$UI/system/components/justep/data/bizData" xid="mainData"
   
6.       directDelete="true" autoLoad="true" concept="partnerCompany" columns=""
   
7.       onSaveCommit="saveCommit" limit="20">
   
8.       <reader action="/DEMOERP/DEMOERP/logic/action/queryPartnerCompanyAction"/>  
   
9.       <writer action="/DEMOERP/DEMOERP/logic/action/savePartnerCompanyAction"/>  
   
10.       <creator action="/DEMOERP/DEMOERP/logic/action/createPartnerCompanyAction"/>  
    
11.       <calculateRelation relation="calcCheckBox"/>
    
12.     </div>
    
13.   <div component="$UI/system/components/justep/data/bizData" autoLoad="true" xid="typeData" concept="basicDetail" orderBy="fNo asc"><reader xid="default1" action="/DEMOERP/DEMOERP/logic/action/queryBasicDetailAction"></reader>
    
14.   <filter name="filter0" xid="filter1"><![CDATA[ basicMain.fBasicType ='客商类别']]></filter></div>
    
15.   <div component="$UI/system/components/justep/data/bizData" autoLoad="true" xid="areaData" concept="basicDetail" orderBy="fNo asc"><reader xid="default6" action="/DEMOERP/DEMOERP/logic/action/queryBasicDetailAction"></reader>
    
16.   <filter name="filter1" xid="filter2"><![CDATA[ basicMain.fBasicType ='客商区域']]></filter></div>
    
17.   <div component="$UI/system/components/justep/data/bizData" autoLoad="true" xid="gradeData" concept="basicDetail" orderBy="fNo asc"><reader xid="default7" action="/DEMOERP/DEMOERP/logic/action/queryBasicDetailAction"></reader>
    
18.   <filter name="filter2" xid="filter3"><![CDATA[ basicMain.fBasicType ='客商级别']]></filter></div></div>  
    
19.   <div xid="view">
    
20.     <div component="$UI/system/components/justep/toolBar/toolBar" class="x-toolbar x-toolbar-spliter form-inline"
    
21.       xid="bar">
    
22.       <div component="$UI/system/components/justep/smartFilter/smartFilter"
    
23.         xid="smartFilter1" filterData="mainData" filterCols="fpartnerName,fpartnerType,fpartnerArea,fpartnerGrade"
    
24.         class="pull-right">
    
25.         <input type="text" class="form-control" placeholder="搜索" data-bind="valueUpdate: ['input', 'afterkeydown']"
    
26.           bind-value="$model.comp($element.parentElement).searchText" bind-change="$model.comp($element.parentElement).onInputChange.bind($model.comp($element.parentElement))"
    
27.           xid="input1"/>
    
28.       </div>  
    
29.       <a component="$UI/system/components/justep/button/button" label=" 新建"
    
30.         class="btn btn-link btn-icon-left" icon="icon-plus" onClick="{&quot;operation&quot;:&quot;mainData.new&quot;, args:{index:'js:0'}}"
    
31.         xid="newBtn">
    
32.         <i class="icon-plus"/>  
    
33.         <span>新建</span>
    
34.       </a>  
    
35.       <a component="$UI/system/components/justep/button/button" class="btn btn-link btn-icon-left"
    
36.         label="保存" xid="saveBtn" onClick='{"operation":"mainData.save"}'>
    
37.         <i xid="i3"/>  
    
38.         <span xid="label7">保存</span>
    
39.       </a>  
    
40.       <a component="$UI/system/components/justep/button/button" class="btn btn-link btn-icon-left"
    
41.         label="删除" xid="deleteBtn" onClick='{"operation":"mainData.delete"}'>
    
42.         <i xid="i4"/>  
    
43.         <span xid="span7">删除</span>
    
44.       </a>  
    
45.       <a component="$UI/system/components/justep/button/button" class="btn btn-link btn-icon-left"
    
46.         xid="refreshBtn" onClick='{"operation":"mainData.refresh"}' label="刷新">
    
47.         <i xid="i2"/>  
    
48.         <span xid="span2">刷新</span>
    
49.       </a>  
    
50.       <a component="$UI/system/components/justep/button/button" class="btn btn-link btn-icon-left"
    
51.         label="查询" xid="filterBtn" icon="icon-android-search" onClick="{operation:'bizFilter.menu'}">
    
52.         <i xid="i5" class="icon-android-search"/>  
    
53.         <span xid="span8">查询</span>
    
54.       </a>
    
55.     </div>  
    
56.     <div component="$UI/system/components/justep/grid/grid" xid="mainGrid"
    
57.       data="mainData" width="100%" hiddenCaptionbar="true" height="auto" class="x-grid-no-bordered" showRowNumber="true" rowNumberWidth="60">
    
58.       <columns xid="column">
    
59.         <column name="fpartnerName" editable="true">
    
60.           <editor>
    
61.             <input component="$UI/system/components/justep/input/input" class="form-control"
    
62.               bind-ref="ref('fpartnerName')"/>
    
63.           </editor>
    
64.         </column>
    
65.         <column name="fpartnerType" editable="true">
    
66.           <editor>
    
67.             <div class="x-gridSelect" component="$UI/system/components/justep/gridSelect/gridSelect" xid="gridSelect1" bind-ref='$model.mainData.ref("fpartnerType")' bind-labelRef='$model.mainData.ref("fpartnerType")'>
    
68.    <option xid="option1" data="typeData" value="fBasicName" label="fBasicName"></option></div></editor>
    
69.         </column>
    
70.         <column name="fpartnerArea" editable="true">
    
71.           <editor>
    
72.             <div class="x-gridSelect" component="$UI/system/components/justep/gridSelect/gridSelect" xid="gridSelect3" bind-ref='$model.mainData.ref("fpartnerArea")' bind-labelRef='$model.mainData.ref("fpartnerArea")'>
    
73.    <option xid="option3" data="areaData" value="fBasicName" label="fBasicName"></option></div></editor>
    
74.         </column>
    
75.         <column name="fpartnerGrade" editable="true">
    
76.           <editor>
    
77.             <div class="x-gridSelect" component="$UI/system/components/justep/gridSelect/gridSelect" xid="gridSelect2" bind-ref='$model.mainData.ref("fpartnerGrade")' bind-labelRef='$model.mainData.ref("fpartnerGrade")'>
    
78.    <option xid="option2" data="gradeData" value="fBasicName" label="fBasicName"></option></div></editor>
    
79.         </column>
    
80.       </columns>
    
81.     </div>
    
82.   </div>  
    
83.   <span component="$UI/system/components/justep/bizFilter/bizFilter" xid="bizFilter"
    
84.     filterData="mainData" style="left:28px;top:290px;"/>  
    
85.   <div component="$UI/system/components/justep/pagerBar/pagerBar" class="x-pagerbar container-fluid"
    
86.     xid="pagerBar" data="mainData">
    
87.     <div class="row" xid="div1">
    
88.       <div class="col-sm-3" xid="div2">
    
89.         <div class="x-pagerbar-length" xid="div3">
    
90.           <label component="$UI/system/components/justep/pagerLimitSelect/pagerLimitSelect"
    
91.             class="x-pagerlimitselect" xid="pagerLimitSelect1">
    
92.             <span xid="span1">显示</span>  
    
93.             <select component="$UI/system/components/justep/select/select" class="form-control input-sm"
    
94.               xid="select1">
    
95.               <option value="10" xid="default2">10</option>  
    
96.               <option value="20" xid="default3">20</option>  
    
97.               <option value="50" xid="default4">50</option>  
    
98.               <option value="100" xid="default5">100</option>
    
99.             </select>  
    
100.             <span xid="span3">条</span>
     
101.           </label>
     
102.         </div>
     
103.       </div>  
     
104.       <div class="col-sm-3" xid="div4">
     
105.         <div class="x-pagerbar-info" xid="div5">当前显示1-10条，共16条</div>
     
106.       </div>  
     
107.       <div class="col-sm-6" xid="div6">
     
108.         <div class="x-pagerbar-pagination" xid="div7">
     
109.           <ul class="pagination" component="$UI/system/components/bootstrap/pagination/pagination"
     
110.             xid="pagination1">
     
111.             <li class="prev" xid="li1">
     
112.               <a href="#" xid="a1">
     
113.                 <span aria-hidden="true" xid="span4">«</span>  
     
114.                 <span class="sr-only" xid="span5">Previous</span>
     
115.               </a>
     
116.             </li>  
     
117.             <li class="next" xid="li2">
     
118.               <a href="#" xid="a2">
     
119.                 <span aria-hidden="true" xid="span6">»</span>  
     
120.                 <span class="sr-only" xid="span9">Next</span>
     
121.               </a>
     
122.             </li>
     
123.           </ul>
     
124.         </div>
     
125.       </div>
     
126.     </div>
     
127.   </div>
     
128. </div>

复制代码

1. define(function(require){
   
2.         var $ = require("jquery");
   
3.         var justep = require("$UI/system/lib/justep");
   
4. 
   
5.         var Model = function(){
   
6.                 this.callParent();
   
7.         };
   
8. 
   
9.         Model.prototype.saveCommit = function(event){
   
10.                 justep.Util.hint("保存成功！", {type: 'success', parent: this.getRootNode()});
    
11.         };
    
12. 
    
13.         return Model;
    
14. });

复制代码