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