event.row一直为空

小黑大白

用event.row获取当前行一直是空

jishuang

确认grid上是不是设置了冻结列，3.7版本中解决过设置冻结列点击事件获取不到行的问题

小黑大白

jishuang 发表于 2017-10-17 09:22
确认grid上是不是设置了冻结列，3.7版本中解决过设置冻结列点击事件获取不到行的问题 ...

是这个吗，没有设置还是不能获取到当前行；

jishuang

把.w和js文件发一下看看

小黑大白

jishuang 发表于 2017-10-17 15:47
把.w和js文件发一下看看

w.zip (8.09 KB, 下载次数: 165)

2017-10-18 15:26 上传

点击文件名下载附件 你好请帮忙看一下。

jishuang

data中加载的数据确认正确吗？本地你用的文件，直接在data中加数据，可以获取到

小黑大白

jishuang 发表于 2017-10-18 16:08
data中加载的数据确认正确吗？本地你用的文件，直接在data中加数据，可以获取到 ...

你好，数据都能够获取到

小黑大白

jishuang 发表于 2017-10-18 16:08
data中加载的数据确认正确吗？本地你用的文件，直接在data中加数据，可以获取到 ...

数据都是正确的，可是row还是获取不到

jishuang

获取数据的action定义的java代码发一下看看

小黑大白

jishuang 发表于 2017-10-19 09:12
获取数据的action定义的java代码发一下看看

import java.util.Map;

import com.justep.message.CommonMessages;
import com.justep.model.ModelUtils;
import com.justep.system.data.KSQL;
import com.justep.system.data.Table;
import com.justep.util.Utils;

public class KSQLProcedure {

        public static Table query(String ksql, Map<String, Object> variables, String dataModel, String fnModel) {
       
                Utils.check(Utils.isNotEmptyString(ksql) && Utils.isNotEmptyString(dataModel),
                                CommonMessages.class, CommonMessages.PARAM_NULL1, "ksql, dataModel");
                return KSQL.select(ksql, variables, dataModel, Utils.isEmptyString(fnModel) ? null : ModelUtils.getModel(fnModel));

        }
}




select FI_articleInfo as fArticleID,FI_articleInfo.fArticleType as fArticleType,FI_articleInfo.fArticleName as fArticleName,FI_articleInfo.fPrice as fPrice,FI_articleInfo.fUnit as fUnit,FI_WhPosition as fWhPositionID,FI_WhPosition.fMainID as fWhID,FI_WhPosition.fWhArea as fWhArea,FI_WhPosition.fWhPosition as fWhPosition,(customSub1.fInboundSum) as fInboundSum,(customSub6.fOutboundSum) as fOutboundSum,( SQL.IFNULL(customSub1.fInboundSum, 0) - SQL.IFNULL(customSub6.fOutboundSum, 0) ) as fCurrentStock
    from FI_articleInfo FI_articleInfo
    join FI_WhPosition FI_WhPosition on 1 = 1
    join (select FI_articleMoveDetail.farticleID as farticleID, FI_articleMoveDetail.fReceiverPositionID as fReceiverPositionID, (sum(FI_articleMoveDetail.fQuantity)) as fInboundSum from FI_articleMove FI_articleMove
    join FI_articleMoveDetail FI_articleMoveDetail on FI_articleMove = FI_articleMoveDetail.fMainID
    where FI_articleMove.fReceiverID = :fWhID AND FI_articleMove.fType = '入库单' AND FI_articleMove.fProcState = '已完成'
    group by FI_articleMoveDetail.farticleID, FI_articleMoveDetail.fReceiverPositionID) customSub1 on FI_WhPosition = customSub1.fReceiverPositionID AND FI_articleInfo = customSub1.farticleID optional
    join (select FI_articleMoveDetail.farticleID as farticleID, FI_articleMoveDetail.fSendPositionID as fSendPositionID, (sum(FI_articleMoveDetail.fQuantity)) as fOutboundSum from FI_articleMove FI_articleMove
    join FI_articleMoveDetail FI_articleMoveDetail on FI_articleMove = FI_articleMoveDetail.fMainID where FI_articleMove.fSendID = :fWhID AND FI_articleMove.fType = '出库单' AND ( FI_articleMove.fProcState = '已完成' OR FI_articleMove.fProcState = '进行中' )
    group by FI_articleMoveDetail.farticleID, FI_articleMoveDetail.fSendPositionID) customSub6 on FI_articleInfo = customSub6.fArticleID AND FI_WhPosition = customSub6.fSendPositionID where ( SQL.IFNULL(customSub1.fInboundSum, 0) - SQL.IFNULL(customSub6.fOutboundSum, 0) ) > 0