Пример #1
0
        public frmThemHangHoa()
        {
            InitializeComponent();

            txtMaHang.Text = HangHoaBUS.LayMaHH();
            txtMaVach.Text = HangHoaBUS.LayMaHH();

            gridlookupPhanLoaiHangHoa.Properties.DataSource    = PhanLoaiHangHoaBUS.DanhSach();
            gridlookupPhanLoaiHangHoa.Properties.DisplayMember = "TenPhanLoai";
            gridlookupPhanLoaiHangHoa.Properties.ValueMember   = "MaPhanLoai";

            gridlookupKho.Properties.DataSource    = KhoHangBUS.DanhSach();
            gridlookupKho.Properties.DisplayMember = "Ten";
            gridlookupKho.Properties.ValueMember   = "MaKho";

            gridlookupLoaiHangHoa.Properties.DataSource    = NhomHangBUS.DanhSach();
            gridlookupLoaiHangHoa.Properties.DisplayMember = "Ten";
            gridlookupLoaiHangHoa.Properties.ValueMember   = "MaNHH";

            gridlookupNCC.Properties.DataSource    = NhaCungCapBUS.DanhSach();
            gridlookupNCC.Properties.DisplayMember = "TenNCC";
            gridlookupNCC.Properties.ValueMember   = "MaNCC";

            gridlookupDonVi.Properties.DataSource    = DonViBUS.DanhSach();
            gridlookupDonVi.Properties.DisplayMember = "Ten";
            gridlookupDonVi.Properties.ValueMember   = "MaDV";
        }
Пример #2
0
 private void LoadGridHangHoa()
 {
     gridHangHoa.DataSource = HangHoaBUS.LayToanBoHangHoa();
     repositoryItemLookUpEdit1.DataSource    = HangHoaBUS.LayToanBoHangHoa();
     repositoryItemLookUpEdit1.DisplayMember = "TenHangHoa";
     repositoryItemLookUpEdit1.ValueMember   = "MaHangHoa";
 }
Пример #3
0
 public FormHangHoa()
 {
     InitializeComponent();
     themOrSua  = 1;
     hangHoaBUS = new HangHoaBUS();
     initBUS();
 }
Пример #4
0
        private void dataGridView1_SelectionChanged(object sender, EventArgs e)
        {
            if (!dataGridView1.Focused)
            {
                dataGridView1.ClearSelection();
                tabNoHeader1.Visible = false;
                return;
            }

            if (tabNoHeader1.Visible && tabNoHeader1.SelectedIndex == 1)
            {
                return;
            }

            foreach (Control c in tabThem.Controls)
            {
                errorProvider1.SetError(c, string.Empty);
            }

            tabNoHeader1.SelectedIndex = 0;
            tabNoHeader1.Visible       = true;
            btnThem.Text = @"Sửa";

            using (HangHoaBUS bus = new HangHoaBUS())
            {
                string     tennhanghoa = dataGridView1.CurrentRow?.Cells[0].Value.ToString();
                HangHoaDTO info        = bus.LoadHangHoa(tennhanghoa);
                txtTenHangHoa.Text = info.TenHangHoa;
                txtGiaBan.Text     = info.GiaBan.ToString();
                txtDonViTinh.Text  = info.DonViTinh;
                txtSoLuongTon.Text = info.SoLuongTon.ToString();
                txtGhiChu.Text     = info.GhiChu;
            }
        }
Пример #5
0
        public void btnXoa_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
        {
            int[] l = GridView1.GetSelectedRows();

            var index = l[0];

            switch (MessageBox.Show("Bạn có chắc chắn muốn xóa hàng hóa này không?", "Hỏi Xóa", MessageBoxButtons.YesNo, MessageBoxIcon.Question))
            {
            case DialogResult.Yes:
                HangHoaDTO hh = default(HangHoaDTO);
                hh = ((List <HangHoaDTO>)gridHangHoa.DataSource)[index];
                bool test = HangHoaBUS.XoaKhoHang(hh);

                if (test == true)
                {
                    LoadGridHangHoa();
                    Log_BUS.ThemNhatKy("Hàng hóa", "Xóa hàng hoá");
                    MessageBox.Show("Xóa thành công");
                }
                else
                {
                    MessageBox.Show("Xóa không thành công");
                }
                break;

            case DialogResult.No:
                return;
            }
        }
Пример #6
0
 public Form2()
 {
     InitializeComponent();
     this.HangHoaBUS = HangHoaBUSImpl.Instance;
     fillcomboboxTenKH();
     fillcomboboxTenSP();
 }
Пример #7
0
        private void simpleButton1_Click(object sender, EventArgs e)
        {
            frmThemHangHoa frm = new frmThemHangHoa();

            frm.ShowDialog();
            gridControl1.DataSource = HangHoaBUS.DanhSach();
        }
Пример #8
0
        public void GetData(string MaHang)
        {
            HangHoa h = HangHoaBUS.LayChiTiet(MaHang);

            txtMaHang.Text                      = h.MaHang;
            txtTenHang.Text                     = h.TenHang;
            txtGiaBanLe.Text                    = h.GiaBanLe.ToString();
            txtGiaBanSi.Text                    = h.GiaBanSi.ToString();
            txtGiaMua.Text                      = h.GiaMua.ToString();
            txtMaVach.Text                      = h.MaVachNSX;
            txtTonHienTai.Text                  = h.TonHienTai.ToString();
            txtTonKhoToiThieu.Text              = h.TonKhoToiThieu.ToString();
            txtXuatXu.Text                      = h.XuatXu;
            gridlookupKho.EditValue             = h.MaKho;
            gridlookupLoaiHangHoa.EditValue     = h.MaLoaiHangHoa;
            gridlookupNCC.EditValue             = h.MaNCC;
            gridlookupPhanLoaiHangHoa.EditValue = h.MaPhanLoai;
            gridlookupDonVi.EditValue           = h.MaDV;
            if (h.ConQuanLy == true)
            {
                checkBox1.Checked = true;
            }
            else
            {
                checkBox1.Checked = false;
            }
        }
Пример #9
0
        private void listBox1_DoubleClick(object sender, EventArgs e)
        {
            if (listBox1.SelectedItem.ToString() == "  Trực tiếp")
            {
                busHangHoa = new HangHoaBUS();
                List <DonHang_HopDong_DTO> lshh2 = busHangHoa.selectDonHang_CaNhan();
                Load_Datagridview1(lshh2);
                dataGridView1.Columns["TRANGTHAI"].Visible = false;
            }
            else if (listBox1.SelectedItem.ToString() == "  Hợp đồng")
            {
                busHangHoa = new HangHoaBUS();
                List <DonHang_HopDong_DTO> lshh2 = busHangHoa.selectDonHang();
                Load_Datagridview1(lshh2);
                dataGridView1.Columns["TRANGTHAI"].Visible = false;
            }
            else
            {
                busHangHoa = new HangHoaBUS();
                List <DonHang_HopDong_DTO> lshh  = busHangHoa.selectDonHang();
                List <DonHang_HopDong_DTO> lshh2 = busHangHoa.selectDonHang_CaNhan();
                lshh.AddRange(lshh2);

                Load_Datagridview1(lshh);
                dataGridView1.Columns["TRANGTHAI"].Visible = false;
            }
        }
        //Hàng hóa
        void LoadDsHangHoa()
        {
            HangHoaBUS hangBUS = new HangHoaBUS();

            dtgvHangHoa.AutoGenerateColumns = false;
            dtgvHangHoa.DataSource          = hangBUS.LoadDsHH();
        }
Пример #11
0
        private void QuanLyBan_Load(object sender, EventArgs e)
        {
            using (HangHoaBUS bus = new HangHoaBUS())
                dataGridView2.DataSource = bus.ListHangHoa2();

            using (KhuVucBUS bus = new KhuVucBUS())
            {
                foreach (DataRow row in bus.ListKhuVuc().Rows)
                {
                    var group = new ListViewGroup(row["TenKhuVuc"].ToString());
                    listView1.Groups.Add(group);

                    foreach (DataRow r in bus.ListBan(row["TenKhuVuc"].ToString()).Rows)
                    {
                        listView1.Items.Add(new ListViewItem(r["TenBan"].ToString(),
                                                             bus.IsAvailable(r["MaSoBan"].ToString()) ? 0 : 1, group)).Tag = r["MaSoBan"];
                    }

                    listView1.Items[0].Selected = true;
                }
            }

            using (QuanLyBanBUS bus = new QuanLyBanBUS())
                txtSoHoaDon.Text = bus.GetSoHoaDon().ToString();
        }
        private void btnThem_Click(object sender, EventArgs e)
        {
            HangHoaBUS   hhBUS = new HangHoaBUS();
            string       tenhh = hhBUS.LoadTenhhTheoMaHH((int)cboTenHangHoa.SelectedValue);
            ListViewItem lvi   = new ListViewItem(tenhh);

            lvi.SubItems.Add(nmrSoLuong.Value.ToString());
            lvi.SubItems.Add(((int)cboTenHangHoa.SelectedValue).ToString());

            if (lvwChiTietDDh.Items.Count != 0)
            {
                bool flag = true;
                foreach (ListViewItem item in lvwChiTietDDh.Items)
                {
                    if (item.SubItems[2].Text == ((int)cboTenHangHoa.SelectedValue).ToString())
                    {
                        MessageBox.Show("Hàng hóa đã được thêm gòi nha đừng thêm nữa, ahihi!", "Nhắc nhẹ", MessageBoxButtons.OK, MessageBoxIcon.Information);
                        flag = false;
                    }
                }
                if (flag == true)
                {
                    lvwChiTietDDh.Items.Add(lvi);
                }
            }
            else
            {
                lvwChiTietDDh.Items.Add(lvi);
            }
        }
Пример #13
0
        private void simpleButton3_Click(object sender, EventArgs e)
        {
            int    vitri  = gridView1.GetFocusedDataSourceRowIndex();
            string MaHang = gridView1.GetRowCellValue(vitri, "MaHang").ToString();

            HangHoaBUS.Xoa(MaHang);
            gridControl1.DataSource = HangHoaBUS.DanhSach();
        }
        void LoadComboboxTenHH()
        {
            HangHoaBUS hhBUS = new HangHoaBUS();

            cboTenHangHoa.DataSource    = hhBUS.LoadDsHH();
            cboTenHangHoa.DisplayMember = "Tenhh";
            cboTenHangHoa.ValueMember   = "Mahh";
        }
Пример #15
0
 void initBUS()
 {
     hangHoaBUS    = new HangHoaBUS();
     khoBUS        = new KhoBUS();
     nhomHangBUS   = new NhomHangBUS();
     donViBUS      = new DonViBUS();
     nhaCungCapBUS = new NhaCungCapBUS();
     HH            = new HangHoaO();
 }
Пример #16
0
        public void QuanLyDonHang_Load(object sender, EventArgs e)
        {
            busHangHoa = new HangHoaBUS();
            List <DonHang_HopDong_DTO> lshh  = busHangHoa.selectDonHang();
            List <DonHang_HopDong_DTO> lshh2 = busHangHoa.selectDonHang_CaNhan();

            lshh.AddRange(lshh2);
            Load_Datagridview1(lshh);
        }
Пример #17
0
        private void AddProduct_Load(object sender, EventArgs e)
        {
            hhbus = new HangHoaBUS();
            List <HangHoaDTO> lshh = hhbus.selectAvailable();

            Load_Datagridview1(lshh);
            dataGridView1.Columns["MANHASANXUAT"].Visible    = false;
            dataGridView1.Columns["MALOAIHANG"].Visible      = false;
            dataGridView1.Columns["THOIGIANBAOHANH"].Visible = false;
        }
Пример #18
0
 public frmBill()
 {
     InitializeComponent();
     hdBUS   = new HoaDonBUS();
     htttBUS = new HinhThucThanhToanBUS();
     dvmhBUS = new DonViMuaHangBUS();
     nvbBUS  = new NhanVienBanBUS();
     hhBUS   = new HangHoaBUS();
     nmBUS   = new NguoiMuaBUS();
     cthdBUS = new CTHoaDonBUS();
 }
Пример #19
0
 private void FormProduct_Load(object sender, EventArgs e)
 {
     hangHoaBUS = new HangHoaBUS();
     dataTable  = new DataTable();
     dataTable.Columns.Add(new DataColumn("MaHang"));
     dataTable.Columns.Add(new DataColumn("TenHang"));
     dataTable.Columns.Add(new DataColumn("NoiChua"));
     dataTable.Columns.Add(new DataColumn("SoLuongBan"));
     dataTable.Columns.Add(new DataColumn("GiaHang"));
     GetAllToGridView();
 }
Пример #20
0
        private void simpleButton2_Click(object sender, EventArgs e)
        {
            int           vitri  = gridView1.GetFocusedDataSourceRowIndex();
            string        MaHang = gridView1.GetRowCellValue(vitri, "MaHang").ToString();
            frmSuaHangHoa frm    = new frmSuaHangHoa();
            SendData      s      = new SendData(frm.GetData);

            s(MaHang);
            frm.ShowDialog();
            gridControl1.DataSource = HangHoaBUS.DanhSach();
        }
Пример #21
0
        private void BaoGiaTrucTiep_Load(object sender, EventArgs e)
        {
            hhbus = new HangHoaBUS();

            List <HangHoaDTO> lshh = hhbus.select();

            this.Load_Datagridview(lshh);
            dataGridView1.Columns["TEN"].Visible = false;
            // dataGridView1.Columns["MANHASANXUAT"].Visible = false;
            //dataGridView1.Columns["MALOAIHANG"].Visible = false;
            dataGridView1.Columns["SOLUONG"].Visible = false;
        }
        private void LoadGridHangHoa()
        {
            LoadCotDonVi();
            LoadCotLoaiHang();
            LoadCotPhanLoai();
            gridHangHoa.DataSource = HangHoaBUS.LayToanBoHangHoa();

            //ẩn một số cột không cần đùng
            gridHangHoa.Columns["KhoMacDinh"].Visible = false;
            gridHangHoa.Columns["XuatXu"].Visible     = false;
            gridHangHoa.Columns["NhaCungCap"].Visible = false;
        }
Пример #23
0
        private void xoa_btn_Click(object sender, EventArgs e)
        {
            dtoHangHoaDat.MAHANGHOADAT = busHangHoa.selectMaHangHoaDat(dtoDonHang);
            busHangHoa.xoaDonHang(dtoHangHoaDat);
            xoa_btn.Enabled = false;

            busHangHoa = new HangHoaBUS();
            List <DonHang_HopDong_DTO> lshh  = busHangHoa.selectDonHang();
            List <DonHang_HopDong_DTO> lshh2 = busHangHoa.selectDonHang_CaNhan();

            lshh.AddRange(lshh2);
            Load_Datagridview1(lshh);
            dataGridView1.Columns["TRANGTHAI"].Visible = false;
        }
Пример #24
0
        private void btnThem_Click(object sender, EventArgs e)
        {
            foreach (var c in from MaterialSingleLineTextField c in tabThem.Controls.OfType <MaterialSingleLineTextField>() where c != txtGhiChu select c)
            {
                errorProvider1.SetError(c, string.IsNullOrWhiteSpace(c.Text) ? "Bạn không được để trống thông tin này" : string.Empty);
            }

            if (tabThem.Controls.OfType <MaterialSingleLineTextField>().Any(c => errorProvider1.GetError(c) != string.Empty))
            {
                return;
            }

            try
            {
                using (HangHoaBUS bus = new HangHoaBUS())
                {
                    HangHoaDTO info = new HangHoaDTO
                    {
                        TenHangHoa = txtTenHangHoa.Text,
                        GiaBan     = Convert.ToInt32(txtGiaBan.Text),
                        DonViTinh  = txtDonViTinh.Text,
                        SoLuongTon = Convert.ToInt32(txtSoLuongTon.Text),
                        GhiChu     = txtGhiChu.Text
                    };

                    if (dataGridView1.SelectedRows.Count == 0)
                    {
                        bus.InsertHangHoa(info);
                    }
                    else
                    {
                        string tenhanghoa = dataGridView1.SelectedRows[0].Cells[0].Value.ToString();
                        bus.EditHangHoa(info, tenhanghoa);
                    }
                }
            }
            catch (SqlException ex)
            {
                if (ex.Number == DbConnection.MssqlEng002627)
                {
                    errorProvider1.SetError(txtTenHangHoa, "Hàng hóa đã tồn tại");
                }
                else
                {
                    throw;
                }
            }

            RefreshHangHoa();
        }
Пример #25
0
 void initObjectBUS()
 {
     CK                  = new ChuyenKhoO();
     CTCK                = new ChiTietChuyenKhoO();
     HH                  = new HangHoaO();
     DV                  = new DonViO();
     TK                  = new TonKhoO();
     chuyenKhoBUS        = new ChuyenKhoBUS();
     chiTietChuyenKhoBUS = new ChiTietChuyenKhoBUS();
     nhanVienBUS         = new NhanVienBUS();
     khoBUS              = new KhoBUS();
     hangHoaBUS          = new HangHoaBUS();
     donViBUS            = new DonViBUS();
     tonKhoBUS           = new TonKhoBUS();
 }
Пример #26
0
        private void XoaHangHoa()
        {
            DialogResult hopThoai = MessageBox.Show("Bạn chắc chắn muốn xóa những dòng bạn chọn?", "Xóa", MessageBoxButtons.YesNo, MessageBoxIcon.Question);

            if (hopThoai == DialogResult.Yes)
            {
                HangHoaBUS itemBUS = new HangHoaBUS();
                for (int i = 0; i < gvDanhMucHangHoa.SelectedRowsCount; i++)
                {
                    int ma = int.Parse(gvDanhMucHangHoa.GetRowCellValue(gvDanhMucHangHoa.GetSelectedRows()[i], gvDanhMucHangHoa.Columns["Id"]).ToString());
                    itemBUS.Xoa(ma);
                }
            }
            this.LayDanhSachHangHoa();
        }
 private void btnThem_Click(object sender, EventArgs e)
 {
     if (txtGia.Text == "")
     {
         MessageBox.Show("Bạn chưa nhập giá", "Nhắc nhẹ", MessageBoxButtons.OK, MessageBoxIcon.Information);
     }
     else if (!IsNumber(txtGia.Text))
     {
         MessageBox.Show("Nhập giá chưa đúng định dạng, giá phải là số (số nguyên hoặc số thực)", "Nhắc nhẹ", MessageBoxButtons.OK, MessageBoxIcon.Information);
     }
     else
     {
         HangHoaBUS   hhBUS = new HangHoaBUS();
         string       tenhh = hhBUS.LoadTenhhTheoMaHH((int)cmbTenHangHoa.SelectedValue);
         ListViewItem lvi   = new ListViewItem(tenhh);
         lvi.SubItems.Add(nmrSoLuong.Value.ToString());
         lvi.SubItems.Add(txtGia.Text);
         double thanhTien = Convert.ToDouble(nmrSoLuong.Value.ToString()) * Convert.ToDouble(txtGia.Text);
         lvi.SubItems.Add(thanhTien.ToString());
         lvi.SubItems.Add(((int)cmbTenHangHoa.SelectedValue).ToString());
         if (lvwChiTietPhieuNhap.Items.Count != 0)
         {
             bool flag = true;
             foreach (ListViewItem item in lvwChiTietPhieuNhap.Items)
             {
                 if (item.SubItems[3].Text == ((int)cmbTenHangHoa.SelectedValue).ToString())
                 {
                     MessageBox.Show("Hàng hóa đã được thêm gòi nha đừng thêm nữa, ahihi!", "Nhắc nhẹ", MessageBoxButtons.OK, MessageBoxIcon.Information);
                     flag = false;
                 }
             }
             if (flag == true)
             {
                 lvwChiTietPhieuNhap.Items.Add(lvi);
             }
         }
         else
         {
             lvwChiTietPhieuNhap.Items.Add(lvi);
         }
     }
 }
Пример #28
0
 private void btnThem_Click(object sender, EventArgs e)
 {
     if (txtGia.Text == "")
     {
         MessageBox.Show(Instance.TBChuaNhapGia, Instance.CanhBao, MessageBoxButtons.OK, MessageBoxIcon.Information);
     }
     else if (!IsNumber(txtGia.Text))
     {
         MessageBox.Show(Instance.TBNhapGiaChuaDungDinhDang, Instance.CanhBao, MessageBoxButtons.OK, MessageBoxIcon.Information);
     }
     else
     {
         HangHoaBUS   hhBUS = new HangHoaBUS();
         string       tenhh = hhBUS.LoadTenhhTheoMaHH((int)cmbTenHangHoa.SelectedValue);
         ListViewItem lvi   = new ListViewItem(tenhh);
         lvi.SubItems.Add(nmrSoLuong.Value.ToString());
         lvi.SubItems.Add(txtGia.Text);
         double thanhTien = Convert.ToDouble(nmrSoLuong.Value.ToString()) * Convert.ToDouble(txtGia.Text);
         lvi.SubItems.Add(thanhTien.ToString());
         lvi.SubItems.Add(((int)cmbTenHangHoa.SelectedValue).ToString());
         if (lvwChiTietPhieuNhap.Items.Count != 0)
         {
             bool flag = true;
             foreach (ListViewItem item in lvwChiTietPhieuNhap.Items)
             {
                 if (item.SubItems[4].Text == ((int)cmbTenHangHoa.SelectedValue).ToString())
                 {
                     MessageBox.Show(Instance.TBHHDaTonTai, Instance.CanhBao, MessageBoxButtons.OK, MessageBoxIcon.Information);
                     flag = false;
                 }
             }
             if (flag == true)
             {
                 lvwChiTietPhieuNhap.Items.Add(lvi);
             }
         }
         else
         {
             lvwChiTietPhieuNhap.Items.Add(lvi);
         }
     }
 }
Пример #29
0
        void initObjectBUS()
        {
            MH                     = new MuaHangO();
            NCC                    = new NhaCungCapO();
            HH                     = new HangHoaO();
            DV                     = new DonViO();
            CTPMH                  = new ChiTietPhieuMuaHangO();
            TK                     = new TonKhoO();
            muaHangBUS             = new MuaHangBUS();
            nhaCungCapBUS          = new NhaCungCapBUS();
            nhanVienBUS            = new NhanVienBUS();
            khoBUS                 = new KhoBUS();
            hangHoaBUS             = new HangHoaBUS();
            donViBUS               = new DonViBUS();
            tonKhoBUS              = new TonKhoBUS();
            chiTietPhieuMuaHangBUS = new ChiTietPhieuMuaHangBUS();

            kieuThanhToanBUS     = new KieuThanhToanBUS();
            hinhThucThanhToanBUS = new HinhThucThanhToanBUS();
        }
Пример #30
0
        private void btnXoa_Click(object sender, EventArgs e)
        {
            if (dataGridView1.CurrentRow == null)
            {
                return;
            }

            using (HangHoaBUS bus = new HangHoaBUS())
            {
                if (new XacNhan {
                    Text = @"Bạn có chắc chắn muốn xóa hàng hóa " + dataGridView1.CurrentRow.Cells[0].Value
                }.ShowDialog() == DialogResult.Yes)
                {
                    string tenhanghoa = dataGridView1.CurrentRow.Cells[0].Value.ToString();
                    bus.DeleteHangHoa(tenhanghoa);
                }
            }

            RefreshHangHoa();
        }