C# (CSharp) PostBundle PersonResultCtlの例

コード例 #1

ファイル: Sheet1.cs プロジェクト: stevesloka/bvcms

        void PeopleId_Change(Microsoft.Office.Interop.Excel.Range Target)
        {
            if (ignoreChanges)
                return;
            var c = Target as Excel.Range;

            var f = c.Cells[1, 3] as Excel.Range;
            f.Value2 = BundleFund.Value;
            var n = c.Cells[1, 4] as Excel.Range;

            if (Globals.ThisWorkbook.ClickToChange)
                return;
            if (c.Text.ToString() != "")
            {
                var ws = Globals.ThisWorkbook.ws;
                var header = Globals.ThisWorkbook.header;
                var a = ws.SearchPerson(header, c.Text.ToString(), "", "", "");
                if (a.Length == 1)
                {
                    n.Value2 = a[0].Name;
                    var ctl = new PersonResultCtl(a[0], null);
                    ctl.AddComment(n);
                }
            }
        }

コード例 #2

ファイル: Sheet1.cs プロジェクト: sengithub/SenSourcecode

        void PeopleId_Change(Microsoft.Office.Interop.Excel.Range Target)
        {
            if (ignoreChanges)
            {
                return;
            }
            var c = Target as Excel.Range;

            var f = c.Cells[1, 3] as Excel.Range;

            f.Value2 = BundleFund.Value;
            var n = c.Cells[1, 4] as Excel.Range;

            if (Globals.ThisWorkbook.ClickToChange)
            {
                return;
            }
            if (c.Text.ToString() != "")
            {
                var ws     = Globals.ThisWorkbook.ws;
                var header = Globals.ThisWorkbook.header;
                var a      = ws.SearchPerson(header, c.Text.ToString(), "", "", "");
                if (a.Length == 1)
                {
                    n.Value2 = a[0].Name;
                    var ctl = new PersonResultCtl(a[0], null);
                    ctl.AddComment(n);
                }
            }
        }