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

        }