软件源程序

Sub ProcessLog (Byval pid,Byval batchcode,Byval username)
Dim sCon1
Dim sSql1
Dim oRs1
Dim oCom1
Dim sCon
Dim sSql
Dim oRs
Dim conn
Dim oCom
Dim Con
Dim tt
Dim count
Con=HMIRuntime.Tags(“SQL”).Read
Set conn = CreateObject(“ADODB.Connection”)
conn.ConnectionString = Con
conn.CursorLocation = 3
conn.Open
sSql1=”select count(*) from processlog”
Set oRs1 = CreateObject(“ADODB.Recordset”)
Set oCom1 = CreateObject(“ADODB.Command”)
Set oCom1.ActiveConnection = conn
oCom1.CommandType = 1
oCom1.CommandText = sSql1
Set oRs1 = oCom1.Execute
count = oRs1.Fields(0).Value + 1
sSql=”insert into PROCESSLOG(PROCESSLOGID,PROCESSID,BATCHCODE,STARTTIME,STARTUSERNAME,ENDTIME,ENDUSERNAME,FINISH) VALUES (‘”&count&”’,N’”&pid&”’,N’”&batchcode&”’,getdate(),N’”&username&”’,’1900-1-1’,N’无’,0)”
Set oRs = CreateObject(“ADODB.Recordset”)
Set oCom = CreateObject(“ADODB.Command”)
Set oCom.ActiveConnection = conn
oCom.CommandType = 1
oCom.CommandText = sSql
Set oRs = oCom.Execute
Set oRs = Nothing
Set oRs1 = Nothing
conn.Close
Set conn = Nothing
End Sub
Sub SETPOST (Byval a,Byval b,Byval c)
Dim sCon
Dim sSql
Dim oRs
Dim conn
Dim oCom
Dim Con
Dim tt
Con=HMIRuntime.Tags(“SQL”).Read
Set conn = CreateObject(“ADODB.Connection”)
conn.ConnectionString = Con
conn.CursorLocation = 3
conn.Open
sSql=”select “&c&” from USERPOST where USERNAME = ‘”&b&”’”
Set oRs = CreateObject(“ADODB.Recordset”)
Set oCom = CreateObject(“ADODB.Command”)
Set oCom.ActiveConnection = conn
oCom.CommandType = 1
oCom.CommandText = sSql
Set oRs = oCom.Execute
tt = oRs.Fields(0).Value
HMIRuntime.Tags(“”&a&”“).Write tt
Set oRs = Nothing
conn.Close
Set conn = Nothing
End Sub
Sub StartBatch (Byval STARTUSERNAME,Byval BATCHID)
Dim sCon
Dim sSql
Dim oRs
Dim conn
Dim oCom
Dim Con
Dim tt
Con=HMIRuntime.Tags(“SQL”).Read
Set conn = CreateObject(“ADODB.Connection”)
conn.ConnectionString = Con
conn.CursorLocation = 3
conn.Open
sSql=”UPDATE BATCH SET STARTTIME = getdate(),STARTUSERNAME = N’”&STARTUSERNAME&”’,FINISH = 1 WHERE BATCHID = ‘”&BATCHID&”’”
Set oRs = CreateObject(“ADODB.Recordset”)
Set oCom = CreateObject(“ADODB.Command”)
Set oCom.ActiveConnection = conn
oCom.CommandType = 1
oCom.CommandText = sSql
Set oRs = oCom.Execute
Set oRs = Nothing
conn.Close
Set conn = Nothing
End Sub
Sub Text(Byval a)
Dim sCon
Dim sSql
Dim oRs
Dim conn
Dim oCom
Dim Con
Con=HMIRuntime.Tags(“SQL”).Read
Set conn = CreateObject(“ADODB.Connection”)
conn.ConnectionString = Con
conn.CursorLocation = 3
conn.Open
sSql=a
Set oRs = CreateObject(“ADODB.Recordset”)
Set oCom = CreateObject(“ADODB.Command”)
Set oCom.ActiveConnection = conn
oCom.CommandType = 1
oCom.CommandText = sSql
Set oRs = oCom.Execute
Set oRs = Nothing
conn.Close
Set conn = Nothing
End Sub
Dim oCom
Dim Con
Dim tt
Con=HMIRuntime.Tags(“SQL”).Read
Set conn = CreateObject(“ADODB.Connection”)
conn.ConnectionString = Con
conn.CursorLocation = 3
conn.Open
sSql=”select “&c&” from text where ID = “&b&””
Set oRs = CreateObject(“ADODB.Recordset”)
Set oCom = CreateObject(“ADODB.Command”)
Set oCom.ActiveConnection = conn
oCom.CommandType = 1
oCom.CommandText = sSql
Set oRs = oCom.Execute
tt = oRs.Fields(0).Value
HMIRuntime.Tags(“”&a&”“).Write tt
Set oRs = Nothing
conn.Close
Set conn = Nothing
End Sub
Sub TextRead (Byval a)
Dim sCon
Dim sSql
Dim oRs
Dim conn
Dim oCom
Dim Con
Dim tt
tt = HMIRuntime.Tags(“”&a&”“).Read
Con=HMIRuntime.Tags(“SQL”).Read
Set conn = CreateObject(“ADODB.Connection”)
conn.ConnectionString = Con
conn.CursorLocation = 3
conn.Open
sSql=”insert into text(NAME) VALUES (‘”&tt&”’)”
Set oRs = CreateObject(“ADODB.Recordset”)
Set oCom = CreateObject(“ADODB.Command”)
Set oCom.ActiveConnection = conn
oCom.CommandType = 1
oCom.CommandText = sSql
Set oRs = oCom.Execute
tt = oRs.Fields(0).Value
Set oRs = Nothing
conn.Close
Set conn = Nothing
End Sub
Sub OperateLog (Byval description,Byval equipcode,Byval ymid)
Dim sCon
Dim sSql
Dim oRs
Dim conn
Dim oCom
Dim Con
Dim tt
Dim processid
Dim batch
Dim username
username = HMIRuntime.Tags(“@NOTP::@CurrentUserName”).Read
Select Case ymid
Case “1”
processid = HMIRuntime.Tags(“@NOTP::TQNowProcess”).Read
batch = HMIRuntime.Tags(“@NOTP::BatchTQ”).Read
Case “2”
processid = HMIRuntime.Tags(“@NOTP::CCNowProcess”).Read
batch = HMIRuntime.Tags(“@NOTP::BatchChunChen”).Read
Case “3”
processid = HMIRuntime.Tags(“@NOTP::SQNowProcess”).Read
batch = HMIRuntime.Tags(“@NOTP::BatchShangQing”).Read
Case “4”
processid = HMIRuntime.Tags(“@NOTP::TMNowProcess”).Read
batch = HMIRuntime.Tags(“@NOTP::BatchTotalMix”).Read
Case “0”
processid = 24
batch = “无”
End Select
Con=HMIRuntime.Tags(“SQL”).Read
Set conn = CreateObject(“ADODB.Connection”)
conn.ConnectionString = Con
conn.CursorLocation = 3
conn.Open
sSql=”insert into OPERATELOG(OPERATETIME,USERNAME,DESCRIPTION,REMARK,BITCHCODE,EQUIPCODE,PROCESSID) VALUES (getdate(),N’”&username&”’,N’”&description&”’,N’无’,N’”&batch&”’,N’”&equipcode&”’,”&processid&”)”
Set oRs = CreateObject(“ADODB.Recordset”)
Set oCom = CreateObject(“ADODB.Command”)
Set oCom.ActiveConnection = conn
oCom.CommandType = 1
oCom.CommandText = sSql
Set oRs = oCom.Execute
Set oRs = Nothing
conn.Close
Set conn = Nothing
End Sub
Sub OnLButtonDown(ByVal Item, ByVal Flags, ByVal x, ByVal y)
Dim a
Dim sCon
Dim sSql
Dim oRs
Dim conn
Dim oCom
Dim Con
Dim tt
Dim h
Con=HMIRuntime.Tags(“SQL”).Read
Set conn = CreateObject(“ADODB.Connection”)
conn.ConnectionString = Con
conn.CursorLocation = 3
conn.Open
sSql=”select USERNAME from USERPOST where POSTID < 5”
Set oRs = CreateObject(“ADODB.Recordset”)
Set oCom = CreateObject(“ADODB.Command”)
Set oCom.ActiveConnection = conn
oCom.CommandType = 1
oCom.CommandText = sSql
Set oRs = oCom.Execute
oRs.MoveFirst
Set a = ScreenItems(“列表框1”)
a.NumberLines = oRs.RecordCount
For h = 1 To oRs.RecordCount
tt = oRs.Fields(0).Value
a.SelIndex = h
a.SelText = tt
oRs.MoveNext
Next
a.SelIndex = 1
Set oRs = Nothing
conn.Close
Set conn = Nothing
End Sub
Sub OnLButtonDown(ByVal Item, ByVal Flags, ByVal x, ByVal y)
Dim a
Dim c
Dim d
Dim sCon
Dim sSql
Dim oRs
Dim conn
Dim oCom
Dim Con
Dim tt
Dim ts
Dim h
Dim p
Dim v
Set v = ScreenItems(“k2”)
p = v.Text
Con=HMIRuntime.Tags(“SQL”).Read
Set conn = CreateObject(“ADODB.Connection”)
conn.ConnectionString = Con
conn.CursorLocation = 3
conn.Open
sSql=”select USERNAME,POSTID from USERPOST WHERE USERNAME = N’”&p&”’ AND POSTID < 5”
Set oRs = CreateObject(“ADODB.Recordset”)
Set oCom = CreateObject(“ADODB.Command”)
Set oCom.ActiveConnection = conn
oCom.CommandType = 1
oCom.CommandText = sSql
Set oRs = oCom.Execute
If oRs.RecordCount = 0 Then
MsgBox “未找到该用户”,0,”警告”
Else
tt = oRs.Fields(0).Value
ts = oRs.Fields(1).Value
Set c = ScreenItems(“静态文本3”)
c.Text = tt
Set d = ScreenItems(“静态文本4”)
Select Case ts
Case “1”
d.Text = “操作员”
Case “2”
d.Text = “维护员”
Case “3”
d.Text = “工程师”
Case “4”
d.Text = “管理员”
End Select
End If
Set oRs = Nothing
conn.Close
Set conn = Nothing
End Sub

include “apdefap.h”

void OnLButtonDown(char* lpszPictureName, char* lpszObjectName, char* lpszPropertyName, UINT nFlags, int x, int y)
{

pragma option(mbcs)

char * strTagPrefix;
char * strPictureName;
strPictureName=”pic1”;
SetVisible(“UserMain.pdl”,strPictureName,0); //Return-Type: BOOL
SetPictureName(“UserMain.pdl”,strPictureName,”UserAdd.pdl”); //Return-Type: BOOL
SetVisible(“UserMain.pdl”,strPictureName,1); //Return-Type: BOOL
}

include “apdefap.h”

void OnLButtonDown(char* lpszPictureName, char* lpszObjectName, char* lpszPropertyName, UINT nFlags, int x, int y)
{

pragma option(mbcs)

char * strTagPrefix;
char * strPictureName;
strPictureName=”pic1”;
SetVisible(“UserMain.pdl”,strPictureName,0); //Return-Type: BOOL
SetPictureName(“UserMain.pdl”,strPictureName,”UserSet.pdl”); //Return-Type: BOOL
SetVisible(“UserMain.pdl”,strPictureName,1); //Return-Type: BOOL
SetText(“UserSet.pdl”,”静态文本3”,GetText(“UserMain.pdl”,”静态文本3”)); //Return-Type: BOOL
SetPropWord(“UserSet.pdl”,”组合框1”,”SelIndex”,GetPropWord(“UserMain.pdl”,”组合框1”,”SelIndex”));
}

include “apdefap.h”

void OnLButtonDown(char* lpszPictureName, char* lpszObjectName, char* lpszPropertyName, UINT nFlags, int x, int y)
{

pragma option(mbcs)

pragma code(“UseGen.dll”)

include “USEGENAP.H”

pragma code()

LPCMN_ERROR err; //定义的LPCMN_ERROR型变量,在函数调用中需使用
if (PWGENConnect(“CC_OS-FDA_11_07_29_16_42_11”,err)) //建立与数据库的联接
{
if (PWGENDeleteUser(GetPropChar(“UserMain.pdl”,”静态文本3”,”Text”),1,err)) //删除用户
{//密码修改成功后的操作,如给用户提示等
}
}
PWGENDisconnect(err); //断开与数据库的联接
}
Sub OnLButtonUp(ByVal Item, ByVal Flags, ByVal x, ByVal y)
Dim a
Dim sCon
Dim sSql
Dim oRs
Dim conn
Dim oCom
Dim Con
Dim tt
Dim bkval
Dim p
Dim ts
Dim hh
Dim aa
Set a = ScreenItems(“静态文本3”)
p = a.Text
bkval = MsgBox (“是否要删除用户”+”“&p&”“,1,”警告”)
If bkval=1 Then
Con=HMIRuntime.Tags(“SQL”).Read
Set conn = CreateObject(“ADODB.Connection”)
conn.ConnectionString = Con
conn.CursorLocation = 3
conn.Open
sSql=”delete from USERPOST where USERNAME = N’”&p&”’”
Set oRs = CreateObject(“ADODB.Recordset”)
Set oCom = CreateObject(“ADODB.Command”)
Set oCom.ActiveConnection = conn
oCom.CommandType = 1
oCom.CommandText = sSql
Set oRs = oCom.Execute
MsgBox “成功删除用户”+”“&p&”“,0,”提示”
End If
sSql=”select USERNAME from USERPOST”
Set oRs = CreateObject(“ADODB.Recordset”)
Set oCom = CreateObject(“ADODB.Command”)
Set oCom.ActiveConnection = conn
oCom.CommandType = 1
oCom.CommandText = sSql
Set oRs = oCom.Execute
oRs.MoveFirst
Set aa = ScreenItems(“列表框1”)
a.Text = “”
aa.NumberLines = oRs.RecordCount
For h = 1 To oRs.RecordCount
ts = oRs.Fields(0).Value
a.SelIndex = hh
a.SelText = ts
oRs.MoveNext
Next
aa.SelIndex = 1
Set oRs = Nothing
conn.Close
Set conn = Nothing
End Sub

include “apdefap.h”

void OnLButtonDown(char* lpszPictureName, char* lpszObjectName, char* lpszPropertyName, UINT nFlags, int x, int y)
{

pragma option(mbcs)

pragma code(“UseGen.dll”)

include “USEGENAP.H”

pragma code()

LPCMN_ERROR err; //定义的LPCMN_ERROR型变量,在函数调用中需使用
if (PWGENConnect(“CC_OS-FDA_11_07_29_16_42_11”,err)) //建立与数据库的联接
{
if (PWGENAddUser(GetPropChar(“UserAdd.pdl”,”n1”,”Text”),GetPropChar(“UserAdd.pdl”,”m1”,”Text”),”Administrator-Group”,0,err)) //修改密码,user,oldpassword,password分别为存贮用户名,原密码,新密码的内部变量,类型为文本变量8位字符集
{
//密码修改成功后的操作,如给用户提示等
}
}
PWGENDisconnect(err); //断开与数据库的联接
}
Sub OnLButtonUp(ByVal Item, ByVal Flags, ByVal x, ByVal y)
Dim a
Dim b
Dim sCon
Dim sSql
Dim oRs
Dim conn
Dim oCom
Dim Con
Dim tt
Dim bkval
Dim p
Dim v
Set a = ScreenItems(“n1”)
Set b = ScreenItems(“组合框1”)
p = a.Text
v = b.SelIndex
Con=HMIRuntime.Tags(“SQL”).Read
Set conn = CreateObject(“ADODB.Connection”)
conn.ConnectionString = Con
conn.CursorLocation = 3
conn.Open
sSql=”insert into USERPOST(USERNAME,POSTID) VALUES (N’”&p&”’,”&v&”)”
Set oRs = CreateObject(“ADODB.Recordset”)
Set oCom = CreateObject(“ADODB.Command”)
Set oCom.ActiveConnection = conn
oCom.CommandType = 1
oCom.CommandText = sSql
Set oRs = oCom.Execute
MsgBox “成功创建用户”+”“&p&”“,0,”提示”
Set oRs = Nothing
conn.Close
Set conn = Nothing
End Sub
Sub OnLButtonDown(ByVal Item, ByVal Flags, ByVal x, ByVal y)
Dim a
Dim sCon
Dim sSql
Dim oRs
Dim conn
Dim oCom
Dim Con
Dim t
Dim h
Dim b
Set a = ScreenItems(“静态文本3”)
t = a.Text
Set h = ScreenItems(“组合框1”)
b = h.SelIndex
Con=HMIRuntime.Tags(“SQL”).Read
Set conn = CreateObject(“ADODB.Connection”)
conn.ConnectionString = Con
conn.CursorLocation = 3
conn.Open
sSql=”Update USERPOST SET POSTID = “&b&” where USERNAME = N’”&t&”’”
Set oRs = CreateObject(“ADODB.Recordset”)
Set oCom = CreateObject(“ADODB.Command”)
Set oCom.ActiveConnection = conn
oCom.CommandType = 1
oCom.CommandText = sSql
Set oRs = oCom.Execute
MsgBox “成功修改用户”+”“&t&”“+”权限”,0,”提示”
Set oRs = Nothing
conn.Close
Set conn = Nothing
End Sub

include “apdefap.h”

void OnLButtonDown(char* lpszPictureName, char* lpszObjectName, char* lpszPropertyName, UINT nFlags, int x, int y)
{

pragma option(mbcs)

pragma code(“UseGen.dll”)

include “USEGENAP.H”

pragma code()

LPCMN_ERROR err; //定义的LPCMN_ERROR型变量,在函数调用中需使用
if (PWGENConnect(“CC_OS-FDA_11_07_29_16_42_11”,err)) //建立与数据库的联接
{
if (PWGENChangePassword(GetPropChar(“UserSet.pdl”,”静态文本3”,”Text”),GetPropChar(“UserSet.pdl”,”控件1”,”Text”),GetPropChar(“UserSet.pdl”,”控件2”,”Text”),err)) //修改密码,user,oldpassword,password分别为存贮用户名,原密码,新密码的内部变量,类型为文本变量8位字符集
{
//密码修改成功后的操作,如给用户提示等
}
}
PWGENDisconnect(err); //断开与数据库的联接
}
Sub OnLButtonDown(ByVal Item, ByVal Flags, ByVal x, ByVal y)
Dim a
Dim sCon
Dim sSql
Dim oRs
Dim conn
Dim oCom
Dim Con
Dim tt
Dim h
Con=HMIRuntime.Tags(“SQL”).Read
‘MsgBox(Con)
‘“Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=CC_OS-FDA_13_06_19_21_24_37R;Data Source=.\WINCC”
Set conn = CreateObject(“ADODB.Connection”)
conn.ConnectionString = Con
conn.CursorLocation = 3
conn.Open
sSql=”select BATCHCODE from BATCH where FINISH < 2”
Set oRs = CreateObject(“ADODB.Recordset”)
Set oCom = CreateObject(“ADODB.Command”)
Set oCom.ActiveConnection = conn
oCom.CommandType = 1
oCom.CommandText = sSql
Set oRs = oCom.Execute
oRs.MoveFirst
Set a = ScreenItems(“列表框1”)
a.NumberLines = oRs.RecordCount + 1
For h = 2 To oRs.RecordCount + 1
tt = oRs.Fields(0).Value
a.SelIndex = h
a.SelText = tt
oRs.MoveNext
Next
a.SelIndex = 1
Set oRs = Nothing
conn.Close
Set conn = Nothing
End Sub
Sub OnLButtonDown(Byval Item, Byval Flags, Byval x, Byval y)
Dim o
Set o = ScreenItems(“列表框1”)
o.SelIndex = 1
End Sub

include “apdefap.h”

void OnLButtonDown(char* lpszPictureName, char* lpszObjectName, char* lpszPropertyName,
Select Case ymid
Case “1”
processid = HMIRuntime.Tags(“@NOTP::TQNowProcess”).Read
batch = HMIRuntime.Tags(“@NOTP::BatchTQ”).Read
Case “2”
processid = HMIRuntime.Tags(“@NOTP::CCNowProcess”).Read
batch = HMIRuntime.Tags(“@NOTP::BatchChunChen”).Read
Case “3”
processid = HMIRuntime.Tags(“@NOTP::SQNowProcess”).Read
batch = HMIRuntime.Tags(“@NOTP::BatchShangQing”).Read
Case “4”
processid = HMIRuntime.Tags(“@NOTP::TMNowProcess”).Read
batch = HMIRuntime.Tags(“@NOTP::BatchTotalMix”).Read
Case “0”
processid = 24
batch = “无”
End Select
Con=HMIRuntime.Tags(“SQL”).Read
Set conn = CreateObject(“ADODB.Connection”)
conn.ConnectionString = Con
conn.CursorLocation = 3
conn.Open
sSql=”insert into OPERATELOG(OPERATETIME,USERNAME,DESCRIPTION,REMARK,BITCHCODE,EQUIPCODE,PROCESSID) VALUES (getdate(),N’”&username&”’,N’”&description&”’,N’无’,N’”&batch&”’,N’”&equipcode&”’,”&processid&”)”
Set oRs = CreateObject(“ADODB.Recordset”)
Set oCom = CreateObject(“ADODB.Command”)
Set oCom.ActiveConnection = conn
oCom.CommandType = 1
oCom.CommandText = sSql
Set oRs = oCom.Execute
Set oRs = Nothing
conn.Close
Set conn = Nothing
End Sub
Sub OnLButtonDown(ByVal Item, ByVal Flags, ByVal x, ByVal y)
Dim a
Dim sCon
Dim sSql
Dim oRs
Dim conn
Dim oCom
Dim Con
Dim tt
Dim h
Con=HMIRuntime.Tags(“SQL”).Read
Set conn = CreateObject(“ADODB.Connection”)
conn.ConnectionString = Con
conn.CursorLocation = 3
conn.Open
sSql=”select USERNAME from USERPOST where POSTID < 5”
Set oRs = CreateObject(“ADODB.Recordset”)
Set oCom = CreateObject(“ADODB.Command”)
Set oCom.ActiveConnection = conn
oCom.CommandType = 1
oCom.CommandText = sSql
Set oRs = oCom.Execute
oRs.MoveFirst
UINT nFlags, int x, int y)
{

pragma option(mbcs)

char * strTagPrefix;
char * strPictureName;
strPictureName=”pic1”;
SetVisible(“BatchMain.pdl”,strPictureName,0); //Return-Type: BOOL
SetPictureName(“BatchMain.pdl”,strPictureName,”BatchAdd.pdl”); //Return-Type: BOOL
SetVisible(“BatchMain.pdl”,strPictureName,1); //Return-Type: BOOL
}
Sub OnLButtonDown(ByVal Item, ByVal Flags, ByVal x, ByVal y)
Dim sCon
Dim sSql
Dim oRs
Dim conn
Dim oCom
Dim Con
Dim tt
Dim bcm
Dim bz
Dim ts
Dim RW1
Dim RW1W
Dim RW1P
Dim RW2
Dim RW2W
Dim RW2P
Dim RW3
Dim RW3W
Dim RW3P
Dim RW4
Dim RW4W
Dim RW4P
Dim RW5
Dim RW5W
Dim RW5P
Set bcm = ScreenItems(“n1”)
Set bz = ScreenItems(“D1”)
ts = HMIRuntime.Tags(“@CurrentUserName”).Read
Set RW1 = ScreenItems(“RW1”)
Set RW1W = ScreenItems(“RW1W”)
Set RW1P = ScreenItems(“RW1P”)
Set RW2 = ScreenItems(“RW2”)
Set RW2W = ScreenItems(“RW2W”)
Set RW2P = ScreenItems(“RW2P”)
Set RW3 = ScreenItems(“RW3”)
Set RW3W = ScreenItems(“RW3W”)
Set RW3P = ScreenItems(“RW3P”)
Set RW4 = ScreenItems(“RW4”)
Set RW4W = ScreenItems(“RW4W”)
Set RW4P = ScreenItems(“RW4P”)
Set RW5 = ScreenItems(“RW5”)
Set RW5W = ScreenItems(“RW5W”)
Set RW5P = ScreenItems(“RW5P”)
‘MsgBox(“”&bcm.Text&”“+”“&RW1.Text&”“+”“&RW1W.Text&”“+”“&RW1P.Text&”“+”“&ts&”“+”“&bz.Text&”“)
‘InsertBatch “”&bcm.Text&”“,”“&RW1.Text&”“,”“&RW1W.Text&”“,”“&RW1P.Text&”“, “”&ts&”“,”“&bz.Text &””
Con=HMIRuntime.Tags(“SQL”).Read
Set conn = CreateObject(“ADODB.Connection”)
conn.ConnectionString = Con
conn.CursorLocation = 3
conn.Open
Set oRs = CreateObject(“ADODB.Recordset”)
Set oCom = CreateObject(“ADODB.Command”)
Set oCom.ActiveConnection = conn
‘判断 BATCHCODE 是否有重复
oCom.CommandType = 1
sSql=”select * from BATCH WHERE BATCHCODE=N’”&bcm.Text&”’”
oCom.CommandText = sSql
Set oRs = oCom.Execute
If oRs.RecordCount = 0 Then
sSql=”insert into BATCH (BATCHCODE,STARTTIME,ENDTIME,STARTUSERNAME,ENDUSERNAME,REMARK,FINISH) VALUES (N’”&bcm.Text&”’,’1900-1-1’,’1900-1-1’,N’无’,N’无’,N’”&bz.Text&”’,0)”
oCom.CommandText = sSql
Set oRs = oCom.Execute
sSql=”update BATCH set rm1=N’”&rw1.text&”’,rm1_price=N’”&rw1w.Text&”’,rm1_weight=N’”&rw1p.Text&”’ WHERE BATCHCODE=N’”&bcm.Text&”’”
oCom.CommandText = sSql
Set oRs = oCom.Execute
sSql=”update BATCH set rm2=N’”&rw2.text&”’,rm2_price=N’”&rw2w.Text&”’,rm2_weight=N’”&rw2p.Text&”’ WHERE BATCHCODE=N’”&bcm.Text&”’”
oCom.CommandText = sSql
Set oRs = oCom.Execute
sSql=”update BATCH set rm3=N’”&rw3.text&”’,rm3_price=N’”&rw3w.Text&”’,rm3_weight=N’”&rw3p.Text&”’ WHERE BATCHCODE=N’”&bcm.Text&”’”
oCom.CommandText = sSql
Set oRs = oCom.Execute
sSql=”update BATCH set rm4=N’”&rw4.text&”’,rm4_price=N’”&rw4w.Text&”’,rm4_weight=N’”&rw4p.Text&”’ WHERE BATCHCODE=N’”&bcm.Text&”’”
oCom.CommandText = sSql
Set oRs = oCom.Execute
sSql=”update BATCH set rm5=N’”&rw5.text&”’,rm5_price=N’”&rw5w.Text&”’,rm5_weight=N’”&rw5p.Text&”’ WHERE BATCHCODE=N’”&bcm.Text&”’”
oCom.CommandText = sSql
Set oRs = oCom.Execute
Else
MsgBox “批次代码已有”,0,”警告”
End If
Set oRs = Nothing
conn.Close
Set conn = Nothing
End Sub
Sub OnClick(ByVal Item)
Dim a
Dim sCon
Dim sSql
Dim oRs
Dim conn
Dim oCom
Dim Con
Dim tt
Dim h
Con=HMIRuntime.Tags(“SQL”).Read
Set conn = CreateObject(“ADODB.Connection”)
conn.ConnectionString = Con
conn.CursorLocation = 3
conn.Open
‘sSql=”select BATCHCODE from BATCH where FINISH = 1”
sSql=”select BATCHCODE from BATCH ”
Set oRs = CreateObject(“ADODB.Recordset”)
Set oCom = CreateObject(“ADODB.Command”)
Set oCom.ActiveConnection = conn
oCom.CommandType = 1
oCom.CommandText = sSql
Set oRs = oCom.Execute
oRs.MoveFirst
Set a = ScreenItems(“Z1”)
a.NumberLines = oRs.RecordCount
‘MsgBox oRs.RecordCount
For h = 1 To oRs.RecordCount
tt = oRs.Fields(0).Value
a.SelIndex = h
a.SelText = tt
oRs.MoveNext
Next
a.SelIndex = 1
Set oRs = Nothing
conn.Close
Set conn = Nothing
End Sub
Sub OnLButtonDown(ByVal Item, ByVal Flags, ByVal x, ByVal y)
Dim a
Dim sCon
Dim sSql
Dim oRs
Dim conn
Dim oCom
Dim Con
Dim t1
Dim t2
Dim t3
Dim t4
Dim t5
Dim t6
Dim t7
Dim t8
Dim t9
Dim t10
Dim t11
Dim h
Dim bc
Dim bc1
Dim bc2
Dim gx
Dim gx1
Set a = ScreenItems(“控件11”)
Set bc = ScreenItems(“Z1”)
If bc.SelText = “” Then
MsgBox(“请选择批次”)
Else
bc1 = “= N’”&bc.SelText&”’”
HMIRuntime.Tags(“BatchDY”).Write bc.SelText
Set gx = ScreenItems(“Z2”)
If gx.SelIndex = 1 Then
gx1 = “is not null”
Else
gx1 = “= N’”&gx.SelIndex-1&”’”
End If
a.TextMatrix(0,0) = “序号”
a.TextMatrix(0,1) = “ID”
a.TextMatrix(0,2) = “批次号”
a.TextMatrix(0,3) = “工序”
a.TextMatrix(0,4) = “开始时间”
a.TextMatrix(0,5) = “变量名”
‘a.TextMatrix(0,6) = “备注”
a.TextMatrix(0,6) = “最大值”
a.TextMatrix(0,7) = “最小值”
a.TextMatrix(0,8) = “平均值”
a.TextMatrix(0,9) = “差值”
a.TextMatrix(0,10) = “结束时间”
a.ColWidth (1) = 1000
a.ColWidth (2) = 1000
a.ColWidth (3) = 1000
a.ColWidth (4) = 2000
a.ColWidth (5) = 5000
a.ColWidth (6) = 1000
a.ColWidth (7) = 1000
a.ColWidth (8) = 1000
a.ColWidth (9) = 1000
a.ColWidth (10) =2000
‘a.ColWidth (11) = 3000
Dim RTDBName
RTDBName=HMIRuntime.Tags(“@DatasourceNameRT”).Read
Con =”Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=”&RTDBName&”;Data Source=.\WINCC”
Set conn = CreateObject(“ADODB.Connection”)
conn.ConnectionString = Con
conn.CursorLocation = 3
conn.Open
sSql=”select * FROM BATCH_PARA WHERE BATCHCODE “&bc1&” and gx “&gx1&” order by ID DESC ”
MsgBox sSql
Set oRs = CreateObject(“ADODB.Recordset”)
Set oCom = CreateObject(“ADODB.Command”)
Set oCom.ActiveConnection = conn
oCom.CommandType = 1
oCom.CommandText = sSql
Set oRs = oCom.Execute
If oRs.RecordCount = 0 Then
MsgBox “没有此记录”,0,”警告”
Else
a.Rows = oRs.RecordCount + 1
a.Cols = oRs.Fields.Count + 1
oRs.MoveFirst
‘MsgBox oRs.RecordCount
For h = 1 To oRs.RecordCount
t1 = oRs.Fields(0).Value
t2 = oRs.Fields(1).Value
t3 = oRs.Fields(2).Value
t4 = oRs.Fields(3).Value
t5 = oRs.Fields(4).Value
’ t6 = oRs.Fields(5).Value
t6 = oRs.Fields(6).Value
t7 = oRs.Fields(7).Value
t8 = oRs.Fields(8).Value
t9 = oRs.Fields(9).Value
t10 = oRs.Fields(10).Value
’ t12 = oRs.Fields(11).Value
a.TextMatrix(h,0) = h
a.TextMatrix(h,1) = t1
a.TextMatrix(h,2) = t2
a.TextMatrix(h,3) = t3
a.TextMatrix(h,4) = t4
a.TextMatrix(h,5) = t5
a.TextMatrix(h,6) = t6
a.TextMatrix(h,7) = t7
a.TextMatrix(h,8) = t8
a.TextMatrix(h,9) = t9
a.TextMatrix(h,10) = t10
’ a.TextMatrix(h,11) = t11
oRs.MoveNext
Next
End If
Set oRs = Nothing
conn.Close
Set conn = Nothing
End if
End Sub

pragma option(mbcs)

define N 81

void ACCMenuText(char* lpszPictureName,char* ValueName,char* YMID)
{
char * strTagPrefix;
char * strPictureName;
char destination[25];
char *blank = ValueName, *c = “AI.”, *Borland = “Pro/DB“;
strcpy(destination, Borland);
strcat(destination, blank);
strcat(destination, c);
strPictureName=”pic1”;
SetVisible(lpszPictureName,strPictureName,0); //Return-Type: BOOL
SetPropChar(lpszPictureName,strPictureName,”TagPrefix”,destination); //Return-Type: BOOL
SetPictureName(lpszPictureName,strPictureName,”fp_ACC.Pdl”); //Return-Type: BOOL
SetLeft(lpszPictureName,”pic1”,500); //Return-Type: BOOL
SetTop(lpszPictureName,”pic1”,240); //Return-Type: BOOL
SetVisible(lpszPictureName,strPictureName,1); //Return-Type: BOOL
strTagPrefix=GetTagPrefix(lpszPictureName,strPictureName); //Return-Type: char*
SetTagPrefix(lpszPictureName,strPictureName,strTagPrefix); //Return-Type: BOOL
SetText(“fp_ACC.Pdl”,”静态文本19”,ValueName); //Return-Type: BOOL
SetText(“fp_ACC.Pdl”,”ymid”,YMID); //Return-Type: BOOL
SetText(“ACCMain.Pdl”,”静态文本99”,ValueName); //Return-Type: BOOL
SetText(“ACCMain.Pdl”,”ymid”,YMID); //Return-Type: BOOL
}

pragma option(mbcs)

define N 81

void ACSMenuText(char* lpszPictureName,char* ValueName,char* YMID)
{
char * strTagPrefix;
char * strPictureName;
char destination[25];
char *blank = ValueName, *c = “DATA.”, *Borland = “Pro/DB“;
strcpy(destination, Borland);
strcat(destination, blank);
strcat(destination, c);
strPictureName=”pic12”;
SetVisible(lpszPictureName,strPictureName,0); //Return-Type: BOOL
SetPropChar(lpszPictureName,strPictureName,”TagPrefix”,destination); //Return-Type: BOOL
SetPictureName(lpszPictureName,strPictureName,”fp_ACSMain.Pdl”); //Return-Type: BOOL
SetLeft(lpszPictureName,”pic12”,560); //Return-Type: BOOL
SetTop(lpszPictureName,”pic12”,340); //Return-Type: BOOL
SetVisible(lpszPictureName,strPictureName,1); //Return-Type: BOOL
strTagPrefix=GetTagPrefix(lpszPictureName,strPictureName); //Return-Type: char*
SetTagPrefix(lpszPictureName,strPictureName,strTagPrefix); //Return-Type: BOOL
SetText(“fp_ACSMain.Pdl”,”静态文本19”,ValueName); //Return-Type: BOOL
SetText(“fp_ACSMain.Pdl”,”ymid”,YMID); //Return-Type: BOOL
SetText(“ACSMain.Pdl”,”静态文本24”,GetText(“fp_ACSMain.Pdl”,”静态文本19”)); //Return-Type: char*
SetText(“ACSMain.Pdl”,”ymid”,YMID); //Return-Type: BOOL

pragma option(mbcs)

define N 81

void ACSPIDText(char* lpszPictureName,char* ValueName,char* YMID)
{
char * strTagPrefix;
char * strPictureName;
char destination[25];
char *blank = ValueName, *c = “.”, *Borland = “Pro/DB_”;
strcpy(destination, Borland);
strcat(destination, blank);
strcat(destination, c);
strPictureName=”pic12”;
SetVisible(lpszPictureName,strPictureName,0); //Return-Type: BOOL
SetPropChar(lpszPictureName,strPictureName,”TagPrefix”,destination); //Return-Type: BOOL
SetPictureName(lpszPictureName,strPictureName,”fp_ACSNew.Pdl”); //Return-Type: BOOL
SetLeft(lpszPictureName,”pic12”,560); //Return-Type: BOOL
SetTop(lpszPictureName,”pic12”,340); //Return-Type: BOOL
SetVisible(lpszPictureName,strPictureName,1); //Return-Type: BOOL
strTagPrefix=GetTagPrefix(lpszPictureName,strPictureName); //Return-Type: char*
SetTagPrefix(lpszPictureName,strPictureName,strTagPrefix); //Return-Type: BOOL
SetText(“fp_ACSNew.Pdl”,”静态文本19”,ValueName); //Return-Type: BOOL
SetText(“ACSMainNew.Pdl”,”静态文本24”,GetText(“fp_ACSNew.Pdl”,”静态文本19”)); //Return-Type: char*
SetText(“fp_ACSNew.Pdl”,”ymid”,YMID); //Return-Type: BOOL
SetText(“ACSMainNew.Pdl”,”ymid”,YMID); //Return-Type: BOOL
}

pragma option(mbcs)

void Confirm(char* TagName)
{
int B;
B=MessageBox(NULL,”是否确认该操作”,”警告”,MB_OKCANCEL|MB_ICONEXCLAMATION|MB_SETFOREGROUND|MB_SYSTEMMODAL);
if(B==1)
SetTagBit(TagName,1);
}

pragma option(mbcs)

void ConfirmZero(char* TagName)
{
int B;
B=MessageBox(NULL,”是否确认该操作”,”警告”,MB_OKCANCEL|MB_ICONEXCLAMATION|MB_SETFOREGROUND|MB_SYSTEMMODAL);
if(B==1)
SetTagBit(TagName,0);
}

pragma option(mbcs)

define N 81

void ManualMenuText(char* lpszPictureName,char* ValueName,int x,int y,char* YMID)
{
char * strTagPrefix;
char * strPictureName;
char destination[25];
char *blank = ValueName, *c = “.”;
strcat(destination, blank);
strcat(destination, c);
strPictureName=”pic6”;
SetVisible(lpszPictureName,strPictureName,0); //Return-Type: BOOL
SetPropChar(lpszPictureName,strPictureName,”TagPrefix”,destination); //Return-Type: BOOL
SetPictureName(lpszPictureName,strPictureName,”fp_Manual.Pdl”); //Return-Type: BOOL
SetLeft(lpszPictureName,”pic6”,x); //Return-Type: BOOL
SetTop(lpszPictureName,”pic6”,y); //Return-Type: BOOL
SetVisible(lpszPictureName,strPictureName,1); //Return-Type: BOOL
strTagPrefix=GetTagPrefix(lpszPictureName,strPictureName); //Return-Type: char*
SetTagPrefix(lpszPictureName,strPictureName,strTagPrefix); //Return-Type: BOOL
SetText(“fp_Manual.Pdl”,”静态文本19”,ValueName); //Return-Type: BOOL
SetText(“fp_Manual.Pdl”,”ymid”,YMID); //Return-Type: BOOL
SetText(“ManualMain.Pdl”,”静态文本99”,ValueName); //Return-Type: BOOL
SetText(“ManualMain.Pdl”,”ymid”,YMID); //Return-Type: BOOL
}

pragma option(mbcs)

void MeterBack(char* lpszPictureName)
{
if(GetTagDouble(“LimAlarmEnable”)==0)
{
SetProcess(lpszPictureName,”A1”,0); //Return-Type: BOOL
SetProcess(lpszPictureName,”A2”,0); //Return-Type: BOOL
SetProcess(lpszPictureName,”A3”,0); //Return-Type: BOOL
SetProcess(lpszPictureName,”A4”,0); //Return-Type: BOOL
}
else
{
if(GetTagDouble(“LimAlarmEnable”)==1)
{
SetProcess(lpszPictureName,”A1”,1); //Return-Type: BOOL
SetProcess(lpszPictureName,”A2”,0); //Return-Type: BOOL
SetProcess(lpszPictureName,”A3”,0); //Return-Type: BOOL
SetProcess(lpszPictureName,”A4”,0); //Return-Type: BOOL
}
else
{
if(GetTagDouble(“LimAlarmEnable”)==2)
{
SetProcess(lpszPictureName,”A1”,0); //Return-Type: BOOL
SetProcess(lpszPictureName,”A2”,1); //Return-Type: BOOL
SetProcess(lpszPictureName,”A3”,0); //Return-Type: BOOL
SetProcess(lpszPictureName,”A4”,0); //Return-Type: BOOL
}
else
{
if(GetTagDouble(“LimAlarmEnable”)==3)
{
SetProcess(lpszPictureName,”A1”,1); //Return-Type: BOOL
SetProcess(lpszPictureName,”A2”,1); //Return-Type: BOOL
SetProcess(lpszPictureName,”A3”,0); //Return-Type: BOOL
SetProcess(lpszPictureName,”A4”,0); //Return-Type: BOOL
}
else
{
if(GetTagDouble(“LimAlarmEnable”)==4)
{
SetProcess(lpszPictureName,”A1”,0); //Return-Type: BOOL
SetProcess(lpszPictureName,”A2”,0); //Return-Type: BOOL
SetProcess(lpszPictureName,”A3”,1); //Return-Type: BOOL
SetProcess(lpszPictureName,”A4”,0); //Return-Type: BOOL
}
else
{
if(GetTagDouble(“LimAlarmEnable”)==5)
{
SetProcess(lpszPictureName,”A1”,1); //Return-Type: BOOL
SetProcess(lpszPictureName,”A2”,0); //Return-Type: BOOL
SetProcess(lpszPictureName,”A3”,1); //Return-Type: BOOL
SetProcess(lpszPictureName,”A4”,0); //Return-Type: BOOL
}
else
{
if(GetTagDouble(“LimAlarmEnable”)==6)
{
SetProcess(lpszPictureName,”A1”,0); //Return-Type: BOOL
SetProcess(lpszPictureName,”A2”,1); //Return-Type: BOOL
SetProcess(lpszPictureName,”A3”,1); //Return-Type: BOOL
SetProcess(lpszPictureName,”A4”,0); //Return-Type: BOOL
}
else
{

{
if(GetTagDouble(“LimAlarmEnable”)==8)
{
SetProcess(lpszPictureName,”A1”,0); //Return-Type: BOOL
SetProcess(lpszPictureName,”A2”,0); //Return-Type: BOOL
SetProcess(lpszPictureName,”A3”,0); //Return-Type: BOOL
SetProcess(lpszPictureName,”A4”,1); //Return-Type: BOOL
}
else
{
if(GetTagDouble(“LimAlarmEnable”)==9)
{
SetProcess(lpszPictureName,”A1”,1); //Return-Type: BOOL
SetProcess(lpszPictureName,”A2”,0); //Return-Type: BOOL
SetProcess(lpszPictureName,”A3”,0); //Return-Type: BOOL
SetProcess(lpszPictureName,”A4”,1); //Return-Type: BOOL
}
else
{
if(GetTagDouble(“LimAlarmEnable”)==10)
{
SetProcess(lpszPictureName,”A1”,0); //Return-Type: BOOL
SetProcess(lpszPictureName,”A2”,1); //Return-Type: BOOL
SetProcess(lpszPictureName,”A3”,0); //Return-Type: BOOL
SetProcess(lpszPictureName,”A4”,1); //Return-Type: BOOL
}
else
{
if(GetTagDouble(“LimAlarmEnable”)==11)
{
SetProcess(lpszPictureName,”A1”,1); //Return-Type: BOOL
SetProcess(lpszPictureName,”A2”,1); //Return-Type: BOOL
SetProcess(lpszPictureName,”A3”,0); //Return-Type: BOOL
SetProcess(lpszPictureName,”A4”,1); //Return-Type: BOOL
}
else
{
if(GetTagDouble(“LimAlarmEnable”)==12)
{
SetProcess(lpszPictureName,”A1”,0); //Return-Type: BOOL
SetProcess(lpszPictureName,”A2”,0); //Return-Type: BOOL
SetProcess(lpszPictureName,”A3”,1); //Return-Type: BOOL
SetProcess(lpszPictureName,”A4”,1); //Return-Type: BOOL
}
else
{
if(GetTagDouble(“LimAlarmEnable”)==13)
{
SetProcess(lpszPictureName,”A1”,1); //Return-Type: BOOL
SetProcess(lpszPictureName,”A2”,0); //Return-Type: BOOL
SetProcess(lpszPictureName,”A3”,1); //Return-Type: BOOL
SetProcess(lpszPictureName,”A4”,1); //Return-Type: BOOL
}
else
{
if(GetTagDouble(“LimAlarmEnable”)==14)
{
SetProcess(lpszPictureName,”A1”,0); //Return-Type: BOOL
SetProcess(lpszPictureName,”A2”,1); //Return-Type: BOOL
SetProcess(lpszPictureName,”A3”,1); //Return-Type: BOOL
SetProcess(lpszPictureName,”A4”,1); //Return-Type: BOOL
}
else
{
if(GetTagDouble(“LimAlarmEnable”)==15)
{
SetProcess(lpszPictureName,”A1”,1); //Return-Type: BOOL
SetProcess(lpszPictureName,”A2”,1); //Return-Type: BOOL
SetProcess(lpszPictureName,”A3”,1); //Return-Type: BOOL
SetProcess(lpszPictureName,”A4”,1); //Return-Type: BOOL
}

‘a.ColWidth (11) = 3000
Dim RTDBName
RTDBName=HMIRuntime.Tags(“@DatasourceNameRT”).Read
Con =”Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=”&RTDBName&”;Data Source=.\WINCC”
Set conn = CreateObject(“ADODB.Connection”)
conn.ConnectionString = Con
conn.CursorLocation = 3
conn.Open
sSql=”select * FROM BATCH_PARA WHERE BATCHCODE “&bc1&” and gx “&gx1&” order by ID DESC ”
MsgBox sSql
Set oRs = CreateObject(“ADODB.Recordset”)
Set oCom = CreateObject(“ADODB.Command”)
Set oCom.ActiveConnection = conn
oCom.CommandType = 1
oCom.CommandText = sSql
Set oRs = oCom.Execute
If oRs.RecordCount = 0 Then
MsgBox “没有此记录”,0,”警告”
Else
a.Rows = oRs.RecordCount + 1
a.Cols = oRs.Fields.Count + 1
oRs.MoveFirst
‘MsgBox oRs.RecordCount
For h = 1 To oRs.RecordCount
t1 = oRs.Fields(0).Value
t2 = oRs.Fields(1).Value
t3 = oRs.Fields(2).Value
t4 = oRs.Fields(3).Value
t5 = oRs.Fields(4).Value
’ t6 = oRs.Fields(5).Value
t6 = oRs.Fields(6).Value
t7 = oRs.Fields(7).Value
t8 = oRs.Fields(8).Value
t9 = oRs.Fields(9).Value
t10 = oRs.Fields(10).Value
’ t12 = oRs.Fields(11).Value
a.TextMatrix(h,0) = h
a.TextMatrix(h,1) = t1
a.TextMatrix(h,2) = t2
a.TextMatrix(h,3) = t3
a.TextMatrix(h,4) = t4
a.TextMatrix(h,5) = t5
a.TextMatrix(h,6) = t6
a.TextMatrix(h,7) = t7
a.TextMatrix(h,8) = t8
a.TextMatrix(h,9) = t9
a.TextMatrix(h,10) = t10
’ a.TextMatrix(h,11) = t11
oRs.MoveNext
Next
End If
Set oRs = Nothing
conn.Close
Set conn = Nothing
End if
End Sub

pragma option(mbcs)

define N 81

void ACCMenuText(char* lpszPictureName,char* ValueName,char* YMID)
{
char * strTagPrefix;
char * strPictureName;
char destination[25];
char *blank = ValueName, *c = “AI.”, *Borland = “Pro/DB“;
strcpy(destination, Borland);
strcat(destination, blank);
strcat(destination, c);
strPictureName=”pic1”;
SetVisible(lpszPictureName,strPictureName,0); //Return-Type: BOOL
SetPropChar(lpszPictureName,strPictureName,”TagPrefix”,destination); //Return-Type: BOOL
SetPictureName(lpszPictureName,strPictureName,”fp_ACC.Pdl”); //Return-Type: BOOL
SetLeft(lpszPictureName,”pic1”,500); //Return-Type: BOOL
SetTop(lpszPictureName,”pic1”,240); //Return-Type: BOOL
SetVisible(lpszPictureName,strPictureName,1); //Return-Type: BOOL
strTagPrefix=GetTagPrefix(lpszPictureName,strPictureName); //Return-Type: char*
SetTagPrefix(lpszPictureName,strPictureName,strTagPrefix); //Return-Type: BOOL
SetText(“fp_ACC.Pdl”,”静态文本19”,ValueName); //Return-Type: BOOL
SetText(“fp_ACC.Pdl”,”ymid”,YMID); //Return-Type: BOOL
SetText(“ACCMain.Pdl”,”静态文本99”,ValueName); //Return-Type: BOOL
SetText(“ACCMain.Pdl”,”ymid”,YMID); //Return-Type: BOOL
}

pragma option(mbcs)

define N 81

void ACSMenuText(char* lpszPictureName,char* ValueName,char* YMID)
{
char * strTagPrefix;
char * strPictureName;
char destination[25];
char *blank = ValueName, *c = “DATA.”, *Borland = “Pro/DB“;
strcpy(destination, Borland);
strcat(destination, blank);
strcat(destination, c);
strPictureName=”pic12”;
SetVisible(lpszPictureName,strPictureName,0); //Return-Type: BOOL
SetPropChar(lpszPictureName,strPictureName,”TagPrefix”,destination); //Return-Type: BOOL
SetPictureName(lpszPictureName,strPictureName,”fp_ACSMain.Pdl”); //Return-Type: BOOL
SetLeft(lpszPictureName,”pic12”,560); //Return-Type: BOOL
SetTop(lpszPictureName,”pic12”,340); //Return-Type: BOOL
SetVisible(lpszPictureName,strPictureName,1); //Return-Type: BOOL
strTagPrefix=GetTagPrefix(lpszPictureName,strPictureName); //Return-Type: char*
SetTagPrefix(lpszPictureName,strPictureName,strTagPrefix); //Return-Type: BOOL
SetText(“fp_ACSMain.Pdl”,”静态文本19”,ValueName); //Return-Type: BOOL
SetText(“fp_ACSMain.Pdl”,”ymid”,YMID); //Return-Type: BOOL
SetText(“ACSMain.Pdl”,”静态文本24”,GetText(“fp_ACSMain.Pdl”,”静态文本19”)); //Return-Type: char*
SetText(“ACSMain.Pdl”,”ymid”,YMID); //Return-Type: BOOL

pragma option(mbcs)

define N 81

void ACSPIDText(char* lpszPictureName,char* ValueName,char* YMID)
{
char * strTagPrefix;
char * strPictureName;
char destination[25];
char *blank = ValueName, *c = “.”, *Borland = “Pro/DB_”;
strcpy(destination, Borland);
strcat(destination, blank);
strcat(destination, c);
strPictureName=”pic12”;
SetVisible(lpszPictureName,strPictureName,0); //Return-Type: BOOL
SetPropChar(lpszPictureName,strPictureName,”TagPrefix”,destination); //Return-Type: BOOL
SetPictureName(lpszPictureName,strPictureName,”fp_ACSNew.Pdl”); //Return-Type: BOOL
SetLeft(lpszPictureName,”pic12”,560); //Return-Type: BOOL
SetTop(lpszPictureName,”pic12”,340); //Return-Type: BOOL
SetVisible(lpszPictureName,strPictureName,1); //Return-Type: BOOL
strTagPrefix=GetTagPrefix(lpszPictureName,strPictureName); //Return-Type: char*
SetTagPrefix(lpszPictureName,strPictureName,strTagPrefix); //Return-Type: BOOL
SetText(“fp_ACSNew.Pdl”,”静态文本19”,ValueName); //Return-Type: BOOL
SetText(“ACSMainNew.Pdl”,”静态文本24”,GetText(“fp_ACSNew.Pdl”,”静态文本19”)); //Return-Type: char*
SetText(“fp_ACSNew.Pdl”,”ymid”,YMID); //Return-Type: BOOL
SetText(“ACSMainNew.Pdl”,”ymid”,YMID); //Return-Type: BOOL
}

pragma option(mbcs)

void Confirm(char* TagName)
{
int B;
B=MessageBox(NULL,”是否确认该操作”,”警告”,MB_OKCANCEL|MB_ICONEXCLAMATION|MB_SETFOREGROUND|MB_SYSTEMMODAL);
if(B==1)
SetTagBit(TagName,1);
}

pragma option(mbcs)

void ConfirmZero(char* TagName)
{
int B;
B=MessageBox(NULL,”是否确认该操作”,”警告”,MB_OKCANCEL|MB_ICONEXCLAMATION|MB_SETFOREGROUND|MB_SYSTEMMODAL);
if(B==1)
SetTagBit(TagName,0);
}

pragma option(mbcs)

pragma option(mbcs)

void MeterBackWarn(char* lpszPictureName)
{
if(GetTagDouble(“LimWarnEnable”)==0)
{
SetProcess(lpszPictureName,”W1”,0); //Return-Type: BOOL
SetProcess(lpszPictureName,”W2”,0); //Return-Type: BOOL
SetProcess(lpszPictureName,”W3”,0); //Return-Type: BOOL
SetProcess(lpszPictureName,”W4”,0); //Return-Type: BOOL
}
else
{
if(GetTagDouble(“LimWarnEnable”)==1)
{
SetProcess(lpszPictureName,”W1”,1); //Return-Type: BOOL
SetProcess(lpszPictureName,”W2”,0); //Return-Type: BOOL
SetProcess(lpszPictureName,”W3”,0); //Return-Type: BOOL
SetProcess(lpszPictureName,”W4”,0); //Return-Type: BOOL
}
else
{
if(GetTagDouble(“LimWarnEnable”)==2)
{
SetProcess(lpszPictureName,”W1”,0); //Return-Type: BOOL
SetProcess(lpszPictureName,”W2”,1); //Return-Type: BOOL
SetProcess(lpszPictureName,”W3”,0); //Return-Type: BOOL
SetProcess(lpszPictureName,”W4”,0); //Return-Type: BOOL
}
else
{
if(GetTagDouble(“LimWarnEnable”)==3)
{
SetProcess(lpszPictureName,”W1”,1); //Return-Type: BOOL
SetProcess(lpszPictureName,”W2”,1); //Return-Type: BOOL
SetProcess(lpszPictureName,”W3”,0); //Return-Type: BOOL
SetProcess(lpszPictureName,”W4”,0); //Return-Type: BOOL
}
else
{
if(GetTagDouble(“LimWarnEnable”)==4)
{
SetProcess(lpszPictureName,”W1”,0); //Return-Type: BOOL
SetProcess(lpszPictureName,”W2”,0); //Return-Type: BOOL
SetProcess(lpszPictureName,”W3”,1); //Return-Type: BOOL
SetProcess(lpszPictureName,”W4”,0); //Return-Type: BOOL
}
else
{
if(GetTagDouble(“LimWarnEnable”)==5)
{
SetProcess(lpszPictureName,”W1”,1); //Return-Type: BOOL
SetProcess(lpszPictureName,”W2”,0); //Return-Type: BOOL
SetProcess(lpszPictureName,”W3”,1); //Return-Type: BOOL
SetProcess(lpszPictureName,”W4”,0); //Return-Type: BOOL
}
else
{
if(GetTagDouble(“LimWarnEnable”)==6)
{
SetProcess(lpszPictureName,”W1”,0); //Return-Type: BOOL
SetProcess(lpszPictureName,”W2”,1); //Return-Type: BOOL
SetProcess(lpszPictureName,”W3”,1); //Return-Type: BOOL
SetProcess(lpszPictureName,”W4”,0); //Return-Type: BOOL
}
else
{
if(GetTagDouble(“LimWarnEnable”)==7)
{
SetProcess(lpszPictureName,”W1”,1); //Return-Type: BOOL
SetProcess(lpszPictureName,”W2”,1); //Return-Type: BOOL
SetProcess(lpszPictureName,”W3”,1); //Return-Type: BOOL
SetProcess(lpszPictureName,”W4”,0); //Return-Type: BOOL
}
else
{
if(GetTagDouble(“LimWarnEnable”)==8)
{
SetProcess(lpszPictureName,”W1”,0); //Return-Type: BOOL
SetProcess(lpszPictureName,”W2”,0); //Return-Type: BOOL
SetProcess(lpszPictureName,”W3”,0); //Return-Type: BOOL
SetProcess(lpszPictureName,”W4”,1); //Return-Type: BOOL
}
else
{
if(GetTagDouble(“LimWarnEnable”)==9)
{
SetProcess(lpszPictureName,”W1”,1); //Return-Type: BOOL
SetProcess(lpszPictureName,”W2”,0); //Return-Type: BOOL
SetProcess(lpszPictureName,”W3”,0); //Return-Type: BOOL
SetProcess(lpszPictureName,”W4”,1); //Return-Type: BOOL
}
else
{
if(GetTagDouble(“LimWarnEnable”)==10)
{
SetProcess(lpszPictureName,”W1”,0); //Return-Type: BOOL
SetProcess(lpszPictureName,”W2”,1); //Return-Type: BOOL
SetProcess(lpszPictureName,”W3”,0); //Return-Type: BOOL
SetProcess(lpszPictureName,”W4”,1); //Return-Type: BOOL
}
else
{
if(GetTagDouble(“LimWarnEnable”)==11)
{
SetProcess(lpszPictureName,”W1”,1); //Return-Type: BOOL
SetProcess(lpszPictureName,”W2”,1); //Return-Type: BOOL
SetProcess(lpszPictureName,”W3”,0); //Return-Type: BOOL
SetProcess(lpszPictureName,”W4”,1); //Return-Type: BOOL
}
else
{
if(GetTagDouble(“LimWarnEnable”)==12)
{
SetProcess(lpszPictureName,”W1”,0); //Return-Type: BOOL
SetProcess(lpszPictureName,”W2”,0); //Return-Type: BOOL
SetProcess(lpszPictureName,”W3”,1); //Return-Type: BOOL
SetProcess(lpszPictureName,”W4”,1); //Return-Type: BOOL
}
else
{
if(GetTagDouble(“LimWarnEnable”)==13)
{
SetProcess(lpszPictureName,”W1”,1); //Return-Type: BOOL
SetProcess(lpszPictureName,”W2”,0); //Return-Type: BOOL
SetProcess(lpszPictureName,”W3”,1); //Return-Type: BOOL
SetProcess(lpszPictureName,”W4”,1); //Return-Type: BOOL
}
else
{
if(GetTagDouble(“LimWarnEnable”)==14)
{
SetProcess(lpszPictureName,”W1”,0); //Return-Type: BOOL
SetProcess(lpszPictureName,”W2”,1); //Return-Type: BOOL
SetProcess(lpszPictureName,”W3”,1); //Return-Type: BOOL
SetProcess(lpszPictureName,”W4”,1); //Return-Type: BOOL
}
else
{
if(GetTagDouble(“LimWarnEnable”)==15)
{
SetProcess(lpszPictureName,”W1”,1); //Return-Type: BOOL
SetProcess(lpszPictureName,”W2”,1); //Return-Type: BOOL
SetProcess(lpszPictureName,”W3”,1); //Return-Type: BOOL
SetProcess(lpszPictureName,”W4”,1); //Return-Type: BOOL
}

pragma option(mbcs)

define N 81

void MeterMenuPT(char* lpszPictureName,char* ValueName,char* YMID)
{
char * strTagPrefix;
char * strPictureName;
char destination[25];
char *blank = ValueName, *c = “.”, *Borland = “Pro/DB_”;
strcpy(destination, Borland);
strcat(destination, blank);
strcat(destination, c);
strPictureName=”pic1”;
SetVisible(lpszPictureName,strPictureName,0); //Return-Type: BOOL
SetPropChar(lpszPictureName,strPictureName,”TagPrefix”,destination); //Return-Type: BOOL
SetPictureName(lpszPictureName,strPictureName,”fp_MeterPT.Pdl”); //Return-Type: BOOL
SetLeft(lpszPictureName,”pic1”,500); //Return-Type: BOOL
SetTop(lpszPictureName,”pic1”,240); //Return-Type: BOOL
SetVisible(lpszPictureName,strPictureName,1); //Return-Type: BOOL
strTagPrefix=GetTagPrefix(lpszPictureName,strPictureName); //Return-Type: char*
SetTagPrefix(lpszPictureName,strPictureName,strTagPrefix); //Return-Type: BOOL
SetText(“fp_MeterPT.Pdl”,”静态文本19”,ValueName); //Return-Type: BOOL
SetText(“fp_MeterPT.Pdl”,”BC1”,”无”); //Return-Type: BOOL
SetText(“fp_MeterPT.Pdl”,”UN1”,GetTagChar(“@CurrentUserName”)); //Return-Type: BOOL
SetText(“fp_MeterPT.Pdl”,”ymid”,YMID); //Return-Type: BOOL
SetText(“MeterMainPT.Pdl”,”静态文本99”,ValueName); //Return-Type: BOOL
SetText(“MeterMainPT.Pdl”,”UN1”,GetTagChar(“@CurrentUserName”)); //Return-Type: BOOL
SetText(“MeterMainPT.Pdl”,”BC1”,”无”); //Return-Type: BOOL
SetText(“MeterMainPT.Pdl”,”ymid”,YMID); //Return-Type: BOOL
}

pragma option(mbcs)

define N 81

void MeterMenuText(char* lpszPictureName,char* ValueName,char* YMID)
{
char * strTagPrefix;
char * strPictureName;
char destination[25];
char *blank = ValueName, *c = “.”, *Borland = “Pro/DB_”;
strcpy(destination, Borland);
strcat(destination, blank);
strcat(destination, c);
strPictureName=”pic1”;
SetVisible(lpszPictureName,strPictureName,0); //Return-Type: BOOL
SetPropChar(lpszPictureName,strPictureName,”TagPrefix”,destination); //Return-Type: BOOL
SetPictureName(lpszPictureName,strPictureName,”fp_Meter.Pdl”); //Return-Type: BOOL
SetLeft(lpszPictureName,”pic1”,500); //Return-Type: BOOL
SetTop(lpszPictureName,”pic1”,240); //Return-Type: BOOL
SetVisible(lpszPictureName,strPictureName,1); //Return-Type: BOOL
strTagPrefix=GetTagPrefix(lpszPictureName,strPictureName); //Return-Type: char*
SetTagPrefix(lpszPictureName,strPictureName,strTagPrefix); //Return-Type: BOOL
SetText(“fp_Meter.Pdl”,”静态文本19”,ValueName); //Return-Type: BOOL
SetText(“fp_Meter.Pdl”,”BC1”,”无”); //Return-Type: BOOL
SetText(“fp_Meter.Pdl”,”UN1”,GetTagChar(“@CurrentUserName”)); //Return-Type: BOOL
SetText(“fp_Meter.Pdl”,”ymid”,YMID); //Return-Type: BOOL
SetText(“MeterMain.Pdl”,”静态文本99”,ValueName); //Return-Type: BOOL
SetText(“MeterMain.Pdl”,”UN1”,GetTagChar(“@CurrentUserName”)); //Return-Type: BOOL
SetText(“MeterMain.Pdl”,”BC1”,”无”); //Return-Type: BOOL
SetText(“MeterMain.Pdl”,”ymid”,YMID); //Return-Type: BOOL
}

pragma option(mbcs)

void PIDBack(char* lpszPictureName)
{
if(GetTagBit(“P_SEL”)==0)
{
SetProcess(lpszPictureName,”A4”,0); //Return-Type: BOOL
}
else
{
SetProcess(lpszPictureName,”A4”,1); //Return-Type: BOOL
}
if(GetTagBit(“I_SEL”)==0)
{
SetProcess(lpszPictureName,”A3”,0); //Return-Type: BOOL
}
else
{
SetProcess(lpszPictureName,”A3”,1); //Return-Type: BOOL
}
if(GetTagBit(“D_SEL”)==0)
{
SetProcess(lpszPictureName,”A2”,0); //Return-Type: BOOL
}
else
{
SetProcess(lpszPictureName,”A2”,1); //Return-Type: BOOL
}
}

pragma option(mbcs)

define N 81

void ACCMenuText(char* lpszPictureName,char* ValueName,char* YMID)
{
char * strTagPrefix;
char * strPictureName;
char destination[25];
char *blank = ValueName, *c = “AI.”, *Borland = “Pro/DB“;
strcpy(destination, Borland);
strcat(destination, blank);
strcat(destination, c);
strPictureName=”pic1”;
SetVisible(lpszPictureName,strPictureName,0); //Return-Type: BOOL
SetPropChar(lpszPictureName,strPictureName,”TagPrefix”,destination); //Return-Type: BOOL
SetPictureName(lpszPictureName,strPictureName,”fp_ACC.Pdl”); //Return-Type: BOOL
SetLeft(lpszPictureName,”pic1”,500); //Return-Type: BOOL
SetTop(lpszPictureName,”pic1”,240); //Return-Type: BOOL
SetVisible(lpszPictureName,strPictureName,1); //Return-Type: BOOL
strTagPrefix=GetTagPrefix(lpszPictureName,strPictureName); //Return-Type: char*
SetTagPrefix(lpszPictureName,strPictureName,strTagPrefix); //Return-Type: BOOL
SetText(“fp_ACC.Pdl”,”静态文本19”,ValueName); //Return-Type: BOOL
SetText(“fp_ACC.Pdl”,”ymid”,YMID); //Return-Type: BOOL
SetText(“ACCMain.Pdl”,”静态文本99”,ValueName); //Return-Type: BOOL
SetText(“ACCMain.Pdl”,”ymid”,YMID); //Return-Type: BOOL
}

include “apdefap.h”

void OnLButtonDown(char* lpszPictureName, char* lpszObjectName, char* lpszPropertyName, UINT nFlags, int x, int y)
{

pragma option(mbcs)

char * strTagPrefix;
char * strPictureName;
strPictureName=”pic1”;
SetVisible(“UserMain.pdl”,strPictureName,0); //Return-Type: BOOL
SetPictureName(“UserMain.pdl”,strPictureName,”UserAdd.pdl”); //Return-Type: BOOL
SetVisible(“UserMain.pdl”,strPictureName,1); //Return-Type: BOOL
}

include “apdefap.h”

void OnClick(char* lpszPictureName, char* lpszObjectName, char* lpszPropertyName)
{

pragma option(mbcs)

if(GetTagBit(“topmenu3”)==1)
SetTagBit(“topmenu3”,0);
if(GetTagBit(“topmenu4”)==1)
SetTagBit(“topmenu4”,0);
if(GetTagBit(“topmenu5”)==1)
SetTagBit(“topmenu5”,0);
if(GetTagBit(“topmenu6”)==1)
SetTagBit(“topmenu6”,0);
if(GetTagBit(“topmenu7”)==1)
SetTagBit(“topmenu7”,0);
if(GetTagBit(“topmenu8”)==1)
SetTagBit(“topmenu8”,0);
if(GetTagBit(“topmenu9”)==1)
SetTagBit(“topmenu9”,0);
if(GetTagBit(“topmenu10”)==1)
SetTagBit(“topmenu10”,0);
if(GetTagBit(“topmenu1”)==1)
SetTagBit(“topmenu1”,0);
if(GetTagBit(“topmenu2”)==1)
SetTagBit(“topmenu2”,0);
}

  • 0
    点赞
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值