public override string ToString()
{
return(string.Join(",", ApiKey, Temp.ToString(CultureInfo.InvariantCulture),
Hum.ToString(CultureInfo.InvariantCulture), Preassure.ToString(CultureInfo.InvariantCulture),
CO2.ToString(CultureInfo.InvariantCulture), LPG.ToString(CultureInfo.InvariantCulture),
CO.ToString(CultureInfo.InvariantCulture), CH4.ToString(CultureInfo.InvariantCulture),
Dust.ToString(CultureInfo.InvariantCulture), Longitude.ToString(CultureInfo.InvariantCulture),
Latitude.ToString(CultureInfo.InvariantCulture)));
}
static void Main(string[] args)
{
Console.WriteLine("Hello DHT!");
DHTSensor dht = new DHTSensor(26, DhtType.Dht22);
while (true)
{
// You have 2 ways to read the data, both are equivalent
// First way to read the data
bool readret = dht.ReadData();
if (readret)
{
Console.WriteLine($"Temperature: {dht.Temperature.Celsius.ToString("0.00")} °C, Humidity: {dht.Humidity.ToString("0.00")} %");
}
else
{
Console.WriteLine("Error reading the sensor");
}
Thread.Sleep(1000);
// Second way to read the data
Temperature Temp;
double Hum;
if (dht.TryGetTemperatureAndHumidity(out Temp, out Hum))
{
Console.WriteLine($"Temperature: {Temp.Celsius.ToString("0.00")} °C, Humidity: {Hum.ToString("0.00")} %");
}
else
{
Console.WriteLine("Error reading the sensor");
}
Thread.Sleep(1000);
}
}
static void Main(string[] args)
{
SqlConnection connection = SQL.GetInstance();
CommandMaker maker = new CommandMaker();
SqlCommand command = new SqlCommand();
while (true)
{
Console.WriteLine("Выберите таблицу с которой будете работать\nHuman - 1\nMail - 2\n" +
"Give - 3\nЗакончить работу с таблицами - другое");
string choise = Console.ReadLine();
string table;
if (choise == "1")
{
table = "Human";
}
else if (choise == "2")
{
table = "Mail";
}
else if (choise == "3")
{
table = "Give";
}
else
{
break;
}
while (true)
{
Console.WriteLine("Какую команду используем\nInsert - 1\nUpdate - 2\n" +
"Delete - 3\nЗакончить работу с данной таблицей - другое");
choise = Console.ReadLine();
if (choise == "1")
{
if (table == "Human")
{
command = maker.GetCommand(new InsertHuman(table));
}
else if (table == "Mail")
{
command = maker.GetCommand(new InsertMail(table));
}
else if (table == "Give")
{
command = maker.GetCommand(new InsertGive(table));
}
}
else if (choise == "2")
{
if (table == "Human")
{
command = maker.GetCommand(new UpdateHuman(table));
}
else if (table == "Mail")
{
command = maker.GetCommand(new UpdateMail(table));
}
else if (table == "Give")
{
command = maker.GetCommand(new UpdateGive(table));
}
}
else if (choise == "3")
{
command = maker.GetCommand(new Delete(table));
}
else
{
break;
}
command.Connection = connection;
DoCommand(command);
}
}
SqlDataAdapter adapter = new SqlDataAdapter();
DataSet ds = new DataSet();
adapter.SelectCommand = new SqlCommand("Select Human.Name, Human.Birth from Human " +
"join Mail on Human.ID = Mail.Send where len(mail.text) = (Select min(len(mail.text)) from mail)", connection);
adapter.Fill(ds, "1");
adapter.SelectCommand = new SqlCommand("Select Human.Name, Human.Second, tab2.Give, tab.Send from Human " +
"join (Select Human.ID, count(Mail.Send) as Send from Human " +
"left join Mail on Human.ID = Mail.Send group by Human.ID) as tab on tab.ID = Human.ID " +
"join (Select Human.ID, count(Give.Give) as Give from Human " +
"left join Give on Human.ID = Give.Give group by Human.ID) as tab2 on tab2.ID = Human.ID", connection);
adapter.Fill(ds, "2");
DataSet CloseSet = new DataSet();
adapter.SelectCommand = new SqlCommand("Select * From Human", connection);
adapter.Fill(CloseSet, "Human");
adapter.SelectCommand = new SqlCommand("Select * From Mail", connection);
adapter.Fill(CloseSet, "Mail");
adapter.SelectCommand = new SqlCommand("Select * From Give", connection);
adapter.Fill(CloseSet, "Give");
connection.Close();
foreach (DataTable dt in ds.Tables)
{
Console.WriteLine(dt.TableName);
foreach (DataColumn column in dt.Columns)
{
Console.Write("{0}\t\t", column.ColumnName);
}
Console.WriteLine();
foreach (DataRow row in dt.Rows)
{
var cells = row.ItemArray;
foreach (object cell in cells)
{
Console.Write("{0}\t", cell);
}
Console.WriteLine();
}
}
Console.WriteLine("Введите тему");
string theme = Console.ReadLine();
var Three = (from Hum in CloseSet.Tables["Human"].AsEnumerable()
join Give in CloseSet.Tables["Give"].AsEnumerable() on Hum.Field <int>("ID") equals Give.Field <int>("Give")
join Mail in CloseSet.Tables["Mail"].AsEnumerable() on Give.Field <int>("Mail") equals Mail.Field <int>("ID")
where Mail.Field <string>("Theme").TrimEnd(' ') == theme
select new { name = Hum.Field <string>("Name"), second = Hum.Field <string>("Second") }).Distinct();
Console.WriteLine("Получатели заданной темы");
foreach (var item in Three)
{
Console.WriteLine("{0} {1}", item.name, item.second);
}
}
