public bool ThemSPvaoDSHangXuat(DSHANGXUAT ds) { try { ds.ThanhTien = pn.ThanhTien(1, ds.MASP); qlkho.DSHANGXUATs.InsertOnSubmit(ds); qlkho.SubmitChanges(); return(true); } catch { return(false); } }
public void XoaDSPhieuXuat(string mapx, int dem) { for (int i = 0; i <= dem; i++) { DSHANGXUAT p = qlkho.DSHANGXUATs.Where(t => t.MAPX == mapx).FirstOrDefault(); if (p == null) { return; } else { qlkho.DSHANGXUATs.DeleteOnSubmit(p); qlkho.SubmitChanges(); } } }
public bool SuaTTDSPhieuXuat(DSHANGXUAT ds) { try { var k = qlkho.DSHANGXUATs.Where(t => t.MAPX == ds.MAPX).Where(t => t.MASP == ds.MASP).FirstOrDefault(); ds.SoLuong = k.SoLuong + 1; int n = (int)ds.SoLuong; string ma = ds.MASP.ToString(); ds.ThanhTien = pn.ThanhTien(n, ma); qlkho.DSHANGXUATs.DeleteOnSubmit(k); qlkho.DSHANGXUATs.InsertOnSubmit(ds); qlkho.SubmitChanges(); return(true); } catch { return(false); } }