//TableWidget.qml import Felgo import QtQuick import QtQuick.Controls import QtQuick.Window import QtQuick.Dialogs import QtQuick.LocalStorage import EasyModel 1.0 import com.example.database 1.0 import "../common" import "../controls" //自定义QtQuick 2中的TableView AppPage { id: sqlite_page implicitHeight: 800 implicitWidth: 1280 rightBarItem: IconButtonBarItem { iconType: IconType.paintbrush onClicked: { console.log("database") sqliteModal.open() } } //行表头-竖向的 property int verHeaderHeight: 30 property int verHeaderWidth: 150 //列表头-横向的 property int horHeaderHeight: 30 //滚动条 property color scrollBarColor: "cyan" property int scrollBarWidth: 6 //列宽 property variant columnWidthArr: [30,100,100,100,100,100,200,100,100,100,100,100,100] property variant table_mqtt_Value: ["id","dtype","ip","port","imei","uid","pwd","clientid","qos","keepalive","sub","pub","offline"] property variant table_ftp_Value: ["id","ip","port","dir","uid","pwd","mode"] property variant table_location_Value: ["id","lbs_lat","lbs_lng","gps_lat","gps_lng","gps_elevation"] property variant table_camera_Value: ["camera_type","mode","stitch_photonum","photo_width","photo_height","auto_focus"] property variant table_json_Value: ["id","datetime","json_data","json_data"] property int datacount: 1 DatabaseInterface { id: db_cfg } EasyTableModel{ id: table_model horHeader: table_mqtt_Value //initData: []//myClass.getdata_JsonArray() //initData: [] } //表格内容(不包含表头) TableView{ id: table_view height: sqlite_page.implicitHeight anchors{ left: parent.left right: parent.right top: parent.top leftMargin: 30 topMargin: sqlite_page.horHeaderHeight } clip: true boundsBehavior: Flickable.StopAtBounds columnSpacing: 1 rowSpacing: 1 //视图的高度 //contentHeight: rowHeightProvider(0) * rows + rowHeightProvider(rows-1) //视图的宽度 //contentWidth: //content内容区域边距,但是不影响滚动条的位置 //leftMargin: //topMargin: //此属性可以包含一个函数,该函数返回模型中每行的行高 rowHeightProvider: function (row) { return sqlite_page.verHeaderHeight; } //此属性可以保存一个函数,该函数返回模型中每个列的列宽 columnWidthProvider: function (column) { return sqlite_page.columnWidthArr[column]; //return Math.max(1, (table_view.width - leftMargin) / table_view.columns) } ScrollBar.vertical: ScrollBar { id: scroll_vertical anchors.right: parent.right anchors.rightMargin: 2 //active: table_view.ScrollBar.vertical.active //policy: ScrollBar.AsNeeded contentItem: Rectangle{ visible: (scroll_vertical.size<1.0) implicitWidth: sqlite_page.scrollBarWidth color: sqlite_page.scrollBarColor } } ScrollBar.horizontal: ScrollBar { id: scroll_horizontal anchors.bottom: parent.bottom anchors.bottomMargin: 2 //active: table_view.ScrollBar.vertical.active //policy: ScrollBar.AsNeeded contentItem: Rectangle{ visible: (scroll_horizontal.size<1.0) implicitHeight: sqlite_page.scrollBarWidth color: sqlite_page.scrollBarColor } } //model是在C++中定义的,和QtC++是类似的 model: table_model delegate: Rectangle { color: (model.row%2)?"orange":Qt.darker("orange") //根据行数设置背景颜色 AppText{ id : value_text anchors.centerIn: parent verticalAlignment: Text.AlignVCenter // 水平居中对齐 horizontalAlignment: Text.AlignHCenter //elide: Text.ElideRight // selectByMouse: true // selectedTextColor: "black" // selectionColor: "white" //获取单元格对应的值 text: model.value AppButton { onClicked: { var dialog = InputDialog.inputTextSingleLine(app, "请输入要修改内容", value_text.text, function(ok,text){ if(ok){ value_text.text = text model.edit=text; //将改变写入到数据库中 console.log("edit",model.value) if(sqlite_switch.checked) { if(table_combox.displayText===table_combox.model[0]||table_combox.displayText===table_combox.model[1]) { columnWidthArr = [30,100,100,100,100,100,200,100,100,100,100,100,100] db_cfg.updateData(table_combox.displayText,table_mqtt_Value[index],model.value) } if(table_combox.displayText===table_combox.model[2]||table_combox.displayText===table_combox.model[3]) { db_cfg.updateData(table_combox.displayText,table_ftp_Value[index],model.value) } if(table_combox.displayText===table_combox.model[4]) { db_cfg.updateData(table_combox.displayText,table_location_Value[index],model.value) } if(table_combox.displayText===table_combox.model[5]){ db_cfg.updateData(table_combox.displayText,table_camera_Value[index],model.value) } } } }) // Disable the negative action dialog.negativeAction = false // Dismiss when touched outside dialog.outsideTouchable = true } } // onEditingFinished: { // model.edit=text; // //将改变写入到数据库中 // console.log("edit",model.value) // if(sqlite_switch.checked) // { // if(table_combox.displayText===table_combox.model[0]||table_combox.displayText===table_combox.model[1]) // { // db_cfg.updateData(table_combox.displayText,table_mqtt_Value[index],model.value) // } // if(table_combox.displayText===table_combox.model[2]||table_combox.displayText===table_combox.model[3]) // { // db_cfg.updateData(table_combox.displayText,table_ftp_Value[index],model.value) // } // if(table_combox.displayText===table_combox.model[4]) // { // db_cfg.updateData(table_combox.displayText,table_location_Value[index],model.value) // } // } // } } } } //横项表头 Item{ id: header_horizontal anchors{ left: parent.left right: parent.right leftMargin: 30//control.verHeaderWidth } height: sqlite_page.horHeaderHeight z: 2 //暂存鼠标拖动的位置 property int posXTemp: 0 MouseArea{ anchors.fill: parent onPressed: { header_horizontal.posXTemp=mouseX; } onPositionChanged: { if(table_view.contentX+(header_horizontal.posXTemp-mouseX)>0){ table_view.contentX+=(header_horizontal.posXTemp-mouseX); }else{ table_view.contentX=0; } header_horizontal.posXTemp=mouseX; } } Row { id: header_horizontal_row anchors.fill: parent leftPadding: -table_view.contentX clip: true spacing: 0 Repeater { model: table_view.columns > 0 ? table_view.columns : 0 Rectangle { id: header_horizontal_item width: table_view.columnWidthProvider(index)+table_view.columnSpacing height: sqlite_page.horHeaderHeight color: "purple" AppText { anchors.centerIn: parent text: table_model.headerData(index, Qt.Horizontal) } Rectangle{ width: 1 height: parent.height anchors.right: parent.right color: "black" opacity: 0.5 } MouseArea{ width: 3 height: parent.height anchors.right: parent.right cursorShape: Qt.SplitHCursor onPressed: header_horizontal.posXTemp=mouseX; onPositionChanged: { if((header_horizontal_item.width-(header_horizontal.posXTemp-mouseX))>10){ header_horizontal_item.width-=(header_horizontal.posXTemp-mouseX); }else{ header_horizontal_item.width=10; } header_horizontal.posXTemp=mouseX; sqlite_page.columnWidthArr[index]=(header_horizontal_item.width-table_view.columnSpacing); //刷新布局,这样宽度才会改变 table_view.forceLayout(); } } } } } } //竖向表头 Column { id: header_verical height: sqlite_page.implicitHeight anchors{ left: parent.left top: parent.top //bottom: parent.bottom topMargin: sqlite_page.horHeaderHeight } topPadding: -table_view.contentY z: 2 clip: true spacing: 1 Repeater { model: table_view.rows > 0 ? table_view.rows : 0 Rectangle { width: 30 height: table_view.rowHeightProvider(index) color: "green" Text { anchors.centerIn: parent text: table_model.headerData(index, Qt.Vertical) } } } } // JsonListModel { // id: jsonModel // source: table_model.initData // keyField: "id" // } // AppListView { // anchors.fill: parent // bottomMargin: nativeUtils.safeAreaInsets.bottom // model: jsonModel // delegate: SimpleRow { // text: model.sub // } // // Transition animation for adding items // add: Transition { // NumberAnimation { // property: "opacity" // from: 0 // to: 1 // duration: 1000 // easing.type: Easing.OutQuad // } // } // } AppModal { id: sqliteModal fullscreen: false modalHeight: dp(380) + nativeUtils.safeAreaInsets.bottom NavigationStack { AppPage { title: "配置信息管理" rightBarItem: TextButtonBarItem { text: "关闭" textItem.font.pixelSize: sp(16) onClicked: sqliteModal.close() } Column { id: sqliteColumn width: parent.width Section { title: "数据库" ComboBox { id: sqlite_combox height: dp(40) width: parent.width/2 model: ["config.db", "data.db"] } } Section { title: "数据表" ComboBox { id: table_combox height: dp(40) width: parent.width/2 model: ["mqtt", "mqtt_other","ftp","ftp_other","location","camera","data"] onActivated: { console.log(displayText) table_model.table_name = displayText if(displayText===model[0]||displayText===model[1]) { columnWidthArr = [30,100,100,100,100,100,200,100,100,100,100,100,100] table_model.horHeader = table_mqtt_Value } else if(displayText===model[2]||displayText===model[3]) { table_model.horHeader = table_ftp_Value } else if(displayText===model[4]) { table_model.horHeader = table_location_Value }else if(displayText===model[5]){ columnWidthArr = [100,100,150,100,100,100] table_model.horHeader = table_camera_Value } else if(displayText===model[6]) { table_model.horHeader = table_json_Value } table_model.initData=db_cfg.queryData(displayText,datacount) } } } AppText { id: sqlite_text text: "开关:" } AppSwitch { id: sqlite_switch anchors.left: sqlite_text.light anchors.leftMargin: 10 onToggled: { if(sqlite_switch.checked){ var dbs = db_cfg.openDatabase(sqlite_combox.displayText) if(dbs){ console.log("打开数据库成功"); sqlite_combox.enabled = false table_combox.enabled = true if(sqlite_combox.displayText==="data.db") { table_combox.displayText=table_combox.model[6]; } table_model.table_name = table_combox.displayText table_model.initData=db_cfg.queryData(table_combox.displayText,datacount) //text_row_count.text = db_cfg.getTable_row(table_combox.displayText) //rowindex_text.text = datacount }else{ sqlite_switch.checked = false sqlite_combox.enabled = true; console.log("打开数据库失败"); } }else{ sqlite_combox.enabled = true; db_cfg.closeDatabase() console.log("关闭数据库"); } } } } } } } }