//删除职位
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();
}
