二○○九~二○一○學(xué)年第二學(xué)期 2.系統(tǒng)分析與設(shè)計(jì)2.2窗體類型2.3流程圖身份驗(yàn)證藥品信息銷售情況用戶管理空。能，是按照會(huì)員編號(hào)查詢的，把編號(hào)輸入文代碼privatevoidbutton1_Click(objectsender,EventArgse){stringcnProviderMicrosoftJetOLEDB.4.0;DataSource="+Application.StartupPath+OleDbConnectioncnnnewOleDbConnectioncn;OleDbConnectioncnnnewOleDbConnectioncn;textBoxTextOleDbCommandcomnewOleDbCommand(txt3,cnn);DataTabledtnewDataTable();OleDbDataAdapterdanewOleDbDataAdaptercomOleDbCommandBuildercbnewOleDbCommandBuilder(da);{MessageBox.Show("無(wú)此用戶,請(qǐng)重新輸入");}{FormmynewForm2();myShowDialog;}}4.2藥品信息插入的相關(guān)代碼privatevoidbutton3_Click(objectsender,EventArgse){StringstrSQLINSERTINTOb(藥品名稱,價(jià)格,生產(chǎn)批號(hào),藥物數(shù)量,生產(chǎn)日期,保質(zhì)期)VALUES('"+textBox1.Text+"',"+textBox2.Text+","+textBox3.Text+","+textBox4.Text+","+textBox5.Text+","+textBox6.Text+")";cebiaomdbOleDbCommandcommnewOleDbCommandstrSQL,conn);{onQuery}xceptionex{}}4.3藥品信息刪除的相關(guān)代碼privatevoidbutton2_Click(objectsender,EventArgse){CmdonnectionconnrdelCmdDeleteFrombWhere品名稱="+"'"+textBox8.Text+"'";DbCommandcmdewOleDbConnectionconnStr{cmdnewOleDbCommanddelCmdconnnQueryMessageBoxShow("刪除成功");}xceptionex{MessageBox.Show("Errorinhanding:"+ex.Message);}{}}4.4藥品信息查詢的相關(guān)代碼privatevoidbutton4_Click(objectsender,EventArgse){tronnectionconnDbCommandcmdReadermyReaderewOleDbConnectionconnStr{cmdnewOleDbCommandselectCmdconnmyReadercmdExecuteReader();{gn+++}{w}myReaderClose}xceptionex{}{}}4.5藥品信息更新的相關(guān)代碼privatevoidbutton1_Click(objectsender,EventArgse){leDbConnectionconnnewOleDbConnectionProviderMicrosoftJetOLEDBDataSourcebiao.mdb");{apternewOleDbDataAdapterdadapterSelectCommandnewOleDbCommandstrSqlconn);ewDataSetdsetidViewDataSourcedsetTables}xceptionex{}{}}4.6文本框清空的相關(guān)代碼privatevoidbutton6_Click(objectsender,EventArgse){textBox1.Text="";textBox2.Text="";textBox3.Text="";textBox4.Text="";textBox5.Text="";textBox6.Text="";textBox7.Text="";textBox8.Text="";richTextBox1.Text="";}4.7月總收入排序的相關(guān)代碼privatevoidbutton2_Click(objectsender,EventArgse){OleDbConnectionanewOleDbConnectionProviderMicrosoft.Jet.OLEDB.4.0;DatacebiaomdbstringsqlStringselectfromorderby月總收入";OleDbCommandtnewOleDbCommand(sqlString,a);DbDataReaderdrtExecuteReaderrichTextBoxText="月份\t\t月總收入\n";whiledrRead()){richTextBoxAppendText(dr["月份"]+"\t\t");richTextBoxAppendText(dr["月總收入"]+"\t\t\n");}}5.