public void CreateFromXslTest()
{
TransferInDatatable td = new TransferInDatatable();
DataTable dt1= td.CreateFromXsl(Environment.CurrentDirectory + @"\testresource\NTS编码表.xls");
Assert.AreEqual(1,dt1.Rows.Count);
DataTable dt2 = td.CreateFromXsl(Environment.CurrentDirectory + @"\testresource\NTS产品报价单.xls");
Assert.AreEqual(1, dt2.Rows.Count);
DataTable dt3 = td.CreateFromXsl(Environment.CurrentDirectory + @"\testresource\标准格式物料.XLS");
Assert.AreEqual(0, dt3.Rows.Count);
DataTable dt4 = td.CreateFromXsl(Environment.CurrentDirectory + @"\testresource\供应商编码.xls");
Assert.AreEqual(1, dt4.Rows.Count);
}
public void JoinXslToDataTableTest()
{
TransferInDatatable td = new TransferInDatatable();
//string baojia = Environment.CurrentDirectory + @"\testresource\NTS产品报价单.xls";
//string bianma = Environment.CurrentDirectory + @"\testresource\NTS编码表.xls";
//string gongyingshang = Environment.CurrentDirectory + @"\testresource\供应商编码.xls";
// string erpOut = Environment.CurrentDirectory + @"\testresource\out标准格式物料.XLS";
//DataTable dt = td.JoinXslToDataTable(baojia, bianma, gongyingshang, erp);
//Assert.AreEqual(2, dt.Rows.Count);
//td.CreateXslFromDataTable(dt, erp, erpOut);
Console.WriteLine(DateTime.Now);
string baojia1756 = Environment.CurrentDirectory + @"\测试文件\NTS产品报价单1756.xls";
//string bianma2130 = Environment.CurrentDirectory + @"\testresource\NTS编码表2130.xls";
DataTable dt1728 = td.JoinXslToDataTable(baojia1756,true);
Assert.AreEqual(6, dt1728.Rows.Count);
td.CreateXslFromDataTable(dt1728,true);
Console.WriteLine(DateTime.Now);
}
public void BuildNtsCodeTest()
{
TransferInDatatable td = new TransferInDatatable();
Assert.AreEqual("01.012.0000400001", td.BuildNtsCode("01.012", "00004",true));
}