|
楼主 |
发表于 2018-12-6 15:10
|
显示全部楼层
- Private Sub LoginSys()
- '初始化共用参数
- Dim n As New DbCmd, cPath As String, cName As String, cVal As String, i%
- cPath = ThisWorkbook.Path & "\Config\\Config.ini"
- Close #2
- Open cPath For Input As #2
- i = 1
- Do While Not EOF(2)
- Input #2, cName, cVal
- If i = 1 Then SerIP = cVal
- If i = 2 Then DbName = cVal
- If i = 3 Then Uid = cVal
- If i = 4 Then Pwd = cVal
- If i = 5 Then UfSerIP = cVal
- If i = 6 Then UfDbName = cVal
- If i = 7 Then UfUid = cVal
- If i = 8 Then UfPwd = cVal
- If i = 9 Then BackPath = cVal
- If i = 10 Then DefTaxRate = cVal
- i = i + 1
- Loop
- Close #2
- cPath = ThisWorkbook.Path & "\Config\\CellStyle.ini"
- Open cPath For Input As #2
- i = 1
- Do While Not EOF(2)
- Input #2, cName, cVal
- If i = 1 Then CellColor1 = cVal
- If i = 2 Then CellColor2 = cVal
- If i = 3 Then CellColor3 = cVal
- If i = 4 Then CellRowHeight = cVal
- If i = 5 Then HeadCellRowHeight = cVal
- i = i + 1
- Loop
- Close #2
- strCn = "Provider=SQLOLEDB;server=" & SerIP & ";DATABASE=" & DbName & ";UID=" & Uid & ";PWD=" & Pwd & "; " '数据库连接字符串
- SheetPwd = ""
- n.ReadRsTo "Select cCorpCode,cCorpName From Corporation", ShTempSave.Range("R5") '公司档案表
- '显示登录窗口
- LoginForm.Show
- End Sub
- Private Sub CellStyleSave()
- Dim cPath As String
- cPath = ThisWorkbook.Path & "\Config\CellStyle.ini"
- Dim cName As String * 30, cVal As String
- Close #2
- Open cPath For Output As #2
- '服务器
- cName = "表头颜色"
- cVal = Range("B9").Interior.Color
- Write #2, cName, cVal
-
- cName = "只读表体色"
- cVal = Range("B10").Interior.Color
- Write #2, cName, cVal
-
- cName = "可写表体色"
- cVal = Range("B11").Interior.Color
- Write #2, cName, cVal
-
- cName = "表体行高"
- If Range("C12") > 0 Then
- cVal = Range("C12")
- Else
- cVal = "28"
- End If
- Write #2, cName, cVal
-
- cName = "表头 行高"
- If Range("C13") > 0 Then
- cVal = Range("C13")
- Else
- cVal = "28"
- End If
- Write #2, cName, cVal
-
- Close #2
- MsgBox "设置成功"
- End Sub
复制代码
写入和读取自定义格式文件,通过文本文件存储在本机上,登陆时读入公共变量中 |
评分
-
2
查看全部评分
-
|