// Update is called once per frame
void Update()
{
if (mainparts = GetComponentInParent <parts2>())
{
parts_input_voltage = mainparts.input_voltage;
parts_output_voltage = mainparts.output_voltage;
parts_resistance = mainparts.resistance;
parts_amperage = mainparts.amperage;
parts_voltage = mainparts.voltage;
parts_flag = true;
}
if (mainbattery = GetComponentInParent <battery>())
{
parts_input_voltage = mainbattery.input_voltage;
parts_output_voltage = mainparts.output_voltage;
parts_amperage = mainbattery.amperage;
parts_voltage = mainbattery.input_voltage;
}
if (wire_attached_count < 12)
{
wire_attached_count++;
}
else if (wire_attached_flag)
{
wire_attached_flag = false;
}
}
//Update is called once per frame
void Update()
{
if (wire_attached_count < 12)
{
wire_attached_count++;
}
else if (wire_attached_flag)
{
wire_attached_flag = false;
}
if (mainparts = GetComponentInParent <parts>())
{
parts_voltage = mainparts.output_voltage;
amperage = mainparts.amperage;
flag = true;
}
if (mainbattery = GetComponentInParent <battery>())
{
parts_voltage = mainbattery.output_voltage;
amperage = mainbattery.amperage;
if (mainbattery.battery_exist_flag)
{
flag = true;
}
else
{
voltage = mainbattery.output_voltage;
}
}
}
public List <battery> GetAllBatteries()
{
var batteryList = new List <battery>();
using (SqlConnection conn = new SqlConnection(connectionString))
{
conn.Open();
SqlDependency.Start(connectionString);
string cmdText = "select TOP (10)[name],[time],[sensor_number],[sensor_type],[value] from dbo.battery where [sensor_number] ='E110-sensortag-01' UNION " +
"select TOP (10)[name],[time],[sensor_number],[sensor_type],[value] from dbo.battery where [sensor_number] ='E110-sensortag-02' UNION " +
"select TOP(10)[name],[time],[sensor_number],[sensor_type],[value] from dbo.battery where[sensor_number] = 'E110-sensortag-03' UNION " +
"select TOP (10)[name],[time],[sensor_number],[sensor_type],[value] from dbo.battery where [sensor_number] ='E110-sensortag-04'UNION " +
"select TOP (10)[name],[time],[sensor_number],[sensor_type],[value] from dbo.battery where [sensor_number] ='E110-sensortag-05'"
;
SqlCommand cmd = new SqlCommand(cmdText, conn);
SqlDependency dependency = new SqlDependency(cmd);
dependency.OnChange += dbChangeNotification;
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
var reader = cmd.ExecuteReader();
while (reader.Read())
{
var batteryInfo = new battery
{
time = Convert.ToInt64(reader["time"]),
name = reader["name"].ToString(),
sensor_number = reader["sensor_number"].ToString(),
sensor_type = reader["sensor_type"].ToString(),
value = Convert.ToInt16(reader["value"])
};
batteryList.Add(batteryInfo);
}
}
return(batteryList);
}
private void Awake()
{
battery = new battery(100);
score = new score(0);
InvokeRepeating("CustomeUpdate", 0.5f, 0.5f);
}
