def sql_create_mine(name, province, city, region, account_id): mine = Mine() mine.name = name mine.province = province mine.city = city mine.mine_region_id = SQLClientHelper.GetMineRegionIdByField1( 'name', region) mine.account_id = account_id return SQLClientHelper.AddMine(mine)
def onSave(self): mine = SQLClientHelper.GetMineById(self.mine_id) if mine.id <= 0: UiHelper.MessageBox(u'sorry,出了点问题,请联系技术人员(错误码:M4)!') return mine.name = unicode(self.ui.name.text()).encode('utf-8') mine.capacity, ok = self.ui.capacity.text().toDouble() mine.province = unicode(self.ui.province.text()).encode('utf-8') mine.city = unicode(self.ui.city.text()).encode('utf-8') mine.topo_geo = self.ui.topo_geo.currentIndex() + 1 mine.hydr_geo = self.ui.hydr_geo.currentIndex() + 1 mine.ground_condition = int(self.ui.ground_cond.isChecked()) region_name = unicode(self.ui.region.currentText()).encode('utf-8') mine.mine_region_id = SQLClientHelper.GetMineRegionIdByField1( 'name', region_name) if SQLClientHelper.UpdateMine(mine): UiHelper.MessageBox(u'恭喜您,更新矿井数据成功!!!') else: UiHelper.MessageBox(u'sorry,出了点问题,请联系技术人员(错误代:D1)!')