物资管理信息系统3

import win.ui;/*DSG{{*/var frmUserAdd = ..win.form(text="添加用户";right=333;bottom=363;parent=...)
frmUserAdd.add(
button={cls="button";text="添加";left=43;top=286;right=126;bottom=321;z=7};
button2={cls="button";text="取消";left=185;top=286;right=268;bottom=321;z=8};
id={cls="edit";left=140;top=33;right=286;bottom=61;edge=1;z=10};
name={cls="edit";left=140;top=97;right=286;bottom=125;edge=1;z=4};
password={cls="edit";left=140;top=160;right=286;bottom=188;edge=1;password=1;z=5};
password2={cls="edit";left=140;top=224;right=286;bottom=252;edge=1;password=1;z=6};static={cls="static";text="请输入用户名";left=27;top=100;right=111;bottom=118;transparent=1;z=1};
static2={cls="static";text="请输入密码";left=27;top=166;right=111;bottom=184;transparent=1;z=2};
static3={cls="static";text="请确认密码";left=27;top=233;right=111;bottom=252;transparent=1;z=3};
static4={cls="static";text="请输入操作员编号";left=27;top=33;right=126;bottom=51;transparent=1;z=9}
)/*}}*/var db = mainForm.parent.db
frmUserAdd.id.setFocus()

frmUserAdd.button2.oncommand = function(id,event){//取消;if(db)db.close()
frmUserAdd.close()
}

frmUserAdd.button.oncommand = function(id,event){//添加;var d = 0var id = frmUserAdd.id.textvar name = frmUserAdd.name.textvar pass = frmUserAdd.password.textvar pass2  = frmUserAdd.password2.text;if(!#id){
frmUserAdd.msgbox("用户编号不能为空")
frmUserAdd.id.setFocus()
}
elseif(!#name){
frmUserAdd.msgbox("用户名不能为空")
frmUserAdd.name.setFocus()
}
elseif(!#pass){
frmUserAdd.msgbox("密码不能为空")
frmUserAdd.password.setFocus()
}elseif(pass2!=pass){
frmUserAdd.msgbox("密码不符请重输")
frmUserAdd.password2.text = ""frmUserAdd.password2.setFocus()
}else{try{if(db)db.exec("insert into use values(@id,@n,@p);",{id=id;n=name;p=pass})
}catch(e){
d = frmUserAdd.msgbox("用户编号不能重复")
frmUserAdd.id.setFocus(0)
}if(!d){
frmUserAdd.msgbox("添加成功")
}

}
}

frmUserAdd.show()
win.loopMessage();return frmUserAdd;
(0)

相关推荐