//システム情報の表示
private void disp_system(DISP_dataSet dsp_L)
{
//システム情報
if (dsp_L.system_L != null)
{
string fastline = "";
systemDSList = new List <systemDS>();
foreach (systemDS sys in dsp_L.system_L)
{
if (fastline == sys.systemno)
{
continue;
}
string[] h = Enumerable.Range(1, 7).Select(x =>
{
switch (x)
{
case 1:
return(sys.systemno == null || sys.systemno == "" ? "" : sys.systemno);
case 2:
return(sys.status == null || sys.status == "" ? "" : sys.status);
case 3:
return(sys.systemname == null || sys.systemname == "" ? "" : sys.systemname);
case 4:
return(sys.systemkana == null || sys.systemkana == "" ? "" : sys.systemkana);
case 5:
return(sys.biko == null || sys.biko == "" ? "" : sys.biko);
case 6:
return(sys.chk_date == null || sys.chk_date == "" ? "" : sys.chk_date);
case 7:
return(sys.chk_name_id == null || sys.chk_name_id == "" ? "" : sys.chk_name_id);
default: return("");
}
}).ToArray();
//システム情報の表示
this.m_system_list.Rows.Add(h);
fastline = sys.systemno;
systemDSList.Add(sys);
}
//件数を書き込む
//this.m_system_count.Text = system_list.Rows.Count.ToString() + "件";
//dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells;
m_system_list.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCells);
}
}
//検索ボタン
private void m_selectBtn_Click(object sender, EventArgs e)
{
this.m_selectBtn.Enabled = false;
try
{
m_system_list.Rows.Clear();
m_site_list.Rows.Clear();
m_host_list.Rows.Clear();
m_interface_list.Rows.Clear();
Dictionary <string, string> param_dict = new Dictionary <string, string>();
Class_Detaget getdata = new Class_Detaget();
dsp_L = new DISP_dataSet();
//カスタマ名コンボボックス
if (m_usernameCombo.Text != "")
{
param_dict["username"] = m_usernameCombo.Text;
}
//構成データの取得
getdata.con = con;
dsp_L = getdata.getSelectDataFor_Interface(param_dict, con, dsp_L);
disp_system(dsp_L);
disp_site(dsp_L);
disp_host(dsp_L);
disp_interface(dsp_L);
//テンプレートを取得
taskchange();
}
catch (Exception ex)
{
MessageBox.Show("構成情報の表示時にエラーが発生しました。" + ex.Message, "構成情報表示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
logger.ErrorFormat("構成情報の表示時にエラーが発生しました。" + ex.Message);
}
finally
{
this.m_selectBtn.Enabled = true;
}
this.m_selectBtn.Enabled = true;
}
//検索ボタン
private void m_select_btn_Click(object sender, EventArgs e)
{
m_templetelist.Clear();
DISP_dataSet dset = new DISP_dataSet();
Dictionary <string, string> param_dict = new Dictionary <string, string>();
Class_Detaget dg = new Class_Detaget();
if (m_selecttext.Text != "")
{
if (this.m_selectCombo.SelectedIndex.ToString() != "")
{
switch (this.m_selectCombo.SelectedIndex)
{
//テンプレート通番
case 0:
param_dict["templeteno"] = m_selecttext.Text;
break;
//テンプレート種別
case 1:
if (m_selecttext.Text == "インシデント")
{
param_dict["templetetype"] = "1";
}
else if (m_selecttext.Text.IndexOf("タスク") > -1 || m_selecttext.Text.IndexOf("計画作業") > -1)
{
param_dict["templetetype"] = "2";
}
break;
//テンプレート名
case 2:
param_dict["templetename"] = m_selecttext.Text;
break;
//カスタマ名
case 3:
param_dict["username"] = m_selecttext.Text;
break;
case 4:
param_dict["title"] = m_selecttext.Text;
break;
//本文
case 5:
param_dict["text"] = m_selecttext.Text;
break;
//更新日時
case 6:
DateTime dt;
String str = m_selecttext.Text;
//入力された日付の形式の確認
if (DateTime.TryParse(str, out dt))
{
param_dict["chk_date"] = str;
}
else
{
MessageBox.Show("日付の形式が正しくありません。", "拠点検索");
return;
}
break;
//更新者
case 7:
param_dict["chk_name_id"] = m_selecttext.Text;
break;
default:
break;
}
}
}
//まず件数を取得する
Int64 count = dg.getTempleteListCount("", param_dict, con);
if (MessageBox.Show(count.ToString() + "件ヒットしました。表示しますか？", "ホスト", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No)
{
return;
}
//テンプレート一覧を取得する
templList = dg.selectTempleteList("", param_dict, con);
this.splitContainer1.SplitterDistance = 210;
this.m_templetelist.VirtualMode = true;
// １行全体選択
this.m_templetelist.FullRowSelect = true;
this.m_templetelist.HideSelection = false;
this.m_templetelist.HeaderStyle = ColumnHeaderStyle.Clickable;
//Hook up handlers for VirtualMode events.
this.m_templetelist.RetrieveVirtualItem += new RetrieveVirtualItemEventHandler(incident_RetrieveVirtualItem);
this.m_templetelist.AutoResizeColumns(ColumnHeaderAutoResizeStyle.HeaderSize);
this.m_templetelist.Scrollable = true;
this.m_templetelist.Columns.Insert(0, "テンプレート通番", 30, HorizontalAlignment.Left);
this.m_templetelist.Columns.Insert(1, "テンプレート種別", 50, HorizontalAlignment.Left);
this.m_templetelist.Columns.Insert(2, "テンプレート名", 300, HorizontalAlignment.Left);
this.m_templetelist.Columns.Insert(3, "カスタマ通番", 50, HorizontalAlignment.Left);
this.m_templetelist.Columns.Insert(4, "タイトル(インシデントのみ)", 80, HorizontalAlignment.Left);
this.m_templetelist.Columns.Insert(5, "テンプレート内容", 300, HorizontalAlignment.Left);
this.m_templetelist.Columns.Insert(6, "更新日時", 110, HorizontalAlignment.Left);
this.m_templetelist.Columns.Insert(7, "更新者", 50, HorizontalAlignment.Left);
//リストビューを初期化する
templ_list = new DataTable("table1");
templ_list.Columns.Add("テンプレート通番", Type.GetType("System.Int32"));
templ_list.Columns.Add("テンプレート種別", Type.GetType("System.String"));
templ_list.Columns.Add("テンプレート名", Type.GetType("System.String"));
templ_list.Columns.Add("カスタマ通番", Type.GetType("System.String"));
templ_list.Columns.Add("タイトル(インシデントのみ)", Type.GetType("System.String"));
templ_list.Columns.Add("テンプレート内容", Type.GetType("System.String"));
templ_list.Columns.Add("更新日時", Type.GetType("System.String"));
templ_list.Columns.Add("更新者", Type.GetType("System.String"));
//リストに表示
if (templList != null)
{
m_templetelist.BeginUpdate();
foreach (templeteDS s_ds in templList)
{
DataRow urow = templ_list.NewRow();
urow["テンプレート通番"] = s_ds.templeteno;
//1:インシデント 2:計画作業
string typestr = "";
if (s_ds.templetetype == "1")
{
typestr = "インシデント";
}
else if (s_ds.templetetype == "2")
{
typestr = "タスク(インシデントタスク・計画作業)";
}
urow["テンプレート種別"] = typestr;
urow["テンプレート名"] = s_ds.templetename;
urow["カスタマ通番"] = s_ds.userno;
urow["テンプレート内容"] = s_ds.text;
urow["タイトル(インシデントのみ)"] = s_ds.title;
urow["更新日時"] = s_ds.chk_date;
urow["更新者"] = s_ds.chk_name_id;
templ_list.Rows.Add(urow);
}
this.m_templetelist.VirtualListSize = templ_list.Rows.Count;
this.m_templetelist.AutoResizeColumns(ColumnHeaderAutoResizeStyle.HeaderSize);
m_templetelist.EndUpdate();
}
}
//インターフェイス
private void disp_interface(DISP_dataSet dsp_L, String siteno = null, String hostno = null)
{
if (dsp_L == null)
{
return;
}
//インターフェイス情報
if (dsp_L.watch_L != null)
{
HashSet <string> ary1 = new HashSet <string>();
int dispflg = 0;
if (interfaceDSList != null)
{
interfaceDSList.Clear();
}
interfaceDSList = new List <watch_InterfaceDS>();
foreach (watch_InterfaceDS w in dsp_L.watch_L)
{
dispflg = 0;
//チェックボックスがOFFになっている場合は表示しない
// if (this.m_interface_umu_check.Checked == false && w.status == "無効")
// continue;
//絞込みの時
if (siteno != null)
{
//拠点番号が同じなら表示
if (siteno == w.siteno)
{
dispflg = 1;
}
}
//拠点ごとではなくホストごとのとき
else if (hostno != null)
{
if (hostno == w.host_no)
{
dispflg = 1;
}
}
//普通の表示
else
{
dispflg = 1;
}
//表示対象
if (dispflg == 1)
{
//重複チェック
if (ary1.Add(w.watch_Interfaceno))
{
string[] wi = Enumerable.Range(1, 12)
.Select(x =>
{
switch (x)
{
case 1: return(w.watch_Interfaceno == null || w.watch_Interfaceno == "" ? "" : w.watch_Interfaceno);
case 2: return(w.status == null || w.status == "" ? "" : w.status);
case 3: return(w.interfacename == null || w.interfacename == "" ? "" : w.interfacename);
case 4: return(w.type == null || w.type == "" ? "" : w.type);
case 5: return(w.kanshi == null || w.kanshi == "" ? "" : w.kanshi);
case 6: return(w.border == null || w.border == "" ? "" : w.border);
case 7: return(w.IPaddress == null || w.IPaddress == "" ? "" : w.IPaddress);
case 8: return(w.IPaddressNAT == null || w.IPaddressNAT == "" ? "" : w.IPaddressNAT);
case 9: return(w.biko == null || w.biko == "" ? "" : w.biko);
case 10: return(w.chk_date == null || w.chk_date == "" ? "" : w.chk_date);
case 11: return(w.chk_name_id == null || w.chk_name_id == "" ? "" : w.chk_name_id);
default: return("");
}
}).ToArray();
//インターフェイス情報の表示
this.m_interface_list.Rows.Add(wi);
interfaceDSList.Add(w);
}
}
}
//件数を書き込む
// this.m_interface_count.Text = interface_list.Rows.Count.ToString() + "件";
m_interface_list.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCells);
}
}
//ホスト
private void disp_host(DISP_dataSet dsp_L, String siteno = null)
{
//機器
if (dsp_L == null)
{
return;
}
//機器情報
if (dsp_L.host_L != null)
{
if (hostDSList != null)
{
hostDSList.Clear();
}
hostDSList = new List <hostDS>();
HashSet <string> ary1 = new HashSet <string>();
foreach (hostDS h in dsp_L.host_L)
{
//チェックボックスがOFFになっている場合は表示しない
// if (this.m_host_umu_check.Checked == false && h.status == "無効")
// continue;
//絞込みの時
if (siteno != null)
{
if (siteno == h.siteno)
{
//重複チェック
if (ary1.Add(h.host_no))
{
string[] hos = Enumerable.Range(1, 14).Select(x =>
{
switch (x)
{
case 1: return(h.host_no == null || h.host_no == "" ? "" : h.host_no);
case 2: return(h.status == null || h.status == "" ? "" : h.status);
case 3: return(h.hostname == null || h.hostname == "" ? "" : h.hostname);
case 4: return(h.device == null || h.device == "" ? "" : h.device);
case 5: return(h.location == null || h.location == "" ? "" : h.location);
case 6: return(h.usefor == null || h.usefor == "" ? "" : h.usefor);
case 7: return(h.settikikiid == null || h.settikikiid == "" ? "" : h.settikikiid);
case 8: return(h.kansiStartdate == null || h.kansiStartdate == "" ? "" : h.kansiStartdate);
case 9: return(h.kansiEndsdate == null || h.kansiEndsdate == "" ? "" : h.kansiEndsdate);
case 10: return(h.hosyukanri == null || h.hosyukanri == "" ? "" : h.hosyukanri);
case 11: return(h.hosyuinfo == null || h.hosyuinfo == "" ? "" : h.hosyuinfo);
case 12: return(h.biko == null || h.biko == "" ? "" : h.biko);
case 13: return(h.chk_date == null || h.chk_date == "" ? "" : h.chk_date);
case 14: return(h.chk_name_id == null || h.chk_name_id == "" ? "" : h.chk_name_id);
default: return("");
}
}).ToArray();
//ホスト情報の表示
this.m_host_list.Rows.Add(hos);
hostDSList.Add(h);
}
}
}
else
{
//重複チェック
if (ary1.Add(h.host_no))
{
string[] hos = Enumerable.Range(1, 14).Select(x =>
{
switch (x)
{
case 1: return(h.host_no == null || h.host_no == "" ? "" : h.host_no);
case 2: return(h.status == null || h.status == "" ? "" : h.status);
case 3: return(h.hostname == null || h.hostname == "" ? "" : h.hostname);
case 4: return(h.device == null || h.device == "" ? "" : h.device);
case 5: return(h.location == null || h.location == "" ? "" : h.location);
case 6: return(h.usefor == null || h.usefor == "" ? "" : h.usefor);
case 7: return(h.settikikiid == null || h.settikikiid == "" ? "" : h.settikikiid);
case 8: return(h.kansiStartdate == null || h.kansiStartdate == "" ? "" : h.kansiStartdate);
case 9: return(h.kansiEndsdate == null || h.kansiEndsdate == "" ? "" : h.kansiEndsdate);
case 10: return(h.hosyukanri == null || h.hosyukanri == "" ? "" : h.hosyukanri);
case 11: return(h.hosyuinfo == null || h.hosyuinfo == "" ? "" : h.hosyuinfo);
case 12: return(h.biko == null || h.biko == "" ? "" : h.biko);
case 13: return(h.chk_date == null || h.chk_date == "" ? "" : h.chk_date);
case 14: return(h.chk_name_id == null || h.chk_name_id == "" ? "" : h.chk_name_id);
default: return("");
}
}).ToArray();
//ホスト情報の表示
this.m_host_list.Rows.Add(hos);
hostDSList.Add(h);
}
}
}
//件数を書き込む
// this.m_host_count.Text = m_host_list.Rows.Count.ToString() + "件";
m_host_list.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCells);
}
}
//拠点情報一覧の表示
private void disp_site(DISP_dataSet dsp_L, String systemno = null)
{
if (dsp_L == null)
{
return;
}
//拠点情報
if (dsp_L.site_L != null)
{
siteDSList = new List <siteDS>();
HashSet <string> ary1 = new HashSet <string>();
foreach (siteDS s in dsp_L.site_L)
{
//チェックボックスがOFFになっている場合は表示しない
// if (this.m_site_umu_check.Checked == false && s.status == "無効")
// continue;
//絞込みの時
if (systemno != null)
{
if (systemno == s.systemno)
{
//重複チェック
if (ary1.Add(s.siteno))
{
string[] si = Enumerable.Range(1, 9)
.Select(x =>
{
switch (x)
{
case 1: return(s.siteno == null || s.siteno == "" ? "" : s.siteno);
case 2: return(s.status == null || s.status == "" ? "" : s.status);
case 3: return(s.sitename == null || s.sitename == "" ? "" : s.sitename);
//郵便番号
case 4: return(s.address1 == null || s.address1 == "" ? "" : s.address1);
//住所
case 5: return(s.address2 == null || s.address2 == "" ? "" : s.address2);
case 6: return(s.telno == null || s.telno == "" ? "" : s.telno);
case 7: return(s.biko == null || s.biko == "" ? "" : s.biko);
case 8: return(s.chk_date == null || s.chk_date == "" ? "" : s.chk_date);
case 9: return(s.chk_name_id == null || s.chk_name_id == "" ? "" : s.chk_name_id);
default: return("");
}
}).ToArray();
//拠点情報の表示
this.m_site_list.Rows.Add(si);
siteDSList.Add(s);
}
}
}
else
{
//重複チェック
if (ary1.Add(s.siteno))
{
string[] si = Enumerable.Range(1, 9)
.Select(x =>
{
switch (x)
{
case 1: return(s.siteno == null || s.siteno == "" ? "" : s.siteno);
case 2: return(s.status == null || s.status == "" ? "" : s.status);
case 3: return(s.sitename == null || s.sitename == "" ? "" : s.sitename);
//郵便番号
case 4: return(s.address1 == null || s.address1 == "" ? "" : s.address1);
//住所
case 5: return(s.address2 == null || s.address2 == "" ? "" : s.address2);
case 6: return(s.telno == null || s.telno == "" ? "" : s.telno);
case 7: return(s.biko == null || s.biko == "" ? "" : s.biko);
case 8: return(s.chk_date == null || s.chk_date == "" ? "" : s.chk_date);
case 9: return(s.chk_name_id == null || s.chk_name_id == "" ? "" : s.chk_name_id);
default: return("");
}
}).ToArray();
//拠点情報の表示
this.m_site_list.Rows.Add(si);
siteDSList.Add(s);
}
}
}
//件数を書き込む
// this.m_site_count.Text = site_list.Rows.Count.ToString() + "件";
m_site_list.AutoResizeColumns(DataGridViewAutoSizeColumnsMode.AllCells);
}
}
//対応状況を取得する
private void disp_alermList()
{
m_taioulist.Clear();
DISP_dataSet dset = new DISP_dataSet();
Dictionary <string, string> param_dict = new Dictionary <string, string>();
Class_Detaget dg = new Class_Detaget();
param_dict["alertdatetime_Before"] = m_alertdatetime_Before.Value.ToString("yyyy-MM-dd HH:mm");
param_dict["alertdatetime_After"] = m_alertdatetime_After.Value.ToString("yyyy-MM-dd HH:mm");
param_dict["taiou"] = m_taiouchk.Checked.ToString();
if (m_taiou.Text != "")
{
param_dict["opeid"] = m_taiou.Text;
}
this.m_taioulist.FullRowSelect = true;
this.m_taioulist.HideSelection = false;
this.m_taioulist.HeaderStyle = ColumnHeaderStyle.Clickable;
this.m_taioulist.Columns.Insert(0, "No", 30, HorizontalAlignment.Left);
this.m_taioulist.Columns.Insert(1, "スケジュールタイプ", 90, HorizontalAlignment.Left);
this.m_taioulist.Columns.Insert(2, "繰り返し区分", 60, HorizontalAlignment.Left);
this.m_taioulist.Columns.Insert(3, "アラーム日時", 120, HorizontalAlignment.Left);
this.m_taioulist.Columns.Insert(4, "対応者", 90, HorizontalAlignment.Left);
this.m_taioulist.Columns.Insert(5, "対応日時", 120, HorizontalAlignment.Left);
this.m_taioulist.Columns.Insert(6, "タイマーID", 30, HorizontalAlignment.Left);
this.m_taioulist.Columns.Insert(7, "タイマー名", 120, HorizontalAlignment.Left);
this.m_taioulist.Columns.Insert(8, "内容", 80, HorizontalAlignment.Left);
this.m_taioulist.Columns.Insert(9, "カスタマ名", 80, HorizontalAlignment.Left);
almList = dg.gettaiouRireki(param_dict, con);
if (almList != null && almList.Count > 0)
{
//リストに表示
foreach (alermDS ads in almList)
{
ListViewItem itemx1 = new ListViewItem();
itemx1.Text = ads.schedule_no;
//スケジュールタイプ
string str = "";
if (ads.schedule_type == "1")
{
str = "インシデント対応";
}
else if (ads.schedule_type == "2")
{
str = "定期作業";
}
else if (ads.schedule_type == "3")
{
str = "計画作業";
}
else if (ads.schedule_type == "4")
{
str = "特別対応";
}
itemx1.SubItems.Add(str);
//繰り返しタイプ //1:1回、2:1時間毎、3:日毎、4:週毎、5:月毎
if (ads.repeat_type == "1")
{
str = "1回";
}
else if (ads.repeat_type == "2")
{
str = "時間毎";
}
else if (ads.repeat_type == "3")
{
str = "日毎";
}
else if (ads.repeat_type == "4")
{
str = "週毎";
}
else if (ads.repeat_type == "5")
{
str = "月毎";
}
itemx1.SubItems.Add(str);
itemx1.SubItems.Add(ads.alertdatetime);
itemx1.SubItems.Add(ads.opeid);
itemx1.SubItems.Add(ads.taioudate);
itemx1.SubItems.Add(ads.timerid);
itemx1.SubItems.Add(ads.timername);
itemx1.SubItems.Add(ads.naiyou);
itemx1.SubItems.Add(ads.username);
this.m_taioulist.Items.Add(itemx1);
}
}
}
//検索ボタン
private void m_select_btn_Click_1(object sender, EventArgs e)
{
m_addressslist.Clear();
DISP_dataSet dset = new DISP_dataSet();
Dictionary <string, string> param_dict = new Dictionary <string, string>();
Class_Detaget dg = new Class_Detaget();
if (m_selecttext.Text != "")
{
if (this.m_selectCombo.SelectedIndex.ToString() != "")
{
switch (this.m_selectCombo.SelectedIndex)
{
case 0:
param_dict["kubun"] = m_selecttext.Text;
break;
case 1:
param_dict["opetantouno"] = m_selecttext.Text;
break;
case 2:
param_dict["addressNo"] = m_selecttext.Text;
break;
case 3:
param_dict["mailAddress"] = m_selecttext.Text;
break;
case 4:
param_dict["addressname"] = m_selecttext.Text;
break;
//更新日時
case 5:
DateTime dt;
String str = m_selecttext.Text;
//入力された日付の形式の確認
if (DateTime.TryParse(str, out dt))
{
param_dict["chk_date"] = str;
}
else
{
MessageBox.Show("日付の形式が正しくありません。", "メール検索");
return;
}
break;
//更新者
case 6:
param_dict["chk_name_id"] = m_selecttext.Text;
break;
default:
break;
}
}
}
//メール一覧をリストに表示する
getmailaddress(param_dict, con);
}
//検索ボタン
private void m_select_btn_Click(object sender, EventArgs e)
{
m_oper_List.Clear();
DISP_dataSet dset = new DISP_dataSet();
Dictionary <string, string> param_dict = new Dictionary <string, string>();
Class_Detaget dg = new Class_Detaget();
if (m_selecttext.Text != "")
{
if (this.m_selectCombo.SelectedIndex.ToString() != "")
{
switch (this.m_selectCombo.SelectedIndex)
{
case 0:
param_dict["openo"] = m_selecttext.Text;
break;
case 1:
param_dict["opeid"] = m_selecttext.Text;
break;
case 2:
param_dict["lastname"] = m_selecttext.Text;
break;
case 3:
param_dict["fastname"] = m_selecttext.Text;
break;
case 4:
param_dict["password"] = m_selecttext.Text;
break;
case 5:
param_dict["type"] = m_selecttext.Text;
break;
case 6:
param_dict["biko"] = m_selecttext.Text;
break;
//更新日時
case 7:
DateTime dt;
String str = m_selecttext.Text;
//入力された日付の形式の確認
if (DateTime.TryParse(str, out dt))
{
param_dict["chk_date"] = str;
}
else
{
MessageBox.Show("日付の形式が正しくありません。", "拠点検索");
return;
}
break;
//更新者
case 11:
param_dict["chk_name_id"] = m_selecttext.Text;
break;
default:
break;
}
}
}
List <opeDS> opeList = dg.getSelectOper(param_dict, con);
this.m_oper_List.FullRowSelect = true;
this.m_oper_List.HideSelection = false;
this.m_oper_List.HeaderStyle = ColumnHeaderStyle.Clickable;
this.m_oper_List.Columns.Insert(0, "No", 30, HorizontalAlignment.Left);
this.m_oper_List.Columns.Insert(1, "オペレータID", 120, HorizontalAlignment.Left);
this.m_oper_List.Columns.Insert(2, "姓", 120, HorizontalAlignment.Left);
this.m_oper_List.Columns.Insert(3, "名", 90, HorizontalAlignment.Left);
this.m_oper_List.Columns.Insert(4, "パスワード", 80, HorizontalAlignment.Left);
this.m_oper_List.Columns.Insert(5, "権限", 80, HorizontalAlignment.Left);
this.m_oper_List.Columns.Insert(6, "備考", 50, HorizontalAlignment.Left);
this.m_oper_List.Columns.Insert(7, "更新日時", 50, HorizontalAlignment.Left);
this.m_oper_List.Columns.Insert(8, "更新者", 50, HorizontalAlignment.Left);
//リストに表示
if (opeList != null)
{
foreach (opeDS t_ds in opeList)
{
ListViewItem itemx1 = new ListViewItem();
itemx1.Text = t_ds.openo;
itemx1.SubItems.Add(t_ds.opeid);
itemx1.SubItems.Add(t_ds.lastname);
itemx1.SubItems.Add(t_ds.fastname);
itemx1.SubItems.Add(t_ds.password);
String str = "";
if (t_ds.type == "1")
{
str = "管理者";
}
else
{
str = "利用者";
}
itemx1.SubItems.Add(str);
itemx1.SubItems.Add(t_ds.biko);
itemx1.SubItems.Add(t_ds.chk_date);
itemx1.SubItems.Add(t_ds.chk_name_id);
this.m_oper_List.Items.Add(itemx1);
}
}
}
//検索ボタン
private void m_selectBtn_Click(object sender, EventArgs e)
{
ListView lv;
if (tabcontrol1.SelectedIndex == 1)
{
lv = m_user_tanntouList;
}
else
{
lv = m_operaterList;
}
lv.Clear();
DISP_dataSet dset = new DISP_dataSet();
Dictionary <string, string> param_dict = new Dictionary <string, string>();
Class_Detaget dg = new Class_Detaget();
if (m_selecttext.Text != "")
{
if (this.m_selectKoumoku.SelectedIndex.ToString() != "")
{
switch (this.m_selectKoumoku.SelectedIndex)
{
//ユーザID
case 0:
param_dict["opetantouno"] = m_selecttext.Text;
break;
//カスタマメイ
case 1:
param_dict["username"] = m_selecttext.Text;
break;
//アドレス番号
case 2:
param_dict["addressNo"] = m_selecttext.Text;
break;
case 3:
param_dict["mailAddress"] = m_selecttext.Text;
break;
case 4:
param_dict["addressname"] = m_selecttext.Text;
break;
//更新者
case 5:
param_dict["chk_name_id"] = m_selecttext.Text;
break;
default:
break;
}
}
}
List <MailaddressDS> addressList;
if (tabcontrol1.SelectedIndex == 1)
{
//カスタマ担当者
addressList_tantou = dg.selectMailList(param_dict, con, "2");
addressList = addressList_tantou;
}
else
{
//オペレータ
addressList_ope = dg.selectMailList(param_dict, con, "1");
addressList = addressList_ope;
}
//リストに表示
if (addressList != null)
{
//リストに表示
disp_addressList(addressList, lv);
}
}
//検索ボタン
private void m_selectBtn_Click(object sender, EventArgs e)
{
m_Site_List.Clear();
DISP_dataSet dset = new DISP_dataSet();
Dictionary <string, string> param_dict = new Dictionary <string, string>();
Class_Detaget dg = new Class_Detaget();
if (m_selecttext.Text != "")
{
if (this.m_selectKoumoku.SelectedIndex.ToString() != "")
{
switch (this.m_selectKoumoku.SelectedIndex)
{
//拠点通番
case 0:
param_dict["siteno"] = m_selecttext.Text;
break;
//拠点名
case 1:
param_dict["sitename"] = m_selecttext.Text;
break;
//郵便番号
case 2:
param_dict["address1"] = m_selecttext.Text;
break;
//住所
case 3:
param_dict["address2"] = m_selecttext.Text;
break;
//TEL/FAX
case 4:
param_dict["telno"] = m_selecttext.Text;
break;
//ステータス
case 5:
if (m_selecttext.Text == "無効")
{
param_dict["status"] = "0";
}
else if (m_selecttext.Text == "有効")
{
param_dict["status"] = "1";
}
break;
//備考
case 6:
param_dict["biko"] = m_selecttext.Text;
break;
//カスタマ通番
case 7:
param_dict["userno"] = m_selecttext.Text;
break;
//システム通番
case 8:
param_dict["systemno"] = m_selecttext.Text;
break;
//更新日時
case 9:
DateTime dt;
String str = m_selecttext.Text;
//入力された日付の形式の確認
if (DateTime.TryParse(str, out dt))
{
param_dict["chk_date"] = str;
}
else
{
MessageBox.Show("日付の形式が正しくありません。", "拠点検索");
return;
}
break;
//更新者
case 10:
param_dict["chk_name_id"] = m_selecttext.Text;
break;
default:
break;
}
}
}
//まず件数を取得する
Int64 count = dg.getSelectSiteCount(param_dict, con, dset, true);
if (MessageBox.Show(count.ToString() + "件ヒットしました。表示しますか？", "拠点", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No)
{
return;
}
//拠点一覧を取得する
dset = dg.getSelectSite(param_dict, con, dset, true);
this.splitContainer1.SplitterDistance = 227;
this.m_Site_List.VirtualMode = true;
// １行全体選択
this.m_Site_List.FullRowSelect = true;
this.m_Site_List.HideSelection = false;
this.m_Site_List.HeaderStyle = ColumnHeaderStyle.Clickable;
//Hook up handlers for VirtualMode events.
this.m_Site_List.RetrieveVirtualItem += new RetrieveVirtualItemEventHandler(Site_RetrieveVirtualItem);
this.m_Site_List.AutoResizeColumns(ColumnHeaderAutoResizeStyle.HeaderSize);
this.m_Site_List.Scrollable = true;
this.m_Site_List.Columns.Insert(0, "No", 30, HorizontalAlignment.Left);
this.m_Site_List.Columns.Insert(1, "拠点名", 120, HorizontalAlignment.Left);
this.m_Site_List.Columns.Insert(2, "郵便番号", 120, HorizontalAlignment.Left);
this.m_Site_List.Columns.Insert(3, "住所", 90, HorizontalAlignment.Left);
this.m_Site_List.Columns.Insert(4, "TEL/FAX", 80, HorizontalAlignment.Left);
this.m_Site_List.Columns.Insert(5, "ステータス", 50, HorizontalAlignment.Left);
this.m_Site_List.Columns.Insert(6, "カスタマ番号", 50, HorizontalAlignment.Left);
this.m_Site_List.Columns.Insert(7, "カスタマ名", 120, HorizontalAlignment.Left);
this.m_Site_List.Columns.Insert(8, "システム番号", 120, HorizontalAlignment.Left);
this.m_Site_List.Columns.Insert(9, "システム名", 120, HorizontalAlignment.Left);
this.m_Site_List.Columns.Insert(10, "更新日時", 50, HorizontalAlignment.Left);
this.m_Site_List.Columns.Insert(11, "更新者", 50, HorizontalAlignment.Left);
//リストビューを初期化する
site_list = new DataTable("table1");
site_list.Columns.Add("No", Type.GetType("System.Int32"));
site_list.Columns.Add("拠点名", Type.GetType("System.String"));
site_list.Columns.Add("郵便番号", Type.GetType("System.String"));
site_list.Columns.Add("住所", Type.GetType("System.String"));
site_list.Columns.Add("TEL/FAX", Type.GetType("System.String"));
site_list.Columns.Add("ステータス", Type.GetType("System.String"));
site_list.Columns.Add("カスタマ番号", Type.GetType("System.String"));
site_list.Columns.Add("カスタマ名", Type.GetType("System.String"));
site_list.Columns.Add("システム番号", Type.GetType("System.String"));
site_list.Columns.Add("システム名", Type.GetType("System.String"));
site_list.Columns.Add("更新日時", Type.GetType("System.String"));
site_list.Columns.Add("更新者", Type.GetType("System.String"));
//リストに表示
if (dset.site_L != null)
{
m_Site_List.BeginUpdate();
foreach (siteDS s_ds in dset.site_L)
{
DataRow urow = site_list.NewRow();
urow["No"] = s_ds.siteno;
urow["拠点名"] = s_ds.sitename;
urow["郵便番号"] = s_ds.address1;
urow["住所"] = s_ds.address2;
urow["TEL/FAX"] = s_ds.telno;
urow["ステータス"] = s_ds.status;
urow["カスタマ番号"] = s_ds.userno;
urow["カスタマ名"] = s_ds.username;
urow["システム番号"] = s_ds.systemno;
urow["システム名"] = s_ds.systemname;
urow["更新日時"] = s_ds.chk_date;
urow["更新者"] = s_ds.chk_name_id;
site_list.Rows.Add(urow);
}
this.m_Site_List.VirtualListSize = site_list.Rows.Count;
this.m_Site_List.AutoResizeColumns(ColumnHeaderAutoResizeStyle.HeaderSize);
m_Site_List.EndUpdate();
}
}
//検索ボタン
private void m_select_btn_Click(object sender, EventArgs e)
{
m_customertantouList.Clear();
DISP_dataSet dset = new DISP_dataSet();
Dictionary <string, string> param_dict = new Dictionary <string, string>();
Class_Detaget dg = new Class_Detaget();
if (m_selecttext.Text != "")
{
if (this.m_selectCombo.SelectedIndex.ToString() != "")
{
switch (this.m_selectCombo.SelectedIndex)
{
//担当者番号
case 0:
param_dict["user_tantou_no"] = m_selecttext.Text;
break;
case 1:
param_dict["user_tantou_name"] = m_selecttext.Text;
break;
case 2:
param_dict["user_tantou_name_kana"] = m_selecttext.Text;
break;
case 3:
param_dict["busho_name"] = m_selecttext.Text;
break;
case 4:
param_dict["telno1"] = m_selecttext.Text;
break;
case 5:
param_dict["telno2"] = m_selecttext.Text;
break;
case 6:
param_dict["yakusyoku"] = m_selecttext.Text;
break;
case 7:
if (m_selecttext.Text == "無効")
{
param_dict["status"] = "0";
}
else if (m_selecttext.Text == "有効")
{
param_dict["status"] = "1";
}
break;
case 8:
param_dict["biko"] = m_selecttext.Text;
break;
case 9:
param_dict["userno"] = m_selecttext.Text;
break;
//更新日時
case 10:
DateTime dt;
String str = m_selecttext.Text;
//入力された日付の形式の確認
if (DateTime.TryParse(str, out dt))
{
param_dict["chk_date"] = str;
}
else
{
MessageBox.Show("日付の形式が正しくありません。", "カスタマ担当者");
return;
}
break;
//更新者
case 11:
param_dict["chk_name_id"] = m_selecttext.Text;
break;
default:
break;
}
}
}
List <tantouDS> tantouList = dg.get_tantouName(param_dict, con);
this.m_customertantouList.FullRowSelect = true;
this.m_customertantouList.HideSelection = false;
this.m_customertantouList.HeaderStyle = ColumnHeaderStyle.Clickable;
this.m_customertantouList.Columns.Insert(0, "No", 30, HorizontalAlignment.Left);
this.m_customertantouList.Columns.Insert(1, "担当者名", 120, HorizontalAlignment.Left);
this.m_customertantouList.Columns.Insert(2, "担当者名カナ", 120, HorizontalAlignment.Left);
this.m_customertantouList.Columns.Insert(3, "部署名", 90, HorizontalAlignment.Left);
this.m_customertantouList.Columns.Insert(4, "電話番号1", 80, HorizontalAlignment.Left);
this.m_customertantouList.Columns.Insert(5, "電話番号2", 80, HorizontalAlignment.Left);
this.m_customertantouList.Columns.Insert(6, "役職", 50, HorizontalAlignment.Left);
this.m_customertantouList.Columns.Insert(7, "ステータス", 50, HorizontalAlignment.Left);
this.m_customertantouList.Columns.Insert(8, "備考", 50, HorizontalAlignment.Left);
this.m_customertantouList.Columns.Insert(9, "カスタマID", 50, HorizontalAlignment.Left);
this.m_customertantouList.Columns.Insert(10, "カスタマ名", 50, HorizontalAlignment.Left);
this.m_customertantouList.Columns.Insert(11, "更新日時", 50, HorizontalAlignment.Left);
this.m_customertantouList.Columns.Insert(12, "更新者", 50, HorizontalAlignment.Left);
//リストに表示
if (tantouList != null)
{
foreach (tantouDS t_ds in tantouList)
{
ListViewItem itemx1 = new ListViewItem();
itemx1.Text = t_ds.user_tantou_no;
itemx1.SubItems.Add(t_ds.user_tantou_name);
itemx1.SubItems.Add(t_ds.user_tantou_name_kana);
itemx1.SubItems.Add(t_ds.busho_name);
itemx1.SubItems.Add(t_ds.telno1);
itemx1.SubItems.Add(t_ds.telno2);
itemx1.SubItems.Add(t_ds.yakusyoku);
itemx1.SubItems.Add(t_ds.status);
itemx1.SubItems.Add(t_ds.biko);
itemx1.SubItems.Add(t_ds.userno);
itemx1.SubItems.Add(t_ds.username);
itemx1.SubItems.Add(t_ds.chk_date);
itemx1.SubItems.Add(t_ds.chk_name_id);
this.m_customertantouList.Items.Add(itemx1);
}
}
}
//検索ボタン
private void m_selectBtn_Click(object sender, EventArgs e)
{
m_System_List.Clear();
DISP_dataSet dset = new DISP_dataSet();
Dictionary <string, string> param_dict = new Dictionary <string, string>();
Class_Detaget dg = new Class_Detaget();
if (m_selecttext.Text != "")
{
if (this.m_selectKoumoku.SelectedIndex.ToString() != "")
{
switch (this.m_selectKoumoku.SelectedIndex)
{
//システム通番
case 0:
param_dict["systemno"] = m_selecttext.Text;
break;
//システム名
case 1:
param_dict["systemname"] = m_selecttext.Text;
break;
//システム名カナ
case 2:
param_dict["systemkana"] = m_selecttext.Text;
break;
//ステータス
case 3:
param_dict["status"] = m_selecttext.Text;
break;
//備考
case 4:
param_dict["biko"] = m_selecttext.Text;
break;
//カスタマ通番
case 5:
param_dict["userno"] = m_selecttext.Text;
break;
//更新日時
case 6:
DateTime dt;
String str = m_selecttext.Text;
//入力された日付の形式の確認
if (DateTime.TryParse(str, out dt))
{
param_dict["chk_date"] = str;
}
else
{
MessageBox.Show("日付の形式が正しくありません。", "拠点検索");
return;
}
break;
//更新者
case 7:
param_dict["chk_name_id"] = m_selecttext.Text;
break;
default:
break;
}
}
}
//システム一覧を取得する
dset = dg.getSelectSystem(param_dict, con, dset, true);
this.splitContainer1.SplitterDistance = 180;
this.m_System_List.FullRowSelect = true;
this.m_System_List.HideSelection = false;
this.m_System_List.HeaderStyle = ColumnHeaderStyle.Clickable;
this.m_System_List.Columns.Insert(0, "No", 30, HorizontalAlignment.Left);
this.m_System_List.Columns.Insert(1, "システム名", 200, HorizontalAlignment.Left);
this.m_System_List.Columns.Insert(2, "システム名カナ", 200, HorizontalAlignment.Left);
this.m_System_List.Columns.Insert(3, "カスタマ通番", 90, HorizontalAlignment.Left);
this.m_System_List.Columns.Insert(4, "カスタマ名", 200, HorizontalAlignment.Left);
this.m_System_List.Columns.Insert(5, "ステータス", 50, HorizontalAlignment.Left);
this.m_System_List.Columns.Insert(6, "備考", 200, HorizontalAlignment.Left);
this.m_System_List.Columns.Insert(7, "更新日時", 120, HorizontalAlignment.Left);
this.m_System_List.Columns.Insert(8, "更新者", 50, HorizontalAlignment.Left);
//リストに表示
if (dset.system_L != null)
{
foreach (systemDS s_ds in dset.system_L)
{
ListViewItem itemx1 = new ListViewItem();
itemx1.Text = s_ds.systemno;
itemx1.SubItems.Add(s_ds.systemname);
itemx1.SubItems.Add(s_ds.systemkana);
itemx1.SubItems.Add(s_ds.userno);
itemx1.SubItems.Add(s_ds.username);
itemx1.SubItems.Add(s_ds.status);
itemx1.SubItems.Add(s_ds.biko);
itemx1.SubItems.Add(s_ds.chk_date);
itemx1.SubItems.Add(s_ds.chk_name_id);
this.m_System_List.Items.Add(itemx1);
}
}
}
//検索ボタン
private void m_selectBtn_Click(object sender, EventArgs e)
{
m_Customer_List.Clear();
DISP_dataSet dset = new DISP_dataSet();
Dictionary <string, string> param_dict = new Dictionary <string, string>();
Class_Detaget dg = new Class_Detaget();
if (m_selecttext.Text != "")
{
if (this.m_selectKoumoku.SelectedIndex.ToString() != "")
{
switch (this.m_selectKoumoku.SelectedIndex)
{
//カスタマ通番
case 0:
param_dict["userno"] = m_selecttext.Text;
break;
//カスタマID
case 1:
param_dict["customerID"] = m_selecttext.Text;
break;
//カスタマ名
case 2:
param_dict["username"] = m_selecttext.Text;
break;
//カスタマ名カナ
case 3:
param_dict["username_kana"] = m_selecttext.Text;
break;
//カスタマ名略称
case 4:
param_dict["username_sum"] = m_selecttext.Text;
break;
//有効/無効
case 5:
if (m_selecttext.Text == "無効")
{
param_dict["status"] = "0";
}
else if (m_selecttext.Text == "有効")
{
param_dict["status"] = "1";
}
break;
//レポート出力有無
case 6:
if (m_selecttext.Text == "無効")
{
param_dict["report_status"] = "0";
}
else if (m_selecttext.Text == "有効")
{
param_dict["report_status"] = "1";
}
break;
//備考
case 7:
param_dict["biko"] = m_selecttext.Text;
break;
//更新日時
case 8:
DateTime dt;
String str = m_selecttext.Text;
//入力された日付の形式の確認
if (DateTime.TryParse(str, out dt))
{
param_dict["chk_date"] = str;
}
else
{
MessageBox.Show("日付の形式が正しくありません。", "カスタマ検索");
return;
}
break;
//更新者
case 9:
param_dict["chk_name_id"] = m_selecttext.Text;
break;
default:
break;
}
}
}
dset = dg.getSelectUser(param_dict, con, dset, true);
this.splitContainer1.SplitterDistance = 220;
this.m_Customer_List.FullRowSelect = true;
this.m_Customer_List.HideSelection = false;
this.m_Customer_List.HeaderStyle = ColumnHeaderStyle.Clickable;
this.m_Customer_List.Columns.Insert(0, "No", 30, HorizontalAlignment.Left);
this.m_Customer_List.Columns.Insert(1, "カスタマID", 50, HorizontalAlignment.Left);
this.m_Customer_List.Columns.Insert(2, "カスタマ名", 200, HorizontalAlignment.Left);
this.m_Customer_List.Columns.Insert(3, "カスタマ名カナ", 200, HorizontalAlignment.Left);
this.m_Customer_List.Columns.Insert(4, "カスタマ名略称", 100, HorizontalAlignment.Left);
this.m_Customer_List.Columns.Insert(5, "有効/無効", 40, HorizontalAlignment.Left);
this.m_Customer_List.Columns.Insert(6, "SLO対象", 40, HorizontalAlignment.Left);
this.m_Customer_List.Columns.Insert(7, "備考", 300, HorizontalAlignment.Left);
this.m_Customer_List.Columns.Insert(8, "更新日時", 120, HorizontalAlignment.Left);
this.m_Customer_List.Columns.Insert(9, "更新者", 120, HorizontalAlignment.Left);
//リストに表示
if (dset.user_L != null)
{
foreach (userDS t_ds in dset.user_L)
{
ListViewItem itemx1 = new ListViewItem();
itemx1.Text = t_ds.userno;
itemx1.SubItems.Add(t_ds.customerID);
itemx1.SubItems.Add(t_ds.username);
itemx1.SubItems.Add(t_ds.username_kana);
itemx1.SubItems.Add(t_ds.username_sum);
itemx1.SubItems.Add(t_ds.status);
itemx1.SubItems.Add(t_ds.report_status);
itemx1.SubItems.Add(t_ds.biko);
itemx1.SubItems.Add(t_ds.chk_date);
itemx1.SubItems.Add(t_ds.chk_name_id);
this.m_Customer_List.Items.Add(itemx1);
}
}
}
//検索ボタン
private void m_selectBtn_Click(object sender, EventArgs e)
{
m_InterfaceList.Clear();
DISP_dataSet dset = new DISP_dataSet();
Dictionary <string, string> param_dict = new Dictionary <string, string>();
Class_Detaget dg = new Class_Detaget();
String str;
if (m_selecttext.Text != "")
{
if (this.m_selectKoumoku.SelectedIndex.ToString() != "")
{
switch (this.m_selectKoumoku.SelectedIndex)
{
case 0:
param_dict["kennshino"] = m_selecttext.Text;
break;
//ホスト名
case 1:
param_dict["interfacename"] = m_selecttext.Text;
break;
case 2:
if (m_selecttext.Text == "無効")
{
param_dict["status"] = "0";
}
else if (m_selecttext.Text == "有効")
{
param_dict["status"] = "1";
}
break;
case 3:
param_dict["type"] = m_selecttext.Text;
break;
case 4:
param_dict["kanshi"] = m_selecttext.Text;
break;
case 5:
param_dict["border"] = m_selecttext.Text;
break;
case 6:
param_dict["IPaddress"] = m_selecttext.Text;
break;
case 7:
param_dict["IPaddressNAT"] = m_selecttext.Text;
break;
case 8:
param_dict["biko"] = m_selecttext.Text;
break;
case 9:
param_dict["userno"] = m_selecttext.Text;
break;
case 10:
param_dict["systemno"] = m_selecttext.Text;
break;
case 11:
param_dict["siteno"] = m_selecttext.Text;
break;
case 12:
param_dict["host_no"] = m_selecttext.Text;
break;
//更新日時
case 13:
DateTime dt;
str = m_selecttext.Text;
//入力された日付の形式の確認
if (DateTime.TryParse(str, out dt))
{
param_dict["chk_date"] = str;
}
else
{
MessageBox.Show("日付の形式が正しくありません。", "監視インターフェイス検索");
return;
}
break;
//更新者
case 14:
param_dict["chk_name_id"] = m_selecttext.Text;
break;
default:
break;
}
}
}
//まず件数を取得する
Int64 count = dg.getSelectInterfaceCount(param_dict, con, dset, true);
if (MessageBox.Show(count.ToString() + "件ヒットしました。表示しますか？", "監視インターフェイス", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No)
{
return;
}
//インターフェイス一覧を取得する
dset = dg.getSelectInterface(param_dict, con, dset, true);
this.splitContainer1.SplitterDistance = 250;
this.m_InterfaceList.VirtualMode = true;
// １行全体選択
this.m_InterfaceList.FullRowSelect = true;
this.m_InterfaceList.HideSelection = false;
this.m_InterfaceList.HeaderStyle = ColumnHeaderStyle.Clickable;
//Hook up handlers for VirtualMode events.
this.m_InterfaceList.RetrieveVirtualItem += new RetrieveVirtualItemEventHandler(InterfaceList_RetrieveVirtualItem);
this.m_InterfaceList.AutoResizeColumns(ColumnHeaderAutoResizeStyle.HeaderSize);
this.m_InterfaceList.Scrollable = true;
this.m_InterfaceList.Columns.Insert(0, "No", 30, HorizontalAlignment.Left);
this.m_InterfaceList.Columns.Insert(1, "インターフェイス名", 120, HorizontalAlignment.Left);
this.m_InterfaceList.Columns.Insert(2, "ステータス", 90, HorizontalAlignment.Left);
this.m_InterfaceList.Columns.Insert(3, "監視タイプ", 90, HorizontalAlignment.Left);
this.m_InterfaceList.Columns.Insert(4, "監視項目名", 80, HorizontalAlignment.Left);
this.m_InterfaceList.Columns.Insert(5, "閾値", 50, HorizontalAlignment.Left);
this.m_InterfaceList.Columns.Insert(6, "IPアドレス", 50, HorizontalAlignment.Left);
this.m_InterfaceList.Columns.Insert(7, "IPアドレス(NAT)", 50, HorizontalAlignment.Left);
this.m_InterfaceList.Columns.Insert(8, "備考", 50, HorizontalAlignment.Left);
this.m_InterfaceList.Columns.Insert(9, "カスタマ番号", 50, HorizontalAlignment.Left);
this.m_InterfaceList.Columns.Insert(10, "システム通番番号", 50, HorizontalAlignment.Left);
this.m_InterfaceList.Columns.Insert(11, "拠点通番", 50, HorizontalAlignment.Left);
this.m_InterfaceList.Columns.Insert(12, "ホスト通番", 50, HorizontalAlignment.Left);
this.m_InterfaceList.Columns.Insert(13, "更新日時", 50, HorizontalAlignment.Left);
this.m_InterfaceList.Columns.Insert(14, "更新者", 50, HorizontalAlignment.Left);
//リストビューを初期化する
interface_list = new DataTable("table1");
interface_list.Columns.Add("No", Type.GetType("System.Int32"));
interface_list.Columns.Add("インターフェイス名", Type.GetType("System.String"));
interface_list.Columns.Add("ステータス", Type.GetType("System.String"));
interface_list.Columns.Add("監視タイプ", Type.GetType("System.String"));
interface_list.Columns.Add("監視項目名", Type.GetType("System.String"));
interface_list.Columns.Add("閾値", Type.GetType("System.String"));
interface_list.Columns.Add("IPアドレス", Type.GetType("System.String"));
interface_list.Columns.Add("IPアドレス(NAT)", Type.GetType("System.String"));
interface_list.Columns.Add("備考", Type.GetType("System.String"));
interface_list.Columns.Add("カスタマ番号", Type.GetType("System.String"));
interface_list.Columns.Add("システム通番番号", Type.GetType("System.String"));
interface_list.Columns.Add("拠点通番", Type.GetType("System.String"));
interface_list.Columns.Add("ホスト通番", Type.GetType("System.String"));
interface_list.Columns.Add("更新日時", Type.GetType("System.String"));
interface_list.Columns.Add("更新者", Type.GetType("System.String"));
//リストに表示
if (dset.watch_L != null)
{
m_InterfaceList.BeginUpdate();
foreach (watch_InterfaceDS s_ds in dset.watch_L)
{
DataRow urow = interface_list.NewRow();
urow["No"] = s_ds.watch_Interfaceno;
urow["インターフェイス名"] = s_ds.interfacename;
urow["ステータス"] = s_ds.status;
urow["監視タイプ"] = s_ds.type;
urow["監視項目名"] = s_ds.kanshi;
urow["閾値"] = s_ds.border;
urow["IPアドレス"] = s_ds.IPaddress;
urow["IPアドレス(NAT)"] = s_ds.IPaddressNAT;
urow["備考"] = s_ds.biko;
urow["カスタマ番号"] = s_ds.userno;
urow["システム通番番号"] = s_ds.systemno;
urow["拠点通番"] = s_ds.siteno;
urow["ホスト通番"] = s_ds.host_no;
urow["更新日時"] = s_ds.chk_date;
urow["更新者"] = s_ds.chk_name_id;
interface_list.Rows.Add(urow);
}
this.m_InterfaceList.VirtualListSize = interface_list.Rows.Count;
this.m_InterfaceList.AutoResizeColumns(ColumnHeaderAutoResizeStyle.HeaderSize);
m_InterfaceList.EndUpdate();
}
}
//検索ボタン
private void m_selectBtn_Click(object sender, EventArgs e)
{
m_kaisenList.Clear();
DISP_dataSet dset = new DISP_dataSet();
Dictionary <string, string> param_dict = new Dictionary <string, string>();
Class_Detaget dg = new Class_Detaget();
if (m_selecttext.Text != "")
{
if (this.m_selectKoumoku.SelectedIndex.ToString() != "")
{
switch (this.m_selectKoumoku.SelectedIndex)
{
case 0:
param_dict["kaisenno"] = m_selecttext.Text;
break;
case 1:
if (m_selecttext.Text == "無効")
{
param_dict["status"] = "0";
}
else if (m_selecttext.Text == "有効")
{
param_dict["status"] = "1";
}
break;
//ホスト名日本
case 2:
param_dict["career"] = m_selecttext.Text;
break;
case 3:
param_dict["type"] = m_selecttext.Text;
break;
case 4:
param_dict["kaisenid"] = m_selecttext.Text;
break;
case 5:
param_dict["isp"] = m_selecttext.Text;
break;
case 6:
param_dict["servicetype"] = m_selecttext.Text;
break;
case 7:
param_dict["serviceid"] = m_selecttext.Text;
break;
case 8:
param_dict["userno"] = m_selecttext.Text;
break;
case 9:
param_dict["systemno"] = m_selecttext.Text;
break;
case 10:
param_dict["siteno"] = m_selecttext.Text;
break;
case 11:
param_dict["host_no"] = m_selecttext.Text;
break;
case 12:
param_dict["telno"] = m_selecttext.Text;
break;
case 13:
param_dict["biko"] = m_selecttext.Text;
break;
//更新日時
case 14:
DateTime dt;
String str = m_selecttext.Text;
//入力された日付の形式の確認
if (DateTime.TryParse(str, out dt))
{
param_dict["start_date"] = str;
}
else
{
MessageBox.Show("日付の形式が正しくありません。", "監視インターフェイス検索");
return;
}
break;
//更新者
case 15:
param_dict["chk_name_id"] = m_selecttext.Text;
break;
default:
break;
}
}
}
//回線一覧を取得する
dset = dg.getSelectKaisenList(param_dict, con, dset);
this.splitContainer1.SplitterDistance = 218;
this.m_kaisenList.VirtualMode = true;
// １行全体選択
this.m_kaisenList.FullRowSelect = true;
this.m_kaisenList.HideSelection = false;
this.m_kaisenList.HeaderStyle = ColumnHeaderStyle.Clickable;
//Hook up handlers for VirtualMode events.
this.m_kaisenList.RetrieveVirtualItem += new RetrieveVirtualItemEventHandler(Kaisen_RetrieveVirtualItem);
this.m_kaisenList.AutoResizeColumns(ColumnHeaderAutoResizeStyle.HeaderSize);
this.m_kaisenList.Scrollable = true;
this.m_kaisenList.Columns.Insert(0, "No", 30, HorizontalAlignment.Left);
this.m_kaisenList.Columns.Insert(1, "ステータス", 50, HorizontalAlignment.Left);
this.m_kaisenList.Columns.Insert(2, "キャリア", 180, HorizontalAlignment.Left);
this.m_kaisenList.Columns.Insert(3, "回線種別", 180, HorizontalAlignment.Left);
this.m_kaisenList.Columns.Insert(4, "回線ID", 150, HorizontalAlignment.Left);
this.m_kaisenList.Columns.Insert(5, "ISP", 180, HorizontalAlignment.Left);
this.m_kaisenList.Columns.Insert(6, "サービス種別", 180, HorizontalAlignment.Left);
this.m_kaisenList.Columns.Insert(7, "サービスID", 180, HorizontalAlignment.Left);
this.m_kaisenList.Columns.Insert(8, "電話番号1", 70, HorizontalAlignment.Left);
this.m_kaisenList.Columns.Insert(9, "電話番号2", 70, HorizontalAlignment.Left);
this.m_kaisenList.Columns.Insert(10, "電話番号3", 70, HorizontalAlignment.Left);
this.m_kaisenList.Columns.Insert(11, "備考", 70, HorizontalAlignment.Left);
this.m_kaisenList.Columns.Insert(12, "カスタマ通番", 50, HorizontalAlignment.Left);
this.m_kaisenList.Columns.Insert(13, "システム通番", 50, HorizontalAlignment.Left);
this.m_kaisenList.Columns.Insert(14, "拠点通番", 50, HorizontalAlignment.Left);
this.m_kaisenList.Columns.Insert(15, "ホスト通番", 50, HorizontalAlignment.Left);
this.m_kaisenList.Columns.Insert(16, "更新日時", 120, HorizontalAlignment.Left);
this.m_kaisenList.Columns.Insert(17, "更新者", 50, HorizontalAlignment.Left);
//リストビューを初期化する
kaisen_list = new DataTable("kaisentable");
kaisen_list.Columns.Add("No", Type.GetType("System.Int32"));
kaisen_list.Columns.Add("ステータス", Type.GetType("System.String"));
kaisen_list.Columns.Add("キャリア", Type.GetType("System.String"));
kaisen_list.Columns.Add("回線種別", Type.GetType("System.String"));
kaisen_list.Columns.Add("回線ID", Type.GetType("System.String"));
kaisen_list.Columns.Add("ISP", Type.GetType("System.String"));
kaisen_list.Columns.Add("サービス種別", Type.GetType("System.String"));
kaisen_list.Columns.Add("サービスID", Type.GetType("System.String"));
kaisen_list.Columns.Add("電話番号1", Type.GetType("System.String"));
kaisen_list.Columns.Add("電話番号2", Type.GetType("System.String"));
kaisen_list.Columns.Add("電話番号3", Type.GetType("System.String"));
kaisen_list.Columns.Add("備考", Type.GetType("System.String"));
kaisen_list.Columns.Add("カスタマ通番", Type.GetType("System.String"));
kaisen_list.Columns.Add("システム通番", Type.GetType("System.String"));
kaisen_list.Columns.Add("拠点通番", Type.GetType("System.String"));
kaisen_list.Columns.Add("ホスト通番", Type.GetType("System.String"));
kaisen_list.Columns.Add("更新日時", Type.GetType("System.String"));
kaisen_list.Columns.Add("更新者", Type.GetType("System.String"));
//リストに表示
if (dset.kaisen_L != null)
{
m_kaisenList.BeginUpdate();
foreach (kaisenDS s_ds in dset.kaisen_L)
{
DataRow urow = kaisen_list.NewRow();
urow["No"] = s_ds.kaisenno;
urow["ステータス"] = s_ds.status;
urow["キャリア"] = s_ds.career;
urow["回線種別"] = s_ds.type;
urow["回線ID"] = s_ds.kaisenid;
urow["ISP"] = s_ds.isp;
urow["サービス種別"] = s_ds.servicetype;
urow["サービスID"] = s_ds.serviceid;
urow["電話番号1"] = s_ds.telno1;
urow["電話番号2"] = s_ds.telno2;
urow["電話番号3"] = s_ds.telno3;
urow["備考"] = s_ds.biko;
urow["カスタマ通番"] = s_ds.userno;
urow["システム通番"] = s_ds.systemno;
urow["拠点通番"] = s_ds.siteno;
urow["ホスト通番"] = s_ds.host_no;
urow["更新日時"] = s_ds.chk_date;
urow["更新者"] = s_ds.chk_name_id;
kaisen_list.Rows.Add(urow);
}
this.m_kaisenList.VirtualListSize = kaisen_list.Rows.Count;
this.m_kaisenList.AutoResizeColumns(ColumnHeaderAutoResizeStyle.HeaderSize);
m_kaisenList.EndUpdate();
}
}
//検索ボタン
private void m_selectBtn_Click(object sender, EventArgs e)
{
m_host_List.Clear();
DISP_dataSet dset = new DISP_dataSet();
Dictionary <string, string> param_dict = new Dictionary <string, string>();
Class_Detaget dg = new Class_Detaget();
if (m_selecttext.Text != "")
{
if (this.m_selectKoumoku.SelectedIndex.ToString() != "")
{
switch (this.m_selectKoumoku.SelectedIndex)
{
//ホスト通番
case 0:
param_dict["host_no"] = m_selecttext.Text;
break;
//ホスト名
case 1:
param_dict["hostname"] = m_selecttext.Text;
break;
//カスタマ通番
case 2:
param_dict["userno"] = m_selecttext.Text;
break;
case 3:
param_dict["systemno"] = m_selecttext.Text;
break;
case 4:
param_dict["siteno"] = m_selecttext.Text;
break;
case 5:
if (m_selecttext.Text == "有効")
{
param_dict["status"] = "1";
}
else if (m_selecttext.Text == "無効")
{
param_dict["status"] = "0";
}
break;
case 6:
param_dict["device"] = m_selecttext.Text;
break;
case 7:
param_dict["location"] = m_selecttext.Text;
break;
case 8:
param_dict["usefor"] = m_selecttext.Text;
break;
//設置機器ID
case 9:
param_dict["settikikiid"] = m_selecttext.Text;
break;
case 10:
DateTime dt;
String str = m_selecttext.Text;
//入力された日付の形式の確認
if (DateTime.TryParse(str, out dt))
{
param_dict["kansiStartdate"] = str;
}
else
{
MessageBox.Show("日付の形式が正しくありません。", "拠点検索");
return;
}
break;
case 11:
str = m_selecttext.Text;
//入力された日付の形式の確認
if (DateTime.TryParse(str, out dt))
{
param_dict["kansiEndsdate"] = str;
}
else
{
MessageBox.Show("日付の形式が正しくありません。", "拠点検索");
return;
}
break;
case 12:
param_dict["hosyukanri"] = m_selecttext.Text;
break;
case 13:
param_dict["hosyuinfo"] = m_selecttext.Text;
break;
case 14:
param_dict["biko"] = m_selecttext.Text;
break;
//更新日時
case 15:
str = m_selecttext.Text;
//入力された日付の形式の確認
if (DateTime.TryParse(str, out dt))
{
param_dict["chk_date"] = str;
}
else
{
MessageBox.Show("日付の形式が正しくありません。", "拠点検索");
return;
}
break;
//更新者
case 16:
param_dict["chk_name_id"] = m_selecttext.Text;
break;
default:
break;
}
}
}
//まず件数を取得する
Int64 count = dg.getSelectHostCount(param_dict, con, dset, true);
if (MessageBox.Show(count.ToString() + "件ヒットしました。表示しますか？", "ホスト", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No)
{
return;
}
//ホスト一覧を取得する
dset = dg.getSelectHost(param_dict, con, dset);
this.splitContainer1.SplitterDistance = 280;
this.m_host_List.VirtualMode = true;
// １行全体選択
this.m_host_List.FullRowSelect = true;
this.m_host_List.HideSelection = false;
this.m_host_List.HeaderStyle = ColumnHeaderStyle.Clickable;
//Hook up handlers for VirtualMode events.
this.m_host_List.RetrieveVirtualItem += new RetrieveVirtualItemEventHandler(Host_RetrieveVirtualItem);
this.m_host_List.AutoResizeColumns(ColumnHeaderAutoResizeStyle.HeaderSize);
this.m_host_List.Scrollable = true;
this.m_host_List.Columns.Insert(0, "No", 30, HorizontalAlignment.Left);
this.m_host_List.Columns.Insert(1, "ホスト名", 120, HorizontalAlignment.Left);
this.m_host_List.Columns.Insert(2, "ステータス", 90, HorizontalAlignment.Left);
this.m_host_List.Columns.Insert(3, "機種", 80, HorizontalAlignment.Left);
this.m_host_List.Columns.Insert(4, "設置場所", 50, HorizontalAlignment.Left);
this.m_host_List.Columns.Insert(5, "用途", 50, HorizontalAlignment.Left);
this.m_host_List.Columns.Insert(6, "設置機器ID", 120, HorizontalAlignment.Left);
this.m_host_List.Columns.Insert(7, "監視開始日時", 120, HorizontalAlignment.Left);
this.m_host_List.Columns.Insert(8, "監視終了日時", 120, HorizontalAlignment.Left);
this.m_host_List.Columns.Insert(9, "保守管理番号", 50, HorizontalAlignment.Left);
this.m_host_List.Columns.Insert(10, "保守情報", 50, HorizontalAlignment.Left);
this.m_host_List.Columns.Insert(11, "備考", 50, HorizontalAlignment.Left);
this.m_host_List.Columns.Insert(12, "カスタマ番号", 50, HorizontalAlignment.Left);
this.m_host_List.Columns.Insert(13, "システム通番番号", 50, HorizontalAlignment.Left);
this.m_host_List.Columns.Insert(14, "拠点通番", 50, HorizontalAlignment.Left);
this.m_host_List.Columns.Insert(15, "更新日時", 50, HorizontalAlignment.Left);
this.m_host_List.Columns.Insert(16, "更新者", 50, HorizontalAlignment.Left);
//リストビューを初期化する
host_list = new DataTable("table1");
host_list.Columns.Add("No", Type.GetType("System.Int32"));
host_list.Columns.Add("ホスト名", Type.GetType("System.String"));
host_list.Columns.Add("ステータス", Type.GetType("System.String"));
host_list.Columns.Add("機種", Type.GetType("System.String"));
host_list.Columns.Add("設置場所", Type.GetType("System.String"));
host_list.Columns.Add("用途", Type.GetType("System.String"));
host_list.Columns.Add("設置機器ID", Type.GetType("System.String"));
host_list.Columns.Add("監視開始日時", Type.GetType("System.String"));
host_list.Columns.Add("監視終了日時", Type.GetType("System.String"));
host_list.Columns.Add("保守管理番号", Type.GetType("System.String"));
host_list.Columns.Add("保守情報", Type.GetType("System.String"));
host_list.Columns.Add("備考", Type.GetType("System.String"));
host_list.Columns.Add("カスタマ番号", Type.GetType("System.String"));
host_list.Columns.Add("システム通番番号", Type.GetType("System.String"));
host_list.Columns.Add("拠点通番", Type.GetType("System.String"));
host_list.Columns.Add("更新日時", Type.GetType("System.String"));
host_list.Columns.Add("更新者", Type.GetType("System.String"));
//リストに表示
if (dset.host_L != null)
{
m_host_List.BeginUpdate();
foreach (hostDS s_ds in dset.host_L)
{
DataRow urow = host_list.NewRow();
urow["No"] = s_ds.host_no;
urow["ホスト名"] = s_ds.hostname;
urow["ステータス"] = s_ds.status;
urow["機種"] = s_ds.device;
urow["設置場所"] = s_ds.location;
urow["用途"] = s_ds.usefor;
urow["設置機器ID"] = s_ds.settikikiid;
urow["監視開始日時"] = s_ds.kansiStartdate;
urow["監視終了日時"] = s_ds.kansiEndsdate;
urow["保守管理番号"] = s_ds.hosyukanri;
urow["保守情報"] = s_ds.hosyuinfo;
urow["備考"] = s_ds.biko;
urow["カスタマ番号"] = s_ds.userno;
urow["システム通番番号"] = s_ds.systemno;
urow["拠点通番"] = s_ds.siteno;
urow["更新日時"] = s_ds.chk_date;
urow["更新者"] = s_ds.chk_name_id;
host_list.Rows.Add(urow);
}
this.m_host_List.VirtualListSize = host_list.Rows.Count;
this.m_host_List.AutoResizeColumns(ColumnHeaderAutoResizeStyle.HeaderSize);
m_host_List.EndUpdate();
}
}