private void addlistviewPM(phieu_muon a) { lvi = lvPM.Items.Add(a.Ma_doc_gia); lvi.SubItems.Add(a.Ma_phieu_muon); lvi.SubItems.Add(a.Ngay_muon.ToShortDateString()); lvi.SubItems.Add(a.Ngay_hen_tra.ToShortDateString()); lvi.SubItems.Add(a.Ma_sach_1); lvi.SubItems.Add(a.Ma_sach_2); }
private void nap_du_lieu_PM() { for (int i = ds_PM.count() - 1; i >= 0; i--) { ds_PM.removeat(i); } var query = from PM in a.PHIEUMUONs join CTPM in a.CTPMs on PM.MAPHIEUMUON equals CTPM.MAPHIEUMUON join DG in a.DOCGIAs on PM.MADOCGIA equals DG.MADOCGIA orderby PM.MAPHIEUMUON ascending select new { MaPM = PM.MAPHIEUMUON, MaDG = PM.MADOCGIA, Ngaymuon = PM.NGAYMUON, NgayHentra = PM.NGAYHENTRA, ma_sach = CTPM.MASACH, }; var c = query.Except(from PM in a.PHIEUMUONs join PT in a.PHIEUTRAs on PM.MAPHIEUMUON equals PT.MAPHIEUMUON join CTPM in a.CTPMs on PM.MAPHIEUMUON equals CTPM.MAPHIEUMUON join DG in a.DOCGIAs on PM.MADOCGIA equals DG.MADOCGIA orderby PM.MAPHIEUMUON ascending select new { MaPM = PM.MAPHIEUMUON, MaDG = PM.MADOCGIA, Ngaymuon = PM.NGAYMUON, NgayHentra = PM.NGAYHENTRA, ma_sach = CTPM.MASACH, }); foreach (var tmp in c) { phieu_muon a = new phieu_muon(tmp.MaPM, tmp.MaDG, tmp.Ngaymuon, tmp.NgayHentra, tmp.ma_sach, ""); ds_PM.add(a); } for (int i = 0; i < ds_PM.count() - 1; i++) { if (ds_PM[i].Ma_phieu_muon.Equals(ds_PM[i + 1].Ma_phieu_muon)) { ds_PM[i].Ma_sach_2 = ds_PM[+1].Ma_sach_1; ds_PM.removeat(i + 1); } } }
private void btMuon_Click(object sender, EventArgs e) { string ngay_hen = dtpkNgay_hen_tra.Value.Date.ToShortDateString(); DateTime ngayhen = Convert.ToDateTime(ngay_hen); TimeSpan limit = ngayhen - DateTime.Now; if (DateTime.Now > ngayhen) { this.errorProvider1.SetError(dtpkNgay_hen_tra, "Ngay hen tra phai sau ngay cho muon."); } else { if (limit.Days > 60) { this.errorProvider1.SetError(dtpkNgay_hen_tra, "Ngay muon toi da la 60 ngay"); } else { this.errorProvider1.Clear(); if (tbMa_doc_gia.Text != "") { var c = from b in a.PHIEUMUONs orderby b.MAPHIEUMUON descending select b; string t = ""; foreach (var tmp1 in c) { t = tmp1.MAPHIEUMUON; break; } t = t.Remove(0, 2); if (tbMa_sach_1.Text != "" || tbMa_sach_2.Text != "") { DateTime mm = Convert.ToDateTime(DateTime.Now.ToShortDateString()); string tmp = "PM"; if ((Convert.ToInt32(t) + 1) < 10) { tmp += "0"; } phieu_muon PM = new phieu_muon(tmp + (Convert.ToInt32(t) + 1).ToString(), tbMa_doc_gia.Text, mm, ngayhen, tbMa_sach_1.Text, tbMa_sach_2.Text); ds_PM.add(PM); loadlistPM(); add_lvSach(); MessageBox.Show("Cho muon thanh cong"); PHIEUMUON PMmoi = new PHIEUMUON(); PMmoi.MAPHIEUMUON = tmp + (Convert.ToInt32(t) + 1).ToString(); PMmoi.MADOCGIA = tbtim_Ma_doc_gia.Text; PMmoi.NGAYHENTRA = ngayhen; PMmoi.NGAYMUON = mm; a.PHIEUMUONs.InsertOnSubmit(PMmoi); CTPM ctpm_moi1 = new CTPM(); CTPM ctpm_moi2 = new CTPM(); ctpm_moi1.MAPHIEUMUON = tmp + (Convert.ToInt32(t) + 1).ToString(); ctpm_moi2.MAPHIEUMUON = tmp + (Convert.ToInt32(t) + 1).ToString(); if (PM.Ma_sach_1 != "") { ctpm_moi1.MASACH = PM.Ma_sach_1; a.CTPMs.InsertOnSubmit(ctpm_moi1); a.SubmitChanges(); } if (PM.Ma_sach_2 != "") { ctpm_moi2.MASACH = PM.Ma_sach_2; a.CTPMs.InsertOnSubmit(ctpm_moi2); a.SubmitChanges(); } loadlistPM(); cleardata(); } else { MessageBox.Show("Chua chon sach"); } } else { MessageBox.Show("Chua nhap ma doc gia"); } } } }
public void add(phieu_muon a) { ds.Add(a); }