private void btnslcon_Click(object sender, EventArgs e)
{
txtsoluong.Text =
DAO.GetFieldValues("SELECT sachtruyen.soluong FROM sachtruyen join" +
" chitietthuesach on sachtruyen.masach=chitietthuesach.masach WHERE" +
" sachtruyen.masach = N'" + txtmasach.Text + "'");
}
private void hienthi()
{
txthienthi.Text = DAO.GetFieldValues("select sum(DATEDIFF(day,c.ngaythue,f.ngaytra)*(a.dongiathue)+i.tienphat) as [tong tien hoa don thue] from sachtruyen a join chitietthuesach b on a.masach = b.masach join thuesach c on c.mathue = b.mathue join chitiettrasach d on d.masach = a.masach join trasach f on f.matra = d.matra join vipham i on i.mavipham = d.mavipham where datepart(month,f.ngaytra)='" + txtdtt.Text + "' and datepart(year, f.ngaytra) = '" + txtnam.Text + "'");
}
private void btntinhtien_Click(object sender, EventArgs e)
{
txttinhtien.Text = DAO.GetFieldValues("select sum(DATEDIFF(day,c.ngaythue,f.ngaytra)*(a.dongiathue)+i.tienphat) as [tong tien hoa don thue] from sachtruyen a join chitietthuesach b on a.masach = b.masach join thuesach c on c.mathue = b.mathue join chitiettrasach d on d.masach = a.masach join trasach f on f.matra = d.matra join vipham i on i.mavipham = d.mavipham where f.matra='" + txtmatra.Text + "'");
}
private void btnslcon_Click(object sender, EventArgs e)
{
txtsoluong.Text = DAO.GetFieldValues("SELECT sachtruyen.soluong FROM sachtruyen WHERE sachtruyen.masach = '" + txtmasach.Text + "'");
}