void ThemChiTietPhieuMuaHang_TonKho_dtDBCu(DataTable dtmoi, DataTable dtcu) { string err = ""; foreach (DataRow rMoi in dtmoi.Rows) { if (KiemTraMaHangHoaTonTaiTrongDB(dtcu, rMoi[2].ToString())) { foreach (DataRow rCu in dtcu.Rows) { if (rCu[2].Equals(rMoi[2])) { TK.MaHangHoa = rCu[2].ToString(); TK.MaKho = lueKho.EditValue.ToString(); TK.SoLuong = Convert.ToInt32(rCu[3]); int soLuongMoi = Convert.ToInt32(rMoi[3]); if (soLuongMoi != TK.SoLuong) { if (soLuongMoi > TK.SoLuong) { TK.SoLuong = soLuongMoi - TK.SoLuong; bool f = tonKhoBUS.CongSoLuongTonKhoBUS(ref err, TK); if (f == true) { MessageBox.Show("Cong thanh cong"); } } else { TK.SoLuong = TK.SoLuong - soLuongMoi; bool f = tonKhoBUS.TruSoLuongTonKho(ref err, TK); if (f == true) { MessageBox.Show("Tru thanh cong"); } } } } } } else { TK.MaHangHoa = rMoi[2].ToString(); TK.MaKho = lueKho.EditValue.ToString(); TK.SoLuong = Convert.ToInt32(rMoi[3]); bool f = tonKhoBUS.ThemTonKhoBUS(ref err, TK); if (f == true) { MessageBox.Show("Them thanh cong ton kho, bo sung moi, MaHangHoa: " + TK.MaHangHoa + " makho:" + TK.MaKho + "So luong " + TK.SoLuong); } } } }
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 = chuyenKhoBUS.XoaChuyenKhoBUS(ref err, CK); bool f1 = false; if (f == true) { DataTable dtChiTietCK = new DataTable(); dtChiTietCK = chiTietChuyenKhoBUS.GetAllChiTietChuyenKhoByMaPhieuChuyenBUS(CTCK); f1 = chiTietChuyenKhoBUS.XoaChiTietChuyenKhoByMaPhieuChuyenBUS(ref err, CTCK); MessageBox.Show("Xoa thanh cong chuyen kho"); if (f1 == true) { foreach (DataRow r in dtChiTietCK.Rows) { TK.MaHangHoa = r[2].ToString(); TK.MaKho = CK.MaKhoChuyen; TK.SoLuong = Convert.ToInt32(r[3]); bool f2 = tonKhoBUS.CongSoLuongTonKhoBUS(ref err, TK); if (f2 == true) { MessageBox.Show("Cong thanh cong kho:" + TK.MaKho + ",MaHangHoa:" + TK.MaHangHoa + ", So luong:" + TK.SoLuong); } TK.MaKho = CK.MaKhoNhan; bool f3 = tonKhoBUS.TruSoLuongTonKho(ref err, TK); if (f3 == true) { MessageBox.Show("Tru thanh cong kho:" + TK.MaKho + ",MaHangHoa:" + TK.MaHangHoa + ", So luong:" + TK.SoLuong); } } MessageBox.Show("Xoa thanh cong chitietmuahang, ma phieu:" + CTCK.MaPhieuChuyen); } loadData(); } else { MessageBox.Show("Khong Xoa duoc chuyenkho. Loi: " + err); } } catch (SqlException) { MessageBox.Show("Khong Xoa duoc. Loi: " + err); } } }
void SuaChiTietPhieuTraHang_TonKho_dtDBCu(DataTable dtmoi, DataTable dtcu) { string err = ""; foreach (DataRow rMoi in dtmoi.Rows) { if (KiemTraMaHangHoaTonTaiTrongDB(dtcu, rMoi[2].ToString())) { foreach (DataRow rCu in dtcu.Rows) { if (rCu[2].Equals(rMoi[2])) { //cap nhat tonkho TK.MaHangHoa = rCu[2].ToString(); TK.MaKho = lueKho.EditValue.ToString(); TK.SoLuong = Convert.ToInt32(rCu[3]); int soLuongMoi = Convert.ToInt32(rMoi[3]); if (soLuongMoi != TK.SoLuong) { if (soLuongMoi > TK.SoLuong) { TK.SoLuong = soLuongMoi - TK.SoLuong; bool f = tonKhoBUS.CongSoLuongTonKhoBUS(ref err, TK); if (f == true) { MessageBox.Show("Cong thanh cong"); } } else { TK.SoLuong = TK.SoLuong - soLuongMoi; bool f = tonKhoBUS.TruSoLuongTonKho(ref err, TK); if (f == true) { MessageBox.Show("Tru thanh cong"); } } } // cap nhat chi tiet phieu ban CTTH.MaChiTietPhieuTra = "1"; CTTH.MaPhieuTra = txtMaPhieuTra.Text; CTTH.MaHangHoa = rMoi[2].ToString(); CTTH.SoLuong = Convert.ToInt32(rMoi[3]); CTTH.DonGia = Convert.ToInt32(rMoi[4]); CTTH.ThanhTien = Convert.ToInt32(rMoi[5]); bool f1 = chiTietPhieuTraHangBUS.CapNhatChiTietPhieuTraHangBUS(ref err, CTTH); } } } else { //xuat ton kho TK.MaHangHoa = rMoi[2].ToString(); TK.MaKho = lueKho.EditValue.ToString(); TK.SoLuong = Convert.ToInt32(rMoi[3]); //bool f = tonKhoBUS.ThemTonKhoBUS(ref err, TK); bool f = tonKhoBUS.TruSoLuongTonKho(ref err, TK); if (f == true) { MessageBox.Show("Tru thanh cong ton kho, MaHangHoa: " + TK.MaHangHoa + " makho:" + TK.MaKho + "So luong " + TK.SoLuong); } // them chi tiet phieu ban CTTH.MaChiTietPhieuTra = "1"; CTTH.MaPhieuTra = txtMaPhieuTra.Text; CTTH.MaHangHoa = rMoi[2].ToString(); CTTH.SoLuong = Convert.ToInt32(rMoi[3]); CTTH.DonGia = Convert.ToInt32(rMoi[4]); CTTH.ThanhTien = Convert.ToInt32(rMoi[5]); bool f1 = chiTietPhieuTraHangBUS.ThemChiTietPhieuTraHangBUS(ref err, CTTH); } } }
void SuaChiTietPhieuChuyenKho_TonKho_dtDBCu(DataTable dtmoi, DataTable dtcu) { string err = ""; foreach (DataRow rMoi in dtmoi.Rows) { if (KiemTraMaHangHoaTonTaiTrongDB(dtcu, rMoi[2].ToString())) { foreach (DataRow rCu in dtcu.Rows) { if (rCu[2].Equals(rMoi[2])) { //cap nhat tonkho TK.MaHangHoa = rCu[2].ToString(); TK.SoLuong = Convert.ToInt32(rCu[3]); int soLuongMoi = Convert.ToInt32(rMoi[3]); if (soLuongMoi != TK.SoLuong) { if (soLuongMoi > TK.SoLuong) { //tru so luong kho chuyen TK.MaKho = lueKhoChuyen.EditValue.ToString(); TK.SoLuong = soLuongMoi - TK.SoLuong; bool f = tonKhoBUS.TruSoLuongTonKho(ref err, TK); if (f == true) { MessageBox.Show("Tru thanh cong kho:" + TK.MaKho + ",MaHangHoa:" + TK.MaHangHoa + ", So luong:" + TK.SoLuong); } //cong so luong kho nhan TK.MaKho = lueKhoNhan.EditValue.ToString(); bool f1 = tonKhoBUS.CongSoLuongTonKhoBUS(ref err, TK); if (f1 == true) { MessageBox.Show("Cong thanh cong kho:" + TK.MaKho + ",MaHangHoa:" + TK.MaHangHoa + ", So luong:" + TK.SoLuong); } } else { //cong so luong kho chuyen TK.MaKho = lueKhoChuyen.EditValue.ToString(); TK.SoLuong = TK.SoLuong - soLuongMoi; bool f = tonKhoBUS.CongSoLuongTonKhoBUS(ref err, TK); if (f == true) { MessageBox.Show("Cong thanh cong kho:" + TK.MaKho + ",MaHangHoa:" + TK.MaHangHoa + ", So luong:" + TK.SoLuong); } bool f1 = tonKhoBUS.TruSoLuongTonKho(ref err, TK); if (f1 == true) { MessageBox.Show("Tru thanh cong kho:" + TK.MaKho + ",MaHangHoa:" + TK.MaHangHoa + ", So luong:" + TK.SoLuong); } } } // cap nhat chi tiet phieuchuyen CTCK.MaChiTietPhieuChuyen = "1"; CTCK.MaPhieuChuyen = txtMaPhieuChuyen.Text; CTCK.MaHangHoa = rMoi[2].ToString(); CTCK.SoLuong = Convert.ToInt32(rMoi[3]); CTCK.DonGia = Convert.ToInt32(rMoi[4]); CTCK.ThanhTien = Convert.ToInt32(rMoi[5]); bool f2 = chiTietChuyenKhoBUS.CapNhatChiTietChuyenKhoByMaPhieuChuyenMaHangHoaBUS(ref err, CTCK); if (f2 == true) { MessageBox.Show("Cap nhat thanh cong chi tiet phieu chuyen,MaPhieuChuyen=" + CTCK.MaPhieuChuyen + ", MaHangHoa:" + CTCK.MaHangHoa); } } } } else { //them ton kho TK.MaHangHoa = rMoi[2].ToString(); TK.MaKho = lueKhoChuyen.EditValue.ToString(); TK.SoLuong = Convert.ToInt32(rMoi[3]); bool f = tonKhoBUS.TruSoLuongTonKho(ref err, TK); if (f == true) { MessageBox.Show("Them thanh cong ton kho, MaHangHoa: " + TK.MaHangHoa + " makho:" + TK.MaKho + "So luong " + TK.SoLuong); } TK.MaKho = lueKhoNhan.EditValue.ToString(); bool f1 = tonKhoBUS.ThemTonKhoBUS(ref err, TK); if (f1 == true) { MessageBox.Show("Them thanh cong ton kho, bo sung moi, MaHangHoa: " + TK.MaHangHoa + " makho:" + TK.MaKho + "So luong " + TK.SoLuong); } // them chi tiet phieu CTCK.MaChiTietPhieuChuyen = "1"; CTCK.MaPhieuChuyen = txtMaPhieuChuyen.Text; CTCK.MaHangHoa = rMoi[2].ToString(); CTCK.SoLuong = Convert.ToInt32(rMoi[3]); CTCK.DonGia = Convert.ToInt32(rMoi[4]); CTCK.ThanhTien = Convert.ToInt32(rMoi[5]); bool f2 = chiTietChuyenKhoBUS.ThemChiTietChuyenKhoBUS(ref err, CTCK); if (f2 == true) { MessageBox.Show("Them thanh cong chuyen kho, bo sung moi, MaPhieuChuyen: " + CTCK.MaPhieuChuyen + " MaHangHoa:" + CTCK.MaHangHoa + "So luong " + CTCK.SoLuong); } } } }