//停止消费
private void btnOnClock_Click(object sender, EventArgs e)
{
InputSeatForm seatForm = new InputSeatForm(2);
if (seatForm.ShowDialog() != DialogResult.OK)
return;
if (m_Seats.FirstOrDefault(x => x.text == seatForm.m_Seat.text) != null)
{
BathClass.printErrorMsg("转账手牌中已经包含该手牌，请重新输入");
return;
}
string systemId = seatForm.m_Seat.systemId;
foreach (Seat s in m_Seats)
{
var orderList = db.Orders.Where(x => x.systemId == s.systemId && x.deleteEmployee == null && !x.paid);
foreach (Orders order in orderList)
{
order.systemId = systemId;
if (order.priceType == "每小时")
{
order.priceType = "停止消费";
order.money = order.money * Math.Ceiling((GeneralClass.Now - order.inputTime).TotalHours);
}
}
s.status = 3;
}
db.SubmitChanges();
this.DialogResult = DialogResult.OK;
}
//减少
private void btnDec_Click(object sender, EventArgs e)
{
if (m_room.seatIds == null)
{
BathClass.printErrorMsg("已经为0!");
return;
}
var ids = m_room.seatIds.Split('|').ToList();
if (ids.Count == 0)
{
BathClass.printErrorMsg("已经为0!");
return;
}
if (ids.Count == 1)
{
m_room.seatIds = null;
dc.SubmitChanges();
this.Close();
return;
}
List <int> s = new List <int>();
s.Add(2);
s.Add(6);
s.Add(7);
InputSeatForm form = new InputSeatForm(s);
if (form.ShowDialog() != DialogResult.OK)
{
return;
}
var t = form.m_Seat.text;
if (!ids.Contains(t))
{
BathClass.printErrorMsg("手牌：" + t + "不在该房间");
return;
}
ids.Remove(t);
if (ids.Count == 0)
{
m_room.seatIds = null;
}
else
{
m_room.seatIds = string.Join("|", ids.ToArray());
}
curPop.Text = m_room.seatIds;
}
//押金离场
private void btnDeposit_Click(object sender, EventArgs e)
{
List<int> s = new List<int>();
s.Add(2);
s.Add(7);
InputSeatForm inputSeatForm = new InputSeatForm(s);
if (inputSeatForm.ShowDialog() != DialogResult.OK)
return;
var seat = inputSeatForm.m_Seat;
if (seat.status == SeatStatus.USING || seat.status == SeatStatus.DEPOSITLEFT)
{
DepositForm depositForm = new DepositForm(inputSeatForm.m_Seat);
depositForm.ShowDialog();
}
}
//减少
private void btnDec_Click(object sender, EventArgs e)
{
if (m_room.seatIds == null)
{
BathClass.printErrorMsg("已经为0!");
return;
}
var ids = m_room.seatIds.Split('|').ToList();
if (ids.Count == 0)
{
BathClass.printErrorMsg("已经为0!");
return;
}
if (ids.Count == 1)
{
m_room.seatIds = null;
dc.SubmitChanges();
this.Close();
return;
}
List<int> s = new List<int>();
s.Add(2);
s.Add(6);
s.Add(7);
InputSeatForm form = new InputSeatForm(s);
if (form.ShowDialog() != DialogResult.OK)
return;
var t = form.m_Seat.text;
if (!ids.Contains(t))
{
BathClass.printErrorMsg("手牌：" + t + "不在该房间");
return;
}
ids.Remove(t);
if (ids.Count == 0)
m_room.seatIds = null;
else
m_room.seatIds = string.Join("|", ids.ToArray());
curPop.Text = m_room.seatIds;
}
//增加
private void btnInc_Click(object sender, EventArgs e)
{
if (m_room.seatIds != null && m_room.seatIds.Split('|').Length == m_room.population)
{
BathClass.printErrorMsg("已经为达到入住上限!");
return;
}
List <int> s = new List <int>();
s.Add(2);
s.Add(7);
InputSeatForm form = new InputSeatForm(s);
if (form.ShowDialog() != DialogResult.OK)
{
return;
}
var t = form.m_Seat.text;
var room = dc.Room.FirstOrDefault(x => x.seatIds != null && x.seatIds.Contains(t));
if (room != null)
{
BathClass.printErrorMsg("该手牌已经入住房间:" + room.name);
return;
}
if (m_room.seatIds == null)
{
m_room.seatIds = t;
}
else
{
var ids = m_room.seatIds.Split('|').ToList();
ids.Add(t);
m_room.seatIds = string.Join("|", ids.ToArray());
}
curPop.Text = m_room.seatIds;
//curPop.Text = (Convert.ToInt32(curPop.Text) + 1).ToString();
}
//消费录入
private void orderTool_Click(object sender, EventArgs e)
{
//BathDBDataContext db_new = new BathDBDataContext(LogIn.connectionString);
if (!dao.get_authority(LogIn.m_User, "完整点单") &&
!dao.get_authority(LogIn.m_User, "可见本人点单"))
{
BathClass.printErrorMsg("权限不够!");
return;
}
List<int> sLst = new List<int>();
sLst.Add(2);
sLst.Add(6);
InputSeatForm inputSeatForm = new InputSeatForm(sLst);
if (inputSeatForm.ShowDialog() != DialogResult.OK)
return;
var seat = dao.get_seat("text", inputSeatForm.m_Seat.text);
//var seat = db_new.Seat.FirstOrDefault(x => x.text == inputSeatForm.m_Seat.text);
//seat.ordering = true;
//db_new.SubmitChanges();
OrderForm orderForm = new OrderForm(seat, LogIn.m_User, LogIn.connectionString, false);
orderForm.ShowDialog();
//seat.ordering = false;
//db_new.SubmitChanges();
}
//更换手牌
private void CtxChangeSeat_Click(object sender, EventArgs e)
{
//BathDBDataContext db_new = new BathDBDataContext(LogIn.connectionString);
var seat = getContextSenderSeat(sender);
InputEmployeeByPwd inputEmployee = new InputEmployeeByPwd();
if (inputEmployee.ShowDialog() != DialogResult.OK)
return;
if (!dao.get_authority(inputEmployee.employee, "更换手牌"))
{
BathClass.printErrorMsg(inputEmployee.employee.id + "不具有更换手牌操作权限!");
return;
}
if (seat.status != SeatStatus.USING)
{
BathClass.printErrorMsg("该手牌目前不在使用中，不能换台!");
return;
}
List<int> sLst = new List<int>();
sLst.Add(1);
sLst.Add(3);
InputSeatForm inputSeatForm = new InputSeatForm(sLst);
if (inputSeatForm.ShowDialog() != DialogResult.OK)
return;
StringBuilder sb = new StringBuilder();
sb.Append(@"update [Orders] set text='" + inputSeatForm.m_Seat.text + "' where systemId='" + seat.systemId + "' ");
//Seat newSeat = db_new.Seat.FirstOrDefault(x => x == inputSeatForm.m_Seat);
//var orders = db_new.Orders.Where(x => x.systemId == seat.systemId);
//foreach (Orders order in orders)
//order.text = newSeat.text;
sb.Append(@"update [Seat] set systemId='" + seat.systemId + "',name='" + seat.name + "',population=" + seat.population);
sb.Append(",openTime=getdate(),openEmployee='" + LogIn.m_User.id + "',chainId='" + seat.chainId + "',status=" + seat.status);
sb.Append(",note='" + seat.note + "',ordering='False'");
//newSeat.systemId = seat.systemId;
//newSeat.name = seat.name;
//newSeat.population = seat.population;
//newSeat.openTime = BathClass.Now(LogIn.connectionString);
//newSeat.openEmployee = LogIn.m_User.name;
//newSeat.phone = seat.phone;
//newSeat.chainId = seat.chainId;
//newSeat.status = seat.status;
//newSeat.note = seat.note;
//newSeat.ordering = seat.ordering;
sb.Append(dao.reset_seat_string() + "text='" + seat.text + "')");
if (!dao.execute_command(sb.ToString()))
{
BathClass.printErrorMsg("更换手牌失败，请重试！");
return;
}
//BathClass.reset_seat(seat);
//db_new.SubmitChanges();
}
//宾客转账
private void transferTool_Click(object sender, EventArgs e)
{
InputSeatForm seatForm = new InputSeatForm(2);
if (seatForm.ShowDialog() != DialogResult.OK)
return;
if (m_Seats.FirstOrDefault(x => x.text == seatForm.m_Seat.text) != null)
{
BathClass.printErrorMsg("转账手牌中已经包含该手牌，请重新输入");
return;
}
var dc = new BathDBDataContext(LogIn.connectionString);
string systemId = seatForm.m_Seat.systemId;
foreach (HotelRoom s in m_Seats)
{
var orderList = dc.Orders.Where(x => x.systemId == s.systemId && x.deleteEmployee == null && !x.paid);
foreach (Orders order in orderList)
{
order.systemId = systemId;
if (order.priceType == "每小时")
{
order.priceType = "停止消费";
order.money = order.money * Math.Ceiling((GeneralClass.Now - order.inputTime).TotalHours);
}
order.stopTiming = true;
}
dc.HotelRoom.FirstOrDefault(x=>x.text==s.text).status = 3;
}
dc.SubmitChanges();
List<string> printCols = new List<string>();
printCols.Add("手牌");
printCols.Add("项目名称");
printCols.Add("技师");
printCols.Add("单价");
printCols.Add("数量");
printCols.Add("金额");
PrintSeatBill.Print_DataGridView(m_Seats, "转账确认单", dgvExpense, printCols, moneyPayable.Text, companyName);
this.DialogResult = DialogResult.OK;
}
//消费查看
private void BtnExpense_Click(object sender, EventArgs e)
{
List<int> sList = new List<int>();
sList.Add(2);
sList.Add(6);
sList.Add(7);
InputSeatForm inputSeatForm = new InputSeatForm(sList);
if (inputSeatForm.ShowDialog() == DialogResult.OK)
{
//修改
//OrderCheckForm seatExpenseForm = new OrderCheckForm(inputSeatForm.m_Seat, connectionString);
//seatExpenseForm.ShowDialog();
}
}
//消费录入
private void orderTool_Click(object sender, EventArgs e)
{
if (!dao.get_authority(LogIn.m_User, "完整点单") &&
!dao.get_authority(LogIn.m_User, "可见本人点单"))
{
BathClass.printErrorMsg("权限不够!");
return;
}
List<int> sLst = new List<int>();
sLst.Add(2);
sLst.Add(6);
InputSeatForm inputSeatForm = new InputSeatForm(sLst);
if (inputSeatForm.ShowDialog() != DialogResult.OK)
return;
OrderForm orderForm = new OrderForm(inputSeatForm.m_Seat, LogIn.m_User, LogIn.connectionString, false);
orderForm.ShowDialog();
}
//增加
private void btnInc_Click(object sender, EventArgs e)
{
if (m_room.seatIds!=null && m_room.seatIds.Split('|').Length == m_room.population)
{
BathClass.printErrorMsg("已经为达到入住上限!");
return;
}
List<int> s = new List<int>();
s.Add(2);
s.Add(7);
InputSeatForm form = new InputSeatForm(s);
if (form.ShowDialog() != DialogResult.OK)
return;
var t = form.m_Seat.text;
var room = dc.Room.FirstOrDefault(x => x.seatIds != null && x.seatIds.Contains(t));
if (room != null)
{
BathClass.printErrorMsg("该手牌已经入住房间:" + room.name);
return;
}
if (m_room.seatIds == null)
m_room.seatIds = t;
else
{
var ids = m_room.seatIds.Split('|').ToList();
ids.Add(t);
m_room.seatIds = string.Join("|", ids.ToArray());
}
curPop.Text = m_room.seatIds;
//curPop.Text = (Convert.ToInt32(curPop.Text) + 1).ToString();
}
//更换手牌
private void CtxChangeSeat_Click(object sender, EventArgs e)
{
var seat = getContextSenderSeat(sender);
Employee oper = null;
InputEmployeeByPwd inputEmployee = new InputEmployeeByPwd();
if (dao.get_authority(LogIn.m_User, "更换手牌"))
{
oper = LogIn.m_User;
}
else if (inputEmployee.ShowDialog() != DialogResult.OK)
{
return;
}
else
{
if (dao.get_authority(inputEmployee.employee, "更换手牌"))
{
oper = inputEmployee.employee;
}
else
{
BathClass.printErrorMsg(inputEmployee.employee.id + "不具有更换手牌操作权限!");
return;
}
}
if (seat.status != SeatStatus.USING)
{
BathClass.printErrorMsg("该手牌目前不在使用中，不能换台!");
return;
}
List<int> sLst = new List<int>();
sLst.Add(1);
sLst.Add(3);
InputSeatForm inputSeatForm = new InputSeatForm(sLst);
if (inputSeatForm.ShowDialog() != DialogResult.OK)
return;
StringBuilder sb = new StringBuilder();
sb.Append(@"update [Orders] set text='" + inputSeatForm.m_Seat.text + "' where systemId='" + seat.systemId + "' ");
sb.Append(@"update [Seat] set systemId='" + seat.systemId + "'");
sb.Append(",openTime=getdate(),openEmployee='" + oper.id + "',chainId='" + seat.chainId);
sb.Append("',status=" + (int)seat.status + ",ordering='False'");
if (seat.name != null && seat.name != "")
sb.Append(",name='" + seat.name + "'");
if (seat.population != null)
sb.Append(",population=" + seat.population);
if (seat.note != null && seat.name != "")
sb.Append(",note='" + seat.note + "'");
sb.Append(" where id=" + inputSeatForm.m_Seat.id);
sb.Append(dao.reset_seat_string() + "text='" + seat.text + "')");
if (!dao.execute_command(sb.ToString()))
{
BathClass.printErrorMsg("更换手牌失败，请重试！");
return;
}
}
private void change_seat(CSeat seat)
{
if (!dao.get_authority(LogIn.m_User, "更换手牌"))
{
BathClass.printErrorMsg(LogIn.m_User.name + "不具有更换手牌操作权限!");
return;
}
if (seat.status != SeatStatus.USING)
{
BathClass.printErrorMsg("该手牌目前不在使用中，不能换台!");
return;
}
List<int> sLst = new List<int>();
sLst.Add(1);
sLst.Add(3);
InputSeatForm inputSeatForm = new InputSeatForm(sLst);
if (inputSeatForm.ShowDialog() != DialogResult.OK)
return;
//Seat newSeat = db_new.Seat.FirstOrDefault(x => x == inputSeatForm.m_Seat);
StringBuilder sb = new StringBuilder();
sb.Append(@"update [Orders] set text='" + inputSeatForm.m_Seat.text + "' where systemId='" + seat.systemId + "' ");
//var orders = db_new.Orders.Where(x => x.systemId == seat.systemId);
//foreach (Orders order in orders)
// order.text = newSeat.text;
sb.Append(@"update [Seat] set systemId='" + seat.systemId + "'");
sb.Append(",openTime=getdate(),openEmployee='" + LogIn.m_User.id + "',chainId='" + seat.chainId
+ "',status=" + (int)seat.status + ",ordering='False'");
if (seat.name != null && seat.name != "")
sb.Append(",name='" + seat.name + "'");
if (seat.population != null)
sb.Append(",population=" + seat.population);
if (seat.note != null && seat.name != "")
sb.Append(",note='" + seat.note + "'");
sb.Append(" where id=" + inputSeatForm.m_Seat.id);
//newSeat.systemId = seat.systemId;
//newSeat.name = seat.name;
//newSeat.population = seat.population;
//newSeat.openTime = BathClass.Now(LogIn.connectionString);
//newSeat.openEmployee = LogIn.m_User.name;
////newSeat.money = seat.money;
//newSeat.phone = seat.phone;
//newSeat.chainId = seat.chainId;
//newSeat.status = seat.status;
//newSeat.note = seat.note;
//newSeat.ordering = seat.ordering;
sb.Append(dao.reset_seat_string() + "text='" + seat.text + "')");
if (!dao.execute_command(sb.ToString()))
{
BathClass.printErrorMsg("更换手牌失败，请重试！");
return;
}
//BathClass.reset_seat(seat);
//db_new.SubmitChanges();
dgv_shoe_show();
}
//更换手牌
private void changeSeatTool_Click(object sender, EventArgs e)
{
//BathDBDataContext db_new = new BathDBDataContext(LogIn.connectionString);
InputSeatForm inputSeatForm = new InputSeatForm(2);
if (inputSeatForm.ShowDialog() != DialogResult.OK)
return;
//var seat = db_new.Seat.FirstOrDefault(x => x.Equals(inputSeatForm.m_Seat));
change_seat(inputSeatForm.m_Seat);
}
//查看手牌所在包厢
private void toolCab_Click(object sender, EventArgs e)
{
InputSeatForm seatForm = new InputSeatForm(2);
if (seatForm.ShowDialog() != DialogResult.OK)
return;
string seatId = seatForm.m_Seat.text;
string room_name = dao.get_seat_room(seatId);
if (room_name == "")
{
BathClass.printInformation("未找到手牌所在包厢");
}
else
{
BathClass.printInformation("手牌所在包为:" + room_name);
}
}
//更换手牌
private void CtxChangeSeat_Click(object sender, EventArgs e)
{
var seat = getContextSenderSeat(sender);
Employee oper = null;
InputEmployeeByPwd inputEmployee = new InputEmployeeByPwd();
if (dao.get_authority(LogIn.m_User, "更换手牌"))
{
oper = LogIn.m_User;
}
else if (inputEmployee.ShowDialog() != DialogResult.OK)
{
return;
}
else
{
if (dao.get_authority(inputEmployee.employee, "更换手牌"))
{
oper = inputEmployee.employee;
}
else
{
BathClass.printErrorMsg(inputEmployee.employee.id + "不具有更换手牌操作权限!");
return;
}
}
if (seat.status != SeatStatus.USING)
{
BathClass.printErrorMsg("该手牌目前不在使用中，不能换台!");
return;
}
List<int> sLst = new List<int>();
sLst.Add(1);
sLst.Add(3);
InputSeatForm inputSeatForm = new InputSeatForm(sLst);
if (inputSeatForm.ShowDialog() != DialogResult.OK)
return;
}
//宾客转账
private void transferTool_Click(object sender, EventArgs e)
{
InputSeatForm seatForm = new InputSeatForm(2);
if (seatForm.ShowDialog() != DialogResult.OK)
return;
if (m_Seats.FirstOrDefault(x => x.text == seatForm.m_Seat.text) != null)
{
BathClass.printErrorMsg("转账手牌中已经包含该手牌，请重新输入");
return;
}
//var dc = new BathDBDataContext(LogIn.connectionString);
string systemId = seatForm.m_Seat.systemId;
string cmd_str = @"update [Orders] set systemId='" + systemId + "' where deleteEmployee is null and paid='False' and (";
string id_str = "";
int count = m_Seats.Count;
for (int i = 0; i < count; i++ )
{
id_str += @"systemId='" + m_Seats[i].systemId + "'";
if (i != count - 1)
id_str += " or ";
else
id_str += ")";
m_rooms.Add(dao.get_seat_room(m_Seats[i].text));
}
cmd_str += id_str;
cmd_str += @"update [Orders] set priceType='停止消费', "
+ @"money=money*ceiling(datediff(minute,inputTime, getdate())/60.0)"
+ @" where deleteEmployee is null and paid='False' and priceType='每小时' and (";
cmd_str += id_str;
cmd_str += @"update [Seat] set status='3' where (";
cmd_str += id_str;
cmd_str += " insert into [Operation](employee, explain,opTime, note1, note2) values('" +
LogIn.m_User.id + "', '转账', getdate(),'" + string.Join("\n", m_Seats.Select(x => x.text).ToArray()) + "','" +
seatForm.m_Seat.text + "')";
if (!dao.execute_command(cmd_str))
{
BathClass.printErrorMsg("转账失败，请重试!");
return;
}
//if (auto_shoe)
//{
// var pars = new List<string>();
// pars.Add("text");
// pars.Add("payEmployee");
// pars.Add("payTime");
// pars.Add("processed");
// var vals = new List<string>();
// vals.Add(string.Join("|", m_Seats.Select(x => x.name).ToArray()));
// vals.Add(LogIn.m_User.id);
// vals.Add(DateTime.Now.ToString());
// vals.Add("False");
// dao.insert_table_row("ShoeMsg", pars, vals);
//}
List<string> printCols = new List<string>();
printCols.Add("手牌");
if (use_pad)
printCols.Add("房间");
printCols.Add("项目名称");
printCols.Add("技师");
printCols.Add("单价");
printCols.Add("数量");
printCols.Add("金额");
PrintSeatBill.Print_DataGridView(m_Seats, m_rooms,seatForm.m_Seat.text, "转账确认单", dgvExpense, printCols, moneyPayable.Text, companyName);
this.DialogResult = DialogResult.OK;
this.Close();
}
//更换手牌
private void CtxChangeSeat_Click(object sender, EventArgs e)
{
BathDBDataContext db_new = new BathDBDataContext(LogIn.connectionString);
Seat seat = getContextSenderSeat(db_new, sender);
InputEmployeeByPwd inputEmployee = new InputEmployeeByPwd();
if (inputEmployee.ShowDialog() != DialogResult.OK)
return;
if (!BathClass.getAuthority(db_new, inputEmployee.employee, "更换手牌"))
{
BathClass.printErrorMsg(inputEmployee.employee.id + "不具有更换手牌操作权限!");
return;
}
if (seat.status != 2)
{
BathClass.printErrorMsg("该手牌目前不在使用中，不能换台!");
return;
}
List<int> sLst = new List<int>();
sLst.Add(1);
sLst.Add(3);
InputSeatForm inputSeatForm = new InputSeatForm(sLst);
if (inputSeatForm.ShowDialog() != DialogResult.OK)
return;
Seat newSeat = db_new.Seat.FirstOrDefault(x => x == inputSeatForm.m_Seat);
var orders = db_new.Orders.Where(x => x.systemId == seat.systemId);
foreach (Orders order in orders)
order.text = newSeat.text;
newSeat.systemId = seat.systemId;
newSeat.name = seat.name;
newSeat.population = seat.population;
newSeat.openTime = BathClass.Now(LogIn.connectionString);
newSeat.openEmployee = LogIn.m_User.name;
newSeat.phone = seat.phone;
newSeat.chainId = seat.chainId;
newSeat.status = seat.status;
newSeat.note = seat.note;
newSeat.ordering = seat.ordering;
BathClass.reset_seat(seat);
db_new.SubmitChanges();
}