#region 批量保存到数据库
public bool InsertDB(DataTable dt)
{
bool bResult = true;
LogInfo.WriteTextToFile("使用Bulk插入的实现方式");
Stopwatch sw = new Stopwatch();
using (SqlConnection conn = new SqlConnection(con))
{//连接数据库
try
{
SqlBulkCopy bulkCopy = new SqlBulkCopy(conn);
bulkCopy.DestinationTableName = "表名";
bulkCopy.BatchSize = dt.Rows.Count;
conn.Open();
sw.Start();
if (dt != null && dt.Rows.Count != 0)
{
bulkCopy.WriteToServer(dt);
sw.Stop();
}
LogInfo.WriteTextToFile(string.Format("插入{0}条记录共花费{1}毫秒", dt.Rows.Count, sw.ElapsedMilliseconds));
}
catch (Exception e)
{
sw.Stop();
LogInfo.WriteTextToFile("异常原因:" + e.Message);
bResult = false;
}
finally
{
conn.Close();
}
return bResult;
}
}
#endregion
DataTable 用于比较一个字段的大小或者范围,但是该列却被定义为string类型,采用以下转换类型方式之后进行比较
dt.Select("convert (money, 'System.Decimal')>0")