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)!')
