public bool Kiemtrasutontai(string maphieu)
{
Tbl_PhieuXK pxk = DB.Tbl_PhieuXKs.Where(x => x.maPhieuXuat == maphieu).FirstOrDefault();
if (pxk == null)
{
return(false);
}
return(true);
}
public bool DeletePhieuXK(string delid)
{
try
{
Tbl_PhieuXK deletema = DB.Tbl_PhieuXKs.Single(x => x.maPhieuXuat == delid);
DB.Tbl_PhieuXKs.DeleteOnSubmit(deletema);
DB.SubmitChanges();
return(true);
}
catch
{
return(false);
}
}
public bool UpDatePhieuNK(ePhieuXK updatepxk)
{
try
{
Tbl_PhieuXK pxk = DB.Tbl_PhieuXKs.Single(x => x.maPhieuXuat == updatepxk._maPhieuXuat);
pxk.maPhieuXuat = updatepxk._maPhieuXuat;
pxk.ngayLapXuat = Convert.ToDateTime(updatepxk._ngayLapXuat);
pxk.maNV = updatepxk._maNV;
pxk.tinhTrang = updatepxk._tinhTrang;
DB.SubmitChanges();
return(true);
}
catch
{
return(false);
}
}
public int ThemPhieuXuatKho(ePhieuXK newpxk)
{
if (Kiemtrasutontai(newpxk._maPhieuXuat))
{
return(0);
}
Tbl_PhieuXK pxkTmp = new Tbl_PhieuXK();
pxkTmp.maPhieuXuat = newpxk._maPhieuXuat;
pxkTmp.ngayLapXuat = newpxk._ngayLapXuat;
pxkTmp.maNV = newpxk._maNV;
pxkTmp.maKho = newpxk._maKho;
pxkTmp.tinhTrang = newpxk._tinhTrang;
DB.Tbl_PhieuXKs.InsertOnSubmit(pxkTmp);
DB.SubmitChanges();
return(1);
}
public bool AddAllPhieuNK(ePhieuXK newpxk)
{
try
{
Tbl_PhieuXK pxk = DB.Tbl_PhieuXKs.Single(x => x.maPhieuXuat == newpxk._maPhieuXuat);
pxk.maPhieuXuat = newpxk._maPhieuXuat;
pxk.ngayLapXuat = Convert.ToDateTime(newpxk._ngayLapXuat);
pxk.maNV = newpxk._maNV;
pxk.tinhTrang = newpxk._tinhTrang;
DB.Tbl_PhieuXKs.InsertOnSubmit(pxk);
DB.SubmitChanges();
return(true);
}
catch
{
return(false);
}
}
