Exemplo n.º 1
0
        private void button5_Click(object sender, EventArgs e)
        {
            if (Mysqlcom.Myopen())
                return;

            input getcardid = new input("输入卡号", "请输入卡号:", false);
            getcardid.ShowDialog();

            if (getcardid.value == "" || getcardid.value == "-1")
                return;

            input getpw = new input("输入密码", "请输入密码:", true);
            getpw.ShowDialog();

            Mwa_vip vipMod = sql.VIP.GetByPW(getcardid.value, getpw.value);
            if (vipMod == null)
            {
                MessageBox.Show("卡号或密码错误!", "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
                return;
            }

            label8.Text = "会员卡号:" + getcardid.value;
            label8.Text += "\n姓名:" + vipMod.vipid;
            label8.Text += "\n余额:" + vipMod.ChunKuan;
            label8.Text += "\n打折:" + vipMod.discount;

            if (vipMod.state == 2)
            {
                MessageBox.Show("此卡已挂失!", "错误");
                return;
            }

            if (MessageBox.Show("姓名:" + vipMod.vipid + "\n余额:" + vipMod.ChunKuan + "\n打折:" + vipMod.discount, "确定要使用此会员卡?", MessageBoxButtons.OKCancel) != DialogResult.OK)
                return;

            string OldPro = label5.Text;
            int cou = 0;
            double counum = 0; ;
            double OnePri = 0;
            for (int i = 0; i < listView1.Items.Count; i++)
            {
                if (listView1.Items[i].Checked)
                {
                    OnePri = Comdata.CalMon(double.Parse(listView1.Items[i].SubItems[11].Text), int.Parse(listView1.Items[i].SubItems[5].Text), vipMod.discount, Comdata.iniShop.FileObj.count_mode);

                    if (Mysqlcom.enq("update wa_wash set FuKuan='VIP卡',CPay=" + OnePri + ",todate=now(),toID='" + Comdata.loginid + "',discount='" + vipMod.discount + "',mark=CONCAT(mark,'取衣刷卡')  where WID=" + listView1.Items[i].SubItems[9].Text) == -1)
                        MessageBox.Show("取衣失败:" + Mysqlcom.error);
                    else
                    {
                        Mysqlcom.enq("UPDATE wa_code SET cardid=" + getcardid.value + ",totpri=totpri-" + listView1.Items[i].SubItems[6].Text + "+" + OnePri.ToString() + " where coid=" + listView1.Items[i].SubItems[0].Text);
                        listView1.Items[i].SubItems[7].Text = "VIP卡";
                        listView1.Items[i].SubItems[8].Text = "已取";
                        listView1.Items[i].Checked = false;
                        listView1.Items[i].SubItems[6].Text = OnePri.ToString();
                        listView1.Items[i].SubItems[10].Text = vipMod.discount.ToString();

                        counum += OnePri;
                        cou++;
                    }

                }
            }

            if (cou <= 0)
            {
                MessageBox.Show("无未取衣物!");
                return;
            }

            if (Mysqlcom.enq("UPDATE wa_vip SET ChunKuan = ChunKuan - " + counum + ",XaoFei=XaoFei+" + counum + " WHERE Card = " + getcardid.value) < 1)
            {
                MessageBox.Show("vip账户扣费失败!" + Mysqlcom.error);
                return;
            }

            label8.Text = "会员卡号:" + getcardid.value;
            label8.Text += "\n姓名:" + vipMod.vipid;
            label8.Text += "\n余额:" + (vipMod.ChunKuan - counum);
            label8.Text += "\n打折:" + vipMod.discount;
            label8.Text += "\n\n原价格:" + OldPro;
            label8.Text += "\n会员价格:" + counum;

            printline = "";
            printline = "          取衣单\r\n";
            printline += "     %%%%%%%%%%%%%%%%%%\r\n\r\n";
            printline += "顾客姓名:  " + vipMod.vipid + "\r\n";

            printline += "会员卡号:  " + getcardid.value + "\r\n";

            if (vipMod.discount == 10)
                printline += "全单折扣:  无打折\r\n";
            else
                printline += "全单折扣:  " + vipMod.discount + "折\r\n";

            printline += "取衣数量:  " + cou + "件\r\n";
            printline += "合计:  " + counum + "元\r\n";

            printline += "\r\n卡内余额:" + (vipMod.ChunKuan - counum) + "元\r\n\r\n";
            printline += Comdata.PrintFooter();

            button7.Enabled = true;
        }
Exemplo n.º 2
0
        private void 添加瑕疵ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            washmange.sql.Xiaci xia = new washmange.sql.Xiaci();
            washmange.sql.Brand bran = new washmange.sql.Brand();
            this.Activate();

            if (listBox4.Focused)
            {
                input insert = new input("添加瑕疵", "请输入瑕疵:", false);
                insert.openIME();
                insert.ShowDialog();
                if (insert.value == "" || insert.value == "-1")
                    return;

                xia.Xname = insert.value;
                if (!xia.Insert())
                {
                    MessageBox.Show("添加失败:" + Mysqlcom.error);
                    return;
                }
                Comdata.AllXiaci = xia.GetAll();
                listBox4.Items.Add(insert.value);
            }

            else if (listBox5.Focused)
            {
                input insert = new input("添加品牌", "请输入品牌:", false);
                insert.openIME();
                insert.ShowDialog();
                if (insert.value == "" || insert.value == "-1")
                    return;

                bran.Bname = insert.value;
                if (!bran.Insert())
                {
                    MessageBox.Show("添加失败:" + Mysqlcom.error);
                    return;
                }
                Comdata.AllBrand = bran.GetAll();
                listBox5.Items.Add(insert.value);
            }
        }
Exemplo n.º 3
0
        private void listView1_Click(object sender, EventArgs e)
        {
            if (Mysqlcom.Myopen())
                return;

            if (listView1.SelectedIndices.Count > 0)
            {

                if (comboBox1.Text == "自动")
                {

                }

                input uip = new input("输入挂点", "挂点(空白清除挂点):", false);
                uip.ShowDialog();
                if (uip.value != "-1")
                {

                    if (uip.value == "") uip.value = "-1";

                    try
                    {
                        int.Parse(uip.value);
                    }
                    catch (Exception)
                    {

                        MessageBox.Show("挂点必须是数子!","错误");
                        return;
                    }
                    if (uip.value != "0" && uip.value != "-1")
                    {
                        string sqlS = "select COID from wa_code,wa_wash where COID=Wnumber and toID='' and GuaDian=" + uip.value;
            #if !ALONE
                        sqlS += " and shopID=" + Comdata.shopnum;
            #endif
                        long Gcoid = Mysqlcom.es(sqlS);
                        if (Gcoid > 0)
                        {
                            //剪贴板
                            Clipboard.SetDataObject(Gcoid.ToString(), true);
                           if( MessageBox.Show("此挂点已存在衣物!\r\n编号为:" + Gcoid,"继续上挂?",MessageBoxButtons.YesNo)!=DialogResult.Yes)
                            return;
                        }
                    }
                    int selectI=listView1.SelectedIndices[0];
                    if (Mysqlcom.enq("update wa_wash set GuaDian=" + uip.value + " where wid=" + listView1.Items[selectI].SubItems[9].Text) < 1)
                    {
                        MessageBox.Show("上挂失败!" + Mysqlcom.error);
                        return;
                    }

                    if (uip.value == "-1") listView1.Items[selectI].SubItems[4].Text = "无";
                    else listView1.Items[selectI].SubItems[4].Text = uip.value;

                }

            }
        }
Exemplo n.º 4
0
        /// <summary>
        /// vip刷卡
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void radioButton3_CheckedChanged(object sender, EventArgs e)
        {
            if (radioButton3.Checked)
            {
                try
                {
                    if (Mysqlcom.Myopen())
                    {
                        radioButton3.Checked = false;
                        return;
                    }

                    input getcardid = new input("输入卡号", "请输入卡号:", false);
                    getcardid.ShowDialog();

                    if (getcardid.value == "" || getcardid.value == "-1")
                    {
                        radioButton3.Checked = false;
                        return;
                    }

                    input getpw = new input("输入密码", "请输入密码:", true);
                    getpw.ShowDialog();

                    vipMod = sql.VIP.GetByPW(getcardid.value, getpw.value);
                    if (vipMod == null)
                        throw new Exception("卡号或密码错误!");

                    if (vipMod.state == 2)
                        throw new Exception("此卡已挂失!");

                    textBox10.Text = vipMod.vipid;
                    textBox11.Text = vipMod.Telphone;
                    textBox13.Text = vipMod.ChunKuan.ToString();
                    comboBox3.Text = vipMod.discount.ToString();
                    textBox10.ReadOnly = true;
                    textBox11.ReadOnly = true;
                }
                catch (Exception ce)
                {
                    vipMod = null;
                    radioButton3.Checked = false;
                    MessageBox.Show(ce.Message, "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
                }
            }
            else
            {
                textBox10.ReadOnly = false;
                textBox11.ReadOnly = false;
                textBox13.Text = "";
                comboBox3.Text = "10";
            }
        }