Exemple #1
0
        private void Test1()
        {
            OrderListHandler orderListHandler = new OrderListHandler("30155762", "Gm7PeLH6ZBRR", "5366be7b-97ff-4285-85ca-7c37d6a49ae5");
            var accessToken = GetAccessToken(orderListHandler._appKey, orderListHandler._appSecret, orderListHandler._refreshToken);
            var urlList     = orderListHandler.GetFindOrderListQueryUrlList(orderListHandler._appKey, orderListHandler._appSecret, accessToken);

            foreach (var url in urlList)
            {
                HttpHelper httpHelper = new HttpHelper();
                var        html       = httpHelper.GetHtmlByGet(url);
                orderListHandler.GetMainInfoDicList(html);
            }
        }
Exemple #2
0
        private void Process(Action <Exception> writeLog, Action adsl, string taskTableName)
        {
            MySqlHelper   taskHelper    = new MySqlHelper("127.0.0.1", "zhanxian", "root", "root");
            MySqlHelper   resultHelper  = new MySqlHelper("127.0.0.1", "zhanxian", "root", "root");
            TaskDbHandler taskDbHandler = new AliExpressTaskDbHandler(taskHelper);

            //设置任务表名
            taskDbHandler.TableName = taskTableName;

            ResultDbHandler resultDbHandler = new AliExpressResultDbHandler(resultHelper);
            string          accountId       = null;

            try
            {
                //var dic =
                //    taskDbHandler.GetSelectDicBySql(
                //        $"SELECT account_id,client_id,client_secret,refresh_token,queryDateSpan FROM {taskTableName} WHERE taskstatue = 1");


                var dic =
                    taskDbHandler.GetSelectDicBySqlWithLock(
                        $"SELECT account_id,client_id,client_secret,refresh_token,queryDateSpan FROM {taskTableName} WHERE taskstatue = 1 ORDER BY id LIMIT 1",
                        $"key_db.{taskTableName}.taskStatueEqual1",
                        id => taskDbHandler.Start(id)
                        );
                //dic输出
                dic.Print();
                ICollection <string> keys = dic.Keys;
                int rowCount = dic.GetRowCount();

                if (rowCount == 0)
                {
                    dic =
                        taskDbHandler.GetSelectDicBySqlWithLock(
                            $"SELECT account_id,client_id,client_secret,refresh_token,queryDateSpan FROM {taskTableName} WHERE taskstatue = 6 ORDER BY id LIMIT 1",
                            $"key_db.{taskTableName}.taskStatueEqual6",
                            id => taskDbHandler.Start(id)
                            );
                    //dic输出
                    dic.Print();
                    keys     = dic.Keys;
                    rowCount = dic.GetRowCount();
                }


                //数据库表一行一行处理
                for (var i = 0; i < rowCount; i++)
                {
                    try
                    {
                        var curDic = new Dictionary <string, object>();
                        foreach (var key in keys)
                        {
                            curDic.Add(key, dic[key][i]);
                        }
                        curDic.Print();
                        accountId = curDic["account_id"].ToString();

                        string clientId      = curDic["client_id"].ToString();
                        string clientSecret  = curDic["client_secret"].ToString();
                        string refreshToken  = curDic["refresh_token"].ToString();
                        string queryDateSpan = curDic["queryDateSpan"].ToString();
                        string tableName     = $"order_{accountId}";
                        ////设置任务表名
                        //taskDbHandler.TableName = taskTableName;
                        ////任务表设置开始状态
                        //taskDbHandler.Start(accountId);
                        string startDate;
                        string endDate;
                        //表存在处理
                        if (resultDbHandler.TableIfExists(tableName))
                        {
                            //读出lastDate,不存在则设置为当前时间
                            string lastDateInDb = resultDbHandler.GetEndDate(tableName, "gmtCreate");
                            endDate = DateTime.Now.ToString("MM/dd/yyyy hh:mm:ss");
                            if (string.IsNullOrEmpty(lastDateInDb))
                            {
                                startDate = GetDateTimeByDateSpan(endDate, queryDateSpan);
                            }
                            else
                            {
                                //var endDate = "20120801154220368+0800";
                                string   lastDateFormat = Regex.Match(lastDateInDb, @"\d{14}").Value;
                                DateTime dateTime       = DateTime.ParseExact(lastDateFormat, "yyyyMMddHHmmss",
                                                                              CultureInfo.CurrentCulture);
                                startDate = dateTime.ToString("MM/dd/yyyy hh:mm:ss");
                            }
                        }
                        //表不存在处理
                        else
                        {
                            //创建表
                            resultDbHandler.CreateTable(tableName);
                            endDate   = DateTime.Now.ToString("MM/dd/yyyy hh:mm:ss");
                            startDate = GetDateTimeByDateSpan(endDate, queryDateSpan);
                        }


                        OrderListHandler orderListHandler = new OrderListHandler(clientId, clientSecret, refreshToken);
                        var urlList = orderListHandler.GetFindOrderListQueryUrlIList(startDate, endDate);
                        foreach (var url in urlList)
                        {
                            HttpHelper httpHelper = new HttpHelper();
                            string     html       = httpHelper.GetHtmlByGet(url);

                            IList <IDictionary <string, object> > list = orderListHandler.GetMainInfoDicList(html,
                                                                                                             infoDic =>
                            {
                                resultDbHandler.InsertTableWithDicExistsUpdate(infoDic, tableName);
                            });
                        }

                        //订单数据导入成功操作
                        resultDbHandler.OrderImportSuccessfullyExistsUpdate(accountId,
                                                                            Convert.ToDateTime(startDate).ToString("yyyy/MM/dd hh:mm:ss"), "0",
                                                                            DateTime.Now.ToString(CultureInfo.CurrentCulture), "成功");
                        //任务表设置成功状态
                        taskDbHandler.Succeed(accountId);
                    }
                    catch (Exception e)
                    {
                        //任务表设置失败状态
                        taskDbHandler.Failed(accountId, e);
                        //写错误日志
                        writeLog?.Invoke(e);
                    }
                    //adsl换ip
                    adsl?.Invoke();
                }
            }
            catch (Exception exception)
            {
                //写错误日志
                writeLog?.Invoke(exception);
            }
        }