//删除职位 private void delOfficer_Click(object sender, EventArgs e) { if (jobTree.SelectedNode == null || db.Job.FirstOrDefault(x => x.name == jobTree.SelectedNode.Text) == null) { GeneralClass.printErrorMsg("没有选择节点!"); return; } string jobSelName = jobTree.SelectedNode.Text; int jobSelId = db.Job.FirstOrDefault(x => x.name == jobSelName).id; if (GeneralClass.printAskMsg("确认删除职位: " + jobSelName + " ?") != DialogResult.Yes) { return; } if (db.Employee.FirstOrDefault(x => x.jobId == jobSelId) != null) { GeneralClass.printErrorMsg("所选择的职位包含员工,不能删除!"); return; } db.Job.DeleteOnSubmit(db.Job.FirstOrDefault(x => x.name == jobSelName)); db.Authority.DeleteOnSubmit(db.Authority.FirstOrDefault(x => x.jobId == jobSelId)); db.SubmitChanges(); createTree(); }
//删除员工 private void delTool_Click(object sender, EventArgs e) { if (dgv.CurrentCell == null) { GeneralClass.printErrorMsg("没有选择行!"); return; } if (GeneralClass.printAskMsg("确认删除?") != DialogResult.Yes) { return; } string delId = dgv.CurrentRow.Cells[0].Value.ToString(); db.Employee.DeleteOnSubmit(db.Employee.FirstOrDefault(s => s.id == delId)); var authEmployee = db.Authority.FirstOrDefault(x => x.emplyeeId == delId); if (authEmployee != null) { db.Authority.DeleteOnSubmit(authEmployee); } db.SubmitChanges(); dgv_show(); }
//删除手牌类型 private void delSeatType_Click(object sender, EventArgs e) { if (seatTypeTree.SelectedNode == null || db.SeatType.FirstOrDefault(x => x.name == seatTypeTree.SelectedNode.Text) == null) { GeneralClass.printErrorMsg("没有选择节点!"); return; } string typeSelName = seatTypeTree.SelectedNode.Text; int typeSelId = db.SeatType.FirstOrDefault(x => x.name == typeSelName).id; if (GeneralClass.printAskMsg("确认删除类型: " + typeSelName + " ?") != DialogResult.Yes) { return; } if (db.Seat.FirstOrDefault(x => x.typeId == typeSelId) != null) { GeneralClass.printErrorMsg("所选择的手牌类型包含手牌,不能删除!"); return; } db.SeatType.DeleteOnSubmit(db.SeatType.FirstOrDefault(x => x.name == typeSelName)); db.SubmitChanges(); createTree(); }
//删除部门 private void delOfficer_Click(object sender, EventArgs e) { if (jobTree.SelectedNode == null) { GeneralClass.printErrorMsg("没有选择节点!"); return; } string jobSelName = jobTree.SelectedNode.Text; var depart = db.Department.FirstOrDefault(x => x.name == jobSelName); if (depart == null) { BathClass.printErrorMsg("所选节点异常,请确认!"); return; } int jobSelId = depart.id; if (GeneralClass.printAskMsg("确认删除部门: " + jobSelName + " ?") != DialogResult.Yes) { return; } if (db.Job.FirstOrDefault(x => x.departId == jobSelId) != null) { GeneralClass.printErrorMsg("所选择的部门包含职位,不能删除!"); return; } db.Department.DeleteOnSubmit(depart); db.SubmitChanges(); createTree(); }
//删除类型 private void delType_Click(object sender, EventArgs e) { //if (m_thread != null && m_thread.IsAlive) // m_thread.Abort(); if (typeTree.SelectedNode == null || db.MemberType.FirstOrDefault(x => x.name == typeTree.SelectedNode.Text) == null) { GeneralClass.printErrorMsg("没有选择节点!"); return; } string typeSelName = typeTree.SelectedNode.Text; int typeSelId = db.MemberType.FirstOrDefault(x => x.name == typeSelName).id; if (GeneralClass.printAskMsg("确认删除类型: " + typeSelName + " ?") != DialogResult.Yes) { return; } if (db.CardInfo.FirstOrDefault(x => x.CI_CardTypeNo == typeSelId) != null) { GeneralClass.printErrorMsg("所选择的类型包含会员卡,不能删除!"); return; } db.MemberType.DeleteOnSubmit(db.MemberType.FirstOrDefault(x => x.name == typeSelName)); db.SubmitChanges(); createTree(); }
//删除支出 private void delTool_Click(object sender, EventArgs e) { if (dgv.CurrentCell == null) { GeneralClass.printErrorMsg("没有选择行!"); return; } if (GeneralClass.printAskMsg("确认删除?") != DialogResult.Yes) { return; } int delId = Convert.ToInt32(dgv.CurrentRow.Cells[0].Value); var expense = db.Expense.FirstOrDefault(s => s.id == delId); if (del_time_limit != null) { if ((BathClass.Now(LogIn.connectionString) - expense.inputDate) >= TimeSpan.Parse("00:" + del_time_limit.ToString() + ":00")) { GeneralClass.printErrorMsg("超过支出删除时限,不能删除!"); return; } } db.Expense.DeleteOnSubmit(expense); db.SubmitChanges(); dgv_show(); }
//删除类别 private void delType_Click(object sender, EventArgs e) { if (typeTree.SelectedNode == null || db.Job.FirstOrDefault(x => x.name == typeTree.SelectedNode.Text) == null) { GeneralClass.printErrorMsg("没有选择节点!"); return; } string jobSelName = typeTree.SelectedNode.Text; int jobSelId = db.ExpenseType.FirstOrDefault(x => x.name == jobSelName).id; if (GeneralClass.printAskMsg("确认删除类别: " + jobSelName + " ?") != DialogResult.Yes) { return; } if (db.Expense.FirstOrDefault(x => x.typeId == jobSelId) != null) { GeneralClass.printErrorMsg("所选择的类别包含支出,不能删除!"); return; } db.ExpenseType.DeleteOnSubmit(db.ExpenseType.FirstOrDefault(x => x.name == jobSelName)); db.SubmitChanges(); createTree(); }
//删除类别 private void delCat_Click(object sender, EventArgs e) { if (catTree.SelectedNode == null || db.Catgory.FirstOrDefault(x => x.name == catTree.SelectedNode.Text) == null) { GeneralClass.printWarningMsg("没有选择节点!"); return; } string catSel = catTree.SelectedNode.Text; int catSelId = db.Catgory.FirstOrDefault(x => x.name == catSel).id; if (GeneralClass.printAskMsg("确认删除类别: " + catSel + " ?") != DialogResult.Yes) { return; } if (db.Menu.FirstOrDefault(x => x.catgoryId == catSelId) != null) { GeneralClass.printErrorMsg("所选择的职位包含菜式,不能删除!"); return; } db.Catgory.DeleteOnSubmit(db.Catgory.FirstOrDefault(x => x.name == catSel)); db.SubmitChanges(); createTree(); }
//删除手牌 private void delTool_Click(object sender, EventArgs e) { if (dgv.CurrentCell == null) { GeneralClass.printErrorMsg("没有选择行!"); return; } if (GeneralClass.printAskMsg("确认删除?") != DialogResult.Yes) { return; } db.Seat.DeleteOnSubmit(db.Seat.FirstOrDefault(s => s.text == dgv.CurrentRow.Cells[0].Value.ToString())); db.SubmitChanges(); dgv_show(); }
//删除 private void delTool_Click(object sender, EventArgs e) { if (dgv.CurrentCell == null) { GeneralClass.printErrorMsg("没有选择行!"); return; } if (GeneralClass.printAskMsg("确认删除?") != DialogResult.Yes) { return; } int selId = Convert.ToInt32(dgv.CurrentRow.Cells[0].Value); db.Room.DeleteOnSubmit(db.Room.FirstOrDefault(s => s.id == selId)); db.SubmitChanges(); dgv_show(); }
//修改密码 private void modifyPwdTool_Click(object sender, EventArgs e) { if (dgv.CurrentCell == null) { GeneralClass.printWarningMsg("没有选择行!"); return; } if (GeneralClass.printAskMsg("恢复初始密码?") != DialogResult.Yes) { return; } string selId = dgv.CurrentRow.Cells[0].Value.ToString(); var employee = db.Employee.FirstOrDefault(x => x.id == selId); employee.password = IOUtil.GetMD5("12345678"); db.SubmitChanges(); }
//删除套餐 private void delTool_Click(object sender, EventArgs e) { if (dgvCombo.CurrentCell == null) { GeneralClass.printErrorMsg("没有选择行!"); return; } if (GeneralClass.printAskMsg("确认删除?") != DialogResult.Yes) { return; } int bigcomboID = Convert.ToInt32(dgvCombo.CurrentRow.Cells[0].Value.ToString()); db.BigCombo.DeleteOnSubmit(db.BigCombo.FirstOrDefault(x => x.id == bigcomboID)); db.SubmitChanges(); dgvCombo_show(); }
//删除菜式 private void delTool_Click(object sender, EventArgs e) { if (dgv.CurrentCell == null) { GeneralClass.printWarningMsg("没有选择行!"); return; } if (GeneralClass.printAskMsg("确认删除?") != DialogResult.Yes) { return; } int delId = Convert.ToInt32(dgv.CurrentRow.Cells[0].Value); bool be_contained_in_combo = false; List <int> combo_ids = new List <int>(); foreach (var combo in db.Combo) { var ids = BathClass.disAssemble(combo.menuIds); var freeIds = BathClass.disAssemble(combo.freeMenuIds); if (ids.Contains(delId) || freeIds.Contains(delId)) { be_contained_in_combo = true; combo_ids.Add(combo.id); } } if (be_contained_in_combo && BathClass.printAskMsg("套餐" + combo_ids[0] + "等中已经包含该项目,若删除项目,则套餐也会被删除,是否删除?") != DialogResult.Yes) { return; } bool be_contained_in_bigcombo = false; List <int> bigcombo_ids = new List <int>(); foreach (var combo in db.BigCombo) { var ids = BathClass.disAssemble(combo.substmenuid, Constants.SplitChar); if (ids.Contains(delId) || combo.menuid == delId) { be_contained_in_bigcombo = true; bigcombo_ids.Add(combo.id); } } if (be_contained_in_bigcombo && BathClass.printAskMsg("大项套餐" + bigcombo_ids[0] + "等中已经包含该项目,若删除项目,则套餐也会被删除,是否删除?") != DialogResult.Yes) { return; } db.Menu.DeleteOnSubmit(db.Menu.FirstOrDefault(s => s.id == delId)); if (be_contained_in_combo) { db.Combo.DeleteAllOnSubmit(db.Combo.Where(x => combo_ids.Contains(x.id))); } if (be_contained_in_bigcombo) { db.BigCombo.DeleteAllOnSubmit(db.BigCombo.Where(x => bigcombo_ids.Contains(x.id))); } db.SubmitChanges(); dgv_show(); }