public static void test2() {

		String sql = "update funall_text set prop_value_t3 = N'Đã gửi thành công' where prop_key = 'oa-appcc.text2'";

		_log.showDebug("........sql="+sql);

		

		DaoParam param = _dao.createParam(sql);

		_dao.update(param);

	}

	public static void test2() {

		String sql = "update funall_text set prop_value_t3 = ? where prop_key = 'oa-appcc.text2'";

		_log.showDebug("........sql="+sql);

		

		DaoParam param = _dao.createParam(sql);

		param.addNStringValue("Đã gửi thành công");

		_dao.update(param);

	}

/*

 * Copyright(c) 2017 DongHong Inc.

 */

package com.jxstar.demo.eam;



import java.util.List;

import java.util.Map;



import org.jxstar.control.action.RequestContext;

import org.jxstar.service.BusinessObject;

import org.jxstar.util.ArrayUtil;

import org.jxstar.util.JsonUtil;



/**

 * 数据导入扩展测试类。

 * 注册在数据导入事件“dataimp”的类设置中。

 *

 * @author TonyTan

 * @version 1.0, 2017-6-10

 */

public class DataImpExtBO extends BusinessObject {

	private static final long serialVersionUID = 1L;



	/**

	 * 导入前的判断

	 * @param request

	 * @return

	 */

	public String preImp(RequestContext request) {

		String srcFunId = request.getFunID();

		//目标功能ID

		String destFunId = request.getRequestValue("destfunid");

		//其他参数有： keyid 选择记录主键数组、parentId 父记录ID

		String[] keyids = request.getRequestValues("keyid");

		String forKeyId = request.getRequestValue("parentId");

		

		_log.showDebug("..............导入前事情，相关参数：");

		_log.showDebug("..............来源功能ID："+srcFunId);

		_log.showDebug("..............目标功能ID："+destFunId);

		_log.showDebug("..............选择记录主键："+ArrayUtil.arrayToString(keyids));

		_log.showDebug("..............目标功能外键："+forKeyId);

		

		//判断示列效果

		if (keyids.length > 2) {

			setMessage("不能同时选择2条以上记录导入！");

			return _returnFaild;

		}

		

		return _returnSuccess;

	}

	

	/**

	 * 导入后的扩展

	 * @param request

	 * @return

	 */

	public String postImp(RequestContext request) {

		//格式如：[{impKeyId:"xxxx", newKeyId:"xxxx"}, {impKeyId:"xxxx", newKeyId:"xxxx"}]

		String json = request.getReturnData();

		_log.showDebug("..............新建主键对照："+json);

		

		List<Map<String,String>> lsData = JsonUtil.json2list(json);

		_log.showDebug("..............解析后的数据："+lsData);

		

		return _returnSuccess;

	}

}

config.eventcfg = {

		setFunext: function(){

			var records = this.grid.getSelectionModel().getSelections();

			if (!JxUtil.selectone(records)) return;

			var selfunid = records[0].get('fun_base__fun_id');

			

			//加载Form数据

			var hdcall = function(page) {

				//设置外键键

				page.getForm().fkName = 'fun_ext__fun_id';

				page.getForm().fkValue = selfunid;

				

				//加载显示数据

				var options = {

					where_sql: 'fun_ext.fun_id = ?',

					where_type: 'string',

					where_value: selfunid,

					callback: function(data) {

						//如果没有数据则执行新增

						if (data.length == 0) {

							page.formNode.event.create();

						} else {

							var r = page.formNode.event.newRecord(data[0]);

							

							page.getForm().myRecord = r;

							page.getForm().loadRecord(r);

						}

					}

				};

				Jxstar.queryData('fun_ext', options);

			};

			

			//显示数据

			var define = Jxstar.findNode('fun_ext');

			Jxstar.showData({

				filename: define.formpage,

				title: define.nodetitle,

				width: 500,

				height: 250,

				callback: hdcall

			});

		}

}

config.eventcfg = {

	setFunext: function(){

		var keyid = this.getPkField().getValue();--取主键值

		var myform = this.form;

		var selfunid = myform.get("fun_base__fun_id");

		

		--打开表单的方法同上

		...

	}

}

config.eventcfg = {

    mywin: function(){

        var records = this.grid.getSelectionModel().getSelections();

        if (!JxUtil.selectone(records)) return;

        //var selfunid = records[0].get('fun_base__fun_id');

        

        //加载Form数据

        var hdcall = function(layout) {

            //过滤条件

            var where_sql = 'store_in.in_id like ?';

            var where_type = 'string';

            var where_value = '%';//查询条件根据实际情况修改



            //加载数据

            JxUtil.delay(500, function(){

                var grid = layout.getComponent(0).getComponent(0);

                if (!grid) {

                    alert('没有找到表格对象！'); return;

                }

                Jxstar.loadData(grid, {where_sql:where_sql, where_value:where_value, where_type:where_type});

            });

        };

        

        //显示数据

        var define = Jxstar.findNode('store_in');

        Jxstar.showData({

            nodedefine: define,

            filename: define.layout,

            title: define.nodetitle,

            width: 900,

            height: 650,

            callback: hdcall

        });

    }

}

config.eventcfg = {

	setRole: function(){

		var records = this.grid.getSelectionModel().getSelections();

		if (!JxUtil.selectone(records)) return;



		var pkcol = this.define.pkcol;

		var seluserid = records[0].get(pkcol);

		

		//过滤条件

		var where_sql = 'sys_user_role.user_id = ?';

		var where_type = 'string';

		var where_value = seluserid;

		

		//加载数据

		var hdcall = function(grid) {

			//显示数据

			JxUtil.delay(500, function(){

				//设置外键值

				grid.fkValue = where_value;

				Jxstar.loadData(grid, {where_sql:where_sql, where_value:where_value, where_type:where_type});

			});

		};



		var srcDefine = Jxstar.findNode('sys_user_role');

		//显示数据

		Jxstar.showData({

			filename: srcDefine.gridpage,

			title: srcDefine.nodetitle, 

			pagetype: 'subgrid',

			nodedefine: srcDefine,

			callback: hdcall

		});

	}

};