/// <summary> /// 获取设备状态转变原因。 /// </summary> /// <param name="dsParams">包含查询条件的数据集对象。</param> /// <returns>包含设备状态转变原因的数据集对象。</returns> public DataSet GetEquipmentChangeReasons(DataSet dsParams) { DataSet dsReturn = new DataSet(); try { EMS_EQUIPMENT_CHANGE_REASONS_FIELDS equipmentChangeReasonsFields = new EMS_EQUIPMENT_CHANGE_REASONS_FIELDS(); List <string> interestColumns = new List <string>(); interestColumns.Add(EMS_EQUIPMENT_CHANGE_REASONS_FIELDS.FIELD_EQUIPMENT_CHANGE_REASON_KEY); interestColumns.Add(EMS_EQUIPMENT_CHANGE_REASONS_FIELDS.FIELD_EQUIPMENT_CHANGE_REASON_NAME); interestColumns.Add(EMS_EQUIPMENT_CHANGE_REASONS_FIELDS.FIELD_DESCRIPTION); interestColumns.Add(EMS_EQUIPMENT_CHANGE_REASONS_FIELDS.FIELD_EQUIPMENT_CHANGE_STATE_KEY); Conditions conditions = null; if (dsParams != null && dsParams.Tables.Contains(PARAMETERS_INPUT.DATABASE_TABLE_NAME)) { DataTable inputParamDataTable = dsParams.Tables[PARAMETERS_INPUT.DATABASE_TABLE_NAME]; if (inputParamDataTable != null && inputParamDataTable.Columns.Contains(PARAMETERS_INPUT.FIELD_KEY)) { conditions = new Conditions(); foreach (DataRow row in inputParamDataTable.Rows) { object key = row[PARAMETERS_INPUT.FIELD_KEY]; if (key == null || key == DBNull.Value) { conditions.Add(DatabaseLogicOperator.And, EMS_EQUIPMENT_CHANGE_REASONS_FIELDS.FIELD_EQUIPMENT_CHANGE_STATE_KEY, DatabaseCompareOperator.Null, string.Empty); } else { conditions.Add(DatabaseLogicOperator.And, EMS_EQUIPMENT_CHANGE_REASONS_FIELDS.FIELD_EQUIPMENT_CHANGE_STATE_KEY, DatabaseCompareOperator.Equal, key.ToString()); } } } } string sqlString = DatabaseTable.BuildQuerySqlStatement(equipmentChangeReasonsFields, interestColumns, conditions); db.LoadDataSet(CommandType.Text, sqlString, dsReturn, new string[] { EMS_EQUIPMENT_CHANGE_REASONS_FIELDS.DATABASE_TABLE_NAME }); FanHai.Hemera.Share.Common.ReturnMessageUtils.AddServerReturnMessage(dsReturn, string.Empty); } catch (Exception ex) { FanHai.Hemera.Share.Common.ReturnMessageUtils.AddServerReturnMessage(dsReturn, ex.Message); LogService.LogError("GetEquipmentChangeReasons Error: " + ex.Message); } return(dsReturn); }
private void grdViewChangeStates_FocusedRowChanged(object sender, FocusedRowChangedEventArgs e) { if (e.FocusedRowHandle >= 0) { string equipmentChangeStateKey = this.grdViewChangeStates.GetRowCellValue(e.FocusedRowHandle, EMS_EQUIPMENT_CHANGE_STATES_FIELDS.FIELD_EQUIPMENT_CHANGE_STATE_KEY).ToString(); if (!string.IsNullOrEmpty(equipmentChangeStateKey)) { LoadEquipmentChangeReasonsData(equipmentChangeStateKey); } } else { BindDataToChangeReasonsGrid(EMS_EQUIPMENT_CHANGE_REASONS_FIELDS.CreateDataTable()); } }
protected override void InitUIControls() { int index = 0; this.grdViewChangeStates.Columns.Clear(); EMS_EQUIPMENT_CHANGE_STATES_FIELDS equipmentChangeStatesFields = new EMS_EQUIPMENT_CHANGE_STATES_FIELDS(); foreach (KeyValuePair <string, FieldProperties> field in equipmentChangeStatesFields.FIELDS) { GridColumn column = new GridColumn(); column.Name = field.Key; column.FieldName = field.Key; column.Visible = true; column.VisibleIndex = index++; this.grdViewChangeStates.Columns.Add(column); } this.grdViewChangeReasons.Columns.Clear(); EMS_EQUIPMENT_CHANGE_REASONS_FIELDS equipmentChangeReasonsFields = new EMS_EQUIPMENT_CHANGE_REASONS_FIELDS(); index = 0; foreach (KeyValuePair <string, FieldProperties> field in equipmentChangeReasonsFields.FIELDS) { GridColumn column = new GridColumn(); column.Name = field.Key; column.FieldName = field.Key; column.Visible = true; column.VisibleIndex = index++; this.grdViewChangeReasons.Columns.Add(column); } }