基于VC_的生产线信息管理系统开发

2010274:2010-10-12:(D09010400700901):(1984-),,,,.:1006-3269(2010)04-0012-06VC++蔡明,张怀存(,100192):介绍了生产线信息管理系统.本系统基于面向对象的编程语言VisualC++6.0和SQL2000数据库作为开发平台,采用ODBC技术对数据库进行访问,利用VisualC++6.0进行界面的相关设计来实现生产线信息数据的记录增加修改查询打印报表和列表视图等技术,同时还通过用户密码登陆企业生产线信息管理系统,用来提高生产线信息管理系统的安全性.:VisualC++6.0;SQL2000;生产线信息管理;开发式数据库连接:TP311.5:Adoi:10.3969/j.issn.1006-3269.2010.04.004.,,.,,,[1].,,.,,.,.VisualC++SQL2000.,VisualC++6.0,SQL2000,.ODBC,,SQL,,.11.1,.,.,.1.2.,,.1.!12!GroupTechnology&ProductionModernizationVol.27,No.4,201011.3,.,:∀;#;;∃.1.4SQL2000,.,,..1(tb_user)..1usernamepasswordvarchar(50)varchar(50)2(tb_subject).,.2subjectnamesubjectnumbervarchar(50)varchar(50)3(tb_examinfo_sub)..3studentidcodegradekindexamdatevarchar(50)varchar(50)float(8)varchar(50)varchar(50)4(tb_studentinfo)..!13!20102744studentidstudentnamesexageaddrphoneclassvarchar(50)varchar(50)varchar(50)float(8)varchar(50)varchar(50)varchar(50)5(tb_regbreakinfo)..5studentidcontentresultmemotimewxnamewxrengzmsvarchar(50)varchar(50)varchar(50)varchar(50)datetime(8)varchar(50)varchar(50)varchar(50)6(tb_info)..6idtimeincometypeincomenumcosttypecostnumaboutint(4)datetime(8)varchar(50)varchar(50)varchar(50)varchar(50)varchar(50)7(tb_Log).,.7studentidwxlevelwxfzrengzkindkdatewxtimewxfeegzfxwxcodevarchar(50)varchar(50)varchar(50)varchar(50)varchar(50)datetime(8)varchar(50)float(8)varchar(50)varchar(50)8(tb_pj)..8studentidwxcodepjnameghfzrenghdatepjxhvarchar(50)varchar(50)varchar(50)varchar(50)datetime(8)varchar(50)!14!GroupTechnology&ProductionModernizationVol.27,No.4,20109(tb_shouhou)..9fenleiidpmguigedanweikcsliangbeizhuvarchar(50)varchar(50)varchar(50)varchar(50)varchar(50)varchar(50)10(tb_xiaoshou)..10xsdhkhmcjbrszdqxsrqgddhjehzslhzvarchar(50)varchar(50)varchar(50)varchar(50)datetime(8)varchar(50)varchar(50)varchar(50),..22.1.,[2].8.:∀,;#;∃,;%.://,m_ImageList.Create(32,32,ILC_COLOR24|ILC_MASK,1,1);//m_ImageList.Add(AfxGetApp()-LoadIcon(IDI_ICONBOOK));m_ImageList.Add(AfxGetApp()-LoadIcon(IDI_ICONNOTE));//m_ToolBar.GetToolBarCtrl().SetImageList(&m_ImageList);m_ToolBar.SetSizes(CSize(50,60),CSize(32,32));//m_ToolBar.SetButtonText(0,&∋);m_ToolBar.SetButtonText(1,&∋);RepositionBars(AFX_IDW_CONTROLBAR_FIRST,AFX_IDW_CONTROLBAR_LAST,0);2.2ODBCODBC(SQL),ODBC[3].ODBC,CDatabaseOpen,Open.virtualBOOLOpen(LPCTSTRlpszDSN,BOOLbExclusive=FALSE,BOOLbReadOnly=FALSE,LPCTSTRlpszConnect=&ODBC;∋,BOOLbUseCursorLib=TRUE);OpenODBC,!15!2010274,CRecordset..,WindowsXP,&∋&∋&DataSources(ODBC)∋,&ODBC∋.&ODBC∋,VC++ODBC.2.3,,,.[][],,,.[],CRecordSetAddNew(),Update(),[4].://UpdateData(TRUE);mysubjectset-AddNew();mysubjectset-m_subjectnumber=m_subjectid;mysubjectset-m_subjectname=m_subjectname;//mysubjectset-Update();mysubjectset-MoveLast();mysubjectset-Requery();2.4[5]..,m_list2,WM_INITDIALOG,OnInitDialog.,InsertColumn(),.,,DeleteAllItems().,CRecordSetDelete(),Requery().://m_list2.InsertColumn(0,&∋,LVCFMT_CENTER,150);m_list2.InsertColumn(1,&∋,LVCFMT_CENTER,150);m_list2.SetExtendedStyle(LVS_EX_GRIDLINES|LVS_EX_FULLROWSELECT);//m_list2.DeleteAllItems();//inti=0;while(!mysubjectset-IsEOF()){CStringstr,str1;str=mysubjectset-m_subjectnumber;str1=mysubjectset-m_subjectname;m_list2.InsertItem(i,str);m_list2.SetItemText(i,1,str1);i++;mysubjectset-MoveNext();}//mysubjectset-Delete();mysubjectset-Requery();2.5.,CDialogCPreParentCPreView.CPreParent,CPreParentCPreVieew[6].[],CPreParentDlgPreView,DlgPreViewSetCallBackFun(DrawInfo,PrnInfo),DlgPreViewDoModal(),!16!GroupTechnology&ProductionModernizationVol.27,No.4,2010.:if(m_list.GetItemCount()=0)return;PRNINFOPrnInfo={0};PrnInfo.hListView=m_list.m_hWnd;PrnInfo.hWnd=this-m_hWnd;PrnInfo.IsPrint=FALSE;PrnInfo.nCurPage=1;PrnInfo.nMaxLine=m_list.GetItemCount();CPreParentDlgPreView;DlgPreView.SetCallBackFun(DrawInfo,PrnInfo);DlgPreView.DoModal();3.,,,,.2.24VisualC++6.0,ODBC,.,,.,.,.,.,,,B/S,.:[1],,.[J].,2005,22(5):25-26.[2].VisualC++6.0[M].:,2009.[3].VisualC++6.0[M].:,2007.[4].VisualC++[M].:,2007.[5],,.VisualC++[M].:,2007.[6],,,.VisualC++[M].:,2008.AProductionLinesInformationManagementSystemDevelopmentBasedonVC++CAIMing,ZHANGHuaicun(SchoolofElectromechanicalEngineering,BeijingInformationScienceandTechnologyUniversity,Beijing100192,China)Abstract:Aproductionlinesinformationmanagementsystemistheimportantaspectofinformationmanagementinanenterprise.WithVisualC++6.0andSQL2000asthedevelopmentplatform,thepaperstudiesonusingODBCtechnologytoaccessdatasources,andtheVisualC++isusedtodotherelatedworkofdevelopmentoftheinterface,whichcanbeusedtorealizethecollectionofinformationdata,records,increase,query,groupreports,andlistviewtechnologies,meanwhileusingkeypasswordprotectiontechnologytoputontheproductionlinesinformationmanagementsystem,inordertoimprovethesafetyleveloftheproductionlinesinformationmanagementsystem.Keywords:VisualC++6.0;SQL2000;productionlinesinformationmanagement;opendatabaseconnectivity!17!