Ejemplo n.º 1
0
        private void button1_Click(object sender, EventArgs e)
        {
            if (!CheckDbParam())
            {
                MessageBox.Show("数据库参数错误,请检查!");
                return;
            }
            if (MessageBox.Show("从库中查询数据将清空您已经选择的商品,您确定要查询吗?", "提示", MessageBoxButtons.OKCancel) != DialogResult.OK)
            {
                return;
            }
            StringBuilder sb = new StringBuilder();

            lsProducts.Clear();
            //this.richTextBoxDisp.Clear();
            DisplaySelectProducts();

            //string queryBeginDate = GetTimeStampShort(DateTime.Parse(this.dateTimePickerQueryB.Value.ToString("yyyy-MM-dd 00:00:00")));
            //string queryFinishDate = GetTimeStampShort(DateTime.Parse(this.dateTimePickerQueryE.Value.ToString("yyyy-MM-dd 23:59:59")));
            string queryBeginDate  = GetTimeStampShort(this.dateTimePickerQueryB.Value);
            string queryFinishDate = GetTimeStampShort(this.dateTimePickerQueryE.Value);
            string queryCateID     = this.textBoxQueryCateID.Text.Trim();
            string queryKey        = this.textBoxQueryKey.Text.Trim();
            string queryNumIID     = this.textBoxQueryNumiiD.Text.Trim();

            try
            {
                if (string.IsNullOrEmpty(queryNumIID))
                {
                    sb.Append(string.Format("select * from {0} where add_time>='{1}' and add_time<='{2}' ",
                                            DBHelperServer.ProductTableName,
                                            queryBeginDate, queryFinishDate

                                            ));
                    if (!string.IsNullOrEmpty(queryCateID))
                    {
                        sb.Append(string.Format(" and cate_id='{0}'", queryCateID));
                    }
                    if (!string.IsNullOrEmpty(queryKey))
                    {
                        sb.Append(string.Format(" and title like '%{0}%'", queryKey));
                    }
                }
                else
                {
                    sb.Append(string.Format("select * from {0} where num_iid in(", DBHelperServer.ProductTableName));
                    MatchCollection mc = Regex.Matches(queryNumIID, @"\S+");
                    foreach (Match _m in mc)
                    {
                        sb.Append("'").Append(_m.Value).Append("',");
                    }
                    sb.Append("'')");
                }



                MySql.Data.MySqlClient.MySqlDataReader mySqlRd = DBHelperServer.GetReader(sb.ToString());
                while (mySqlRd.Read())
                {
                    ProductItem _item = new ProductItem();
                    _item.ID        = mySqlRd.GetInt32("id").ToString();
                    _item.sourceID  = mySqlRd.GetString("num_iid");
                    _item.Image     = mySqlRd.GetString("pic_url");
                    _item.Titel     = mySqlRd.GetString("title");
                    _item.Price     = mySqlRd.GetDecimal("coupon_price").ToString();
                    _item.OrigPrice = mySqlRd.GetDecimal("price").ToString();
                    _item._IsPost   = mySqlRd.GetInt32("ems").ToString();
                    _item._IsSale   = mySqlRd.GetInt32("pxj").ToString();
                    _item._dtBegin  = mySqlRd.GetInt32("coupon_start_time").ToString();
                    _item._dtFinish = mySqlRd.GetInt32("coupon_end_time").ToString();
                    _item._cateID   = mySqlRd.GetInt32("cate_id").ToString();

                    _item._IsTmall = mySqlRd.GetString("shop_type");
                    _item._dtAdd   = mySqlRd.GetInt32("add_time").ToString();

                    lsProducts.Add(_item);
                }
                mySqlRd.Close();
                SetLog(string.Format(@"查询到 {0} 条商品!!", lsProducts.Count));
                DisplaySelectProducts();
            }
            catch (System.Exception ex)
            {
                // this.richTextBoxDisp.AppendText(ex.Message);
                SetLog(ex.Message);
            }
        }
Ejemplo n.º 2
0
        void backgroundWorker1_DoWork(object sender, DoWorkEventArgs e)
        {
            //throw new NotImplementedException();
            for (int i = 0; i < lsProducts.Count; i++)
            {
                if (this.backgroundWorker1.CancellationPending)
                {
                    break;
                }
                try
                {
                    string      cmdStr = string.Empty;
                    ProductItem _item  = lsProducts[i];
                    if (CfgOnlyUpdatePicUrl)
                    {
                        #region 只更新图片Url入库处理
                        cmdStr = string.Format(@"Update {0} set pic_url='{1}'  where num_iid='{2}'",
                                               DBHelperServer.ProductTableName, _item.Image, _item.sourceID.Trim());
                        int hr = DBHelperServer.ExecuteCommand(cmdStr);
                        if (hr <= 0)
                        {
                            //SetLog(string.Format("{0} 库中已存在!", lsProducts[i].sourceID));
                        }
                        else
                        {
                            SetLog(string.Format("{0} 商品图片地址修改成功!", lsProducts[i].sourceID));
                        }
                        #endregion
                    }
                    else
                    {
                        #region 正常入库处理

                        if (string.IsNullOrEmpty(_item.ID))
                        {
                            cmdStr = string.Format(@"INSERT IGNORE INTO `{11}` VALUES (NULL,'9999','{0}','0','1','{1}','{2}',NULL,NULL,'萌黛儿旗舰店',NULL,'1','admin','{3}',NULL,'{4}',NULL,'2277','0.00','0','{5}','6700','{6}','{7}','1','underway',NULL,'{12}',NULL,'{8}','{9}',NULL,NULL,NULL,'0','1','9844','0',NULL,NULL,NULL,'{10}','0','0',NULL)",
                                                   //ProductItem.cateID,
                                                   lsProducts[i]._cateID,
                                                   lsProducts[i].sourceID,
                                                   lsProducts[i].Titel,
                                                   lsProducts[i].Image,
                                                   lsProducts[i].OrigPrice,
                                                   lsProducts[i].Price,
                                                   //ProductItem.dtBegin,
                                                   //ProductItem.dtFinish,
                                                   //ProductItem.IsPost,
                                                   //ProductItem.IsSale,
                                                   lsProducts[i]._dtBegin,
                                                   lsProducts[i]._dtFinish,
                                                   lsProducts[i]._IsPost,
                                                   lsProducts[i]._IsSale,

                                                   //GetTimeStampShort(),
                                                   lsProducts[i]._dtAdd,
                                                   DBHelperServer.ProductTableName,
                                                   lsProducts[i]._IsTmall
                                                   );
                        }
                        else
                        {
                            cmdStr = string.Format(@"Update {0} set coupon_start_time='{1}',coupon_end_time='{2}',ems='{3}',pxj='{4}',cate_id='{6}',shop_type='{7}',add_time='{8}',title='{9}'  where id='{5}'",
                                                   DBHelperServer.ProductTableName, _item._dtBegin, _item._dtFinish, _item._IsPost, _item._IsSale, _item.ID, _item._cateID, _item._IsTmall, _item._dtAdd, _item.Titel);
                        }

                        int hr = DBHelperServer.ExecuteCommand(cmdStr);
                        if (hr <= 0)
                        {
                            SetLog(string.Format("{0} 库中已存在!", lsProducts[i].sourceID));
                        }
                        else
                        {
                            SetLog(string.Format("{0}入库成功!", lsProducts[i].sourceID));
                        }

                        #endregion
                    }
                }
                catch (System.Exception ex)
                {
                    Console.WriteLine(ex.Message);
                    SetLog(string.Format("商品{0}入库错误!", lsProducts[i].sourceID));
                }
                this.backgroundWorker1.ReportProgress(i);
            }
        }