aarido-snippets.ipynb

{
 "cells": [
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "# aardio-snippets"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## listview 原地编辑效果的实现"
   ]
  },
  {
   "cell_type": "raw",
   "metadata": {},
   "source": [
    "import win.ui;\n",
    "/*DSG{{*/\n",
    "var winform = win.form( bottom=300;parent=...;right=522;text=\"listview 原地编辑效果 by adsadss\" )\n",
    "winform.add(\n",
    "listview={ bgcolor=16777215;bottom=217;right=505;left=26;fullRow=1;top=23;z=1;gridLines=1;edge=1;cls=\"listview\" };\n",
    "static={ bottom=278;color=255;right=498;left=28;top=228;font=LOGFONT( h=-14;weight=700 );transparent=1;text=\"static\";z=2;cls=\"static\" }\n",
    ")\n",
    "/*}}*/\n",
    "\n",
    "winform.static.text=/*\n",
    "点击单元格开始编辑。按回车键结束编辑。\n",
    "listview 必须有 fullRow=1 属性。\n",
    "*/\n",
    "winform.listview.insertColumn(\"测试项 1\",80)\n",
    "winform.listview.insertColumn(\"测试项 2\",100)\n",
    "winform.listview.insertColumn(\"测试项 3\",-1)\n",
    "for(i=1;9;1){\n",
    "    winform.listview.addItem({tostring(i);\"点我 1\";\"点我 2\"});\n",
    "}\n",
    "\n",
    "winform.listview.onnotify = function(id,code,ptr){\n",
    "\n",
    "    if(code=0xFFFFFFFE/*_NM_CLICK*/ ){\n",
    "        var notifyMessage = winform.listview.getNotifyMessage(code,ptr);\n",
    "        if( ! notifyMessage.iItem && notifyMessage.iSubItem ) return ;\n",
    "        \n",
    "        var edit = winform.listview.editlable\n",
    "        if( ! edit ){\n",
    "            winform.listview.addCtrl(\n",
    "                editlable = {\n",
    "                    cls=\"edit\";font = LOGFONT( h = 11 );left = 0;top = 0;\n",
    "                    right = 50;bottom = 50;autoResize = false ;hide = 1;edge = 1;  \n",
    "                    wndproc = function( hwnd, message, wParam, lParam ){\n",
    "                        if( ( message = 0x8/*_WM_KILLFOCUS*/)\n",
    "                            || message == 0x101/*_WM_KEYUP*/ && wParam == 0xD/*_VK_RETURN*/){\n",
    "                            // 按下了回车键或失去焦点，更新 listview 数据\n",
    "                            owner.parent.setItemText( owner.text, owner.listViewNotifyMessage.iItem\n",
    "                                , owner.listViewNotifyMessage.iSubItem );\n",
    "                            owner.show(false);\n",
    "                        ｝\n",
    "                    }  \n",
    "                }\n",
    "            )  \n",
    "            edit = winform.listview.editlable;\n",
    "        }\n",
    "        edit.listViewNotifyMessage = notifyMessage;\n",
    "        edit.text=winform.listview.getItemText(notifyMessage.iItem,notifyMessage.iSubItem);\n",
    "        var rc=winform.listview.getItemRect( notifyMessage.iItem,notifyMessage.iSubItem,,2/*_LVIR_LABEL*/ )\n",
    "        rc.right += 5; rc.bottom += 5;\n",
    "        edit.setRect(rc);\n",
    "        edit.show();\n",
    "        edit.setFocus();// 获取焦点\n",
    "    }\n",
    "}\n",
    "winform.show()  \n",
    "win.loopMessage();"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## sqlite+listview 综合应用"
   ]
  },
  {
   "cell_type": "raw",
   "metadata": {},
   "source": [
    "import win.ui;\n",
    "import sqlite;\n",
    "import console;\n",
    "/*DSG{{*/\n",
    "var winform = win.form(text=\"aardio Form\";right=596;bottom=433;parent=...)\n",
    "winform.add(\n",
    "btnDelete={cls=\"button\";text=\"删除表中数据\";left=473;top=388;right=560;bottom=415;z=2};\n",
    "btn_adddb={cls=\"button\";text=\"添加中数据到数据库\";left=416;top=12;right=555;bottom=67;z=11};\n",
    "ed_age={cls=\"edit\";left=277;top=10;right=369;bottom=32;edge=1;z=6};\n",
    "ed_kg={cls=\"edit\";left=279;top=48;right=371;bottom=70;edge=1;z=5};\n",
    "ed_love={cls=\"edit\";left=108;top=53;right=200;bottom=73;edge=1;z=4};\n",
    "ed_name={cls=\"edit\";left=109;top=16;right=201;bottom=37;edge=1;z=3};\n",
    "listview={cls=\"listview\";left=31;top=100;right=561;bottom=369;bgcolor=16777215;edge=1;fullRow=1;gridLines=1;items={};z=1};\n",
    "static={cls=\"static\";text=\"name:\";left=49;top=18;right=91;bottom=38;transparent=1;z=7};\n",
    "static2={cls=\"static\";text=\"age:\";left=218;top=14;right=260;bottom=34;transparent=1;z=8};\n",
    "static3={cls=\"static\";text=\"kg:\";left=219;top=52;right=261;bottom=72;transparent=1;z=9};\n",
    "static4={cls=\"static\";text=\"love:\";left=48;top=55;right=90;bottom=70;transparent=1;z=10}\n",
    ")\n",
    "/*}}*/\n",
    "\n",
    "winform.listview.setExtended(0x4/*_LVS_EX_CHECKBOXES*/);\n",
    "winform.listview.insertColumn(\"id\",50,1)\n",
    "winform.listview.insertColumn(\"name\",100,2)\n",
    "winform.listview.insertColumn(\"age\",150,3)\n",
    "winform.listview.insertColumn(\"kg\",100,4)\n",
    "winform.listview.insertColumn(\"love\",100,5)\n",
    "\n",
    "\n",
    "// 打开数据库链接\n",
    "sqlConnection=sqlite(\"\\db.db\")\n",
    "if(not sqlConnection.existsTable(\"file\")){        \n",
    "            sqlConnection.exec(\"CREATE TABLE file(\n",
    "                     id INTEGER PRIMARY KEY AUTOINCREMENT,  \n",
    "                     name,\n",
    "                     age,\n",
    "                     kg,\n",
    "                     love\n",
    "                    );\"\n",
    "            )\n",
    "            win.msgbox (\"创建表成功\",\"aardio\")\n",
    "            // 创建索引利于查询\n",
    "            //sqlConnection.exec (\"create index 索引名字 on 表名字 (索引字段名字)\")\n",
    "            \n",
    "}else {\n",
    "\n",
    "                var db=sqlConnection.getTable(\"SELECT * FROM file\");\n",
    "        \n",
    "                 for(i=1;#db;1){        \n",
    "                 winform.listview.addItem();\n",
    "                 winform.listview.setItemText(tostring(db[i].id),i,1)\n",
    "                 winform.listview.setItemText(db[i].name,i,2)\n",
    "                 winform.listview.setItemText(tostring(db[i].age),i,3)\n",
    "                 winform.listview.setItemText(tostring(db[i].kg),i,4)\n",
    "                 winform.listview.setItemText(db[i].love,i,5)\n",
    "                 }\n",
    "}\n",
    "// 刷新 listview\n",
    "Refresh_main=function(){\n",
    "\n",
    "        winform.listview.clear();\n",
    "        var db=sqlConnection.getTable(\"SELECT * FROM file\");\n",
    "        \n",
    "                 for(i=1;#db;1){        \n",
    "                 winform.listview.addItem();\n",
    "                 winform.listview.setItemText(tostring(db[i].id),i,1)\n",
    "                 winform.listview.setItemText(db[i].name,i,2)\n",
    "                 winform.listview.setItemText(tostring(db[i].age),i,3)\n",
    "                 winform.listview.setItemText(tostring(db[i].kg),i,4)\n",
    "                 winform.listview.setItemText(db[i].love,i,5)\n",
    "        }\n",
    "}\n",
    "\n",
    "// 删除所选数据\n",
    "delete_db = function(){\n",
    "        \n",
    "for(i=1;winform.listview.count;1){        \n",
    "\n",
    "                if(winform.listview.getChecked(i)){\n",
    "               \n",
    "                        var id=winform.listview.getItemText(i,1)\n",
    "                        sqlConnection.exec(\"DELETE FROM file WHERE id=\"+id+\"\")\n",
    "                }\n",
    "}\n",
    "win.msgbox (\"删除成功\",\"系统提示\")\n",
    "Refresh_main()        \n",
    "}\n",
    "// 查询表中相同的并删除\n",
    "delete_thesame = function(name){\n",
    "\n",
    "        sqlConnection.exec(\"DELETE FROM file where name not in(select max(id) from file group by name)\")\n",
    "        \n",
    "}\n",
    "// 查询表中相同姓名\n",
    "select_db = function(name){\n",
    "\n",
    "        return sqlConnection.getTable(\"select name from file where name='\"+name+\"'\");\n",
    "        \n",
    "}\n",
    "// 查询表中有相同数据的便覆盖掉\n",
    "the_same = function(name,age,kg,love){\n",
    "        \n",
    "        var num = sqlConnection.exec(\"insert into file(name,age,kg,love) select '\"+name+\"','\"+age+\"','\"+kg+\"','\"+love+\"' where not exists(select * from file where name='\"+name+\"');\")\n",
    "        win.msgbox (\"添加成功\",\"系统提示\")\n",
    "        Refresh_main()\n",
    "        \n",
    "}\n",
    "// 修改表中数据\n",
    "update_db = function(id,name,age,kg,love){\n",
    "        var doubt=win.msgboxTest (\"确定修改并且更新到数据库？\",\"系统提示\");\n",
    "        if(doubt){\n",
    "         \n",
    "         sqlConnection.exec(\"UPDATE file SET name='\"+name+\"',age='\"+age+\"',kg='\"+kg+\"',love='\"+love+\"' WHERE id ='\"+id+\"'\");\n",
    "         \n",
    "        }\n",
    "        \n",
    "}\n",
    "\n",
    "\n",
    "// 添加\n",
    "add_db =function(name,age,kg,love){\n",
    "\n",
    "                var add=sqlConnection.exec(\"insert into file (name,age,kg,love) values('\"+name+\"','\"+age+\"','\"+kg+\"','\"+love+\"')\")\n",
    "               \n",
    "                win.msgbox (\"添加成功\",\"系统提示\")\n",
    "                Refresh_main();        \n",
    "               \n",
    "}\n",
    "//listview 原地编辑并更新到数据库\n",
    "winform.listview.onnotify = function(id,code,ptr){\n",
    "\n",
    "    if(code=0xFFFFFFFE/*_NM_CLICK*/ ){\n",
    "        var notifyMessage = winform.listview.getNotifyMessage(code,ptr);\n",
    "        if( ! notifyMessage.iItem && notifyMessage.iSubItem ) return ;\n",
    "        \n",
    "        var edit = winform.listview.editlable\n",
    "        if( ! edit ){\n",
    "            winform.listview.addCtrl(\n",
    "                editlable = {\n",
    "                    cls=\"edit\";font = LOGFONT( h = 11 );left = 0;top = 0;\n",
    "                    right = 50;bottom = 50;autoResize = false ;hide = 1;edge = 1;  \n",
    "                    wndproc = function( hwnd, message, wParam, lParam ){\n",
    "                        if( ( message = 0x8/*_WM_KILLFOCUS*/)\n",
    "                            || message == 0x101/*_WM_KEYUP*/ && wParam == 0xD/*_VK_RETURN*/){\n",
    "                            // 按下了回车键或失去焦点，更新 listview 数据\n",
    "                            owner.parent.setItemText( owner.text, owner.listViewNotifyMessage.iItem\n",
    "                                , owner.listViewNotifyMessage.iSubItem );\n",
    "                                \n",
    "                                    // 获取选中的焦点\n",
    "                                   var focus=winform.listview.getFocused()\n",
    "                                                                        if(focus!=0){\n",
    "                                                                        var id=winform.listview.getItemText (focus,1);// 第 i 行第一列\n",
    "                                                            var name=winform.listview.getItemText(focus,2);\n",
    "                                                            var age=winform.listview.getItemText(focus,3);\n",
    "                                                            var kg=winform.listview.getItemText(focus,4);\n",
    "                                                            var love=winform.listview.getItemText(focus,5);\n",
    "                                                            console.log(id,name,age,kg,love)\n",
    "                                                            // 更新语句 update\n",
    "                                                            update_db(id,name,age,kg,love);\n",
    "                                                            // 调用刷新\n",
    "                                                            Refresh_main();\n",
    "                                                                        }\n",
    "                                      \n",
    "                            owner.show(false);\n",
    "                        }\n",
    "                    }  \n",
    "                }\n",
    "            )\n",
    "            edit = winform.listview.editlable;\n",
    "        }\n",
    "        edit.listViewNotifyMessage = notifyMessage;\n",
    "        edit.text=winform.listview.getItemText(notifyMessage.iItem,notifyMessage.iSubItem);\n",
    "        var rc=winform.listview.getItemRect( notifyMessage.iItem,notifyMessage.iSubItem,,2/*_LVIR_LABEL*/ )\n",
    "        rc.right += 5; rc.bottom += 5;\n",
    "        edit.setRect(rc);\n",
    "        edit.show();\n",
    "        edit.setFocus ();// 获取焦点\n",
    "    }\n",
    "}\n",
    "// 删除所选数据\n",
    "winform.btnDelete.oncommand = function(){\n",
    "\n",
    "    win.util.tooltip.pop (\"这是一个提示\",,,2000)\n",
    "     var bool=win.msgboxTest (\"确定删除？\",\"系统提示\")\n",
    "     \n",
    "     if(bool){\n",
    "             delete_db();\n",
    "     }\n",
    "}\n",
    "// 添加数据到 db\n",
    "winform.btn_adddb.oncommand = function(){\n",
    "        \n",
    "        var name=winform.ed_name.text;\n",
    "        var age =winform.ed_age.text;\n",
    "        var kg  =winform.ed_kg.text;\n",
    "        var love=winform.ed_love.text;\n",
    "        var name_01;\n",
    "        var num=select_db(name);\n",
    "        for(i=1;#num;1){\n",
    "               \n",
    "                name_01=num[i].name;\n",
    "\n",
    "            }\n",
    "    if(name_01!=null){\n",
    "   \n",
    "       win.msgbox (\"该名称数据库已经存在\",\"系统提示\")\n",
    "               \n",
    "    }else {\n",
    "            \n",
    "                 if(name!=\"\" ? age!=null ? kg!=null ? love!=\"\"){\n",
    "                        add_db(name,age,kg,love)\n",
    "                }        \n",
    "    }\n",
    "}\n",
    "winform.show();\n",
    "win.loopMessage();"
   ]
  },
  {
   "attachments": {},
   "cell_type": "markdown",
   "metadata": {},
   "source": [
    "## sqlite+listview 综合应用改进加强版"
   ]
  },
  {
   "cell_type": "raw",
   "metadata": {},
   "source": [
    "import win.ui;\n",
    "import sqlite;\n",
    "import console;\n",
    "/*DSG{{*/\n",
    "var winform = ..win.form( bottom=433;parent=...;right=596;text=\"aardio Form\" )\n",
    "winform.add(\n",
    "ed_kg={ bottom=70;right=371;left=279;top=48;z=5;edge=1;cls=\"edit\" };\n",
    "listview={ top=100;bgcolor=16777215;bottom=369;right=561;left=31;cls=\"listview\";\n",
    "items={  };z=1;gridLines=1;edge=1;fullRow=1 };\n",
    "static={ bottom=38;right=91;left=49;text=\"name:\";top=18;z=7;transparent=1;cls=\"static\" };\n",
    "ed_name={ bottom=37;right=201;left=109;top=13;z=3;edge=1;cls=\"edit\" };\n",
    "static2={ bottom=34;right=260;left=218;text=\"age:\";top=14;z=8;transparent=1;cls=\"static\" };\n",
    "static4={ bottom=70;right=90;left=48;text=\"love:\";top=55;z=10;transparent=1;cls=\"static\" };\n",
    "static3={ bottom=72;right=261;left=219;text=\"kg:\";top=52;z=9;transparent=1;cls=\"static\" };\n",
    "btnDelete={ bottom=415;right=560;left=473;top=388;z=2;text=\"删除表中数据\";cls=\"button\" };\n",
    "btn_adddb={ bottom=67;text=\"添加中数据到数据库\";left=416;top=12;z=11;right=555;cls=\"button\" };\n",
    "ed_love={ bottom=73;right=200;left=108;top=53;z=4;edge=1;cls=\"edit\" };\n",
    "ed_age={ bottom=32;right=369;left=277;top=10;z=6;edge=1;cls=\"edit\" }\n",
    ")\n",
    "/*}}*/\n",
    "\n",
    "winform.listview.setExtended(0x4/*_LVS_EX_CHECKBOXES*/);// 勾选框\n",
    "winform.listview.insertColumn(\"id\",50,1)\n",
    "winform.listview.insertColumn(\"name\",100,2)\n",
    "winform.listview.insertColumn(\"age\",150,3)\n",
    "winform.listview.insertColumn(\"kg\",100,4)\n",
    "winform.listview.insertColumn(\"love\",100,5)\n",
    "\n",
    "\n",
    "var sqlConnection = sqlite(\"\\db.db\") // 连接数据库\n",
    "if(not sqlConnection.existsTable(\"filea\")){        // 如果不存在表，则创建数据表\n",
    "            sqlConnection.exec(\"CREATE TABLE filea(\n",
    "                     id INTEGER PRIMARY KEY AUTOINCREMENT,  \n",
    "                     name,\n",
    "                     age,\n",
    "                     kg,\n",
    "                     love\n",
    "                    );\"\n",
    "            )\n",
    "            win.msgbox(\"创建表成功\",\"aardio\")\n",
    "            // 创建索引利于查询\n",
    "            //sqlConnection.exec (\"create index 索引名字 on 表名字 (索引字段名字)\")            \n",
    "}else {\n",
    "\n",
    "                var db=sqlConnection.getTable(\"SELECT * FROM filea\");// 查询全表数据\n",
    "                    // 将查询到的数据显示于 listview\n",
    "                 for(i=1;#db;1){        \n",
    "                 winform.listview.addItem();\n",
    "                 winform.listview.setItemText(tostring(db[ i ].id),i,1)\n",
    "                 winform.listview.setItemText(tostring(db[ i ].name),i,2)\n",
    "                 winform.listview.setItemText(tostring(db[ i ].age),i,3)\n",
    "                 winform.listview.setItemText(tostring(db[ i ].kg),i,4)\n",
    "                 winform.listview.setItemText(tostring(db[ i ].love),i,5)\n",
    "                 }\n",
    "}\n",
    "// 刷新 listview\n",
    "Refresh_main=function(){\n",
    "\n",
    "        winform.listview.clear();// 先清空，再显示，实现刷新\n",
    "        var db=sqlConnection.getTable(\"SELECT * FROM filea\");\n",
    "        \n",
    "                 for(i=1;#db;1){        \n",
    "                 winform.listview.addItem();\n",
    "                 winform.listview.setItemText(tostring(db[ i ].id),i,1)\n",
    "                 winform.listview.setItemText(tostring(db[ i ].name),i,2)\n",
    "                 winform.listview.setItemText(tostring(db[ i ].age),i,3)\n",
    "                 winform.listview.setItemText(tostring(db[ i ].kg),i,4)\n",
    "                 winform.listview.setItemText(tostring(db[ i ].love),i,5)\n",
    "        }\n",
    "}\n",
    "\n",
    "// 删除所选数据\n",
    "delete_db = function(){\n",
    "        \n",
    "for(i=1;winform.listview.count;1){        \n",
    "\n",
    "                if(winform.listview.getChecked(i)){\n",
    "               \n",
    "                        var id=winform.listview.getItemText(i,1)\n",
    "                        sqlConnection.exec(\"DELETE FROM filea WHERE id=\"+id+\"\")\n",
    "                }\n",
    "}\n",
    "win.msgbox(\"删除成功\",\"系统提示\")\n",
    "Refresh_main()        \n",
    "}\n",
    "// 查询表中相同的并删除\n",
    "delete_thesame = function(name){\n",
    "\n",
    "        sqlConnection.exec(\"DELETE FROM filea where name not in(select max(id) from filea group by name)\")\n",
    "        \n",
    "}\n",
    "// 查询表中相同姓名\n",
    "select_db = function(name){\n",
    "\n",
    "        return sqlConnection.getTable(\"select name from filea where name='\"+name+\"'\");\n",
    "        \n",
    "}\n",
    "// 查询表中有相同数据的便覆盖掉\n",
    "the_same = function(name,age,kg,love){\n",
    "        \n",
    "        var num = sqlConnection.exec(\"insert into filea(name,age,kg,love) select '\"+name+\"','\"+age+\"','\"+kg+\"','\"+love+\"' where not exists(select * from filea where name='\"+name+\"');\")\n",
    "        win.msgbox(\"添加成功\",\"系统提示\")\n",
    "        Refresh_main()\n",
    "        \n",
    "}\n",
    "// 修改表中数据\n",
    "update_db = function(id,name,age,kg,love){\n",
    "        var doubt=win.msgboxTest(\"确定修改并且更新到数据库？\",\"系统提示\");\n",
    "        if(doubt){\n",
    "         \n",
    "         sqlConnection.exec(\"UPDATE filea SET name='\"+name+\"',age='\"+age+\"',kg='\"+kg+\"',love='\"+love+\"' WHERE id ='\"+id+\"'\");\n",
    "         \n",
    "        }\n",
    "        \n",
    "}\n",
    "\n",
    "\n",
    "// 添加\n",
    "add_db =function(name,age,kg,love){\n",
    "\n",
    "                var add=sqlConnection.exec(\"insert into filea (name,age,kg,love) values('\"+name+\"','\"+age+\"','\"+kg+\"','\"+love+\"')\")\n",
    "               \n",
    "                win.msgbox(\"添加成功\",\"系统提示\")\n",
    "                Refresh_main();        \n",
    "               \n",
    "}\n",
    "\n",
    "\n",
    "winform.listview.onnotify = function(id,code,ptr){\n",
    "    if(code==0xFFFFFF4B){// 滚动条\n",
    "        if(!winform.listview.editlable) return ;\n",
    "        edit = winform.listview.editlable;\n",
    "        rc=winform.listview.getItemRect(edit.listViewNotifyMessage.iItem,edit.listViewNotifyMessage.iSubItem,,2/*_LVIR_LABEL*/);\n",
    "        if(rc.top<rc.bottom-rc.top){// 选中行向上滚动到了列标题及其以上的位置，不处理的话编辑框会覆盖掉列标题。\n",
    "            rc.top-=math.abs(rc.bottom);rc.bottom=rc.top;\n",
    "        }else {\n",
    "            rc.right += 5; rc.bottom += 5;\n",
    "        }\n",
    "        edit.setRect(rc);\n",
    "        winform.listview.redraw();// 经测试，这行会引起滚动条位置变化时 listview 控件闪烁，如果在意这个问题，请主动给 listview 控件增加_WS_CLIPCHILDREN 样式，可以省略掉这行。\n",
    "    }\n",
    "    if(code=0xFFFFFFFD/*_NM_DBLCLK*/ ){ //code=0xFFFFFFFE/*_NM_CLICK 鼠标单击 */\n",
    "        var notifyMessage = winform.listview.getNotifyMessage(code,ptr);\n",
    "        if( ! notifyMessage.iItem && notifyMessage.iSubItem ) return ;\n",
    "        \n",
    "        var edit = winform.listview.editlable\n",
    "        if( ! edit ){\n",
    "            winform.listview.addCtrl(\n",
    "                editlable = {\n",
    "                    cls=\"edit\";font = LOGFONT( h = 11 );left = 0;top = 0;\n",
    "                    right = 50;bottom = 50;autoResize = false ;hide = 1;edge = 1;                    \n",
    "                    wndproc = function( hwnd, message, wParam, lParam ){\n",
    "                        if( ( message = 0x8/*_WM_KILLFOCUS*/)\n",
    "                            || message == 0x101/*_WM_KEYUP*/ && wParam == 0xD/*_VK_RETURN*/){\n",
    "                            // 按下了回车键或失去焦点，更新 listview 数据\n",
    "                            owner.parent.setItemText( owner.text, // 格子内容\n",
    "                                                      owner.listViewNotifyMessage.iItem, // 行号\n",
    "                                                      owner.listViewNotifyMessage.iSubItem );// 列号\n",
    "                            //console.log (owner.text, owner.listViewNotifyMessage.iItem, owner.listViewNotifyMessage.iSubItem) // 测试显示数据\n",
    "                            var focus=owner.listViewNotifyMessage.iItem\n",
    "                            var id=winform.listview.getItemText(focus,1);//focus = 第 i 行，第 1 列\n",
    "                            var name=winform.listview.getItemText(focus,2);\n",
    "                            var age=winform.listview.getItemText(focus,3);\n",
    "                            var kg=winform.listview.getItemText(focus,4);\n",
    "                            var love=winform.listview.getItemText(focus,5);\n",
    "                            console.log(id,name,age,kg,love)\n",
    "                            // 更新语句 update\n",
    "                            update_db(id,name,age,kg,love);\n",
    "                            // 调用刷新\n",
    "                            Refresh_main();\n",
    "                            owner.show(false);\n",
    "                        }\n",
    "                    }  \n",
    "                }\n",
    "            )  \n",
    "            edit = winform.listview.editlable;\n",
    "        }\n",
    "        edit.listViewNotifyMessage = notifyMessage;\n",
    "        edit.text=winform.listview.getItemText(notifyMessage.iItem,notifyMessage.iSubItem);\n",
    "        var rc=winform.listview.getItemRect( notifyMessage.iItem,notifyMessage.iSubItem,,2/*_LVIR_LABEL*/ )\n",
    "        rc.right += 5; rc.bottom += 5;\n",
    "        edit.setRect(rc);\n",
    "        edit.show();\n",
    "        edit.setFocus();// 获取焦点\n",
    "    }\n",
    "}\n",
    "\n",
    "\n",
    "// 删除所选数据\n",
    "winform.btnDelete.oncommand = function(){\n",
    "     var bool=win.msgboxTest(\"确定删除？\",\"系统提示\")\n",
    "     \n",
    "     if(bool){\n",
    "             delete_db();\n",
    "     }\n",
    "}\n",
    "// 添加数据到 db\n",
    "winform.btn_adddb.oncommand = function(){\n",
    "        \n",
    "        var name=winform.ed_name.text;\n",
    "        var age =winform.ed_age.text;\n",
    "        var kg  =winform.ed_kg.text;\n",
    "        var love=winform.ed_love.text;\n",
    "        var name_01;\n",
    "        var num=select_db(name);\n",
    "        for(i=1;#num;1){\n",
    "               \n",
    "                name_01=num[ i ].name;\n",
    "\n",
    "            }\n",
    "    if(name_01!=null){\n",
    "   \n",
    "       win.msgbox(\"该名称数据库已经存在\",\"系统提示\")\n",
    "               \n",
    "    }else {\n",
    "            \n",
    "                 if(name!=\"\" ? age!=null ? kg!=null ? love!=\"\"){\n",
    "                        add_db(name,age,kg,love)\n",
    "                }        \n",
    "    }\n",
    "}\n",
    "\n",
    "\n",
    "winform.show()  \n",
    "win.loopMessage();"
   ]
  },
  {
   "cell_type": "raw",
   "metadata": {},
   "source": []
  }
 ],
 "metadata": {
  "language_info": {
   "name": "python"
  },
  "orig_nbformat": 4
 },
 "nbformat": 4,
 "nbformat_minor": 2
}