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