/// <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, UserScreenPermissionDTO data) { Database db = UseDatabase(database); StringBuilder sb = new StringBuilder(); #region SQL Statement sb.AppendLine(" UPDATE " + data.TableName); sb.AppendLine(" SET "); sb.AppendLine(" " + UserScreenPermissionDTO.eColumns.FLG_VIEW + "=:FLG_VIEW"); sb.AppendLine(" ," + UserScreenPermissionDTO.eColumns.FLG_ADD + "=:FLG_ADD"); sb.AppendLine(" ," + UserScreenPermissionDTO.eColumns.FLG_CHG + "=:FLG_CHG"); sb.AppendLine(" ," + UserScreenPermissionDTO.eColumns.FLG_DEL + "=:FLG_DEL"); sb.AppendLine(" ," + UserScreenPermissionDTO.eColumns.UPD_BY + "=:UPD_BY"); sb.AppendLine(" ," + UserScreenPermissionDTO.eColumns.UPD_DATE + "=GETDATE()"); sb.AppendLine(" ," + UserScreenPermissionDTO.eColumns.UPD_MACHINE + "=:UPD_MACHINE"); sb.AppendLine(" WHERE "); sb.AppendLine(" " + UserScreenPermissionDTO.eColumns.SCREEN_CD + "=:SCREEN_CD"); sb.AppendLine(" AND " + UserScreenPermissionDTO.eColumns.USER_CD + "=:USER_CD"); #endregion DataRequest req = new DataRequest(sb.ToString()); #region Parameters req.Parameters.Add("SCREEN_CD", DataType.VarChar, data.SCREEN_CD.Value); req.Parameters.Add("USER_CD", DataType.VarChar, data.USER_CD.Value); req.Parameters.Add("FLG_VIEW", DataType.Number, data.FLG_VIEW.Value); req.Parameters.Add("FLG_ADD", DataType.Number, data.FLG_ADD.Value); req.Parameters.Add("FLG_CHG", DataType.Number, data.FLG_CHG.Value); req.Parameters.Add("FLG_DEL", DataType.Number, data.FLG_DEL.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, UserScreenPermissionDTO data) { Database db = UseDatabase(database); if (Exist(database, data.SCREEN_CD, data.USER_CD)) { return(UpdateWithoutPK(db, data)); } return(AddNew(db, data)); }
/// <summary> /// Insert new record into database. /// </summary> /// <param name="database"></param> /// <param name="data"></param> /// <returns></returns> public int AddNew(Database database, UserScreenPermissionDTO data) { Database db = UseDatabase(database); StringBuilder sb = new StringBuilder(); #region SQL Statement sb.AppendLine(" INSERT INTO " + data.TableName + "("); sb.AppendLine(" " + UserScreenPermissionDTO.eColumns.SCREEN_CD); sb.AppendLine(" ," + UserScreenPermissionDTO.eColumns.USER_CD); sb.AppendLine(" ," + UserScreenPermissionDTO.eColumns.FLG_VIEW); sb.AppendLine(" ," + UserScreenPermissionDTO.eColumns.FLG_ADD); sb.AppendLine(" ," + UserScreenPermissionDTO.eColumns.FLG_CHG); sb.AppendLine(" ," + UserScreenPermissionDTO.eColumns.FLG_DEL); sb.AppendLine(" ," + UserScreenPermissionDTO.eColumns.CRT_BY); sb.AppendLine(" ," + UserScreenPermissionDTO.eColumns.CRT_DATE); sb.AppendLine(" ," + UserScreenPermissionDTO.eColumns.CRT_MACHINE); sb.AppendLine(" ," + UserScreenPermissionDTO.eColumns.UPD_BY); sb.AppendLine(" ," + UserScreenPermissionDTO.eColumns.UPD_DATE); sb.AppendLine(" ," + UserScreenPermissionDTO.eColumns.UPD_MACHINE); sb.AppendLine(") VALUES("); sb.AppendLine(" :SCREEN_CD"); sb.AppendLine(" ,:USER_CD"); sb.AppendLine(" ,:FLG_VIEW"); sb.AppendLine(" ,:FLG_ADD"); sb.AppendLine(" ,:FLG_CHG"); sb.AppendLine(" ,:FLG_DEL"); 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("SCREEN_CD", DataType.VarChar, data.SCREEN_CD.Value); req.Parameters.Add("USER_CD", DataType.VarChar, data.USER_CD.Value); req.Parameters.Add("FLG_VIEW", DataType.Number, data.FLG_VIEW.Value); req.Parameters.Add("FLG_ADD", DataType.Number, data.FLG_ADD.Value); req.Parameters.Add("FLG_CHG", DataType.Number, data.FLG_CHG.Value); req.Parameters.Add("FLG_DEL", DataType.Number, data.FLG_DEL.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 void UpdateUserScreenPermissionFlagDEL(int objFLG_DEL, string UserCD, string ScreenCD) { AuthorizedMaintenanceBIZ biz = new AuthorizedMaintenanceBIZ(); UserScreenPermissionDTO dto = new UserScreenPermissionDTO(); dto.SCREEN_CD.Value = ScreenCD; dto.USER_CD.Value = UserCD; //dto.FLG_VIEW.Value = objFLG_VIEW; //dto.FLG_ADD.Value = objFLG_ADD; //dto.FLG_CHG.Value = objFLG_CHG; dto.FLG_DEL.Value = objFLG_DEL; dto.UPD_BY = CommonLib.Common.CurrentUserInfomation.UserCD; dto.UPD_DATE.Value = DateTime.Now; dto.UPD_MACHINE = CommonLib.Common.CurrentUserInfomation.Machine; biz.UpdateUserScreenPermissionFlagDEL(dto); }
public int UpdateUserScreenPermissionFlagADD(Database database, UserScreenPermissionDTO dto) { Database db = UseDatabase(database); string sql = @"UPDATE TZ_USER_SCREEN_PERMISSION_MS SET FLG_ADD = :FLG_ADD, UPD_BY = :UPD_BY, UPD_DATE = :UPD_DATE, UPD_MACHINE = :UPD_MACHINE WHERE SCREEN_CD = :SCREEN_CD AND USER_CD = :USER_CD"; DataRequest req = new DataRequest(sql); req.Parameters.Add("SCREEN_CD", DataType.VarChar, dto.SCREEN_CD.StrongValue); req.Parameters.Add("USER_CD", DataType.VarChar, dto.USER_CD.StrongValue); req.Parameters.Add("FLG_ADD", DataType.VarChar, dto.FLG_ADD.StrongValue); req.Parameters.Add("UPD_BY", DataType.VarChar, dto.UPD_BY.StrongValue); req.Parameters.Add("UPD_DATE", DataType.DateTime, dto.UPD_DATE.StrongValue); req.Parameters.Add("UPD_MACHINE", DataType.VarChar, dto.UPD_MACHINE.StrongValue); return(db.ExecuteNonQuery(req)); }
internal void UpdateUserScreenPermissionFlagDEL(UserScreenPermissionDTO dto) { IUserScreenPermissionDAO dao = DAOFactory.CreateUserScreenPermissionDAO(CommonLib.Common.CurrentDatabase); dao.UpdateUserScreenPermissionFlagDEL(null, dto); }