（工作笔记）数据分批次操作，封装方法（sql添删改查）

// // idList为数据总的和，count代表按照多少一组//public static IList<IList<int>> GetlistGroup(IList<int> idList,int count)        {            IList<int> templist = null;            IList<IList<int>> relist = new List<IList<int>>();            for (int i = 0; i < (idList.Count % count == 0 ? idList.Count / count : idList.Count / count + 1); i++)            {                templist = new List<int>();                for (int j = 0; j < count; j++)                {                              int index = i * count + j;                    if (index == idList.Count) { break; }                    templist.Add(idList[index]);                   }                relist.Add(templist);            }            return relist;                }//调用IList<IList<int>> relist = GetlistGroup(list,100);
 string ids = string.Empty;            for (int i = 0; i < relist.Count; i++)            {                 ids =string.Join(",", relist[i].ToArray());         string strSQL = string.Format("update {0} set synstatus = 1 where {1} in ({2})", tableName, idName, ids);                           }