public void ImportMedicament()
{
var table = new DS_Medicament.SP_GetMedicamentDataTable();
table.SetAllowDBNull(true);
foreach (var row in ds_Import.T_Info10)
{
if (row.IsMedicamentNameNull() || row.MedicamentName.Trim().Length == 0)
{
continue;
}
//ზედმეტ ასოებს აშორებს.
row.MedicamentName = row.MedicamentName.Replace("\n", string.Empty).Replace("\t", string.Empty).Trim();
var newRow = table.NewSP_GetMedicamentRow();
newRow.Name = row.MedicamentName;
table.AddSP_GetMedicamentRow(newRow);
}
table.PrimaryKey = null;
table.RemoveColumns(table.MedicamentIDColumn,
table.StandardCostColumn,
table.ListPriceColumn,
table.DealerPriceColumn,
table.DiscountPctColumn,
table.TaxRateColumn,
table.ValidDateColumn,
table.CountryCodeColumn,
table.BrandIDColumn,
table.SerieColumn,
table.StatusColumn,
table.ModifiedUserIDColumn,
table.ModifiedDateColumn,
table.ApproverUserIDColumn);
var newTable = table.SelectDistinct(true, table.Columns, table.NameColumn);
var xmlTable = newTable.PackAlternationTypedDataTable(dataRowState: DataRowState.Added, addActionColumn: true);
ImportManager.ImportDataTable(ObjectNames.Medicament, xmlTable);
ImportManager.InitID(ds_Import.T_Info10, ObjectNames.Medicament, ds_Import.T_Info10.MedicamentIDColumn.ColumnName, false, null, ds_Import.T_Info10.MedicamentNameColumn.ColumnName);
}
private void ImportMedicament()
{
var table = new DS_Medicament.SP_GetMedicamentDataTable();
table.SetAllowDBNull(true);
foreach (var row in ds_Import.PurchaseOrderDetail)
{
if (row.IsMedicamentNameNull() || row.MedicamentName.Trim().Length == 0)
{
continue;
}
//ზედმეტ ასოებს აშორებს.
row.MedicamentName = row.MedicamentName.Replace("\n", string.Empty).Replace("\t", string.Empty).Trim();
var newRow = table.NewSP_GetMedicamentRow();
if (!row.IsMedicamentSubcategoryIDNull())
{
newRow.MedicamentSubcategoryID = row.MedicamentSubcategoryID;
}
if (!row.IsMedicamentNameNull())
{
newRow.Name = row.MedicamentName;
}
if (!row.IsProductNumberNull())
{
newRow.ProductNumber = row.ProductNumber;
}
if (!row.IsMakeFlagNull())
{
newRow.MakeFlag = row.MakeFlag;
}
if (!row.IsFinishedGoodsFlagNull())
{
newRow.FinishedGoodsFlag = row.FinishedGoodsFlag;
}
if (!row.IsColorNull())
{
newRow.Color = row.Color;
}
if (!row.IsSafetyStockLevelNull())
{
newRow.SafetyStockLevel = row.SafetyStockLevel;
}
if (!row.IsReorderPointNull())
{
newRow.ReorderPoint = row.ReorderPoint;
}
if (!row.IsStandardCostNull())
{
newRow.StandardCost = row.StandardCost;
}
if (!row.IsListPriceNull())
{
newRow.ListPrice = row.ListPrice;
}
if (!row.IsDealerPriceNull())
{
newRow.DealerPrice = row.DealerPrice;
}
if (!row.IsDiscountPctNull())
{
newRow.DiscountPct = row.DiscountPct;
}
if (!row.IsTaxRateNull())
{
newRow.TaxRate = row.TaxRate;
}
if (!row.IsSizeNull())
{
newRow.Size = row.Size;
}
if (!row.IsSizeRangeNull())
{
newRow.SizeRange = row.SizeRange;
}
if (!row.IsSizeUnitMeasureCodeNull())
{
newRow.SizeUnitMeasureCode = row.SizeUnitMeasureCode;
}
if (!row.IsWeightNull())
{
newRow.Weight = row.Weight;
}
if (!row.IsWeightUnitMeasureCodeNull())
{
newRow.WeightUnitMeasureCode = row.WeightUnitMeasureCode;
}
if (!row.IsDaysToManufactureNull())
{
newRow.DaysToManufacture = row.DaysToManufacture;
}
if (!row.IsProductLineNull())
{
newRow.ProductLine = row.ProductLine;
}
if (!row.IsClassNull())
{
newRow.Class = row.Class;
}
if (!row.IsStyleNull())
{
newRow.Style = row.Style;
}
if (!row.IsProductModelIDNull())
{
newRow.ProductModelID = row.ProductModelID;
}
if (!row.IsSellStartDateNull())
{
newRow.SellStartDate = row.SellStartDate;
}
if (!row.IsSellEndDateNull())
{
newRow.SellEndDate = row.SellEndDate;
}
if (!row.IsDiscontinuedDateNull())
{
newRow.DiscontinuedDate = row.DiscontinuedDate;
}
if (!row.IsUnitsInStockNull())
{
newRow.UnitsInStock = row.UnitsInStock;
}
//if (!row.IsValidDateNull())
// newRow.ValidDate = row.ValidDate;
//if (!row.IsCountryCodeNull())
// newRow.CountryCode = row.CountryCode;
//if (!row.IsBrandIDNull())
// newRow.BrandID = row.BrandID;
//if (!row.IsSerieNull())
// newRow.Serie = row.Serie;
//newRow.Status = (byte)Statuses.Pending;
//newRow.ModifiedUserID = GlobalVariable.UserID;
//newRow.ModifiedDate = GlobalVariable.ServerDateTime;
table.AddSP_GetMedicamentRow(newRow);
}
table.PrimaryKey = null;
table.RemoveColumns(table.MedicamentIDColumn,
//table.StandardCostColumn,
//table.ListPriceColumn,
//table.DealerPriceColumn,
//table.DiscountPctColumn,
//table.TaxRateColumn,
table.ValidDateColumn,
table.CountryCodeColumn,
table.BrandIDColumn,
table.SerieColumn,
table.StatusColumn,
table.ModifiedUserIDColumn,
table.ModifiedDateColumn,
table.ApproverUserIDColumn);
var newTable = table.SelectDistinct(true, table.Columns, table.NameColumn);
var xmlTable = newTable.PackAlternationTypedDataTable <DataTable>(dataRowState: DataRowState.Added, addActionColumn: true);
ImportManager.ImportDataTable(ObjectNames.Medicament, xmlTable);
ImportManager.InitID(ds_Import.PurchaseOrderDetail, ObjectNames.Medicament, ds_Import.PurchaseOrderDetail.MedicamentIDColumn.ColumnName, false, null, ds_Import.PurchaseOrderDetail.MedicamentNameColumn.ColumnName);
}