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