public DataSet1 getUnits() { UnitsDataAccessor DA = new UnitsDataAccessor(); PositionDataAccessor DApos = new PositionDataAccessor(); DataSet1 dataSet1 = new DataSet1(); AbstractConnection absConnection = null; AbstractTransaction absTransaction = null; try { absConnection = DBFactory.createConnection(); absConnection.open(); absTransaction = absConnection.beginTransaction(); DA.Read(absConnection, absTransaction, dataSet1); DApos.Read(absConnection, absTransaction, dataSet1); absTransaction.commit(); } catch (Exception e) { absTransaction.rollback(); } finally { absConnection.close(); } return(dataSet1); }
public void GetAll() { //Setup(); PositionDataAccessor daInvoice = new PositionDataAccessor(); DataSet1 dataSet1 = new DataSet1(); AbstractConnection connection = null; AbstractTransaction transaction = null; try { connection = DBFactory.createConnection(); connection.open(); transaction = connection.beginTransaction(); daInvoice.Read(connection, transaction, dataSet1); transaction.commit(); } catch (Exception e) { transaction.rollback(); } finally { connection.close(); } List <DataRow> list = dataSet1.position_in_mat_delivery_note.Select().OfType <DataRow>().ToList(); list.Sort((x, y) => ((int)x["id_"]).CompareTo((int)y["id_"])); //сортируем по ид Assert.That(1, Is.EqualTo(1)); Assert.That(list.Count, Is.EqualTo(5)); Assert.That((int)(list[0]["id_"]), Is.EqualTo(1)); Assert.That((double)(list[0]["amount"]), Is.EqualTo(10)); Assert.That((int)(list[0]["invoice_id"]), Is.EqualTo(1)); }