public static List <Role> Find(string roleName)
{
List <Role> ret = new List <Role>();
string querySql = "SELECT ID, Name, Description, RightsID, Status,CreateID,CreateDate FROM HPMS_Role where Name=@name and Status >=0";
IDbDataParameter[] b = new IDbDataParameter[1];
b[0] = Gloabal.GDatabase.CreatePara("name", roleName);
DataTable table = Gloabal.GDatabase.GetDataTable(querySql, b);
foreach (DataRow tempRow in table.Rows)
{
Role role = new Role
{
RoleId = int.Parse(tempRow["ID"].ToString()),
Name = (string)tempRow["Name"],
Description = (string)tempRow["Description"],
RightsId = (string)tempRow["RightsID"],
Right = RightDao.GetRightsById((string)tempRow["RightsID"]),
CreateDate = ((DateTime)tempRow["CreateDate"]).ToString(),
CreateId = (int)tempRow["CreateID"],
RecordStatus = (RecordStatus)(int)tempRow["Status"]
};
ret.Add(role);
}
return(ret);
}
public static List <Role> FindAll()
{
List <Role> ret = new List <Role>();
string querySql = "SELECT ID, Name, Description, RightsID, Status,CreateID,CreateDate FROM HPMS_Role where Status =1 and isSuper is Null";
DataTable table = Gloabal.GDatabase.GetDataTable(querySql);
foreach (DataRow tempRow in table.Rows)
{
Role role = new Role
{
RoleId = int.Parse(tempRow["ID"].ToString()),
Name = (string)tempRow["Name"],
Description = (string)tempRow["Description"],
RightsId = (string)tempRow["RightsID"],
Right = RightDao.GetRightsById((string)tempRow["RightsID"]),
CreateDate = ((DateTime)tempRow["CreateDate"]).ToString(),
CreateId = (int)tempRow["CreateID"],
RecordStatus = (RecordStatus)(int)tempRow["Status"]
};
ret.Add(role);
}
return(ret);
}
public static List <User> Find(string userName)
{
List <User> ret = new List <User>();
string querySql = "SELECT ID, UserName, Password, Salt, RoleID, " +
"isSuper, CreateID, CreateDate,RoleRights, UserStatus,RoleName,RoleStatus FROM v_HPMS_User" +
" where UserName = @username";
IDbDataParameter[] b = new IDbDataParameter[1];
b[0] = Gloabal.GDatabase.CreatePara("username", userName);
DataTable table = Gloabal.GDatabase.GetDataTable(querySql, b);
foreach (DataRow tempRow in table.Rows)
{
var user = new User();
user.UserId = int.Parse(tempRow["ID"].ToString());
user.Username = (string)tempRow["UserName"];
user.Psw = (string)tempRow["Password"];
user.Role = (string)tempRow["RoleName"];
user.RoleId = int.Parse(tempRow["RoleID"].ToString());
user.CreateDate = ((DateTime)tempRow["CreateDate"]).ToString();
user.Rights = RightDao.GetRightsById((string)tempRow["RoleRights"]);
user.CreaterId = (int)tempRow["CreateID"];
user.UserStatus = (RecordStatus)(int)tempRow["UserStatus"];
user.IsSuper = tempRow["isSuper"] != null;
user.RoleStatus = (RecordStatus)(int)tempRow["RoleStatus"];
ret.Add(user);
}
return(ret);
}