/// <summary> /// Swap display sequence of Menu Item. /// </summary> /// <param name="sourceMenuSubCD"></param> /// <param name="sourceScreenCD"></param> /// <param name="destMenuSubCD"></param> /// <param name="destScreenCD"></param> public void SwapDisplaySequence(NZString sourceMenuSubCD, NZString sourceScreenCD, NZString destMenuSubCD, NZString destScreenCD) { Database db = CommonLib.Common.CurrentDatabase; MenuSubItemDAO daoMenuSubItem = new MenuSubItemDAO(CommonLib.Common.CurrentDatabase); try { db.KeepConnection = true; db.BeginTransaction(); MenuSubItemDTO fromMenuSubItem = daoMenuSubItem.LoadByPK(null, sourceMenuSubCD, sourceScreenCD); MenuSubItemDTO toMenuSubItem = daoMenuSubItem.LoadByPK(null, destMenuSubCD, destScreenCD); NZString UPD_BY = CommonLib.Common.CurrentUserInfomation.UserCD; NZString UPD_MACHINE = CommonLib.Common.CurrentUserInfomation.Machine; daoMenuSubItem.UpdateSequence(null, sourceMenuSubCD, sourceScreenCD, UPD_BY, UPD_MACHINE, toMenuSubItem.DISP_SEQ); daoMenuSubItem.UpdateSequence(null, destMenuSubCD, destScreenCD, UPD_BY, UPD_MACHINE, fromMenuSubItem.DISP_SEQ); db.Commit(); } catch { db.Rollback(); throw; } finally { if (db.DBConnectionState == ConnectionState.Open) { db.Close(); } } }
/// <summary> /// Update record by using the table's primary key. /// </summary> /// <param name="database"></param> /// <param name="data">Data which to update.</param> /// <param name="oldMENU_SUB_CD">Old Key #1</param> /// <param name="oldSCREEN_CD">Old Key #2</param> /// <returns></returns> public int UpdateWithPK(Database database, MenuSubItemDTO data, NZString oldMENU_SUB_CD, NZString oldSCREEN_CD) { Database db = UseDatabase(database); StringBuilder sb = new StringBuilder(); #region SQL Statement sb.AppendLine(" UPDATE " + data.TableName); sb.AppendLine(" SET "); sb.AppendLine(" " + MenuSubItemDTO.eColumns.MENU_SUB_CD + "=:MENU_SUB_CD"); sb.AppendLine(" ," + MenuSubItemDTO.eColumns.SCREEN_CD + "=:SCREEN_CD"); sb.AppendLine(" ," + MenuSubItemDTO.eColumns.DISP_SEQ + "=:DISP_SEQ"); sb.AppendLine(" ," + MenuSubItemDTO.eColumns.UPD_BY + "=:UPD_BY"); sb.AppendLine(" ," + MenuSubItemDTO.eColumns.UPD_DATE + "=SYSDATE"); sb.AppendLine(" ," + MenuSubItemDTO.eColumns.UPD_MACHINE + "=:UPD_MACHINE"); sb.AppendLine(" WHERE "); sb.AppendLine(" " + MenuSubItemDTO.eColumns.MENU_SUB_CD + "=:oldMENU_SUB_CD"); sb.AppendLine(" AND " + MenuSubItemDTO.eColumns.SCREEN_CD + "=:oldMenuSubItem"); #endregion DataRequest req = new DataRequest(sb.ToString()); #region Parameters req.Parameters.Add("MENU_SUB_CD", DataType.VarChar, data.MENU_SUB_CD.Value); req.Parameters.Add("SCREEN_CD", DataType.VarChar, data.SCREEN_CD.Value); req.Parameters.Add("DISP_SEQ", DataType.Number, data.DISP_SEQ.Value); req.Parameters.Add("UPD_BY", DataType.NVarChar, data.UPD_BY.Value); req.Parameters.Add("UPD_MACHINE", DataType.NVarChar, data.UPD_MACHINE.Value); req.Parameters.Add("oldMENU_SUB_CD", DataType.VarChar, oldMENU_SUB_CD.Value); req.Parameters.Add("oldSCREEN_CD", DataType.VarChar, oldSCREEN_CD.Value); #endregion return(db.ExecuteNonQuery(req)); }
private void menuTree1_MenuItemClick(object sender, MenuItem item) { MenuSubItemDTO menuItem = item.Tag as MenuSubItemDTO; if (menuItem != null) { OpenScreen(menuItem.SCREEN_CD.NVL(string.Empty)); } }
/// <summary> /// Check exist before manipulate data. If found record will update data. Otherwise insert new data. /// </summary> /// <param name="database"></param> /// <param name="data"></param> /// <returns></returns> public int AddNewOrUpdate(Database database, MenuSubItemDTO data) { Database db = UseDatabase(database); if (Exist(database, data.MENU_SUB_CD, data.SCREEN_CD)) { return(UpdateWithoutPK(db, data)); } return(AddNew(db, data)); }
/// <summary> /// Insert new record into database. /// </summary> /// <param name="database"></param> /// <param name="data"></param> /// <returns></returns> public int AddNew(Database database, MenuSubItemDTO data) { Database db = UseDatabase(database); StringBuilder sb = new StringBuilder(); #region SQL Statement sb.AppendLine(" INSERT INTO " + data.TableName + "("); sb.AppendLine(" " + MenuSubItemDTO.eColumns.MENU_SUB_CD); sb.AppendLine(" ," + MenuSubItemDTO.eColumns.SCREEN_CD); sb.AppendLine(" ," + MenuSubItemDTO.eColumns.DISP_SEQ); sb.AppendLine(" ," + MenuSubItemDTO.eColumns.CRT_BY); sb.AppendLine(" ," + MenuSubItemDTO.eColumns.CRT_DATE); sb.AppendLine(" ," + MenuSubItemDTO.eColumns.CRT_MACHINE); sb.AppendLine(" ," + MenuSubItemDTO.eColumns.UPD_BY); sb.AppendLine(" ," + MenuSubItemDTO.eColumns.UPD_DATE); sb.AppendLine(" ," + MenuSubItemDTO.eColumns.UPD_MACHINE); sb.AppendLine(") VALUES("); sb.AppendLine(" :MENU_SUB_CD"); sb.AppendLine(" ,:SCREEN_CD"); sb.AppendLine(" ,:DISP_SEQ"); sb.AppendLine(" ,:CRT_BY"); sb.AppendLine(" ,SYSDATE"); sb.AppendLine(" ,:CRT_MACHINE"); sb.AppendLine(" ,:UPD_BY"); sb.AppendLine(" ,SYSDATE"); sb.AppendLine(" ,:UPD_MACHINE"); sb.AppendLine(" )"); #endregion DataRequest req = new DataRequest(sb.ToString()); #region Parameters req.Parameters.Add("MENU_SUB_CD", DataType.VarChar, data.MENU_SUB_CD.Value); req.Parameters.Add("SCREEN_CD", DataType.VarChar, data.SCREEN_CD.Value); req.Parameters.Add("DISP_SEQ", DataType.Number, data.DISP_SEQ.Value); req.Parameters.Add("CRT_BY", DataType.NVarChar, data.CRT_BY.Value); req.Parameters.Add("CRT_MACHINE", DataType.NVarChar, data.CRT_MACHINE.Value); req.Parameters.Add("UPD_BY", DataType.NVarChar, data.UPD_BY.Value); req.Parameters.Add("UPD_MACHINE", DataType.NVarChar, data.UPD_MACHINE.Value); #endregion return(db.ExecuteNonQuery(req)); }
public void AddMenuSubItems(NZString MENU_SUB_CD, params NZString[] SCREEN_CDs) { Database db = CommonLib.Common.CurrentDatabase; db.KeepConnection = true; db.BeginTransaction(); try { IMenuSubItemDAO dao = DAOFactory.CreateMenuSubItemDAO(db); for (int i = 0; i < SCREEN_CDs.Length; i++) { // Get new seq of MenuSubItem; NZInt seq = dao.GetNewSequenceNo(null, MENU_SUB_CD); MenuSubItemDTO data = new MenuSubItemDTO(); data.MENU_SUB_CD = MENU_SUB_CD; data.SCREEN_CD = SCREEN_CDs[i]; data.DISP_SEQ = seq; data.CRT_BY = CommonLib.Common.CurrentUserInfomation.UserCD; data.CRT_MACHINE = CommonLib.Common.CurrentUserInfomation.Machine; data.UPD_BY = CommonLib.Common.CurrentUserInfomation.UserCD; data.UPD_MACHINE = CommonLib.Common.CurrentUserInfomation.Machine; dao.AddNew(null, data); } db.Commit(); } catch (Exception err) { db.Rollback(); throw err; } finally { if (db.DBConnectionState == ConnectionState.Open) { db.Close(); } } }
public void RaiseChangedLanguage() { this.SuspendLayout(); //MenuSubList menuList = m_menuManager.GetMenu(); List <MenuSub> menuList = m_menuController.LoadMenuHierachy(); // Load buffer workflow document list. m_workflowDocumentList.Clear(); for (int i = 0; i < menuList.Count; i++) { WorkflowDocument doc = WorkflowDocument.LoadDatabase(Common.CurrentDatabase, menuList[i].WORKFLOW_ID.NVL(String.Empty), Common.CurrentUserInfomation.UserCD); m_workflowDocumentList.Add(doc); } // Load Menu control. menuTree1.BeginUpdateMenuBar(); menuTree1.ClearMenuBars(); for (int i = 0; i < menuList.Count; i++) { MenuSub menuSub = menuList[i]; MenuBar menuBar = new MenuBar(); menuBar.Host = menuTree1; menuBar.Text = menuSub.MENU_SUB_DESC.NVL(string.Empty); menuBar.Tag = menuSub; for (int iScreen = 0; iScreen < menuSub.MenuSubItemList.Count; iScreen++) { MenuSubItemDTO menuSubItem = menuSub.MenuSubItemList[iScreen]; MenuItem menuItem = new MenuItem(menuBar); DatabaseScreen dbScreen = m_databaseScreenCache[menuSubItem.SCREEN_CD.StrongValue]; if (dbScreen == null) { #if DEBUG MessageDialog.ShowBusiness(this, "Not found screen code: " + menuSubItem.SCREEN_CD.StrongValue); #endif continue; } menuItem.Tag = menuSubItem; menuItem.Text = dbScreen.ScreenDescription.StrongValue; ImageItem imgItem = m_imageCache.Get(dbScreen.ImageCD.NVL(String.Empty)); Image img = null; if (imgItem != null) { img = imgItem.ImageBin; } if (img != null) { try { menuItem.Image = ImageHelper.GetThumbnailImage(img, 16, 16); } catch (Exception err) { MessageDialog.ShowBusiness(this, err.Message); } } menuBar.MenuItems.Add(menuItem); } menuTree1.AddMenuBar(menuBar); } if (menuTree1.MenuBars.Count > 0) { menuTree1.MenuBarSelected = menuTree1.MenuBars[0]; } menuTree1.EndUpdateMenuBar(); // Load Favorite button flowFavorite.Controls.Clear(); LoadFavorite(); this.ResumeLayout(false); }