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; }