public void Fill(DS_PSP.T_DBFDataTable table)
{
var tmpTable = OleDbHelper.GetDataTable(ConnectionString, SelectCmd);
table.Clear();
foreach (DataRow row in tmpTable.Rows)
{
table.ImportRow(row);
}
Translate(table);
}
private void BindPSPData()
{
var helper = new PSPHelper(_file, _unitPricePct, _taxRate);
var table = new DS_PSP.T_DBFDataTable();
helper.Fill(table);
foreach (var row in table)
{
if (row.IsNAME_GEONull() || row.NAME_GEO.Trim().Length == 0)
{
continue;
}
var newRow = ds_Import.PurchaseOrderDetail.NewPurchaseOrderDetailRow();
newRow.ReceivedQty = row.RAOD;
newRow.UnitPrice = row._UNIT_PRICE_GEL;
newRow.TaxRate = _taxRate / 100m;
newRow.ListPrice = row.SUM_LAR_D;
newRow.ProductCurrencyCode = GlobalVariable.MyCompanyConditionalUnitCurrencyCode;
if (!row.IsSERIANull())
{
newRow.Serie = row.SERIA;
}
if (!row.Is_VADANull())
{
newRow.ValidDate = row._VADA;
}
if (!row.IsMANUFNull())
{
newRow.BrandName = row.NAME_MANUF;
}
if (!row.IsCOUNTRYNull())
{
newRow.CountryName = row.COUNTRY;
}
newRow.MedicamentName = row.NAME_GEO.Trim();
ds_Import.PurchaseOrderDetail.AddPurchaseOrderDetailRow(newRow);
}
}
public void Translate(DS_PSP.T_DBFDataTable table)
{
foreach (var row in table)
{
if (!row.IsNAME_GEONull())
{
row.NAME_GEO = GeoConvertHelper.Convert(row.NAME_GEO, GeoConvertHelper.PSP, GeoConvertHelper.Unicode);
}
if (!row.IsNAME_MANUFNull())
{
row.NAME_MANUF = GeoConvertHelper.Convert(row.NAME_MANUF, GeoConvertHelper.PSP, GeoConvertHelper.Unicode);
}
if (!row.IsCOUNTRYNull())
{
row.COUNTRY = GeoConvertHelper.Convert(row.COUNTRY, GeoConvertHelper.PSP, GeoConvertHelper.Unicode);
}
//შესასყიდი ფასი
row._UNIT_PRICE_USD = (_UnitPricePct == 0m ? MathHelper.RemoveAddedPct(row.SUM_USD, _TaxRate) : MathHelper.RemoveAddedPct(MathHelper.AddPct(row.SUM_USD_D, _UnitPricePct), _TaxRate));
row._UNIT_PRICE_GEL = (_UnitPricePct == 0m ? MathHelper.RemoveAddedPct(row.SUM_LAR, _TaxRate) : MathHelper.RemoveAddedPct(MathHelper.AddPct(row.SUM_LAR_D, _UnitPricePct), _TaxRate));
if (!row.IsVADANull())
{
int year;
int month;
var vada = row.VADA.Split('/');
if (vada.Length == 2)
{
int.TryParse(vada[1].Trim(), out year);
int.TryParse(vada[0].Trim(), out month);
if (year >= DateTimeHelper.MinDate.Year && year <= DateTimeHelper.MaxDate.Year && month > 0 && month < 13)
{
row._VADA = new DateTime(year, month, 1);
}
}
}
}
}
