/// <summary> /// /// </summary> /// <param name="tableName">表名</param> /// <param name="ids"></param> /// <param name="pageIndex"></param> /// <param name="pageSize"></param> /// <param name="total"></param> /// <returns></returns> public object GetDataTw(string tableName, IdsModel ids, int pageIndex, int pageSize, out int total) { total = 0; int start = 0, end = pageSize; if (pageIndex > 1) { start = (pageIndex - 1) * pageSize; end = pageIndex * pageSize; } string sql = string.Format("SELECT SQL_CALC_FOUND_ROWS time,data_work_status from `{0}` WHERE area_id = @AreaId AND mc_id=@McId AND par_id=@ParId AND dir_id=@DirId ORDER BY time DESC LIMIT {1},{2};SELECT FOUND_ROWS() total;", tableName, start, end); IDataReader reader = Db.Ado.GetDataReader(sql, new { ids.AreaId, ids.McId, ids.ParId, ids.DirId }); List <long> time = new List <long>(); List <int> twWorkStatus = new List <int>(); while (reader.Read()) { time.Add(new DateTimeOffset(Convert.ToDateTime(reader["time"])).ToUnixTimeSeconds()); twWorkStatus.Add(Convert.ToInt32(reader["data_work_status"])); } if (reader.NextResult()) { if (reader.Read()) { total = Convert.ToInt32(reader["total"]); } } if (!reader.IsClosed) { reader.Close(); } return(new { time, twWorkStatus }); }
/// <summary> /// 获取方向下某时间波形 /// </summary> /// <param name="tableName">表名</param> /// <param name="ids">方向</param> /// <param name="time">时间</param> /// <returns></returns> public ResultData GetDataTwByDirId(string parameter, IdsModel ids, TimeModel time) { List <DataTw> list = _dataTwDal.GetDataTwByDirId(GetTableName(parameter), ids, time); List <DataTwModel> dtmList = new List <DataTwModel>(); foreach (DataTw item in list) { dtmList.Add(_mapper.Map <DataTwModel>(item)); } return(new ResultData(dtmList)); }
/// <summary> /// 获取方向下最新 count条数据 /// </summary> /// <param name="ids">方向</param> /// <param name="count">数量</param> /// <returns>结果集</returns> public ResultData GetDataOaByDirId(IdsModel ids, int count) { List <DataOa> list = _dataOaDal.GetDataOaByDirId(ids, count); List <DataOaModel> domList = new List <DataOaModel>(); foreach (DataOa oa in list) { domList.Add(_mapper.Map <DataOaModel>(oa)); } return(new ResultData(domList)); }
/// <summary> /// 获取方向下的时间列表(包含工况) /// </summary> /// <param name="tableName"></param> /// <param name="ids"></param> /// <returns></returns> public object GetDataTwTimeList(string tableName, IdsModel ids) { string sql = string.Format("SELECT time,data_work_status from `{0}` WHERE area_id = @AreaId AND mc_id=@McId AND par_id=@ParId AND dir_id=@DirId ORDER BY time DESC", tableName); IDataReader reader = Db.Ado.GetDataReader(sql, new { ids.AreaId, ids.McId, ids.ParId, ids.DirId }); List <long> time = new List <long>(); List <int> twWorkStatus = new List <int>(); while (reader.Read()) { time.Add(new DateTimeOffset(Convert.ToDateTime(reader["time"])).ToUnixTimeSeconds()); twWorkStatus.Add(Convert.ToInt32(reader["data_work_status"])); } if (!reader.IsClosed) { reader.Close(); } return(new { time, twWorkStatus }); }
/// <summary> /// 获取方向下所有总值,每一项是个数组 /// </summary> /// <param name="ids">方向</param> /// <returns></returns> public object GetDataOaByDirId(IdsModel ids) { string sql = "SELECT * FROM tb_data_oa WHERE area_id=@AreaId AND mc_id=@McId AND par_id=@ParId AND dir_id=@DirId Order BY oa_time DESC"; IDataReader dataReader = Db.Ado.GetDataReader(sql, new { AreaId = ids.AreaId, McId = ids.McId, ParId = ids.ParId, DirId = ids.DirId }); List <float> temp = new List <float>(); List <float> acc = new List <float>(); List <float> vel = new List <float>(); List <float> disp = new List <float>(); List <float> env = new List <float>(); List <float> cf = new List <float>(); List <float> kurt = new List <float>(); List <float> bv = new List <float>(); List <float> bg = new List <float>(); List <long> time = new List <long>(); List <int> oaWorkStatus = new List <int>(); while (dataReader.Read()) { temp.Add(Convert.ToInt32(dataReader["oa_temp"])); acc.Add(Convert.ToSingle(dataReader["oa_acc"])); vel.Add(Convert.ToSingle(dataReader["oa_vel"])); bg.Add(Convert.ToSingle(dataReader["oa_bg"])); bv.Add(Convert.ToSingle(dataReader["oa_bv"])); env.Add(Convert.ToSingle(dataReader["oa_env"])); disp.Add(Convert.ToSingle(dataReader["oa_disp"])); cf.Add(Convert.ToSingle(dataReader["oa_CF"])); kurt.Add(Convert.ToSingle(dataReader["oa_kurt"])); time.Add(new DateTimeOffset(Convert.ToDateTime(dataReader["oa_time"])).ToUnixTimeSeconds()); oaWorkStatus.Add(Convert.ToInt32(dataReader["oa_work_status"])); } if (!dataReader.IsClosed) { dataReader.Close(); } return(new { temp, acc, vel, disp, env, cf, kurt, bv, bg, time, oaWorkStatus }); }
/// <summary> /// 获取方向下某时间波形 /// </summary> /// <param name="tableName"></param> /// <param name="ids"></param> /// <returns></returns> public List <DataTw> GetDataTwByDirId(string tableName, IdsModel ids, TimeModel time) { string sql = string.Format("SELECT * FROM `{0}` WHERE area_id=@AreaId AND mc_id=@McId AND par_id=@ParId AND dir_id=@DirId AND time=@Time", tableName); return(Db.Ado.SqlQuery <DataTw>(sql, new { ids.AreaId, ids.McId, ids.ParId, ids.DirId, time.Time })); }
/// <summary> /// 查询方向下的时间数据列表 /// </summary> /// <param name="ids"></param> /// <returns></returns> public ResultData GetDataOaTimeList(IdsModel ids) { List <TimeModel> list = _dataOaDal.GetDataOaTimeList(ids); return(new ResultData(list)); }
/// <summary> /// 获取方向下所有总值,每一项是个数组 /// </summary> /// <param name="ids">方向</param> public ResultData GetDataOaByDirId(IdsModel ids) { object obj = _dataOaDal.GetDataOaByDirId(ids); return(new ResultData(obj)); }
/// <summary> /// 获取方向下的时间列表(包含工况) /// </summary> /// <param name="tableName">表名</param> /// <param name="ids">方向</param> /// <returns>时间列表(含对应工况)</returns> public ResultData GetDataTwTimeList(string parameter, IdsModel ids) { object obj = _dataTwDal.GetDataTwTimeList(GetTableName(parameter), ids); return(new ResultData(obj)); }
public IActionResult CheckIfOrganizationsHaveUsers([FromBody] IdsModel model) { return(Ok(organizationService.CheckIfOrganizationsHaveUsers(model.Ids))); }
/// <summary> /// 查询方向下的时间数据列表 /// </summary> /// <param name="ids"></param> /// <returns></returns> public List <TimeModel> GetDataOaTimeList(IdsModel ids) { string sql = "SELECT time FROM tb_data_oa WHERE area_id=@AreaId AND mc_id=@McId AND par_id=@ParId AND dir_id=@DirId "; return(Db.Ado.SqlQuery <TimeModel>(sql, ids)); }
/// <summary> /// 获取方向下最新 count条数据 /// </summary> /// <param name="ids">方向</param> /// <param name="count">数量</param> /// <returns>结果集</returns> public List <DataOa> GetDataOaByDirId(IdsModel ids, int count) { string sql = "SELECT * FROM tb_data_oa WHERE area_id=@AreaId AND mc_id=@McId AND par_id=@ParId AND dir_id=@DirId Order BY oa_time DESC LIMIT 0,@Count"; return(Db.Ado.SqlQuery <DataOa>(sql, new { AreaId = ids.AreaId, McId = ids.McId, ParId = ids.ParId, DirId = ids.DirId, Count = count })); }