/// <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 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 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);
}
}
/// <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="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 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>
/// 検索結果を表示する
/// </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 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>
/// 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);
}
}
/// <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>
/// フォームロードイベント処理
/// </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 NotesSettingList_Load(object sender, EventArgs e)
{
try
{
InitNotesSettingList();
}
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);
}
}
private void NotesSettingList_Load(object sender, EventArgs e)
{
try
{
this.ProgressPanel.Visible = false;
InitNotesSettingList();
}
catch (Exception ex)
{
Log.Write(ex);
RSM.ShowMessage(this, ex);
}
}
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);
}
}
/// <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 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="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 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>
/// <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>
/// <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);
}
private bool ValidateInputs()
{
if (this.cmbLogType.SelectedIndex == -1)
{
RSM.ShowMessage(this, RS.Exclamations.NotSelectLogType);
this.cmbLogType.Focus();
return(false);
}
DateTime?sdate = null;
DateTime?edate = null;
//開始日
if (dtpStartDate.Checked)
{
sdate = dtpStartDate.Value.Date;
if (sdate.Value > SqlDateTime.MaxValue || sdate.Value < SqlDateTime.MinValue)
{
RSM.ShowMessage(this, RS.Exclamations.InvalidateDateRang);
this.dtpStartDate.Focus();
return(false);
}
}
//終了日
if (dtpEndDate.Checked)
{
edate = dtpEndDate.Value.Date;
if (edate.Value > SqlDateTime.MaxValue || edate.Value < SqlDateTime.MinValue)
{
RSM.ShowMessage(this, RS.Exclamations.InvalidateDateRang);
this.dtpEndDate.Focus();
return(false);
}
}
//日付範囲
if (sdate.HasValue && edate.HasValue && sdate.Value > edate.Value)
{
RSM.ShowMessage(this, RS.Exclamations.InvalidateDateRang);
this.dtpStartDate.Focus();
return(false);
}
return(true);
}
/// <summary>
/// データベース選択
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void SelectDb_Click(object sender, EventArgs e)
{
try
{
NsfPicker nsfPicker = new NsfPicker();
nsfPicker.NotesPassword = Config.NotesPassword;
if (nsfPicker.ShowNsfPicker(this, false) == System.Windows.Forms.DialogResult.OK)
{
NsfInfo dbInfo = nsfPicker.SelectNsfDb;
IDatabase db = GetDatabase(dbInfo.Server, dbInfo.FilePath);
this._taskInfo.ResetNotesDatabase(db);
InitDatabaseInfo();
}
}
catch (Exception ex)
{
Log.Write(ex);
RSM.ShowMessage(this, ex);
}
}
/// <summary>
/// ソート種別設定
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnSortType_Click(object sender, EventArgs e)
{
try
{
if (this.lsvSortColumn.SelectedItems.Count == 0)
{
return;
}
ListViewItem lvItem = this.lsvSortColumn.SelectedItems[0];
IViewColumn column = lvItem.Tag as IViewColumn;
column.IsSortDescending = this.rdbDesc.Checked;
string desc = column.IsSortDescending ? "降順" : "昇順";
lvItem.SubItems[2].Text = desc;
}
catch (Exception ex)
{
Log.Write(ex);
RSM.ShowMessage(this, ex);
}
}
/// <summary>
/// 入力情報をチェックする
/// </summary>
private bool ValidSP()
{
//SPWebSiteが未入力の場合
if (string.IsNullOrEmpty(this.txtSPWebSite.Text))
{
RSM.ShowMessage(this, RS.Exclamations.NotSPWebSite);
FocusControl(this.txtSPWebSite);
return(false);
}
//SPUserIDが未入力の場合
if (string.IsNullOrEmpty(this.txtSPUser.Text))
{
RSM.ShowMessage(this, RS.Exclamations.NotSPUserID);
FocusControl(this.txtSPUser);
return(false);
}
//SPPasswordが未入力の場合
if (string.IsNullOrEmpty(this.txtSPPassword.Text))
{
RSM.ShowMessage(this, RS.Exclamations.NotSPPassword);
FocusControl(this.txtSPPassword);
return(false);
}
string website = this.txtSPWebSite.Text;
string userId = this.txtSPUser.Text;
string psw = this.txtSPPassword.Text;
//SP接続できない
SpAccessor spAccessor = Accessor.AccessorFactory.GetSpAccessor(website, userId, psw);
if (!spAccessor.TryConnect())
{
RSM.ShowMessage(this, RS.Exclamations.SPConnectFailed);
FocusControl(this.txtSPPassword);
return(false);
}
return(true);
}
/// <summary>
/// 設定を保存する
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void SaveButton_Click(object sender, EventArgs e)
{
try
{
if (!ValidateInputs())
{
return;
}
using (SqlAccessor sqlAccessor = Accessor.AccessorFactory.GetSqlAccessor())
{
sqlAccessor.UpdateMigrateForm(this.TargetForm);
}
Log.Write(RSM.GetMessage(RS.Informations.FormSetted, this.TargetForm.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 RemoveForm_Click(object sender, EventArgs e)
{
try
{
if (this.listFormTarget.SelectedItems == null || this.listFormTarget.SelectedItems.Count == 0)
{
return;
}
IForm formItem = this.listFormTarget.SelectedItems[0].Tag as IForm;
if (formItem != null)
{
formItem.IsTarget = false;
this._taskInfo.TargetForms.Remove(formItem);
}
this.InitForms();
}
catch (Exception ex)
{
Log.Write(ex);
RSM.ShowMessage(this, ex);
}
}
/// <summary>
/// 対象ビューを削除する
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void RemoveView_Click(object sender, EventArgs e)
{
try
{
if (this.listViewTarget.SelectedItems == null || this.listViewTarget.SelectedItems.Count == 0)
{
return;
}
IView viewItem = this.listViewTarget.SelectedItems[0].Tag as IView;
if (viewItem != null)
{
viewItem.IsTarget = false;
this._taskInfo.TargetViews.Remove(viewItem);
}
this.InitViews();
}
catch (Exception ex)
{
Log.Write(ex);
RSM.ShowMessage(this, ex);
}
}