//添加车型 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; } }