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("记录有关联，删除失败");
}
}
