Signal从数据库读取数据插入表格

And & Or .在WHERE子句中AND和OR被用来连接两个或者更多的条件

• 用AND运算子来查找"Persons" 表中FirstName为”Tove”而且LastName为” Svendson”的数据

SELECT * FROM Persons
WHERE FirstName='Tove'
AND LastName='Svendson'

 List<object> HorizontalBarChartsDate = new List<object>();
                List<object> HorizontalBarChartsValue = new List<object>();
                for (int i = 0; i < 25; i++)
                {
                    var stationName = "tableproductioninfostation" + (i + 1).ToString("D2");
                    var query = new StringBuilder();
                    query.Append("SELECT * FROM ").Append(stationName).Append(" WHERE checkResult = 'NG'");
                    DbSet dbSet = db.GetDbSetByName(stationName);
                    if (dbSet == null)
                    {
                        continue;
                    }
                    int horizontalBarChartsDate = dbSet.SqlQuery(query.ToString()).ToListAsync().Result.Count();
                  
                    HorizontalBarChartsValue.Add(horizontalBarChartsDate);
                }
                Clients.All.addHorizontalBarChartValue(HorizontalBarChartsValue.ToArray());