/// <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="oldMENU_SET_CD">Old Key #2</param> /// <returns></returns> public int UpdateWithPK(Database database, MenuSetDetailDTO data, NZString oldMENU_SUB_CD, NZString oldMENU_SET_CD) { Database db = UseDatabase(database); StringBuilder sb = new StringBuilder(); #region SQL Statement sb.AppendLine(" UPDATE " + data.TableName); sb.AppendLine(" SET "); sb.AppendLine(" " + MenuSetDetailDTO.eColumns.MENU_SUB_CD + "=:MENU_SUB_CD"); sb.AppendLine(" ," + MenuSetDetailDTO.eColumns.MENU_SET_CD + "=:MENU_SET_CD"); sb.AppendLine(" ," + MenuSetDetailDTO.eColumns.DISP_SEQ + "=:DISP_SEQ"); sb.AppendLine(" ," + MenuSetDetailDTO.eColumns.UPD_BY + "=:UPD_BY"); sb.AppendLine(" ," + MenuSetDetailDTO.eColumns.UPD_DATE + "=GETDATE()"); sb.AppendLine(" ," + MenuSetDetailDTO.eColumns.UPD_MACHINE + "=:UPD_MACHINE"); sb.AppendLine(" WHERE "); sb.AppendLine(" " + MenuSetDetailDTO.eColumns.MENU_SUB_CD + "=:oldMENU_SUB_CD"); sb.AppendLine(" AND " + MenuSetDetailDTO.eColumns.MENU_SET_CD + "=:oldMenuSetDetail"); #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("MENU_SET_CD", DataType.VarChar, data.MENU_SET_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("oldMENU_SET_CD", DataType.VarChar, oldMENU_SET_CD.Value); #endregion return(db.ExecuteNonQuery(req)); }
internal int DeleteMenuSetDetail(string menuSetCD, string menuSubCD) { MenuSetMaintenanceBIZ biz = new MenuSetMaintenanceBIZ(); MenuSetDetailDTO dto = new MenuSetDetailDTO(); dto.MENU_SET_CD.Value = menuSetCD; dto.MENU_SUB_CD.Value = menuSubCD; return(biz.DeleteMenuSetDetail(dto)); }
/// <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, MenuSetDetailDTO data) { Database db = UseDatabase(database); if (Exist(database, data.MENU_SUB_CD, data.MENU_SET_CD)) { return(UpdateWithoutPK(db, data)); } return(AddNew(db, data)); }
public MenuRegisterUIDM LoadMenuList() { MenuRegisterUIDM model = new MenuRegisterUIDM(); MenuSetMaintenanceBIZ bizMenuSet = new MenuSetMaintenanceBIZ(); MenuSubMaintenanceBIZ bizMenuSub = new MenuSubMaintenanceBIZ(); NZString langCD = CommonLib.Common.CurrentUserInfomation.LanguageCD; // Load All MenuSet List <MenuSetDTO> listMenuSetDTO = bizMenuSet.LoadAllMenuSet(); for (int i = 0; i < listMenuSetDTO.Count; i++) { MenuSetDTO menuSetDTO = listMenuSetDTO[i]; MenuRegisterUIDM.MenuSet menuSet = new MenuRegisterUIDM.MenuSet(); menuSet.MENU_SET_CD.Value = menuSetDTO.MENU_SET_CD.Value; menuSet.MENU_SET_NAME.Value = menuSetDTO.MENU_SET_NAME.Value; // Load MenuSub which is child of MenuSet. List <MenuSetDetailDTO> listMenuSetDetail = bizMenuSet.LoadAllMenuSubByMenuSetCD(menuSet.MENU_SET_CD.StrongValue); for (int iDetail = 0; iDetail < listMenuSetDetail.Count; iDetail++) { MenuSetDetailDTO menuSetDetailDTO = listMenuSetDetail[iDetail]; // Load description of each MenuSub DataTable dtMenuSubDescription = bizMenuSub.LoadMenuSubWithLang(menuSetDetailDTO.MENU_SUB_CD, langCD); MenuRegisterUIDM.MenuSub menuSub = new MenuRegisterUIDM.MenuSub(menuSet); menuSub.MENU_SUB_CD.Value = menuSetDetailDTO.MENU_SUB_CD.Value; if (dtMenuSubDescription.Rows.Count > 0) { menuSub.MENU_SUB_NAME.Value = dtMenuSubDescription.Rows[0][(int)MenuSubDTO.eColumns.MENU_SUB_NAME]; menuSub.MENU_SUB_DESC.Value = dtMenuSubDescription.Rows[0][(int)MenuSubLangDTO.eColumns.MENU_SUB_DESC]; } // Add menuSub object into MenuSet object. menuSet.ListMenuSub.Add(menuSub); } model.ListMenuHierachy.Add(menuSet); } return(model); }
internal int AddMenuSetDetail(string MenuSetCD, string MenuSubCD) { MenuSetMaintenanceBIZ biz = new MenuSetMaintenanceBIZ(); MenuSetDetailDTO dto = new MenuSetDetailDTO(); dto.MENU_SET_CD.Value = MenuSetCD; dto.MENU_SUB_CD.Value = MenuSubCD; dto.DISP_SEQ.Value = GetLastDisplaySEQ(MenuSetCD) + 1; dto.CRT_BY = CommonLib.Common.CurrentUserInfomation.UserCD; dto.CRT_DATE.Value = DateTime.Now; dto.CRT_MACHINE = CommonLib.Common.CurrentUserInfomation.Machine; dto.UPD_BY = CommonLib.Common.CurrentUserInfomation.UserCD; dto.UPD_DATE.Value = DateTime.Now; dto.UPD_MACHINE = CommonLib.Common.CurrentUserInfomation.Machine; return(biz.AddMenuSetDetail(dto)); }
internal int UpdateMenuSetDetailWithoutPK(MenuSetDetailDTO dto) { CommonLib.Common.CurrentDatabase.KeepConnection = true; CommonLib.Common.CurrentDatabase.BeginTransaction(); try { IMenuSetDetailDAO dao = DAOFactory.CreateMenuSetDetailDAO(CommonLib.Common.CurrentDatabase); dao.UpdateWithoutPK(null, dto); CommonLib.Common.CurrentDatabase.Commit(); return(1); } catch { CommonLib.Common.CurrentDatabase.Rollback(); throw; } }
internal int DeleteMenuSetDetail(MenuSetDetailDTO dto) { CommonLib.Common.CurrentDatabase.KeepConnection = true; CommonLib.Common.CurrentDatabase.BeginTransaction(); try { IMenuSetDetailDAO dao = DAOFactory.CreateMenuSetDetailDAO(CommonLib.Common.CurrentDatabase); dao.Delete(null, dto.MENU_SUB_CD, dto.MENU_SET_CD); CommonLib.Common.CurrentDatabase.Commit(); return(1); } catch { CommonLib.Common.CurrentDatabase.Rollback(); throw; } }
internal void UpdateDisplaySEQ(string MenuSetCD, string MenuSubCD_UP, string MenuSubCD_DOWN, int DisplaySQ_UP, int DisplaySQ_DOWN) { MenuSetMaintenanceBIZ biz = new MenuSetMaintenanceBIZ(); MenuSetDetailDTO dto = new MenuSetDetailDTO(); dto.MENU_SET_CD.Value = MenuSetCD; dto.MENU_SUB_CD.Value = MenuSubCD_UP; dto.DISP_SEQ.Value = DisplaySQ_UP; dto.UPD_BY = CommonLib.Common.CurrentUserInfomation.UserCD; dto.UPD_DATE.Value = DateTime.Now; dto.UPD_MACHINE = CommonLib.Common.CurrentUserInfomation.Machine; biz.UpdateMenuSetDetailWithoutPK(dto); dto.MENU_SET_CD.Value = MenuSetCD; dto.MENU_SUB_CD.Value = MenuSubCD_DOWN; dto.DISP_SEQ.Value = DisplaySQ_DOWN; biz.UpdateMenuSetDetailWithoutPK(dto); }
/// <summary> /// Insert new record into database. /// </summary> /// <param name="database"></param> /// <param name="data"></param> /// <returns></returns> public int AddNew(Database database, MenuSetDetailDTO data) { Database db = UseDatabase(database); StringBuilder sb = new StringBuilder(); #region SQL Statement sb.AppendLine(" INSERT INTO " + data.TableName + "("); sb.AppendLine(" " + MenuSetDetailDTO.eColumns.MENU_SUB_CD); sb.AppendLine(" ," + MenuSetDetailDTO.eColumns.MENU_SET_CD); sb.AppendLine(" ," + MenuSetDetailDTO.eColumns.DISP_SEQ); sb.AppendLine(" ," + MenuSetDetailDTO.eColumns.CRT_BY); sb.AppendLine(" ," + MenuSetDetailDTO.eColumns.CRT_DATE); sb.AppendLine(" ," + MenuSetDetailDTO.eColumns.CRT_MACHINE); sb.AppendLine(" ," + MenuSetDetailDTO.eColumns.UPD_BY); sb.AppendLine(" ," + MenuSetDetailDTO.eColumns.UPD_DATE); sb.AppendLine(" ," + MenuSetDetailDTO.eColumns.UPD_MACHINE); sb.AppendLine(") VALUES("); sb.AppendLine(" :MENU_SUB_CD"); sb.AppendLine(" ,:MENU_SET_CD"); sb.AppendLine(" ,:DISP_SEQ"); sb.AppendLine(" ,:CRT_BY"); sb.AppendLine(" ,GETDATE()"); sb.AppendLine(" ,:CRT_MACHINE"); sb.AppendLine(" ,:UPD_BY"); sb.AppendLine(" ,GETDATE()"); 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("MENU_SET_CD", DataType.VarChar, data.MENU_SET_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)); }
internal int AddMenuSetDetail(MenuSetDetailDTO dto) { IMenuSetDetailDAO dao = DAOFactory.CreateMenuSetDetailDAO(CommonLib.Common.CurrentDatabase); return(dao.AddNew(null, dto)); }