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);
}
}
}
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 = traHangBUS.XoaTraHangBUS(ref err, TH);
bool f1 = false;
int demThemTK = 0;
if (f == true)
{
DataTable dtChiTietPTH = new DataTable();
dtChiTietPTH = chiTietPhieuTraHangBUS.GetAllChiTietPhieuTraHangByMaPhieuTraBUS(CTTH);
f1 = chiTietPhieuTraHangBUS.XoaChiTietPhieuTraHangByMaPhieuTraBUS(ref err, CTTH);
MessageBox.Show("Xoa thanh cong tra hang");
if (f1 == true)
{
foreach (DataRow r in dtChiTietPTH.Rows)
{
TK.MaHangHoa = r[2].ToString();
TK.MaKho = TH.MaKho;
TK.SoLuong = Convert.ToInt32(r[3]);
bool f2 = tonKhoBUS.TruSoLuongTonKho(ref err, TK);
if (f2 == true)
{
demThemTK++;
}
}
MessageBox.Show("Xoa thanh cong chitiettrahang, ma phieu tra:" + CTTH.MaPhieuTra);
}
if (demThemTK == dtChiTietPTH.Rows.Count)
{
MessageBox.Show("them thanh cong ton kho,Soluong" + demThemTK);
}
loadData();
}
else
{
MessageBox.Show("Khong Xoa duoc mua hang. Loi: " + err);
}
if (f1 == true)
{
MessageBox.Show("Xoa thanh cong chitietphieumuahang");
loadData();
}
else
{
MessageBox.Show("Khong Xoa duoc chitietphieumuahang. Loi: " + err);
}
}
catch (SqlException)
{
MessageBox.Show("Khong Xoa duoc. Loi: " + err);
}
}
}
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);
}
}
}
}
