public static DataSet ImportExcelFromFile( string filePath) { var result = DataSetHelper.CreateDataSet(filePath); return(result); }
public void SimpleCreateTest() { string tempFilePath = Path.GetTempFileName(); { DataSet ds = new DataSet(); DataTable dt1 = new DataTable("Table 1"); dt1.Columns.Add("Column A", typeof(String)); dt1.Columns.Add("Column B", typeof(String)); dt1.Rows.Add("Test 1", "Test 2"); dt1.Rows.Add("Test 3", "Test 4"); ds.Tables.Add(dt1); DataTable dt2 = new DataTable("Table 2"); ds.Tables.Add(dt2); DataTable dt3 = new DataTable("Table 3"); dt3.Columns.Add("Column C", typeof(String)); ds.Tables.Add(dt3); DataSetHelper.CreateWorkbook(tempFilePath, ds); } { DataSet ds = DataSetHelper.CreateDataSet(tempFilePath); Assert.AreEqual(3, ds.Tables.Count); Assert.AreEqual("Table 1", ds.Tables[0].TableName); Assert.AreEqual("Table 2", ds.Tables[1].TableName); Assert.AreEqual("Table 3", ds.Tables[2].TableName); Assert.AreEqual(2, ds.Tables[0].Columns.Count); Assert.AreEqual(1, ds.Tables[1].Columns.Count); Assert.AreEqual(1, ds.Tables[2].Columns.Count); Assert.AreEqual("Column A", ds.Tables[0].Columns[0].ColumnName); Assert.AreEqual("Column B", ds.Tables[0].Columns[1].ColumnName); Assert.AreEqual("Column C", ds.Tables[2].Columns[0].ColumnName); Assert.AreEqual(2, ds.Tables[0].Rows.Count); Assert.AreEqual(0, ds.Tables[1].Rows.Count); Assert.AreEqual(0, ds.Tables[2].Rows.Count); Assert.AreEqual("Test 1", ds.Tables[0].Rows[0][0]); Assert.AreEqual("Test 2", ds.Tables[0].Rows[0][1]); Assert.AreEqual("Test 3", ds.Tables[0].Rows[1][0]); Assert.AreEqual("Test 4", ds.Tables[0].Rows[1][1]); } }
public void BaseTest() { var producerName = Generator.Name(); var clientId = 0u; var supplier = TestSupplier.CreateNaked(session); var producer = new TestProducer(producerName); session.Save(producer); var product = new TestProduct("testProduct"); session.Save(product); var price = supplier.Prices[0]; price.Enabled = true; price.AgencyEnabled = true; session.Save(price); var client = TestClient.CreateNaked(session); var core = new TestCore(price.AddProductSynonym(product)) { Price = price, Producer = producer, Quantity = "2", Code = "2", Period = "" }; session.Save(core); var matrix = new TestMatrix(); session.Save(matrix); var costId = new CostPrimaryKey { CoreId = core.Id, CostId = price.Costs[0].Id }; var cost = new TestCost { Id = costId, Cost = 10 }; session.Save(cost); var rule = client.Settings; rule.BuyingMatrix = matrix; rule.BuyingMatrixAction = TestMatrixAction.Delete; rule.BuyingMatrixType = TestMatrixType.BlackList; session.Save(rule); session.CreateSQLQuery(string.Format(@" insert into farm.BuyingMatrix (PriceId, ProductId, MatrixId) value ({0}, {1}, {2})", price.Id, product.Id, matrix.Id)) .ExecuteUpdate(); clientId = client.Id; Property("ClientCode", clientId); report = new Inforoom.ReportSystem.ByOffers.MatrixReport(Conn, properties); BuildOrderReport("Rep.xls"); var resuleSet = DataSetHelper.CreateDataSet("Rep.xls").Tables[0]; Assert.That(resuleSet.Rows[4][13], Does.Contain("Удаление предложения")); Assert.That(resuleSet.Rows[4][5], Does.Contain(producerName)); }
private static void ExportBin(string filePath, string filename) { ByteArray ba = new ByteArray(); Assembly asm = Assembly.LoadFile(Application.dataPath + "/../Library/ScriptAssemblies/Assembly-CSharp.dll"); DataSet dataSet = DataSetHelper.CreateDataSet(filePath + filename + FILE_SUFFIX); if (dataSet != null) { //int sheetNum = dataSet.Tables.Count; int canreadSheet = 0; foreach (DataTable sheet in dataSet.Tables) { string className = sheet.TableName; object obj = asm.CreateInstance(className); //Debug.Log("当前表名是: " + sheet.TableName); if (obj == null) { continue; } ++canreadSheet; } ba.writeInt(canreadSheet); //Converter.WriteInt(writer, sheetNum); foreach (DataTable sheet in dataSet.Tables) { string className = sheet.TableName; object obj = asm.CreateInstance(className); if (obj == null) { //MUtils.ShowNotice("Load data error: "+className+" in "+filePath+" has no data."); continue; } FieldInfo[] fis = obj.GetType().GetFields(); ba.writeUTF(sheet.TableName); //Converter.WriteJavaString(writer,sheet.TableName); int rows = sheet.Rows.Count; int rowCount = 0; for (int r = 0; r != rows; ++r) { if (string.IsNullOrEmpty(sheet.Rows[r].ItemArray[0].ToString())) { break; } rowCount++; } ba.writeInt(rowCount); if (rows > 0) { ba.writeInt(sheet.Rows[0].ItemArray.Length); } else { ba.writeInt(0); } foreach (DataRow row in sheet.Rows) { int i = 0; foreach (object item in row.ItemArray) { if (i >= fis.Length) { break; } if (fis[i].FieldType == typeof(int)) { int val = 0; int.TryParse(item.ToString(), out val); ba.writeInt(val); } else if (fis[i].FieldType == typeof(short)) { short val = 0; short.TryParse(item.ToString(), out val); ba.writeShort(val); } else if (fis[i].FieldType == typeof(long)) { long val = 0; long.TryParse(item.ToString(), out val); ba.writeLong(val); } else if (fis[i].FieldType == typeof(float) || fis[i].FieldType == typeof(double) || fis[i].FieldType == typeof(string)) { ba.writeUTF(item.ToString()); } ++i; } } } } //string binpath = AssetBundlePath.GetStreamingAssetsPath() + "bin/".Replace("file://",""); string binpath = AssetBundlePath.GetStreamingAssetsPath().Replace("file://", ""); binpath = binpath.Replace("file://", ""); var file = new FileStream(binpath + filename + FILE_BIN_SUFFIX, FileMode.Create, System.IO.FileAccess.Write); byte[] bytes = ba.data; file.Write(bytes, 0, bytes.Length); file.Close(); }