public override Stream BuildReport() { StockHistoryWorksheet = Excel.Workbook.Worksheets.Add("Список Пользователей"); StockList = StockFunction.GetAllStockHistory(); // шапка StockHistoryWorksheet.Cells[1, 1].Value = "Название товара"; StockHistoryWorksheet.Cells[1, 2].Value = "Было"; StockHistoryWorksheet.Cells[1, 3].Value = "Изменение"; StockHistoryWorksheet.Cells[1, 4].Value = "Стало"; StockHistoryWorksheet.Cells[1, 5].Value = "Дата"; StockHistoryWorksheet.Cells[1, 6].Value = "Комментарий"; int row = 2; var ProductGroup = StockList.GroupBy(s => s.ProductId).ToList(); foreach (var group in ProductGroup) { group.OrderByDescending(x => x.Id); foreach (var stock in group) { StockHistoryWorksheet.Cells[row, 1].Value = stock.Product.Name; StockHistoryWorksheet.Cells[row, 2].Value = stock.Balance - stock.Quantity; StockHistoryWorksheet.Cells[row, 3].Value = stock.Quantity; StockHistoryWorksheet.Cells[row, 4].Value = stock.Balance; StockHistoryWorksheet.Cells[row, 5].Value = stock.DateAdd.ToString(); StockHistoryWorksheet.Cells[row, 6].Value = stock.Text; row++; } } //foreach(var stock in StockList) //{ // StockHistoryWorksheet.Cells[row, 1].Value = stock.Product.Name; // StockHistoryWorksheet.Cells[row, 2].Value = stock.Balance + stock.Quantity; // StockHistoryWorksheet.Cells[row, 3].Value = stock.Quantity; // StockHistoryWorksheet.Cells[row, 4].Value = stock.Balance; // StockHistoryWorksheet.Cells[row, 5].Value = stock.DateAdd.ToString(); // StockHistoryWorksheet.Cells[row, 6].Value = stock.Text; // row++; //} return(new MemoryStream(Excel.GetAsByteArray())); }
public override BotMessage BuildMsg() { db = new MarketBotDbContext(); StockList = db.Stock.Where(s => s.ProductId == ProductId).Include(s => s.Product).OrderByDescending(s => s.Id).ToList(); Pages = base.BuildDataPage <Stock>(StockList, base.PageSize); base.MessageReplyMarkup = base.PageNavigatorKeyboard <Stock>(Pages, Bot.AdminModule.AdminBot.ViewStockHistoryProdCmd, Bot.AdminModule.AdminBot.ModuleName, base.BackToAdminPanelBtn(), Argument: ProductId); if (Pages != null && Pages.Count > 0 && Pages[SelectPageNumber] != null) { var page = Pages[SelectPageNumber]; int counter = 0; base.TextMessage = base.BlueRhombus + " " + StockList.FirstOrDefault().Product.Name + NewLine() + "Всего записей:" + StockList.Count.ToString() + NewLine() + "Страница " + SelectPageNumber.ToString() + " из " + Pages.Count.ToString() + NewLine() + NewLine(); foreach (var stock in page) { base.TextMessage += "Дата: " + stock.DateAdd.ToString() + " | Было " + (stock.Balance - stock.Quantity).ToString() + " | Изменение: " + stock.Quantity.ToString() + " | Стало: " + stock.Balance.ToString() + " | комментарий: " + stock.Text + NewLine(); counter++; } } return(this); }
public List <Goods> GetStockOutGoodsList(uint filterarea) { List <uint> goodsids = StockList.FindAll(c => c.area == filterarea && (c.TrackType == TrackTypeE.储砖_出 || c.TrackType == TrackTypeE.储砖_出入)).Select(t => t.goods_id).ToList(); return(GoodsList.FindAll(c => c.area_id == filterarea && goodsids.Contains(c.id))); }
private async void ButtonLoadAllStocksClick(object sender, EventArgs e) { comboBoxStocks.Items.Clear(); labelRemainingTime.Text = @"Время загрузки порядка 15 с."; SetButtonsMode(false); comboBoxStocks.Text = ""; m_selectedList = GetList(StockListNamesEnum.All); m_bestStocksNames.Clear(); foreach (var st in m_selectedList.StList) { m_bestStocksNames.Add(st.Name); } Stopwatch stopwa = Stopwatch.StartNew(); await MainClass.GetStocksList(new FormsTextReporter(labelRemainingTime), new FormsProgressReporter(progressBar)); FillStockLists(); stopwa.Stop(); LogWriter.WriteLog($"Загрузка списка акций заняла {stopwa.Elapsed.TotalSeconds:F0} с"); SetButtonsMode(true); MessageBox.Show(@"Список загружен"); }
private DateTime?GetEarliestTime(uint trackid) { Stock stock = StockList.Find(c => c.track_id == trackid && c.PosType == StockPosE.顶部); if (stock != null) { return(stock.produce_time); } DateTime? earytime = null; List <Stock> list = StockList.FindAll(c => c.track_id == trackid); foreach (Stock item in list) { if (earytime == null) { earytime = item.produce_time; } if (earytime is DateTime areat && item.produce_time is DateTime stime) { if (stime.CompareTo(areat) < 0) { earytime = stime; } } } return(earytime); }
protected virtual void LoadStockAction() { try { if (Partidas_DGW.CurrentRow == null) { return; } if (Partidas_DGW.CurrentRow.DataBoundItem == null) { return; } BatchInfo batch = Partidas_DGW.CurrentRow.DataBoundItem as BatchInfo; //if (Cache.Instance.Get(typeof(StockList)) != null) return; PgMng.Reset(3, 1, Face.Resources.Messages.LOADING_DATA, this); PgMng.Grow(); StockList list = StockList.GetByBatchList(batch.Oid, false, true); list.UpdateStocksByBatch(false); Stock_BS.DataSource = list; //Cache.Instance.Save(typeof(StockList), Stock_BS.DataSource as StockList); PgMng.Grow(); HideComponentes(Stock_TP); ControlsMng.UpdateBinding(Stock_BS); } finally { PgMng.FillUp(); } }
public PlayerPilesViewModel(CommandContainer commandContainer, FlinchGameContainer gameContainer, FlinchVMData model, FlinchMainGameClass mainGame) { gameContainer.SingleInfo = gameContainer.PlayerList !.GetWhoPlayer(); CommandContainer = commandContainer; _model = model; _mainGame = mainGame; _model.StockPile.ClearCards(); //model.StockPile = new Piles.StockViewModel(commandContainer, gameContainer.Aggregator); gameContainer.SingleInfo !.StockList.ForEach(x => { model.StockPile.AddCard(x); }); //model.StockPile.StockFrame.PileList!.ReplaceRange(gameContainer.SingleInfo!.StockList); _model.DiscardPiles = new DiscardPilesVM <FlinchCardInformation>(commandContainer, gameContainer.Aggregator); _model.DiscardPiles.Init(HowManyDiscards); if (gameContainer.SingleInfo !.DiscardList.Count > 0) { model.DiscardPiles !.PileList !.ReplaceRange(gameContainer.SingleInfo.DiscardList); } _model.DiscardPiles.PileClickedAsync += DiscardPiles_PileClickedAsync; _model.StockPile !.StockClickedAsync += StockPile_StockClickedAsync; }
public async Task<IActionResult> Edit(int id, [Bind("StockID,ItemName,ImagePath,OrgID")] StockList stockList) { if (id != stockList.StockID) { return NotFound(); } if (ModelState.IsValid) { try { _context.Update(stockList); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!StockListExists(stockList.StockID)) { return NotFound(); } else { throw; } } return RedirectToAction(nameof(Index)); } return View(stockList); }
private List <StockTotals> GetTotals() { List <StockTotals> result = new List <StockTotals>(); foreach (StockType stockType in Enum.GetValues(typeof(StockType))) { result.Add(new StockTotals() { StockType = stockType.ToString(), TotalMarketValue = StockList.Where(x => x.StockType == stockType).Sum(x => x.MarketValue), TotalStockWeight = StockList.Where(x => x.StockType == stockType).Sum(x => x.StockWeight), TotalNumber = StockList.Count(x => x.StockType == stockType) }); } result.Add(new StockTotals() { StockType = "All", TotalMarketValue = StockList.Sum(x => x.MarketValue), TotalStockWeight = StockList.Sum(x => x.StockWeight), TotalNumber = StockList.Count }); return(result); }
public List <string[]> GetStockList(string rawJson) { var stockList = StockList.FromJson(rawJson); var lstStock = stockList.Data.Diff.Select(p => new string[] { (p.F12.StartsWith("6")?"sh":"sz") + p.F12, p.F14 }).ToList(); return(lstStock); }
private void _NewStockViewModel_TabClosed(object sender, EventArgs e) { StockList.Clear(); switch (TransactionObject.TransactionType) { case TransactionType.Purchase: PurchaseOBJ.UpdateCurrentObject(); foreach (var item in PurchaseOBJ.LinkedStock) { StockList.Add(item); } break; case TransactionType.Sale: PurchaseOBJ.UpdateCurrentObject(); foreach (var item in SaleOBJ.StockList) { StockList.Add(item); } break; // case TransactionType.Refund: } }
public bool ChangeStockGood(uint trackid, uint goodid, bool changedate, DateTime?newdate) { if (Monitor.TryEnter(_so, TimeSpan.FromSeconds(2))) { try { List <Stock> stocks = StockList.FindAll(c => c.track_id == trackid); foreach (Stock stock in stocks) { if (changedate && newdate != null) { stock.produce_time = newdate; } stock.goods_id = goodid; PubMaster.Mod.GoodSql.EditStock(stock, StockUpE.Goods); } StockSumChangeGood(trackid, goodid); SortSumList(); return(true); } finally { Monitor.Exit(_so); } } return(false); }
public void CheckTrackSum(uint trackId) { StockSum sum = StockSumList.Find(c => c.track_id == trackId); uint goodsid = StockList.Find(c => c.track_id == trackId && c.goods_id != 0)?.goods_id ?? 0; if (sum == null) { Track track = PubMaster.Track.GetTrack(trackId); sum = new StockSum() { track_id = trackId, goods_id = goodsid, produce_time = StockList.Find(c => trackId == c.track_id).produce_time, area = track.area, track_type = track.type }; StockSumList.Add(sum); SortSumList(); } if (goodsid > 0) { Goods goods = GoodsList.Find(c => c.id == goodsid); if (goods != null) { sum.count = (uint)StockList.Count(c => c.track_id == trackId); sum.stack = sum.count * goods.stack; sum.pieces = sum.stack * goods.pieces; SendSumMsg(sum, ActionTypeE.Update); } } }
public async Task Run() { using (var colour = new ScopedConsoleColourHelper(ConsoleColor.Yellow)) { Console.WriteLine("Everybody’s Got Something to Hide Except Me and My Monkey"); } await _stockDeliveryManager.CreateOrUpdate(new StockItem() { Name = "Mr Marvelous Monkey Munch", Quantity = 100 }); var stockList = StockList.Create(); for (int i = 0; i < 100; i++) { Random rnd = new Random(); int index = rnd.Next(minValue, maxValue); int quantity = rnd.Next(minValue, maxQuantityValue); var stockItem = stockList[index]; using (var colour = new ScopedConsoleColourHelper()) { Console.WriteLine($" Name { stockItem.Name} Quantity {quantity}"); } await _stockDeliveryManager.CreateOrUpdate(new StockItem() { Name = stockItem.Name, Quantity = quantity }); await Task.Delay(2000); } }
/// <summary> /// Copy the supplement eaten into a SupplementEaten[] /// </summary> /// <param name="model">The animal model</param> /// <param name="suppValues">The supplement data returned</param> public static void MakeSuppEaten(StockList model, ref SupplementEaten[] suppValues) { int count; int paddIdx; uint idx; count = 0; for (paddIdx = 0; paddIdx <= model.Paddocks.Count() - 1; paddIdx++) { if (model.Paddocks.byIndex(paddIdx).SuppRemovalKG > 0.0) { count++; } } suppValues = new SupplementEaten[count]; idx = 0; for (paddIdx = 0; paddIdx <= model.Paddocks.Count() - 1; paddIdx++) { if (model.Paddocks.byIndex(paddIdx).SuppRemovalKG > 0.0) { suppValues[idx] = new SupplementEaten(); suppValues[idx].Paddock = model.Paddocks.byIndex(paddIdx).sName; suppValues[idx].Eaten = model.Paddocks.byIndex(paddIdx).SuppRemovalKG; idx++; } } }
/// <summary> /// 添加库存 /// </summary> /// <param name="trackid"></param> /// <param name="goodid"></param> /// <param name="transid"></param> public uint AddStock(uint tile_id, uint trackid, uint goodid, byte fullqty, DateTime?producetime = null) { if (Monitor.TryEnter(_go, TimeSpan.FromSeconds(2))) { try { uint newid = PubMaster.Dic.GenerateID(DicTag.NewStockId); byte stack = PubMaster.Goods.GetGoodStack(goodid); ushort allpieces = (ushort)(stack * fullqty); Track track = PubMaster.Track.GetTrack(trackid); Stock stock = new Stock() { id = newid, track_id = trackid, goods_id = goodid, produce_time = producetime ?? DateTime.Now, stack = stack, pieces = allpieces, //总片数 tilelifter_id = tile_id, area = track.area, track_type = track.type }; UpdateTrackPos(stock); StockList.Add(stock); PubMaster.Mod.GoodSql.AddStock(stock); return(newid); } finally { Monitor.Exit(_go); } } return(0); }
private void RadioButtonUSA_CheckedChanged(object sender, EventArgs e) { if (radioButtonUSAStocks.Checked) { m_selectedList = GetList(StockListNamesEnum.Usa); LoadNewListInComboBox(m_selectedList.StList); } }
public ActionResult DeleteConfirmed(int id) { StockList stockList = db.StockLists.Find(id); db.StockLists.Remove(stockList); db.SaveChanges(); return(RedirectToAction("Index")); }
public ReconcileStock(int _id) { InitializeComponent(); id = _id; sl = new StockList(id); s = sl.ViewAStock(sl[0].StockID); }
protected void Page_Load(object sender, EventArgs e) { Stock locStock = new Stock(); DataTable dv = locStock.GetStock(AgentState.GetInstance((string)Session["UserName"]).Name); StockList.DataSource = dv; StockList.DataBind(); }
private void getStockListCallback(IEnumerable <string> stockList) { StockList.Clear(); foreach (string s in stockList) { StockList.Add(s); } }
/// <summary> /// 显示条码规则列表 /// </summary> public void ShowStockTable() { foreach (var model in GetStockList()) { StockList.Add(model); } ShowStockList(); }
public void SetActiveStock(string symbol) { ActiveStock = StockList.Find(stock => stock.Symbol == symbol); if (ActiveStock != null) { OnActiveStockProcessed(ActiveStock); } }
private void RadioButtonFromTinkoff_CheckedChanged(object sender, EventArgs e) { if (radioButtonFromTinkoff.Checked) { m_selectedList = GetList(StockListNamesEnum.Tinkoff); LoadNewListInComboBox(m_selectedList.StList); } }
public Stock AddStock(string symbol, string companyName, Industry industry) { Stock stock = new Stock(symbol, companyName, industry, this); StockList.Add(stock); stock.OnProcess += HandleStockProcessed; OnStockAdded(stock); return(stock); }
/// <summary> /// 生成上砖记录 /// </summary> /// <param name="stockid"></param> /// <param name="iD"></param> /// <param name="leftTrackId"></param> public void AddStockOutLog(uint stockid, uint trackid, uint tileid) { Stock stock = StockList.Find(c => c.id == stockid); if (stock != null) { PubMaster.Mod.GoodSql.AddStockOutLog(stock, trackid, tileid); } }
public void TransferCards() { _moves += 2; var thisCard = _gameContainer.CurrentComputer !.StockList.First(); _gameContainer.CurrentComputer.Discard.Add(thisCard); _gameContainer.CurrentComputer.StockList.RemoveSpecificItem(thisCard); UpdateComputerCount(); }
/// <summary> /// 添加下砖记录 /// </summary> /// <param name="stockid"></param> public void AddStockInLog(uint stockid) { Stock stock = StockList.Find(c => c.id == stockid); if (stock != null) { PubMaster.Mod.GoodSql.AddStockInLog(stock); } }
/// <summary> /// 根据上砖机,品种,分配库存 /// 1.优先分配,非满砖轨道 /// 2.在满砖轨道中,分配时间最早的轨道 /// </summary> /// <param name="tilelifterid"></param> /// <param name="goodsid"></param> /// <param name="stockid"></param> /// <param name="taketrackid"></param> /// <returns></returns> public bool GetStock(uint areaid, uint tilelifterid, uint goodsid, out List <Stock> allocatstocks) { allocatstocks = new List <Stock>(); //1.找到上砖机配置的轨道 List <AreaDeviceTrack> devtrack = PubMaster.Area.GetAreaDevTraList(areaid, tilelifterid); //2.根据优先级查看非空且是需求的品种的轨道 List <Stock> stocks = StockList.FindAll(c => c.goods_id == goodsid && c.PosType == StockPosE.顶部 && devtrack.Exists(d => d.track_id == c.track_id)); if (stocks.Count == 0) { //找不到库存 return(false); } stocks.Sort((x, y) => x.pos.CompareTo(y.pos)); //foreach (Stock stock in stocks) //{ // //优先取非满的轨道 // if (stock.pos > 1 && PubMaster.Track.IsTrackHaveStock(stock.track_id) // && PubMaster.Track.IsTrackEnable(stock.track_id)) // { // allocatstocks.Add(stock); // } //} //全部都是满砖,则找时间最早的库存 stocks.Sort( (x, y) => { if (x.produce_time is DateTime xtime && y.produce_time is DateTime ytime) { return(xtime.CompareTo(ytime)); } return(0); } ); int minStockTime = PubMaster.Dic.GetDtlIntCode("MinStockTime"); foreach (Stock stock1 in stocks) { if ((DateTime.Now - (DateTime)stock1.produce_time).TotalHours >= minStockTime) { if (PubMaster.Track.IsTrackFull(stock1.track_id) && PubMaster.Track.IsTrackEnable(stock1.track_id, TrackStatusE.仅上砖)) { allocatstocks.Add(stock1); } } } return(allocatstocks.Count > 0); }
protected void BindStockList(int Pm_id, int WareHouseId) { int count = 0; SqlHelper conn = LocalSqlHelper.WH; string sql = "select stock_id,pro_txm,pro_name,pro_spec,pro_model, shelf_no from View_Product with(nolock) where warehouse_id=" + WareHouseId + " and pm_id=" + Pm_id + " order by pro_model"; //Response.Write(sql); DataTable dt = conn.ExecDataTable(sql); StockList.DataShow(dt); }
public async Task<IActionResult> Create([Bind("StockID,ItemName,ImagePath,OrgID")] StockList stockList) { if (ModelState.IsValid) { _context.Add(stockList); await _context.SaveChangesAsync(); return RedirectToAction(nameof(Index)); } return View(stockList); }
public CuttingStock(StockList theStocks, ItemList theItems/*, float theTotalItemsSum/*, ToolStripLabel theTextBoxStatus, ToolStripProgressBar theToolStripProgressBar, CheckBox theExitGreedyNextFit*/) { this.TotalItemsSum =theItems.Sum; //this.Label = theTextBoxStatus; //this.ProgressBar = theToolStripProgressBar; // this.ExitGreedyNextFit = theExitGreedyNextFit; // Get a List of Stocks available this.ListOfStocks = theStocks.Available; // Get a List of Items available this.ListOfItems = theItems.Available; }
public viewStock(int _id) { InitializeComponent(); id = _id; sl = new StockList(id); s = sl.ViewAStock(sl[0].StockID); txtBrand.Text = s.Brand; txtProduct.Text = s.Product; txtPrice.Text = Convert.ToString(s.Price); txtSize.Text = Convert.ToString(s.Size); txtQuantity.Text = Convert.ToString(s.Quantity); txtBarcode.Text = s.Barcode; txtSupplier.Text = Convert.ToString(s.SupplierID); }
private void button2_Click(object sender, EventArgs e) { StockList ss = new StockList(); try { ss = sl.SearchStock(txtSName.Text, txtBName.Text, txtPName.Text); dataGridView1.DataSource = ss; if (ss.Count == 0) { MessageBox.Show("No Items Found"); } } catch (Exception d) { MessageBox.Show("ERROR: " + d); } }