Пример #1
0
        // 从datagridview插入订单到数据库
        private void materialRaisedButton8_Click(object sender, EventArgs e)
        {
            MysqlManager manager = new MysqlManager();
            DialogResult dr      = MessageBox.Show("确认添加订单到数据库 ? ", "提示", MessageBoxButtons.YesNo);

            if (dr == DialogResult.Yes)
            {
                DataTable dt = GetDgvToTable(dataGridView2);
                if (dt.Rows.Count == 0)
                {
                    MessageBox.Show("没有数据可添加");
                }
                else
                {
                    for (int i = 0; i < dt.Rows.Count; i++)
                    {
                        BillPO billPO = new BillPO();
                        billPO.Billid      = dt.Rows[i]["Column1"].ToString();
                        billPO.GuestName   = dt.Rows[i]["Column2"].ToString();
                        billPO.Xinghao     = dt.Rows[i]["Column3"].ToString();
                        billPO.Zhonglei    = dt.Rows[i]["Column4"].ToString();
                        billPO.Color       = dt.Rows[i]["Column5"].ToString();
                        billPO.Num         = Convert.ToInt32(dt.Rows[i]["Column6"]);
                        billPO.SinglePrice = Convert.ToDouble(dt.Rows[i]["Column7"]);
                        billPO.TotalPrice  = Convert.ToDouble(dt.Rows[i]["Column8"]);
                        billPO.OtherText   = dt.Rows[i]["Column9"].ToString();

                        billPO.KaipiaoDate = DateTime.Now.Year.ToString() + "-" + DateTime.Now.Month.ToString() + "-" + DateTime.Now.Day.ToString();
                        billPO.Danwei      = "码 / 米";
                        billPO.Kaipiaor    = "硕麒拉链码庄";
                        billPO.Jinshour    = "无";
                        billPO.PicPath     = "无";
                        billPO.Address     = "无";
                        manager.insertBill(billPO);
                    }
                    MessageBox.Show("订单添加成功,请返回首页查看 !");
                }
            }
        }
Пример #2
0
        //  删除页面  订单查询按钮
        private void materialRaisedButton5_Click(object sender, EventArgs e)
        {
            MysqlManager manager = new MysqlManager();

            if (textBox2.Text == "")
            {
                MessageBox.Show("请输入订单编号!");
            }
            else
            {
                BillPO bill = manager.getBillPObyBillid(textBox2.Text);
                if (bill == null)
                {
                    MessageBox.Show("订单编号输入有误,请重新输入!");
                }
                else
                {
                    DeleteBill deleteBill = new DeleteBill(textBox2.Text);
                    deleteBill.StartPosition = FormStartPosition.CenterParent;
                    deleteBill.ShowDialog();
                }
            }
        }