コード例 #1
0
        public DataTable testBulkRowData(SqlBaseItemXml basemodel, string tablename)
        {
            DataTable bulkdata   = DBConfig.GetTableStruct(basemodel, tablename);
            Random    random     = new Random();
            long      rowmin     = 0;
            long      rowcurrent = 0;
            long      rowmax     = 0;
            int       rownum     = 10000;

            long rowidrrr = DBConfig.GetRowId(basemodel.Number);

            DBConfig.UpdateRowId(basemodel.Number, rownum);
            rowmin     = rowidrrr + 1;
            rowmax     = rowmin + rownum;
            rowcurrent = rowmin;
            for (int i = 0; i < rownum; i++)
            {
                DataRow newRow;
                newRow = bulkdata.NewRow();
                #region
                newRow["id"]    = rowcurrent++;
                newRow["num1"]  = rowcurrent / 100000;
                newRow["num2"]  = random.Next(10000);
                newRow["num3"]  = random.NextDouble();
                newRow["str11"] = tablename + i;
                #endregion
                bulkdata.Rows.Add(newRow);
            }
            return(bulkdata);
        }