private void btnDelete_Click(object sender, EventArgs e) { try { int id = int.Parse(clID.Text); if (FormUpload.HasFiles("ctdb-slice", id)) { MessageBox.Show("Files related, can't delete!"); return; } if (CTHelper.AlertYes("Delete " + id.ToString() + "?")) { using (var db = new CTDBEntities()) { var student = db.tbSlice.FirstOrDefault(s => s.slice_id == id); db.tbSlice.Remove(student); //删除萝莉 db.SaveChanges(); refreshdata(null, null); } } } catch { MessageBox.Show("记录有关联,删除失败"); } }
//add demos from slice private void mitCreateExampleFromSlice_Click(object sender, EventArgs e) { if (!CTHelper.AlertYes("Selecte 10 slices as example?")) { return; } CTDBEntities ct = new CTDBEntities(); var q = from c in ct.tbFile where c.f_pid == ParaDatasetID && c.f_table == "ctdb-slice" select c; List <tbFile> lll = q.ToList <tbFile>(); int spid = ct.tbSlice.Where(c => c.slice_id == ParaDatasetID).Single().tbScan.tbSpecimen.sp_id; uploadSpecimenFile(spid, lll, "ctdb-slice", 10); refreshdb(); }
private void btDelete_Click(object sender, EventArgs e) { try { int id = int.Parse(ceID.Text); if (CTHelper.AlertYes("Delete " + id.ToString())) { using (var db = new CTDBEntities()) { var student = db.tbEquipment.FirstOrDefault(s => s.e_id == id); db.tbEquipment.Remove(student); //删除 db.SaveChanges(); refrashDataGridview(null, null); } } } catch { MessageBox.Show("Fail to delete, there is related data in database!"); } }
//=======remote / server========= ///remove from database private void btnDelete_Click(object sender, EventArgs e) { //if (MessageBox.Show("Delete " + lboxDB.SelectedItems.Count.ToString() + " files", "Alert", MessageBoxButtons.YesNo) == DialogResult.Yes) if (CTHelper.AlertYes("Delete " + lboxDB.SelectedItems.Count + " files")) { using (var db = new CTDBEntities()) { note(lboxDB.Items.Count); foreach (tbFile f in lboxDB.SelectedItems) { var student = db.tbFile.FirstOrDefault(s => s.f_id == f.f_id); db.tbFile.Remove(student); //删除 db.SaveChanges(); notep(); } } } refreshdb(); }
private void bsmDelete_Click(object sender, EventArgs e) { try { int id = int.Parse(csmID.Text); //if (MessageBox.Show("确认删除" + id.ToString(), "提示", MessageBoxButtons.YesNo) == DialogResult.Yes) if (CTHelper.AlertYes("Delete " + id.ToString() + "?")) { using (var db = new CTDBEntities()) { var student = db.tbSpecimen.FirstOrDefault(s => s.sp_id == id); db.tbSpecimen.Remove(student); db.SaveChanges(); } refreshdata(0); } } catch { MessageBox.Show("记录有关联,删除失败"); } }