? <connectionStrings>
??? <add name="mysqlwxs" connectionString="server=192.168.0.200;user id=root;password=admin;database=wxs;CharSet=gb2312;" providerName="MySql.Data.MySqlClient"/>
? </connectionStrings>
?
?
?private string mysqlYunfeng = ConfigurationManager.ConnectionStrings["mysqlwxs"].ConnectionString;
?
?public FriendGPSList ReturnFriendGPSList(string groupId)
??????? {
??????????? FriendGPSList gpsList = new FriendGPSList();
??????????? gpsList.gpsList = new List<GPSNode>();
??????????? gpsList.resNode = new ResErrorNode();
??????????? try
??????????? {
???????????????? MySqlConnection conn = new MySqlConnection(mysqlYunfeng);
??????????????? conn.Open();
??????????????? string selectStr = String.Format("select FID,FName,FTel,FSex,FGLatitude,FGLongitude,FGHight from friends where FGroupID = '{0}'",groupId);
??????????????? MySqlDataAdapter adapter = new MySqlDataAdapter(selectStr,conn);
??????????????? DataSet ds = new DataSet();
??????????????? adapter.Fill(ds);
??????????????? DataTable dt = ds.Tables[0];
??????????????? for (int i = 0; i < dt.Rows.Count; i++)
??????????????? {
??????????????????? GPSNode node = new GPSNode();
??????????????????? node.FId = dt.Rows[i][0].ToString();
??????????????????? node.FName = dt.Rows[i][1].ToString();
??????????????????? node.FTel = dt.Rows[i][2].ToString();
??????????????????? node.FSex = dt.Rows[i][3].ToString();
??????????????????? node.Latitude = double.Parse(dt.Rows[i][4].ToString());
??????????????????? node.Longitude = double.Parse(dt.Rows[i][5].ToString());
??????????????????? node.Hight =Int32.Parse(dt.Rows[i][6].ToString());
??????????????????? gpsList.gpsList.Add(node);
??????????????? }
??????????? }
??????????? catch(Exception e)
??????????? {
??????????????? gpsList.resNode.Code = -1;
??????????????? gpsList.resNode.Message = e.Message;
??????????????? gpsList.gpsList = null;
??????????????? return gpsList;
??????????? }
??????????? gpsList.resNode.Code = gpsList.gpsList.Count;
??????????? gpsList.resNode.Message = "OK";
??????????? return gpsList;
??????? }
?
?
?
?
?
?
?
?
?
?
?
?
?
?
? public ResErrorNode AddGroup(string name,string pass,string adminId)
??????? {
??????????? MySqlConnection conn = new MySqlConnection(mysqlYunfeng);
??????????? conn.Open();
??????????? DateTime dt = DateTime.Now;
??????????? string id = dt.ToString("MMddhhmmss");
??????????? string insertStr = String.Format("insert into Groups(GroupID,GroupName,GroupPass,GroupAdminId) values('{0}','{1}','{2}',{3})",id,name,pass,adminId);
??????????? MySqlCommand cmd = new MySqlCommand(insertStr,conn);??????????? ResErrorNode resNode = new ResErrorNode();??????????? try??????????? {??????????????? cmd.ExecuteNonQuery();??????????? }??????????? catch (Exception ex)??????????? {??????????????? String message = ex.Message;??????????????? Console.WriteLine("插入失败：" + message);??????????????? resNode.Code = -1;??????????????? resNode.Message = message;??????????????? return resNode;??????????? }??????????? resNode.Code = 0;??????????? resNode.Message = id;??????????? return resNode;??????? }
