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 + "'"); }