public void Fill(DS_Aversi.T_ImportDataTable table)
{
var tmpTable = OleDbHelper.GetDataTable(ConnectionString, SelectCmd);
table.Clear();
foreach (DataRow row in tmpTable.Rows)
{
table.ImportRow(row);
}
Translate(table);
}
public void Translate(DS_Aversi.T_ImportDataTable table)
{
foreach (var row in table)
{
if (!row.IsNAM_MATNull())
row.NAM_MAT = GeoConvertHelper.Convert(row.NAM_MAT, GeoConvertHelper.Aversi, GeoConvertHelper.Unicode);
if (!row.IsPRONAMENull())
row.PRONAME = GeoConvertHelper.Convert(row.PRONAME, GeoConvertHelper.Aversi, GeoConvertHelper.Unicode);
if (!row.IsNAM_CONGNull())
row.NAM_CONG = GeoConvertHelper.Convert(row.NAM_CONG, GeoConvertHelper.Aversi, GeoConvertHelper.Unicode);
//შესასყიდი ფასი
//row._UNIT_PRICE_USD = (_UnitPricePct == 0m ? MathHelper.RemoveAddedPct(row.USD_PRICE, _TaxRate) : MathHelper.RemoveAddedPct(MathHelper.AddPct(row.USD_PRICE, _UnitPricePct), _TaxRate));
//row._UNIT_PRICE_GEL = (_UnitPricePct == 0m ? MathHelper.RemoveAddedPct(row.PRICE, _TaxRate) : MathHelper.RemoveAddedPct(MathHelper.AddPct(row.PRICE, _UnitPricePct), _TaxRate));
}
}
private void BindAversiData()
{
var helper = new AversiHelper(_file, _unitPricePct, _taxRate);
var table = new DS_Aversi.T_ImportDataTable();
helper.Fill(table);
foreach (var row in table)
{
if (row.IsNAM_MATNull() || row.NAM_MAT.Trim().Length == 0)
{
continue;
}
var newRow = ds_Import.PurchaseOrderDetail.NewPurchaseOrderDetailRow();
newRow.ReceivedQty = row.NUM_KRIT;
newRow.UnitPrice = row.ZAK_PRI;
newRow.TaxRate = _taxRate / 100m;
newRow.ListPrice = MathHelper.AddPct(row.PRICE, _taxRate);//გასარკვევია შედის თუ არა პსპ-ში დღგ...
newRow.ProductCurrencyCode = GlobalVariable.MyCompanyConditionalUnitCurrencyCode;
if (!row.IsSERIANull())
{
newRow.Serie = row.SERIA;
}
if (!row.IsDAT_GOODNull())
{
newRow.ValidDate = row.DAT_GOOD;
}
if (!row.IsPRONAMENull())
{
newRow.BrandName = row.PRONAME;
}
if (!row.IsNAM_CONGNull())
{
newRow.CountryName = row.NAM_CONG;
}
newRow.MedicamentName = row.NAM_MAT.Trim();
ds_Import.PurchaseOrderDetail.AddPurchaseOrderDetailRow(newRow);
}
}
