protected void Page_Load(object sender, EventArgs e)
{
var style = new MenuTemplate.MenuAttributes();
style.MenuCssClass = "nav";
style.MenuId = "side-menu";
style.ItemSelectedClass = "active";
Template = new MenuTemplate(style);
//Template.ItemHeader = "<li class='[[ItemCssClass]]'>"
// + "<a href='[[ItemHref]]' onclick='[[ItemOnClick]]' class='{{ItemCssClass}} [[ItemCssClass]]' "
// + "style='{{ItemStyle}} [[ItemStyle]]'>"
// + "<i class='[[ItemCssClass]]'></i>"
// + "[[ItemContent]]"
// + "</a>";
Template.ItemHeader = "<li class='[[ItemSelectedClass]]'>"
+ "<a href='[[ItemHref]]' class='[[ItemSelectedClass]]' onclick='[[ItemOnClick]]' "
+ "style='{{ItemStyle}} [[ItemStyle]]'>"
+ "<i class='[[ItemCssClass]]'></i>"
+ " [[ItemContent]]"
+ "</a>";
Template.ReBuild(style);
//base.Page_Load(sender, e);
LblContent = base.GetContent();
}
public SimpleMenu(int top, int left, MenuTemplate template, int maxMenuItem)
{
this.position = new Position(top, left);
this.template = template;
this.items = new MenuItem[maxMenuItem];
this.index = 0;
this.current = 0;
}
protected new void CreateMenuTemplate()
{
var product = Repository<Product>.FindFirst();
var menuTemplate = new MenuTemplate(product, "MENU_TEMPLATE") {Name = "메뉴템플릿", Description = "설명입니다."};
menuTemplate.AddLocale(new CultureInfo("en"), new MenuTemplateLocale {Name = "MENU_TEMPLATE"});
menuTemplate.AddLocale(new CultureInfo("ko"), new MenuTemplateLocale {Name = "메뉴템플릿"});
Repository<MenuTemplate>.SaveOrUpdate(menuTemplate);
}
private MenuTemplate getMainMenu()
{
MenuTemplate menu = new MenuTemplate ("main");
menu.setTitle ();
menu.addButton ("Start Game");
menu.addButton ("Sandbox");
menu.addButton ("Credits");
menu.addButton ("Exit");
return menu;
}
void Awake()
{
escIsEnabled = true;
menuAction = null;
levelNameDic=new Hashtable();
startMenuMusic ();
mainMenu = getMainMenu ();
creditsMenu = getCreditsMenu ();
startGameMenu = getStartGameMenu ();
activeMenu = mainMenu;
}
private MenuTemplate getCreditsMenu()
{
MenuTemplate menu = new MenuTemplate ("credits");
menu.addText ("Credits:", MenuTemplate.MenuFonts.large);
menu.addText ("Stuart Spence", MenuTemplate.MenuFonts.medium);
menu.addText ("Programmer", MenuTemplate.MenuFonts.small);
menu.addText ("Kyler Kelly", MenuTemplate.MenuFonts.medium);
menu.addText ("Artist", MenuTemplate.MenuFonts.small);
menu.addText ("Philip Storey", MenuTemplate.MenuFonts.medium);
menu.addText ("Project Starter", MenuTemplate.MenuFonts.small);
menu.addButton ("Back");
return menu;
}
private MenuTemplate getStartGameMenu()
{
MenuTemplate menu = new MenuTemplate ("levels");
menu.addText ("Levels", MenuTemplate.MenuFonts.large);
foreach (Object obj in Resources.LoadAll("Prefabs/Levels", typeof(LevelData))) {
//foreach (GameObject obj in Resources.LoadAll("Prefabs/Levels", typeof(LevelData))) {
if (obj.name!="default" && obj.name!="sandbox"){
string levelName=((LevelData)obj).levelName;
levelNameDic.Add(levelName,obj.name);
menu.addButton (levelName);
}
}
menu.addButton ("Back");
return menu;
}
/// <summary>
/// <see cref="Menu"/>정보를 조회하기 위한 Criteria를 빌드합니다.
/// </summary>
public QueryOver<Menu, Menu> BuildQueryOverOfMenu(Product product, string code, MenuTemplate menuTemplate, bool? isActive)
{
var query = QueryOver.Of<Menu>();
MenuTemplate @menuTemplateAlias = null;
if(product != null)
query.JoinAlias(m => m.MenuTemplate, () => @menuTemplateAlias)
.AddWhere(() => @menuTemplateAlias.Product == product);
if(code.IsNotWhiteSpace())
query.AddWhere(m => m.Code == code);
if(menuTemplate != null)
query.AddWhere(m => m.MenuTemplate == menuTemplate);
if(isActive.HasValue)
query.AddNullAsTrue(m => m.IsActive, isActive.Value);
return query;
}
public bool TryHandle(object sender, object message)
{
var view = _view;
if (!view.IsAlive())
{
Update(null);
return(false);
}
var activity = _view.Context.GetActivity();
if (activity == null)
{
Update(null);
Tracer.Warn("(PopupMenu) The contex of view is not an activity.");
return(false);
}
var templateId = _view.GetBindingMemberValue(AttachedMembers.View.PopupMenuTemplate);
var path = _view.GetBindingMemberValue(AttachedMembers.View.PopupMenuPlacementTargetPath);
View itemView = null;
if (!string.IsNullOrEmpty(path))
{
itemView = (View)BindingExtensions.GetValueFromPath(message, path);
}
var menuPresenter = _view.GetBindingMemberValue(AttachedMembers.View.PopupMenuPresenter);
if (menuPresenter == null)
{
var menu = new PopupMenu(activity, itemView ?? view);
activity.MenuInflater.Inflate(templateId, menu.Menu, itemView ?? view);
menu.SetOnDismissListener(DismissListener);
menu.Show();
return(true);
}
return(menuPresenter.Show(view, itemView ?? view, templateId, message, (s, menu) => MenuTemplate.Clear(menu)));
}
public void OnDismiss(PopupMenu menu)
{
MenuTemplate.Clear(menu.Menu);
}
public async Task <OperationResult> LoadNavigationMenuDuringStartProgram(string pluginId)
{
var eformPlugin = await _dbContext.EformPlugins
.FirstOrDefaultAsync(x => x.PluginId == pluginId);
if (eformPlugin == null)
{
return(new OperationDataResult <InstalledPluginsModel>(false,
_localizationService.GetString("PluginNotFound")));
}
var plugin = Program.EnabledPlugins.FirstOrDefault(x => x.PluginId == pluginId);
if (plugin == null)
{
return(new OperationDataResult <InstalledPluginsModel>(false,
_localizationService.GetString("PluginNotFound")));
}
var pluginMenu = plugin.GetNavigationMenu(_serviceProvider);
// get all menu templates from plugin
var menuTemplatesFromPlugin = new List <PluginMenuTemplateModel>();
foreach (var pluginMenuItem in pluginMenu)
{
if (pluginMenuItem.Type == MenuItemTypeEnum.Link)
{
menuTemplatesFromPlugin.Add(pluginMenuItem.MenuTemplate);
}
if (pluginMenuItem.Type == MenuItemTypeEnum.Dropdown)
{
foreach (var childMenuItem in pluginMenuItem.ChildItems)
{
if (childMenuItem.Type == MenuItemTypeEnum.Link)
{
menuTemplatesFromPlugin.Add(childMenuItem.MenuTemplate);
}
}
}
}
var menuTemplatesFromDatabase = _dbContext.MenuTemplates
.Where(x => x.EformPluginId == eformPlugin.Id)
.ToList();
if (menuTemplatesFromDatabase.Any())
{
if (menuTemplatesFromPlugin.Count() != menuTemplatesFromDatabase.Count())
{
foreach (var menuTemplateFromPlugin in menuTemplatesFromPlugin)
{
// get all templates name that in database
var menuTemplatesFromDatabaseNames = menuTemplatesFromDatabase.Select(x => x.E2EId).ToList();
// if template from plugin is not contains in database
if (!menuTemplatesFromDatabaseNames.Contains(menuTemplateFromPlugin.E2EId))
{
// add to database menu templates from plugin
var menuTemplateToDatabase = new MenuTemplate()
{
Name = menuTemplateFromPlugin.Name,
E2EId = menuTemplateFromPlugin.E2EId,
DefaultLink = menuTemplateFromPlugin.DefaultLink,
EformPluginId = eformPlugin.Id,
};
_dbContext.MenuTemplates.Add(menuTemplateToDatabase);
_dbContext.SaveChanges();
foreach (var translation in menuTemplateFromPlugin.Translations)
{
var menuTemplateTranslation = new MenuTemplateTranslation
{
Language = translation.Language,
LocaleName = translation.LocaleName,
Name = translation.Name,
MenuTemplateId = menuTemplateToDatabase.Id,
};
_dbContext.MenuTemplateTranslations.Add(menuTemplateTranslation);
_dbContext.SaveChanges();
}
if (menuTemplateFromPlugin.Permissions.Any())
{
foreach (var itemPermission in menuTemplateFromPlugin.Permissions)
{
PermissionType newPermissionType = null;
var permissionType = _dbContext.PermissionTypes.FirstOrDefault(x => x.Name == itemPermission.PermissionTypeName);
if (permissionType == null)
{
newPermissionType = new PermissionType
{
Name = itemPermission.PermissionTypeName,
};
_dbContext.PermissionTypes.Add(newPermissionType);
_dbContext.SaveChanges();
}
var permission = new Permission
{
PermissionName = itemPermission.PermissionName,
ClaimName = itemPermission.ClaimName,
PermissionTypeId = newPermissionType == null
? permissionType.Id
: newPermissionType.Id
};
_dbContext.Permissions.Add(permission);
_dbContext.SaveChanges();
var menuTemplatePermission = new MenuTemplatePermission
{
MenuTemplateId = menuTemplateToDatabase.Id,
PermissionId = permission.Id,
};
_dbContext.MenuTemplatePermissions.Add(menuTemplatePermission);
_dbContext.SaveChanges();
}
}
}
}
}
}
else
{
// Load to database all navigation menu from plugin by id
var pluginMenuItemsLoader = new PluginMenuItemsLoader(_dbContext, pluginId);
pluginMenuItemsLoader.Load(pluginMenu);
}
return(new OperationResult(true));
}
/// <summary>
/// 绑定Gridview
/// </summary>
private void BindGridView()
{
using (db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString))
{
BoundField bfColumn;
foreach (var kvp in Titlelist)
{
bfColumn = new BoundField();
bfColumn.HeaderText = kvp.Split(':')[0];
bfColumn.DataField = kvp.Split(':')[1];
this.gv.Columns.Add(bfColumn);
}
//添加选择列
TemplateField tfieldCheckbox = new TemplateField();
tfieldCheckbox.ItemTemplate = new CheckBoxTemplate("请选择", DataControlRowType.DataRow, "StorageInID");
tfieldCheckbox.HeaderTemplate = new CheckBoxTemplate("请选择", DataControlRowType.Header);
this.gv.Columns.Insert(0, tfieldCheckbox);
SPMenuField colMenu = new SPMenuField();
colMenu.HeaderText = "交货通知单编号";
colMenu.TextFields = "StorageInCode";
colMenu.MenuTemplateId = "actionMenu";
colMenu.NavigateUrlFields = "StorageInID"; //定义方式:"列名1,列名2..."
colMenu.NavigateUrlFormat = "StorageDetailedManage.aspx?StorageInID={0}";
colMenu.TokenNameAndValueFields = "curStorageID=StorageInID"; //定义方式:"别名1=列名1,别名2=列名2...."
MenuTemplate menuItemCollection = new MenuTemplate();
menuItemCollection.ID = "actionMenu";
MenuItemTemplate createMenuItem = new MenuItemTemplate("送往物资组", "/_layouts/images/newitem.gif");
createMenuItem.ClientOnClickNavigateUrl = "QualityControlMessage.aspx?StorageInID=%curStorageID%&&state=物资组员&&storageInType=委外入库";
//editMenuItem.ClientOnClickScript = "if(!window.confirm('确认删除所选项?')) return false;window.location.href='StorageEdit.aspx?StorageID=%curStorageID%'";//%curStorageID%代表别名curStorageID，而StorageID代表数据库的表中的列名
//editMenuItem.ClientOnClickScript = "window.location.href='StorageEdit.aspx?StorageID=%curStorageID%&curTime=" + DateTime.Now.ToString() + "'";
menuItemCollection.Controls.Add(createMenuItem);
this.Controls.Add(menuItemCollection);
this.gv.Columns.Insert(1, colMenu);
//this.gv.Columns.Add(hlTask);
HyperLinkField hlTask = new HyperLinkField();
hlTask.HeaderText = "任务详情";
this.gv.Columns.Insert(5, hlTask);
//hlTask.DataNavigateUrlFields={}
// hlTask.DataNavigateUrlFormatString = "javaScript:onClick=window.showModalDialog('../PublicPage/ErrorInfo.aspx?StorageInID={0}')";
this.gv.DataSource = from a in db.CommitInMain
where a.Creator == UserLoginId
select new
{
a.StorageInID,
a.StorageInCode,
a.ReceivingType,
a.Remark,
a.CreateTime
};
this.gv.RowDataBound += new GridViewRowEventHandler(gv_RowDataBound);
this.gv.DataBind();
this.gv.Columns[6].Visible = false;
Panel p1 = (Panel)GetControltByMaster("Panel1");
p1.Controls.Add(this.gv);
}
}
/// <summary>
/// <see cref="Menu"/>정보를 조회하기 위한 Criteria를 빌드합니다.
/// </summary>
public DetachedCriteria BuildCriteriaOfMenu(Product product, string code, MenuTemplate menuTemplate, bool? isActive)
{
return BuildQueryOverOfMenu(product, code, menuTemplate, isActive).DetachedCriteria;
}
/// <summary>
/// Create all your controls here for rendering.
/// Try to avoid using the RenderWebPart() method.
/// </summary>
protected override void CreateChildControls()
{
if (!_error)
{
try
{
//Getting the Public URL to handle http & https url issues
string _publicURL = GetPublicUrl();
_publicURL = "";
base.CreateChildControls();
gvTaskList = new SPGridView();
gvTaskList.Width = Unit.Percentage(100);
gvTaskList.AutoGenerateColumns = false;
gvTaskList.BorderStyle = BorderStyle.Dotted;
//Adding Title Field
SPMenuField nameMenu = new SPMenuField();
nameMenu.HeaderText = "Title";
nameMenu.TextFields = "Title";
nameMenu.MenuTemplateId = "TaskListMenu";
nameMenu.NavigateUrlFields = "Task Ref";
nameMenu.TokenNameAndValueFields = "Task Ref=Task Ref";
//nameMenu.NavigateUrlFormat = _publicURL + "/{0}";
nameMenu.SortExpression = "Due Date";
//Adding Due Date Field
BoundField dueDate = new BoundField();
dueDate.DataField = "Due Date";
dueDate.HeaderText = "Due Date";
dueDate.SortExpression = "Due Date";
//Adding Due Date Field
BoundField documentAuthor = new BoundField();
documentAuthor.DataField = "Document Author";
documentAuthor.HeaderText = "Document Author";
documentAuthor.SortExpression = "Document Author";
//Adding DropDown Menu for 'Evidence Log'
TaskListMenu = new MenuTemplate();
TaskListMenu.ID = "TaskListMenu";
MenuItemTemplate evidenceLogMenu = new MenuItemTemplate("Open", "/_layouts/images/actionseditpage.gif");
evidenceLogMenu.ClientOnClickNavigateUrl = "%Task Ref%";
//Adding Controls to Control Collection
TaskListMenu.Controls.Add(evidenceLogMenu);
this.Controls.Add(TaskListMenu);
gvTaskList.Columns.Add(nameMenu);
gvTaskList.Columns.Add(dueDate);
gvTaskList.Columns.Add(documentAuthor);
this.Controls.Add(gvTaskList);
gvTaskList.PagerTemplate = null;
}
catch (Exception ex)
{
HandleException(ex);
}
}
}
/// <summary>
/// 새로운 메뉴를 생성합니다.
/// </summary>
public Menu CreateMenu(MenuTemplate menuTemplate, string code)
{
menuTemplate.ShouldNotBeNull("menuTemplate");
code.ShouldNotBeWhiteSpace("code");
if(IsDebugEnabled)
log.Debug(@"새로운 Menu 정보를 생성합니다. code={0}, menuTemplate={1}", code, menuTemplate);
var menu = new Menu(menuTemplate, code);
return Repository<Menu>.SaveOrUpdate(menu);
}
protected void InsertNavigationSettings()
{
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append("var navigationSettings = {");
string menuList = String.Empty;
string menuTemplateList = String.Empty;
MembershipUser mu = Membership.GetUser();
if (mu != null && mu.ProviderUserKey != null)
{
SqlConnection connection = new SqlConnection(Config.ConnectionString);
try
{
connection.Open();
SqlTransaction trans = null;
try
{
trans = connection.BeginTransaction();
DataTable dt = AccessUser.RoleAndObjectsByUserList(trans, (Guid)mu.ProviderUserKey, Department.ObjectTypeID).Table;
if (dt != null)
{
foreach (DataRow row in dt.Rows)
{
Guid objectID = (Guid)row["ObjectID"];
Department department = new Department(objectID, mu.UserName);
menuList += "{";
menuList += String.Format(" id:{0}, name: \"{1}\" ", department.ID, department.ShortName);
menuList += "},";
}
}
DataTable mt = AccessUser.RoleAndObjectsByUserList(trans, (Guid)mu.ProviderUserKey, MenuTemplate.ObjectTypeID).Table;
if (mt != null)
{
foreach (DataRow row in mt.Rows)
{
Guid objectID = (Guid)row["ObjectID"];
MenuTemplate menuTemp = new MenuTemplate(objectID, mu.UserName);
menuTemplateList += "{";
menuTemplateList += String.Format(" id:{0}, name: \"{1}\", systemName: \"{2}\" ", menuTemp.ID, menuTemp.Name, menuTemp.SystemName);
menuTemplateList += "},";
}
}
/*
* List<Department> dl = Department.GetList(mu.UserName);
* foreach (Department department in dl)
* {
* if (Permission.IsUserPermission(trans, (Guid) mu.ProviderUserKey, department.ObjectID, (int)Department.ActionType.View))
* {
* menuList += "{";
* menuList += String.Format(" id:{0}, name: \"{1}\" ", department.ID, department.ShortName);
* menuList += "},";
* }
* }
*/
trans.Commit();
}
catch (Exception)
{
if (trans != null)
{
trans.Rollback();
}
throw;
}
}
finally
{
connection.Close();
}
}
char[] charsToTrim = { ',' };
stringBuilder.Append(String.Format("menuList: [{0}],", menuList.TrimEnd(charsToTrim)));
stringBuilder.Append(String.Format("templateList: [{0}]", menuTemplateList.TrimEnd(charsToTrim)));
stringBuilder.Append("}");
HtmlGenericControl scriptControl = new HtmlGenericControl("script");
scriptControl.Attributes["type"] = "text/javascript";
scriptControl.InnerHtml = stringBuilder.ToString();
Page.Header.Controls.AddAt(1, scriptControl);
}
/// <summary>
/// 메뉴코드로 메뉴를 조회합니다.
/// </summary>
public Menu FindOneMenuByTemplateAndCode(MenuTemplate menuTemplate, string code)
{
menuTemplate.ShouldNotBeNull("menuTemplate");
code.ShouldNotBeWhiteSpace("code");
return Repository<Menu>.FindOne(BuildQueryOverOfMenu(null, code, menuTemplate, null));
}
/// <summary>
/// 지정된 MenuTemplate와 관계된 Menu 들을 조회합니다.
/// </summary>
/// <param name="menuTemplate"></param>
/// <returns></returns>
public IList<Menu> FindAllMenuByMenuTemplate(MenuTemplate menuTemplate)
{
menuTemplate.ShouldNotBeNull("menuTemplate");
if(IsDebugEnabled)
log.Debug(@"지정한 메뉴 템플릿D의 모든 Menu 정보를 조회합니다... " + menuTemplate);
return Repository<Menu>.FindAll(BuildQueryOverOfMenu(null, null, menuTemplate, null));
}
/// <summary>
/// 지정한 메뉴 템플릿 정보를 삭제합니다. HBM의 cascade 설정에 따라 cascade-delete가 수행될 수 있습니다.
/// </summary>
public void DeleteMenuTemplate(MenuTemplate menuTemplate)
{
menuTemplate.ShouldNotBeNull("menuTemplate");
if(IsDebugEnabled)
log.Debug(@"지정한 MenuTemplate를 삭제합니다... " + menuTemplate);
DeleteEntityTransactional(menuTemplate);
}
/// <summary>
/// 지정된 MenuTemplate과 관련된 모든 메뉴를 삭제합니다.
/// </summary>
/// <param name="menuTemplate"></param>
public void DeleteAllMenuByMenuTemplate(MenuTemplate menuTemplate)
{
menuTemplate.ShouldNotBeNull("menuTemplate");
if(IsDebugEnabled)
log.Debug(@"지정된 MenuTemplate과 관련된 모든 메뉴를 삭제합니다... " + menuTemplate);
Repository<Menu>.DeleteAll(BuildQueryOverOfMenu(null, null, menuTemplate, null));
}
protected void Page_Load(object sender, EventArgs e)
{
//==================================Integration Menu=================================
MenuTemplate propertyNameListMenu = new MenuTemplate();
propertyNameListMenu.ID = "IntegrationMenu";
MenuItemTemplate testMenu = new MenuItemTemplate("Edit Connection", "/_layouts/epmlive/images/integration/editcon.png");
testMenu.ClientOnClickNavigateUrl = "connection.aspx?intlistid=%INTLISTID%&LIST=%LISTID%&ret=Manage";
propertyNameListMenu.Controls.Add(testMenu);
MenuItemTemplate testMenu2 = new MenuItemTemplate("Edit Properties", "/_layouts/images/edit.gif");
testMenu2.ClientOnClickNavigateUrl = "properties.aspx?intlistid=%INTLISTID%&LIST=%LISTID%&ret=Manage";
propertyNameListMenu.Controls.Add(testMenu2);
MenuItemTemplate testMenu3 = new MenuItemTemplate("Edit Columns", "/_layouts/epmlive/images/integration/editcols.png");
testMenu3.ClientOnClickNavigateUrl = "columns.aspx?intlistid=%INTLISTID%&LIST=%LISTID%&ret=Manage";
propertyNameListMenu.Controls.Add(testMenu3);
MenuItemTemplate testMenu4 = new MenuItemTemplate("View Log", "/_layouts/epmlive/images/integration/log.png");
testMenu4.ClientOnClickNavigateUrl = "log.aspx?intlistid=%INTLISTID%&LIST=%LISTID%&ret=Manage";
propertyNameListMenu.Controls.Add(testMenu4);
MenuItemTemplate testMenu5 = new MenuItemTemplate("Delete Integration", "/_layouts/images/delete.gif");
testMenu5.ClientOnClickScript = "DeleteIntegration('%INTLISTID%');";
propertyNameListMenu.Controls.Add(testMenu5);
this.Controls.Add(propertyNameListMenu);
//===================================================================================
MenuTemplate propertyNameListMenu2 = new MenuTemplate();
propertyNameListMenu2.ID = "IntegrationGroupMenu";
MenuItemTemplate testMenu6 = new MenuItemTemplate("Add Integration", "/_layouts/images/add.gif");
testMenu6.ClientOnClickNavigateUrl = "Add.aspx?LIST=%LISTID%&ret=Manage";
propertyNameListMenu2.Controls.Add(testMenu6);
MenuItemTemplate testMenu7 = new MenuItemTemplate("Edit Fields", "/_layouts/images/edit.gif");
testMenu7.ClientOnClickScript = "EditFields('%LISTID%')";
propertyNameListMenu2.Controls.Add(testMenu7);
this.Controls.Add(propertyNameListMenu2);
//===================================================================================
SPMenuField colMenu = new SPMenuField();
colMenu.HeaderText = "";
colMenu.TextFields = "ListName"; // GroupName field, bind to a List column
colMenu.MenuTemplateId = "IntegrationGroupMenu";
colMenu.TokenNameAndValueFields = "LISTID=LIST_ID";
colMenu.SortExpression = "ListName";
colMenu.MenuFormat = MenuFormat.ArrowAlwaysVisible;
gvIntegrations.GroupMenu = colMenu;
SPSecurity.RunWithElevatedPrivileges(delegate()
{
var dataSet = new DataSet();
using (var connection = new SqlConnection(CoreFunctions.getConnectionString(Web.Site.WebApplication.Id)))
{
connection.Open();
using (var sqlCommand = new SqlCommand(
@"SELECT dbo.INT_MODULES.Title, dbo.INT_MODULES.Description, dbo.INT_MODULES.Icon, dbo.INT_LISTS.INT_LIST_ID, dbo.INT_LISTS.LIST_ID, dbo.INT_LISTS.ACTIVE
FROM dbo.INT_MODULES INNER JOIN
dbo.INT_LISTS ON dbo.INT_MODULES.MODULE_ID = dbo.INT_LISTS.MODULE_ID where SITE_ID=@siteid",
connection))
{
sqlCommand.Parameters.AddWithValue("@siteid", Web.Site.ID);
using (var sqlDataAdapter = new SqlDataAdapter(sqlCommand))
{
sqlDataAdapter.Fill(dataSet);
}
}
}
DataTable dt = dataSet.Tables[0];
dt.Columns.Add("ListName");
Hashtable hshLists = new Hashtable();
ArrayList arrExists = new ArrayList();
ArrayList arrIgnore = new ArrayList();
foreach (SPList list in Web.Lists)
{
if (!list.Hidden)
{
hshLists.Add(list.ID, list.Title);
}
if (bIsSystemList(list.Title) || list.BaseType == SPBaseType.DocumentLibrary)
{
arrIgnore.Add(list.ID);
}
}
foreach (DataRow dr in dt.Rows)
{
try
{
Guid ListId = new Guid(dr["LIST_ID"].ToString());
if (hshLists.Contains(ListId))
{
dr["ListName"] = hshLists[ListId].ToString();
arrExists.Add(ListId);
}
}
catch { }
}
foreach (DictionaryEntry de in hshLists)
{
if (!arrExists.Contains(de.Key) && !arrIgnore.Contains(de.Key))
{
DataRow dr = dt.NewRow();
dr["List_Id"] = de.Key;
dr["ListName"] = de.Value;
dr["Title"] = "No Integrations";
dt.Rows.Add(dr);
}
}
gvIntegrations.DataSource = dataSet;
gvIntegrations.DataBind();
});
}
/// <summary>
/// 새로운 메뉴 템플릿을 생성합니다.
/// </summary>
/// <returns></returns>
public MenuTemplate CreateMenuTemplate(Product product, string code, string name, string menuUrl)
{
product.ShouldNotBeNull("product");
code.ShouldNotBeWhiteSpace("code");
if(IsDebugEnabled)
log.Debug(@"새로운 MenuTemplate를 생성합니다. product={0}, code={1}, name={2}, menuUrl={3}", product, code, name, menuUrl);
var menuTemplate = new MenuTemplate(product, code)
{
Name = name ?? code,
MenuUrl = menuUrl
};
menuTemplate.SetParent(null);
menuTemplate.UpdateNodePosition();
return Repository<MenuTemplate>.SaveOrUpdate(menuTemplate);
}
private void updateMenu()
{
//Debug.Log (menuAction.menuName + ": " + menuAction.menuCommand);
if (menuAction.menuCommand == "Back") {
activeMenu = mainMenu;
return;
}
if (menuAction.menuName == "main") {
switch (menuAction.menuCommand) {
case "Start Game":
activeMenu = startGameMenu;
break;
case "Sandbox":
GameSettings.sandboxEnabled = true;
GameSettings.setLevelPath ("sandbox");
Application.LoadLevel ("Game World");
break;
case "Credits":
activeMenu = creditsMenu;
break;
case "Exit":
Application.Quit ();
break;
}
} else if (menuAction.menuName == "levels") {
string levelName=(string)levelNameDic[menuAction.menuCommand];
GameSettings.setLevelPath (levelName);
GameSettings.sandboxEnabled = false;
Application.LoadLevel ("Game World");
}
}
/// <summary>
/// 지정된 부모 메뉴의 자식 메뉴를 생성합니다.
/// </summary>
/// <param name="parent">부모 메뉴</param>
/// <param name="code">새로운 메뉴의 Id</param>
/// <param name="menuTemplate">새로운 메뉴의 메뉴 템플릿 정보</param>
/// <returns></returns>
public Menu CreateMenuOf(Menu parent, string code, MenuTemplate menuTemplate)
{
if(parent == null)
return CreateMenu(menuTemplate, code);
code.ShouldNotBeWhiteSpace("code");
Guard.Assert(parent.MenuTemplate.Product == menuTemplate.Product,
@"부모 메뉴의 Product 정보와 새로 만들 MenuTemplate의 Product정보가 틀립니다.");
if(IsDebugEnabled)
log.Debug(@"새로운 Menu 정보를 생성합니다... parent={0}, code={1}, menuTemplate={2}",
parent, code, menuTemplate);
var menu = new Menu(menuTemplate, code);
menu.SetParent(parent);
menu.UpdateNodePosition();
return Repository<Menu>.SaveOrUpdate(menu);
}
/// <summary>
/// 지정된 메뉴 템플릿을 새로운 부모의 자식으로 등록합니다.
/// </summary>
/// <param name="child"></param>
/// <param name="newParent"></param>
public void ChangeMenuTemplateParent(MenuTemplate child, MenuTemplate newParent)
{
child.ShouldNotBeNull("child");
var oldParent = child.Parent;
if(Equals(oldParent, newParent))
{
if(IsDebugEnabled)
log.Debug(@"변경할 부모가 현재 부모와 같습니다. 부모 변경 작업을 수행하지 않습니다!!!");
return;
}
if(IsDebugEnabled)
log.Debug(@"MenuTemplate의 부모 정보를 변경합니다... child code={0}, new parent code={1}, old parent code={2}",
child.Code,
(newParent != null) ? newParent.Code : EntityTool.NULL_STRING,
(oldParent != null) ? oldParent.Code : EntityTool.NULL_STRING);
child.ChangeParent(oldParent, newParent);
Repository<MenuTemplate>.SaveOrUpdate(child);
}
private MenuTemplate getPauseMenu()
{
MenuTemplate menu = new MenuTemplate ("pause");
menu.setTitle ();
menu.addButton ("Resume");
menu.addButton ("Main Menu");
menu.addButton ("Exit");
return menu;
}
/// <summary>
/// 메뉴를 조회합니다. 없으면 새로 생성합니다.
/// </summary>
public Menu GetOrCreateMenu(MenuTemplate menuTemplate, string code)
{
var menu = FindOneMenuByTemplateAndCode(menuTemplate, code);
if(menu != null)
return menu;
lock(_syncLock)
new Menu(menuTemplate, code).InsertStateless();
menu = FindOneMenuByTemplateAndCode(menuTemplate, code);
menu.AssertExists("menu");
return menu;
}
/// <summary>
/// 지정된 부모 메뉴 템플릿의 하위로 자식 메뉴 템플릿을 생성합니다.
/// </summary>
/// <param name="parent"></param>
/// <param name="code"></param>
/// <param name="name"></param>
/// <param name="menuUrl"></param>
/// <returns></returns>
public MenuTemplate CreateMenuTemplateOf(MenuTemplate parent, string code, string name, string menuUrl)
{
parent.ShouldNotBeNull("parent");
var menuTemplate = CreateMenuTemplate(parent.Product, code, name, menuUrl);
menuTemplate.SetParent(parent);
return Repository<MenuTemplate>.SaveOrUpdate(menuTemplate);
}
/// <summary>
/// Add columns from configuration to Grid
/// </summary>
private void AddColumns()
{
foreach (DataField dataField in Config.Columns)
{
// Generate menus
if (dataField.ContextMenu.Count > 0)
{
SPMenuField menu = new SPMenuField();
menu.HeaderText = dataField.Header;
menu.TextFields = dataField.Name;
menu.SortExpression = dataField.Name;
menu.MenuTemplateId = "MT" + ID + dataField.Name;
if (string.IsNullOrEmpty(dataField.ContextMenu.Fields))
{
menu.NavigateUrlFields = dataField.ContextMenu.Fields;
}
// TODO: Change
if (!string.IsNullOrEmpty(dataField.ContextMenu.Format))
{
//menu.NavigateUrlFormat = dataField.ContextMenu.Format;
menu.TokenNameAndValueFields = dataField.ContextMenu.Format;
}
// Menu Template linked
_menuTemplate = new MenuTemplate();
_menuTemplate.ID = "MT" + ID + dataField.Name;
foreach (ContextMenuItem menuItem in dataField.ContextMenu)
{
MenuItemTemplate optionMenu = new MenuItemTemplate(menuItem.Name, menuItem.Image);
if (menuItem.Url.Contains("Row"))
{
Debug.WriteLine(string.Format("Menu {0} - {1} - {2}", Title, dataField.Name, menuItem.Name));
//TODO: Check the send item (see Test1) Send value is the column name
//not the field value
// Page become null when we are connecting webparts
if (Page != null)
{
// Generate the script
string script = Page.ClientScript.GetPostBackEventReference(this, "_");
// Add the special SPSGetRowId call
optionMenu.ClientOnClickScript =
script.Replace("'_'", "'Row$'+SPSGetRowId('%MENUCLIENTID%')");
}
}
else
{
// Other url
optionMenu.ClientOnClickNavigateUrl = menuItem.Url;
}
_menuTemplate.Controls.Add(optionMenu);
}
Controls.Add(_menuTemplate);
_gridView.Columns.Add(menu);
}
else
{
// Normal Bound field
BoundField boundField = new BoundField();
boundField.DataField = dataField.Name;
boundField.HeaderText = dataField.Header;
if (string.IsNullOrEmpty(dataField.SortExpression))
{
boundField.SortExpression = dataField.Name;
}
else
{
boundField.SortExpression = dataField.SortExpression;
}
if (dataField.IsHtml)
{
boundField.HtmlEncode = false;
}
if (!string.IsNullOrEmpty(dataField.Format))
{
boundField.DataFormatString = dataField.Format;
boundField.HtmlEncode = false;
}
if (dataField.Select)
{
boundField.DataFormatString = string.Format("<a href=\"#\" onclick=\"{0}\">", SelectRowScript());
boundField.DataFormatString += "{0}</a>";
boundField.HtmlEncode = false;
}
_gridView.Columns.Add(boundField);
}
}
}
private void InitializeCustomControls()
{
InitToolBar();
this.spgvCommitNotice = new SPGridView();
this.spgvCommitNotice.AutoGenerateColumns = false;
this.spgvCommitNotice.Attributes.Add("style", "word-break:keep-all;word-wrap:normal");
string[] ShowTlist =
{
"领料单位:BusinessUnitName",
"创建时间:CreateTime",
"备注:Remark",
"ID:StorageCommitOutNoticeID"
};
BoundField bfColumn;
foreach (var kvp in ShowTlist)
{
bfColumn = new BoundField();
bfColumn.HeaderText = kvp.Split(':')[0];
bfColumn.DataField = kvp.Split(':')[1];
this.spgvCommitNotice.Columns.Add(bfColumn);
}
//添加选择列
TemplateField tfieldCheckbox = new TemplateField();
tfieldCheckbox.ItemTemplate = new CheckBoxTemplate("请选择", DataControlRowType.DataRow, "StorageCommitOutNoticeID");
tfieldCheckbox.HeaderTemplate = new CheckBoxTemplate("请选择", DataControlRowType.Header);
this.spgvCommitNotice.Columns.Insert(0, tfieldCheckbox);
//添加任务详情列
HyperLinkField hlfTask = new HyperLinkField();
hlfTask.HeaderText = "任务详情";
this.spgvCommitNotice.Columns.Insert(5, hlfTask);
SPMenuField colMenu = new SPMenuField();
colMenu.HeaderText = "调拨通知单编号";
colMenu.TextFields = "StorageCommitOutNoticeCode";
colMenu.MenuTemplateId = "spmfNoticeCode";
colMenu.NavigateUrlFields = "StorageCommitOutNoticeID"; //定义方式:"列名1,列名2..."
colMenu.NavigateUrlFormat = "ManageCommitOutDetails.aspx?NoticeID={0}";
colMenu.TokenNameAndValueFields = "curNoticeID=StorageCommitOutNoticeID"; //定义方式:"别名1=列名1,别名2=列名2...."
MenuTemplate menuItemCollection = new MenuTemplate();
menuItemCollection.ID = "spmfNoticeCode";
MenuItemTemplate createMenuItem = new MenuItemTemplate("生产组长审核", "/_layouts/images/newitem.gif");
createMenuItem.ClientOnClickNavigateUrl = "../PublicPage/AuditDispatchCenter.aspx?Process=委外出库&NoticeID=%curNoticeID%";
menuItemCollection.Controls.Add(createMenuItem);
this.Controls.Add(menuItemCollection);
this.spgvCommitNotice.Columns.Insert(1, colMenu);
this.spgvCommitNotice.RowDataBound += new GridViewRowEventHandler(spgvCommitNotice_RowDataBound);
}
public SimpleMenu(int top, int left, MenuTemplate template)
: this(top, left, template, MAXIMUM_MENU_ITEMS)
{
}
public override void Load(PluginMenuItemModel MenuItem, string pluginId, int?parentId)
{
var menuTemplate = new MenuTemplate()
{
Name = MenuItem.MenuTemplate.Name,
E2EId = MenuItem.MenuTemplate.E2EId,
DefaultLink = MenuItem.MenuTemplate.DefaultLink,
EformPluginId = _dbContext.EformPlugins.Single(x => x.PluginId == pluginId).Id
};
_dbContext.MenuTemplates.Add(menuTemplate);
_dbContext.SaveChanges();
foreach (var translation in MenuItem.MenuTemplate.Translations)
{
var menuTemplateTranslation = new MenuTemplateTranslation
{
Language = translation.Language,
LocaleName = translation.LocaleName,
Name = translation.Name,
MenuTemplateId = menuTemplate.Id,
};
_dbContext.MenuTemplateTranslations.Add(menuTemplateTranslation);
_dbContext.SaveChanges();
}
if (MenuItem.MenuTemplate.Permissions.Any())
{
foreach (var itemPermission in MenuItem.MenuTemplate.Permissions)
{
PermissionType newPermissionType = null;
var permissionType = _dbContext.PermissionTypes.FirstOrDefault(x => x.Name == itemPermission.PermissionTypeName);
if (permissionType == null)
{
newPermissionType = new PermissionType
{
Name = itemPermission.PermissionTypeName,
};
_dbContext.PermissionTypes.Add(newPermissionType);
_dbContext.SaveChanges();
}
var permission = new Permission
{
PermissionName = itemPermission.PermissionName,
ClaimName = itemPermission.ClaimName,
PermissionTypeId = newPermissionType == null
? permissionType.Id
: newPermissionType.Id
};
_dbContext.Permissions.Add(permission);
_dbContext.SaveChanges();
var menuTemplatePermission = new MenuTemplatePermission
{
MenuTemplateId = menuTemplate.Id,
PermissionId = permission.Id,
};
_dbContext.MenuTemplatePermissions.Add(menuTemplatePermission);
_dbContext.SaveChanges();
}
}
var newMenuItem = new MenuItem()
{
E2EId = MenuItem.E2EId,
Name = MenuItem.Name,
Link = MenuItem.Link,
Type = MenuItem.Type,
Position = parentId != null
? MenuItem.Position
: _dbContext.MenuItems.Where(x => x.ParentId == null).Max(x => x.Position) + MenuItem.Position + 1,
MenuTemplateId = menuTemplate.Id,
ParentId = parentId,
};
_dbContext.MenuItems.Add(newMenuItem);
_dbContext.SaveChanges();
foreach (var menuItemTranslation in MenuItem.Translations)
{
var translation = new MenuItemTranslation
{
Language = menuItemTranslation.Language,
LocaleName = menuItemTranslation.LocaleName,
Name = menuItemTranslation.Name,
MenuItemId = newMenuItem.Id,
};
_dbContext.MenuItemTranslations.Add(translation);
_dbContext.SaveChanges();
}
}
void Start()
{
//player = GameObject.FindGameObjectWithTag ("Player");
worldManager = (WorldManager)FindObjectOfType (typeof(WorldManager));
player = worldManager.getPlayer ();
escIsEnabled = true;
setResume ();
pauseMenu = getPauseMenu ();
sandboxMenu = getSandboxMenu ();
endLevelMenu = getEndLevelMenu ();
gameHUD = getGameHUD ();
}
/// <summary>
/// 绑定Gridview
/// </summary>
private void BindGridView()
{
using (db = new MMSProDBDataContext(ConfigurationManager.ConnectionStrings["mmsConString"].ConnectionString))
{
BoundField bfColumn;
foreach (var kvp in Titlelist)
{
bfColumn = new BoundField();
bfColumn.HeaderText = kvp.Split(':')[0];
bfColumn.DataField = kvp.Split(':')[1];
this.gv.Columns.Add(bfColumn);
}
//添加选择列
TemplateField tfieldCheckbox = new TemplateField();
tfieldCheckbox.ItemTemplate = new CheckBoxTemplate("请选择", DataControlRowType.DataRow, "CommitInID");
tfieldCheckbox.HeaderTemplate = new CheckBoxTemplate("请选择", DataControlRowType.Header);
this.gv.Columns.Insert(0, tfieldCheckbox);
SPMenuField colMenu = new SPMenuField();
colMenu.HeaderText = "交货通知单编号";
colMenu.TextFields = "CommitInCode";
colMenu.MenuTemplateId = "actionMenu";
HyperLinkField hlTask = new HyperLinkField();
hlTask.HeaderText = "任务详情";
colMenu.NavigateUrlFields = "CommitInID"; //定义方式:"列名1,列名2..."
colMenu.NavigateUrlFormat = "CommitInDetailedManage.aspx?CommitInID={0}";
colMenu.TokenNameAndValueFields = "curCommitID=CommitInID"; //定义方式:"别名1=列名1,别名2=列名2...."
MenuTemplate menuItemCollection = new MenuTemplate();
menuItemCollection.ID = "actionMenu";
MenuItemTemplate createMenuItem = new MenuItemTemplate("送往质检", "/_layouts/images/newitem.gif");
createMenuItem.ClientOnClickNavigateUrl = "../PublicPage/AuditDispatchCenter.aspx?Process=委外入库&CommitInID=%curCommitID%";
menuItemCollection.Controls.Add(createMenuItem);
this.Controls.Add(menuItemCollection);
this.gv.Columns.Insert(1, colMenu);
this.gv.Columns.Insert(4, hlTask);
this.gv.DataSource = from a in db.CommitIn
select new
{
a.CommitInID,
a.CommitInCode,
a.Remark,
a.CreateTime
};
this.gv.RowDataBound += new GridViewRowEventHandler(gv_RowDataBound);
this.gv.DataBind();
this.gv.Columns[5].Visible = false;
Panel p1 = (Panel)GetControltByMaster("Panel1");
p1.Controls.Add(this.gv);
}
}
protected void Page_Load(object sender, EventArgs e)
{
MenuTemplate propertyNameListMenu = new MenuTemplate();
propertyNameListMenu.ID = "PropertyNameListMenu";
MenuItemTemplate testMenu = new MenuItemTemplate("Edit Report", "/_layouts/epmlive/images/integration/editcon.png");
testMenu.ClientOnClickNavigateUrl = "edit.aspx?name=%NAME%";
propertyNameListMenu.Controls.Add(testMenu);
this.Controls.Add(propertyNameListMenu);
SPSecurity.RunWithElevatedPrivileges(delegate
{
using (var connection = new SqlConnection(CoreFunctions.getConnectionString(Web.Site.WebApplication.Id)))
{
connection.Open();
using (var command = new SqlCommand("SELECT * FROM IzendaAdHocReports where TenantID=@siteid order by Name", connection))
{
command.Parameters.AddWithValue("@siteid", Convert.ToString(Web.ID));
using (var dataSet = new DataSet())
{
using (var dataReader = new SqlDataAdapter(command))
{
dataReader.Fill(dataSet);
dataSet.Tables[0].Columns.Add(CategoryColumn);
dataSet.Tables[0].Columns.Add(ShortNameColumn);
foreach (DataRow dataRow in dataSet.Tables[0].Rows)
{
if (dataRow[NameColumn].ToString().Contains("\\"))
{
var names = dataRow[NameColumn].ToString().Split('\\');
dataRow[ShortNameColumn] = names[1];
dataRow[CategoryColumn] = names[0];
}
else
{
dataRow[ShortNameColumn] = dataRow[NameColumn];
dataRow[CategoryColumn] = "Uncategorized";
}
dataRow[NameColumn] = HttpUtility.UrlEncode(dataRow[NameColumn].ToString());
}
var dataTable = dataSet.Tables[0]
.AsEnumerable()
.GroupBy(x => x[CategoryColumn])
.SelectMany(g => g.OrderBy(v => v[ShortNameColumn]))
.CopyToDataTable();
gvReports.DataSource = dataTable;
gvReports.DataBind();
}
}
}
}
});
}
protected void Page_Load(object sender, EventArgs e)
{
MenuTemplate propertyNameListMenu = new MenuTemplate();
propertyNameListMenu.ID = "PropertyNameListMenu";
MenuItemTemplate testMenu = new MenuItemTemplate("Edit Lookup", "/_layouts/images/edit.gif");
testMenu.ClientOnClickNavigateUrl = "ListLookupEdit.aspx?field=%NAME%&List=" + Request["List"];
propertyNameListMenu.Controls.Add(testMenu);
//MenuItemTemplate testMenu2 = new MenuItemTemplate("Delete Planner", "/_layouts/images/delete.gif");
//testMenu2.ClientOnClickNavigateUrl = "ListLookupEdit.aspx?delete=%NAME%&List=" + Request["List"];
//propertyNameListMenu.Controls.Add(testMenu2);
this.Controls.Add(propertyNameListMenu);
DataTable dt = new DataTable();
dt.Columns.Add("displayname");
dt.Columns.Add("internalname");
dt.Columns.Add("enabled");
dt.Columns.Add("style");
dt.Columns.Add("cascading");
dt.Columns.Add("security");
SPList list = Web.Lists[new Guid(Request["List"])];
GridGanttSettings gSettings = new GridGanttSettings(list);
string[] LookupArray = gSettings.Lookups.Split('|');
Hashtable hshLookups = new Hashtable();
foreach (string sLookup in LookupArray)
{
if (sLookup != "")
{
string[] sLookupInfo = sLookup.Split('^');
hshLookups.Add(sLookupInfo[0], sLookupInfo);
}
}
foreach (SPField field in list.Fields)
{
if (field.Type == SPFieldType.Lookup && !field.Hidden && field.Reorderable)
{
SPFieldLookup lookup = (SPFieldLookup)field;
if (lookup.LookupList != "")
{
string display = field.Title;
string internalname = field.InternalName;
string enabled = "No";
string style = "";
string cascading = "";
string security = "";
if (hshLookups.Contains(field.InternalName))
{
string [] sLookupInfo = (string[])hshLookups[field.InternalName];
enabled = "Yes";
try
{
if (sLookupInfo[1] == "2")
{
style = "Auto Complete";
}
else
{
style = "Standard";
}
}
catch { style = "Standard"; }
try
{
if (sLookupInfo[2] != "")
{
cascading = "Yes";
}
else
{
cascading = "No";
}
}
catch { cascading = "No"; }
try
{
if (sLookupInfo[4].ToLower() == "true")
{
security = "Yes";
}
else
{
security = "No";
}
}
catch { security = "No"; }
}
dt.Rows.Add(new object[] { display, internalname, enabled, style, cascading, security });
}
}
}
gvPlans.DataSource = dt;
gvPlans.DataBind();
}
