def onWcCacl(self):
index = self.ui.drilling_surf.currentIndex()
if index < 0: return
drilling_surf_id, ok = self.ui.drilling_surf.itemData(index).toInt()
drilling_surf = SQLClientHelper.GetDrillingSurfById(drilling_surf_id)
if drilling_surf.id <= 0:
UiHelper.MessageBox(u'sorry,出了点问题,请联系技术人员(错误码:G11)!')
return
# 保存煤层数据
work_area_id = drilling_surf.work_area_id
work_area = SQLClientHelper.GetWorkAreaById(work_area_id)
if work_area.id <= 0:
UiHelper.MessageBox(u'sorry,出了点问题,请联系技术人员(错误码:G12)!')
return
coal_id = work_area.coal_id
coal = SQLClientHelper.GetCoalById(coal_id)
if coal.id <= 0:
UiHelper.MessageBox(u'sorry,出了点问题,请联系技术人员(错误码:G13)!')
return
# 查看煤质
if coal.quality < 3 or caol.gas_w0 > 10:
pass
# UiHelper.MessageBox(u'弹出对话框让用户选择(尚未实现)')
else:
# 通过经验公式计算
W0 = coal.gas_w0
Wc = 10.385 * exp(-7.207 * W0)
coal.gas_wc2 = Wc
# 更新到界面
self.ui.gas_wc2.setText(u'%.1f' % coal.gas_wc2)
def onDrillingSurfChanged(self, index):
drilling_surf_id, ok = self.ui.drilling_surf.itemData(index).toInt()
drilling_surf = SQLClientHelper.GetDrillingSurfById(drilling_surf_id)
if drilling_surf.id <= 0: return
# 提取数据到界面
self.ui.drilling_surf_qa.setText(u'%.1f' % drilling_surf.qa)
def onDrillingSurfChanged(self, index):
drilling_surf_id, ok = self.ui.drilling_surf.itemData(index).toInt()
drilling_surf = SQLClientHelper.GetDrillingSurfById(drilling_surf_id)
if drilling_surf.id <= 0:
UiHelper.MessageBox(u'sorry,出了点问题,请联系技术人员(错误码:G1)!')
return
# 填充掘进面的数据
self.ui.q4.setText(u'%.1f' % drilling_surf.q4)
self.ui.qa.setText(u'%.1f' % drilling_surf.qa)
# 填充煤层数据
work_area_id = drilling_surf.work_area_id
work_area = SQLClientHelper.GetWorkAreaById(work_area_id)
if work_area.id <= 0:
UiHelper.MessageBox(u'sorry,出了点问题,请联系技术人员(错误码:G2)!')
return
coal_id = work_area.coal_id
coal = SQLClientHelper.GetCoalById(coal_id)
if coal.id <= 0:
UiHelper.MessageBox(u'sorry,出了点问题,请联系技术人员(错误码:G3)!')
return
# 填充煤层数据
self.ui.vr.setText(u'%.1f' % coal.vr)
self.ui.rho.setText(u'%.1f' % coal.rho)
self.ui.gas_w0.setText(u'%.1f' % coal.gas_w0)
self.ui.gas_wc2.setText(u'%.1f' % coal.gas_wc2)
# 填充掘进巷道数据
tunnel_id = drilling_surf.tunnel_id
if tunnel_id <= 0:
self.ui.d.setText(u'0.0')
self.ui.v.setText(u'0.0')
self.ui.l.setText(u'0.0')
self.ui.s.setText(u'0.0')
self.ui.q0.setText(u'0.0')
self.ui.q3.setText(u'0.0')
else:
tunnel = SQLClientHelper.GetTunnelById(tunnel_id)
self.ui.d.setText(u'%.1f' % tunnel.d)
self.ui.v.setText(u'%.1f' % tunnel.v)
self.ui.l.setText(u'%.1f' % tunnel.l)
self.ui.s.setText(u'%.1f' % tunnel.s)
self.ui.q0.setText(u'%.1f' % tunnel.q0)
self.ui.q3.setText(u'%.1f' % tunnel.q3)
def onSave(self):
# 从数据库中查找当前的回采工作面
index = self.ui.work_surf.currentIndex()
if index < 0:
UiHelper.MessageBox(u'sorry,出了点问题,请联系技术人员(错误码:L6)!')
return
work_surf_id, ok = self.ui.work_surf.itemData(index).toInt()
work_surf = SQLClientHelper.GetWorkSurfById(work_surf_id)
if work_surf.id <= 0:
UiHelper.MessageBox(u'sorry,出了点问题,请联系技术人员(错误码:L5)!')
return
# 从界面中读取数据
work_surf.a, ok = self.ui.work_surf_a.text().toDouble()
work_surf.qr, ok = self.ui.work_surf_qr.text().toDouble()
# 提交工作面数据到数据库
if not SQLClientHelper.UpdateWorkSurf(work_surf):
UiHelper.MessageBox(u'sorry,出了点问题,请联系技术人员(错误码:L1)!')
return
# 从数据库中查找当前的掘进面
index = self.ui.drilling_surf.currentIndex()
if index < 0:
UiHelper.MessageBox(u'sorry,出了点问题,请联系技术人员(错误码:L3)!')
return
drilling_surf_id, ok = self.ui.drilling_surf.itemData(index).toInt()
drilling_surf = SQLClientHelper.GetDrillingSurfById(drilling_surf_id)
if drilling_surf.id <= 0:
UiHelper.MessageBox(u'sorry,出了点问题,请联系技术人员(错误码:L4)!')
return
# 从界面中读取数据
drilling_surf.qa, ok = self.ui.drilling_surf_qa.text().toDouble()
# 提交掘进面数据到数据库
if not SQLClientHelper.UpdateDrillingSurf(drilling_surf):
UiHelper.MessageBox(u'sorry,出了点问题,请联系技术人员(错误码:L2)!')
#关闭对话框并返回1
# self.accept()
UiHelper.MessageBox(u'恭喜您,更新数据成功啦!')
def onSave(self):
index = self.ui.drilling_surf.currentIndex()
if index < 0: return
drilling_surf_id, ok = self.ui.drilling_surf.itemData(index).toInt()
drilling_surf = SQLClientHelper.GetDrillingSurfById(drilling_surf_id)
if drilling_surf.id <= 0:
UiHelper.MessageBox(u'sorry,出了点问题,请联系技术人员(错误码:G4)!')
return
# 保存煤层数据
work_area_id = drilling_surf.work_area_id
work_area = SQLClientHelper.GetWorkAreaById(work_area_id)
if work_area.id <= 0:
UiHelper.MessageBox(u'sorry,出了点问题,请联系技术人员(错误码:G9)!')
return
coal_id = work_area.coal_id
coal = SQLClientHelper.GetCoalById(coal_id)
if coal.id <= 0:
UiHelper.MessageBox(u'sorry,出了点问题,请联系技术人员(错误码:G5)!')
return
# 保存掘进巷道数据
tunnel = SQLClientHelper.GetTunnelById(drilling_surf.tunnel_id)
tunnel_id = tunnel.id
if tunnel_id <= 0:
# 新建一条巷道,提交到数据库得到id
tunnel = Tunnel()
tunnel_id = SQLClientHelper.AddTunnel(tunnel)
# 更新掘进面关联的掘进巷道id
drilling_surf.tunnel_id = tunnel_id
# 从界面中读取掘进巷道的数据
tunnel.d, ok = self.ui.d.text().toDouble()
tunnel.v, ok = self.ui.v.text().toDouble()
tunnel.l, ok = self.ui.l.text().toDouble()
tunnel.s, ok = self.ui.s.text().toDouble()
tunnel.q0, ok = self.ui.q0.text().toDouble()
tunnel.q3, ok = self.ui.q3.text().toDouble()
# 从界面中读取掘进面数据
drilling_surf.q4, ok = self.ui.q4.text().toDouble()
drilling_surf.qa, ok = self.ui.qa.text().toDouble()
# 从界面中读取煤层数据
coal.vr, ok = self.ui.vr.text().toDouble()
coal.rho, ok = self.ui.rho.text().toDouble()
coal.gas_w0, ok = self.ui.gas_w0.text().toDouble()
coal.gas_wc2, ok = self.ui.gas_wc2.text().toDouble()
# 提交到数据库
if not SQLClientHelper.UpdateDrillingSurf(drilling_surf):
UiHelper.MessageBox(u'sorry,出了点问题,请联系技术人员(错误码:G6)!')
return
if not SQLClientHelper.UpdateTunnel(tunnel):
UiHelper.MessageBox(u'sorry,出了点问题,请联系技术人员(错误码:G7)!')
return
if not SQLClientHelper.UpdateCoal(coal):
UiHelper.MessageBox(u'sorry,出了点问题,请联系技术人员(错误码:G8)!')
return
#关闭对话框并返回1
# self.accept()
UiHelper.MessageBox(u'恭喜您,更新数据成功啦!')
def onCacl(self):
index = self.ui.drilling_surf.currentIndex()
if index < 0: return
drilling_surf_id, ok = self.ui.drilling_surf.itemData(index).toInt()
drilling_surf = SQLClientHelper.GetDrillingSurfById(drilling_surf_id)
if drilling_surf.id <= 0:
UiHelper.MessageBox(u'sorry,出了点问题,请联系技术人员(错误码:G14)!')
return
# 保存煤层数据
work_area_id = drilling_surf.work_area_id
work_area = SQLClientHelper.GetWorkAreaById(work_area_id)
if work_area.id <= 0:
UiHelper.MessageBox(u'sorry,出了点问题,请联系技术人员(错误码:G15)!')
return
coal_id = work_area.coal_id
coal = SQLClientHelper.GetCoalById(coal_id)
if coal.id <= 0:
UiHelper.MessageBox(u'sorry,出了点问题,请联系技术人员(错误码:G16)!')
return
# 保存掘进巷道数据
tunnel = SQLClientHelper.GetTunnelById(drilling_surf.tunnel_id)
tunnel_id = tunnel.id
if tunnel_id <= 0:
# 新建一条巷道
tunnel = Tunnel()
# 更新掘进面关联的掘进巷道id
drilling_surf.tunnel_id = tunnel_id
# 从界面中读取掘进巷道的数据
tunnel.d, ok = self.ui.d.text().toDouble()
tunnel.v, ok = self.ui.v.text().toDouble()
tunnel.l, ok = self.ui.l.text().toDouble()
tunnel.s, ok = self.ui.s.text().toDouble()
tunnel.q0, ok = self.ui.q0.text().toDouble()
tunnel.q3, ok = self.ui.q3.text().toDouble()
# 从界面中读取掘进面数据
drilling_surf.q4, ok = self.ui.q4.text().toDouble()
drilling_surf.qa, ok = self.ui.qa.text().toDouble()
# 从界面中读取煤层数据
coal.vr, ok = self.ui.vr.text().toDouble()
coal.rho, ok = self.ui.rho.text().toDouble()
coal.gas_w0, ok = self.ui.gas_w0.text().toDouble()
coal.gas_wc2, ok = self.ui.gas_wc2.text().toDouble()
# 数据检查
if tunnel.v <= 0:
UiHelper.MessageBox(u'巷道掘进速度v必须取大于0的值')
return
# 调用rpc计算掘进面瓦斯涌出量
ret = CbmClientHelper.DrillingSurfGasFlow(coal, drilling_surf, tunnel)
# 计算结果更新到界面
tunnel.q0 = ret.q0
tunnel.q3 = ret.q3
drilling_surf.q4 = ret.q4
drilling_surf.qa = ret.qa
UiHelper.MessageBox(u'数据计算成功,请查看"瓦斯涌出量预测结果"部分的数据!')
