/// <summary> /// 検索結果を表示する /// </summary> /// <param name="logType"></param> /// <param name="sdate"></param> /// <param name="edate"></param> private void BindLogList(LogType logType, DateTime?sdate, DateTime?edate) { DataSet result = null; using (SqlAccessor accessor = Accessor.AccessorFactory.GetSqlAccessor()) { result = accessor.GetLogList(logType, sdate, edate); } if (result != null || result.Tables.Count > 1) { //件数 int count = Utility.DBToInteger(result.Tables[0].Rows[0]["LOGCOUNT"]); if (count > MAX_DISPLAY_NUM) { RSM.ShowMessage(this, RS.Exclamations.MaxDisplayNumOvered); } DataTable datasource = result.Tables[1]; if (logType == LogType.System) { this.dtgSystemLog.DataSource = datasource; this.dtgEventLog.DataSource = null; this.dtgEventLog.Visible = false; this.dtgSystemLog.Visible = true; } else { this.dtgEventLog.DataSource = datasource; this.dtgSystemLog.DataSource = null; this.dtgSystemLog.Visible = false; this.dtgEventLog.Visible = true; } } }
private void EnsureSession() { if (!this.IsInitialized) { throw RSM.GetException(RS.Exceptions.SessionNotInitialized); } }
/// <summary> /// SP接続テスト /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnTryAccessSP_Click(object sender, EventArgs e) { if (ValidSP()) { RSM.ShowMessage(this, RS.Informations.TryConnectOK); } }
private void dataGridView1_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e) { if (e.ColumnIndex == 4) { //状態 if (e.Value != null && e.Value is int) { TaskState state = (TaskState)((int)e.Value); e.FormattingApplied = true; switch (state) { case TaskState.NotExecute: e.Value = RSM.GetMessage(RS.StringTable.TaskState_NotExecute); break; case TaskState.Executed: e.Value = RSM.GetMessage(RS.StringTable.TaskState_Executed); break; case TaskState.ExecutFailed: e.Value = RSM.GetMessage(RS.StringTable.TaskState_ExecutFailed); break; default: e.Value = string.Empty; break; } } } }
/// <summary> /// 保存 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void SaveButton_Click(object sender, EventArgs e) { try { if (!ValidateInputs()) { return; } //入力値を変更 //表示名 this._targetView.DisplayName = this.txtViewTitle.Text; //変換対象 this._targetView.IsTarget = this.rdbConvert.Checked; //アイテム数 this._targetView.RowLimit = (int)this.numLimitRow.Value; //既定のビュー this._targetView.IsTarget = this.chkDefault.Checked; //チェックボックス表示 this._targetView.ShowChecked = this.chkDefault.Checked; using (SqlAccessor sqlAccessor = Accessor.AccessorFactory.GetSqlAccessor()) { sqlAccessor.UpdateMigrateView(this._targetView); } Log.Write(this.TargetView.TaskId, RSM.GetMessage(RS.Informations.ViewSetted, this.TargetView.Name)); this.DialogResult = System.Windows.Forms.DialogResult.OK; this.Close(); } catch (Exception ex) { Log.Write(ex); RSM.ShowMessage(this, ex); } }
/// <summary> /// ロジックタイプ変更 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnSetLogicType_Click(object sender, EventArgs e) { try { if (this.treeCondition.Nodes.Count == 0) { return; } TreeNode root = this.treeCondition.Nodes[0]; LogicItem logitem = (LogicItem)root.Tag; if (this.rdbAnd.Checked) { logitem.Type = LogicType.And; } else { logitem.Type = LogicType.Or; } root.Text = logitem.TagName; } catch (Exception ex) { Log.Write(ex); RSM.ShowMessage(this, ex); } }
private void cmbTaskList_SelectedIndexChanged(object sender, EventArgs e) { if (this.cmbTaskList.SelectedItem == null) { return; } try { DataRowView row = (DataRowView)this.cmbTaskList.SelectedItem; string taskId = Utility.DBToString(row["TASK_ID"]); MigrateTask task = null; using (SqlAccessor accessor = Accessor.AccessorFactory.GetSqlAccessor()) { task = accessor.GetMigrateTaskById(taskId, SqlAccessor.DataKind.ViewOnly); } if (task == null) { return; } this._selectedTask = task; this.InitViewList(task); } catch (Exception ex) { Log.Write(ex); RSM.ShowMessage(this, ex); } }
/// <summary> /// 進歩報告 /// </summary> /// <param name="sender"></param> /// <param name="messageId"></param> /// <param name="isSucess"></param> /// <param name="args"></param> public void ReportStep(Enum messageId, bool isSucess, params string[] args) { if (this._reportHandler == null) { return; } string message = string.Empty; if (args == null || args.Length == 0) { message = RSM.GetMessage(messageId); } else { message = RSM.GetMessage(messageId, args); } this._processCount++; if (isSucess) { this._sucessCount++; } int parcent = this._processPercentage + (int)(this._stepRate * StepPercentage / 100); ReportEventArgs eventArgs = new ReportEventArgs( this._taskName, parcent, this.SetpCount, this._sucessCount, this._processCount, message); this._reportHandler(this, eventArgs); }
/// <summary> /// 処理ステップ設定 /// </summary> /// <param name="stepRate"></param> /// <param name="stepCount"></param> public void SetStep(double stepRate, int stepCount, Enum messageId, params string[] args) { this._processPercentage = (int)(this._processPercentage + this._stepRate); this._stepCount = stepCount; this._stepRate = stepRate; this._processCount = 0; this._sucessCount = 0; string message = string.Empty; if (this._reportHandler == null) { return; } if (args == null || args.Length == 0) { message = RSM.GetMessage(messageId); } else { message = RSM.GetMessage(messageId, args); } int parcent = this._processPercentage + (int)(this._stepRate * StepPercentage / 100); ReportEventArgs eventArgs = new ReportEventArgs( this._taskName, parcent, this.SetpCount, this._sucessCount, this._processCount, message); this._reportHandler(this, eventArgs); }
/// <summary> /// フィルター条件追加 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnAddFilter_Click(object sender, EventArgs e) { try { if (this.cmbFields.SelectedItem == null) { return; } if (this.cmbOperator.SelectedItem == null) { return; } EnumNameAttribute selectedItem = (EnumNameAttribute)this.cmbOperator.SelectedItem; OperatorType op = (OperatorType)selectedItem.EnumValue; ConditionItem condiItem = new ConditionItem(op); condiItem.FieldRef = (IFieldRef)this.cmbFields.SelectedItem; condiItem.Value = this.txtValue.Text; this._targetView.ViewCondition.Nodes.Add(condiItem); InitConditionTree(); } catch (Exception ex) { Log.Write(ex); RSM.ShowMessage(this, ex); } }
/// <summary> /// データ保存する /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnSave_Click(object sender, EventArgs e) { try { if (!this.ValidateInputs()) { return; } //入力値を設定する this._taskInfo.TaskName = this.txtTaskName.Text; this._taskInfo.DisplayName = this.txtDisplayName.Text; this._taskInfo.ListName = this.txtListName.Text; this._taskInfo.Description = this.txtDescription.Text; this._taskInfo.IsUseDefaultIcon = this.rdoDefaultIcon.Checked; string strType = Convert.ToString(this.cmbSPType.SelectedValue); SPListType sptype = SPListType.GenericList; if (Enum.TryParse(strType, true, out sptype)) { this._taskInfo.ListType = sptype; } using (SqlAccessor sqlAccessor = Accessor.AccessorFactory.GetSqlAccessor()) { sqlAccessor.InsertMigrate(this._taskInfo); } this.DialogResult = System.Windows.Forms.DialogResult.OK; Log.Write(this._taskInfo.TaskId, RSM.GetMessage(RS.Informations.DataBaseSetted, this._taskInfo.TaskName, this._taskInfo.TaskId)); this.Close(); } catch (Exception ex) { Log.Write(ex); RSM.ShowMessage(this, ex); } }
/// <summary> /// 削除ボタンを押す処理 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void DeleteButton_Click(object sender, EventArgs e) { if (this.TaskList.SelectedRows == null || this.TaskList.SelectedRows.Count == 0) { return; } try { var seleRow = this.TaskList.SelectedRows[0]; var item = seleRow.DataBoundItem as DataRowView; if (item == null) { return; } string taskId = item["TASK_ID"] as string; string taskName = item["TASK_NAME"] as string; using (SqlAccessor accessor = Accessor.AccessorFactory.GetSqlAccessor()) { accessor.DeleteMigrateTask(taskId); } Log.Write(taskId, RSM.GetMessage(RS.Informations.DatabaseDeleted, taskName, taskId)); InitNotesSettingList(); } catch (Exception ex) { Log.Write(ex); RSM.ShowMessage(this, ex); } }
/// <summary> /// DB接続テスト /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnTryAccessDB_Click(object sender, EventArgs e) { if (this.ValidDatabase()) { RSM.ShowMessage(this, RS.Informations.TryConnectOK); } }
/// <summary> /// フィルター条件削除 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnDeleteFilter_Click(object sender, EventArgs e) { try { if (this.treeCondition.SelectedNode == null || this.treeCondition.SelectedNode.Tag == null) { return; } object selectedItem = this.treeCondition.SelectedNode.Tag; if (selectedItem is LogicItem) { return; } else if (selectedItem is ConditionItem) { ConditionItem condiItem = (ConditionItem)selectedItem; this._targetView.ViewCondition.Nodes.Remove(condiItem); } InitConditionTree(); } catch (Exception ex) { Log.Write(ex); RSM.ShowMessage(this, ex); } }
/// <summary> /// ログを削除する /// </summary> /// <param name="type"></param> /// <param name="sdate"></param> /// <param name="edate"></param> private void DeleteLog(LogType type, DateTime?sdate, DateTime?edate) { using (SqlAccessor accessor = Accessor.AccessorFactory.GetSqlAccessor()) { accessor.DeleteLog(type, sdate, edate); } RSM.ShowMessage(this, RS.Informations.LogDataDeleted); this.BindLogList(type, sdate, edate); }
/// <summary> /// SQL Accessorのインスタンスを取得する /// </summary> /// <returns></returns> public static SqlAccessor GetSqlAccessor() { AuthenticateMode mode = (AuthenticateMode)Config.DBAuthenticateMode; if (string.IsNullOrEmpty(Config.SqlServer) || string.IsNullOrEmpty(Config.DataBaseName)) { throw RSM.GetException(RS.Exceptions.NotConfiged); } return(GetSqlAccessor(mode, Config.SqlServer, Config.DBUserId, Config.DBPassWord, Config.DataBaseName)); }
private void NotesSettingList_Load(object sender, EventArgs e) { try { InitNotesSettingList(); } catch (Exception ex) { Log.Write(ex); RSM.ShowMessage(this, ex); } }
/// <summary> /// フォームロードイベント処理 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void ViewSetting_Load(object sender, EventArgs e) { try { this.InitControls(); } catch (Exception ex) { Log.Write(ex); RSM.ShowMessage(this, ex); } }
private void PreViewForm_Load(object sender, EventArgs e) { try { InitHtml(this.NotesForm); } catch (Exception ex) { Log.Write(ex); RSM.ShowMessage(this, ex); } }
/// <summary> /// ワーカー処理完了 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void TaskWorker_RunWorkerCompleted(object sender, RunWorkerCompletedEventArgs e) { this.ProgressPanel.Visible = false; this.TaskList.Enabled = true; this.btnRun.Enabled = true; this.btnClose.Enabled = true; if (e.Error != null) { Log.Write(e.Error); RSM.ShowMessage(this, e.Error); } InitNotesSettingList(); }
private void CloseButton_Click(object sender, EventArgs e) { try { this.Close(); this.DialogResult = System.Windows.Forms.DialogResult.Cancel; } catch (Exception ex) { Log.Write(ex); RSM.ShowMessage(this, ex); } }
private void ViewSelectDialog_Load(object sender, EventArgs e) { try { this.btnOK.Enabled = false; InitTaskList(); } catch (Exception ex) { Log.Write(ex); RSM.ShowMessage(this, ex); } }
private void NotesSettingList_Load(object sender, EventArgs e) { try { this.ProgressPanel.Visible = false; InitNotesSettingList(); } catch (Exception ex) { Log.Write(ex); RSM.ShowMessage(this, ex); } }
/// <summary> /// 画面初期化する /// </summary> private void InitDatabaseInfo() { this.txtTaskName.Text = this._taskInfo.TaskName; string server = string.IsNullOrEmpty(this._taskInfo.NotesServer) ? "Local" : this._taskInfo.NotesServer; this.txtServer.Text = server; this.txtFileName.Text = this._taskInfo.NotesFilePath; this.txtListName.Text = this._taskInfo.ListName; this.txtDisplayName.Text = this._taskInfo.DisplayName; this.txtDescription.Text = this._taskInfo.Description; this.txtWebSite.Text = this._taskInfo.SPSiteUrl; //状態 switch (this._taskInfo.State) { case TaskState.NotExecute: this.lblStatus.Text = RSM.GetMessage(RS.StringTable.TaskState_NotExecute); break; case TaskState.Executed: this.lblStatus.Text = RSM.GetMessage(RS.StringTable.TaskState_Executed); break; case TaskState.ExecutFailed: this.lblStatus.Text = RSM.GetMessage(RS.StringTable.TaskState_ExecutFailed); break; default: this.lblStatus.Text = string.Empty; break; } //既定のアイコン this.rdoDefaultIcon.Checked = this._taskInfo.IsUseDefaultIcon; this.rdoNotDefIcon.Checked = !this._taskInfo.IsUseDefaultIcon; //実行日時 if (this._taskInfo.LastExecuteTime.HasValue) { this.lblConvertDate.Text = this._taskInfo.LastExecuteTime.Value.ToString("yyyy/MM/dd HH:mm:ss"); } //フォーム一覧 InitForms(); //ビュー一覧 InitViews(); int pos = this.cmbSPType.FindString(this._taskInfo.ListType.ToString()); if (pos > -1) { this.cmbSPType.SelectedIndex = pos; } }
private void btnTryAccessNotes_Click(object sender, EventArgs e) { string password = this.txtNotesPassword.Text; NotesAccessor nsAccessor = Accessor.AccessorFactory.GetNotesAccessor(); if (nsAccessor.TryConnect(password)) { this.lblUserId.Text = nsAccessor.GetCurrentUser(); RSM.ShowMessage(this, RS.Informations.TryConnectOK); } else { RSM.ShowMessage(this, RS.Exclamations.InvalidNotesPassword); } }
/// <summary> /// アイコンを出力する /// </summary> /// <param name="nsAccessor"></param> /// <param name="task"></param> /// <param name="databaseDir"></param> private void ExportDBIcon(NotesAccessor nsAccessor, IMigrateTask task, string databaseDir) { Image rawIcon = nsAccessor.ExportIcon(task.CurrentDb); Image smallIcon = nsAccessor.GetSmallIcon(rawIcon); Image LargeIcon = nsAccessor.GetLargeNotesIcon(rawIcon, task.NotesDbTitle); //元アイコン string iconFile = System.IO.Path.Combine(databaseDir, RSM.GetMessage(RS.StringTable.DBIconName)); rawIcon.Save(iconFile, ImageFormat.Png); //Smallアイコン iconFile = System.IO.Path.Combine(databaseDir, RSM.GetMessage(RS.StringTable.DBSmallIconName)); smallIcon.Save(iconFile, ImageFormat.Png); //大きいアイコン iconFile = System.IO.Path.Combine(databaseDir, RSM.GetMessage(RS.StringTable.DBLargeIconName)); LargeIcon.Save(iconFile, ImageFormat.Png); }
/// <summary> /// ログを削除する /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnDelete_Click(object sender, EventArgs e) { try { if (!ValidateInputs()) { return; } SearchArgs args = GetSearchArgs(); this.DeleteLog(args.Type, args.StartDate, args.EndDate); } catch (Exception ex) { Log.Write(ex); RSM.ShowMessage(this, ex); } }
/// <summary> /// グループ項目削除 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnDeleteGroup_Click(object sender, EventArgs e) { try { if (this.lsvGroupColumns.SelectedItems.Count == 0) { return; } IViewColumn column = this.lsvGroupColumns.SelectedItems[0].Tag as IViewColumn; this._targetView.GroupColumns.Remove(column); InitGroupColumnTab(); } catch (Exception ex) { Log.Write(ex); RSM.ShowMessage(this, ex); } }
/// <summary> /// グループ項目追加 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnAddGroup_Click(object sender, EventArgs e) { try { if (this.lsvFieldForGroup.SelectedItems.Count == 0) { return; } IFieldRef fld = this.lsvFieldForGroup.SelectedItems[0].Tag as IFieldRef; this._targetView.GroupColumns.Add(new ViewColumn(fld)); InitGroupColumnTab(); } catch (Exception ex) { Log.Write(ex); RSM.ShowMessage(this, ex); } }
/// <summary> /// 入力内容チェック /// </summary> /// <returns></returns> private bool ValidateInputs() { //ビュータイトル if (string.IsNullOrWhiteSpace(this.txtViewTitle.Text)) { RSM.ShowMessage(this, RS.Exclamations.NotViewTitle); FocusControl(this.txtViewTitle); return(false); } //ビュー表示列 if (this.lsvColumns.Items.Count == 0) { RSM.ShowMessage(this, RS.Exclamations.NotDisplayColumn); FocusControl(this.txtViewTitle); return(false); } return(true); }