SilverLight中用實體類訪問WebService的方法

SilverLight工程中調用方法

----------------------------------------------------

private void Uc_UserManager_Loaded(object sender, RoutedEventArgs e)
        {
            //Id,UserGroupId,Name,AliasName,Sex,Password,Locked,Description
            //string sqlQuery = "select * from User";
            DbServiceSoapClient dbs = ServiceUtil.GetDynamicClient();
            dbs.GetALLUsersAsync();
            dbs.GetALLUsersCompleted += new EventHandler<GetALLUsersCompletedEventArgs>(dbs_GetALLUsersCompleted);
           
            //dbs.GetDataTableAsync(sqlQuery);
            //dbs.GetDataTableCompleted += new EventHandler<GetDataTableCompletedEventArgs>(dbs_GetDataTableCompleted);

        }

 

private void dbs_GetALLUsersCompleted(object sender, GetALLUsersCompletedEventArgs e)
        {
            User[] userArray=e.Result;

            this.dataGrid1.ItemsSource = userArray;
           
        }

 

WebSerivce定義方法

------------------------------------------------

[WebMethod]
        public User[] GetALLUsers()
        {
            return UserService.GetAllUsers();
        }

 

public static class UserService
    {
        public static User[] GetAllUsers()
        {
            List<User> UserList = new List<User>();
            string x = "select * from User ";
            DataTable dt = DbConnPool.DBWrap.ExecuteDataTable(x);
            if (dt != null && dt.Rows.Count > 0)
            {
                foreach (DataRow dr in dt.Rows)
                {
                    //Id,UserGroupId,Name,AliasName,Sex,Password,Locked,Description
                    User user = new User();
                    user.Id = dr["ID"].ToString();
                    user.UserGroupId = dr["UserGroupId"].ToString();
                    user.Name = dr["Name"].ToString();
                    user.AliasName = dr["AliasName"].ToString();
                    //user.Sex = dr["Sex"].ToString();
                    user.Password = dr["Password"].ToString();
                    //user.Locked = dr["Locked"].ToString();
                    user.Description = dr["Description"].ToString();
                    UserList.Add(user);
                }
            }
            if (dt != null)
            {
                dt.Dispose();
                dt = null;
            }
            return UserList.ToArray();
        }

}

 

定義實體類

-------------------------------------------------------------------

[Serializable]
    public class User
    {
        //Id,UserGroupId,Name,AliasName,Sex,Password,Locked,Description
        private string m_Id = "";

        public string Id
        {
            get { return m_Id; }
            set { m_Id = value; }
        }
        private string m_UserGroupId = "";

        public string UserGroupId
        {
            get { return m_UserGroupId; }
            set { m_UserGroupId = value; }
        }
        private string m_Name = "";

        public string Name
        {
            get { return m_Name; }
            set { m_Name = value; }
        }
        private string m_AliasName = "";

        public string AliasName
        {
            get { return m_AliasName; }
            set { m_AliasName = value; }
        }
        private bool m_Sex = false;

        public bool Sex
        {
            get { return m_Sex; }
            set { m_Sex = value; }
        }
        private string m_Password = "";

        public string Password
        {
            get { return m_Password; }
            set { m_Password = value; }
        }
        private bool m_Locked = false;

        public bool Locked
        {
            get { return m_Locked; }
            set { m_Locked = value; }
        }
        private string m_Description = "";

        public string Description
        {
            get { return m_Description; }
            set { m_Description = value; }
        }

        //----
    }