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); } } } } }