Esempio n. 1
0
        private void dgv_show()
        {
            dgv.Rows.Clear();
            var companyCode = companies[ComboShopName.SelectedIndex].Split(Constants.SplitChar)[0];

            if (companyCode == "")
            {
                MessageBox.Show("未定义连锁店铺,请先到连锁店铺定义!");
                return;
            }

            string errorDesc = "";
            var    comments  = ShopManagement.queryCommentByCompany(MainForm.ip, companyCode, out errorDesc);

            if (comments == null)
            {
                MessageBox.Show(errorDesc);
                return;
            }

            int i = 1;

            foreach (var comment in comments)
            {
                dgv.Rows.Add(i, comment.content, PCUtil.converJavaTimeToNetTime(comment.createTime).ToString("MM-dd HH:mm"));
                i++;
            }
        }
Esempio n. 2
0
        private void dgvUsed_show()
        {
            dgvUsed.Rows.Clear();

            string errorDesc = "";
            var    coupons   = WxCouponManagement.queryCouponRecords(LogIn.connectionIP, LogIn.options.company_Code, openId,
                                                                     DPStart.Value.ToString("yyyy-MM-dd HH:mm:ss"), DPEnd.Value.ToString("yyyy-MM-dd HH:mm:ss"), out errorDesc);

            if (coupons == null)
            {
                BathClass.printErrorMsg(errorDesc);
                return;
            }

            int i = 1;

            foreach (var coupon in coupons)
            {
                dgvUsed.Rows.Add(i, coupon.id, coupon.title, coupon.value, PCUtil.converJavaTimeToNetTime(coupon.consumeTime));
                i++;
            }

            BathClass.set_dgv_fit(dgvUsed);
            dgvUsed.CurrentCell = null;
        }
Esempio n. 3
0
        //插入账单数据库
        private void insert_account(ref Account account, string name)
        {
            account.text           = m_Seat.text;
            account.systemId       = m_Seat.systemId;
            account.openTime       = m_Seat.openTime.ToString();
            account.openEmployee   = m_Seat.openEmployee;
            account.payTime        = DateTime.Now;
            account.payEmployee    = LogIn.m_User.id;
            account.server         = BathClass.get_seat_expense(m_Seat, LogIn.connectionString);
            account.serverEmployee = name;
            account.macAddress     = PCUtil.getMacAddr_Local();

            db.Account.InsertOnSubmit(account);
            db.SubmitChanges();
        }
Esempio n. 4
0
        /// <summary>
        /// 生成计算机码
        /// </summary>
        /// <returns></returns>
        public static string GenerationCode()
        {
            string text = PCUtil.GetCPUID();

            text += PCUtil.GetMacAddress();
            text += PCUtil.GetSystemType();

            byte[] b = Encoding.UTF8.GetBytes(text);

            SHA256 sh = SHA256.Create();

            byte[] bytes = sh.ComputeHash(b);

            string base64string = Convert.ToBase64String(bytes);

            return(base64string);
        }
Esempio n. 5
0
        private void dgv_show()
        {
            string errorDesc = "";
            var    comments  = ShopManagement.queryCommentByCompany(LogIn.connectionIP, LogIn.options.company_Code, out errorDesc);

            if (comments == null)
            {
                BathClass.printErrorMsg(errorDesc);
                return;
            }

            int i = 1;

            foreach (var comment in comments)
            {
                dgv.Rows.Add(i, comment.content, PCUtil.converJavaTimeToNetTime(comment.createTime).ToString("MM-dd HH:mm"));
                i++;
            }
        }
Esempio n. 6
0
        //对话框载入
        private void CashierForm_Load(object sender, EventArgs e)
        {
            try
            {
                this.Size     = new Size(this.Size.Width, Screen.GetWorkingArea(this).Height);
                this.Location = new Point(0, 0);
                ptTimeList.Items.Add(DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
                macAdd = PCUtil.getMacAddr_Local();
                var cpts = db.CashPrintTime.Where(x => x.macAdd == macAdd).OrderByDescending(x => x.time).Select(x => x.time);
                foreach (var cpt in cpts)
                {
                    ptTimeList.Items.Add(cpt.ToString("yyyy-MM-dd HH:mm:ss"));
                }

                ptTimeList.SelectedIndex = 0;
            }
            catch (System.Exception ex)
            {
                BathClass.printErrorMsg(ex.Message);
                this.Close();
            }
        }
Esempio n. 7
0
        //设置账单
        private void set_account()
        {
            //account.text = string.Join("|", m_Seats_Real.OrderBy(x => x.text).Select(x => x.text).ToArray());
            //account.systemId = string.Join("|", m_Seats_Real.OrderBy(x => x.text).Select(x => x.systemId).ToArray());
            //account.openTime = string.Join("|", m_Seats_Real.OrderBy(x => x.text).Select(x => x.openTime.ToString()).ToArray());
            //account.openEmployee = string.Join("|", m_Seats_Real.OrderBy(x => x.text).Select(x => x.openEmployee).ToArray());

            account.text         = string.Join("|", m_Seats.OrderBy(x => x.text).Select(x => x.text).ToArray());
            account.systemId     = string.Join("|", m_Seats.OrderBy(x => x.text).Select(x => x.systemId).ToArray());
            account.openTime     = string.Join("|", m_Seats.OrderBy(x => x.text).Select(x => x.openTime.ToString()).ToArray());
            account.openEmployee = string.Join("|", m_Seats.OrderBy(x => x.text).Select(x => x.openEmployee).ToArray());
            //account.payTime = now;
            account.payEmployee = LogIn.m_User.id.ToString();
            account.macAddress  = PCUtil.getMacAddr_Local();
            if (m_promotion_Member != null)
            {
                account.promotionMemberId = m_promotion_Member.CI_CardNo;
                account.promotionAmount   = m_discount_money;
            }
            if (m_Member_List != null)
            {
                account.memberId = string.Join("|", m_Member_List.Keys.ToArray());
            }
        }
Esempio n. 8
0
        //在使用会员卡和优惠券结账时,发送消息给摄像头进行录像
        public static bool sendMessageToCamera(DAO dao, string systemId)
        {
            string cmd_str = "insert into [PayMsg](systemId, ip) values('" + systemId + "','" + PCUtil.getLocalIp() + "')";

            if (!dao.execute_command(cmd_str))
            {
                return(false);
            }
            return(true);
        }
Esempio n. 9
0
        //宾客付款
        private void payTool_Click(object sender, EventArgs e)
        {
            BathDBDataContext dc = new BathDBDataContext(LogIn.connectionString);

            HintForm hintForm = new HintForm("请插入会员卡...");

            if (hintForm.ShowDialog() != DialogResult.OK)
            {
                return;
            }

            MemberCardUsingForm memberCardUsingForm = new MemberCardUsingForm(Convert.ToDouble(moneyPayable.Text));

            if (memberCardUsingForm.ShowDialog() != DialogResult.OK)
            {
                return;
            }

            if (m_Member == null)
            {
                m_Member = memberCardUsingForm.m_member;
            }

            Account account = new Account();

            account.text         = m_Seat.text;
            account.systemId     = m_Seat.systemId;
            account.openTime     = m_Seat.openTime.ToString();
            account.openEmployee = m_Seat.openEmployee;
            account.payTime      = DateTime.Now;
            account.payEmployee  = LogIn.m_User.id.ToString();
            account.macAddress   = PCUtil.getMacAddr_Local();
            if (m_promotion_Member != null)
            {
                account.promotionMemberId = m_promotion_Member.CI_CardNo;
                account.promotionAmount   = discount_money;
            }
            if (m_Member != null)
            {
                account.memberId = memberCardUsingForm.m_member.CI_CardNo;
            }

            account.creditCard = Convert.ToInt32(moneyPayable.Text);
            db.Account.InsertOnSubmit(account);

            db.SubmitChanges();

            var orderList = db.Orders.Where(x => x.systemId == m_Seat.systemId && !x.paid);

            foreach (Orders order in orderList)
            {
                order.paid      = true;
                order.accountId = account.id;
            }

            m_Seat.status = 3;
            var room = db.Room.FirstOrDefault(x => x.seat == m_Seat.text);

            if (room != null)
            {
                room.status = "等待清洁";
            }

            insert_member_infor(account);
            db.SubmitChanges();

            var act_old = dc.Account.FirstOrDefault(x => x.systemId == m_Seat.systemId && x.abandon != null);

            if (act_old == null)
            {
                printTool_Click("结账单");
                printTool_Click("存根单");
            }
            else
            {
                printTool_Click("补救单");
            }

            var act = dc.Account.FirstOrDefault(x => x.systemId == m_Seat.systemId && x.abandon == null);
        }
Esempio n. 10
0
        //赠送卡
        private void btn_free_Click(object sender, EventArgs e)
        {
            if (btnOk.Text == "读卡")
            {
                get_member();
            }
            else if (btnOk.Text == "激活")
            {
                if (m_use_finder_pwd && m_finger == null)
                {
                    if (BathClass.printAskMsg("系统指定需要使用指纹密码,是否确定放弃录入指纹?") != DialogResult.Yes)
                    {
                        return;
                    }
                }

                if (tb_cash.Text.Trim() != "" || tb_bank.Text.Trim() != "")
                {
                    BathClass.printErrorMsg("已经输入付款金额,请点击\"激活\"售卡激活!");
                    return;
                }

                string pars = "memberId";
                string vals = "'" + m_member.CI_CardNo + "'";

                pars += ",payEmployee";
                vals += ",'" + LogIn.m_User.id + "'";

                pars += ",payTime";
                vals += ",getdate()";

                pars += ",macAddress";
                vals += ",'" + PCUtil.getMacAddr_Local() + "'";

                if (balance.Text != "")
                {
                    pars += ",balance";
                    vals += ",'" + balance.Text + "'";
                }

                pars += ",note";
                vals += ",'赠送卡'";

                if (tb_seat.Text != "")
                {
                    pars += ",seat";
                    vals += ",'" + tb_seat.Text + "'";
                }

                string cmd_str = @"insert into [CardSale](" + pars + ") values(" + vals + ") ";

                if (m_finger == null || m_finger == "")
                {
                    m_finger = "null";
                }
                else
                {
                    m_finger = "'" + m_finger + "'";
                }
                cmd_str += @"update [CardInfo] set state='在用',CI_Password="******" where CI_CardNo='" + id.Text + "'";
                if (!dao.execute_command(cmd_str))
                {
                    BathClass.printErrorMsg("赠送卡失败,请重试!");
                    return;
                }

                string seat = null;
                if (tb_seat.Text != "")
                {
                    seat = tb_seat.Text;
                }
                PrintMemberActivateMsg.Print_DataGridView(id.Text, type.Text, balance.Text, LogIn.m_User.id,
                                                          DateTime.Now.ToString("MM-dd HH:mm"), LogIn.options.companyName, null, seat);
                this.DialogResult = DialogResult.OK;
            }
        }
Esempio n. 11
0
        //确定
        private void btnOk_Click(object sender, EventArgs e)
        {
            if (btnOk.Text == "读卡")
            {
                get_member();
            }
            else if (btnOk.Text == "激活")
            {
                if (m_use_finder_pwd && m_finger == null)
                {
                    if (BathClass.printAskMsg("系统指定需要使用指纹密码,是否确定放弃录入指纹?") != DialogResult.Yes)
                    {
                        return;
                    }
                }
                var m_waiter = dao.get_Employee("id='" + tb_waiter.Text + "'");
                if (m_waiter == null)
                {
                    BathClass.printErrorMsg("输入服务员工号不存在!");
                    return;
                }

                if (tb_cash.Text.Trim() == "" && tb_bank.Text.Trim() == "")
                {
                    BathClass.printErrorMsg("需要输入金额!");
                    return;
                }

                double card_val = find_card_value(MConvert <double> .ToTypeOrDefault(balance.Text, 0));
                if (card_val != -1 && MConvert <double> .ToTypeOrDefault(tb_cash.Text, 0) + MConvert <double> .ToTypeOrDefault(tb_bank.Text, 0) < card_val)
                {
                    BathClass.printErrorMsg("付款金额不足");
                    return;
                }

                string pars = "";
                string vals = "";

                pars = "memberId";
                vals = "'" + m_member.CI_CardNo + "'";

                pars += ",payEmployee";
                vals += ",'" + m_waiter.id + "'";

                pars += ",payTime";
                vals += ",getdate()";

                pars += ",macAddress";
                vals += ",'" + PCUtil.getMacAddr_Local() + "'";

                Dictionary <string, string> pay_info = new Dictionary <string, string>();
                if (tb_bank.Text.Trim() != "")
                {
                    pars          += ",bankUnion";
                    vals          += ",'" + tb_bank.Text + "'";
                    pay_info["银联"] = tb_bank.Text;
                }

                if (tb_cash.Text.Trim() != "")
                {
                    pars          += ",cash";
                    vals          += ",'" + tb_cash.Text + "'";
                    pay_info["现金"] = tb_cash.Text;
                }

                if (balance.Text != "")
                {
                    pars += ",balance";
                    vals += ",'" + balance.Text + "'";
                }

                if (tb_seat.Text != "")
                {
                    pars += ",seat";
                    vals += ",'" + tb_seat.Text + "'";
                }

                string cmd_str = @"insert into [CardSale](" + pars + ") values(" + vals + ")";

                if (m_finger == null || m_finger == "")
                {
                    m_finger = "null";
                }
                else
                {
                    m_finger = "'" + m_finger + "'";
                }
                cmd_str += @"update [CardInfo] set state='在用',CI_Password="******" where CI_CardNo='" + id.Text + "'";
                if (!dao.execute_command(cmd_str))
                {
                    BathClass.printErrorMsg("会员激活失败,请重试!");
                    return;
                }

                string seat = null;
                if (tb_seat.Text != "")
                {
                    seat = tb_seat.Text;
                }
                PrintMemberActivateMsg.Print_DataGridView(id.Text, type.Text, balance.Text, LogIn.m_User.id,
                                                          DateTime.Now.ToString("MM-dd HH:mm"), LogIn.options.companyName, pay_info, seat);
                this.DialogResult = DialogResult.OK;
            }
            else if (btnOk.Text == "退卡")
            {
                if (BathClass.printAskMsg("确定退还卡号:" + m_member.CI_CardNo + "?") != DialogResult.Yes)
                {
                    return;
                }

                if (dao.exist_instance("CardCharge", "CC_CardNo='" + m_member.CI_CardNo + "' and (CC_ItemExplain='会员刷卡' or CC_ItemExplain='会员打折')"))
                {
                    BathClass.printErrorMsg("已有消费记录,不能退卡");
                    return;
                }
                string cmd_str = @" update cardSale set abandon='" + LogIn.m_User.id + "' where id in (select top 1 id from cardsale where memberId='" + id.Text + "' order by id desc)";
                cmd_str += @"update [CardInfo] set state='入库' where CI_CardNo='" + id.Text + "'";

                if (!dao.execute_command(cmd_str))
                {
                    BathClass.printErrorMsg("退卡失败,请重试!");
                    return;
                }

                this.DialogResult = DialogResult.OK;
            }
        }
Esempio n. 12
0
        //确定
        private void btnOk_Click(object sender, EventArgs e)
        {
            if (btnOk.Text == "读卡")
            {
                get_member();
            }
            else if (btnOk.Text == "充值")
            {
                string bank   = tb_bank.Text.Trim();
                string cash   = tb_cash.Text.Trim();
                string server = tb_server.Text.Trim();
                if (cash == "" && bank == "" && server == "")
                {
                    BathClass.printErrorMsg("需要输入充值金额");
                    return;
                }

                string serverEmployee = string.Empty;
                if (tb_server.Text.Trim() != "")
                {
                    var form = new SignForFreeForm();
                    if (form.ShowDialog() != DialogResult.OK)
                    {
                        BathClass.printErrorMsg("需要输入赠送人姓名");
                        return;
                    }
                    serverEmployee = form.signature;
                }

                string pars = "";
                string vals = "";

                pars = "memberId";
                vals = "'" + id.Text + "'";
                if (balance.Text != "")
                {
                    pars += ",balance";
                    vals += ",'" + balance.Text + "'";
                }

                double money = 0;
                if (bank != "")
                {
                    double b = Convert.ToDouble(bank);
                    pars  += ",bankUnion";
                    vals  += ",'" + bank + "'";
                    money += b;
                }

                if (cash != "")
                {
                    double c = Convert.ToDouble(cash);
                    pars  += ",cash";
                    vals  += ",'" + cash + "'";
                    money += c;
                }

                if (server != "")
                {
                    double s = Convert.ToDouble(server);
                    pars  += ",server";
                    vals  += ",'" + server + "'";
                    money += s;

                    pars += ",serverEmployee";
                    vals += ",'" + serverEmployee + "'";
                }

                if (tb_seat.Text.Trim() != "")
                {
                    pars += ",seat";
                    vals += ",'" + tb_seat.Text + "'";
                }

                pars += ",macAddress";
                vals += ",'" + PCUtil.getMacAddr_Local() + "'";

                pars += ",explain";
                vals += ",'会员充值'";

                pars += ",payEmployee";
                vals += ",'" + LogIn.m_User.id + "'";

                pars += ",payTime";
                vals += ",getdate()";

                string cmd_str = @"insert into [CardSale](" + pars + ") values(" + vals + ") ";

                #region 会员充值
                pars = "CC_CardNo";
                vals = "'" + m_member.CI_CardNo + "'";

                pars += ",CC_DebitSum";
                vals += "," + money;

                pars += ",CC_ItemExplain";
                vals += ",'会员卡充值-收'";

                pars += ",CC_InputOperator";
                vals += ",'" + LogIn.m_User.id + "'";

                pars += ",CC_InputDate";
                vals += ",getdate()";

                if (m_Seat != null)
                {
                    pars += ",systemId";
                    vals += ",'" + m_Seat.systemId + "'";
                }

                cmd_str += @" insert into [CardCharge](" + pars + ") values(" + vals + ")";
                #endregion

                #region 会员充值送
                var sale_money = get_promotion_for_cardPop(money);
                if (sale_money != 0)
                {
                    BathClass.printInformation("会员充值送" + sale_money.ToString());
                    pars = "CC_CardNo";
                    vals = "'" + m_member.CI_CardNo + "'";

                    pars += ",CC_DebitSum";
                    vals += "," + sale_money;

                    pars += ",CC_ItemExplain";
                    vals += ",'会员卡充值-送'";

                    pars += ",CC_InputOperator";
                    vals += ",'" + LogIn.m_User.id + "'";

                    pars += ",CC_InputDate";
                    vals += ",getdate()";

                    if (m_Seat != null)
                    {
                        pars += ",systemId";
                        vals += ",'" + m_Seat.systemId + "'";
                    }

                    cmd_str += @" insert into [CardCharge](" + pars + ") values(" + vals + ")";
                }

                #endregion

                if (!dao.execute_command(cmd_str))
                {
                    BathClass.printErrorMsg("会员充值失败,请重试!");
                    return;
                }

                Dictionary <string, string> pay_info = new Dictionary <string, string>();
                if (bank != "")
                {
                    pay_info["银联"] = bank;
                }

                if (cash != "")
                {
                    pay_info["现金"] = cash;
                }

                if (server != "")
                {
                    pay_info["招待"] = server + "$" + serverEmployee;
                }

                string bl = dao.get_member_balance(id.Text).ToString();
                PrintMemberPopMsg.Print_DataGridView(id.Text, type.Text, bl, LogIn.m_User.id,
                                                     DateTime.Now.ToString("MM-dd HH:mm"), LogIn.options.companyName, pay_info, tb_seat.Text);

                this.DialogResult = DialogResult.OK;
                this.Close();
            }
        }