/// <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="oldSCREEN_CD">Old Key #1</param> /// <param name="oldLANG_CD">Old Key #2</param> /// <returns></returns> public int UpdateWithPK(Database database, ScreenLangDTO data, NZString oldSCREEN_CD, NZString oldLANG_CD) { Database db = UseDatabase(database); StringBuilder sb = new StringBuilder(); #region SQL Statement sb.AppendLine(" UPDATE " + data.TableName); sb.AppendLine(" SET "); sb.AppendLine(" " + ScreenLangDTO.eColumns.SCREEN_CD + "=:SCREEN_CD"); sb.AppendLine(" ," + ScreenLangDTO.eColumns.LANG_CD + "=:LANG_CD"); sb.AppendLine(" ," + ScreenLangDTO.eColumns.SCREEN_DESC + "=:SCREEN_DESC"); sb.AppendLine(" ," + ScreenLangDTO.eColumns.UPD_BY + "=:UPD_BY"); sb.AppendLine(" ," + ScreenLangDTO.eColumns.UPD_DATE + "=GETDATE()"); sb.AppendLine(" ," + ScreenLangDTO.eColumns.UPD_MACHINE + "=:UPD_MACHINE"); sb.AppendLine(" WHERE "); sb.AppendLine(" " + ScreenLangDTO.eColumns.SCREEN_CD + "=:oldSCREEN_CD"); sb.AppendLine(" AND " + ScreenLangDTO.eColumns.LANG_CD + "=:oldScreenLang"); #endregion DataRequest req = new DataRequest(sb.ToString()); #region Parameters req.Parameters.Add("SCREEN_CD", DataType.VarChar, data.SCREEN_CD.Value); req.Parameters.Add("LANG_CD", DataType.VarChar, data.LANG_CD.Value); req.Parameters.Add("SCREEN_DESC", DataType.NVarChar, data.SCREEN_DESC.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("oldSCREEN_CD", DataType.VarChar, oldSCREEN_CD.Value); req.Parameters.Add("oldLANG_CD", DataType.VarChar, oldLANG_CD.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, ScreenLangDTO data) { Database db = UseDatabase(database); if (Exist(database, data.SCREEN_CD, data.LANG_CD)) { return(UpdateWithoutPK(db, data)); } return(AddNew(db, data)); }
internal int SaveScreenDisplayText(string ScreenCD, string LangCD, string DisplayTitle) { ScreenLangBIZ biz = new ScreenLangBIZ(); ScreenLangDTO dto = new ScreenLangDTO(); dto.SCREEN_CD.Value = ScreenCD; dto.LANG_CD.Value = LangCD; dto.SCREEN_DESC.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, ScreenLangDTO data) { Database db = UseDatabase(database); StringBuilder sb = new StringBuilder(); #region SQL Statement sb.AppendLine(" INSERT INTO " + data.TableName + "("); sb.AppendLine(" " + ScreenLangDTO.eColumns.SCREEN_CD); sb.AppendLine(" ," + ScreenLangDTO.eColumns.LANG_CD); sb.AppendLine(" ," + ScreenLangDTO.eColumns.SCREEN_DESC); sb.AppendLine(" ," + ScreenLangDTO.eColumns.CRT_BY); sb.AppendLine(" ," + ScreenLangDTO.eColumns.CRT_DATE); sb.AppendLine(" ," + ScreenLangDTO.eColumns.CRT_MACHINE); sb.AppendLine(" ," + ScreenLangDTO.eColumns.UPD_BY); sb.AppendLine(" ," + ScreenLangDTO.eColumns.UPD_DATE); sb.AppendLine(" ," + ScreenLangDTO.eColumns.UPD_MACHINE); sb.AppendLine(" ," + ScreenLangDTO.eColumns.IS_USED); sb.AppendLine(") VALUES("); sb.AppendLine(" :SCREEN_CD"); sb.AppendLine(" ,:LANG_CD"); sb.AppendLine(" ,:SCREEN_DESC"); 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("SCREEN_CD", DataType.VarChar, data.SCREEN_CD.Value); req.Parameters.Add("LANG_CD", DataType.VarChar, data.LANG_CD.Value); req.Parameters.Add("SCREEN_DESC", DataType.NVarChar, data.SCREEN_DESC.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, ScreenLangDTO argScreenLangDTO) { Database db = UseDatabase(database); StringBuilder sb = new StringBuilder(); sb.AppendLine(" UPDATE TZ_SCREEN_LANG_MS "); sb.AppendLine(" SET IS_USED = 1 "); sb.AppendLine(" WHERE SCREEN_CD = :pSCREEN_CD"); sb.AppendLine(" AND LANG_CD = :pLANG_CD"); DataRequest req = new DataRequest(sb.ToString()); req.Parameters.Add("@pSCREEN_CD", argScreenLangDTO.SCREEN_CD.Value); req.Parameters.Add("@pLANG_CD", argScreenLangDTO.LANG_CD.Value); db.ExecuteNonQuery(req); }
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); }
//public int DeletebyScreenCD(NZString nZString) //{ // ScreenLangDAO dao = new ScreenLangDAO(CommonLib.Common.CurrentDatabase); // return dao.DeletebyScreenCD(null, nZString); //} public int UpdateScreenDisplayText(ScreenLangDTO dto) { IScreenLangDAO dao = DAOFactory.CreateScreenLangDAO(CommonLib.Common.CurrentDatabase); return(dao.UpdateWithoutPK(null, dto)); }
public int AddNew(ScreenLangDTO dtoScreenLang) { IScreenLangDAO dao = DAOFactory.CreateScreenLangDAO(CommonLib.Common.CurrentDatabase); return(dao.AddNew(null, dtoScreenLang)); }