示例#1
0
        public int InsertsObtainGzListSplit(ObtainGzListSplit splitmodel)
        {
            using (var helper = new SqlHelper())
            {
                int result = new InternalObtainGzListSplit(helper).InsertsObtainGzListSplit(splitmodel);

                return(result);
            }
        }
        internal ObtainGzListSplit GetObtainGzListSplit(int id)
        {
            string sql = @"SELECT [id]
      ,[total]
      ,[splitcount]
      ,[splitopenid]
      ,[splittime]
      ,[dealerid]
      ,[comid]
      ,[obtainno]
      ,[splitno]
      ,[issuc]
  FROM [EtownDB].[dbo].[ObtainGzList_Split] where id=@id";

            var cmd = sqlHelper.PrepareTextSqlCommand(sql);

            cmd.AddParam("@id", id);

            using (var reader = cmd.ExecuteReader())
            {
                ObtainGzListSplit u = null;
                if (reader.Read())
                {
                    u = new ObtainGzListSplit
                    {
                        Id          = reader.GetValue <int>("id"),
                        Total       = reader.GetValue <int>("total"),
                        Splitcount  = reader.GetValue <int>("splitcount"),
                        Splitopenid = reader.GetValue <string>("splitopenid"),
                        Splittime   = reader.GetValue <DateTime>("splittime"),
                        Dealerid    = reader.GetValue <int>("dealerid"),
                        Comid       = reader.GetValue <int>("comid"),
                        Obtainno    = reader.GetValue <int>("obtainno"),
                        Splitno     = reader.GetValue <int>("splitno"),
                        Issuc       = reader.GetValue <int>("issuc"),
                    };
                }
                return(u);
            }
        }
示例#3
0
        protected void Button2_Click(object sender, EventArgs e)
        {
            initJavascript();
            //获得以前总共抓取关注者列表的次数
            int MaxOtainNo = new ObtainGzListLogData().GetMaxObtainNo(comid);

            if (MaxOtainNo == 0)
            {
                Literal2.Text = "还未获取过微信关注者列表";
            }
            else
            {
                ////验证一下是否拆分过,拆分过不在拆分
                //bool issplited = false;
                //if (issplited == true)
                //{
                //    Literal2.Text = "关注者列表已经拆分过无需再分";
                //    return;
                //}
                //else
                //{
                //获得以前总共拆分过关注者列表的次数
                int MaxSplitNo = new ObtainGzListSplitData().MaxSplitNo(comid, MaxOtainNo);

                IList <ObtainGzListLog> loglist = new ObtainGzListLogData().GetObtaingzlistlog(comid, MaxOtainNo);
                if (loglist != null)
                {
                    string openidstr = "";
                    foreach (ObtainGzListLog log in loglist)
                    {
                        openidstr += log.Openid + ",";
                    }
                    openidstr = openidstr.Substring(0, openidstr.Length - 1);

                    string[] str = openidstr.Split(',');

                    //每20000个一组,判断可以拆分为几组
                    int splitnum = int.Parse(Math.Ceiling((double)(str.Length) / (double)20000).ToString());

                    if (splitnum == 1)
                    {
                        ObtainGzListSplit splitmodel = new ObtainGzListSplit
                        {
                            Id          = 0,
                            Comid       = comid,
                            Dealerid    = dealuserid,
                            Total       = str.Length,
                            Splitcount  = str.Length,
                            Splitno     = MaxSplitNo + 1,
                            Obtainno    = MaxOtainNo,
                            Splittime   = DateTime.Now,
                            Splitopenid = openidstr,
                            Issuc       = 1
                        };

                        new ObtainGzListSplitData().InsertsObtainGzListSplit(splitmodel);
                    }
                    else
                    {
                        //获取拆分的openid字符串
                        for (int i = 1; i <= splitnum; i++)
                        {
                            if (i == splitnum)
                            {
                                //录入最后不满20000的openid字符串
                                string splitopenid = "";
                                for (int j = 20000 * (splitnum - 1); j < str.Length; j++)
                                {
                                    splitopenid += str[j] + ",";
                                }
                                splitopenid = splitopenid.Substring(0, splitopenid.Length - 1);
                                ObtainGzListSplit splitmodel = new ObtainGzListSplit
                                {
                                    Id          = 0,
                                    Comid       = comid,
                                    Dealerid    = dealuserid,
                                    Total       = str.Length,
                                    Splitcount  = (str.Length) % 20000,
                                    Splitno     = MaxSplitNo + 1,
                                    Obtainno    = MaxOtainNo,
                                    Splittime   = DateTime.Now,
                                    Splitopenid = splitopenid,
                                    Issuc       = 1
                                };

                                new ObtainGzListSplitData().InsertsObtainGzListSplit(splitmodel);
                            }
                            else
                            {
                                string splitopenid = "";
                                for (int j = 20000 * (i - 1); j < 20000 * i; j++)
                                {
                                    splitopenid += str[j] + ",";
                                }
                                splitopenid = splitopenid.Substring(0, splitopenid.Length - 1);


                                ObtainGzListSplit splitmodel = new ObtainGzListSplit
                                {
                                    Id          = 0,
                                    Comid       = comid,
                                    Dealerid    = dealuserid,
                                    Total       = str.Length,
                                    Splitcount  = 20000,
                                    Splitno     = MaxSplitNo + 1,
                                    Obtainno    = MaxOtainNo,
                                    Splittime   = DateTime.Now,
                                    Splitopenid = splitopenid,
                                    Issuc       = 1
                                };

                                new ObtainGzListSplitData().InsertsObtainGzListSplit(splitmodel);
                            }
                        }
                    }

                    UnloadJavascript();
                    Literal2.Text = "微信关注者总数目:" + str.Length;


                    BindGrid2(comid, MaxSplitNo + 1, MaxOtainNo);
                }
                else
                {
                    UnloadJavascript();
                    Literal2.Text = "获取微信关注者列表为空";
                }
                //}
            }
        }