// Blobデータを取得
        // POST api/blobdata/{UserID名}/{Module名}
        public alldata Post(string fir, string sec, [FromBody]BlobQuery blobquery) {

          alldata AllData = new alldata();  // ここに、データの中身が入る

          // RDBの中から、ターゲットモジュールなどの検索
          try {
              var usertest = RDB.db.Users.Where(p => p.idName.Equals(fir)).Single();
          } catch {
              AllData.Type = new List<string>();
              AllData.Type.Add("User does not exist.");
              return AllData;
          }
          var user = RDB.db.Users.Where(p => p.idName.Equals(fir)).Single();
          try {
              var moduletest = user.Modules.Where(p => p.Name.Equals(sec)).Single();
          } catch {
              AllData.Type = new List<string>();
              AllData.Type.Add("Module does not exist.");
              return AllData;
          }
          var module = user.Modules.Where(p => p.Name.Equals(sec)).Single();
          var units = module.Units;

          // パスワードチェック
          if (common.PasswordError(blobquery.pw, module.rPassWord)) {
            AllData.Type = new List<string>();
            AllData.Type.Add("Password Error");
            return AllData;
          }

          string time = common.GetTimeIndex(blobquery.dt);

          // Blob内のデータを取得
          CloudBlobContainer container = common.BlobAccess();
          CloudBlockBlob blockBlob = container.GetBlockBlobReference(module.id.ToString() + "," + time);
          string jsontext;
          using (var memoryStream = new MemoryStream()) {
            blockBlob.DownloadToStream(memoryStream);
            jsontext = System.Text.Encoding.UTF8.GetString(memoryStream.ToArray());
          }
          JavaScriptSerializer serializer = new JavaScriptSerializer();
          BlobAdd blobdata = serializer.Deserialize<BlobAdd>(jsontext);


          // unitlist配列には、ユーザが取得したい列インデックス番号が入ってある
          if (!(blobquery.unitlist == null)) {
            AllData.Type = new List<string>();
            foreach (var unitindex in blobquery.unitlist) {
              AllData.Type.Add(blobdata.type[unitindex-1]);
            }
          } else {
            AllData.Type = blobdata.type;
          }


          AllData.data = new List<List<string>>();
          List<List<string>> tmpAllData = new List<List<string>>();
          int num = 0;
          foreach (var data in blobdata.dataaddlist) {
            
            List<string> tmpdata = new List<string>();

            // ユーザが取得したいデータ個数やデータ範囲内ではないデータは無視する
            if ((blobquery.num != 0) && (num >= blobquery.num)) {
              break;
            }
            if ((!(blobquery.since == null)) && (long.Parse(common.GetTimeIndex(data.dt)) > long.Parse(common.GetTimeIndex(blobquery.since)))) {
              continue;
            }
            if ((!(blobquery.until == null)) && (long.Parse(common.GetTimeIndex(data.dt)) < long.Parse(common.GetTimeIndex(blobquery.until)))) {
              continue;
            }

            num++;

            // noDateがtrueなら更新時刻を取得しない
            if (!blobquery.noDate) {
              tmpdata.Add(data.dt);
            }

            // unitlistがnullなら、全列のデータを取得
            if (!(blobquery.unitlist == null)) {
              foreach (var unitindex in blobquery.unitlist) {
                  tmpdata.Add(data.dat[unitindex-1]);
              }
            } else {
                foreach(var dat in data.dat){
                    tmpdata.Add(dat);
                }
              //tmpdata = data.dat;
            }

            tmpAllData.Add(tmpdata);
            AllData.data.Add(tmpdata);
          }

          // "asc"なら、逆順にする
          if (blobquery.orderby.Equals("asc")) {
            int count = tmpAllData.Count();
            int i = 1;
            foreach (var tmpdata in tmpAllData) {
              AllData.data[count - i] = tmpdata;
              i++;
            }
          }


          return AllData;
        }
예제 #2
0
    // Azure Tableのデータを取得
    // POST api/data/{UserID名}/{Module名}
    public alldata Post(string fir, string sec, [FromBody]DataQuery dataquery) {

      alldata AllData = new alldata();  // 取得したデータをここに格納

      // RDBの中から、ターゲットモジュールなどを検索
      try {
          var usertest = RDB.db.Users.Where(p => p.idName.Equals(fir)).Single();
      } catch {
          AllData.Type = new List<string>();
          AllData.Type.Add("User does not exist.");
          return AllData;
      }
      var user = RDB.db.Users.Where(p => p.idName.Equals(fir)).Single();
      try {
          var moduletest = user.Modules.Where(p => p.Name.Equals(sec)).Single();
      } catch {
          AllData.Type = new List<string>();
          AllData.Type.Add("Module does not exist.");
          return AllData;
      }
      var module = user.Modules.Where(p => p.Name.Equals(sec)).Single();
      var units = module.Units;

      // パスワードチェック
      if (common.PasswordError(dataquery.pw, module.rPassWord)) {
        AllData.Type = new List<string>();
        AllData.Type.Add("Password Error");
        return AllData;
      }

      table = common.AzureAccess(); // Azure Tableへアクセス

      TableQuery<DataEntity> query = new TableQuery<DataEntity>();

      if ((dataquery.since == null) && (dataquery.until == null)) { //範囲指定なし
        query = new TableQuery<DataEntity>().Where(
        TableQuery.CombineFilters(
        TableQuery.GenerateFilterCondition("PartitionKey", QueryComparisons.Equal, "Value," + module.id),
        TableOperators.And,
        TableQuery.GenerateFilterCondition("RowKey", QueryComparisons.GreaterThanOrEqual, common.GetTimeIndex(module.Latest))
        ));
      } else if (dataquery.since == null) { //~untilのデータ取得
        query = new TableQuery<DataEntity>().Where(
        TableQuery.CombineFilters(
        TableQuery.GenerateFilterCondition("PartitionKey", QueryComparisons.Equal, "Value," + module.id),
        TableOperators.And,
        TableQuery.GenerateFilterCondition("RowKey", QueryComparisons.GreaterThanOrEqual, common.GetTimeIndex(dataquery.until))
      ));
      } else if (dataquery.until == null) { //since~のデータ取得
        query = new TableQuery<DataEntity>().Where(
        TableQuery.CombineFilters(
        TableQuery.GenerateFilterCondition("PartitionKey", QueryComparisons.Equal, "Value," + module.id),
        TableOperators.And,
        TableQuery.GenerateFilterCondition("RowKey", QueryComparisons.LessThanOrEqual, common.GetTimeIndex(dataquery.since) + 1)
      ));
      } else { //since~untilのデータ取得
        query = new TableQuery<DataEntity>().Where(
        TableQuery.CombineFilters(
        TableQuery.GenerateFilterCondition("PartitionKey", QueryComparisons.Equal, "Value," + module.id),
        TableOperators.And,
        TableQuery.CombineFilters(
          TableQuery.GenerateFilterCondition("RowKey", QueryComparisons.LessThanOrEqual, common.GetTimeIndex(dataquery.since) + 1),
          TableOperators.And,
          TableQuery.GenerateFilterCondition("RowKey", QueryComparisons.GreaterThanOrEqual, common.GetTimeIndex(dataquery.until))
          )
      ));
      }

      List<DataEntity> BeforeDataList = new List<DataEntity>();
      List<DataEntity> AfterDataList = new List<DataEntity>();

      BeforeDataList = table.ExecuteQuery(query).ToList<DataEntity>();
      AfterDataList = table.ExecuteQuery(query).ToList<DataEntity>();

      //"asc"なら逆順にする
      if (dataquery.orderby.Equals("asc")) {
        int count = BeforeDataList.Count();
        int i = 1;
        foreach (var BeforeData in BeforeDataList) {
          AfterDataList[count - i] = BeforeData;
          i++;
        }
      }

      string[] Type;
      int[] TypeId;

      int num = 0;

      //unitlistの中には、ユーザが取得したいデータの列インデックスが格納されている
      if (dataquery.unitlist == null) {
        Type = new string[units.Count];
        TypeId = new int[units.Count];
        foreach (var unit in units) {
          Type[num] = unit.Unit1;
          TypeId[num] = unit.id;
          num++;
        }
      } else {
        Type = new string[dataquery.unitlist.Count()];
        TypeId = new int[dataquery.unitlist.Count()];
        foreach (int index in dataquery.unitlist) {
          Type[num] = units.ElementAt(index - 1).Unit1;
          TypeId[num] = units.ElementAt(index - 1).id;
          num++;
        }
      }

      num = 2;

      AllData.Type = new List<string>();
      AllData.data = new List<List<string>>();

      AllData.Type = Type.ToList();

      List<string> datatmp1 = new List<string>();
      string[] datatmp2;
      if (dataquery.noDate) { //noDateがtrueなら、更新時刻分の列がいらない
        datatmp2 = new string[Type.LongLength];
        for (int i = 0; i < Type.LongLength; i++) {
          datatmp2[i] = string.Empty;
        }
      } else {
        datatmp2 = new string[Type.LongLength + 1];
        for (int i = 0; i < Type.LongLength + 1; i++) {
          datatmp2[i] = string.Empty;
        }
      }

      string time = string.Empty;

      bool first = false;

      foreach (DataEntity entity in AfterDataList) {


        if (time.Equals(entity.RowKey.Split(',')[0])) {
        } else {
          if (first) {
            if (!(dataquery.num == 0)) {
              if (num > dataquery.num) {
                break; // 要求されているデータ数を超えた時点でbreak
              }
            }
            if (!dataquery.noDate) { //noDateがfalseなら、更新時刻を1列目に追加
              datatmp2[0] = common.GetDateIndex(time);
            }
            datatmp1 = datatmp2.ToList();
            AllData.data.Add(datatmp1);
            datatmp1 = new List<string>();
            if (dataquery.noDate) {
              datatmp2 = new string[Type.LongLength];
            } else {
              datatmp2 = new string[Type.LongLength + 1];
            }
            num++;
          }
          first = true;
        }

        // RDBのデータ種類IDと一致する場合のみdatatmpに格納
        for (int i = 0; i < Type.LongLength; i++) {
          if (units.Where(p => p.id == int.Parse(entity.RowKey.Split(',')[1])).Single().id.Equals(TypeId[i])) {
            if (dataquery.noDate) {
              datatmp2[i] = entity.DataVal;
            } else {
              datatmp2[i + 1] = entity.DataVal;
            }
          }
        }

        time = entity.RowKey.Split(',')[0];



      }
      if (!dataquery.noDate) {
        datatmp2[0] = common.GetDateIndex(time);
      }
      datatmp1 = datatmp2.ToList();
      AllData.data.Add(datatmp1);

      return AllData;
    }
예제 #3
0
    //query条件に一致するデータを取得(Azure)
    alldata GetData(TableQuery<DataEntity> query, ICollection<Unit> units, string unitsindex) {

      alldata AllData = new alldata();

      string[] indexes;

      string[] Type;
      int[] TypeId;

      int num = 0;

      if (unitsindex.Equals("all")) {
        Type = new string[units.Count];
        TypeId = new int[units.Count];
        foreach (var unit in units) {
          Type[num] = unit.Unit1;
          TypeId[num] = unit.id;
          num++;
        }
      } else {
        indexes = unitsindex.Split(',');
        Type = new string[indexes.Count()];
        TypeId = new int[indexes.Count()];
        foreach (var index in indexes) {
          Type[num] = units.ElementAt(int.Parse(index)-1).Unit1;
          TypeId[num] = units.ElementAt(int.Parse(index)-1).id;
          num++;
        }
      }
      
      

      AllData.Type = new List<string>();
      AllData.data = new List<List<string>>();

      AllData.Type = Type.ToList();

      List<string> datatmp1 = new List<string>();
      string[] datatmp2 = new string[Type.LongLength + 1];
      for (int i = 0; i < Type.LongLength + 1; i++) {
        datatmp2[i] = string.Empty;
      }

      string time = string.Empty;

      bool first = false;

      foreach (DataEntity entity in table.ExecuteQuery(query)) {

        if (time.Equals(entity.RowKey.Split(',')[0])) {
        } else {
          if (first) {
            datatmp2[0] = common.GetDateIndex(time);
            datatmp1 = datatmp2.ToList();
            AllData.data.Add(datatmp1);
            datatmp1 = new List<string>();
            datatmp2 = new string[Type.LongLength + 1];
          }
          first = true;
        }

        for (int i = 0; i < Type.LongLength; i++) {
          if (units.Where(p => p.id == int.Parse(entity.RowKey.Split(',')[1])).Single().id.Equals(TypeId[i])) {
            datatmp2[i + 1] = entity.DataVal;
          }
        }

        time = entity.RowKey.Split(',')[0];

      }
      datatmp2[0] = common.GetDateIndex(time);
      datatmp1 = datatmp2.ToList();
      AllData.data.Add(datatmp1);

      return AllData;

    }
예제 #4
0
    //(テスト用) POST api/data/{UserID名}/{Module名}/{item}/{最初の件数}/{最後の件数}/{UnitsIndex1,UnitsIndex2,…} or "all"
    //(テスト用) POST api/data/{UserID名}/{Module名}/{date}/{日時(最古)}/{日時(最新)}/{UnitsIndex1,UnitsIndex2,…} or "all"
    public alldata Post(string fir, string sec, string thi, string fou, string fif, string six, [FromBody]string data) {

      alldata AllData = new alldata();

      table = common.AzureAccess();

      var user = RDB.db.Users.Where(p => p.idName.Equals(fir)).Single();
      var module = user.Modules.Where(p => p.Name.Equals(sec)).Single();
      var units = module.Units;
      int id = module.id;

      if(common.PasswordError(data,module.rPassWord)){
        AllData.Type = new List<string>();
        AllData.Type.Add("Password Error");
        return AllData;
      }

      TableQuery<DataEntity> query3 = new TableQuery<DataEntity>();

      if (thi.Equals("item")) {

        TableQuery<DataEntity> query1 = new TableQuery<DataEntity>().Where(TableQuery.GenerateFilterCondition("PartitionKey", QueryComparisons.Equal, "Take," + id)).Take(int.Parse(fou));

        TableQuery<DataEntity> query2 = new TableQuery<DataEntity>().Where(TableQuery.GenerateFilterCondition("PartitionKey", QueryComparisons.Equal, "Take," + id)).Take(int.Parse(fif));

        query3 = new TableQuery<DataEntity>().Where(
          TableQuery.CombineFilters(
          TableQuery.GenerateFilterCondition("PartitionKey", QueryComparisons.Equal, "Value," + id),
          TableOperators.And,
          TableQuery.CombineFilters(
            TableQuery.GenerateFilterCondition("RowKey", QueryComparisons.GreaterThanOrEqual, table.ExecuteQuery(query1).LastOrDefault().RowKey),
            TableOperators.And,
            TableQuery.GenerateFilterCondition("RowKey", QueryComparisons.LessThan, (long.Parse(table.ExecuteQuery(query2).LastOrDefault().RowKey) + 1).ToString())
            )
        ));
      }
      if (thi.Equals("date")) {
        query3 = new TableQuery<DataEntity>().Where(
        TableQuery.CombineFilters(
        TableQuery.GenerateFilterCondition("PartitionKey", QueryComparisons.Equal, "Value," + id),
        TableOperators.And,
        TableQuery.CombineFilters(
          TableQuery.GenerateFilterCondition("RowKey", QueryComparisons.LessThanOrEqual, common.GetTimeIndex(fou) + 1),
          TableOperators.And,
          TableQuery.GenerateFilterCondition("RowKey", QueryComparisons.GreaterThanOrEqual, common.GetTimeIndex(fif))
          )
      ));
      }

      AllData = GetData(query3, units, six);

      return AllData;

    }
예제 #5
0
    //(テスト用) POST api/data/{UserID名}/{Module名}/{UnitsIndex1,UnitsIndex2,…} or "all"
    public alldata Post(string fir, string sec,string thi, [FromBody]string data) {

      alldata AllData = new alldata();

      table = common.AzureAccess();

      var user = RDB.db.Users.Where(p => p.idName.Equals(fir)).Single();
      var module = user.Modules.Where(p => p.Name.Equals(sec)).Single();
      var units = module.Units;
      int id = module.id;

      if (common.PasswordError(data, module.rPassWord)) {
        AllData.Type = new List<string>();
        AllData.Type.Add("Password Error");
        return AllData;
      }

      try {

        TableQuery<DataEntity> query = new TableQuery<DataEntity>().Where(TableQuery.GenerateFilterCondition("PartitionKey", QueryComparisons.Equal, "Value," + id));

        AllData = GetData(query, units,thi);

        return AllData;
      } catch {
        return AllData;
      }
      
    }
예제 #6
0
    //(テスト用) GET api/data/{UserID名}/{Module名}/{UnitsIndex1,UnitsIndex2,…} or "all"
    public alldata Get(string fir, string sec, string thi) {

      alldata AllData = new alldata();

      table = common.AzureAccess();

      var user = RDB.db.Users.Where(p => p.idName.Equals(fir)).Single();
      var module = user.Modules.Where(p => p.Name.Equals(sec)).Single();
      var units = module.Units;

      int id = module.id;

      try {

        TableQuery<DataEntity> query = new TableQuery<DataEntity>().Where(TableQuery.GenerateFilterCondition("PartitionKey", QueryComparisons.Equal, "Value," + id));

        AllData = GetData(query, units,thi);

        return AllData;
      } catch {
        return AllData;
      }
    }