using Infrastructure; using Microsoft.AspNetCore.Hosting; using Microsoft.AspNetCore.Http; using System; using System.Collections.Generic; using System.Linq; using System.Linq.Expressions; using WebRepository; namespace WebApp { /// <summary> /// 库存交易表 /// </summary> public partial class InventoryTransactionApp { private IUnitWork _unitWork; public IRepository<InventoryTransaction> _app; private static IHostingEnvironment _hostingEnvironment; ExcelHelper imp = new ExcelHelper(_hostingEnvironment); public InventoryTransactionApp(IUnitWork unitWork, IRepository<InventoryTransaction> repository, IHostingEnvironment hostingEnvironment) { _unitWork = unitWork; _app = repository; _hostingEnvironment = hostingEnvironment; } public InventoryTransactionApp SetLoginInfo(LoginInfo loginInfo) { _app._loginInfo = loginInfo; return this; } public TableData Load(PageReq pageRequest, InventoryTransaction entity) { return _app.Load(pageRequest, entity); } public void Ins(InventoryTransaction entity) { _app.Add(entity); } public void Upd(InventoryTransaction entity) { _app.Update(entity); } public void DelByIds(int[] ids) { _app.Delete(u => ids.Contains(u.Id.Value)); } public InventoryTransaction FindSingle(Expression<Func<InventoryTransaction, bool>> exp) { return _app.FindSingle(exp); } public IQueryable<InventoryTransaction> Find(Expression<Func<InventoryTransaction, bool>> exp) { return _app.Find(exp); } public Response ImportIn(IFormFile excelfile) { Response result = new Infrastructure.Response(); List<InventoryTransaction> exp = imp.ConvertToModel<InventoryTransaction>(excelfile); string sErrorMsg = ""; for (int i = 0; i < exp.Count; i++) { try { InventoryTransaction e = exp[i]; e.Id = null; _app.Add(e); } catch (Exception ex) { sErrorMsg += "第" + (i + 2) + "行:" + ex.Message + "<br>"; result.Message = sErrorMsg; break; } } if (sErrorMsg.Equals(string.Empty)) { if (exp.Count == 0) { sErrorMsg += "没有发现有效数据, 请确定模板是否正确, 或是否有填充数据!"; result.Message = sErrorMsg; } else { result.Message = "导入完成"; } } else { result.Status = false; result.Message = result.Message; } return result; } public TableData ExportData(InventoryTransaction entity) { return _app.ExportData(entity); } public TableData Query(InventoryTransaction entity) { var result = new TableData(); var data = _app.Find(EntityToExpression<InventoryTransaction>.GetExpressions(entity)); GetData(data, result); result.count = data.Count(); return result; } public void GetData(IQueryable<InventoryTransaction> data, TableData result, PageReq pageRequest = null) { _app.GetData(data, result, pageRequest); } } }