private void FrmSetInfoEdit_Load(object sender, EventArgs e) { if (_id != 0) { SetOrd model = _dal.GetModel(_id); txtSetText.Text = model.SetOrdText; txtSetValue.Text = model.SetOrdKey; txtSetValue.ReadOnly = true; } }
private void btnDeleteOrd_Click(object sender, EventArgs e) { if (dataGridView1.SelectedRows.Count == 0) { MessageBox.Show(@"请选择要删除的记录"); return; } if (dataGridView1.CurrentRow != null) { int id = Convert.ToInt32(dataGridView1.CurrentRow.Cells[0].Value.ToString().Trim()); SetOrd model = _ordDal.GetModel(id); model.State = 0; bool flag = _ordDal.Update(model); if (flag) { MessageBox.Show(@"删除成功"); frmSetInfo_Load(null, null); dataGridView1_CellClick(null, null); } } }
private void btnSave_Click(object sender, EventArgs e) { if (txtSetValue.Text.Trim() == string.Empty) { MessageBox.Show(@"请输入代码"); txtSetValue.Select(); return; } if (txtSetText.Text.Trim() == string.Empty) { MessageBox.Show(@"请输入名称"); txtSetText.Select(); return; } if (_id != 0)//修改 { //已经存在 DataSet ds = _dal.GetList("State=1 and id!=" + _id + " and SetOrdKey='" + txtSetValue.Text.Trim() + "' "); if (ds != null && ds.Tables[0].Rows.Count > 0) { MessageBox.Show(@"该代码已经存在"); txtSetValue.Select(); } else { SetOrd model = _dal.GetModel(_id); model.SetOrdKey = txtSetValue.Text.Trim(); model.SetOrdText = txtSetText.Text.Trim(); bool flag = _dal.Update(model); if (flag) { DialogResult = DialogResult.OK; Close(); } } } else { //已经存在 DataSet ds = _dal.GetList("State=1 and SetOrdKey='" + txtSetValue.Text.Trim() + "' "); if (ds != null && ds.Tables[0].Rows.Count > 0) { MessageBox.Show(@"该代码已经存在"); txtSetValue.Select(); } else { SetOrd model = new SetOrd { SetOrdText = txtSetText.Text.Trim(), SetOrdKey = txtSetValue.Text.Trim(), State = 1 }; int res = _dal.Add(model); if (res >= 0) { DialogResult = DialogResult.OK; Close(); } } } }