public void setDimensions(int height, int width, int length, measurement usedMeasurement)
{
myDimensions.x = width;
myDimensions.y = length;
myDimensions.z = height;
myDimensions.myMeasurement = usedMeasurement;
}
//计量单位 新增
public static int measurementadd(measurement k)
{
NewHope4Entities uu = new NewHope4Entities();
uu.measurement.Add(k);
return(uu.SaveChanges());
}
public async Task <IHttpActionResult> Putmeasurement(int id, measurement measurement)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != measurement.measure_id)
{
return(BadRequest());
}
db.Entry(measurement).State = EntityState.Modified;
try
{
await db.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!measurementExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public room(double x, double y, measurement measuredIn, string descriptionFile, string name, string desc, string hist, string imageFile) : base(name, desc, hist, imageFile)
{
myRoom = new dimensions();
myRoom.x = x;
myRoom.y = y;
myRoom.usedMeasurement = measuredIn;
this.myDescription = descriptionFile;
}
private async Task <IActionResult> addLoggerLayout101(ge_data data, string [] lines)
{
dbConnectDetails cd = await getConnectDetails(data.projectId, gINTTables.DB_DATA_TYPE);
if (cd == null)
{
return(NotFound());
}
int gINTProjectID = cd.ProjectId;
string POINT_ID = "PointId";
string MOND_ID = "Monitoring Id";
string WATER_DEPTH = "Water Depth";
string DATE_TIME = "DateTime";
measurement mm = dict_measurement[WATER_DEPTH];
string[] header = lines[0].Split(",");
int colPOINT_ID = header.findColumn(POINT_ID);
int colMOND_ID = header.findColumn(MOND_ID);
int colDATE_TIME = header.findColumn(DATE_TIME);
int colWATER_DEPTH = header.findColumn(WATER_DEPTH);
int row_start = 1;
int col_start = colDATE_TIME + 1;
for (int i = row_start; i < lines.Length; i++)
{
string[] line = lines[i].Split(",");
try {
var newMOND = new MOND();
newMOND.gINTProjectID = gINTProjectID;
newMOND.PointID = line[colPOINT_ID];
newMOND.ItemKey = line[colMOND_ID];
MONG.sqlWhere("gINTProjectID=" + gINTProjectID + " and PointID='" + newMOND.PointID + "' and ItemKey='" + newMOND.ItemKey + "'");
MONG.getDataTable();
if (!MONG.EOF())
{
DataRow row = MONG.FirstRow();
newMOND.MONG_DIS = Convert.ToDouble(row["MONG_DIS"]);
}
newMOND.DateTime = Convert.ToDateTime(line[colDATE_TIME]);
newMOND.MOND_RDNG = line[colWATER_DEPTH];
newMOND.MOND_TYPE = mm.Type;
newMOND.MOND_NAME = mm.Name;
newMOND.MOND_UNIT = mm.Units;
AddMOND(newMOND, true);
} catch (Exception e) {
Console.Write(e.Message);
}
}
return(Ok());
}
//修改
public static int Get_jiliangdanweiupdate(measurement m)
{
NewHope4Entities uu = new NewHope4Entities();
var obj = uu.measurement.Find(m.MID);
obj.MName = m.MName;
//obj.CreationDate = m.CreationDate;
//obj.state = m.state;
return(uu.SaveChanges());
}
public async Task <IHttpActionResult> Getmeasurement(int id)
{
measurement measurement = await db.measurements.FindAsync(id);
if (measurement == null)
{
return(NotFound());
}
return(Ok(measurement));
}
public async Task <IHttpActionResult> Postmeasurement(measurement measurement)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
db.measurements.Add(measurement);
await db.SaveChangesAsync();
return(CreatedAtRoute("DefaultApi", new { id = measurement.measure_id }, measurement));
}
public async Task <IHttpActionResult> Deletemeasurement(int id)
{
measurement measurement = await db.measurements.FindAsync(id);
if (measurement == null)
{
return(NotFound());
}
db.measurements.Remove(measurement);
await db.SaveChangesAsync();
return(Ok(measurement));
}
public ActionResult <string> Post([Bind("temperature", "humidity", "pressure")] measurement value)
{
return(value.humidity + " " + value.temperature + " " + value.pressure);
}
//修改
public ActionResult Get_jiliangdanweiupdate(measurement m)
{
return(Json(YQmanager.Get_jiliangdanweiupdate(m), JsonRequestBehavior.AllowGet));
}
//新增
public ActionResult measurementadd(measurement k)
{
k.state = 0;
k.CreationDate = DateTime.Now;
return(Json(YQmanager.measurementadd(k), JsonRequestBehavior.AllowGet));
}
//修改
public static int Get_jiliangdanweiupdate(measurement m)
{
return(YQdal.Get_jiliangdanweiupdate(m));
}
//计量单位 新增
public static int measurementadd(measurement k)
{
return(YQdal.measurementadd(k));
}
public ActionResult <string> Post([Bind("dato", "temperature", "humidity", "pressure")] measurement value)
{
db.measurement.Add(value);
db.SaveChanges();
return(value.dato + " " + value.humidity + " " + value.temperature + " " + value.pressure);
}
public Building(string name, string desc, string hist, string imageFile, int height, int width, int length, measurement usedMeasurement, int stories = 1, int rooms = 1) : base(name, desc, hist, imageFile)
{
this.stories = stories;
this.rooms = rooms;
myDimensions = new dimensions();
setDimensions(height, width, length, usedMeasurement); //Returns true if input value is a number
}