/// <summary> /// 根据SQL语句获得对象列表 /// </summary> /// <param name="strSql"></param> /// <param name="dbParameter"></param> /// <param name="pagination"></param> /// <returns></returns> public ResultClass <List <TEntity> > FindList(string strSql, Dictionary <string, object> dbParameters, Pagination pagination) { ResultClass <List <TEntity> > _ret = new ResultClass <List <TEntity> >(); try { ResultClass <List <TEntity> > tmp = FindList(strSql, dbParameters); pagination.records = tmp.Result ? tmp.ResultData.Count : 0; if (pagination.records > 0) { string StrSql = DatabasePage.GetStrSql(strSql, dbParameters, pagination); _ret.ResultData = dbcontext.Database.SqlQuery <TEntity>(strSql, new List <DbParameter>()).ToList <TEntity>(); if (_ret.ResultData != null) { _ret.Result = true; } else { _ret.ErrorMessage = "没有数据!"; } } else { _ret.ErrorMessage = "没有数据!"; } } catch (Exception ex) { _ret.ErrorMessage = ex.Message; } return(_ret); }
/// <summary> /// /// </summary> /// <param name="objectType"></param> /// <param name="objectID"></param> /// <returns></returns> public ResultClass <List <ModuleButtonEntity> > GetModuleButtonByObjectID(Pagination pagination, string objectType, string objectID) { StringBuilder strSql = new StringBuilder(); strSql.Append(@"select t.* from Sys_ModuleButton t,Sys_RoleAuthorize r where t.F_Id=r.F_ItemId and r.F_ItemType=2 and r.F_ObjectType=@F_ObjectType and r.F_ObjectId=@F_ObjectId"); Dictionary <string, object> parameter = new Dictionary <string, object>(); parameter.Add("F_ObjectType", objectType); parameter.Add("F_ObjectId", objectID); string sql = DatabasePage.GetStrSql(strSql.ToString(), parameter, pagination); return(this.FindList(sql, new Dictionary <string, object>())); }
/// <summary> /// /// </summary> /// <param name="enCode"></param> /// <returns></returns> public List <ItemsDetailEntity> GetItemList(Pagination pagination, string enCode) { StringBuilder strSql = new StringBuilder(); strSql.Append(@"SELECT d.* FROM Sys_ItemsDetail d INNER JOIN Sys_Items i ON i.F_Id = d.F_ItemId WHERE 1 = 1 AND i.F_EnCode = @enCode AND d.F_EnabledMark = 1 AND d.F_DeleteMark = 0 "); Dictionary <string, object> parameter = new Dictionary <string, object>(); parameter.Add("enCode", enCode); string sql = DatabasePage.GetStrSql(strSql.ToString(), parameter, pagination); ResultClass <List <ItemsDetailEntity> > _ret = this.FindList(sql, new Dictionary <string, object>()); if (_ret.Result) { return(_ret.ResultData); } return(new List <ItemsDetailEntity>()); }
public static AzusaDexTimeline LoadFrom(DexcomDevice dd) { AzusaDexTimeline result = new AzusaDexTimeline(); result.Timestamp = dd.ReadRTC(); PartitionInfo pi = dd.ReadDatabaseParitionInfo(); for (int i = 0; i < pi.Partition.Length; i++) { DatabasePageRange dpr = dd.ReadDatabasePageRange(pi.Partition[i]); if (dpr.Start == -1) { continue; } for (int j = dpr.Start; j < dpr.End; j++) { DatabasePage page = dd.ReadDatabasePage(pi.Partition[i], j); for (int k = 0; k < page.Record.Length; k++) { switch (page.RecordType) { case RecordType.SensorData: SensorData sd = page.Record[k] as SensorData; result[sd.DisplayTime].Rssi = sd.Rssi; result[sd.DisplayTime].SensorFiltered = sd.Filtered; result[sd.DisplayTime].SensorUnfiltered = sd.Unfiltered; break; case RecordType.EgvData: EGVRecord egv = page.Record[k] as EGVRecord; if (egv.SpecialGlucoseValue == null) { result[egv.DisplayTime].Glucose = egv.Glucose; } else { result[egv.DisplayTime].SpecialGlucoseValue = egv.SpecialGlucoseValue; } result[egv.DisplayTime].TrendArrow = egv.TrendArrow; break; case RecordType.InsertionTime: InsertionTime it = page.Record[k] as InsertionTime; result[it.DisplayTime].SessionState = it.SessionState; break; case RecordType.MeterData: MeterData md = page.Record[k] as MeterData; result[md.DisplayTime].MeterGlucose = md.MeterGlucose; break; case RecordType.UserEventData: UserEventData ued = page.Record[k] as UserEventData; result[ued.DisplayTime2].EventType = ued.EventType; switch (ued.EventType) { case EventType.Carbs: result[ued.DisplayTime2].Carbs = ued.EventValue; break; case EventType.Insulin: result[ued.DisplayTime2].Insulin = ued.EventValue; break; default: result[ued.DisplayTime2].HealthEvent = ued.HealthEvent; result[ued.DisplayTime2].ExerciseEvent = ued.ExerciseEvent; break; } break; case RecordType.ManufacturingData: ManufacturingParameters mp = page.Record[k] as ManufacturingParameters; result[mp.DisplayTime].ManufacturingParameters = mp; break; case RecordType.FirmwareParameterData: FirmwareParameterData fpd = page.Record[k] as FirmwareParameterData; result[fpd.DisplayTime].FirmwareParameters = fpd.FPR; break; case RecordType.PcSoftwareParameter: PcSoftwareParameter pcp = page.Record[k] as PcSoftwareParameter; result[pcp.DisplayTime].PcSoftwareParameter = pcp; break; case RecordType.CalSet: case RecordType.ReceiverLogData: case RecordType.UserSettingData: case RecordType.Deviation: break; default: throw new NotImplementedException(page.RecordType.ToString()); } } } } result.Order(); return(result); }
public IActionResult UpdateDatabasePage([FromBody] DatabasePage entity) { _databasePageService.Update(entity); return(Ok()); }
public Task SavePageAsync(string allRecordsKey, DatabasePage databasePage) => _redis.Db0.AddAsync(allRecordsKey, databasePage);
public void Update(DatabasePage entity) { _databaseDal.Update(entity); }
public void Delete(DatabasePage entity) { _databaseDal.Delete(entity); }
public void Add(DatabasePage entity) { _databaseDal.Add(entity); }
public Task SavePageAsync(string allRecordsKey, DatabasePage databasePage) { DbPageToUpdate = databasePage; return(Task.CompletedTask); }
public static string GetDatabasePageUniqueKey(this DatabasePage databasePage) { return($"{databasePage.PageID}_{databasePage.FileID}"); }