private void btnHoanTat_Click(object sender, EventArgs e) { PhieuThanhLySachDTO phieuThanhLySachDTO = new PhieuThanhLySachDTO(); phieuThanhLySachDTO.MaPhieuthanhLy = txtMaPhieu.Text; phieuThanhLySachDTO.MaNV = cbbNhanVien.SelectedValue.ToString(); phieuThanhLySachDTO.NgayThanhLy = dtNgayThanhLy.Value.ToString("MM-dd-yyyy"); QuanLyThanhLySachBUS quanLyThanhLySachBUS = new QuanLyThanhLySachBUS(); quanLyThanhLySachBUS.ThemPhieuThanhLySach(phieuThanhLySachDTO); foreach (DataGridViewRow row in dgvChiTietPhieuThanhLy.Rows) { if (row.Index == dgvChiTietPhieuThanhLy.Rows.Count - 1) { break; } ChiTietPhieuThanhLySachDTO ChiTiet = new ChiTietPhieuThanhLySachDTO(); ChiTiet.MaPhieuThanhLy = txtMaPhieu.Text; ChiTiet.MaSach = row.Cells["MaSach"].Value.ToString(); ChiTiet.MaLyDoThanhLy = row.Cells["LyDoThanhLy"].Value.ToString(); quanLyThanhLySachBUS.ThemChiTietPhieuThanhLySach(ChiTiet); quanLyThanhLySachBUS.XoaSach(ChiTiet.MaSach); } MessageBox.Show("Lập phiếu thanh lý sách thành công"); LoadMaPhieuThanhLy(); LamMoiForm(); }
public int ThemChiTietPhieuThanhLySach(ChiTietPhieuThanhLySachDTO phieuChiTietThanhLySach) { try { string strSQL = "INSERT INTO CT_PHIEUTHANHLY VALUES(@MaPhieuThanhLy, @MaSach, @MaLyDoThanhLy)"; provider.Connect(); int Row = provider.ExecuteNonQuery(CommandType.Text, strSQL, new SqlParameter { ParameterName = "@MaPhieuThanhLy", Value = phieuChiTietThanhLySach.MaPhieuThanhLy }, new SqlParameter { ParameterName = "@MaSach", Value = phieuChiTietThanhLySach.MaSach }, new SqlParameter { ParameterName = "@MaLyDoThanhLy", Value = phieuChiTietThanhLySach.MaLyDoThanhLy } ); return(Row); } catch (Exception ex) { throw ex; } finally { provider.DisConnect(); } }
public int ThemChiTietPhieuThanhLySach(ChiTietPhieuThanhLySachDTO phieuChiTietThanhLySach) { try { QuanLyThanhLySachDAO quanLyThanhLySachDAO = new QuanLyThanhLySachDAO(); int Row = quanLyThanhLySachDAO.ThemChiTietPhieuThanhLySach(phieuChiTietThanhLySach); return(Row); } catch (Exception ex) { throw ex; } }