private void tBtnDelProj_Click(object sender, EventArgs e) { if (listVProjects.SelectedItems.Count > 0) { if (MessageBox.Show("是否要删除该项目?", "项目删除提示", MessageBoxButtons.YesNo) == DialogResult.Yes) { var a = listVProjects.SelectedItems[0]; DbService db = null; db = DB.GetMainDb(); Hashtable htPara = new Hashtable(); htPara.Add("proj_code", a.SubItems[0].Text); int count = (int)db.ExecuteScalarID("CountIntfNumbers", htPara); if (count > 0) { MessageBox.Show("项目下还存在接口的定义,请先删除项目下的接口"); return; } HA_ProjectDAL dal = new HA_ProjectDAL(); if (dal.Delete(a.SubItems[0].Text)) { ReloadProjects(); } } } }
private void button1_Click(object sender, EventArgs e) { try { if (string.IsNullOrEmpty(txtProjCode.Text)) { MessageBox.Show("请输入代码"); return; } //db = DB.GetMainDb(); //Hashtable htPara = new Hashtable(); //htPara.Add("proj_name", txtProjName.Text); //htPara.Add("proj_code", txtProjCode.Text); //htPara.Add("proj_note", txtProjNote.Text); HA_ProjectDAL dal = new HA_ProjectDAL(); if (projobj == null) { int ret = dal.AddNew(new HA_Project { proj_code = txtProjCode.Text, proj_name = txtProjName.Text, proj_note = txtProjNote.Text, proj_port = Convert.ToInt32(txtPort.Text) }); //int ret = db.ExecuteNonQueryID("InsertProject", htPara); } else { //UpdateProject bool ret = dal.Update(new HA_Project { proj_code = txtProjCode.Text, proj_name = txtProjName.Text, proj_note = txtProjNote.Text, proj_port = Convert.ToInt32(txtPort.Text) }); //int ret = db.ExecuteNonQueryID("UpdateProject", htPara); if (ret == false) { MessageBox.Show("修改失败 : " + ret); } } Close(); } catch (Exception ex) { MessageBox.Show("保存失败 : " + ex.Message); } }