1 public bool InsertAll(IList<NewStockLuoPan> list)
2 {
3 DataTable dt = new DataTable();
4 dt.Columns.Add("StockNo",typeof(string));
5 dt.Columns.Add("Angel", typeof(int));
6 dt.Columns.Add("YesterDayAmountIn", typeof(decimal));
7 dt.Columns.Add("TwoDayAmountInTest", typeof(string));
8 dt.Columns.Add("YesterDay10AmountIn", typeof(decimal));
9 dt.Columns.Add("TenDayAmountInTest", typeof(string));
10 dt.Columns.Add("CreatedDate", typeof(DateTime));
11
12 foreach (var item in list)
13 {
14 DataRow dr = dt.NewRow();
15 dr["StockNo"] = item.StockNo;
16 dr["Angel"] = item.Angel;
17 dr["YesterDayAmountIn"] = item.YesterDayAmountIn;
18 dr["TwoDayAmountInTest"] = item.TwoDayAmountInTest;
19 dr["YesterDay10AmountIn"] = item.YesterDay10AmountIn;
20 dr["TenDayAmountInTest"] = item.TenDayAmountInTest;
21 dr["CreatedDate"] = item.CreatedDate;
22
23 dt.Rows.Add(dr);
24 }
25 27 using (SqlBulkCopy sqlBC=new SqlBulkCopy(connstr))
28 {
29 sqlBC.DestinationTableName = "dbo.table";
30 sqlBC.ColumnMappings.Add("StockNo", "StockNo");
31 sqlBC.ColumnMappings.Add("Angel", "Angel");
32 sqlBC.ColumnMappings.Add("YesterDayAmountIn", "YesterDayAmountIn");
33 sqlBC.ColumnMappings.Add("TwoDayAmountInTest", "TwoDayAmountInTest");
34 sqlBC.ColumnMappings.Add("YesterDay10AmountIn", "YesterDay10AmountIn");
35 sqlBC.ColumnMappings.Add("TenDayAmountInTest", "TenDayAmountInTest");
36 sqlBC.ColumnMappings.Add("CreatedDate", "CreatedDate");
37 sqlBC.WriteToServer(dt);
38 }
39 return true;
40 }
