public FactProductionTreeImporter()
{
dataContext = new DataClasses1DataContext();
dataContextS1 = new s1_DataClasses1DataContext();
deleteAllProductionTree();
}
public DocSalesImporter()
{
dataContext = new DataClasses1DataContext();
dataContextS1 = new s1_DataClasses1DataContext();
}
public FactPricesImporter()
{
dataContext = new DataClasses1DataContext();
dataContextS1 = new s1_DataClasses1DataContext();
}
Int64 unitIDGramm = 18; // ID for unit Gramm
public FactManufactureDocs()
{
dataContext = new DataClasses1DataContext();
dataContextS1 = new s1_DataClasses1DataContext();
}
} // public void impFactMovementsDel()
public void fromHistoryToRemains()
{
DateTime toDateCount = new DateTime(2016, 06, 01);
//--------> DELETE ALL REMAINS
deleteAllRemains();
dataContext = new DataClasses1DataContext();
dataContextS1 = new s1_DataClasses1DataContext();
DateTime now = DateTime.Now;
DateTime onDate = DateTime.Today; // Remains on current date
Dictionary <Int64, string> edIzmer = new Dictionary <Int64, string>();
Dictionary <Int64, Int64?> edIzmerId = new Dictionary <Int64, Int64?>();
long edIzmerGram = new long();
Dictionary <Int64, decimal> nominalWghts = new Dictionary <Int64, decimal>();
// ed izm
var edIzms = from e in dataContext.DimGoods
select e;
foreach (DimGoods ed in edIzms)
{
edIzmerId.Add(ed.ID, ed.BaseUnitID);
edIzmer.Add(ed.ID, ed.BaseUnit);
}
edIzmerGram = (from e in dataContext.DimUnits
where e.TypeName == "г" &&
e.Active == true
select e.ID).First();
// ed izm
// NominalWeights
var nomWts = from n in dataContext.DimGoods
where n.WeightGrammNominal != null
select n;
foreach (DimGoods nw in nomWts)
{
nominalWghts.Add(nw.ID, nw.WeightGrammNominal.Value);
}
// NominalWeights
// Delete on date
deleteRemainsOnDate(onDate); // Fast delete from DB
//var onDateRemains = from r in dataContext.FactRemains
// where r.RemainsDate == onDate
// select r;
//dataContext.FactRemains.DeleteAllOnSubmit(onDateRemains);
//dataContext.SubmitChanges();
// Delete on date
var dimDates = (from d in dataContext.DimDates
where d.Date == onDate
select d).FirstOrDefault();
if (dimDates == null)
{
throw new Exception();
}
var remHistIn = from f in dataContext.FactMovements
where f.RecordKind == 0 &&
f.Active == true
//&& f.Date <= toDateCount
group f by new
{
f.WarehouseID,
f.GoodID,
f.ConsignNumber,
f.Date
}
into g
select new
{
WarehouseID = g.Key.WarehouseID,
GoodID = g.Key.GoodID,
Date = g.Key.Date,
ConsignNumber = g.Key.ConsignNumber,
OnStockQty = g.Sum(t => t.OnStockQty),
InOrdersQty = g.Sum(t => t.InOrdersQty)
};
var remHistOut = from f in dataContext.FactMovements
where f.RecordKind == 1 &&
f.Active == true
//&& f.Date <= toDateCount
group f by new
{
f.WarehouseID,
f.GoodID,
f.ConsignNumber,
f.Date
}
into g
select new
{
WarehouseID = g.Key.WarehouseID,
GoodID = g.Key.GoodID,
Date = g.Key.Date,
ConsignNumber = g.Key.ConsignNumber,
OnStockQty = g.Sum(t => t.OnStockQty) * (-1),
InOrdersQty = g.Sum(t => t.InOrdersQty) * (-1)
};
var remHistT = (from r in remHistIn
where r.OnStockQty != 0
select r).Concat(from r in remHistOut
where r.OnStockQty != 0
select r);
var remHist = from r in remHistT
where r.OnStockQty != 0
group r by new
{
r.WarehouseID,
r.GoodID,
r.ConsignNumber
}
into g
select new
{
WarehouseID = g.Key.WarehouseID,
GoodID = g.Key.GoodID,
ConsignNumber = g.Key.ConsignNumber,
OnStockQty = g.Sum(t => t.OnStockQty),
InOrdersQty = g.Sum(t => t.InOrdersQty)
};
int i = 0;
foreach (var rh in remHist)
{
FactRemains rm = new FactRemains();
rm.WarehouseID = rh.WarehouseID;
rm.DepartmentID = null;
rm.GoodID = rh.GoodID;
rm.ConsignNumber = rh.ConsignNumber;
rm.RemainsDate = onDate;
rm.DateKey = dimDates.DateKey;
rm.OnStockQty = rh.OnStockQty;
rm.InOrdersQty = rh.InOrdersQty;
// Unit
var edIzmB = (from r in edIzmer
where r.Key == rh.GoodID
select r).FirstOrDefault();
var edIzmBId = (from r in edIzmerId
where r.Key == rh.GoodID
select r).FirstOrDefault();
if (edIzmB.Value != null)
{
rm.BaseUnitID = edIzmBId.Value; // don't move down!
switch (edIzmB.Value)
{
case "шт":
rm.QtyGram = 0;
rm.QtyPcs = rh.OnStockQty;
break;
case "г":
rm.QtyPcs = 0;
rm.QtyGram = rh.OnStockQty;
{
decimal n;
if (nominalWghts.TryGetValue(rm.GoodID.Value, out n) == true)
{
if (n != 0)
{
rm.QtyPcs = rm.QtyGram / n;
}
}
}
break;
case "кг":
rm.QtyPcs = 0;
rm.QtyGram = rh.OnStockQty * (1000);
rm.BaseUnitID = edIzmerGram; // repair from kg to g
{
decimal n;
if (nominalWghts.TryGetValue(rm.GoodID.Value, out n) == true)
{
if (n != 0)
{
rm.QtyPcs = rm.QtyGram / n;
}
}
}
break;
default:
rm.QtyPcs = rh.OnStockQty;
rm.QtyGram = 0;
break;
}
}
// Unit
rm.Active = true;
dataContext.FactRemains.InsertOnSubmit(rm);
if (i % 250 == 0)
{
dataContext.SubmitChanges();
}
i++;
}
dataContext.SubmitChanges();
} // public void fromHistoryToRemains()
Int64 unitIDGramm = 18; // ID for unit Gramm
public DocProductionImporter()
{
dataContext = new DataClasses1DataContext();
dataContextS1 = new s1_DataClasses1DataContext();
}
public FactPOSClass()
{
dataContext = new DataClasses1DataContext();
dataContextS1 = new s1_DataClasses1DataContext();
}
Int64 unitIDGramm = 18; // ID for unit Gramm
public FactManufactureImporter()
{
dataContext = new DataClasses1DataContext();
dataContextS1 = new s1_DataClasses1DataContext();
}
