private void btnLuuCTXH_Click(object sender, EventArgs e)
{
ChiTietXuatDTO ctx = new ChiTietXuatDTO();
int dongia = 0;
int soluong = 0;
int.TryParse(txtDonGiaCTXH.Text, out dongia);
int.TryParse(txtSoLuongCTXH.Text, out soluong);
ctx.DonGia = dongia;
ctx.SoLuong = soluong;
ctx.MaHangHoa = (int)cboTenSanPham.SelectedValue;
ctx.MaHDXuat = maHoaDon;
// trường hợp bấm phím thêm
if (ktctx == 1)
{
try
{
ChiTietXuatDAO.ThemCTX(ctx);
}
catch
{
try
{
int soluongcon = 0;
int.TryParse(ChiTietXuatDAO.TinhSoLuong(ctx).Rows[0]["SoLuong"].ToString(), out soluongcon);
ctx.SoLuong += soluongcon;
ChiTietXuatDAO.SuaCTX(ctx);
}
catch
{
MessageBox.Show("Có lỗi không thêm được");
}
}
}
// trường hợp bấm phím sửa
if (ktctx == 2)
{
try
{
ChiTietXuatDAO.SuaCTX(ctx);
}
catch
{
MessageBox.Show("Lỗi chưa sửa được");
}
}
anhd();
btnLuuCTXH.Visible = false;
dgvHoaDon.DataSource = HoaDonXuatDAO.LoadDataHoaDonVaKhach();
dgvChiTietXuat.DataSource = ChiTietXuatDAO.LoadDataCTX(maHoaDon);
resettext();
ktctx = 0;
}
public static DataTable TinhSoLuong(ChiTietXuatDTO ctx)
{
string sTruyVan = string.Format("select * from tblChiTietXuat where MaHangHoa = '{0}'and MaHDXuat={1}", ctx.MaHangHoa, ctx.MaHDXuat);
con = DataProvider.KetNoi();
DataTable dt = DataProvider.LayDataTable(sTruyVan, con);
DataProvider.DongKetNoi(con);
return(dt);
}
public static bool ThemCTX(ChiTietXuatDTO ctx)
{
string sTruyVan = string.Format("Insert into tblChiTietXuat(MaHDXuat,MaHangHoa,SoLuong,DonGia) values ({0},'{1}','{2}','{3}')", ctx.MaHDXuat, ctx.MaHangHoa, ctx.SoLuong, ctx.DonGia);
con = DataProvider.KetNoi();
DataTable dt = DataProvider.LayDataTable(sTruyVan, con);
DataProvider.DongKetNoi(con);
return(true);
}
public static bool XoaCTX(ChiTietXuatDTO ctx)
{
try
{
con = DataProvider.KetNoi();
string sTruyVan = string.Format("Delete tblChiTietXuat where MaHangHoa={0} and MaHDXuat={1} ", ctx.MaHangHoa, ctx.MaHDXuat);
DataProvider.ThucThiTruyVan(sTruyVan, con);
DataProvider.DongKetNoi(con);
return(true);
}
catch
{
return(false);
}
}
public static bool SuaCTX(ChiTietXuatDTO ctx)
{
try
{
con = DataProvider.KetNoi();
string sTruyVan = string.Format("Update tblChiTietXuat set SoLuong='{0}',DonGia = '{1}' where MaHDXuat={2} and MaHangHoa = '{3}'", ctx.SoLuong, ctx.DonGia, ctx.MaHDXuat, ctx.MaHangHoa);
DataProvider.ThucThiTruyVan(sTruyVan, con);
DataProvider.DongKetNoi(con);
return(true);
}
catch
{
return(false);
}
}
public List <ChiTietXuatDTO> GetListChiTietHang(string maphieu)
{
List <ChiTietXuatDTO> list = new List <ChiTietXuatDTO>();
string query = "SELECT dbo.CHITIETXUAT.MaMatHang, TenMatHang, DonViTinh, SoLuong, DonGia, ThanhTien " +
"FROM dbo.CHITIETXUAT,dbo.MATHANG " +
"WHERE MaPhieuXuatHang = '" + maphieu + "'";
DataTable data = Data_SQL.Instance.GetQuery(query);
foreach (DataRow item in data.Rows)
{
ChiTietXuatDTO CTXH = new ChiTietXuatDTO(item);
list.Add(CTXH);
}
return(list);
}
private void btnXoaCTXH_Click(object sender, EventArgs e)
{
ChiTietXuatDTO ctx = new ChiTietXuatDTO();
ctx.MaHangHoa = (int)cboTenSanPham.SelectedValue;
ctx.MaHDXuat = maHoaDon;
try
{
ChiTietXuatDAO.XoaCTX(ctx);
}
catch
{
MessageBox.Show("Chưa xóa được!");
}
dgvHoaDon.DataSource = HoaDonXuatDAO.LoadDataHoaDonVaKhach();
dgvChiTietXuat.DataSource = ChiTietXuatDAO.LoadDataCTX(maHoaDon);
resettext();
}
