public void Update(MaterielOutStoreBillHd hd, List <MaterielOutStoreBillDtl> dtl) { using (DCC dcc = DBMLFty.Dcc) { DALFty.Create <MaterielOutStoreBillDAL>().Update(dcc, hd, dtl); dcc.Save(); } }
public void Insert(DCC dcc, MaterielOutStoreBillHd hd, List <MaterielOutStoreBillDtl> dtl) { using (TransactionScope ts = new TransactionScope()) { dcc.MaterielOutStoreBillHd.InsertOnSubmit(hd); dcc.MaterielOutStoreBillDtl.InsertAllOnSubmit(dtl); dcc.SubmitChanges(); ts.Complete(); } }
public void Update(DCC dcc, MaterielOutStoreBillHd hd, List <MaterielOutStoreBillDtl> dtl) { using (TransactionScope ts = new TransactionScope()) { dcc.MaterielOutStoreBillHd.Attach(hd); dcc.Refresh(System.Data.Linq.RefreshMode.KeepCurrentValues, hd); //更新明细可能有新增记录,所有先将原有记录删除再全部添加 var lstHd = dcc.MaterielOutStoreBillDtl.Where(o => o.HdID == hd.ID); dcc.MaterielOutStoreBillDtl.DeleteAllOnSubmit(lstHd); foreach (MaterielOutStoreBillDtl item in dtl) { item.ID = Guid.NewGuid(); item.HdID = hd.ID; } dcc.MaterielOutStoreBillDtl.InsertAllOnSubmit(dtl); dcc.SubmitChanges(); ts.Complete(); } }