private void sbtnLuu_Click(object sender, EventArgs e)
{
string[] ngayLapPhieu = dtpNgayLapPhieu.Text.Split('/');
string caAn = cboCaAn.Text;
string nguoiLapPhieu = txtNguoiLapPhieu.Text.Trim();
string nguoiNhanHang = txtNguoiNhapHang.Text.Trim();
string soPhieu = txtSoPhieu.Text.Trim();
string dienGiai = txtDienGiai.Text.Trim();
string xuatTaiKho = txtXuatKhoTai.Text.Trim();
string diaDiem = txtDiaDiem.Text.Trim();
string tongTien = KiemTraKhongCo(txtTongTien.Text.Trim());
if (LoaiForm == "NhapKho")
{
if (maPhieuXuatNhapKho == 0)//THEEM MOI
{
#region THEM MOI
string sql = "";
try
{
maPhieuXuatNhapKho = int.Parse(Connect.GetTable("select maphieuNhapXuatkho from PhieuNhapXuatKho order by maphieunhapxuatkho desc").Rows[0][0].ToString());
}
catch { }
sql = @" insert into PhieuNhapXuatKho(maphieunhapxuatkho,ngay,thang,nam,ngaythangnam,sophieu,nguoilap,diengiai,tongtien,loaiphieu,caan,bophannhanhang,diadiem,nguoigiaonhanhang)
values(
" + ++maPhieuXuatNhapKho + @",
" + ngayLapPhieu[0] + @",
" + ngayLapPhieu[1] + @",
" + ngayLapPhieu[2] + @",
'" + ngayLapPhieu[1] + "/" + ngayLapPhieu[0] + "/" + ngayLapPhieu[2] + @"',
'" + soPhieu + @"',
'" + nguoiLapPhieu + @"',
'" + dienGiai + @"',
" + tongTien + @",
0,
'" + caAn + @"',
'" + xuatTaiKho + @"',
'" + diaDiem + @"',
'" + nguoiNhanHang + @"'
) ";
if (Connect.Exec(sql))
{
for (int i = 0; i < gvChiTietNhapXuatKho.RowCount; i++)
{
decimal maquanly = 0;
try
{
maquanly = decimal.Parse(KiemTraKhongCo(Connect.GetTable("select maquanly from ChiTietPhieuNhapXuatKho order by maquanly desc").Rows[0][0].ToString()));
}
catch { }
string maThucPham = gvChiTietNhapXuatKho.GetRowCellValue(i, colMaThucPham).ToString();
string soLuong = KiemTraKhongCo(gvChiTietNhapXuatKho.GetRowCellValue(i, colSoLuong).ToString());
string donGia = KiemTraKhongCo(gvChiTietNhapXuatKho.GetRowCellValue(i, colDonGia).ToString());
string thanhTien = KiemTraKhongCo(gvChiTietNhapXuatKho.GetRowCellValue(i, colThanhTien).ToString());
Connect.Exec(@" insert into ChiTietPhieuNhapXuatKho(maquanly,maphieunhapxuatkho,mathucpham,soluong,giatien,thanhtien)
values(
" + ++maquanly + @",
" + maPhieuXuatNhapKho + @",
" + maThucPham + @",
" + soLuong + @",
" + donGia + @",
" + thanhTien + @"
)");
}
MessageBox.Show("Đã tạo mới phiếu nhập", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
ucNhapKho.LoadDanhSach_NhapKho();
}
else
{
MessageBox.Show("Lỗi thêm mới", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
#endregion
}
else//CAP NHẬT
{
#region CAP NHAT
string sql = @" update PhieuNhapXuatKho set
ngay = " + ngayLapPhieu[0] + @",
thang = " + ngayLapPhieu[1] + @",
nam = " + ngayLapPhieu[2] + @",
ngaythangnam = '" + ngayLapPhieu[1] + "/" + ngayLapPhieu[0] + "/" + ngayLapPhieu[2] + @"',
sophieu = '" + soPhieu + @"',
nguoilap = '" + nguoiLapPhieu + @"',
diengiai = '" + dienGiai + @"',
tongtien = " + tongTien + @",
caan = '" + caAn + @"',
bophannhanhang = '" + xuatTaiKho + @"',
diadiem = '" + diaDiem + @"',
nguoigiaonhanhang = '" + nguoiNhanHang + @"'
where maphieunhapxuatkho =" + maPhieuXuatNhapKho;
if (Connect.Exec(sql))
{
for (int i = 0; i < gvChiTietNhapXuatKho.RowCount; i++)
{
string maquanly = gvChiTietNhapXuatKho.GetRowCellValue(i, colMaChiTietPhieuNhapXuat).ToString();
string maThucPham = gvChiTietNhapXuatKho.GetRowCellValue(i, colMaThucPham).ToString();
string soLuong = KiemTraKhongCo(gvChiTietNhapXuatKho.GetRowCellValue(i, colSoLuong).ToString());
string donGia = KiemTraKhongCo(gvChiTietNhapXuatKho.GetRowCellValue(i, colDonGia).ToString());
string thanhTien = KiemTraKhongCo(gvChiTietNhapXuatKho.GetRowCellValue(i, colThanhTien).ToString());
if (maquanly.Trim() != "-99")
{
string sql_ChiTiet = @" update ChiTietPhieuNhapXuatKho set
mathucpham = " + maThucPham + @",
soLuong = " + soLuong + @",
giatien = " + donGia + @",
thanhTien = " + thanhTien + @"
where maquanly =" + maquanly;
Connect.Exec(sql_ChiTiet);
}
else
{
decimal maquanly_new = 0;
try
{
maquanly_new = decimal.Parse(KiemTraKhongCo(Connect.GetTable("select maquanly from ChiTietPhieuNhapXuatKho order by maquanly desc").Rows[0][0].ToString()));
}
catch { }
string sql_ChiTiet = @" insert into ChiTietPhieuNhapXuatKho(maquanly,maphieunhapxuatkho,mathucpham,soluong,giatien,thanhtien)
values(
" + ++maquanly_new + @",
" + maPhieuXuatNhapKho + @",
" + maThucPham + @",
" + soLuong + @",
" + donGia + @",
" + thanhTien + @"
)";
Connect.Exec(sql_ChiTiet);
}
}
MessageBox.Show("Đã cập nhật phiếu nhập", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
ucNhapKho.LoadDanhSach_NhapKho();
}
else
{
MessageBox.Show("Lỗi cập nhật phiếu nhập", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
#endregion
}
}
else if (LoaiForm == "XuatKho")
{
if (maPhieuXuatNhapKho == 0)//THEEM MOI
{
#region THEM MOI
string sql = "";
try
{
maPhieuXuatNhapKho = int.Parse(Connect.GetTable("select maphieuNhapXuatkho from PhieuNhapXuatKho order by maphieunhapxuatkho desc").Rows[0][0].ToString());
}
catch { }
sql = @" insert into PhieuNhapXuatKho(maphieunhapxuatkho,ngay,thang,nam,ngaythangnam,sophieu,nguoilap,diengiai,tongtien,loaiphieu,caan,bophannhanhang,diadiem,nguoigiaonhanhang)
values(
" + ++maPhieuXuatNhapKho + @",
" + ngayLapPhieu[0] + @",
" + ngayLapPhieu[1] + @",
" + ngayLapPhieu[2] + @",
'" + ngayLapPhieu[1] + "/" + ngayLapPhieu[0] + "/" + ngayLapPhieu[2] + @"',
'" + soPhieu + @"',
'" + nguoiLapPhieu + @"',
'" + dienGiai + @"',
" + tongTien + @",
1,
'" + caAn + @"',
'" + xuatTaiKho + @"',
'" + diaDiem + @"',
'" + nguoiNhanHang + @"'
) ";
if (Connect.Exec(sql))
{
for (int i = 0; i < gvChiTietNhapXuatKho.RowCount; i++)
{
decimal maquanly = 0;
try
{
maquanly = decimal.Parse(KiemTraKhongCo(Connect.GetTable("select maquanly from ChiTietPhieuNhapXuatKho order by maquanly desc").Rows[0][0].ToString()));
}
catch { }
string maThucPham = gvChiTietNhapXuatKho.GetRowCellValue(i, colMaThucPham).ToString();
string soLuong = KiemTraKhongCo(gvChiTietNhapXuatKho.GetRowCellValue(i, colSoLuong).ToString());
string donGia = KiemTraKhongCo(gvChiTietNhapXuatKho.GetRowCellValue(i, colDonGia).ToString());
string thanhTien = KiemTraKhongCo(gvChiTietNhapXuatKho.GetRowCellValue(i, colThanhTien).ToString());
Connect.Exec(@" insert into ChiTietPhieuNhapXuatKho(maquanly,maphieunhapxuatkho,mathucpham,soluong,giatien,thanhtien)
values(
" + ++maquanly + @",
" + maPhieuXuatNhapKho + @",
" + maThucPham + @",
" + soLuong + @",
" + donGia + @",
" + thanhTien + @"
)");
}
MessageBox.Show("Đã tạo mới phiếu xuất", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
ucXuatKho.LoadDanhSach_XuatKho();
}
else
{
MessageBox.Show("Lỗi thêm mới", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
#endregion
}
else//CAP NHẬT
{
#region CAP NHAT
string sql = @" update PhieuNhapXuatKho set
ngay = " + ngayLapPhieu[0] + @",
thang = " + ngayLapPhieu[1] + @",
nam = " + ngayLapPhieu[2] + @",
ngaythangnam = '" + ngayLapPhieu[1] + "/" + ngayLapPhieu[0] + "/" + ngayLapPhieu[2] + @"',
sophieu = '" + soPhieu + @"',
nguoilap = '" + nguoiLapPhieu + @"',
diengiai = '" + dienGiai + @"',
tongtien = " + tongTien + @",
caan = '" + caAn + @"',
bophannhanhang = '" + xuatTaiKho + @"',
diadiem = '" + diaDiem + @"',
nguoigiaonhanhang = '" + nguoiNhanHang + @"'
where maphieunhapxuatkho =" + maPhieuXuatNhapKho;
if (Connect.Exec(sql))
{
for (int i = 0; i < gvChiTietNhapXuatKho.RowCount; i++)
{
string maquanly = gvChiTietNhapXuatKho.GetRowCellValue(i, colMaChiTietPhieuNhapXuat).ToString();
string maThucPham = gvChiTietNhapXuatKho.GetRowCellValue(i, colMaThucPham).ToString();
string soLuong = KiemTraKhongCo(gvChiTietNhapXuatKho.GetRowCellValue(i, colSoLuong).ToString());
string donGia = KiemTraKhongCo(gvChiTietNhapXuatKho.GetRowCellValue(i, colDonGia).ToString());
string thanhTien = KiemTraKhongCo(gvChiTietNhapXuatKho.GetRowCellValue(i, colThanhTien).ToString());
if (maquanly.Trim() != "-99")
{
string sql_ChiTiet = @" update ChiTietPhieuNhapXuatKho set
mathucpham = " + maThucPham + @",
soLuong = " + soLuong + @",
giatien = " + donGia + @",
thanhTien = " + thanhTien + @"
where maquanly =" + maquanly;
Connect.Exec(sql_ChiTiet);
}
else
{
decimal maquanly_new = 0;
try
{
maquanly_new = decimal.Parse(KiemTraKhongCo(Connect.GetTable("select maquanly from ChiTietPhieuNhapXuatKho order by maquanly desc").Rows[0][0].ToString()));
}
catch { }
string sql_ChiTiet = @" insert into ChiTietPhieuNhapXuatKho(maquanly,maphieunhapxuatkho,mathucpham,soluong,giatien,thanhtien)
values(
" + ++maquanly_new + @",
" + maPhieuXuatNhapKho + @",
" + maThucPham + @",
" + soLuong + @",
" + donGia + @",
" + thanhTien + @"
)";
Connect.Exec(sql_ChiTiet);
}
}
MessageBox.Show("Đã cập nhật phiếu xuất", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
ucXuatKho.LoadDanhSach_XuatKho();
}
else
{
MessageBox.Show("Lỗi cập nhật phiếu xuất", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
#endregion
}
}
}
