public UserInfo Select(String name)
{
UserInfo returns = null;
var dt = SqlDbAccess.GetInstance().GetTable("SELECT * FROM TRightuser WHERE Name = '" + name + "'");
foreach (DataRow dr in dt.Rows)
{
returns = new UserInfo();
returns.FromDataRow(dr);
break;
}
return returns;
}
public UserInfo Select(Int32 idx)
{
UserInfo returns = null;
var dt = SqlDbAccess.GetInstance().GetTable("SELECT * FROM TRightuser WHERE Idx = " + idx);
foreach (DataRow dr in dt.Rows)
{
returns = new UserInfo();
returns.FromDataRow(dr);
break;
}
return returns;
}
public IList<UserInfo> SelectAll()
{
var returns = new List<UserInfo>();
var dt = SqlDbAccess.GetInstance().GetTable("SELECT * FROM TRightuser");
foreach (DataRow dr in dt.Rows)
{
var tUser = new UserInfo();
tUser.FromDataRow(dr);
returns.Add(tUser);
}
return returns;
}