大二下12c個人項目

目錄緒 目錄緒 課題背 課題研究現(xiàn) 課題研究的意 文檔的內(nèi) 需求分 需求陳 業(yè)務(wù)流 系統(tǒng)設(shè) 系統(tǒng)功能設(shè) 數(shù)據(jù)庫設(shè) 系統(tǒng)實 登陸界 選擇考試界 計算機考試界 后臺管理界 試題管理界 結(jié) 11Interent的模擬考試系統(tǒng)1996美國的NTU、英國的OPENCOLLEGE都是當(dāng)時十分典型的網(wǎng)絡(luò)教育示22333-11233-11234表3-312345671234512345表3-3123456712345123453-43-53-612123456712343-43-53-6121234567123456744在線考試namespace{publicpartialclassfrmLogin:{public{}privatevoidbtnReturn_Click(objectsender,EventArgs{{publicpartialclassfrmLogin:{public{}privatevoidbtnReturn_Click(objectsender,EventArgs{}privatevoidbtnLogin_Click(objectsender,EventArgs{if(txtUserName.Text.Trim()=={}if(txtUserPwd.Text.Trim()=={}DBHelperdb=newstringQuery="select*fromexamUserInfowhere+"examUserName='"++"'andexamUserPwd='"+txtUserPwd.Text+"'";SqlDataReaderdr=db.MyQuery(Query);if{stringQuery1="selectexamUserRightfromexamUserInfo"+"examUserName='"+txtUserName.Text+"'";SqlDataReaderdr1=db.MyQuery(Query1);if{if(dr1["examUserRight"].ToString().Trim(){frmUserMainfUserMain=newfrmUserMain();fUserMain.UserName=txtUserName.Text;fUserMain.UserPwd=txtUserPwd.Text;}elseif(dr1["examUserRight"].ToString().Trim(){frmManageMainfUserMain.UserPwd=txtUserPwd.Text;}elseif(dr1["examUserRight"].ToString().Trim(){frmManageMainfManageMain=newfrmManageMain();fManageMain.UserName=txtUserName.Text;fManageMain.UserPwd=txtUserPwd.Text;}}}{}}privatevoidbtnAdd_Click(objectsender,{frmRegisterfRegister=newfrmRegister();}}}namespace{publicpartialclassfrmUserMain:{publicstringstring{}EventArgse){frmUpdatePwdpublicstringstring{}EventArgse){frmUpdatePwdfUpdate=newfrmUpdatePwd();fUpdate.UserName=this.UserName;fUpdate.UserPwd=this.UserPwd;}EventArgse){frmCompTestfCompTest=newfrmCompTest();fCompTest.UserName=this.UserName;}{frmQueryfQuery=new}privatevoidEToolStripMenuItem_Click(objectsender,EventArgs{}privatevoidEToolStripMenuItem_Click(objectsender,EventArgs{}{=}}namespace{publicpartialclass{:namespace{publicpartialclass{:{CNO=newContent=newKeyA====newuserAnswer=newintNumber=0;intScore=0;string}publicinttime=privatevoidbutton1_Click(objectsender,EventArgs{txtTimer.Text=GetTime(time);button1.Enabled=false;DBHelperdb=newDBHelper();stringdelTest="deletefromexamTestprivatevoidbutton1_Click(objectsender,EventArgs{txtTimer.Text=GetTime(time);button1.Enabled=false;DBHelperdb=newDBHelper();stringdelTest="deletefromexamTest";stringdelAnswer="deletefromexamUserAnswerselecttop*stringaddTest="insertintoexamTestexamEngRadioInfoorderbyNEWID()"; examTest.CNO,nullfromexamTeststringQueryTest="select*fromexamTestSqlDataReaderdr=db.MyQuery(QueryTest);inti=0;while{CNO[i]=dr["CNO"].ToString();Content[i]=dr["Content"].ToString();=====}i=}privatevoidtimer1_Tick(objectsender,{time-=txtTimer.Text=(time=={for(inti=0;i<=19;privatevoidtimer1_Tick(objectsender,{time-=txtTimer.Text=(time=={for(inti=0;i<=19;{if(userAnswer[i]=={Score+=}{}}DBHelperdb=newstringnow==examUserScore(examUserName,examType,examUserScore,examUserTime)"valuesUserNameScore+frmUserMainfUserMain=newfrmUserMain();}}publicstringGetTime(int{stringmm,intm/%=<intif{mm=0}{mm=}intm/%=<intif{mm=0}{mm=}if(s<{=0+}{=}mm+":"+}publicvoidShowChoose(inti)//{rrtbContent.Text=rbtnKeyA.Text===}privatevoid{sender,EventArgstxtName.Text=}privatevoidbtnFirst_Click(objectsender,EventArgs{Number=0;}privatevoidbtnLast_Click(objectsender,EventArgstxtName.Text=}privatevoidbtnFirst_Click(objectsender,EventArgs{Number=0;}privatevoidbtnLast_Click(objectsender,EventArgs{Number=19;}sender,EventArgsprivatevoid{if(Number=={}{}}sender,EventArgsprivatevoid{if(Number=={}{}}privatevoid{userAnswer[Number]="A";DBHelperdb=new}{}}privatevoid{userAnswer[Number]="A";DBHelperdb=newDBHelper();sender,EventArgs"stringupdate="updateexamUserAnswerset+"whereCNO='"+CNO[Number]+"'";}privatevoidrbtnKeyB_Click(objectsender,EventArgs{userAnswer[Number]="B";DBHelperdb=newDBHelper();stringupdate="updateexamUserAnswerset+"whereCNO='"+CNO[Number]+"'";}"privatevoidrbtnKeyC_Click(objectsender,EventArgs{userAnswer[Number]="C";DBHelperdb=newDBHelper();stringupdate="updateexamUserAnswerset"+"whereCNO='"+CNO[Number]+}privatevoidrbtnKeyD_Click(objectsender,EventArgs{userAnswer[Number]="D";DBHelperdb=newDBHelper();stringupdate="updateexamUserAnswerset+"whereCNO='"+"whereCNO='"+CNO[Number]+}privatevoidrbtnKeyD_Click(objectsender,EventArgs{userAnswer[Number]="D";DBHelperdb=newDBHelper();stringupdate="updateexamUserAnswerset+"whereCNO='"+CNO[Number]+"'";}"voidbtnSubmit_Click(object{{(inti=0;i<=19;if(userAnswer[i]=={Score+=}{}}DBHelperdb=newstringnow==examUserScore(examUserName,examType,examUserScore,examUserTime)+"values('"+UserName+"','英語',"+ScorefrmUserMainfUserMain=new+now}}}}}}usingusingnamespace{publicpartialclassfrmManageMain:{usingusingnamespace{publicpartialclassfrmManageMain:{{stringUserName;stringUserPwd;}privatevoid{}sender,EventArgsEventArgse){frmAddManagefAddManage=new}{frmDeleteUserfDeleteUser=newfrmDeleteUser();}{frmQueryUserfQueryUser=new{frmQueryUserfQueryUser=newfrmQueryUser();}privatevoidsender,{frmUpdatePwdfUpdatePwd=newfrmUpdatePwd();fUpdatePwd.UserName=this.UserName;fUpdatePwd.UserPwd=this.UserPwd;}EventArgsprivatevoidtoolStripMenuItem1_Click(object{frmManageRadiofManageRadio=newfrmManageRadio();}}}namespacenamespace{publicpartialclassfrmManageRadio:{public{}privatevoidfrmManageRadio_Load(objectsender,EventArgs{if(cbbSubject.Text{SqlConnectionconn=newSqlConnection();conn.ConnectionString=DBHelper.getConnectionString();SqlDataAdapterda=newSqlDataAdapter("selectCNOas題號,Contentas題目內(nèi)容,"+"KeyAas選項A,KeyBas選項B,KeyCas選項C,KeyDas選項D,Answeras答案from"+"examCompRadioInfo",conn);DataSetds=newDataSet();dataGridView1.DataSource=}elseif(cbbSubject.Text{SqlConnectionconn=newSqlConnection();conn.ConnectionString=DBHelper.getConnectionString();SqlDataAdapterda=newSqlDataAdapter("selectCNOas題號,Contentas題目內(nèi)容,"+"KeyAas選項A,KeyBas選項B,KeyCas選項C,KeyDas選項D,Answeras答案from"+"examEngRadioInfo",conn);DataSetds=newDataSet();dataGridView1.DataSource=}}DataGridViewCellEventArgs{=======}privatevoidbtnReturn_Click(objectsender,{frmManageMainfManageMain}DataGridViewCellEventArgs{=======}privatevoidbtnReturn_Click(objectsender,{frmManageMainfManageMain=newfrmManageMain();}privatevoidbtnAdd_Click(objectsender,EventArgs{(txtCNO.Text.Trim()=={}if(txtAnswer.Text.Trim()=={}{(rtbContent.Text.Trim()==}{(rtbKeyA.Text.Trim()==}{(rtbKeyB.Text.Trim()==}{(rtbKeyC.Text.Trim()==}{(rtbKeyA.Text.Trim()==}{(rtbKeyB.Text.Trim()==}{(rtbKeyC.Text.Trim()==}{(rtbKeyD.Text.Trim()==}{(cbbSubject.TextDBHelperdb=newstringQueryCno="select*fromexamCompRadioInfoSqlDataReaderdr=db.MyQuery(QueryCno);if(dr.Read()){}{where+txtCNO.TextstringQueryContent="Select*fromexamCompRadioInfowhereContent='"+rtbContent.Text+"'";dr=db.MyQuery(QueryContent);if(dr.Read()){DialogResultresultMessageBox.Show("已存在相同內(nèi)容試題，是否仍要添加試題？","提示",MessageBoxButtons.YesNo,if(result=={stringaddTest="insertinto++"','"+if(result=={stringaddTest="insertinto++"','"++"','"+rtbKeyA.Text+"','"++"','"rtbKeyC.Text+"','"+rtbKeyD.Text+"','"+txtAnswer.Text+"')";frmManageRadio_Load(sender,}{}}{string= ++"','"++"','"+rtbKeyA.Text+"','"+rtbKeyB.Text"','"+rtbKeyC.Text+"','"+rtbKeyD.Text+"','"+txtAnswer.Text+}}}elseif(cbbSubject.Text{DBHelperdb=newwherestringQueryCno="select*fromexamEngRadioInfoSqlDataReaderdr=db.MyQuery(QueryCno);if(dr.Read()){}{+txtCNO.TextstringQueryContent="Select*fromexamEngRadioInfowhereContent='"+rtbContent.Text+"'";dr=db.MyQuery(QueryContent);if(dr.Read()){DialogResultresultMessageBox.Show("已存在相同內(nèi)容試題，是否仍要添加試題？","提示",MessageBoxButtons.YesNo,if(result=={stringaddTest=dr=db.MyQuery(QueryContent);if(dr.Read()){DialogResultresultMessageBox.Show("已存在相同內(nèi)容試題，是否仍要添加試題？","提示",MessageBoxButtons.YesNo,if(result=={stringaddTest="insertinto++"','"++"','"+rtbKeyA.Text+"','"++"','"rtbKeyC.Text+"','"+rtbKeyD.Text+"','"+txtAnswer.Text+"')";frmManageRadio_Load(sender,}{}}{ = ++"','"++"','"+rtbKeyA.Text"','"+rtbKeyB.Text"','"+rtbKeyC.Text+"','"+rtbKeyD.Text+"','"+txtAnswer.Text+}}}}privatevoidcbbSubject_SelectedValueChanged(objectsender,{if(cbbSubject.Text{SqlConnectionconn=newSqlConnection();conn.ConnectionString=DBHelper.getConnectionString();SqlDataAdapterda=new號,Contentas題目內(nèi)容,"+"KeyAas選項A,KeyBasD,AnswerasfromexamCompRadioInfoDataSetds=newSqlDataAdapter("selectSqlDataAdapterda=new號,Contentas題目內(nèi)容,"+"KeyAas選項A,KeyBasD,AnswerasfromexamCompRadioInfoDataSetds=newSqlDataAdapter("selectCNOas選項B,KeyCas選項C,KeyDas選項da.Fill(ds,"examCompRadioInfo");dataGridView1.DataSource=ds.Tables[0];}elseif(cbbSubject.Text{SqlConnectionconn=newSqlConnection();conn.ConnectionString=DBHelper.getConnectionString();SqlDataAdapterda=newSqlDataAdapter("selectCNOas題號,Contentas題目內(nèi)容,"+"KeyAas選項A,KeyBas選項B,KeyCas選項C,KeyDas選項D,Answeras答案fromexamEngRadioInfo",conn);DataSetds=newDataSet();dataGridView1.DataSource=}}privatevoidbtnQuery_Click(objectsender,EventArgs{if(cbbSubject.Text{if(txtQueryStr.Text.Trim()=={SqlConnectionconn=newSqlConnection();conn.ConnectionString=DBHelper.getConnectionString();SqlDataAdapterda=new號,Contentas題目內(nèi)容,""KeyAasA,KeyBasD,Answeras答案from"+"examCompRadioInfoSqlDataAdapter("selectCNOas題選項B,KeyCas選項C,KeyDasDataSetds=newDataSet();dataGridView1.DataSource=}{SqlConnectionconn=newconn.ConnectionString=conn.ConnectionString=DBHelper.getConnectionString();SqlDataAdapterda=newSqlDataAdapter("selectCNOas題號,Contentas題目內(nèi)容,""KeyAasA,KeyBasB,KeyCasC,KeyDasD,Answeras答案from"+"examCompRadioInfowhereCNO='"+txtQueryStr.Text+DataSetds=newDataSet();dataGridView1.DataSource=}}elseif(cbbSubject.Text{if(txtQueryStr.Text.Trim()=={SqlConnectionconn=newSqlConnection();conn.ConnectionString=DBHelper.getConnectionString();SqlDataAdapterda=newSqlDataAdapter("selectCNOas題號,Contentas題目內(nèi)容,""KeyAasA,KeyBasB,KeyCasC,KeyDasD,Answeras答案from"+"examEngRadioInfo",conn);DataSetds=newDataSet();dataGridView1.DataSource=}{SqlConnectionconn=newSqlConnection();conn.ConnectionString=DBHelper.getConnectionString();SqlDataAdapterda=newSqlDataAdapter("selectCNOas題號,Contentas題目內(nèi)容,""KeyAasA,KeyBasB,KeyCasC,KeyDasD,Answeras答案from"+"examEngRadioInfowhereCNO='"+txtQueryStr.Text+DataSetds=newDataSet();dataGridView1.DataSource=}}privatevoidbtnDel_Click(objectsender,EventArgs{if(txtCNO.Text.Trim()=={}if(cbbSubject.Text{}}privatevoidbtnDel_Click(objectsender,EventArgs{if(txtCNO.Text.Trim()=={}if(cbbSubject.Text{DBHelperdb=newstringQuery="select*fromexamCompRadioInfowhere+txtCNO.Text+SqlDataReaderdr=db.MyQuery(Query);if(dr.Read()){DialogResultresultMessageBox.Show("是否刪除該條記錄的"提示",MessageBoxButtons.YesNo,if(result=={stringnonQuery="deletefrom+txtCNO.Text+"'";txtQueryStr.Text="";frmManageRadioLoad(sender,e);}{}}{}}elseif(cbbSubject.Text{DBHelperdb=newstringQuery="select*fromexamEngRadioInfowhere+txtCNO.Text+SqlDataReaderdr={DBHelperdb=newstringQuery="select*fromexamEngRadioInfowhere+txtCNO.Text+SqlDataReaderdr=db.MyQuery(Query);if(dr.Read()){DialogResultresultMessageBox.Show("是否刪除該條記錄的"提示",MessageBoxButtons.YesNo,if(result=={stringnonQuery="deletefrom+txtCNO.Text+"'";txtQueryStr.Text="";frmManageRadio_Load(sender,e);}{}}{}}}voidbtnUpdate_Click(objectsender,{if(txtCNO.Text.Trim()=={}if(txtAnswer.Text.Trim()=={}{(rtbContent.Text.Trim()==}{(rtbKeyA.Text.Trim()==}{}{(rtbContent.Text.Trim()==}{(rtbKeyA.Text.Trim()==}{(rtbKeyB.Text.Trim()==}{(cbbSubject.TextDBHelperdb=newstringQueryCno="select*fromexamCompRadioInfowhere+txtCNO.Text+SqlDataReaderdr=db.MyQuery(QueryCno);if(!dr.Read()){}{DialogResultresultMessageBox.Show("確認(rèn)修改試題？","提示",MessageBoxButtons.YesNo,==if{updateContent="updatesetContent='"+rtbContent.Text+"'whereCNO='"+txtCNO.Text+stringupdateKeyA="updateexamCompRadioInfosetKeyA='"+rtbKeyA.Text+"'whereCNO='"+txtCNO.Text+"'";stringupdateKeyB="updateexamCompRadioInfowhereCNO='"+txtCNO.Text+"'";stringupdateKeyC="updateexamCompRadioInfowhereCNO='"+txtCNO.Te