//删除类别 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 editCat_Click(object sender, EventArgs e) { if (catTree.SelectedNode == null || db.Catgory.FirstOrDefault(x => x.name == catTree.SelectedNode.Text) == null) { GeneralClass.printWarningMsg("没有选择类别!"); return; } Catgory cat = db.Catgory.FirstOrDefault(x => x.name == catTree.SelectedNode.Text); MenuCatgoryForm editCat = new MenuCatgoryForm(db, cat); if (editCat.ShowDialog() == DialogResult.OK) { createTree(); } }
//修改 private void toolEdit_Click(object sender, EventArgs e) { if (dgv.CurrentCell == null) { GeneralClass.printWarningMsg("没有选择行!"); return; } int selId = Convert.ToInt32(dgv.CurrentRow.Cells[0].Value); var promotion = db.Promotion.FirstOrDefault(x => x.id == selId); PromotionForm editPromotion = new PromotionForm(db, promotion); if (editPromotion.ShowDialog() == DialogResult.OK) { dgv_show(); } }
//编辑菜式 private void editGoods_Click(object sender, EventArgs e) { if (dgv.CurrentCell == null) { GeneralClass.printWarningMsg("没有选择行!"); return; } int selId = Convert.ToInt32(dgv.CurrentRow.Cells[0].Value); var menu = db.Menu.FirstOrDefault(x => x.id == selId); MenuForm editMenu = new MenuForm(db, menu, "", this); if (editMenu.ShowDialog() == DialogResult.OK) { dgv_show(); } }
//检车软件是否注册,没有注册的话,检测软件是否使用超过10天的时限 public static bool registered() { bool HasRegistered = false; string regStr = GetRNum(); var regKey = Registry.LocalMachine; regKey = regKey.OpenSubKey("SOFTWARE", true); if (regKey.OpenSubKey("wxf") == null) { regKey.CreateSubKey("wxf").CreateSubKey("wxf.INI"); return(HasRegistered); } regKey = regKey.OpenSubKey("wxf", true); if (regKey.OpenSubKey("wxf.INI") == null) { regKey.CreateSubKey("wxf.INI"); return(HasRegistered); } regKey = regKey.OpenSubKey("wxf.INI"); foreach (string strRNum in regKey.GetSubKeyNames()) { if (strRNum.IndexOf(regStr) == 0) { string regTimeStr = strRNum.Substring(24); DateTime regTime = reg_date(regTimeStr); TimeSpan tSpan = BathClass.Now(LogIn.connectionString) - regTime; if (tSpan.TotalDays >= 365) { GeneralClass.printWarningMsg("软件使用已经过期,请联系YouSoft优软公司重新注册!"); return(false); } if (tSpan.TotalDays >= 335) { GeneralClass.printWarningMsg("软件使用还剩" + (10 - tSpan.Days).ToString() + "天,请联系YouSoft优软公司重新注册!"); return(false); } HasRegistered = true; } } return(HasRegistered); }
//删除 private void toolDel_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); db.Promotion.DeleteOnSubmit(db.Promotion.FirstOrDefault(s => s.id == delId)); 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 editSeatType_Click(object sender, EventArgs e) { var db = new BathDBDataContext(LogIn.connectionString); if (stockTree.SelectedNode == null || db.GoodsCat.FirstOrDefault(x => x.name == stockTree.SelectedNode.Text) == null) { GeneralClass.printWarningMsg("没有选择类别!"); return; } var goodsCat = db.GoodsCat.FirstOrDefault(x => x.name == stockTree.SelectedNode.Text); var form = new GoodsCatForm(db, goodsCat); if (form.ShowDialog() == DialogResult.OK) { goodsCatList = db.GoodsCat.Select(x => x.name).ToList(); createTree(stockTree, goodsCatList); } }
//员工权限 private void authoTool_Click(object sender, EventArgs e) { if (!BathClass.getAuthority(db, LogIn.m_User, "权限管理")) { GeneralClass.printErrorMsg("没有权限!"); return; } if (dgv.CurrentCell == null) { GeneralClass.printWarningMsg("没有选择行!"); return; } string selId = dgv.CurrentRow.Cells[0].Value.ToString(); var employee = db.Employee.FirstOrDefault(x => x.id == selId); EmployeeAuthorityForm eauthoForm = new EmployeeAuthorityForm(db, employee); eauthoForm.ShowDialog(); }
//删除库存商品类别 private void delSeatType_Click(object sender, EventArgs e) { var db = new BathDBDataContext(LogIn.connectionString); if (stockTree.SelectedNode == null || db.GoodsCat.FirstOrDefault(x => x.name == stockTree.SelectedNode.Text) == null) { GeneralClass.printWarningMsg("没有选择类别!"); return; } var goodsCat = db.GoodsCat.FirstOrDefault(x => x.name == stockTree.SelectedNode.Text); if (db.StorageList.Any(x => x.goodsCatId == goodsCat.id)) { BathClass.printErrorMsg("所选类别包含商品,不能删除!"); return; } db.GoodsCat.DeleteOnSubmit(goodsCat); db.SubmitChanges(); goodsCatList = db.GoodsCat.Select(x => x.name).ToList(); createTree(stockTree, goodsCatList); }
//删除菜式 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(); }