簡析倉儲(chǔ)物資管理系統(tǒng)

《簡析倉儲(chǔ)物資管理系統(tǒng)》由會(huì)員上傳分享，免費(fèi)在線閱讀，更多相關(guān)內(nèi)容在工程資料-天天文庫。

1、簡析倉儲(chǔ)物資管理系統(tǒng)簡析倉儲(chǔ)物資管理系統(tǒng)_數(shù)據(jù)庫課程設(shè)計(jì)導(dǎo)讀：.........145.7出入庫信息表設(shè)計(jì)..................................175.8刪改信息設(shè)計(jì)......................................236總結(jié)..................................................25簡析倉儲(chǔ)物資管理系統(tǒng)_數(shù)據(jù)庫課程設(shè)計(jì)(2)導(dǎo)讀：lmandm=neand(;register;,conn);m.mandType=mandT

2、ype.StoredProcedure;m.Parameters.AddS_DB.mdf;IntegratedSecurity=True;ConnectTimeout=30;UserInstance=True;;SqlConnectionconn=neat(;selectcount(*)from[usertable]e='{0}'andpasse,passp;tbuser.Text==;admin;){conn.Open();Sqlmandm=neand(sql,conn);intnum=(int)m.ExecuteSc

3、alar();if(num>0){this.Hide();Fmmenuf1=nemenu();f1.Shoation);}}elseif(boBox1.Text==;普通管理員;){conn.Open();Sqlmandm=neand(sql,conn);intnum=(int)m.ExecuteScalar();if(num>0){this.Hide();Fmmenuf1=nemenu();f1.刪改信息ToolStripMenuItem.Enabled=false;f1.Shoation);}}else{

4、MessageBox.Shoation);}}catch(Exceptioneee){MessageBox.Shoation);}finally{conn.Close();}}privatevoidBUT_z_Click(objectsender,EventArgse){Fmregisterf2=neregister();f2.Shoe=F:倉庫管理系統(tǒng)倉庫管理系統(tǒng)S_DB.mdf;IntegratedSecurity=True;ConnectTimeout=30;UserInstance=True;;SqlCon

5、nectionconn=neandm=neand(;register;,conn);m.mandType=mandType.StoredProcedure;m.Parameters.AddessageBox.Shoation);}else{MessageBox.Shoation);}}catch(Exception){MessageBox.Shoation);}finally{conn.Close();}}elseMessageBox.Shoation);}privatevoidbut_return_Click(obje

6、ctsender,EventArgse){this.Close();}5.3修改privatevoidbut_Y_Click(objectsender,EventArgse){if(tBsure.Text==tBNpass.Text){stringconnstring=;DataSource=zhaojuan-PCSQLEXPRESS;AttachDbFilename=D:倉庫管理系統(tǒng)倉庫管理系統(tǒng)S_DB.mdf;IntegratedSecurity=True;;SqlConnectiontry{conn.Ope

7、n();Sqlmandm=neand(;updatepass;,conn);m.mandType=mandType.StoredProcedure;m.Parameters.AddessageBox.Show簡析倉儲(chǔ)物資管理系統(tǒng)_數(shù)據(jù)庫課程設(shè)計(jì)(3)導(dǎo)讀：ipMenuItem_Click(objectsender,EventArgse){putinto__Click(objectsender,EventArgse){allinformations=neation();s.Sho_Click(objectsender,Ev

8、entArgse)(;修改成功;);tBuser.Text=;;;tBpass.Text=;;;tBNpass.Text=;;;tBsure.Text=;;;tBuser.Focus();}else{MessageBox.Shoation);}}catch{MessageBox.Shoation);}finally{