附录2新华书店进销存管理系统部分程序源代码

附录2新华书店进销存管理系统部分程序源代码1、主程序MAIN.PRG程序代码SETDEFAULTTOC:\毕业设计PUBLICnkfgl,nxsgl,ncggl,nkcgl,nxtglSTORE.f.TOnkfgl,nxsgl,ncggl,nkcgl,nxtglPUBLICnname,ndepartmentSTORETOnname,ndepartmentDoFormloginfReadEventsDoFormmainReadEventsQuit2、主表单MAIN.SCX代码2.1表单Init过程程序代码dommenu.mprwiththis,.T.this.label2.caption=nnamethis.label4.caption=ndepartment3、系统登入表单LOGINF.SCX代码3.1表单登入按钮Click事件程序代码SELECTuserGOTOP*检查用户名和密码是否输入Ifempty(thisform.text1.value)thenthisform.label3.caption=请输入用户名returnelseifempty(thisform.text2.value)thenthisform.label3.caption=请输入密码returnendifendif*操作USER表，查询满足条件记录locateforname=alltrim(thisform.text1.value)if!found()thisform.label3.caption=用户不存在returnelseifuser.password!=alltrim(thisform.text2.value)thenthisform.label3.caption=密码错误returnendifendifnname=user.namendepartment=user.departmentnkfgl=user.kfglnxsgl=user.xsglncggl=user.cgglnkcgl=user.kcglnxtgl=user.xtglthisform.releaseclearevents4、系统管理表单XTGLF.SCX代码4.1表单Init过程程序代码thisform.text1.enabled=.f.thisform.text2.enabled=.f.thisform.text3.enabled=.f.thisform.combo1.enabled=.f.thisform.check1.enabled=.f.thisform.check2.enabled=.f.thisform.check3.enabled=.f.thisform.check4.enabled=.f.thisform.check5.enabled=.f.thisform.label5.visible=.f.thisform.text3.visible=.f.thisform.command10.enabled=.f.thisform.command11.enabled=.f.thisform.dis_recordthisform.dis_reccommand4.2表单自定义过程DIS_RECORD程序代码PUBLICnewcommandSTORE.f.TOnewcommandifreccount(user)=0thisform.text1.value=thisform.text2.value=thisform.combo1.value=thisform.check1.value=0thisform.check2.value=0thisform.check3.value=0thisform.check4.value=0thisform.check5.value=0elsethisform.text1.value=user.namethisform.text2.value=user.passwordthisform.combo1.value=user.departmentifuser.kfglthenthisform.check1.value=1elsethisform.check1.value=0endififuser.xsglthenthisform.check2.value=1elsethisform.check2.value=0endififuser.cgglthenthisform.check3.value=1elsethisform.check3.value=0endififuser.kcglthenthisform.check4.value=1elsethisform.check4.value=0endififuser.xtglthenthisform.check5.value=1elsethisform.check5.value=0endifendifthisform.refresh4.3表单自定义过程DIS_RECCOMMAND程序代码privatenstore0tonn=reccount(user)ifn=1.or.n=0thenthisform.command1.enabled=.f.thisform.command2.enabled=.f.thisform.command3.enabled=.f.thisform.command4.enabled=.f.elseifrecno(user)=1thenthisform.command1.enabled=.f.thisform.command2.enabled=.f.thisform.command3.enabled=.t.thisform.command4.enabled=.t.elseifrecno(user)=nthenthisform.command1.enabled=.t.thisform.command2.enabled=.t.thisform.command3.enabled=.f.thisform.command4.enabled=.f.elsethisform.command1.enabled=.t.thisform.command2.enabled=.t.thisform.command3.enabled=.t.thisform.command4.enabled=.t.endifendifendifthisform.refresh4.4表单保存按钮Click事件程序代码ifempty(thisform.text1.value)then=messagebox(请输入用户名,0+48+0,出错)thisform.text1.setfocusthisform.refreshreturnendififempty(thisform.text2.value)then=messagebox(请输入密码,0+48+0,出错)thisform.text2.setfocusthisform.refreshreturnendifif.not.(alltrim(thisform.text2.value)==alltrim(thisform.text3.value))then=messagebox(密码重复错误,请重新输入,0+48+0,出错)thisform.text2.value=thisform.text3.value=thisform.text2.setfocusthisform.refreshreturnendififempty(thisform.combo1.value)then=messagebox(请选择所属部门,0+48+0,出错)thisform.combo1.setfocusthisform.refreshreturnendififthisform.check1.value=0.and.thisform.check2.value=0.and.thisform.check3.value=0.and.thisform.check4.value=0.and.thisform.check5.value=0then=messagebox(至少选择一个用户权限,0+48+0,出错)thisform.check1.setfocusthisform.refreshreturnendififthisform.check1.value=1.and.thisform.check2.value=1.and.thisform.check3.value=1.and.thisform.check4.value=1.and.thisform.check5.value=1thenmesbox=messagebox(此用户将具有全部权限,请确认,4+48+0,警告)ifmesbox=7thenthisform.check1.setfocusthisform.refreshreturnendifendif*用户权限处理PRIVATEnname,npassword,ndepartment,nkf,nxs,ncg,nkc,nxtnname=alltrim(thisform.text1.value)npassword=alltrim(thisform.text2.value)ndepartment=alltrim(thisform.combo1.value)ifthisform.check1.value=1thennkf=.t.elsenkf=.f.endififthisform.check2.value=1thennxs=.t.elsenxs=.f.endififthisform.check3.value=1thenncg=.t.elsencg=.f.endififthisform.check4.value=1thennkc=.t.elsenkc=.f.endififthisform.check5.value=1thennxt=.t.elsenxt=.f.endif*判断是新记录保存还是修改记录Ifnewcommandthen&&newcommand=.t.是新记录保存locateforuser.name=alltrim(thisform.text1.value)iffound()then=messagebox(用户已经存在,0+48+0,出错)thisform.text1.setfocusthisform.refreshreturnendif*数据表user保存记录insertintouser(name,password,department,kfgl,xsgl,cggl,kcgl,xtgl)values(nname,npassword,ndepartment,nkf,nxs,ncg,nkc,nxt)=messagebox(保存完毕,0+48+0,提示)elseupdateusersetpassword=npassword,department=ndepartment,kfgl=nkf,xsgl=nxs,cggl=ncg,kcgl=nkc,xtgl=nxtwherename=nname=messagebox(修改完成,0+48+0,提示)endif*表单初始化thisform.text1.enabled=.f.thisform.text2.enabled=.f.thisform.text3.enabled=.f.thisform.combo1.enabled=.f.thisform.check1.enabled=.f.thisform.check2.enabled=.f.thisform.check3.enabled=.f.thisform.check4.enabled=.f.thisform.check5.enabled=.f.thisform.command1.enabled=.t.thisform.command2.enabled=.t.thisform.command3.enabled=.t.thisform