private void btnLuuHDNhap_Click(object sender, EventArgs e) { // Lấy mã hóa đơn vừa nhập HDNhapHangDTO HDNhap = new HDNhapHangDTO(); HDNhap.MaNV = 1; int id = HDNhapBUS.Them(HDNhap); bool isThanhCong = true; // Duyệt danh sách chi tiết hóa đơn (DataGridView) foreach (DataGridViewRow row in dgvDSCTHDNhap.Rows) { CTHDNhapHangDTO CTHDNhap = new CTHDNhapHangDTO(); CTHDNhap.MaHD = id; CTHDNhap.MaSach = Convert.ToInt32(row.Cells["colMaSach_CTHD"].Value); CTHDNhap.SoLuong = Convert.ToInt32(row.Cells["colSoLuong_CTHD"].Value); CTHDNhap.GiaBia = Convert.ToInt32(row.Cells["colGiaBia_CTHD"].Value); isThanhCong = CTHDNhapBUS.Them(CTHDNhap); if (!isThanhCong) { break; } sBUS.CapNhatSoLuongGiaBia(CTHDNhap.MaSach, CTHDNhap.SoLuong, CTHDNhap.GiaBia, CTHDNhap.GiaNhap); } if (isThanhCong) { MessageBox.Show("Lưu hoá đơn thành công!"); bdsSach.DataSource = sBUS.LayDanhSach(); } else { MessageBox.Show("Lưu hoá đơn không thành công!"); } dgvDSCTHDNhap.Rows.Clear(); }
public void getRow(CTHDNhapHangDTO ctnh, string tenhh, string ghiChu) { DataGridViewRow row = (DataGridViewRow)dtgNhaphang.Rows[0].Clone(); row.Cells[1].Value = ctnh.MaHDNH; row.Cells[2].Value = tenhh; row.Cells[3].Value = ctnh.Dvt; row.Cells[4].Value = ctnh.Sl; row.Cells[5].Value = ctnh.DonGia; row.Cells[6].Value = ctnh.ThanhTien; row.Cells[7].Value = ghiChu; dtgNhaphang.Rows.Add(row); kiemTraRowTrungValue(); }
public bool Them(CTHDNhapHangDTO CTHDNhapDTO) { conn.Open(); string SQL = string.Format("INSERT INTO [dbo].[CTHDNhapHang] ([MaHD],[MaSach],[SoLuong],[GiaBia],[GiaNhap]) " + "VALUES ({0},{1},{2},{3},{4})", CTHDNhapDTO.MaHD, CTHDNhapDTO.MaSach, CTHDNhapDTO.SoLuong, CTHDNhapDTO.GiaBia, CTHDNhapDTO.GiaNhap); SqlCommand com = new SqlCommand(SQL, conn); int kq = com.ExecuteNonQuery(); conn.Close(); if (kq > 0) { return(true); } return(false); }
void eventDeThemHangHoaVaoHoaDon() { CTHDNhapHangDTO ctnh = new CTHDNhapHangDTO(); ctnh.MaHDNH = Convert.ToInt32(txtMahh.Text); string tehh = txtTenHH.Text; ctnh.Dvt = lblDonvitinh.Text; ctnh.Sl = Convert.ToInt32(txtSoluong.Text); ctnh.DonGia = Convert.ToInt32(txtGiamua.Text); ctnh.ThanhTien = Convert.ToInt32(txtThanhtien.Text); string ghiChu = txtGhichu.Text; eventGetRow(ctnh, tehh, ghiChu); }
private void btnThanhtoan_Click(object sender, EventArgs e) { mangCTHD = new ArrayList(); for (int i = 0; i < dtgNhaphang.Rows.Count - 1; i++) { CTHDNhapHangDTO cTHDNhap = new CTHDNhapHangDTO(); cTHDNhap.SanPham = Convert.ToInt32(dtgNhaphang.Rows[i].Cells[1].Value.ToString()); cTHDNhap.Sl = Convert.ToInt32(dtgNhaphang.Rows[i].Cells[4].Value.ToString()); cTHDNhap.DonGia = Convert.ToDecimal(dtgNhaphang.Rows[i].Cells[5].Value.ToString()); mangCTHD.Add(cTHDNhap); } cbTenncc.ValueMember = "MaNCC"; string maNCC = cbTenncc.SelectedValue.ToString(); string tenNCC = cbTenncc.Text; string tienHang = lblTongcong.Text; string noCuCuaHang = lblNocucuahang.Text; ThanhToan tt = new ThanhToan(tenNCC, tienHang, noCuCuaHang, maNCC, mangCTHD); tt.eventLuu += thanhToan; tt.ShowDialog(); }
public bool Them(CTHDNhapHangDTO CTHDNhapDTO) { return(CTHDNhapDAO.Them(CTHDNhapDTO)); }