/// <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);
}
}
