public List <eChiTietPhieuDeNghiXuatKho> GetALLChitietPDNXKByMa(string SoPhieu)
{
var c = from i in db.ChiTietPhieuDNXKs
where i.MaPhieuDNXK == SoPhieu
select i;
List <eChiTietPhieuDeNghiXuatKho> ls = new List <eChiTietPhieuDeNghiXuatKho>();
foreach (ChiTietPhieuDNXK CT in c.ToList())
{
eChiTietPhieuDeNghiXuatKho ct = new eChiTietPhieuDeNghiXuatKho();
ct.SoPhieu = CT.MaPhieuDNXK;
ct.MaSP = CT.MaSP;
ct.SoLuong = CT.SoLuong;
ct.GhiChu = CT.GhiChu;
ls.Add(ct);
}
return(ls);
}
public int InsertPDNXKChiTiet(eChiTietPhieuDeNghiXuatKho Chitiet)
{
var sp = from i in db.SanPhams
where i.MaSP == Chitiet.MaSP
select i;
if (sp.Any())
{
var c = from i in db.ChiTietPhieuDNXKs
where i.MaSP == Chitiet.MaSP && i.MaPhieuDNXK == Chitiet.SoPhieu
select i;
if (c.Any())
{
return(0);
throw new Exception("There have already");
}
else
{
ChiTietPhieuDNXK newct = new ChiTietPhieuDNXK();
newct.MaPhieuDNXK = Chitiet.SoPhieu;
newct.MaSP = Chitiet.MaSP;
newct.GhiChu = Chitiet.GhiChu;
newct.SoLuong = Chitiet.SoLuong;
db.ChiTietPhieuDNXKs.InsertOnSubmit(newct);
db.SubmitChanges();
return(1);
}
}
else
{
return(2);
throw new Exception("Invaild SanPham");
}
}
public int ThemCTPDNXK(eChiTietPhieuDeNghiXuatKho Ct)
{
return(XK.InsertPDNXKChiTiet(Ct));
}
