/// <summary> /// Load Equipment Group Data /// </summary> /// <param name="msg"></param> /// <returns></returns> /// Owner:Andy Gao 2011-07-20 13:11:03 public DataTable LoadEquipmentGroupData(out string msg) { #region Call Remoting Interface DataSet reqDS = new DataSet(); DataSet resDS = new DataSet(); try { IServerObjFactory serverFactory = CallRemotingService.GetRemoteObject(); resDS = serverFactory.CreateIEquipmentGroups().GetEquipmentGroups(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_GROUPS_FIELDS.DATABASE_TABLE_NAME]); #endregion }
/// <summary> /// Load Equipment Groups Data /// </summary> private void LoadEquipmentGroupsData() { #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.CreateIEquipmentGroups().GetEquipmentGroups(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)) { BindDataToStatesGrid(resDS.Tables[EMS_EQUIPMENT_GROUPS_FIELDS.DATABASE_TABLE_NAME]); } else { MessageService.ShowError(returnMsg); } #endregion }
public override bool Delete() { #region Variables DataSet reqDS = new DataSet(); DataSet resDS = new DataSet(); #endregion #region Build Input Parameters if (!string.IsNullOrEmpty(equipmentGroupKey)) { DataTable inputParamDataTable = PARAMETERS_INPUT.CreateDataTable(); object inputKey = DBNull.Value; object inputEditor = DBNull.Value; object inputEditTime = DBNull.Value; if (!string.IsNullOrEmpty(equipmentGroupKey)) { inputKey = equipmentGroupKey; } 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.CreateIEquipmentGroups().DeleteEquipmentGroups(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 Update() { #region Variables DataSet reqDS = new DataSet(); DataSet resDS = new DataSet(); #endregion #region Build Input Parameters if (!string.IsNullOrEmpty(equipmentGroupKey)) { DataTable inputParamDataTable = PARAMETERS_INPUT.CreateDataTable(); object inputKey = DBNull.Value; object inputEditor = DBNull.Value; object inputEditTime = DBNull.Value; if (!string.IsNullOrEmpty(equipmentGroupKey)) { inputKey = equipmentGroupKey; } 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 Build Equipment Groups Data this.DirtyList.Add(EMS_EQUIPMENT_GROUPS_FIELDS.FIELD_EDIT_TIME, new DirtyItem(EMS_EQUIPMENT_GROUPS_FIELDS.FIELD_EDIT_TIME, "", "")); Editor = PropertyService.Get(PROPERTY_FIELDS.USER_NAME); EditTimeZone = PropertyService.Get(PROPERTY_FIELDS.TIMEZONE); DataTable equipmentGroupsDataTable = EMS_EQUIPMENT_GROUPS_FIELDS.CreateDataTable(); FanHai.Hemera.Utils.Common.Utils.AddKeyValuesToDataTable(ref equipmentGroupsDataTable, DirtyList); equipmentGroupsDataTable.AcceptChanges(); reqDS.Tables.Add(equipmentGroupsDataTable); #endregion #region Call Remoting Interface try { IServerObjFactory serverFactory = CallRemotingService.GetRemoteObject(); if (serverFactory != null) { resDS = serverFactory.CreateIEquipmentGroups().UpdateEquipmentGroups(reqDS); } } catch (Exception ex) { MessageService.ShowError(ex); return(false); } finally { CallRemotingService.UnregisterChannel(); } #endregion #region Process Output Parameters string outputEditTime = string.Empty; string returnMsg = FanHai.Hemera.Share.Common.ReturnMessageUtils.GetServerReturnMessage(resDS, ref outputEditTime); if (string.IsNullOrEmpty(returnMsg)) { EditTime = outputEditTime; return(true); } else { MessageService.ShowError(returnMsg); return(false); } #endregion }
public override bool Insert() { #region Variables DataSet reqDS = new DataSet(); DataSet resDS = new DataSet(); #endregion #region Build Equipment Groups Data DataTable equipmentGroupsDataTable = EMS_EQUIPMENT_GROUPS_FIELDS.CreateDataTable(); Dictionary <string, string> dataRow = new Dictionary <string, string>() { { EMS_EQUIPMENT_GROUPS_FIELDS.FIELD_EQUIPMENT_GROUP_KEY, equipmentGroupKey }, { EMS_EQUIPMENT_GROUPS_FIELDS.FIELD_EQUIPMENT_GROUP_NAME, equipmentGroupName }, { EMS_EQUIPMENT_GROUPS_FIELDS.FIELD_SPEC, spec }, { EMS_EQUIPMENT_GROUPS_FIELDS.FIELD_DESCRIPTION, description }, { EMS_EQUIPMENT_GROUPS_FIELDS.FIELD_CREATOR, Creator }, { EMS_EQUIPMENT_GROUPS_FIELDS.FIELD_CREATE_TIMEZONE_KEY, CreateTimeZone }, { EMS_EQUIPMENT_GROUPS_FIELDS.FIELD_CREATE_TIME, string.Empty } }; FanHai.Hemera.Utils.Common.Utils.AddKeyValuesToDataTable(ref equipmentGroupsDataTable, dataRow); equipmentGroupsDataTable.AcceptChanges(); reqDS.Tables.Add(equipmentGroupsDataTable); #endregion #region Build Input Parameters if (!string.IsNullOrEmpty(equipmentGroupKey)) { DataTable inputParamDataTable = PARAMETERS_INPUT.CreateDataTable(); object inputKey = DBNull.Value; object inputEditor = DBNull.Value; object inputEditTime = DBNull.Value; if (!string.IsNullOrEmpty(equipmentGroupKey)) { inputKey = equipmentGroupKey; } if (!string.IsNullOrEmpty(Creator)) { inputEditor = Creator; } if (!string.IsNullOrEmpty(CreateTime)) { inputEditTime = CreateTime; } 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.CreateIEquipmentGroups().InsertEquipmentGroups(reqDS); } } catch (Exception ex) { MessageService.ShowError(ex); return(false); } finally { CallRemotingService.UnregisterChannel(); } #endregion #region Process Output Parameters string outputcreateTime = string.Empty; string returnMsg = FanHai.Hemera.Share.Common.ReturnMessageUtils.GetServerReturnMessage(resDS, ref outputcreateTime); if (string.IsNullOrEmpty(returnMsg)) { CreateTime = outputcreateTime; return(true); } else { MessageService.ShowError(returnMsg); return(false); } #endregion }