//アドレス
private void getmailaddress(Dictionary <string, string> param_dict, NpgsqlConnection con)
{
m_addressslist.Clear();
Class_Detaget dg = new Class_Detaget();
List <MailaddressDS> addressList = new List <MailaddressDS>();
//アドレスを取得3は両方
addressList = dg.selectMailList(param_dict, con, "3");
this.m_addressslist.FullRowSelect = true;
this.m_addressslist.HideSelection = false;
this.m_addressslist.HeaderStyle = ColumnHeaderStyle.Clickable;
this.m_addressslist.Columns.Insert(0, "ユーザ区分", 100, HorizontalAlignment.Left);
this.m_addressslist.Columns.Insert(1, "ユーザ通番", 50, HorizontalAlignment.Left);
this.m_addressslist.Columns.Insert(2, "アドレス番号", 50, HorizontalAlignment.Left);
this.m_addressslist.Columns.Insert(3, "ユーザ名", 150, HorizontalAlignment.Left);
this.m_addressslist.Columns.Insert(4, "カスタマ名", 150, HorizontalAlignment.Left);
this.m_addressslist.Columns.Insert(5, "メールアドレス", 250, HorizontalAlignment.Left);
this.m_addressslist.Columns.Insert(6, "アドレス名", 250, HorizontalAlignment.Left);
this.m_addressslist.Columns.Insert(7, "更新日時", 120, HorizontalAlignment.Left);
this.m_addressslist.Columns.Insert(8, "更新者", 120, HorizontalAlignment.Left);
//リストに表示
if (addressList != null)
{
foreach (MailaddressDS ad_ds in addressList)
{
ListViewItem itemx1 = new ListViewItem();
string kubunstr = "";
if (ad_ds.kubun == "1")
{
kubunstr = "1:オペレータ";
}
else if (ad_ds.kubun == "2")
{
kubunstr = "2:カスタマ担当者";
}
itemx1.Text = kubunstr;
itemx1.SubItems.Add(ad_ds.opetantouno);
itemx1.SubItems.Add(ad_ds.addressNo);
itemx1.SubItems.Add(ad_ds.user_tantou_name);
itemx1.SubItems.Add(ad_ds.username);
itemx1.SubItems.Add(ad_ds.mailAddress);
itemx1.SubItems.Add(ad_ds.addressname);
itemx1.SubItems.Add(ad_ds.chk_date);
itemx1.SubItems.Add(ad_ds.chk_name_id);
this.m_addressslist.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);
}
}