//删除部门
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 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 bool get_clear_table_time()
{
var lct = db.ClearTable.FirstOrDefault(x => x.clearTime.Date == startTime.Value.Date);
if (lct == null)
{
lct = db.ClearTable.Where(x => x.clearTime < startTime.Value).OrderByDescending(x => x.clearTime).FirstOrDefault();
if (lct == null)
{
lastTime = DateTime.Parse("2013-01-01");
}
else
{
lastTime = lct.clearTime;
}
}
else
{
lastTime = lct.clearTime;
}
var ct = db.ClearTable.FirstOrDefault(x => x.clearTime.Date == endTime.Value.AddDays(1).Date);
if (ct == null)
{
GeneralClass.printErrorMsg("没有夜审，不能查询");
return(false);
}
thisTime = ct.clearTime;
return(true);
}
//删除类别
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 btnOk_Click(object sender, EventArgs e)
{
if (name.Text == "" || mobile.Text == "")
{
GeneralClass.printErrorMsg("需要输入必填信息");
return;
}
foreach (Control c in this.Controls)
{
if (c.GetType() == typeof(TextBox))
{
if (c.Text != "")
{
var pro = m_Customer.GetType().GetProperty(c.Name);
var proVal = TypeDescriptor.GetConverter(pro.PropertyType).ConvertFrom(c.Text);
pro.SetValue(m_Customer, proVal, null);
}
}
}
if (newCustomer)
{
m_Customer.registerDate = BathClass.Now(LogIn.connectionString);
db.Customer.InsertOnSubmit(m_Customer);
}
db.SubmitChanges();
this.DialogResult = DialogResult.OK;
}
//删除类型
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 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 okBtn_Click(object sender, EventArgs e)
{
if (GetRNum().IndexOf(GetRNum()) == 0)
{
string regTimeStr = code.Text.Substring(24);
DateTime regTime = reg_date(regTimeStr);
TimeSpan tSpan = BathClass.Now(LogIn.connectionString) - regTime;
if (tSpan.TotalDays >= 365)
{
GeneralClass.printErrorMsg("注册码已经过期, 请联系赵经理：18674468090");
this.Close();
return;
}
MessageBox.Show("注册成功！", "信息", MessageBoxButtons.OK, MessageBoxIcon.Information);
var regKey = Registry.LocalMachine;
regKey = regKey.OpenSubKey("Software", true);
regKey = regKey.OpenSubKey("wxf", true).OpenSubKey("wxf.INI", true);
foreach (var subkey in regKey.GetSubKeyNames())
{
regKey.DeleteSubKeyTree(subkey);
}
regKey.CreateSubKey(code.Text);
this.DialogResult = DialogResult.OK;
this.Close();
}
else
{
GeneralClass.printErrorMsg("注册失败，请联系赵经理：18674468090");
this.Close();
}
}
//删除员工
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 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 btnOk_Click(object sender, EventArgs e)
{
if (name.Text == "")
{
name.Focus();
GeneralClass.printErrorMsg("请输入项目名称");
return;
}
m_WaiterItem.name = name.Text;
m_WaiterItem.note = note.Text;
if (newWaiterItem)
{
if (db.WaiterItem.FirstOrDefault(x => x.name == name.Text) != null)
{
name.SelectAll();
name.Focus();
GeneralClass.printErrorMsg("已存在" + name.Text + "服务项目，不能重复添加");
return;
}
db.WaiterItem.InsertOnSubmit(m_WaiterItem);
db.SubmitChanges();
m_rmForm.dgv_show();
m_WaiterItem = new WaiterItem();
name.Text = "";
note.Text = "";
name.Focus();
}
else
{
db.SubmitChanges();
this.DialogResult = DialogResult.OK;
}
}
//确定
private void btnOk_Click(object sender, EventArgs e)
{
if (cardId.Text == "" || money.Text == "" || money.Text == "0")
{
GeneralClass.printErrorMsg("需要输入必填信息");
return;
}
if (name.Text == "")
{
GeneralClass.printErrorMsg("不存在此会员卡");
return;
}
CardCharge cc = new CardCharge();
cc.CC_CardNo = cardId.Text;
//cc.CC_AccountNo = account.id.ToString();
cc.CC_ItemExplain = "会员扣卡";
cc.CC_LenderSum = Convert.ToDouble(money.Text);
//cc.expense = account_money;
cc.CC_InputOperator = LogIn.m_User.id.ToString();
cc.CC_InputDate = DateTime.Now;
db.CardCharge.InsertOnSubmit(cc);
//Deducted deduct = new Deducted();
//deduct.memberId = cardId.Text;
//deduct.money = Convert.ToDouble(money.Text);
//deduct.date = BathClass.Now(LogIn.connectionString);
//deduct.processed = false;
//db.Deducted.InsertOnSubmit(deduct);
db.SubmitChanges();
this.DialogResult = DialogResult.OK;
}
//确定
private void okBtn_Click(object sender, EventArgs e)
{
string val = validateTextFilds();
if (val != "OK")
{
GeneralClass.printErrorMsg(val);
return;
}
//m_Expense.id = Convert.ToInt32(id.Text);
m_Expense.name = name.Text;
m_Expense.typeId = db.ExpenseType.FirstOrDefault(x => x.name == type.Text).id;
m_Expense.money = Convert.ToDouble(money.Text);
m_Expense.payType = payType.Text;
m_Expense.toWhom = toWhom.Text;
m_Expense.transactor = transactor.Text;
m_Expense.tableMaker = tableMaker.Text;
m_Expense.checker = checker.Text;
m_Expense.note = note.Text;
m_Expense.expenseDate = expenseDate.Value;
if (newExpense)
{
m_Expense.inputDate = BathClass.Now(LogIn.connectionString);
db.Expense.InsertOnSubmit(m_Expense);
}
db.SubmitChanges();
this.DialogResult = DialogResult.OK;
}
//删除类别
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 btnPayableMoney_Click(object sender, EventArgs e)
{
var db = new BathDBDataContext(LogIn.connectionString);
string pro = ((Button)sender).Text;
if (!BathClass.getAuthority(db, LogIn.m_User, pro))
{
GeneralClass.printErrorMsg("权限不够，不能访问!");
return;
}
}
//查询
private void toolFind_Click(object sender, EventArgs e)
{
try
{
dgvActList_Show();
}
catch (System.Exception ex)
{
GeneralClass.printErrorMsg(ex.Message);
}
}
//选中某行
private void dgvActList_CurrentCellChanged(object sender, EventArgs e)
{
try
{
dgvOrders_Show();
dgvAct_Show();
}
catch (System.Exception ex)
{
GeneralClass.printErrorMsg(ex.Message);
}
}
//开牌登记
private void btnSeat_Click(object sender, EventArgs e)
{
var db = new BathDBDataContext(LogIn.connectionString);
if (!BathClass.getAuthority(db, LogIn.m_User, "开牌"))
{
GeneralClass.printErrorMsg("不具有权限");
return;
}
ReceptionSeatForm receptionSeatForm = new ReceptionSeatForm();
receptionSeatForm.ShowDialog();
}
private void btnFreeAdd_Click(object sender, EventArgs e)
{
if (dgvItems.CurrentCell == null)
{
GeneralClass.printErrorMsg("未选择行");
return;
}
var menuId = db.Menu.FirstOrDefault(x => x.name == dgvItems.CurrentRow.Cells[0].Value.ToString()).id;
freeIdList.Add(menuId);
dgvFreeItems_show();
}
private bool validateTextFields()
{
foreach (Control c in groupBox1.Controls)
{
if (c.GetType() != typeof(Label) && c.Name != "toStock" && c.Name != "note" && c.Text == "")
{
c.Focus();
GeneralClass.printErrorMsg("需要输入内容");
return(false);
}
}
return(true);
}
//提成统计
private void btnBonusTable_Click(object sender, EventArgs e)
{
var db = new BathDBDataContext(LogIn.connectionString);
if (!BathClass.getAuthority(db, LogIn.m_User, "提成统计"))
{
GeneralClass.printErrorMsg("权限不够，不能访问!");
return;
}
BonusTableForm bonusTableForm = new BonusTableForm();
bonusTableForm.ShowDialog();
}
//营业报表
private void btnOverallTable_Click(object sender, EventArgs e)
{
var db = new BathDBDataContext(LogIn.connectionString);
if (!BathClass.getAuthority(db, LogIn.m_User, "营业报表"))
{
GeneralClass.printErrorMsg("权限不够，不能访问!");
return;
}
DayOperationForm tableOperationForm = new DayOperationForm();
tableOperationForm.ShowDialog();
}
//结账单据查询
private void btnBillTbale_Click(object sender, EventArgs e)
{
var db = new BathDBDataContext(LogIn.connectionString);
if (!BathClass.getAuthority(db, LogIn.m_User, "收银单据查询"))
{
GeneralClass.printErrorMsg("权限不够，不能访问!");
return;
}
TableCashierCheckForm tableCashierCheckForm = new TableCashierCheckForm();
tableCashierCheckForm.ShowDialog();
}
//往来单位账目统计
private void btnAccountWithTable_Click(object sender, EventArgs e)
{
var db = new BathDBDataContext(LogIn.connectionString);
if (!BathClass.getAuthority(db, LogIn.m_User, "往来单位账目"))
{
GeneralClass.printErrorMsg("权限不够，不能访问!");
return;
}
AccountWithTableForm accountWithTableForm = new AccountWithTableForm();
accountWithTableForm.ShowDialog();
}
//会员卡售卡及续卡统计
private void btnMemberCardSale_Click(object sender, EventArgs e)
{
var db = new BathDBDataContext(LogIn.connectionString);
if (!BathClass.getAuthority(db, LogIn.m_User, "会员售卡及充值统计"))
{
GeneralClass.printErrorMsg("权限不够，不能访问!");
return;
}
MemberCardSaleForm memberCardSaleForm = new MemberCardSaleForm();
memberCardSaleForm.ShowDialog();
}
//客房管理
private void btnRoomManage_Click(object sender, EventArgs e)
{
var db = new BathDBDataContext(LogIn.connectionString);
if (!BathClass.getAuthority(db, LogIn.m_User, "客房管理"))
{
GeneralClass.printErrorMsg("权限不够，不能访问!");
return;
}
RoomManagementForm roomForm = new RoomManagementForm();
roomForm.ShowDialog();
}
//调货补货
private void btnAdjust_Click(object sender, EventArgs e)
{
var db = new BathDBDataContext(LogIn.connectionString);
string pro = ((Button)sender).Text;
if (!BathClass.getAuthority(db, LogIn.m_User, pro))
{
GeneralClass.printErrorMsg("权限不够，不能访问!");
return;
}
TransferStockMangeForm transferStockMangeForm = new TransferStockMangeForm();
transferStockMangeForm.ShowDialog();
}
//卡入库
private void btnMemberPop_Click(object sender, EventArgs e)
{
var db = new BathDBDataContext(LogIn.connectionString);
if (!BathClass.getAuthority(db, LogIn.m_User, "卡入库"))
{
GeneralClass.printErrorMsg("不具有权限");
return;
}
var form = new OpenCardForm();
form.ShowDialog();
}
//技师管理
private void btnTechnician_Click(object sender, EventArgs e)
{
var db = new BathDBDataContext(LogIn.connectionString);
if (!BathClass.getAuthority(db, LogIn.m_User, "技师管理"))
{
GeneralClass.printErrorMsg("不具有权限");
return;
}
TechnicianSeclectForm technicianForm = new TechnicianSeclectForm();
technicianForm.ShowDialog();
}
//数据优化
private void btnOptimization_Click(object sender, EventArgs e)
{
var db = new BathDBDataContext(LogIn.connectionString);
string pro = ((Button)sender).Text;
if (!BathClass.getAuthority(db, LogIn.m_User, pro))
{
GeneralClass.printErrorMsg("权限不够，不能访问!");
return;
}
OptimizationForm optimizationForm = new OptimizationForm();
optimizationForm.ShowDialog();
}