//検索ボタン
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();
}
}