Exemplo n.º 1
0
        public void LoadLabel()
        {
            DataTable table = new DataTable();
            string    lenh3 = "select maTTDH from DonHang where maCN='" + maCN + "'";
            var       sql   = new GetDataFromSQL();

            table = sql.getDataTable(lenh3);
            int mangve = 0, tongdai = 0, empty = 0;;

            foreach (DataRow row in table.Rows)
            {
                if (Convert.ToInt32(row[0].ToString()) == 6)
                {
                    mangve++;
                }
                if (Convert.ToInt32(row[0].ToString()) == 7)
                {
                    tongdai++;
                }
            }

            button11.Text = "Mang về (" + mangve + ")";
            button12.Text = "Tổng đài (" + tongdai + ")";


            var    table1 = new DataTable();
            string lenh   = "select maBA, tenBA, ghiChu, sucChua, tinhTrang, cn.maCN from BanAn ba, ChiNhanh cn where tinhTrang=0 and cn.maCN=ba.maCN and cn.tenCN=N'" + tenCN + "'";

            table1 = sql.getDataTable(lenh);
            foreach (DataRow row in table1.Rows)
            {
                empty++;
            }
            button7.Text = "Còn trống (" + empty + ")";

            int    open   = 0;
            var    table2 = new DataTable();
            string lenh2  = "select distinct ba.maBA, cn.maCN from BanAn ba, ChiNhanh cn, DonHang dh where dh.maCN=cn.maCN and dh.maTTDH=1 and tinhTrang=1 and cn.maCN=ba.maCN and ba.maBA=dh.maBA and cn.tenCN=N'" + tenCN + "'";

            table2 = sql.getDataTable(lenh2);
            foreach (DataRow row in table2.Rows)
            {
                open++;
            }
            button1.Text = "Bàn đang mở (" + open + ")";

            int    chebien = 0;
            var    table3  = new DataTable();
            string lenh4   = "select distinct ba.maBA, cn.maCN from BanAn ba, ChiNhanh cn, DonHang dh where dh.maCN=cn.maCN and (dh.maTTDH=2 or dh.maTTDH=3) and tinhTrang=1 and ba.maBA=dh.maBA and cn.maCN=ba.maCN and cn.tenCN=N'" + tenCN + "'";

            table3 = sql.getDataTable(lenh4);
            foreach (DataRow row in table3.Rows)
            {
                chebien++;
            }
            button2.Text = "Đang chế biến (" + chebien + ")";
        }
Exemplo n.º 2
0
        private void button3_Click(object sender, EventArgs e)
        {
            foreach (DataGridViewRow row in dataGridView1.Rows)
            {
                tien += Convert.ToDecimal(row.Cells[1].Value);
            }
            var    sql  = new GetDataFromSQL();
            string time = DateTime.Now.ToString();
            string lenh = "insert into DonHang(maTTDH,thoiGian,SDT,diaChi,giaTriDonHang) values (9,'" + time + "','" + textBox1.Text + "',N'" + label4.Name + "'," + tien + ")";

            if (sql.ExecuteNonQuery(lenh) > 0)
            {
                string    lenhx = "select maDH from DonHang where SDT='" + textBox1.Text + "' and thoiGian='" + time + "'";
                DataTable tab   = new DataTable();
                tab = sql.getDataTable(lenhx);
                foreach (DataRow row in tab.Rows)
                {
                    maDH          = Convert.ToInt32(row[0].ToString());
                    textBox1.Text = "dsa " + maDH;
                }

                int i = dataGridView1.RowCount, j = 0;
                foreach (DataGridViewRow row in dataGridView1.Rows)
                {
                    var    dt       = new DataTable();
                    string tenMonAn = row.Cells[0].Value.ToString();
                    string timMaMA  = "select maMA from MonAn where tenMA=N'" + tenMonAn + "'";
                    dt = sql.getDataTable(timMaMA);
                    int maMA = 0;
                    foreach (DataRow dtRow in dt.Rows)
                    {
                        maMA = Convert.ToInt32(dtRow[0].ToString());
                    }

                    string lenh1 = "insert into ChiTietDonHang(maDonHang,maMA) values ('" + maDH + "','" + maMA + "')";
                    if (sql.ExecuteNonQuery(lenh1) > 0)
                    {
                        j++;
                    }
                }
                if (i == j)
                {
                    MessageBox.Show("Tạo đơn hàng thành công!");
                    this.Refresh();
                }
                else
                {
                    MessageBox.Show("Không thể tạo đơn hàng này!");
                }
            }
        }
Exemplo n.º 3
0
        private void Form5_Load(object sender, EventArgs e)
        {
            var       sql  = new GetDataFromSQL();
            DataTable dh   = new DataTable();
            string    lenh = "select ten, kh.SDT, maDH from KhachHang kh, DonHang dh where dh.SDT=kh.SDT and maTTDH=6 and dh.maCN=" + Form1.maCN;

            dh = sql.getDataTable(lenh);
            foreach (DataRow row in dh.Rows)
            {
                Button bt = new Button();
                bt.Parent     = flowLayoutPanel1;
                bt.Size       = new Size(365, 165);
                bt.Text       = row[0].ToString() + "\r\n" + row[1].ToString();
                bt.Font       = new System.Drawing.Font("Microsoft Sans Serif", 25, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
                bt.ForeColor  = Color.DodgerBlue;
                bt.BackColor  = Color.Navy;
                bt.Click     += Bt_Click;
                bt.LostFocus += Bt_LostFocus;
                bt.Name       = row[1].ToString();
            }


            //hide task and fullscreen
            FormState fm = new FormState();

            fm.Maximize(this);
        }
Exemplo n.º 4
0
        private void button7_Click(object sender, EventArgs e)
        {
            flowLayoutPanel1.Controls.Clear();
            var    table = new DataTable();
            string lenh  = "select maBA, tenBA, ghiChu, sucChua, tinhTrang, cn.maCN from BanAn ba, ChiNhanh cn where tinhTrang=0 and cn.maCN=ba.maCN and cn.tenCN=N'" + tenCN + "'";
            var    sql   = new GetDataFromSQL();

            table = sql.getDataTable(lenh);
            foreach (DataRow row in table.Rows)
            {
                Button bt = new Button()
                {
                    Width = 120, Height = 120
                };
                bt.Name      = row[0].ToString();
                bt.Parent    = flowLayoutPanel1;
                bt.Text      = "Bàn " + row[1].ToString();
                bt.BackColor = Color.Lavender;
                bt.ForeColor = Color.Navy;
                bt.Font      = new System.Drawing.Font("Microsoft Sans Serif", 17, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
                var    projectPath = Directory.GetParent(Directory.GetCurrentDirectory()).Parent.FullName;
                string filePath    = Path.Combine(projectPath, "Resources\\Icons8-Ios7-Household-Table.ico");
                bt.Image                 = Image.FromFile(filePath, true);
                bt.ImageAlign            = System.Drawing.ContentAlignment.TopCenter;
                bt.TextAlign             = System.Drawing.ContentAlignment.BottomCenter;
                bt.BackgroundImageLayout = ImageLayout.Center;
                bt.Click                += Bt_Click;
            }
        }
Exemplo n.º 5
0
        private void Bt_Click(object sender, EventArgs e)
        {
            Button bt = (Button)sender;

            curTable = Convert.ToInt32(bt.Name);

            var    sql  = new GetDataFromSQL();
            string lenh = "insert into DonHang(maTTDH, maCN, thoiGian, maBA) values (1,'" + maCN + "','" + DateTime.Now.ToString() + "'," + curTable + ")";

            sql.ExecuteNonQuery(lenh);

            var    temp  = new DataTable();
            string lenh2 = "select maDH from DonHang where maCN=" + maCN + " and maBA=" + curTable;

            temp = sql.getDataTable(lenh2);
            foreach (DataRow row in temp.Rows)
            {
                maDH = Convert.ToInt32(row[0].ToString());
            }

            string lenh3 = "update BanAn set tinhTrang=1 where maBA='" + curTable + "' and maCN=" + maCN;

            sql.ExecuteNonQuery(lenh3);
            tenTable = bt.Text;
            Form4 f3 = new Form4();

            f3.ShowDialog();
        }
Exemplo n.º 6
0
        private void Form4_Load(object sender, EventArgs e)
        {
            label3.Text = DateTime.Now.ToString();
            var       sql     = new GetDataFromSQL();
            DataTable danhmuc = new DataTable();
            string    lenh    = "select distinct tenDM from DanhMucMonAn dm, MonAn ma, MenuChiNhanh mn where dm.maDM=ma.danhMuc and ma.maMA=mn.maMA and mn.maCN='" + Form1.maCN + "'";

            danhmuc = sql.getDataTable(lenh);
            foreach (DataRow row in danhmuc.Rows)
            {
                Button bt = new Button();
                bt.Parent    = flowLayoutPanel1;
                bt.Size      = new Size(165, 165);
                bt.Text      = row[0].ToString();
                bt.ForeColor = Color.DodgerBlue;
                bt.BackColor = Color.Navy;
                bt.Font      = new Font(this.Font, FontStyle.Bold);
                bt.Click    += Bt_Click;
            }
            label1.Text = Form1.tenTable;


            //hide task and fullscreen
            FormState fm = new FormState();

            fm.Maximize(this);
        }
Exemplo n.º 7
0
        void LoadDGVDonHang() //dgv3
        {
            string lenh = "select maDH as N'Mã đơn hàng', ten as N'Tên khách hàng', kh.SDT as N'Số điện thoại', dh.thoiGian as N'Thời gian đặt hàng' from KhachHang kh, DonHang dh where dh.SDT = kh.SDT and maTTDH = 9 ";
            var    sql  = new GetDataFromSQL();

            dtDuyet = sql.getDataTable(lenh);
            dataGridView3.DataSource = dtDuyet;
        }
Exemplo n.º 8
0
        public void LoadChiNhanh()
        {
            var sql = new GetDataFromSQL();

            cn = sql.getDataTable("select maCN, tenCN, dienThoai, diaChi, tinhThanh from ChiNhanh");
            dataGridView3.DataSource = cn;
            dataGridView3.ReadOnly   = true;
        }
Exemplo n.º 9
0
        void LoadDGVHuyDoi() //dgv5
        {
            string lenh = "select maDH as N'Mã đơn hàng', tenTTDH as 'Trạng thái' ,ten as N'Tên khách hàng', kh.SDT as N'Số điện thoại', dh.thoiGian as N'Thời gian đặt hàng' from KhachHang kh, DonHang dh, TinhTrangDonHang ttdh where dh.SDT = kh.SDT and dh.maTTDH=ttdh.maTTDH and (dh.maTTDH = 4 or dh.maTTDH = 6 or dh.maTTDH =7 or dh.maTTDH =8 or dh.maTTDH =9 or dh.maTTDH =10 or dh.maTTDH =11) and dh.maBA is null";
            var    sql  = new GetDataFromSQL();

            dtDuyet = sql.getDataTable(lenh);
            dataGridView5.DataSource = dtDuyet;
        }
Exemplo n.º 10
0
        private void Form2_Activated(object sender, EventArgs e)
        {
            var    tableOfCN = new DataTable();
            var    sql       = new GetDataFromSQL();
            string lenh      = "select maBA,tenBA,ghiChu,sucChua from BanAn where maCN= " + masoCN;

            tableOfCN = sql.getDataTable(lenh);
            dataGridView4.DataSource = tableOfCN;
        }
Exemplo n.º 11
0
        void LoadFlowPanel2()
        {
            var dt = new DataTable();

            dt = sql.getDataTable("select top(8) tenMA,maMA from MonAn order by dem desc");
            foreach (DataRow row in dt.Rows)
            {
                Button btTop = new Button();
                btTop.Parent    = flowLayoutPanel2;
                btTop.Text      = row[0].ToString();
                btTop.ForeColor = Color.MediumBlue;
                btTop.BackColor = Color.SeaShell;
                btTop.TextAlign = System.Drawing.ContentAlignment.MiddleCenter;
                btTop.Size      = new Size(386, 55);
                btTop.Font      = new System.Drawing.Font("Microsoft Sans Serif", 18, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
                btTop.Click    += BtTop_Click;
                btTop.Name      = row[1].ToString();
            }
        }
Exemplo n.º 12
0
        void LoadDonHangChuyenXuongCN()
        {
            var    table = new DataTable();
            string lenh  = "select tenCN,maCN from ChiNhanh";
            var    sql   = new GetDataFromSQL();

            table = sql.getDataTable(lenh);
            double congsuat = 0;
            double tong     = 0;
            double hien     = 0;

            foreach (DataRow row in table.Rows)
            {
                var    temp = new DataTable();
                string cmd  = "select maBA,tinhTrang from BanAn ba, ChiNhanh cn where ba.maCN=cn.maCN and cn.maCN=" + Convert.ToInt32(row[1].ToString());
                temp = sql.getDataTable(cmd);
                foreach (DataRow rowtemp in temp.Rows)
                {
                    tong++;
                    if (Convert.ToInt32(rowtemp[1]) == 1)
                    {
                        hien++;
                    }
                }
                congsuat = (hien / tong) * 100;
                if (hien == 0 || tong == 0)
                {
                    congsuat = 0;
                }
                Button btDuyet = new Button();
                btDuyet.Parent     = flowLayoutPanel6;
                btDuyet.Size       = new Size(290, 100);
                btDuyet.Text       = row[0].ToString() + "\r\nCông suất: " + Math.Round(congsuat, 1) + "%";
                btDuyet.Font       = new System.Drawing.Font("Microsoft Sans Serif", 15, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
                btDuyet.ForeColor  = Color.DodgerBlue;
                btDuyet.BackColor  = Color.Navy;
                btDuyet.Click     += btDuyet_Click;
                btDuyet.LostFocus += btDuyet_LostFocus;
                btDuyet.Name       = row[1].ToString();
                //btDuyet.AccessibleName = row[2].ToString();
            }
        }
Exemplo n.º 13
0
        void LoadcbbDanhMuc()
        {
            var dtDM = new DataTable();
            var sql  = new GetDataFromSQL();

            dtDM = sql.getDataTable("select tenDM from DanhMucMonAn");
            foreach (DataRow row in dtDM.Rows)
            {
                cb_DM.Items.Add(row["tenDM"]);
            }
        }
Exemplo n.º 14
0
        //MON AN

        private void LoadComboBoxDanhMuc()
        {
            cb_MADanhMuc.Items.Clear();
            var sql = new GetDataFromSQL();

            cbb = sql.getDataTable("select distinct tenDM from DanhMucMonAn");
            foreach (DataRow row in cbb.Rows)
            {
                cb_MADanhMuc.Items.Add(row["tenDM"]);
            }
        }
Exemplo n.º 15
0
        private void chebien_Load(object sender, EventArgs e)
        {
            var       sql  = new GetDataFromSQL();
            DataTable dh   = new DataTable();
            string    lenh = "select tenBA, dh.maBA, maDH, dh.thoiGian from DonHang dh, BanAn ba where (maTTDH=2 or maTTDH=3) and dh.maCN='" + Form1.maCN + "' and dh.maBA=ba.maBA";
            DataTable dh2  = new DataTable();

            dh2 = sql.getDataTable(lenh);
            foreach (DataRow row in dh2.Rows)
            {
                Button open = new Button();
                open.Parent         = flowLayoutPanel1;
                open.Size           = new Size(350, 150);
                open.Text           = "Bàn: " + row[0].ToString() + "\r\nThời gian: " + row[3].ToString();
                open.Font           = new System.Drawing.Font("Microsoft Sans Serif", 15, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
                open.ForeColor      = Color.DodgerBlue;
                open.BackColor      = Color.Navy;
                open.Click         += open_Click;
                open.LostFocus     += open_LostFocus;
                open.Name           = row[1].ToString();
                open.AccessibleName = row[2].ToString();
            }

            string lenh2 = "select kh.ten, dh.maBA, maDH, dh.SDT from DonHang dh, KhachHang kh where (maTTDH=2 or maTTDH=3) and dh.maCN='" + Form1.maCN + "' and dh.SDT=kh.SDT";

            dh = sql.getDataTable(lenh2);
            foreach (DataRow row in dh.Rows)
            {
                Button open = new Button();
                open.Parent         = flowLayoutPanel1;
                open.Size           = new Size(350, 150);
                open.Text           = "Khách hàng: " + row[0].ToString() + "\r\nSDT: " + row[3].ToString();
                open.Font           = new System.Drawing.Font("Microsoft Sans Serif", 15, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
                open.ForeColor      = Color.DodgerBlue;
                open.BackColor      = Color.Navy;
                open.Click         += open_Click;
                open.LostFocus     += open_LostFocus;
                open.Name           = row[1].ToString();
                open.AccessibleName = row[2].ToString();
            }
        }
Exemplo n.º 16
0
        void LoadCBB()
        {
            string s   = "select tenCN from ChiNhanh";
            var    sql = new GetDataFromSQL();
            var    dt  = new DataTable();

            dt = sql.getDataTable(s);
            foreach (DataRow row in dt.Rows)
            {
                comboBox1.Items.Add(row[0].ToString());
            }
        }
Exemplo n.º 17
0
        private void dataGridView3_SelectionChanged(object sender, EventArgs e)
        {
            masoCN = Convert.ToInt32(dataGridView3.CurrentRow.Cells[0].Value);
            tenCN  = Convert.ToString(dataGridView3.CurrentRow.Cells[1].Value);
            var    tableOfCN = new DataTable();
            var    sql       = new GetDataFromSQL();
            string lenh      = "select maBA,tenBA,ghiChu,sucChua from BanAn where maCN= " + masoCN;

            tableOfCN = sql.getDataTable(lenh);
            dataGridView4.DataSource = tableOfCN;
            dataGridView4.ReadOnly   = true;
            textBox3.Text            = "Danh sách bàn chi nhánh: " + tenCN;
        }
Exemplo n.º 18
0
        private void Form7_Load(object sender, EventArgs e)
        {
            DataTable table = new DataTable();
            var       sql   = new GetDataFromSQL();
            string    lenh  = "select SDT from KhachHang";

            table = sql.getDataTable(lenh);
            AutoCompleteStringCollection collection = new AutoCompleteStringCollection();

            foreach (DataRow row in table.Rows)
            {
                collection.Add(row[0].ToString());
            }
            textBox1.AutoCompleteCustomSource = collection;

            DataTable danhmuc = new DataTable();
            string    lenh2   = "select distinct tenDM from DanhMucMonAn dm ";

            danhmuc = sql.getDataTable(lenh2);
            foreach (DataRow row in danhmuc.Rows)
            {
                Button bt = new Button();
                bt.Parent    = flowLayoutPanel1;
                bt.Size      = new Size(180, 55);
                bt.Text      = row[0].ToString();
                bt.ForeColor = Color.DodgerBlue;
                bt.BackColor = Color.SeaShell;
                bt.Font      = new Font(this.Font, FontStyle.Bold);
                bt.Click    += Bt_Click;
            }

            LoadDonHangChuyenXuongCN(); //chinhanh de don hang chuyen xuong
            LoadDGVDuyetDonHang();      //dgv2
            LoadDGVDonHang();           //dgv3
            LoadDGVXemTTDonHang();      //dgv4
            LoadDGVHuyDoi();
            hidetabpage();
        }
Exemplo n.º 19
0
        void LoadDGVChiTietDonHang()
        {
            dataGridView1.Rows.Clear();
            dataGridView1.Refresh();
            var    table = new DataTable();
            string lenh  = "select tenMA from MonAn ma, ChiTietDonHang ctdh where ma.maMA=ctdh.maMA and ctdh.maDonHang='" + maDH + "'";
            var    sql   = new GetDataFromSQL();

            table = sql.getDataTable(lenh);
            foreach (DataRow row in table.Rows)
            {
                dataGridView1.Rows.Add(row[0].ToString());
            }
        }
Exemplo n.º 20
0
        void LoadcbbMonAn(string danhmuc)
        {
            cb_TenMA.Items.Clear();
            var    dtMA  = new DataTable();
            var    sql   = new GetDataFromSQL();
            int    s     = sql.timMaDanhMuc(danhmuc);
            string query = "select distinct tenMA from MonAn ma, DanhMucMonAn dm where ma.danhMuc=" + s;

            dtMA = sql.getDataTable(query);
            foreach (DataRow row in dtMA.Rows)
            {
                cb_TenMA.Items.Add(row["tenMA"]);
            }
        }
Exemplo n.º 21
0
        private void Form1_Load(object sender, EventArgs e)
        {
            var    sql  = new GetDataFromSQL();
            string lenh = "select tenCN from ChiNhanh";

            table = sql.getDataTable(lenh);
            AutoCompleteStringCollection collection = new AutoCompleteStringCollection();

            foreach (DataRow row in table.Rows)
            {
                collection.Add(row[0].ToString());
            }
            textBox1.AutoCompleteCustomSource = collection;
        }
Exemplo n.º 22
0
 private void button4_Click(object sender, EventArgs e)
 {
     if (MessageBox.Show("Bạn có muốn chuyển xuống bếp?", "Thông báo", MessageBoxButtons.YesNo) == System.Windows.Forms.DialogResult.Yes)
     {
         var     sql = new GetDataFromSQL();
         int     i = dataGridView1.RowCount, j = 0;
         decimal tien = 0;
         foreach (DataGridViewRow row in dataGridView1.Rows)
         {
             var    dt       = new DataTable();
             string tenMonAn = row.Cells[0].Value.ToString();
             string timMaMA  = "select maMA from MonAn where tenMA=N'" + tenMonAn + "'";
             dt = sql.getDataTable(timMaMA);
             int maMA = 0;
             foreach (DataRow dtRow in dt.Rows)
             {
                 maMA = Convert.ToInt32(dtRow[0].ToString());
             }
             string lenh = "insert into ChiTietDonHang(maDonHang,maMA) values ('" + Form1.maDH + "','" + maMA + "')";
             if (sql.ExecuteNonQuery(lenh) > 0)
             {
                 j++;
             }
             tien += Convert.ToDecimal(row.Cells[1].Value.ToString());
         }
         if (i == j)
         {
             string s = "update DonHang set maTTDH=2 , giaTriDonHang='" + tien + "' where maDH='" + Form1.maDH + "'";
             sql.ExecuteNonQuery(s);
             string s1 = "update BanAn set tinhTrang=1 where maBA=" + Form1.curTable + " and maCN=" + Form1.maCN;
             if (sql.ExecuteNonQuery(s1) > 0)
             {
                 MessageBox.Show("Đã chuyển xuống bếp");
             }
             var f1 = new Form1();
             this.Close();
             f1.Show();
         }
         else
         {
             MessageBox.Show("Không thể chuyển đơn hàng này xuống bếp!");
         }
     }
     else
     {
         MessageBox.Show("Đã hủy chuyển đơn xuống bếp");
     }
 }
Exemplo n.º 23
0
        //DANH MUC
        private void LoadDGVDanhMuc()
        {
            tb_ghiChu.Clear();
            tb_tenDM.Clear();
            tb_ghiChu.Enabled = false;
            tb_tenDM.Enabled  = false;
            bt_sua.Enabled    = true;
            bt_xoa.Enabled    = true;
            bt_them.Enabled   = true;
            bt_luu.Enabled    = false;

            var sql = new GetDataFromSQL();

            dt = sql.getDataTable("select maDM as 'Mã danh mục', tenDM as 'Tên danh mục', ghiChu as 'Ghi chú'  from DanhMucMonAn");
            dataGridView1.DataSource = dt;
        }
Exemplo n.º 24
0
        private void button1_Click(object sender, EventArgs e)
        {
            var    kh   = new DataTable();
            string lenh = "select SDT,ten,diaChi,email from KhachHang where SDT=N'" + textBox1.Text + "'";
            var    sql  = new GetDataFromSQL();

            kh = sql.getDataTable(lenh);
            foreach (DataRow row in kh.Rows)
            {
                label2.Text = "Tên khách hàng: " + row[1].ToString();
                label2.Name = row[1].ToString();
                label4.Text = "Địa chỉ: " + row[2].ToString();
                label4.Name = row[2].ToString();
                label6.Text = "Email: " + row[3].ToString();
                label6.Name = row[3].ToString();
            }
        }
Exemplo n.º 25
0
        private void Form1_Load(object sender, EventArgs e)
        {
            //Ban An
            //Trong:0
            //Co nguoi: 1
            flowLayoutPanel1.Controls.Clear();
            label1.Text = "Chi nhánh :" + dangnhap.tenCN;
            var    sql  = new GetDataFromSQL();
            string lenh = "select maBA, tenBA, ghiChu, sucChua, tinhTrang, cn.maCN from BanAn ba, ChiNhanh cn where cn.maCN=ba.maCN and cn.tenCN=N'" + tenCN + "'";

            dsBan = sql.getDataTable(lenh);
            foreach (DataRow row in dsBan.Rows)
            {
                maCN = Convert.ToInt32(row[5].ToString());
            }


            foreach (DataRow row in dsBan.Rows)
            {
                Button bt = new Button()
                {
                    Width = 120, Height = 120
                };
                bt.Name      = row[0].ToString();
                bt.Parent    = flowLayoutPanel1;
                bt.Text      = "Bàn " + row[1].ToString();
                bt.BackColor = Color.Lavender;
                bt.ForeColor = Color.Navy;
                bt.Font      = new System.Drawing.Font("Microsoft Sans Serif", 17, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
                var    projectPath = Directory.GetParent(Directory.GetCurrentDirectory()).Parent.FullName;
                string filePath    = Path.Combine(projectPath, "Resources\\Icons8-Ios7-Household-Table.ico");
                bt.Image                 = Image.FromFile(filePath, true);
                bt.ImageAlign            = System.Drawing.ContentAlignment.TopCenter;
                bt.TextAlign             = System.Drawing.ContentAlignment.BottomCenter;
                bt.BackgroundImageLayout = ImageLayout.Center;
                bt.Click                += Bt_Click;
            }
            LoadLabel();


            //hide taskbar and fullscreen
            FormState fm = new FormState();

            fm.Maximize(this);
        }
Exemplo n.º 26
0
        private void Form10_Load(object sender, EventArgs e)
        {
            DataTable danhmuc = new DataTable();
            string    lenh2   = "select distinct tenDM from DanhMucMonAn dm ";

            danhmuc = sql.getDataTable(lenh2);
            foreach (DataRow row in danhmuc.Rows)
            {
                Button bt = new Button();
                bt.Parent    = flowLayoutPanel1;
                bt.Size      = new Size(180, 55);
                bt.Text      = row[0].ToString();
                bt.ForeColor = Color.DodgerBlue;
                bt.BackColor = Color.SeaShell;
                bt.Font      = new Font(this.Font, FontStyle.Bold);
                bt.Click    += Bt_Click;;
            }
        }
Exemplo n.º 27
0
        private void Form11_Load(object sender, EventArgs e)
        {
            string lenh = "select tenCN,diaChi,dienThoai from ChiNhanh";
            var    dt   = new DataTable();
            var    sql  = new GetDataFromSQL();

            dt = sql.getDataTable(lenh);
            foreach (DataRow row in dt.Rows)
            {
                Button lb = new Button();
                lb.Parent    = flowLayoutPanel1;
                lb.Text      = "Chi nhánh " + row[0].ToString() + "\r\nĐịa chỉ: " + row[1].ToString() + "\r\nĐiện thoại " + row[2].ToString();
                lb.ForeColor = Color.DarkGreen;
                lb.BackColor = Color.AliceBlue;
                lb.TextAlign = System.Drawing.ContentAlignment.MiddleLeft;
                lb.Font      = new System.Drawing.Font("Microsoft Sans Serif", 18, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
                lb.Size      = new Size(400, 150);
            }
        }
Exemplo n.º 28
0
 private void button5_Click(object sender, EventArgs e)
 {
     if (MessageBox.Show("Bạn có muốn thanh toán đơn hàng này và in hóa đơn?", "Thanh toán", MessageBoxButtons.YesNo) == System.Windows.Forms.DialogResult.Yes)
     {
         var     sql = new GetDataFromSQL();
         int     i = dataGridView1.RowCount, j = 0;
         decimal tien = 0;
         foreach (DataGridViewRow row in dataGridView1.Rows)
         {
             var    dt       = new DataTable();
             string tenMonAn = row.Cells[0].Value.ToString();
             string timMaMA  = "select maMA from MonAn where tenMA=N'" + tenMonAn + "'";
             dt = sql.getDataTable(timMaMA);
             int maMA = 0;
             foreach (DataRow dtRow in dt.Rows)
             {
                 maMA = Convert.ToInt32(dtRow[0].ToString());
             }
             string lenh = "insert into ChiTietDonHang(maDonHang,maMA) values ('" + Form1.maDH + "','" + maMA + "')";
             if (sql.ExecuteNonQuery(lenh) > 0)
             {
                 j++;
             }
             string rank = "update MonAn set dem=dem+1 where maMA=" + maMA;
             sql.ExecuteNonQuery(rank);
             tien += Convert.ToDecimal(row.Cells[1].Value.ToString());
         }
         if (i == j)
         {
             string s = "update DonHang set maTTDH=4 , giaTriDonHang='" + tien + "' where maDH='" + Form1.maDH + "'";
             sql.ExecuteNonQuery(s);
             MessageBox.Show("Đã thanh toán. Vui lòng chờ in hóa đơn");
             var f1 = new Form1();
             this.Close();
             f1.Show();
         }
         ;
     }
     else
     {
         MessageBox.Show("Đã hủy thanh toán");
     }
 }
Exemplo n.º 29
0
        private void opening_Load(object sender, EventArgs e)
        {
            var       sql  = new GetDataFromSQL();
            DataTable dh   = new DataTable();
            string    lenh = "select ten, dh.maBA, maDH from KhachHang kh, DonHang dh where dh.SDT=kh.SDT and maTTDH=1";

            dh = sql.getDataTable(lenh);
            foreach (DataRow row in dh.Rows)
            {
                Button open = new Button();
                open.Parent     = flowLayoutPanel1;
                open.Size       = new Size(365, 165);
                open.Text       = row[0].ToString() + "\r\n" + row[1].ToString();
                open.Font       = new System.Drawing.Font("Microsoft Sans Serif", 25, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
                open.ForeColor  = Color.DodgerBlue;
                open.BackColor  = Color.Navy;
                open.Click     += open_Click;
                open.LostFocus += open_LostFocus;
                open.Name       = row[1].ToString();
            }
        }
Exemplo n.º 30
0
        void LoadDonHangTuTongDai()
        {
            var    table = new DataTable();
            string lenh  = "select ten, kh.SDT, maDH from KhachHang kh, DonHang dh where dh.SDT = kh.SDT and maTTDH = 7 and dh.maCN=" + Form1.maCN;
            var    sql   = new GetDataFromSQL();

            table = sql.getDataTable(lenh);
            foreach (DataRow row in table.Rows)
            {
                Button bt = new Button();
                bt.Parent         = flowLayoutPanel1;
                bt.Size           = new Size(315, 165);
                bt.Text           = row[0].ToString() + "\r\n" + row[1].ToString();
                bt.Font           = new System.Drawing.Font("Microsoft Sans Serif", 25, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
                bt.ForeColor      = Color.DodgerBlue;
                bt.BackColor      = Color.Navy;
                bt.Click         += Bt_Click;
                bt.LostFocus     += Bt_LostFocus;
                bt.Name           = row[1].ToString();
                bt.AccessibleName = row[2].ToString();
            }
        }