Example #1
0
        void XoaChiTietPhieuMuaHang_TonKho_dtDBMoi(DataTable dtmoi, DataTable dtcu)
        {
            string err = "";

            foreach (DataRow rCu in dtcu.Rows)
            {
                if (KiemTraMaHangHoaTonTaiTrongDB(dtmoi, rCu[2].ToString()) == false)//ko ton tai trong dbmoi
                {
                    //cap nhat tonkho
                    TK.MaHangHoa = rCu[2].ToString();
                    TK.MaKho     = lueKho.EditValue.ToString();
                    TK.SoLuong   = Convert.ToInt32(rCu[3]);
                    bool f = tonKhoBUS.XuatTonKhoBUS(ref err, TK);
                    if (f == true)
                    {
                        MessageBox.Show("xuat ton kho thanh cong, Ma Hang Hoa:" + TK.MaHangHoa + ", Kho:" + TK.MaKho
                                        + ", so luong:" + TK.SoLuong);
                    }
                    // xoa chi tiet phieu
                    CTPMH.MaChiTietPhieu = "1";
                    CTPMH.MaPhieu        = txtMaPhieu.Text;
                    CTPMH.MaHangHoa      = rCu[2].ToString();
                    CTPMH.SoLuong        = Convert.ToInt32(rCu[3]);
                    CTPMH.DonGia         = Convert.ToInt32(rCu[4]);
                    CTPMH.ThanhTien      = Convert.ToInt32(rCu[5]);
                    bool f1 = chiTietPhieuMuaHangBUS.XoaChiTietPhieuMuaHangByMaPhieuMaHangHoaBUS(ref err, CTPMH);
                    if (f1 == true)
                    {
                        MessageBox.Show("xoa thanh cong chi tietphieumuahang, MaPhieu: " + CTPMH.MaPhieu + ", MahangHoa:" + CTPMH.MaHangHoa);
                    }
                }
            }
        }
Example #2
0
        private void btnXoa_Click(object sender, EventArgs e)
        {
            DialogResult result = MessageBox.Show("Bạn có muốn xóa không?",
                                                  "Question",
                                                  MessageBoxButtons.OKCancel, MessageBoxIcon.Question);

            if (result == DialogResult.OK)
            {
                string err = "";
                try
                {
                    bool f        = muaHangBUS.XoaMuaHangBUS(ref err, MH);
                    bool f1       = false;
                    int  demXoaTK = 0;
                    if (f == true)
                    {
                        DataTable dtChiTietPMH = new DataTable();
                        dtChiTietPMH = chiTietPhieuMuaHangBUS.GetAllChiTietPhieuMuaHangByMaPhieuBUS(CTPMH);
                        f1           = chiTietPhieuMuaHangBUS.XoaChiTietPhieuMuaHangByMaPhieuBUS(ref err, CTPMH);
                        MessageBox.Show("Xoa thanh cong muahang");
                        if (f1 == true)
                        {
                            MessageBox.Show("Xoa thanh cong chitietphieumuahang");
                            loadData();
                            foreach (DataRow r in dtChiTietPMH.Rows)
                            {
                                TK.MaHangHoa = r[2].ToString();
                                TK.MaKho     = MH.MaKho;
                                TK.SoLuong   = Convert.ToInt32(r[3]);
                                bool f2 = tonKhoBUS.XuatTonKhoBUS(ref err, TK);
                                if (f2 == true)
                                {
                                    demXoaTK++;
                                }
                            }

                            MessageBox.Show("Xoa thanh cong chitietmuahang, ma phieu:" + CTPMH.MaPhieu);
                        }

                        if (demXoaTK == dtChiTietPMH.Rows.Count)
                        {
                            MessageBox.Show("Xuat thanh cong ton kho,Soluong" + demXoaTK);
                        }
                        loadData();
                    }
                    else
                    {
                        MessageBox.Show("Khong Xoa duoc mua hang. Loi: " + err);
                    }
                }
                catch (SqlException)
                {
                    MessageBox.Show("Khong Xoa duoc. Loi: " + err);
                }
            }
        }
Example #3
0
        private void btnLuu_Click(object sender, EventArgs e)
        {
            string err = "";

            //them mua hang
            BH.MaPhieuBan   = txtMaPhieuBan.Text;
            BH.TenPhieu     = txtTenPhieu.Text;
            BH.NgayLapPhieu = Convert.ToDateTime(deNgayLapPhieu.EditValue);

            BH.MaKieuTT         = lueKieuThanhToan.EditValue.ToString();
            BH.MaHinhThucTT     = lueHinhThucThanhToan.EditValue.ToString();
            BH.MaKhachHang      = lueKhachHang.EditValue.ToString();
            BH.ThoiHanThanhToan = Convert.ToDateTime(deThoiHanThanhToan.EditValue);
            BH.NgayGiaoHang     = Convert.ToDateTime(deNgayGiaoHang.EditValue);
            BH.GhiChu           = txtGhiChu.Text;
            BH.MaNhanVien       = lueNhanVien.EditValue.ToString();
            BH.MaKho            = lueKho.EditValue.ToString();
            BH.TongTien         = Convert.ToDouble(txtTongTien.Text);
            BH.PTramCK          = Convert.ToInt32(txtPhanTramChuyenKhoan.Text);
            BH.Thue             = Convert.ToInt32(txtPhanTramThue.Text);
            BH.TuongDuongTien   = Convert.ToDouble(txtTuongDuongTien.Text);
            BH.TienThanhToan    = Convert.ToDouble(txtTienThanhToan.Text);
            if (txtMaPhieuBan.Text == "" || txtTenPhieu.Text == "" || BH.NgayLapPhieu == Convert.ToDateTime("1/1/0001 12:00:00 AM") ||
                BH.NgayGiaoHang == Convert.ToDateTime("1/1/0001 12:00:00 AM") || BH.ThoiHanThanhToan == Convert.ToDateTime("1/1/0001 12:00:00 AM") ||
                BH.MaHinhThucTT == "" || BH.MaKieuTT == "" || BH.MaKhachHang == "" || BH.MaNhanVien == "" || BH.MaKho == "" || BH.TongTien == 0 || BH.TienThanhToan == 0)
            {
                MessageBox.Show("Bạn chưa nhập đầy đủ thông tin");
            }
            else
            {
                if (themOrSua == 1)
                {
                    try
                    {
                        bool f = banHangBUS.ThemBanHangBUS(ref err, BH);
                        int  demTonKho = 0, demChiTietPMH = 0;
                        if (f == true)
                        {
                            foreach (DataRow r in dt.Rows)
                            {
                                TK.MaHangHoa = r[0].ToString();
                                TK.MaKho     = lueKho.EditValue.ToString();
                                TK.SoLuong   = Convert.ToInt32(r[4]);
                                bool f1 = tonKhoBUS.XuatTonKhoBUS(ref err, TK);

                                CTPBH.MaChiTietPhieuBan = "1";
                                CTPBH.MaPhieuBan        = txtMaPhieuBan.Text;
                                CTPBH.MaHangHoa         = r[0].ToString();
                                CTPBH.SoLuong           = Convert.ToInt32(r[4]);
                                CTPBH.DonGia            = Convert.ToInt32(r[5]);
                                CTPBH.ThanhTien         = Convert.ToInt32(r[6]);
                                bool f2 = chiTietPhieuBanHangBUS.ThemChiTietPhieuBanHangBUS(ref err, CTPBH);
                                if (f1 == true)
                                {
                                    demTonKho++;
                                }
                                if (f2 == true)
                                {
                                    demChiTietPMH++;
                                }
                            }
                            MessageBox.Show("Them thanh cong");
                        }
                        else
                        {
                            MessageBox.Show("Khong them duoc, Loi: " + err);
                        }
                        if (demTonKho == dt.Rows.Count)
                        {
                            MessageBox.Show("Them thanh cong Ton kho: " + demTonKho);
                        }
                        if (demChiTietPMH == dt.Rows.Count)
                        {
                            MessageBox.Show("Them thanh cong Chi tiet phieu mua hang: " + demChiTietPMH);
                        }
                        else
                        {
                            MessageBox.Show("Khong them duoc, so luong them: " + demChiTietPMH);
                        }
                    }
                    catch (SqlException)
                    {
                        MessageBox.Show("Không thêm được. Lỗi: " + err);
                    }
                }
                else
                {
                    try
                    {
                        bool f = banHangBUS.CapNhatBanHangBUS(ref err, BH);
                        if (f == true)
                        {
                            DataTable dtDBCu  = chiTietPhieuBanHangBUS.GetAllChiTietPhieuBanHangByMaPhieuBanBUS(CTPBH);
                            DataTable dtDBMoi = dt;
                            // chay theo dtDBCu
                            SuaChiTietPhieuMuaHang_TonKho_dtDBCu(dtDBMoi, dtDBCu);
                            //ThemChiTietPhieuMuaHang_TonKho_dtDBCu(dtDBMoi,dtDBCu);
                            XoaChiTietPhieuMuaHang_TonKho_dtDBMoi(dtDBMoi, dtDBCu);
                        }
                    }
                    catch (SqlException)
                    {
                        MessageBox.Show("Không thêm được. Lỗi: " + err);
                    }
                }
            }
        }