コード例 #1
0
ファイル: Form1.cs プロジェクト: pandyer/learngit
        private void MainThread()
        {
            TxtLog.WriteLine("数据库 chl", dbsp.ConnectionString);
            ThreadStart threadStart = delegate
            {
                do
                {
                    DataTable mqsDt  = null;
                    string    mqsSql = "select * from crm_attributesprodetect where   tools=" + textBox1.Text.Trim();
                    mqsDt = dbtool.ExecuteDataTable(mqsSql);
                    if (mqsDt != null && mqsDt.Rows.Count > 0)
                    {
                        Mypic mp = new Mypic();
                        this.SendMain(mqsDt);
                    }
                    Thread.Sleep(1000 * 10);//休息10s
                } while (true);
            };
            Thread thread = new Thread(threadStart);

            thread.IsBackground = true;
            thread.Start();
        }
コード例 #2
0
ファイル: Form1.cs プロジェクト: pandyer/learngit
        public void TaskDetection(Dictionary <string, Item> dicItem, SellerInfoEntity sellerinfo, string activityId, string activityType)
        {
            try
            {
                if (dicItem == null)
                {
                    TxtLog.WriteLine("getItemListErrorLog", sellerinfo.strUserNick + ":" + sellerinfo.strUserId + "=== :出现异常:获取宝贝为空" + sellerinfo.top_session);
                    return;
                }
                string      tableindex    = sellerinfo.strUserId.Substring(sellerinfo.strUserId.Length - 1, 1);
                MySqlHelper dbtool        = new MySqlHelper(DataType.ToolsProducts);
                string      sql           = "select proword from crm_prohibitedword where is_del='0'";
                string      sqluser       = "******" + tableindex + " where is_del='0' and seller_id =" + sellerinfo.strUserId;
                DataTable   dt            = dbtool.ExecuteDataTable(sql);
                DataTable   dtuser        = dbtool.ExecuteDataTable(sqluser);
                string      ItemImgsError = string.Empty;
                string      titleword     = string.Empty; //标题异常
                string      desc          = string.Empty; //详情异常
                string      pictext       = string.Empty;
                Mypic       myp           = new Mypic();
                int         itemcount     = 0;
                foreach (var item in dicItem.Values)
                {//'任务类型 0,文字检测 1图片检测 3 全部检测'
                    titleword = ""; desc = ""; ItemImgsError = "";
                    switch (activityType)
                    {
                    case "0":    //文字检测
                        myp.DetectionTitelDesc(dtuser, dt, item, ref titleword, ref desc);
                        break;

                    case "1":    //图片检测
                        myp.DetectionPIC(dtuser, dt, item, ref ItemImgsError, ref pictext);
                        break;

                    case "3":    //  全部检测'
                        myp.DetectionTitelDesc(dtuser, dt, item, ref titleword, ref desc);
                        myp.DetectionPIC(dtuser, dt, item, ref ItemImgsError, ref pictext);
                        break;

                    default:
                        break;
                    }
                    if (pictext != null && pictext.Contains("Open api daily request limit reached"))
                    {
                        LogApi.MonitorLog.Write(LogApi.LogType.Error, LogApi.Products.CRM, LogApi.VersionM.Standard, "图片检测欠费", sellerinfo.strUserId, sellerinfo.strUserNick, "", " 检测api欠费:活动id:" + activityId);
                        return;
                    }
                    else if (pictext != null && pictext.Contains("Open api qps request limit reached"))
                    {
                        LogApi.MonitorLog.Write(LogApi.LogType.Error, LogApi.Products.CRM, LogApi.VersionM.Standard, "图片检测欠费", sellerinfo.strUserId, sellerinfo.strUserNick, "", " 检测api限流 活动id:" + activityId);
                        return;
                    }
                    itemcount++;
                    ShowSend("开始检测" + DateTime.Now.ToString() + "宝贝id" + item.NumIid + itemcount + "/" + dicItem.Count + "用户id" + sellerinfo.strUserId);
                    //任务进度写进缓存
                    Sethc(activityId, itemcount + "/" + dicItem.Count);
                    string errors    = titleword + desc + ItemImgsError;
                    string tabelName = sellerinfo.strUserId.Substring(sellerinfo.strUserId.Length - 1);
                    if (!string.IsNullOrWhiteSpace(errors))
                    {
                        if (!string.IsNullOrWhiteSpace(ItemImgsError))
                        {
                            ItemImgsError = "[" + ItemImgsError.Substring(0, ItemImgsError.Length - 1) + "]";
                        }
                        string psql = string.Format("INSERT INTO  `crm_prohibiteword_detail{0}` (`id`, `mainid1`, `seller_id`, `num_id`, `title` , `pic_url`, `create_time`, `title_fail_reason`, `sellpoint_fail_reason`, `desc_fail_reason`, picture_fail_reason1,is_error) VALUES ('{1}', '{2}', '{3}', '{4}', '{5}' , '{6}', now(), '{7}', '', '{8}','{9}',{10} );", tabelName, Guid.NewGuid(), activityId, sellerinfo.strUserId, item.NumIid, item.Title.Replace("'", ""), item.PicUrl, titleword, desc, ItemImgsError, "1");
                        dbtool.ExecuteNonQuery(psql);
                    }
                    else
                    {
                        string psql = string.Format("INSERT INTO  `crm_prohibiteword_detail{0}` (`id`, `mainid1`, `seller_id`, `num_id`, `title` , `pic_url`, `create_time`, `title_fail_reason`, `sellpoint_fail_reason`, `desc_fail_reason`, picture_fail_reason1,is_error) VALUES ('{1}', '{2}', '{3}', '{4}', '{5}' , '{6}', now(), '{7}', '', '{8}','{9}' ,{10});", tabelName, Guid.NewGuid(), activityId, sellerinfo.strUserId, item.NumIid, item.Title.Replace("'", ""), item.PicUrl, titleword, desc, ItemImgsError, "0");
                        dbtool.ExecuteNonQuery(psql);
                    }
                }
            }
            catch (Exception ex)
            {
                TxtLog.WriteLine("图片违禁词检测", ex.ToString());
            }
        }