public void BulkWriteToServer()
{
DataTable dt = _dba.BulkGetEmptyDataTable("Sys_Product");
for (int i = 0; i < 3; i++)
{
var dr = dt.NewRow();
dr["ProductName"] = "BulkWriteToServer";
dr["ProductCode"] = "BulkWriteToServer";
dt.Rows.Add(dr);
}
_dba.BulkWriteToServer(dt);
_dba.BulkWriteToServer(dt, 0, new BulkCopyColumnMapping("ProductName", "ProductName"));
}
public void Test()
{
string filePath = @"C:\Users\zwb\Desktop\cartype.xlsx";
using (var fs = new FileStream(filePath, FileMode.Open))
{
var dt = new WorkbookDataAdapter(new XSSFWorkbook(fs))
//.SetColumnNameMapping(dic)
.AddOnRowAdapt(c =>
{
return(true);
}).ToDataTable();
DbAccessor dba = DbAccessor.Get();
foreach (DataRow dr in dt.Rows)
{
foreach (DataColumn dc in dt.Columns)
{
//if (dc.ColumnName.ToUpper() == "STATUS" || dc.ColumnName.ToUpper()== "BELONGTTYPE")
//{
// dr[dc.ColumnName] = Int16.Parse(dr[dc.ColumnName].ToString());
//}
if (string.IsNullOrEmpty(dr[dc.ColumnName].ToString()))
{
dr[dc.ColumnName] = DBNull.Value;
}
}
}
dt.TableName = "Biz_Cartype";
dba.BulkWriteToServer(dt);
Console.WriteLine();
}
}
