/// <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);
}