/// <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 menu item sequence.
/// </summary>
/// <param name="menuSubCD"></param>
/// <param name="screenCD"></param>
/// <param name="newSequence"></param>
/// <returns></returns>
public int UpdateMenuItemSequence(NZString menuSubCD, NZString screenCD, NZInt newSequence)
{
MenuSubItemDAO dao = new MenuSubItemDAO(CommonLib.Common.CurrentDatabase);
return(dao.UpdateSequence(null, menuSubCD, screenCD, CommonLib.Common.CurrentUserInfomation.UserCD, CommonLib.Common.CurrentUserInfomation.Machine, newSequence));
}