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));
}
