/// <summary>
/// Get Equipment Change States Data Table
/// </summary>
/// <returns></returns>
/// Owner:Andy Gao 2010-07-19 09:10:21
public DataTable GetEquipmentChangeStatesDataTable()
{
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);
equipmentChangeStatesDataTable.AcceptChanges();
}
}
return(equipmentChangeStatesDataTable);
}
/// <summary>
/// 获取设备转变状态数据。
/// </summary>
/// <param name="dsParams">包含查询条件的数据集对象。</param>
/// <returns>包含设备转变状态数据的数据集对象。</returns>
public DataSet GetEquipmentChangeStates(DataSet dsParams)
{
DataSet resDS = new DataSet();
try
{
EMS_EQUIPMENT_CHANGE_STATES_FIELDS equipmentChangeStatesFields = new EMS_EQUIPMENT_CHANGE_STATES_FIELDS();
List <string> interestColumns = new List <string>();
interestColumns.Add(EMS_EQUIPMENT_CHANGE_STATES_FIELDS.FIELD_EQUIPMENT_CHANGE_STATE_KEY);
interestColumns.Add(EMS_EQUIPMENT_CHANGE_STATES_FIELDS.FIELD_EQUIPMENT_CHANGE_STATE_NAME);
interestColumns.Add(EMS_EQUIPMENT_CHANGE_STATES_FIELDS.FIELD_DESCRIPTION);
interestColumns.Add(EMS_EQUIPMENT_CHANGE_STATES_FIELDS.FIELD_EQUIPMENT_FROM_STATE_KEY);
interestColumns.Add(EMS_EQUIPMENT_CHANGE_STATES_FIELDS.FIELD_EQUIPMENT_TO_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_STATES_FIELDS.FIELD_EQUIPMENT_CHANGE_STATE_KEY, DatabaseCompareOperator.Null, string.Empty);
}
else
{
conditions.Add(DatabaseLogicOperator.And, EMS_EQUIPMENT_CHANGE_STATES_FIELDS.FIELD_EQUIPMENT_CHANGE_STATE_KEY, DatabaseCompareOperator.Equal, key.ToString());
}
}
}
}
string sqlString = DatabaseTable.BuildQuerySqlStatement(equipmentChangeStatesFields, interestColumns, conditions);
db.LoadDataSet(CommandType.Text, sqlString, resDS, new string[] { EMS_EQUIPMENT_CHANGE_STATES_FIELDS.DATABASE_TABLE_NAME });
FanHai.Hemera.Share.Common.ReturnMessageUtils.AddServerReturnMessage(resDS, string.Empty);
}
catch (Exception ex)
{
FanHai.Hemera.Share.Common.ReturnMessageUtils.AddServerReturnMessage(resDS, ex.Message);
LogService.LogError("GetEquipmentChangeStates Error: " + ex.Message);
}
return(resDS);
}
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);
}
}
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
}
/// <summary>
/// 删除设备状态。
/// </summary>
/// <param name="dsParams">包含删除条件的数据集对象。</param>
/// <returns>包含执行结果的数据集对象。</returns>
public DataSet DeleteEquipmentStates(DataSet dsParams)
{
DataSet dsReturn = new DataSet();
try
{
if (dsParams != null && dsParams.Tables.Contains(PARAMETERS_INPUT.DATABASE_TABLE_NAME))
{
DataTable inputParamDataTable = dsParams.Tables[PARAMETERS_INPUT.DATABASE_TABLE_NAME];
#region Build Conditions List
List <Conditions> conditionsList = new List <Conditions>();
foreach (DataRow row in inputParamDataTable.Rows)
{
Conditions conditions = new Conditions();
Condition keyCondition;
if (row[PARAMETERS_INPUT.FIELD_KEY] != null && row[PARAMETERS_INPUT.FIELD_KEY] != DBNull.Value)
{
keyCondition = new Condition(DatabaseLogicOperator.And, EMS_EQUIPMENT_STATES_FIELDS.FIELD_EQUIPMENT_STATE_KEY,
DatabaseCompareOperator.Equal, row[PARAMETERS_INPUT.FIELD_KEY].ToString());
}
else
{
keyCondition = new Condition(DatabaseLogicOperator.And, EMS_EQUIPMENT_STATES_FIELDS.FIELD_EQUIPMENT_STATE_KEY,
DatabaseCompareOperator.Null, string.Empty);
}
conditions.Add(keyCondition);
Condition editorCondition;
if (row[PARAMETERS_INPUT.FIELD_EDITOR] != null && row[PARAMETERS_INPUT.FIELD_EDITOR] != DBNull.Value)
{
editorCondition = new Condition(DatabaseLogicOperator.And, EMS_EQUIPMENT_STATES_FIELDS.FIELD_EDITOR,
DatabaseCompareOperator.Equal, row[PARAMETERS_INPUT.FIELD_EDITOR].ToString());
}
else
{
editorCondition = new Condition(DatabaseLogicOperator.And, EMS_EQUIPMENT_STATES_FIELDS.FIELD_EDITOR,
DatabaseCompareOperator.Null, string.Empty);
}
conditions.Add(editorCondition);
Condition editTimeCondition;
if (row[PARAMETERS_INPUT.FIELD_EDIT_TIME] != null && row[PARAMETERS_INPUT.FIELD_EDIT_TIME] != DBNull.Value)
{
editTimeCondition = new Condition(DatabaseLogicOperator.And, EMS_EQUIPMENT_STATES_FIELDS.FIELD_EDIT_TIME,
DatabaseCompareOperator.Equal, row[PARAMETERS_INPUT.FIELD_EDIT_TIME].ToString());
}
else
{
editTimeCondition = new Condition(DatabaseLogicOperator.And, EMS_EQUIPMENT_STATES_FIELDS.FIELD_EDIT_TIME,
DatabaseCompareOperator.Null, string.Empty);
}
conditions.Add(editTimeCondition);
conditionsList.Add(conditions);
}
#endregion
EMS_EQUIPMENT_STATES_FIELDS equipmentStatesFields = new EMS_EQUIPMENT_STATES_FIELDS();
List <string> sqlStringList = DatabaseTable.BuildDeleteSqlStatements(equipmentStatesFields, conditionsList);
string sqlString = string.Empty;
if (sqlStringList.Count > 0)
{
sqlString = sqlStringList[0];
}
#region Check Equipment Change States Reference
string equipmentStateKey = inputParamDataTable.Rows[0][PARAMETERS_INPUT.FIELD_KEY].ToString();
Conditions checkConditions = new Conditions();
checkConditions.Add(DatabaseLogicOperator.And, EMS_EQUIPMENT_CHANGE_STATES_FIELDS.FIELD_EQUIPMENT_FROM_STATE_KEY, DatabaseCompareOperator.Equal, equipmentStateKey);
checkConditions.Add(DatabaseLogicOperator.Or, EMS_EQUIPMENT_CHANGE_STATES_FIELDS.FIELD_EQUIPMENT_TO_STATE_KEY, DatabaseCompareOperator.Equal, equipmentStateKey);
EMS_EQUIPMENT_CHANGE_STATES_FIELDS equipmentChangeStatesFields = new EMS_EQUIPMENT_CHANGE_STATES_FIELDS();
List <string> interestColumns = new List <string>()
{
EMS_EQUIPMENT_CHANGE_STATES_FIELDS.FIELD_EQUIPMENT_CHANGE_STATE_KEY
};
string checkSqlString = DatabaseTable.BuildQuerySqlStatement(equipmentChangeStatesFields, interestColumns, checkConditions);
object scalar = db.ExecuteScalar(CommandType.Text, checkSqlString);
if (scalar != null && scalar != DBNull.Value)
{
throw new Exception("${res:FanHai.Hemera.Modules.EMS.EquipmentStates.M0002}");
}
#endregion
if (db.ExecuteNonQuery(CommandType.Text, sqlString) > 0)
{
FanHai.Hemera.Share.Common.ReturnMessageUtils.AddServerReturnMessage(dsReturn, string.Empty);
}
else
{
throw new Exception("${res:FanHai.Hemera.Module.Common.M0002}");
}
}
else
{
FanHai.Hemera.Share.Common.ReturnMessageUtils.AddServerReturnMessage(dsReturn, "${res:FanHai.Hemera.Module.Common.M0001}");
}
}
catch (Exception ex)
{
FanHai.Hemera.Share.Common.ReturnMessageUtils.AddServerReturnMessage(dsReturn, ex.Message);
LogService.LogError("DeleteEquipmentStates Error: " + ex.Message);
}
return(dsReturn);
}
