/// <summary> /// Update record by using primary key value on the given data variable /// </summary> /// <param name="database"></param> /// <param name="data">Data with primary key value.</param> /// <returns></returns> public int UpdateWithoutPK(Database database, ScreenDetailLangDTO data) { Database db = UseDatabase(database); StringBuilder sb = new StringBuilder(); #region SQL Statement sb.AppendLine(" UPDATE " + data.TableName); sb.AppendLine(" SET "); sb.AppendLine(" " + ScreenDetailLangDTO.eColumns.CONTROL_CAPTION + "=:CONTROL_CAPTION"); sb.AppendLine(" ," + ScreenDetailLangDTO.eColumns.UPD_BY + "=:UPD_BY"); sb.AppendLine(" ," + ScreenDetailLangDTO.eColumns.UPD_DATE + "=GETDATE()"); sb.AppendLine(" ," + ScreenDetailLangDTO.eColumns.UPD_MACHINE + "=:UPD_MACHINE"); sb.AppendLine(" WHERE "); sb.AppendLine(" " + ScreenDetailLangDTO.eColumns.CONTROL_CD + "=:CONTROL_CD"); sb.AppendLine(" AND " + ScreenDetailLangDTO.eColumns.LANG_CD + "=:LANG_CD"); sb.AppendLine(" AND " + ScreenDetailLangDTO.eColumns.SCREEN_CD + "=:SCREEN_CD"); #endregion DataRequest req = new DataRequest(sb.ToString()); #region Parameters req.Parameters.Add("CONTROL_CD", DataType.VarChar, data.CONTROL_CD.Value); req.Parameters.Add("LANG_CD", DataType.VarChar, data.LANG_CD.Value); req.Parameters.Add("SCREEN_CD", DataType.VarChar, data.SCREEN_CD.Value); req.Parameters.Add("CONTROL_CAPTION", DataType.NVarChar, data.CONTROL_CAPTION.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)); }
/// <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, ScreenDetailLangDTO data) { Database db = UseDatabase(database); if (Exist(database, data.CONTROL_CD, data.LANG_CD, data.SCREEN_CD)) { return(UpdateWithoutPK(db, data)); } return(AddNew(db, data)); }
internal int SaveScreenDetailDisplayText(string ScreenCD, string ControlCD, string LangCD, string DisplayTitle) { ScreenDetailLangBIZ biz = new ScreenDetailLangBIZ(); ScreenDetailLangDTO dto = new ScreenDetailLangDTO(); dto.CONTROL_CD.Value = ControlCD; dto.LANG_CD.Value = LangCD; dto.SCREEN_CD.Value = ScreenCD; dto.CONTROL_CAPTION.Value = DisplayTitle; dto.UPD_BY.Value = CommonLib.Common.CurrentUserInfomation.UserCD.StrongValue; dto.UPD_DATE.Value = DateTime.Now; dto.UPD_MACHINE.Value = Environment.MachineName; return(biz.UpdateScreenDisplayText(dto)); }
/// <summary> /// Insert new record into database. /// </summary> /// <param name="database"></param> /// <param name="data"></param> /// <returns></returns> public int AddNew(Database database, ScreenDetailLangDTO data) { Database db = UseDatabase(database); StringBuilder sb = new StringBuilder(); #region SQL Statement sb.AppendLine(" INSERT INTO " + data.TableName + "("); sb.AppendLine(" " + ScreenDetailLangDTO.eColumns.CONTROL_CD); sb.AppendLine(" ," + ScreenDetailLangDTO.eColumns.LANG_CD); sb.AppendLine(" ," + ScreenDetailLangDTO.eColumns.SCREEN_CD); sb.AppendLine(" ," + ScreenDetailLangDTO.eColumns.CONTROL_CAPTION); sb.AppendLine(" ," + ScreenDetailLangDTO.eColumns.CRT_BY); sb.AppendLine(" ," + ScreenDetailLangDTO.eColumns.CRT_DATE); sb.AppendLine(" ," + ScreenDetailLangDTO.eColumns.CRT_MACHINE); sb.AppendLine(" ," + ScreenDetailLangDTO.eColumns.UPD_BY); sb.AppendLine(" ," + ScreenDetailLangDTO.eColumns.UPD_DATE); sb.AppendLine(" ," + ScreenDetailLangDTO.eColumns.UPD_MACHINE); sb.AppendLine(" ," + ScreenDetailLangDTO.eColumns.IS_USED); sb.AppendLine(") VALUES("); sb.AppendLine(" :CONTROL_CD"); sb.AppendLine(" ,:LANG_CD"); sb.AppendLine(" ,:SCREEN_CD"); sb.AppendLine(" ,:CONTROL_CAPTION"); sb.AppendLine(" ,:CRT_BY"); sb.AppendLine(" ,GETDATE()"); sb.AppendLine(" ,:CRT_MACHINE"); sb.AppendLine(" ,:UPD_BY"); sb.AppendLine(" ,GETDATE()"); sb.AppendLine(" ,:UPD_MACHINE"); sb.AppendLine(" ,1"); sb.AppendLine(" )"); #endregion DataRequest req = new DataRequest(sb.ToString()); #region Parameters req.Parameters.Add("CONTROL_CD", DataType.VarChar, data.CONTROL_CD.Value); req.Parameters.Add("LANG_CD", DataType.VarChar, data.LANG_CD.Value); req.Parameters.Add("SCREEN_CD", DataType.VarChar, data.SCREEN_CD.Value); req.Parameters.Add("CONTROL_CAPTION", DataType.NVarChar, data.CONTROL_CAPTION.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 UpdateIsUsed(Database database, ScreenDetailLangDTO argScreenDetailLangDTO) { Database db = UseDatabase(database); StringBuilder sb = new StringBuilder(); sb.AppendLine(" UPDATE TZ_SCREEN_DETAIL_LANG_MS "); sb.AppendLine(" SET IS_USED = 1 "); sb.AppendLine(" WHERE CONTROL_CD = :pCONTROL_CD"); sb.AppendLine(" AND LANG_CD = :pLANG_CD"); sb.AppendLine(" AND SCREEN_CD = :pSCREEN_CD"); DataRequest req = new DataRequest(sb.ToString()); req.Parameters.Add("@pCONTROL_CD", argScreenDetailLangDTO.CONTROL_CD.Value); req.Parameters.Add("@pLANG_CD", argScreenDetailLangDTO.LANG_CD.Value); req.Parameters.Add("@pSCREEN_CD", argScreenDetailLangDTO.SCREEN_CD.Value); db.ExecuteNonQuery(req); }
private void AddControlDetailtoDatabase(List <LangDTO> langDTOList, string ScreenCD, Control control, string controlName, List <ScreenDetailDTO> screenDetailDTOList, List <ScreenDetailLangDTO> screenDetailLangDTOList) { ScreenDetailDTO dtoScreenDetail = new ScreenDetailDTO(); // add all control id to screen detail // dtoScreenDetail.SCREEN_CD.Value = ScreenCD; dtoScreenDetail.CONTROL_CD.Value = controlName; dtoScreenDetail.CONTROL_TYPE.Value = control.GetType().Name; dtoScreenDetail.CRT_BY = CommonLib.Common.CurrentUserInfomation.UserCD; dtoScreenDetail.CRT_DATE.Value = DateTime.Now; dtoScreenDetail.CRT_MACHINE.Value = Environment.MachineName; dtoScreenDetail.UPD_BY = CommonLib.Common.CurrentUserInfomation.UserCD; dtoScreenDetail.UPD_DATE.Value = DateTime.Now; dtoScreenDetail.UPD_MACHINE.Value = Environment.MachineName; screenDetailDTOList.Add(dtoScreenDetail); if (langDTOList.Count > 0) { foreach (LangDTO langdto in langDTOList) { ScreenDetailLangDTO dtoScreenDetailLang = new ScreenDetailLangDTO(); dtoScreenDetailLang.SCREEN_CD.Value = ScreenCD; dtoScreenDetailLang.CRT_BY = CommonLib.Common.CurrentUserInfomation.UserCD; dtoScreenDetailLang.CRT_DATE.Value = DateTime.Now; dtoScreenDetailLang.CRT_MACHINE.Value = Environment.MachineName; dtoScreenDetailLang.UPD_BY = CommonLib.Common.CurrentUserInfomation.UserCD; dtoScreenDetailLang.UPD_DATE.Value = DateTime.Now; dtoScreenDetailLang.UPD_MACHINE.Value = Environment.MachineName; dtoScreenDetailLang.CONTROL_CD.Value = controlName; dtoScreenDetailLang.CONTROL_CAPTION.Value = control.Text; dtoScreenDetailLang.LANG_CD = langdto.LANG_CD; screenDetailLangDTOList.Add(dtoScreenDetailLang); } } }
public void ImportData(List <ScreenImportUIDM> ScreenImportList, List <ScreenDetailUIDM> UIDMScreenDetailList) { LangBIZ bizLang = new LangBIZ(); LangDTO dtoLang = new LangDTO(); ScreenDetailBIZ bizScreenDetail = new ScreenDetailBIZ(); List <ScreenDTO> screenDTOList = new List <ScreenDTO>(); List <ScreenLangDTO> screenLangDTOList = new List <ScreenLangDTO>(); List <ScreenDetailDTO> screenDetailDTOList = new List <ScreenDetailDTO>(); List <ScreenDetailLangDTO> screenDetailLangDTOList = new List <ScreenDetailLangDTO>(); // count lang detail List <LangDTO> langDTOList = bizLang.LoadAll(); #region Collect Data foreach (ScreenImportUIDM ScreenImport in ScreenImportList) { // check if screen is never been import then import to screen ms if (ScreenImport.ImportStatus.StrongValue.ToUpper() == "NOTIMPORT") { ScreenDTO dtoScreen = new ScreenDTO(); dtoScreen.SCREEN_CD = ScreenImport.ScreenCD; dtoScreen.SCREEN_NAME = ScreenImport.ScreenName; dtoScreen.ORIGINAL_TITLE = ScreenImport.ScreenName; dtoScreen.IMAGE_CD.Value = "DEFAULT"; dtoScreen.SCREEN_TYPE = ScreenImport.ScreenType; dtoScreen.SCREEN_ACTION.Value = 0; dtoScreen.EXT_PROGRAM.Value = string.Empty; dtoScreen.CRT_BY = CommonLib.Common.CurrentUserInfomation.UserCD; dtoScreen.CRT_DATE.Value = DateTime.Now; dtoScreen.CRT_MACHINE.Value = Environment.MachineName; dtoScreen.UPD_BY = CommonLib.Common.CurrentUserInfomation.UserCD; dtoScreen.UPD_DATE.Value = DateTime.Now; dtoScreen.UPD_MACHINE.Value = Environment.MachineName; screenDTOList.Add(dtoScreen); if (langDTOList.Count > 0) { foreach (LangDTO langdto in langDTOList) { ScreenLangDTO dtoScreenLang = new ScreenLangDTO(); // add multilang for screen name dtoScreenLang.SCREEN_CD = ScreenImport.ScreenCD; dtoScreenLang.SCREEN_DESC = ScreenImport.ScreenName; dtoScreenLang.CRT_BY = CommonLib.Common.CurrentUserInfomation.UserCD; dtoScreenLang.CRT_DATE.Value = DateTime.Now; dtoScreenLang.CRT_MACHINE.Value = Environment.MachineName; dtoScreenLang.UPD_BY = CommonLib.Common.CurrentUserInfomation.UserCD; dtoScreenLang.UPD_DATE.Value = DateTime.Now; dtoScreenLang.UPD_MACHINE.Value = Environment.MachineName; dtoScreenLang.LANG_CD = langdto.LANG_CD; //bizScreenLang.AddNew(dtoScreenLang); screenLangDTOList.Add(dtoScreenLang); } } } } foreach (ScreenDetailUIDM ScreenDetail in UIDMScreenDetailList) { ScreenDetailDTO dtoScreenDetail = new ScreenDetailDTO(); dtoScreenDetail.SCREEN_CD = ScreenDetail.ScreenCD; dtoScreenDetail.CONTROL_TYPE = ScreenDetail.ControlType; dtoScreenDetail.ORIGINAL_TITLE = ScreenDetail.ControlCaption; dtoScreenDetail.CRT_BY = CommonLib.Common.CurrentUserInfomation.UserCD; dtoScreenDetail.CRT_DATE.Value = DateTime.Now; dtoScreenDetail.CRT_MACHINE.Value = Environment.MachineName; dtoScreenDetail.UPD_BY = CommonLib.Common.CurrentUserInfomation.UserCD; dtoScreenDetail.UPD_DATE.Value = DateTime.Now; dtoScreenDetail.UPD_MACHINE.Value = Environment.MachineName; dtoScreenDetail.CONTROL_CD = ScreenDetail.ControlCD; screenDetailDTOList.Add(dtoScreenDetail); if (langDTOList.Count > 0) { foreach (LangDTO langdto in langDTOList) { ScreenDetailLangDTO dtoScreenDetailLang = new ScreenDetailLangDTO(); // add spread column to screen detail ms dtoScreenDetailLang.SCREEN_CD = ScreenDetail.ScreenCD; dtoScreenDetailLang.CRT_BY = CommonLib.Common.CurrentUserInfomation.UserCD; dtoScreenDetailLang.CRT_DATE.Value = DateTime.Now; dtoScreenDetailLang.CRT_MACHINE.Value = Environment.MachineName; dtoScreenDetailLang.UPD_BY = CommonLib.Common.CurrentUserInfomation.UserCD; dtoScreenDetailLang.UPD_DATE.Value = DateTime.Now; dtoScreenDetailLang.UPD_MACHINE.Value = Environment.MachineName; // add multilang for spread column dtoScreenDetailLang.CONTROL_CD = ScreenDetail.ControlCD; //.Value = fpsspread.Name + ".Column[" + i.ToString() + "]"; dtoScreenDetailLang.CONTROL_CAPTION = ScreenDetail.ControlCaption; //.Value = fpsspread.Sheets[0].Columns[i].Label; dtoScreenDetailLang.LANG_CD = langdto.LANG_CD; screenDetailLangDTOList.Add(dtoScreenDetailLang); } } } #endregion ImportScreenBIZ bizImportScreen = new ImportScreenBIZ(); bizImportScreen.ImportData(screenDTOList, screenLangDTOList, screenDetailDTOList, screenDetailLangDTOList); }
/// <summary> /// Initialize all control text following by stored data on database, depend on current user's language. /// </summary> protected virtual void InitializeControlText() { if (this.ScreenCode == string.Empty) { return; } Map <string, ScreenDetail> mapControlList = this.GetControlList(); ScreenDetailLangBIZ bizScreenDetailLang = new ScreenDetailLangBIZ(); string langCD = CommonLib.Common.SystemLanguage.StrongValue; if (CommonLib.Common.CurrentUserInfomation != null) { langCD = CommonLib.Common.CurrentUserInfomation.LanguageCD.StrongValue; } // Load screen detail depend on language. List <ScreenDetailLangDTO> listScreenDetailLang = bizScreenDetailLang.LoadScreenDetailByLangCD(this.ScreenCode, langCD); for (int i = 0; i < listScreenDetailLang.Count; i++) { ScreenDetailLangDTO dto = listScreenDetailLang[i]; MapKeyValue <string, ScreenDetail> mapKeyValue = mapControlList[dto.CONTROL_CD.StrongValue]; if (mapKeyValue == null) { continue; } ScreenDetail screenDetail = mapKeyValue.Value; Control ctrl = null; switch (screenDetail.Type) { case ScreenDetail.TYPE_FORM: ctrl = screenDetail.ObjOwner as Control; if (ctrl != null) { ctrl.Text = ScreenAttribute.GetScreenAttribute(screenDetail.ObjOwner.GetType()).ScreenCD + ": " + dto.CONTROL_CAPTION.NVL(string.Empty); } break; case ScreenDetail.TYPE_BUTTON: case ScreenDetail.TYPE_CHECKBOX: case ScreenDetail.TYPE_GROUPBOX: case ScreenDetail.TYPE_LABEL: case ScreenDetail.TYPE_RADIOBUTTON: case ScreenDetail.TYPE_TABPAGE: ctrl = screenDetail.ObjOwner as Control; if (ctrl != null) { ctrl.Text = dto.CONTROL_CAPTION.NVL(string.Empty); } break; case ScreenDetail.TYPE_SPREAD_COLUMN: Column column = screenDetail.ObjOwner as Column; if (column != null) { column.Label = dto.CONTROL_CAPTION.NVL(string.Empty); } break; } } }
public int UpdateScreenDisplayText(ScreenDetailLangDTO dto) { IScreenDetailLangDAO dao = DAOFactory.CreateScreenDetailLangDAO(CommonLib.Common.CurrentDatabase); return(dao.UpdateWithoutPK(null, dto)); }
public int AddNew(ScreenDetailLangDTO dtoScreenDetailLang) { IScreenDetailLangDAO dao = DAOFactory.CreateScreenDetailLangDAO(CommonLib.Common.CurrentDatabase); return(dao.AddNew(null, dtoScreenDetailLang)); }