public List <VOutStoreBill> GetOutStoreBill()
{
using (DCC dcc = DBMLFty.Dcc)
{
return(DALFty.Create <OutStoreBillDAL>().GetOutStoreBill(dcc));
}
}
public List <MaterielOutStoreBillDtl> GetVBillDtlByBOM(Guid hdID)
{
using (DCC dcc = DBMLFty.Dcc)
{
return(DALFty.Create <MaterielOutStoreBillDAL>().GetVBillDtlByBOM(dcc, hdID));
}
}
public OutStoreBillHd GetOutStoreBillHd(Guid id)
{
using (DCC dcc = DBMLFty.Dcc)
{
return(DALFty.Create <OutStoreBillDAL>().GetOutStoreBillHd(dcc, id));
}
}
public void FinishUnlistedGoods(List <UnlistedGoodsLog> dtlList)
{
using (WmsContext db = EDMXFty.Dc)
{
DALFty.Create <InventoryDAL>().FinishUnlistedGoods(db, dtlList);
}
}
public void FinishCheck(SystemStatus systemStatus, StocktakingLogHd hd, List <ProfitAndLossLog> plLogList, List <InventoryLossLog> lossLogList, List <UnlistedGoodsLog> ugLogList, List <InventoryLog> stockLogList)
{
using (WmsContext db = EDMXFty.Dc)
{
DALFty.Create <InventoryDAL>().FinishCheck(db, systemStatus, hd, plLogList, lossLogList, ugLogList, stockLogList);
}
}
public List <CustomerSLSalePrice> GetCustomerSLSalePrice()
{
using (DCC dcc = DBMLFty.Dcc)
{
return(DALFty.Create <CustomerSLSalePriceDAL>().GetCustomerSLSalePrice(dcc));
}
}
public List <MaterielInStoreBillDtl> GetMaterielInStoreBillDtl(Guid hdID)
{
using (DCC dcc = DBMLFty.Dcc)
{
return(DALFty.Create <MaterielInStoreBillDAL>().GetMaterielInStoreBillDtl(dcc, hdID));
}
}
/// <summary>
/// 海量数据修改方法
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="list"></param>
public virtual void UpdateByBulk <T>(List <T> list) where T : class, new()
{
using (WmsContext db = EDMXFty.Dc)
{
DALFty.Create <EfPlusDAL>().UpdateByBulk <T>(db, list);
}
}
/// <summary>
/// 执行查询操作
/// </summary>
/// <typeparam name="db"></typeparam>
/// <param name="type">实体类型名称</param>
/// <param name="filter">where条件</param>
/// <returns></returns>
public virtual IList ExecuteQuery(Type type, string filter)
{
using (WmsContext db = EDMXFty.Dc)
{
return(DALFty.Create <BaseDAL>().ExecuteQuery(db, type, filter));
}
}
public void Insert(UsersInfo obj, List <Permission> pList, List <ButtonPermission> btnList)
{
using (WmsContext db = EDMXFty.Dc)
{
DALFty.Create <UsersInfoDAL>().Insert(db, obj, pList, btnList);
}
}
public void SaveProfitAndLoss(SystemStatus systemStatus, StocktakingLogHd hd, List <StocktakingLogDtl> dtlList, List <ProfitAndLoss> insertList, List <ProfitAndLoss> updateList)
{
using (WmsContext db = EDMXFty.Dc)
{
DALFty.Create <InventoryDAL>().SaveProfitAndLoss(db, systemStatus, hd, dtlList, insertList, updateList);
}
}
public MaterielInStoreBillHd GetMaterielInStoreBillHd(Guid id)
{
using (DCC dcc = DBMLFty.Dcc)
{
return(DALFty.Create <MaterielInStoreBillDAL>().GetMaterielInStoreBillHd(dcc, id));
}
}
public string GetMaxBillNo()
{
using (DCC dcc = DBMLFty.Dcc)
{
return(DALFty.Create <MaterielInStoreBillDAL>().GetMaxBillNo(dcc));
}
}
public void Update(List <Permission> opList, List <ButtonPermission> btnList)
{
using (WmsContext db = EDMXFty.Dc)
{
DALFty.Create <PermissionDAL>().Update(db, opList, btnList);
}
}
public List <VMaterielInStoreBill> GetMaterielInStoreBill()
{
using (DCC dcc = DBMLFty.Dcc)
{
return(DALFty.Create <MaterielInStoreBillDAL>().GetMaterielInStoreBill(dcc));
}
}
/// <summary>
/// 根据条件删除(支持批量删除)
/// </summary>
/// <param name="delWhere">传入Lambda表达式(生成表达式目录树)</param>
/// <returns></returns>
public virtual int DeleteByBulk <T>(Expression <Func <T, bool> > delWhere) where T : class, new()
{
using (WmsContext db = EDMXFty.Dc)
{
return(DALFty.Create <EfPlusDAL>().DeleteByBulk <T>(db, delWhere));
}
}
/// <summary>
/// 执行查询操作
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="sql"></param>
/// <param name="pars"></param>
/// <returns></returns>
public virtual List <T> ExecuteQuery <T>(string sql, params SqlParameter[] pars)
{
using (WmsContext db = EDMXFty.Dc)
{
return(DALFty.Create <BaseDAL>().ExecuteQuery <T>(db, sql, pars));
}
}
/// <summary>
/// 海量数据插入方法
/// </summary>
/// <typeparam name="db"></typeparam>
/// <param name="list"></param>
public virtual void AddByBulkCopy <T>(List <T> list) where T : class, new()
{
using (WmsContext db = EDMXFty.Dc)
{
DALFty.Create <BaseDAL>().AddByBulkCopy <T>(db, list);
}
}
/// <summary>
/// 海量数据插入和更新方法
/// </summary>
/// <param name="insertList">插入的实体列表</param>
/// <param name="updateList">更新实体列表</param>
/// <returns></returns>
public virtual void AddAndUpdate <T>(List <T> insertList, List <T> updateList) where T : class, new()
{
using (WmsContext db = EDMXFty.Dc)
{
DALFty.Create <BaseDAL>().AddAndUpdate <T>(db, insertList, updateList);
}
}
/// <summary>
/// 添加或更新实体
/// </summary>
/// <param name="entity">实体</param>
/// <returns></returns>
public int AddOrUpdate <T>(T entity) where T : class, new()
{
using (WmsContext db = EDMXFty.Dc)
{
return(DALFty.Create <BaseDAL>().AddOrUpdate <T>(db, entity));
}
}
/// <summary>
/// 贪婪加载查询
/// </summary>
/// <typeparam name="T">实体类型</typeparam>
/// <param name="path">贪婪加载实体</param>
/// <returns></returns>
public virtual List <T> GetListByInclude <T>(string path) where T : class, new()
{
using (WmsContext db = EDMXFty.Dc)
{
return(DALFty.Create <BaseDAL>().GetListByInclude <T>(db, path));
}
}
/// <summary>
/// 先删除再添加(批量操作)
/// </summary>
/// <param name="delWhere">传入Lambda表达式(生成表达式目录树)</param>
/// <param name="insertList">插入列表</param>
/// <returns></returns>
public virtual void DeleteAndAdd <T>(Expression <Func <T, bool> > delWhere, List <T> insertList) where T : class, new()
{
using (WmsContext db = EDMXFty.Dc)
{
DALFty.Create <BaseDAL>().DeleteAndAdd <T>(db, delWhere, insertList);
}
}
/// <summary>
/// 根据条件查询
/// </summary>
/// <param name="whereLambda">查询条件(lambda表达式的形式生成表达式目录树)</param>
/// <returns></returns>
public virtual List <T> GetListBy <T>(Expression <Func <T, bool> > whereLambda) where T : class, new()
{
using (WmsContext db = EDMXFty.Dc)
{
return(DALFty.Create <BaseDAL>().GetListBy <T>(db, whereLambda));
}
}
/// <summary>
/// 修改
/// </summary>
/// <param name="model">修改后的实体</param>
/// <returns></returns>
public virtual int Modify <T>(T model) where T : class, new()
{
using (WmsContext db = EDMXFty.Dc)
{
return(DALFty.Create <BaseDAL>().Modify <T>(db, model));
}
}
public void Update(CustomerSLSalePrice obj)
{
using (DCC dcc = DBMLFty.Dcc)
{
DALFty.Create <CustomerSLSalePriceDAL>().Update(dcc, obj);
dcc.Save();
}
}
public void Delete(Guid parentGoodsID)
{
using (DCC dcc = DBMLFty.Dcc)
{
DALFty.Create <CustomerSLSalePriceDAL>().Delete(dcc, parentGoodsID);
dcc.Save();
}
}
public void Delete(Guid id)
{
using (DCC dcc = DBMLFty.Dcc)
{
DALFty.Create <MaterielInStoreBillDAL>().Delete(dcc, id);
dcc.Save();
}
}
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(List <CustomerSLSalePrice> list)
{
using (DCC dcc = DBMLFty.Dcc)
{
DALFty.Create <CustomerSLSalePriceDAL>().Insert(dcc, list);
dcc.Save();
}
}
public void Update(Guid parentGoodsID, List <CustomerSLSalePrice> list)
{
using (DCC dcc = DBMLFty.Dcc)
{
DALFty.Create <CustomerSLSalePriceDAL>().Update(dcc, parentGoodsID, list);
dcc.Save();
}
}