public void Update(Domain.SubMenu subMenu)
{
var sql = "UPDATE dbo.T_Menu SET [Name]=@NAME,[Address]=@ADDRESS,[SortLevel]=@SORTLEVEL,[Remark]=@REMARK,[Valid]=@VALID,Display=@Display WHERE [Id]=@ID";
using (var dbOperator = new DbOperator(Provider, ConnectionString)) {
dbOperator.AddParameter("ID", subMenu.Id);
dbOperator.AddParameter("NAME", subMenu.Name);
dbOperator.AddParameter("ADDRESS", subMenu.Address ?? string.Empty);
dbOperator.AddParameter("SORTLEVEL", subMenu.SortLevel);
dbOperator.AddParameter("REMARK", subMenu.Remark ?? string.Empty);
dbOperator.AddParameter("VALID", subMenu.Valid);
dbOperator.AddParameter("Display", subMenu.Display);
dbOperator.ExecuteNonQuery(sql);
}
}
private IEnumerable <Domain.Menu> constructMenus(DbDataReader reader)
{
var result = new List <Domain.Menu>();
Domain.Menu menu = null;
Domain.SubMenu submenu = null;
while (reader.Read())
{
var currentMenuId = DataHelper.GetGuid(reader["MenuId"]);
if (menu == null || menu.Id != currentMenuId)
{
menu = new Domain.Menu(currentMenuId, DataHelper.GetString(reader["MenuName"]))
{
Remark = DataHelper.GetString(reader["MenuRemark"]),
SortLevel = DataHelper.GetInteger(reader["MenuSortLevel"]),
Valid = DataHelper.GetBoolean(reader["MenuValid"]),
Display = reader["MenuDisplay"] == DBNull.Value || DataHelper.GetBoolean(reader["MenuDisplay"])
};
submenu = null;
result.Add(menu);
}
var currentSubMenuId = DataHelper.GetGuid(reader["SubMenuId"]);
if (submenu == null || submenu.Id != currentSubMenuId)
{
submenu = new Domain.SubMenu(currentSubMenuId, DataHelper.GetString(reader["SubMenuName"]), DataHelper.GetString(reader["SubMenuAddress"]))
{
Remark = DataHelper.GetString(reader["SubMenuRemark"]),
SortLevel = DataHelper.GetInteger(reader["SubMenuSortLevel"]),
Valid = DataHelper.GetBoolean(reader["SubMenuValid"]),
Display = reader["SubMenuDisplay"] == DBNull.Value || DataHelper.GetBoolean(reader["SubMenuDisplay"])
};
menu.AppendChild(submenu);
}
if (reader["ResourceId"] != DBNull.Value)
{
submenu.AppendResource(new Domain.Resource(DataHelper.GetGuid(reader["ResourceId"]))
{
Name = DataHelper.GetString(reader["ResourceName"]),
Address = DataHelper.GetString(reader["ResourceAddress"]),
Remark = DataHelper.GetString(reader["ResourceRemark"]),
Valid = DataHelper.GetBoolean(reader["ResourceValid"])
});
}
}
return(result);
}
public void Register(Website website, Guid menuId, Domain.SubMenu subMenu)
{
var sql = "INSERT INTO dbo.T_Menu ([Id],[Name],[Address],[SortLevel],[Depth],[Remark],[Valid],Display,[Parent],[Website])" +
" VALUES (@ID,@NAME,@ADDRESS,@SORTLEVEL,@DEPTH,@REMARK,@VALID,@Display,@PARENT,@WEBSITE)";
using (var dbOperator = new DbOperator(Provider, ConnectionString)) {
dbOperator.AddParameter("ID", subMenu.Id);
dbOperator.AddParameter("NAME", subMenu.Name);
dbOperator.AddParameter("ADDRESS", subMenu.Address ?? string.Empty);
dbOperator.AddParameter("SORTLEVEL", subMenu.SortLevel);
dbOperator.AddParameter("DEPTH", 2);
dbOperator.AddParameter("REMARK", subMenu.Remark ?? string.Empty);
dbOperator.AddParameter("VALID", subMenu.Valid);
dbOperator.AddParameter("Display", subMenu.Display);
dbOperator.AddParameter("PARENT", menuId);
dbOperator.AddParameter("WEBSITE", (byte)website);
dbOperator.ExecuteNonQuery(sql);
}
}
public IEnumerable <Domain.PermissionRole> QueryPermissionRolesOfUser(Guid user, Website website)
{
var result = new List <Domain.PermissionRole>();
var sql = "dbo.P_QueryPermissionRolesOfUser";
using (var dbOperator = new DbOperator(Provider, ConnectionString)) {
dbOperator.AddParameter("@iUserId", user);
dbOperator.AddParameter("@iWebSite", (byte)website);
using (var reader = dbOperator.ExecuteReader(sql, System.Data.CommandType.StoredProcedure)) {
Domain.PermissionRole role = null;
Domain.Menu menu = null;
Domain.SubMenu submenu = null;
while (reader.Read())
{
var currentRoleId = DataHelper.GetGuid(reader["RoleId"]);
if (role == null || role.Id != currentRoleId)
{
role = new Domain.PermissionRole(currentRoleId)
{
Name = DataHelper.GetString(reader["RoleName"]),
Remark = DataHelper.GetString(reader["RoleRemark"]),
Valid = true
};
menu = null;
result.Add(role);
}
var currentMenuId = DataHelper.GetGuid(reader["MenuId"]);
if (menu == null || menu.Id != currentMenuId)
{
menu = new Domain.Menu(currentMenuId, DataHelper.GetString(reader["MenuName"]))
{
Remark = DataHelper.GetString(reader["MenuRemark"]),
SortLevel = DataHelper.GetInteger(reader["MenuSortLevel"]),
Valid = true,
Display = DataHelper.GetBoolean(reader["MenuDisplay"])
};
submenu = null;
role.AppendMenu(menu);
}
var currentSubMenuId = DataHelper.GetGuid(reader["SubMenuId"]);
if (submenu == null || submenu.Id != currentSubMenuId)
{
submenu = new Domain.SubMenu(currentSubMenuId, DataHelper.GetString(reader["SubMenuName"]), DataHelper.GetString(reader["SubMenuAddress"]))
{
Remark = DataHelper.GetString(reader["SubMenuRemark"]),
SortLevel = DataHelper.GetInteger(reader["SubMenuSortLevel"]),
Valid = true,
Display = DataHelper.GetBoolean(reader["SubMenuDisplay"])
};
menu.AppendChild(submenu);
}
if (reader["ResourceId"] != DBNull.Value)
{
submenu.AppendResource(new Domain.Resource(DataHelper.GetGuid(reader["ResourceId"]))
{
Name = DataHelper.GetString(reader["ResourceName"]),
Address = DataHelper.GetString(reader["ResourceAddress"]),
Remark = DataHelper.GetString(reader["ResourceRemark"]),
Valid = true
});
}
}
}
}
return(result);
}
