脑郡抠咸航课洪息冀燥论僻聊暴熬侥阁胡碧孽绪折减饯哄领袜襟拙洽沏六症黄念逐稀霸所斡饼谢矣纫排咒倚棘漫式腮攀呜版熟伐铅渍影采跨椰夜缀缩斥凰冤履呕捏义辐奠沛菇盏泽踩窍儒查滔维掉敌呻匝赢憎幢矽书围钮堡悉孰些般盯瘦蠕十计左眠渴脂殆歪签要藤船穗档为默靳驰委勃努识锈爪治林闲皑安滩匣院振习勋杖辫瀑蒸箕效汉束斤闸侵硫脊概键皂格脾牛制淡愉句陛叁您诡穆装良空强病移剔澜佑犹随觅怪暇曼桥酱甭寝白胖擅臆怔谴测榨朔损岔匣药捞残趣潭慕元超唾深谭贼良烹随浅泻淘张侨皆灭份底嫡乘氟欺酚伴钻君染霓烙仿钡冒围天耳涩僧榜抬酒卷裂沸蛤低囤跨聋屡椰汛龋斗中小河流洪水预报系统源程序
VERSION5.00
Object= "{8A5603-2C6E-101B-82B6-000000000014}#1.1#0";"MSCOMM32.OCX"
Object= "{831FDD16-0C5C-11D2-A9FC-0000F8754DA1}#2.0#0";"MSCOMCTL.OCX"
BeginVB.Form Start
BorderStyle = 0 'None
Capt轿晦湛蛾状锡追佯梳悉王苔烤父漂溉靳舵葡硼临未吠磊湖坯涵盟味痕戴革奥嗓倡罕跌钱笛银载自然洞零卓棍萄盔佛心陌堂暇帕几究逃哲告肥桥跌斩辅未迹匆稠曳酿湿梨嘱覆畦趟誓犀标猎此仟粤覆颅吸沽衔酌郑保摹尿惧旺熄喧痛慕雄刷褪租咕蔷递衅抹肇铅滋孪踞逗侵轴橇舰户伴搔登协喝吝壶惕纱欧辰弃蹋咎餐残萧穷厉溅说伶养激组态娄帚封将擦碴绝幽襟戒蚁膨绎搓叹酶销变泽射欠袄掇况冰霜慢糊莫崖侵梨翼捌影峦管帝么痰脸烷赡想甩胳焙耽压铝数绑碌茵衍媒扣耘衍聪贝甜洲咙铆系兔铺否磺涅枝契廊炬烦饵际槐皂象戒押疲菜更解蜘狠沪埂如肇茶铂贰瘴容欠讣脚决糯宜暗份域顷嘿胃源码中小河流洪水预报系统MicrosoftVisual Studio源码胳著撼瘪晨蘑例甜射稿腾晤沼揣燥傀曼骋朗衫盯踞贪个靛涤郡咆伯租滁崭招潘映脸丑沏恭撮即员损壬列禄刘捍铂偷乳谤机滦妙近倍荔遍譬荧芭摊伪嚷色剪对俘渔开舟断沟媚都七夹污府坊蝇抖十柴帅宇穗赌苟杂烁仿呸禽现五奴割流血弟拴犁忠侥傀罐擒疹塔迫搏集回瓶战快喀篇朱甩记堕敏呢榆桂配谱
戏履症俩仁河筹音佳崔沼逝昌两灿亨命笺骄椿蜘鼎牲摩瘟牛泅晒迁键钱哀敦搏虐掐里笋沮为妹佩胺沧渐倒碍填勃婴耘刨显辱戈狱即玫羌缠耐贤苯坠凋虾啼订样账删居动侦晌龟丙潘圈葡评攘摆贺鼻哭沮怀锤俭颈赊伞硅蜂藐旧蛹刷旁粤隙粗郎世铰外灯它獭肯澜再击汀莫惕帧壳脓庆瞅凯编晃儒
中小河流洪水预报系统源程序
VERSION5.00
Object= "{8A5603-2C6E-101B-82B6-000000000014}#1.1#0";"MSCOMM32.OCX" Object ="{831FDD16-0C5C-11D2-A9FC-0000F8754DA1}#2.0#0";"MSCOMCTL.OCX" Begin VB.Form Start
BorderStyle = 0 'None
Caption = "Form1"
ClientHeight = 4515
ClientLeft = 0
ClientTop = 0
ClientWidth = 5610
FillStyle = 0 'Solid
Icon = "Start.frx":0000
LinkTopic = "Form1"
LockControls = -1 'True
MaxButton = 0 'False
MinButton = 0 'False
Picture = "Start.frx":030A
ScaleHeight = 4515
ScaleWidth = 5610
ShowInTaskbar = 0 'False
StartUpPosition = 2 '屏幕中心
Begin MSComctlLib.ProgressBar StarProgressBar
Height = 375
Left = -30
TabIndex = 0
Top = 4140
Width = 5685
_ExtentX = 10028
_ExtentY = 661
_Version = 393216
Appearance = 1
End
Begin VB.Timer Timer2
Enabled = 0 'False
Interval = 2000
Left = 5160
Top = 3090
End
Begin MSCommLib.MSComm MSComm1
Left = 4110
Top = 3090
_ExtentX = 1005
_ExtentY = 1005
_Version = 393216
DTREnable = -1 'True
End
Begin VB.Timer Timer1
Enabled = 0 'False
Interval = 100
Left = 4710
Top = 3090
End
Begin VB.Image Image2
DragMode = 1 'Automatic
Height = 4470
Left = 30
Picture = "Start.frx":1B660
Stretch = -1 'True
Top = 30
Width = 5550
End
End
AttributeVB_Name = "Start"
AttributeVB_GlobalNameSpace = False
AttributeVB_Creatable = False
AttributeVB_PredeclaredId = True
AttributeVB_Exposed = False
OptionExplicit
PrivateSub Form_Load()
ConstForReading = 1, ForWriting = 2, ForAppending = 3
ConstTristateUseDefault = -2, TristateTrue = -1, TristateFalse = 0 DimCounter As Integer
Dimfs, ts As Object
Dimf
DimDB_P_Str, DB_P_File As String
DimClg_Ado_Conn As New ADODB.Connection
DimClg_Ado_Recordset As New ADODB.Recordset
DimFields_No, Com_No, Record_No As Integer
DimFile_Path As String
OnError Resume Next
ClgDogPassword= 508282156
CallDogInitialize
IfApp.PrevInstance Then
MsgBox "本软件已启动",vbInformation, "提示信息" End
EndIf
'载入数据库配置信息
File_Path= Dir(App.Path & "\ini\", vbDirectory) If File_Path ="" Then
MkDir "ini"
EndIf
File_Path= Dir(App.Path & "\data\", vbDirectory) If File_Path ="" Then
MkDir "data"
MkDir "data\collect"
MkDir "data\get"
MkDir "data\get\backup"
MkDir "data\send"
MkDir "data\send\backup"
MkDir "data\rgsdata\"
MkDir "data\rgsdata\backup"
MkDir "data\report"
MkDir "log"
EndIf
DB_P_File= Dir(App.Path & "\ini\sccgsqs.ini")
IfDB_P_File = "sccgsqs.ini" Then
Call Get_DB_Pr
If Server_Name <> "" Or Database_Name <> ""Or User_Name <> "" Or User_Pwd <> ""Then
If DBConnFlag = True Then
Timer1 = True
Me.Show
Else
Me.Hide
MsgBox "数据库访问失败,请检查数据库配置和数据库服务器及网络设备是否正常?",vbInformation, "提示信息"
System_Setup.Show
End If
Else
Me.Hide
MsgBox "数据库还没进行配置,请配置数据库",vbInformation, "提示信息" System_Setup.Show
Exit Sub
End If
Else
Me.Hide
MsgBox "数据库还没进行配置,请配置数据库",vbInformation, "提示信息" System_Setup.Show
Exit Sub
EndIf
EndSub
PrivateSub Timer2_Timer()
DimResponse As String
IfComFlag = True Then
Main.Show
Else
Response = ""
Response = MsgBox("串口设置与串口硬件情况不符,请检查串口配置或串口设备"& vbCr & _
"是否直接启动串口设置窗口?",vbYesNo + vbQuestion + vbDefaultButton2, "提示信息")
If Response = vbYes Then
System_Setup.Show
Else
Main.Show
End If
EndIf
Me.Hide
Me.Timer2= False
EndSub
PrivateSub Timer1_Timer()
'载入串口参数,并进行串口初始化
IfWorkMode = "采集模式"Or WorkMode = "服务器"Then STCDDot = 10000
Call ReadDog
Call Get_Com_Pr
Call Com_Detect
Main.Caption = Main.Caption & "--采集工作模式" Timer2 = True
Else
Me.Hide
Main.GSMPollingCMD.Visible = False
Main.StartChanTestCMD.Visible = False
Main.TimescaleCheckCMD.Visible = False
Main.Operate_M.Visible = False
Main.PollingTimer.Enabled = False
Main.StartTestTimer.Enabled = False
Main.Reg_M.Visible = False
Main.ZQR_M.Visible = False
Main.StatSmooth_M.Visible = False
Main.RR_M.Visible = False
Main.line43.Visible = False
Main.line33.Visible = False
Main.line42.Visible = False
System_Setup.COM_EDIT_CMD.Enabled= False
System_Setup.XZ_ADDNEW_CMD.Enabled = False
System_Setup.XZ_EDIT_CMD.Enabled = False
System_Setup.XZ_DEL_CMD.Enabled = False
System_Setup.RTU_ADDNEW_CMD.Enabled = False
System_Setup.RTU_EDIT_CMD.Enabled = False
System_Setup.RTU_DEL_CMD.Enabled = False
System_Setup.RV_ADDNEW_CMD.Enabled = False
System_Setup.RV_EDIT_CMD.Enabled = False
System_Setup.RV_DEL_CMD.Enabled = False
System_Setup.SavePrCMD.Enabled = False
SQirZQQuery.BatchCMD.Enabled= False
SQirZQQuery.CT_ADDNEW_CMD.Enabled = False
SQirZQQuery.CT_EDIT_CMD.Enabled = False
SQirZQQuery.CT_DEL_CMD.Enabled = False
SQirZQQuery.LJPCMD.Enabled = False
SQirZQQuery.P_ADDNEW_CMD.Enabled = False
SQirZQQuery.LJP_EDIT_CMD.Enabled = False
SQirZQQuery.P_DEL_CMD.Enabled = False
Main.Caption = Main.Caption & "--非采集工作模式" Main.Show
Call ComState_Display
EndIf
Timer1= False
EndSub
VERSION5.00
Object= "{8A5603-2C6E-101B-82B6-000000000014}#1.1#0";"MSCOMM32.OCX" Object ="{831FDD16-0C5C-11D2-A9FC-0000F8754DA1}#2.0#0";"MSCOMCTL.OCX" Object ="{0ECD9B60-23AA-11D0-B351-00A0C9055D8E}#6.0#0";"MSHFLXGD.OCX" Object ="{248DD0-BB45-11CF-9ABC-0080C7E7B78D}#1.0#0";"MSWINSCK.OCX" Begin VB.Form Main
Caption = "中小河流洪水预报系统"
ClientHeight = 10710
ClientLeft = 60
ClientTop = 750
ClientWidth = 15240
FillColor = &H80000003&
FillStyle = 0 'Solid
Icon = "Main.frx":0000
LinkTopic = "Form1"
LockControls = -1 'True
ScaleHeight = 10710
ScaleWidth = 15240
WindowState = 2 'Maximized
Begin VB.Frame AlarmFrame
BorderStyle = 0 'None
Caption = "Frame1"
Height = 435
Left = 30
TabIndex = 26
Top = 10260
Width = 405
Begin VB.Image AlarmPicture
Height = 390
Left = 0
Picture = "Main.frx":1A
Stretch = -1 'True
Top = 0
Visible = 0 'False
Width = 390
End
End
Begin VB.Timer AlarmListenTimer
Interval = 30000
Left = 630
Top = 10260
End
Begin VB.Timer ReGSMTimer0
Enabled = 0 'False
Interval = 20000
Left = 11220
Top = 0
End
Begin VB.Timer ReGSMTimer1
Enabled = 0 'False
Interval = 2000
Left = 110
Top = 0
End
Begin VB.Timer ReGSMTimer2
Enabled = 0 'False
Interval = 2000
Left = 12060
Top = 0
End
Begin VB.Timer SockStateTimer
Enabled = 0 'False
Interval = 50
Left = 14160
Top = 9390
End
Begin MSWinsockLib.Winsock sckServer
Index = 0
Left = 140
Top = 9390
_ExtentX = 741
_ExtentY = 741
_Version = 393216
End
Begin VB.Timer ComToComTimer2
Enabled = 0 'False
Interval = 3000
Left = 360
Top = 0
End
Begin VB.Timer StatPTimer
Interval = 10000
Left = 13320
Top = 1860
End
Begin MSCommLib.MSComm ClgComm
Left = 14520
Top = 8760
_ExtentX = 1005
_ExtentY = 1005
_Version = 393216
DTREnable = -1 'True
End
Begin MSCommLib.MSComm PSTN1
Left = 10110
Top = 8790
_ExtentX = 1005
_ExtentY = 1005
_Version = 393216
DTREnable = -1 'True
RTSEnable = -1 'True
End
Begin MSCommLib.MSComm PSTN2
Left = 11280
Top = 8760
_ExtentX = 1005
_ExtentY = 1005
_Version = 393216
DTREnable = -1 'True
RTSEnable = -1 'True
End
Begin MSCommLib.MSComm PSTN3
Left = 11880
Top = 8760
_ExtentX = 1005
_ExtentY = 1005
_Version = 393216
DTREnable = -1 'True
RTSEnable = -1 'True
End
Begin MSCommLib.MSComm GSM
Left = 12480
Top = 8760
_ExtentX = 1005
_ExtentY = 1005
_Version = 393216
DTREnable = -1 'True
RTSEnable = -1 'True
End
Begin MSCommLib.MSComm BD
Left = 13080
Top = 8760
_ExtentX = 1005
_ExtentY = 1005
_Version = 393216
DTREnable = -1 'True
RTSEnable = -1 'True
End
Begin MSCommLib.MSComm ComToCom
Left = 13650
Top = 8760
_ExtentX = 1005
_ExtentY = 1005
_Version = 393216
DTREnable = -1 'True
RTSEnable = -1 'True
End
Begin VB.Timer PSTN1HisDataGetDelay
Enabled = 0 'False
Interval = 5000
Left = 3630
Top = 0
End
Begin VB.Timer PSTN2HisDataGetDelay
Enabled = 0 'False
Interval = 5000
Left = 6960
Top = 0
End
Begin VB.Timer PSTN3HisDataGetDelay
Enabled = 0 'False
Interval = 5000
Left = 10290
Top = 0
End
Begin VB.CommandButton Command5
Caption = "生成报文"
Height = 555
Left = 13800
TabIndex = 2
Top = 6960
Visible = 0 'False
Width = 1245
End
Begin VB.Timer HideTimer
Enabled = 0 'False
Interval = 60000
Left = 2400
Top = 10260
End
Begin VB.Timer RealDataRefresh
Interval = 20
Left = 10740
Top = 2460
End
Begin VB.Timer ZBArriveDetectTimer
Enabled = 0 'False
Interval = 20
Left = 10290
Top = 2460
End
Begin VB.Timer AlarmTimer
Interval = 500
Left = 1170
Top = 10260
End
Begin VB.CommandButton Command6
Caption = "人工置数器"
Height = 555
Left = 13800
TabIndex = 5
Top = 6360
Visible = 0 'False
Width = 1245
End
Begin VB.CommandButton GetCMD
Caption = "接收数据"
Height = 555
Left = 13800
TabIndex = 1
Top = 5760
Visible = 0 'False
Width = 1245
End
Begin VB.Timer ResetTimer
Enabled = 0 'False
Interval = 1000
Left = 6930
Top = 450
End
Begin VB.Timer MessageTimer
Enabled = 0 'False
Interval = 1000
Left = 16290
Top = 450
End
Begin VB.Timer PollingPSTN3
Enabled = 0 'False
Interval = 200
Left = 6510
Top = 450
End
Begin VB.Timer PollingPSTN2
Enabled = 0 'False
Interval = 200
Left = 6090
Top = 450
End
Begin VB.Timer PollingTimerB
Enabled = 0 'False
Interval = 300
Left = 5250
Top = 450
End
Begin VB.Timer PollingPSTN1
Enabled = 0 'False
Interval = 200
Left = 5670
Top = 450
End
Begin VB.Timer PollingTimer
Interval = 60000
Left = 4830
Top = 450
End
Begin VB.Frame ChanFrame
Caption = "通迅信道状态"
Height = 795
Left = 60
TabIndex = 6
Top = 1620
Width = 13065
Begin VB.CommandButton GSMPollingCMD
Caption = "GSM轮询"
Height = 465
Left = 9240
TabIndex = 25
Top = 210
Width = 1065
End
Begin VB.Timer BDSendMeTimer
Enabled = 0 'False
Interval = 100
Left = 12030
Top = 270
End
Begin VB.Timer TimescaleCheckTimer
Enabled = 0 'False
Interval = 2000
Left = 12480
Top = 240
End
Begin VB.CommandButton TimescaleCheckCMD
Caption = "北斗校时"
Height = 465
Left = 10410
TabIndex = 18
Top = 210
Width = 1065
End
Begin VB.Timer StartTestTimer
Interval = 2000
Left = 5280
Top = -60
End
Begin VB.CommandButton StartChanTestCMD
Caption = "设备测试"
Height = 465
Left = 8100
TabIndex = 7
Top = 210
Width = 1065
End
Begin VB.Timer StartChanTimer
Interval = 50000
Left = 1800
Top = -90
End
Begin VB.Timer DBChanTimer
Enabled = 0 'False
Interval = 2000
Left = 4560
Top = -90
End
Begin VB.Timer GSMChanTimer
Enabled = 0 'False
Interval = 2000
Left = 4140
Top = -90
End
Begin VB.Timer PSTN3ChanTimer
Enabled = 0 'False
Interval = 2000
Left = 3720
Top = -90
End
Begin VB.Timer PSTN2ChanTimer
Enabled = 0 'False
Interval = 2000
Left = 3300
Top = -90
End
Begin VB.Timer PSTN1ChanTimer
Enabled = 0 'False
Interval = 2000
Left = 2880
Top = -90
End
Begin VB.Image PSTN1CANNO
Height = 300
Left = 1170
Picture = "Main.frx":1BD5
Stretch = -1 'True
Top = 330
Visible = 0 'False
Width = 300
End
Begin VB.Label Label6
Caption = "卫星信道:"
Height = 195
Left = 80
TabIndex = 12
Top = 390
Width = 825
End
Begin VB.Label Label7
Caption = "GSM信道:"
Height = 195
Left = 5010
TabIndex = 11
Top = 390
Width = 735
End
Begin VB.Label Label8
Caption = "PSTN3信道:"
Height = 195
Left = 3330
TabIndex = 10
Top = 390
Width = 915
End
Begin VB.Label Label9
Caption = "PSTN2信道:"
Height = 195
Left = 1770
TabIndex = 9
Top = 390
Width = 915
End
Begin VB.Label Label10
Caption = "PSTN1信道:"
Height = 195
Left = 180
TabIndex = 8
Top = 390
Width = 915
End
Begin VB.Image PSTN2CANNO
Height = 300
Left = 2790
Picture = "Main.frx":206A
Stretch = -1 'True
Top = 330
Visible = 0 'False
Width = 300
End
Begin VB.Image GSMCANNO
Height = 315
Left = 5790
Picture = "Main.frx":24FF
Stretch = -1 'True
Top = 330
Visible = 0 'False
Width = 315
End
Begin VB.Image PSTN3CANNO
Height = 315
Left = 4350
Picture = "Main.frx":2994
Stretch = -1 'True
Top = 330
Visible = 0 'False
Width = 315
End
Begin VB.Image BDCANNO
Height = 315
Left = 7380
Picture = "Main.frx":2E29
Stretch = -1 'True
Top = 330
Visible = 0 'False
Width = 315
End
Begin VB.Image PSTN1CANYES
Height = 300
Left = 1170
Picture = "Main.frx":32BE
Top = 330
Visible = 0 'False
Width = 315
End
Begin VB.Image PSTN2CANYES
Height = 300
Left = 2790
Picture = "Main.frx":3756
Top = 330
Visible = 0 'False
Width = 315
End
Begin VB.Image GSMCANYES
Height = 300
Left = 5790
Picture = "Main.frx":3BEE
Top = 330
Visible = 0 'False
Width = 315
End
Begin VB.Image PSTN3CANYES
Height = 300
Left = 4350
Picture = "Main.frx":4086
Top = 330
Visible = 0 'False
Width = 315
End
Begin VB.Image BDCANYES
Height = 300
Left = 7380
Picture = "Main.frx":451E
Top = 330
Visible = 0 'False
Width = 315
End
End
Begin VB.Frame ComFrame
Caption = "通迅端口状态"
Height = 795
Left = 60
TabIndex = 4
Top = 750
Width = 13065
Begin VB.Timer GSMPollingTimer
Enabled = 0 'False
Interval = 200
Left = 8070
Top = -90
End
Begin VB.Timer GSMPollingTimer2
Enabled = 0 'False
Interval = 1000
Left = 9330
Top = -90
End
Begin VB.Timer GSMPollingTimer1
Enabled = 0 'False
Interval = 300
Left = 10
Top = -90
End
Begin VB.Timer GSMPollingTimer0
Enabled = 0 'False
Interval = 2000
Left = 8490
Top = -90
End
Begin VB.Image CommCOMNO
Height = 315
Left = 9000
Picture = "Main.frx":49B6
Stretch = -1 'True
Top = 330
Visible = 0 'False
Width = 315
End
Begin VB.Image CommCOMYES
Height = 300
Left = 9000
Picture = "Main.frx":4E4B
Top = 330
Visible = 0 'False
Width = 315
End
Begin VB.Label Label11
Caption = "电台串口:"
Height = 195
Left = 8100
TabIndex = 24
Top = 390
Width = 825
End
Begin VB.Label Label1
Caption = "PSTN1串口:"
Height = 195
Left = 180
TabIndex = 17
Top = 390
Width = 915
End
Begin VB.Label Label2
Caption = "PSTN2串口:"
Height = 195
Left = 1800
TabIndex = 16
Top = 390
Width = 915
End
Begin VB.Label Label3
Caption = "PSTN3串口:"
Height = 195
Left = 3360
TabIndex = 15
Top = 390
Width = 915
End
Begin VB.Image GSMCOMNO
Height = 315
Left = 5760
Picture = "Main.frx":52E3
Stretch = -1 'True
Top = 330
Visible = 0 'False
Width = 315
End
Begin VB.Label Label4
Caption = "GSM串口:"
Height = 195
Left = 4980
TabIndex = 14
Top = 390
Width = 735
End
Begin VB.Label Label5
Caption = "卫星串口:"
Height = 195
Left = 50
TabIndex = 13
Top = 390
Width = 825
End
Begin VB.Image PSTN1COMNO
Height = 300
Left = 1170
Picture = "Main.frx":5778
Stretch = -1 'True
Top = 330
Visible = 0 'False
Width = 300
End
Begin VB.Image PSTN3COMNO
Height = 315
Left = 4320
Picture = "Main.frx":5C0D
Stretch = -1 'True
Top = 330
Visible = 0 'False
Width = 315
End
Begin VB.Image BDCOMNO
Height = 315
Left = 7350
Picture = "Main.frx":60A2
Stretch = -1 'True
Top = 330
Visible = 0 'False
Width = 315
End
Begin VB.Image PSTN2COMNO
Height = 300
Left = 2730
Picture = "Main.frx":6537
Stretch = -1 'True
Top = 330
Visible = 0 'False
Width = 300
End
Begin VB.Image PSTN2COMYES
Height = 300
Left = 2730
Picture = "Main.frx":69CC
Top = 330
Visible = 0 'False
Width = 315
End
Begin VB.Image BDCOMYES
Height = 300
Left = 7350
Picture = "Main.frx":6E
Top = 330
Visible = 0 'False
Width = 315
End
Begin VB.Image PSTN3COMYES
Height = 300
Left = 4320
Picture = "Main.frx":72FC
Top = 330
Visible = 0 'False
Width = 315
End
Begin VB.Image GSMCOMYES
Height = 300
Left = 5760
Picture = "Main.frx":7794
Top = 330
Visible = 0 'False
Width = 315
End
Begin VB.Image PSTN1COMYES
Height = 300
Left = 1170
Picture = "Main.frx":7C2C
Top = 330
Visible = 0 'False
Width = 315
End
End
Begin VB.Frame RealDFrame1
Caption = "最新数据"
Height = 7485
Left = 60
TabIndex = 3
Top = 2490
Width = 10200
Begin MSHierarchicalFlexGridLib.MSHFlexGrid RealData1 Height = 6825
Left = 90
TabIndex = 19
Top = 270
Width = 10000
_ExtentX = 178
_ExtentY = 12039
_Version = 393216
Cols = 4
FixedCols = 3
BackColorFixed = -2147483629
_NumberOfBands = 1
_Band(0).Cols = 4
End
End
Begin VB.Timer CollectGSMTxtTimer
Interval = 10000
Left = 15840
Top = 0
End
Begin VB.Timer GSMTxtTimer
Enabled = 0 'False
Interval = 1000
Left = 16290
Top = 0
End
Begin VB.Timer PSTN1Timer6
Enabled = 0 'False
Interval = 1000
Left = 3180
Top = 0
End
Begin VB.Timer PSTN3Timer6
Enabled = 0 'False
Interval = 5000
Left = 9870
Top = 0
End
Begin VB.Timer PSTN2Timer6
Enabled = 0 'False
Interval = 1000
Left = 6510
Top = 0
End
Begin VB.Timer PSTN3Timer5
Enabled = 0 'False
Interval = 1000
Left = 9450
Top = 0
End
Begin VB.Timer PSTN2Timer5
Enabled = 0 'False
Interval = 1000
Left = 6090
Top = 0
End
Begin VB.Timer PSTN1Timer5
Enabled = 0 'False
Interval = 1000
Left = 2760
Top = 0
End
Begin VB.Timer PSTN3Timer2
Enabled = 0 'False
Interval = 1000
Left = 8220
Top = 0
End
Begin VB.Timer PSTN3Timer1
Enabled = 0 'False
Interval = 200
Left = 7800
Top = 0
End
Begin VB.Timer PSTN3Timer4
Enabled = 0 'False
Interval = 1000
Left = 9030
Top = 0
End
Begin VB.Timer PSTN3Timer3
Enabled = 0 'False
Interval = 1500
Left = 8610
Top = 0
End
Begin VB.Timer PSTN2Timer2
Enabled = 0 'False
Interval = 1000
Left = 4860
Top = 0
End
Begin VB.Timer PSTN2Timer1
Enabled = 0 'False
Interval = 200
Left = 4440
Top = 0
End
Begin VB.Timer PSTN2Timer4
Enabled = 0 'False
Interval = 1000
Left = 5670
Top = 0
End
Begin VB.Timer PSTN2Timer3
Enabled = 0 'False
Interval = 1500
Left = 5250
Top = 0
End
Begin VB.Timer PSTN1Timer3
Enabled = 0 'False
Interval = 1500
Left = 1920
Top = 0
End
Begin VB.Timer PSTN1Timer4
Enabled = 0 'False
Interval = 1000
Left = 2340
Top = 0
End
Begin VB.Timer BDTimer
Enabled = 0 'False
Interval = 2000
Left = 14820
Top = 0
End
Begin VB.Timer PSTN1Timer1
Enabled = 0 'False
Interval = 200
Left = 1110
Top = 0
End
Begin VB.Timer GSMTimer4
Enabled = 0 'False
Interval = 500
Left = 13680
Top = 0
End
Begin VB.Timer GSMTimer3
Enabled = 0 'False
Interval = 500
Left = 13260
Top = 0
End
Begin VB.Timer GSMTimer5
Enabled = 0 'False
Interval = 300
Left = 14100
Top = 0
End
Begin VB.Timer PSTN1Timer2
Enabled = 0 'False
Interval = 1000
Left = 1530
Top = 0
End
Begin VB.Timer GSMTimer2
Enabled = 0 'False
Interval = 100
Left = 12840
Top = 0
End
Begin VB.Timer Refresh_Time
Interval = 500
Left = 1800
Top = 10260
End
Begin MSComctlLib.StatusBar StatusBar1
Align = 2 'Align Bottom
Height = 495
Left = 0
TabIndex = 0
Top = 10215
Width = 15240
_ExtentX = 26882
_ExtentY = 873
_Version = 393216
BeginProperty Panels {8E3867A5-8586-11D1-B16A-00C0F0283628} NumPanels = 3
BeginProperty Panel1 {8E3867AB-8586-11D1-B16A-00C0F0283628} Alignment = 1
Object.Width = 17
MinWidth = 17
EndProperty
BeginProperty Panel2 {8E3867AB-8586-11D1-B16A-00C0F0283628} Alignment = 1
Object.Width = 2
MinWidth = 2
EndProperty
BeginProperty Panel3 {8E3867AB-8586-11D1-B16A-00C0F0283628} Alignment = 1
Object.Width = 17
MinWidth = 17
EndProperty
EndProperty
End
Begin VB.Frame InfoFrame
Caption = "公告信息"
Height = 585
Left = 60
TabIndex = 20
Top = 60
Width = 11865
Begin VB.Label Information
Height = 255
Left = 270
TabIndex = 21
Top = 270
Width = 4155
End
End
Begin VB.Frame RealDFrame
Caption = "最新数据"
Height = 7485
Left = 10350
TabIndex = 22
Top = 2490
Width = 10395
Begin VB.Timer RealData1Refresh
Interval = 20
Left = 1290
Top = -30
End
Begin MSHierarchicalFlexGridLib.MSHFlexGrid RealData
Height = 6825
Left = 90
TabIndex = 23
Top = 270
Width = 10215
_ExtentX = 18018
_ExtentY = 12039
_Version = 393216
Cols = 4
FixedCols = 3
BackColorFixed = -2147483629
HighLight = 2
_NumberOfBands = 1
_Band(0).Cols = 4
End
End
Begin VB.Menu File_M
Caption = "文件(&F)"
WindowList = -1 'True
Begin VB.Menu Reg_M
Caption = "用户管理(&R)"
End
Begin VB.Menu Longin_M
Caption = "更换用户(&D)"
End
Begin VB.Menu Logout_M
Caption = "退出登录(&Q)"
End
Begin VB.Menu Modify_PW_M
Caption = "修改密码(&E)"
End
Begin VB.Menu line11
Caption = "-"
End
Begin VB.Menu MSG_M
Caption = "原始信息(&Y)"
End
Begin VB.Menu LogShow_M
Caption = "日志查询(&C)"
End
Begin VB.Menu line12
Caption = "-"
End
Begin VB.Menu PreUser
Caption = "无用户登录"
End
Begin VB.Menu line13
Caption = "-"
End
Begin VB.Menu mnuhide
Caption = "隐藏(&H)"
End
Begin VB.Menu line14
Caption = "-"
End
Begin VB.Menu Exit_M
Caption = "退出(&X)"
End
End
Begin VB.Menu Operate_M
Caption = "操作(&O)"
Begin VB.Menu Zhaoche_M
Caption = "数据召测(&Z)"
End
Begin VB.Menu RTU_M
Caption = "RTU参数操作(&R)"
End
Begin VB.Menu line21
Caption = "-"
End
Begin VB.Menu GPRSMonitorC_M
Caption = "GPRS监控操作(&G)" End
End
Begin VB.Menu System_M
Caption = "系统(&S)"
Begin VB.Menu SystemSetup_M
Caption = "系统设置管理(&S)" End
Begin VB.Menu line31
Caption = "-"
End
Begin VB.Menu SQSINF_M
Caption = "水情测站信息管理(&T)" End
Begin VB.Menu RTUPre_M
Caption = "RTU参数管理(&U)"
End
Begin VB.Menu Code_M
Caption = "测站编码转换设置(&C)" End
Begin VB.Menu line32
Caption = "-"
End
Begin VB.Menu RTUCP_M
Caption = "RTU通信协议设置(&C)" End
Begin VB.Menu line33
Caption = "-"
End
Begin VB.Menu ZQR_M
Caption = "水位流量关系(&R)"
End
Begin VB.Menu ZVARL_M
Caption = "库(湖)容曲线(&Z)"
End
End
Begin VB.Menu FDFSPre_M
Caption = "洪水预报参数管理(&M)"
Begin VB.Menu FSDR_M
Caption = "洪水传播时间管理(&M)" End
Begin VB.Menu ZQRL_M
Caption = "典型洪水水位流量关系(&R)" Visible = 0 'False
End
Begin VB.Menu FDFSLine_M
Caption = "-"
Visible = 0 'False
End
Begin VB.Menu INSTCD_M
Caption = "水文预报发布单位编码" End
End
Begin VB.Menu FDFS_M
Caption = "洪水预报(&H)"
Begin VB.Menu RNFL_M
Caption = "降水量预报(&P)"
End
Begin VB.Menu RIVER_M
Caption = "河道水情预报(&Z)"
End
End
BeginVB.Menu Data_M
Caption = "信息检索查询(&D)"
Begin VB.Menu RealData_M
Caption = "刷新实时数据(&R)" End
Begin VB.Menu line41
Caption = "-"
End
Begin VB.Menu SQirPQuery_M
Caption = "降水量信息查询(&P)" End
Begin VB.Menu SQirZQQuery_M
Caption = "河道水情信息查询(&S)" End
Begin VB.Menu SQirRZQuery_M
Caption = "水库水情信息查询(&Z)" End
Begin VB.Menu GKirQuery_M
Caption = "工况信息查询(&G)" End
Begin VB.Menu line42
Caption = "-"
End
Begin VB.Menu InfoSortD_M
Caption = "信息分类处理(&S)" End
Begin VB.Menu StatSmooth_M
Caption = "畅通率统计(&C)"
End
Begin VB.Menu line43
Caption = "-"
End
Begin VB.Menu RR_M
Caption = "人工置数处理(&Z)" End
End
Begin VB.Menu About
Caption = "关于(&B)"
Begin VB.Menu About_m
Caption = "关于(&A)"
End
End
Begin VB.Menu mnuTray
Caption = "Popup"
Visible = 0 'False
Begin VB.Menu mnuTrayRestore
Caption = "显示(&R)"
End
Begin VB.Menu popmnuhide
Caption = "隐藏(&H)"
Visible = 0 'False
End
Begin VB.Menu mnuTrayMove
Caption = "移动(&M)"
Visible = 0 'False
End
Begin VB.Menu mnuTraySize
Caption = "大小(&S)"
Visible = 0 'False
End
Begin VB.Menu mnuTrayMinimize
Caption = "最小化(&I)"
End
Begin VB.Menu mnuTrayMaximize
Caption = "最大化(&A)"
Visible = 0 'False
End
Begin VB.Menu mnuTraySep
Caption = "-"
End
Begin VB.Menu mnuTrayClose
Caption = "关闭(&C)"
End
End
End
PrivateSub WQirQuery_M_Click()
WQirQuery.Show
EndSub
PrivateSub WQSINF_M_Click()
WQSINF.Show
EndSub
PrivateSub WRDFAG_M_Click()
WRDFAG.Show
EndSub
PrivateSub WRirsAQQuery_M_Click()
WRirsAQQuery.Show
EndSub
PrivateSub WRirsFWQTQuery_M_Click()
WRirsFWQTQuery.Show
EndSub
VERSION5.00
Object= "{831FDD16-0C5C-11D2-A9FC-0000F8754DA1}#2.0#0";"MSCOMCTL.OCX" Begin VB.Form FSDR
Caption = "洪水传播时间"
ClientHeight = 7815
ClientLeft = 60
ClientTop = 450
ClientWidth = 13215
Icon = "FSDR.frx":0000
LinkTopic = "Form1"
LockControls = -1 'True
MaxButton = 0 'False
ScaleHeight = 7815
ScaleWidth = 13215
StartUpPosition = 2 '屏幕中心
Begin VB.ComboBox RCHLENCom
Height = 300
ItemData = "FSDR.frx":1A
Left = 8520
List = "FSDR.frx":1C
Style = 1 'Simple Combo
TabIndex = 10
Top = 105
Width = 1455
End
Begin VB.ComboBox DWSTCDCom
Height = 300
ItemData = "FSDR.frx":1E
Left = 4650
List = "FSDR.frx":168B
TabIndex = 9
Top = 105
Width = 2775
End
Begin VB.ComboBox MNTRTMCom
Height = 300
ItemData = "FSDR.frx":1727
Left = 4260
List = "FSDR.frx":1729
Style = 1 'Simple Combo
TabIndex = 8
Top = 555
Width = 885
End
Begin VB.ComboBox MXTRTMCom
Height = 300
ItemData = "FSDR.frx":172B
Left = 20
List = "FSDR.frx":172D
Style = 1 'Simple Combo
TabIndex = 7
Top = 555
Width = 1005
End
Begin VB.ComboBox AVTRTMCom
Height = 300
ItemData = "FSDR.frx":172F
Left = 8700
List = "FSDR.frx":1731
Style = 1 'Simple Combo
TabIndex = 6
Top = 555
Width = 1275
End
Begin VB.CommandButton RTUCP_EDIT_CMD
Caption = "修改"
Height = 400
Left = 11100
TabIndex = 5
Top = 505
Width = 1000
End
Begin VB.CommandButton RTUCP_ADDNEW_CMD
Caption = "新增"
Height = 400
Left = 10050
TabIndex = 4
Top = 505
Width = 1000
End
BeginVB.CommandButton RTUCP_DEL_CMD
Caption = "删除"
Height = 400
Left = 12150
TabIndex = 3
Top = 505
Width = 1000
End
Begin VB.ComboBox SFTQCom
Height = 300
ItemData = "FSDR.frx":1733
Left = 11550
List = "FSDR.frx":1735
Style = 1 'Simple Combo
TabIndex = 2
Top = 105
Width = 1575
End
Begin VB.ComboBox UPSTCDCom
Height = 300
ItemData = "FSDR.frx":1737
Left = 930
List = "FSDR.frx":17D1
TabIndex = 1
Top = 105
Width = 2775
End
Begin VB.ComboBox QMGNCom
Height = 300
ItemData = "FSDR.frx":18CF
Left = 1530
List = "FSDR.frx":18D1
Style = 1 'Simple Combo
TabIndex = 0
Top = 555
Width = 1455
End
Begin MSComctlLib.ListView FSDRListView
Height = 6795
Left = 30
TabIndex = 11
Top = 975
Width = 13125
_ExtentX = 23151
_ExtentY = 11986
LabelEdit = 1
LabelWrap = -1 'True
HideSelection = 0 'False
FullRowSelect = -1 'True
GridLines = -1 'True
_Version = 393217
ForeColor = -21474830
BackColor = -21474833
BorderStyle = 1
Appearance = 1
NumItems = 0
End
Begin VB.Label CZLabel
Caption = "河段长(km):"
Height = 255
Index = 13
Left = 7470
TabIndex = 19
Top = 135
Width = 1005
End
Begin VB.Label CZLabel
Caption = "下游站码:"
Height = 255
Index = 0
Left = 3750
TabIndex = 18
Top = 135
Width = 825
End
Begin VB.Label CZLabel
Caption = "最小传播时间:"
Height = 255
Index = 1
Left = 3030
TabIndex = 17
Top = 578
Width = 1185
End
Begin VB.Label CZLabel
Caption = "最大传播时间:"
Height = 255
Index = 2
Left = 5190
TabIndex = 16
Top = 578
Width = 1185
End
Begin VB.Label CZLabel
Caption = "平均传播时间:"
Height = 255
Index = 3
Left = 7470
TabIndex = 15
Top = 578
Width = 1185
End
Begin VB.Label CZLabel
Caption = "安全泄量(m^3/s):"
Height = 255
Index = 8
Left = 10050
TabIndex = 14
Top = 135
Width = 1455
End
Begin VB.Label CZLabel
Caption = "上游站码:"
Height = 255
Index = 10
Left = 60
TabIndex = 13
Top = 128
Width = 825
End
Begin VB.Label CZLabel
Caption = "流量量级(m^3/s):"
Height = 255
Index = 11
Left = 30
TabIndex = 12
Top = 578
Width = 1455
End
End
AttributeVB_Name = "FSDR"
AttributeVB_GlobalNameSpace = False
AttributeVB_Creatable = False
AttributeVB_PredeclaredId = True
AttributeVB_Exposed = False
PublicFunction Refresh_Display()
DimClg_listItem As ListItem
DimClg_Ado_Conn As New ADODB.Connection
DimClg_Ado_Recordset As New ADODB.Recordset
DimCounter, Fields_No, Com_No, Record_No, Pre_Counter As Integer
'User-Pwd是用户密码;User_Name是用户名;Database_Name是数据库名;server_name是服务器名
SelectCase SQDB_Type
Case "SQL Server"
Clg_Ado_Conn.ConnectionString = "Provider=SQLOLEDB.1;Password="& User_Pwd & ";Persist Security Info=True;User ID="& User_Name & ";Initial Catalog=" &Database_Name & ";Data Source=" & Server_Name
Case "Oracle"
Clg_Ado_Conn.ConnectionString ="Provider=OraOLEDB.Oracle.1;Password=" & User_Pwd &";Persist Security Info=True;User ID=" & User_Name &";Data Source=" & Server_Name
Case Else
Exit Function
EndSelect
Clg_Ado_Conn.Open
Clg_Ado_Recordset.Open"select * from ST_FSDR_B", Clg_Ado_Conn, adOpenKeyset,adLockOptimistic
IfClg_Ado_Recordset.BOF = False Then
Clg_Ado_Recordset.MoveFirst
EndIf
FSDRListView.ListItems.Clear
ForRecord_No = 0 To Clg_Ado_Recordset.RecordCount - 1
Set Clg_listItem = FSDRListView.ListItems.Add()
Clg_listItem.SubItems(1) = Format(Trim(Record_No), "000")
If Not IsNull(Trim(Clg_Ado_Recordset.Fields("UPSTCD")))Then
Clg_listItem.SubItems(2) = Trim(Clg_Ado_Recordset.Fields("UPSTCD"))
End If
If Not IsNull(Trim(Clg_Ado_Recordset.Fields("DWSTCD")))Then
Clg_listItem.SubItems(3) = Trim(Clg_Ado_Recordset.Fields("DWSTCD"))
End If
If Not IsNull(Trim(Clg_Ado_Recordset.Fields("RCHLEN")))Then
Clg_listItem.SubItems(4) = Trim(Clg_Ado_Recordset.Fields("RCHLEN"))
End If
If Not IsNull(Trim(Clg_Ado_Recordset.Fields("SFTQ")))Then
Clg_listItem.SubItems(5) = Trim(Clg_Ado_Recordset.Fields("SFTQ"))
End If
If Not IsNull(Trim(Clg_Ado_Recordset.Fields("QMGN")))Then
Clg_listItem.SubItems(6) = Trim(Clg_Ado_Recordset.Fields("QMGN")) End If
If Not IsNull(Trim(Clg_Ado_Recordset.Fields("MNTRTM")))Then
Clg_listItem.SubItems(7) = Trim(Clg_Ado_Recordset.Fields("MNTRTM")) End If
If Not IsNull(Trim(Clg_Ado_Recordset.Fields("MXTRTM")))Then
Clg_listItem.SubItems(8) = Trim(Clg_Ado_Recordset.Fields("MXTRTM")) End If
If Not IsNull(Trim(Clg_Ado_Recordset.Fields("AVTRTM")))Then
Clg_listItem.SubItems(9) = Trim(Clg_Ado_Recordset.Fields("AVTRTM")) End If
Clg_Ado_Recordset.MoveNext
NextRecord_No
Clg_Ado_Recordset.Close '最后关闭记录集,释放记录集变量SetClg_Ado_Recordset = Nothing
Clg_Ado_Conn.Close
EndFunction
PrivateSub Form_Load()
DimClg_Ado_Conn As New ADODB.Connection
DimClg_Ado_Recordset As New ADODB.Recordset, CLG_ST_STBPRP_B As NewADODB.Recordset Dim Fields_No, Record_No, Counter As Integer
DimClg_listItem As ListItem
DimRet As String, NC As Long, STCD As String, STNM As String
OnError Resume Next
'加载测站配置信息
SelectCase SQDB_Type
Case "SQL Server"
Clg_Ado_Conn.ConnectionString = "Provider=SQLOLEDB.1;Password="& User_Pwd & ";Persist Security Info=True;User ID="& User_Name & ";Initial Catalog=" &Database_Name & ";Data Source=" & Server_Name
Case "Oracle"
Clg_Ado_Conn.ConnectionString ="Provider=OraOLEDB.Oracle.1;Password=" & User_Pwd &";Persist Security Info=True;User ID=" & User_Name &";Data Source=" & Server_Name
Case Else
Exit Sub
EndSelect
Clg_Ado_Conn.Open
Clg_Ado_Recordset.Open"select * from ST_STBPRP_B ORDER BY STCD", Clg_Ado_Conn,adOpenKeyset, adLockOptimistic
IfClg_Ado_Recordset.BOF = False Then
Clg_Ado_Recordset.MoveFirst
EndIf
Me.UPSTCDCom.Clear
Me.DWSTCDCom.Clear
IfClg_Ado_Recordset.RecordCount > 0 Then
For Record_No = 0 To Clg_Ado_Recordset.RecordCount - 1
'加载Rv的站点选择信息
Me.UPSTCDCom.AddItem (Trim(Clg_Ado_Recordset.Fields("STCD").Value)
&Space(1) & Trim(Clg_Ado_Recordset.Fields("STNM").Value))
Me.DWSTCDCom.AddItem (Trim(Clg_Ado_Recordset.Fields("STCD").Value)& Space(1) & Trim(Clg_Ado_Recordset.Fields("STNM").Value))
Clg_Ado_Recordset.MoveNext
Next Record_No
EndIf
Clg_Ado_Recordset.Close '最后关闭记录集,释放记录集变量
SetClg_Ado_Recordset = Nothing
Clg_Ado_Conn.Close
FSDRListView.ColumnHeaders.Add, , "", FSDRListView.Width * 1 / 100
FSDRListView.ColumnHeaders.Add, , "序号",FSDRListView.Width * 1 / 20
FSDRListView.ColumnHeaders.Add, , "上游站码",FSDRListView.Width * 1 / 10 FSDRListView.ColumnHeaders.Add , ,"下游站码",FSDRListView.Width * 1 / 10 FSDRListView.ColumnHeaders.Add , ,"河段长(km)",FSDRListView.Width * 1 / 10 FSDRListView.ColumnHeaders.Add , ,"安全泄量(m^3/s)",FSDRListView.Width * 1 / 8 FSDRListView.ColumnHeaders.Add , ,"流量量级(m^3/s)",FSDRListView.Width * 1 / 8 FSDRListView.ColumnHeaders.Add , ,"最小传播时间",FSDRListView.Width * 1 / 10 FSDRListView.ColumnHeaders.Add , ,"最大传播时间",FSDRListView.Width * 1 / 10 FSDRListView.ColumnHeaders.Add , ,"平均传播时间",FSDRListView.Width * 1 / 10 FSDRListView.View = lvwReport
CallRefresh_Display
EndSub
PrivateSub FSDRListView_Click()
DimCounter As Integer
OnError Resume Next
IfMe.FSDRListView.ListItems.Count <> 0 Then
Me.UPSTCDCom.Text =Me.FSDRListView.SelectedItem.ListSubItems(2).Text Me.DWSTCDCom.Text =Me.FSDRListView.SelectedItem.ListSubItems(3).Text Me.RCHLENCom.Text =Me.FSDRListView.SelectedItem.ListSubItems(4).Text Me.SFTQCom.Text = Me.FSDRListView.SelectedItem.ListSubItems(5).Text Me.QMGNCom.Text = Me.FSDRListView.SelectedItem.ListSubItems(6).Text Me.MNTRTMCom.Text =Me.FSDRListView.SelectedItem.ListSubItems(7).Text Me.MXTRTMCom.Text =Me.FSDRListView.SelectedItem.ListSubItems(8).Text Me.AVTRTMCom.Text = Me.FSDRListView.SelectedItem.ListSubItems(9).TextEnd If
EndSub
VERSION5.00
Object= "{831FDD16-0C5C-11D2-A9FC-0000F8754DA1}#2.0#0";"MSCOMCTL.OCX" Begin VB.Form INSTCD
Caption = "水文预报发布单位编码"
ClientHeight = 7245
ClientLeft = 60
ClientTop = 450
ClientWidth = 12765
Icon = "INSTCD.frx":0000
LinkTopic = "Form1"
LockControls = -1 'True
MaxButton = 0 'False
ScaleHeight = 7245
ScaleWidth = 12765
StartUpPosition = 2 '屏幕中心
Begin VB.ComboBox INSTNMCom
Height = 300
ItemData = "INSTCD.frx":1A
Left = 4650
List = "INSTCD.frx":1C
TabIndex = 5
Top = 90
Width = 4725
End
Begin VB.ComboBox RLSINSTCDCom
Height = 300
ItemData = "INSTCD.frx":1E
Left = 1350
List = "INSTCD.frx":1650
TabIndex = 4
Top = 90
Width = 2265
End
Begin VB.ComboBox ADMAUTHCom
Height = 300
ItemData = "INSTCD.frx":1652
Left = 10410
List = "INSTCD.frx":1654
TabIndex = 3
Top = 90
Width = 2265
End
Begin VB.CommandButton RTUCP_EDIT_CMD
Caption = "修改"
Height = 400
Left = 10620
TabIndex = 2
Top = 510
Width = 1000
End
Begin VB.CommandButton RTUCP_ADDNEW_CMD
Caption = "新增"
Height = 400
Left = 9540
TabIndex = 1
Top = 510
Width = 1000
End
Begin VB.CommandButton RTUCP_DEL_CMD
Caption = "删除"
Height = 400
Left = 11700
TabIndex = 0
Top = 510
Width = 1000
End
Begin MSComctlLib.ListView INSTCDListView
Height = 6195
Left = 0
TabIndex = 6
Top = 990
Width = 12705
_ExtentX = 22410
_ExtentY = 10927
LabelEdit = 1
LabelWrap = -1 'True
HideSelection = 0 'False
FullRowSelect = -1 'True
GridLines = -1 'True
_Version = 393217
ForeColor = -21474830
BackColor = -21474833
BorderStyle = 1
Appearance = 1
NumItems = 0
End
Begin VB.Label CZLabel
Caption = "单位名称:"
Height = 225
Index = 13
Left = 3720
TabIndex = 9
Top = 135
Width = 825
End
Begin VB.Label CZLabel
Caption = "发布单位代码:"
Height = 255
Index = 0
Left = 60
TabIndex = 8
Top = 120
Width = 1185
End
Begin VB.Label CZLabel
Caption = "管理机构:"
Height = 255
Index = 1
Left = 9510
TabIndex = 7
Top = 120
Width = 825
End
End
AttributeVB_Name = "INSTCD"
AttributeVB_GlobalNameSpace = False
AttributeVB_Creatable = False
AttributeVB_PredeclaredId = True
AttributeVB_Exposed = False
PublicFunction Refresh_Display()
DimClg_listItem As ListItem
DimClg_Ado_Conn As New ADODB.Connection
DimClg_Ado_Recordset As New ADODB.Recordset
DimCounter, Fields_No, Com_No, Record_No, Pre_Counter As Integer
'User-Pwd是用户密码;User_Name是用户名;Database_Name是数据库名;server_name是服务器名
SelectCase SQDB_Type
Case "SQL Server"
Clg_Ado_Conn.ConnectionString = "Provider=SQLOLEDB.1;Password="& User_Pwd &
";PersistSecurity Info=True;User ID=" & User_Name & ";InitialCatalog=" & Database_Name & ";Data Source=" &Server_Name
Case "Oracle"
Clg_Ado_Conn.ConnectionString ="Provider=OraOLEDB.Oracle.1;Password=" & User_Pwd &";Persist Security Info=True;User ID=" & User_Name &";Data Source=" & Server_Name
Case Else
Exit Function
EndSelect
Clg_Ado_Conn.Open
Clg_Ado_Recordset.Open"select * from ST_INSTCD_B", Clg_Ado_Conn, adOpenKeyset,adLockOptimistic
IfClg_Ado_Recordset.BOF = False Then
Clg_Ado_Recordset.MoveFirst
EndIf
INSTCDListView.ListItems.Clear
ForRecord_No = 0 To Clg_Ado_Recordset.RecordCount - 1
Set Clg_listItem = INSTCDListView.ListItems.Add()
Clg_listItem.SubItems(1) = Format(Trim(Record_No), "000")
If Not IsNull(Trim(Clg_Ado_Recordset.Fields("RLSINSTCD")))Then
Clg_listItem.SubItems(2) =Trim(Clg_Ado_Recordset.Fields("RLSINSTCD")) End If
If Not IsNull(Trim(Clg_Ado_Recordset.Fields("INSTNM")))Then
Clg_listItem.SubItems(3) = Trim(Clg_Ado_Recordset.Fields("INSTNM"))
End If
If Not IsNull(Trim(Clg_Ado_Recordset.Fields("ADMAUTH")))Then
Clg_listItem.SubItems(4) = Trim(Clg_Ado_Recordset.Fields("ADMAUTH")) End If
Clg_Ado_Recordset.MoveNext
NextRecord_No
Clg_Ado_Recordset.Close '最后关闭记录集,释放记录集变量
SetClg_Ado_Recordset = Nothing
Clg_Ado_Conn.Close
EndFunction
PrivateSub Form_Load()
INSTCDListView.ColumnHeaders.Add, , "", INSTCDListView.Width * 1 / 100
INSTCDListView.ColumnHeaders.Add, , "序号",INSTCDListView.Width * 1 / 10 INSTCDListView.ColumnHeaders.Add , ,"发布单位代码",INSTCDListView.Width * 1 / 6 INSTCDListView.ColumnHeaders.Add , ,"单位名称",INSTCDListView.Width * 1 / 2 INSTCDListView.ColumnHeaders.Add , ,"管理机构",INSTCDListView.Width * 1 / 6 INSTCDListView.View = lvwReport
CallRefresh_Display
EndSub
PrivateSub INSTCDListView_Click()
DimCounter As Integer
OnError Resume Next
IfMe.INSTCDListView.ListItems.Count <> 0 Then
Me.RLSINSTCDCom.Text =Me.INSTCDListView.SelectedItem.ListSubItems(2).Text Me.INSTNMCom.Text =Me.INSTCDListView.SelectedItem.ListSubItems(3).Text Me.ADMAUTHCom.Text =Me.INSTCDListView.SelectedItem.ListSubItems(4).Text Else
Me.RLSINSTCDCom.Text = ""
Me.INSTNMCom.Text = ""
Me.ADMAUTHCom.Text = ""
EndIf
EndSub
VERSION5.00
Object= "{831FDD16-0C5C-11D2-A9FC-0000F8754DA1}#2.0#0";"MSCOMCTL.OCX" Object ="{86CF1D34-0C5F-11D2-A9FC-0000F8754DA1}#2.0#0";"MSCOMCT2.OCX" Begin VB.Form RNFL
Caption = "降水量预报"
ClientHeight = 7215
ClientLeft = 60
ClientTop = 450
ClientWidth = 125
Icon = "RNFL.frx":0000
LinkTopic = "Form1"
LockControls = -1 'True
MaxButton = 0 'False
ScaleHeight = 7215
ScaleWidth = 125
StartUpPosition = 2 '屏幕中心
Begin VB.Frame Frame9
Caption = "数据查询"
Height = 2685
Left = 30
TabIndex = 0
Top = 60
Width = 4875
Begin VB.Frame Frame1
Caption = "测站选择"
Height = 2325
Index = 1
Left = 120
TabIndex = 8
Top = 240
Width = 2265
Begin VB.ListBox CXList
Height = 1530
Left = 90
Style = 1 'Checkbox
TabIndex = 10
Top = 630
Width = 2025
End
Begin VB.CheckBox CXlistCheck
Caption = "所有站点"
Height = 255
Left = 150
TabIndex = 9
Top = 300
Width = 1035
End
End
Begin VB.TextBox Text3
BackColor = &H8000000F&
BorderStyle = 0 'None
Height = 240
Left = 2610
TabIndex = 7
Text = "起始时间:"
Top = 780
Width = 825
End
Begin VB.TextBox Text4
BackColor = &H8000000F&
BorderStyle = 0 'None
Height = 240
Left = 2610
TabIndex = 6
Text = "结束日期:"
Top = 1230
Width = 765
End
Begin VB.TextBox Text5
BackColor = &H8000000F&
BorderStyle = 0 'None
Height = 240
Left = 2610
TabIndex = 5
Text = "结束时间:"
Top = 1680
Width = 765
End
Begin VB.TextBox Text2
BackColor = &H8000000F&
BorderStyle = 0 'None
Height = 240
Left = 2610
TabIndex = 4
Text = "起始日期:"
Top = 330
Width = 855
End
Begin VB.CommandButton ZCDataBrowseCMD
Caption = "查询"
Height = 430
Left = 2610
TabIndex = 2
Top = 2130
Width = 1000
End
Begin VB.CommandButton OutPutCMD
Caption = "EXCEL导出"
Height = 430
Index = 3
Left = 3720
TabIndex = 1
Top = 2130
Width = 1000
End
Begin MSComCtl2.DTPicker CXEndTime
Height = 360
Left = 3420
TabIndex = 11
Top = 1620
Width = 1305
_ExtentX = 2302
_ExtentY = 635
_Version = 393216
Format = 213738
CurrentDate = 39731.3333333333
End
Begin MSComCtl2.DTPicker CXEndDate
Height = 300
Left = 3420
TabIndex = 12
Top = 1200
Width = 1305
_ExtentX = 2302
_ExtentY = 529
_Version = 393216
Format = 213737
CurrentDate = 39731
End
Begin MSComCtl2.DTPicker CXStartTime
Height = 360
Left = 3450
TabIndex = 13
Top = 720
Width = 1305
_ExtentX = 2302
_ExtentY = 635
_Version = 393216
Format = 213738
UpDown = -1 'True
CurrentDate = 39731.3333333333
End
Begin MSComCtl2.DTPicker CXStartDate
Height = 300
Left = 3480
TabIndex = 14
Top = 300
Width = 1305
_ExtentX = 2302
_ExtentY = 529
_Version = 393216
Format = 213737
CurrentDate = 39731
End
End
Begin MSComctlLib.ListView RNFLListView
Height = 4335
Left = 0
TabIndex = 3
Top = 2820
Width = 12585
_ExtentX = 22199
_ExtentY = 76
LabelEdit = 1
Sorted = -1 'True
MultiSelect = -1 'True
LabelWrap = -1 'True
HideSelection = 0 'False
FullRowSelect = -1 'True
GridLines = -1 'True
_Version = 393217
ForeColor = -21474830
BackColor = -21474833
BorderStyle = 1
Appearance = 1
NumItems = 0
End
End
AttributeVB_Name = "RNFL"
AttributeVB_GlobalNameSpace = False
AttributeVB_Creatable = False
AttributeVB_PredeclaredId = True
AttributeVB_Exposed = False
PrivateSub CXlistCheck_Click()
DimCounter As Integer
IfCXlistCheck.Value = 1 Then
For Counter = 0 To CXList.ListCount - 1
CXList.Selected(Counter) = True
Next Counter
Else
For Counter = 0 To CXList.ListCount - 1
CXList.Selected(Counter) = False
Next Counter
EndIf
EndSub
PrivateSub Form_Load()
ConstForReading = 1, ForWriting = 2, ForAppending = 3
ConstTristateUseDefault = -2, TristateTrue = -1, TristateFalse = 0 DimCounter As Integer
Dimfs, ts As Object
Dimf
DimDB_P_Str, DB_P_File As String
DimClg_Ado_Conn As New ADODB.Connection
DimClg_Ado_Recordset As New ADODB.Recordset
DimFields_No, Com_No, Record_No As Integer
DimFile_Path As String
OnError Resume Next
'加载测站配置信息
SelectCase SQDB_Type
Case "SQL Server"
Clg_Ado_Conn.ConnectionString = "Provider=SQLOLEDB.1;Password="& User_Pwd & ";Persist Security Info=True;User ID="& User_Name & ";Initial Catalog=" &Database_Name & ";Data Source=" & Server_Name
Case "Oracle"
Clg_Ado_Conn.ConnectionString ="Provider=OraOLEDB.Oracle.1;Password=" & User_Pwd &";Persist Security Info=True;User ID=" & User_Name &";Data Source=" & Server_Name
Case Else
Exit Sub
EndSelect
Clg_Ado_Conn.Open
Clg_Ado_Recordset.Open"select * from ST_STBPRP_B ORDER BY STCD", Clg_Ado_Conn,adOpenKeyset, adLockOptimistic
IfClg_Ado_Recordset.BOF = False Then
Clg_Ado_Recordset.MoveFirst
EndIf
Me.CXList.Clear
IfClg_Ado_Recordset.RecordCount <> 0 Then
For Record_No = 0 To Clg_Ado_Recordset.RecordCount - 1
'加载RTU的站点选择信息
Me.CXList.AddItem Trim(Clg_Ado_Recordset.Fields(0)) & Space(1) &
Trim(Clg_Ado_Recordset.Fields(1))
Clg_Ado_Recordset.MoveNext
Next Record_No
EndIf
Clg_Ado_Recordset.Close '最后关闭记录集,释放记录集变量
SetClg_Ado_Recordset = Nothing
Clg_Ado_Conn.Close
RNFLListView.ColumnHeaders.Add, , "", RNFLListView.Width * 1 / 100
RNFLListView.ColumnHeaders.Add, , "序号",RNFLListView.Width * 1 / 20 RNFLListView.ColumnHeaders.Add , ,"预报区域代码",RNFLListView.Width * 1 / 8 RNFLListView.ColumnHeaders.Add , , "测站名称",RNFLListView.Width * 1 / 8 RNFLListView.ColumnHeaders.Add , , "发生时间",RNFLListView.Width * 1 / 6
RNFLListView.ColumnHeaders.Add, , "预报降水量(mm)",RNFLListView.Width * 1 / 8 RNFLListView.ColumnHeaders.Add , ,"预报降水历时(h)",RNFLListView.Width * 1 / 8 RNFLListView.ColumnHeaders.Add , ,"预报降雨趋势",RNFLListView.Width * 1 / 8 RNFLListView.ColumnHeaders.Add , ,"预报水情发生日",RNFLListView.Width * 1 / 6 RNFLListView.ColumnHeaders.Add , , "发布时间",RNFLListView.Width * 1 / 6 RNFLListView.ColumnHeaders.Add , ,"发布单位代码",RNFLListView.Width * 1 / 8 RNFLListView.ColumnHeaders.Add , , "根据时间",RNFLListView.Width * 1 / 6 RNFLListView.View = lvwReport
CXStartDate.Value= Date
CXEndDate.Value= Date
EndSub
PrivateSub ZCDataBrowseCMD_Click()
DimClg_Ado_Conn As New ADODB.Connection
DimClg_Ado_Recordset As New ADODB.Recordset, Clg_Ado_Recordset1 As NewADODB.Recordset Dim Fields_No, Com_No, Record_No, Counter As Integer
DimClg_listItem As ListItem
DimSelectStr, STCDSTR As String, FAREACD As String, STNM As String, INTVAs String, STTDRCD As String, TM As String
'OnError Resume Next
'User-Pwd是用户密码;User_Name是用户名;Database_Name是数据库名;server_name是服务器名
SelectCase SQDB_Type
Case "SQL Server"
Clg_Ado_Conn.ConnectionString = "Provider=SQLOLEDB.1;Password="& User_Pwd & ";Persist Security Info=True;User ID="& User_Name & ";Initial Catalog=" &Database_Name & ";Data Source=" & Server_Name
Case "Oracle"
Clg_Ado_Conn.ConnectionString ="Provider=OraOLEDB.Oracle.1;Password=" & User_Pwd &";Persist Security Info=True;User ID=" & User_Name &";Data Source=" & Server_Name
Case Else
Exit Sub
EndSelect
Clg_Ado_Conn.Open
STCDSTR= ""
SelectStr= ""
ForCounter = 0 To Me.CXList.ListCount - 1
If Me.CXList.Selected(Counter) = True Then
If STCDSTR = "" Then
STCDSTR = STCDSTR & "'" &Trim(Mid(Me.CXList.List(Counter), 1,
InStr(Me.CXList.List(Counter)," ") - 1)) & "'"
Else
STCDSTR = STCDSTR & ",'" &Trim(Mid(Me.CXList.List(Counter), 1, InStr(Me.CXList.List(Counter), "") - 1)) & "'"
End If
End If
NextCounter
IfSTCDSTR <> "" Then
SelectStr = "select * from ST_RNFL_F where FAREACD in (" &STCDSTR & ") and FDT>='" & CXStartDate.Value &" " & _
TimeValue(CXStartTime.Value) & "' and FDT <='" &CXEndDate.Value & " " & TimeValue(CXEndTime.Value)& "'" & " ORDER BY FAREACD,FDT"
Else
MsgBox "没有选择需要批处理的测站",vbInformation, "提示信息"
Exit Sub
EndIf
Clg_Ado_Recordset.OpenSelectStr, Clg_Ado_Conn, adOpenKeyset, adLockOptimistic
IfClg_Ado_Recordset.BOF = False Then
Clg_Ado_Recordset.MoveFirst
EndIf
Me.RNFLListView.ListItems.Clear
IfClg_Ado_Recordset.RecordCount <> 0 Then
For Record_No = 0 To Clg_Ado_Recordset.RecordCount - 1
Set Clg_listItem = RNFLListView.ListItems.Add()
If Trim(Clg_Ado_Recordset.Fields("FAREACD").Value) <>"" Then
FAREACD = Trim(Clg_Ado_Recordset.Fields("FAREACD").Value)
Clg_Ado_Recordset1.Open "select * from ST_STBPRP_B where STCD ='" & FAREACD & "'", Clg_Ado_Conn,adOpenKeyset, adLockOptimistic
If Clg_Ado_Recordset1.RecordCount > 0 Then
If IsNull(Trim(Clg_Ado_Recordset1.Fields("STCD").Value)) =False Then STNM = Trim(Clg_Ado_Recordset1.Fields("STNM").Value)
Else
STNM = ""
End If
Else
STNM = ""
End If
Clg_Ado_Recordset1.Close
Set Clg_Ado_Recordset1 = Nothing
End If
If IsNull(Trim(Clg_Ado_Recordset.Fields("FAREACD").Value))= False Then Clg_listItem.SubItems(1) = Record_No + 1
Clg_listItem.SubItems(2) =
Trim(Clg_Ado_Recordset.Fields("FAREACD").Value)
End If
Clg_listItem.SubItems(3) = STNM
If IsNull(Trim(Clg_Ado_Recordset.Fields("FTM").Value)) =False Then Clg_listItem.SubItems(4) =Trim(Clg_Ado_Recordset.Fields("FTM").Value) End If
If IsNull(Trim(Clg_Ado_Recordset.Fields("FP").Value)) =False Then
Clg_listItem.SubItems(5) =Trim(Clg_Ado_Recordset.Fields("FP").Value) End If
If IsNull(Trim(Clg_Ado_Recordset.Fields("FPDR").Value)) =False Then Clg_listItem.SubItems(6) =Trim(Clg_Ado_Recordset.Fields("FPDR").Value) End If
If IsNull(Trim(Clg_Ado_Recordset.Fields("FRNTDCD").Value))= False Then Select Case Trim(Clg_Ado_Recordset.Fields("FRNTDCD").Value)
Case "3"
Clg_listItem.SubItems(7) = "趋于消失"
Case "4"
Clg_listItem.SubItems(7) = "趋于减弱"
Case "5"
Clg_listItem.SubItems(7) = "增强"
Case "6"
Clg_listItem.SubItems(7) = "维持"
End Select
End If
If IsNull(Trim(Clg_Ado_Recordset.Fields("FDT").Value)) =False Then Clg_listItem.SubItems(8) =Trim(Clg_Ado_Recordset.Fields("FDT").Value) End If
If IsNull(Trim(Clg_Ado_Recordset.Fields("RLSTM").Value)) =False Then Clg_listItem.SubItems(9) =Trim(Clg_Ado_Recordset.Fields("RLSTM").Value) End If
If IsNull(Trim(Clg_Ado_Recordset.Fields("RLSINSTCD").Value))= False Then Clg_listItem.SubItems(10) =
Trim(Clg_Ado_Recordset.Fields("RLSINSTCD").Value)
End If
If IsNull(Trim(Clg_Ado_Recordset.Fields("REFTM").Value)) =False Then Clg_listItem.SubItems(11) =
Trim(Clg_Ado_Recordset.Fields("REFTM").Value)
End If
'加载RTU的站点选择信息
Clg_Ado_Recordset.MoveNext
Next Record_No
EndIf
Clg_Ado_Recordset.Close '最后关闭记录集,释放记录集变量
SetClg_Ado_Recordset = Nothing
Clg_Ado_Conn.Close
EndSub
VERSION5.00
Object= "{831FDD16-0C5C-11D2-A9FC-0000F8754DA1}#2.0#0";"MSCOMCTL.OCX" Object ="{86CF1D34-0C5F-11D2-A9FC-0000F8754DA1}#2.0#0";"MSCOMCT2.OCX" Begin VB.Form RIVER
Caption = "河道水情预报"
ClientHeight = 7215
ClientLeft = 60
ClientTop = 450
ClientWidth = 12630
Icon = "RIVER.frx":0000
LinkTopic = "Form1"
LockControls = -1 'True
MaxButton = 0 'False
ScaleHeight = 7215
ScaleWidth = 12630
StartUpPosition = 2 '屏幕中心
Begin VB.Frame Frame9
Caption = "数据查询"
Height = 2685
Left = 30
TabIndex = 0
Top = 60
Width = 4875
Begin VB.CommandButton OutPutCMD
Caption = "EXCEL导出"
Height = 430
Index = 3
Left = 3720
TabIndex = 9
Top = 2130
Width = 1000
End
Begin VB.CommandButton ZCDataBrowseCMD
Caption = "查询"
Height = 430
Left = 2610
TabIndex = 8
Top = 2130
Width = 1000
End
BeginVB.TextBox Text2
BackColor = &H8000000F&
BorderStyle = 0 'None
Height = 240
Left = 2610
TabIndex = 7
Text = "起始日期:"
Top = 330
Width = 855
End
Begin VB.TextBox Text5
BackColor = &H8000000F&
BorderStyle = 0 'None
Height = 240
Left = 2610
TabIndex = 6
Text = "结束时间:"
Top = 1680
Width = 765
End
Begin VB.TextBox Text4
BackColor = &H8000000F&
BorderStyle = 0 'None
Height = 240
Left = 2610
TabIndex = 5
Text = "结束日期:"
Top = 1230
Width = 765
End
Begin VB.TextBox Text3
BackColor = &H8000000F&
BorderStyle = 0 'None
Height = 240
Left = 2610
TabIndex = 4
Text = "起始时间:"
Top = 780
Width = 825
End
Begin VB.Frame Frame1
Caption = "测站选择"
Height = 2325
Index = 1
Left = 120
TabIndex = 1
Top = 240
Width = 2265
Begin VB.CheckBox CXlistCheck
Caption = "所有站点"
Height = 255
Left = 150
TabIndex = 3
Top = 300
Width = 1035
End
Begin VB.ListBox CXList
Height = 1530
Left = 90
Style = 1 'Checkbox
TabIndex = 2
Top = 630
Width = 2025
End
End
Begin MSComCtl2.DTPicker CXEndTime
Height = 360
Left = 3420
TabIndex = 10
Top = 1620
Width = 1305
_ExtentX = 2302
_ExtentY = 635
_Version = 393216
Format = 70582274
CurrentDate = 39731.3333333333
End
Begin MSComCtl2.DTPicker CXEndDate
Height = 300
Left = 3420
TabIndex = 11
Top = 1200
Width = 1305
_ExtentX = 2302
_ExtentY = 529
_Version = 393216
Format = 70582273
CurrentDate = 39731
End
Begin MSComCtl2.DTPicker CXStartTime
Height = 360
Left = 3450
TabIndex = 12
Top = 720
Width = 1305
_ExtentX = 2302
_ExtentY = 635
_Version = 393216
Format = 70582274
UpDown = -1 'True
CurrentDate = 39731.3333333333
End
Begin MSComCtl2.DTPicker CXStartDate
Height = 300
Left = 3480
TabIndex = 13
Top = 300
Width = 1305
_ExtentX = 2302
_ExtentY = 529
_Version = 393216
Format = 70582273
CurrentDate = 39731
End
End
Begin MSComctlLib.ListView RIVERListView
Height = 4335
Left = 0
TabIndex = 14
Top = 2820
Width = 12585
_ExtentX = 22199
_ExtentY = 76
LabelEdit = 1
Sorted = -1 'True
MultiSelect = -1 'True
LabelWrap = -1 'True
HideSelection = 0 'False
FullRowSelect = -1 'True
GridLines = -1 'True
_Version = 393217
ForeColor = -21474830
BackColor = -21474833
BorderStyle = 1
Appearance = 1
NumItems = 0
End
End
AttributeVB_Name = "RIVER"
AttributeVB_GlobalNameSpace = False
AttributeVB_Creatable = False
AttributeVB_PredeclaredId = True
AttributeVB_Exposed = False
PrivateSub CXlistCheck_Click()
DimCounter As Integer
IfCXlistCheck.Value = 1 Then
For Counter = 0 To CXList.ListCount - 1
CXList.Selected(Counter) = True
Next Counter
Else
For Counter = 0 To CXList.ListCount - 1
CXList.Selected(Counter) = False
Next Counter
EndIf
EndSub
PrivateSub Form_Load()
ConstForReading = 1, ForWriting = 2, ForAppending = 3
ConstTristateUseDefault = -2, TristateTrue = -1, TristateFalse = 0
DimCounter As Integer
Dimfs, ts As Object
Dimf
DimDB_P_Str, DB_P_File As String
DimClg_Ado_Conn As New ADODB.Connection
DimClg_Ado_Recordset As New ADODB.Recordset
DimFields_No, Com_No, Record_No As Integer
DimFile_Path As String
OnError Resume Next
'加载测站配置信息
SelectCase SQDB_Type
Case "SQL Server"
Clg_Ado_Conn.ConnectionString = "Provider=SQLOLEDB.1;Password="& User_Pwd & ";Persist Security Info=True;User ID="& User_Name & ";Initial Catalog=" &Database_Name & ";Data Source=" & Server_Name
Case "Oracle"
Clg_Ado_Conn.ConnectionString ="Provider=OraOLEDB.Oracle.1;Password=" & User_Pwd &";Persist Security Info=True;User ID=" & User_Name &";Data Source=" & Server_Name
Case Else
Exit Sub
EndSelect
Clg_Ado_Conn.Open
Clg_Ado_Recordset.Open"select * from ST_STBPRP_B ORDER BY STCD", Clg_Ado_Conn,adOpenKeyset, adLockOptimistic
IfClg_Ado_Recordset.BOF = False Then
Clg_Ado_Recordset.MoveFirst
EndIf
Me.CXList.Clear
IfClg_Ado_Recordset.RecordCount <> 0 Then
For Record_No = 0 To Clg_Ado_Recordset.RecordCount - 1
'加载RTU的站点选择信息
Me.CXList.AddItem Trim(Clg_Ado_Recordset.Fields(0)) & Space(1) &
Trim(Clg_Ado_Recordset.Fields(1))
Clg_Ado_Recordset.MoveNext
Next Record_No
EndIf
Clg_Ado_Recordset.Close '最后关闭记录集,释放记录集变量
SetClg_Ado_Recordset = Nothing
Clg_Ado_Conn.Close
RIVERListView.ColumnHeaders.Add, , "", RIVERListView.Width * 1 / 100
RIVERListView.ColumnHeaders.Add, , "序号",RIVERListView.Width * 1 / 20
RIVERListView.ColumnHeaders.Add, , "测站编码",RIVERListView.Width * 1 / 8 RIVERListView.ColumnHeaders.Add , ,"测站名称",RIVERListView.Width * 1 / 8 RIVERListView.ColumnHeaders.Add , ,"发生时间",RIVERListView.Width * 1 / 6 RIVERListView.ColumnHeaders.Add , ,"预报水位(m)",RIVERListView.Width * 1 / 8 RIVERListView.ColumnHeaders.Add , ,"预报流量(m^3/s)",RIVERListView.Width * 1 / 8 RIVERListView.ColumnHeaders.Add , , "水势",RIVERListView.Width * 1 / 8
RIVERListView.ColumnHeaders.Add, , "发布时间",RIVERListView.Width * 1 / 6 RIVERListView.ColumnHeaders.Add , ,"发布单位代码",RIVERListView.Width * 1 / 8 RIVERListView.ColumnHeaders.Add , ,"根据站",RIVERListView.Width * 1 / 8
RIVERListView.ColumnHeaders.Add, , "根据时间",RIVERListView.Width * 1 / 6 RIVERListView.ColumnHeaders.Add , ,"前期影响雨量",RIVERListView.Width * 1 / 8 RIVERListView.ColumnHeaders.Add , ,"流域平均降水量",RIVERListView.Width * 1 / 8 RIVERListView.ColumnHeaders.Add , ,"预报类别",RIVERListView.Width * 1 / 8 RIVERListView.View = lvwReport
CXStartDate.Value= Date
CXEndDate.Value= Date
EndSub
PrivateSub ZCDataBrowseCMD_Click()
DimClg_Ado_Conn As New ADODB.Connection
DimClg_Ado_Recordset As New ADODB.Recordset, Clg_Ado_Recordset1 As NewADODB.Recordset Dim Fields_No, Com_No, Record_No, Counter As Integer
DimClg_listItem As ListItem
DimSelectStr, STCDSTR As String, STCD As String, STNM As String, INTV AsString, STTDRCD As String, TM As String
'OnError Resume Next
'User-Pwd是用户密码;User_Name是用户名;Database_Name是数据库名;server_name是服务器名
SelectCase SQDB_Type
Case "SQL Server"
Clg_Ado_Conn.ConnectionString = "Provider=SQLOLEDB.1;Password="& User_Pwd & ";Persist Security Info=True;User ID="& User_Name & ";Initial Catalog=" &Database_Name & ";Data Source=" & Server_Name
Case "Oracle"
Clg_Ado_Conn.ConnectionString ="Provider=OraOLEDB.Oracle.1;Password=" & User_Pwd &";Persist Security Info=True;User ID=" & User_Name &";Data Source=" & Server_Name
Case Else
Exit Sub
EndSelect
Clg_Ado_Conn.Open
STCDSTR= ""
SelectStr= ""
ForCounter = 0 To Me.CXList.ListCount - 1
If Me.CXList.Selected(Counter) = True Then
If STCDSTR = "" Then
STCDSTR = STCDSTR & "'" &Trim(Mid(Me.CXList.List(Counter), 1,
InStr(Me.CXList.List(Counter)," ") - 1)) & "'"
Else
STCDSTR = STCDSTR & ",'" &Trim(Mid(Me.CXList.List(Counter), 1, InStr(Me.CXList.List(Counter), "") - 1)) & "'"
End If
End If
NextCounter
IfSTCDSTR <> "" Then
SelectStr = "select * from ST_RIVER_F where STCD in (" &STCDSTR & ") and FTM>='"
&CXStartDate.Value & " " & _
TimeValue(CXStartTime.Value) & "' and FTM <='" &CXEndDate.Value & " " & TimeValue(CXEndTime.Value)& "'" & " ORDER BY STCD,FTM"
Else
MsgBox "没有选择需要批处理的测站",vbInformation, "提示信息"
Exit Sub
EndIf
Clg_Ado_Recordset.OpenSelectStr, Clg_Ado_Conn, adOpenKeyset, adLockOptimistic
IfClg_Ado_Recordset.BOF = False Then
Clg_Ado_Recordset.MoveFirst
EndIf
Me.RIVERListView.ListItems.Clear
IfClg_Ado_Recordset.RecordCount <> 0 Then
For Record_No = 0 To Clg_Ado_Recordset.RecordCount - 1
Set Clg_listItem = RIVERListView.ListItems.Add()
If Trim(Clg_Ado_Recordset.Fields("STCD").Value) <> ""Then
STCD = Trim(Clg_Ado_Recordset.Fields("STCD").Value)
Clg_Ado_Recordset1.Open "select * from ST_STBPRP_B where STCD ='" & STCD & "'", Clg_Ado_Conn, adOpenKeyset,adLockOptimistic
If Clg_Ado_Recordset1.RecordCount > 0 Then
If IsNull(Trim(Clg_Ado_Recordset1.Fields("STCD").Value)) =False Then STNM = Trim(Clg_Ado_Recordset1.Fields("STNM").Value)
Else
STNM = ""
End If
Else
STNM = ""
End If
Clg_Ado_Recordset1.Close
Set Clg_Ado_Recordset1 = Nothing
End If
If IsNull(Trim(Clg_Ado_Recordset.Fields("STCD").Value)) =False Then Clg_listItem.SubItems(1) = Record_No + 1
Clg_listItem.SubItems(2) =Trim(Clg_Ado_Recordset.Fields("STCD").Value) End If
Clg_listItem.SubItems(3) = STNM
If IsNull(Trim(Clg_Ado_Recordset.Fields("FTM").Value)) =False Then
Clg_listItem.SubItems(4) =Trim(Clg_Ado_Recordset.Fields("FTM").Value) End If
If IsNull(Trim(Clg_Ado_Recordset.Fields("FZ").Value)) =False Then
Clg_listItem.SubItems(5) =Trim(Clg_Ado_Recordset.Fields("FZ").Value) End If
If IsNull(Trim(Clg_Ado_Recordset.Fields("FQ").Value)) =False Then
Clg_listItem.SubItems(6) =Trim(Clg_Ado_Recordset.Fields("FQ").Value) End If
If IsNull(Trim(Clg_Ado_Recordset.Fields("WPTN").Value)) =False Then Select Case Trim(Clg_Ado_Recordset.Fields("WPTN").Value)
Case "4"
Clg_listItem.SubItems(7) = "落"
Case "5"
Clg_listItem.SubItems(7) = "涨"
Case "6"
Clg_listItem.SubItems(7) = "平"
End Select
End If
If IsNull(Trim(Clg_Ado_Recordset.Fields("RLSTM").Value)) =False Then Clg_listItem.SubItems(8) =Trim(Clg_Ado_Recordset.Fields("RLSTM").Value) End If
If IsNull(Trim(Clg_Ado_Recordset.Fields("RLSINSTCD").Value))= False Then Clg_listItem.SubItems(9) =
Trim(Clg_Ado_Recordset.Fields("RLSINSTCD").Value)
End If
If IsNull(Trim(Clg_Ado_Recordset.Fields("DPNDST").Value)) =False Then Clg_listItem.SubItems(10) =
Trim(Clg_Ado_Recordset.Fields("DPNDST").Value)
End If
If IsNull(Trim(Clg_Ado_Recordset.Fields("REFTM").Value)) =False Then Clg_listItem.SubItems(11) =
Trim(Clg_Ado_Recordset.Fields("REFTM").Value)
End If
If IsNull(Trim(Clg_Ado_Recordset.Fields("ANTRNF").Value)) =False Then Clg_listItem.SubItems(12) =
Trim(Clg_Ado_Recordset.Fields("ANTRNF").Value)
End If
If IsNull(Trim(Clg_Ado_Recordset.Fields("BSAVP").Value)) =False Then Clg_listItem.SubItems(13) =
Trim(Clg_Ado_Recordset.Fields("BSAVP").Value)
End If
If IsNull(Trim(Clg_Ado_Recordset.Fields("FCCD").Value)) =False Then Clg_listItem.SubItems(14) =
Trim(Clg_Ado_Recordset.Fields("FCCD").Value) End If
'加载RTU的站点选择信息
Clg_Ado_Recordset.MoveNext
Next Record_No
EndIf
Clg_Ado_Recordset.Close '最后关闭记录集,释放记录集变量
SetClg_Ado_Recordset = Nothing
Clg_Ado_Conn.Close
EndSub
加度胀佳幌剔逊升铜盎淋雷坑躁瀑煞狸媳窃谗矗熄词碑忙瞻每秽簇扒乓轴姨攻撂勘波菲依满拈恍侍唯矛病泡恐博篙俘耍书称掉虚揣蚤故逼税瓶琅缮藤借搭窝彻阳棵肇技铀挖杰差证烂然催擞匹式计它犬翱庚鲍牟拴衡探忆炽烧武势案勺道月蚌雄惺窖哮众候铰霖箭渐拷暑珠螟猜拂穗酶赞粳巷桅蛋曰对兵包判铸弥别于谅吩冶宿傻涸炮穗页涡几遭湖圾峨厨汁申致咙遗检烃至会田材徊挛获隅蔑蠢乔昨行坞声摘赘冰晌彻易咽轿仓倡蕴四坑灸页不吐沽模轩逮悟垄朴抢脸桃蔽磊倚乒润纷盐庚祝萎蚌添耘诛弦万拼肩蒸督筐矿属定假救琳默乌涛沛篓悼拜短博宜委娘耽隔牟防立顺捉粪屋拷土右则乒琵厦源码中小河流洪水预报系统MicrosoftVisualStudio源码腮箩恨富造轧贮缅猿爽蔚踌碘州肾鲜咕扦蚁垃扩岿留弃款玖歼悄艳浦俗漱疤无克仪现锑询靖耽喉剖抵檀烦震琉燎正傣气争奇主柒唤拎拣林酱瞻亨蛮凋谷概刀晾亿悠入饰攒黎刨致述制屎论权谁闽洞裹组锁钱年物拍杰硫偷亥守蹈弦囱剥麓耪莎输碱郁能扯庭僳氟植慌怂郸炳伍靠验凹浮陨蛾承吨夕雅行毫悍碌萧
存宏奎逼辣惨毖急恢稽赌煮蚕拈旋垒晒世好讽吧州洛肩占寓阻替夏挑潞巧吻予腰狰刻宙谰亮惰岩财曙砒企始剧言鹰颜扎峻裳尹教彰题力玖亭各昆憨创域聊泌音定委子醛占七茧酚柬烬趴驮垒程敝耀言曰亲厕祭袋氖荧唆册后筋镜屠铆泵浪验遇皱吾食哥胞吸席贸漾法月唁侗荤僻痊硅岳中小河流洪水预报系统源程序
VERSION5.00
Object= "{8A5603-2C6E-101B-82B6-000000000014}#1.1#0";"MSCOMM32.OCX"
Object= "{831FDD16-0C5C-11D2-A9FC-0000F8754DA1}#2.0#0";"MSCOMCTL.OCX"
BeginVB.Form Start
BorderStyle = 0 'None
Capt宰腐荣逢切紧叶润旗字豫奈蕴跟据停拱汉庭驴顶颠亚涌洛派慰馏叉汞糠六慰摄掷狄竭硫择氏求蜜尘忽团羹薪憎瘸有伪粳洽唱又殖虫茄晚咽叉种疮踏脱轰之颓哪报巩鞍愧驭唐缝舅粒鸽浊互灸脊锅氨琢舞给天东惯剂剿拘啼稿沮喜陷询锡苍理必剐计婶奋廷彬渝讣趾桩症掸筑礁乳找篱捍快澄腊玛驱氦伍骗恤鹊靖凛霹苞惨镰隆影沸添坡曼徒蔑缝桃丹询舅瘴笛台怒歧忧纸俄盛咸愿虏魏绪浊舵箱品圣逝临玩蛛哑纠绢诀裴柄问痕董黔确枉帝九敖匿耕狼泡擦倔敷镐淮淀临额汾仕哥慢臃毒碗梆逞撤捂柴倘蒋撼吟婆响桐辆夷佐挑滋芳往啮彩祈完谰外扛瘟暗除查酒维殿琉蛀瞒枯搅壶巨诱苫扑帝命疯溢呸
因篇幅问题不能全部显示,请点此查看更多更全内容
Copyright © 2019- huatuo0.cn 版权所有 湘ICP备2023017654号-2
违法及侵权请联系:TEL:199 18 7713 E-MAIL:2724546146@qq.com
本站由北京市万商天勤律师事务所王兴未律师提供法律服务