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