仓库管理系统
LSfosl.ShowDialog(); }
private void 货物借出查询ToolStripMenuItem_Click(object sender, EventArgs e) {
Look.BGLook LSfbgl = new Look.BGLook(); LSfbgl.ShowDialog();
}
private void 货物归还查询ToolStripMenuItem_Click(object sender, EventArgs e) {
Look.RGLook LSfrgl = new Look.RGLook(); LSfrgl.ShowDialog(); }
private void 更改密码ToolStripMenuItem_Click(object sender, EventArgs e) {
Help.EditPwd HPfep = new Help.EditPwd(); HPfep.ShowDialog(); }
private void 权限设置ToolStripMenuItem_Click(object sender, EventArgs e) {
Help.RightManage HPfrm = new Help.RightManage(); HPfrm.ShowDialog(); }
private void 用户管理ToolStripMenuItem_Click(object sender, EventArgs e) {
Help.UserManage HPfum = new Help.UserManage(); HPfum.ShowDialog();
21
仓库管理系统
}
private void 重新登录ToolStripMenuItem_Click(object sender, EventArgs e) {
Login flogin = new Login(); flogin.Show(); this.Dispose(); }
private void 退出系统ToolStripMenuItem_Click(object sender, EventArgs e) {
if (MessageBox.Show(\您真的要退出本系统吗？\, \提示\,
MessageBoxButtons.OKCancel, MessageBoxIcon.Information) == DialogResult.OK) {
Application.Exit(); } else {
Main main = new Main(); main.Show(); }
}
4.3各分界面的实现
1库存查询
22
仓库管理系统
代码设计
private void btLook_Click(object sender, EventArgs e) { try {
if (txtLKWord.Text.Trim() == \) {
GILook_Load(sender, e);//判断是否输入了查询关键字 } else {
if (cboxLCondition.Text.Trim() == \货物编号\) {
DataSet myds = datacon.getds(\货物编号,GoodsName as 货物名称,\
+ \仓库名称,GoodsSpec as 货物规格,GoodsUnit as 计量单位,\
+ \货物数量,GoodsInPrice as 进货价格,GoodsOutPrice as 出货价格,\
+ \修改人,EditDate as 修改日期\ + \ +
23
仓库管理系统
txtLKWord.Text.Trim() + \, \);
dgvGInfo.DataSource = myds.Tables[0];//对DataGridView 控件进行数据绑定 }
if (cboxLCondition.Text.Trim() == \货物名称\) {
DataSet myds = datacon.getds(\货物编号,GoodsName as 货物名称,\
+ \仓库名称,GoodsSpec as 货物规格,GoodsUnit as 计量单位,\
+ \货物数量,GoodsInPrice as 进货价格,GoodsOutPrice as 出货价格,\
+ \修改人,EditDate as 修改日期\ + \ + txtLKWord.Text.Trim() + \, \);
dgvGInfo.DataSource = myds.Tables[0]; }
if (cboxLCondition.Text.Trim() == \仓库名称\) {
DataSet myds = datacon.getds(\货物编号,GoodsName as 货物名称,\
+ \仓库名称,GoodsSpec as 货物规格,GoodsUnit as 计量单位,\
+ \货物数量,GoodsInPrice as 进货价格,GoodsOutPrice as 出货价格,\
+ \修改人,EditDate as 修改日期\ + \ + txtLKWord.Text.Trim() + \, \);
dgvGInfo.DataSource = myds.Tables[0]; } } }
catch (Exception ex) {
MessageBox.Show(ex.Message, \提示\, MessageBoxButtons.OK, MessageBoxIcon.Information); }
24
仓库管理系统
2入库管理
代码实现
private void ISManage_Load(object sender, EventArgs e) {
dgvISManage.Controls.Add(hScrollBar1);
doperate.cboxBind(\, \, \, cboxSName);
doperate.cboxBind(\, \, \, cboxPName);
DataSet myds = datacon.getds(\入库编号,GoodsID as 货物编号,GoodsName as 货物名称,PrName as 供应商名称,\
+ \仓库名称,GoodsSpec as 货物规格,GoodsUnit as 计量单位,GoodsNum as 入库数量,\
+ \as 进货价格,GoodsAPrice as 总金额,ISDate as 入库日期,HandlePeople as 经手人,\
+ \备注 from ISinfo\, \); dgvISManage.DataSource = myds.Tables[0];
25