WebService

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