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