/// <summary> /// Get Empty Check List Job Data Table /// </summary> /// <returns></returns> /// Owner:Andy Gao 2011-07-21 08:45:55 private DataTable GetEmptyCheckListJobDataTable() { DataTable dataTable = EMS_CHECKLIST_JOBS_FIELDS.CreateDataTable(true); dataTable.Columns.Add(EMS_CHECKLIST_JOBS_FIELDS.FIELD_PM_NAME); dataTable.Columns.Add(EMS_EQUIPMENTS_FIELDS.FIELD_EQUIPMENT_NAME); dataTable.Columns.Add(EMS_CHECKLIST_FIELDS.FIELD_CHECKLIST_NAME); return(dataTable); }
public override bool Insert() { DataSet reqDS = new DataSet(); DataTable checkListJobsDataTable = EMS_CHECKLIST_JOBS_FIELDS.CreateDataTable(false); Dictionary <string, string> dataRow = new Dictionary <string, string>() { { EMS_CHECKLIST_JOBS_FIELDS.FIELD_CHECKLIST_JOB_KEY, checkListJobKey }, { EMS_CHECKLIST_JOBS_FIELDS.FIELD_CHECKLIST_JOB_NAME, checkListJobName }, { EMS_CHECKLIST_JOBS_FIELDS.FIELD_DESCRIPTION, description }, { EMS_CHECKLIST_JOBS_FIELDS.FIELD_CHECKLIST_JOB_STATE, checkListJobState }, { EMS_CHECKLIST_JOBS_FIELDS.FIELD_EQUIPMENT_KEY, equipmentKey }, { EMS_CHECKLIST_JOBS_FIELDS.FIELD_CHECKLIST_KEY, checkListKey }, { EMS_CHECKLIST_JOBS_FIELDS.FIELD_CREATOR, Creator }, { EMS_CHECKLIST_JOBS_FIELDS.FIELD_CREATE_TIMEZONE_KEY, CreateTimeZone }, { EMS_CHECKLIST_JOBS_FIELDS.FIELD_CREATE_TIME, string.Empty } }; FanHai.Hemera.Utils.Common.Utils.AddKeyValuesToDataTable(ref checkListJobsDataTable, dataRow); checkListJobsDataTable.AcceptChanges(); reqDS.Tables.Add(checkListJobsDataTable); string msg; DataSet resDS = FanHai.Hemera.Utils.Common.Utils.ExecuteEngineMethod("FanHai.Hemera.Modules.EMS.EquipmentCheckListJobsEngine, FanHai.Hemera.Modules.EMS", "InsertCheckListJob", reqDS, out msg); if (string.IsNullOrEmpty(msg)) { CheckListJobName = resDS.ExtendedProperties.ContainsKey(EMS_CHECKLIST_JOBS_FIELDS.FIELD_CHECKLIST_JOB_NAME) ? resDS.ExtendedProperties[EMS_CHECKLIST_JOBS_FIELDS.FIELD_CHECKLIST_JOB_NAME].ToString() : string.Empty; CreateTimeStamp = resDS.ExtendedProperties.ContainsKey(EMS_CHECKLIST_JOBS_FIELDS.FIELD_CREATE_TIMESTAMP) ? resDS.ExtendedProperties[EMS_CHECKLIST_JOBS_FIELDS.FIELD_CREATE_TIMESTAMP].ToString() : string.Empty; CreateTime = resDS.ExtendedProperties.ContainsKey(PARAMETERS.OUTPUT_EDIT_TIME) ? resDS.ExtendedProperties[PARAMETERS.OUTPUT_EDIT_TIME].ToString() : string.Empty; return(true); } else { MessageService.ShowError(msg); return(false); } }
public override bool Update() { DataSet reqDS = new DataSet(); reqDS.ExtendedProperties.Add(PARAMETERS.INPUT_KEY, checkListJobKey); reqDS.ExtendedProperties.Add(PARAMETERS.INPUT_EDITOR, Editor); reqDS.ExtendedProperties.Add(PARAMETERS.INPUT_EDIT_TIME, EditTime); this.DirtyList.Add(EMS_CHECKLIST_JOBS_FIELDS.FIELD_EDIT_TIME, new DirtyItem(EMS_CHECKLIST_JOBS_FIELDS.FIELD_EDIT_TIME, string.Empty, string.Empty)); Editor = PropertyService.Get(PROPERTY_FIELDS.USER_NAME); EditTimeZone = PropertyService.Get(PROPERTY_FIELDS.TIMEZONE); DataTable checkListJobsDataTable = EMS_CHECKLIST_JOBS_FIELDS.CreateDataTable(false); FanHai.Hemera.Utils.Common.Utils.AddKeyValuesToDataTable(ref checkListJobsDataTable, this.DirtyList); checkListJobsDataTable.AcceptChanges(); reqDS.Tables.Add(checkListJobsDataTable); string msg; DataSet resDS = FanHai.Hemera.Utils.Common.Utils.ExecuteEngineMethod("FanHai.Hemera.Modules.EMS.EquipmentCheckListJobsEngine, FanHai.Hemera.Modules.EMS", "UpdateCheckListJob", reqDS, out msg); if (string.IsNullOrEmpty(msg)) { EditTime = resDS.ExtendedProperties.ContainsKey(PARAMETERS.OUTPUT_EDIT_TIME) ? resDS.ExtendedProperties[PARAMETERS.OUTPUT_EDIT_TIME].ToString() : string.Empty; return(true); } else { MessageService.ShowError(msg); return(false); } }