/// <summary> /// Load Equipment Change Reasons Data /// </summary> /// <param name="equipmentChangeStateKey"></param> /// <param name="msg"></param> /// <returns></returns> /// Owner:Andy Gao 2011-08-03 14:58:11 public DataTable LoadEquipmentChangeReasonsData(string equipmentChangeStateKey, out string msg) { #region Call Remoting Interface DataSet reqDS = new DataSet(); DataSet resDS = new DataSet(); if (!string.IsNullOrEmpty(equipmentChangeStateKey)) { DataTable inputParamDataTable = PARAMETERS_INPUT.CreateDataTable(); object inputKey = DBNull.Value; object inputEditor = DBNull.Value; object inputEditTime = DBNull.Value; inputKey = equipmentChangeStateKey; inputParamDataTable.Rows.Add(new object[] { inputKey, inputEditor, inputEditTime }); inputParamDataTable.AcceptChanges(); reqDS.Tables.Add(inputParamDataTable); } try { IServerObjFactory serverFactory = CallRemotingService.GetRemoteObject(); resDS = serverFactory.CreateIEquipmentChangeReasons().GetEquipmentChangeReasons(reqDS); } catch (Exception ex) { msg = ex.Message; return(null); } finally { CallRemotingService.UnregisterChannel(); } msg = FanHai.Hemera.Share.Common.ReturnMessageUtils.GetServerReturnMessage(resDS); return(resDS.Tables[EMS_EQUIPMENT_CHANGE_REASONS_FIELDS.DATABASE_TABLE_NAME]); #endregion }
/// <summary> /// Update Equipment Change Reasons Data /// </summary> /// <returns></returns> /// Owner:Andy Gao 2010-07-20 14:52:52 private bool UpdateEquipmentChangeReasonsData() { #region Variables DataSet reqDS = new DataSet(); DataSet resDS = new DataSet(); #endregion #region Build Equipment Change Reasons Data if (this.grdChangeReasons.DataSource != null && this.grdChangeReasons.DataSource is DataTable) { DataTable equipmentChangeReasonsDataTable = (DataTable)this.grdChangeReasons.DataSource; DataTable addedDataTable = equipmentChangeReasonsDataTable.GetChanges(DataRowState.Added); DataTable modifiedDataTable = equipmentChangeReasonsDataTable.GetChanges(DataRowState.Modified); DataTable deletedDataTable = equipmentChangeReasonsDataTable.GetChanges(DataRowState.Deleted); if ((addedDataTable != null && addedDataTable.Rows.Count > 0) || (modifiedDataTable != null && modifiedDataTable.Rows.Count > 0) || (deletedDataTable != null && deletedDataTable.Rows.Count > 0)) { equipmentChangeReasonsDataTable.TableName = EMS_EQUIPMENT_CHANGE_REASONS_FIELDS.DATABASE_TABLE_NAME; reqDS.Tables.Add(equipmentChangeReasonsDataTable.Copy()); } else { MessageService.ShowMessage("${res:FanHai.Hemera.Addins.EMS.EquipmentChangeReasons.M0006}", "${res:Global.InformationText}"); return(false); } } #endregion #region Call Remoting Interface try { IServerObjFactory serverFactory = CallRemotingService.GetRemoteObject(); if (serverFactory != null) { resDS = serverFactory.CreateIEquipmentChangeReasons().UpdateEquipmentChangeReasons(reqDS); } } catch (Exception ex) { MessageService.ShowError(ex); return(false); } finally { CallRemotingService.UnregisterChannel(); } #endregion #region Process Output Parameters string returnMsg = FanHai.Hemera.Share.Common.ReturnMessageUtils.GetServerReturnMessage(resDS); if (string.IsNullOrEmpty(returnMsg)) { return(true); } else { MessageService.ShowError(returnMsg); return(false); } #endregion }
private void LoadEquipmentChangeReasonsData(string equipmentChangeStateKey) { #region Variables DataSet reqDS = new DataSet(); DataSet resDS = new DataSet(); #endregion #region Build Input Parameters if (!string.IsNullOrEmpty(equipmentChangeStateKey)) { DataTable inputParamDataTable = PARAMETERS_INPUT.CreateDataTable(); object inputKey = DBNull.Value; object inputEditor = DBNull.Value; object inputEditTime = DBNull.Value; inputKey = equipmentChangeStateKey; inputParamDataTable.Rows.Add(new object[] { inputKey, inputEditor, inputEditTime }); inputParamDataTable.AcceptChanges(); reqDS.Tables.Add(inputParamDataTable); } #endregion #region Call Remoting Interface try { IServerObjFactory serverFactory = CallRemotingService.GetRemoteObject(); if (serverFactory != null) { resDS = serverFactory.CreateIEquipmentChangeReasons().GetEquipmentChangeReasons(reqDS); } } catch (Exception ex) { MessageService.ShowError(ex); return; } finally { CallRemotingService.UnregisterChannel(); } #endregion #region Process Output Parameters string returnMsg = FanHai.Hemera.Share.Common.ReturnMessageUtils.GetServerReturnMessage(resDS); if (string.IsNullOrEmpty(returnMsg)) { BindDataToChangeReasonsGrid(resDS.Tables[EMS_EQUIPMENT_CHANGE_REASONS_FIELDS.DATABASE_TABLE_NAME]); } else { MessageService.ShowError(returnMsg); } #endregion }