public string querySensor(string tbim, string type)
{
string[] senType = new string[11];
senType[0] = "speedSensor";
senType[1] = "heightSensor";
senType[2] = "temperatureSensor";
senType[3] = "pressureSensor";
senType[4] = "FuelQuantitySensor";
senType[5] = "solidGague";
senType[6] = "accelerateSensor";
senType[7] = "VUSensor";
senType[8] = "switch";
senType[9] = "battery";
senType[10] = "indicator";
/* long tick = DateTime.Now.Ticks;
* Random ro = new Random((int)(tick & 0xffffffffL) | (int)(tick >> 32));
* List<SensorDescription> list = new List<SensorDescription>();
* for (int i = 1; i <= 20; i++) {
* SensorDescription f = new SensorDescription();
* f.tbim = i.ToString();
* f.alias = i.ToString();
* int iRan = ro.Next(0, 11);
* f.sensorType = senType[iRan];
* list.Add(f);
* }
*/
string coonString = @"SERVER=tianmn-pc\sqlexpress;UID=tianmn2109;password=10000000;";
SqlConnection connection = new SqlConnection(coonString);
connection.Open();
string queryStr = @"select * from dbo.testData";
if (tbim != "ALL")
{
queryStr += @" and tbim='" + tbim + "'";
}
if (type != "ALL")
{
queryStr += @" and type ='" + type + "'";
}
SqlCommand seleceCMD = new SqlCommand(queryStr, connection);
SqlDataAdapter custDA = new SqlDataAdapter();
custDA.SelectCommand = seleceCMD;
DataSet custDS = new DataSet();
custDA.Fill(custDS);
List <SensorDescription> list = new List <SensorDescription>();
foreach (DataRow mDr in custDS.Tables[0].Rows)
{
SensorDescription f = new SensorDescription();
f.tbim = mDr["tbim"].ToString();
f.alias = mDr["alias"].ToString();
f.sensorType = senType[int.Parse(mDr["sensorType"].ToString())];
list.Add(f);
}
string json = new JavaScriptSerializer().Serialize(list);
return(json);
}
public string querySensor(string tbim, string type)
{
string[] senType = new string[11];
senType[0] = "speedSensor";
senType[1] = "heightSensor";
senType[2] = "temperatureSensor";
senType[3] = "pressureSensor";
senType[4] = "FuelQuantitySensor";
senType[5] = "solidGague";
senType[6] = "accelerateSensor";
senType[7] = "VUSensor";
senType[8] = "switch";
senType[9] = "battery";
senType[10] = "indicator";
/* long tick = DateTime.Now.Ticks;
Random ro = new Random((int)(tick & 0xffffffffL) | (int)(tick >> 32));
List<SensorDescription> list = new List<SensorDescription>();
for (int i = 1; i <= 20; i++) {
SensorDescription f = new SensorDescription();
f.tbim = i.ToString();
f.alias = i.ToString();
int iRan = ro.Next(0, 11);
f.sensorType = senType[iRan];
list.Add(f);
}
*/
string coonString = @"SERVER=tianmn-pc\sqlexpress;UID=tianmn2109;password=10000000;";
SqlConnection connection = new SqlConnection(coonString);
connection.Open();
string queryStr = @"select * from dbo.testData";
if (tbim != "ALL") {
queryStr += @" and tbim='" + tbim + "'";
}
if (type != "ALL") {
queryStr += @" and type ='" + type + "'";
}
SqlCommand seleceCMD = new SqlCommand(queryStr, connection);
SqlDataAdapter custDA = new SqlDataAdapter();
custDA.SelectCommand = seleceCMD;
DataSet custDS = new DataSet();
custDA.Fill(custDS);
List<SensorDescription> list = new List<SensorDescription>();
foreach (DataRow mDr in custDS.Tables[0].Rows)
{
SensorDescription f = new SensorDescription();
f.tbim = mDr["tbim"].ToString();
f.alias = mDr["alias"].ToString();
f.sensorType = senType[int.Parse(mDr["sensorType"].ToString())];
list.Add(f);
}
string json = new JavaScriptSerializer().Serialize(list);
return json;
}