仓库管理系统
}
private void btAdd_Click(object sender, EventArgs e) {
if (txtISGID.Text == \) {
MessageBox.Show(\货物编号不能为空!\, \信息\, MessageBoxButtons.OK, MessageBoxIcon.Information); }
if (txtGIPrice.Text == \) {
MessageBox.Show(\货物单价不能为空!\, \信息\, MessageBoxButtons.OK, MessageBoxIcon.Information);
}
if (txtISGNum.Text == \) {
MessageBox.Show(\进货数量不能为空!\, \信息\, MessageBoxButtons.OK, MessageBoxIcon.Information); }
else // 获取货物入库存储过程的执行返回值 {
int P_returnValue =
doperate.InsertGoods(Convert.ToInt32(txtISGID.Text.Trim()), txtISGName.Text.Trim(),
cboxPName.Text.Trim(), cboxSName.Text.Trim(), txtGSpec.Text.Trim(), cboxGUnit.Text.Trim(),
Convert.ToInt32(txtISGNum.Text.Trim()), Convert.ToDecimal(txtGIPrice.Text.Trim()), txtHPeople.Text.Trim(), txtISRemark.Text.Trim());
if (P_returnValue == 100) {
MessageBox.Show(\该货物号已经被占用!\, \信息\, MessageBoxButtons.OK, MessageBoxIcon.Information); }
26
仓库管理系统
else if (P_returnValue == 200) {
MessageBox.Show(\这类货物已经存在惟一编号!\, \信息\, MessageBoxButtons.OK, MessageBoxIcon.Information); } else {
MessageBox.Show(\货物入库成功!\, \信息\, MessageBoxButtons.OK, MessageBoxIcon.Information); ISManage_Load(sender, e); } } }
3用户管理
代码实现
27
仓库管理系统
private void UserManage_Load(object sender, EventArgs e) {
DataSet myds = datacon.getds(\UserID as 用户编号,UserName as 用户名,UserPwd as 用户密码,\
+ \用户权限 from Userinfo\, \); dgvUInfo.DataSource = myds.Tables[\];
}
private void btAdd_Click(object sender, EventArgs e) {
if (txtUPwd.Text.Trim() != txtQPwd.Text.Trim())
MessageBox.Show(\您的两次输入不一致,请重新输入!\); else
{ try {
int P_int_returnValue =
doperate.InsertUser(txtUName.Text.Trim(), txtUPwd.Text.Trim(), cboxURight.Text.Trim());
if (P_int_returnValue == 100) {
MessageBox.Show(\该用户已经存在\, \警告\, MessageBoxButtons.OK, MessageBoxIcon.Warning); } else {
MessageBox.Show(\用户信息添加成功!\, \信息\, MessageBoxButtons.OK, MessageBoxIcon.Information); UserManage_Load(sender, e); } }
catch (Exception ex) {
MessageBox.Show(ex.Message, \警告\,
28
仓库管理系统
MessageBoxButtons.OK, MessageBoxIcon.Warning); }
} }
private void btModify_Click(object sender, EventArgs e) {
if (txtUPwd.Text.Trim() != txtQPwd.Text.Trim())
MessageBox.Show(\您的两次输入不一致,请重新输入!\); else { try {
datacon.getcom(\ + txtUName.Text.Trim() + \
+ txtUPwd.Text.Trim()
+ \ + cboxURight.Text.Trim() + \ + Convert.ToString(dgvUInfo[0, dgvUInfo.CurrentCell.RowIndex].Value).Trim() + \);
MessageBox.Show(\用户信息修改成功!\, \信息\, MessageBoxButtons.OK, MessageBoxIcon.Information); UserManage_Load(sender, e); }
catch (Exception ex) {
MessageBox.Show(ex.Message, \信息\, MessageBoxButtons.OK, MessageBoxIcon.Information); } } }
private void btDel_Click(object sender, EventArgs e) { try {
29
仓库管理系统
datacon.getcom(\ + Convert.ToString(dgvUInfo[0, dgvUInfo.CurrentCell.RowIndex].Value).Trim() + \);
MessageBox.Show(\删除用户信息成功!\, \信息\, MessageBoxButtons.OK, MessageBoxIcon.Information); UserManage_Load(sender, e); }
catch (Exception ex) {
MessageBox.Show(ex.Message, \警告\, MessageBoxButtons.OK, MessageBoxIcon.Warning); } }
private void btExit_Click(object sender, EventArgs e) {
this.Close(); }
private void dgvUInfo_CellClick(object sender, DataGridViewCellEventArgs e) {
txtUName.Text = Convert.ToString(dgvUInfo[1, dgvUInfo.CurrentCell.RowIndex].Value).Trim();
txtUPwd.Text = Convert.ToString(dgvUInfo[2, dgvUInfo.CurrentCell.RowIndex].Value).Trim();
txtQPwd.Text = Convert.ToString(dgvUInfo[2, dgvUInfo.CurrentCell.RowIndex].Value).Trim();
cboxURight.Text = Convert.ToString(dgvUInfo[3, dgvUInfo.CurrentCell.RowIndex].Value).Trim(); }
五 总结
本系统以建筑行业原材料库存管理为背景,运用C#编程语言
30
百度搜索“77cn”或“免费范文网”即可找到本站免费阅读全部范文。收藏本站方便下次阅读,免费范文网,提供经典小说综合文库C#仓库管理系统 论文(6)在线全文阅读。
相关推荐: