private void textBoxX3_TextChanged(object sender, EventArgs e) { string TimKiemTS = @"select TenSach,TacGia,NXB from SACH where TenSach LIKE N'%" + textBoxX3.Text + "%'"; DataTable dt = DatabaseService.getDataTable(TimKiemTS); dataSach.DataSource = dt; }
// Load Sách public void Load_DataSach() { string str = @"select TenSach,TacGia,NXB from SACH"; DataTable dt = DatabaseService.getDataTable(str); dataSach.DataSource = dt; }
private void btnDangNhap_Click(object sender, EventArgs e) { if (txtTaiKhoan.Text == "" || txtMatKhau.Text == "") { MessageBox.Show("Bạn chưa nhập tên đăng nhập hoặc mật khẩu!", "Thông báo"); return; } DataTable dt = DatabaseService.getDataTable("Select * from NGUOIDUNG where ID = '" + txtTaiKhoan.Text + "' and Password = '******'"); if (dt.Rows.Count > 0) { MessageBox.Show("Xin chào: " + txtTaiKhoan.Text + "!\nBạn đã đăng nhập thành công!", "Thông báo"); this.Hide(); Form main = new frmMain("admin", "admin"); main.Show(); } else { MessageBox.Show("Đăng nhập không thành công!", "Thông báo"); txtTaiKhoan.Clear(); txtMatKhau.Clear(); txtTaiKhoan.Focus(); } }
// Load Ngày Mượn public void Load_Ngay() { string sqlcboxSup_ = "select * from CHITIETHOADON where MaPM='" + cboxMaPM.Text + "'"; // tới đây!! cboxNgayMuon.DisplayMember = "NgayThue"; cboxNgayMuon.DataSource = DatabaseService.getDataTable(sqlcboxSup_); }
// Load ĐG public void Load_cboxDG() { string dt = "select * from DOCGIA"; cboxMaDG.DisplayMember = "MaDG"; cboxMaDG.DataSource = DatabaseService.getDataTable(dt); }
private void txtTim_TextChanged(object sender, EventArgs e) { string TimKiemTS = @"select * from TACGIA where TenTG LIKE N'%" + txtTim.Text + "%'"; DataTable dt = DatabaseService.getDataTable(TimKiemTS); dataTacGia.DataSource = dt; }
// Load ĐG public void Load_cboxTenDG() { string dt = "select * from DOCGIA where MaDG='" + cboxMaDG.Text + "'"; cboxTenDG.DisplayMember = "TenDG"; cboxTenDG.DataSource = DatabaseService.getDataTable(dt); }
private void textBoxX2_TextChanged(object sender, EventArgs e) { string TimKiemTS = @"select TenTL from THELOAI where TenTL LIKE N'%" + textBoxX2.Text + "%'"; DataTable dt = DatabaseService.getDataTable(TimKiemTS); dataTheLoai.DataSource = dt; }
public void Load_Data() { string str = @"select * from TACGIA"; DataTable dt = DatabaseService.getDataTable(str); dataTacGia.DataSource = dt; }
private void txtTim_TextChanged(object sender, EventArgs e) { string TimKiemTS = @"select * from NGUOIDUNG where ID LIKE N'%" + txtTim.Text + "%'"; DataTable dt = DatabaseService.getDataTable(TimKiemTS); dataNguoiDung.DataSource = dt; }
public void Load_Data() { string str = @"select * from NGUOIDUNG"; DataTable dt = DatabaseService.getDataTable(str); dataNguoiDung.DataSource = dt; }
public void Load_Data() { string str = @"select * from NXB"; DataTable dt = DatabaseService.getDataTable(str); dataNXB.DataSource = dt; }
// Load TL Sách public void Load_dataTL() { string str = @"select TenTL from THELOAI"; DataTable dt = DatabaseService.getDataTable(str); dataTheLoai.DataSource = dt; }
// Load Mã Phiếu Mượn public void Load_cboxPM() { string dt = "select * from HOADON where MaDG='" + cboxMaDG.Text + "'"; cboxMaPM.DisplayMember = "MaPM"; cboxMaPM.DataSource = DatabaseService.getDataTable(dt); }
public void Load_Muon() { //string Muon = @"select MaSach,TenSach from tblSach where MaSach=(select MaSach from tblChiTietMuon where tblChiTietMuon.MaPM='"+cboxMaPM.Text+"' and tblChiTietMuon.NgayThue='"+cboxNgayMuon.Text+"')"; string Muon = @"select MaSach,TenSach from SACH where MaSach=( select MaSach from CHITIETHOADON where (CHITIETHOADON.MaPM='" + cboxMaPM.Text + "' and CHITIETHOADON.NgayThue='" + cboxNgayMuon.Text + "' and SACH.MaSach=CHITIETHOADON.MaSach))"; //MessageBox.Show(Muon); DataTable dt = DatabaseService.getDataTable(Muon); dataSach.DataSource = dt; }
private void frmRPDSSach_Load(object sender, EventArgs e) { DataTable dt = new DataTable(); dt = DatabaseService.getDataTable("select * from sach"); RPDSSach rp = new RPDSSach(); rp.SetDataSource(dt); crystalReportViewer1.ReportSource = rp; }
private void dataTheLoai_CellMouseClick(object sender, DataGridViewCellMouseEventArgs e) { string s = ""; try { DataGridViewRow row = new DataGridViewRow(); row = dataTheLoai.Rows[e.RowIndex]; s = row.Cells[0].Value.ToString(); //MessageBox.Show(s); string str = @"select TenSach,TacGia,NXB from SACH where TheLoai=N'" + s + "'"; DataTable dt = DatabaseService.getDataTable(str); dataSach.DataSource = dt; } catch (Exception) { } }
private void btnTheLoai_Click(object sender, EventArgs e) { string MaPM; string sql = " select MaPM from HOADON"; DataTable tb = DatabaseService.getDataTable(sql); int s = tb.Rows.Count; if (tb.Rows.Count < 1) { MaPM = "PM0001"; } else { MaPM = sinhMa(); } txtMaPM.Text = MaPM; }
private void buttonX1_Click(object sender, EventArgs e) { string currTime = DateTime.Now.Date.ToShortDateString(); if (Convert.ToString(listBox1.SelectedItem) == "Báo cáo tên 10 đầu sách được mượn nhiều nhất.") { string str = @"SELECT TOP(10) MaSach,TenSach,TacGia,NXB,SLMuon FROM SACH ORDER BY SLMuon DESC;"; DataTable dt = DatabaseService.getDataTable(str); dataHienThi.DataSource = dt; } // if (Convert.ToString(listBox1.SelectedItem) == "Danh mục sách không được mượn lần nào.") { string str = @"SELECT MaSach,TenSach,TacGia,NXB,SLMuon FROM SACH where SLMuon=0"; DataTable dt = DatabaseService.getDataTable(str); dataHienThi.DataSource = dt; } // if (Convert.ToString(listBox1.SelectedItem) == "Danh mục sách đang được mượn.") { try { string str = @"select MaSach,TenSach,TacGia,NXB from SACH where MaSach=(select MaSach from CHITIETHOADON where CHITIETHOADON.MaSach=SACH.MaSach)"; DataTable dt = DatabaseService.getDataTable(str); dataHienThi.DataSource = dt; } catch (Exception) { } //MessageBox.Show(DateTime.Now.Date.ToShortDateString()); } // if (Convert.ToString(listBox1.SelectedItem) == "Danh mục sách đã quá hạn trả.") { string str = @"SELECT MaSach,TenSach,TacGia,NXB from SACH where MaSach=(select MaSach from CHITIETHOADON where NgayTra <'" + currTime + "')"; DataTable dt = DatabaseService.getDataTable(str); dataHienThi.DataSource = dt; } if (Convert.ToString(listBox1.SelectedItem) == "Danh sách sinh viên bị phạt vì trả quá hạn.") { string str = @"select * from DOCGIA where MaDG=(select MaDG from HOADON,CHITIETHOADON where HOADON.MaPM=CHITIETHOADON.MaPM and CHITIETHOADON.NgayTra<'" + currTime + "')"; DataTable dt = DatabaseService.getDataTable(str); dataHienThi.DataSource = dt; } }
public void Load_cboxTheLoai() { string dt = "select * from THELOAI"; cboxTheLoai.DisplayMember = "TenTL"; cboxTheLoai.DataSource = DatabaseService.getDataTable(dt); }
private void txtTim_TextChanged(object sender, EventArgs e) { string TimKiemTS = @"select * from SACH where TenSach LIKE N'%" + txtTim.Text + "%' or TacGia LIKE N'%" + txtTim.Text + "%' or TheLoai LIKE N'%" + txtTim.Text + "%'"; DataTable dt = DatabaseService.getDataTable(TimKiemTS); dataSach.DataSource = dt; }
// Load Tác Giả public void Load_cboxTacGia() { string dt = "select * from TACGIA"; cboxTacGia.DisplayMember = "TenTG"; cboxTacGia.DataSource = DatabaseService.getDataTable(dt); }
public void Load_cboxNXB() { string dt = "select * from NXB"; cboxNXB.DisplayMember = "TenNXB"; cboxNXB.DataSource = DatabaseService.getDataTable(dt); }