public void themDauSach(DAUSACH ds) { data.themDauSach(ds); }
public DataTable timDauSach(DAUSACH ds, int type) { return data.timDauSach(ds, type); }
private void btnthem_Click(object sender, EventArgs e) { if (tcthemsach.SelectedTabIndex == 0) //thêm tựa sách { TUASACH ts = new TUASACH(); ts.matuasach = txtmatuasach.Text; ts.tentuasach = txttentuasach.Text; ts.tacgia = txttacgia.Text; ts.gioithieu = txtgioithieu.Text; dataSach.themTuaSach(ts); noticeAddBook(); Close(); MessageBox.Show("Đã thêm"); } else if (tcthemsach.SelectedTabIndex == 1) //thêm đầu sách { DAUSACH ds = new DAUSACH(); ds.madausach = txtmadausach.Text; ds.tinhtrang = false; if (cbxtuasach.SelectedItem != null) ds.matuasach = (cbxtuasach.SelectedItem as ComboboxItem).Value.ToString(); if (cbxngonngu.SelectedItem != null) ds.ngonngu = (cbxngonngu.SelectedItem as ComboboxItem).Value.ToString(); dataSach.themDauSach(ds); noticeAddBook(); Close(); MessageBox.Show("Đã thêm"); } else { CUONSACH cs = new CUONSACH(); cs.macuonsach = txtmacuonsach.Text; if (cbxmadausach.SelectedItem != null) cs.madausach = (cbxmadausach.SelectedItem as ComboboxItem).Value.ToString(); cs.tinhtrang = true; dataSach.themCuonSach(cs); DAUSACH ds = dataSach.timDauSach(cs.madausach); if (ds.tinhtrang != true) { ds.tinhtrang = true; dataSach.suaDauSach(ds); } noticeAddBook(); int macuonsach = Convert.ToInt32(txtmacuonsach.Text); txtmacuonsach.Clear(); txtmacuonsach.Text = (++macuonsach).ToString(); MessageBox.Show("Đã thêm"); } }
public void suaDauSach(DAUSACH ds) { data.suaDauSach(ds); }
private void btntim_Click(object sender, EventArgs e) { if (tctimsach.SelectedTabIndex == 0)//tab tựa sách { TUASACH ts = new TUASACH(); if (rbmatuasach.Checked == true)//tìm theo mã tựa sách { ts.matuasach = txtmatuasach.Text; dgvtuasach.DataSource = dataSach.timTuaSach(ts, 1); } else if (rbtentuasach.Checked == true)//tìm theo tên tựa sách { ts.tentuasach = txttentuasach.Text; dgvtuasach.DataSource = dataSach.timTuaSach(ts, 2); } else if (rbtacgia.Checked == true)//tìm theo tác giả { ts.tacgia = txttacgia.Text; dgvtuasach.DataSource = dataSach.timTuaSach(ts, 3); } } else if (tctimsach.SelectedTabIndex == 1) { DAUSACH ds = new DAUSACH(); if (rbmadausach.Checked == true)//tìm theo mã đầu sách { ds.madausach = txtmadausach.Text; dgvdausach.DataSource = dataSach.timDauSach(ds, 1); } else if (rbmatuasach2.Checked == true)//tìm theo mã tựa sách { ds.matuasach = txtmatuasach2.Text; dgvdausach.DataSource = dataSach.timDauSach(ds, 2); } else if (rbtentuasach2.Checked == true) //tìm theo tên tựa sách { dgvdausach.DataSource = dataSach.timTheoTen(txttentuasach2.Text.ToString(), 1); } } else { CUONSACH cs = new CUONSACH(); if (rbmacuonsach.Checked == true) //tìm theo mã cuốn sách { cs.macuonsach = txtmacuonsach.Text; dgvcuonsach.DataSource = dataSach.timCuonSach(cs, 1); } else if (rbmadausach2.Checked == true) //tìm theo mã đầu sách { cs.madausach = txtmadausach2.Text; dgvcuonsach.DataSource = dataSach.timCuonSach(cs, 2); } else if (rbmatuasach3.Checked == true) { cs.madausach = txtmatuasach3.Text; dgvcuonsach.DataSource = dataSach.timCuonSach(cs, 3); } else if (rbtentuasach3.Checked == true) { dgvcuonsach.DataSource = dataSach.timTheoTen(txttentuasach3.Text.ToString(), 2); } } }
private void btnsua_Click(object sender, EventArgs e) { try { TUASACH ts; DAUSACH ds; CUONSACH cs; if (selectedTab == 0) { ts = new TUASACH(); ts.matuasach = txtmatuasach.Text; ts.tentuasach = txttentuasach.Text; ts.tacgia = txttacgia.Text; ts.gioithieu = txtgioithieu.Text; dataSach.suaTuaSach(ts); noticeUpdateBook(); Close(); MessageBox.Show("Đã lưu!"); } else if (selectedTab == 1) { ds = new DAUSACH(); ds.madausach = txtmadausach.Text; if (cbdausach.Checked == true) ds.tinhtrang = true; else ds.tinhtrang = false; if (cbxmatuasach.SelectedItem != null) ds.matuasach = (cbxmatuasach.SelectedItem as ComboboxItem).Value.ToString(); if(cbxngonngu.SelectedItem != null) ds.ngonngu = (cbxngonngu.SelectedItem as ComboboxItem).Value.ToString(); dataSach.suaDauSach(ds); noticeUpdateBook(); Close(); MessageBox.Show("Đã lưu!"); } else if (selectedTab == 2) { cs = new CUONSACH(); cs.macuonsach = txtmacuonsach.Text; if (cbxmadausach.SelectedItem != null) cs.madausach = (cbxmadausach.SelectedItem as ComboboxItem).Value.ToString(); if (cbcuonsach.Checked == true) cs.tinhtrang = true; else cs.tinhtrang = false; dataSach.suaCuonSach(cs); noticeUpdateBook(); Close(); MessageBox.Show("Đã lưu!"); } cbxmadausach.Items.Clear(); cbxngonngu.Items.Clear(); cbxmatuasach.Items.Clear(); } catch (SqlException) { MessageBox.Show("Lỗi xảy ra, không thể sửa!"); } }
public void suaDauSach(DAUSACH ds) { var temp = data.DAUSACHes.Find(ds.madausach); if (temp != null) { data.Entry(temp).CurrentValues.SetValues(ds); data.SaveChanges(); } }
public void xoaTuaSach(string matuasach) { DAUSACH ds = new DAUSACH(); ds.matuasach = matuasach; DataTable dtDauSach = timDauSach(ds, 2); //tìm đầu sách theo mã tựa sách for (int i = 0; i < dtDauSach.Rows.Count; i++ ) { data.Database.ExecuteSqlCommand("delete from CUONSACH where madausach = '" + dtDauSach.Rows[i]["Mã đầu sách"].ToString() + "'"); } data.Database.ExecuteSqlCommand("delete from DAUSACH where matuasach = '" + matuasach + "'"); data.Database.ExecuteSqlCommand("delete from TUASACH where matuasach = '" + matuasach + "'"); }
public DataTable timDauSach(DAUSACH ds, int type) { DataTable result = new DataTable(); if (type == 1) //tìm theo mã đầu sách { SqlDataAdapter da = new SqlDataAdapter("select* from DAUSACH where madausach = @mds", DataProvider.con); da.SelectCommand.Parameters.AddWithValue("@mds", ds.madausach); da.Fill(result); } else if (type == 2) //tìm theo mã tựa sách { SqlDataAdapter da = new SqlDataAdapter("select* from DAUSACH where matuasach = @mts", DataProvider.con); da.SelectCommand.Parameters.AddWithValue("@mts", ds.matuasach); da.Fill(result); result.Columns["madausach"].ColumnName = "Mã đầu sách"; result.Columns["matuasach"].ColumnName = "Mã tựa sách"; } return result; }
public void themDauSach(DAUSACH ds) { data.DAUSACHes.Add(ds); data.SaveChanges(); }
public void NhapDuLieu() { OpenFileDialog openFile = new OpenFileDialog(); openFile.Filter = "Excel file (*.xls; *.xlsx; *.xlsm; *.xlsb)|*.xls"; openFile.ShowDialog(); if (openFile.FileName == String.Empty) return; Excel.Application xlApp; Excel.Workbook xlWorkBook; Excel.Worksheet xlWorkSheet; Excel.Worksheet sheetDocGia, sheetHocSinh, sheetNhanVien, sheetViPham; Excel.Worksheet sheetTuaSach, sheetDauSach, sheetCuonSach; Excel.Worksheet sheetMuonSach; Excel.Worksheet sheetDkChoMuon; Excel.Range rangeDocGia; string str; xlApp = new Excel.Application(); xlWorkBook = xlApp.Workbooks.Open(openFile.FileName, 0, true, 5, "", "", true, Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, "\t", false, false, 0, true, 1, 0); //xlWorkSheet = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1); sheetDocGia = xlWorkBook.Sheets["Độc giả"] as Excel.Worksheet; sheetHocSinh = xlWorkBook.Sheets["Học sinh"] as Excel.Worksheet; sheetNhanVien = xlWorkBook.Sheets["Nhân viên"] as Excel.Worksheet; sheetViPham = xlWorkBook.Sheets["Vi phạm"] as Excel.Worksheet; sheetTuaSach = xlWorkBook.Sheets["Tựa sách"] as Excel.Worksheet; sheetDauSach = xlWorkBook.Sheets["Đầu sách"] as Excel.Worksheet; sheetCuonSach = xlWorkBook.Sheets["Cuốn sách"] as Excel.Worksheet; sheetMuonSach = xlWorkBook.Sheets["Mượn sách"] as Excel.Worksheet; sheetDkChoMuon = xlWorkBook.Sheets["ĐK chờ mượn"] as Excel.Worksheet; //sheetDocGia = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1); /*sheetHocSinh = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(2); sheetNhanVien = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(3); sheetViPham = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(4); sheetTuaSach = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(5); sheetDauSach = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(6); sheetCuonSach = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(7); sheetMuonSach = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(8); sheetDkChoMuon = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(9);*/ //range = xlWorkSheet.UsedRange; //for (int rCnt = 1; rCnt <= range.Rows.Count; rCnt++) //{ // for (int cCnt = 1; cCnt <= range.Columns.Count; cCnt++) // { // str = (string)(range.Cells[rCnt, cCnt] as Excel.Range).Value2; // MessageBox.Show(str); // } //} //rangeDocGia = sheetDocGia.UsedRange; //if ((sheetDocGia.Cells[2, 6] as Excel.Range).Value == false) // MessageBox.Show("false"); //MessageBox.Show(Convert.ToString((sheetDocGia.Cells[2,6] as Excel.Range).Value)); DangKyCho dataDkCho = new DangKyCho(); MuonTraSach dataMuonSach = new MuonTraSach(); Sach dataSach = new Sach(); DocGia dataDocGia = new DocGia(); ViPham dataViPham = new ViPham(); dataDkCho.xoaTatCa(); dataMuonSach.xoaTatCa(); dataSach.xoaTatCa(); dataViPham.xoaTatCa(); dataDocGia.xoaTatCa(); //Excel.Range rangeDkChoMuon = sheetDkChoMuon.UsedRange; DOCGIA dg; for (int i = 2; i <= sheetDocGia.UsedRange.Rows.Count; i++) { dg = new DOCGIA(); dg.madocgia = Convert.ToString((sheetDocGia.Cells[i, 1] as Excel.Range).Value); dg.hoten = Convert.ToString((sheetDocGia.Cells[i, 2] as Excel.Range).Value); dg.gioitinh = Convert.ToString((sheetDocGia.Cells[i, 3] as Excel.Range).Value); String date = Convert.ToString((sheetDocGia.Cells[i, 4] as Excel.Range).Value); if (date != null) dg.ngaysinh = DateTime.Parse(date); String date1 = Convert.ToString((sheetDocGia.Cells[i, 5] as Excel.Range).Value); if (date1 != null) dg.ngaylap = DateTime.Parse(date1); dg.tinhtrang = (bool)(sheetDocGia.Cells[i, 6] as Excel.Range).Value; dataDocGia.themDocGia(dg); } HOCSINH hs; for (int i = 2; i <= sheetHocSinh.UsedRange.Rows.Count; i++) { hs = new HOCSINH(); hs.madocgia = Convert.ToString((sheetHocSinh.Cells[i, 1] as Excel.Range).Value); hs.lop = Convert.ToString((sheetHocSinh.Cells[i, 2] as Excel.Range).Value); dataDocGia.themHocSinh(hs); } NHANVIEN nv; for (int i = 2; i <= sheetNhanVien.UsedRange.Rows.Count; i++) { nv = new NHANVIEN(); nv.madocgia = Convert.ToString((sheetNhanVien.Cells[i, 1] as Excel.Range).Value); dataDocGia.themNhanVien(nv); } VIPHAM vp; for (int i = 2; i <= sheetViPham.UsedRange.Rows.Count; i++) { vp = new VIPHAM(); vp.madocgia = Convert.ToString((sheetViPham.Cells[i, 1] as Excel.Range).Value); vp.vipham1 = Convert.ToInt32((sheetViPham.Cells[i, 2] as Excel.Range).Value); String date = Convert.ToString((sheetViPham.Cells[i, 3] as Excel.Range).Value); if (date != null) vp.ngayhethan = DateTime.Parse(date); dataViPham.themViPham(vp); } TUASACH ts; for (int i = 2; i <= sheetTuaSach.UsedRange.Rows.Count; i++) { ts = new TUASACH(); ts.matuasach = Convert.ToString((sheetTuaSach.Cells[i, 1] as Excel.Range).Value); ts.tentuasach = Convert.ToString((sheetTuaSach.Cells[i, 2] as Excel.Range).Value); ts.tacgia = Convert.ToString((sheetTuaSach.Cells[i, 3] as Excel.Range).Value); ts.gioithieu = Convert.ToString((sheetTuaSach.Cells[i, 4] as Excel.Range).Value); dataSach.themTuaSach(ts); } DAUSACH ds; for (int i = 2; i <= sheetDauSach.UsedRange.Rows.Count; i++) { ds = new DAUSACH(); ds.madausach = Convert.ToString((sheetDauSach.Cells[i, 1] as Excel.Range).Value); ds.matuasach = Convert.ToString((sheetDauSach.Cells[i, 2] as Excel.Range).Value); ds.ngonngu = Convert.ToString((sheetDauSach.Cells[i, 3] as Excel.Range).Value); ds.tinhtrang = (bool)(sheetDauSach.Cells[i, 4] as Excel.Range).Value; dataSach.themDauSach(ds); } CUONSACH cs; for (int i = 2; i <= sheetCuonSach.UsedRange.Rows.Count; i++) { cs = new CUONSACH(); cs.macuonsach = Convert.ToString((sheetCuonSach.Cells[i, 1] as Excel.Range).Value); cs.madausach = Convert.ToString((sheetCuonSach.Cells[i, 2] as Excel.Range).Value); cs.tinhtrang = (bool)(sheetCuonSach.Cells[i, 3] as Excel.Range).Value; dataSach.themCuonSach(cs); } DKCHOMUON dk; for (int i = 2; i <= sheetDkChoMuon.UsedRange.Rows.Count; i++) { dk = new DKCHOMUON(); dk.madocgia = Convert.ToString((sheetDkChoMuon.Cells[i, 1] as Excel.Range).Value); dk.madausach = Convert.ToString((sheetDkChoMuon.Cells[i, 2] as Excel.Range).Value); String date = Convert.ToString((sheetDkChoMuon.Cells[i, 3] as Excel.Range).Value); if (date != null) dk.ngaygiodk = DateTime.Parse(date); dk.tinhtrang = (bool)(sheetDkChoMuon.Cells[i, 4] as Excel.Range).Value; dataDkCho.themDangKyCho(dk); } MUONSACH ms; for (int i = 2; i <= sheetMuonSach.UsedRange.Rows.Count; i++) { ms = new MUONSACH(); ms.madocgia = Convert.ToString((sheetMuonSach.Cells[i, 1] as Excel.Range).Value); ms.macuonsach = Convert.ToString((sheetMuonSach.Cells[i, 2] as Excel.Range).Value); String date = Convert.ToString((sheetMuonSach.Cells[i, 3] as Excel.Range).Value); if (date != null) ms.ngaygiomuon = DateTime.Parse(date); String date1 = Convert.ToString((sheetMuonSach.Cells[i, 4] as Excel.Range).Value); if (date1 != null) ms.ngayhethan = DateTime.Parse(date1); String date2 = Convert.ToString((sheetMuonSach.Cells[i, 5] as Excel.Range).Value); if (date2 != null) ms.ngaygiotra = DateTime.Parse(date2); dataMuonSach.themMuonTraSach(ms); } xlWorkBook.Close(true, null, null); xlApp.Quit(); MessageBox.Show("Hoàn thành!"); noticeImport(); //releaseObject(xlWorkSheet); //releaseObject(xlWorkBook); //releaseObject(xlApp); }