public string queryDatabase(string tbim, string alias)
{
/* long tick = DateTime.Now.Ticks;
* Random ro = new Random((int)(tick & 0xffffffffL) | (int)(tick >> 32));
* int iResult;
* int iUp = 100;
* int iDown = 80;
* iResult = ro.Next(iDown, iUp);
* iResult.ToString();
* SensorInfo f1 = new SensorInfo();
* f1.tbim = int.Parse(tbim);
* f1.alias = int.Parse(alias);
* f1.value = double.Parse(iResult.ToString());
* f1.description = "for test";
* f1.peroid = int.Parse("100");
* List<SensorInfo> list = new List<SensorInfo>();
* list.Add(f1);
*/
string coonString = @"SERVER=tianmn-pc\sqlexpress;UID=tianmn2109;password=10000000;";
SqlConnection connection = new SqlConnection(coonString);
connection.Open();
string queryStr = @"select * from dbo.testData where tbim='" + tbim + "' and alias = '" + alias + "'";
SqlCommand seleceCMD = new SqlCommand(queryStr, connection);
SqlDataAdapter custDA = new SqlDataAdapter();
custDA.SelectCommand = seleceCMD;
DataSet custDS = new DataSet();
custDA.Fill(custDS);
List <SensorInfo> list = new List <SensorInfo>();
foreach (DataRow mDr in custDS.Tables[0].Rows)
{
SensorInfo f1 = new SensorInfo();
f1.tbim = int.Parse(tbim);
f1.alias = int.Parse(alias);
f1.value = float.Parse(mDr["value"].ToString());
f1.description = mDr["description"].ToString();
f1.peroid = int.Parse(mDr["peroid"].ToString());
list.Add(f1);
}
connection.Close();
string json = new JavaScriptSerializer().Serialize(list);
return(json);
}
public string queryDatabase(string tbim, string alias)
{
/* long tick = DateTime.Now.Ticks;
Random ro = new Random((int)(tick & 0xffffffffL) | (int)(tick >> 32));
int iResult;
int iUp = 100;
int iDown = 80;
iResult = ro.Next(iDown, iUp);
iResult.ToString();
SensorInfo f1 = new SensorInfo();
f1.tbim = int.Parse(tbim);
f1.alias = int.Parse(alias);
f1.value = double.Parse(iResult.ToString());
f1.description = "for test";
f1.peroid = int.Parse("100");
List<SensorInfo> list = new List<SensorInfo>();
list.Add(f1);
*/
string coonString = @"SERVER=tianmn-pc\sqlexpress;UID=tianmn2109;password=10000000;";
SqlConnection connection = new SqlConnection(coonString);
connection.Open();
string queryStr = @"select * from dbo.testData where tbim='" + tbim + "' and alias = '" + alias + "'";
SqlCommand seleceCMD = new SqlCommand(queryStr, connection);
SqlDataAdapter custDA = new SqlDataAdapter();
custDA.SelectCommand = seleceCMD;
DataSet custDS = new DataSet();
custDA.Fill(custDS);
List<SensorInfo> list = new List<SensorInfo>();
foreach (DataRow mDr in custDS.Tables[0].Rows)
{
SensorInfo f1 = new SensorInfo();
f1.tbim = int.Parse(tbim);
f1.alias = int.Parse(alias);
f1.value = float.Parse(mDr["value"].ToString());
f1.description = mDr["description"].ToString();
f1.peroid = int.Parse(mDr["peroid"].ToString());
list.Add(f1);
}
connection.Close();
string json = new JavaScriptSerializer().Serialize(list);
return json;
}
