武汉生物工程学院学士学位论文
//将当前选中的项的内容放到下面的控件中 editItem = listView1.SelectedItems[0]; textBox20.Text = editItem.Text;
textBox16.Text = editItem.SubItems[1].Text; textBox17.Text = editItem.SubItems[2].Text; textBox18.Text = editItem.SubItems[3].Text; textBox19.Text = editItem.SubItems[4].Text; string key = editItem.ImageKey;
pictureBox2.Image = imageList3.Images[key]; comboBox1.SelectedItem = editItem.Group.Header; }
catch { MessageBox.Show(\请正确操作\ }
private void linkLabel1_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e) {
try {
//选择图片，把选择的图片放到pictureBox上 OpenFileDialog ofd = new OpenFileDialog(); ofd.Filter = \图片文件(*.jpg;*.png;*.gif;*.bmp;*.img)|*.jpg;*.png;*.gif;*.bmp;*.img\ if (ofd.ShowDialog() == DialogResult.OK) {
string fileName = ofd.FileName; Image img = new Bitmap(fileName); pictureBox2.Image = img; } }
catch { MessageBox.Show(\请正确操作\ }
private void contextMenuStrip1_Opening(object sender, CancelEventArgs e) {
//当选中的时候变亮，否则变灰
if (listView1.SelectedItems.Count > 0) {
编辑ToolStripMenuItem.Enabled = true; 删除ToolStripMenuItem.Enabled = true; } else {
编辑ToolStripMenuItem.Enabled = false;
30
武汉生物工程学院学士学位论文
删除ToolStripMenuItem.Enabled = false; } }
7.1.4 销售管理
private void treeView1_AfterSelect(object sender, TreeViewEventArgs e) {
//选择节点之后的事件
TreeNode tn = treeView1.SelectedNode; if (tn.Text == \订单信息\ {
label17.Enabled = true; textBox9.Enabled = true;
string cmdText = \ dataGridView1.Visible = true; dataGridView2.Visible = false; groupBox1.Visible = true; panel1.Visible = false; //MessageBox.Show(tn.Text);
DataTable dt = SqlHelper.GetTable(cmdText, false); dataGridView1.DataSource = dt; }
if (tn.Text == \销售业绩\ {
string cmdText = \ dataGridView2.Visible = true; dataGridView1.Visible = false; groupBox1.Visible = false; panel1.Visible = true;
DataTable dt = SqlHelper.GetTable(cmdText, false); dataGridView2.DataSource = dt; } }
销售管理的订单信息 //新增订单
private void button1_Click(object sender, EventArgs e) {
try {
string sql = \into sale values(@a,@b,@c,@d,@e,@f,@h,@j,@l,@m,@n)\
SqlParameter[] pms = new SqlParameter[11];
pms[0] = new SqlParameter(\指定参数
31
武汉生物工程学院学士学位论文
类型及长度
pms[1] = new SqlParameter(\
pms[2] = new SqlParameter(\ pms[3] = new SqlParameter(\ pms[4] = new SqlParameter(\ pms[5] = new SqlParameter(\ pms[6] = new SqlParameter(\ pms[7] = new SqlParameter(\ pms[8] = new SqlParameter(\ pms[9] = new SqlParameter(\ pms[10] = new SqlParameter(\ int i = SqlHelper.ExecuteSQL(sql, false, pms); if (i > 0) {
MessageBox.Show(\新增成功！\ } else {
MessageBox.Show(\新增失败\ } } catch {
MessageBox.Show(\请正确操作\ } }
//删除订单
private void button2_Click(object sender, EventArgs e) {
try {
//找到选中行的数据的销售编号，通过编号把表中的数据删除 if (dataGridView1.SelectedRows.Count == 0) {
MessageBox.Show(\亲，没有要删除的数据！！\ return; }
DialogResult dr = MessageBox.Show(\亲，真心要删除么？\友情提示\
if (dr == DialogResult.Yes) {
string sNo = dataGridView1.SelectedRows[0].Cells[0].Value.ToString();
string sql = \
32
武汉生物工程学院学士学位论文
SqlParameter pms = new SqlParameter(\ int i = SqlHelper.ExecuteSQL(sql, false, pms); if (i > 0) {
MessageBox.Show(\删除成功！\ } else {
MessageBox.Show(\删除失败！\ } } }
catch { MessageBox.Show(\请正确操作\ }
销售管理的销售业绩
private void button3_Click_1(object sender, EventArgs e) {
try {
label17.Enabled = false; textBox9.Enabled = false;
string sql = \ SqlParameter[] pms = new SqlParameter[2];
pms[0] = new SqlParameter(\ pms[1] = new SqlParameter(\ int i = SqlHelper.ExecuteSQL(sql, false, pms); if (i > 0) {
MessageBox.Show(\新增员工成功！\ } else {
MessageBox.Show(\新增员工失败\ } }
catch { MessageBox.Show(\请正确操作\ }
private void button4_Click(object sender, EventArgs e) {
try {
label17.Enabled = true; textBox9.Enabled =true;
33
武汉生物工程学院学士学位论文
if (dataGridView2.SelectedRows.Count == 0) {
MessageBox.Show(\亲，没有要删除的数据！！\ return; }
DialogResult dr = MessageBox.Show(\亲，真心要删除么？\友情提示\
if (dr == DialogResult.Yes) {
string sNo = dataGridView2.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(\请正确操作\ }
private void button5_Click(object sender, EventArgs e) {
try {
label17.Enabled = true; textBox9.Enabled = true;
string sql = \sWork set saleMan=@a ,price=@b where sNo=@c\ SqlParameter[] pms = new SqlParameter[3];
pms[0] = new SqlParameter(\ pms[1] = new SqlParameter(\ pms[2] = new SqlParameter(\ int i = SqlHelper.ExecuteSQL(sql, false, pms); if (i > 0) {
MessageBox.Show(\修改信息成功！\ } else {
34