[解决办法] 学习主要是为了其思路,不是为了其编码,有了思路,代码自然就有了。 [解决办法] Set Exac On This.passn=1 csql='driver=sql server;server='+Allt(sysinfo.sername)+';uid=jq;pwd=87030300;database=lsyd' lnhandle=Sqlstringconnect(csql) If lnhandle>0 SQLExec(lnhandle,"select * from ls_log where clientid=?sysinfo.clientid ","tlog") If sysinfo.clientid#tlog.clientid OR lflag Messagebox('站点冲突!请与管理员联系...',64,'信息') SQLDisconnect(lnhandle) lnhandle=0 Thisform.command2.Click retu ENDIF
SQLExec(lnhandle,"select * from ls_oper","operate") Thisform.combo2.RowSource='operate.oper' Thisform.combo2.SetFocus Else Thisform.command2.Click Endi ******************************* If Empt(This.Parent.combo2.DisplayValue) Messagebox('请选择操作员...',64,'信息') This.Parent.combo2.SetFocus Retu Endi
If Allt(This.Parent.text2.Value)==cpw(.F.,operate.pw) And Upper(Allt(This.Parent.text2.Value))#'ERROR' SQLExec(lnhandle,"update ls_log set lflag=1 where clientid=?sysinfo.clientid") Repl opid With operate.opid,oper With operate.oper In sysinfo
SQLExec(lnhandle,"select * from ls_oprole where opid=?sysinfo.opid","tope") Select tope qx=.F. Scan qx(rolecode)=.T. Endscan Use In tope
If This.Parent.CHECK1.Value &&修改口令 Do Form modipass Else If Empty(This.Parent.TEXT2.Value) =Messagebox('为了数据安全,请设置操作口令!',64,'信息') Endi Endi