Пример #1
0
        //システム情報の表示
        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);
            }
        }
Пример #2
0
        //検索ボタン
        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;
        }
Пример #3
0
        //検索ボタン
        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;
            // 1行全体選択
            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();
            }
        }
Пример #4
0
        //インターフェイス
        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);
            }
        }
Пример #5
0
        //ホスト
        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);
            }
        }
Пример #6
0
        //拠点情報一覧の表示
        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);
            }
        }
Пример #7
0
        //対応状況を取得する
        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);
                }
            }
        }
Пример #8
0
        //検索ボタン
        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);
        }
Пример #9
0
        //検索ボタン
        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);
                }
            }
        }
Пример #10
0
        //検索ボタン
        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);
            }
        }
Пример #11
0
        //検索ボタン
        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;
            // 1行全体選択
            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();
            }
        }
Пример #12
0
        //検索ボタン
        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);
                }
            }
        }
Пример #13
0
        //検索ボタン
        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);
                }
            }
        }
Пример #14
0
        //検索ボタン
        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);
                }
            }
        }
Пример #15
0
        //検索ボタン
        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;
            // 1行全体選択
            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();
            }
        }
Пример #16
0
        //検索ボタン
        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;
            // 1行全体選択
            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();
            }
        }
Пример #17
0
        //検索ボタン
        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;
            // 1行全体選択
            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();
            }
        }