public bool kt_dangnhap(string ten, string matkhau, string tenserver, string matkhauserver) { Lnhanvien nv = new Lnhanvien(); try { if (tenserver != "") { L_Ketnoi.strChuoiKN = L_Ketnoi.strChuoiKN + "; server= " + tenserver; if (matkhauserver != "") { L_Ketnoi.strChuoiKN = L_Ketnoi.strChuoiKN + " ; Password = "******"select * from nhanvien where matkhau = '" + matkhau + "' and tendangnhap = '" + ten + "'"); if (ds.Tables[0].Rows.Count == 0) { L_Ketnoi.HuyKetNoi(); return(false); } else { strmanhanvien = ds.Tables[0].Rows[0]["manhanvien"].ToString(); strhoten = ds.Tables[0].Rows[0]["hoten"].ToString(); strdiachi = ds.Tables[0].Rows[0]["diachi"].ToString(); strquyenhan = ds.Tables[0].Rows[0]["quyenhan"].ToString(); strnguoidung = ds.Tables[0].Rows[0]["tendangnhap"].ToString(); strmatkhau = ds.Tables[0].Rows[0]["matkhau"].ToString(); L_Ketnoi.HuyKetNoi(); return(true); } } catch { return(false); } }
public DataSet nangcao(string strsach, string tacgia, string strphanloai, string strngonngu) { string strkn = "select sach.masach as ' Mã Sách',sach.nhande as 'Nhan Đề',tacgia.tentacgia as 'Tên tác giả',ngonngu.ngonngu as 'Ngôn ngữ',sach.soluong as 'Sách còn',vitriluutru.kho, vitriluutru.ke as 'Kệ',vitriluutru.ngan as 'Ngăn' from tacgia,phanloai,ngonngu,sach,vitriluutru where sach.mavitri = vitriluutru.mavitri and sach.maphanloai = phanloai.maphanloai and tacgia.matacgia = sach.matacgia and sach.mangonngu = ngonngu.mangonngu and sach.nhande like N'%" + strsach + "%' "; if (tacgia != "") { strkn = strkn + " and tacgia.tentacgia like N'%" + tacgia + "%'"; } if (strphanloai != "") { strkn = strkn + " and phanloai.loai like N'%" + strphanloai + "%'"; } if (strngonngu != "") { strkn = strkn + " and ngonngu.ngonngu like N'%" + strngonngu + "%'"; } laydulieu dl = new laydulieu(); return(dl.getdata(strkn)); }
public DataSet coban(string strtk) { laydulieu dl = new laydulieu(); return(dl.getdata("select sach.masach as ' Mã Sách',sach.nhande as 'Nhan Đề',tacgia.tentacgia as 'Tên tác giả',ngonngu.ngonngu as 'Ngôn ngữ',sach.soluong as 'Sách còn',vitriluutru.kho, vitriluutru.ke as 'Kệ',vitriluutru.ngan as 'Ngăn' from tacgia,phanloai,ngonngu,sach,vitriluutru where sach.mavitri = vitriluutru.mavitri and sach.maphanloai = phanloai.maphanloai and tacgia.matacgia = sach.matacgia and sach.mangonngu = ngonngu.mangonngu and (sach.nhande like N'%" + strtk + "%' or tacgia.tentacgia like N'%" + strtk + "%' or sach.masach='" + strtk + "')")); }