public int ThemChiTietPhieuMuon(List <ThongTinMuonTra_DTO> lstThongTin) { try { string query = "INSERT dbo.ThongTinMuonTra (MaCuonSach, SoPhieuMuon, NgayTra, TinhTrangSach, MaViPham ) VALUES "; for (int i = 0; i < lstThongTin.Count; i++) { ThongTinMuonTra_DTO tt = lstThongTin[i]; if (i < lstThongTin.Count - 1) { query += "('" + tt.MaCuonSach + "','" + tt.SoPhieuMuon + "', NULL, 100, NULL),"; } else { query += "('" + tt.MaCuonSach + "','" + tt.SoPhieuMuon + "', NULL, 100, NULL)"; } } int kq = DataProvider.Instance.ExecuteNonQuery(query); return(kq); } catch (Exception ex) { return(0); } }
private void btnThem_Click(object sender, EventArgs e) { List <ThongTinMuonTra_DTO> lstThongTin = new List <ThongTinMuonTra_DTO>(); for (int i = 0; i < chklstCuonSach.CheckedItems.Count; i++) { ThongTinMuonTra_DTO tt = new ThongTinMuonTra_DTO(); CuonSach_DTO cs = chklstCuonSach.CheckedItems[i] as CuonSach_DTO; tt.MaCuonSach = cs.MaCuonSach; tt.SoPhieuMuon = txtSoPhieuMuon.Text; lstThongTin.Add(tt); } int kq = ThongTinMuonTra_DAO.Instance.ThemChiTietPhieuMuon(lstThongTin); if (kq > 0) { MessageBox.Show("Đã thêm chi tiết phiếu mượn"); this.Close(); } else { MessageBox.Show("Thêm chi tiết phiếu mượn thất bại"); } }
public List <ThongTinMuonTra_DTO> LoadTatCaThongTinMuonTra() { try { List <ThongTinMuonTra_DTO> lstThongTinMuonTra = new List <ThongTinMuonTra_DTO>(); string query = "SELECT tt.*, ds.TenDauSach FROM ThongTinMuonTra tt INNER JOIN CuonSach cs ON tt.MaCuonSach = cs.MaCuonSach" + " INNER JOIN DauSach ds ON cs.MaDauSach = ds.MaDauSach"; DataTable data = DataProvider.Instance.ExecuteQuery(query); foreach (DataRow item in data.Rows) { ThongTinMuonTra_DTO thongTin = new ThongTinMuonTra_DTO(item); lstThongTinMuonTra.Add(thongTin); } return(lstThongTinMuonTra); } catch (Exception ex) { return(null); } }