public List <ePhieuDNXK> laydanhsachPhieuDNXK() { var listphieuDNXK = db.Tbl_PhieuDNXKs.ToList(); List <ePhieuDNXK> ls = new List <ePhieuDNXK>(); var k = db.Tbl_PhieuXKs.ToList(); int kq; foreach (Tbl_PhieuDNXK xk in listphieuDNXK) { kq = 0; ePhieuDNXK ednxk = new ePhieuDNXK(); ednxk.maKho = xk.maKho; ednxk.maNV = xk.maNV; ednxk.ngayLap = xk.ngayLap; ednxk.soPDNXK = xk.soPDNNK; foreach (Tbl_PhieuXK i in k) { ePhieuNK epnk = new ePhieuNK(); epnk._maPhieuNhap = i.maPhieuXuat; if (ednxk.soPDNXK == epnk._maPhieuNhap) { kq = 1; } } if (kq == 0) { ls.Add(ednxk); } } return(ls); }
public int themPDNXK(ePhieuDNXK PDNXK) { var tPDNXK = db.Tbl_PhieuDNXKs.Where(x => x.soPDNNK == PDNXK.soPDNXK).FirstOrDefault(); if (tPDNXK != null) { return(0); } Tbl_PhieuDNXK p = new Tbl_PhieuDNXK(); p.soPDNNK = PDNXK.soPDNXK; p.maNV = PDNXK.maNV; p.ngayLap = Convert.ToDateTime(PDNXK.ngayLap); p.maKho = PDNXK.maKho; db.Tbl_PhieuDNXKs.InsertOnSubmit(p); db.SubmitChanges(); return(1); }
private void btnthemdnxk_Click(object sender, EventArgs e) { ePhieuDNXK p = new ePhieuDNXK(); p.soPDNXK = txtsophieudnxk.Text; p.ngayLap = Convert.ToString(dtpngaylapphieudnxk.Text); p.maNV = txtMaNV.Text; p.maKho = Convert.ToString(cmbMKho.Text); int m = pdnxkbll.themPDNXK(p); if (m == 1) { MessageBox.Show("Thêm thành công"); } else { MessageBox.Show("Thêm thất bại"); } dgvPDNXK.DataSource = pdnxkbll.getAllPDNXK(); btnSua.Enabled = true; }
public PhieuDNXK_BLL(ePhieuDNXK pdn) { this.pdn = pdn; ctp = new List <eCTPhieuDNNK>(); }