Beispiel #1
0
        private void btnPO_Click(object sender, EventArgs e)
        {
            if (InitExcel("Purchase Order") == false)
                return;

            UnitOfWork uow = new UnitOfWork();
            PurchOrderLine poLine;
            int row = 3;
            uow.BeginTransaction();

            while (ExcelHelper.GetCellStringValue(xlSht, row, 1) != "")
            {
                poLine = new PurchOrderLine(uow);
                poLine.SetPurchOrderLineNo(ExcelHelper.GetCellStringValue(xlSht, row, 1));
                poLine.Item = Item.FindItem(uow, ExcelHelper.GetCellStringValue(xlSht, row, 2));
                poLine.OrderType = uow.FindObject<OrderType>(new BinaryOperator("Name", ExcelHelper.GetCellStringValue(xlSht, row, 3)));
                poLine.Vendor = uow.FindObject<Vendor>(new BinaryOperator("No", ExcelHelper.GetCellStringValue(xlSht, row, 4)));
                poLine.PriceUnit = uow.FindObject<Unit>(new BinaryOperator("UnitName", ExcelHelper.GetCellStringValue(xlSht, row, 5)));
                poLine.NeedQty = ExcelHelper.GetCellIntValue(xlSht, row, 8);
                poLine.NeedDate = ExcelHelper.GetCellDateTimeValue(xlSht, row, 9);
                poLine.Price = ExcelHelper.GetCellFloatValue(xlSht, row, 10);
                poLine.Save();
                poLine.ApproveOrder();
                poLine.IssuePurchOrder(uow);

                row++;
            }
            uow.CommitTransaction();
            ReleaseExcel();
        }