简析仓储物资管理系统

《简析仓储物资管理系统》由会员上传分享，免费在线阅读，更多相关内容在工程资料-天天文库。

　　简析仓储物资管理系统简析仓储物资管理系统_数据库课程设计导读：.........145.7出入库信息表设计..................................175.8删改信息设计......................................236总结..................................................25简析仓储物资管理系统_数据库课程设计(2)导读：lmandm=neand(;register;,conn);m.mandType=mandType.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.ExecuteScalar();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{MessageBox.Shoation);}}catch(Exceptioneee){MessageBox.Shoation);}finally{conn.Close();}}privatevoidBUT_z_Click(objectsender,EventArgse){Fmregisterf2=neregister();f2.Shoe=F:仓库管理系统仓库管理系统S_DB.mdf;IntegratedSecurity=True;ConnectTimeout=30;UserInstance=True;; SqlConnectionconn=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(objectsender,EventArgse){this.Close();}5.3修改privatevoidbut_Y_Click(objectsender,EventArgse){if(tBsure.Text==tBNpass.Text){stringconnstring= ;DataSource=zhaojuan-PCSQLEXPRESS;AttachDbFilename=D:仓库管理系统仓库管理系统S_DB.mdf;IntegratedSecurity=True;;SqlConnectiontry{conn.Open();Sqlmandm=neand(;updatepass;,conn);m.mandType=mandType.StoredProcedure;m.Parameters.AddessageBox.Show简析仓储物资管理系统_数据库课程设计(3)导读：ipMenuItem_Click(objectsender,EventArgse){putinto__Click(objectsender,EventArgse){allinformations=neation();s.Sho_Click(objectsender,EventArgse)(;修改成功;);tBuser.Text=;;;tBpass.Text=;;;tBNpass.Text=;;;tBsure.Text=;;;tBuser.Focus();}else{MessageBox.Shoation);}}catch {MessageBox.Shoation);}finally{conn.Close();}}else{MessageBox.Shoation);tBuser.Text=;;;tBpass.Text=;;;tBNpass.Text=;;;tBsure.Text=;;;tBuser.Focus();}}privatevoidbutton1_Click(objectsender,EventArgse){this.Close();}5.4系统主界面设计和代码publicpartialclassFmmenu:Form{publicFmmenu(){Initializeponent();}privatevoid职员ToolStripMenuItem_Click(objectsender,EventArgse){putinto__Click(objectsender,EventArgse){allinformations=neation();s.Sho_Click(objectsender,EventArgse) {BY_indre=neind();re.Sho_Click(objectsender,EventArgse){updatapassup=ne_Click(objectsender,EventArgse){Aboutab=ne_Click(objectsender,EventArgse){BY_SUPbs=newBY_SUP();bs.ShowDialog();}}