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