private void 除车型ToolStripMenuItem_Click(object sender, EventArgs e) { try { if (this.gridView1.RowCount > 0) { if (this.gridView1.GetSelectedRows()[0] < 0) { MessageBox.Show("没有选中信息,请选择!", "提示", MessageBoxButtons.OK); return; } if (MessageBox.Show("确认删除车型信息", "确认信息", MessageBoxButtons.OKCancel, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2) == DialogResult.OK) { LatheDao dao = new LatheDao(); string LATHE_ID = this.gridView1.GetRowCellValue(this.gridView1.FocusedRowHandle, this.gridView1.Columns[0]).ToString(); if (dao.delete(LATHE_ID)) { FreshForm(); } } } } catch { MessageBox.Show("删除失败,这个车型在被使用!\n"); return; } }
//添加车型 private void simpleButton1_Click(object sender, EventArgs e) { LatheDao dao = new LatheDao(); string name = textEdit1.Text.Trim(); //控制参数格式 if (name == "") { MessageBox.Show("信息不能为空!"); return; } string sql1 = "select * from LATHE_INFO where LATHE_NAME = '" + name + "'"; if (common.SqlHelper.ExcuteSql(sql1) > 0) { MessageBox.Show("该车型已经被使用,请核查!", "信息提示", MessageBoxButtons.OK); return; } dao.Save(this.textEdit1.Text.Trim()); FreshForm(); }
//保存车型信息 private void simpleButton1_Click(object sender, EventArgs e) { LatheDao dao = new LatheDao(); string name = LATHE_NAME.Text.Trim(); //控制参数格式 if (name == "") { MessageBox.Show("信息不能为空!"); return; } switch (strOperationFlag) { case "add": string sql1 = "select * from LATHE_INFO where LATHE_NAME = '" + name + "'"; if (common.SqlHelper.ExcuteSql(sql1) > 0) { MessageBox.Show("该车型已经被使用,请核查!", "信息提示", MessageBoxButtons.OK); return; } dao.Save(this.LATHE_NAME.Text.Trim()); this.DialogResult = DialogResult.OK; this.Close(); break; case "modify": string sql2 = "select count(*) from LATHE_INFO where LATHE_NAME = '" + name + "' and LATHE_ID <> '" + LATHE_ID + "'"; if (common.SqlHelper.ExcuteSql(sql2) > 0) { MessageBox.Show("该车型已经被使用,请核查!", "信息提示", MessageBoxButtons.OK); this.LATHE_NAME.Focus(); return; } dao.Modify(LATHE_ID, this.LATHE_NAME.Text.Trim()); this.DialogResult = DialogResult.OK; this.Close(); break; } }