public IEnumerable <StorageModel> Page(string orgId, string name, int page, int size, out int count) { using (var storageHandler = new StorageHandle(Repository)) using (var orgHandler = new OrganizationHandle(Repository)) using (var officerHandler = new OfficerHandle(Repository)) using (var siteHandler = new SiteHandle(Repository)) { var noDel = (short)DeleteStatus.No; var query = from stg in storageHandler.All(t => t.IsDel == noDel) join org in orgHandler.All(t => t.IsDel == noDel) on stg.OrgId equals org.Id join officer in officerHandler.All(t => t.IsDel == noDel) on stg.OfficerId equals officer.Id into officers from off in officers.DefaultIfEmpty(new Officer { }) join site in siteHandler.All(t => t.IsDel == noDel) on stg.StationId equals site.Id into sites from sta in sites.DefaultIfEmpty(new Station { }) select new { stg = stg, org = org, officer = off, sta = sta }; if (!string.IsNullOrWhiteSpace(name)) { query = query.Where(t => t.stg.Name.Contains(name)); } if (!string.IsNullOrWhiteSpace(orgId)) { query = query.Where(t => t.stg.OrgId == orgId); } if (string.IsNullOrWhiteSpace(orgId) && !User.IsSupperAdministrator) { var code = User.Organization.Code; query = query.Where(t => t.org.Code.StartsWith(code)); } count = query.Count(); var skipCount = (page - 1) * size; var items = query.OrderBy(t => t.sta.OrgId).Skip(skipCount).Take(size).ToArray() .Select(t => new StorageModel { officer = t.officer, org = t.org, storage = t.stg }); return(items); } }
public static extern void StorageClear(StorageHandle storage);
protected override void Dispose(bool disposing) { base.Dispose(disposing); Handler.Dispose(); Handler = null; }
public StorageModule(UserInfo user) : base(user) { Handler = new StorageHandle(Repository); }
public IEnumerable <EquipmentModel> Page(string orgId, string storageId, string cabinetId, string tagCode, string factorCode, short dataType, int page, int size, out int count) { using (var eqtHandler = new EquipmentHandle(Repository)) using (var cateHandler = new EqtTypeHandle(Repository)) using (var stgHandler = new StorageHandle(Repository)) using (var cabHandler = new CabinetHandle(Repository)) using (var orgHandler = new OrganizationHandle(Repository)) using (var offHandler = new OfficerHandle(Repository)) { var noDel = (short)DeleteStatus.No; var query = from eqt in eqtHandler.All(t => t.IsDel == noDel) join org in orgHandler.All(t => t.IsDel == noDel) on eqt.OrgId equals org.Id join cate in cateHandler.All(t => t.IsDel == noDel) on eqt.CateId equals cate.Id join stg in stgHandler.All(t => t.IsDel == noDel) on eqt.LibId equals stg.Id join cabitem in cabHandler.All(t => t.IsDel == noDel) on eqt.CabId equals cabitem.Id into cabs from cab in cabs.DefaultIfEmpty(new Cabinet { }) join offitem in offHandler.All(t => t.IsDel == noDel) on eqt.OfficerId equals offitem.Id into offs from off in offs.DefaultIfEmpty(new Officer { }) select new { eqt = eqt, org = org, cate = cate, stg = stg, cab = cab, officer = off }; if (!string.IsNullOrWhiteSpace(storageId)) { query = query.Where(t => t.eqt.LibId == storageId); } if (!string.IsNullOrWhiteSpace(cabinetId)) { query = query.Where(t => t.eqt.CabId == cabinetId); } if (!string.IsNullOrWhiteSpace(tagCode)) { query = query.Where(t => t.eqt.TagId.Contains(tagCode)); } if (!string.IsNullOrWhiteSpace(factorCode)) { query = query.Where(t => t.eqt.FactorCode.Contains(factorCode)); } if (!string.IsNullOrWhiteSpace(orgId)) { query = query.Where(t => t.eqt.OrgId == orgId); } if (string.IsNullOrWhiteSpace(orgId) && !User.IsSupperAdministrator) { orgId = User.Organization.Id; query = query.Where(t => t.eqt.OrgId == orgId); } var dispatchStatus = 0; // 布控中 if (dataType == (short)QueryEqtDataType.Dispatching) { dispatchStatus = (short)DispatchedStatus.Doing; query = query.Where(t => t.eqt.Dispatched == dispatchStatus); } // 撤控 if (dataType == (short)QueryEqtDataType.Dispatched) { dispatchStatus = (short)DispatchedStatus.Done; query = query.Where(t => t.eqt.Dispatched == dispatchStatus); } var now = DateTime.Now.ToUnixTime(); // 已过期 if (dataType == (short)QueryEqtDataType.Expired) { query = query.Where(t => t.eqt.ExpiredTime <= now); } // 即将过期 if (dataType == (short)QueryEqtDataType.PreExpired) { var preDate = DateTime.Now.AddDays(PreExpiredInterval).ToUnixTime(); query = query.Where(t => t.eqt.ExpiredTime >= preDate && t.eqt.ExpiredTime < now); } // 尚未过期 if (dataType == (short)QueryEqtDataType.NoExpired) { query = query.Where(t => t.eqt.ExpiredTime >= now); } // 绑定警员 if (dataType == (short)QueryEqtDataType.Bound) { query = query.Where(t => t.eqt.OfficerId != null); } // 已损坏 if (dataType == (short)QueryEqtDataType.Destoried) { var sta = (short)EquipmentStatus.Destory; query = query.Where(t => t.eqt.Status == sta); } // 低电量 if (dataType == (short)QueryEqtDataType.LowPower) { query = query.Where(t => t.eqt.Power <= LowPowerFlag); } count = query.Count(); var skipCount = (page - 1) * size; var items = query.OrderByDescending(t => t.eqt.InputTime).Skip(skipCount).Take(size).ToArray() .Select(t => new EquipmentModel { cabinet = t.cab, category = t.cate, equipment = t.eqt, officer = t.officer, org = t.org, storage = t.stg }); return(items); } }