/// <summary> /// Load Equipment Change State Data /// </summary> /// <param name="equipmentChangeStateKey"></param> /// <param name="msg"></param> /// <returns></returns> /// Owner:Andy Gao 2011-08-25 17:56:52 public DataTable LoadEquipmentChangeStateData(string equipmentChangeStateKey, out string msg) { #region Call Remoting Interface DataSet reqDS = new DataSet(); DataSet resDS = new DataSet(); try { IServerObjFactory serverFactory = CallRemotingService.GetRemoteObject(); resDS = serverFactory.CreateIEquipmentChangeStates().GetEquipmentChangeStates(equipmentChangeStateKey); } 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_STATES_FIELDS.DATABASE_TABLE_NAME]);; #endregion }
/// <summary> /// Load Equipment Change States Data /// </summary> /// Owner:Andy Gao 2010-07-16 10:02:36 private void LoadEquipmentChangeStatesData() { #region Variables DataSet reqDS = new DataSet(); DataSet resDS = new DataSet(); #endregion #region Call Remoting Interface try { IServerObjFactory serverFactory = CallRemotingService.GetRemoteObject(); if (serverFactory != null) { resDS = serverFactory.CreateIEquipmentChangeStates().GetEquipmentChangeStates(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)) { BindDataToChangeStatesGrid(resDS.Tables[EMS_EQUIPMENT_CHANGE_STATES_FIELDS.DATABASE_TABLE_NAME]); } else { MessageService.ShowError(returnMsg); } #endregion }
/// <summary> /// Load Equipment Change State Data /// </summary> /// <param name="msg"></param> /// <returns></returns> /// Owner:Andy Gao 2011-08-03 14:48:24 public DataTable LoadEquipmentChangeStateData(out string msg) { #region Call Remoting Interface DataSet reqDS = new DataSet(); DataSet resDS = new DataSet(); try { IServerObjFactory serverFactory = CallRemotingService.GetRemoteObject(); resDS = serverFactory.CreateIEquipmentChangeStates().GetEquipmentChangeStates(reqDS); } catch (Exception ex) { msg = ex.Message; return(null); } finally { CallRemotingService.UnregisterChannel(); } msg = FanHai.Hemera.Share.Common.ReturnMessageUtils.GetServerReturnMessage(resDS); DataTable dataTable = resDS.Tables[EMS_EQUIPMENT_CHANGE_STATES_FIELDS.DATABASE_TABLE_NAME]; foreach (DataRow dataRow in dataTable.Rows) { //Equipment State 420EFAD0-CA7E-452b-8400-3F3863736152-000 is IDLE //Equipment State 3B78582E-136D-46d3-A7FE-D2EA3B5DC645-000 is Running if ((dataRow[EMS_EQUIPMENT_CHANGE_STATES_FIELDS.FIELD_EQUIPMENT_FROM_STATE_KEY].ToString() != "420EFAD0-CA7E-452b-8400-3F3863736152-000") || (dataRow[EMS_EQUIPMENT_CHANGE_STATES_FIELDS.FIELD_EQUIPMENT_TO_STATE_KEY].ToString() == "3B78582E-136D-46d3-A7FE-D2EA3B5DC645-000")) { dataRow.Delete(); } } dataTable.AcceptChanges(); return(dataTable); #endregion }
/// <summary> /// Update Equipment Change States Data For Update The Description /// </summary> /// <returns></returns> /// Owner:Andy Gao 2010-07-20 15:12:47 private bool UpdateEquipmentChangeStatesData() { #region Variables DataSet reqDS = new DataSet(); DataSet resDS = new DataSet(); #endregion #region Build Equipment Change States Data if (this.grdChangeStates.DataSource != null && this.grdChangeStates.DataSource is DataTable) { DataTable equipmentChangeStatesDataTalbe = (DataTable)this.grdChangeStates.DataSource; DataTable modifiedDataTable = equipmentChangeStatesDataTalbe.GetChanges(DataRowState.Modified); if (modifiedDataTable != null && modifiedDataTable.Rows.Count > 0) { equipmentChangeStatesDataTalbe.TableName = EMS_EQUIPMENT_CHANGE_STATES_FIELDS.DATABASE_TABLE_NAME; reqDS.Tables.Add(equipmentChangeStatesDataTalbe.Copy()); } else { return(true); } } #endregion #region Call Remoting Interface try { IServerObjFactory serverFactory = CallRemotingService.GetRemoteObject(); if (serverFactory != null) { resDS = serverFactory.CreateIEquipmentChangeStates().UpdateEquipmentChangeStates(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 }
public bool Save() { #region Variables DataSet reqDS = new DataSet(); DataSet resDS = new DataSet(); #endregion #region Build Equipment Change States Data DataTable equipmentChangeStatesDataTable = EMS_EQUIPMENT_CHANGE_STATES_FIELDS.CreateDataTable(); foreach (EquipmentChangeStateEntity equipmentChangeStateEntity in equipmentChangeStateList) { if (equipmentChangeStateEntity.EntityState != EntityState.None) { Dictionary <string, string> dataRow = new Dictionary <string, string>() { { EMS_EQUIPMENT_CHANGE_STATES_FIELDS.FIELD_EQUIPMENT_CHANGE_STATE_KEY, equipmentChangeStateEntity.EquipmentChangeStateKey }, { EMS_EQUIPMENT_CHANGE_STATES_FIELDS.FIELD_EQUIPMENT_CHANGE_STATE_NAME, equipmentChangeStateEntity.EquipmentChangeStateName }, { EMS_EQUIPMENT_CHANGE_STATES_FIELDS.FIELD_DESCRIPTION, equipmentChangeStateEntity.Description }, { EMS_EQUIPMENT_CHANGE_STATES_FIELDS.FIELD_EQUIPMENT_FROM_STATE_KEY, equipmentChangeStateEntity.EquipmentFromStateKey }, { EMS_EQUIPMENT_CHANGE_STATES_FIELDS.FIELD_EQUIPMENT_TO_STATE_KEY, equipmentChangeStateEntity.EquipmentToStateKey } }; FanHai.Hemera.Utils.Common.Utils.AddKeyValuesToDataTable(ref equipmentChangeStatesDataTable, dataRow); if (equipmentChangeStateEntity.EntityState == EntityState.Added) { equipmentChangeStatesDataTable.Rows[equipmentChangeStatesDataTable.Rows.Count - 1].AcceptChanges(); equipmentChangeStatesDataTable.Rows[equipmentChangeStatesDataTable.Rows.Count - 1].SetAdded(); } else if (equipmentChangeStateEntity.EntityState == EntityState.Deleted) { equipmentChangeStatesDataTable.Rows[equipmentChangeStatesDataTable.Rows.Count - 1].AcceptChanges(); equipmentChangeStatesDataTable.Rows[equipmentChangeStatesDataTable.Rows.Count - 1].Delete(); } } } reqDS.Tables.Add(equipmentChangeStatesDataTable); #endregion #region Call Remoting Interface try { IServerObjFactory serverFactory = CallRemotingService.GetRemoteObject(); if (serverFactory != null) { resDS = serverFactory.CreateIEquipmentChangeStates().UpdateEquipmentChangeStates(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 }
public override bool Load() { #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; if (!string.IsNullOrEmpty(equipmentChangeStateKey)) { inputKey = equipmentChangeStateKey; } if (!string.IsNullOrEmpty(Editor)) { inputEditor = Editor; } if (!string.IsNullOrEmpty(EditTime)) { inputEditTime = EditTime; } 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.CreateIEquipmentChangeStates().GetEquipmentChangeStates(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)) { SetEquipmentChangeStateEntityProperties(resDS.Tables[EMS_EQUIPMENT_CHANGE_STATES_FIELDS.DATABASE_TABLE_NAME]); return(true); } else { MessageService.ShowError(returnMsg); return(false); } #endregion }