//插入账单数据库
/*private void insert_account()
* {
* if (bankUnion.Text != "")
* account.bankUnion = Convert.ToDouble(bankUnion.Text);
*
* if (creditCard.Text != "")
* {
* account.memberId = string.Join("|", m_Member_List.Keys.ToArray());
* account.creditCard = Convert.ToDouble(creditCard.Text);
* }
*
* if (coupon.Text != "")
* {
* account.coupon = Convert.ToDouble(coupon.Text);
* }
*
* if (groupBuy.Text != "")
* {
* account.groupBuy = Convert.ToDouble(groupBuy.Text);
* }
*
* if (zero.Text != "")
* {
* account.name = customerId;
* account.zero = Convert.ToDouble(zero.Text);
* }
*
* if (cash.Text != "")
* {
* account.changes = Convert.ToDouble(changes.Text);
* account.cash = Convert.ToDouble(cash.Text);
* }
*
* if (wipeZero.Text != "")
* {
* account.wipeZero = Convert.ToDouble(wipeZero.Text);
* }
*
* if (sign.Text != "")
* {
* account.server = Convert.ToDouble(sign.Text);
* account.serverEmployee = signature;
* }
* }*/
//实时更新找零
private void money_TextChanged(object sender, EventArgs e)
{
string msg = validateTextFilds();
if (msg != "OK")
{
BathClass.printErrorMsg(msg);
return;
}
double moneyPaid = 0;
if (bankUnion.Text != "" && bankUnion.Text != "-")
{
moneyPaid += Convert.ToDouble(bankUnion.Text);
}
if (creditCard.Text != "" && creditCard.Text != "-")
{
moneyPaid += Convert.ToDouble(creditCard.Text);
}
if (coupon.Text != "" && coupon.Text != "-")
{
moneyPaid += Convert.ToDouble(coupon.Text);
}
if (groupBuy.Text != "" && groupBuy.Text != "-")
{
moneyPaid += Convert.ToDouble(groupBuy.Text);
}
if (zero.Text != "" && zero.Text != "-")
{
moneyPaid += Convert.ToDouble(zero.Text);
}
if (cash.Text != "" && cash.Text != "-")
{
moneyPaid += Convert.ToDouble(cash.Text);
}
if (wipeZero.Text != "" && wipeZero.Text != "-")
{
moneyPaid += Convert.ToDouble(wipeZero.Text);
}
if (sign.Text != "" && sign.Text != "-")
{
moneyPaid += Convert.ToDouble(sign.Text);
}
changes.Text = Math.Round((moneyPaid - Convert.ToDouble(moneyPayable.Text)), 2).ToString();
}
private void dgvPays_show(Customer c)
{
dgvCustomerPays.Rows.Clear();
var pays = db.CustomerPays.Where(x => x.customerId == c.id);
foreach (var p in pays)
{
dgvCustomerPays.Rows.Add(p.id, p.cash, p.bank, p.date, p.payEmployee, p.note);
}
BathClass.set_dgv_fit(dgvCustomerPays);
}
//发卡
public static bool destribute_card_M1(string company_code, string cardCode)
{
if (!connect_card_machine("M1"))
{
return(false);
}
ulong snr = 0;
char mode = '1';
ICRF.rf_card(icdev, mode, ref snr);
byte[] key1 = new byte[20];
byte[] key2 = new byte[20];
string skey = "6a3530303033";
int keylen = skey.Length;
key1 = Encoding.ASCII.GetBytes(skey);
ICRF.a_hex(key1, key2, 12);
int st = ICRF.rf_load_key(icdev, 1, 2, key2);
if (st != 0)
{
MessageBox.Show("装载密码失败");
ICRF.rf_exit(icdev);
return(false);
}
st = ICRF.rf_authentication(icdev, 1, 2);
if (st != 0)
{
MessageBox.Show("验证密码失败");
ICRF.rf_exit(icdev);
return(false);
}
string str = company_code + cardCode;
byte[] data = Encoding.ASCII.GetBytes(str);
//byte[] buff = new byte[16];
//st = IC4442.my_encrypt(data, buff);
st = ICRF.rf_write(icdev, 9, data);
if (st != 0)
{
BathClass.printErrorMsg("写卡失败!");
return(false);
}
st = ICRF.rf_beep(icdev, 20);
st = ICRF.rf_exit(icdev);
return(true);
}
private bool check_if_combined()
{
foreach (Control c in panel2.Controls)
{
if (c.GetType() == typeof(TextBox) && c.Text != "")
{
BathClass.printErrorMsg("请输入金额后，点击确定以混合方式结账!");
return(true);
}
}
return(false);
}
private void dgvActs_show(Customer c)
{
dgvActs.Rows.Clear();
var acts = db.Account.Where(x => x.zero != null && x.abandon == null && x.name == c.id.ToString());
foreach (var a in acts)
{
dgvActs.Rows.Add(a.id, a.text, a.payTime, a.payEmployee, a.zero);
}
BathClass.set_dgv_fit(dgvActs);
}
//对话框载入
private void MonthTableForm_Load(object sender, EventArgs e)
{
int year = BathClass.Now(LogIn.connectionString).Year;
yearBox.Items.Add(year);
for (int i = 1; i < 11; i++)
{
yearBox.Items.Add(year - i);
}
yearBox.SelectedIndex = 0;
monthBox.Text = BathClass.Now(LogIn.connectionString).Month.ToString();
}
//显示信息
private void setStatus(BathDBDataContext dc)
{
double money = 0;
population.Text = m_Seats.Sum(x => x.population).ToString();
money = BathClass.get_rooms_expenses(dc, m_Seats, LogIn.connectionString);
seatText.Text = "";
openTime.Text = "";
timeSpan.Text = "";
expense.Text = money.ToString();
moneyPayable.Text = money.ToString();
}
//连接读卡机
private static bool connect_card_machine(string cardType)
{
if (icdev > 0)
{
if (cardType == "SLE4442")
{
IC.ic_exit(icdev);
}
else if (cardType == "M1")
{
ICRF.rf_exit(icdev);
}
}
string card_port = IOUtil.get_config_by_key(ConfigKeys.KEY_CARD_PORT);
string card_baud = IOUtil.get_config_by_key(ConfigKeys.KEY_CARD_BAUD);
string no_hint = IOUtil.get_config_by_key(ConfigKeys.KEY_CARD_NOHINT);
if ((card_port == "" || card_baud == "") && (no_hint == "" || no_hint == "false"))
{
CardPortBaudForm cardPortBaudForm = new CardPortBaudForm();
if (cardPortBaudForm.ShowDialog() != DialogResult.OK)
{
return(false);
}
card_port = cardPortBaudForm.card_port.ToString();
card_baud = cardPortBaudForm.card_baud.ToString();
}
if (card_port == "" || card_baud == "")
{
return(false);
}
Int16 port = Convert.ToInt16(card_port);
int baud = Convert.ToInt32(card_baud);
if (cardType == "SLE4442")
{
icdev = IC.ic_init(port, baud);
}
else if (cardType == "M1")
{
icdev = ICRF.rf_init(port, baud);
}
if (icdev <= 0)
{
BathClass.printErrorMsg("连接读卡器失败，请重试!");
return(false);
}
return(true);
}
//定位
private void BtnPos_Click(object sender, EventArgs e)
{
int i = MConvert <int> .ToTypeOrDefault(TextMsgStart.Text.Trim(), 0);
if (i >= dgv.Rows.Count)
{
BathClass.printErrorMsg("会员正在加载中，请稍等!");
return;
}
dgv.Rows[i].DefaultCellStyle.BackColor = Color.Cyan;
}
private void dgv_show()
{
//var db = new BathDBDataContext(LogIn.connectionString);
//var ct = db.ClearTable.OrderByDescending(x => x.clearTime).FirstOrDefault();
var ct = dao.get_last_clear_time();
var lastTime = DateTime.Parse("2013-01-01 00:00:00");
if (ct != null)
{
lastTime = ct.Value;
}
//var acts = db.Account.Where(x => x.text.Contains(m_seat_text) && x.payTime > lastTime && x.abandon == null);
//dgv.DataSource = from x in acts
// orderby x.payTime
// select new
// {
// 账单号 = x.id,
// 手牌号 = x.text,
// 结账时间 = x.payTime,
// 结账员工 = x.payEmployee
// };
SqlConnection sqlCn = null;
string cmd_str = "";
try
{
sqlCn = new SqlConnection(LogIn.connectionString);
sqlCn.Open();
cmd_str = "Select * from [Account] where (abandon is null and payTime>'" + lastTime.ToString() + "' and text like" +
"'%" + m_seat_text + "%')";
SqlCommand cmdSelect = new SqlCommand(cmd_str, sqlCn);
using (SqlDataReader dr = cmdSelect.ExecuteReader())
{
while (dr.Read())
{
dgv.Rows.Add(dr["id"], dr["text"], dr["payTime"], dr["payEmployee"]);
}
}
}
catch (System.Exception e)
{
IOUtil.insert_file(DateTime.Now.ToString() + "=" + cmd_str);
BathClass.printErrorMsg(e.ToString());
}
finally
{
dao.close_connection(sqlCn);
}
BathClass.set_dgv_fit(dgv);
}
//确定
private void okBtn_Click(object sender, EventArgs e)
{
if (TextBigMenuName.Text == "")
{
BathClass.printErrorMsg("请选择一个要替换的项目!");
return;
}
if (SubstIDList.Count == 0)
{
BathClass.printErrorMsg("请选择要替换的项目!");
return;
}
if (newBigCombo)
{
string substIDs = "";
var menu = db.Menu.FirstOrDefault(x => x.name == TextBigMenuName.Text);
if (db.BigCombo.Where(x => x.menuid == menu.id).Any())
{
MessageBox.Show("该项目已存在，不能继续添加!");
return;
}
m_BigCombo.menuid = menu.id;
m_BigCombo.price = menu.price;
foreach (var s in SubstIDList)
{
substIDs += s;
substIDs += Constants.SplitChar;
}
m_BigCombo.substmenuid = substIDs.Remove(substIDs.Length - 1);
db.BigCombo.InsertOnSubmit(m_BigCombo);
db.SubmitChanges();
this.DialogResult = DialogResult.OK;
this.Close();
}
else
{
string substIDs = "";
foreach (var s in SubstIDList)
{
substIDs += s;
substIDs += Constants.SplitChar;
}
m_BigCombo.substmenuid = substIDs.Remove(substIDs.Length - 1);
db.SubmitChanges();
this.DialogResult = DialogResult.OK;
this.Close();
}
}
//补卡
private void btnResume_Click(object sender, EventArgs e)
{
if (!BathClass.getAuthority(db, LogIn.m_User, "补卡"))
{
BathClass.printErrorMsg("权限不够!");
return;
}
MemberResumForm memberResumForm = new MemberResumForm();
memberResumForm.ShowDialog();
}
//添加
private void toolAdd_Click(object sender, EventArgs e)
{
GroupBuyItemAddForm f = new GroupBuyItemAddForm(db, m_Promotion);
if (f.ShowDialog() == DialogResult.OK)
{
m_Offer.Add(f.m_Offer, f.m_discoutType + "#" + f.m_discout.ToString());
m_Promotion.menuIds = BathClass.assemble(m_Offer);
db.SubmitChanges();
dgvDetails_show();
}
}
//确定
private void btnOk_Click(object sender, EventArgs e)
{
if (ptList.SelectedIndex == -1)
{
BathClass.printErrorMsg("需要选择打印机 ");
return;
}
printer = ptList.SelectedItem.ToString();
//write_printer();
IOUtil.set_config_by_key(ConfigKeys.KEY_PRINTER, printer);
this.DialogResult = DialogResult.OK;
}
//构造函数
public PromotionForm(BathDBDataContext dc, Promotion promotion)
{
db = dc;
if (promotion != null)
{
newPromotion = false;
m_Promotion = promotion;
m_Offer = BathClass.disAssemble(db, m_Promotion);
}
InitializeComponent();
dgv_show();
}
//绑定快捷键
private void Form_KeyDown(object sender, KeyEventArgs e)
{
switch (e.KeyCode)
{
case Keys.Escape:
this.Close();
break;
case Keys.F1:
addOfficer_Click(null, null);
break;
case Keys.F2:
delOfficer_Click(null, null);
break;
case Keys.F3:
editOfficer_Click(null, null);
break;
case Keys.F4:
BathClass.exportDgvToExcel(dgv);
break;
case Keys.F5:
PrintDGV.Print_DataGridView(dgv, "员工管理", false, "");
break;
case Keys.F6:
addTool_Click(null, null);
break;
case Keys.F7:
delTool_Click(null, null);
break;
case Keys.F8:
editTool_Click(null, null);
break;
case Keys.F9:
authoTool_Click(null, null);
break;
case Keys.F10:
modifyPwdTool_Click(null, null);
break;
default:
break;
}
}
//单项项目统计
private void find_0()
{
dgv.Columns.Clear();
add_cols_to_dgv(dgv, "编号");
add_cols_to_dgv(dgv, "发生时间");
add_cols_to_dgv(dgv, "项目名称");
add_cols_to_dgv(dgv, "手牌号");
add_cols_to_dgv(dgv, "数量");
add_cols_to_dgv(dgv, "金额");
add_cols_to_dgv(dgv, "输入员工");
add_cols_to_dgv(dgv, "技师号");
add_cols_to_dgv(dgv, "账单号");
add_cols_to_dgv(dgv, "单据号");
var orderLst = db.Orders.Where(x => x.menu == menu.Text && x.inputTime >= lastTime &&
x.inputTime <= thisTime && x.deleteEmployee == null);
var paid_orderLst = db.HisOrders.Where(x => x.menu == menu.Text && x.inputTime >= lastTime &&
x.inputTime <= thisTime && x.deleteEmployee == null);
if (cboxBill.Checked && tbBill.Text != "")
{
orderLst = db.Orders.Where(x => x.billId == tbBill.Text);
paid_orderLst = db.HisOrders.Where(x => x.billId == tbBill.Text);
if (!orderLst.Any() && !paid_orderLst.Any())
{
BathClass.printErrorMsg("输入单据号不存在！");
return;
}
}
double number = 0;
double money = 0;
foreach (Orders order in orderLst)
{
number += order.number;
money += Convert.ToDouble(order.money);
dgv.Rows.Add(order.id, order.inputTime, order.menu, order.text, order.number, order.money,
order.inputEmployee, order.technician, order.accountId, order.billId);
}
foreach (var order in paid_orderLst)
{
number += order.number;
money += Convert.ToDouble(order.money);
dgv.Rows.Add(order.id, order.inputTime, order.menu, order.text, order.number, order.money,
order.inputEmployee, order.technician, order.accountId, order.billId);
}
dgv.Rows.Add("合计", "", menu.Text, "", number, money);
BathClass.set_dgv_fit(dgv);
}
//获取会员卡
private void get_member()
{
string card_data = "";
string company_code = db.Options.FirstOrDefault().companyCode;
bool st = false;
var cardType = db.MemberSetting.FirstOrDefault().cardType;
if (cardType == "SLE4442")
{
st = ICCard.read_data_4442(company_code, ref card_data);
}
else if (cardType == "M1")
{
st = ICCard.read_data_M1(company_code, ref card_data);
}
if (!st)
{
return;
}
m_member = db.CardInfo.FirstOrDefault(x => x.CI_CardNo == card_data);
//m_member = db.CardInfo.FirstOrDefault(x => x.CI_CardNo == "05302");
if (m_member == null)
{
BathClass.printErrorMsg("非本公司卡!");
return;
}
id.Text = m_member.CI_CardNo;
name.Text = m_member.CI_Name;
phone.Text = m_member.CI_Telephone;
var t = db.MemberType.FirstOrDefault(x => x.id == m_member.CI_CardTypeNo);
if (t != null)
{
memberType.Text = t.name;
}
var cc = db.CardCharge.Where(x => x.CC_CardNo == m_member.CI_CardNo);
double debit = BathClass.ToInt(cc.Sum(x => x.CC_DebitSum));
double lend = BathClass.ToInt(cc.Sum(x => x.CC_LenderSum));
balance.Text = (debit - lend).ToString();
var c = BathClass.ToInt(m_member.CI_CreditsUsed);
var cu = BathClass.ToInt(db.MemberSetting.FirstOrDefault().money);
int cs = (int)(lend / cu - c);
credits.Text = cs.ToString();
btnOk.Text = "会员打折";
}
//减少
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 order_guoye(HotelRoom seat, BathDBDataContext dc)
{
if (!BathClass.ToBool(m_Options.自动加收过夜费))
{
return;
}
if (dc.Orders.FirstOrDefault(x => x.systemId == seat.systemId && x.menu == "过夜费") != null ||
dc.HisOrders.FirstOrDefault(x => x.systemId == seat.systemId && x.menu == "过夜费") != null)
{
return;
}
var m_OverMenu = dc.Menu.FirstOrDefault(x => x.name == "过夜费");
if (m_OverMenu == null)
{
return;
}
DateTime now = DateTime.Now;
string year = now.Year.ToString();
string month = now.Month.ToString();
string day = now.Day.ToString();
string date = year + "-" + month + "-" + day + " ";
string time = ":00:00";
DateTime st = DateTime.Parse(date + m_Options.过夜费起点 + time);
DateTime et = DateTime.Parse(date + m_Options.过夜费终点 + time);
DateTime open_time = seat.openTime.Value;
if ((now >= et && open_time >= et) || (open_time <= st && now <= st))
{
return;
}
Orders order = new Orders();
order.menu = m_OverMenu.name;
order.text = seat.text;
order.systemId = seat.systemId;
order.number = 1;
order.money = m_OverMenu.price;
order.inputTime = now;
order.inputEmployee = "过夜费";
order.departmentId = 1;
order.paid = false;
dc.Orders.InsertOnSubmit(order);
dc.SubmitChanges();
find_combo(dc, order);
}
//技师管理
private void toolTech_Click(object sender, EventArgs e)
{
//var db_new = new BathDBDataContext(LogIn.connectionString);
if (!dao.get_authority(LogIn.m_User, "技师管理"))
{
BathClass.printErrorMsg("不具有权限");
return;
}
TechnicianSeclectForm technicianForm = new TechnicianSeclectForm();
technicianForm.ShowDialog();
}
//显示清单
public void dgv_show()
{
dgv.DataSource = from x in db.WaiterItem
orderby x.id
select new
{
编号 = x.id,
称 = x.name,
备注 = x.note
};
BathClass.set_dgv_fit(dgv);
}
//确定
private void btnOk_Click(object sender, EventArgs e)
{
btnOk.Enabled = false;
btnOk.Enabled = true;
if (text.Text == "")
{
BathClass.printErrorMsg("需要输入内容!");
return;
}
str = text.Text;
this.DialogResult = DialogResult.OK;
}
//显示信息
private void dgv_show()
{
dgv.DataSource = from x in db.BarMsg
where x.time >= startTime.Value && x.time <= endTime.Value
select new
{
编号 = x.id,
时间 = x.time,
包厢 = x.roomId,
信息 = x.msg
};
BathClass.set_dgv_fit(dgv);
}
private void dgv_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
if (dgv.CurrentCell == null)
{
BathClass.printErrorMsg("未选择行");
return;
}
var memberId = dgv.CurrentRow.Cells[0].Value.ToString();
var form = new MemberItemChart(memberId);
form.ShowDialog();
}
//录单汇总
private void toolAllOrder_Click(object sender, EventArgs e)
{
//var db_new = new BathDBDataContext(LogIn.connectionString);
if (!dao.get_authority(LogIn.m_User, "录单汇总"))
{
BathClass.printErrorMsg("不具有权限");
return;
}
TableOrderTableForm orderTableForm = new TableOrderTableForm(LogIn.connectionString, LogIn.m_User);
orderTableForm.ShowDialog();
}
private bool validateTextFields()
{
foreach (Control c in groupBox1.Controls)
{
if (c.GetType() != typeof(Label) && c.Name != "cost" && c.Name != "note" && c.Text == "")
{
c.Focus();
BathClass.printErrorMsg("需要输入内容");
return(false);
}
}
return(true);
}
//客房
private void btnRoom_Click(object sender, EventArgs e)
{
//BathDBDataContext db_new = new BathDBDataContext(LogIn.connectionString);
if (!dao.get_authority(LogIn.m_User, "包房管理"))
{
BathClass.printErrorMsg("权限不够!");
return;
}
RoomViewForm rmvForm = new RoomViewForm();
rmvForm.ShowDialog();
}
private void dgv_show()
{
get_timeSpan();
if (details)
{
find_details();
}
else
{
find_summery();
}
BathClass.set_dgv_fit(dgv);
}
//构造函数
public MemberFingerForm(CCardInfo member)
{
InitializeComponent();
try
{
dao = new DAO(LogIn.connectionString);
m_member = member;
}
catch (System.Exception e)
{
BathClass.printErrorMsg(e.Message);
}
}
