Example #1
0
        private List <OrigionLink> parseEntities(MySqlDataReader dr)
        {
            List <OrigionLink> results = new List <OrigionLink>();

            try
            {
                while (dr.Read())
                {
                    OrigionLink entity = new OrigionLink();
                    entity.ID           = dr.GetInt64("ID");
                    entity.QQOwner      = dr.GetString("QQOwner");
                    entity.RetrieveDate = dr.GetDateTime("RetrieveDate");
                    entity.Type         = dr.GetString("Type") ?? "";
                    entity.Name         = dr.GetString("Name");
                    entity.JoinLink     = dr.GetString("JoinLink");
                    entity.CreateTime   = dr.GetDateTime("CreateTime");
                    entity.ChangeTime   = dr.GetDateTime("ChangeTime");

                    results.Add(entity);
                }
            }
            finally
            {
                dr.Close();
                dr.Dispose();
            }
            return(results);
        }
Example #2
0
        public void TC04_GetQQTaoLunZuList()
        {
            OrigionLinkService olService = new OrigionLinkService();

            MsgManWindow mmw = new MsgManWindow();

            Mouse.Click(mmw.MsgManTabs.MultipleTalksTabPage);
            Mouse.Click(mmw.LeftList.MyMultipleTalk);

            WinListItem last = null;
            int         i    = 0;

            while (mmw.HasNext(mmw.MidList, i))
            {
                if (last != null)
                {
                    Mouse.Click(last);
                    Keyboard.SendKeys(KeyboardKeys.DOWN);
                }

                WinListItem item = mmw.Next(mmw.MidList, i);
                Mouse.DoubleClick(item);

                #region
                //获取聊天对话框
                Console.WriteLine("[{0}] 获取聊天对话框", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
                QQTalkWindow window = new QQTalkWindow();
                //获取工具条按钮
                Console.WriteLine("[{0}] 获取工具条按钮", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
                WinSplitButton btnJoinTalk = window.TalkToolBar.BtnJoinTalk;
                //点击“邀请加入多人聊天”
                Console.WriteLine("[{0}] 点击“邀请加入多人聊天”", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
                Mouse.Click(btnJoinTalk);

                //获取弹出窗口
                Console.WriteLine("[{0}] 获取弹出窗口", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
                JoinTalkWindow jtWin = new JoinTalkWindow();
                //等待弹出窗口显示完毕
                Console.WriteLine("[{0}] 等待弹出窗口显示完毕", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
                jtWin.JoinTalkMenu.JoinTalkItem.WaitForControlExist();
                //点击“复制邀请链接”
                Console.WriteLine("[{0}] 点击“复制邀请链接”", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
                //Mouse.Click(jtWin.JoinTalkMenu.JoinTalkItem);
                Keyboard.SendKeys(KeyboardKeys.DOWN);
                Keyboard.SendKeys(KeyboardKeys.DOWN);
                Keyboard.SendKeys(KeyboardKeys.ENTER);
                Console.WriteLine("[{0}] 休眠1秒钟", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
                Thread.Sleep(1000);

                //从黏贴板中读取新邀请链接
                Console.WriteLine("[{0}] 从黏贴板中读取新邀请链接", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
                string newLink = Clipboard.GetText();
                if (!string.IsNullOrWhiteSpace(newLink) && newLink.StartsWith("点击链接加入多人聊天"))
                {
                    newLink = Clipboard.GetText().Split("\r\n".ToCharArray())[1];
                }

                //关闭讨论组标签
                Console.WriteLine("[{0}] 关闭讨论组标签", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
                Keyboard.SendKeys(window, KeyboardKeys.ESC);
                #endregion

                OrigionLink link = new OrigionLink()
                {
                    QQOwner      = "",
                    RetrieveDate = DateTime.Parse(DateTime.Now.ToString("yyyy-MM-dd")),
                    Type         = "Z",
                    Name         = item.Name.Substring(0, 1000),
                    JoinLink     = newLink
                };

                try
                {
                    olService.Insert(link);
                }
                catch (Exception ex)
                {
                    Console.WriteLine(link.ToString());
                    Console.WriteLine(ex.Message);
                }

                last = item;
                //if (++i >= 595) break;
            }
        }
Example #3
0
 public void Insert(OrigionLink item)
 {
     BulkInsert(new List <OrigionLink>(new OrigionLink[] { item }));
 }