/// <summary> /// Key: /// <para>MENU_SUB_CD, MENU_SUB_NAME, MENU_SUB_DESC</para> /// </summary> /// <param name="menuSubCD"></param> /// <param name="langCD"></param> /// <returns></returns> public DataTable LoadMenuSubWithLang(NZString menuSubCD, NZString langCD) { IMenuSubDAO dao = DAOFactory.CreateMenuSubDAO(CommonLib.Common.CurrentDatabase); DataTable dtView = dao.LoadMenuSubWithDescription(null, menuSubCD, langCD); return(dtView); }
public void DeleteMenuSub(NZString menuSubCD) { Database database = CommonLib.Common.CurrentDatabase; try { database.KeepConnection = true; database.BeginTransaction(); IMenuSubDAO daoMenuSub = DAOFactory.CreateMenuSubDAO(database); IMenuSubLangDAO daoMenuSubLang = DAOFactory.CreateMenuSubLangDAO(database); daoMenuSub.Delete(null, menuSubCD); daoMenuSubLang.DeleteOnAllLang(null, menuSubCD); database.Commit(); } catch { database.Rollback(); throw; } finally { if (database.DBConnectionState == ConnectionState.Open) { database.Close(); } } }
/// <summary> /// Save new menu sub. /// </summary> /// <param name="menuSubCD"></param> /// <param name="menuSubName"></param> /// <exception cref="EVOFramework.ValidateException"><c>ValidateException</c>.</exception> /// <exception cref="EVOFramework.BusinessException"><c>BusinessException</c>.</exception> public void SaveNewMenuSubDescription(NZString menuSubCD, NZString menuSubName) { MenuSubValidator validator = new MenuSubValidator(); validator.ValidateBeforeSaveAdd(menuSubCD, menuSubName); Database database = CommonLib.Common.CurrentDatabase; try { database.KeepConnection = true; database.BeginTransaction(); ILangDAO daoLang = DAOFactory.CreateLangDAO(database); IMenuSubDAO daoMenuSub = DAOFactory.CreateMenuSubDAO(database); IMenuSubLangDAO daoMenuSubLang = DAOFactory.CreateMenuSubLangDAO(database); //== Add menu sub master. MenuSubDTO dtoMenuSub = new MenuSubDTO(); dtoMenuSub.MENU_SUB_CD = menuSubCD; dtoMenuSub.MENU_SUB_NAME = menuSubName; dtoMenuSub.IMAGE_CD.Value = null; dtoMenuSub.CRT_BY = CommonLib.Common.CurrentUserInfomation.UserCD; dtoMenuSub.UPD_BY = CommonLib.Common.CurrentUserInfomation.UserCD; dtoMenuSub.CRT_MACHINE = CommonLib.Common.CurrentUserInfomation.Machine; dtoMenuSub.UPD_MACHINE = CommonLib.Common.CurrentUserInfomation.Machine; daoMenuSub.AddNew(null, dtoMenuSub); //== Add menu sub on each language. List <LangDTO> langs = daoLang.LoadAll(null); for (int i = 0; i < langs.Count; i++) { MenuSubLangDTO dtoMenuSubLang = new MenuSubLangDTO(); dtoMenuSubLang.MENU_SUB_CD = menuSubCD; dtoMenuSubLang.LANG_CD = langs[i].LANG_CD; dtoMenuSubLang.MENU_SUB_DESC = menuSubName; dtoMenuSubLang.CRT_BY = CommonLib.Common.CurrentUserInfomation.UserCD; dtoMenuSubLang.UPD_BY = CommonLib.Common.CurrentUserInfomation.UserCD; dtoMenuSubLang.CRT_MACHINE = CommonLib.Common.CurrentUserInfomation.Machine; dtoMenuSubLang.UPD_MACHINE = CommonLib.Common.CurrentUserInfomation.Machine; daoMenuSubLang.AddNewOrUpdate(null, dtoMenuSubLang); } database.Commit(); } catch { database.Rollback(); throw; } finally { if (database.DBConnectionState == ConnectionState.Open) { database.Close(); } } }
public void SaveEditMenuSub(NZString menuSubCD, NZString menuSubName) { Database database = CommonLib.Common.CurrentDatabase; try { database.KeepConnection = true; database.BeginTransaction(); IMenuSubDAO daoMenuSub = DAOFactory.CreateMenuSubDAO(database); //== Update menu sub master. MenuSubDTO dtoMenuSub = new MenuSubDTO(); dtoMenuSub.MENU_SUB_CD = menuSubCD; dtoMenuSub.MENU_SUB_NAME = menuSubName; dtoMenuSub.IMAGE_CD.Value = null; dtoMenuSub.CRT_BY = CommonLib.Common.CurrentUserInfomation.UserCD; dtoMenuSub.UPD_BY = CommonLib.Common.CurrentUserInfomation.UserCD; dtoMenuSub.CRT_MACHINE = CommonLib.Common.CurrentUserInfomation.Machine; dtoMenuSub.UPD_MACHINE = CommonLib.Common.CurrentUserInfomation.Machine; daoMenuSub.UpdateWithoutPK(null, dtoMenuSub); database.Commit(); } catch { database.Rollback(); throw; } finally { if (database.DBConnectionState == ConnectionState.Open) { database.Close(); } } }
/// <summary> /// Check exist menu sub code. /// </summary> /// <param name="menuSubCD"></param> /// <returns></returns> public bool ExistMenuSub(NZString menuSubCD) { IMenuSubDAO dao = DAOFactory.CreateMenuSubDAO(CommonLib.Common.CurrentDatabase); return(dao.Exist(null, menuSubCD)); }