<table class="layui-table layui-form" lay-data="{limit:30}" lay-filter="edittable">
<thead>
<tr>
<th lay-data="{field:'conf_key'}">键</th>
<th lay-data="{field:'conf_value', edit: 'text'}">值</th>
</tr>
</thead>
</table>
<script type="text/javascript">
layui.use(['table'], function () {
layui.table.on('edit(edittable)', function (obj) {
var value = obj.value //得到修改后的值
, data = obj.data //得到所在行所有键值
, field = obj.field; //得到字段
$.post("updateRobotConf", { id: data.conf_key, field: field, value: value }, function (data) {
if (data == "true") {
layer.msg("修改成功");
} else {
layer.msg(data);
}
});
});
});
</script>
public string updateRobotConf(string id,string field,string value)
{
try
{
aideAccountsFacade.ExecuteSql("update RobotConf set " + field + "='" + value + "' where id ='" + id + "' ");
return "true";
}
catch (Exception e)
{
return e.Message;
}
}