武汉生物工程学院学士学位论文
}
catch { MessageBox.Show(\请正确操作\ }
//显示数据
private void treeView3_AfterSelect(object sender, TreeViewEventArgs e) {
//选择节点之后的事件
TreeNode tn = treeView3.SelectedNode; if (tn.Text == \库存管理\ {
groupBox4.Visible = true; groupBox5.Visible = true; panel2.Visible = true;
string cmdText = \
DataTable dt = SqlHelper.GetTable(cmdText, false); dataGridView4.DataSource = dt; } try {
if (tn.Text == \汽车入库\ {
groupBox4.Visible = true; groupBox5.Visible = true; panel2.Visible = true; string sql = \insert into carInfo values(@a,@b,@c,@d,@e,@f,@g)\
SqlParameter[] pms = new SqlParameter[7];
pms[0] = new SqlParameter(\ pms[1] = new SqlParameter(\ pms[2] = new SqlParameter(\ pms[3] = new SqlParameter(\ pms[4] = new SqlParameter(\ pms[5] = new SqlParameter(\
pms[6] = new SqlParameter(\ int i = SqlHelper.ExecuteSQL(sql, false, pms); if (i > 0) {
MessageBox.Show(\汽车成功入库\ } else {
MessageBox.Show(\汽车入库失败\ }
25
武汉生物工程学院学士学位论文
}
if (tn.Text == \汽车出库\ {
groupBox4.Visible = true; groupBox5.Visible = true; panel2.Visible = true;
if (dataGridView4.SelectedRows.Count == 0) {
MessageBox.Show(\亲，请选择要离开的数据！！\ return; }
DialogResult dr = MessageBox.Show(\亲，真心要离开么？\友情提示\
if (dr == DialogResult.Yes) {
string storageNo = dataGridView4.SelectedRows[0].Cells[0].Value.ToString();
string sql = \ SqlParameter pms = new SqlParameter(\ int i = SqlHelper.ExecuteSQL(sql, false, pms); if (i > 0) {
MessageBox.Show(\汽车成功出库\ } else {
MessageBox.Show(\汽车出库失败\ } } } } catch {
MessageBox.Show(\请正确操作\ }
}
汽车管理表： ListView的操作: //修改
private void button7_Click(object sender, EventArgs e) {
try
26
武汉生物工程学院学士学位论文
{
if (editItem == null) {
return; }
//更新
editItem.SubItems[1].Text = textBox16.Text; editItem.SubItems[2].Text = textBox17.Text; editItem.SubItems[3].Text = textBox19.Text; editItem.SubItems[4].Text = textBox18.Text; int i = comboBox1.SelectedIndex;
editItem.Group = listView1.Groups[i]; string imgKey = editItem.ImageKey; //把imgkey对应的图片删除 ，
if (pictureBox2.Image != imageList3.Images[imgKey]) {
imageList2.Images.RemoveByKey(imgKey); imageList3.Images.RemoveByKey(imgKey); //把新图片增加进去，名称为imgkey Image ig = pictureBox2.Image;
imageList2.Images.Add(imgKey, ig); imageList3.Images.Add(imgKey, ig);
}
MessageBox.Show(\修改成功！\ }
catch { MessageBox.Show(\请正确操作\ }
视图
private void 大图ToolStripMenuItem_Click(object sender, EventArgs e) {
listView1.View = View.LargeIcon; }
private void 小图ToolStripMenuItem_Click(object sender, EventArgs e) {
listView1.View = View.SmallIcon; }
private void 详情ToolStripMenuItem_Click(object sender, EventArgs e) {
listView1.View = View.Details;
27
武汉生物工程学院学士学位论文
}
private void 列表ToolStripMenuItem_Click(object sender, EventArgs e) {
listView1.View = View.List; }
private void 平铺ToolStripMenuItem_Click(object sender, EventArgs e) {
listView1.View = View.Tile; }
右击增删改
private void 新增ToolStripMenuItem_Click(object sender, EventArgs e) {
try {
string carNo = textBox20.Text; if (carNo == \是否为空检测 {
MessageBox.Show(\汽车编号不能为空\ return; }
//检测列表中有没有这个编号存在
foreach (ListViewItem item in listView1.Items) {
if (carNo == item.Text) {
MessageBox.Show(\此编号已经存在\ return; } }
//1.将图片存到imageList中,图片的名称就取编号名 Image img = pictureBox2.Image; imageList2.Images.Add(carNo, img); imageList3.Images.Add(carNo, img);
//2.将数据获取到新增列表里面去 string color = textBox16.Text; string fcName = textBox17.Text; string tel = textBox18.Text; string ofcDate = textBox19.Text; int index = comboBox1.SelectedIndex;
28
武汉生物工程学院学士学位论文
ListViewItem lvi = new ListViewItem();
lvi.Group = listView1.Groups[index];//用编号找对应的组 lvi.ImageKey = carNo; lvi.Text = carNo;
lvi.SubItems.Add(color); lvi.SubItems.Add(fcName); lvi.SubItems.Add(tel); lvi.SubItems.Add(ofcDate); listView1.Items.Add(lvi);
MessageBox.Show(\新增成功！\ }
catch { MessageBox.Show(\请正确操作\ }
private void 删除ToolStripMenuItem_Click(object sender, EventArgs e) {
try {
//将选中的项删除，同时将imgagelist中的对应头像也删除 int count = 0;//计数器
DialogResult dr = MessageBox.Show(\真心要删除么？\友情提示\MessageBoxButtons.OKCancel, MessageBoxIcon.Asterisk); if (dr != DialogResult.OK) {
return; }
while (listView1.SelectedItems.Count > 0) {
ListViewItem lvi = listView1.SelectedItems[0]; string imgkey = lvi.ImageKey;//这一项对应的图片名 listView1.Items.Remove(lvi);//移除这一项 //把这一项对应的头像移除
imageList1.Images.RemoveByKey(imgkey); count++; }
MessageBox.Show(\你删除了\条数据！！\ }
catch { MessageBox.Show(\请正确操作\ }
ListViewItem editItem = null;//正在被修改的项
private void 编辑ToolStripMenuItem_Click(object sender, EventArgs e) {
try {
29