public Guid Create(NomenclatureInfo nomenclatureInfo) { var res = Mapper.Map <Nomenclature>(nomenclatureInfo); _context.Nomenclatures.Add(res); _context.SaveChanges(); return(res.NomenclatureGuid); }
private DataRow addNewNomenclatureRow(long stickerId, long nomenclatureId) { var newRow = NomenclatureInfo.GetNewRow(this); newRow[NomenclatureCode] = stickerId; newRow[Nomenclature] = nomenclatureId; newRow.AddRowToTable(this); return(newRow); }
private void addWareRow(Stickers sticker, Cells cell, Nomenclature nomenclature, int quantity, long partyId) { if (quantity > 0 && !nomenclature.Empty) { var row = NomenclatureInfo.GetNewRow(this); row[Nomenclature] = nomenclature.Id; row[NomenclaturePlan] = quantity; row[NomenclatureParty] = partyId; row[NomenclatureCode] = sticker.Id; row[NomenclatureCell] = cell.Id; row.AddRowToTable(this); } }
internal void FixWrongRelations() { var table = DB.NewQuery("SELECT Pallet, PreviousPallet, -Quantity Quantity FROM [dbo].[GetPalletsRelations] ('0001-01-01',0,0) where Quantity<0 order by Quantity").SelectToTable(); foreach (DataRow row in table.Rows) { var rowsQuantity = Convert.ToInt32(row["Quantity"]); for (int i = 0; i < rowsQuantity; i++) { var newRow = NomenclatureInfo.GetNewRow(this); newRow[PalletCode] = Convert.ToInt64(row["Pallet"]); newRow[FinalCodeOfPreviousPallet] = Convert.ToInt64(row["PreviousPallet"]); newRow[RowState] = RowsStates.Completed; newRow[FinalCell] = Consts.EmptyCell.Id; newRow.AddRowToTable(this); } } }