代码实现:string ls_user_name
string ls_password
long ll_count
//鼠标焦点放到ddlb_1:用户名的文本框中
ddlb_1.setfocus()
//将文本框的值赋给变量
ls_user_name=trim(ddlb_1.text)
ls_password=trim(sle_password.text)
//判空
If ls_user_name= ' ' or isnull(ls_user_name) then
messagebox('提示','请输入用户编号!')
return
end if
If ls_password= ' ' or isnull(ls_password) then
messagebox('提示','请输入用户密码!')
return
end if
sle_password.setfocus()
//判断用户名和密码是否正确
select count(*) into :ll_count from sys_user where username =:ls_user_name and password =:ls_password;
If ll_count<1 then
messagebox('提示','用户编号或密码错误')
sle_password.text = ''
return
end if
//判断用户权限
select userid into :g_user_id from sys_user where username=:ls_user_name;
select flag into :gs_flag from sys_user where userid=:g_user_id;
//设置全局变量
g_username = ls_user_name
//定义变量
string ls_id,ls_max_id,ls_userid,ls_username,ls_login_time
//显示时间
ls_login_time = string(today(),"yyyy-mm-dd hh:mm:ss")
//将用户登录记录插入用户操作日志表中
insert into log(id,userid,username,login_time) values (:ls_id,:g_user_id,:g_username,:ls_login_time);
//打开主窗体
open(w_main)
//关闭登录窗体
close(w_login)