/// <summary> /// 刪除角色ID信息 /// </summary> public void DeleteRole(Newtonsoft.Json.Linq.JObject requestValue, Newtonsoft.Json.Linq.JObject Data, MESStationReturn StationReturn) { MESDBHelper.OleExec SFCDB = _DBPools["SFCDB"].Borrow(); MESDataObject.Module.T_C_ROLE GetRoleInformation = new MESDataObject.Module.T_C_ROLE(SFCDB, DB_TYPE_ENUM.Oracle); MESDataObject.Module.Row_C_ROLE RoleRow = (MESDataObject.Module.Row_C_ROLE)GetRoleInformation.NewRow(); string EMP_NO = Data["EMP_NO"].ToString(); RoleRow = (MESDataObject.Module.Row_C_ROLE)GetRoleInformation.SELECTC_Rolebyrolename(EMP_NO, SFCDB, DB_TYPE_ENUM.Oracle); if (RoleRow != null) { string strRet = SFCDB.ExecSQL(RoleRow.GetDeleteString(DB_TYPE_ENUM.Oracle)); StationReturn.Status = StationReturnStatusValue.Pass; StationReturn.Message = "成功刪除角色信息!"; StationReturn.Data = ""; } else { StationReturn.Status = StationReturnStatusValue.Fail; StationReturn.Message = "無此用戶信息!"; } this.DBPools["SFCDB"].Return(SFCDB); }
/// <summary> /// 更新角色ID信息 /// </summary> public void UpdateRole(Newtonsoft.Json.Linq.JObject requestValue, Newtonsoft.Json.Linq.JObject Data, MESStationReturn StationReturn) { MESDBHelper.OleExec SFCDB = _DBPools["SFCDB"].Borrow(); MESDataObject.Module.T_C_ROLE GetRoleInformation = new MESDataObject.Module.T_C_ROLE(SFCDB, DB_TYPE_ENUM.Oracle); MESDataObject.Module.Row_C_ROLE RoleRow = (MESDataObject.Module.Row_C_ROLE)GetRoleInformation.NewRow(); string ROLE_NAME = Data["ROLE_NAME"].ToString(); string ROLE_DESC = Data["ROLE_DESC"].ToString(); RoleRow = (MESDataObject.Module.Row_C_ROLE)GetRoleInformation.SELECTC_Rolebyrolename(ROLE_NAME, SFCDB, DB_TYPE_ENUM.Oracle); if (RoleRow != null) { RoleRow.ROLE_DESC = Data["ROLE_DESC"].ToString(); RoleRow.EDIT_EMP = Data["EDIT_EMP"].ToString(); RoleRow.EDIT_TIME = DateTime.Now; string strRet = SFCDB.ExecSQL(RoleRow.GetUpdateString(DB_TYPE_ENUM.Oracle)); StationReturn.Status = StationReturnStatusValue.Pass; StationReturn.Message = "成功更新角色信息!"; StationReturn.Data = ""; } else { StationReturn.Status = StationReturnStatusValue.Fail; StationReturn.Message = "無此角色信息!"; } this.DBPools["SFCDB"].Return(SFCDB); }