Exemplo n.º 1
0
        private void HienThiDanhSachSanPham()
        {
            try
            {
                lvSanPham.Items.Clear();
                SanPhamBLL     spBLL = new SanPhamBLL();
                List <SanPham> dssp  = spBLL.LayToanBoSanPham();
                foreach (SanPham sp in dssp)
                {
                    ListViewItem lvi = new ListViewItem(sp.MaSanPham);
                    lvi.SubItems.Add(sp.TenSanPham);
                    lvi.SubItems.Add(sp.DonGia + "");
                    lvi.SubItems.Add(sp.NgayNhap + "");

                    if (sp.NgayBan.Year < sp.NgayNhap.Year)
                    {
                        lvi.SubItems.Add("null");
                    }
                    else
                    {
                        lvi.SubItems.Add(sp.NgayBan + "");
                    }
                    lvi.SubItems.Add(sp.TonKho + "");

                    lvi.Tag = sp;

                    lvSanPham.Items.Add(lvi);
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show("Lỗi Khi lấy toàn bộ sản phẩm.\nChi tiết lỗi:\n" + ex.Message);
            }
        }
Exemplo n.º 2
0
        private void btnDelete_Click(object sender, EventArgs e)
        {
            try
            {
                if (lvSanPham.SelectedItems.Count == 0)
                {
                    return;
                }
                SanPham curSP = lvSanPham.SelectedItems[0].Tag as SanPham;

                DialogResult ret = MessageBox.Show(
                    "Bạn muốn xóa sản phẩm này?",
                    "Question",
                    MessageBoxButtons.YesNo,
                    MessageBoxIcon.Question);
                if (ret == DialogResult.No)
                {
                    return;
                }

                SanPhamBLL spBLL = new SanPhamBLL();
                spBLL.XoaSanPham(curSP.MaSanPham);
                MessageBox.Show("Xóa sản phẩm thành công.");
                HienThiDanhSachSanPham();
            }
            catch (Exception ex)
            {
                MessageBox.Show("Lỗi xóa sản phẩm.\nChi tiết lỗi:\n" + ex.Message);
            }
        }
        public JsonResult LayDS(string ngay)
        {
            RMessage message = new RMessage {
                code = Resources.Global.Message_Error, success = false
            };
            List <ThongTinSanPhamVayModel> rs = new List <ThongTinSanPhamVayModel>();

            try
            {
                DateTime dtDate = DateTime.MinValue;
                if (ngay != "")
                {
                    dtDate = DateTimeFormat.ConvertddMMyyyyToDateTime(ngay);
                }
                rs = new SanPhamBLL().LayThongTinSanPhamByID(3, dtDate);
                if (rs == null)
                {
                    rs = new List <ThongTinSanPhamVayModel>();
                }
            }
            catch (BusinessException ex)
            {
                message.success = false;
                message.code    = ex.Message;
            }
            return(Json(rs, JsonRequestBehavior.AllowGet));
        }
Exemplo n.º 4
0
        private void cboLoaiHang_SelectedIndexChanged(object sender, EventArgs e)
        {
            txtMaSanPham.Text = "";
            if (cboLoaiHang.SelectedIndex == -1)
            {
                return;
            }
            try
            {
                LoaiHang   lh    = cboLoaiHang.SelectedItem as LoaiHang;
                SanPhamBLL spBLL = new SanPhamBLL();
                int        soLuongSanPhamCuaMaSinh = spBLL.ValidMaSanPhamToAdd(lh.MaSanPhamTuSinh);
                txtMaSanPham.Text = lh.MaSanPhamTuSinh + soLuongSanPhamCuaMaSinh;
                txtTenSanPham.Focus();

                //current san pham
                currentSanPham = new SanPham()
                {
                    MaLoaiHang = lh.MaLoaiHang,
                    MaSanPham  = txtMaSanPham.Text
                };
            }
            catch (Exception ex)
            {
                MessageBox.Show("Lỗi sản phẩm Lấy valid mã sinh\n" + ex.Message);
            }
        }
Exemplo n.º 5
0
        private void btnThemSanPham_Click(object sender, EventArgs e)
        {
            if (!ShowError())
            {
                return;
            }
            try
            {
                currentSanPham.TenSanPham = txtTenSanPham.Text;
                currentSanPham.DonGia     = int.Parse(txtDonGia.Text);
                currentSanPham.TonKho     = int.Parse(txtTonKho.Text);
                currentSanPham.NgayNhap   = dtpNgayNhap.Value;
                currentSanPham.GhiChu     = txtGhiChu.Text;

                //insert new sanpham to database
                SanPhamBLL spBLL = new SanPhamBLL();
                spBLL.ThemSanPham(currentSanPham);
                MessageBox.Show("Thêm sản phẩm thành công.");
                HienThiDanhSachSanPham();
            }
            catch (Exception ex)
            {
                MessageBox.Show("Lỗi thêm sản phẩm.\nChi tiết lỗi:\n" + ex.Message);
            }
        }
Exemplo n.º 6
0
 public frmNhapHang(Form f)
 {
     spbll  = new SanPhamBLL();
     khbll  = new KhoHangBLL();
     ds     = new DataSet();
     this.f = f;
     InitializeComponent();
 }
Exemplo n.º 7
0
 private void HienThiDGVSP()
 {
     _SPBLL = new SanPhamBLL();
     dgvSanPham.DataSource = _SPBLL.LayTatCaSanPham();
     dgvSanPham.Columns["MaSP"].HeaderText="Mã SP";
     dgvSanPham.Columns["TenSP"].HeaderText = "Tên SP";
     dgvSanPham.Columns["DacTa"].HeaderText = "Đặc tả";
     dgvSanPham.Columns["DonViTinh"].HeaderText = "Đơn vị tính";
     dgvSanPham.Columns["SoLuongNhap"].HeaderText = "Tồn kho";
 }
 public frmXuatHang(Form f)
 {
     spbll        = new SanPhamBLL();
     ds           = new DataSet();
     dsspid       = new DataSet();
     dskh         = new DataSet();
     khachhangbll = new KhachHangBLL();
     hoadonBLL    = new HoaDonBLL();
     this.f       = f;
     InitializeComponent();
 }
Exemplo n.º 9
0
        private void btnSua_Click(object sender, EventArgs e)
        {
            if (!ShowError())
            {
                return;
            }
            try
            {
                if (lvSanPham.SelectedItems.Count == 0)
                {
                    return;
                }
                SanPham    curSP = lvSanPham.SelectedItems[0].Tag as SanPham;
                SanPhamBLL spBLL = new SanPhamBLL();

                curSP.TenSanPham = txtTenSanPham.Text;
                curSP.DonGia     = int.Parse(txtDonGia.Text);
                curSP.TonKho     = int.Parse(txtTonKho.Text);
                curSP.NgayNhap   = dtpNgayNhap.Value;
                curSP.GhiChu     = txtGhiChu.Text;


                // cboLoaiHang_SelectedIndexChanged
                // current sanpham now exist
                if (currentSanPham.MaLoaiHang != curSP.MaLoaiHang)
                {
                    //another elements
                    currentSanPham.TenSanPham = txtTenSanPham.Text;
                    currentSanPham.DonGia     = int.Parse(txtDonGia.Text);
                    currentSanPham.TonKho     = int.Parse(txtTonKho.Text);
                    currentSanPham.NgayNhap   = dtpNgayNhap.Value;
                    currentSanPham.GhiChu     = txtGhiChu.Text;

                    //delete the old
                    spBLL.XoaSanPham(curSP.MaSanPham);
                    //insert the new
                    spBLL.ThemSanPham(currentSanPham);
                }
                else
                {
                    spBLL.SuaSanPham(curSP);
                }

                MessageBox.Show("Sửa sản phẩm thành công.");
                HienThiDanhSachSanPham();
            }
            catch (Exception ex)
            {
                MessageBox.Show("Lỗi sửa sản phẩm.\nChi tiết lỗi:\n" + ex.Message);
            }
        }
Exemplo n.º 10
0
        public ActionResult Xoa(int id)
        {
            try
            {
                bool result = false;
                result = new SanPhamBLL().Xoa(id);

                return(ToResponse(result));
            }
            catch (BusinessException ex)
            {
                return(ToResponse(false, ex.Message));
            }
        }
Exemplo n.º 11
0
 public void Tim()
 {
     Console.Clear();
     ISanPhamBLL Sanpham = new SanPhamBLL();
     List<Sanpham> list = Sanpham.TimSanPham(new Sanpham());
     string masanpham1;
     Console.Write("Nhap ma san pham can tim:");
     masanpham1 = Console.ReadLine();
     for (int i = 0; i < list.Count; ++i)
     {
         if (masanpham1 == list[i].Masp)
             Console.WriteLine(list[i].Masp + "\t" + list[i].Tensp + "\t" + list[i].Maloai + "\t" + list[i].Soluong + "\t" + list[i].Giaban + "\t" + list[i].Nhasx);
     }
 }
Exemplo n.º 12
0
 /// <summary>
 /// hien thi dsSP cua loai hang vua chon len comboboxSanPham
 /// </summary>
 /// <param name="lh"></param>
 private void HienThiSanPham(LoaiHang lh)
 {
     cboTenSanPham.Items.Clear();
     try
     {
         SanPhamBLL     spBLL = new SanPhamBLL();
         List <SanPham> dsSP  = spBLL.LaySanPhamTheoMaLoaiHang(lh.MaLoaiHang);
         foreach (SanPham sp in dsSP)
         {
             cboTenSanPham.Items.Add(sp);
         }
     }
     catch (Exception ex)
     {
         MessageBox.Show("Lỗi hiển thị sản phẩm:\n" + ex.Message);
     }
 }
Exemplo n.º 13
0
        public ActionResult ThemMoi(string ma, string ngay)
        {
            try
            {
                if (new SanPhamBLL().Trung(ma) == true)
                {
                    return(ToResponse(false, "Mã sản phẩm bị trùng!", 0));
                }
                else
                {
                    DateTime dtDate = DateTime.MinValue;
                    try
                    {
                        if (ngay != "")
                        {
                            dtDate = DateTimeFormat.ConvertddMMyyyyToDateTime(ngay);
                        }
                    }
                    catch (Exception)
                    {
                        return(ToResponse(false, "Ngày không đúng định dạng!", 0));
                    }

                    int             result = 0;
                    SanPhamVayModel sp     = new SanPhamVayModel();
                    sp.Ma         = ma;
                    sp.Ten        = ma;
                    sp.MaNguoiTao = GlobalData.User.IDUser;
                    sp.NgayTao    = dtDate;
                    sp.MaDoiTac   = 3;
                    sp.Loai       = 1;
                    result        = new SanPhamBLL().Them(sp);
                    if (result > 0)
                    {
                        return(ToResponse(true, Resources.Global.Message_Succ, result));
                    }
                    return(ToResponse(false, "Không thành công", 0));
                }
            }
            catch (BusinessException ex)
            {
                return(ToResponse(false, ex.Message));
            }
        }
Exemplo n.º 14
0
 private void DemSoSanPham()
 {
     _SPBLL = new SanPhamBLL();
     dem = _SPBLL.DemTatCaSanPham();
 }
 public frmChiTietSP()
 {
     bll = new SanPhamBLL();
     InitializeComponent();
 }
 public frmBaoHanh()
 {
     spBLL = new SanPhamBLL();
     InitializeComponent();
 }
 public frmMaMoi()
 {
     ofdOpenFile = new OpenFileDialog();
     InitializeComponent();
     bll = new SanPhamBLL();
 }
Exemplo n.º 18
0
        public JsonResult LayDSSanPhamByHS(int maDoiTac, int maHS)
        {
            List <SanPhamModel> rs = new SanPhamBLL().LaySanPhamByID(maDoiTac, maHS);

            return(ToJsonResponse(true, null, rs));
        }
Exemplo n.º 19
0
        private void HienThiDGVSanPhamBan()
        {
            _SPBLL = new SanPhamBLL();
            dgvSanPham.DataSource = _SPBLL.HienThiChiTietSanPhamBan();
            dgvSanPham.Columns["MaHD"].Visible = false;
            dgvSanPham.Columns["MaNV"].Visible = false;
            //dgvSanPham.Columns["CuocPhiVanChuyen"].Visible = false;

            dgvSanPham.Columns["MaSP"].HeaderText = "Mã SP";
            dgvSanPham.Columns["TenSP"].HeaderText = "Tên SP";
            dgvSanPham.Columns["DonGiaBan"].HeaderText = "Đơn giá";
            dgvSanPham.Columns["SoLuongNhap"].HeaderText = "Tồn kho";
            dgvSanPham.Columns["DonViTinh"].HeaderText = "Đơn vị tính";
            dgvSanPham.Columns["DacTa"].HeaderText = "Đặc tả";
            dgvSanPham.Columns["DonViTinh"].Width = 120;
            dgvSanPham.Columns["TenSP"].Width = 120;

            dgvChiTietHD.Columns["CuocPhiVanChuyen"].Visible = false;
            LayMaHoaDonHienTai();
        }
 DataTable dssp      = new DataTable();//table chứa danh sách sản phẩm
 public frmQuanLiSanPham(Form f)
 {
     this.f = f;
     InitializeComponent();
     bll = new SanPhamBLL();
 }