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