コード例 #1
0
        /// <summary>
        /// 进货单打印
        /// </summary>
        /// <param name="ssql"></param>
        /// <returns></returns>
        public bool JHinto(int category_id, string title, string zhaiyao, string content, string add_time, string zhuzai)
        {
            string gsql = "insert into dt_article(channel_id,category_id,call_index,title,link_url,img_url,seo_title,seo_keywords,seo_description,zhaiyao,content,sort_id,click,status,groupids_view,vote_id,is_top,is_red,is_hot,is_slide,is_sys,is_msg,user_name,add_time,update_time)values(1," + category_id + ",'','" + title + "','','','" + title + "','','','" + zhaiyao + "','" + content + "',99,0,0,'',0,0,0,0,0,1,1,'admin','" + add_time + "',NULL)";
            int    PU   = Ms.IntExeSQLNonQuery(gsql);
            string Sql  = "insert into dt_article_attribute_value([article_id],[source],[author])values(" + PU + ",'" + zhuzai + "','" + zhuzai + "')";

            return(Ms.ExeSQLNonQuery(Sql));
        }
コード例 #2
0
        private void button4_Click(object sender, EventArgs e)
        {
            string IshopItemID = this.comboBox1.Text;
            string delSql1     = "delete from hqUVList where ItemID='" + IshopItemID + "'";
            string delSql2     = "delete from hqUVListCUS where ItemID='" + IshopItemID + "'";
            string delSql3     = "delete from hqKeywordList where ItemID='" + IshopItemID + "'";
            string delSql4     = "delete from hqKeywordListCUS where ItemID='" + IshopItemID + "'";

            Ms.ExeSQLNonQuery(delSql1);
            Ms.ExeSQLNonQuery(delSql2);
            Ms.ExeSQLNonQuery(delSql3);
            Ms.ExeSQLNonQuery(delSql4);
            string Sql = "SELECT DISTINCT ItemID  FROM dbo.hqUVListCUS";

            comboBox1.DisplayMember = "ItemID"; //控件显示的列名
            comboBox1.ValueMember   = "ItemID"; //控件值的列名
            comboBox1.DataSource    = Ms.runSQLDataSet(Sql, "ss").Tables[0];
        }
コード例 #3
0
        public void GetshopCar(string URLA)
        {
            string KCDateTime = DateTime.Now.ToString("yyyy-MM-dd");

            PostServer.Getcookie = FPPcokk.ToString();
            //22m^2


            // string strpayRateIndex = "https://sycm.taobao.com/mc/mq/mkt/rank/item/hotpurpose.json?dateRange=" + KCDateTime + "%7C" + KCDateTime + "&dateType=day&pageSize=50&page=1&order=desc&orderBy=cartHits&cateId=350404&device=0&sellerType=-1&indexCode=cateRankId%2CcltHits%2CcartHits%2CtradeIndex&_=1536297303197&token=";
            PostServer.GetHTTPTaobao(URLA);
            string  txpayRateIndex = PostServer.GetHtml;
            JObject json           = (JObject)JsonConvert.DeserializeObject(txpayRateIndex);
            string  zone           = json["data"]["data"].ToString();
            // ShowInfo(zone);
            JArray results = JArray.Parse(zone);

            for (int i = 0; i < results.Count; i++)
            {
                string citemid, ctitle, cuvIndex, cpicUrl;
                citemid  = results[i]["itemId"].ToString();
                ctitle   = results[i]["shopName"].ToString();
                cuvIndex = results[i]["payItmCnt"].ToString();
                cpicUrl  = "https:" + results[i]["picUrl"].ToString();
                string Sql = "INSERT INTO [Dp_shopindex]([ItemID],[shopname],[uvIndex],[indexdate],[picUrl])VALUES('" + citemid + "','" + ctitle + "'," + Math.Ceiling(decimal.Parse(cuvIndex)) + ",'" + CDateTime + "','" + cpicUrl + "')";
                Ms.ExeSQLNonQuery(Sql);
            }
        }
コード例 #4
0
        public void Getshopindex()
        {
            DateTime BegDate = this.txtbegdate.Value;
            DateTime EndDate = this.txtenddate.Value;
            double   ts2     = EndDate.Subtract(BegDate).TotalDays;
            string   cItemid = txtItemID.Text;
            string   ccateId = txtcateId.Text;

            for (int i = 0; i < ts2; i++)
            {
                Thread.Sleep(5000);

                string KeUrl = "https://sycm.taobao.com/mc/rivalItem/analysis/getFlowSource.json?device=2&cateId=" + ccateId + "&selfItemId=" + cItemid + "&dateType=day&dateRange=" + BegDate.AddDays(i).ToString("yyyy-MM-dd") + "%7C" + BegDate.AddDays(i).ToString("yyyy-MM-dd") + "&indexCode=payByrCntIndex&orderBy=payByrCntIndex&order=desc&_=1537104746274&token=";
                PostServer.Getcookie = FPPcokk.ToString();
                PostServer.GetHTTPTaobao(KeUrl);

                string  txpayRateIndex = PostServer.GetHtml;
                JObject json           = (JObject)JsonConvert.DeserializeObject(txpayRateIndex);
                string  zone           = json["data"].ToString();
                JArray  results        = JArray.Parse(zone);
                for (int j = 0; j < results.Count; j++)
                {
                    decimal aa = decimal.Parse(results[j]["selfItemPayByrCntIndex"]["value"].ToString());
                    // ShowInfo("值:" + aa.ToString());
                    decimal bb = Math.Round(aa, 0);
                    //;
                    decimal cc = decimal.Parse(results[j]["selfItemPayByrCnt"]["value"].ToString());

                    string Sql = "INSERT INTO [DP_Num]([inNum],[outNum],[typeid])VALUES(" + bb + "," + cc + ",1)";
                    Ms.ExeSQLNonQuery(Sql);
                }
            }
            string Sqll = "Delete from DP_Num where outNum=0";

            Ms.ExeSQLNonQuery(Sqll);
        }
コード例 #5
0
ファイル: DPindex.cs プロジェクト: zhoulangAAA/GTSium
        /// <summary>
        /// 清空数据
        /// </summary>
        /// <param name="IshopItemID"></param>
        public void DelUVTom(string IshopItemID)
        {
            string delSql1 = "delete from hqUVList where ItemID='" + IshopItemID + "'";
            string delSql2 = "delete from hqUVListCUS where ItemID='" + IshopItemID + "'";
            string delSql3 = "delete from hqKeywordList where ItemID='" + IshopItemID + "'";
            string delSql4 = "delete from hqKeywordListCUS where ItemID='" + IshopItemID + "'";

            Ms.ExeSQLNonQuery(delSql1);
            Ms.ExeSQLNonQuery(delSql2);
            Ms.ExeSQLNonQuery(delSql3);
            Ms.ExeSQLNonQuery(delSql4);
        }
コード例 #6
0
        private void button2_Click(object sender, EventArgs e)
        {
            string Sqldel = "delete from hqKeyword  where  ItemID='" + CItemid + "' and DItemdate='" + CDateTime + "'";

            Ms.ExeSQLNonQuery(Sqldel);
        }
コード例 #7
0
        /// <summary>
        /// 大盘行情指数
        /// </summary>
        public void getallList()
        {
            int       HourNumber = DateTime.Now.Hour;
            DataTable shoptable  = new DataTable();
            string    Sqlshop    = "SELECT distinct top 70 [ItemID] ,[shopname],[uvIndex] ,[indexdate]  FROM [Dp_shopindex] where indexdate='" + CDateTime + "' order by uvIndex desc";

            shoptable = Ms.runSQLDataSet(Sqlshop, "ss").Tables[0];

            string Sqldels = "delete from DPrivalItem where getdate='" + CDateTime + "'";

            Ms.ExeSQLNonQuery(Sqldels);

            string SqlPE = "delete from DayDPAllListNumber where  DItemdate='" + CDateTime + "' and daytypeid=" + 0 + "";

            Ms.ExeSQLNonQuery(SqlPE);
            foreach (DataRow keydr in shoptable.Rows)
            {
                PostServer.Getcookie = FPPcokk.ToString();
                string CcateId, CItemid, CshopName;
                CItemid   = keydr["itemid"].ToString();
                CshopName = keydr["shopname"].ToString();
                CcateId   = "50012100";
                try
                {
                    string strpayRateIndex = "https://sycm.taobao.com/mc/rivalItem/analysis/getLiveCoreIndexes.json?dateType=today&dateRange=" + CDateTime + "%7C" + CDateTime + "&device=2&cateId=" + CcateId + "&rivalItem1Id=" + CItemid + "&_=1535966409385&token=";
                    PostServer.GetHTTPTaobaoTID(strpayRateIndex, TTid, "https://sycm.taobao.com/mc/ci/item/analysis?");
                    // PostServer.GetHTTPTaobao(strpayRateIndex);



                    string  txpayRateIndex = PostServer.GetHtml;
                    JObject EJson          = (JObject)JsonConvert.DeserializeObject(txpayRateIndex);
                    string  strJson        = EJson["data"].ToString();
                    Etrace  EtrJson        = new Etrace();
                    string  ToJson         = EtrJson.stringJson(strJson);

                    JObject json = (JObject)JsonConvert.DeserializeObject(ToJson);

                    decimal cartHits     = 0;
                    decimal cltHits      = 0;
                    decimal payItemCnt   = 0;
                    decimal payRateIndex = 0;
                    decimal seIpvUvHits  = 0;
                    decimal tradeIndex   = 0;
                    decimal uvIndex      = 0;
                    string  itemid       = "2342323423";
                    string  shopName     = "景宏";

                    cartHits     = decimal.Parse(json["data"]["rivalItem1"]["cartHits"]["value"].ToString());
                    cltHits      = decimal.Parse(json["data"]["rivalItem1"]["cltHits"]["value"].ToString());
                    payItemCnt   = decimal.Parse(json["data"]["rivalItem1"]["payItemCnt"]["value"].ToString());
                    payRateIndex = decimal.Parse(json["data"]["rivalItem1"]["payRateIndex"]["value"].ToString());
                    seIpvUvHits  = decimal.Parse(json["data"]["rivalItem1"]["seIpvUvHits"]["value"].ToString());
                    tradeIndex   = decimal.Parse(json["data"]["rivalItem1"]["tradeIndex"]["value"].ToString());
                    uvIndex      = decimal.Parse(json["data"]["rivalItem1"]["uvIndex"]["value"].ToString());
                    itemid       = CItemid;
                    shopName     = CshopName;


                    string SqlB = "INSERT INTO [DayDPAllListNumber]([shopName],[HouNumber],[typeID],[ItemID],[DItemdate],[daytypeid])VALUES('" + CItemid + shopName + "'," + payItemCnt + ",'今日','" + itemid + "','" + CDateTime + "'," + 0 + ")";
                    Ms.ExeSQLNonQuery(SqlB);

                    string SqlC = "INSERT INTO [DayDPAllListNumber]([shopName],[HouNumber],[typeID],[ItemID],[DItemdate],[daytypeid])VALUES('" + CItemid + shopName + "'," + uvIndex + ",'流量指数','" + itemid + "','" + CDateTime + "'," + 0 + ")";
                    Ms.ExeSQLNonQuery(SqlC);

                    string SqlD = "INSERT INTO [DayDPAllListNumber]([shopName],[HouNumber],[typeID],[ItemID],[DItemdate],[daytypeid])VALUES('" + CItemid + shopName + "'," + cartHits + ",'加购人气','" + itemid + "','" + CDateTime + "'," + 0 + ")";
                    Ms.ExeSQLNonQuery(SqlD);
                }
                catch (Exception)
                {
                    label2.Text = CItemid + "-";
                    //MessageBox.Show(CItemid);
                }
            }
        }
コード例 #8
0
ファイル: Dztc.cs プロジェクト: zhoulangAAA/GTSium
        /// <summary>
        /// 成交和指数
        /// </summary>
        public void getai()
        {
            int HourNumber = DateTime.Now.Hour;

            DataTable shoptable = new DataTable();
            string    Sqlshop   = "select itemid,shopname,IDshopName from dp_shop";

            shoptable = Ms.runSQLDataSet(Sqlshop, "ss").Tables[0];
            foreach (DataRow keydr in shoptable.Rows)
            {
                try
                {
                    PostServer.Getcookie = FPPcokk.ToString();
                    string CcateId, CItemid, CshopName;
                    CItemid   = keydr["itemid"].ToString();
                    CshopName = keydr["itemid"].ToString() + keydr["shopname"].ToString();
                    CcateId   = "50012100";
                    string strpayRateIndex = "https://sycm.taobao.com/mc/rivalItem/analysis/getLiveCoreTrend.json?dateType=today&dateRange=" + CDateTime + "%7C" + CDateTime + "&indexCode=&device=2&cateId=" + CcateId + "&rivalItem1Id=" + CItemid + "&_=1535966409385&token=";
                    //  string strpayRateIndex = "https://sycm.taobao.com/mc/rivalItem/analysis/getLiveCoreTrend.json?dateRange=" + CDateTime + "%7C" + CDateTime + "&dateType=today&device=2&sellerType=0&cateId=" + CcateId + "&itemId=" + CItemid + "&topType=flow&indexCode=uv&_=1535778429590&token=";
                    Thread.Sleep(5000);
                    PostServer.GetHTTPTaobaoTID(strpayRateIndex, TTid);
                    string txpayRateIndex = PostServer.GetHtml;

                    JObject EJson   = (JObject)JsonConvert.DeserializeObject(txpayRateIndex);
                    string  strJson = EJson["data"].ToString();
                    Etrace  EtrJson = new Etrace();
                    string  ToJson  = EtrJson.stringJson(strJson);

                    // PostServer.GetHTTPTaobao(strpayRateIndex);
                    //  string txpayRateIndex = PostServer.GetHtml;
                    JObject json = (JObject)JsonConvert.DeserializeObject(ToJson);
                    for (int j = 0; j <= 6; j++)
                    {
                        //支付转化指数
                        string typeIDstr        = "";
                        string jsonpayRateIndex = "";

                        if (j == 0)
                        {
                            jsonpayRateIndex = json["data"]["rivalItem1"]["cartHits"].ToString();
                            typeIDstr        = "cartHits";
                        }
                        if (j == 1)
                        {
                            jsonpayRateIndex = json["data"]["rivalItem1"]["cltHits"].ToString();
                            typeIDstr        = "cltHits";
                        }
                        if (j == 2)
                        {
                            jsonpayRateIndex = json["data"]["rivalItem1"]["payItemCnt"].ToString();
                            typeIDstr        = "payItemCnt";
                        }
                        if (j == 3)
                        {
                            jsonpayRateIndex = json["data"]["rivalItem1"]["payRateIndex"].ToString();
                            typeIDstr        = "payRateIndex";
                        }
                        if (j == 4)
                        {
                            jsonpayRateIndex = json["data"]["rivalItem1"]["seIpvUvHits"].ToString();
                            typeIDstr        = "seIpvUvHits";
                        }
                        if (j == 5)
                        {
                            jsonpayRateIndex = json["data"]["rivalItem1"]["tradeIndex"].ToString();
                            typeIDstr        = "tradeIndex";
                        }
                        if (j == 6)
                        {
                            jsonpayRateIndex = json["data"]["rivalItem1"]["uvIndex"].ToString();
                            typeIDstr        = "uvIndex";
                        }
                        //删除
                        string Sqldel = " delete from Dpnumber where ItemID='" + CItemid + "' and typeid='" + typeIDstr + "'";
                        Ms.ExeSQLNonQuery(Sqldel);
                        //ShowInfo(jsonpayRateIndex);
                        JArray payRateIndexJArray = JArray.Parse(jsonpayRateIndex);
                        for (int i = 0; i < payRateIndexJArray.Count; i++)
                        {
                            decimal NumberPayRate = 0;
                            if (payRateIndexJArray[i].ToString() != "")
                            {
                                NumberPayRate = Math.Ceiling(decimal.Parse(payRateIndexJArray[i].ToString()));
                            }
                            else
                            {
                                NumberPayRate = 0;
                            }
                            string Sql = "INSERT INTO [DPNumber]([shopName],[DateHour],[HouNumber],[typeID],[ItemID],[DItemdate])VALUES('" + CshopName + "'," + i + "," + NumberPayRate + ",'" + typeIDstr + "','" + CItemid + "','" + CDateTime + "')";
                            Ms.ExeSQLNonQuery(Sql);
                        }
                    }
                }
                catch (Exception)
                {
                    throw;
                }
            }


            this.ultraGridcnt.DataSource = Ms.runSQLDataSet(txtSql(CDateTime, "payItemCnt").ToString(), "ss").Tables[0];
            //this.ultraGrid2.DataSource = Ms.runSQLDataSet(txtSql(CDateTime, "uvIndex").ToString(), "ss").Tables[0];
            //this.ultraGrid5.DataSource = Ms.runSQLDataSet(txtSql(CDateTime, "cartHits").ToString(), "ss").Tables[0];
            this.ultraGrid3.DataSource = Ms.runSQLDataSet(txtSql(CDateTime, "payRateIndex").ToString(), "ss").Tables[0];

            ultraGridcnt.DisplayLayout.Bands[0].Columns["shopname"].Header.Fixed = true;
            //ultraGrid2.DisplayLayout.Bands[0].Columns["shopname"].Header.Fixed = true;
            //ultraGrid5.DisplayLayout.Bands[0].Columns["shopname"].Header.Fixed = true;
            ultraGrid3.DisplayLayout.Bands[0].Columns["shopname"].Header.Fixed = true;


            ultraGridcnt.DisplayLayout.Bands[0].Columns[HourNumber.ToString()].SortIndicator = Infragistics.Win.UltraWinGrid.SortIndicator.Descending;
            ultraGridcnt.DisplayLayout.Bands[0].Columns[HourNumber.ToString()].Header.Appearance.ForeColor = Color.Red;

            //ultraGrid2.DisplayLayout.Bands[0].Columns[HourNumber.ToString()].SortIndicator = Infragistics.Win.UltraWinGrid.SortIndicator.Descending;
            //ultraGrid2.DisplayLayout.Bands[0].Columns[HourNumber.ToString()].Header.Appearance.ForeColor = Color.Red;

            //ultraGrid5.DisplayLayout.Bands[0].Columns[HourNumber.ToString()].SortIndicator = Infragistics.Win.UltraWinGrid.SortIndicator.Descending;
            //ultraGrid5.DisplayLayout.Bands[0].Columns[HourNumber.ToString()].Header.Appearance.ForeColor = Color.Red;

            //ultraGrid3.DisplayLayout.Bands[0].Columns[HourNumber.ToString()].SortIndicator = Infragistics.Win.UltraWinGrid.SortIndicator.Descending;
            //ultraGrid3.DisplayLayout.Bands[0].Columns[HourNumber.ToString()].Header.Appearance.ForeColor = Color.Red;
        }
コード例 #9
0
        public void getai()
        {
            //  GetCook();
            int HourNumber = DateTime.Now.Hour;

            PostServer.Getcookie = FPPcokk.ToString();
            //空调扇 string KKurl = "https://sycm.taobao.com/ipoll/live/industry/showTopItems.json?cateId=50017589&cateLevel=2&device=0&limit=100&page=1&seller=-1&size=50&token=9592cec50&_=1532944703615";
            //蒸气刷 string KKurl = "https://sycm.taobao.com/ipoll/live/industry/showTopItems.json?cateId=50008553&cateLevel=2&device=0&limit=100&page=1&seller=-1&size=50&token=9592cec50&_=1532944703615";
            //女童装 string KKurl = "https://sycm.taobao.com/ipoll/live/industry/showTopItems.json?cateId=50010518&cateLevel=2&device=0&limit=100&page=1&seller=-1&size=50&token=9592cec50&_=1532944703615";
            string KKurl = "https://sycm.taobao.com/ipoll/live/industry/showTopItems.json?cateId=350404&cateLevel=2&device=0&limit=100&page=1&seller=-1&size=50&token=9592cec50&_=1532944703615";

            PostServer.GetHTTPTaobao(KKurl);
            string gHtml = PostServer.GetHtml;
            // ShowInfo(gHtml);
            //  Thread.Sleep(10000);

            JObject   json  = (JObject)JsonConvert.DeserializeObject(gHtml);
            string    zone  = json["data"]["data"]["topDatas"]["list"].ToString();
            string    zone1 = json["data"]["data"]["watchDatas"].ToString();
            DataTable dts   = JsonConvert.DeserializeObject <DataTable>(zone);
            DataTable dts1  = JsonConvert.DeserializeObject <DataTable>(zone1);

            this.ultraGrid1.DataSource = dts;
            string Sqldel = "delete from hqNumber  where DateHour=" + HourNumber;

            Ms.ExeSQLNonQuery(Sqldel);
            // ultraGrid1.DisplayLayout.Bands[0].Columns["ADDate"].SortIndicator = Infragistics.Win.UltraWinGrid.SortIndicator.Descending;
            // DataTable WXdts = JsonConvert.DeserializeObject<DataTable>(zone);
            // loadDataSet();
            DataTable dt = new DataTable();
            DataRow   dr = null;

            // dt = KeywordProdurcer.Tables[0];
            foreach (DataRow keydr in dts.Rows)
            {
                //    dr = dt.NewRow();
                //    dr["ID"] = 0;
                //    //
                //    dr["ItemID"] = ItemID.Text;
                //    //
                //    dr["keyword"] = keydr["keyword"].ToString();
                //    //
                //    dr["keypv"] = float.Parse(keydr["uv"].ToString());
                //    //
                //    dr["keydate"] = DateTime.Now.AddDays(i).ToString("yyyy-MM-dd"); ;
                //    //
                //    dr["keytype"] = 0;
                //    dt.Rows.Add(dr);
                string bb         = "店铺:" + keydr["shopName"].ToString();
                string aa         = "件数:" + keydr["paySubOrderCnt"].ToString();
                string shopNameID = keydr["itemid"].ToString() + keydr["shopName"].ToString();
                // ShowInfo(bb + "----" + aa);
                string Sql = "INSERT INTO [hqNumber]([shopName],[DateHour],[HouNumber])VALUES('" + shopNameID + "'," + HourNumber + "," + int.Parse(keydr["paySubOrderCnt"].ToString()) + "-(SELECT isnull(SUM(houNumber),0) FROM dbo.hqNumber where shopname='" + shopNameID + "' and DateHour<" + HourNumber + "))";



                //  ShowInfo(Sql);
                Ms.ExeSQLNonQuery(Sql);
            }
            string GSql = "select * from [Pnumber_View]";

            this.ultraGrid2.DataSource = Ms.runSQLDataSet(GSql, "ss").Tables[0];;
            //  ultraGrid3.DisplayLayout.Bands[0].Columns[HourNumber.ToString()].SortIndicator = Infragistics.Win.UltraWinGrid.SortIndicator.Descending;
        }