//public EdiController(EdiDBContext _DbO) { DbO = _DbO; }
public EdiController(EdiDBContext _DbO, WmsContext _WmsDb, IConfiguration _Config)
{
DbO = _DbO;
WmsDb = _WmsDb;
Config = _Config;
WmsDb.Database.SetCommandTimeout(TimeSpan.FromMinutes(2));
}
public void Update(List <Permission> opList, List <ButtonPermission> btnList)
{
using (WmsContext db = EDMXFty.Dc)
{
DALFty.Create <PermissionDAL>().Update(db, opList, btnList);
}
}
/// <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>
/// <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>
/// <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);
}
}
public int SelectFunction(out DataTable dtResult)
{
int returnCode = 0;
try
{
using (DBContext = new WmsContext())
{
var query = from f in DBContext.sy_functions
join fm in DBContext.sy_functionmapping on f.FunctionID equals fm.FunctionID
join p in DBContext.ms_permissionsassign on fm.ID equals p.MappingID
join ug in DBContext.ms_usergroups on p.GroupCode equals ug.Code
join ga in DBContext.ms_groupsassign on ug.Code equals ga.GroupCode
join u in DBContext.ms_users on ga.UserCode equals u.Code
where u.Code == UserSession.UserName
select new
{
FunctionID = f.ID
};
dtResult = ToDataTable(query);
dtResult = null;
}
}
catch (Exception ex)
{
dtResult = new DataTable();
returnCode = this.ProcessDbException(ex);
}
return(returnCode);
}
/// <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));
}
}
public void FinishUnlistedGoods(List <UnlistedGoodsLog> dtlList)
{
using (WmsContext db = EDMXFty.Dc)
{
DALFty.Create <InventoryDAL>().FinishUnlistedGoods(db, dtlList);
}
}
/// <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));
}
}
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 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);
}
}
/// <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));
}
}
/// <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>
/// <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="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));
}
}
public void Insert(UsersInfo obj, List <Permission> pList, List <ButtonPermission> btnList)
{
using (WmsContext db = EDMXFty.Dc)
{
DALFty.Create <UsersInfoDAL>().Insert(db, obj, pList, btnList);
}
}
/// <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="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 CboController(EdiDBContext _DbO, EdiDBContext _DbOL, WmsContext _WmsDbO, WmsContext _WmsDbOLong, IConfiguration _Config)
{
DbO = _DbO;
DbOLong = _DbOL;
WmsDbO = _WmsDbO;
WmsDbOLong = _WmsDbOLong;
Config = _Config;
DbO.Database.SetCommandTimeout(TimeSpan.FromMinutes(2));
DbOLong.Database.SetCommandTimeout(TimeSpan.FromMinutes(10));
WmsDbO.Database.SetCommandTimeout(TimeSpan.FromMinutes(4));
WmsDbOLong.Database.SetCommandTimeout(TimeSpan.FromMinutes(10));
}
public void Update(WmsContext db, List <Permission> opList, List <ButtonPermission> btnList)
{
using (TransactionScope ts = new TransactionScope())
{
// 让使用typeof(T).Name标签的所有缓存过期
QueryCacheManager.ExpireTag(nameof(Permission));
QueryCacheManager.ExpireTag(nameof(ButtonPermission));
db.Set <Permission>().BulkUpdate(opList);
db.Set <ButtonPermission>().BulkUpdate(btnList);
ts.Complete();
}
}
public void Insert(WmsContext db, UsersInfo obj, List <Permission> pList, List <ButtonPermission> btnList)
{
using (TransactionScope ts = new TransactionScope())
{
// 让使用typeof(T).Name标签的所有缓存过期
QueryCacheManager.ExpireTag(nameof(UsersInfo));
QueryCacheManager.ExpireTag(nameof(Permission));
QueryCacheManager.ExpireTag(nameof(ButtonPermission));
db.Configuration.ValidateOnSaveEnabled = false;
BaseDAL baseDAL = DALFty.Create <BaseDAL>();
db.Set <UsersInfo>().Add(obj);
db.SaveChanges();
if (pList.Count > 0)
{
baseDAL.AddByBulkCopy <Permission>(db, pList);
}
if (btnList.Count > 0)
{
baseDAL.AddByBulkCopy <ButtonPermission>(db, btnList);
}
db.Configuration.ValidateOnSaveEnabled = true;
ts.Complete();
}
}
public CheckoutService(WmsContext context)
{
_context = context;
}
public AccountController(EdiDBContext _DbO, WmsContext _WmsDbO, IConfiguration _Config)
{
DbO = _DbO;
WmsDbO = _WmsDbO;
Config = _Config;
}
public WarehouseAssetService(WmsContext context)
{
_context = context;
}
public MaterialService(WmsContext context)
{
_context = context;
}
public WarehouseEmployeeCardService(WmsContext context)
{
_context = context;
}
public StatusService(WmsContext context)
{
_context = context;
}
public EmployeeService(WmsContext context)
{
_context = context;
}
public ToolService(WmsContext context)
{
_context = context;
}
public WarehouseBranchService(WmsContext context)
{
_context = context;
}
