using Hh.Mes.Common.Infrastructure; using Hh.Mes.Common.log; using Hh.Mes.Common.Request; using Hh.Mes.Pojo.System; using Hh.Mes.POJO.Entity; using Hh.Mes.Service.Repository; using SqlSugar; using System; using System.Collections.Generic; using System.Linq; using System.Linq.Expressions; using Hh.Mes.POJO.Response; namespace Hh.Mes.Service.Distribution { public class BusMaterialDistributeLoadService : RepositorySqlSugar<bus_material_distribute_load> { public dynamic Load(PageReq pageReq, bus_material_distribute_load entity) { return ExceptionsHelp.Instance.ExecuteT(() => { var result = new Response(); var expression = LinqWhere(entity); //先组合查询表达式 var query = Context.Queryable<bus_material_distribute_load>().Where(expression); //Exel为ture就不分页,因为导出的话是全部导出 if (pageReq != null) { int total = 0; result.Result = query.ToOffsetPage(pageReq.page, pageReq.limit, ref total); result.Count = total; } else { result.Result = query.ToList(); result.Count = result.Result.Count(); } return result; }, catchRetrunValue: "list"); } public dynamic Ins(bus_material_distribute_load entity) { return ExceptionsHelp.Instance.ExecuteT(() => { var response = new Response(); Context.Insertable(entity).ExecuteCommand(); return response; }); } public dynamic Upd(bus_material_distribute_load entity) { return ExceptionsHelp.Instance.ExecuteT(() => { var response = new Response(); Context.Updateable(entity).ExecuteCommand(); return response; }); } public dynamic DelByIds(int[] ids) { return ExceptionsHelp.Instance.ExecuteT(() => { var response = new Response(); Context.Deleteable<bus_material_distribute_load>(t => ids.Contains(t.id)).ExecuteCommand(); return response; }); } public Response ExportData(bus_material_distribute_load entity) { return Load(null, entity); } public Expression<Func<bus_material_distribute_load, bool>> LinqWhere(bus_material_distribute_load model) { try { var exp = Expressionable.Create<bus_material_distribute_load>(); //数据过滤条件 //if (!string.IsNullOrWhiteSpace(model.XXX)) exp.And(x => x.XXX.Contains(model.XXX)); if (!string.IsNullOrWhiteSpace(model.productCode)) { exp.And(x => x.productCode.Contains(model.productCode)); } if (!string.IsNullOrWhiteSpace(model.startPosition)) { exp.And(x => x.startPosition.Contains(model.startPosition)); } if (!string.IsNullOrWhiteSpace(model.endPosition)) { exp.And(x => x.endPosition.Contains(model.endPosition)); } return exp.ToExpression();//拼接表达式 } catch (Exception ex) { throw new Exception($"{ex.Message}"); } } } }