public void ThemChiTietPhieuMuon(DTO_PhieuMuon DTO) { string strSql = "usp_ThemChiTietPhieuMuon"; DBConnect provider = new DBConnect(); provider.Connect(); provider.ExecuteNonQuery(CommandType.StoredProcedure, strSql, new SqlParameter { ParameterName = "@MaCTPM", Value = DTO.MaCTPM }, new SqlParameter { ParameterName = "@MaTaiLieu", Value = DTO.MaTaiLieuMuon }, new SqlParameter { ParameterName = "@MaPhieuMuon", Value = DTO.MaPhieuMuon }); provider.Disconnect(); }
public int ThemPhieuMuon(DTO_PhieuMuon DTO) { string strSql = "usp_ThemPhieuMuon"; DBConnect provider = new DBConnect(); provider.Connect(); SqlParameter p = new SqlParameter("@result", SqlDbType.Int); p.Direction = ParameterDirection.Output; provider.ExecuteNonQuery(CommandType.StoredProcedure, strSql, new SqlParameter { ParameterName = "@MaNVLapPhieuMuon", Value = DTO.MaNhanVienLapPhieuMuon }, new SqlParameter { ParameterName = "@MaDocGia", Value = DTO.MaDocGiaMuon }, p); provider.Disconnect(); return(Int32.Parse(p.Value.ToString())); }
public void UpdatePhieuMuon(DTO_PhieuMuon PM) { string strSql = "usp_CapNhatPhieuMuon"; DBConnect provider = new DBConnect(); provider.Connect(); provider.ExecuteNonQuery(CommandType.StoredProcedure, strSql, new SqlParameter { ParameterName = "@MaCTPM", Value = PM.MaCTPM }, new SqlParameter { ParameterName = "@MaTaiLieu", Value = PM.MaTaiLieuMuon }, new SqlParameter { ParameterName = "@MaTaiLieuCu", Value = PM.MaTaiLieuCu }, new SqlParameter { ParameterName = "@MaPhieuMuon", Value = PM.MaPhieuMuon }); provider.Disconnect(); }
public void CapNhatDocGia_INSERT(DTO_PhieuMuon dl) { xl.table_Command("UPDATE TheDocGia SET TrangThai_TheDocGia = N'Quá giới hạn' WHERE ID_TheDocGia = " + dl.ID_TheDocGia + ""); }
public DataTable CapNhatQuaHan_Select(DTO_PhieuMuon dl) { return(xl.table_Select("select count(ID_PhieuMuonSach) as KetQua from PhieuMuonSach where ID_TheDocGia =" + dl.ID_TheDocGia + "")); }
public DataTable ShowKetQua_Select(DTO_PhieuMuon dl) { return(xl.table_Select("select count(ID_PhieuMuonSach) as KetQua from PhieuMuonSach, TheDocGia, Sach, TheLoaiSach where PhieuMuonSach.ID_TheDocGia = TheDocGia.ID_TheDocGia and Sach.ID_Sach = PhieuMuonSach.ID_Sach and Sach.ID_TheLoaiSach = TheLoaiSach.ID_TheLoaiSach and Ten_TheLoaiSach=N'" + dl.LayTheLoaiThongKe + "' and DAY(NgayMuon) = " + dl.LayNgayMuon + "")); }
public DataTable ChonTheLoaiSach_Select(DTO_PhieuMuon dl) { return(xl.table_Select("select ID_TheLoaiSach,Ten_TheLoaiSach from TheLoaiSach")); }
public DataTable LoadPhieuMuonTre_Select(DTO_PhieuMuon dl) { return(xl.table_Select("select ID_PhieuMuonSach, HoTen_DocGia, Ten_Sach, Ten_TheLoaiSach, CONVERT(varchar(20), NgayMuon, 103) as NgayMuon,GhiChu,TrangThai_PhieuMuon from PhieuMuonSach,TheDocGia,Sach,TheLoaiSach where PhieuMuonSach.ID_TheDocGia = TheDocGia.ID_TheDocGia and Sach.ID_Sach = PhieuMuonSach.ID_Sach and Sach.ID_TheLoaiSach = TheLoaiSach.ID_TheLoaiSach and TrangThai_PhieuMuon = N'Quá hạn' and NgayMuon ='" + dl.LayNgayThongKe + "'"));// and NgayMuon =N'03/07/2019' }
public bool suaPM(DTO_PhieuMuon pm) { return(dalphieumuon.suaPM(pm)); }
public void ThemChiTietPhieuMuon(DTO_PhieuMuon DTO) { dal_Phieu.ThemChiTietPhieuMuon(DTO); }
public DataTable NguoiMuon_Select(DTO_PhieuMuon dl) { return(xl.table_Select("Select HoTen_DocGia from TheDocGia where ID_TheDocGia=" + dl.ID_TheDocGia + "")); }
public DataTable ChonSachMuon_Select(DTO_PhieuMuon dl) { return(xl.table_Select("Select ID_PhieuMuonSach,ID_TheDocGia,ID_Sach,NgayMuon,NgayHenTra,GhiChu,TrangThai_PhieuMuon from PhieuMuonSach order by ID_PhieuMuonSach desc")); }
public DataTable Sach_Select(DTO_PhieuMuon dl) { return(xl.table_Select("select ID_Sach,Ten_Sach from Sach where TrangThai_MuonSach =N''")); }
public DataTable DocGia_Select(DTO_PhieuMuon dl) { return(xl.table_Select("select ID_TheDocGia,HoTen_DocGia from TheDocGia where TrangThai_TheDocGia =''")); }
public void CapNhatSach_INSERT(DTO_PhieuMuon dl) { xl.table_Command("UPDATE Sach SET TrangThai_MuonSach = N'Đã được mượn' WHERE ID_Sach = " + dl.ID_Sach + ""); }
public void LapPhieuMuon_INSERT(DTO_PhieuMuon dl) { xl.table_Command("set dateformat dmy Insert into PhieuMuonSach Values ('" + dl.ID_TheDocGia + "',N'" + dl.ID_Sach + "','" + dl.Ten_NguoiMuon + "','" + dl.NgayMuon + "','" + dl.NgayHenTra + "','" + dl.Sl_SachMuon + "','" + dl.GhiChu + "','" + dl.TrangThai_PhieuMuon + "')"); }
public int ThemPhieuMuon(DTO_PhieuMuon DTO) { return(dal_Phieu.ThemPhieuMuon(DTO)); }
public DataTable LoadPhieuMuon_Select(DTO_PhieuMuon dl) { return(xl.table_Select("select ID_PhieuMuonSach, HoTen_DocGia,Ten_Sach,Ten_TheLoaiSach,CONVERT(varchar(20),NgayMuon,103) as NgayMuon,GhiChu,TrangThai_PhieuMuon from PhieuMuonSach,TheDocGia,Sach,TheLoaiSach where PhieuMuonSach.ID_TheDocGia=TheDocGia.ID_TheDocGia and Sach.ID_Sach = PhieuMuonSach.ID_Sach and Sach.ID_TheLoaiSach = TheLoaiSach.ID_TheLoaiSach and Ten_TheLoaiSach=N'" + dl.LayTheLoaiThongKe + "' and DAY(NgayMuon) = " + dl.LayNgayMuon + "")); }
public void UpdatePhieuMuon(DTO_PhieuMuon PM) { dal_Phieu.UpdatePhieuMuon(PM); }
public bool addPM(DTO_PhieuMuon pm) { return(dalphieumuon.AddPM(pm)); }