/// <summary> /// Загрузить настройки роли для активной формы /// </summary> private void LoadRolesForActiveForm() { if (lueRoles.EditValue == null || ActiveForm == null) { return; } HighlightControl.IsPaint = false; bbiSave.Enabled = true; bbiDefault.Enabled = true; bbiRestore.Enabled = true; try { var name = ActiveForm.Name; tlControls.DataSource = ActiveForm.GetDataTableControl(); //Обновим форму до первоначальных настроек var xml = DBAppContext.RolesRule_GetFormXML(name, (int)lueRoles.EditValue); ActiveForm.LoadAllControlsState(xml); isChangedProperty = false; } catch (Exception ex) { DBException.WriteLog(ex); } finally { HighlightControl.IsPaint = true; } }
/// <summary>プロジェクトの異常処理</summary> void App_DispatcherUnhandledException(object sender, DispatcherUnhandledExceptionEventArgs e) { if (e.Exception is DBException) { DBException ex = (DBException)e.Exception; LogInfo.WriteErrorLog(ex.MessageID, ex); LogInfo.WriteFatalLog(ex.InnerException); CommonDialog.ShowErrorDialog(ex.MessageID); } else if (e.Exception is FileException) { FileException ex = (FileException)e.Exception; LogInfo.WriteErrorLog(ex.MessageID, ex.InnerException); CommonDialog.ShowErrorDialog(ex.MessageID); } else if (e.Exception is BaseException) { BaseException ex = (BaseException)e.Exception; LogInfo.WriteErrorLog(ex.MessageID, ex.InnerException); CommonDialog.ShowErrorDialog(ex.MessageID); } else { LogInfo.WriteErrorLog(Consts.SYSERR_003, e.Exception); CommonDialog.ShowErrorDialog(Consts.SYSERR_003); } e.Handled = true; }
private void LogException(Exception exception) { try { SqlUtilities sqlHelper = new SqlUtilities(new SqlConnection(ConfigurationManager.AppSettings["DSConnectionString"])); sqlHelper.LogExceptionToDB(LogType.WindowsService, exception.Message, exception.StackTrace); } catch (Exception DBException) { try { LoggerService.LogError("DBException: " + DBException.ToString() + Environment.NewLine); } catch { } } try { LoggerService.LogError("Exception: " + exception.ToString()); } catch (Exception LoggerException) { try { SqlUtilities sqlHelper = new SqlUtilities(new SqlConnection(ConfigurationManager.AppSettings["DSConnectionString"])); sqlHelper.LogExceptionToDB(LogType.WindowsService, LoggerException.Message, LoggerException.StackTrace); } catch { } } }
void CurrentDomain_UnhandledException(object sender, UnhandledExceptionEventArgs e) { MessageBoxResult result; Exception exception = (Exception)e.ExceptionObject; if (exception is DBException) { DBException ex = (DBException)exception; LogInfo.WriteErrorLog(ex.MessageID, ex); LogInfo.WriteFatalLog(ex.InnerException); result = CommonDialog.ShowErrorDialog(ex.MessageID); } else if (exception is FileException) { FileException ex = (FileException)exception; LogInfo.WriteErrorLog(ex.MessageID, ex.InnerException); result = CommonDialog.ShowErrorDialog(ex.MessageID); } else if (exception is BaseException) { BaseException ex = (BaseException)exception; LogInfo.WriteErrorLog(ex.MessageID, ex.InnerException); result = CommonDialog.ShowErrorDialog(ex.MessageID); } else { LogInfo.WriteErrorLog(Consts.SYSERR_003, exception); result = CommonDialog.ShowErrorDialog(Consts.SYSERR_003); } if (result == MessageBoxResult.OK) { Environment.Exit(ERROR_EXIT_CODE); } }
/// <summary> /// Добавление выбранных в CheckedComboBox пользователей к текущей роли /// </summary> private void UsersEditValueChanged(object sender, EventArgs e) { if (string.IsNullOrEmpty(riccbeUsers.GetCheckedItems().ToString())) { return; } var query = riccbeUsers.Items.Cast <CheckedListBoxItem>() .Where(t => t.CheckState == CheckState.Checked) .Select(i => (int)i.Value) .SelectMany(pId => DBAppContext.Where <User>(p => p.Id == pId)) .ToList(); cgvUsers.BeginDataUpdate(); try { foreach (var user in query) { CurrentRole.Users.Add(user); bsRoleUsers.Add(user); } } catch (Exception ex) { DBException.WriteLog(ex); } finally { cgvUsers.EndDataUpdate(); } }
/// <summary> /// Загрузить настройки внешнего вида для формы /// </summary> /// <param name="form">форма</param> /// <param name="xml">Xml с настройками внешнего вида формы</param> public static void DefaultFormState_InsertUpdate(this Form form, string xml) { using (var dbAdmin = new ApplicationEntitie(0)) { try { if (!dbAdmin.DefaultFormStates.Any(f => f.FormName == form.Name)) { var defauleRule = new DefaultFormState { FormName = form.Name, DefaultXml = xml }; dbAdmin.DefaultFormStates.Add(defauleRule); } else { dbAdmin.DefaultFormStates.First(f => f.FormName == form.Name) .DefaultXml = xml; } dbAdmin.SaveChanges(); } catch (Exception ex) { DBException.WriteLog(ex); } } }
private void AdminToolShown(object sender, EventArgs e) { try { Focus(); //Загружаем список всех ролей в выпадающий список #if DEBUG lueRoles.Properties.DataSource = DBAppContext.Roles_SelectAll(); #else lueRoles.Properties.DataSource = DBAppContext.Roles_SelectAll() .Where(r => !r.IsAdmin) .ToArray(); #endif } catch (Exception ex) { DBException.WriteLog(ex); } finally { Cursor = Cursors.Default; } MessageWindow.GetInstance(@"Выберите роль для загрузки настроек", MessageType.Info); CloseWaitForm(); }
/// <summary> /// Создать новую зависимую форму /// </summary> /// <param name="args">Параметры, передаваемые на форму</param> public T CreateChildForm <T>(params object[] args) where T : class { Application.DoEvents(); var type = typeof(T); try { var f = MdiChildren.FirstOrDefault(a => a.Name == type.Name); if (f == null) { f = (Form)Activator.CreateInstance(type, args); f.MdiParent = this; } f.Show(); f.Activate(); return(f as T); } catch (Exception ex) { MessageBox.Show(@"Неожиданное поведение при загрузке формы, данные о ней отправлены программистам.", @"Сообщение отправлено программистам", MessageBoxButtons.OK, MessageBoxIcon.Error); DBException.WriteLog(ex); } return(null); }
public void DBExceptionConstructorTest1() { const string message = "Testmessage"; DBException target = new DBException(message); Assert.IsNotNull(target, "DBException Object created."); Assert.AreEqual(message, target.Message, "Messages are equal."); }
public void DBExceptionConstructorTest2() { const string message = "Testmessage"; Exception innnerException = new Exception("Inner exception"); DBException target = new DBException(message, innnerException); Assert.IsNotNull(target, "DBException Object created."); Assert.AreEqual(message, target.Message, "Messages are equal."); Assert.AreSame(innnerException, target.InnerException, "Inner exception equal."); }
private void Login() { // Oppretter database-objekt Database db = new Database(); try { db.OpenConnection(); string query = "SELECT passord FROM formlogin WHERE bruker = @Brukernavn;"; var mySqlCommand = db.SqlCommand(query); // Hindrer SQL-injection mySqlCommand.Parameters.AddWithValue("@Brukernavn", Username.Text); // Bruker ExecuteReader-metoden til å returnere resulatet til MySqlDataReader-objektet MySqlDataReader reader = mySqlCommand.ExecuteReader(); // Sjekker om det finnes rader if (!reader.HasRows) { HelpText.Text = "Brukernavnet eller passordet er feil!"; } else { Hasher hash = new Hasher(); string hashpw = ""; while (reader.Read()) { hashpw = reader.GetString("passord"); } // Sjekker om passordet er riktig if (!hash.SjekkHash(Password.Text, hashpw)) { HelpText.Text = "Feil passord!"; } else { UserInfo.Username = Username.Text; DialogResult = DialogResult.OK; this.Dispose(); } } // Stenger MySqlDataReader-objektet reader.Close(); // Stenger databasetilgangen db.CloseConnection(); } catch (MySqlException DBException) { /* * Under testing og debugging av prototypen skriver vi til konsollen. * Kan bytte til å skrive til feilmelding label når vi nærmer oss et produkt */ Console.WriteLine(DBException.ToString()); } }
/// <summary> /// Загрузить настройки внешнего вида для формы /// </summary> /// <param name="form">форма</param> public static void LoadFormsControlsBeforeShow(this Form form) { try { form.DefaultFormState_InsertUpdate(form.SaveXmlFormRule()); form.LoadLastFormSettings(); } catch (Exception ex) { DBException.WriteLog(ex); } }
public void DBExceptionSerializeTest() { const string message = "Error Serial test DBException"; DBException testException = new DBException(message); const string fileName = "Exception.test"; Assert.IsTrue(Serializer.Serialize(fileName, testException), "Serialized"); DBException result = (Serializer.Deserialize <DBException>(fileName)); Assert.IsInstanceOfType(result, typeof(DBException), "Deserialized"); Assert.IsTrue(message.Equals(result.ExceptionMessage), "Exception message equal"); }
/// <summary> /// Загрузить последние настройки интерфейса для формы /// </summary> /// <param name="form">форма</param> public static void LoadLastFormSettings(this Form form) { try { var xmlSettings = form.RolesRule_Load_FormName(); form.SetXmlSettings(xmlSettings); form.LoadAllControlsState(xmlSettings); } catch (Exception ex) { DBException.WriteLog(ex); } }
/// <summary> /// Удалить выделенного пользователя из роли /// </summary> private void DeleteUserFromRole(params object[] objects) { try { foreach (var user in objects.Cast <User>()) { CurrentRole.Users.Remove(user); } } catch (Exception ex) { DBException.WriteLog(ex); } }
public static void Add(this ApplicationEntitie db, object entity) { try { if (db.Entry(entity).State != EntityState.Added) { db.Entry(entity).State = EntityState.Added; } } catch (Exception e) { DBException.WriteLog(e); } }
public virtual bool SaveChanges(bool showMsg = true) { try { this.CommitFormsChanges(); DBAppContext.SaveChanges(); if (showMsg) { MessageWindow.GetInstance("Изменения успешно сохранены.", MessageType.Info); } } catch (SqlException e) { var msg = e.Message.GetUserMessageByErrorMessage(); if (msg.IsEmptyAfterTrim()) { DBException.WriteLog(e); } else { XtraMessageBox.Show(this, msg, @"Операция отменена", MessageBoxButtons.OK, MessageBoxIcon.Error); } return(false); } catch (DbUpdateException e) { var inner = e.InnerException; while (inner.InnerException != null) { inner = inner.InnerException; } var msg = inner.Message.GetUserMessageByErrorMessage(); if (msg.IsEmptyAfterTrim()) { DBException.WriteLog(e); } else { XtraMessageBox.Show(this, msg, @"Операция отменена", MessageBoxButtons.OK, MessageBoxIcon.Error); } return(false); } catch (Exception e) { MessageWindow.GetInstance("Произошла ошибка при обновлении информации в базе данных. Операция отменена."); DBException.WriteLog(e); return(false); } return(true); }
/// <summary> /// Загрузить свойства объекта из xml /// </summary> /// <param name="instance">Элемент управления</param> /// <param name="xml">Xml c настройками</param> /// <param name="name">Название компонента</param> public static void PropertyFromXml(this object instance, XmlDocument xml, string name = null) { if (xml == null) { return; } if (name == null) { name = instance.GetType() .GetProperty("Name") .GetValue(instance, null) .ToString(); } foreach (var xmlNode in xml.GetElementsByTagName(name) .Cast <XmlNode>() .Where(node => node != null)) { var properties = instance.GetType() .GetProperties(); foreach (var property in properties) { try { var visiblePropertie = MainSettings.GetPropertie(property.Name); if (visiblePropertie == null || xmlNode[property.Name] == null) { continue; } if (visiblePropertie.IsComplex) { var xmldoc = new XmlDocument(); xmldoc.LoadXml(xmlNode.OuterXml); property.GetValue(instance, null).PropertyFromXml(xmldoc, property.Name); } else { var typeConverter = TypeDescriptor.GetConverter(property.PropertyType); var value = typeConverter.ConvertFromString(xmlNode[property.Name].InnerText); property.SetValue(instance, value, null); } } catch (Exception ex) { DBException.WriteLog(ex); } } } }
public static void Remove(this ApplicationEntitie db, object entity) { try { if (db.Entry(entity).State == EntityState.Added) { db.Entry(entity).State = EntityState.Detached; } else if (db.Entry(entity).State != EntityState.Deleted) { db.Entry(entity).State = EntityState.Deleted; } } catch (Exception e) { DBException.WriteLog(e); } }
public override void RefreshData() { base.RefreshData(); ShowWaitForm(); try { bsUser.DataSource = DBAppContext.Users_SelectAll(); bsRole.DataSource = DBAppContext.Roles_SelectAll_IncludeUsers(); } catch (Exception ex) { DBException.WriteLog(ex); } finally { CloseWaitForm(); } }
/// <summary> /// Загрузить настройки для данной формы /// </summary> /// <param name="form">настраиваемая форма</param> /// <param name="xmlStrings">xml-и с настройками для формы</param> private static void LoadAllControlsState(this Control form, ICollection <string> xmlStrings) { if (xmlStrings.Count == 0) { return; } try { var xmlResult = XmlDocumentFromStrinList(xmlStrings); foreach (Control c in form.Controls) { c.GetControlTuner() .TuneControl(c, xmlResult); } } catch (Exception e) { DBException.WriteLog(e); } }
private void AdminToolFormClosed(object sender, FormClosedEventArgs e) { DBUser.DesignMode = false; HighlightControl.CloseForm(); Instance = null; //Возвращаем размеры и расположение главной формы в начальное положение FormControls.MainForm.Size = parentBound.Size; FormControls.MainForm.Location = parentBound.Location; FormControls.MainForm.WindowState = parentState; //Обновляем информацию в базе данных о созданных правилах для форм try { FormControls.MainForm.LoadLastFormSettings(); } catch (Exception ex) { DBException.WriteLog(ex); } }
public void refresh(object sender, EventArgs e) { /* added by YAMA 2014/12/09 V2.1.0 No23 対応 */ DBException dbEx = _dbAccess.exExecuteHealthCheck(); if (dbEx.MessageID.Equals("")) { FillTables(_innerJobnetId); ResetColor(); ResetToolTip(); } else { if (_isDb) { _isDb = false; LogInfo.WriteErrorLog(Consts.SYSERR_001, dbEx.InnerException); CommonDialog.ShowErrorDialog(Consts.SYSERR_001); } } //FillTables(_innerJobnetId); //ResetColor(); //ResetToolTip(); }
public void DBExceptionConstructorTest() { DBException target = new DBException(); Assert.IsNotNull(target, "DBException Object created."); }
private void LagBrukerBtn_Click(object sender, EventArgs e) { Database db = new Database(); if (Brukernavn.Text == "" || fornavn.Text == "" || etternavn.Text == "" || Passord.Text == "" || Passord2.Text == "") { // Setter rød farge på de boksene som ikke oppflyer kravene foreach (Control c in Controls) { if (c is TextBox) { //Sjekker om en eller flere tekstboker er tomme. if (c.Text == "") { c.BackColor = Color.Red; Feilmelding.Text = "Alle felt må fylles ut!"; Feilmelding.Show(); } } } } // Sjekker om passordene er like else if (Passord.Text != Passord2.Text) { Feilmelding.Text = "Passordene må være like!"; Feilmelding.Show(); Passord2.BackColor = Color.Red; } else { try { Feilmelding.Hide(); db.OpenConnection(); string query = "SELECT bruker FROM formlogin WHERE bruker = @Brukernavn;"; var mySqlCommand = db.SqlCommand(query); mySqlCommand.Parameters.AddWithValue("@Brukernavn", Brukernavn.Text); MySqlDataReader reader = mySqlCommand.ExecuteReader(); // Sjekker om brukeren finnes i databasen fra før av. if (reader.HasRows) { Feilmelding.Text = "Brukeren finnes allerede!"; Feilmelding.Show(); Brukernavn.BackColor = Color.Red; db.CloseConnection(); } // Hvis ikke skal dataen lagres og opprette en ny bruker. else { // Objekt for hashing av passord. Hasher hasher = new Hasher(); // Hasher passordet og lagrer det i en streng. string hash = hasher.PassordHasher(Passord.Text); db.OpenConnection(); query = "INSERT INTO formlogin (bruker, passord, fornavn, etternavn, brukertype) VALUES (@Brukernavn, @Passord, @Fornavn, @Etternavn, 2);"; var mySqlCommandInsert = db.SqlCommand(query); // Hinderer SQL-injection. mySqlCommandInsert.Parameters.AddWithValue("@Brukernavn", Brukernavn.Text); mySqlCommandInsert.Parameters.AddWithValue("@Passord", hash); mySqlCommandInsert.Parameters.AddWithValue("@Fornavn", fornavn.Text); mySqlCommandInsert.Parameters.AddWithValue("@Etternavn", etternavn.Text); int resultat = mySqlCommandInsert.ExecuteNonQuery(); if (resultat < 0) { Console.WriteLine("Noe gikk galt! Kunne ikke legge til data i databasen!"); } db.CloseConnection(); // Oppdaterer formen med å gjemme bort unødvendige labels og tekstbokser. nyBrukerLbl.Hide(); BrukernavnLbl.Hide(); Brukernavn.Hide(); fornavn.Hide(); fornavnLbl.Hide(); etternavn.Hide(); etternavnLbl.Hide(); nyttPassordLbl.Hide(); Passord.Hide(); nyttPassordLbl2.Hide(); Passord2.Hide(); LagBrukerBtn.Hide(); AvsluttBtn.Hide(); Feilmelding.Hide(); nyBrukerLogginn.Show(); opprettetLbl.Show(); } } catch (MySqlException DBException) { /* * Under testing og debugging av prototypen skriver vi til konsollen. * Kan bytte til å skrive til feilmelding label når vi nærmer oss et produkt */ Console.WriteLine(DBException.ToString()); } } }
//******************************************************************* /// <summary> 実行ジョブネットデータの検索(編集、コピー新規用)</summary> /// <param name="innerJobnetId">`実行ジョブネットID</param> /// <param name="updDate">`更新日</param> //******************************************************************* private void FillTables(string innerJobnetId) { /* added by YAMA 2014/12/09 V2.1.0 No23 対応 */ DBException dbEx = _dbAccess.exExecuteHealthCheck(); if (dbEx.MessageID.Equals("")) { RunJobnetSummaryTable = _runJobnetSummaryDAO.GetEntityByPk(innerJobnetId); if (RunJobnetSummaryTable.Rows.Count > 0) { JobnetRunStatus = (RunJobStatusType)RunJobnetSummaryTable.Rows[0]["status"]; } // 実行ジョブネット管理テーブル container.JobnetControlTable = _runJobnetDAO.GetEntityByPk(innerJobnetId); } else { if (_isDb) { _isDb = false; LogInfo.WriteErrorLog(Consts.SYSERR_001, dbEx.InnerException); CommonDialog.ShowErrorDialog(Consts.SYSERR_001); } } dbEx = _dbAccess.exExecuteHealthCheck(); if (dbEx.MessageID.Equals("")) { // 実行ジョブ管理テーブル container.JobControlTable = null; container.JobControlTable = _runJobControlDAO.GetEntityByJobnet(innerJobnetId); } else { if (_isDb) { _isDb = false; LogInfo.WriteErrorLog(Consts.SYSERR_001, dbEx.InnerException); CommonDialog.ShowErrorDialog(Consts.SYSERR_001); } } dbEx = _dbAccess.exExecuteHealthCheck(); if (dbEx.MessageID.Equals("")) { // フロー管理テーブル container.FlowControlTable = _runFlowControlDAO.GetEntityByJobnet(innerJobnetId); } else { if (_isDb) { _isDb = false; LogInfo.WriteErrorLog(Consts.SYSERR_001, dbEx.InnerException); CommonDialog.ShowErrorDialog(Consts.SYSERR_001); } } dbEx = _dbAccess.exExecuteHealthCheck(); if (dbEx.MessageID.Equals("")) { // 計算アイコン設定テーブル container.IconCalcTable = _runIconCalcDAO.GetEntityByJobnet(innerJobnetId); } else { if (_isDb) { _isDb = false; LogInfo.WriteErrorLog(Consts.SYSERR_001, dbEx.InnerException); CommonDialog.ShowErrorDialog(Consts.SYSERR_001); } } dbEx = _dbAccess.exExecuteHealthCheck(); if (dbEx.MessageID.Equals("")) { // 終了アイコン設定テーブル container.IconEndTable = _runIconEndDAO.GetEntityByJobnet(innerJobnetId); } else { if (_isDb) { _isDb = false; LogInfo.WriteErrorLog(Consts.SYSERR_001, dbEx.InnerException); CommonDialog.ShowErrorDialog(Consts.SYSERR_001); } } dbEx = _dbAccess.exExecuteHealthCheck(); if (dbEx.MessageID.Equals("")) { // 拡張実行ジョブアイコン設定テーブル container.IconExtjobTable = _runIconExtJobDAO.GetEntityByJobnet(innerJobnetId); } else { if (_isDb) { _isDb = false; LogInfo.WriteErrorLog(Consts.SYSERR_001, dbEx.InnerException); CommonDialog.ShowErrorDialog(Consts.SYSERR_001); } } dbEx = _dbAccess.exExecuteHealthCheck(); if (dbEx.MessageID.Equals("")) { // 条件分岐アイコン設定テーブル container.IconIfTable = _runIconIfDAO.GetEntityByJobnet(innerJobnetId); } else { if (_isDb) { _isDb = false; LogInfo.WriteErrorLog(Consts.SYSERR_001, dbEx.InnerException); CommonDialog.ShowErrorDialog(Consts.SYSERR_001); } } dbEx = _dbAccess.exExecuteHealthCheck(); if (dbEx.MessageID.Equals("")) { // 情報取得アイコン設定テーブル container.IconInfoTable = _runIconInfoDAO.GetEntityByJobnet(innerJobnetId); } else { if (_isDb) { _isDb = false; LogInfo.WriteErrorLog(Consts.SYSERR_001, dbEx.InnerException); CommonDialog.ShowErrorDialog(Consts.SYSERR_001); } } dbEx = _dbAccess.exExecuteHealthCheck(); if (dbEx.MessageID.Equals("")) { // 実行ジョブネットアイコン設定テーブル container.IconJobnetTable = _runIconJobnetDAO.GetEntityByJobnet(innerJobnetId); } else { if (_isDb) { _isDb = false; LogInfo.WriteErrorLog(Consts.SYSERR_001, dbEx.InnerException); CommonDialog.ShowErrorDialog(Consts.SYSERR_001); } } dbEx = _dbAccess.exExecuteHealthCheck(); if (dbEx.MessageID.Equals("")) { // 実行ジョブアイコン設定テーブル container.IconJobTable = _runIconJobDAO.GetEntityByJobnet(innerJobnetId); } else { if (_isDb) { _isDb = false; LogInfo.WriteErrorLog(Consts.SYSERR_001, dbEx.InnerException); CommonDialog.ShowErrorDialog(Consts.SYSERR_001); } } dbEx = _dbAccess.exExecuteHealthCheck(); if (dbEx.MessageID.Equals("")) { // 実行ジョブコマンド設定テーブル container.JobCommandTable = _jobCommandDAO.GetEntityByJobnet(innerJobnetId); } else { if (_isDb) { _isDb = false; LogInfo.WriteErrorLog(Consts.SYSERR_001, dbEx.InnerException); CommonDialog.ShowErrorDialog(Consts.SYSERR_001); } } dbEx = _dbAccess.exExecuteHealthCheck(); if (dbEx.MessageID.Equals("")) { // 実行ジョブ変数設定テーブル container.ValueJobTable = _valueJobDAO.GetEntityByJobnet(innerJobnetId); } else { if (_isDb) { _isDb = false; LogInfo.WriteErrorLog(Consts.SYSERR_001, dbEx.InnerException); CommonDialog.ShowErrorDialog(Consts.SYSERR_001); } } dbEx = _dbAccess.exExecuteHealthCheck(); if (dbEx.MessageID.Equals("")) { // 実行ジョブコントローラ変数設定テーブル container.ValueJobConTable = _valueJobConDAO.GetEntityByJobnet(innerJobnetId); } else { if (_isDb) { _isDb = false; LogInfo.WriteErrorLog(Consts.SYSERR_001, dbEx.InnerException); CommonDialog.ShowErrorDialog(Consts.SYSERR_001); } } dbEx = _dbAccess.exExecuteHealthCheck(); if (dbEx.MessageID.Equals("")) { // タスクアイコン設定テーブル container.IconTaskTable = _runIconTaskDAO.GetEntityByJobnet(innerJobnetId); } else { if (_isDb) { _isDb = false; LogInfo.WriteErrorLog(Consts.SYSERR_001, dbEx.InnerException); CommonDialog.ShowErrorDialog(Consts.SYSERR_001); } } dbEx = _dbAccess.exExecuteHealthCheck(); if (dbEx.MessageID.Equals("")) { // 実行ジョブコントローラ変数アイコン設定テーブル container.IconValueTable = _runIconValueDAO.GetEntityByJobnet(innerJobnetId); } else { if (_isDb) { _isDb = false; LogInfo.WriteErrorLog(Consts.SYSERR_001, dbEx.InnerException); CommonDialog.ShowErrorDialog(Consts.SYSERR_001); } } dbEx = _dbAccess.exExecuteHealthCheck(); if (dbEx.MessageID.Equals("")) { // 実行ファイル転送アイコン設定テーブル container.IconFcopyTable = _runIconFcopyDAO.GetEntityByJobnet(innerJobnetId); } else { if (_isDb) { _isDb = false; LogInfo.WriteErrorLog(Consts.SYSERR_001, dbEx.InnerException); CommonDialog.ShowErrorDialog(Consts.SYSERR_001); } } dbEx = _dbAccess.exExecuteHealthCheck(); if (dbEx.MessageID.Equals("")) { // 実行ファイル待ち合わせアイコン設定テーブル container.IconFwaitTable = _runIconFwaitDAO.GetEntityByJobnet(innerJobnetId); } else { if (_isDb) { _isDb = false; LogInfo.WriteErrorLog(Consts.SYSERR_001, dbEx.InnerException); CommonDialog.ShowErrorDialog(Consts.SYSERR_001); } } dbEx = _dbAccess.exExecuteHealthCheck(); if (dbEx.MessageID.Equals("")) { // 実行リブートアイコン設定テーブル container.IconRebootTable = _runIconRebootDAO.GetEntityByJobnet(innerJobnetId); } else { if (_isDb) { _isDb = false; LogInfo.WriteErrorLog(Consts.SYSERR_001, dbEx.InnerException); CommonDialog.ShowErrorDialog(Consts.SYSERR_001); } } dbEx = _dbAccess.exExecuteHealthCheck(); if (dbEx.MessageID.Equals("")) { // 実行保留解除アイコン設定テーブル container.IconReleaseTable = _runIconReleaseDAO.GetEntityByJobnet(innerJobnetId); } else { if (_isDb) { _isDb = false; LogInfo.WriteErrorLog(Consts.SYSERR_001, dbEx.InnerException); CommonDialog.ShowErrorDialog(Consts.SYSERR_001); } } dbEx = _dbAccess.exExecuteHealthCheck(); if (dbEx.MessageID.Equals("")) { //added by YAMA 2014/02/06 // 実行Zabbix連携アイコン設定テーブル container.IconCooperationTable = _runIconCooperationDAO.GetEntityByJobnet(innerJobnetId); } else { if (_isDb) { _isDb = false; LogInfo.WriteErrorLog(Consts.SYSERR_001, dbEx.InnerException); CommonDialog.ShowErrorDialog(Consts.SYSERR_001); } } dbEx = _dbAccess.exExecuteHealthCheck(); if (dbEx.MessageID.Equals("")) { //added by YAMA 2014/05/19 /// 実行エージェントレスアイコン設定テーブル container.IconAgentlessTable = _runIconAgentlessDAO.GetEntityByJobnet(innerJobnetId); } else { if (_isDb) { _isDb = false; LogInfo.WriteErrorLog(Consts.SYSERR_001, dbEx.InnerException); CommonDialog.ShowErrorDialog(Consts.SYSERR_001); } } /* * RunJobnetSummaryTable = _runJobnetSummaryDAO.GetEntityByPk(innerJobnetId); * if (RunJobnetSummaryTable.Rows.Count > 0) JobnetRunStatus = (RunJobStatusType)RunJobnetSummaryTable.Rows[0]["status"]; * // 実行ジョブネット管理テーブル * container.JobnetControlTable = _runJobnetDAO.GetEntityByPk(innerJobnetId); * * // 実行ジョブ管理テーブル * container.JobControlTable = null; * container.JobControlTable = _runJobControlDAO.GetEntityByJobnet(innerJobnetId); * // フロー管理テーブル * container.FlowControlTable = _runFlowControlDAO.GetEntityByJobnet(innerJobnetId); * * // 計算アイコン設定テーブル * container.IconCalcTable = _runIconCalcDAO.GetEntityByJobnet(innerJobnetId); * * //container.IconCalcTable.Rows * // 終了アイコン設定テーブル * container.IconEndTable = _runIconEndDAO.GetEntityByJobnet(innerJobnetId); * // 拡張実行ジョブアイコン設定テーブル * container.IconExtjobTable = _runIconExtJobDAO.GetEntityByJobnet(innerJobnetId); * * // 条件分岐アイコン設定テーブル * container.IconIfTable = _runIconIfDAO.GetEntityByJobnet(innerJobnetId); * * // 情報取得アイコン設定テーブル * container.IconInfoTable = _runIconInfoDAO.GetEntityByJobnet(innerJobnetId); * * // 実行ジョブネットアイコン設定テーブル * container.IconJobnetTable = _runIconJobnetDAO.GetEntityByJobnet(innerJobnetId); * * // 実行ジョブアイコン設定テーブル * container.IconJobTable = _runIconJobDAO.GetEntityByJobnet(innerJobnetId); * * // 実行ジョブコマンド設定テーブル * container.JobCommandTable = _jobCommandDAO.GetEntityByJobnet(innerJobnetId); * * // 実行ジョブ変数設定テーブル * container.ValueJobTable = _valueJobDAO.GetEntityByJobnet(innerJobnetId); * * // 実行ジョブコントローラ変数設定テーブル * container.ValueJobConTable = _valueJobConDAO.GetEntityByJobnet(innerJobnetId); * * // タスクアイコン設定テーブル * container.IconTaskTable = _runIconTaskDAO.GetEntityByJobnet(innerJobnetId); * * // 実行ジョブコントローラ変数アイコン設定テーブル * container.IconValueTable = _runIconValueDAO.GetEntityByJobnet(innerJobnetId); * * // 実行ファイル転送アイコン設定テーブル * container.IconFcopyTable = _runIconFcopyDAO.GetEntityByJobnet(innerJobnetId); * * // 実行ファイル待ち合わせアイコン設定テーブル * container.IconFwaitTable = _runIconFwaitDAO.GetEntityByJobnet(innerJobnetId); * * // 実行リブートアイコン設定テーブル * container.IconRebootTable = _runIconRebootDAO.GetEntityByJobnet(innerJobnetId); * * // 実行保留解除アイコン設定テーブル * container.IconReleaseTable = _runIconReleaseDAO.GetEntityByJobnet(innerJobnetId); * * //added by YAMA 2014/02/06 * // 実行Zabbix連携アイコン設定テーブル * container.IconCooperationTable = _runIconCooperationDAO.GetEntityByJobnet(innerJobnetId); * * //added by YAMA 2014/05/19 * /// 実行エージェントレスアイコン設定テーブル * container.IconAgentlessTable = _runIconAgentlessDAO.GetEntityByJobnet(innerJobnetId); */ }